Page 1 of 1

[FIX] Fatal Error (quickbar)

PostPosted: Tue Jun 24, 2008 6:38 pm
by soccerstar
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.
  1. ALTER TABLE `characters` CHANGE `quickbar` `quickbar` VARCHAR( 512 ) NOT NULL DEFAULT '0',
  2. 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',
  3. 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',
  4. 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',
  5. 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';