Awsome
I will try to pull by myself, but I'm not familiar with the structure
Edit: Failing hard
There have been 4 items by hsombini (Search limited from 10-July 23)
Posted by hsombini on 02 September 2013 - 08:06 PM in Database Support
Please check your global SQL settings. They should match on both servers (not the IP of course ).
../conf/inter_athena.conf
// Global SQL settings// overridden by local settings when the hostname is defined there// (currently only the login-server reads/obeys these settings)sql.db_hostname: 127.0.0.1sql.db_port: 3306sql.db_username: ragnaroksql.db_password: ragnaroksql.db_database: ragnarok
They should have different ip? How the query on the Server 2 will run on the 'master' login table hosted on Server1 ?
This is the setting on the Server2
sql.db_hostname: IPServer1
sql.db_port: 3306
sql.db_username: ragnarokServer1
sql.db_password: ragnarokServer1
sql.db_database: ragnarokServer1
Posted by hsombini on 02 September 2013 - 08:34 AM in Database Support
Hello, I'm trying to use Multiple-Zone servers, almost everything is working fine, except the query for the 'master' login table
I'm using two different VPS to host these two servers:
Server 1: login server, map server, char server
Server 2: map server, char server
The problem here is the query from the npc's of the Server 2, they do not apply to the 'master' login table on the Server 1, the query just run on the local database, who should not have any information about the 'login' table.
There's any way to force the query from the npc's run on the 'master' database or should I just forget about Multi-Zone servers on different machines ?
Posted by hsombini on 17 July 2013 - 05:35 PM in Client-Side Support
Hello guys, I got a really wierd problem with my Ragexe 20120612 from Judas, it crashes everyone if and only if you are in party and hit a monster!
I aready tryed these possible solutions:
1. Change packets.h
//2012-06-12aRagexeRE //packet(0x01FD,15,clif->prepairitem,2); //packet(0x023B,26,clif->pfriendslistadd,2); //packet(0x0361,5,clif->phommenu,2,4); //packet(0x0954,36,clif->pstoragepassword,0); //packet(0x0288,-1,clif->pcashshopbuy,4,8); //packet(0x0802,26,clif->ppartyinvite2,2); //packet(0x022D,19,clif->pwanttoconnection,2,6,10,14,18); //packet(0x0369,7,clif->pactionrequest,2,6); //packet(0x083C,10,clif->puseskilltoid,2,4,6); //packet(0x0439,8,clif->puseitem,2,4); //packet(0x0281,-1,clif->pitemlistwindowselected,2,4,8); //packet(0x0815,-1,clif->preqopenbuyingstore,2,4,8,9,89); //packet(0x0817,2,clif->preqclosebuyingstore,0); //packet(0x0360,6,clif->preqclickbuyingstore,2); //packet(0x0811,-1,clif->preqtradebuyingstore,2,4,8,12); //packet(0x0819,-1,clif->psearchstoreinfo,2,4,5,9,13,14,15); //packet(0x0835,2,clif->psearchstoreinfonextpage,0); //packet(0x0838,12,clif->psearchstoreinfolistitemclick,2,6,10); //packet(0x0437,5,clif->pwalktoxy,2); //packet(0x035F,6,clif->pticksend,2); //packet(0x0202,5,clif->pchangedir,2,4); //packet(0x07E4,6,clif->ptakeitem,2); //packet(0x0362,6,clif->pdropitem,2,4); //packet(0x07EC,8,clif->pmovetokafra,2,4); //packet(0x0364,8,clif->pmovefromkafra,2,4); //packet(0x0438,10,clif->puseskilltopos,2,4,6,8); packet(0x0366,90,clif->pUseSkillToPosMoreInfo,2,4,6,8,10); //packet(0x096A,6,clif->pgetcharnamerequest,2); //packet(0x0368,6,clif->psolvecharname,2); packet(0x08E5,41,clif->pPartyBookingRegisterReq,2,4); //Added to prevent disconnections packet(0x08E6,4); packet(0x08E7,10,clif->pPartyBookingSearchReq,2); packet(0x08E8,-1); packet(0x08E9,2,clif->pPartyBookingDeleteReq,2); packet(0x08EA,4); packet(0x08EB,39,clif->pPartyBookingUpdateReq,2); packet(0x08EC,73); packet(0x08ED,43); packet(0x08EE,6); //packet(0x08EF,6,clif->pbookingignorereq,2); packet(0x08F0,6); //packet(0x08F1,6,clif->pbookingjoinpartyreq,2); packet(0x08F2,36); packet(0x08F3,-1); packet(0x08F4,6); //packet(0x08F5,-1,clif->pbookingsummonmember,2,4); packet(0x08F6,22); packet(0x08F7,3); packet(0x08F8,7); packet(0x08F9,6); packet(0x08FA,6); //packet(0x08FB,6,clif->pbookingcanceljoinparty,2); //packet(0x0907,5,clif->pmoveitem,2,4); packet(0x0908,5); //packet(0x08D7,28,clif->pbattlegroundreg,2,4); //Added to prevent disconnections
2. Change mmo.h to use packets form 20120618
All these things did not resolved my problem, I'm really lost on this, haha
**Update
Just tested with 20120410 Ragexe and got the same poblem, omg