MYSQL problem

[dugasz1]

local host = "xy" 
local felhnev = "xy" 
local pw = "xy" 
local database = "xy" 
local pontForInv = 30 
  
local connect = dbConnect( "mysql", "dbname="..database..";host="..host, felhnev, pw, "share=1" ) 
  
function getZpont ( thePlayer ) 
    local accountData = getPlayerAccount(thePlayer) 
    local accName = getAccountName (accountData)     
    if accName == "guest" then 
        triggerClientEvent(thePlayer, "zPontRefresh", getRootElement(), 0) 
    else 
        local query = dbPoll(dbQuery(connect, "SELECT * FROM zshop WHERE accNev='"..accName.."' ;" ),-1) 
        if not(query) then 
            outputDebugString("Query hiba!") 
        else 
            for _,v in pairs(query) do 
                zPontja = v['pont'] 
            end 
            if zPontja then 
                triggerClientEvent(thePlayer, "zPontRefresh", getRootElement(), zPontja) 
                zPontja = nil 
            else 
                triggerClientEvent(thePlayer, "zPontRefresh", getRootElement(), 0) 
                zPontja = nil 
            end 
        end 
    end 
end 

http://img15.imageshack.us/img15/6892/m4um.png

(This is a DayZ server)

I never seen error liek this yet Any idea?

[xXMADEXx]

Try this:

local query = dbPoll(dbQuery(connect, "SELECT * FROM zshop WHERE accNev='?", accName ), -1 ) 

[dugasz1]

Now the same error jist ..not use near 'zix" now write the player's name : ...not use near XY

[csiguusz]

local query = dbPoll(dbQuery(connect, "SELECT * FROM zshop WHERE accNev=? ", accName ), -1 ) 

[John_Scott]

    local query = dbPoll(dbQuery(connect, "INSERT INTO `test`.`meghivottak` (`id`, `serial`, `meghivo`) VALUES (NULL, '"..playerSerial.."', '"..meghivoNeve.."');"),-1) -- Vislzát 

http://kepfeltoltes.hu/130806/mta-scree ... es.hu_.png

Edited August 6, 2013 by Guest

[dugasz1]

It's working thank you !

Köszi:D

[csiguusz]

You are welcome.

Nm.