I am using database rev 1052, i will post my item schema and the item im trying to look up that is causing the crash.
**Schema***
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',
`unknown002` int(11) NOT NULL default '0',
`unknown003` int(11) NOT NULL default '0',
`unknown005` int(11) NOT NULL default '0',
`unknown007` int(11) NOT NULL default '0',
`unknown018` int(11) NOT NULL default '0',
`unknown019` int(11) NOT NULL default '0',
`unknown020` 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',
`unknown061` int(11) NOT NULL default '0',
`UNK054` int(11) NOT NULL default '0',
`unknown067` int(11) NOT NULL default '0',
`unknown069` int(11) NOT NULL default '0',
`UNK059` int(11) NOT NULL default '0',
`UNK061` int(11) NOT NULL default '0',
`unknown081` int(11) NOT NULL default '0',
`unknown105` int(11) NOT NULL default '0',
`booktype` int(11) NOT NULL default '0',
`unknown122` int(11) NOT NULL default '0',
`unknown123` varchar(11) NOT NULL default '0',
`unknown124` varchar(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',
`unknown128` varchar(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',
`unknown133` varchar(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',
`UNK098` int(11) NOT NULL default '0',
`UNK109` 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',
`UNK131` 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',
`UNK129` 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;
***Item im sourcing in**
INSERT INTO `items` (`id`, `minstatus`, `Name`, `aagi`, `ac`, `accuracy`, `acha`, `adex`, `aint`, `artifactflag`, `asta`, `astr`, `attack`, `augrestrict`, `augslot1type`, `augslot1visible`, `augslot2type`, `augslot2visible`, `augslot3type`, `augslot3visible`, `augslot4type`, `augslot4visible`, `augslot5type`, `augslot5visible`, `augtype`, `avoidance`, `awis`, `bagsize`, `bagslots`, `bagtype`, `bagwr`, `banedmgamt`, `banedmgraceamt`, `banedmgbody`, `banedmgrace`, `bardtype`, `bardvalue`, `book`, `casttime`, `casttime_`, `charmfile`, `charmfileid`, `classes`, `color`, `combateffects`, `extradmgskill`, `extradmgamt`, `price`, `cr`, `damage`, `damageshield`, `deity`, `delay`, `augdistiller`, `dotshielding`, `dr`, `clicktype`, `clicklevel2`, `elemdmgtype`, `elemdmgamt`, `endur`, `factionamt1`, `factionamt2`, `factionamt3`, `factionamt4`, `factionmod1`, `factionmod2`, `factionmod3`, `factionmod4`, `filename`, `focuseffect`, `fr`, `fvnodrop`, `haste`, `clicklevel`, `hp`, `regen`, `icon`, `idfile`, `itemclass`, `itemtype`, `ldonprice`, `ldontheme`, `ldonsold`, `light`, `lore`, `loregroup`, `magic`, `mana`, `manaregen`, `enduranceregen`, `material`, `maxcharges`, `mr`, `nodrop`, `norent`, `pendingloreflag`, `pr`, `procrate`, `races`, `range`, `reclevel`, `recskill`, `reqlevel`, `sellrate`, `shielding`, `size`, `skillmodtype`, `skillmodvalue`, `slots`, `clickeffect`, `spellshield`, `strikethrough`, `stunresist`, `summonedflag`, `tradeskills`, `favor`, `weight`, `unknown002`, `unknown003`, `unknown005`, `unknown007`, `unknown018`, `unknown019`, `unknown020`, `UNK012`, `UNK013`, `benefitflag`, `unknown061`, `UNK054`, `unknown067`, `unknown069`, `UNK059`, `UNK061`, `unknown081`, `unknown105`, `booktype`, `unknown122`, `unknown123`, `unknown124`, `recastdelay`, `recasttype`, `guildfavor`, `unknown128`, `UNK123`, `UNK124`, `attuneable`, `nopet`, `unknown133`, `updated`, `comment`, `UNK127`, `pointtype`, `potionbelt`, `potionbeltslots`, `stacksize`, `notransfer`, `stackable`, `UNK134`, `UNK137`, `proceffect`, `proctype`, `proclevel2`, `proclevel`, `UNK142`, `worneffect`, `worntype`, `wornlevel2`, `wornlevel`, `UNK147`, `focustype`, `focuslevel2`, `focuslevel`, `UNK152`, `scrolleffect`, `scrolltype`, `scrolllevel2`, `scrolllevel`, `UNK157`, `serialized`, `verified`, `serialization`, `source`, `UNK033`) VALUES
(556, 0, 'Antheks Stone of Godly Sight', 15, 34, 3, 25, 16, 25, 0, 15, 15, 35, 0, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 128, 0, 25, 0, 0, 0, 0, 0, 0, 0, 0, 51, 32, 0, -1, -1, '', '', 65535, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 186, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 1450, 0, 948, 'IT63', 0, 54, 0, 0, 0, 0, 'Augment of Ring Events', 0, 1, 0, 0, 0, 0, -1, 0, 0, 255, 0, 0, 0, 32767, 0, 0, 0, 65, 0, 0, 0, 0, 0, 2097150, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', 0, 0, 0, '0', 0, 0, 0, 0, '0', '0000-00-00 00:00:00', '', 0, 0, 0, 0, 20, 0, 0, '00000000000000000000000000000000000000', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'KingMort', 0);
|
Hybrid Mode
