A little problem with ArcEmu

[raddry]

Hi all, I installed ArcEmu recently, and already found a problem :S
All the items in game havent got the proper stats ( 7 agi or 7 str etc) and I jsut can't hit with weapons.

Any solutions? Please.

[y2kss66]

if they do not have the right stats that is a db problem.

[Mitron]

Dload a new DB or make the stats right manually ^^ your choice

[raddry]

Ok, thanks alot for fast reply. But as i mentionned, I installed it recently so im very new to this, so could you tell me where could I download a new DB please? Would be great. =)

[y2kss66]

I reccomend rivaldb

at

rivaldb.com

[raddry]

Thanks alor guys, I tried to download it but don't really know how, still thanks alot, any other DB or some download method for this?

[Vindicated]

Nope. Just use a program called TortoiseSVN (google is your friend). Then make a folder to keep the files in and call it "Rival DB". Then right click the folder and click "SVN Checkout". After you do this, enter in the SVN download information from the Rival DB site and click ok. Then you have the files

[Algorithm]

Hi all, I installed ArcEmu recently, and already found a problem :S
All the items in game havent got the proper stats ( 7 agi or 7 str etc) and I jsut can't hit with weapons.

Any solutions? Please.

You dont need to change your database, you are simply missing a very important SQl update for your -Items- table.

execute this query in your World database

alter table `items` add column `itemstatscount` int UNSIGNED DEFAULT '10' NOT NULL after `ContainerSlots`;
alter table `items` add column `existingduration` int UNSIGNED DEFAULT '0' NOT NULL after `unk2`;

[jackthripper]

theres a vid here on how to do it if you have to


http://www.mmowned.com/forums/emulat...ml#post1442766

[Algorithm]

theres a vid here on how to do it if you have to


http://www.mmowned.com/forums/emulat...ml#post1442766

he doesnt need a video. you only confusing the guy,., We all know Arcemu had this problem in earlier revisions when stats were not accumulating correctly from your equiped items, such attack power, hit rating. So once the fix was available on SVN this SQL i posted cam with it, therefore if you do not run that update your items will not give you stats.

[raddry]

You dont need to change your database, you are simply missing a very important SQl update for your -Items- table.

execute this query in your World database

alter table `items` add column `itemstatscount` int UNSIGNED DEFAULT '10' NOT NULL after `ContainerSlots`;
alter table `items` add column `existingduration` int UNSIGNED DEFAULT '0' NOT NULL after `unk2`;

Thanks alot for that, but when I do this, "1060 Duplicate column name 'itemsstatscount' appears :/ what should I do now?

[Algorithm]

Thanks alot for that, but when I do this, "1060 Duplicate column name 'itemsstatscount' appears :/ what should I do now?

it means you already have itemsstatscount in your Items table structure.

[raddry]

Hmm ok, so what should I do then?

[Algorithm]

Hmm ok, so what should I do then?

post your ITEMS structure and i will take a look at it and tell you whats missing..
also tell me which revision of arcemu u using ill upload you the items table

[raddry]

"ArcEmu Revision: 2337"
About the Items Structure I'm not sure what's this, but let's try

-- Table "items" DDL

CREATE TABLE `items` (
  `entry` int(255) unsigned NOT NULL default '0',
  `class` int(30) NOT NULL default '0',
  `subclass` int(30) NOT NULL default '0',
  `field4` int(10) NOT NULL default '-1',
  `name1` varchar(255) NOT NULL,
  `name2` varchar(255) NOT NULL default '',
  `name3` varchar(255) NOT NULL default '',
  `name4` varchar(255) NOT NULL default '',
  `displayid` int(70) unsigned NOT NULL default '0',
  `quality` int(30) NOT NULL default '0',
  `flags` int(30) NOT NULL default '0',
  `buyprice` int(30) NOT NULL default '0',
  `sellprice` int(30) NOT NULL default '0',
  `inventorytype` int(30) NOT NULL default '0',
  `allowableclass` int(30) NOT NULL default '0',
  `allowablerace` int(30) NOT NULL default '0',
  `itemlevel` int(30) NOT NULL default '0',
  `requiredlevel` int(30) NOT NULL default '0',
  `RequiredSkill` int(30) NOT NULL default '0',
  `RequiredSkillRank` int(30) NOT NULL default '0',
  `RequiredSkillSubRank` int(30) NOT NULL default '0',
  `RequiredPlayerRank1` int(30) NOT NULL default '0',
  `RequiredPlayerRank2` int(30) NOT NULL default '0',
  `RequiredFaction` int(30) NOT NULL default '0',
  `RequiredFactionStanding` int(30) NOT NULL default '0',
  `Unique` int(30) NOT NULL default '0',
  `maxcount` int(30) NOT NULL default '0',
  `ContainerSlots` int(30) NOT NULL default '0',
  `itemstatscount` int(10) unsigned NOT NULL default '10',
  `stat_type1` int(30) NOT NULL default '0',
  `stat_value1` int(30) NOT NULL default '0',
  `stat_type2` int(30) NOT NULL default '0',
  `stat_value2` int(30) NOT NULL default '0',
  `stat_type3` int(30) NOT NULL default '0',
  `stat_value3` int(30) NOT NULL default '0',
  `stat_type4` int(30) NOT NULL default '0',
  `stat_value4` int(30) NOT NULL default '0',
  `stat_type5` int(30) NOT NULL default '0',
  `stat_value5` int(30) NOT NULL default '0',
  `stat_type6` int(30) NOT NULL default '0',
  `stat_value6` int(30) NOT NULL default '0',
  `stat_type7` int(30) NOT NULL default '0',
  `stat_value7` int(30) NOT NULL default '0',
  `stat_type8` int(30) NOT NULL default '0',
  `stat_value8` int(30) NOT NULL default '0',
  `stat_type9` int(30) NOT NULL default '0',
  `stat_value9` int(30) NOT NULL default '0',
  `stat_type10` int(30) NOT NULL default '0',
  `stat_value10` int(30) NOT NULL default '0',
  `ScaledStatsDistributionId` int(32) unsigned NOT NULL default '0',
  `ScaledStatsDistributionFlags` int(32) unsigned NOT NULL default '0',
  `dmg_min1` float NOT NULL default '0',
  `dmg_max1` float NOT NULL default '0',
  `dmg_type1` int(30) NOT NULL default '0',
  `dmg_min2` float NOT NULL default '0',
  `dmg_max2` float NOT NULL default '0',
  `dmg_type2` int(30) NOT NULL default '0',
  `dmg_min3` float NOT NULL default '0',
  `dmg_max3` float NOT NULL default '0',
  `dmg_type3` int(30) NOT NULL default '0',
  `dmg_min4` float NOT NULL default '0',
  `dmg_max4` float NOT NULL default '0',
  `dmg_type4` int(30) NOT NULL default '0',
  `dmg_min5` float NOT NULL default '0',
  `dmg_max5` float NOT NULL default '0',
  `dmg_type5` int(30) NOT NULL default '0',
  `armor` int(30) NOT NULL default '0',
  `holy_res` int(30) NOT NULL default '0',
  `fire_res` int(30) NOT NULL default '0',
  `nature_res` int(30) NOT NULL default '0',
  `frost_res` int(30) NOT NULL default '0',
  `shadow_res` int(30) NOT NULL default '0',
  `arcane_res` int(30) NOT NULL default '0',
  `delay` int(30) NOT NULL default '0',
  `ammo_type` int(30) NOT NULL default '0',
  `range` float NOT NULL default '0',
  `spellid_1` int(30) NOT NULL default '0',
  `spelltrigger_1` int(30) NOT NULL default '0',
  `spellcharges_1` int(30) NOT NULL default '0',
  `spellcooldown_1` int(30) NOT NULL default '0',
  `spellcategory_1` int(30) NOT NULL default '0',
  `spellcategorycooldown_1` int(30) NOT NULL default '0',
  `spellid_2` int(30) NOT NULL default '0',
  `spelltrigger_2` int(30) NOT NULL default '0',
  `spellcharges_2` int(30) NOT NULL default '0',
  `spellcooldown_2` int(30) NOT NULL default '0',
  `spellcategory_2` int(30) NOT NULL default '0',
  `spellcategorycooldown_2` int(30) NOT NULL default '0',
  `spellid_3` int(30) NOT NULL default '0',
  `spelltrigger_3` int(30) NOT NULL default '0',
  `spellcharges_3` int(30) NOT NULL default '0',
  `spellcooldown_3` int(30) NOT NULL default '0',
  `spellcategory_3` int(30) NOT NULL default '0',
  `spellcategorycooldown_3` int(30) NOT NULL default '0',
  `spellid_4` int(30) NOT NULL default '0',
  `spelltrigger_4` int(30) NOT NULL default '0',
  `spellcharges_4` int(30) NOT NULL default '0',
  `spellcooldown_4` int(30) NOT NULL default '0',
  `spellcategory_4` int(30) NOT NULL default '0',
  `spellcategorycooldown_4` int(30) NOT NULL default '0',
  `spellid_5` int(30) NOT NULL default '0',
  `spelltrigger_5` int(30) NOT NULL default '0',
  `spellcharges_5` int(30) NOT NULL default '0',
  `spellcooldown_5` int(30) NOT NULL default '0',
  `spellcategory_5` int(30) NOT NULL default '0',
  `spellcategorycooldown_5` int(30) NOT NULL default '0',
  `bonding` int(30) NOT NULL default '0',
  `description` varchar(255) NOT NULL default '',
  `page_id` int(30) NOT NULL default '0',
  `page_language` int(30) NOT NULL default '0',
  `page_material` int(30) NOT NULL default '0',
  `quest_id` int(30) NOT NULL default '0',
  `lock_id` int(30) NOT NULL default '0',
  `lock_material` int(30) NOT NULL default '0',
  `sheathID` int(30) NOT NULL default '0',
  `randomprop` int(30) NOT NULL default '0',
  `unk203_1` int(11) NOT NULL default '0',
  `block` int(30) NOT NULL default '0',
  `itemset` int(30) NOT NULL default '0',
  `MaxDurability` int(30) NOT NULL default '0',
  `ZoneNameID` int(30) NOT NULL default '0',
  `mapid` int(30) default NULL,
  `bagfamily` int(30) NOT NULL default '0',
  `TotemCategory` int(30) default NULL,
  `socket_color_1` int(30) default NULL,
  `unk201_3` int(30) NOT NULL default '0',
  `socket_color_2` int(30) default NULL,
  `unk201_5` int(30) NOT NULL default '0',
  `socket_color_3` int(30) default NULL,
  `unk201_7` int(30) NOT NULL default '0',
  `socket_bonus` int(30) default NULL,
  `GemProperties` int(30) default NULL,
  `ReqDisenchantSkill` int(30) NOT NULL default '-1',
  `unk2` int(30) NOT NULL default '0',
  `existingduration` int(10) unsigned NOT NULL default '0',
  `ItemLimitCategoryId` int(32) unsigned NOT NULL default '0',
  PRIMARY KEY  (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Item System';