mysql-result I Need help for mysql result

[Asokanta]

addEventHandler("onPlayerLogin", root,
  function()
    outputChatBox(getPlayerName(source).." Giriş yapti.", root) 
local oyuncu = getPlayerName(source)
local ip = getPlayerIP(source)
local serial = getPlayerSerial(source)
local account = getPlayerAccount(source)
local username = getAccountName(account)
	local qh = dbQuery( usedata_db, "SELECT * FROM masterdata WHERE username =?",username )
	local result = dbPoll( qh, -1 )
if result == nil then
	local sorgu = dbQuery( userdata_db, "INSERT INTO `masterdata`(`username`, `serial`, `ip` ,`puan` , `name`) VALUES (?,?,?,'',?)",username,serial,ip,oyuncu)
	dbFree( sorgu )
	else
	outputChatBox("#afafaf[#f9a52fSA:MP#afafaf] #f9a52fVeritabanina bir veri eklenmedi.",getRootElement(), 255, 255, 255, true )
	end
	end)

 

in here,i'm saying this : if this username don't exist in database insert data else do nothing.

But when i try the script it gives nothing everytime like exist or don't exist usernames

help pls.

[Simple.]

try this

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

 

[Asokanta]

Dude,i think you saved my life.

I will try this code when i go online.

[Asokanta]

I tested the script but there is a problem: When i login its adding data to database all the time

its bypassing the code and just insert data allways...

[undefined]

I don't use social media. You can contact me only here with private message.

[Asokanta]

Yes,because i can't solve this problem

6 hours ago, Asokanta said:

addEventHandler("onPlayerLogin", root,
  function()
    outputChatBox(getPlayerName(source).." Giriş yapti.", root) 
local oyuncu = getPlayerName(source)
local ip = getPlayerIP(source)
local serial = getPlayerSerial(source)
local account = getPlayerAccount(source)
local username = getAccountName(account)
	local qh = dbQuery( usedata_db, "SELECT * FROM masterdata WHERE username =?",username )
	local result = dbPoll( qh, -1 )
if result == nil then
	local sorgu = dbQuery( userdata_db, "INSERT INTO `masterdata`(`username`, `serial`, `ip` ,`puan` , `name`) VALUES (?,?,?,'',?)",username,serial,ip,oyuncu)
	dbFree( sorgu )
	else
	outputChatBox("#afafaf[#f9a52fSA:MP#afafaf] #f9a52fVeritabanina bir veri eklenmedi.",getRootElement(), 255, 255, 255, true )
	end
	end)

 

in here,i'm saying this : if this username don't exist in database insert data else do nothing.

But when i try the script it gives nothing everytime like exist or don't exist usernames

help pls.

Can anybody help me to solve this problem ?

[Simple.]

	local sorgu = dbQuery( userdata_db, "INSERT INTO `masterdata`(`username`, `serial`, `ip` ,`puan` , `name`) VALUES (?,?,?,'',?)",username,serial,ip,oyuncu)

 what is `puan` for ?

[Asokanta]

It means point but point need to be empty

Edited May 3, 2017 by Asokanta

[Simple.]

ok try this

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( usedata_db, "SELECT * FROM masterdata WHERE username = ?", username ), -1 )
    if type(result) == "table" and #result ~= 0 and result[1]["username"] == username 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)

 

Edited May 3, 2017 by 'SimpleArtS . .

[Asokanta]

when i try command it inserting all the time

 

Console log : mysql/serverside.lua:22: Bad argument @ 'dbPoll' [Expected dbquery at argument 1, got boolean] (in your code 22 is 8   )

 

Edited May 4, 2017 by Asokanta

[Simple.]

make sure the db variable 'usedata' isn't local in some function

 

[Asokanta]

Nobody can't help ?

Edited May 4, 2017 by Asokanta

[keymetaphore]

 dbPoll( dbQuery( usedata_db

it's usedata_db here

	dbQuery( userdata_db, "INS

and userdata_db here

do you have 2 variables or you typed it incorrectly?

@Asokanta

[Asokanta]

I created new topic for more details look here