<?php

if(!defined("UBB_MAIN_PROGRAM")) exit;

function &page_xfix_gpc () {
	return array(
		"wordlets" => array("fdc"),
		"admin_or_mod" => 1,
	);
}

function &page_xfix_run () {

	global $html,$myinfo,$smarty,$user,$in,$ubbt_lang,$config,$forumvisit,$visit,$dbh,$var_start,$var_eq,$var_sep,$var_extra;

	extract($in, EXTR_OVERWRITE | EXTR_REFS);
	$Number = $user['USER_ID'];

require ('scripts/xfdc.inc.php');

   $query = "
	  SELECT COUNT(*)
	  FROM  f03_FDCcorps
   ";
   $sth = $dbh -> do_query($query);
   list($totalcorps) = $dbh -> fetch_array($sth);
   $dbh -> finish_sth($sth);

   for($i=0;$i<$totalcorps;$i++){

		$query = "
			SELECT t1.C_UNumber, t1.C_CNumber, t2.U_Username, t3.USER_ID
			FROM f03_FDCcorps AS t1, w3t_Users AS t2, ubbt_USERS AS t3
			WHERE t1.C_CNumber = '$i'
			AND t1.C_UNumber = t2.U_Number
			AND t2.U_Username = t3.USER_DISPLAY_NAME
			";
			$sth = $dbh -> do_query($query);
			
			list($oldunumber, $corpsnumber, $username, $newunumber) = $dbh -> fetch_array($sth);
			
			$userrow[$i]['oldunumber']	= $oldunumber;
			$userrow[$i]['corpsnumber']	= $corpsnumber;
			$userrow[$i]['username']	= $username;
			$userrow[$i]['newunumber']	= $newunumber;
			
			$dbh -> finish_sth($sth);
			
			$query = "
				UPDATE f03_FDCcorps
				SET C_UNumber = '{$userrow[$i]['newunumber']}'
				WHERE C_CNumber = '{$userrow[$i]['corpsnumber']}'
				";
				$dbh -> do_query($query);
			}
			
	return array(
		"header" => array (
			"title" => "Fantasy Drum Corps - 20{$fdcyear} Season",
			"breadcrumb" => <<<BREADCRUMB
 <a href="{$config['BASE_URL']}/ubbthreads.php{$var_start}ubb{$var_eq}cfrm">{$ubbt_lang['FORUM_TEXT']}</a>
 &raquo;
 {$ubbt_lang['LOGIN_PROMPT']}
BREADCRUMB			,

		),
		"template" => "xshowseason",
		"data" => & $smarty_data,
		"footer" => true,
	);

}

?>