i updated my server to rev 584 and now i dont have the items table i dont know how i download it form the svn now my player is naked
Printable View
i updated my server to rev 584 and now i dont have the items table i dont know how i download it form the svn now my player is naked
your playeritems should of been in your character database, if you update it, it will erase all items already in there.
In other words, the basic table I can get you, your items are gone.
Code:CREATE TABLE `playeritems` (
`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(11) NOT NULL default '0',
`itemtext` int(10) unsigned NOT NULL default '0',
`durability` int(10) unsigned NOT NULL default '0',
`containerslot` int(11) NOT NULL default '-1',
`slot` tinyint(4) NOT NULL default '0',
`enchantments` longtext NOT NULL,
PRIMARY KEY (`guid`),
KEY `ownerguid` (`ownerguid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
no i dont mean playeritems i mean items i dont have thet table so i have no items
please some one?
You can downgrade to 575 with items,than create from your 575 ncdb sql file with table "items",then drop your 575 and execute 584!(after this execute your "items" table)
ok i will do it but why did they deleted the items table?
BTW whats the site of ncdb cuz ncdb.info dosent work for me
items.sql has ben fixed in rev 586.
t4k