Skills "stuck"

[Rodo]

For one reason, the skills of the knights became "stuck", the skill don't go up it doesn't matter if they train 9999 hours.

What can be the problem?

 

[Synthetic_]

What skill are they stuck at?

 

[Rodo]

sword, club, axe

 

[Red]

He's speaking of TFS 0.2 I believe. They stop after a certain point.

Any way to fix that?

Red

 

[Cykotitan]

Normally they get stuck at skill level 212.

 

[Rodo]

Im talking about 0.3.5pl1, and it stuck some at 110, some at 95, not at the same.

 

[Rodo]

Bump ._.

 

[hodleo]

does this happens with only recently and all new created players? the problem is in db, the new players won't come with skill tables, or something like that
I got a LUASQL script fix in my old 0.2 ot (real map project heheh)

 

[Icy]

Maybe the `skilltries` table's value in the database is exceeding the limit so it's defaulting back to 0 and therefore never increasing the skill level? Just a thought...

If so then the solution would be to change the value to a bigger one

 

[Rodo]

does this happens with only recently and all new created players? the problem is in db, the new players won't come with skill tables, or something like that
I got a LUASQL script fix in my old 0.2 ot (real map project heheh)

but mine isn't 0.2

@thread:

anyone?

 

[hodleo]

-.- ofc it is compatible with 0.3

 

[Rodo]

so, can you share your "fix script"? :O

 

[C00KIE]

share the goodies... cookie wants script! <munch> <munch> <munch> <munch>

 

[hodleo]

...wahtever but I warn you: My code will only work if the skill bug is the same that occurs in many TFS: New Created Chars don't have their respective sql skill tables..and credits to the original scripter, I googled this some months ago
test it, and you know what to type in creaturescripts.xml

function onLogin(cid)

    if getPlayerGroupId(cid) == 1 and getPlayerStorageValue(cid, 50000) == -1 then
    
    dofile("./config.lua")
    env = assert(luasql.mysql()) 
    con = assert(env:connect(mysqlDatabase, mysqlUser, mysqlPass, mysqlHost, mysqlPort))                
    id = getPlayerGUID(cid)           
    assert(con:execute("INSERT INTO `player_skills` (`player_id` ,`skillid` ,`value` ,`count`) VALUES ('" .. id .. "', '0', '10', '0');"))
    assert(con:execute("INSERT INTO `player_skills` (`player_id` ,`skillid` ,`value` ,`count`) VALUES ('" .. id .. "', '1', '10', '0');"))
    assert(con:execute("INSERT INTO `player_skills` (`player_id` ,`skillid` ,`value` ,`count`) VALUES ('" .. id .. "', '2', '10', '0');"))
    assert(con:execute("INSERT INTO `player_skills` (`player_id` ,`skillid` ,`value` ,`count`) VALUES ('" .. id .. "', '3', '10', '0');"))
    assert(con:execute("INSERT INTO `player_skills` (`player_id` ,`skillid` ,`value` ,`count`) VALUES ('" .. id .. "', '4', '10', '0');"))
    assert(con:execute("INSERT INTO `player_skills` (`player_id` ,`skillid` ,`value` ,`count`) VALUES ('" .. id .. "', '5', '10', '0');"))
    assert(con:execute("INSERT INTO `player_skills` (`player_id` ,`skillid` ,`value` ,`count`) VALUES ('" .. id .. "', '6', '10', '0');"))                    
    con:close()
    env:close()
    
     return TRUE
end

 

[Rodo]

With this all will get skill 10? x.x

 

[hodleo]

lol I forgot that, you'll have to set the storage value of old players to 1 so they don't get resetted

 

[Rodo]

wich storage value?

 

[hodleo]

no, wait, which are you using?
creaturescripts/scripts/firstitems.lua?
or
mods/firstitems.xml?

 

[Rodo]

none, I don't use that script

 

[hodleo]

well it's up to you to decide what to do
setting the storage value positive, so old players won't be affected by the script
then new created ones will have their fixed skills
zzz