Jeeveegee Posted November 3, 2012 Posted November 3, 2012 Every time I try to use getPedWeapon and getPedTotalAmmo it returns the following in the console: Bad argument @ 'getPedWeapon' Bad argument @ 'getPedTotalAmmo' I use this script in a function after 'onPlayerQuit' to get the weapon and ammo and save it to a mysql database. Any idea how to fix this? This is how I try to retrieve the data local weaponSlot0 = getPedWeapon(source,0) local weaponAmmo0 = getPedTotalAmmo(source,0) local weaponSlot1 = getPedWeapon(source,1) local weaponAmmo1 = getPedTotalAmmo(source,1)
Baseplate Posted November 3, 2012 Posted November 3, 2012 use it Client sided local weaponSlot0 = getPedWeapon(getLocalPlayer(),0) local weaponAmmo0 = getPedTotalAmmo(getLocalPlayer(),0) local weaponSlot1 = getPedWeapon(getLocalPlayer(),1) local weaponAmmo1 = getPedTotalAmmo(getLocalPlayer(),1)
Jeeveegee Posted November 3, 2012 Author Posted November 3, 2012 So now I am trying to trigger the function, which is now saved client-side, from a server-side script like this but nothing is happening. I checked an the client script is not triggered, any help? server script triggerClientEvent("saveWeapons", root, playerID) client script function weaponSaveHandler(playerID) outputDebugString("Disconnect Client Script"..playerID) local weaponSlot0 = getPedWeapon(getLocalPlayer(),0) local weaponAmmo0 = getPedTotalAmmo(getLocalPlayer(),0) local weaponSlot1 = getPedWeapon(getLocalPlayer(),1) local weaponAmmo1 = getPedTotalAmmo(getLocalPlayer(),1) local weaponSlot2 = getPedWeapon(getLocalPlayer(),2) local weaponAmmo2 = getPedTotalAmmo(getLocalPlayer(),2) local weaponSlot3 = getPedWeapon(getLocalPlayer(),3) local weaponAmmo3 = getPedTotalAmmo(getLocalPlayer(),3) local weaponSlot4 = getPedWeapon(localPlayer,4) local weaponAmmo4 = getPedTotalAmmo(localPlayer,4) local weaponSlot5 = getPedWeapon(getLocalPlayer(),5) local weaponAmmo5 = getPedTotalAmmo(getLocalPlayer(),5) local weaponSlot6 = getPedWeapon(getLocalPlayer(),6) local weaponAmmo6 = getPedTotalAmmo(getLocalPlayer(),6) local weaponSlot7 = getPedWeapon(getLocalPlayer(),7) local weaponAmmo7 = getPedTotalAmmo(getLocalPlayer(),7) local weaponSlot8 = getPedWeapon(getLocalPlayer(),8) local weaponAmmo8 = getPedTotalAmmo(getLocalPlayer(),8) local weaponSlot9 = getPedWeapon(getLocalPlayer(),9) local weaponAmmo9 = getPedTotalAmmo(getLocalPlayer(),9) local weaponSlot10 = getPedWeapon(getLocalPlayer(),10) local weaponAmmo10 = getPedTotalAmmo(getLocalPlayer(),10) local weaponSlot11 = getPedWeapon(getLocalPlayer(),11) local weaponAmmo11 = getPedTotalAmmo(getLocalPlayer(),11) local weaponSlot12 = getPedWeapon(getLocalPlayer(),12) local weaponAmmo12 = getPedTotalAmmo(getLocalPlayer(),12) mysql_query(handler,"UPDATE weapons SET weaponSlot0='"..weaponSlot0.."', weaponAmmo0='"..weaponAmmo0.."', weaponSlot1='"..weaponSlot1.."', weaponAmmo1='"..weaponAmmo1.."', weaponSlot2 = '"..weaponSlot2.."', weaponAmmo2 = '"..weaponAmmo2.."', weaponSlot3 = '"..weaponSlot3.."', weaponAmmo3 = '"..weaponAmmo3.."', weaponSlot4 = '"..weaponSlot4.."', weaponAmmo4 = '"..weaponAmmo4.."', weaponSlot5 = '"..weaponSlot5.."', weaponAmmo5 = '"..weaponAmmo5.."', weaponSlot6 = '"..weaponSlot6.."', weaponAmmo6 = '"..weaponAmmo6.."', weaponSlot7 = '"..weaponSlot7.."', weaponAmmo7 = '"..weaponAmmo7.."', weaponSlot8 = '"..weaponSlot8.."', weaponAmmo8 = '"..weaponAmmo8.."', weaponSlot9 = '"..weaponSlot9.."', weaponAmmo9 = '"..weaponAmmo9.."', weaponSlot10 = '"..weaponSlot10.."', weaponAmmo10 = '"..weaponAmmo10.."', weaponSlot11 = '"..weaponSlot11.."', weaponAmmo11 = '"..weaponAmmo11.."', weaponSlot12='"..weaponSlot12.."', weaponAmmo12='"..weaponAmmo12.."' WHERE weaponPlayerID='"..playerID.."'") end addEvent("saveWeapons", true) addEventHandler("saveWeapons", root, weaponSaveHandler)
Baseplate Posted November 3, 2012 Posted November 3, 2012 Client: function weaponSaveHandler(playerID) outputDebugString("Disconnect Client Script"..playerID) local weaponSlot0 = getPedWeapon(getLocalPlayer(),0) local weaponAmmo0 = getPedTotalAmmo(getLocalPlayer(),0) local weaponSlot1 = getPedWeapon(getLocalPlayer(),1) local weaponAmmo1 = getPedTotalAmmo(getLocalPlayer(),1) local weaponSlot2 = getPedWeapon(getLocalPlayer(),2) local weaponAmmo2 = getPedTotalAmmo(getLocalPlayer(),2) local weaponSlot3 = getPedWeapon(getLocalPlayer(),3) local weaponAmmo3 = getPedTotalAmmo(getLocalPlayer(),3) local weaponSlot4 = getPedWeapon(localPlayer,4) local weaponAmmo4 = getPedTotalAmmo(localPlayer,4) local weaponSlot5 = getPedWeapon(getLocalPlayer(),5) local weaponAmmo5 = getPedTotalAmmo(getLocalPlayer(),5) local weaponSlot6 = getPedWeapon(getLocalPlayer(),6) local weaponAmmo6 = getPedTotalAmmo(getLocalPlayer(),6) local weaponSlot7 = getPedWeapon(getLocalPlayer(),7) local weaponAmmo7 = getPedTotalAmmo(getLocalPlayer(),7) local weaponSlot8 = getPedWeapon(getLocalPlayer(),8) local weaponAmmo8 = getPedTotalAmmo(getLocalPlayer(),8) local weaponSlot9 = getPedWeapon(getLocalPlayer(),9) local weaponAmmo9 = getPedTotalAmmo(getLocalPlayer(),9) local weaponSlot10 = getPedWeapon(getLocalPlayer(),10) local weaponAmmo10 = getPedTotalAmmo(getLocalPlayer(),10) local weaponSlot11 = getPedWeapon(getLocalPlayer(),11) local weaponAmmo11 = getPedTotalAmmo(getLocalPlayer(),11) local weaponSlot12 = getPedWeapon(getLocalPlayer(),12) local weaponAmmo12 = getPedTotalAmmo(getLocalPlayer(),12) mysql_query(handler,"UPDATE weapons SET weaponSlot0='"..weaponSlot0.."', weaponAmmo0='"..weaponAmmo0.."', weaponSlot1='"..weaponSlot1.."', weaponAmmo1='"..weaponAmmo1.."', weaponSlot2 = '"..weaponSlot2.."', weaponAmmo2 = '"..weaponAmmo2.."', weaponSlot3 = '"..weaponSlot3.."', weaponAmmo3 = '"..weaponAmmo3.."', weaponSlot4 = '"..weaponSlot4.."', weaponAmmo4 = '"..weaponAmmo4.."', weaponSlot5 = '"..weaponSlot5.."', weaponAmmo5 = '"..weaponAmmo5.."', weaponSlot6 = '"..weaponSlot6.."', weaponAmmo6 = '"..weaponAmmo6.."', weaponSlot7 = '"..weaponSlot7.."', weaponAmmo7 = '"..weaponAmmo7.."', weaponSlot8 = '"..weaponSlot8.."', weaponAmmo8 = '"..weaponAmmo8.."', weaponSlot9 = '"..weaponSlot9.."', weaponAmmo9 = '"..weaponAmmo9.."', weaponSlot10 = '"..weaponSlot10.."', weaponAmmo10 = '"..weaponAmmo10.."', weaponSlot11 = '"..weaponSlot11.."', weaponAmmo11 = '"..weaponAmmo11.."', weaponSlot12='"..weaponSlot12.."', weaponAmmo12='"..weaponAmmo12.."' WHERE weaponPlayerID='"..playerID.."'") end addEvent("saveWeapons", true) addEventHandler("saveWeapons", getRootElement(), weaponSaveHandler) Server: triggerClientEvent("saveWeapons", getRootElement(), playerID)
Castillo Posted November 3, 2012 Posted November 3, 2012 MySQL is server side only, you can't use it client side.
Jeeveegee Posted November 3, 2012 Author Posted November 3, 2012 Client: function weaponSaveHandler(playerID) outputDebugString("Disconnect Client Script"..playerID) local weaponSlot0 = getPedWeapon(getLocalPlayer(),0) local weaponAmmo0 = getPedTotalAmmo(getLocalPlayer(),0) local weaponSlot1 = getPedWeapon(getLocalPlayer(),1) local weaponAmmo1 = getPedTotalAmmo(getLocalPlayer(),1) local weaponSlot2 = getPedWeapon(getLocalPlayer(),2) local weaponAmmo2 = getPedTotalAmmo(getLocalPlayer(),2) local weaponSlot3 = getPedWeapon(getLocalPlayer(),3) local weaponAmmo3 = getPedTotalAmmo(getLocalPlayer(),3) local weaponSlot4 = getPedWeapon(localPlayer,4) local weaponAmmo4 = getPedTotalAmmo(localPlayer,4) local weaponSlot5 = getPedWeapon(getLocalPlayer(),5) local weaponAmmo5 = getPedTotalAmmo(getLocalPlayer(),5) local weaponSlot6 = getPedWeapon(getLocalPlayer(),6) local weaponAmmo6 = getPedTotalAmmo(getLocalPlayer(),6) local weaponSlot7 = getPedWeapon(getLocalPlayer(),7) local weaponAmmo7 = getPedTotalAmmo(getLocalPlayer(),7) local weaponSlot8 = getPedWeapon(getLocalPlayer(),8) local weaponAmmo8 = getPedTotalAmmo(getLocalPlayer(),8) local weaponSlot9 = getPedWeapon(getLocalPlayer(),9) local weaponAmmo9 = getPedTotalAmmo(getLocalPlayer(),9) local weaponSlot10 = getPedWeapon(getLocalPlayer(),10) local weaponAmmo10 = getPedTotalAmmo(getLocalPlayer(),10) local weaponSlot11 = getPedWeapon(getLocalPlayer(),11) local weaponAmmo11 = getPedTotalAmmo(getLocalPlayer(),11) local weaponSlot12 = getPedWeapon(getLocalPlayer(),12) local weaponAmmo12 = getPedTotalAmmo(getLocalPlayer(),12) mysql_query(handler,"UPDATE weapons SET weaponSlot0='"..weaponSlot0.."', weaponAmmo0='"..weaponAmmo0.."', weaponSlot1='"..weaponSlot1.."', weaponAmmo1='"..weaponAmmo1.."', weaponSlot2 = '"..weaponSlot2.."', weaponAmmo2 = '"..weaponAmmo2.."', weaponSlot3 = '"..weaponSlot3.."', weaponAmmo3 = '"..weaponAmmo3.."', weaponSlot4 = '"..weaponSlot4.."', weaponAmmo4 = '"..weaponAmmo4.."', weaponSlot5 = '"..weaponSlot5.."', weaponAmmo5 = '"..weaponAmmo5.."', weaponSlot6 = '"..weaponSlot6.."', weaponAmmo6 = '"..weaponAmmo6.."', weaponSlot7 = '"..weaponSlot7.."', weaponAmmo7 = '"..weaponAmmo7.."', weaponSlot8 = '"..weaponSlot8.."', weaponAmmo8 = '"..weaponAmmo8.."', weaponSlot9 = '"..weaponSlot9.."', weaponAmmo9 = '"..weaponAmmo9.."', weaponSlot10 = '"..weaponSlot10.."', weaponAmmo10 = '"..weaponAmmo10.."', weaponSlot11 = '"..weaponSlot11.."', weaponAmmo11 = '"..weaponAmmo11.."', weaponSlot12='"..weaponSlot12.."', weaponAmmo12='"..weaponAmmo12.."' WHERE weaponPlayerID='"..playerID.."'") end addEvent("saveWeapons", true) addEventHandler("saveWeapons", getRootElement(), weaponSaveHandler) Server: triggerClientEvent("saveWeapons", getRootElement(), playerID) I changed 'root' to 'getRootElement()' like you told me too, but the client script is still not triggered.
Anderl Posted November 3, 2012 Posted November 3, 2012 Client-side code is not needed, you can do everything on server-side. And as Solidsnake14 said, MySQL functions are server-side only.
Jeeveegee Posted November 3, 2012 Author Posted November 3, 2012 Then how do I properly use getPedWeapon and getpedTotalAmmo? I read about it on the wiki and used it like I showed in my first post, but that is not working. Any idea how to get rid of that 'bad argument'?
Anderl Posted November 3, 2012 Posted November 3, 2012 Where is source defined? I asked you that ( for server-side code ), you didn't answer me...
Jeeveegee Posted November 3, 2012 Author Posted November 3, 2012 Where is source defined? I asked you that ( for server-side code ), you didn't answer me... I guess I did not define the source, how exactly do you suggest me doing that?
Anderl Posted November 3, 2012 Posted November 3, 2012 Show the whole code ( server-side, where you call the functions, etc ).
Jeeveegee Posted November 3, 2012 Author Posted November 3, 2012 function onPlayerDisconnect(quitType) local online = getElementData(source, "loggedIn") if (online == "WelcomeBack") then local playername = getPlayerName(source) local ID = mysql_query(handler,"SELECT playerID FROM players WHERE playerName = '"..playername.."'") local row = mysql_fetch_assoc(ID) local playerID = row['playerID'] outputDebugString("Disconnect Server Script "..playerID) triggerClientEvent("saveWeapons", getRootElement(), playerID) mysql_free_result(ID) local x, y, z = getElementPosition(source) local rx,ry,rz = getElementRotation(source) mysql_query(handler,"UPDATE players SET playerHealth='"..getElementHealth(source).."', playerArmor='"..getPedArmor(source).."', playerMoney='"..getPlayerMoney(source).."', playerSkin='"..getElementModel(source).."', playerX='"..x.."', playerY='"..y.."', playerZ='"..z.."', playerA='"..rz.."' WHERE playerName='" .. getPlayerName(source) .. "'") else outputDebugString("NIET ONLINE, NIETS OPGESLAGEN!") end end addEventHandler("onPlayerQuit", getRootElement(), onPlayerDisconnect) addEvent("saveWeapons", true) function weaponSaveHandler(playerID) local weaponSlot0 = getPedWeapon(getLocalPlayer(),0) local weaponAmmo0 = getPedTotalAmmo(getLocalPlayer(),0) local weaponSlot1 = getPedWeapon(getLocalPlayer(),1) local weaponAmmo1 = getPedTotalAmmo(getLocalPlayer(),1) local weaponSlot2 = getPedWeapon(getLocalPlayer(),2) local weaponAmmo2 = getPedTotalAmmo(getLocalPlayer(),2) local weaponSlot3 = getPedWeapon(getLocalPlayer(),3) local weaponAmmo3 = getPedTotalAmmo(getLocalPlayer(),3) local weaponSlot4 = getPedWeapon(localPlayer,4) local weaponAmmo4 = getPedTotalAmmo(localPlayer,4) local weaponSlot5 = getPedWeapon(getLocalPlayer(),5) local weaponAmmo5 = getPedTotalAmmo(getLocalPlayer(),5) local weaponSlot6 = getPedWeapon(getLocalPlayer(),6) local weaponAmmo6 = getPedTotalAmmo(getLocalPlayer(),6) local weaponSlot7 = getPedWeapon(getLocalPlayer(),7) local weaponAmmo7 = getPedTotalAmmo(getLocalPlayer(),7) local weaponSlot8 = getPedWeapon(getLocalPlayer(),8) local weaponAmmo8 = getPedTotalAmmo(getLocalPlayer(),8) local weaponSlot9 = getPedWeapon(getLocalPlayer(),9) local weaponAmmo9 = getPedTotalAmmo(getLocalPlayer(),9) local weaponSlot10 = getPedWeapon(getLocalPlayer(),10) local weaponAmmo10 = getPedTotalAmmo(getLocalPlayer(),10) local weaponSlot11 = getPedWeapon(getLocalPlayer(),11) local weaponAmmo11 = getPedTotalAmmo(getLocalPlayer(),11) local weaponSlot12 = getPedWeapon(getLocalPlayer(),12) local weaponAmmo12 = getPedTotalAmmo(getLocalPlayer(),12) mysql_query(handler,"UPDATE weapons SET weaponSlot0='"..weaponSlot0.."', weaponAmmo0='"..weaponAmmo0.."', weaponSlot1='"..weaponSlot1.."', weaponAmmo1='"..weaponAmmo1.."', weaponSlot2 = '"..weaponSlot2.."', weaponAmmo2 = '"..weaponAmmo2.."', weaponSlot3 = '"..weaponSlot3.."', weaponAmmo3 = '"..weaponAmmo3.."', weaponSlot4 = '"..weaponSlot4.."', weaponAmmo4 = '"..weaponAmmo4.."', weaponSlot5 = '"..weaponSlot5.."', weaponAmmo5 = '"..weaponAmmo5.."', weaponSlot6 = '"..weaponSlot6.."', weaponAmmo6 = '"..weaponAmmo6.."', weaponSlot7 = '"..weaponSlot7.."', weaponAmmo7 = '"..weaponAmmo7.."', weaponSlot8 = '"..weaponSlot8.."', weaponAmmo8 = '"..weaponAmmo8.."', weaponSlot9 = '"..weaponSlot9.."', weaponAmmo9 = '"..weaponAmmo9.."', weaponSlot10 = '"..weaponSlot10.."', weaponAmmo10 = '"..weaponAmmo10.."', weaponSlot11 = '"..weaponSlot11.."', weaponAmmo11 = '"..weaponAmmo11.."', weaponSlot12='"..weaponSlot12.."', weaponAmmo12='"..weaponAmmo12.."' WHERE weaponPlayerID='"..playerID.."'") end addEventHandler("saveWeapons", getRootElement(), weaponSaveHandler)
Anderl Posted November 3, 2012 Posted November 3, 2012 I think you didn't get me; I asked you to show me the whole code as server-side ( how it was before you created the topic ).
Jeeveegee Posted November 3, 2012 Author Posted November 3, 2012 That's exactly what I showed you, but I will post the whole script. it's made up of two seperate scripts, so I will post them both. --LOGIN SCRIPT function loginHandler(username, password) outputChatBox("Name: " .. username .. " and password: " .. password .. ".", client) local result = mysql_query(handler, "SELECT * FROM players WHERE playerName = '" .. username .. "' AND playerPassword = '" .. password .. "' ") local count = mysql_num_rows(result) if (count == 1) then if (client) then local row = mysql_fetch_assoc(result) local playerID = row['playerID'] local playerX = row['playerX'] local playerY = row['playerY'] local playerZ = row['playerZ'] local playerA = row['playerA'] local playerSkin = row['playerSkin'] local playerMoney = row['playerMoney'] local playerHealth = row['playerHealth'] local playerArmor = row['playerArmor'] spawnPlayer(client, playerX, playerY, playerZ, playerA) setElementModel(client, playerSkin) setPlayerMoney(client, playerMoney) setElementHealth(client, playerHealth) setPedArmor(client, playerArmor) fadeCamera(client, true) setCameraTarget(client, client) local online = "WelcomeBack" setElementData(client, "loggedIn", online) triggerEvent("loadWeapons", root, playerID) outputChatBox("You succesfully logged in!", client) end else outputChatBox("Invalid username and password. Please re-connect and try again.", client) end mysql_free_result(result) end addEvent("submitLogin", true) addEventHandler("submitLogin", root, loginHandler) --REGISTER SCRIPT function registerHandler(username, password) outputChatBox("Name: " .. username .. " and password: " .. password .. ".", client) local result = mysql_query(handler, "SELECT * FROM players WHERE playerName = '" .. username .. "'") local count = mysql_num_rows(result) if (count ~= 1) then local query = "INSERT INTO players SET playerName='" .. username .. "', playerPassword='" .. password .. "', playerHealth='100', playerArmor='0', playerMoney='1000', playerSkin='217', playerX='1692.80', playerY='1448.41', playerZ='13', playerA='270', playerAdminLevel='0'" if (mysql_query(handler, query)) then outputChatBox("Account created. Please enter your password to login.") local ID = mysql_query(handler,"SELECT playerID FROM players WHERE playerName = '"..username.."'") local row = mysql_fetch_assoc(ID) local playerID = row['playerID'] triggerEvent("createWeapons", root, playerID) else outputChatBox("An error has occured when trying to create your account.",client) end else outputChatBox("That name is already in use.",client) end mysql_free_result(result) end addEvent("submitRegister", true) addEventHandler("submitRegister", root, registerHandler) --ON PLAYER DISCONNECT function onPlayerDisconnect(quitType) local online = getElementData(source, "loggedIn") if (online == "WelcomeBack") then local playername = getPlayerName(source) local ID = mysql_query(handler,"SELECT playerID FROM players WHERE playerName = '"..playername.."'") local row = mysql_fetch_assoc(ID) local playerID = row['playerID'] outputDebugString("Disconnect Server Script "..playerID) triggerClientEvent("saveWeapons", getRootElement(), playerID) mysql_free_result(ID) local x, y, z = getElementPosition(source) local rx,ry,rz = getElementRotation(source) mysql_query(handler,"UPDATE players SET playerHealth='"..getElementHealth(source).."', playerArmor='"..getPedArmor(source).."', playerMoney='"..getPlayerMoney(source).."', playerSkin='"..getElementModel(source).."', playerX='"..x.."', playerY='"..y.."', playerZ='"..z.."', playerA='"..rz.."' WHERE playerName='" .. getPlayerName(source) .. "'") else outputDebugString("NIET ONLINE, NIETS OPGESLAGEN!") end end addEventHandler("onPlayerQuit", getRootElement(), onPlayerDisconnect) --CHANGE NICKNAME KICK function changeNickHandler(oldNick, newNick) setPlayerName(source, oldNick) kickPlayer(source, "the Server", "Your Nick has to be the same as your Account Name!") end addEvent("changeNick", true) addEventHandler("changeNick", getRootElement(), changeNickHandler) --CAMERA ON PLAYER JOIN function setCameraOnPlayerJoin() fadeCamera(source, true, 5) setCameraMatrix(source, 1979.69, 1564.31, 103.89, 2101.18, 1342.60, 20.53) end addEventHandler("onPlayerJoin", getRootElement(), setCameraOnPlayerJoin) addEvent("createWeapons", true) function weaponCreateHandler(playerID) mysql_query(handler, "INSERT INTO weapons SET weaponPlayerID = '"..playerID.."'") end addEventHandler("createWeapons", root, weaponCreateHandler) addEvent("loadWeapons", true) function weaponLoadHandler(playerID) local result = mysql_query(handler, "SELECT * FROM weapons WHERE weaponPlayerID = '" .. playerID .. "'") local row = mysql_fetch_assoc(result) local weaponSlot0 = row['weaponSlot0'] local weaponAmmo0 = row['weaponAmmo0'] local weaponSlot1 = row['weaponSlot1'] local weaponAmmo1 = row['weaponAmmo1'] local weaponSlot2 = row['weaponSlot2'] local weaponAmmo2 = row['weaponAmmo2'] local weaponSlot3 = row['weaponSlot3'] local weaponAmmo3 = row['weaponAmmo3'] local weaponSlot4 = row['weaponSlot4'] local weaponAmmo4 = row['weaponAmmo4'] local weaponSlot5 = row['weaponSlot5'] local weaponAmmo5 = row['weaponAmmo5'] local weaponSlot6 = row['weaponSlot6'] local weaponAmmo6 = row['weaponAmmo6'] local weaponSlot7 = row['weaponSlot7'] local weaponAmmo7 = row['weaponAmmo7'] local weaponSlot8 = row['weaponSlot8'] local weaponAmmo8 = row['weaponAmmo8'] local weaponSlot9 = row['weaponSlot9'] local weaponAmmo9 = row['weaponAmmo9'] local weaponSlot10 = row['weaponSlot10'] local weaponAmmo10 = row['weaponAmmo10'] local weaponSlot11 = row['weaponSlot11'] local weaponAmmo11 = row['weaponAmmo11'] local weaponSlot12 = row['weaponSlot12'] local weaponAmmo12 = row['weaponAmmo12'] giveWeapon(source, weaponSlot0, weaponAmmo0) giveWeapon(source, weaponSlot1, weaponAmmo1) giveWeapon(source, weaponSlot2, weaponAmmo2) giveWeapon(source, weaponSlot3, weaponAmmo3) giveWeapon(source, weaponSlot4, weaponAmmo4) giveWeapon(source, weaponSlot5, weaponAmmo5) giveWeapon(source, weaponSlot6, weaponAmmo6) giveWeapon(source, weaponSlot7, weaponAmmo7) giveWeapon(source, weaponSlot8, weaponAmmo8) giveWeapon(source, weaponSlot9, weaponAmmo9) giveWeapon(source, weaponSlot10, weaponAmmo10) giveWeapon(source, weaponSlot11, weaponAmmo11) giveWeapon(source, weaponSlot12, weaponAmmo12) mysql_free_result(result) end addEventHandler("loadWeapons", root, weaponLoadHandler) addEvent("saveWeapons", true) function weaponSaveHandler(playerID) local weaponSlot0 = getPedWeapon(getLocalPlayer(),0) local weaponAmmo0 = getPedTotalAmmo(getLocalPlayer(),0) local weaponSlot1 = getPedWeapon(getLocalPlayer(),1) local weaponAmmo1 = getPedTotalAmmo(getLocalPlayer(),1) local weaponSlot2 = getPedWeapon(getLocalPlayer(),2) local weaponAmmo2 = getPedTotalAmmo(getLocalPlayer(),2) local weaponSlot3 = getPedWeapon(getLocalPlayer(),3) local weaponAmmo3 = getPedTotalAmmo(getLocalPlayer(),3) local weaponSlot4 = getPedWeapon(localPlayer,4) local weaponAmmo4 = getPedTotalAmmo(localPlayer,4) local weaponSlot5 = getPedWeapon(getLocalPlayer(),5) local weaponAmmo5 = getPedTotalAmmo(getLocalPlayer(),5) local weaponSlot6 = getPedWeapon(getLocalPlayer(),6) local weaponAmmo6 = getPedTotalAmmo(getLocalPlayer(),6) local weaponSlot7 = getPedWeapon(getLocalPlayer(),7) local weaponAmmo7 = getPedTotalAmmo(getLocalPlayer(),7) local weaponSlot8 = getPedWeapon(getLocalPlayer(),8) local weaponAmmo8 = getPedTotalAmmo(getLocalPlayer(),8) local weaponSlot9 = getPedWeapon(getLocalPlayer(),9) local weaponAmmo9 = getPedTotalAmmo(getLocalPlayer(),9) local weaponSlot10 = getPedWeapon(getLocalPlayer(),10) local weaponAmmo10 = getPedTotalAmmo(getLocalPlayer(),10) local weaponSlot11 = getPedWeapon(getLocalPlayer(),11) local weaponAmmo11 = getPedTotalAmmo(getLocalPlayer(),11) local weaponSlot12 = getPedWeapon(getLocalPlayer(),12) local weaponAmmo12 = getPedTotalAmmo(getLocalPlayer(),12) mysql_query(handler,"UPDATE weapons SET weaponSlot0='"..weaponSlot0.."', weaponAmmo0='"..weaponAmmo0.."', weaponSlot1='"..weaponSlot1.."', weaponAmmo1='"..weaponAmmo1.."', weaponSlot2 = '"..weaponSlot2.."', weaponAmmo2 = '"..weaponAmmo2.."', weaponSlot3 = '"..weaponSlot3.."', weaponAmmo3 = '"..weaponAmmo3.."', weaponSlot4 = '"..weaponSlot4.."', weaponAmmo4 = '"..weaponAmmo4.."', weaponSlot5 = '"..weaponSlot5.."', weaponAmmo5 = '"..weaponAmmo5.."', weaponSlot6 = '"..weaponSlot6.."', weaponAmmo6 = '"..weaponAmmo6.."', weaponSlot7 = '"..weaponSlot7.."', weaponAmmo7 = '"..weaponAmmo7.."', weaponSlot8 = '"..weaponSlot8.."', weaponAmmo8 = '"..weaponAmmo8.."', weaponSlot9 = '"..weaponSlot9.."', weaponAmmo9 = '"..weaponAmmo9.."', weaponSlot10 = '"..weaponSlot10.."', weaponAmmo10 = '"..weaponAmmo10.."', weaponSlot11 = '"..weaponSlot11.."', weaponAmmo11 = '"..weaponAmmo11.."', weaponSlot12='"..weaponSlot12.."', weaponAmmo12='"..weaponAmmo12.."' WHERE weaponPlayerID='"..playerID.."'") end addEventHandler("saveWeapons", getRootElement(), weaponSaveHandler)
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now