Help|NCDB Items Table

[alex5025]

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

[MentaL]

[gmaze]

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.

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;

[alex5025]

no i dont mean playeritems i mean items i dont have thet table so i have no items

[alex5025]

please some one?

[Viperwow]

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)

[alex5025]

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

[titus4k]

items.sql has ben fixed in rev 586.

t4k