summaryrefslogtreecommitdiff
path: root/sql-files/item_db.sql
AgeCommit message (Collapse)AuthorFilesLines
2012-07-20* Optimized "Magic Books" quest, 60% size reduction ↵euphyy1-1/+1
(npc\re\quests\magic_books.txt) * Follow-up r16449, added missing SQL entry for bugreport:6132 git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16455 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-20Added new status bonuses: SC_INCMHP and SC_INCMSP to increase maximum HP and ↵cookiecrumbs1-3/+3
SP by a FIXED amount. Fixed the following items in the /db/*re/item_db.txt and /sql-files/item_db.sql: Increase HP Potion (Small), Increase HP Potion (Medium), Increase HP Potion (Large). bugreport:5790 git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16454 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-02* Neuralizer is no longer consumed upon failure (bugreport:6040)euphyy1-1/+1
* Some cleaning of the Sorcerer job change quest (jobs\3-2\sorcerer.txt) * Cleaning of "Bunny Band Quest" script (quests\bunnyband.txt) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16367 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-16Fixed a wrong SQL stat script.flaid1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16310 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-15item_db stat optimization and fix bugreport:6001flaid1-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16307 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-13git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16291 ↵rikimaru171-1/+1
54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-12Added iRO hats and matk fixes into SQLflaid1-1/+15
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16275 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-10Follow up r16249 - enabled double attack ability for all weapon types in all ↵kenpachi2k111-4/+4
item scripts that enables use of TF_DOUBLE. (bugreport:5935) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16266 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-10Fixed Concentrated White Potion(Z)s script. (bugreport:5895)kenpachi2k111-2/+2
Fixed Gym Pass Box' script. (bugreport:5976) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16261 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-09Fixed Black Wing, Peuz's and Ur's sets, Scarlet Rose' (#5548) location and ↵kenpachi2k111-14/+14
Ebon Armors (#15014) job code. (bugreport:5895) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16251 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-09Fixed some Genetic items related to Pharmacy skill. (bugreport:5790)kenpachi2k111-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16250 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-09Follow up r16248 - changed table name for Canon Balls (#18000-#18004) to ↵kenpachi2k111-4/+4
item_db_re. Added some books to the renewal database because of their MATK changes. (bugreport:5921) Changed bonus bDoubleRate to skill "TF_DOUBLE" because bonus bDoubleRate isn't enough and the official script explicitly states that the skill should be given. (bugreport:5935) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16249 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-09Follow up r16245 and r16247 - changed table name for Megingjard (#2629) and ↵kenpachi2k111-7/+1
Tao Gunka Card (#4302) to `item_db_re`. Fixed job code for Bone Plate (#15000). (bugreport:5816) Added Wizardry Staff (#1473) to renewal SQL database. (bugreport:5904) Moved Cannon Balls (#18000-#18004) from pre-renewal to renewal database and changed their weigth to 1. (SQL DB only) (bugreport:5907) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16248 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-09Fixed Shining Electric Bulb Hairbands (#5310) script. (bugreport:5805)kenpachi2k111-1/+1
Fixed Imperial Guards (#2153) ViewID. (bugreport:5785) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16246 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-09Fixed Barricades (#1905) HP in pre-renewal database. (bugreport:5423)kenpachi2k111-1/+1
Changed Poison Bottles (#678) script to use SC_ASPDPOTION3 instead of SC_ASPDPOTION2. (bugreport:1996) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16244 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-05-25- Fixed invalid item types in item_db.sqltr0n931-31/+31
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16148 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-05-24- Fixed a buy/sell zeny exploit (bugreport:5799), follow up to r16138 and ↵brianluau1-1/+1
bugreport:5781. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16141 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-05-11- Added Baby Hunter and Baby Ranger check. bugreport:5728masao871-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16097 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-05-10- Added Falcon Flute Trader NPC.masao871-0/+1
- Added Falcon Flute to db/pre-re/item_db.txt, db/re/item_db.txt and item_db.sql. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16095 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-05-08Fixed Nydhorgg's Shadow Garbs (2554) bonus script. (bugreport:5648)kenpachi2k111-2/+2
Fixed bonus3 bSPDrainRate documentation. (bugreport:5648) Fixed Tao Gunka Cards bonus script.(bugreport:5711) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16087 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-03-22Added GM Sandman Skill (part of bugreport:5172). now available thru angra ↵shennetsind1-1/+1
manyu item. - Causes target player, mob, homunculus or mercenary to enter in endless sleep state until cast again (logoff cancels). - Cannot be cast on self git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15747 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-03-10Fixed Poison Bottles (ID:678) script. (bugreport:5246)kenpachi2k111-1/+0
Added Bradium Golem to mob_race2_db.txt (bugreport:5257) Fixed Pile Bunkers (ID:1549) job requirements. (bugreport:5394) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15669 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-03-07Enabled some headgears. (Follow up r15662.)kenpachi2k111-48/+48
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15664 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-03-06Enabled some headgears. (Inspired by bugreport:1849)kenpachi2k111-65/+65
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15662 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-19Fixed Refined Quadrilles bonus script. (bugreport:4835)kenpachi2k111-2/+2
Fixed Glorious Arc Wands MATK values and added its entry to item_db_re.sql. (bugreport:4708) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15619 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-19Updated Guillotines (1369) bonus script. (bugreport:4904)kenpachi2k111-2/+2
Updated Hyuke's Black Cat Ears' (5360) bonus script. (bugreport:5055) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15611 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-17Corrected two mercenary names. (bugreport:4976)kenpachi2k111-4/+4
Updated Chemical Protection Scrolls bonus script. (bugreport:4944) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15605 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-17Updated Shadow Walks (2426) bonus script. (bugreport:4893)kenpachi2k111-3/+3
Added cash shop version of Wasteland Outlaw (13109) and updated Western Outlaw Box' rentitem script. (bugreport:4840) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15604 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-17Updated Guarana Candys (12414) bonus script. (bugreport:5338)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15601 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-12Removed remaining Fire Ivy database entries. (bugreport:5306)kenpachi2k111-4/+0
Removed some double entries from item DB. Added lost of entries to item_trade.txt and cleand it a little. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15571 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-04*Fixed a bug where a boss card was dropped from OCA.Chilly01231-2/+2
*Fixed drops and drop rates for a few mobs. *Added mob_chat for Nidhoggur's Memory mobs. *Updated item_db_re with all weapons that have a MATK bonus and added more items that have different DEF values in renewal. *Updated mob_boss and mob_branch with official episode 13.3 aegis spawns (special thanks to Muad_Dib) *Updated mob's skills to Malaya Port. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15387 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-04` Updated item_db.sql file to match the contents of the txt versionxantara1-363/+878
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15385 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-03- Follow up r15363.masao871-9/+9
* Enabled Item Scripts for Job change specific Items. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15364 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-03- Added first Version of Warlock Job change Quest.masao871-1/+1
- Updated mob/fields/splendide.txt for Warlock Job change Quest. - Fix for previous commit r15352 . git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15363 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-02- Kenpachi asked for it, so here is also the change for the item_db ;Pmasao871-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15354 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-25Updated several card scripts according to their description. (bugreport:4751)kenpachi2k111-9/+9
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15276 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-25Removed Atros duplicate from mob_boss.txt. (bugreport:4651)kenpachi2k111-4/+4
Took over Tantan Noodle (12395) script from item_db.txt to item_db.sql. (bugreport:4722) Updated RWC 2008 Dragon Helm (5451, 5452, 5453) bonus. (bugreport:4730) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15272 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-25Added the two new bonuses from r15269 and r15270 to item_bonus.txt.kenpachi2k111-3/+3
Updated Refined Bloody Roar (1273) bonus. (bugreport:4767) Updated Entweihen Crothen Card (4451) bonus. (bugreport:4486) Updated Angeling Hat (5132) DEF and required level. (bugreport:4517) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15271 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-25Updated October Fest Cap (5807) bonus. Assumed 2% chance until we get more ↵kenpachi2k111-5/+5
information. (bugreport:4475) Updated Shield of Naga (2134) bonus. (bugreport:4379) Updated Well-Chewed Pencil (5574) bonus. (bugreport:4381) Updated Parade Hat (5225) bonus. (bugreport:4481) Removed changes from r15112 / bugreport:4356. (Was a custom iRO bonus.) Updated Speed Potion drop chance in First Aid Kit. (bugreport:5157) Fixed item_bonus.txt where x/10000 should be x/100. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15259 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-24Fixed typo in item_db.sql (bugreport:5153)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15258 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-14Updated Rideword Hat bonus. (bugreport:4356)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15112 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-14Updated Kasa Card bonus. (bugreport:2499)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15110 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-13Updated Water Lilly Hats DEF value. (bugreport:4304)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15097 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-13Fixed some job codes. (bugreport:4254)kenpachi2k111-4/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15095 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-13Fixed some items. (bugreport:4274)kenpachi2k111-4/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15094 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-13Fixed comment in exp.txtkenpachi2k111-4/+4
Updated Luxurious Keycards (7509) trading behaviour. (bugreport:3718) Updated Sleipnirs (2410) bonus script according to iRO Wiki. (bugreport:5118) Updated Soldier Grenade Launchers bonus effect and trading behaviour. (bugreport:4133) Updated Full Plates (2316/2317) DEF value. (bugreport:4260) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15093 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-12Fixed bonus for Valorous Assaulter's Katzbalger (1184). (Bugreport:3021)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15082 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-12Fixed bonuses for Kafra Dolls (ItemIDs 5340, 5341, 5342, 5343, 5344 5345) ↵kenpachi2k111-6/+6
and added a missing semicolon in item_bonus.txt. (bugreport:3129) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15080 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-11Fixxed Mole Card bonus.(bugreport:2230)kenpachi2k111-2/+2
Fixxed The Sign bonus.(bugreport:5116) Fixxed documentation for Guardian() and GuardianInfo script commands.(bugreport:5117) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15058 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-10Corrected an issue with Sprint Ring adjusting bDelayRate the wrong way. ↵jmanfffreak1-1/+1
(bugreport:5070) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15055 54d463be-8e91-2dee-dedb-b68131a5f0ec
generated by cgit v1.2.3-70-g09d2 (git 2.46.0) at 2024-11-02 10:26:06 +0000