summaryrefslogtreecommitdiff
path: root/sql-files/item_db.sql
AgeCommit message (Collapse)AuthorFilesLines
2009-03-18* Updated item_db.sql with the perl scriptPlaytester1-1680/+2371
* Added missing changelog entries about Moscovia mob changes git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13597 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-11-29Fixed typo on item script.Kisuka1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13390 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-05-24Updated sql files to latesttoms1-10/+32
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12722 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-25Updated item_db.sql to latesttoms1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12652 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-21Updated sql files to latesttoms1-7/+7
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12630 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-15Removed all _ in the second name in item_db.txt and updated item_db.sqltoms1-61/+61
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12601 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-15Updated item_db.sql to latesttoms1-21/+24
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12597 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-04Replaced the TYPE keyword with ENGINE in all sql files, because this is the ↵ultramage1-1/+1
preferred alternative. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12480 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-03-27Updated SQL Files (item & mobs)toms1-727/+871
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12444 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-03-15Updated Poring Tower to not refinable. (bugreport: 1050)Paradox924X1-1/+1
Renamed custom Stylist to Stylist#customstylist to avoid conflicts with official one. (bugreport: 1042 Updated Airship Typing Challenge to not fail you when you get both strings correct. (bugreport: 1008) Fixed Job_Change Function to properly jobchange babies. (bugreport: 943) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12368 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-01-25Updated conversion tools for mob_db & item_dbtoms1-216/+334
Updated SQL Files (item & mobs) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12138 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-11-05Updated sql filesPlaytester1-77/+77
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11669 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-28Updated sql filesPlaytester1-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11602 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-21* Added new cards to drops so they can be testedPlaytester1-19/+19
- updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11539 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-17Updated sql filesPlaytester1-14/+14
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11497 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-12* Removed exp of poring stat mobsPlaytester1-8/+9
- updated Moscovia mob stats - updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11421 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-09Added a missing item name thanks to rollopopPlaytester1-9/+9
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11389 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-06* Added missing item names in the item_dbPlaytester1-23/+23
- please fix the txt files if there's a bug to begin with next time - also ingame names shouldn't have "_" - updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11372 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-05- Bug ID #143: Error In Item_db.sqlzephyrus1-4/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11368 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-01Small sql updatePlaytester1-4/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11339 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-01* Reverted the bug that was added in the last updatePlaytester1-1/+1
- official script clearly says 30% - please don't update db files without official source git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11338 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-01Fixed Gemini-S58 Card.Paradox924X1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11335 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-28Updated item_db.sqlPlaytester1-1/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11322 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-27* Removed Final Strike from skill_cast_dbPlaytester1-890/+889
- also updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11317 54d463be-8e91-2dee-dedb-b68131a5f0ec
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-22Updated sql filesPlaytester1-69/+69
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11273 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-19* Slightly adjusted some drop ratesPlaytester1-2/+2
- updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11242 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-17Updated sql filesPlaytester1-34/+48
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 filesPlaytester1-496/+665
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11152 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-04* Some drop and item fixesPlaytester1-107/+141
- 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-08-30Updated sql filesPlaytester1-71/+475
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11098 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 updatesPlaytester1-238/+361
- 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-09* Added some official Thor Volcano mob statsPlaytester1-3/+3
- 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 filesPlaytester1-10/+10
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10661 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-05-22Updated sql filesPlaytester1-70/+70
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10606 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-05-13Updated sql filestoms1-47/+47
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 filesPlaytester1-6/+246
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10461 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-04-24* Updated sql files and AnubisPlaytester1-34/+45
- 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-12* Updated Aegis name, price and weight of etc itemsPlaytester1-198/+203
- 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-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