Hirox

Maybe Im missing something, but I downloaded the file, installed everything... but when I try to equip the boots, the client crashes. I noticed that the rar does not contain the spr and act files that need to be in the male and female folder when equipped.... Or.. did I do something wrong?

After testing for a whole day, I had no database timeouts. I changed the timeout variable in the code, based on the tests of my server. For example, default is 28800. My server had 7800 but kept disconnecting. I tried lowering the number to 7000, 5000, and found out that 3600 is the lowest number that kept the database alive. If you have a similar problem, you should try the same. /// @return the keepalive timer id, or INVALID_TIMER /// @private static int Sql_P_Keepalive(Sql *self) { uint32 timeout, ping_interval; // set a default value first timeout = 3600; // lowest number I found that my server did not disconnect // request the timeout value from the mysql server //Sql_GetTimeout(self, &timeout); <removed this as it gave a higher number and kept disconnecting and you are already giving the variable. if (timeout < 60) timeout = 60; So thats it. It can be counted as problem solved. Thank you very much.

Yes, the reason is because it is preconfigured to websites and forums. Ive been with this host for almost two years, and just recently I opened a private RO server. (Though it is closed because of this problem) I will change the function sql_p_keepalive... se if that helps. Will post back if it solves the problem. (If not, Im planning on changing servers...)

Yes it is. Although it is a shared server with other sites hosted in the same machine. My solution so far has been shutting down loginaserv and charserv once every hour and then restart them both. Of course, with a cronjob... But it would be nice to have a real solution to this problem.

So, Im having this problem: I start my server, login correctly, and start playing. After an hour or so, if I try to logout, the command console says DB Error, Mysql server has gone away. I tried googling and found that this variable in mysql database might be at fault: SHOW VARIABLES LIKE 'wait_timeout'; In my server, it shows that it is only 7800 instead of the default 28800. So I asked my server provider to change it and he said he cannot. So, I guess i need to find other solutions... Maybe Charserv and Loginserv keep pinging the database to keep it alive? I tried googling again and found this on one of the rathena source branches in google. https://code.google....=svn9728&r=9728 on File inter_athena.conf // Interval (in hours) at which servers do a ping on all sql-connections // to keep them alive (the default mysql settings makes a connection time-out // after 8 hours of inactivity). // 0 disables (default). Enable it only if you are getting // "MySQL server has gone Away" errors due to lack of activity on your server connection_ping_interval: 7 then I checked my inter_athena.conf and does not have that line, so I added it. Unfortunately, it did not work. It has no effect whatsoever So, again, I need to ask if any other file has something like this to keep Db alive? Or again, maybe another solution for this problem? Im thinking... maaybe a cronjob that stops loginserv and charserv and restarts it every hour? Bump, anyone havin this issue too?

Tried All that, even recompiling.

Tried editing re/item_db.txt, for item 7539 (Poring Coin) < just in case... . Change it to type 2. Went back to the client, reloaded scripts and database. typed: @iteminfo 7539 just to check, and it still showed Poring coin as an ETC item!!! wtf? o.O Pd. This thing is trolling me

Still not working. In my database (SQL) I have this column: 677 White_Gold_Coin Platinum Coin 2 2000 NULL 40 NULL NULL NULL NULL 4294967295 7 2 NULL NULL NULL NULL NULL set #CASHPOINTS,#CASHPOINTS + 50; So, as you can see, it says that this coin is supposed to be an Usable item, but instead it shows in my client as a misc item, making it unsusable. I tried changing the item to 0 and 2 just in case. I tried creating a new item, just to see what was going on, and it did work. I can see this new item as being consumable and when I double click it, it gives me my cash points. But I still cannot figure out why the Poring Coin wont change its tab to the consumables tab. (I tried with Gold Coin, Platinum Coin, Bronze Coin, Mithril Coin)

Ok, so in my database (SQL) I changed my Poring Coin from Type 3, to Type 2 hoping to make it an usable item instead of a misc. item. But, even though Ive changed the DB correctly, the item is Stil displaying in the Misc tab, making it unclickable and unusable. Any reason why this is happening? How con I achieve my goal of making this item usable...

Thanx, that did it =). Problem Solved.

I just started up my server. Well, I patched my client with WeeDiffGen and selected the translate to English using WDGTranslateClient. When i login to my server, i see this big and obtrusive Inventory window and I need help to change it. Ive tried hexing it with no luck. Also, there are other things like "NO MSG" on some parts... Any help will be appreciated. Thanks.