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;