View file shoutbox/history.php

<?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();
}
if(shoutbanned(getuid_sid($sid))){
echo head_tag("Error!!!",1,getnick_sid($sid));
echo shoutbanned_msg($sid);
echo foot_tag();
exit();
}
mysql_query("UPDATE users SET browser='".browser()."', ipaddress='".ip()."', host='".subno()."' WHERE id='".getuid_sid($sid)."'");

/////////////////////////SHOUTBOX HISTORY/////////////////////////

addonline(getuid_sid($sid),"Viewing Shouts","");
echo head_tag(getnick_sid($sid)."@Shoutbox",1,getnick_sid($sid));
$title="<b>Shoutbox Hstory</b>";
$main="<p align=".align().">\n";
if($page==""||$page<=0)$page=1;
if($who==""){$noi=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM shouts"));}
else{$noi=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM shouts WHERE uid='".$who."'"));}
$num_items=$noi[0];
$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;
if($who==""){
$sql="SELECT id, shout, uid, shtime FROM shouts 
ORDER BY shtime DESC LIMIT $limit_start, $items_per_page
";
}else{
$sql="SELECT id, shout, uid, shtime FROM shoutsWHERE uid='".$who."' 
ORDER BY shtime DESC LIMIT $limit_start, $items_per_page
";
}
$items=mysql_query($sql);
$main.=mysql_error();
if(mysql_num_rows($items)>0){
while($item=mysql_fetch_array($items)){
$sex=mysql_fetch_array(mysql_query("SELECT sex FROM profiles WHERE uid='".$item[2]."'"));
if($sex[0]=="M"){$color="#0000FF";}
else if($sex[0]=="F"){$color="#FF0066";}
$main.="<a href=\"../profile.php?who=$item[2]&amp;sid=$sid\" style=\"color:$color;\">".getnick_uid($item[2])."</a>:<br/>
".date("d m y-H:i", $item[3])."<br/>
".getbbcode($item[1],$sid,1)."<br/>\n";
if(delshout(getuid_sid($sid),$item[0])){
$main.="<a href=\"./delete.php?delete=$item[0]&amp;sid=$sid\">
<img src=\"../images/error.gif\" alt=\"[x]\"/></a><br/>\n";
}
}
}
if($page>1){
$main.="<br/><a href=\"./history.php?page=".($page-1)."&amp;sid=$sid\">&lt;-Prev</a> ";
}
if($page<$num_pages){
if($page==1)$main.="<br/>";
$main.="<a href=\"./history.php?page=".($page+1)."&amp;sid=$sid\">Next-&gt;</a>\n";
}
$main.="<br/>Page - $page/$num_pages</p>\n";
if($num_pages>2){$main.=getjumper("history","who","$who",$sid);}
$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();
?>