summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2015-09-19ItemDB SQL SyncHercules.ws1-0/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-09-17Added redundancy to some SQL statements.GammCrucis1-35/+34
Closes #641 Signed-off-by: Haru <haru@dotalux.com>
2015-09-07ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-09-06ItemDB SQL SyncHercules.ws1-2/+5
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-08-30Follow up@2b4b33b06a964e83bf5df9f7f0b795ddf76f9dd0malufett1-0/+1
- missing sql upgrade index. Signed-off-by: malufett <malufett.eat.my.binaries@gmail.com>
2015-08-27Hotkey Rotate Packet ImplementedDastgir2-0/+5
2015-08-10Corrected an issue with the last SQL updateHaru2-1/+2
- Follow-up to 8caa0e564b5331a88d8dc1712513368b37ba9694 - It's safe to re-apply the related sql update script (sql-files/upgrades/2015-07-08--13-08.sql) in order to get rid of the 'detected 1 new SQL updates' message. - Thanks to KirieZ Signed-off-by: Haru <haru@dotalux.com>
2015-08-09Removed unused tables sstatus and interregHaru3-21/+8
Signed-off-by: Haru <haru@dotalux.com>
2015-07-12ItemDB SQL SyncHercules.ws1-278/+278
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-07-12ItemDB SQL SyncHercules.ws1-1/+9
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-07-08ItemDB SQL SyncHercules.ws3-15782/+15782
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-07-08Update Unique ID system to match official now it cover all cash items ↵Ibrahim Hossam6-1/+62
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-06-25ItemDB SQL SyncHercules.ws2-4/+4
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-06-24ItemDB SQL SyncHercules.ws2-18/+18
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-06-13ItemDB SQL SyncHercules.ws1-2/+2
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-06-12ItemDB SQL SyncHercules.ws1-51/+51
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-06-12ItemDB SQL SyncHercules.ws1-241/+241
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-06-12ItemDB SQL SyncHercules.ws1-1089/+1241
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-06-12ItemDB SQL SyncHercules.ws1-160/+160
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-06-02Follow up to 712812bMysteries1-1/+1
- More link changes - Added proper link to Roulette topic
2015-05-17ItemDB SQL SyncHercules.ws1-6/+6
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-05-09ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-05-01ItemDB SQL SyncHercules.ws1-2/+2
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-04-27ItemDB SQL SyncHercules.ws1-1672/+1672
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-04-26ItemDB SQL SyncHercules.ws2-14/+14
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-04-22ItemDB SQL SyncHercules.ws1-17/+17
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-04-14ItemDB SQL SyncHercules.ws1-42/+121
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-04-06ItemDB SQL SyncHercules.ws1-7/+7
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-04-06ItemDB SQL SyncHercules.ws1-7/+7
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-04-04ItemDB SQL SyncHercules.ws1-61/+131
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-04-01ItemDB SQL SyncHercules.ws1-0/+3
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-03-31ItemDB SQL SyncHercules.ws1-8/+70
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-03-30ItemDB SQL SyncHercules.ws1-33/+414
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-03-24ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-03-24ItemDB SQL SyncHercules.ws1-7/+7
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-03-11ItemDB SQL SyncHercules.ws1-0/+8893
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-03-11ItemDB SQL SyncHercules.ws1-8893/+0
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-03-09ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-03-05ItemDB SQL SyncHercules.ws1-9/+562
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-02-15ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-02-15ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-01-25ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-01-22Removed name distinction between (sql) mob/item/mob_skill db and db_re variantsHaru3-8349/+8349
- Since there (currently and in future) is no difference between the table structure for renewal and pre-renewal databases, it makes no sense to have extra code that makes a distinction between their names. A server will always use either one or the other, never both at the same time. - If you have a mob_db_re, mob_skill_db_re and/or item_db_re table, please rename it to mob_db, mob_skill_db and/or item_db_re, respectively. - No upgrade script provided. I'd like to remind everyone that these tables are optional (and deprecated), and they are only offered for convenience for those who need them for web control panels and similar software. Signed-off-by: Haru <haru@dotalux.com>
2015-01-10ItemDB SQL SyncHercules.ws1-1/+10
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-12-28Split mob sql database into mob_db and mob_db_re.malufett2-6/+6
-http://hercules.ws/board/topic/8084-separate-the-mob-db-and-mob-db-re/
2014-12-07ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-11-07ItemDB SQL SyncHercules.ws2-6/+9
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-11-04ItemDB SQL SyncHercules.ws1-0/+3
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-11-04Added missing sql_updates query in main.sqldastgir1-0/+1
2014-11-03ItemDB SQL SyncHercules.ws2-4/+6
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>