[مســاعدة] - executeSQLQuery انشاء جدول علي قاعدة البيانات

[Mmohab]

executeSQLQuery("CREATE TABLE IF NOT EXISTS `player_stats` (`username` TEXT, `Thirst` INT, `Hunger` INT)")

addEventHandler("onPlayerQuit",
function (Player)
  local atsh = getElementData(source, "Thirst")
  local hungry = getElementData(source, "Hunger")
  local username = getAccountName(getPlayerAccount(thePlayer))

  local result = executeSQLQuery("SELECT * FROM player_stats WHERE `username` = ?", username)
  if (#result > 1) then
    executeSQLQuery("UPDATE `player_stats` SET `Hunger` = ?, `Thirst` = ? WHERE `username` = ?", hungry, atsh, username)
  else
    executeSQLQuery("INSERT INTO health (username, Thirst, Hunger) VALUES (?, ?, ?)", username, atsh, hungry)
  end
end)

addEventHandler("onPlayerLogin", root, function(_, account)
  local accountName = getAccountName(account)
  local result = executeSQLQuery("SELECT * FROM player_stats WHERE username = ?", accountName)
  if (#result > 1) then
    setElementData(source, "Thirst", result[1].Thirst)
    setElementData(source, "Hunger", result[1].Hunger)
  end
end)

هذا عشان مود الجوع والعطش

بحيث ان لو اللاعب سجل خروج وجوعه 50

لما يرجع يصير جوعه 50 

ما يصير 100

من فضلكم ساعدوني ليش هذا السكريبت ما يشتغل ؟

[Infinity-War]

executeSQLQuery("CREATE TABLE IF NOT EXISTS `player_stats` (`username` TEXT, `Thirst` INT, `Hunger` INT)")

addEventHandler("onPlayerQuit", root ,
function (Player)
  local atsh = getElementData(source, "Thirst")
  local hungry = getElementData(source, "Hunger")
    local account = getPlayerAccount(thePlayer)
    if ( isGuestAccount ( account ) ) then return end 
  local username = getAccountName(account)

  local result = executeSQLQuery("SELECT * FROM player_stats WHERE `username` = ?", username)
  if (#result > 1) then
    executeSQLQuery("UPDATE `player_stats` SET `Hunger` = ?, `Thirst` = ? WHERE `username` = ?", hungry, atsh, username)
  else
    executeSQLQuery("INSERT INTO health (username, Thirst, Hunger) VALUES (?, ?, ?)", username, atsh, hungry)
  end
end)

addEventHandler("onPlayerLogin", root, function(_, account)
  local accountName = getAccountName(account)
  local result = executeSQLQuery("SELECT * FROM player_stats WHERE username = ?", accountName)
  if (#result > 1) then
    setElementData(source, "Thirst", result[1].Thirst)
    setElementData(source, "Hunger", result[1].Hunger)
  end
end)

 

[Mmohab]

10 hours ago, Infinity-War said:

executeSQLQuery("CREATE TABLE IF NOT EXISTS `player_stats` (`username` TEXT, `Thirst` INT, `Hunger` INT)")

addEventHandler("onPlayerQuit", root ,
function (Player)
  local atsh = getElementData(source, "Thirst")
  local hungry = getElementData(source, "Hunger")
    local account = getPlayerAccount(thePlayer)
    if ( isGuestAccount ( account ) ) then return end 
  local username = getAccountName(account)

  local result = executeSQLQuery("SELECT * FROM player_stats WHERE `username` = ?", username)
  if (#result > 1) then
    executeSQLQuery("UPDATE `player_stats` SET `Hunger` = ?, `Thirst` = ? WHERE `username` = ?", hungry, atsh, username)
  else
    executeSQLQuery("INSERT INTO health (username, Thirst, Hunger) VALUES (?, ?, ?)", username, atsh, hungry)
  end
end)

addEventHandler("onPlayerLogin", root, function(_, account)
  local accountName = getAccountName(account)
  local result = executeSQLQuery("SELECT * FROM player_stats WHERE username = ?", accountName)
  if (#result > 1) then
    setElementData(source, "Thirst", result[1].Thirst)
    setElementData(source, "Hunger", result[1].Hunger)
  end
end)

 

Iam using OwlGaming Backup so .. i think this is the problem bcuse it doesn't work

[Infinity-War]

@Mohab - كان في خطا بسيط
جرب هسا :
 

executeSQLQuery("CREATE TABLE IF NOT EXISTS `player_stats` (`username` TEXT, `Thirst` INT, `Hunger` INT)")

addEventHandler("onPlayerQuit", root ,
function ()
  local atsh = getElementData(source, "Thirst")
  local hungry = getElementData(source, "Hunger")
    local account = getPlayerAccount(source)
    if ( isGuestAccount ( account ) ) then return end 
  local username = getAccountName(account)

  local result = executeSQLQuery("SELECT * FROM player_stats WHERE `username` = ?", username)
  if (#result > 1) then
    executeSQLQuery("UPDATE `player_stats` SET `Hunger` = ?, `Thirst` = ? WHERE `username` = ?", hungry, atsh, username)
  else
    executeSQLQuery("INSERT INTO health (username, Thirst, Hunger) VALUES (?, ?, ?)", username, atsh, hungry)
  end
end)

addEventHandler("onPlayerLogin", root, function(_, account)
  local accountName = getAccountName(account)
  local result = executeSQLQuery("SELECT * FROM player_stats WHERE username = ?", accountName)
  if (#result > 1) then
    setElementData(source, "Thirst", result[1].Thirst)
    setElementData(source, "Hunger", result[1].Hunger)
  end
end)

 

[Mmohab]

انا خليته يقول في الديبق success

عشان اتأكد انه نجح

test = executeSQLQuery("CREATE TABLE IF NOT EXISTS `player_stats` (`username` TEXT, `Thirst` INT, `Hunger` INT)")
if test then
    print ("success")
else
    print ("failed")
end
addEventHandler("onPlayerQuit", root ,
function ()
  local atsh = getElementData(source, "Thirst")
  local hungry = getElementData(source, "Hunger")
    local account = getPlayerAccount(source)
    if ( isGuestAccount ( account ) ) then return end 
  local username = getAccountName(account)

  local result = executeSQLQuery("SELECT * FROM player_stats WHERE `username` = ?", username)
  if (#result > 1) then
    executeSQLQuery("UPDATE `player_stats` SET `Hunger` = ?, `Thirst` = ? WHERE `username` = ?", hungry, atsh, username)
  else
    executeSQLQuery("INSERT INTO health (username, Thirst, Hunger) VALUES (?, ?, ?)", username, atsh, hungry)
  end
end)

addEventHandler("onPlayerLogin", root, function(_, account)
  local accountName = getAccountName(account)
  local result = executeSQLQuery("SELECT * FROM player_stats WHERE username = ?", accountName)
  if (#result > 1) then
    setElementData(source, "Thirst", result[1].Thirst)
    setElementData(source, "Hunger", result[1].Hunger)
  end
end)

بس ايش الخطوة اللي بعدها ؟ يعني انا اشكرك جدا انك ساعدتني المشكلة اتحلت

بس مافي شئ اتغير بالنسبة للكلاينت حق المود يعني المفروض اني لما اسوي

local atsh = getElementData(getLocalPlayer(), "Thirst") 
local hungry = getElementData(getLocalPlayer(), "Hunger") 

المفروض انه يسوي تلقائي الجوع والعطش اللي كان متسجل

بس يقولي نفس المشكله ان الجوع والعطش متغير ولازم اخليه كدا

local atsh = getElementData(getLocalPlayer(), "Thirst") or 100
local hungry = getElementData(getLocalPlayer(), "Hunger") or 100

عشان كدا حسيت انه ما في تقدم

ساعدني من فضلك

@Infinity-War

[Infinity-War]

executeSQLQuery("CREATE TABLE IF NOT EXISTS `player_stats` (`username` TEXT, `Thirst` INT, `Hunger` INT)")

addEventHandler("onPlayerQuit", root ,
function ()
  local atsh = getElementData(source, "Thirst")
  local hungry = getElementData(source, "Hunger")
    local account = getPlayerAccount(source)
    if ( isGuestAccount ( account ) ) then return end 
  local username = getAccountName(account)

  local result = executeSQLQuery("SELECT * FROM player_stats WHERE `username` = ?", username)
  if (#result > 1) then
    executeSQLQuery("UPDATE `player_stats` SET `Hunger` = ?, `Thirst` = ? WHERE `username` = ?", hungry, atsh, username)
  else
    executeSQLQuery("INSERT INTO health (username, Thirst, Hunger) VALUES (?, ?, ?)", username, atsh, hungry)
  end
end)

addEventHandler("onPlayerLogin", root, function(_, account)
  local accountName = getAccountName(account)
  local result = executeSQLQuery("SELECT * FROM player_stats WHERE username = ?", accountName)
  if (#result > 1) then
      outputChatBox ( 'done' )
    setElementData(source, "Thirst", result[1].Thirst)
    setElementData(source, "Hunger", result[1].Hunger)
  end
end)

شوف اذا قال لك Done بالشات او لا .

[Mmohab]

للأسف ما حصل شئ 
طب ممكن تكون المشكلة في الكلاينت سايد ؟
@Infinity-War

طب هل استخدامي لباك اب owlgaming 

ممكن يكون السبب في المشكلة ؟

[Infinity-War]

34 minutes ago, Mohab said:

للأسف ما حصل شئ 
طب ممكن تكون المشكلة في الكلاينت سايد ؟
@Infinity-War

طب هل استخدامي لباك اب owlgaming 

ممكن يكون السبب في المشكلة ؟

لا , طلع لك شيء في الشات ولا لا ؟

[Mmohab]

11 hours ago, Infinity-War said:

لا , طلع لك شيء في الشات ولا لا ؟

شكرا لمساعدتك حليت المشكلة

11 hours ago, Infinity-War said:

لا , طلع لك شيء في الشات ولا لا ؟

شكرا لمساعدتك حليت المشكلة

[iwalidza]

8 hours ago, Infinity-War said:

لا , طلع لك شيء في الشات ولا لا ؟

من الافضل ان تشرح له المشكلة و اين هي و طريقة حلها 
مش تعطيه اياها جاهزة عشان يتعلم يحل مشاكله بنفسه

[N3xT]

executeSQLQuery("CREATE TABLE IF NOT EXISTS `player_stats` (`username` TEXT, `Thirst` INT, `Hunger` INT)")

addEventHandler("onPlayerQuit", root,
    function ()
        local account = getPlayerAccount(source)
        if ( isGuestAccount ( account ) ) then return end 
        
        local atsh = getElementData(source, "Thirst")
        local hungry = getElementData(source, "Hunger")
        local username = getAccountName(account)

        local result = executeSQLQuery("SELECT * FROM player_stats WHERE `username` = ?", username)
        if (result and #result > 0) then
            executeSQLQuery("UPDATE `player_stats` SET `Hunger` = ?, `Thirst` = ? WHERE `username` = ?", hungry, atsh, username)
        else
            executeSQLQuery("INSERT INTO health (username, Thirst, Hunger) VALUES (?, ?, ?)", username, atsh, hungry)
        end
    end
)

addEventHandler("onPlayerLogin", root, 
    function (_, account)
        local accountName = getAccountName(account)
        local result = executeSQLQuery("SELECT * FROM player_stats WHERE username = ?", accountName)
        if (result and #result > 0) then
            setElementData(source, "Thirst", result[1].Thirst)
            setElementData(source, "Hunger", result[1].Hunger)
        end
    end
)