<?php require_once "../../config.inc.php"; $auth = new auth("ANALYSE_RATINGS"); $page_action = "update"; $go = "update"; $page = new Page("Rating Results"); $form = new EditForm($lang->get("rateres", "Rate Results")); $interval = array(); $count = countRows("pgn_rating", "RATINGID", "COMMENT <>''"); $steps = $count / 50; for ($i = 0; $i < $steps; $i++) { $interval[$i][0] = $i * 50 . " - " . (($i + 1) * 50 - 1); $interval[$i][1] = $i; } $form->add(new Label("lbl", $lang->get("display", "Display"), "standard")); $form->add(new Select("display", $interval, "standardlight", value("display"), 1)); $grid = new NXGrid("grid", 3); $grid->setRatio(array(150, 350, 100)); $grid->addRow(array(new Label("lbl", "<b>" . $lang->get("page", "Page") . "</b>"), new Label("lbl", "<b>" . $lang->get("comment", "Comment") . "</b>"), new Label("lbl", "<b>" . $lang->get("date", "Date") . "</b>"))); $thisInterval = value("interval"); $sql = "SELECT SOURCEID, COMMENT, TIMESTAMP FROM pgn_rating WHERE COMMENT <> '' ORDER BY TIMESTAMP DESC"; $query = new query($db, $sql); while ($query->getrow()) { $grid->addRow(array(new Label("lbl", resolvePageToLink($query->field("SOURCEID"))), new Label("lbl", str_replace('\\\\', '\\', $query->field("COMMENT"))), new Label("lbl", formatDBTimestamp($query->field('TIMESTAMP'))))); } $query->free(); $form->add($grid); $page->add($form); $page->draw();
/** * prepare Statistic data * @param array (0=>timeframe, 1=>valuetype) */ function renderStatsData() { global $lang; $output = '<tr><td width="70%" class="underlined">' . $lang->get("path", "Path") . '</td><td width="30%" class="underlined" align="right">' . $lang->get("count", "Count") . '</td></tr>' . "\n"; $this->container .= $output; for ($i = 0; $i < count($this->data); $i++) { $spc = ""; $do = $this->data[$i]; $paths = ""; $count = $do->count; for ($j = 0; $j < $do->length; $j++) { $paths .= $spc . ($j + 1) . ". " . resolvePageToLink($do->documents[$j]) . "<br>"; $spc .= " "; } $this->container .= '<tr><td width="70%" class="underlined">' . $paths . '</td><td width="30%" class="underlined" align="right" valign="top">' . $count . '</td></tr>' . "\n"; } }
/** * prepare Statistic data * @param array (0=>timeframe, 1=>valuetype) */ function renderStatsData() { global $lang; $output = '<tr><td width="10%" class="underlined"><b>' . $lang->get("rank", "Rank") . '</b></td><td width="40%" class="underlined"><b>' . $lang->get("page", "Page") . '</b></td><td width="25%" class="underlined" align="right"><b>' . $lang->get("count", "Count") . '</b></td><td width="25%" class="underlined" align="right"><b>' . $lang->get("percent", "Percent") . '</b></td></tr>' . "\n"; $this->container .= $output; for ($i = 0; $i < count($this->data["top_items"]); $i++) { $this->container .= "<tr>"; $this->container .= '<td class="underlined">' . ($i + 1) . '</td>'; $this->container .= '<td class="underlined">' . resolvePageToLink($this->data["top_items"][$i]["string"]) . '</td>'; $this->container .= '<td class="underlined" align="right">' . $this->data["top_items"][$i]["count"] . '</td>'; $this->container .= '<td class="underlined" align="right">' . sprintf("%01.2f", $this->data["top_items"][$i]["percent"]) . ' %</td>'; $this->container .= '</tr>'; } }