The Myra database:

Darkwaters · #21 08-20-2004, 08:26 PM

Here's my two cents again to implement the fixes and I'd post the updated items table but SBC homepages is down atm so no where to post the small zip file.

Here Ace,
If you plan on only using MW_57DR2_alpha_1.sql and newdumpeditems.sql and following the tutorial posted elsewhere.
There are 7 unique table fields missing from newdumpeditems.sql's "items" table [unknown004, 070, 076, 077, 099, 107, & 108] add these entries listed in the code snippet below to this table.
There are 30 missing fields in the MW_57DR2_alpha_1.sql's "items_" table [not manually listing them just verify you alter your table properties to match the information below in the code snippet].

Code:

# MySQL-Front 3.0  (Build 28.10)

# Items and Items_ updated by Darkwaters
# ------------------------------------------------------
# Server version 4.0.20a-nt

#
# Table structure for table items
#

CREATE TABLE `items` (
  `id` int(11) NOT NULL default '0',
  `minstatus` smallint(5) NOT NULL default '0',
  `Name` varchar(64) NOT NULL default '0',
  `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',
  `attackbonus` int(11) NOT NULL default '0',
  `augmentrestriction` int(11) NOT NULL default '0',
  `augslot1type` tinyint(3) NOT NULL default '0',
  `augslot2type` tinyint(3) NOT NULL default '0',
  `augslot3type` tinyint(3) NOT NULL default '0',
  `augslot4type` tinyint(3) NOT NULL default '0',
  `augslot5type` tinyint(3) NOT NULL default '0',
  `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',
  `banedmgamt2` 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',
  `booktype` int(11) NOT NULL default '0',
  `casttime` int(11) NOT NULL default '0',
  `casttime2` int(11) NOT NULL default '0',
  `charges` int(11) NOT NULL default '0',
  `charmfile` varchar(32) NOT NULL default '0',
  `classes` int(11) NOT NULL default '0',
  `color` int(11) NOT NULL default '0',
  `combateffects` varchar(10) NOT NULL default '0',
  `combatskill` int(11) NOT NULL default '0',
  `combatskilldmg` int(11) NOT NULL default '0',
  `cost` 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',
  `dotshielding` int(11) NOT NULL default '0',
  `dr` int(11) NOT NULL default '0',
  `effecttype` 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(15) NOT NULL default '0',
  `focusid` int(11) NOT NULL default '0',
  `fr` int(11) NOT NULL default '0',
  `gmflag` int(11) NOT NULL default '0',
  `hastepercent` int(11) NOT NULL default '0',
  `hasteproclvl` int(11) NOT NULL default '0',
  `hp` int(11) NOT NULL default '0',
  `hpregen` int(11) NOT NULL default '0',
  `icon` int(11) NOT NULL default '0',
  `idfile` varchar(30) NOT NULL default '0',
  `itemclass` int(11) NOT NULL default '0',
  `itemtype` int(11) NOT NULL default '0',
  `ldonpointcost` int(11) NOT NULL default '0',
  `ldonpointtheme` 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 '0',
  `loreflag` tinyint(3) unsigned 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',
  `material` int(11) NOT NULL default '0',
  `maxcharges` int(11) NOT NULL default '0',
  `merchantprice` 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',
  `proc_rate_mod` 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',
  `spellid` 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',
  `tribute` 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',
  `unknown006` 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',
  `unknown061` int(11) NOT NULL default '0',
  `unknown067` int(11) NOT NULL default '0',
  `unknown069` int(11) NOT NULL default '0',
  `unknown081` int(11) NOT NULL default '0',
  `unknown105` 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',
  `unknown125` varchar(11) NOT NULL default '0',
  `unknown126` varchar(11) NOT NULL default '0',
  `unknown127` varchar(11) NOT NULL default '0',
  `unknown128` varchar(11) NOT NULL default '0',
  `unknown129` varchar(11) NOT NULL default '0',
  `unknown130` varchar(11) NOT NULL default '0',
  `unknown131` varchar(11) NOT NULL default '0',
  `unknown132` varchar(11) NOT NULL default '0',
  `unknown133` varchar(11) NOT NULL default '0',
  `updated` datetime default '2004-06-20 00:00:00',
  `comment` varchar(255) NOT NULL default '0',
  `unknown008` int(10) unsigned NOT NULL default '0',
  `unknown004` int(11) NOT NULL default '0',
  `unknown070` int(11) NOT NULL default '0',
  `unknown076` int(11) NOT NULL default '0',
  `unknown077` int(11) NOT NULL default '0',
  `unknown099` int(11) NOT NULL default '0',
  `unknown107` int(11) NOT NULL default '0',
  `unknown108` int(11) NOT NULL default '0',
  UNIQUE KEY `ID` (`id`)
) TYPE=MyISAM;

After making appropriate changes to both "items" and "items_".
Remove the dupes in the "items_" table compared to "items". This can be done easily enough using the following information in MySQL's SQL Editor Window:

Code:

DELETE FROM items_ USING items_, items WHERE items_.id=items.id;

Source the left over original items into "items" the [newdumpeditems.sql's "items"] you'll find you now have 147 table fields for items and 28,810 items in your table. The "items_new" has only 140 table fields and 19,881 items in the table versus "items_orig" which has only 117 table fields yet 28,731 items in the table.

Darkwaters