<?
/*
 * (C) 2008 Christopher Olsen <cwolsen@domainatlantic.com>
 *
 * $Id$
 */

include ("include/config.php");

$query = "SELECT file,artist FROM videos_pending ORDER by vid desc";
$result = $db->query($query);

$i = 0;

while ($qData = $result->fetch_assoc()) {
  print $i++ . ",";
  $query = "UPDATE videos SET artist=\"" . $qData['artist'] . "\" WHERE file=\"" . $qData['file'] . ".flv\"";
  $db->query($query);
}
?>