mysql [MySQL RESULT]I NEED HELP ABOUT MySQL RESULT FUNCTION

[Asokanta]

when i try this code it's never insert datas into database pls help me...

 

)
-- root = getElementRoot()
addEventHandler("onPlayerLogin", root,
function(_, account)
    outputChatBox(getPlayerName(source).." Giriş yapti.", root) 
    local oyuncu = getPlayerName(source)
    local ip = getPlayerIP(source)
    local serial = getPlayerSerial(source)
    local username = getAccountName(account)
    local result = dbPoll( dbQuery( userdata_db, "SELECT * FROM masterdata WHERE username = ?", username ), -1 )
    if type(result) ~= 0 then
        outputChatBox("#afafaf[#f9a52fSA:MP#afafaf] #f9a52fVeritabanina bir veri eklenmedi.",root, 255, 255, 255, true )
    else
		dbQuery( userdata_db, "INSERT INTO masterdata VALUES (?,?,?,?,?)",username,serial,ip, '',oyuncu)
    end
end)

Console Log : 

Username = Asokanta

WARNING: mysql/serverside.lua:22: Bad argument @ 'dbQuery' [Expected
db-connection at argument 1, got nil]
WARNING: mysql/serverside.lua:22: Bad argument @ 'dbPoll' [Expected dbquery at argument 1, got boolean]

Username = deneme

WARNING: mysql/serverside.lua:22: Bad argument @ 'dbQuery' [Expected
db-connection at argument 1, got nil]
WARNING: mysql/serverside.lua:22: Bad argument @ 'dbPoll' [Expected dbquery at argument 1, got boolean]

I Fixed Here* It's giving only login logs but it still don't insert data in database when result isn't 0

New Console Log :

LOGIN: (Everyone, Console) Asokanta successfully logged in as 'Asokanta'

LOGIN: (Everyone) Asokanta successfully logged in as 'deneme'

Database Screenshot : 

Edited May 4, 2017 by Asokanta

[Hale]

WARNING: mysql/serverside.lua:22: Bad argument @ 'dbQuery' [Expected
db-connection at argument 1, got nil]

 

It says that 'userdata_db' isn't a database connection, meaning you failed to connect to the database.

[Asokanta]

I fixed this can u read again ?

[GTX]

Use

dbExec( userdata_db, "INSERT INTO masterdata VALUES (?,?,?,?,?)",username,serial,ip, '',oyuncu)

 

[Asokanta]

Why dbExec ? Can u explain pls

[GTX]

Because dbQuery returns a handle, with which you can get data from a table using dbPoll. It waits until you use it, so if you free it, it would work.

dbExec only executes query, therefore returns nothing.

[Asokanta]

Okay i will try

[Asokanta]

i tried but allways its giving 

        outputChatBox("#afafaf[#f9a52fSA:MP#afafaf] #f9a52fVeritabanina bir veri eklenmedi.",root, 255, 255, 255, true )

The first code

not after this code

[undefined]

Can you post your creating table code?

If you want to view 'result' table, you can use this:

outputConsole(toJSON(result))

 

[GTX]

local result, num_rows_affected = dbPoll(dbQuery(userdata_db,"SELECT * FROM masterdata WHERE username = ?",username),-1)
if num_rows_affected ~= 0 then
    outputChatBox("#afafaf[#f9a52fSA:MP#afafaf] #f9a52fVeritabanina bir veri eklenmedi.",root,255,255,255,true)
else
    dbExec(userdata_db,"INSERT INTO masterdata VALUES (?,?,?,?,?)",username,serial,ip,'',oyuncu)
end

 

[Asokanta]

THX FOR HELP!

Edited May 5, 2017 by Asokanta