addEventHandler ( 'onResourceStart', root,
function ( )
executeSQLQuery("CREATE TABLE IF NOT EXISTS _Name( Name, serial )")
end
)
addEventHandler ( "onPlayerQuit", root,
function ( )
local Info = executeSQLQuery ( 'SELECT * FROM _Name WHERE serial=?' , getPlayerSerial ( source ) )
if Info and type(Info) == 'table' and #Info ~= 0 then
executeSQLQuery ( "UPDATE _Name SET Name = ? WHERE serial=?", getPlayerName ( source ), getPlayerSerial( source ) )
else
executeSQLQuery( "INSERT INTO _Name ( Name, serial ) VALUES( ?, ? )", getPlayerName ( source ), getPlayerSerial ( source ) )
end
end
)
addEventHandler("onPlayerJoin", root,
function ( )
if isChanged ( source ) then
outputChatBox ( "#00EE00"..getPlayerName(source):gsub("#%x%x%x%x%x%x","").."#FF0000 x بالخروج من السرفر وتغير اسمه إلي #aaaaaa"..isC:gsub("#%x%x%x%x%x%x","").."#FF0000 x لقد قام الاعب",root, 255, 0, 0, true )
end
end
)
function isChanged(player)
isC = false
local Info = executeSQLQuery ( 'SELECT * FROM _Name WHERE serial=?' ,getPlayerSerial ( player ))
if Info and type(Info) == 'table' and #Info ~= 0 then
for i,v in ipairs (Info) do
if v.Name ~= getPlayerName(player) then
isC = v.Name
break
end
end
end
return isC
end