[g-force2k2]

Originally posted by michealo
great hack

is it possible to reset someone's gold amounts back to 0?

just run this query ::

PHP Code:

UPDATE user SET gold='0' WHERE userid='[userid here]' 


replace the [userid here] with the userid...

but if ppl want an admin file to edit users gold i can do that

btw about getting the top five richest members i believe the coding is something like this::

PHP Code:

$richest = $DB_site->query("
  SELECT userid, username, gold
  FROM user
  ORDER BY gold DESC LIMIT 5");
     while($rich = $DB_site->fetch_array($richest)) {
       [ data here template etc whatever you may ]
     } 


thats the php code and you just customize it how you want it to be regards...

g-force2k2