|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc. |
 |
|
 |
05-23-2009, 12:10 PM
|
|
Banned
|
|
Join Date: Sep 2006
Posts: 841
|
|
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
|
 |
|
 |
|
|
|
05-23-2009, 12:35 PM
|
|
Discordant
|
|
Join Date: Sep 2006
Location: Green Bay, WI
Posts: 436
|
|
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='';
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 02:51 AM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
Linear Mode
