Usage-Summary

To create the most current summary below, run the UPDATE pages located in the USAGE Menu.

[php]
global $current_user;
get_currentuserinfo();

$secret= $current_user->user_email;

include(“../dbconnectlocal.php”);

#echo “[div style=\”font-family:verdana;width:100%;padding:8px;border-radius:10px;border:10px solid #EE872A; \”]\n”;
echo “\n”;
echo “\n”;

//yes we have email
if($secret != “”) {

echo “[style] table,th,td { border:0px solid black; border-collapse:collapse;} [/style]\n”;

echo “(PRIVATE) Summary for NAME=”.$current_user->display_name.” since Jan 2015\n”;
$query =

SELECT sum(num_marks) as num_marks FROM `summary`
where name= ‘$current_user->display_name’
“;
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
$nmarks= $row[‘num_marks’];
}
echo “[br][br]\n”;

$query =

SELECT sum(num) as num_submits FROM `stats`
where email= ‘$secret’ or
deletedOn_email= ‘$secret’
“;
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
$nsubmits= $row[‘num_submits’];
}

$query =

SELECT limits as ll FROM `dailylimit` where name=’$current_user->display_name’
“;
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
$nlimit= $row[‘ll’];
}

echo “[table width=\”100%\” ]\n”;
echo “[tr]\n”;
echo ” [th width=\”33%\”]Num Marks[/th]\n”;
echo ” [th width=\”33%\”]Num Submits[/th]\n”;
echo ” [th width=\”33%\”]Your daily MARKS limit[/th]\n”;
echo “[/tr]\n”;
echo “[tr]\n”;
echo ” [td]”.$nmarks.”[/td]\n”;
echo ” [td]”.$nsubmits.”[/td]\n”;
echo ” [td]”.$nlimit.”[/td]\n”;
echo “[/tr]\n”;
echo “[/table]”;

if($nlimit < 10000) {
echo “This page is new. If you feel its wrong, don’t hesitate to send an email to speedup@wikispeedia.org .”;
echo “[br]”;

}

} else { //we have email

echo “No records found. Logging in may help.”;

} //we have email

echo “To raise your Daily Limit, log some signs.”;
echo “The easiest way is with the open source logger here:\n”.”[br]”;
echo “[a href=\”https://play.google.com/store/apps/details?id=org.wikispeedia.zombiepro\”]Zombie speed limit logger.[/a]”;

[/php]

Leave a Reply