Код: Выделить всё
local spawnX, spawnY, spawnZ = -711, 957, 13
P_CONNECTION = dbConnect( 'sqlite', 'users.db' )
function Login( sLogin, sPassword )
local pQuery = dbQuery( P_CONNECTION, "SELECT * FROM `users` WHERE `login` = '" .. sLogin .. "'" )
local aQuery = dbPoll( pQuery, - 1 )
if type( aQuery ) == 'table' and #aQuery > 0 then
--Аккаунт найден
if sPassword == aQuery[ 1 ][ 'password' ] then
spawnPlayer(client, spawnX, spawnY, spawnZ)
fadeCamera(client, true)
setCameraTarget(client, client)
outputChatBox("Добро пожаловать на мой сервер.", client)
end
else
outputChatBox("Неправильный логин или пароль!")
end
end
function Register( LoginR, PasswordR, )
local pExec = dbExec( P_CONNECTION, "INSERT INTO `users` VALUES(login, password)", "WHERE `login` = '" .. LoginR .. "', WHERE `password` = '" .. PasswordR .. "'" )
local aQuery = dbPoll(pQuery, - 1)
if type(aQuery) == 'table' and #aQuery > 0 then
outputChatBox("Аккаунт уже зарегистрирован!")
if type(aQuery) == 'table' and #aQuery < 1 then
dbExec(P_CONNECTION, "") --Еще не дописал
end
end
function ifUserDead()
spawnPlayer(source, spawnX, spawnY, spawnZ)
fadeCamera(source, true)
setCameraTarget(source, source)
end
function playerDied(totalAmmo, killer, killerWeapon, bodypart)
outputChatBox(getPlayerName(source).." Умер!")
end
addEvent("submitLogin",true)
addEventHandler("submitLogin", root, Login)
addEvent("submitLoginR",true)
addEventHandler("submitLoginR", root, Register)
addEventHandler("onPlayerWasted", getRootElement(), ifUserDead)
addEventHandler("onPlayerWasted", getRootElement(), playerDied)