SQL Data Error.

[Maurize]

So no errors appearing. But if i browse the database, i can´t find any table named "playerData".

Please help me and tell me what i have done wrong.

Thanks

function CreateTable() 
executeSQLCreateTable( "playerData", "name STRING, x FLOAT, y FLOAT, z FLOAT, s INT" ) 
end 
addEventHandler( "onResourceStart", getResourceRootElement( getThisResource() ), CreateTable ) 
  
function UpdateTable() 
local x, y, z  = getElementPosition( source ) 
local s = getElementModel( source ) 
local playerTable = executeSQLUpdate( "playerData", "name = '" .. getAccountName( getPlayerAccount( source ) ) .. "'", "x = '" .. x .. "'", "y = '" .. y .. "'", "z = '" .. z .. "'", "s = '" .. s .. "'" ) 
end 
addEventHandler( "onPlayerQuit", getRootElement(), UpdateTable ) 
  
function SelectTable() 
local playerTable = executeSQLSelect ( "playerData", "name = '" .. getAccountName( getPlayerAccount( source ) ) .. "'", "x", "y", "z", "s" ) 
setElementPosition( source, playerTable[3], playerTable[4], playerTable[5] ) 
setElementModel( source, playerTable[6] ) 
end 
addEventHandler( "onPlayerLogin", getRootElement(), SelectTable ) 

[JR10]

Both function arguments are wrong.

bool executeSQLUpdate ( string tableName, string set, [ string conditions ] ) 

3 arguments.

executeSQLUpdate should be:

executeSQLUpdate( "playerData", "name = '" .. getAccountName( getPlayerAccount( source ) ) .. "', x = '" .. x .. "', y = '" .. y .. "', z = '" .. z .. "', s = '" .. s .. "'" ) 

Creating the table is correct, make sure you are checking registry.db not internal.db

[Maurize]

Thanks. Hm. So SQL is a very smart database