function initTourGoldsXNineChars_20110309($TournamentID)
{
$maps = getMapsGoldsXNineChars_20110309();
$sql = "SELECT ToGolds,ToXNine FROM Tournament WHERE ToId={$TournamentID} ";
$r = safe_r_sql($sql);
if ($r && safe_num_rows($r) == 1) {
$row = safe_fetch($r);
$gold = $maps['G'][$row->ToGolds];
$xnine = $maps['X'][$row->ToXNine];
$sql = "UPDATE Tournament SET ToGoldsChars='{$gold}',ToXNineChars='{$xnine}' WHERE ToId={$TournamentID} ";
$r = safe_w_sql($sql);
}
}
safe_w_SQL($MySql, false, array(1060));
// metto a posto il campo per le gare presenti e le rank
$q = "SELECT ToId FROM Tournament ";
$r = safe_r_sql($q);
while ($row = safe_fetch($r)) {
calcMaxTeamPerson_20110216($row->ToId);
recalculateTeamRanking_20110216($row->ToId);
}
db_save_version('2011-02-16 15:42:00');
}
if ($version < '2011-03-09 14:38:00') {
$MySql = "ALTER TABLE `TournamentType` ADD `TtGoldsChars` VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER `TtXNine` ,\n\t\tADD `TtXNineChars` VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER `TtGoldsChars` ;\n\t";
safe_w_SQL($MySql, false, array(1060));
$MySql = "ALTER TABLE `Tournament` ADD `ToGoldsChars` VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER `ToXNine` ,\n\t\tADD `ToXNineChars` VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER `ToGoldsChars` ;\n\t";
safe_w_SQL($MySql, false, array(1060));
$maps = getMapsGoldsXNineChars_20110309();
// aggiorno TournamentType
$q = "\n\t\tSELECT\n\t\t\tTtId,TtGolds,TtXNine\n\t\tFROM\n\t\t\tTournamentType\n\t";
//print $q;exit;
$r = safe_r_sql($q);
if (safe_num_rows($r) > 0) {
while ($row = safe_fetch($r)) {
$gold = $maps['G'][$row->TtGolds];
$xnine = $maps['X'][$row->TtXNine];
//print $gold . ' - ' . $xnine . '<br>';
$sql = "UPDATE TournamentType SET TtGoldsChars='{$gold}',TtXNineChars='{$xnine}' WHERE TtId={$row->TtId} ";
//print $sql.'<br><br>';
$rr = safe_w_sql($sql);
}
}
//exit;