Help - 16. HP/Mana/Endurance Changes - All new formulas for these have been added

[Rykeau]

I'm sorry for bothering all of you with this but I'm at the end of my rope with this issue. I've been searching the forums for almost 2 weeks for a solution and can't seem to find (or see) the answer.

I know there used to be a large display issue with the way HP/Mana/End displayed in the SOD client. According to the SOD Dev Tracking list it shows new formulas were added and HP/Mana/Endurance are now showing correctly (#16 in the list).

I'm using the Steam unpatched SOD client, EQEmu-Rev1612-Bots.zip source and the peqdb_rev1589.sql dabase from the downloads area and I'm not able to get my stats to display anything close to full. All characters (stripped down with no items or AAs) from level 1 to 56 will display no higher than 59% HP, 78% Mana and 78% Endurance. I had understood the newer formulas were more accurate than this which is why I'm asking. I've tried reverting back to the 1316 bot build with no success.

If somebody could point me in some direction (if there is one) to look and/or remedy this it would be appreciated.

Rykeau

[pfyon]

In your rules_values table, there's a rule called:

Character:SoDClientUseSoDHPManaEnd

Set that to true.

[Rykeau]

Thanks for the response Pfyon. My rules_values table does not have that line item for some reason. As I mentioned, I created my DB from scratch using peqdb_rev1589.sql from the downloads area. I do restore other tables but don't touch the rules_values table for anything. I'll manually add the entry and see if it helps.

For reference, my rules_value table currently has 249 line items... do you happen to know how many it should have?

[pfyon]

Mine has 249 as well, so either we have some different values or you just missed it.

mysql> select rule_name from rule_values;
+----------------------------------------------+
| rule_name                                    |
+----------------------------------------------+
| AA:ExpPerPoint                               |
| Adventure:ItemIDToEnablePorts                |
| Adventure:LDoNAdventureExpireTime            |
| Adventure:MaxLevelRange                      |
| Adventure:MaxNumberForGroup                  |
| Adventure:MaxNumberForRaid                   |
| Adventure:MinNumberForGroup                  |
| Adventure:MinNumberForRaid                   |
| Aggro:CriticallyWoundedAggroMod              |
| Aggro:CurrentTargetAggroMod                  |
| Aggro:MeleeRangeAggroMod                     |
| Aggro:PetSpellAggroMod                       |
| Aggro:SittingAggroMod                        |
| Aggro:SmartAggroList                         |
| Aggro:SongAggroMod                           |
| Aggro:SpellAggroMod                          |
| Bazaar:AuditTrail                            |
| Bazaar:EnableWarpToTrader                    |
| Bazaar:MaxBarterSearchResults                |
| Bazaar:MaxSearchResults                      |
| Channels:DeleteTimer                         |
| Channels:RequiredStatusAdmin                 |
| Channels:RequiredStatusListAll               |
| Character:AAExpMultiplier                    |
| Character:AutosaveIntervalS                  |
| Character:BaseHPRegenBonusRaces              |
| Character:BindAnywhere                       |
| Character:ConsumptionMultiplier              |
| Character:CorpseDecayTimeMS                  |
| Character:DeathExpLossLevel                  |
| Character:DeathExpLossMaxLevel               |
| Character:DeathExpLossMultiplier             |
| Character:DeathItemLossLevel                 |
| Character:EnduranceRegenMultiplier           |
| Character:ExpMultiplier                      |
| Character:FeignKillsPet                      |
| Character:GroupExpMultiplier                 |
| Character:HealOnLevel                        |
| Character:HPRegenMultiplier                  |
| Character:ItemAccuracyCap                    |
| Character:ItemAvoidanceCap                   |
| Character:ItemCombatEffectsCap               |
| Character:ItemDamageShieldCap                |
| Character:ItemDoTShieldingCap                |
| Character:ItemHealthRegenCap                 |
| Character:ItemManaRegenCap                   |
| Character:ItemShieldingCap                   |
| Character:ItemSpellShieldingCap              |
| Character:ItemStrikethroughCap               |
| Character:ItemStunResistCap                  |
| Character:KillsPerGroupLeadershipAA          |
| Character:KillsPerRaidLeadershipAA           |
| Character:LeaveCorpses                       |
| Character:LeaveNakedCorpses                  |
| Character:ManaRegenMultiplier                |
| Character:MaxCharmDurationForPlayerCharacter |
| Character:MaxExpLevel                        |
| Character:MaxFearDurationForPlayerCharacter  |
| Character:MaxLevel                           |
| Character:RaidExpMultiplier                  |
| Character:RestRegenPercent                   |
| Character:RestRegenTimeToActivate            |
| Character:SharedBankPlat                     |
| Character:SkillUpModifier                    |
| Character:SoDClientUseSoDHPManaEnd           |
| Character:UseDeathExpLossMult                |
| Chat:EnableAntiSpam                          |
| Chat:EnableMailKeyIPVerification             |
| Chat:EnableVoiceMacros                       |
| Chat:GlobalChatLevelLimit                    |
| Chat:IntervalDurationMS                      |
| Chat:KarmaGlobalChatLimit                    |
| Chat:KarmaUpdateIntervalMS                   |
| Chat:MaximumMessagesPerInterval              |
| Chat:MaxMessagesBeforeKick                   |
| Chat:MinimumMessagesPerInterval              |
| Chat:MinStatusToBypassAntiSpam               |
| Chat:ServerWideAuction                       |
| Chat:ServerWideOOC                           |
| Combat:AdjustProcPerMinute                   |
| Combat:AgiHitFactor                          |
| Combat:ArcheryBaseDamageBonus                |
| Combat:ArcheryBonusRequiresStationary        |
| Combat:ArcheryHitPenalty                     |
| Combat:AssistNoTargetSelf                    |
| Combat:AvgProcsPerMinute                     |
| Combat:BaseCritChance                        |
| Combat:BaseHitChance                         |
| Combat:BaseProcChance                        |
| Combat:BerserkBaseCritChance                 |
| Combat:ClientBaseCritChance                  |
| Combat:DragonPunchBonus                      |
| Combat:EagleStrikeBonus                      |
| Combat:EnableFearPathing                     |
| Combat:FleeHPRatio                           |
| Combat:FleeIfNotAlone                        |
| Combat:FleeSnareHPRatio                      |
| Combat:FlyingKickBonus                       |
| Combat:HitBonusPerLevel                      |
| Combat:HitFalloffMajor                       |
| Combat:HitFalloffMinor                       |
| Combat:HitFalloffModerate                    |
| Combat:MaxFlurryHits                         |
| Combat:MaxRampageTargets                     |
| Combat:MinRangedAttackDist                   |
| Combat:MonkDamageTableBonus                  |
| Combat:NPCBashKickLevel                      |
| Combat:NPCBonusHitChance                     |
| Combat:PetAttackMagicLevel                   |
| Combat:ProcDexDivideBy                       |
| Combat:ProcPerMinDexContrib                  |
| Combat:ProcTargetOnly                        |
| Combat:RoundKickBonus                        |
| Combat:TigerClawBonus                        |
| Combat:UseIntervalAC                         |
| Combat:WarBerBaseCritChance                  |
| Combat:WeaponSkillFalloff                    |
| EventLog:RecordBuyFromMerchant               |
| EventLog:RecordSellToMerchant                |
| GM:MinStatusToZoneAnywhere                   |
| Guild:MaxMembers                             |
| Mail:EnableMailSystem                        |
| Mail:ExpireRead                              |
| Mail:ExpireTrash                             |
| Mail:ExpireUnread                            |
| Map:FindBestZHeightAdjust                    |
| Map:FixPathingZAtWaypoints                   |
| Map:FixPathingZMaxDeltaLoading               |
| Map:FixPathingZMaxDeltaMoving                |
| Map:FixPathingZMaxDeltaSendTo                |
| Map:FixPathingZMaxDeltaWaypoint              |
| Map:FixPathingZOnSendTo                      |
| Map:FixPathingZWhenLoading                   |
| Map:FixPathingZWhenMoving                    |
| Map:UseClosestZ                              |
| Merchant:BuyCostMod                          |
| Merchant:ChaBonusMod                         |
| Merchant:ChaPenaltyMod                       |
| Merchant:PriceBonusPct                       |
| Merchant:PricePenaltyPct                     |
| Merchant:SellCostMod                         |
| Merchant:UsePriceMod                         |
| NPC:BuffFriends                              |
| NPC:CorpseUnlockTimer                        |
| NPC:EmptyNPCCorpseDecayTimeMS                |
| NPC:EnableNPCQuestJournal                    |
| NPC:LastFightingDelayMovingMax               |
| NPC:LastFightingDelayMovingMin               |
| NPC:MajorNPCCorpseDecayTimeMS                |
| NPC:MinorNPCCorpseDecayTimeMS                |
| NPC:OOCRegen                                 |
| NPC:ReturnNonQuestNoDropItems                |
| NPC:SayPauseTimeInSec                        |
| NPC:SmartLastFightingDelayMoving             |
| NPC:UseItemBonusesForNonPets                 |
| Pathing:Aggro                                |
| Pathing:AggroReturnToGrid                    |
| Pathing:CandidateNodeRangeXY                 |
| Pathing:CandidateNodeRangeZ                  |
| Pathing:CullNodesFromEnd                     |
| Pathing:CullNodesFromStart                   |
| Pathing:Fear                                 |
| Pathing:Find                                 |
| Pathing:Guard                                |
| Pathing:LOSCheckFrequency                    |
| Pathing:MinDistanceForLOSCheckLong           |
| Pathing:MinDistanceForLOSCheckShort          |
| Pathing:MinNodesTraversedForLOSCheck         |
| Pathing:RouteUpdateFrequencyLong             |
| Pathing:RouteUpdateFrequencyNodeCount        |
| Pathing:RouteUpdateFrequencyShort            |
| Pathing:ZDiffThreshold                       |
| Pets:AttackCommandRange                      |
| Skills:MaxTradeskillSearchSkillDiff          |
| Skills:MaxTrainTradeskills                   |
| Skills:UseLimitTradeskillSearchSkillDiff     |
| Spells:AutoResistDiff                        |
| Spells:BaseCritChance                        |
| Spells:BaseCritRatio                         |
| Spells:EnableSpellGlobals                    |
| Spells:MaxBuffSlotsNPC                       |
| Spells:MaxDiscSlotsNPC                       |
| Spells:MaxSongSlotsNPC                       |
| Spells:MaxTotalSlotsNPC                      |
| Spells:PartialHitChance                      |
| Spells:PartialHitChanceFear                  |
| Spells:ResistChance                          |
| Spells:ResistMod                             |
| Spells:ResistPerLevelDiff                    |
| Spells:SacrificeItemID                       |
| Spells:SacrificeMaxLevel                     |
| Spells:SacrificeMinLevel                     |
| Spells:TranslocateTimeLimit                  |
| Spells:WizCritChance                         |
| Spells:WizCritLevel                          |
| Spells:WizCritRatio                          |
| TaskSystem:EnableTaskProximity               |
| TaskSystem:EnableTaskSystem                  |
| TaskSystem:KeepOneRecordPerCompletedTask     |
| TaskSystem:PeriodicCheckTimer                |
| TaskSystem:RecordCompletedOptionalActivities |
| TaskSystem:RecordCompletedTasks              |
| Watermap:CheckForWaterAtWaypoints            |
| Watermap:CheckForWaterOnSendTo               |
| Watermap:CheckForWaterWhenFishing            |
| Watermap:CheckForWaterWhenMoving             |
| Watermap:CheckWaypointsInWaterWhenLoading    |
| Watermap:FishingLineLength                   |
| Watermap:FishingRodLength                    |
| World:AccountSessionLimit                    |
| World:AddMaxClientsPerIP                     |
| World:AddMaxClientsStatus                    |
| World:ClearTempMerchantlist                  |
| World:ClientKeepaliveTimeoutMS               |
| World:EnableReturnHomeButton                 |
| World:EnableTutorialButton                   |
| World:ExemptAccountLimitStatus               |
| World:ExemptMaxClientsStatus                 |
| World:GMAccountIPList                        |
| World:GuildBankZoneID                        |
| World:MaxClientsPerIP                        |
| World:MaxClientsSetByStatus                  |
| World:MaxLevelForTutorial                    |
| World:MinGMAntiHackStatus                    |
| World:MinOfflineTimeToReturnHome             |
| World:SoFStartZoneID                         |
| World:TutorialZoneID                         |
| World:UseBannedIPsTable                      |
| World:ZoneAutobootTimeoutMS                  |
| Zone:AutoShutdownDelay                       |
| Zone:ClientLinkdeadMS                        |
| Zone:EnableMQGateDetector                    |
| Zone:EnableMQGhostDetector                   |
| Zone:EnableMQWarpDetector                    |
| Zone:EnableMQZoneDetector                    |
| Zone:EnableShadowrest                        |
| Zone:GraveyardTimeMS                         |
| Zone:HotZoneBonus                            |
| Zone:MarkMQWarpLT                            |
| Zone:MQGateExemptStatus                      |
| Zone:MQGhostExemptStatus                     |
| Zone:MQWarpDetectionDistanceFactor           |
| Zone:MQWarpExemptStatus                      |
| Zone:MQZoneExemptStatus                      |
| Zone:NPCPositonUpdateTicCount                |
| Zone:PEQZoneDebuff1                          |
| Zone:PEQZoneDebuff2                          |
| Zone:PEQZoneReuseTime                        |
| Zone:UsePEQZoneDebuffs                       |
+----------------------------------------------+
249 rows in set (0.00 sec)

[Bellos]

Originally Posted by pfyon

In your rules_values table, there's a rule called:

Character:SoDClientUseSoDHPManaEnd

Set that to true.

thank you brah

[provocating]

Thank god, that was driving me crazy. I was just about to post when I read this.