Lua Rewrite SQL injections from 0.3.6 too 3777, and serverconsol freezing without error.

[Kolie]

So, ive recently updated to rev 3777 from 0.3.6, but as you might know, there are some scripting problems involved in this change.

In 0.3.6 you can write

return db.setQuery

Whats the correct line in 3777?

2nd problem:
My server consol keeps freezing, whitout leaving any errors. This dosnt allow the auto-restarter to kick in either, and its really annoying. (rev 3777)
Sometimes I get the error out of memory, reason?

Thanks for respond,

Kolie

 

[Cykotitan]

there's no db.setQuery, only Result:setQuery so call it on a result object

 

[Kolie]

Well all my scripts are built that way (db.setQuery)

Another example, start.lua

function onStartup()
	db.setQuery("UPDATE `players` SET `online` = 0 WHERE `world_id` = " .. getConfigValue('worldId') .. ";")
	return true
end

How would you rewrite that for example? Like this?

function onStartup()
	Result:setQuery("UPDATE `players` SET `online` = 0 WHERE `world_id` = " .. getConfigValue('worldId') .. ";")
	return true
end

Also, any idea why the server is running out of memory all of a sudden? Script issue/host issue?

Thanks for reply!