[FIX] Fatal Error (quickbar)

If you want to help us or give some corrections / codes, put it here :)

Moderators: osRose dev team, ospRose dev team, osiRose dev team, Moderators

[FIX] Fatal Error (quickbar)

Postby soccerstar on 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.
  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';
Attachments
characters.rar
(573 Bytes) Downloaded 850 times
Search, Just Do It.
User avatar
soccerstar
Clown
Clown
 
Posts: 501
Joined: Tue Jun 17, 2008 12:46 am

Return to Submit Code

Who is online

Users browsing this forum: No registered users and 2 guests