SQL مساعده في

[KillerX]

السلام عليكم 

SQL انا مسوي قاعده بيانات 

لما يدخل الاعب يسجل كل بيناتوا في القاعده تمام ؟

بس بيطلعلي خطا في ديبوق

الاكواد

executeSQLQuery('CREATE TABLE IF NOT EXISTS Programed (PlayerSerial,PlayerAccount)')

addEventHandler('onPlayerLogin',root,
function(_,Account)
local CheckData = executeSQLQuery('SELECT * FROM Programed WHERE PlayerSerial = ?',getPlayerSerial(source))
if (type(CheckData) == 'table' and #CheckData == 0 or not CheckData) then
executeSQLQuery('INSERT INTO Programed (PlayerSerial,PlayerAccount) VALUES(?,?)',getPlayerSerial(source),getPlayerAccount(source))
outputChatBox('Saved',source,0,255,0,true)
else
executeSQLQuery('UPDATE Programed SET PlayerSerial = ?,PlayerAccount = ?',getPlayerSerial(source),getPlayerAccount(source))
outputChatBox('Updated',source,0,255,0,true)
end

 

[Trefeor]

executeSQLQuery('CREATE TABLE IF NOT EXISTS Programed (PlayerSerial,PlayerAccount)')

addEventHandler('onPlayerLogin',root,
function(_,Account)
local CheckData = executeSQLQuery('SELECT * FROM Programed WHERE PlayerSerial = ?',getPlayerSerial(source))
if (type(CheckData) == 'table' and #CheckData == 0 or not CheckData) then
executeSQLQuery('INSERT INTO Programed (PlayerSerial,PlayerAccount) VALUES(?,?)',getPlayerSerial(source),getAccountName(Account))
outputChatBox('Saved',source,0,255,0,true)
else
executeSQLQuery('UPDATE Programed SET PlayerSerial = ?,PlayerAccount = ?',getPlayerSerial(source),getAccountName(Account))
outputChatBox('Updated',source,0,255,0,true)
end
end 
)

اذا بتخزن الحساب خزن اسم الحساب وليس الحساب نفسه بوظيفة getAccountName + getPlayerAccount

بالحدث حق onPlayerLogin 

فيه بارمتر الحساب الي سجل دخوله مالها داعي تستخدم getPlayerAccount لان فيه برامتر يفي بالغرض

Edited August 13, 2018 by Trefeor

[KillerX]

On ١٣‏/٨‏/٢٠١٨ at 12:22, Trefeor said:

executeSQLQuery('CREATE TABLE IF NOT EXISTS Programed (PlayerSerial,PlayerAccount)')

addEventHandler('onPlayerLogin',root,
function(_,Account)
local CheckData = executeSQLQuery('SELECT * FROM Programed WHERE PlayerSerial = ?',getPlayerSerial(source))
if (type(CheckData) == 'table' and #CheckData == 0 or not CheckData) then
executeSQLQuery('INSERT INTO Programed (PlayerSerial,PlayerAccount) VALUES(?,?)',getPlayerSerial(source),getAccountName(Account))
outputChatBox('Saved',source,0,255,0,true)
else
executeSQLQuery('UPDATE Programed SET PlayerSerial = ?,PlayerAccount = ?',getPlayerSerial(source),getAccountName(Account))
outputChatBox('Updated',source,0,255,0,true)
end
end 
)

اذا بتخزن الحساب خزن اسم الحساب وليس الحساب نفسه بوظيفة getAccountName + getPlayerAccount

وبالاحدث حق onPlayerLogin 

فيه بارمتر الحساب الي سجل دخوله مالها داعي تستخدم getPlayerAccount لان فيه برامتر يفي بالغرض

تسلم يدك يا بطل

[Trefeor]

حياك الله .