problem sql

WASSIm. · August 19, 2013

hi guys i have problem

why it not working ?

addEventHandler ("onResourceStart", getResourceRootElement(getThisResource()),function() 
    executeSQLQuery("CREATE TABLE IF NOT EXISTS Save_Money_Account (Account,Money)") 
    outputDebugString("Sql Save Money loaded .",3) 
end) 
  
  
addEventHandler("onPlayerQuit",getRootElement(),function() 
    local Account = getAccountName(getPlayerAccount(source)) 
    local Money = getPlayerMoney(source) 
    local RowAccount = executeSQLQuery("SELECT * FROM Save_Money_Account WHERE Account = '"..tostring(Account).."'") 
    if not  ( #RowAccount == 0 )   then 
        executeSQLQuery("UPDATE Save_Money_Account SET Money=? WHERE Account=?",tostring(Money),tostring(Account)) 
    else 
        executeSQLQuery("INSERT INTO Save_Money_Account(Account,Money) VALUES(?,?)",tostring(Account),tostring(Money)) 
    end 
end) 
  
addEventHandler("onPlayerLogout",getRootElement(),function() 
    local Account = getAccountName(getPlayerAccount(source)) 
    local Money = getPlayerMoney(source) 
    local RowAccount = executeSQLQuery("SELECT * FROM Save_Money_Account WHERE Account = '"..tostring(Account).."'") 
    if not  ( #RowAccount == 0 )   then 
        executeSQLQuery("UPDATE Save_Money_Account SET Money=? WHERE Account=?",tostring(Money),tostring(Account)) 
    else 
        executeSQLQuery("INSERT INTO Save_Money_Account(Account,Money) VALUES(?,?)",tostring(Account),tostring(Money)) 
    end 
    setPlayerMoney(source,0) 
end) 
  
addEventHandler("onPlayerLogin",getRootElement(),function() 
    local Account = getAccountName(getPlayerAccount(source)) 
    local RowAccount = executeSQLQuery("SELECT * FROM Save_Money_Account WHERE Account = '"..tostring(Account).."'") 
    if not  ( #RowAccount == 0 )   then 
        RowAccount = RowAccount[1]["Money"] 
        setPlayerMoney(source,tonumber(RowAccount)) 
    else 
        return false 
    end 
end)

iPrestege · August 19, 2013

It's you're code? or it's from the community?

فاّرس · August 19, 2013

It's hassan.k.s.a code,

تقدر تستخدم xml

لاكن هذا مثال على

sql حفظ الفلوس بـ

addEventHandler ("onResourceStart", getResourceRootElement(getThisResource()),function() 
    executeSQLQuery("CREATE TABLE IF NOT EXISTS Save_Money_Hassan (Account,Money)") 
end) 
  
addEventHandler("onPlayerQuit",getRootElement(),function() 
    local Account = getAccountName(getPlayerAccount(source)) 
    local Money = getPlayerMoney(source) 
    local RowAccount = executeSQLQuery("SELECT * FROM Save_Money_Hassan WHERE Account = '"..tostring(Account).."'") 
    if not  ( #RowAccount == 0 )   then 
        executeSQLQuery("UPDATE Save_Money_Hassan SET Money=? WHERE Account=?",tostring(Money),tostring(Account)) 
    else 
        executeSQLQuery("INSERT INTO Save_Money_Hassan(Account,Money) VALUES(?,?)",tostring(Account),tostring(Money)) 
    end 
end) 
  
addEventHandler("onPlayerLogout",getRootElement(),function() 
    local Account = getAccountName(getPlayerAccount(source)) 
    local Money = getPlayerMoney(source) 
    local RowAccount = executeSQLQuery("SELECT * FROM Save_Money_Hassan WHERE Account = '"..tostring(Account).."'") 
    if not  ( #RowAccount == 0 )   then 
        executeSQLQuery("UPDATE Save_Money_Hassan SET Money=? WHERE Account=?",tostring(Money),tostring(Account)) 
    else 
        executeSQLQuery("INSERT INTO Save_Money_Hassan(Account,Money) VALUES(?,?)",tostring(Account),tostring(Money)) 
    end 
    setPlayerMoney(source,0) 
end) 
  
addEventHandler("onPlayerLogin",getRootElement(),function() 
    local Account = getAccountName(getPlayerAccount(source)) 
    local RowAccount = executeSQLQuery("SELECT * FROM Save_Money_Hassan WHERE Account = '"..tostring(Account).."'") 
    if not  ( #RowAccount == 0 )   then 
        local RowAccount = RowAccount[1]["Money"] 
        setPlayerMoney(source,tonumber(RowAccount)) 
    end 
end)

and it's wrong lol .

WASSIm. · August 19, 2013

It's hassan.k.s.a code,

تقدر تستخدم xml

لاكن هذا مثال على

sql حفظ الفلوس بـ

addEventHandler ("onResourceStart", getResourceRootElement(getThisResource()),function() 
    executeSQLQuery("CREATE TABLE IF NOT EXISTS Save_Money_Hassan (Account,Money)") 
end) 
  
addEventHandler("onPlayerQuit",getRootElement(),function() 
    local Account = getAccountName(getPlayerAccount(source)) 
    local Money = getPlayerMoney(source) 
    local RowAccount = executeSQLQuery("SELECT * FROM Save_Money_Hassan WHERE Account = '"..tostring(Account).."'") 
    if not  ( #RowAccount == 0 )   then 
        executeSQLQuery("UPDATE Save_Money_Hassan SET Money=? WHERE Account=?",tostring(Money),tostring(Account)) 
    else 
        executeSQLQuery("INSERT INTO Save_Money_Hassan(Account,Money) VALUES(?,?)",tostring(Account),tostring(Money)) 
    end 
end) 
  
addEventHandler("onPlayerLogout",getRootElement(),function() 
    local Account = getAccountName(getPlayerAccount(source)) 
    local Money = getPlayerMoney(source) 
    local RowAccount = executeSQLQuery("SELECT * FROM Save_Money_Hassan WHERE Account = '"..tostring(Account).."'") 
    if not  ( #RowAccount == 0 )   then 
        executeSQLQuery("UPDATE Save_Money_Hassan SET Money=? WHERE Account=?",tostring(Money),tostring(Account)) 
    else 
        executeSQLQuery("INSERT INTO Save_Money_Hassan(Account,Money) VALUES(?,?)",tostring(Account),tostring(Money)) 
    end 
    setPlayerMoney(source,0) 
end) 
  
addEventHandler("onPlayerLogin",getRootElement(),function() 
    local Account = getAccountName(getPlayerAccount(source)) 
    local RowAccount = executeSQLQuery("SELECT * FROM Save_Money_Hassan WHERE Account = '"..tostring(Account).."'") 
    if not  ( #RowAccount == 0 )   then 
        local RowAccount = RowAccount[1]["Money"] 
        setPlayerMoney(source,tonumber(RowAccount)) 
    end 
end)

and it's wrong lol .

yeah he is give me it

iPrestege · August 19, 2013

Proof that please .

IIYAMA · August 20, 2013

no proof needed, he is a known stealer.

Wasted my time a several times,

hassan.k.s.a · August 20, 2013

it's wrong lol .

it's not wrong , it's working .

but the problem with server WASSIm., not the problem of the code .

but test this :

    addEventHandler ("onResourceStart", getResourceRootElement(getThisResource()),function() 
        executeSQLQuery("CREATE TABLE IF NOT EXISTS Save_Money_Account (Account,Money)") 
        outputDebugString("Sql Save Money loaded .",3) 
    end) 
      
      
addEventHandler("onPlayerQuit",getRootElement(),function() 
    local Account = getAccountName(getPlayerAccount(source)) 
    local Money = getPlayerMoney(source) 
    local RowAccount = executeSQLQuery("SELECT * FROM Save_Money_Account WHERE Account = '"..tostring(Account).."'") 
    if ( type(RowAccount) == "table" and #RowAccount == 0 or not RowAccount) then 
        executeSQLQuery("INSERT INTO Save_Money_Account(Account,Money) VALUES(?,?)",tostring(Account),tonumber(Money)) 
    else 
        executeSQLQuery("UPDATE Save_Money_Account SET Money=? WHERE Account=?",tonumber(Money),tostring(Account)) 
    end 
end) 
      
addEventHandler("onPlayerLogout",getRootElement(),function() 
    local Account = getAccountName(getPlayerAccount(source)) 
    local Money = getPlayerMoney(source) 
    local RowAccount = executeSQLQuery("SELECT * FROM Save_Money_Account WHERE Account = '"..tostring(Account).."'") 
    if ( type(RowAccount) == "table" and #RowAccount == 0 or not RowAccount ) then 
        executeSQLQuery("INSERT INTO Save_Money_Account(Account,Money) VALUES(?,?)",tostring(Account),tonumber(Money)) 
    else 
        executeSQLQuery("UPDATE Save_Money_Account SET Money=? WHERE Account=?",tonumber(Money),tostring(Account)) 
    end 
    setPlayerMoney(source,0) 
end) 
      
addEventHandler("onPlayerLogin",getRootElement(),function(_,acc) 
    local Account = getAccountName(acc) 
    local RowAccount = executeSQLQuery("SELECT * FROM Save_Money_Account WHERE Account = '"..tostring(Account).."'") 
    if ( type(RowAccount) == "table" and #RowAccount == 0 or not RowAccount ) then 
        return 
    end 
    setPlayerMoney(source,tonumber(RowAccount[1]["Money"])) 
end)

WASSIm. · August 21, 2013

nothing

ERROR

10: Database query failed: no such table: Save_Money_Account

12: Database query failed: no such table: Save_Money_Account

Castillo · August 21, 2013

Means that the table is not being created.

WASSIm. · August 22, 2013

Means that the table is not being created.

how fix ?

xXMADEXx · August 22, 2013

Means that the table is not being created.

how fix ?

You're not defining the sql column types. If you look on the mta wiki, they have the columns defined to TEXT or INT, etc...

WASSIm. · August 22, 2013

i edite it but not working

   addEventHandler ("onResourceStart", getResourceRootElement(getThisResource()),function() 
        executeSQLQuery("CREATE TABLE IF NOT EXISTS Save_Money_Account (Account TEXT,Money TEXT)") 
        outputDebugString("Sql Save Money loaded .",3) 
    end)

Castillo · August 22, 2013

addEventHandler ( "onResourceStart", resourceRoot, 
    function ( ) 
        local result = executeSQLQuery ( "CREATE TABLE IF NOT EXISTS Save_Money_Account (Account TEXT,Money TEXT)" ) 
        outputChatBox ( "QUERY RESULT: ".. tostring ( result ) ) 
        outputDebugString ( "Sql Save Money loaded .", 3 ) 
    end 
)

Try that and see what it outputs to chatbox.

WASSIm. · August 25, 2013

QUERY RESULT: table: 05F115A0

Castillo · August 25, 2013

I've tested the code and the table was created.

WASSIm. · August 25, 2013

I've tested the code and the table was created.

OK thank you

i think problem in my server

problem sql

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

Link to comment

Create an account or sign in to comment

Create an account

Sign in

Recently Browsing 0 members