MySQL script

[RastaMan]

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

[BriGhtx3]

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 

[RastaMan]

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 ;/

[BriGhtx3]

Errors?

[RastaMan]

In debug is 0 errors, but don't save data.

[BriGhtx3]

Are you sure, that your connecting data is right?

[RastaMan]

Yes, I checked the login and password are correct. Mysql settings too.

[novo]

Are you sure that you have the module "ml_mysql.dll" installed on your server ?

The MYSQL scripts, needs that module to work. Check that.

Wiki of MYSQL; https://wiki.multitheftauto.com/wiki/Modules/MTA-MySQL

[RastaMan]

Yes, i have installed this module, but this script don't work.