EQEmulator Forums - Help Converting Items

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)

- - Help Converting Items (https://www.eqemulator.org/forums/showthread.php?t=28314)

Help Converting Items

I would like to start the process of converting my old school stuff to the latest...

(Mainly because it's driving my devs nuts to make items and have them not source in due to it not being current)

Here is my Current...

Code:

CREATE TABLE `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(11) 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 '255',

  `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',

  UNIQUE KEY `ID` (`id`),

  KEY `name_idx` (`Name`),

  KEY `lore_idx` (`lore`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

If some one could help me to convert my Items Table to the latest would be greatly appreciated!

King
www.raidaddicts.org

This should get you to where you want to be, all tested fine on my end but just make sure to test it in case of copy paste errors.

Code:

ALTER TABLE `items` 

    CHANGE `color` `color` int(10) unsigned   NOT NULL DEFAULT '0' after `classes`, 

    CHANGE `norent` `norent` int(11)   NOT NULL DEFAULT '0' after `nodrop`, 

    ADD COLUMN `lorefile` varchar(32)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `UNK033`, 

    ADD COLUMN `UNK014` int(11)   NOT NULL DEFAULT '0' after `lorefile`, 

    ADD COLUMN `svcorruption` int(11)   NOT NULL DEFAULT '0' after `UNK014`, 

    ADD COLUMN `UNK038` int(11)   NOT NULL DEFAULT '0' after `svcorruption`, 

    ADD COLUMN `UNK060` int(11)   NOT NULL DEFAULT '0' after `UNK038`, 

    ADD COLUMN `augslot1unk2` int(11)   NOT NULL DEFAULT '0' after `UNK060`, 

    ADD COLUMN `augslot2unk2` int(11)   NOT NULL DEFAULT '0' after `augslot1unk2`, 

    ADD COLUMN `augslot3unk2` int(11)   NOT NULL DEFAULT '0' after `augslot2unk2`, 

    ADD COLUMN `augslot4unk2` int(11)   NOT NULL DEFAULT '0' after `augslot3unk2`, 

    ADD COLUMN `augslot5unk2` int(11)   NOT NULL DEFAULT '0' after `augslot4unk2`, 

    ADD COLUMN `UNK098` int(11)   NOT NULL DEFAULT '0' after `augslot5unk2`, 

    ADD COLUMN `UNK109` int(11)   NOT NULL DEFAULT '0' after `UNK098`, 

    ADD COLUMN `UNK120` int(11)   NOT NULL DEFAULT '0' after `UNK109`, 

    ADD COLUMN `UNK121` int(11)   NOT NULL DEFAULT '0' after `UNK120`, 

    ADD COLUMN `questitemflag` int(11)   NOT NULL DEFAULT '0' after `UNK121`, 

    ADD COLUMN `UNK131` int(11)   NOT NULL DEFAULT '0' after `questitemflag`, 

    ADD COLUMN `UNK132` text  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `UNK131`, 

    ADD COLUMN `clickunk5` int(11)   NOT NULL DEFAULT '0' after `UNK132`, 

    ADD COLUMN `clickunk6` varchar(32)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `clickunk5`, 

    ADD COLUMN `clickunk7` int(11)   NOT NULL DEFAULT '0' after `clickunk6`, 

    ADD COLUMN `procunk1` int(11)   NOT NULL DEFAULT '0' after `clickunk7`, 

    ADD COLUMN `procunk2` int(11)   NOT NULL DEFAULT '0' after `procunk1`, 

    ADD COLUMN `procunk3` int(11)   NOT NULL DEFAULT '0' after `procunk2`, 

    ADD COLUMN `procunk4` int(11)   NOT NULL DEFAULT '0' after `procunk3`, 

    ADD COLUMN `procunk6` varchar(32)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `procunk4`, 

    ADD COLUMN `procunk7` int(11)   NOT NULL DEFAULT '0' after `procunk6`, 

    ADD COLUMN `wornunk1` int(11)   NOT NULL DEFAULT '0' after `procunk7`, 

    ADD COLUMN `wornunk2` int(11)   NOT NULL DEFAULT '0' after `wornunk1`, 

    ADD COLUMN `wornunk3` int(11)   NOT NULL DEFAULT '0' after `wornunk2`, 

    ADD COLUMN `wornunk4` int(11)   NOT NULL DEFAULT '0' after `wornunk3`, 

    ADD COLUMN `wornunk5` int(11)   NOT NULL DEFAULT '0' after `wornunk4`, 

    ADD COLUMN `wornunk6` varchar(32)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `wornunk5`, 

    ADD COLUMN `wornunk7` int(11)   NOT NULL DEFAULT '0' after `wornunk6`, 

    ADD COLUMN `focusunk1` int(11)   NOT NULL DEFAULT '0' after `wornunk7`, 

    ADD COLUMN `focusunk2` int(11)   NOT NULL DEFAULT '0' after `focusunk1`, 

    ADD COLUMN `focusunk3` int(11)   NOT NULL DEFAULT '0' after `focusunk2`, 

    ADD COLUMN `focusunk4` int(11)   NOT NULL DEFAULT '0' after `focusunk3`, 

    ADD COLUMN `focusunk5` int(11)   NOT NULL DEFAULT '0' after `focusunk4`, 

    ADD COLUMN `focusunk6` varchar(32)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `focusunk5`, 

    ADD COLUMN `focusunk7` int(11)   NOT NULL DEFAULT '0' after `focusunk6`, 

    ADD COLUMN `scrollunk1` int(11)   NOT NULL DEFAULT '0' after `focusunk7`, 

    ADD COLUMN `scrollunk2` int(11)   NOT NULL DEFAULT '0' after `scrollunk1`, 

    ADD COLUMN `scrollunk3` int(11)   NOT NULL DEFAULT '0' after `scrollunk2`, 

    ADD COLUMN `scrollunk4` int(11)   NOT NULL DEFAULT '0' after `scrollunk3`, 

    ADD COLUMN `scrollunk5` int(11)   NOT NULL DEFAULT '0' after `scrollunk4`, 

    ADD COLUMN `scrollunk6` varchar(32)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `scrollunk5`, 

    ADD COLUMN `scrollunk7` int(11)   NOT NULL DEFAULT '0' after `scrollunk6`, 

    ADD COLUMN `UNK193` int(11)   NOT NULL DEFAULT '0' after `scrollunk7`, 

    ADD COLUMN `purity` int(11)   NOT NULL DEFAULT '0' after `UNK193`, 

    ADD COLUMN `evolvinglevel` int(11)   NOT NULL DEFAULT '0' after `purity`, 

    ADD COLUMN `UNK129` int(11)   NOT NULL DEFAULT '0' after `evolvinglevel`, 

    ADD COLUMN `clickname` varchar(64)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `UNK129`, 

    ADD COLUMN `procname` varchar(64)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `clickname`, 

    ADD COLUMN `wornname` varchar(64)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `procname`, 

    ADD COLUMN `focusname` varchar(64)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `wornname`, 

    ADD COLUMN `scrollname` varchar(64)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `focusname`, 

    ADD COLUMN `dsmitigation` smallint(6)   NOT NULL DEFAULT '0' after `scrollname`, 

    ADD COLUMN `heroic_str` smallint(6)   NOT NULL DEFAULT '0' after `dsmitigation`, 

    ADD COLUMN `heroic_int` smallint(6)   NOT NULL DEFAULT '0' after `heroic_str`, 

    ADD COLUMN `heroic_wis` smallint(6)   NOT NULL DEFAULT '0' after `heroic_int`, 

    ADD COLUMN `heroic_agi` smallint(6)   NOT NULL DEFAULT '0' after `heroic_wis`, 

    ADD COLUMN `heroic_dex` smallint(6)   NOT NULL DEFAULT '0' after `heroic_agi`, 

    ADD COLUMN `heroic_sta` smallint(6)   NOT NULL DEFAULT '0' after `heroic_dex`, 

    ADD COLUMN `heroic_cha` smallint(6)   NOT NULL DEFAULT '0' after `heroic_sta`, 

    ADD COLUMN `healamt` smallint(6)   NOT NULL DEFAULT '0' after `heroic_cha`, 

    ADD COLUMN `spelldmg` smallint(6)   NOT NULL DEFAULT '0' after `healamt`, 

    ADD COLUMN `clairvoyance` smallint(6)   NOT NULL DEFAULT '0' after `spelldmg`, 

    ADD COLUMN `backstabdmg` smallint(6)   NOT NULL DEFAULT '0' after `clairvoyance`, 

    ADD COLUMN `created` varchar(64)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `backstabdmg`, 

    ADD KEY `minstatus`(`minstatus`), COMMENT='';