You know the User System script in resources? Doesn't it use that?...
From UserSystem:
function onJoin()
if( not connect_mysql ) then
outputChatBox( no_connect_sql_message )
else
local colour = mysql_query( connect_mysql, "SELECT * FROM `players` WHERE serial='" .. getPlayerSerial( source ) .. "'" )
if( colour ) then
while true do
local row = mysql_fetch_assoc( colour )
if ( not row ) then
if( not TAGS[source] ) then
nameJoined = getPlayerName( source )
setPlayerNametagColor ( source, 255, 255, 0 )
createBlipAttachedTo( source, 0, 2, 255, 255, 0)
end
break end
nameJoined = getPlayerName( source )
name = row['login']
money = row['money']
local class = row['class']
TAGS[source] = class
bindKey(source, 'F4', 'down', openPanelForUsers)
bindKey( source, 'm', 'down', secure )
-- [[ Admin ]] --
if( TAGS[source] == "4" ) then
setPlayerNametagColor ( source, 255, 0, 0 )
createBlipAttachedTo( source, 0, 2, 255, 0, 0)
setPlayerMoney( source, money )
if( setUpdateMessage == "1" ) then
outputChatBox("#FF0000*USER: #FFFF00"..updateMessage.."", source, 0, 0, 0, true )
end
-- [[ Moderator ]] --
elseif( TAGS[source] == "3" ) then
setPlayerNametagColor ( source, 0, 0, 255 )
createBlipAttachedTo( source, 0, 2, 0, 0, 255)
setPlayerMoney( source, money )
if( setUpdateMessage == "1" ) then
outputChatBox("#FF0000*USER: #FFFF00"..updateMessage.."", source, 0, 0, 0, true )
end
-- [[ Member ]] --
elseif( TAGS[source] == "2" ) then
setPlayerNametagColor ( source, 0, 255, 0 )
createBlipAttachedTo( source, 0, 2, 0, 255, 0)
setPlayerMoney( source, money )
if( setUpdateMessage == "1" ) then
outputChatBox("#FF0000*USER: #FFFF00"..updateMessage.."", source, 0, 0, 0, true )
end
end
end
end
mysql_free_result( colour )
end
end
And further down into the script i believe it uses the "class" field once again...