SQL

[#Paper]

I have some problems:

function onResStart () 
executeSQLCreateTable ( "mspserver.point", "serial TEXT, points INT" ) 
end 
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), onResStart) 
-------------------------------- 
function onJoin () 
local serial = getPlayerSerial(source) 
local getPoints = executeSQLSelect("mspserver.point", "points", "serial='"..serial.."'") 
if getPoints == false then 
executeSQLInsert ( "mspserver.point", "'"..serial.."', '0'" ) 
setElementData(source, "Points", 0) 
else 
setElementData(source, "Points", tonumber(getPoints[1]["point"])) 
end 
end 
addEventHandler("onPlayerJoin", getRootElement(), onJoin) 
---------------------------------------- 
function onPlayerQuit() 
local getActualPoints = getElementData(source, "Points") 
local serial = getPlayerSerial(source) 
executeSQLUpdate ( "mspserver.point", "points = '"..tonumber(getActualPoints).."'","serial = '" ..serial.. "'" ) 
end 
addEventHandler("onPlayerQuit", getRootElement(), onPlayerQuit) 

onJoin and onQuit says: "No such table: mspserver.point"... why?

[Aibo]

probably because there's a dot (.) in your table name. which is used in SQL for «parent.child» reference like databaseName.tableName

and since you don't have «mspserver» database, you cant create a table there.

try removing the dot.

[#Paper]

probably because there's a dot (.) in your table name. which is used in SQL for «parent.child» reference like databaseName.tableName

and since you don't have «mspserver» database, you cant create a table there.

try removing the dot.

mhh, maybe i will use a MySQL module...

[Aibo]

how exactly MySQL will help you in ignoring SQL syntax?

[#Paper]

how exactly MySQL will help you in ignoring SQL syntax?

nono, SQL is better than MySQL

btw, can you fix my script?

[Aibo]

have you tried to remove the dot?

[#Paper]

have you tried to remove the dot?

ye

[Aibo]

ye what? ye where? what's the code? does it work? if not — what is the error?

[#Paper]

ye what? ye where? what's the code? does it work? if not — what is the error?

sry,

ye, it don't works D:

[DakiLLa]

sry,

ye, it don't works D:

if not — what is the error?

[#Paper]

sry,

ye, it don't works D:

if not — what is the error?

okok i solved