X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=web%2Fbriskin5%2Fstat-day.php;h=d21e369b78d5f3ad974d634c9a2610db60d0dc29;hb=2e2d9c36ba2902a4c2171ba0e0f633ed7da8353c;hp=7218905773092cdc12279bcd4d57b5e73a983c62;hpb=5c967dabf5b7bef5b0471e61c9ada4a51d887cb6;p=brisk.git diff --git a/web/briskin5/stat-day.php b/web/briskin5/stat-day.php index 7218905..d21e369 100644 --- a/web/briskin5/stat-day.php +++ b/web/briskin5/stat-day.php @@ -1,9 +1,9 @@ array( 'it' => 'Partite normali', + 'en' => 'Normal matches' ), + 'special match' => array( 'it' => 'Partite speciali', + 'en' => 'Special matches') + ); + + ini_set("max_execution_time", "240"); require_once("../Obj/brisk.phh"); @@ -41,17 +58,17 @@ require_once("Obj/placing.phh"); function main_file($curtime) { - GLOBAL $G_alarm_passwd; + GLOBAL $G_lang, $G_alarm_passwd; $tri = array(); $mon = array(); $wee = array(); - + if (($fp = @fopen(LEGAL_PATH."/points.log", 'r')) == FALSE) { echo "Open data file error"; exit; } echo "prima
"; - + if (($fp_start = @fopen(LEGAL_PATH."/points.start", 'r')) != FALSE) { $skip = intval(fgets($fp_start)); if ($skip > 0) @@ -63,7 +80,7 @@ function main_file($curtime) echo "database connection failed"; exit; } - + $bdb->users_load(); for ($i = 0 ; $i < $bdb->count() ; $i++) { @@ -82,7 +99,7 @@ function main_file($curtime) // if not auth table, continue if (count($ar) < 15) continue; - + // echo $p++."
"; if ($ar[7] >= TABLES_AUTH_N) continue; @@ -98,11 +115,11 @@ function main_file($curtime) fwrite($fp_start, sprintf("%d\n", $curpos)); fclose($fp_start); } - + continue; } // echo $p++." ".BIN5_PLAYERS_N."
"; - + $found = FALSE; $mult = 1; for ($i = 0 ; $i < BIN5_PLAYERS_N ; $i++) { @@ -125,22 +142,22 @@ function main_file($curtime) echo "WARNING: the user [".$username."] NOT EXISTS!
"; continue; } - + // echo $item->login." id)".$id." ".$ar[10+($i*2)]." mult: ".$mult."
"; $tri[$id]->add($ar[10+($i*2)] / $mult); - if ($ar[0] >= $curtime - MON_LIMIT) + if ($ar[0] >= $curtime - MON_LIMIT) $mon[$id]->add($ar[10+($i*2)] / $mult); - if ($ar[0] >= $curtime - WEE_LIMIT) + if ($ar[0] >= $curtime - WEE_LIMIT) $wee[$id]->add($ar[10+($i*2)] / $mult); } // $p++; echo $p++."
"; } fclose($fp); - + usort($tri, ptsgam_cmp); usort($mon, ptsgam_cmp); usort($wee, ptsgam_cmp); - + echo "

TRI
\n"; if (($fplo = @fopen(LEGAL_PATH."/class_tri_lo.log", 'w')) == FALSE) { @@ -156,9 +173,9 @@ function main_file($curtime) if ($tri[$i]->gam == 0.0) continue; printf("%s: %s (%d)
\n", $tri[$i]->username, $tri[$i]->snormpts(), $tri[$i]->gam); - if ($tri[$i]->gam >= TRI_MAX_GAMES) + if ($tri[$i]->gam >= TRI_MAX_GAMES) fwrite($fphi, sprintf("%s|%d|%d|\n", xcapelt($tri[$i]->username), $tri[$i]->pts, $tri[$i]->gam)); - else if ($tri[$i]->gam > TRI_MIN_GAMES) + else if ($tri[$i]->gam > TRI_MIN_GAMES) fwrite($fplo, sprintf("%s|%d|%d|\n", xcapelt($tri[$i]->username), $tri[$i]->pts, $tri[$i]->gam)); } fclose($fphi); @@ -179,9 +196,9 @@ function main_file($curtime) if ($mon[$i]->gam == 0.0) continue; printf("%s: %s (%d)
\n", $mon[$i]->username, $mon[$i]->snormpts(), $mon[$i]->gam); - if ($mon[$i]->gam >= MON_MAX_GAMES) + if ($mon[$i]->gam >= MON_MAX_GAMES) fwrite($fphi, sprintf("%s|%d|%d|\n", xcapelt($mon[$i]->username), $mon[$i]->pts, $mon[$i]->gam)); - else if ($mon[$i]->gam > MON_MIN_GAMES) + else if ($mon[$i]->gam > MON_MIN_GAMES) fwrite($fplo, sprintf("%s|%d|%d|\n", xcapelt($mon[$i]->username), $mon[$i]->pts, $mon[$i]->gam)); } fclose($fphi); @@ -198,12 +215,12 @@ function main_file($curtime) } for ($i = 0 ; $i < count($wee) ; $i++) { - if ($wee[$i]->gam == 0.0) + if ($wee[$i]->gam == 0.0) continue; printf("%s: %s (%d)
\n", $wee[$i]->username, $wee[$i]->snormpts(), $wee[$i]->gam); - if ($wee[$i]->gam >= WEE_MAX_GAMES) + if ($wee[$i]->gam >= WEE_MAX_GAMES) fwrite($fphi, sprintf("%s|%d|%d|\n", xcapelt($wee[$i]->username), $wee[$i]->pts, $wee[$i]->gam)); - else if ($wee[$i]->gam > WEE_MIN_GAMES) + else if ($wee[$i]->gam > WEE_MIN_GAMES) fwrite($fplo, sprintf("%s|%d|%d|\n", xcapelt($wee[$i]->username), $wee[$i]->pts, $wee[$i]->gam)); } fclose($fphi); @@ -213,59 +230,97 @@ function main_file($curtime) function main_pgsql($from, $to) { - GLOBAL $G_dbpfx; + GLOBAL $G_lang, $G_dbpfx, $mlang_stat_day; - if (($fpexp = @fopen(LEGAL_PATH."/explain.log", 'w')) == FALSE) { - echo "Open explain failed
"; - exit; - } - fprintf($fpexp, "

Minuta delle partite dal (%s) al (%s)

", - $from, $to); + $ret = FALSE; + $fpexp = FALSE; - if (($bdb = BriskDB::create()) == FALSE) { - echo "database connection failed"; - exit; - } do { + if (($fpexp = @fopen(LEGAL_PATH."/explain.log", 'w')) == FALSE) { + log_crit("stat-day: open explain failed"); + break; + } + fprintf($fpexp, "

Minuta delle partite dal (%s) al (%s)

", + $from, $to); + + if (($bdb = BriskDB::create()) == FALSE) { + log_crit("stat-day: database connection failed"); + break; + } + if (pg_query($bdb->dbconn->db(), "BEGIN") == FALSE) { - log_crit("statadm: begin failed"); + log_crit("stat-day: begin failed"); break; } - - $tmt_sql = sprintf("select m.code as code from %sbin5_matches as m, %sbin5_games as g WHERE m.code = g.mcode AND g.tstamp >= '%s' AND g.tstamp < '%s' GROUP BY m.code;", $G_dbpfx, $G_dbpfx, $from, $to); - // if deletable old matches exists then ... - if (($tmt_pg = pg_query($bdb->dbconn->db(), $tmt_sql)) != FALSE) { + // retrieve list of active tournaments + $trn_sql = sprintf("SELECT * FROM %sbin5_tournaments WHERE active = 1;", $G_dbpfx); + if (($trn_pg = pg_query($bdb->dbconn->db(), $trn_sql)) == FALSE) { + log_crit("stat-day: select from tournaments failed"); + break; + } + + $trn_n = pg_numrows($trn_pg); + + for ($t = 0 ; $t < $trn_n ; $t++) { + $trn_obj = pg_fetch_object($trn_pg, $t); + + $tmt_sql = sprintf("SELECT m.code AS code FROM %sbin5_matches AS m, %sbin5_games AS g, %sbin5_tournaments as t WHERE t.code = m.tcode AND m.code = g.mcode AND g.tstamp >= '%s' AND g.tstamp < '%s' GROUP BY m.code;", + $G_dbpfx, $G_dbpfx, $G_dbpfx, $from, $to); + + // if deletable old matches exists then ... + if (($tmt_pg = pg_query($bdb->dbconn->db(), $tmt_sql)) == FALSE) { + log_crit("stat-day: select from matches failed"); + break; + } + // // store matches before clean them // $tmt_n = pg_numrows($tmt_pg); // get matches + if ($tmt_n == 0) + continue; + + if (!isset($mlang_stat_day[$trn_obj->name][$G_lang])) { + log_crit("stat-day: tournament name not found in array"); + break; + } + fprintf($fpexp, "

%s

", $mlang_stat_day[$trn_obj->name][$G_lang]); + for ($m = 0 ; $m < $tmt_n ; $m++) { fprintf($fpexp, "
"); $tmt_obj = pg_fetch_object($tmt_pg, $m); - + $usr_sql = sprintf(" -SELECT u.code AS code, u.login AS login, min(g.tstamp) AS first, max(g.tstamp) AS last, m.tidx AS tidx FROM %sbin5_matches AS m, %sbin5_games AS g, %sbin5_points AS p, %susers AS u WHERE m.code = g.mcode AND g.code = p.gcode AND u.code = p.ucode AND m.code = %d GROUP BY u.code, u.login, m.tidx;", $G_dbpfx, $G_dbpfx, $G_dbpfx, $G_dbpfx, $tmt_obj->code); - - if (($usr_pg = pg_query($bdb->dbconn->db(), $usr_sql)) == FALSE ) { +SELECT u.code AS code, u.login AS login, min(g.tstamp) AS first, max(g.tstamp) AS last, m.tidx AS tidx FROM %sbin5_matches AS m, %sbin5_games AS g, %sbin5_points AS p, %susers AS u, %sbin5_table_orders AS o WHERE m.code = g.mcode AND g.code = p.gcode AND u.code = p.ucode AND m.code = %d AND m.code = o.mcode AND u.code = o.ucode GROUP BY u.code, u.login, m.tidx, o.pos ORDER BY o.pos;", $G_dbpfx, $G_dbpfx, $G_dbpfx, $G_dbpfx, $G_dbpfx, $tmt_obj->code); + + if (($usr_pg = pg_query($bdb->dbconn->db(), $usr_sql)) == FALSE ) { break; } $usr_n = pg_numrows($usr_pg); - if ($usr_n != 5) { + if ($usr_n != BIN5_PLAYERS_N) { break; - } + } + + $gam_sql = sprintf("SELECT g.* FROM %sbin5_games AS g, %sbin5_matches AS m WHERE g.mcode = m.code AND m.code = %d ORDER BY g.tstamp;", + $G_dbpfx, $G_dbpfx, $tmt_obj->code); + if (($gam_pg = pg_query($bdb->dbconn->db(), $gam_sql)) == FALSE ) { + break; + } + + $usr_obj = array(); for ($u = 0 ; $u < $usr_n ; $u++) { - $usr_obj = pg_fetch_object($usr_pg, $u); + $usr_obj[$u] = pg_fetch_object($usr_pg, $u); if ($u == 0) { - fprintf($fpexp, "

Codice: %d (%s - %s), Tavolo: %s

\n", $tmt_obj->code, $usr_obj->first, $usr_obj->last, $usr_obj->tidx); + fprintf($fpexp, "

Codice: %d (%s - %s), Tavolo: %s

\n", $tmt_obj->code, $usr_obj[$u]->first, $usr_obj[$u]->last, $usr_obj[$u]->tidx); fprintf($fpexp, "\n"); - } - fprintf($fpexp, "", $usr_obj->login); - $pts_sql = sprintf(" -select p.pts as pts from %sbin5_matches as m, %sbin5_games as g, %sbin5_points as p, %susers as u WHERE m.code = g.mcode AND g.code = p.gcode AND u.code = p.ucode AND m.code = %d AND u.code = %d ORDER BY g.code", $G_dbpfx, $G_dbpfx, $G_dbpfx, $G_dbpfx, - $tmt_obj->code, $usr_obj->code); + } + fprintf($fpexp, "", $usr_obj[$u]->login); + $pts_sql = sprintf("SELECT p.pts as pts from %sbin5_matches as m, %sbin5_games as g, %sbin5_points as p, %susers as u WHERE m.code = g.mcode AND g.code = p.gcode AND u.code = p.ucode AND m.code = %d AND u.code = %d ORDER BY g.code", $G_dbpfx, $G_dbpfx, $G_dbpfx, $G_dbpfx, + $tmt_obj->code, $usr_obj[$u]->code); + // points of the match for each user if (($pts_pg[$u] = pg_query($bdb->dbconn->db(), $pts_sql)) == FALSE) { break; } @@ -278,28 +333,34 @@ select p.pts as pts from %sbin5_matches as m, %sbin5_games as g, %sbin5_points a } } } - if ($u != 5) { + if ($u != BIN5_PLAYERS_N) { break; - } - fprintf($fpexp, "\n"); + } + fprintf($fpexp, "\n"); // LISTA DELLE VARIE PARTITE for ($g = 0 ; $g < $num_games ; $g++) { + $gam_obj = pg_fetch_object($gam_pg, $g); fprintf($fpexp, ""); - for ($u = 0 ; $u < 5 ; $u++) { + for ($u = 0 ; $u < BIN5_PLAYERS_N ; $u++) { $pts_obj = pg_fetch_object($pts_pg[$u], $g); - fprintf($fpexp, "", $pts_obj->pts); + fprintf($fpexp, "", $pts_obj->pts); } + fprintf($fpexp, "", $usr_obj[$gam_obj->mazzo]->login, + xcape( game_description($gam_obj->act, 'plain', + $gam_obj->asta_win, $usr_obj[$gam_obj->asta_win]->login, + $gam_obj->friend, $usr_obj[$gam_obj->friend]->login, + $gam_obj->pnt, $gam_obj->asta_pnt) ) + ); fprintf($fpexp, "\n"); } // LISTA DEI TOTALI fprintf($fpexp, ""); - for ($u = 0 ; $u < 5 ; $u++) { - $usr_obj = pg_fetch_object($usr_pg, $u); + for ($u = 0 ; $u < BIN5_PLAYERS_N ; $u++) { $tot_sql = sprintf(" SELECT SUM(p.pts) AS pts FROM %sbin5_matches AS m, %sbin5_games AS g, %sbin5_points AS p, %susers AS u WHERE m.code = g.mcode AND g.code = p.gcode AND u.code = p.ucode AND m.code = %d AND u.code = %d", $G_dbpfx, $G_dbpfx, $G_dbpfx, $G_dbpfx, - $tmt_obj->code, $usr_obj->code); + $tmt_obj->code, $usr_obj[$u]->code); if (($tot_pg = pg_query($bdb->dbconn->db(), $tot_sql)) == FALSE ) { break; } @@ -311,37 +372,41 @@ SELECT SUM(p.pts) AS pts FROM %sbin5_matches AS m, %sbin5_games AS g, %sbin5_poi } if ($m < $tmt_n) break; - } // if (($tmt_pg = pg_query($bdb->dbco... - - fclose($fpexp); - return (TRUE); + } + if ($t < $trn_n) + break; + $ret = (TRUE); } while (0); - pg_query($bdb->dbconn->db(), "ROLLBACK"); - fclose($fpexp); + if ($ret == FALSE) { + pg_query($bdb->dbconn->db(), "ROLLBACK"); + } + if ($fpexp != FALSE) { + fclose($fpexp); + } - return (FALSE); + return ($ret); } // echo "QUIr\n"; // exit(123); function main() { - GLOBAL $G_dbasetype, $G_alarm_passwd, $pazz, $from, $to; - + GLOBAL $G_lang, $G_dbasetype, $G_alarm_passwd, $pazz, $from, $to; + if ($pazz != $G_alarm_passwd) { echo "Wrong password
"; mop_flush(); exit; } - + $fun_name = "main_${G_dbasetype}"; - + if ($ret = $fun_name($from, $to)) echo "Success.
\n"; else echo "Failed.
\n"; - + echo "Fine.\n"; mop_flush(); }
%s%s
mazzodescrizione
%d%d%s%s