Lua SQL and LUA

[Shinmaru]

I would like a complete explanation on how to use SQL query on LUA:

	db.query(query)
	db.storeQuery(query)
	db.escapeString(str)
	db.escapeBlob(s, length)
	db.lastInsertId()
	db.stringComparison()
	db.updateLimiter()

How do they work?

How does each part(SELECT, UPDATE, SET, WHERE, etc.) look for something in the the database?

Show an example script, if possible.

Thanks in advance!

PS
If the explanation is good and valid, I will make a Tutorial off of this(With proper credits given to the contributers.)

 

[Cykotitan]

there is no need to explain how tfs executes queries from luascripts on the mysql server, and i'm sure nobody would be interested either

a few examples of db.getResult and db.executeQuery are provided with the core scripts of TFS 0.3.6 and higher

stringComparison, updateLimiter, escapeBlob and storeQuery aren't used often here in lua scripts, nor there's need to use them yet

lastInsertId is useful to get id of account or player if you create them using lua

 

[Shinmaru]

Thanks, but can you at least give me an example script of db.executeQuery and db.getResult?

 

[Doggynub]

execute query , uses update,insert,delete like

db.executeQuery ("UPDATE `players` SET `name` = 'lamino' WHERE `id` = '1' ;")

get Result should return number of rows it mostly uses SELECT

local data = db.getResult("SELECT `name` FROM `players` WHERE `id` = '1'";)
--now you need to fetch this result as this is like a arrray returned, so you need to fetch the name value
local name = data:getDataString("name")--this vary according the result type

 

[Acubens]

Make tutorial for LuaSQL

 

[Doggynub]

Actually there is no need in OTS to do that as these functions just do the work, unless you would use it in a outside Ot thingy

 

[Shinmaru]

Thanks a lot Doggynub for the examples! This helps me understand SQL query on OTs.

 

[Znote]

Can be used if you want to make a chat channel in-game which sync with chat channel on website and vise versa.

But you can use more efficient ways for other TFS database stuff. There are functions to fetch pretty much anything.

 

[Cykotitan]

Thanks a lot Doggynub for the examples! This helps me understand SQL query on OTs.

Subversion
Subversion
for more advanced examples with table scans next())

 

[Shinmaru]

Subversion
Subversion
for more advanced examples with table scans next())

Thanks a lot! But after reading the script I got lost on most of the words in Capital letters(UPDATE, SELECT, AND, ASC, DESC, etc.), could somewhat explain what does it do? and/or how does it work?

 

[Doggynub]

You could have a fast look here it is very helpful and easy ,and doesnt mention unneeded stuff. Go through the basic part that would be good to have background on how it works and will be effective to you SQL Basics

 

[Shinmaru]

You could have a fast look here it is very helpful and easy ,and doesnt mention unneeded stuff. Go through the basic part that would be good to have background on how it works and will be effective to you SQL Basics

Thanks, but now I feel stupid, because I posted a link about all of this and I should have check with that site first! LOL