[Link14716]

Originally posted by futureal


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.

Unfortunetly, you hit me a little late and I already made my fingers go numb manually copying and pasting the usernames into all 125 rows.

And the Beta 2, when can we expect it? *starts chanting "MINILEADERBORD!"