Problem with getPedWeapon

Jeeveegee · 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)

Anderl · November 3, 2012

Where is source defined?

Baseplate · 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 · 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 · 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 · November 3, 2012

MySQL is server side only, you can't use it client side.

Jeeveegee · 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 · 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 · 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 · November 3, 2012

Where is source defined?

I asked you that ( for server-side code ), you didn't answer me...

Jeeveegee · 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 · November 3, 2012

Show the whole code ( server-side, where you call the functions, etc ).

Jeeveegee · 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 · 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 · 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)

Problem with getPedWeapon

Recommended Posts

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Create an account or sign in to comment

Create an account

Sign in

Recently Browsing 0 members