[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');