Is there anyway for LUA to access and utilize the SQL Database?

[controlsx2]

I was looking through the list of ArcEmu LUA commands and i came accross

[edit]  sql scripting

 GetColumn  

 NextRow  

 GetColumnCount  

 GetRowCount  

 GetByte  

 GetUByte  

 GetShort  

 GetUShort  

 GetLong  

 GetULong  

 GetString
 
 SqlGetString 
 
 GetGUID  

 GetFloat  

 GetBool

So i was wondering. Is it possible for a LUA script to access the Database. So i could make a script edit parts of a the database?

[adrion]

when you script a npc you need to specify the npc spawn ID the spells IDs.Theoreticaly you are looking on wowhead for these cods but there are actualy in your Databse.So when you do a lua script you actualy take informations from your databse.This i think is the conection beetween LUA and your Databse.

[Breakdawn]

when you script a npc you need to specify the npc spawn ID the spells IDs.Theoreticaly you are looking on wowhead for these cods but there are actualy in your Databse.So when you do a lua script you actualy take informations from your databse.This i think is the conection beetween LUA and your Databse.

That's not what he ment - And yes there is a way to do that, Just depends on how epic you are at LUA scripting

[controlsx2]

That's not what he ment - And yes there is a way to do that, Just depends on how epic you are at LUA scripting

Any hints? xD

[Dynashock]

Use WorldDBQuery, CharDBQuery, WorldDBQueryTable or CharDBQueryTable.
The first two return a queryresult object which you can use the methods on you listed in the first post. Thus for instance:

local qResult = WorldDBQuery("SELECT `name` FROM `items` WHERE `quality` = 2") -- performs query and returns it as a QueryResult object
while (qResult:NextRow()) do -- fetches next row, return true on success, false otherwise (false will break the while loop)
     local field = qResult:GetColumn(0) -- gets the first column of the row and returns it as a field object
     print(field:GetString()) -- fetches the string from the field object and prints it, thus it prints the name of the item
end

WorldDBQueryTable and CharDBQueryTable both return a table instead. You can play around with indices of the table to get the values you want.