View file sitestats2.php

File size: 9.98Kb
<?php
define('WCS',true);
include('./core/main.inc');
header_type();
cleardata();
if(ipbanned(ip(),browser())){
if(!shield(getuid_sid($sid))){
echo head_tag("Ip Blocked!!!",0,0);
echo ipbanned_msg();
echo foot_tag();
exit();
}
}
if(!islogged($sid)){
echo head_tag("Error!!!",0,0);
echo session_expired();
echo foot_tag();
exit();
}
if(banned(getuid_sid($sid))){
echo head_tag("Error!!!",1,getnick_sid($sid));
echo banned_msg($sid);
echo foot_tag();
exit();
}
mysql_query("UPDATE users SET browser='".browser()."', ipaddress='".ip()."', host='".subno()."' WHERE id='".getuid_sid($sid)."'");

/////////////////////////SITE STATS/////////////////////////

if($on2day==1){
addonline(getuid_sid($sid),"Site Stats","");
echo head_tag(getnick_sid($sid)."@Site Stats",1,getnick_sid($sid));
$title="Maximum number of users was online in the last 10 Days";
$main="<p align=".align().">";
$sql="SELECT ddt, dtm, ppl FROM mpot ORDER BY id DESC LIMIT 10";
$items=mysql_query($sql);
if(mysql_num_rows($items)>0){
while($item=mysql_fetch_array($items)){
$main.="$item[0]($item[1]) Members: $item[2]<br/>";
}
}
$main.="</p>";
$L1="$sixkey<a $key6 href=\"./inbox/inbox.php?sid=$sid\">Inbox</a>";
$L2="$sevenkey<a $key7 href=\"./buds/buds.php?sid=$sid\">BuddyList</a>";
$L3="$eightkey<a $key8 href=\"./chat/public.php?sid=$sid\">Chat</a>";
$L4="$ninekey<a $key9 href=\"./forums/forums.php?sid=$sid\">Forums</a>";
$L5="$zerokey<a $key0 href=\"./main.php?sid=$sid\"><img src=\"./images/home.gif\" alt=\"\"/>Main Menu</a>";
echo xhtml($sid,$title,1,$L1,$L2,$L3,$L4,$L5,0,0,0,$main);
echo foot_tag();
exit;
}
else if ($action=="main"){
addonline(getuid_sid($sid),"Site Stats","");
echo head_tag(getnick_sid($sid)."@Site Stats",1,getnick_sid($sid));
$title="<b>Site Stats</b>";
$main="<p align=".align().">";
$norm=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM users"));
$main.="Registered Members: <b>$norm[0]</b> ";
$memid=mysql_fetch_array(mysql_query("SELECT id, username FROM users ORDER BY regdate DESC LIMIT 0,1"));
$main.="The Newest Member is: <b><a href=\"./profile.php?who=$memid[0]&amp;sid=$sid\">$memid[1]</a></b><br/>";
$mols=mysql_fetch_array(mysql_query("SELECT dtm, ppl, ddt FROM mpot WHERE ppl>'0' ORDER BY ppl DESC LIMIT 1"));
$main.="Most Users Online: <b>$mols[1]</b> $mols[0] - $mols[2]<br/>";
$mols=mysql_fetch_array(mysql_query("SELECT ppl, dtm FROM mpot WHERE ddt='".date("l jS F")."'"));
$main.="Most Users Online(<a href=\"./sitestats.php?on2day=1&amp;sid=$sid\"> For today only</a>): <b>$mols[0]</b> Members at $mols[1]<br/>";
$aut=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM users WHERE lastact>'".(time()-(24*60*60))."'"));
$main.="Active users today <b>$aut[0]</b><br/>";
$notc=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM forumtopics"));
$nops=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM forumposts"));
$main.="Number of Topics: <b>$notc[0]</b> - Number of Posts: <b>$nops[0]</b><br/>";
$nopm=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM inbox"));
$main.="Number of Inboxes: <b>$nopm[0]</b><br/>";
$nopm=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM popups"));
$main.="Number of Popups: <b>$nopm[0]</b><br/>";
$nopm=mysql_fetch_array(mysql_query("SELECT value FROM settings WHERE name='Counter'"));
$main.="Counter: <b>$nopm[0]</b><br/>";


    $main.= "<br/><a href=\"sitestats2.php?action=l24&amp;sid=$sid\">Todays Activity</a><br/>";
    
    $main.= "<a href=\"sitestats2.php?action=topp&amp;sid=$sid\">Top Posters</a><br/>";
    $main.= "<a href=\"sitestats2.php?action=tchat&amp;sid=$sid\">Top Chatters</a><br/>";
    $main.= "<a href=\"sitestats2.php?action=tgame&amp;sid=$sid\">Top Gamers</a><br/>";
    $main.= "<a href=\"sitestats.php?action=pviews&amp;sid=$sid\">Top Profile Views</a><br/>";
    $main.= "<a href=\"sitestats2.php?action=tshout&amp;sid=$sid\">Top Shouters</a><br/>";
    $main. "<a href=\"sitestats2.php?action=tplus&amp;sid=$sid\">Top Plusses</a><br/>";







$main.="</p>";
$L1="$sixkey<a $key6 href=\"./inbox/inbox.php?sid=$sid\">Inbox</a>";
$L2="$sevenkey<a $key7 href=\"./buds/buds.php?sid=$sid\">BuddyList</a>";
$L3="$eightkey<a $key8 href=\"./chat/public.php?sid=$sid\">Chat</a>";
$L4="$ninekey<a $key9 href=\"./forums/forums.php?sid=$sid\">Forums</a>";
$L5="$zerokey<a $key0 href=\"./main.php?sid=$sid\"><img src=\"./images/home.gif\" alt=\"\"/>Main Menu</a>";
echo xhtml($sid,$title,1,$L1,$L2,$L3,$L4,$L5,0,0,0,$main);
echo foot_tag();
}

else if($action=="l24")
{

addonline(getuid_sid($sid),"Todays Activity","");
echo head_tag(getnick_sid($sid)."@Todays Activity",1,getnick_sid($sid));
$title="<b>Todays Activity</b>";
$main="<p align=".align().">";



    $main.= "<p>";
    /////
    $main.= "Things that have happened on $sitename during last 24 hours<br/><br/>";
    $tm24 = time() - (24*60*60);
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM users WHERE lastact>'".$tm24."'"));
    $main.= "Active Members: <b>$aut[0]</b><br/>";
$aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM users WHERE regdate>'".$tm24."'"));
    $main.= "Registered Members: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM blogs WHERE date>'".$tm24."'"));
    $main.= "Blogs Created: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM clubmembers WHERE joined>'".$tm24."' AND accepted='1'"));
    $main.= "Members Joined Clubs: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM clubs WHERE created>'".$tm24."'"));
    $main.= "Clubs Created: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM buds WHERE tid>'".$tm24."' AND agreed='1'"));
    $main.= "Buddies Added: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM guestbook WHERE date>'".$tm24."'"));
    $main.= "Guestbooks Signed: <b>$aut[0]</b><br/>";
    if(ismod(getuid_sid($sid))){
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM logs WHERE action>'".$tm24."'"));
    $main.= "ModLog Actions: <b>$aut[0]</b><br/>";
  }
  $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM polls WHERE date>'".$tm24."'"));
    $main.= "Polls Added: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM forumposts WHERE date>'".$tm24."'"));
    $main.= "Posts: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM inbox WHERE timesent>'".$tm24."'"));
    $main.= "PMs Sent: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM shouts WHERE shtime>'".$tm24."'"));
    $main.= "Shouts: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM forumtopics WHERE date>'".$tm24."'"));
    $main.= "Topics Created: <b>$aut[0]</b><br/>";
    $main.="</p>";
$L1="$sixkey<a $key6 href=\"./inbox/inbox.php?sid=$sid\">Inbox</a>";
$L2="$sevenkey<a $key7 href=\"./buds/buds.php?sid=$sid\">BuddyList</a>";
$L3="$eightkey<a $key8 href=\"./chat/public.php?sid=$sid\">Chat</a>";
$L4="$ninekey<a $key9 href=\"./forums/forums.php?sid=$sid\">Forums</a>";
$L5="$zerokey<a $key0 href=\"./main.php?sid=$sid\"><img src=\"./images/home.gif\" alt=\"\"/>Main Menu</a>";
echo xhtml($sid,$title,1,$L1,$L2,$L3,$L4,$L5,0,0,0,$main);
echo foot_tag();
}

//////////////////////////////////Blogs

else if($action=="topp")
{
addonline(getuid_sid($sid),"Viewing Top Posters","");
echo head_tag(getnick_sid($sid)."@Viewing Top Posters",1,getnick_sid($sid));
$title="<b>Top Posters</b>";
$main="<p align=".align().">";
    $main.= "<b>Our Top Posters</b><br/><small>Thank you all for keeping this site alive<br/>";
    $weekago = time();
    $weekago -= 7*24*60*60;
    $noi = mysql_fetch_array(mysql_query("SELECT COUNT(DISTINCT uid) FROM forumposts WHERE date>'".$weekago."';"));
    $main.=  "<a href=\"sitestats2.php?action=tpweek&amp;sid=$sid\">This week($noi[0])</a><br/>";
    $noi = mysql_fetch_array(mysql_query("SELECT COUNT(DISTINCT uid)  FROM forumposts ;"));
    $main.= "<a href=\"sitestats2.php?action=tptime&amp;sid=$sid\">All the time($noi[0])</a></small><br/>";
    //////ALL LISTS SCRIPT <<

    if($page=="" || $page<=0)$page=1;
    $num_items = regmemcount(); //changable
    $items_per_page= 10;
    $num_pages = ceil($num_items/$items_per_page);
    if(($page>$num_pages)&&$page!=1)$page= $num_pages;
    $limit_start = ($page-1)*$items_per_page;

    //changable sql





       

$sql= mysql_fetch_array(mysql_query("SELECT * FROM users a INNER JOIN profiles b ON a.id=b.uid WHERE a.id='".$who."'"));
$posts=mysql_fetch_array(mysql_query("SELECT * FROM profiles WHERE uid='".$who."'"));

    $main.=  "<p>";


      $lnk = "<a href=\"../profile.php?who=$nick[0]&amp;sid=$sid\">$item[1]</a> <small>Posts: $item[2]</small>";
      $main.=  "$lnk<br/>";
    
    
    $main.=  "</p>";
    $main.= "<p align=\"center\">";
    if($page>1)
    {
      $ppage = $page-1;
      $main.=  "<a href=\"lists.php?action=topp&amp;page=$ppage&amp;sid=$sid&amp;view=$view\">&#171;PREV</a> ";
    }
    if($page<$num_pages)
    {
      $npage = $page+1;
      $main.= "<a href=\"lists.php?action=topp&amp;page=$npage&amp;sid=$sid&amp;view=$view\">Next&#187;</a>";
    }
    $main.= "<br/>$page/$num_pages<br/>";
    if($num_pages>2)
    {
        $rets = "<form action=\"sitestats2.php\" method=\"get\">";
        $rets .= "<input name=\"page\" style=\"-wap-input-format: '*N'\" size=\"2\"/>";
        $rets .= "<input type=\"hidden\" name=\"action\" value=\"$action\"/>";
        $rets .= "<input type=\"hidden\" name=\"sid\" value=\"$sid\"/>";
        $rets .= "<input type=\"submit\" value=\"Go To Page\"/>";
        $rets .= "</form>";

        $main.=  $rets;
    }
    $main.= "</p>";
  ////// UNTILL HERE >>

    
$L1="$sixkey<a $key6 href=\"./inbox/inbox.php?sid=$sid\">Inbox</a>";
$L2="$sevenkey<a $key7 href=\"./buds/buds.php?sid=$sid\">BuddyList</a>";
$L3="$eightkey<a $key8 href=\"./chat/public.php?sid=$sid\">Chat</a>";
$L4="$ninekey<a $key9 href=\"./forums/forums.php?sid=$sid\">Forums</a>";
$L5="$zerokey<a $key0 href=\"./main.php?sid=$sid\"><img src=\"./images/home.gif\" alt=\"\"/>Main Menu</a>";
echo xhtml($sid,$title,1,$L1,$L2,$L3,$L4,$L5,0,0,0,$main);
echo foot_tag();
}



?>