summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2007-09-27* Reimplemented mmo_char_fromsql using sql statements. (fixes bugreport:93)FlavioJS1-75/+164
* Fixed buildin_gethominfo not being included in the script engine. (bugreport:124) * homunculus_evolution -> homevolution in script_commands.txt. * Deleted item DEFAULT from item_db.txt and regenerated item_db.sql. (bugreport:103) * Skip empty lines and give more feedback (for invalid lines) when reading item_db.txt/item_db2.txt. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11311 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-24Removed unused mobdb2 entries (late followup to 10988 and 10946)ultramage1-33/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11285 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-22Updated sql filesPlaytester2-80/+80
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11273 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-19* Slightly adjusted some drop ratesPlaytester2-14/+14
- updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11242 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-17Some more drop rate updatesPlaytester1-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11235 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-17Updated sql filesPlaytester2-50/+64
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11232 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-10Updated item_db.sqlPlaytester1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11172 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-09- Modified bonus3 bAddEff/bAddEffWhenHit so that the last parameter is now ↵skotlex1-3/+3
passed directly as "trigger" flag. The possible trigger values are ATF_LONG, ATF_SHORT, ATF_TARGET, ATF_SELF. Explanation added to doc/item_bonus.txt - Updated some cards to use the new format of bonus3 bAddEff* git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11157 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-09Updated sql filesPlaytester2-507/+677
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11152 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-04* Some drop and item fixesPlaytester2-150/+184
- also updated sql files - time for players to test all the new stuff now :x git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11128 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-02Forgot to update base item db sql file! :PParadox924X1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11108 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-02Updated Refined Sakkat Box to give only 1 Sakkat instead of 10.Paradox924X1-0/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11106 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-08-30Updated sql filesPlaytester2-78/+482
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11098 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-08-15- Merged and completed Latio's work on server-side hot-key saving ↵skotlex2-0/+25
(http://www.eathena.ws/board/index.php?s=&showtopic=159388&view=findpost&p=884453) - Now hotkeys are stored server-side (table hotkey in SQL servers, file save/hotkeys.txt for TXT servers). You can disable this behaviour by commenting out the 'HOTKEY_SAVING' define in mmo.h - Fixed a few compilation warnings/errors. - Apply upgrade_svn11018.sql to create the hotkey table. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11019 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-08-10Updated item_db.sqlPlaytester1-4/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10976 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-07-30Updated sql filesPlaytester1-45/+45
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10934 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-07-04Fixed spiritual ringPlaytester1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10854 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-07-04* Cursey Abbey mob updatesPlaytester2-266/+388
- fixed some bugs in the item_db - updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10851 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-06-23random fixingultramage1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10808 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-06-09* Added some official Thor Volcano mob statsPlaytester2-15/+35
- also updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10730 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-06-04* Added 11.2 guns to gunslinger shopPlaytester1-12/+12
- updated gun prices - updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10682 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-06-01Updated sql filesPlaytester2-11/+11
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10661 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-05-22Updated sql filesPlaytester2-83/+83
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10606 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-05-19* Added Global chat and Main chat loggingultramage3-4/+7
- lowered the priority of the 'logging off during gw' filter git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10580 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-05-19* SQL files fixupultramage15-61/+117
- extended convert_engine_myisam and added innodb version - changed the max. email length to 39 (to match value in source code) - added comment for storage/guild storage picklog entries - changed SETs to ENUMs, which is the proper data type in logs - fixed incorrect defaults, shortened mapname lengths to 11 - use upgrade_svn10575_*.sql to apply changes git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10575 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-05-13Updated sql filestoms2-48/+59
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10536 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-05-05Fixed some syntax errors in the item_db and updated sql filesPlaytester2-65/+306
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10461 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-04-24* Updated sql files and AnubisPlaytester2-35/+46
- Anubis gives -40% exp because he's missing one skill git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10349 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-04-14More svn:eol-style-ing and typo fixesultramage1-13/+0
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10256 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-04-12* Updated Aegis name, price and weight of etc itemsPlaytester2-198/+204
- also updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10244 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-04-03updated item_db.sqlPlaytester1-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10148 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-04-03* Had to revert some mob modesPlaytester1-12/+12
- figured out I can't read the mode fully from the inc value - now mob mode is based on Doddler's info - updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10136 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-04-02Spring cleaning in sql-files/DracoRPG35-459/+0
Officialized a very small bit of the wedding NPC git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10133 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-04-02Updated sql filesPlaytester1-45/+50
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10127 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-03-27Updated sql-filesPlaytester1-25/+34
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10080 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-03-19- Removed the last argument from skillitem, the skill name passed to the ↵skotlex1-30/+30
client should always be of the type "AL_HEAL" anyway. - Added skill ITEM_ENCHANTARMS, this is what weapon enchanting items should use. - Corrected itemskill calls in the item_db, also made the weapon enchanting items invoke the ITEM_ENCHANTARMS skill. Corrected Holy Egg not being type 11 (delay consume) - Updated item_db.sql with item_db information. - Added support for specifying different elements per skill level in the skill_db - Added bonus bNoKnockback - Corrected typo in bonus bSubRace2 (it was called bSPSubRace2 for some reason) - Corrected login sql server not resetting your account state to 0 when the banuntil duration expires. - Corrected use of UINT_MAX instead of INT_MAX in some jailing check. - Made the skillatk bonus it's own function, it can now be used to boost Heal/Sanctuary/Potion Pitcher and Slim Pitcher as well. - Cleaned up TK_WARMWIND to use the element acquired from the skill_db rather than hardcoded values. - Corrected Teleport's save map entry being sent without the .gat extension. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10031 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-03-13Updated sql filesPlaytester1-51/+51
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9998 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-03-08- Normalized the mapname in guild get/set castle data, should fix guild flags.skotlex2-1/+2
- Added log options 0x800/0x1000 to log storage moves ('R') and guild storage moves ('G') - Added upgrade_svn9976.sql to include 'R'/'G' on the picklog type column set. - Updated the logs_athena description to include the letter of each type (512 - M, 32 - N, etc) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9976 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-03-05* Added various new headgears thanks to ArgatlahmPlaytester1-243/+330
- some headgears might not be fully official, feel free to report bugs if you find any - also updated item_db.sql git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9965 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-03-05Fixed the loginlog's `user` column length (use upgrade_svn9957.sql)ultramage1-0/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9957 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-03-02EOL-styled some more filesultramage40-1216/+1216
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9947 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-02-23- Updated Box of thunder to use "agi up" effect for 30 secs instead of NPC ↵skotlex1-1/+1
Agi Up for 20. - Guild expulsion now will fail when the character to be kicked is in a guild castle (rather than checking for the character doing the expulsion) - pk damage reduction settings now will take effect only on Player VS player damage. - Fixed produce_db2.txt entries overwriting produce_db.txt ones. - Fixed item-granted/plagiarized skills unlocking skill trees when only your real learned level should. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9899 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-01-23- Added view_data support to mercenary.*, so that the Homunculus entries are ↵skotlex1-16/+0
no longer required on the mob_db. - Removed homunculus entries from mob_db. - Added the status icon to NPC_CHANGEUNDEAD and the Flee/Hit foods - Corrected the check that lets you walk when vending/chatting/etc. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9697 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-01-06- Fixed Succubus/Incubus combo not doing regen correctlyultramage1-2/+2
Read why at http://www.eathena.ws/board/index.php?showtopic=129814 git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9622 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-27Updated SQL filestoms2-359/+368
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9580 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-19- Reverted the mob ThinkTime update, that field is again aDelay as it ↵skotlex2-2/+2
apparently should be. - Fixed one small compilation error. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9522 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-13- Added boss mode (0x20) to a few mobs that were missing it.skotlex1-22/+22
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9487 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-11- Updated mob_db2.sqlskotlex1-38/+38
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9465 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-11Updated sql filesPlaytester2-24/+32
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9459 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-06- Updated the mob_db converter to rename the ADelay column to ThinkTime.skotlex2-51/+52
- Updated the mob_db sql files to have this change as well. - Updated mob_db2.sql git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9425 54d463be-8e91-2dee-dedb-b68131a5f0ec