Hercules Renewal Phase : Renewal SQL Files - Hercules bug tracker archive

Issue information

Issue ID

#7352

Status

Fixed

Severity

None

Started

ossi0110

Jun 13, 2013 17:49

Last Post

Ind

Jun 14, 2013 16:39

Confirmation

N/A

ossi0110 - Jun 13, 2013 17:49

Since the Hercules Renewal Phase : Renewal update from yesterday,

All SC_NAMES in the itemdb.txt got changed , but the Item.DB SQL files didnt got a update for them

so ppls who are using SQL item.dbs atm dont got a upgrade file for the new SC changes.

This post has been edited by ossi0110 on Jun 13, 2013 17:49

jTynne - Jun 14, 2013 4:24

REPLACE INTO `item_db` VALUES (645,'Center_Potion','Concentration Potion',2,800,NULL,100,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'sc_start SC_ASPDPOTION0,1800000,0;',NULL,NULL);
REPLACE INTO `item_db` VALUES (656,'Awakening_Potion','Awakening Potion',2,1500,NULL,150,NULL,NULL,NULL,NULL,0xFFF7FEEF,7,2,NULL,NULL,40,NULL,NULL,'sc_start SC_ASPDPOTION1,1800000,0;',NULL,NULL);
REPLACE INTO `item_db` VALUES (657,'Berserk_Potion','Berserk Potion',2,3000,NULL,200,NULL,NULL,NULL,NULL,0x01E646A6,7,2,NULL,NULL,85,NULL,NULL,'sc_start SC_ASPDPOTION2,1800000,0;',NULL,NULL);

There's a number more, haven't gone through everything yet but have a team working to find discrepancies on my test server. As they're found, will continue to post until they're fixed in the files. XD

Ind - Jun 14, 2013 5:22

I'll write a converter and update it all at once.

Ind - Jun 14, 2013 16:39

Fixed in [url="https://github.com/HerculesWS/Hercules/commit/5321d32c8d670fbfbfe02f7df5066170aa20ee2e"]https://github.com/HerculesWS/Hercules/commit/5321d32c8d670fbfbfe02f7df5066170aa20ee2e[/url]
Thank you all