Log in

View Full Version : Skill cap problems, searched for a long time.


lordoftests
09-17-2007, 11:54 PM
Extremely sorry to ask for help here (god knows I've avoided it for a long time already) but I've been hammering out my server emulator administration skill for weeks now (notice the reg date, 2 wekes AFTER i first got the emulator and started working on it) and I've held off on posting until now, but now I gotta know:

What's with the broken skill caps that defy all fixing? I've tried manually adding 100s of new entries to skill_caps tables but I cannot get anything to show up in levels past 70 (red skills and messed up, low skill levels), and in fact now that I look back, the skills pre-70 are also fubared.

For example: If you look in the skill_caps table (on a fresh install that followed the wonderful tutorial on this forum for setting up an offline server) you will see that at level 70 a warrior should have "305" as his maximum, however the game reads the maximum as "270" and although the game allows you to pass 270 in the chatbox, the skills tab does not reflect this (nor does your ATK rating), and it is certainly a flaw and not just cosmetic as the reason I came upon all of this was because I felt my level 70 warrior was extremely weak for his level despite the gear (stuff I had used when I played ages ago). I noticed if you go to level 75 and try to set skill caps correctly most, such as 1hb and 1hs, stay stuck low, in this case at "30". Even incorrectly setting stats, at say, "122" doesn't do anything, as any number over 30 seems to not be read as "possible" by the server.

I also tried changing the rule value in "rule_values" of character:maxlevel to 75, then 100. I realized this would not take effect without changing it's ruleset_id to "2", as this is the default ruleset used in the tutorial process (I hope I presumed correctly). As an alternative I could have changed the ruleset used to "0" and it would use the built-ins in the database... is my understanding of this correct? Needless to say, this didn't work to fix skill caps.

Sorry this is long but I really have worked on this as in depth as I could to the limits of my knowledge and understanding of this emulator. The search function in this forum would have broken if it were possible from my daily chronic use (!) of it. I appreciate all the great info presented in the posts and guides available here, but so much is out of date or inaccurate that I've learned far more from trial and error (apart from the tutorials) than from reading here (though some of the lists are highly useful).

Edit: Oh and one more thing -- what is the table "class_skill" used for and how do I work with it. I notice a lot of "66" entries but have no idea what that means, for example. Is that where you add and remove built in skills for classes, because I'd really like to give track to my warrior characters. :)

Thanks for reading.

An oldbie from Prexus.

lordoftests
09-18-2007, 01:34 AM
I researched this old thread:

http://www.eqemulator.net/forums/showthread.php?t=21283&highlight=skill+caps+level

but the "solution" in the last post doesn't work. You can correct your stats by setting them to zero, true, but that doesn't change the built in cap at 70 that is then messed up by subsequent levels, even with correct database entries.

An important discovery!! -- Every level after 70 is treated as starting over at 1. So 71 is 1 (skill cap of 1hb at 10 (5+5) the formula used for level 1) 72 is 15 and so on, these are the numbers in red that the client displays on the skills page and that are used to compute combat rolls. I'm pretty certain it doesn't use the ones listed in #showskills -- However now that i know this, I can't figure out what I'd need to do to fix it.

Edit2: This does not explain, however, why the skill cap at 70 is 270, even though the database is set to 305. Any number higher than 270 results in a red 270 in the combat skills page, as 270 appears to be the cap at 70 no matter what you put in the database.

lordoftests
09-18-2007, 01:41 AM
Oh and I apologise if this is in the wrong place, I wasn't sure where to post this as it involved multiple areas.