summaryrefslogtreecommitdiff
path: root/sql-files/item_db.sql
AgeCommit message (Collapse)AuthorFilesLines
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
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-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-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-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 filestoms1-309/+318
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9580 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-11Updated sql filesPlaytester1-10/+10
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9459 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-06Updated sql-filesPlaytester1-87/+92
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9424 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-01Updated sql filesPlaytester1-10/+10
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9378 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-11-28* Enabled Ice Dungeon spawns so they can be testedPlaytester1-84/+87
* Updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9348 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-11-27Updated sql filestoms1-13/+14
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9326 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-11-23Updated sql filesPlaytester1-2735/+2735
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9299 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-11-16Updated sql filestoms1-19/+19
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9233 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-11-05Updated sql filestoms1-15/+15
Updated perl files acording to rev 9135 git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9139 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-11-04* Converted itemdb tables to use smallint. Credits to ALZ. Lance1-2735/+2735
modified Changelog-Trunk.txt modified sql-files/item_db.sql modified sql-files/item_db2.sql added sql-files/upgrade_svn9135.sql git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9135 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-10-26Updated sql filesPlaytester1-5/+5
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9081 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-10-08Updated sql filesPlaytester1-26/+26
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8951 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-14Updated item_db.sql and mob_db.sqlPlaytester1-24/+24
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8753 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-11Added D-Kalck's fix of the TXT -> SQL converterPlaytester1-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8702 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-10Updated item_db.sql and mob_db.sqlPlaytester1-141/+153
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8690 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-17* Gospel can't stack anymorePlaytester1-1121/+1121
* Updated SQL files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8328 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-06Reupdated item_db.sql to latest (forgot to update before -_-)toms1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8155 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-06Updated item_db.sql to latest.toms1-54/+74
Little fixes on homunc (hp/sp are now saved and init stats changed) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8154 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-27- Corrected Combat Knife reducing damage from DemiHumans by 10% instead of ↵skotlex1-1/+1
increasing damage against them. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7924 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-27Fixed Independence Memorial Hat weight, set to 0toms1-1/+1
Updated item_db.sql to latest. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7914 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-25- Added Toms's perl scripts item_db.pl and mob_db.pl (they are in tools/), ↵skotlex1-62/+78
they convert the txt databases into sql. - Usage: "script" < "input file" > "output file". eg: ./tools/item_db.pl < db/item_db.txt > sql-files/item_db.sql - Updated the sql files since now it's easy :D git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7879 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-18- Updated mob_db.sql to current mob_db.txt data.skotlex1-92/+145
- Some cleaning on chrif.c - The char-server will allow off-line character saves when said char is tagged for final-save (this is the scenario when the char-map reconnect). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7722 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-24- Fixed an error on the item_db.sql file... GOSH I HATE THOSE COMMENTS, they ↵skotlex1-1/+1
make it HARD to correctly update the sql file >.<'' git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7327 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-24- Updated mob_db.sql and item_db.sql to latest.skotlex1-42/+146
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7324 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-17- Implemented correct script for "12038,Lotto_Box_04"skotlex1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7228 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-16- Modified the bNoMagicDamage/bNoWeaponDamage bonuses to be a 0-100 setting. ↵skotlex1-1/+1
Meaning you can do bonus bNoMagicDamage,50; To make all magic damage be reduced by half. This bonus stack, so two cards with bNoMagicDamage,50 will give magic immunity. - Removed setting gtb_pvp_only and replaced it with gtb_sc_immunity which specifies the threshold before the bNoMagicDamage starts blocking support statuses as well. ie: gtb_sc_imunity: 75 will mean that "bonus bNoMagicDamage,70;" reduces magic damage by 70%, but does not blocks heal or support status, while "bonus bNoMagicDamage,80;" does. - Updated GTB's card script to be "bonus bNoMagicDamage,100;" git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7212 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-13- Updated mob_db.sql and item_db.sql to latest.skotlex1-63/+89
- Added account_id index to char table. Thanks to Buuyo for reporting it. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7146 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-02- Updated item_db.sql/mob_db.sql to current.skotlex1-104/+41
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6922 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-24- Merged item_db.sql from stable :Bskotlex1-2539/+2539
- Added a missing line (how did it get lost?) in mob_spawn to set aggressive state for angry mobs. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6731 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-12- Reverted again the change that stuns the caster on Ske, Ska, Swoo when the ↵skotlex1-3/+3
target is a nonplayer (rather than always) - Modified mob_spawn_once so that coordinates -1,-1 are "random around the player" while 0,0 are random around the whole map (regardless of whether there's a player attached or not) - Knockback will no longer work on traps during woe. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6566 54d463be-8e91-2dee-dedb-b68131a5f0ec