*/
+foreach (array("HTTP_HOST", "DOCUMENT_ROOT") as $i) {
+ if (isset($_SERVER[$i])) {
+ $$i = $_SERVER[$i];
+ }
+ }
+
+foreach (array("pazz") as $i) {
+ if (isset($_POST[$i])) {
+ $$i = $_POST[$i];
+ }
+ }
+
+foreach (array("from", "to") as $i) {
+ if (isset($_GET[$i])) {
+ $$i = $_GET[$i];
+ }
+ }
+
$G_base = "../";
// SYNC WITH bin5_tournaments table
$trn_obj = pg_fetch_object($trn_pg, $t);
$tmt_sql = sprintf("
-SELECT m.code AS code, m.mazzo_next as minus_one_is_old
- FROM %sbin5_matches AS m, %sbin5_games AS g, %sbin5_tournaments as t
- WHERE t.code = m.tcode AND m.code = g.mcode
- AND t.code = %d AND g.tstamp >= '%s' AND g.tstamp < '%s'
- GROUP BY m.code, minus_one_is_old
+SELECT m.code AS code, m.ttype AS ttype, m.mazzo_next AS minus_one_is_old
+ FROM %sbin5_matches AS m, %sbin5_games AS g, %sbin5_tournaments AS t
+ WHERE t.code = m.tcode AND m.code = g.mcode
+ AND t.code = %d AND g.tstamp >= '%s' AND g.tstamp < '%s'
+ GROUP BY m.code, minus_one_is_old
ORDER BY m.code, minus_one_is_old DESC;",
$G_dbpfx, $G_dbpfx, $G_dbpfx, $trn_obj->code, $from, $to);
for ($u = 0 ; $u < count($users) ; $u++) {
// log_crit("stat-day: LOOP u");
if ($u == 0) {
- fprintf($fpexp, "<h3>Codice: %d (%s - %s), Tavolo: %s</h3>\n", $tmt_obj->code, $users[$u]['first'], $users[$u]['last'], $users[$u]['tidx']);
+ fprintf($fpexp, "<h3>Codice: %d (%s - %s), Tavolo: %s%s</h3>\n",
+ $tmt_obj->code, $users[$u]['first'], $users[$u]['last'], $users[$u]['tidx'],
+ ($tmt_obj->ttype > 2 ? " (tavolo per apprendisti)" : ""));
fprintf($fpexp, "<table align='center' class='placing'><tr>\n");
}
fprintf($fpexp, "<th>%s</th>", $users[$u]['login']);
if ($tmt_obj->minus_one_is_old != -1) {
$rules_name = rules_id2name($trn_obj->code);
fprintf($fpexp, "<td>%s</td><td>%s</td>", $users[$gam_obj->mazzo]['login'],
- xcape( ${rules_name}::game_description($gam_obj->act, 'plain', $gam_obj->mult,
+ xcape( $rules_name::game_description($gam_obj->act, 'plain', $gam_obj->mult,
$gam_obj->asta_win,
($gam_obj->asta_win != -1 ?
$users[$gam_obj->asta_win]['login'] : ""),