Lua Record.lua

[Nevermore]

I get this error when someone logs into the server.

function onRecord(current, old, cid)
	db.executeQuery("INSERT INTO `server_record` (`record`, `world_id`, `timestamp`) VALUES (" .. current .. ", " .. getConfigValue('worldId') .. ", " .. os.time() .. ");")
	addEvent(doBroadcastMessage, 150, "New record: " .. current .. " players are logged in.", MESSAGE_STATUS_DEFAULT)
end

[Error - GlobalEvent Interface]
data/globalevents/scripts/record.lua:onRecord
Description:
data/globalevents/scripts/record.lua:2: attempt to call field 'executeQuery' (a
nil value)
stack traceback:
        data/globalevents/scripts/record.lua:2: in function <data/globalevents/s
cripts/record.lua:1>

 

[Diath]

Replace executeQuery with query. Also, next time use search function.

 

[Alyhide]

Yeye, search ftw.

 

[Nevermore]

>> Checking world type... PvP>> Initializing game state modules and registering services...
mysql_real_query(): SELECT `id`, `ownerid`, `creationdata`, `checkdata` FROM `gu
ilds` WHERE `world_id` = 0; - MYSQL ERROR: Unknown column 'checkdata' in 'field
list' (1054)

 

[Nevermore]

Deleted