• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • New resources must be posted under Resources tab. A discussion thread will be created automatically, you can't open threads manually anymore.

TalkAction Release : SQL queries directly from server.

  • Thread starter Thread starter Rozinx
  • Start date Start date
R

Rozinx

Guest
Small and useful script.

Create a file named dbquery.lua at your data/talkactions/scripts folder.

Code: 
function onSay(cid, words, param)

db.executeQuery(param)

return TRUE
end

Now we're going to declare it in talkactions.xml

Code: 
<talkaction log="yes" access="6" words="/dbquery" script="dbquery.lua"/>

That's my little contribution to otland.
Rep++ if you enjoyed it.
Best regards

Ps : you can use it like this : /dbquery update players set maglevel = 10;
and so on.
 
Last edited by a moderator:
I guess its pretty usefull, But you have to have the syntax of your query correct in order for it to work, which would be alittle touph to do it in that little message window on tibia. But otherwise nice :P
 
Did you test this? Misspell = crash?
 
Yeah , I've been using it for a few weeks.
Never crashed, missspelled loads of times.
 
Back
Top