Exec SQL

[bomba]

I need the function to add skill for SQL database, MYSQL, ex:

WHERE 'player' add 'skill'

, etc... I don't know... help-me =s :thumbup:

 

[bomba]

bump

 

[Darkhaos]

 update players set level = 150 where name = " .. db.escapeString(getCreatureName(cid)) .. ";

 

[bomba]

Can I use:

update players set skillid="7" where name = " .. db.escapeString(getCreatureName(cid)) .. ";

???

The skill 7 is MINEWORKER skill... I need to add this skill to player on my database... help-me

 

[chojrak]

function addSpecialSkill(cid, var)
	local tmpGuid = getPlayerGUID(cid)
	doRemoveCreature(cid)
	db.executeQuery("UPDATE `player_skills` SET `value` = `value` + ".. var .." WHERE `player_id` = '".. tmpGuid .."' AND `skill_id` = 8;")
	return true
end

 

[Cykotitan]

it's easier if you use storages for storing skill levels ..
why would you store it in player_skills if you can't make it show as a new bar in client either way?

 

[bomba]

@Cyk~
I made this skill on sources...

@Choj~
"var" is the skill id?
Can I use:

function addSpecialSkill(cid, var)
 local tmpGuid = getPlayerGUID(cid)
  doRemoveCreature(cid)
  db.executeQuery("UPDATE `player_skills` SET `value` = `value` + ".. var .." wHERE `player_id` = '".. tmpGuid .."';")
 return true
end

function onLogin(cid)
 local storage = 123456789
  if getPlayerStorageValue(cid, storage) <= 0 then
   local SKILL_MINEWORKER = 8
    addSpecialSkill(cid, SKILL_MINEWORKER)
   setPlayerStorageValue(cid, storage, 1)
  end
 return TRUE
end

?

 

[Cykotitan]

No, if you added it in sources, database and vocations.xml properly .. this should work:

local SKILL_MINEWORKER, storage = 8, 30001
function onLogin(cid)
	if getPlayerStorageValue(cid, storage) < 1 then
		doPlayerAddSkill(cid, SKILL_MINEWORKER, 1)
		setPlayerStorageValue(cid, storage, 1)
	end
	return true
end

 

[chojrak]

@bomba :
In my script var = amount of skill to add.

 

[Cykotitan]

@bomba :
In my script var = amount of skill to add.

it would add 'amount' to all skills ..

 

[chojrak]

it would add 'amount' to all skills ..

Aaa lol biga buga, updated my post.

 

[bomba]

Why if I try:

doPlayerAddSkillTry(cid, SKILL_MINEWORKER, 1)

the server down?
look my sources: http://otland.net/f133/mineworker-skill-63568/

HELP-ME please

 

[bomba]

Bump