Usage: Contributor Stats

2015 Contributor Stats

Viewing this page does not require registration.

[php]

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

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

echo “(PUBLIC) Summary:”;
echo “[br]”;
echo “[table border=\”1\”]\n”;
echo “[tr]\n”;
echo ” [td]Num[/td]\n”;
echo “[/tr]\n”;
$query =

select tag,count(*) cnt from signs4 where (submittedOn>’2015-01-01′ or deletedOn>’2015-01-01′) and tag not in (‘Speedy Gonzales’,’Jim Pruett’,’James Pruett’,’your name’) group by tag order by cnt desc limit 25
“;
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
echo “[tr]\n”;
echo “[td]” . $row[‘tag’] . “[/td]\n”;
echo “[td]” . $row[‘cnt’] . “[/td]\n”;
echo “[/tr]\n”;
}
echo “[/table]\n”;
echo “\n”;

[/php]

Leave a Reply