[Guide] How To Put users on expert page[Phoenix]

[Splatter]

This is a noob tutorial
Yes you may call me a noob for Giving the tut but i see many hotels that have no users on the experts page

All you do is..
See the command :award?
:Award 32

And automatically that will put this user on the experts page
Thanks for reading
If anyone knows how to remove the expert title please Post a reply because im still unsure

[LickUrDig]

Delete user.

[azaidi]

remove it from user_archievements table?

[Maelfic]

Sorry, But I "l0l0l3d" at this tut. Waste of space, who doesn't know how to give eXperts the achievment eXpert?

[Gurvir]

Or, you can create another rank in the phpmyadmin, and set the permissions for it, and put this code on the expert page

 <?php
                $staffq = mysql_query("SELECT * FROM users WHERE rank = '9' ORDER BY id ASC");
            while($staff = mysql_fetch_array($staffq))
            {
                ?>  

And then just give people the rank for expert to put them on there, or remove their rank to take them off.

Simples.

[GayPride]

Or, you can create another rank in the phpmyadmin, and set the permissions for it, and put this code on the expert page

 <?php
                $staffq = mysql_query("SELECT * FROM users WHERE rank = '9' ORDER BY id ASC");
            while($staff = mysql_fetch_array($staffq))
            {
                ?>  

And then just give people the rank for expert to put them on there, or remove their rank to take them off.

Simples.

or you can do number option

 <?php
            $staffq = mysql_query("SELECT * FROM users WHERE experts = '1' ORDER BY id ASC");
            while($staff = mysql_fetch_array($staffq))
            {
                ?>  

and to create the column into the database

 ALTER TABLE `users` ADD `experts` enum('0','1') NOT NULL 
  

[Shorty]

You need to delete the badge and achievement from the achievements/badges table. :)

[Quackster]

Some of you get bad habits from PheonixPHP...

[Tha Matrix]

-.-" :award Thing? That wouldn't Work...

[Predict]

Or, you can create another rank in the phpmyadmin, and set the permissions for it, and put this code on the expert page

Or you can use this...

 <?php
$data = mysql_fetch_array(mysql_query("SELECT rank FROM users WHERE rank = '9' ORDER BY id ASC"));
?>  

[Maelfic]

Award is NOT for giving people eXpert.

[tobias142]

Which emulators this for?, Sorry xD
And cheers.. never new this before :)

[MarqDee]

I dont even get the point of eXperts..