Skills reset problem, very annoying

[cbrm]

My distro:
TFS 0.2.5
MySQL phpmyadmin
gesior for 0.2

Well this wasn't happening before just some days ago new players notified me their skills go back to 10, when they train at training monks or when they fight with monsters or players, etc
-.- this is really annoying

My skill rate is 9

I checked the sample chars for gesior, I've even reset-ed them but the problem is there yet. Any clue? rep+

 

[SpiderOT]

there is alot of thread about skill save i think you need to update your phpmyadmin
use search

 

[cbrm]

well I got a not-so-old phpmyadmin seems I'll have to update
hope it works

this problem only happens with new created players

 

[SpiderOT]

new created player then you have something wrong in your sample check the id of sample character in player_skill

 

[cbrm]

@up I don't think so
those samples worked well before

Now I noticed I have to update my phpmyadmin to see if that fixes the prob

 

[cbrm]

new created player then you have something wrong in your sample check the id of sample character in player_skill

updated to last xaamp and phpmyadmin, stillo not working

I did what u told me, and the samples'ID don't appear in skillsdb

 

[cbrm]

thnx dude you gave me a clue so I googled and added this to firstitems.lua:

	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()

credits to the scripter, dontremember now