After looking through all the SQL updates after trev said that might be whatsup I ran into some that were updating this table : "tblWorldServerRegistration"
Well, I don't have that table what is it.. Is it important , would it be causing this? (maybe not)
I couldn't find any of the updates really pertaining to the items or inventory table other than 1542_items_table_cleanup
Here is my Schema for Items and Inventory , maybe some one can see something I am not.
-=ITEMS=-
Code:
CREATE TABLE IF NOT EXISTS `items` (
`id` int(11) NOT NULL default '0',
`minstatus` smallint(5) NOT NULL default '0',
`Name` varchar(64) NOT NULL default '',
`aagi` int(11) NOT NULL default '0',
`ac` int(11) NOT NULL default '0',
`accuracy` int(11) NOT NULL default '0',
`acha` int(11) NOT NULL default '0',
`adex` int(11) NOT NULL default '0',
`aint` int(11) NOT NULL default '0',
`artifactflag` tinyint(3) unsigned NOT NULL default '0',
`asta` int(11) NOT NULL default '0',
`astr` int(11) NOT NULL default '0',
`attack` int(11) NOT NULL default '0',
`augrestrict` int(11) NOT NULL default '0',
`augslot1type` tinyint(3) NOT NULL default '0',
`augslot1visible` tinyint(3) default NULL,
`augslot2type` tinyint(3) NOT NULL default '0',
`augslot2visible` tinyint(3) default NULL,
`augslot3type` tinyint(3) NOT NULL default '0',
`augslot3visible` tinyint(3) default NULL,
`augslot4type` tinyint(3) NOT NULL default '0',
`augslot4visible` tinyint(3) default NULL,
`augslot5type` tinyint(3) NOT NULL default '0',
`augslot5visible` tinyint(3) default NULL,
`augtype` int(11) NOT NULL default '0',
`avoidance` int(11) NOT NULL default '0',
`awis` int(11) NOT NULL default '0',
`bagsize` int(11) NOT NULL default '0',
`bagslots` int(11) NOT NULL default '0',
`bagtype` int(11) NOT NULL default '0',
`bagwr` int(11) NOT NULL default '0',
`banedmgamt` int(11) NOT NULL default '0',
`banedmgraceamt` int(11) NOT NULL default '0',
`banedmgbody` int(11) NOT NULL default '0',
`banedmgrace` int(11) NOT NULL default '0',
`bardtype` int(11) NOT NULL default '0',
`bardvalue` int(11) NOT NULL default '0',
`book` int(11) NOT NULL default '0',
`casttime` int(11) NOT NULL default '0',
`casttime_` int(11) NOT NULL default '0',
`charmfile` varchar(32) NOT NULL default '',
`charmfileid` varchar(32) NOT NULL default '',
`classes` int(11) NOT NULL default '0',
`color` int(10) unsigned NOT NULL default '0',
`combateffects` varchar(10) NOT NULL default '',
`extradmgskill` int(11) NOT NULL default '0',
`extradmgamt` int(11) NOT NULL default '0',
`price` int(11) NOT NULL default '0',
`cr` int(11) NOT NULL default '0',
`damage` int(11) NOT NULL default '0',
`damageshield` int(11) NOT NULL default '0',
`deity` int(11) NOT NULL default '0',
`delay` int(11) NOT NULL default '0',
`augdistiller` int(11) NOT NULL default '0',
`dotshielding` int(11) NOT NULL default '0',
`dr` int(11) NOT NULL default '0',
`clicktype` int(11) NOT NULL default '0',
`clicklevel2` int(11) NOT NULL default '0',
`elemdmgtype` int(11) NOT NULL default '0',
`elemdmgamt` int(11) NOT NULL default '0',
`endur` int(11) NOT NULL default '0',
`factionamt1` int(11) NOT NULL default '0',
`factionamt2` int(11) NOT NULL default '0',
`factionamt3` int(11) NOT NULL default '0',
`factionamt4` int(11) NOT NULL default '0',
`factionmod1` int(11) NOT NULL default '0',
`factionmod2` int(11) NOT NULL default '0',
`factionmod3` int(11) NOT NULL default '0',
`factionmod4` int(11) NOT NULL default '0',
`filename` varchar(32) NOT NULL default '',
`focuseffect` int(11) NOT NULL default '0',
`fr` int(11) NOT NULL default '0',
`fvnodrop` int(11) NOT NULL default '0',
`haste` int(11) NOT NULL default '0',
`clicklevel` int(11) NOT NULL default '0',
`hp` int(11) NOT NULL default '0',
`regen` int(11) NOT NULL default '0',
`icon` int(11) NOT NULL default '0',
`idfile` varchar(30) NOT NULL default '',
`itemclass` int(11) NOT NULL default '0',
`itemtype` int(11) NOT NULL default '0',
`ldonprice` int(11) NOT NULL default '0',
`ldontheme` int(11) NOT NULL default '0',
`ldonsold` int(11) NOT NULL default '0',
`light` int(11) NOT NULL default '0',
`lore` varchar(80) NOT NULL default '',
`loregroup` int(11) NOT NULL default '0',
`magic` int(11) NOT NULL default '0',
`mana` int(11) NOT NULL default '0',
`manaregen` int(11) NOT NULL default '0',
`enduranceregen` int(11) NOT NULL default '0',
`material` int(11) NOT NULL default '0',
`maxcharges` int(11) NOT NULL default '0',
`mr` int(11) NOT NULL default '0',
`nodrop` int(11) NOT NULL default '0',
`norent` int(11) NOT NULL default '0',
`pendingloreflag` tinyint(3) unsigned NOT NULL default '0',
`pr` int(11) NOT NULL default '0',
`procrate` int(11) NOT NULL default '0',
`races` int(11) NOT NULL default '0',
`range` int(11) NOT NULL default '0',
`reclevel` int(11) NOT NULL default '0',
`recskill` int(11) NOT NULL default '0',
`reqlevel` int(11) NOT NULL default '0',
`sellrate` float NOT NULL default '0',
`shielding` int(11) NOT NULL default '0',
`size` int(11) NOT NULL default '0',
`skillmodtype` int(11) NOT NULL default '0',
`skillmodvalue` int(11) NOT NULL default '0',
`slots` int(11) NOT NULL default '0',
`clickeffect` int(11) NOT NULL default '0',
`spellshield` int(11) NOT NULL default '0',
`strikethrough` int(11) NOT NULL default '0',
`stunresist` int(11) NOT NULL default '0',
`summonedflag` tinyint(3) unsigned NOT NULL default '0',
`tradeskills` int(11) NOT NULL default '0',
`favor` int(11) NOT NULL default '0',
`weight` int(11) NOT NULL default '0',
`UNK012` int(11) NOT NULL default '0',
`UNK013` int(11) NOT NULL default '0',
`benefitflag` int(11) NOT NULL default '0',
`UNK054` int(11) NOT NULL default '0',
`UNK059` int(11) NOT NULL default '0',
`booktype` int(11) NOT NULL default '0',
`recastdelay` int(11) NOT NULL default '0',
`recasttype` int(11) NOT NULL default '0',
`guildfavor` int(11) NOT NULL default '0',
`UNK123` int(11) NOT NULL default '0',
`UNK124` int(11) NOT NULL default '0',
`attuneable` int(11) NOT NULL default '0',
`nopet` int(11) NOT NULL default '0',
`updated` datetime NOT NULL default '0000-00-00 00:00:00',
`comment` varchar(255) NOT NULL default '',
`UNK127` int(11) NOT NULL default '0',
`pointtype` int(11) NOT NULL default '0',
`potionbelt` int(11) NOT NULL default '0',
`potionbeltslots` int(11) NOT NULL default '0',
`stacksize` int(11) NOT NULL default '0',
`notransfer` int(11) NOT NULL default '0',
`stackable` int(11) NOT NULL default '0',
`UNK134` varchar(255) NOT NULL default '',
`UNK137` int(11) NOT NULL default '0',
`proceffect` int(11) NOT NULL default '0',
`proctype` int(11) NOT NULL default '0',
`proclevel2` int(11) NOT NULL default '0',
`proclevel` int(11) NOT NULL default '0',
`UNK142` int(11) NOT NULL default '0',
`worneffect` int(11) NOT NULL default '0',
`worntype` int(11) NOT NULL default '0',
`wornlevel2` int(11) NOT NULL default '0',
`wornlevel` int(11) NOT NULL default '0',
`UNK147` int(11) NOT NULL default '0',
`focustype` int(11) NOT NULL default '0',
`focuslevel2` int(11) NOT NULL default '0',
`focuslevel` int(11) NOT NULL default '0',
`UNK152` int(11) NOT NULL default '0',
`scrolleffect` int(11) NOT NULL default '0',
`scrolltype` int(11) NOT NULL default '0',
`scrolllevel2` int(11) NOT NULL default '0',
`scrolllevel` int(11) NOT NULL default '0',
`UNK157` int(11) NOT NULL default '0',
`serialized` datetime default NULL,
`verified` datetime default NULL,
`serialization` text,
`source` varchar(20) NOT NULL default '',
`UNK033` int(11) NOT NULL default '0',
`lorefile` varchar(32) NOT NULL default '',
`UNK014` int(11) NOT NULL default '0',
`svcorruption` int(11) NOT NULL default '0',
`UNK038` int(11) NOT NULL default '0',
`UNK060` int(11) NOT NULL default '0',
`augslot1unk2` int(11) NOT NULL default '0',
`augslot2unk2` int(11) NOT NULL default '0',
`augslot3unk2` int(11) NOT NULL default '0',
`augslot4unk2` int(11) NOT NULL default '0',
`augslot5unk2` int(11) NOT NULL default '0',
`UNK120` int(11) NOT NULL default '0',
`UNK121` int(11) NOT NULL default '0',
`questitemflag` int(11) NOT NULL default '0',
`UNK132` text NOT NULL,
`clickunk5` int(11) NOT NULL default '0',
`clickunk6` varchar(32) NOT NULL default '',
`clickunk7` int(11) NOT NULL default '0',
`procunk1` int(11) NOT NULL default '0',
`procunk2` int(11) NOT NULL default '0',
`procunk3` int(11) NOT NULL default '0',
`procunk4` int(11) NOT NULL default '0',
`procunk6` varchar(32) NOT NULL default '',
`procunk7` int(11) NOT NULL default '0',
`wornunk1` int(11) NOT NULL default '0',
`wornunk2` int(11) NOT NULL default '0',
`wornunk3` int(11) NOT NULL default '0',
`wornunk4` int(11) NOT NULL default '0',
`wornunk5` int(11) NOT NULL default '0',
`wornunk6` varchar(32) NOT NULL default '',
`wornunk7` int(11) NOT NULL default '0',
`focusunk1` int(11) NOT NULL default '0',
`focusunk2` int(11) NOT NULL default '0',
`focusunk3` int(11) NOT NULL default '0',
`focusunk4` int(11) NOT NULL default '0',
`focusunk5` int(11) NOT NULL default '0',
`focusunk6` varchar(32) NOT NULL default '',
`focusunk7` int(11) NOT NULL default '0',
`scrollunk1` int(11) NOT NULL default '0',
`scrollunk2` int(11) NOT NULL default '0',
`scrollunk3` int(11) NOT NULL default '0',
`scrollunk4` int(11) NOT NULL default '0',
`scrollunk5` int(11) NOT NULL default '0',
`scrollunk6` varchar(32) NOT NULL default '',
`scrollunk7` int(11) NOT NULL default '0',
`UNK193` int(11) NOT NULL default '0',
`purity` int(11) NOT NULL default '0',
`evolvinglevel` int(11) NOT NULL default '0',
`clickname` varchar(64) NOT NULL default '',
`procname` varchar(64) NOT NULL default '',
`wornname` varchar(64) NOT NULL default '',
`focusname` varchar(64) NOT NULL default '',
`scrollname` varchar(64) NOT NULL default '',
`dsmitigation` smallint(6) NOT NULL default '0',
`heroic_str` smallint(6) NOT NULL default '0',
`heroic_int` smallint(6) NOT NULL default '0',
`heroic_wis` smallint(6) NOT NULL default '0',
`heroic_agi` smallint(6) NOT NULL default '0',
`heroic_dex` smallint(6) NOT NULL default '0',
`heroic_sta` smallint(6) NOT NULL default '0',
`heroic_cha` smallint(6) NOT NULL default '0',
`heroic_pr` smallint(6) NOT NULL default '0',
`heroic_dr` smallint(6) NOT NULL default '0',
`heroic_fr` smallint(6) NOT NULL default '0',
`heroic_cr` smallint(6) NOT NULL default '0',
`heroic_mr` smallint(6) NOT NULL default '0',
`heroic_svcorrup` smallint(6) NOT NULL default '0',
`healamt` smallint(6) NOT NULL default '0',
`spelldmg` smallint(6) NOT NULL default '0',
`clairvoyance` smallint(6) NOT NULL default '0',
`backstabdmg` smallint(6) NOT NULL default '0',
`created` varchar(64) NOT NULL default '',
`elitematerial` smallint(6) NOT NULL default '0',
`ldonsellbackrate` smallint(6) NOT NULL default '0',
`scriptfileid` smallint(6) NOT NULL default '0',
`expendablearrow` smallint(6) NOT NULL default '0',
`powersourcecapacity` smallint(6) NOT NULL default '0',
`bardeffect` smallint(6) NOT NULL default '0',
`bardeffecttype` smallint(6) NOT NULL default '0',
`bardlevel2` smallint(6) NOT NULL default '0',
`bardlevel` smallint(6) NOT NULL default '0',
`bardunk1` smallint(6) NOT NULL default '0',
`bardunk2` smallint(6) NOT NULL default '0',
`bardunk3` smallint(6) NOT NULL default '0',
`bardunk4` smallint(6) NOT NULL default '0',
`bardunk5` smallint(6) NOT NULL default '0',
`bardname` varchar(64) NOT NULL default '',
`bardunk7` smallint(6) NOT NULL default '0',
`UNK214` smallint(6) NOT NULL default '0',
UNIQUE KEY `ID` (`id`),
KEY `name_idx` (`Name`),
KEY `lore_idx` (`lore`),
KEY `minstatus` (`minstatus`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-=INVENTORY=-
Code:
CREATE TABLE IF NOT EXISTS `inventory` (
`charid` int(11) unsigned NOT NULL default '0',
`slotid` mediumint(7) unsigned NOT NULL default '0',
`itemid` int(11) unsigned default '0',
`charges` tinyint(3) unsigned default '0',
`color` int(11) unsigned NOT NULL default '0',
`augslot1` mediumint(7) unsigned NOT NULL default '0',
`augslot2` mediumint(7) unsigned NOT NULL default '0',
`augslot3` mediumint(7) unsigned NOT NULL default '0',
`augslot4` mediumint(7) unsigned NOT NULL default '0',
`augslot5` mediumint(7) unsigned default '0',
`instnodrop` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`charid`,`slotid`),
KEY `ix_inventory_itemid` (`itemid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Any help would be greatly appreciated
|
Threaded Mode
