Skip to content

Instantly share code, notes, and snippets.

@erfg12
Last active May 26, 2022 13:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save erfg12/75e3dc772a0c9a5e432aec013e748cdb to your computer and use it in GitHub Desktop.
Save erfg12/75e3dc772a0c9a5e432aec013e748cdb to your computer and use it in GitHub Desktop.
EQEmu Single Player DB Changes Recommended
DB: rule_values
_FEATURES_
- Remove corpse retrieving
- Remove experience loss upon death
- Remove unmemorize spells upon death
- Higher HP/MANA/STA regen
- Soul bind anywhere
- Reduce NPC running away at low HP
- Higher hit chance
- Remove NPC bonuses
- Reduce stun chance
- Other minor adjustments
_SQL STATEMENTS_
UPDATE rule_values SET rule_value = 999 WHERE rule_name = 'Character:DeathItemLossLevel';
UPDATE rule_values SET rule_value = 1 WHERE rule_name = 'Character:DeathExpLossMaxLevel';
UPDATE rule_values SET rule_value = false WHERE rule_name = 'Character:UnmemSpellsOnDeath';
UPDATE rule_values SET rule_value = 300 WHERE rule_name = 'Character:HPRegenMultiplier';
UPDATE rule_values SET rule_value = 300 WHERE rule_name = 'Character:ManaRegenMultiplier';
UPDATE rule_values SET rule_value = 300 WHERE rule_name = 'Character:EnduranceRegenMultiplier';
UPDATE rule_values SET rule_value = 300 WHERE rule_name = 'Character:ConsumptionMultiplier';
UPDATE rule_values SET rule_value = true WHERE rule_name = 'Character:HealOnLevel';
UPDATE rule_values SET rule_value = true WHERE rule_name = 'Character:BindAnywhere';
UPDATE rule_values SET rule_value = 15 WHERE rule_name = 'Character:RestRegenPercent';
UPDATE rule_values SET rule_value = 180 WHERE rule_name = 'Character:BaseRunSpeedCap' AND ruleset_id = 1;
UPDATE rule_values SET rule_value = 180 WHERE rule_name = 'Character:BaseRunSpeedCap' AND ruleset_id = 10;
UPDATE rule_values SET rule_value = true WHERE rule_name = 'Mercs:AllowMercs';
UPDATE rule_values SET rule_value = 0 WHERE rule_name = 'Combat:FleeMultiplier';
UPDATE rule_values SET rule_value = 75 WHERE rule_name = 'Combat:BaseHitChance';
UPDATE rule_values SET rule_value = 0 WHERE rule_name = 'Combat:NPCBonusHitChance';
UPDATE rule_values SET rule_value = 15 WHERE rule_name = 'Combat:MinChancetoHit';
UPDATE rule_values SET rule_value = 40 WHERE rule_name = 'Combat:MinRangedAttackDist';
UPDATE rule_values SET rule_value = 10 WHERE rule_name = 'Combat:ClientStunLevel';
UPDATE rule_values SET rule_value = 50 WHERE rule_name = 'Combat:MonkACBonusWeight';
UPDATE rule_values SET rule_value = true WHERE rule_name = 'NPC:LiveLikeEnrage';
UPDATE rule_values SET rule_value = 5 WHERE rule_name = 'Combat:FleeGrayHPRatio';
UPDATE rule_values SET rule_value = 5 WHERE rule_name = 'Combat:FleeHPRatio' AND ruleset_id = 1;
UPDATE rule_values SET rule_value = 5 WHERE rule_name = 'Combat:FleeHPRatio' AND ruleset_id = 10;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment