Lua SQL Junction?

[jpkulik]

Hey guys!
Is it possible, to run an SQL script into an lua script?
Like
if player say 'yes',
INSERT INTO DBNAME.COLUM.... etc?
If yes, can some one post ANY example? so i can program bassed on it!
Hope for anwsers! Cya!

 

[Keraxel]

Yes, It's possible

db.executeQuery("DELETE FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. ";")

 

[jpkulik]

Yeah, but can you posn any script for me?
Coz this dont realy help me, need to see the rest to see how it works in lua, coz i know that it is diferent then in php..
Cya and tanks!

 

[Markey]

---- script -----
if msg == "yes" then
     db.executeQuery("Here comes the MySQL Query")
end
---- script -----

 

[Azi]

function onSay(cid, words, param)
 if getPlayerGroupId(cid) >= 5 then
  local query = db.executeQuery(param..";")
   if query == TRUE then
    doPlayerSendTextMessage(cid, 19, "Query has been executed.")
   else
    doPlayerSendTextMessage(cid, 19, "Error in query!")
   end
 else
  doPlayerSendCancel(cid, "You cannot execute this command.")
 end
end

it's my script, for GM can execute mysql query by command in game !sql insert into ... etc. take it for example.

 

[slaw]

not if query == TRUE then, but if query then ;p

and why group checking if its already in talkactions.lua?