sql

[Wei]

I'm learning sql and I need some help. Can somebuddy show me an example of save system ?

[Castillo]

Why instead of ask for an example of something specified you don't go to the wiki and try to make it with the examples given?

-- SQLite only:

executeSQLCreateTable 
executeSQLDelete 
executeSQLDropTable 
executeSQLInsert 
executeSQLQuery 
executeSQLSelect 
executeSQLUpdate 

-- MySQL and SQLite:

dbConnect 
dbExec 
dbQuery 
dbPoll 
dbFree 

[Cyandie]

Or

this

https://wiki.multitheftauto.com/wiki/Modules/MTA-MySQL

the functions are below.

[Castillo]

I wouldn't recommed that Montiz, these functions are old, the built-on MySQL functions are easier to use.

[Wei]

what about sql resource ? Is there any wiki for it ?

[Dev]

I wouldn't recommed that Montiz, these functions are old, the built-on MySQL functions are easier to use.

True.

[Castillo]

what about sql resource ? Is there any wiki for it ?

What do you mean?

[Wei]

something like that:

exports.sql:query_insertid( "INSERT INTO doingJob (Player, State,) VALUES (" .. table.concat( { theName, state } ) .. ")" ) 

[Castillo]

That resource was created by the game mode scripter.