\n"; $VAR["Content"] .= "" . _TOTALSTORIES . "" . $tmp . "\n"; $sql = "SELECT floor(avg(Hits)) FROM T_Stories "; $sql .= "WHERE Verified = 'Y'"; $result = @mysql_query($sql,$db); $VAR["Content"] .= "" . _AVGHITS . "" . mysql_result($result,0) . "\n"; if ($CONF["Comments"] > 0) { $tmp = F_count("T_Comments"); $VAR["Content"] .= "" . _TOTALCOMMENTS . "" . $tmp . "\n"; } if (F_count("T_PollQuestions") > 0) { $tmp = F_count("T_PollQuestions"); $VAR["Content"] .= "" . _TOTALPOLLS . "" . $tmp . "\n"; } if ($CONF["Links"] > 0) { $tmp = F_count("T_Links"); $VAR["Content"] .= "" . _TOTALLINKS . "" . $tmp . "\n"; } $VAR["Content"] .= "\n"; F_drawMain($VAR); /*== story stats ==*/ $sql = "SELECT Rid,Heading,Hits from T_Stories "; $sql .= "WHERE Hits > 0 "; $sql .= "ORDER BY Hits desc LIMIT 10"; $result = mysql_query($sql,$db); $nrows = mysql_num_rows($result); $VAR["Heading"] = _TOPSTORIES; if ($nrows>0) { $VAR["Content"] = "\n"; for ($i=0;$i<$nrows;$i++) { $A = mysql_fetch_array($result); $VAR["Content"] .= "\n"; $VAR["Content"] .= "\t\n"; $VAR["Content"] .= "\t\n"; $VAR["Content"] .= "\n"; } $VAR["Content"] .= "

" . $A["Heading"] . " (" . F_count("T_Comments","TopRid",$A["Rid"]) . ")

" . $A["Hits"] . " " . _HITS . "

\n"; } else { $VAR["Content"] = _NOSTORIES; } F_drawMain($VAR); /*== poll stats ==*/ $sql = "SELECT Rid,Question,Voters from T_PollQuestions "; $sql .= "WHERE Voters > 0 "; $sql .= "ORDER BY Voters desc LIMIT 10"; $result = mysql_query($sql,$db); $nrows = mysql_num_rows($result); $VAR["Heading"] = _TOPPOLLS; if ($nrows>0) { $VAR["Content"] = "\n"; for ($i=0;$i<$nrows;$i++) { $A = mysql_fetch_array($result); $VAR["Content"] .= "\n"; $VAR["Content"] .= "\t\n"; $VAR["Content"] .= "\t\n"; $VAR["Content"] .= "\n"; } $VAR["Content"] .= "

" . $A["Question"] . " (" . F_count("T_Comments","TopRid",$A["Rid"]) . ")

" . $A["Voters"] . " " . _VOTES . "

\n"; } else { $VAR["Content"] = _NOPOLLS; } F_drawMain($VAR); /*== pages stats ==*/ $sql = "SELECT Rid,Heading,Hits from T_Blocks "; $sql .= "WHERE Hits > 0 "; $sql .= "AND (Display = 'f' OR Display = 'p') "; $sql .= "ORDER BY Hits desc LIMIT 10"; $result = mysql_query($sql,$db); $nrows = mysql_num_rows($result); $VAR["Heading"] = _TOPPAGES; if ($nrows>0) { $VAR["Content"] = "\n"; for ($i=0;$i<$nrows;$i++) { $A = mysql_fetch_array($result); $VAR["Content"] .= "\n"; $VAR["Content"] .= "\t\n"; $VAR["Content"] .= "\n"; $VAR["Content"] .= "\n"; $VAR["Content"] .= "\n"; } $VAR["Content"] .= "

"; $VAR["Content"] .= sprintf("%s", urlencode(stripslashes($A["Heading"])), stripslashes($A["Heading"])); $VAR["Content"] .= "

" . $A["Url"] . "

" . $A["Hits"] . " " . _HITS . "

\n"; } else { $VAR["Content"] = _NOPAGES; } F_drawMain($VAR); /*== link stats ==*/ if ($CONF["Links"] > 0) { $sql = "SELECT Rid,Url,Name,Hits from T_Links "; $sql .= "WHERE Hits > 0 "; $sql .= "ORDER BY Hits desc LIMIT 10"; $result = mysql_query($sql,$db); $nrows = mysql_num_rows($result); $VAR["Heading"] = _TOPLINKS; if ($nrows>0) { $VAR["Content"] = "\n"; for ($i=0;$i<$nrows;$i++) { $A = mysql_fetch_array($result); $VAR["Content"] .= "\n"; $VAR["Content"] .= "\t\n"; $VAR["Content"] .= "\n"; $VAR["Content"] .= "\n"; } $VAR["Content"] .= "

"; $VAR["Content"] .= sprintf("%s - %s", urlencode($A["Url"]), $A["Rid"], stripslashes($A["Name"]), $A["Url"]); $VAR["Content"] .= "

" . $A["Hits"] . " " . _HITS . "

\n"; } else { $VAR["Content"] = _NOLINKS; } F_drawMain($VAR); } include("./include/footer.inc.php"); ?>