Zone.exe problem, please help me out here...

[Andrew80k]

It appears that there is probably a mismatch in the database version and the emu version you are using. Either that or something happened during the import of the database.

[leslamarch]

just a couple of questions?
do you have a rule_values table in your DB? or need an updated rules table?
and do you have the spells_**.txt in your emu directory?

[aapov]

Yup, I do have a spells file in the emu and everquest folder, and also have the rules files in the db. do you think it's more than likely corrupt and have to start over and lose all my work??

[leslamarch]

Originally Posted by aapov

Yup, I do have a spells file in the emu and everquest folder, and also have the rules files in the db. do you think it's more than likely corrupt and have to start over and lose all my work??

Just tackle one problem at a time, I would drop the rule_values table and source that in and try and see what errors that leaves you? not sure what you are using for your database work?

here is the full rule_values table from peq cvs. so try that and see what happens. Just make sure the rule_sets table is set to 1.

CREATE TABLE `rule_values` (
  `ruleset_id` tinyint(3) unsigned NOT NULL  default '0',
  `rule_name` varchar(64) NOT NULL default '',
  `rule_value`  varchar(10) NOT NULL default '',
  PRIMARY KEY   (`ruleset_id`,`rule_name`),
  KEY `ruleset_id` (`ruleset_id`)
)  ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO `rule_values` VALUES ('1',  'GM:MinStatusToZoneAnywhere', '250');
INSERT INTO `rule_values` VALUES ('1',  'Character:MaxLevel', '65');
INSERT INTO `rule_values` VALUES ('1',  'Character:LeaveCorpses', 'true');
INSERT INTO `rule_values` VALUES ('1',  'Character:LeaveNakedCorpses', 'true');
INSERT INTO `rule_values` VALUES  ('1', 'Character:ExpMultiplier', '0.75');
INSERT INTO `rule_values` VALUES  ('1', 'Character:DeathExpLossLevel', '10');
INSERT INTO `rule_values` VALUES  ('1', 'Character:CorpseDecayTimeMS', '86400000');
INSERT INTO `rule_values`  VALUES ('1', 'Character:AutosaveIntervalS', '300');
INSERT INTO `rule_values`  VALUES ('1', 'Character:HPRegenMultiplier', '100');
INSERT INTO `rule_values`  VALUES ('1', 'Character:ManaRegenMultiplier', '100');
INSERT INTO  `rule_values` VALUES ('1', 'Character:EnduranceRegenMultiplier',  '100');
INSERT INTO `rule_values` VALUES ('1', 'Guild:MaxMembers',  '2048');
INSERT INTO `rule_values` VALUES ('1', 'Skills:MaxTrainTradeskills',  '21');
INSERT INTO `rule_values` VALUES ('1', 'Pets:AttackCommandRange',  '150');
INSERT INTO `rule_values` VALUES ('1', 'World:ZoneAutobootTimeoutMS',  '120000');
INSERT INTO `rule_values` VALUES ('1',  'World:ClientKeepaliveTimeoutMS', '95000');
INSERT INTO `rule_values` VALUES  ('1', 'World:UseBannedIPsTable', 'true');
INSERT INTO `rule_values` VALUES  ('1', 'World:MaxClientsPerIP', '-1');
INSERT INTO `rule_values` VALUES ('1',  'World:ExemptMaxClientsStatus', '-1');
INSERT INTO `rule_values` VALUES ('1',  'Aggro:PetSpellAggroMod', '10');
INSERT INTO `rule_values` VALUES ('1',  'Aggro:SongAggroMod', '33');
INSERT INTO `rule_values` VALUES ('1',  'Aggro:SpellAggroMod', '100');
INSERT INTO `rule_values` VALUES ('1',  'Combat:BaseCritChance', '0.0');
INSERT INTO `rule_values` VALUES ('1',  'Combat:WarBerBaseCritChance', '0.03');
INSERT INTO `rule_values` VALUES  ('1', 'Combat:BerserkBaseCritChance', '0.06');
INSERT INTO `rule_values`  VALUES ('1', 'Combat:NPCBashKickLevel', '6');
INSERT INTO `rule_values`  VALUES ('1', 'Character:ConsumptionMultiplier', '200');
INSERT INTO  `rule_values` VALUES ('1', 'Spells:AutoResistDiff', '15');
INSERT INTO  `rule_values` VALUES ('1', 'Spells:ResistChance', '2.0');
INSERT INTO  `rule_values` VALUES ('1', 'Spells:ResistMod', '0.40');
INSERT INTO  `rule_values` VALUES ('1', 'Spells:PartialHitChance', '0.7');
INSERT INTO  `rule_values` VALUES ('1', 'Combat:ClientBaseCritChance', '0.0');
INSERT INTO  `rule_values` VALUES ('1', 'Zone:NPCGlobalPositionUpdateInterval',  '60000');
INSERT INTO `rule_values` VALUES ('1',  'NPC:MinorNPCCorpseDecayTimeMS', '600000');
INSERT INTO `rule_values` VALUES  ('1', 'NPC:MajorNPCCorpseDecayTimeMS', '1200000');
INSERT INTO `rule_values`  VALUES ('1', 'Zone:GraveyardTimeMS', '1200000');
INSERT INTO `rule_values`  VALUES ('1', 'Zone:EnableShadowrest', '1');
INSERT INTO `rule_values` VALUES  ('1', 'Map:FixPathingZWhenLoading', 'true');
INSERT INTO `rule_values` VALUES  ('1', 'Map:FixPathingZAtWaypoints', 'true');
INSERT INTO `rule_values` VALUES  ('1', 'Map:FixPathingZWhenMoving', 'true');
INSERT INTO `rule_values` VALUES  ('1', 'Map:FixPathingZOnSendTo', 'false');
INSERT INTO `rule_values` VALUES  ('1', 'Zone:ClientLinkdeadMS', '180000');
INSERT INTO `rule_values` VALUES  ('1', 'NPC:UseItemBonusesForNonPets', 'true');
INSERT INTO `rule_values`  VALUES ('1', 'Map:FixPathingZMaxDeltaSendTo', '20.0');
INSERT INTO  `rule_values` VALUES ('1', 'Map:FixPathingZMaxDeltaLoading', '20.0');
INSERT  INTO `rule_values` VALUES ('1', 'Map:FixPathingZMaxDeltaMoving',  '20.0');
INSERT INTO `rule_values` VALUES ('1',  'Map:FixPathingZMaxDeltaWaypoint', '20.0');
INSERT INTO `rule_values` VALUES  ('1', 'Character:HealOnLevel', 'false');
INSERT INTO `rule_values` VALUES  ('1', 'Character:FeignKillsPet', 'false');
INSERT INTO `rule_values` VALUES  ('1', 'Character:ItemManaRegenCap', '15');
INSERT INTO `rule_values` VALUES  ('1', 'Character:ItemHealthRegenCap', '15');
INSERT INTO `rule_values` VALUES  ('1', 'Combat:UseIntervalAC', 'true');
INSERT INTO `rule_values` VALUES ('1',  'Combat:PetAttackMagicLevel', '30');
INSERT INTO `rule_values` VALUES ('1',  'NPC:SayPauseTimeInSec', '10');
INSERT INTO `rule_values` VALUES ('1',  'NPC:OOCRegen', '0.66');
INSERT INTO `rule_values` VALUES ('1',  'Aggro:SmartAggroList', 'true');
INSERT INTO `rule_values` VALUES ('1',  'Aggro:SittingAggroMod', '35');
INSERT INTO `rule_values` VALUES ('1',  'Aggro:MeleeRangeAggroMod', '20');
INSERT INTO `rule_values` VALUES ('1',  'Aggro:CurrentTargetAggroMod', '0');
INSERT INTO `rule_values` VALUES ('1',  'Aggro:CriticallyWoundedAggroMod', '100');
INSERT INTO `rule_values` VALUES  ('1', 'Aggro:SlowAggroMod', '450');
INSERT INTO `rule_values` VALUES ('1',  'Aggro:IncapacitateAggroMod', '500');
INSERT INTO `rule_values` VALUES ('1',  'Aggro:MovementImpairAggroMod', '175');
INSERT INTO `rule_values` VALUES  ('1', 'NPC:BuffFriends', 'true');
INSERT INTO `rule_values` VALUES ('1',  'Character:DeathItemLossLevel', '10');
INSERT INTO `rule_values` VALUES ('1',  'Watermap:CheckWaypointsInWaterWhenLoading', 'true');
INSERT INTO  `rule_values` VALUES ('1', 'Watermap:CheckForWaterAtWaypoints',  'true');
INSERT INTO `rule_values` VALUES ('1',  'Watermap:CheckForWaterWhenMoving', 'true');
INSERT INTO `rule_values` VALUES  ('1', 'Watermap:CheckForWaterOnSendTo', 'false');
INSERT INTO `rule_values`  VALUES ('1', 'Watermap:CheckForWaterWhenFishing', 'true');
INSERT INTO  `rule_values` VALUES ('1', 'Watermap:FishingRodLength', '30');
INSERT INTO  `rule_values` VALUES ('1', 'Watermap:FishingLineLength', '40');
INSERT INTO  `rule_values` VALUES ('1', 'Character:ItemDamageShieldCap', '30');
INSERT  INTO `rule_values` VALUES ('1', 'Character:ItemAccuracyCap', '150');
INSERT  INTO `rule_values` VALUES ('1', 'Character:ItemAvoidanceCap', '100');
INSERT  INTO `rule_values` VALUES ('1', 'Character:ItemCombatEffectsCap',  '100');
INSERT INTO `rule_values` VALUES ('1', 'Character:ItemShieldingCap',  '35');
INSERT INTO `rule_values` VALUES ('1',  'Character:ItemSpellShieldingCap', '35');
INSERT INTO `rule_values` VALUES  ('1', 'Character:ItemDoTShieldingCap', '35');
INSERT INTO `rule_values`  VALUES ('1', 'Character:ItemStunResistCap', '35');
INSERT INTO `rule_values`  VALUES ('1', 'Character:ItemStrikethroughCap', '35');
INSERT INTO  `rule_values` VALUES ('1', 'Spells:PartialHitChanceFear', '0.25');
INSERT  INTO `rule_values` VALUES ('1', 'Zone:MQWarpExemptStatus', '-1');
INSERT INTO  `rule_values` VALUES ('1', 'Zone:MQZoneExemptStatus', '-1');
INSERT INTO  `rule_values` VALUES ('1', 'Zone:MQGateExemptStatus', '-1');
INSERT INTO  `rule_values` VALUES ('1', 'Zone:MQGhostExemptStatus', '-1');
INSERT INTO  `rule_values` VALUES ('1', 'Zone:EnableMQWarpDetector', 'true');
INSERT INTO  `rule_values` VALUES ('1', 'Zone:EnableMQZoneDetector', 'true');
INSERT INTO  `rule_values` VALUES ('1', 'Zone:EnableMQGateDetector', 'true');
INSERT INTO  `rule_values` VALUES ('1', 'Zone:EnableMQGhostDetector', 'true');
INSERT INTO  `rule_values` VALUES ('1', 'Zone:MQWarpDetectorDistance', '4900');
INSERT  INTO `rule_values` VALUES ('1', 'Zone:MQWarpLagThreshold', '140');
INSERT  INTO `rule_values` VALUES ('1', 'Zone:MQWarpThresholdTimer', '90000');
INSERT  INTO `rule_values` VALUES ('1', 'Combat:EnableFearPathing', 'true');
INSERT  INTO `rule_values` VALUES ('1', 'Combat:FleeHPRatio', '22');
INSERT INTO  `rule_values` VALUES ('1', 'Combat:FleeIfNotAlone', 'false');

[aapov]

thanks for the info. I will try that. Once again I appreciate it.