mysql Skill system and mysql variable update (how to)

[NopadaN]

Hello everyone! I am beginner in all of this. I am a hobby scripter, because I have interest in scripting. BUT I have problem. I want to make a skill system(like you shoot a leg you get 1points for that), and I found a free resource that varies your skill up to 999 in server side and I found another one that do this client side.(also I won't use it like my scripts in a server) OK I have problems with client AND server side too. I can't connect and update the variable. I created a table for the UZI skill (uzi_skill) to try it, but I can't get working.

Original source: https://community.multitheftauto.com/index.php?p=resources&s=details&id=11129
 

This is just the Uzi skill section. The skill is tied to the character-system. (db: character-system -> table: uzi_skill [tinyint(4)] )

function uzi ( attacker, attackerweapon, bodypart, loss )
	local statz = getPedStat(attacker, 75)
	local healthh = getElementHealth(source)
	local setstat = statz + (100.0 - healthh) * 0.05
	local cteam = getPlayerTeam(attacker)
	local pteam = getPlayerTeam(source)
	--exports['skill']:changeProtectedElementDataEx(source, "uzi_skill", tonumber(setstat)) <--- I tried with this. Complete FAIL(I know why)
		
		if getTeamName(cteam) == getTeamName(pteam) then return false
		elseif attacker and getElementType(attacker) == "player" and (attackerweapon == 28 or attackerweapon == 32) and (statz < 999)
		then
		setPedStat(attacker, 75, setstat)
	end
	if (statz > 980) then
	setPedStat(attacker, 75, 999)
end
end
addEventHandler("onPlayerDamage", getRootElement(), uzi)

I want a bit help, just one example how to do this with this. (Please don't ask in fragments. Also I don't know where to put that script fragment). I'd be happy if someone could help me

[AE.]

debug gives you anything?

Edited June 21, 2017 by 3laa33

[Hale]

You didn't really define what do you want to do. The provided code looks fine so if I got it right you want to update player's (his character actually) weapon stat in an SQL table? If so, simply add (and adjust if needed) the following code into the function that handles player logging out of his character:
 

function onCharacterLogOut(player) -- just an example
  --normal code goes first, that you already should have
  local uzi_stat = getPedStat(player, 75)
  local mp5_stat = getPedStat(player, 76)
  local query = mysql:query_free("UPDATE `character-system` SET `uzi_skill`=" .. mysql:escape_string(uzi_stat) .. ", `mp5_skill`=" .. mysql:escape_string(mp5_stat) .. " WHERE id=" .. mysql:escape_string(getElementData(player, "dbid")))
  if not query then
    outputDebugString("Failed saving weapon stats for " .. getPlayerName(player), 2)
  end
end

 

Edited June 21, 2017 by Hale

[NopadaN]

3laa33

Debug doesn't show anything wrong, just doesn't work at all.

Hale

I'll try your suggestion today in my hobby server and reply if anything goes well or even wrong. (I need a friend who must log in and kill and repeat the process until I see the mysql table variable change)

[NopadaN]

I tried with my friends, and still doesn't work. (I corrected the database name)

function onCharacterLogOut(player) -- just an example
  --normal code goes first, that you already should have EDIT: <--- What do you mean with this? Should I have put the existing script here?
  local uzi_stat = getPedStat(player, 75)
  local mp5_stat = getPedStat(player, 76)
  local query = mysql:query_free("UPDATE `characters` SET `uzi_skill`=" .. mysql:escape_string(uzi_stat) .. ", `mp5_skill`=" .. mysql:escape_string(mp5_stat) .. " WHERE id=" .. mysql:escape_string(getElementData(player, "dbid")))
  if not query then
    outputDebugString("Failed saving weapon stats for " .. getPlayerName(player), 2)
  end

You gave me this script, I'm sure it will work, but I want this to update as I shoot my friend.

 

function uzi ( attacker, attackerweapon, bodypart, loss )
	local statz = getPedStat(attacker, 75)
	local healthh = getElementHealth(source)
	local setstat = statz + (100.0 - healthh) * 0.05
	local cteam = getPlayerTeam(attacker)
	local pteam = getPlayerTeam(source)
		
		if getTeamName(cteam) == getTeamName(pteam) then return false
		elseif attacker and getElementType(attacker) == "player" and (attackerweapon == 28 or attackerweapon == 32) and (statz < 999)
		then
		setPedStat(attacker, 75, setstat)
	end
	if (statz > 980) then
	setPedStat(attacker, 75, 998)
end
end
addEventHandler("onPlayerDamage", getRootElement(), uzi)

You've seen the line, I removed the wrong mysql line. Where should I put your script? Because there are plenty of space and room that makes me lost.

-------------------------------------- UZI -----------------------------------------------------------

function uzi ( attacker, attackerweapon, bodypart, loss )
	local statz = getPedStat(attacker, 75)
	local healthh = getElementHealth(source)
	local setstat = statz + (100.0 - healthh) * 0.05
	local cteam = getPlayerTeam(attacker)
	local pteam = getPlayerTeam(source)
	--exports['skill']:changeProtectedElementDataEx(source, "ui_skill", tonumber(adminlevel)) <--- I tried with this. Complete FAIL
		
		if getTeamName(cteam) == getTeamName(pteam) then return false
		elseif attacker and getElementType(attacker) == "player" and (attackerweapon == 28 or attackerweapon == 32) and (statz < 999)
		then
		setPedStat(attacker, 75, setstat)
	end
	if (statz > 980) then
	setPedStat(attacker, 75, 998)
end
end
addEventHandler("onPlayerDamage", getRootElement(), uzi)

--------------------------------- M4 -------------------------------------------------------------------

function m4 ( attacker, attackerweapon, bodypart, loss )
	local statz2 = getPedStat(attacker, 78)
	local healthh2 = getElementHealth(source)
	local setstat2 = statz2 + (100.0 - healthh2) * 0.05
	local cteam = getPlayerTeam(attacker)
	local pteam = getPlayerTeam(source)
		
	if getTeamName(cteam) == getTeamName(pteam) then return false
	elseif attacker and getElementType(attacker) == "player" and (attackerweapon == 31) and (statz2 < 999)
	then
		setPedStat(attacker, 78, setstat2)
	end
	if (statz > 980) then
	setPedStat(attacker, 78, 999)
end
	end
addEventHandler("onPlayerDamage", getRootElement(), m4)

------------------------------- AK-47 ------------------------------------------------------------------

function ak ( attacker, attackerweapon, bodypart, loss )
	local statz3 = getPedStat(attacker, 77)
	local healthh3 = getElementHealth(source)
	local setstat3 = statz3 + (100.0 - healthh3) * 0.05
	local cteam = getPlayerTeam(attacker)
	local pteam = getPlayerTeam(source)
		
	if getTeamName(cteam) == getTeamName(pteam) then return false
	elseif attacker and getElementType(attacker) == "player" and (attackerweapon == 30) and (statz3 < 999)
	then
		setPedStat(attacker, 77, setstat3)
	end
	if (statz > 980) then
	setPedStat(attacker, 77, 999)
end
	end
addEventHandler("onPlayerDamage", getRootElement(), ak)

----------------------------------- SPAZ SHOTGUN --------------------------------------------------------

function spaz ( attacker, attackerweapon, bodypart, loss )
	local statz4 = getPedStat(attacker, 74)
	local healthh4 = getElementHealth(source)
	local setstat4 = statz4 + (100.0 - healthh4) * 0.05
	local cteam = getPlayerTeam(attacker)
	local pteam = getPlayerTeam(source)
		
	if getTeamName(cteam) == getTeamName(pteam) then return false
	elseif attacker and getElementType(attacker) == "player" and (attackerweapon == 27) and (statz4 < 999)
	then
		setPedStat(attacker, 74, setstat4)
	end
	if (statz > 980) then
	setPedStat(attacker, 74, 999)
end
	end
addEventHandler("onPlayerDamage", getRootElement(), spaz)

------------------------------------ sawed-off ----------------------------------------------------------

function sawed ( attacker, attackerweapon, bodypart, loss )
	local statz5 = getPedStat(attacker, 73)
	local healthh5 = getElementHealth(source)
	local setstat5 = statz5 + (100.0 - healthh5) * 0.05
	local cteam = getPlayerTeam(attacker)
	local pteam = getPlayerTeam(source)
		
	if getTeamName(cteam) == getTeamName(pteam) then return false
	elseif attacker and getElementType(attacker) == "player" and (attackerweapon == 26) and (statz5 < 999)
	then
		setPedStat(attacker, 73, setstat5)
	end
	if (statz > 980) then
	setPedStat(attacker, 73, 999)
end
	end
addEventHandler("onPlayerDamage", getRootElement(), sawed)

--------------------------------------- MP5 ---------------------------------------------------------------

function mp5 ( attacker, attackerweapon, bodypart, loss )
	local statz6 = getPedStat(attacker, 76)
	local healthh6 = getElementHealth(source)
	local setstat6 = statz6 + (100.0 - healthh6) * 0.05
	local cteam = getPlayerTeam(attacker)
	local pteam = getPlayerTeam(source)
		
	if getTeamName(cteam) == getTeamName(pteam) then return false
	elseif attacker and getElementType(attacker) == "player" and (attackerweapon == 29) and (statz6 < 999)
	then
		setPedStat(attacker, 76, setstat6)
	end
	if (statz > 980) then
	setPedStat(attacker, 76, 999)
end
	end
addEventHandler("onPlayerDamage", getRootElement(), mp5)

-------------------------------------- Sniper --------------------------------------------------------------

function sniper ( attacker, attackerweapon, bodypart, loss )
	local statz7 = getPedStat(attacker, 79)
	local healthh7 = getElementHealth(source)
	local setstat7 = statz7 + (100.0 - healthh7) * 0.05
	local cteam = getPlayerTeam(attacker)
	local pteam = getPlayerTeam(source)
		
	if getTeamName(cteam) == getTeamName(pteam) then return false
	elseif attacker and getElementType(attacker) == "player" and (attackerweapon == 34 or attackerweapon == 33) and (statz7 < 999)
	then
		setPedStat(attacker, 79, setstat7)
	end
	if (statz > 980) then
	setPedStat(attacker, 79, 999)
end
	end
addEventHandler("onPlayerDamage", getRootElement(), sniper)

--------------------------------------- DEAGLE ---------------------------------------------------------------

function deagle ( attacker, attackerweapon, bodypart, loss )
	local statz8 = getPedStat(attacker, 71)
	local healthh8 = getElementHealth(source)
	local setstat8 = statz8 + (100.0 - healthh8) * 0.05
	local cteam = getPlayerTeam(attacker)
	local pteam = getPlayerTeam(source)
		
	if getTeamName(cteam) == getTeamName(pteam) then return false
	elseif attacker and getElementType(attacker) == "player" and (attackerweapon == 24) and (statz8 < 999)
	then
		setPedStat(attacker, 71, setstat8)
	end
	if (statz > 980) then
	setPedStat(attacker, 71, 999)
end
	end
addEventHandler("onPlayerDamage", getRootElement(), deagle)

-------------------------------------------- PISTOL --------------------------------------------------------------

function pistol ( attacker, attackerweapon, bodypart, loss )
	local statz9 = getPedStat(attacker, 69)
	local healthh9 = getElementHealth(source)
	local setstat9 = statz9 + (100.0 - healthh9) * 0.05
	local cteam = getPlayerTeam(attacker)
	local pteam = getPlayerTeam(source)
		
	if getTeamName(cteam) == getTeamName(pteam) then return false
	elseif attacker and getElementType(attacker) == "player" and (attackerweapon == 22) and (statz9 < 999)
	then
		setPedStat(attacker, 69, setstat9)
	end
	if (statz > 980) then
	setPedStat(attacker, 69, 999)
end
	end
addEventHandler("onPlayerDamage", getRootElement(), pistol)

function onCharacterLogOut(player) -- just an example
  --normal code goes first, that you already should have
  local uzi_stat = getPedStat(player, 75)
  local mp5_stat = getPedStat(player, 76)
  local query = mysql:query_free("UPDATE `characters` SET `uzi_skill`=" .. mysql:escape_string(uzi_stat) .. ", `mp5_skill`=" .. mysql:escape_string(mp5_stat) .. " WHERE id=" .. mysql:escape_string(getElementData(player, "dbid")))
  if not query then
    outputDebugString("Failed saving weapon stats for " .. getPlayerName(player), 2)
  end
end
end

This is the whole script. I'm new in all of this. I understand C programming language, and that knowledge helps a bit, but I'm lost.

Hale

I don't need the whole script, just an advice. You give me an example, please insert your example to one of the weapons functions ( I'd prefer UZI, because I didn't make m4, ak sql tables yet)

[Hale]

You should really inform yourself more of how Lua works in MTA before going onto something like this. The code I provided doesn't go in any of these, like I said it should go in a different file, where the onCharacterLogOut function is. If this doesn't work, try going client-side and use onClientPlayerDamage event, which will trigger a function that triggers a server event that then triggers the function that has setPedStat in it. I made it complicated for a reason, once you understand what I wrote you'll be ready to make this work.

[NopadaN]

Okay, I wanted just this type of answer. Now I'll try the whole thing you answered. Thank you, all of your help!