[FIX] Fatal Error (quickbar)
Posted: Tue Jun 24, 2008 6:38 pm
Seems like this question comes up every week so i am just going to try to put an end to it here
the characters table is the one that messes everything up so here is a good copy of it
[Drakia] (Sorry about editing your post soccer )
Also, for people who already have a characters table, and somehow got data into it, here's the SQL to fix it without losing data.
the characters table is the one that messes everything up so here is a good copy of it
[Drakia] (Sorry about editing your post soccer )
Also, for people who already have a characters table, and somehow got data into it, here's the SQL to fix it without losing data.
- ALTER TABLE `characters` CHANGE `quickbar` `quickbar` VARCHAR( 512 ) NOT NULL DEFAULT '0',
- CHANGE `askill` `askill` VARCHAR( 512 ) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
- CHANGE `askilllvl` `askilllvl` VARCHAR( 512 ) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
- CHANGE `pskill` `pskill` VARCHAR( 512 ) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
- CHANGE `pskilllvl` `pskilllvl` VARCHAR( 512 ) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0';