Well I am tired to go in Database again and again so i want Can i make admin command which can do like this
adminlist then in account table if player lvl is above from 2 he show in adminlist command
Note( I am using Fuzzie Account System )
Write it in a notepad or make a command like
else if ( cmd =="adminlist")
{
EchoMessage("Level 2:");
EchoMessage("Players");
}It would be easier than ...
lol i can make like that
if ( cmd == "adminlist" )
{
Message( "Owner Finch" );
Message( "CoOwner ZUBI" );
}
Not like that Auto like from queries of Accounts
Like if ( player.Level > 2 ) Message( "admins " + player + " like that
What do u think, that will give the level of the online players, I'll soon try to make a query for it
Create a string which holds players with level higher than 1 so that it will grab all players with level > 1 in one line. Select level from database and run a loop by making it read a next row by using GetSQLNextRow terminate when there are no more rows remaining then create a message to show admin list to the players.
Updated
I never heard about GetSQLnextRow, any examples would be really useful..
Example?
http://liberty-unleashed.co.uk/VCWiki/Scripting/Squirrel/Functions/SQLite/GetSQLNextRow
Haha this system is already made by me month ago i would share it when i got time
Thanks, I too need it!
actually i made a totally separate system for stafflist a table some function and queries that automatic checks and update admin level on player join because i got many problems from checking the level from account table when the table has 500+ accounts registered
Oh! Nice way tho :P