Well the title pretty much says it all. I just updated my DB to some MGT database or something.. I dunno I was told it was good. Anyways now when you try to login the chars are naked and their items are gone. How do i fix this? Thank you
DarkJade
Printable View
Well the title pretty much says it all. I just updated my DB to some MGT database or something.. I dunno I was told it was good. Anyways now when you try to login the chars are naked and their items are gone. How do i fix this? Thank you
DarkJade
I suggest you to use a newer DB, the best is NCDB, so just Grab The Newest one: NCDB Rev 633. ;)Quote:
Originally Posted by DarkJade
Edit the tool file with a text editor and give your user and pass info aswell as your World and Character DB.
Good Luck!
Where you got that Rev633? oOQuote:
Originally Posted by SkH
From the very source!! ;)Quote:
Originally Posted by s3m3L
or just run thisQuote:
Originally Posted by DarkJade
alter table playeritems add column randomsuffix int(30) default 0 after randomprop;
i tried that it didnt help
try these rev 1844 ALTER TABLE playerpets DROP COLUMN autocastspell; UPDATE playerpets SET actionbar=""; rev 1923 alter table playeritems add column randomsuffix int(30) default 0 after randomprop; rev 2068 CREATE TABLE `playeritems_external` ( `ownerguid` int(10) unsigned NOT NULL DEFAULT '0', `guid` bigint(20) unsigned NOT NULL DEFAULT '0', `entry` int(10) unsigned NOT NULL DEFAULT '0', `creator` int(10) unsigned NOT NULL DEFAULT '0', `count` int(10) unsigned NOT NULL DEFAULT '0', `charges` int(10) unsigned NOT NULL DEFAULT '0', `flags` int(10) unsigned NOT NULL DEFAULT '0', `randomprop` int(10) unsigned NOT NULL DEFAULT '0', `randomsuffix` int(30) NOT NULL, `itemtext` int(10) unsigned NOT NULL DEFAULT '0', `durability` int(10) unsigned NOT NULL DEFAULT '0', `containerslot` int(11) DEFAULT '-1' COMMENT '', `slot` tinyint(4) NOT NULL DEFAULT '0', `enchantments` longtext COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`guid`), UNIQUE KEY `guid` (`guid`), KEY `ownerguid` (`ownerguid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; alter table mailbox add column external_attached_item_guid bigint(20) not null default 0 after attached_item_guid; if you need any later revisions lemme know
it appears its word wrapped :/ dont copy all of it,each part starts at "rev"
I have ascent rev2088