Latest update as of 1/2/14
Posted: Sat Jan 03, 2015 3:16 pm
For those that are lost on why everything is blowing up, some stuff changed. This is only needed if you preserve character data, and this only updates for character related tables.
First off, you may want to wipe your ls's and start over. It's easier.
delete from char_inventory where itemid = 513 or itemid = 514 or itemid = 515;
Second off, you need to open char_inventory and add extra blob(24) default null.
alter table char_inventory add extra blob(24);
Third, you need to add zoning to char_stats.
alter table char_stats add zoning tinyint(1) unsigned not null default '0';
Next you can clear your linkshells table.
delete * from linkshells;
Now you want to clean up your char_inventory table
alter table char_inventory drop column locked, drop column col, drop column row, drop column level, drop column rotation, drop column currCharges, drop column lastUseTime, drop column worn, drop column augment0, drop column augment1, drop column augment2, drop column augment3, drop column trialNumber;
I say start over with the linkshells because it's easier, however if you're curious, linkshells are populated with a blob in extra in the char_inventory table. I pulled it's contents from a newly created linkshell and it showed 'E\0\0\0\0\0��\0��4�\0\0\0\0\0\0\0\0\0\0'. However if you update char_inventory set extra = 'E\0\0\0\0\0��\0��4�\0\0\0\0\0\0\0\0\0\0' where itemid = 513 or itemid = 514 or itemid = 515; you will assign all linkpearls to the same "chat", so regardless of which pearl you have on, you chat in the same channel with each other. After messing iwth it a bit, I decided it was easier to start over.
And thanks KJ for cleaning all that up. Here's hte commit in question:
https://github.com/DarkstarProject/dark ... 86a5017917
Also it resets all item charges to full charge, and on zoning it refills all charges, but that should be fixed shortly.
If you log in dead, you need to add the zoning field to char stats:
alter table char_stats add zoning tinyint(1) not null default '0';
Edited to address the dead issue.
First off, you may want to wipe your ls's and start over. It's easier.
delete from char_inventory where itemid = 513 or itemid = 514 or itemid = 515;
Second off, you need to open char_inventory and add extra blob(24) default null.
alter table char_inventory add extra blob(24);
Third, you need to add zoning to char_stats.
alter table char_stats add zoning tinyint(1) unsigned not null default '0';
Next you can clear your linkshells table.
delete * from linkshells;
Now you want to clean up your char_inventory table
alter table char_inventory drop column locked, drop column col, drop column row, drop column level, drop column rotation, drop column currCharges, drop column lastUseTime, drop column worn, drop column augment0, drop column augment1, drop column augment2, drop column augment3, drop column trialNumber;
I say start over with the linkshells because it's easier, however if you're curious, linkshells are populated with a blob in extra in the char_inventory table. I pulled it's contents from a newly created linkshell and it showed 'E\0\0\0\0\0��\0��4�\0\0\0\0\0\0\0\0\0\0'. However if you update char_inventory set extra = 'E\0\0\0\0\0��\0��4�\0\0\0\0\0\0\0\0\0\0' where itemid = 513 or itemid = 514 or itemid = 515; you will assign all linkpearls to the same "chat", so regardless of which pearl you have on, you chat in the same channel with each other. After messing iwth it a bit, I decided it was easier to start over.
And thanks KJ for cleaning all that up. Here's hte commit in question:
https://github.com/DarkstarProject/dark ... 86a5017917
Also it resets all item charges to full charge, and on zoning it refills all charges, but that should be fixed shortly.
If you log in dead, you need to add the zoning field to char stats:
alter table char_stats add zoning tinyint(1) not null default '0';
Edited to address the dead issue.