تصحيح كود

[Mhmd.z]

ابي احد يصحح ذا الكود حق حفظ فلوس الاعب ب SQLite

addEventHandler('onResourceStart',resourceRoot, 
function () 
dataBase = dbConnect( "sqlite", "money.db" ) 
dbExec ( dataBase, "CREATE TABLE IF NOT EXISTS players_money (account TEXT, money INTEGER)" ) 
end 
) 
  
addEventHandler('onPlayerQuit', root, 
function( player ) 
local money = getPlayerMoney(player) 
local account = getAccountName(getPlayerAccount(player)) 
local qh = dbQuery( dataBase, "SELECT * FROM players_money WHERE account=?", account)  
local result = dbPoll( qh, -1 )  
if result and type(result) == "table" and #result >= 1 then return dbExec( dataBase, "UPDATE players_money SET money=? WHERE account=?", money, account)  end 
dbExec( dataBase, "INSERT INTO players_money (account,money) VALUES(?,?)", account,money) 
end 
) 
  
addEventHandler('onPlayerLogin', root, 
function( player ) 
local account = getAccountName( getPlayerAccount(player) ) 
local qh = dbQuery( dataBase, "SELECT * FROM players_money WHERE account=?", account) 
local result = dbPoll( qh, -1 ) 
if result then 
for _, row in ipairs ( result ) do  
outputChatBox(tostring(row["money"])) 
setPlayerMoney(player,row["money"]) 
end 
end 
end 
)    
  

[Mhmd.z]

ابي احد يصحح ذا الكود حق حفظ فلوس الاعب ب SQLite

addEventHandler('onResourceStart',resourceRoot, 
function () 
dataBase = dbConnect( "sqlite", "money.db" ) 
dbExec ( dataBase, "CREATE TABLE IF NOT EXISTS players_money (account TEXT, money INTEGER)" ) 
end 
) 
  
addEventHandler('onPlayerQuit', root, 
function( player ) 
local money = getPlayerMoney(player) 
local account = getAccountName(getPlayerAccount(player)) 
local qh = dbQuery( dataBase, "SELECT * FROM players_money WHERE account=?", account)  
local result = dbPoll( qh, -1 )  
if result and type(result) == "table" and #result >= 1 then return dbExec( dataBase, "UPDATE players_money SET money=? WHERE account=?", money, account)  end 
dbExec( dataBase, "INSERT INTO players_money (account,money) VALUES(?,?)", account,money) 
end 
) 
  
addEventHandler('onPlayerLogin', root, 
function( player ) 
local account = getAccountName( getPlayerAccount(player) ) 
local qh = dbQuery( dataBase, "SELECT * FROM players_money WHERE account=?", account) 
local result = dbPoll( qh, -1 ) 
if result then 
for _, row in ipairs ( result ) do  
outputChatBox(tostring(row["money"])) 
setPlayerMoney(player,row["money"]) 
end 
end 
end 
)    
  

[!#NssoR_)]

addEventHandler('onResourceStart',resourceRoot, 
function () 
    dataBase = dbConnect( "sqlite", "money.db" ) 
    dbExec ( dataBase, "CREATE TABLE IF NOT EXISTS players_money (account TEXT, money INTEGER)" ) 
end 
) 
      
addEventHandler('onPlayerQuit', root, 
function(  ) 
    local money = getPlayerMoney(source) 
    local account = getAccountName(getPlayerAccount(source)) 
    local qh = dbQuery( dataBase, "SELECT * FROM players_money WHERE account=?", account) 
    local result = dbPoll( qh, -1 ) 
    if result and type(result) == "table" and #result >= 1 then return dbExec( dataBase, "UPDATE players_money SET money=? WHERE account=?", money, account)  end 
    dbExec( dataBase, "INSERT INTO players_money (account,money) VALUES(?,?)", account,money) 
end 
) 
      
addEventHandler('onPlayerLogin', root, 
function(  ) 
    local account = getAccountName( getPlayerAccount(source) ) 
    local qh = dbQuery( dataBase, "SELECT * FROM players_money WHERE account=?", account) 
    local result = dbPoll( qh, -1 ) 
    if result then 
        for _, row in ipairs ( result ) do 
            outputChatBox(tostring(row["money"])) 
            setPlayerMoney(source,row["money"]) 
        end 
    end 
end 
)    

[!#NssoR_)]

addEventHandler('onResourceStart',resourceRoot, 
function () 
    dataBase = dbConnect( "sqlite", "money.db" ) 
    dbExec ( dataBase, "CREATE TABLE IF NOT EXISTS players_money (account TEXT, money INTEGER)" ) 
end 
) 
      
addEventHandler('onPlayerQuit', root, 
function(  ) 
    local money = getPlayerMoney(source) 
    local account = getAccountName(getPlayerAccount(source)) 
    local qh = dbQuery( dataBase, "SELECT * FROM players_money WHERE account=?", account) 
    local result = dbPoll( qh, -1 ) 
    if result and type(result) == "table" and #result >= 1 then return dbExec( dataBase, "UPDATE players_money SET money=? WHERE account=?", money, account)  end 
    dbExec( dataBase, "INSERT INTO players_money (account,money) VALUES(?,?)", account,money) 
end 
) 
      
addEventHandler('onPlayerLogin', root, 
function(  ) 
    local account = getAccountName( getPlayerAccount(source) ) 
    local qh = dbQuery( dataBase, "SELECT * FROM players_money WHERE account=?", account) 
    local result = dbPoll( qh, -1 ) 
    if result then 
        for _, row in ipairs ( result ) do 
            outputChatBox(tostring(row["money"])) 
            setPlayerMoney(source,row["money"]) 
        end 
    end 
end 
)    

[Mhmd.z]

شكرا

[Mhmd.z]

شكرا