EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)
-   -   0.6.6 -724 Char Backup bug (https://www.eqemulator.org/forums/showthread.php?t=20222)

typhoon 03-20-2006 09:23 AM

0.6.6 -724 Char Backup bug
 
This was probably in the previous versions of 0.6.6, but when the new guild structure was updated the query and table for character_backup wasn't updated. So now, whenever the auto character_backup kicks in I get an error about guild not being in the update and then it looks like the connection is lost and the characters are hung in the zone.

When the character table was altered to take the guilds out of it, it was never done to the character_backup table.

Looks like this needs to be done to the character_backup table:
ALTER TABLE character_backup ADD class TINYINT NOT NULL DEFAULT 0;
ALTER TABLE character_backup ADD level MEDIUMINT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE character_backup DROP guild;
ALTER TABLE character_backup DROP guildrank;
ALTER TABLE character_backup DROP publicnote;

I didn't go through the code yet but I but I am sure the query needs to be updated also so the insert into the character_backup will work.

fathernitwit 03-20-2006 03:26 PM

changes made, thanks.


All times are GMT -4. The time now is 04:47 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.