[futureal]

Originally posted by Link14716
Ok, I am trying to make an Update Arcade thing in admin/misc.php, but I am not exactly sure how to. It is based off of the Update Forums part........ Can someone make one where it updates the Username in the arcade table based on userids?

You would have to do something like this (this is off the top of my head so it probably needs work):

PHP Code:

$data_q = $DB_site->query("SELECT scoreid,userid FROM arcade");

while ($loop = $DB_site->fetch_array($data_q)) {

  // this gets a userid's username from the user table
  $user_q = $DB_site->query_first("SELECT username FROM user WHERE userid='$loop[userid]'");

  // this updates the score we're looking at with said username
  $DB_site->query("UPDATE arcade SET username='$user_q[username]' WHERE scoreid='$loop[scoreid]'");

} 


That obviously is going to generate 2 queries for each entry in your arcade table. However, since you only need to run it once, it should be acceptable.