resRoot = getResourceRootElement(getThisResource())
function createSQLTable( )
executeSQLCreateTable( "table", "username BLOB, password BLOB, lastname TEXT, firstname TEXT, wallet REAL, bank REAL, faction BLOB, admin INTEGER, phours INTEGER, skin INTEGER, pos_x INTEGER, pos_y INTEGER, pos_z INTEGER"..string1..", "..string2..", "..string3 )
end
function Connect( )
username = { }
username[source] = { }
fadeCamera( source, true )
username[source].log = 0
setCameraPosition( source, -2642.8926, 1927.8561, 224.3582 )
setCameraLookAt( source, 1481.1476, -1750.8605, 15.4453 )
setCameraMode( source, "fixed" )
local name = getClientName( source )
local firstname = gettok( name, 1, string.byte( "_" ) )
local lastname = gettok( name, 2, string.byte( "_" ) )
local check = executeSQLQuery( "SELECT lastname, firstname FROM table WHERE lastname = '"..lastname.."'" )
if( not check == false ) then
triggerClientEvent( source, "2login", getRootElement() )
username[source].lastname = lastname
username[source].firstname = firstname
else
username[source].firstname = firstname
username[source].lastname = lastname
triggerClientEvent( source, "2register", getRootElement(), firstname.."_"..lastname )
end
end
addEventHandler( "onResourceStart", resRoot, createSQLTable )
It is returning the error:
ERROR: Database query failed: near "table": syntax error (SELECT lastname, firstname FROM table WHERE lastname == 'Tokudaiji' )