db* functions

[dudeks]

Hello.

After 1.5 update I was change mysql functions from module to inbuilt functions and have one problem.

dbQuery function works only once and returns a data after start the script. Later? Returns nil and nope, nope, nope.

I've writen function queryUpdate to auto-update row in table.

After use of this, my function query isn't working.

dbQuery(mysql, 'UPDATE `accounts` SET `playerHumanity`=?, `gamePoints`=?, `lastLogin`=?, `premiumPoints`=?, `playerPosition`=?,`playerBlood`=?, `lastIP`=?,`playerGroupID`=?, `playerName`=?, `playerItems`=?, `playerThirsty`=?, `playerPain`=?, `playerHungry`=?, `playerLegs`=?, `playerTemperature`=?, `lastQuitType`=?, `playerModel`=?, `playerEnergy`=?, `playerHands`=?, `playerBleeding`=? WHERE `characterID`=11', "0", "0", "CURRENT_DATE", "0", "93.08;-219.28;1.85;0;0", "12000", "86.63.94.152", "0", "dudeks", "|||BANDAGE,1;BANDAGE,1;PAINKILLER,1||", "100", "0", "100", "0", "36.599998474121", "Quit", "73", "100", "0", "0") 

Is it too long? Any solutions?

Edited July 19, 2015 by Guest

[GTX]

How about if you show us function query? And you can use parameters that are defined with ?.

Example:

local qh = dbQuery( connection, "INSERT INTO table_name VALUES (?,?,?)", "aaa", "bbb", 10 ) 
dbFree( qh ) 

[dudeks]

I've just updated my first post.

Function query didn't work after queryUpdate that I post in 1st post.

query function is:

function query(query, ret) 
    local query = dbQuery(mysql, query) 
    local result, rows, id = dbPoll(query, -1) 
    if result then 
        if ret then 
            return true, result, rows 
        else 
            return true, false, rows 
        end 
    else 
        outputServerLog("MYSQL ERROR: "..rows.." | "..id) 
        dbFree(query) 
        return false, false, false 
    end 
    return false, false, false 
end 

And you can use parameters that are defined with ?.

In query function i've not using this, I wrote my gamemode sometime ago and can't use it now.