Jump to content

MySQL script


RastaMan

Recommended Posts

Hello i have problem. I wrote script to mysql but this script not writes data.

  
function saveTo() 
    local serial = getPlayerSerial(source) 
    local score = getPlayerName(source) 
    local nazwa = getPlayerName(source) 
    local skin = getElementModel(source) 
    local kasa = getPlayerMoney(source) 
    con = mysql_connect ( "127.0.0.1", "****", "****", "****") 
    local res = mysql_query(con, "SELECT serial FROM gracze WHERE serial='"..serial.."'" ) 
    if mysql_num_rows(res) >= 1 then 
        mysql_query ( con, "UPDATE gracze SET serial='"..serial.."' nazwa='"..nazwa.."' score="..score.." skin="..skin.." kasa="..kasa.." WHERE serial='"..serial.."'" ) 
    else 
        mysql_query ( con, "INSERT INTO gracze VALUES ('"..serial.."', '"..nazwa.."', "..score..", "..skin..", "..kasa..")" ) 
    end 
  
end 
  
addEventHandler("onPlayerQuit", getRootElement(), saveTo) 

Please help

Link to comment
function saveTo() 
    local serial = getPlayerSerial(source) 
    local score = getPlayerName(source) 
    local nazwa = getPlayerName(source) 
    local skin = getElementModel(source) 
    local kasa = getPlayerMoney(source) 
    con = mysql_connect ( "127.0.0.1", "****", "****", "****") 
    local res = mysql_query(con, "SELECT serial FROM gracze WHERE serial='"..serial.."'" ) 
    if mysql_num_rows(res) >= 1 then 
        mysql_query ( con, "UPDATE gracze SET serial='"..serial.."', nazwa='"..nazwa.."', score="..score..", skin="..skin..", kasa="..kasa.." WHERE serial='"..serial.."'" ) 
    else 
        mysql_query ( con, "INSERT INTO gracze VALUES ('"..serial.."', '"..nazwa.."', "..score..", "..skin..", "..kasa..")" ) 
    end 
  
end 

Link to comment
function saveTo() 
    local serial = getPlayerSerial(source) 
    local score = getPlayerName(source) 
    local nazwa = getPlayerName(source) 
    local skin = getElementModel(source) 
    local kasa = getPlayerMoney(source) 
    con = mysql_connect ( "127.0.0.1", "****", "****", "****") 
    local res = mysql_query(con, "SELECT serial FROM gracze WHERE serial='"..serial.."'" ) 
    if mysql_num_rows(res) >= 1 then 
        mysql_query ( con, "UPDATE gracze SET serial='"..serial.."', nazwa='"..nazwa.."', score="..score..", skin="..skin..", kasa="..kasa.." WHERE serial='"..serial.."'" ) 
    else 
        mysql_query ( con, "INSERT INTO gracze VALUES ('"..serial.."', '"..nazwa.."', "..score..", "..skin..", "..kasa..")" ) 
    end 
  
end 

Dosen't Work ;/

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...