[Help please]

[2013martin1212]

Please someone help me to set the saving system to mysql

i no its need to do the dbQury or something like that ,but i cant edit this scripts

local spawnPositions = { 
{2285.6999511719,-1535.4000244141,625.40002441406}, 
{2283.3000488281,-1564.1999511719,630.59997558594}, 
{2286.1999511719,-1522.5,623}, 
  
} 
local playerDataTable = { 
  {"alivetime"}, 
  {"skin"}, 
  {"MAX_Slots"}, 
  {"bandit"}, 
  {"blood"}, 
  {"food"}, 
  {"thirst"}, 
  { 
    "temperature" 
  }, 
  { 
    "currentweapon_1" 
  }, 
  { 
    "currentweapon_2" 
  }, 
  { 
    "currentweapon_3" 
  }, 
  {"bleeding"}, 
  {"brokenbone"}, 
  {"pain"}, 
  {"cold"}, 
  {"infection"}, 
  {"humanity"}, 
  {"points"}, 
  { 
    "zombieskilled" 
  }, 
  {"headshots"}, 
  {"murders"}, 
  { 
    "banditskilled" 
  }, 
  {"Wood Pile"}, 
  {"Bandage"}, 
  { 
    "Water Bottle" 
  }, 
  {"Pasta Can"}, 
  {"Beans Can"}, 
  {"Burger"}, 
  { 
    "Box of Matches" 
  }, 
  {"G17 Mag"}, 
  {"Makarov SD Mag"}, 
  { 
    ".45 ACP" 
  }, 
  {"G17"}, 
  {"Makarov SD"}, 
  { 
    "Winchester 1866" 
  }, 
  {"PDW"}, 
  { 
    "Hunting Knife" 
  }, 
  {"Hatchet"}, 
  {"Pizza"}, 
  {"Morphine"}, 
  { 
    "Soda Bottle" 
  }, 
  { 
    "Empty Gas Canister" 
  }, 
  { 
    "Full Gas Canister" 
  }, 
  {"Roadflare"}, 
  {"Milk"}, 
  {"PDW Mag"}, 
  {"MP5A5 Mag"}, 
  {"30Rnd. AKS"}, 
  {"STANAG Mag"}, 
  {"Tear Gas"}, 
  {"M67 Frag Grenade"}, 
  { 
    "Revolver" 
  }, 
  { 
    "Sawn-Off Shotgun" 
  }, 
  { 
    "SPAZ-12 Combat Shotgun" 
  }, 
  {"MP5A5"}, 
  {"Watch"}, 
  {"Medic Kit"}, 
  {"Heat Pack"}, 
  { 
    "Lee Enfield" 
  }, 
  {"PDW"}, 
  {"AKS-74 Kobra"}, 
  {"Blood Bag"}, 
  {"GPS"}, 
  {"Map"}, 
  {"Toolbox"}, 
  {"Wire Fence"}, 
  {"Tire"}, 
  {"Engine"}, 
  {"Tank Parts"}, 
  {"DMR Mag"}, 
  {"TEC-9 Mag"}, 
  {"Lee Enfield Mag"}, 
  {"M4A1 CCO"}, 
  {"DMR"}, 
  {"TEC-9"}, 
  {"Satchel"}, 
  {"Infrared Goggles"}, 
  {"Night Vision Goggles"}, 
  {"Tent"}, 
  {"Raw Meat"}, 
  {"Cooked Meat"}, 
  {"Camouflage Clothing"}, 
  {"Ghillie Suit"}, 
  {"Ghillie Suit [F]"}, 
  {"Civilian Clothing"}, 
  {"Camouflage [F] Clothing"}, 
  {"Survivor Clothing"}, 
  {"Civil Clothing"}, 
  {"Painkiller"}, 
  {"Binoculars"}, 
  {"Empty Water Bottle"}, 
  { 
    "Empty Soda Cans" 
  }, 
  { 
    "Scruffy Burgers" 
  }, 
  {"1866 Slug"}, 
  {"2Rnd. Slug"}, 
  { 
    "SPAZ-12 Pellet" 
  }, 
  { 
    "Radio Device" 
  }, 
  { 
    "Machete" 
  }, 
  {"Crowbar"}, 
  {"Golf Club"}, 
  { 
    "Radio Device" 
  }, 
  {"Parachute"} 
} 
function playerLogin(username, pass, player) 
  local playerID = getAccountData(getPlayerAccount(player), "playerID") 
  account = getPlayerAccount(player) 
  local x, y, z = getAccountData(account, "last_x"), getAccountData(account, "last_y"), getAccountData(account, "last_z") 
  local skin = getAccountData(account, "skin") 
  createZombieTable(player) 
  if getAccountData(account, "isDead") then 
    spawnDayZPlayer(player) 
    return 
  end 
  spawnPlayer(player, x, y, z, math.random(0, 360), skin, 0, 0) 
  fadeCamera(player, true) 
  setCameraTarget(player, player) 
  playerCol = createColSphere(x, y, z, 1.5) 
  setElementData(player, "playerCol", playerCol) 
  attachElements(playerCol, player, 0, 0, 0) 
  setElementData(playerCol, "parent", player) 
  setElementData(playerCol, "player", true) 
  for i, data in ipairs(playerDataTable) do 
    local elementData = getAccountData(account, data[1]) 
    if not elementData and data[1] ~= "brokenbone" and data[1] ~= "pain" and data[1] ~= "cold" and data[1] ~= "infection" and data[1] ~= "currentweapon_1" and data[1] ~= "currentweapon_2" and data[1] ~= "currentweapon_3" then 
      if data[1] == "bandit" then 
      else 
        elementData = 0 
      end 
    end 
    setElementData(player, data[1], elementData) 
  end 
  setElementData(player, "logedin", true) 
  local weapon = getElementData(player, "currentweapon_1") 
  if weapon then 
    local ammoData, weapID = getWeaponAmmoType(weapon) 
    giveWeapon(player, weapID, getElementData(player, ammoData), true) 
  end 
  local weapon = getElementData(player, "currentweapon_2") 
  if weapon then 
    local ammoData, weapID = getWeaponAmmoType(weapon) 
    giveWeapon(player, weapID, getElementData(player, ammoData), false) 
  end 
  local weapon = getElementData(player, "currentweapon_3") 
  if weapon then 
    local ammoData, weapID = getWeaponAmmoType(weapon) 
    giveWeapon(player, weapID, getElementData(player, ammoData), false) 
  end 
  setElementModel(player, getElementData(player, "skin")) 
  setElementData(player, "admin", getAccountData(account, "admin") or false) 
  setElementData(player, "supporter", getAccountData(account, "supporter") or false) 
  triggerClientEvent(player, "onClientPlayerDayZLogin", player) 
end 
addEvent("onPlayerDayZLogin", true) 
addEventHandler("onPlayerDayZLogin", getRootElement(), playerLogin) 
Skins = {} 
function playerRegister(username, pass, player) 
  triggerClientEvent(player, "sex", player) 
  local number = math.random(table.size(spawnPositions)) 
  local x, y, z = spawnPositions[number][1], spawnPositions[number][2], spawnPositions[number][3] 
  spawnPlayer(player, x, y, z, math.random(0, 360), 73, 0, 0) 
  fadeCamera(player, true) 
  setCameraTarget(player, player) 
  playerCol = createColSphere(x, y, z, 1.5) 
  attachElements(playerCol, player, 0, 0, 0) 
  setElementData(playerCol, "parent", player) 
  setElementData(playerCol, "player", true) 
  for i, data in ipairs(playerDataTable) do 
    if data[1] == "Bandage" then 
      setElementData(player, data[1], 2) 
    elseif data[1] == "Painkiller" then 
      setElementData(player, data[1], 1) 
    elseif data[1] == "Parachute" then 
      setElementData(player, data[1], 1) 
    elseif data[1] == "MAX_Slots" then 
      setElementData(player, data[1], -- s8) -->
    elseif data[1] == "skin" then 
      setElementData(player, data[1], 73) 
    elseif data[1] == "blood" then 
      setElementData(player, data[1], 12000) 
    elseif data[1] == "temperature" then 
      setElementData(player, data[1], 37) 
    elseif data[1] == "brokenbone" then 
      setElementData(player, data[1], false) 
    elseif data[1] == "pain" then 
      setElementData(player, data[1], false) 
    elseif data[1] == "cold" then 
      setElementData(player, data[1], false) 
    elseif data[1] == "infection" then 
      setElementData(player, data[1], false) 
    elseif data[1] == "food" then 
      setElementData(player, data[1], 100) 
    elseif data[1] == "thirst" then 
      setElementData(player, data[1], 100) 
    elseif data[1] == "currentweapon_1" then 
      setElementData(player, data[1], false) 
    elseif data[1] == "currentweapon_2" then 
      

[JR10]

Posting a long script with absolutely nothing about what's wrong will not get you help.

[Noki]

setAccountData -> dbExec 
getAccountData -> dbQuery & dbPoll 
addAccount -> dbExec 
getAccount -> dbQuery 
getResourceRootElement(getThisResource()) -> resourceRoot