How To Put users on expert page[Phoenix]

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:D:
If anyone knows how to remove the expert title please Post a reply because im still unsure

Delete user.

remove it from user_archievements table?

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

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

PHP Code:

---

<?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. :ott1:

Quote:

---

Originally Posted by 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 Code:

---

<?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. :ott1:

---

or you can do number option

PHP Code:

---

<?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

PHP Code:

---

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


---

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

Some of you get bad habits from PheonixPHP...

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

Quote:

---

Originally Posted by Gurvir

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 Code:

---

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

---

Award is NOT for giving people eXpert.

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

I dont even get the point of eXperts..