Can't seem to change skills levels! HELP!

[limsniff]

Hi!

I'm trying to create a low level war server and I wish to change the skills of the paladin and knight. I were only used to the old style xml things. How the heck can I change the skills? Plix help
PS: Found a skills parameter in the sql thingy but I cant write anything in there.
PSS: Will try to upload a photo of what I mean .

Thanks!

 

[slavi]

I don't really get that, what do you want to change exactly?
What do you mean by "skills of knight and paladin", multipliers (the rate of skills gain)? Or initial player skills?

if multipliers, then there must be an xml/lua file for that

if initial player skills, then through account creation!!

Sincerely,
Slavi

 

[limsniff]

OK, sorry for the messy explaination. Here is the plan: ONE 1/1 account with 4 characters. 1 knight, 1 paladin, 1 sorcerer, 1 druid. All of level 40 or something with the possibility to log on the same character that doesn't save when death occurs. So I have done all this and changed the mag level of the druid/sorc and so on. But I can't set the, in ths case sword fighting and shielding for the knight and the dist and shielding of the pally to any value. I need the skills to get up to like 70-80. In the old ot servers i could change all this in the "eliteknight.xml" files etc.

Hoping for answers the photo that I uploaded show the only thing I have found in the "phpadmin" thing that seems to have anything with the skills to do.

Thanks!

 

[Addams]

You want players to gain skills on login? This should be added to data\creaturescripts\scripts and registered to login.lua

function onLogin(cid)
local playerVoc = getPlayerVocation(cid)
local reqTries = getPlayerRequiredSkillTries
local skillStor = 56364
local gotSkills = getPlayerStorageValue(cid, 56364)


if playerVoc == 5 and gotSkills == -1 then
doPlayerAddSpentMana(cid, (getPlayerRequiredMana(cid,100)))
doPlayerAddSkillTry(cid, SKILL_SHIELD, reqTries(cid, SKILL_SHIELD, 30))
setPlayerStorageValue(cid, skillStor, 1)

elseif playerVoc == 6 and gotSkills == -1 then
doPlayerAddSpentMana(cid, (getPlayerRequiredMana(cid,100)))
doPlayerAddSkillTry(cid, SKILL_SHIELD, reqTries(cid, SKILL_SHIELD, 25))
setPlayerStorageValue(cid, skillStor, 1)

elseif playerVoc == 7 and gotSkills == -1 then
doPlayerAddSkillTry(cid, SKILL_DISTANCE, reqTries(cid, SKILL_DISTANCE, 90))
doPlayerAddSkillTry(cid, SKILL_SHIELD, reqTries(cid, SKILL_SHIELD, 50))
doPlayerAddSpentMana(cid, (getPlayerRequiredMana(cid,30)))
setPlayerStorageValue(cid, skillStor, 1)

elseif playerVoc == 8 and gotSkills == -1 then
doPlayerAddSpentMana(cid, (getPlayerRequiredMana(cid,8)))
doPlayerAddSkillTry(cid, SKILL_SWORD, reqTries(cid, SKILL_SWORD, 90))
doPlayerAddSkillTry(cid, SKILL_SHIELD, reqTries(cid, SKILL_SHIELD, 60))
setPlayerStorageValue(cid, skillStor, 1)

end
return TRUE
end

<event type="login" name="StartSkills" event="script" value="xxxxx.lua"/>

This one works for TFS 0.4/0.3.6 if you have different TFS post your version and if you want to edit it one player by one player via DB then it should be in players not player_skills like this

 

[limsniff]

You want players to gain skills on login? This should be added to data\creaturescripts\scripts and registered to login.lua

function onLogin(cid)
local playerVoc = getPlayerVocation(cid)
local reqTries = getPlayerRequiredSkillTries
local skillStor = 56364
local gotSkills = getPlayerStorageValue(cid, 56364)


if playerVoc == 5 and gotSkills == -1 then
doPlayerAddSpentMana(cid, (getPlayerRequiredMana(cid,100)))
doPlayerAddSkillTry(cid, SKILL_SHIELD, reqTries(cid, SKILL_SHIELD, 30))
setPlayerStorageValue(cid, skillStor, 1)

elseif playerVoc == 6 and gotSkills == -1 then
doPlayerAddSpentMana(cid, (getPlayerRequiredMana(cid,100)))
doPlayerAddSkillTry(cid, SKILL_SHIELD, reqTries(cid, SKILL_SHIELD, 25))
setPlayerStorageValue(cid, skillStor, 1)

elseif playerVoc == 7 and gotSkills == -1 then
doPlayerAddSkillTry(cid, SKILL_DISTANCE, reqTries(cid, SKILL_DISTANCE, 90))
doPlayerAddSkillTry(cid, SKILL_SHIELD, reqTries(cid, SKILL_SHIELD, 50))
doPlayerAddSpentMana(cid, (getPlayerRequiredMana(cid,30)))
setPlayerStorageValue(cid, skillStor, 1)

elseif playerVoc == 8 and gotSkills == -1 then
doPlayerAddSpentMana(cid, (getPlayerRequiredMana(cid,8)))
doPlayerAddSkillTry(cid, SKILL_SWORD, reqTries(cid, SKILL_SWORD, 90))
doPlayerAddSkillTry(cid, SKILL_SHIELD, reqTries(cid, SKILL_SHIELD, 60))
setPlayerStorageValue(cid, skillStor, 1)

end
return TRUE
end

<event type="login" name="StartSkills" event="script" value="xxxxx.lua"/>

This one works for TFS 0.4/0.3.6 if you have different TFS post your version and if you want to edit it one player by one player via DB then it should be in players not player_skills like this
View attachment 39953

Ok. I want to edit it one by one. The list of skills in the "players tab" that you screenshoted doesnt show on my db i ahd to "train" them.. so kind of worked it out in an odd matter. Thansk for the help!