Staff System

[FinchDon]

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 )

[KAKAN]

Write it in a notepad or make a command like

Code Select Expand

else if ( cmd =="adminlist")
{
EchoMessage("Level 2:");
EchoMessage("Players");
}It would be easier than ...

[FinchDon]

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

[KAKAN]

What do u think, that will give the level of the online players, I'll soon try to make a query for it

[Debian]

 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

[KAKAN]

I never heard about GetSQLnextRow, any examples would be really useful..

[FinchDon]

Example?

[Debian]

http://liberty-unleashed.co.uk/VCWiki/Scripting/Squirrel/Functions/SQLite/GetSQLNextRow

[MacTavish]

Haha this system is already made by me month ago i would share it when i got time

[KAKAN]

Thanks, I too need it!

[FinchDon]

Thanks @Kusanagi

[MacTavish]

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

[KAKAN]

Oh! Nice way tho