Commit graph

214 commits

Author SHA1 Message Date
shennetsind
5b40d0c293 Fixed db2sql
Wasn't taking in account the delay_consume flag which actually means the item type is 11 not 2.
Also added a extra warning in the item packages parser.
Special Thanks to ossi0110 for bringing this up.

Signed-off-by: shennetsind <ind@henn.et>
2013-06-24 17:40:54 -03:00
shennetsind
045c1a44df Follow up fcba8a2161
Fixed "random" item package rates, special thanks to Beret.
Also, added the missing (+130) item package calls (special thanks to Streusel!)

Signed-off-by: shennetsind <ind@henn.et>
2013-06-24 16:23:46 -03:00
shennetsind
fcba8a2161 Official Item Group/Package/Chain
http://hercules.ws/board/topic/1244-official-item-grouppackagechain/
Also
Further implemented itemdb.c/storage.c interfaces, and a minor update to db2sql plugin.

Signed-off-by: shennetsind <ind@henn.et>
2013-06-23 16:35:42 -03:00
shennetsind
5321d32c8d Updating .sql item db files
Also Introducing the official DB2SQL plugin to quickly update the .sql db files.
http://hercules.ws/board/topic/1105-hercules-wpe-free-june-14th-patch

Signed-off-by: shennetsind <ind@henn.et>
2013-06-14 08:50:45 -03:00
Kenpachi
7a625b9574 Fixed bug report #6396
- Updated bonus scripts of Chemical Protection scrolls to ensure that skill requirements are fulfilled.
http://hercules.ws/board/tracker/issue-6396-chemical-protection/
2013-04-29 23:08:00 +02:00
Kenpachi
854851ca11 Fixed bug report #7202
- Updated bonus order of 12218 to enable correct showing of skill effects.
http://hercules.ws/board/tracker/issue-7202-assumptio-effect-on-scrolls/
2013-04-29 20:58:02 +02:00
Kenpachi
9bb7185ea7 Fixed bug report #7156
- Removed double entries for item 6441 and 6442 and updated their names according to fRO database. (http://rns.gamona.de/index.php?show=viewitem&itemid=6441, http://rns.gamona.de/index.php?show=viewitem&itemid=6442)
- Updated name of 12416 in all 4 item database files. (LUcky -> Lucky)
- Updated order of 19533 and 19534 in /db/re/item_db.txt.
- Updated AegisName of 4853-4858.
http://hercules.ws/board/tracker/issue-7156-double-items/
2013-04-29 20:43:43 +02:00
euphyy
7d59a35f2a * Initial implementation of Archangel Wing Enchants script.
* Added some Malangdo coin exchange NPCs, more will come later.
* Updated Malangdo warp portals.
* Fixed item ID 12220 and clarified documentation of 'getiteminfo' types 11 and 14 (bugreport:7256).
* Minor Renewal item database update.
* Applied changes from r17171 to SQL databases.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17172 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-04-11 16:10:12 -03:00
Matheus Macabu
524291493e Merged some commits from rAthena. 2013-02-04 00:32:19 -02:00
rud0lp20
9b02e0156d Fixed bugreport:5689 recoded/reimplement RE Matk formula(including RE Heal)
Fixed bugreport:5745 WL_RECOGNIZED us now functional.
Fixed bugreport:5663 where HW_MAGICPOWER shows glitch in status window.
Fixed bugreport:6759 where items granting matk bonus didn't work.
Follow up r16980 small performance enhancement...:)
Done some TODO in skill_cast_db.txt

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16981 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-29 16:03:55 +00:00
euphyy
a8fedec270 * Added the "Catalog Magician" NPC to merchants/buying_shops.txt, thanks to Muad_Dib!
* Changed all commands in atcommands.txt to their defined names, not aliases, and added two more common aliases.
* Documented 'makerune' in script_commands.txt.
* Documented '@accinfo' in atcommands.txt.
* Follow-up r16965, database update for rune crafting formula.
* Updated Magic Mushroom DB according to 3CeAM revision 703.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16966 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-25 01:08:33 +00:00
euphyy
cb78bae6df * Removed duplicate isequipped() entries from item_db already written in item_combo_db (bugreport:6924).
* Moved a few remaining isequipped() entries to item_combo_db.
* Follow-up r16940: applied change to SQL and pre-re files, and renamed Size constants to Size_ for consistency.
* Follow-up r16947: fixed mob modes.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16955 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-23 18:30:42 +00:00
kenpachi2k11
c308545e23 Replaced 'bonus2 bVariableCastrate' with 'bonus2 bCastrate' in pre-renewal item databases. (bugreport:6913)
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16938 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-21 13:03:30 +00:00
momacabu
390e680403 Updated all items which had groupranditem with getrandgroupitem (better implementation done by Ind)
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16932 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-20 03:47:31 +00:00
flaid
804dd86ce4 Shiny Wing Gown was set to tame the wrong monster, fixed now.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16886 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-09 04:33:14 +00:00
momacabu
bfb15e68b7 - Removed backup.pl (for TXT servers) and vs9-to-vs8.php (outdated versions);
- Merged @killmonster2 with @killmonster tid:73632;
- Fixed bugreport:6764, auction code was misplaced;
- Follow up to r16753 (bugreport:6523), fixed bugreport:6673, using Gravitational Field with Safety Wall would keep the character immobilized. Blame myself, thankyou Lunar for the fix;
- Fixed bugreport:6514, @slaveclone wouldn't be targeted by monster. Thanks to zippy;
- Fixed bugreport:6837, some code was duplicated;
- Fixed bugreport:6768, removed some leftovers from TXT removal;
- Fixed bugreport:6868, Unequipping a weapon with Incantation Samurai card will not kill you if you have less than 999 hp and are on a non-pvp map;
- Fixed wrong bit field on ai field in mob_data structure. Credits to Ind.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16881 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-09 00:26:36 +00:00
brianluau
d4ce93e297 - Fixed more missing single quotes in item_db.sql, follow up to r16822.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16831 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-10-27 04:51:15 +00:00
brianluau
51fd7bb19f - Fixed missing single quotes in item_db.sql, follow up to r16822.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16830 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-10-27 04:42:17 +00:00
spre123
d0857bd997 Fixed bCastrate function in item_combo_db. bugreport:6815
Fixed Item 13694, Freyas Crown Box Changed getitem to the official rentitem Item Script(verified By Joseph and muad). Continuation of bugreport:6714

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16828 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-10-25 07:27:43 +00:00
spre123
b8d1e233e6 major item update activating many script commands aswell as activating many items that are now in the client this effects 250+ items. Bugreport:6714
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16822 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-10-20 00:42:55 +00:00
spre123
723b7cc244 Updated Items, Uncommented the Traditional Cookie as it works fine and is needed for a pet. Also updated The Groomers That sell it. Bugreport:6734 [Spre]
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16798 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-09-26 05:40:18 +00:00
euphyy
883bf49465 * Updated Renewal 'Mjolnir' item (bugreport:6646)
* Updated slots on RWC 2008 Dragon Helms (bugreport:6645)
* Other minor changes...

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16765 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-09-08 19:58:00 +00:00
kenpachi2k11
a31d779891 Fixed Angelic Rings (#2743) autobonus duration. (bugreport:6434)
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16686 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-22 19:46:01 +00:00
kenpachi2k11
c7a2d75bcb Updated all glorious weapons. (bugreport:5013)
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16673 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-20 21:07:52 +00:00
kenpachi2k11
789ec79a39 Renamed bMatk and bWeaponMatk to make it easier to understand the bonus when reading the DB file.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16649 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-17 10:51:44 +00:00
euphyy
36b556a954 * Fixed cutin errors in Fortune script, bugreport:6466 (other\fortune.txt)
* Fixed item #5503, bugreport:6440

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16630 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-13 14:41:57 +00:00
euphyy
922c1158a2 * Added missing quotes around some skill names in item DB, thanks Kenpachi! (bugreport:6405)
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16577 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-04 15:07:24 +00:00
kenpachi2k11
d411a5064b Follow up r16523 - Interchanged attack and atk:matk in pre-RE and RE item DB creation script.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16524 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-28 19:43:36 +00:00
kenpachi2k11
95bc3edbe3 Updated SQL item DBs to match with their TXT versions. (Now tested...)
Follow up r16520 - applied mob DB changes to the DBs, too.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16523 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-28 19:16:30 +00:00
kenpachi2k11
8dc6db3cd5 Reverted item_db.sql and item_db_re.sql to r16512. (bugreport:6349)
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16517 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-27 23:32:41 +00:00
kenpachi2k11
875e7d9577 Follow up r16513 - My converter had one more bug where not all quotes were escaped properly. More shame on me. :(
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16516 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-27 23:14:01 +00:00
kenpachi2k11
c1db276433 Follow up r16513 - My converter had a bug where comments where includded into the OnUnequipScript. Shame on me. :(
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16514 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-27 21:57:25 +00:00
kenpachi2k11
bbfd5ae3c5 Synced SQL DBs and added RE SQL-script for mob_skill_db.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16513 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-27 21:38:01 +00:00
kenpachi2k11
fd771e1087 Fixed some BRO Package item scripts. (bugreport:6319)
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16498 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-25 10:09:13 +00:00
kenpachi2k11
b44899edac Follow up r16494 - added bonus script to the SQL version of item #12311.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16497 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-25 08:40:10 +00:00
kenpachi2k11
cb618b47e4 Follow up r16466 - forgot the move the proper files over after editing them again. Sorry!
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16467 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-21 22:45:44 +00:00
kenpachi2k11
653ba17216 Renamed bUseSPrateSkill to bSkillUseSPrate.
Added bSkillUseSP.
Added documentation for bSkillUseSPrate(bUseSPrateSkill), bSkillUseSP, bSkillCooldown, bSkillFixedCast, bSkillVariableCast, bSkillFixedCast and bVariableCastrate. (bugreport:6193)
Fixed Enriched White PotionZs (#12428) and Enrich Celermine Juices (#12437) bonus script. (bugreport:5790)
Fixed Mental Sticks (#1654) bonus script. (bugreport:6071)

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16466 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-21 22:15:28 +00:00
jtynne
ee6ca5d682 - Added proper scripts to Imp, Sleeper, Gryphon Hats.
- Fixed minor grammatical error in Sleeper Hat name.
- Added proper RE bonus to Bradium Ring script.
- Uncommented proper RE MATK bonus on Entweihen, Scaraba, Banshee Master, and Centipede Larva Cards.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16464 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-21 17:41:08 +00:00
euphyy
44c564bae8 * Optimized "Magic Books" quest, 60% size reduction (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-20 04:14:49 +00:00
cookiecrumbs
bb874f80b4 Added new status bonuses: SC_INCMHP and SC_INCMSP to increase maximum HP and 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-20 03:35:52 +00:00
euphyy
1bdf177a0b * Neuralizer is no longer consumed upon failure (bugreport:6040)
* 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-07-02 18:09:25 +00:00
flaid
3a3540a550 Fixed a wrong SQL stat script.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16310 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-16 03:11:43 +00:00
flaid
1ec9c82750 item_db stat optimization and fix bugreport:6001
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16307 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-15 21:30:17 +00:00
rikimaru17
b3774b92cf git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16291 54d463be-8e91-2dee-dedb-b68131a5f0ec 2012-06-13 19:22:49 +00:00
flaid
d5b8b87721 Added iRO hats and matk fixes into SQL
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16275 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-12 08:12:27 +00:00
kenpachi2k11
e1cd46aaca Follow up r16249 - enabled double attack ability for all weapon types in all 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-10 21:00:08 +00:00
kenpachi2k11
a43e9fd3ea Fixed Concentrated White Potion(Z)s script. (bugreport:5895)
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-10 15:24:04 +00:00
kenpachi2k11
2af91b2fa8 Fixed Black Wing, Peuz's and Ur's sets, Scarlet Rose' (#5548) location and 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-09 23:12:19 +00:00
kenpachi2k11
84aaa2acc0 Fixed some Genetic items related to Pharmacy skill. (bugreport:5790)
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16250 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-09 21:03:30 +00:00
kenpachi2k11
5b1eb9712a Follow up r16248 - changed table name for Canon Balls (#18000-#18004) to 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-09 20:17:21 +00:00