X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=web%2Fbriskin5%2Fstat-day.php;h=8ba77788a3456c7940eb14c2c812be1cbb7d3943;hb=db12d769481823f4c744ce0e3a50404cc6b01cd1;hp=8cbe095011b7ea57140fe335f58f788210ab68c6;hpb=f87bfe467d9f956601c44b8d84404b457f3710af;p=brisk.git diff --git a/web/briskin5/stat-day.php b/web/briskin5/stat-day.php index 8cbe095..8ba7778 100644 --- a/web/briskin5/stat-day.php +++ b/web/briskin5/stat-day.php @@ -29,12 +29,12 @@ wget -O daily.txt dodo.birds.van/brisk/briskin5/stat-day.php?pazz=yourpasswd&fro now="$(date +%s)" # from 100 days ago to 1 day after -to="$(date +"%Y-%m-%d+%H:%M:%S" -d @$(echo "$now + 86400" | bc))" -from="$(date +"%Y-%m-%d+%H:%M:%S" -d @$(echo "$now - 8640000" | bc))" +to="$(date +"%Y-%m-%d+%H:%M:%S" -d @$(echo "$(date +%s) + 86400" | bc))" +from="$(date +"%Y-%m-%d+%H:%M:%S" -d @$(echo "$(date +%s) - 8640000" | bc))" # to="$(date +"%Y-%m-%d+%H:%M:%S" -d @$(echo "$now + 7200 " | bc))" # from="$(date +"%Y-%m-%d+%H:%M:%S" -d @$(echo "$now - 9200 " | bc))" -curl -d "pazz=$BRISK_PASS" "http://$BRISK_SITE/briskin5/stat-day.php?from=$from&to=$to" +curl -d "pazz=$BRISK_PASS" "http://$BRISK_SITE/briskin5/stat-day.php?from=$(date +"%Y-%m-%d+%H:%M:%S" -d @$(echo "$(date +%s) - 8640000" | bc))&to=$(date +"%Y-%m-%d+%H:%M:%S" -d @$(echo "$(date +%s) + 86400" | bc))" */ @@ -43,7 +43,10 @@ $G_base = "../"; $mlang_stat_day = array( 'normal match'=> array( 'it' => 'Partite normali', 'en' => 'Normal matches' ), 'special match' => array( 'it' => 'Partite speciali', - 'en' => 'Special matches') + 'en' => 'Special matches'), + + 'info_total'=> array( 'it' => 'totali', + 'en' => 'En totali') ); @@ -230,60 +233,117 @@ 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; - } + // log_crit("stat-day: BEGIN"); 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; + } + + // 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; } - - $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) { + $trn_n = pg_numrows($trn_pg); + printf("Number of tournaments: %d\n", $trn_n); + + // loop on tournaments + for ($t = 0 ; $t < $trn_n ; $t++) { + // log_crit("stat-day: LOOP t"); + $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 + ORDER BY m.code, minus_one_is_old DESC;", + $G_dbpfx, $G_dbpfx, $G_dbpfx, $trn_obj->code, $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; + } + printf("[Tournament [%s]], number of matches: %d\n", $mlang_stat_day[$trn_obj->name][$G_lang], $tmt_n); + fprintf($fpexp, "

%s

", $mlang_stat_day[$trn_obj->name][$G_lang]); + + // loop on matches for ($m = 0 ; $m < $tmt_n ; $m++) { + // log_crit("stat-day: LOOP 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 ) { + + // get users for the match m + if (($users = $bdb->users_get($tmt_obj->code, TRUE, ($tmt_obj->minus_one_is_old > -1))) == FALSE) { + log_crit(sprintf("stat_day: users_get failed %d", $tmt_obj->code)); break; } - $usr_n = pg_numrows($usr_pg); - if ($usr_n != 5) { + + $gam_sql = sprintf(" +SELECT g.* FROM %sbin5_tournaments AS t, %sbin5_matches AS m, %sbin5_games AS g + WHERE t.code = m.tcode AND m.code = g.mcode AND m.code = %d + ORDER BY g.tstamp;", + $G_dbpfx, $G_dbpfx, $G_dbpfx, $tmt_obj->code); + if (($gam_pg = pg_query($bdb->dbconn->db(), $gam_sql)) == FALSE ) { + log_crit("stat-day: gam_sql failed"); break; - } - for ($u = 0 ; $u < $usr_n ; $u++) { - $usr_obj = pg_fetch_object($usr_pg, $u); + } + + // loop on users of the match m + for ($u = 0 ; $u < count($users) ; $u++) { + // log_crit("stat-day: LOOP 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, $users[$u]['first'], $users[$u]['last'], $users[$u]['tidx']); fprintf($fpexp, "\n"); - } - fprintf($fpexp, "", $usr_obj->login); + } + fprintf($fpexp, "", $users[$u]['login']); + // note: we are looping on users, order on them not needed $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); - - if (($pts_pg[$u] = pg_query($bdb->dbconn->db(), $pts_sql)) == FALSE) { +SELECT p.pts AS pts + FROM %sbin5_games AS g, %sbin5_points AS p + WHERE g.code = p.gcode AND g.mcode = %d AND p.ucode = %d + ORDER BY g.tstamp", + $G_dbpfx, $G_dbpfx, + $tmt_obj->code, $users[$u]['code']); + + // points of the match for each user + if (($pts_pg[$u] = pg_query($bdb->dbconn->db(), $pts_sql)) == FALSE) { + log_crit("stat-day: pts_sql failed"); break; } if ($u == 0) { @@ -291,74 +351,158 @@ select p.pts as pts from %sbin5_matches as m, %sbin5_games as g, %sbin5_points a } else { if ($num_games != pg_numrows($pts_pg[$u])) { + log_crit("stat-day: num_games != pg_numrows"); break; } } } - if ($u != 5) { + if ($u != BIN5_PLAYERS_N) { + log_crit("stat-day: u != BIN5_PLAYERS_N"); break; - } - fprintf($fpexp, "\n"); + } + if ($tmt_obj->minus_one_is_old != -1) { + fprintf($fpexp, "\n"); + } // LISTA DELLE VARIE PARTITE + $pts_obj = array(); for ($g = 0 ; $g < $num_games ; $g++) { + $gam_obj = pg_fetch_object($gam_pg, $g); fprintf($fpexp, ""); - for ($u = 0 ; $u < 5 ; $u++) { - $pts_obj = pg_fetch_object($pts_pg[$u], $g); - fprintf($fpexp, "", $pts_obj->pts); + $pt_min = 1000; + $pt_min_n = 0; + $pt_max = -1000; + $pt_max_n = 0; + for ($u = 0 ; $u < BIN5_PLAYERS_N ; $u++) { + $pts_obj[$u] = pg_fetch_object($pts_pg[$u], $g); + + if ($pt_min > $pts_obj[$u]->pts) { + $pt_min = $pts_obj[$u]->pts; + $pt_min_n = 1; + } + else if ($pt_min == $pts_obj[$u]->pts) { + $pt_min_n++; + } + + if ($pt_max < $pts_obj[$u]->pts) { + $pt_max = $pts_obj[$u]->pts; + $pt_max_n = 1; + } + else if ($pt_max == $pts_obj[$u]->pts) { + $pt_max_n++; + } + } + if ($pt_min_n > 1) { + $pt_min = 1000; + } + if ($pt_max_n > 1) { + $pt_max = -1000; + } + + /* cases: + pts = 0 -> white + pts == pt_min -> red + pts == pt_max -> green + pts < 0 -> light red + pts > 0 -> light green + */ + for ($u = 0 ; $u < BIN5_PLAYERS_N ; $u++) { + $pts = $pts_obj[$u]->pts; + + if ($pts == 0) + $cla_nam = 'bg_white'; + else if ($pts == $pt_min) + $cla_nam = 'bg_red'; + else if ($pts == $pt_max) + $cla_nam = 'bg_green'; + else if ($pts < 0) + $cla_nam = 'bg_lired'; + else if ($pts > 0) + $cla_nam = 'bg_ligre'; + + fprintf($fpexp, "<%s class='%s'>%d", + ($tmt_obj->minus_one_is_old == -1 ? "td" : "th"), + $cla_nam, pow(2,$gam_obj->mult) * $pts, + ($tmt_obj->minus_one_is_old == -1 ? "td" : "th")); + } + if ($tmt_obj->minus_one_is_old != -1) { + fprintf($fpexp, "", $users[$gam_obj->mazzo]['login'], + xcape( game_description($gam_obj->act, 'plain', $gam_obj->mult, + $gam_obj->asta_win, + ($gam_obj->asta_win != -1 ? + $users[$gam_obj->asta_win]['login'] : ""), + $gam_obj->friend, + ($gam_obj->friend != -1 ? + $users[$gam_obj->friend]['login'] : ""), + $gam_obj->pnt, $gam_obj->asta_pnt, $gam_obj->tourn_pts) ) + ); } 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++) { + // NOTE: this part must be revisited when we move to multiple game rules + // probably removing the sum and adding another nested iteration on games. $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); +SELECT sum(p.pts * (2^g.mult)) 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 ( (u.type & (CAST (X'00ff0000' as integer))) <> (CAST (X'00800000' as integer)) ) + AND m.code = %d AND u.code = %d", + $G_dbpfx, $G_dbpfx, $G_dbpfx, $G_dbpfx, + $tmt_obj->code, $users[$u]['code']); if (($tot_pg = pg_query($bdb->dbconn->db(), $tot_sql)) == FALSE ) { break; } $tot_obj = pg_fetch_object($tot_pg, 0); fprintf($fpexp, "", $tot_obj->pts); } - fprintf($fpexp, "\n"); + if ($tmt_obj->minus_one_is_old != -1) { + fprintf($fpexp, "\n", $mlang_stat_day['info_total'][$G_lang]); + } fprintf($fpexp, "
%s%s
mazzodescrizione
%d%s%s
%d
%s
\n"); } - if ($m < $tmt_n) + if ($m < $tmt_n) { + log_crit("stat-day: m < tmt_n"); break; - } // if (($tmt_pg = pg_query($bdb->dbco... - - fclose($fpexp); - return (TRUE); + } + } + if ($t < $trn_n) { + log_crit("stat-day: 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(); }