Commit graph

497 commits

Author SHA1 Message Date
Mr.Postman
c2293db51e Fixed missing table 2013-07-14 07:19:36 +07:00
shennetsind
1584c6d40e Fix for Bug #7507
Merged from rAthena, there is no commit to refer to as I've obtained the missing entries from their latest file.
Special Thanks to jTynne
http://hercules.ws/board/tracker/issue-7507-items-missing-from-item-d/

Signed-off-by: shennetsind <ind@henn.et>
2013-07-11 16:56:29 -03:00
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
Akkarinage
3136a514a1 Whitespace, TABs & Spellings
Replaced indents using spaces with tabs, reducing file sizes and
conforming to standards.
2013-06-14 21:27:02 +01: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
shennetsind
219a4f5267 Fixed missing default in upgrade file
All credits to kyeme! thank you!

Signed-off-by: shennetsind <ind@henn.et>
2013-04-27 17:34:36 -03:00
shennetsind
2967335cb4 Fixed Bug #7127
Also Implemented allow party invitations state.
Implemented saving of client options (atm show_equip and allow party invitation)
http://hercules.ws/board/tracker/issue-7127-view-equipment/

Signed-off-by: shennetsind <ind@henn.et>
2013-04-15 23:27:29 -03:00
shennetsind
1c9fdc0d3b Fixed Bug #7154
http://hercules.ws/board/tracker/issue-7154-equipment-based-skills-skill-891-for-example-persisting-through-resetsremoving-gears/
Merge of 3a9bacc515
Special Thanks to akinari1087
http://hercules.ws/board/topic/410-skill-script-command-updatefix/

Signed-off-by: shennetsind <ind@henn.et>
2013-04-15 22:32:10 -03:00
shennetsind
81bc395cc1 Fixed missing apostrophe
all credits to the awesome jTynne :3 thank you!

Signed-off-by: shennetsind <ind@henn.et>
2013-04-11 18:22:48 -03:00
euphyy
000dd6aa4d * Added remaining Malangdo coin traders.
* Renewal item database update:
-- Implemented nearly all remaining Malangdo items.
-- Added Upg_* boxes (follow-up r17180).
-- Corrected many kRO names.
* Updated Renewal item_trade database for Dewata, Malangdo, and Upg_* boxes.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17186 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-04-11 16:13:31 -03: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
euphyy
5852d650d3 * Renewal item updates, mostly misc items (incl. bugreport:7167).
* A couple of quest_db updates.
* Moved El Dicastes Guide to a separate file and fixed viewpoint syntax.
* Fixed bugreport:7238, two mob skill mode changes.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17122 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-04-11 15:30:28 -03:00
shennetsind
889a866e92 Introducing Slot Change feature
Special Thanks to Yommy for providing the packet structure/data.

Signed-off-by: shennetsind <ind@henn.et>
2013-03-27 15:38:32 -03:00
shennetsind
abe2a62917 Follow up 7436a70cde
Added in-file instructions

Signed-off-by: shennetsind <ind@henn.et>
2013-03-17 02:48:22 -03:00
shennetsind
7436a70cde Adding eAthena -> Hercules SQL Upgrade File
As Requested in http://hercules.ws/board/topic/273-sql-upgrade-files-not-exits/

Signed-off-by: shennetsind <ind@henn.et>
2013-03-17 02:33:48 -03:00
lemongrass3110
a0ed4da171 Start to standardize the database files.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17198 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-03-14 12:28:30 -08:00
Streusel
6505c332f1 -Updated DB, Credits to Euphy & Lemongrass
-Added coin_exchange.txt Credits to EUphy & Lemongrass
2013-03-14 12:25:07 -08:00
Streusel
44e8c096c5 -Vellum's aegis name is Velum, display name is Vellum 2013-03-10 15:57:30 -08:00
Streusel
838168a6b4 -Added Upg items, Credits to Euphy
-Renamed Bellum items to Vellum
-Updated sql file according to above listed changes
2013-03-09 03:00:07 -08:00
shennetsind
d2d734ce09 Hercules Renewal'd Pin Code
Feature is not, I repeat, NOT complete. the decryption is not fully functional which leads to dial values  different from the ones the player used.
Credits:
lemongrass3110 for the base
yommy for the packets
LightFighter for the decrypt function (altho its not stable :P)

Signed-off-by: shennetsind <ind@henn.et>
2013-03-09 00:04:28 -03:00
lemongrass3110
64dc4dbf9c Updated dewata to match the official scripts.
This commit includes a optional SQL upgrade file, that will reset all the dewata quests and the related variables, that your users have done.

Thanks to Euphy for helping me and additionally thanks to Flaid for taking his time to test our conversion.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17178 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-03-06 22:08:16 -08:00
Streusel
7bafb75f42 -Updated EXP table
-Updated healing items & costume items
-Updates item_db_re.sql for last commits healing item update, Credits to Euphy
2013-03-06 14:12:18 -08:00
Streusel
3949564603 -Added Malangdo Enchantments, credits to Euphy
-Fixed Guillotine Cross job change, credits to Euphy
-Updated message display of Malangdo NPC's, credits to Euphy
-Updated item_db_re.sql
2013-03-05 13:00:41 -08:00
euphyy
b5123b2510 * Updated Endless Tower instance to latest official script.
-- String "Floor" changed to "Level".
-- Warp portals open after a 5 second delay.
* Renewal item database fixes (bugreport:7301, bugreport:7308).

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17165 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-03-05 11:59:56 -08:00
playtester
f6777219cc - Fixed amount of item slots on orbs and assassin's glove thanks to letskay (bugreport:7309 and bugreport:7312)
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17164 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-03-05 11:52:33 -08:00
shennetsind
bafe9ad228 Followup 0241d01955
git's commit-per-line thing fooled me, it skipped this line.

Signed-off-by: shennetsind <ind@henn.et>
2013-03-04 22:27:09 -03:00
shennetsind
0241d01955 Introducing account-dependent character slot count
As requested in http://hercules.ws/board/topic/248-reserved-slot-system/

Signed-off-by: shennetsind <ind@henn.et>
2013-03-04 22:22:30 -03:00
euphyy
06526e32ea * Part one of fixing bugreport:6527. This does not yet change functionality.
-- Added 'disable_items' to all applicable scripts.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17160 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-02-25 21:22:29 -08:00
Streusel
625981b877 -Added new items (Credits to Muad_Dib)
-Fixed my previously incorrect bAllStats spelling
-Removed & re-added most of my previously assigned unbreakable heagears
-Fixed weight on 3 other already existing ones
-Added Fly Wing to Poring & Lunatic in the mob_db_re.sql
2013-02-21 01:13:55 -08:00
shennetsind
4ce4adceac Updated main.sql to reflect the latest sql_updates entries
Signed-off-by: shennetsind <ind@henn.et>
2013-02-16 20:35:36 -02:00
shennetsind
651d6857d7 MySQL Update Checker: Updated
Added a primary key to the `sql_updates` table (special thanks to Trojal)
Modified the parser to ignore new/empty lines and added support for "//" comments in the index file.

Signed-off-by: shennetsind <ind@henn.et>
2013-02-15 18:15:57 -02:00
shennetsind
2bc85620e0 Fixed Bug #5018
Skills granted through scripts are now permanent, until this date they were not relog persistent

Signed-off-by: shennetsind <ind@henn.et>
2013-02-14 17:18:11 -02:00
shennetsind
810ba40b78 Introducing MySQL DB Update Checker
First version.

Signed-off-by: shennetsind <ind@henn.et>
2013-02-14 17:15:36 -02:00
shennetsind
7a8857cbf7 Reverting 4b41901d3e
I was using a different git client when I committed that, and it committed all my unstaged changes, not using that client anymore :[.

Signed-off-by: shennetsind <ind@henn.et>
2013-02-08 21:52:20 -02:00
shennetsind
4b41901d3e Fixing a logical issue in ST_RIDING 2013-02-08 21:41:04 -02:00
akrus
bb61951098 Getting rid of unused indexes.
Source: http://dev.mysql.com/doc/refman/5.5/en/multiple-column-indexes.html
If the table has a multiple-column index, any leftmost prefix of the index can be used by the optimizer to find rows. For example, if you have a three-column index on (col1, col2, col3), you have indexed search capabilities on (col1), (col1, col2), and (col1, col2, col3).
2013-02-04 14:13:38 +04:00
Matheus Macabu
524291493e Merged some commits from rAthena. 2013-02-04 00:32:19 -02:00
Mysteries
2f02be9760 Merged rAthena r17103
Added and updated many Renewal item scripts (incl. bugreport:7162,
bugreport:7147).

Some formatting changes in Clothes Dyer script (incl. bugreport:7204).
2013-02-03 20:48:15 -05:00
brianluau
8b05b9b819 - Added svn:eol-style=native property.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17087 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-01-08 09:31:58 +00:00
markzd
5d1712c148 * Renaming variable name from nsiuid to unique_id for better understanding of its meaning, as requested on tid:69380.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17086 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-01-08 05:31:06 +00:00
markzd
cf31e4f05b * Follow Up: r17080
1. Removed an unnecessary update call.
   2. Implemented interreg table at main.sql.
   
* Follow Up: r17077, r17072, r17065
   1. Fixed bugreport:7078, removed unnecessary checks.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17081 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-01-07 06:01:48 +00:00
markzd
24987d8513 * Implemented Unique identifier for Non stackable items. (tid:69380)
* Set as off by default, it can be changed in /src/config/core.h.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17080 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-01-07 05:13:54 +00:00
euphyy
a337fe03f0 * Added Somotology Laboratory F4 quest (written by Ziu, translated by Heris, uses some iRO dialogues).
* Updated quest_db with Somotology Laboratory F4 entries (5113-5125 are placeholders, may be incorrect).
* Moving of warp files, reducing the number of duplicates in pre-re/re paths.
* Added a note to documentation (bugreport:7065) and fixed a small mistake (bugreport:7068).
* Follow-up r17056, missing $ (bugreport:7067) and added a missing item.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17063 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-12-30 02:05:43 +00:00
euphyy
07ae3aa642 * Added more Malangdo scripts.
* Updated quest_db with more translated Malangdo entries.
* Added and updated some newer items.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17060 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-12-29 05:30:43 +00:00
euphyy
a691c52d01 * Custom Quest Shop updated to v1.6, which adds support for bulk purchases.
* Follow-up r17014, fixed a typo in main.sql -- credits to Jeroen for finding that.
* Follow-up r17039, missed a parameter -- thanks, clydelion/mkbu95!

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17040 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-12-24 02:56:49 +00:00