Commit graph

46 commits

Author SHA1 Message Date
hwsapibot
c09c1b5a57
Update item_db SQL data
Signed-off-by: hwsapibot <dev@herc.ws>
2026-04-18 17:30:38 +00:00
hwsapibot
5b4f4c6422
Update item_db SQL data
Signed-off-by: hwsapibot <dev@herc.ws>
2025-02-01 00:18:03 +00:00
hwsapibot
bbf3f0eff4
Update item_db SQL data
Signed-off-by: hwsapibot <dev@herc.ws>
2024-02-04 01:31:13 +00:00
Haru
daca5167ed
Welcome to 2024, Hercules
(update copyright year in headers)

Signed-off-by: Haru <haru@dotalux.com>
2024-02-04 02:26:34 +01:00
hwsapibot
1719dc6615
Update item_db SQL data
Signed-off-by: hwsapibot <dev@herc.ws>
2023-01-13 00:23:47 +00:00
Kei
6a00dabf54
Synced item_db and item_db2 sql-files. 2022-02-09 20:09:37 +08:00
Hercules.ws
b5d5d5ef86
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2022-01-05 15:46:10 +01:00
Hercules.ws
2e6241f0fe
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2021-01-02 15:02:39 +01:00
Hercules.ws
51ed760c22
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2020-12-15 02:28:43 +01:00
Hercules.ws
7e081c9157
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2020-12-14 15:35:37 +01:00
Evil Puncker
ee9e597967 Fix schema warning 2020-11-16 22:36:05 -03:00
Haru
da14478a8c
Update copyright headers for year 2020
Signed-off-by: Haru <haru@dotalux.com>
2020-01-13 03:24:07 +01:00
Hercules.ws
23f1ce53ee
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2020-01-12 16:17:46 +01:00
Hercules.ws
25f1dbc599
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2019-01-13 20:58:36 +01:00
Hercules.ws
af63b68541
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2018-07-23 01:05:52 +02:00
Hercules.ws
b4fd4c1ef8
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2018-01-09 10:01:35 +01:00
Haru
8843fa5ae4
Item DB SQL Update
Signed-off-by: Haru <haru@dotalux.com>
2017-09-17 17:48:11 +02:00
Hercules.ws
c6702cda77
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2017-04-09 15:25:51 +02:00
Hercules.ws
71efcf093e
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2017-01-02 07:15:36 +01:00
Hercules.ws
55fbd44624
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-10-03 15:39:36 +02:00
Hercules.ws
2895839430 ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2016-07-02 19:18:37 +02:00
Haru
1d405de7e4 Added support for the textual "Job" field to the itemdb2sql converter
Signed-off-by: Haru <haru@dotalux.com>
2016-03-06 19:17:12 +01:00
Hercules.ws
babc4d54f2 ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2016-01-03 06:02:34 +01:00
Haru
da78cd6027 Added GPL-compliant header to sql files
Signed-off-by: Haru <haru@dotalux.com>
2015-12-15 20:53:49 +01:00
Hercules.ws
7b1293c3ca ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-07-08 03:44:41 +02:00
Ibrahim Hossam
856b6f1feb Update Unique ID system to match official now it cover all cash items include stackable ones.
Implement ForceSerial option in Package Item Database to force serial for
any item.
Implement ForceSerial option in item database to force serial for any item.
Implement Merge Client interface to merge stackable items with serial numbers ( check npc/other/item_merge.txt ).
2015-07-08 03:26:34 +02:00
Hercules.ws
2bf392d15b ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-31 03:30:14 +02:00
Hercules.ws
cadd611560 ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-31 02:30:43 +02:00
shennetsind
1f5161a2bd Official Item BindOnEquip Support
Implements the 'BindOnEquip' item db field which determines whether the piece of equipment should bind to the character upon being equipped.
When a character tries to equip such a item for the first time a dialog shows up asking the character to confirm whether to equip the item or not, and notifying the character that by equipping the item it will become bound to the character, and therefore unable to be used by another character.
Special Thanks to Beret for all the information, Haruna for testing.

Signed-off-by: shennetsind <ind@henn.et>
2013-11-15 03:32:45 -02:00
Haru
59b9acb3d5 Removed redundant item_db2_re.sql
- Both databases have the same format now.
- Special thanks to Ind.

Signed-off-by: Haru <haru@dotalux.com>
2013-11-14 20:15:28 +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
brianluau
dc4f74eb17 - Fixed a typo in Strawberry Cake (12319). (bugreport:3702)
- Fixed a typo in Halloween 2009 Event. (bugreport:3711)
- Updated SQL item/mob databases to latest. (thanks Peter)
- Applied the change from r14087 to @tonpc, @shownpc, @hidenpc. (bugreport:3599)

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14142 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-11-11 21:49:50 +00:00
brianluau
9828447cdb - Fixed Snake Head Hat (5388) Double Attack bonus. (bugreport:3483)
- Added missing 'break' in some Juperos warps.
- Updated SQL item/mob databases to latest. (thanks Peter)

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14029 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-08-26 10:26:45 +00:00
brianluau
6a60859867 - Added mosk_que to the mapcache (follow up to r13903).
- Fixed some input checks and variable types in Megingjard quest.
- Updated SQL item/mob databases to latest.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13926 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-07-02 18:56:16 +00:00
brianluau
b1fbbb9cbd - Updated SQL item/mob databases to latest.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13908 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-06-23 00:15:39 +00:00
ultramage
43cd16d622 Replaced the TYPE keyword with ENGINE in all sql files, because this is the preferred alternative.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12480 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-04 21:04:47 +00:00
toms
cece111a56 Updated conversion tools for mob_db & item_db
Updated SQL Files (item & mobs)

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12138 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-01-25 16:11:39 +00:00
ultramage
2b9e300e11 Reverted / re-did r11426. Someone please update the db converter to properly handle // comments.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11429 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-12 20:46:20 +00:00
Playtester
01a7cdb581 Updated sql files (2)
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11426 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-12 20:06:16 +00:00
ultramage
4c0285aaff Added missing msg_athena.conf entry for the summer outfit; name 'Summer' used for now.
Removed strange 'svn:executable' attributes from item_db2.sql and mob_db2.sql

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11325 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-28 14:56:39 +00:00
ultramage
572e2c0dcc EOL-styled some more files
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9947 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-03-02 00:11:54 +00:00
Lance
cc03970a0f * Converted itemdb tables to use smallint. Credits to ALZ.
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-11-04 14:51:42 +00:00
skotlex
f43789777a - updated (more or less) the sql-files/item_db2.sql file.
- Some insignificant cleanups.


git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8429 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-22 14:54:29 +00:00
skotlex
42acbf2e1a - Removed db_tables.sql as it's no longer used.
- the mvp_sd is removed when the mob is the emperium and there's no killer/exp-awarded (assumed killed by script), this prevents the on-kill event from triggering and giving the castle to whoever damaged the most the emperium without destroying it.


git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7208 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-16 15:39:16 +00:00
Playtester
e9dde8ed58 Changed item_db2.sql to new format
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6212 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-21 11:51:41 +00:00
skotlex
98f7e84cd7 - Added item_db2.sql and mob_db2.sql, thanks to Joshuaali
- Added more usage of msg_athena on the slave atcommands.


git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5609 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-15 14:00:32 +00:00