SQL =(

[MasterTobi]

hey

i have to start whit SQL Scripting so;

i searched in this Forum and nothing help´s me. I used the Wiki, the Wiki says, use

function createSQLOnStart ()
-- create our table, if it doesn't already exist
executeSQLCreateTable ( "players", "clothes_head_texture TEXT, clothes_head_model TEXT, player TEXT" )
end
addEventHandler ( "onResourceStart", getResourceRootElement(getThisResource()),createSQLOnStart )

so when i restart my server then creates me a new table -.-

can i don´t save the actual Table ?! with SQL ?! =(

i have sqllitedatabaseBrowser, and i have created a database with DatabaseName(Accounts) and "options" PlayerName and Password

i have to start this databse with the functions from mta, is there any way !?

or have anybody a good tutorial for sql ?!

Thx a lot

Tobi

[eXo|Flobu]

if you use the executeSQL functions it will be saved the data to the intern server database of mta (MTA San Andreas\server\mods\deathmatch\registry.db) automatically.

if you want to use an extern database you need a module like this https://wiki.multitheftauto.com/wiki/Modules/MTA-MySQL.

[MasterTobi]

ah ok thx