Aleos

bugreport:9198. It's being looked into.

Glad it worked for you!

You'll have to run something like: INSERT INTO `global_reg_value` (`account_id`, `str`, `value`, `type`) SELECT `account_id`, `key`, `value`, 2 FROM `acc_reg_num_db` WHERE `str` NOT LIKE '#%$'; INSERT INTO `global_reg_value` (`account_id`, `str`, `value`, `type`) SELECT `account_id`, `key`, `value`, 2 FROM `acc_reg_str_db` WHERE `str` LIKE '#%$'; INSERT INTO `global_reg_value` (`char_id`, `str`, `value`, `type`) SELECT `char_id`, `key`, `value`, 3 FROM `char_reg_num_db` WHERE `str` NOT LIKE '%$'; INSERT INTO `global_reg_value` (`char_id`, `str`, `value`, `type`) SELECT `char_id`, `key`, `value`, 3 FROM `char_reg_str_db` WHERE `str` LIKE '%$'; INSERT INTO `global_reg_value` (`account_id`, `str`, `value`, `type`) SELECT `account_id`, `key`, `value`, 1 FROM `global_acc_reg_num_db` WHERE `str` NOT LIKE '##%$'; INSERT INTO `global_reg_value` (`account_id`, `str`, `value`, `type`) SELECT `account_id`, `key`, `value`, 1 FROM `global_acc_reg_str_db` WHERE `str` NOT LIKE '##%$';

Made another small change in 82467e1. @gidzdlcrz The point of the upgrades folder is so for later on, all you need to do is go to the upgrades folder and import the SQL file that was added from the commits you haven't applied yet. It avoids you having to dump your schema every time (using live or offline data). You'd still have to apply those upgrades since some tables affected are core tables used by the server. The tables that you aren't using, such as mob_db, item_db, mob_skill_db, etc can be ignored if you get errors in your case since you are using the db/ files. @Cydh Thanks for testing an even older client! I'm surprised it went back that far.

If you're using the db/ folder then all you need to import are the main and log SQL files. The rest of the files are not needed then.

By default all you need is main.sql. Log would be if you want to use the logging system. The rest of the stuff is not needed unless you want everything to be ran via the SQL side rather than the db/ files.

You don't have to truncate anything when applying anything from the upgrade folder. As long as what steps you did above seem to work for you, then ok. Seems like all you did was remove stuff from non-character based files.

Just import the file as you did with main and log. The file though ending in "_log" will only need to be applied to your log schema though. The other should be applied to your ragnarok schema.

Made a small change in 42b29ee. Cydh pointed out that adjusting the tables before changing CARD0_PET caused the value to be set to 0 since we are applying an unsign change before the absolute change. Just make sure to use the updated SQL files.

@gidzdlcrz The files are linked in here: http://rathena.org/board/topic/95735-increase-item-id-array-size/ @TARTs http://rathena.org/wiki/GIT_Clone/Windows

Increased item ID array size! As of 7cd82d0, rAthena is now able to support item IDs up to 65,535! The added benefit is that there is no extra memory consumption for the increased size. By changing the variables to unsigned this removes all the negative values that could never be used. This patch also included a change to CARD0_PET and removed the negative value of it since it's not dependent on the client. @Cydh was able to help and tested clients 2010-07-30 and up and was able to create items successfully over 32k. If you still run a client before 2010-07-30 post your results so I can update this topic! Don't forget to run sql-files/upgrades/upgrade_20140612.sql and sql-files/upgrades/upgrade_20140612_log.sql! Follow ups: 42b29ee 82467e1 98c6aee please run sql-files/upgrades/upgrade_20140616.sql 6c5d4a7

That's correct. Please don't forget to apply both of the SQL files.

It was so cold.. and dark.

What did you increase your MAX_STORAGE/MAX_GUILD_STORAGE to?

To my knowledge this isn't on anyone's plate for the foreseeable future.

You already have the server running. You will need to find the PID (process ID) and kill it or just restart your box.

Oh. I'm guessing you copied it over from a Windows machine. In that case you will need to use dos2unix to get rid of the Windows CR. dos2unix configure

You need to modify the file's permissions. chmod a+x configure ./configure

If you're using Linux: http://rathena.org/wiki/GDB

I'm not dead. Guess you can't really use the excuse of "exams" when you have your degree, but I have been working on a few bugs in the background. I just haven't gotten around to testing them yet. I have been pretty busy trying to find my first house (not apartment). It's harder than it seems....

Keep up the good work. I know I broke the original diff with all the 3rd skill changes.

I don't see any reason why this can't be done.

I'm somewhat surprised RO beat Dota 2. O.o

It would be nice to change that but we can't. It's hard coded to the client.

If you don't want the item ID to show, just change the map_msg.conf to reflect it. to