summaryrefslogtreecommitdiff
path: root/sql-files/item_db.sql
AgeCommit message (Collapse)AuthorFilesLines
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
2006-05-10- Changed wedding costumes to use setoption rather than changebase.skotlex1-2/+2
- Modified setoption so that flag 1 or no flag adds an option, and flag 0 removes it. - Updated script_commands with the new behaviour. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6548 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-06- Updated item_db.sqlskotlex1-109/+108
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6505 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-27- Small change in the pet_ai that should stop the "strange" catch-up ↵skotlex1-2/+2
behaviour of pets when you are much faster than them. - Corrected the unequip script of the wedding dress/tuxedo (it should be Class, not bClass) - Changebase script command will also refresh the weapon sprites (in case you changed into Wedding/Xmas class) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6317 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-26- Updated item_db.sql to current.skotlex1-43/+43
- Some small code-cleanups. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6298 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-20- Added two columns to item_db: equip_script and unequip_script are scripts ↵skotlex1-2474/+2568
that are executed once when the corresponding item is equipped or unequipped respectively. - Removed bonuses bDamageWhenUnequip, bLoseSPWhenUnequip - Updated sql-files/item_db.sql with latest. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6204 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-14- Updated sql-files/item_db.sql to current.skotlex1-2474/+2474
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6056 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-08- Modified the equip_job field in the item_db to be a hexadecimal value for ↵skotlex1-1231/+1229
easier handling. - Updated item_db.sql to this new file format (even though it's equip_jobs field is still a integer) - Added upgrade_svn5951.sql for those who would like to convert their existing items. - Added doc/item_db.txt to explain each of the fields in db/item_db.txt git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5951 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-23- Updated mob_db.sql and item_db.sql to latest txt versions.skotlex1-625/+625
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5722 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-10- Fixed Valkyrie's shield script in item_db.sqlskotlex1-1/+1
- Added a warning on the char-server's name when it contains a space. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5547 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-09- Fixed a bug that was making the no_spawn_on_player setting useless.skotlex1-2/+2
- Added Deadly Poison and Bleeding to status_get_sc_def, meaning that now vit does increases defense against being inflicted from it. - Fixed a crash and an infinite loop in @whodrops @.@ - Expanded the item_db column sizes for the names to 50. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5526 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-08- Updated mob_db.sql and item_db.sql to latest.skotlex1-190/+276
- Modified mob_db's HP column to be an int. - Fixed the included global_functions file for the Kafra Express script. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5507 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-05- Merged some of the 'plug' items into the main item_dbskotlex1-2415/+2390
- Updated sql-files/item_db.sql to latest. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5191 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-01-29AS OF SVN REV. 5901, WE ARE NOW USING TRUNK. ALL UNTESTED BUGFIXES/FEATURES ↵Valaris1-0/+2415
GO INTO TRUNK. IF YOU HAVE A WORKING AND TESTED BUGFIX PUT IT INTO STABLE AS WELL AS TRUNK. EVERYTHING ELSE GOES INTO TRUNK AND WILL BE MERGED INTO STABLE BY VALARIS AND WIZPUTER. -- VALARIS git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5094 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-01-29Clearing trunk.Valaris1-1835/+0
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5091 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-27* Added use dynamic allocation when loading the msg_tablecelest1-1772/+1805
* Refresh the client when day comes to get rid of the night effect * Changed @refresh to fake map loading, but without teleporting side effect * Updated SQL file for the item_db git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1307 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-20sql changeamber1-1802/+1802
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1255 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-02-28fixed SQL Castle Saving BUGSLupus1-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1193 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-02-21made actual ITEM_DB SQLLupus1-0/+1802
some name fixes in item_db (added missing columns ) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1149 54d463be-8e91-2dee-dedb-b68131a5f0ec