if (defined('IN_PMBT'))die ("You can't include this file");
define("IN_PMBT",true);
include("header.php");

switch ($errid) {
        case 400: {
                header("HTTP/1.0 400 Bad request");
                bterror(str_replace("**email**",spellmail($admin_email),_http400errtxt),_http400errttl);
                break;
        }
        case 401: {
                header("HTTP/1.0 401 Access Denied");
                bterror(str_replace("**email**",spellmail($admin_email),_http401errtxt),_http401errttl);
                break;
        }
        case 403: {
                header("HTTP/1.0 403 Forbidden");
                bterror(str_replace("**email**",spellmail($admin_email),_http403errtxt),_http403errttl);
                break;
        }
        case 404: {
                header("HTTP/1.0 404 Access Denied");
                bterror(str_replace("**email**",spellmail($admin_email),_http404errtxt),_http404errttl);
                break;
        }
        case 500: {
                header("HTTP/1.0 500 Internal Server Error");
                bterror(str_replace("**email**",spellmail($admin_email),_http500errtxt),_http500errttl);
                break;
        }

}

include("footer.php");
?>

function getip() {
   if (isset($_SERVER)) {
     if (isset($_SERVER['HTTP_X_FORWARDED_FOR']) && validip($_SERVER['HTTP_X_FORWARDED_FOR'])) {
       $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
     } elseif (isset($_SERVER['HTTP_CLIENT_IP']) && validip($_SERVER['HTTP_CLIENT_IP'])) {
       $ip = $_SERVER['HTTP_CLIENT_IP'];
     } else {
       $ip = $_SERVER['REMOTE_ADDR'];
     }
   } else {
     if (getenv('HTTP_X_FORWARDED_FOR') && validip(getenv('HTTP_X_FORWARDED_FOR'))) {
       $ip = getenv('HTTP_X_FORWARDED_FOR');
     } elseif (getenv('HTTP_CLIENT_IP') && validip(getenv('HTTP_CLIENT_IP'))) {
       $ip = getenv('HTTP_CLIENT_IP');
     } else {
       $ip = getenv('REMOTE_ADDR');
     }
   }

   return $ip;
}

function getip() {
  $check = array('HTTP_X_FORWARDED_FOR', 'HTTP_X_FORWARDED',
                 'HTTP_FORWARDED_FOR', 'HTTP_FORWARDED',
                 'HTTP_VIA', 'HTTP_X_COMING_FROM', 'HTTP_COMING_FROM');

  foreach ($check as $c) {
    if (ip_valid(&$_SERVER[$c])) {
      return ip_first($_SERVER[$c]);
    }
  }

  return $_SERVER['REMOTE_ADDR'];
}
function ip_first($ips) {
  if (($pos = strpos($ips, ',')) != false) {
    return substr($ips, 0, $pos);
  } else {
    return $ips;
  }
}

function ip_valid($ips) {
  if (isset($ips)) {
    $ip    = ip_first($ips);
    $ipnum = ip2long($ip);
    if ($ipnum !== -1 && $ipnum !== false && (long2ip($ipnum) === $ip)) { // PHP 4 and PHP 5
      if (($ipnum < 167772160   || $ipnum >   184549375) && // Not in 10.0.0.0/8
          ($ipnum < -1408237568 || $ipnum > -1407188993) && // Not in 172.16.0.0/12
          ($ipnum < -1062731776 || $ipnum > -1062666241))   // Not in 192.168.0.0/16
        return true;
    }
  }
  return false;
}

$sql = "INSERT INTO ".$db_prefix."_users (username, clean_username, email, password, act_key, regdate" . $passkeyrow . ") VALUES ('".addslashes($username)."', '".strtolower($username)."', '".addslashes($email)."', '".md5($password)."', '".$act_key."', NOW(),'1')" . $passkey .");";

OpenTable(_btsignup);

/*$replace_markers = Array("**sitename**","**siteurl**","**username**","**password**","**key**");
$replace_data = Array ($sitename,$siteurl,$username,$password,md5($act_key));

$confirm_mail = New eMail;
$confirm_mail->sender = $admin_email;
$confirm_mail->subject = $userregconfirmmailsub[$language];
$confirm_mail->body = str_replace($replace_markers,$replace_data,$userregconfirmmailtext[$language]);
$confirm_mail->Add($email);
$confirm_mail->Send();

echo "<p>"._btregcomplete.spellmail($admin_email)."</p>";
*/
echo "<p>You have been registerd with this site Thank You </p>";

*/
echo "<p>You have been registerd with this site Thank You </p>";

CloseTable();

 SQL Error

Error Executing SQL Query SELECT * FROM gustaff_prt_users WHERE username =''LIMIT 1
Error ID: 1146
Error Message: Table 'gustaff_prt.gustaff_prt_users' doesn't exist

CREATE TABLE IF NOT EXISTS `torrent_userautodel` (
  `inactwarning_time` int(10) NOT NULL default '0',
  `autodel_users_time` int(10) NOT NULL default '0',
  `autodel_users` enum('true','false') NOT NULL default 'true'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `torrent_userautodel` (`inactwarning_time`, `autodel_users_time`, `autodel_users`) VALUES
(30, 10, 'false');
ALTER TABLE `torrent_users` ADD `inactwarning` TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE `torrent_users` ADD `inactive_warn_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';

if (!$row = $db->sql_fetchrow($configquery)) die("phpMyBitTorrent not correctly installed! Ensure you have run setup.php or config_default.sql!!");

$sql = "SELECT * FROM ".$db_prefix."_userautodel LIMIT 1;";

$userautodel = $db->sql_query($sql,BEGIN_TRANSACTION);

if (!$userautodel) die("Configuration not found! Make sure you have installed phpMyBitTorrent correctly.");
if (!$row3 = $db->sql_fetchrow($userautodel)) die("phpMyBitTorrent not correctly installed! Ensure you have run setup.php or config_default.sql!!");

$version = $row["version"];

$inactwarning_time = $row3["inactwarning_time"]*86400;
$autodel_users_time = $row3["autodel_users_time"]*86400;
$autodel_users = ($row3["autodel_users"] == "true") ? true : false;

        $db->sql_query("UPDATE ".$db_prefix."_torrents SET visible = 'no' WHERE type != 'link' AND tot_peer <= '".$down_limit."' AND UNIX_TIMESTAMP(last_action) < UNIX_TIMESTAMP(NOW()) - ".intval($dead_torrent_interval)." AND evidence != 1 AND (TRACKER IS NULL OR ".intval($autoscrape).");");
        $db->sql_query("UPDATE ".$db_prefix."_torrents SET visible = 'yes' WHERE tot_peer > '".$down_limit."';");

#prune users
if ($autodel_users)	
{
$userwarninactivesub = Array();
$userwarninactivesub[english] = "".$sitename." Warning";
$userwarninactivesub[german] = "".$sitename." Achtung";
$userwarninactivesub[spanish] = "Advertencia ".$sitename."";
$userwarninactivesub[brazilian] = "".$sitename." adverte";
$userwarninactivesub[portuguese] = "".$sitename." adverte";

$userwarninactivetext = Array();

$warntexten1 = "Hi,
we would like to warn you that you have not been active on **siteurl** for more than **inactwarning_time** days,
if you do not want to have your account deleted please login to it.
";
if ($autodel_users_time != 0)
{
$warntexten2 = "You have **autodel_users_time** days to log in from now. 
Otherwise we will delete your account permanently.";
}
else $warntexten2 = "";
$warntexten3 = "
Thanks **sitename** Admin
**siteurl**";
$userwarninactivetext[english] = "".$warntexten1.$warntexten2.$warntexten3."";


$warntextger1 = "Wir möchten darauf hinweisen , dass du auf **siteurl** seit mehr als **inactwarning_time** Tagen nicht mehr aktiv warst, 
wenn Du nicht willst, dass dein Account gelöscht wird, logge dich bitte ein. 
";
if ($autodel_users_time != 0)
{
$warntextger2 = "Du hast ab jetzt **autodel_users_time** Tage Zeit um dich auf **sitename** einzuloggen.
Ansonsten werden wir deinen Account permanent löschen.";
}
else $warntextger2 = "";
$warntextger3 = "
Danke**sitename**Admin.
**siteurl**";

$userwarninactivetext[german] = "".$warntextger1.$warntextger2.$warntextger3."";

$warntextspa1 = "Hola, 
Queriamos decirte que no visitaste nuestra pagina **siteurl** por mas de **inactwarning_time** dias.
Si no quieres que tu Cuenta sea borrada, por favor logueate. 
";
if ($autodel_users_time != 0)
{
$warntextspa2 = "Tienes **autodel_users_time** dias para loguearte nuevamente apartir de hoy.
De otra manera borraremos tu cuenta de forma permanente.";
}
else $warntextspa2 = "";
$warntextspa3 = "
Gracias. Los **sitename** administradores
**siteurl**";

$userwarninactivetext[spanish] = "".$warntextspa1.$warntextspa2.$warntextspa3."";

$warntextbra1 = "Oi,
Nós gostaríamos de avisa-lo que voce nao tem estado ativo no **siteurl** por mais de **inactwarning_time** dias.
Se voce nao quer ter sua conta excluída, por favor conecte-se. 
";
if ($autodel_users_time != 0)
{
$warntextbra2 = "Voce tem **autodel_users_time** dias a partir de hoje para fazer isso.
Caso contrário nós iremos apagar sua conta permanentemente.";
}
else $warntextbra2 = "";
$warntextbra3 = "
Obrigado **sitename** Administrador
**siteurl**";
$userwarninactivetext[brazilian] = "".$warntextbra1.$warntextbra2.$warntextbra3."";

$warntextpor1 = "Oi,
Nós gostaríamos de avisa-lo que voce nao tem estado ativo no **siteurl** por mais de **inactwarning_time** dias.
Se voce nao quer ter sua conta excluída, por favor conecte-se. 
";
if ($autodel_users_time != 0)
{
$warntextpor2 = "Voce tem **autodel_users_time** dias a partir de hoje para fazer isso.
Caso contrário nós iremos apagar sua conta permanentemente.";
}
else $warntextpor2 = "";
$warntextpor3 = "
Obrigado **sitename** Administrador
**siteurl**";

$userwarninactivetext[portuguese] = "".$warntextpor1.$warntextpor2.$warntextpor3."";

$sql = "SELECT id, email, inactwarning, lastlogin, language, ban FROM ".$db_prefix."_users WHERE ban != 1 AND inactwarning != 1 AND lastlogin != '0000-00-00 00:00:00' AND (UNIX_TIMESTAMP(lastlogin) < UNIX_TIMESTAMP(NOW()) - ".$inactwarning_time.") ;";
$res = $db->sql_query($sql)or btsqlerror($sql);
while ($get_info = $db->sql_fetchrow($res))
{
echo $get_info['id']."<br>";
logerror($get_info['id'].$get_info['email'].$get_info['inactwarning'].$get_info['lastlogin'], "prune time");
$replace_markers = Array("**sitename**","**siteurl**","**inactwarning_time**","**autodel_users_time**");
$replace_data = Array ("".$sitename."","".$siteurl."","".($inactwarning_time/86400)."","".($autodel_users_time/86400)."");
if ($get_info[language] == "") $get_info[language] = "english";
$warn_mail = new eMail;
$warn_mail->sender = $admin_email;
$warn_mail->subject = $userwarninactivesub[$get_info[language]];
$warn_mail->body = str_replace($replace_markers,$replace_data,$userwarninactivetext[$get_info[language]]);
$warn_mail->Add($get_info['email']);
$warn_mail->Send();
}
}
$db->sql_query("UPDATE ".$db_prefix."_users SET inactwarning = 0, inactive_warn_time = '0000-00-00 00:00:00' WHERE inactwarning = 1 AND (UNIX_TIMESTAMP(lastlogin) > UNIX_TIMESTAMP(NOW()) - ".$inactwarning_time.");");
$up_warn = "UPDATE ".$db_prefix."_users SET inactwarning = 1, inactive_warn_time = NOW() WHERE ((UNIX_TIMESTAMP(lastlogin) < UNIX_TIMESTAMP(NOW()) - ".$inactwarning_time.") AND ban != 1 AND lastlogin != '0000-00-00 00:00:00');";
$db->sql_query($up_warn)or btsqlerror($up_warn);

        if ($autoscrape) multiscrape();
autoclean();

if ($autodel_users)
{
    $sql = "SELECT id FROM ".$db_prefix."_users WHERE inactwarning = 1 AND (UNIX_TIMESTAMP(inactive_warn_time) < UNIX_TIMESTAMP(NOW()) - ".$autodel_users_time.") AND inactwarning = 1;";
    $res = $db->sql_query($sql);
    while ($row = $db->sql_fetchrow($res))
    {
     removedinactive($row['id']);
    }
}

function ratingpic($num) {//Gets the correct star rating picture
        $r = round($num * 2) / 2;
        if ($r < 1 OR $r > 5) return;
        return pic($r."-rating.png");
}

function removedinactive($uid){
                        global $db, $db_prefix, $forumshare;
                        $sql = "SELECT username FROM ".$db_prefix."_users WHERE id = '".$uid."';";
                        $res = $db->sql_query($sql);
                        list ($username) = $db->sql_fetchrow($res);
                        $db->sql_freeresult($res);
                        if (empty($username)) return;
                        $sql = "SELECT avatar FROM ".$db_prefix."_users WHERE id = '".$uid."';";
                        $res = $db->sql_query($sql);
                        list ($avatar) = $db->sql_fetchrow($res);
                        $db->sql_freeresult($sql);
                        if (eregi("^user/",$avatar)) @unlink($avatar);
						if($forumshare AND get_user_forum_name($username)>=2)forum_delete($uid, $username);                        
                        $sql = Array();
                        $sql[] = "DELETE FROM ".$db_prefix."_tickets WHERE user = '".$uid."';";
                        $sql[] = "DELETE FROM ".$db_prefix."_snatched WHERE userid = '".$uid."';";
                        $sql[] = "DELETE FROM ".$db_prefix."_shouts WHERE user = '".$uid."';";
                        $sql[] = "DELETE FROM ".$db_prefix."_download_completed WHERE user = '".$uid."';";
                        $sql[] = "DELETE FROM ".$db_prefix."_privacy_backup WHERE master = '".$uid."' OR slave = '".$uid."';";
                        $sql[] = "DELETE FROM ".$db_prefix."_privacy_file WHERE master = '".$uid."' OR slave = '".$uid."';";
                        $sql[] = "DELETE FROM ".$db_prefix."_privacy_global WHERE master = '".$uid."' OR slave = '".$uid."';";
                        $sql[] = "DELETE FROM ".$db_prefix."_comments_notify WHERE user = '".$uid."';";
                        $sql[] = "DELETE FROM ".$db_prefix."_seeder_notify WHERE user = '".$uid."';";
                        $sql[] = "DELETE FROM ".$db_prefix."_online_users WHERE id = '".$uid."';";
                        $sql[] = "UPDATE ".$db_prefix."_torrents SET owner = '0', ownertype = '2' WHERE owner = '".$uid."';";
                        $sql[] = "UPDATE ".$db_prefix."_peers SET uid = '0' WHERE uid = '".$uid."';";
                        $sql[] = "DELETE FROM ".$db_prefix."_private_messages_blacklist WHERE master = '".$uid."' OR slave = '".$uid."';";
                        $sql[] = "DELETE FROM ".$db_prefix."_private_messages_bookmarks WHERE master = '".$uid."' OR slave = '".$uid."';";
                        $sql[] = "DELETE FROM ".$db_prefix."_private_messages WHERE recipient = '".$uid."';";
                        $sql[] = "DELETE FROM ".$db_prefix."_users WHERE id = '".$uid."';";

                        foreach ($sql as $query) {
                                $db->sql_query($query) or btsqlerror($sql);
                        }
} 

ALTER TABLE `torrent_users`  ADD `birthday` varchar(20) character set utf8 collate utf8_bin default NULL,

if ($user->user) {
OpenTable("Youtube");

	?>
	<style type="text/css">

	#marqueecontainer{
	position: relative;
	/*width: 200px; marquee width */
	height: 500px; /*marquee height */
	background-color: transparent;
	overflow: hidden;
	border: 3px solid lightblue;*/
	padding: 2px;
	padding-left: 4px;
	}

	</style>

	<script type="text/javascript">

	/***********************************************
	* Cross browser Marquee II- © Dynamic Drive (www.dynamicdrive.com)
	* This notice MUST stay intact for legal use
	* Visit http://www.dynamicdrive.com/ for this script and 100s more.
	***********************************************/

	var delayb4scroll=1000 //Specify initial delay before marquee starts to scroll on page (2000=2 seconds)
	var marqueespeed=2 //Specify marquee scroll speed (larger is faster 1-10)
	var pauseit=1 //Pause marquee onMousever (0=no. 1=yes)?

	////NO NEED TO EDIT BELOW THIS LINE////////////

	var copyspeed=marqueespeed
	var pausespeed=(pauseit==0)? copyspeed: 0
	var actualheight=''

	function scrollmarquee(){
	if (parseInt(cross_marquee.style.top)>(actualheight*(-1)+8))
	cross_marquee.style.top=parseInt(cross_marquee.style.top)-copyspeed+"px"
	else
	cross_marquee.style.top=parseInt(marqueeheight)+8+"px"
	}

	function initializemarquee(){
	cross_marquee=document.getElementById("vmarquee")
	cross_marquee.style.top=0
	marqueeheight=document.getElementById("marqueecontainer").offsetHeight
	actualheight=cross_marquee.offsetHeight
	if (window.opera || navigator.userAgent.indexOf("Netscape/7")!=-1){ //if Opera or Netscape 7x, add scrollbars to scroll and exit
	cross_marquee.style.height=marqueeheight+"px"
	cross_marquee.style.overflow="scroll"
	return
	}
	setTimeout('lefttime=setInterval("scrollmarquee()",30)', delayb4scroll)
	}

	if (window.addEventListener)
	window.addEventListener("load", initializemarquee, false)
	else if (window.attachEvent)
	window.attachEvent("onload", initializemarquee)
	else if (document.getElementById)
	window.onload=initializemarquee


	</script>

	<div id="marqueecontainer" onMouseover="copyspeed=pausespeed" onMouseout="copyspeed=marqueespeed">
	<div id="vmarquee" style="position: absolute; width: 100%;">

	<!--YOUR SCROLL CONTENT HERE-->
	<?php
        
$query = "SELECT * FROM ".$db_prefix."_youtubevideo ORDER BY addtime";
$sql = $db->sql_query($query);
echo"<table border=\"1\">\n<tr>";
while ($row = $db->sql_fetchrow($sql)) {
$link = str_replace("http://youtube.com/v/","",$row["link"]);
$name = $row['name'];
echo"<center><a href=\"".$siteurl."/youtube.php?op=show&amp;video=".$row["link"]."\"><img title=\"".$name."\" src=\"http://i3.ytimg.com/vi/".$link."/default.jpg\" class=\"vimg120\" qlicon=\"".$link."\" alt=\"".$name."\"></a><br><p>$name</p>\n</BR></center>\n";
}
echo"</tr>\n</table>\n";
CloseTable();
}

OpenTable(IMDB);
?>

	<CENTER>
   <form action="http://imdb.com/find" method="get" target="_blank" >
  <input name="q" size="15" value="">
  <br>
  <select name="s">
    <option value="all" selected>All</option>
    <option value="tt">Titles</option>
    <option value="ep">TV Episodes</option>
    <option>My Movies</option>
    <option value="nm">Names</option>
    <option value="co">Companies</option>
    <option value="kw">Keywords</option>
    <option value="char">Characters</option>
    <option>Quotes</option>
    <option>Bios</option>
    <option>Plots</option>
  </select><br> 
    <input type="image"  id="nb15go_image"  src="images/icon_imdb.gif" width="40" height="20" alt="go" value="go" title="go">
   </form>
</CENTER>

<?php
CoseTable();

OpenTable(MediaPlayer);
echo "<center>\n";
echo "<object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" codebase=\"http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0\" width=\"150\" height=\"141\" id=\"clock\" align=\"middle\">\n";
echo "<param name=\"movie\" value=\"mp3/player.swf\" />\n";
echo "<param name=\"quality\" value=\"high\" />\n";
echo "<param name=\"scale\" value=\"exactfit\" />\n";
echo "<param name=\"wmode\" value=\"transparent\" />\n";
echo "<param name=\"menu\" value=\"false\">\n";
echo "<embed src=\"mp3/player.swf\" quality=\"high\" scale=\"exactfit\" wmode=\"transparent\" width=\"150\" height=\"141\" name=\"clock\" align=\"middle\" type=\"application/x-shockwave-flash\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" />\n";
echo "</object>\n";
CloseTable();

if ($user->user) {
OpenTable(MediaPlayer);
echo "<center>\n";
echo "<object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" codebase=\"http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0\" width=\"150\" height=\"141\" id=\"clock\" align=\"middle\">\n";
echo "<param name=\"movie\" value=\"mp3/player.swf\" />\n";
echo "<param name=\"quality\" value=\"high\" />\n";
echo "<param name=\"scale\" value=\"exactfit\" />\n";
echo "<param name=\"wmode\" value=\"transparent\" />\n";
echo "<param name=\"menu\" value=\"false\">\n";
echo "<embed src=\"mp3/player.swf\" quality=\"high\" scale=\"exactfit\" wmode=\"transparent\" width=\"150\" height=\"141\" name=\"clock\" align=\"middle\" type=\"application/x-shockwave-flash\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" />\n";
echo "</object>\n";
CloseTable();
}

<?php

include("header.php");

OpenTable("Guide to Making Win RAR files
");
?><center>
<table class=main width=750 border=0 cellspacing=0 cellpadding=0><tr><td class=embedded>
<h2>Guide to Making Win RAR files
</h2>
<table width=100% border=1 cellspacing=0 cellpadding=10><tr><td class=text>
<p>Guide to Making Win RAR files.</p>
<ol>
<li>Download Winrar from here: '<a href=PATH TO WINRAR HERE/ target=_blank>WINRAR</a>'.</li>
<li>First find the file you want to RAR in window explorer.
.</li>
<li>Then right click and choose add to archive.</li>
<li>Next you want to choose "Store" in the compression method box.</li>
<li>In the split to volumes, bytes enter the following</li>
<li>50.000000 for DVD (files over 1.5 gig).</li>
<li>15.000000 for Music (files under 1.5 gig).</li>
Now this is important.
<li>Click the advance tab. Make sure you place a check in old style volume names.</li>
<li>This will make sure that each RAR files ends in r00, r01, r02 ect... Instead of part001, part002, ect...</li>
<li>That's it. It will then create the RAR files ready for torrent making.</li>
</td></tr></table>
</td></tr></table>
<?
CloseTable();

include("footer.php");
?>

print("<p>Seeding Bonus: <a href='mybonus.php'>".$seedbonus."</a></p>");

echo "<br />\n"; 
        print("<p>Transfer Bonus: <a href='bonus_transfer.php'>here</a></p>");

<?
error_reporting(E_ALL & ~E_NOTICE); 
include("header.php");
if(!$user->admin)loginrequired("admin");
define('THIS_SCRIPT', 'admin_pms');
define('HACK_TITLE', 'Dream\'s Read PMs');  
define('MIN_SEARCH_WORD_LENGTH', '4');
function fetch_row_bgclass()
{
// returns the current alternating class for <TR> rows in the CP.
	global $bgcounter;
	return ($bgcounter++ % 2) == 0 ? 'alt1' : 'alt2';
}
function htmlspecialchars_uni($text, $entities = true)
{
	return str_replace(
		// replace special html characters
		array('<', '>', '"'),
		array('&lt;', '&gt;', '&quot;'),
		preg_replace(
			// translates all non-unicode entities
			'/&(?!' . ($entities ? '#[0-9]+|shy' : '(#[0-9]+|[a-z]+)') . ';)/si',
			'&amp;',
			$text
		)
	);
}
function print_table_start($echobr = true, $width = '90%', $cellspacing = 0, $id = '', $border_collapse = false)
{
	global $tableadded;

	$tableadded = 1;

	if ($echobr)
	{
		echo '<br />';
	}

	$id_html = ($id == '' ? '' : " id=\"$id\"");

	echo "\n<table cellpadding=\"4\" cellspacing=\"$cellspacing\" border=\"0\" align=\"center\" width=\"$width\" style=\"border-collapse:" . ($border_collapse ? 'collapse' : 'separate') . "\" class=\"tborder\"$id_html>\n";
}
function print_form_header($phpscript = '', $do = '', $uploadform = false, $addtable = true, $name = 'cpform', $width = '90%', $target = '', $echobr = true, $method = 'post', $cellspacing = 0, $border_collapse = false)
{
	global $vbulletin, $tableadded;

	if (($quote_pos = strpos($name, '"')) !== false)
	{
		$clean_name = substr($name, 0, $quote_pos);
	}
	else
	{
		$clean_name = $name;
	}

	echo "<form action=\"$phpscript.php?do=$do\"" . iif($uploadform, ' enctype="multipart/form-data"') . " method=\"$method\"" . iif($target, " target=\"$target\"") . " name=\"$clean_name\" id=\"$name\">\n";

	//construct_hidden_code('do', $do);
	echo "<input type=\"hidden\" name=\"do\" value=\"" . htmlspecialchars_uni($do) . "\" />\n";

	if ($addtable)
	{
		print_table_start($echobr, $width, $cellspacing, $clean_name . '_table', $border_collapse);
	}
	else
	{
		$tableadded = 0;
	}
}
// grab the counts of all users that have PMs
function rpm_get_pm_users($totalpms)
{
	global $db, $db_prefix;
	$res ="SELECT COUNT(`pm`.`recipient`) AS total, `pm`.`sender`, `pm`.`recipient`, `user`.`username`, `user`.`id` AS `userid` FROM `torrent_private_messages` AS `pm` INNER JOIN `torrent_users` AS `user` ON (`pm`.`recipient` = `user`.`id`) WHERE `pm`.`recipient` = `user`.`id` GROUP BY  `pm`.`recipient` HAVING total = " . $totalpms . " ORDER BY  `pm`.`recipient` DESC ";
	$pms=$db->sql_query($res) or btsqlerror($res);
	return $pms;
}
function rpm_print_footer()
{
}
function rpm_get_all_pm_users()
{
	global $db, $db_prefix;
	$totals = $db->sql_query("
		SELECT COUNT(*) AS total
		FROM `" . $db_prefix . "_private_messages`
		GROUP BY `recipient`
		ORDER BY total DESC
	");
	return $totals;
}
function rpm_get_pm($pmtextid)
{
	global $db, $db_prefix;
	$get_pm = $db->sql_fetchrow($db->sql_query("
		SELECT *
		FROM `" . $db_prefix . "_private_messages`
		WHERE `id` = " . $pmtextid . "
	"));
	return $get_pm;
}
function print_description_row($text, $htmlise = false, $colspan = 2, $class = '', $align = '', $helpname = NULL)
{
	global $stylevar;

	if (!$class)
	{
		$class = fetch_row_bgclass();
	}


	echo "<tr valign=\"top\">
	<td class=\"$class\"" . iif($colspan != 1," colspan=\"$colspan\"") . iif($align, " align=\"$align\"") . ">" . iif($htmlise, htmlspecialchars_uni($text), $text) . "</td>\n</tr>\n";
}
function iif($expression, $returntrue, $returnfalse = '')
{
	return ($expression ? $returntrue : $returnfalse);
}
function print_table_header($title, $colspan = 2, $htmlise = false, $anchor = '', $align = 'center', $helplink = true)
{
	global $bgcounter, $stylevar;

	if ($htmlise)
	{
		$title = htmlspecialchars_uni($title);
	}
	$title = "<b>$title</b>";
	if ($anchor != '')
	{
		$title = "<a name=\"$anchor\">$title</a>";
	}

	echo "<tr>\n\t<td class=\"tcat\" align=\"$align\"" . iif($colspan != 1, " colspan=\"$colspan\"") . ">$title</td>\n</tr>\n";

	$bgcounter = 0;
}
function rpm_user_exists($userid)
{
	global $db;
	$exists = $db->sql_fetchrow($db->sql_query("
		SELECT `id`
		FROM `torrent_users`
		WHERE `id` = " . $userid . "
	"));
	if ($exists)
	{
		return true;
	}
	else
	{
		return false;
	}
}
function print_table_footer($colspan = 2, $rowhtml = '', $tooltip = '', $echoform = true)
{
	global $tableadded, $vbulletin;

	if ($rowhtml)
	{
		$tooltip = iif($tooltip != '', " title=\"$tooltip\"", '');
		if ($tableadded)
		{
			echo "<tr>\n\t<td class=\"tfoot\"" . iif($colspan != 1 ," colspan=\"$colspan\"") . " align=\"center\"$tooltip>$rowhtml</td>\n</tr>\n";
		}
		else
		{
			echo "<p align=\"center\"$tooltip>$extra</p>\n";
		}
	}

	if ($tableadded)
	{
		echo "</table>\n";
	}

	if ($echoform)
	{

		echo "</form>\n\n\n";
	}
}
function rpm_username_exists($username)
{
	global $db, $db_prefix;
	$exists = $db->sql_fetchrow($db->sql_query("
		SELECT `id`
		FROM `" . $db_prefix . "_users`
		WHERE LOWER(`username`) = LOWER('" . $username . "')
	"));
	if ($exists)
	{
		return $exists['id'];
	}
	else
	{
		return false;
	}
}
function rpm_get_name($userid)
{
	global $db, $db_prefix;
	$result = $db->sql_fetchrow($db->sql_query("
		SELECT `username`
		FROM `" . $db_prefix . "_users`
		WHERE `id` = " . $userid . "
	"));
	return $result['username'];
}
// search for PMs that match key search terms
function rpm_search_pms($search_for, $match)
{
	global $db, $db_prefix;
	if ($match == 'exact')
	{
		$sql = "SELECT DISTINCT `id`, `subject`, `sent`
			FROM `" . $db_prefix . "_private_messages` 
			WHERE `text` LIKE '%" . $search_for . "%'
			ORDER BY `sent` DESC";
	}
	elseif ($match == 'all')
	{
		$a = explode(' ', $search_for);
		$ands = implode("%' AND `message` LIKE '%", $a);
		$sql = "SELECT DISTINCT `id`, `subject`, `sent`
			FROM `" . $db_prefix . "_private_messages`
			WHERE `text` LIKE '%" . $ands . "%'
			ORDER BY `sent` DESC";
	}
	else
	{
		$a = explode(' ', $search_for);
		$ors = implode("%' OR `text` LIKE '%", $a);
		$sql = "SELECT DISTINCT `id`, `subject`, `sent`
			FROM `" . $db_prefix . "_private_messages`
			WHERE `text` LIKE '%" . $ors . "%' 
			ORDER BY `sent` DESC";
	}
	
	$result = $db->sql_query($sql);
	$pms = array();
	while($array = $db->sql_fetchrow($result))
	{
		$pms[] = $array;
	}
$db->sql_freeresult($result);
	return $pms;
}
function rpm_get_latest_pms($limit_by)
{
	global $db, $db_prefix;
	$res = "
		SELECT *
		FROM `" . $db_prefix . "_private_messages`
		ORDER BY `sent` DESC
		LIMIT 0, " . $limit_by . "
	";
	$result = $db->sql_query($res) or btsqlerror($res);
	$pms = array();
	while($array = $db->sql_fetchrow($result))
	{
		$pms[] = $array;
	}
$db->sql_freeresult($result);
	return $pms;
}
function rpm_get_pms($userid)
{
	global $db, $db_prefix;
	$res = "
		SELECT 	*
		FROM `" . $db_prefix . "_private_messages` AS pm
		WHERE pm.sender=" . $userid . " OR pm.recipient=" . $userid . "
		ORDER BY `sent` DESC
	";
	$result = $db->sql_query($res) or btsqlerror($res);
	$pms = array();
	while($array = $db->sql_fetchrow($result))
	{
		$pms[] = $array;
	}
$db->sql_freeresult($result);
	return $pms;
}
function print_cells_row($array, $isheaderrow = false, $class = false, $i = 0, $valign = 'top', $column = false, $smallfont = false)
{
	global $colspan, $bgcounter, $stylevar;

	if (is_array($array))
	{
		$colspan = sizeof($array);
		if ($colspan)
		{
			$j = 0;
			$doecho = 0;

			if (!$class AND !$column AND !$isheaderrow)
			{
				$bgclass = fetch_row_bgclass();
			}
			elseif ($isheaderrow)
			{
				$bgclass = 'thead';
			}
			else
			{
				$bgclass = $class;
			}

			$bgcounter = iif($column, 0, $bgcounter);
			$out = "<tr valign=\"$valign\" align=\"center\">\n";

			foreach($array AS $key => $val)
			{
				$j++;
				if ($val == '' AND !is_int($val))
				{
					$val = '&nbsp;';
				}
				else
				{
					$doecho = 1;
				}

				if ($i++ < 1)
				{
					$align = " align=\"$stylevar[left]\"";
				}
				elseif ($j == $colspan AND $i == $colspan AND $j != 2)
				{
					$align = " align=\"$stylevar[right]\"";
				}
				else
				{
					$align = '';
				}

				if (!$class AND $column)
				{
					$bgclass = fetch_row_bgclass();
				}
				if ($smallfont)
				{
					$val = "<span class=\"smallfont\">$val</span>";
				}
				$out .= "\t<td" . iif($column, " class=\"$bgclass\"", " class=\"$bgclass\"") . "$align>$val</td>\n";
			}

			$out .= "</tr>\n";

			if ($doecho)
			{
				echo $out;
			}
		}
	}
}
function print_label_row($title, $value = '&nbsp;', $class = '', $valign = 'top', $helpname = NULL, $dowidth = false)
{
	global $stylevar;

	if (!$class)
	{
		$class = fetch_row_bgclass();
	}

	if ($helpname !== NULL AND $helpbutton = construct_table_help_button($helpname))
	{
		$value = '<table cellpadding="0" cellspacing="0" border="0" width="100%"><tr valign="top"><td>' . $value . "</td><td align=\"$stylevar[right]\" style=\"padding-$stylevar[left]:4px\">$helpbutton</td></tr></table>";
	}

	if ($dowidth)
	{
		if (is_numeric($dowidth))
		{
			$left_width = $dowidth;
			$right_width = 100 - $dowidth;
		}
		else
		{
			$left_width = 70;
			$right_width = 30;
		}
	}

	echo "<tr valign=\"$valign\">
	<td class=\"$class\"" . ($dowidth ? " width=\"$left_width%\"" : '') . ">$title</td>
	<td class=\"$class\"" . ($dowidth ? " width=\"$right_width%\"" : '') . ">$value</td>\n</tr>\n";
}
function rpm_print_stop_back($text = 'error')
{
	global $vbphrase;
	echo '<p>&nbsp;</p><p>&nbsp;</p>';
	print_form_header('', '', 0, 1, 'messageform', '65%');
	print_table_header($vbphrase['vbulletin_message']);
	print_description_row("<blockquote><br />$text<br /><br /></blockquote>");
	print_table_footer(2, '<input class="button" value="Go Back" title="" tabindex="1" onclick="window.location=\'javascript:history.back(1)\';" type="button">');
	rpm_print_footer();
}

// ####################### LIST USERS WITH X AMOUNT OF PMs ##########################
if ( $_REQUEST['do'] == 'havepms' )
{
	// grab list of users that have PMs
	$havepms = rpm_get_pm_users($_REQUEST['totalpms']);

	// if there are no PMs
	if (!$db->sql_numrows($havepms))
	{
		rpm_print_stop_back('There are no PMs.');
		die();
	}

	// show the list
	OpenTable(HACK_TITLE . ' - List Users With ' . $_REQUEST['totalpms'] . ' PMs');
	print_form_header('', '', 0, 1, 'havepmsForm');
	print_table_header('List of users with ' . $_REQUEST['totalpms'] . ' PMs');
	while($pms = $db->sql_fetchrow($havepms))
	{
		$link1 = THIS_SCRIPT . '.php?do=list&userid=' . $pms['userid'];
		$link2 = 'pm.php?op=send&to=' . $pms['userid'];
		$link3 = 'user.php?op=editprofile&id=' . $pms['userid'];
		$row = '<span style="float:right">[<a href="' . $link1 . '">Show All PMs</a>] ';
		$row .= '[<a href="' . $link2 . '">Send PM to User</a>] ';
		$row .= '[<a href="' . $link3 . '">Edit User</a>]</span>';
		$row .= '<b>' . $pms['username'] . '</b>';
		print_description_row($row);
	}
	print_table_footer(2, '<input class="button" value="Go Back" title="" tabindex="1" onclick="window.location=\'javascript:history.back(1)\';" type="button">');
	CloseTable();
}
// ####################### LIST ALL USERS WITH PMs ##########################
if ($_REQUEST['do'] == 'allusershavepms')
{
	// get array of PM counts
	$pmcounts = rpm_get_all_pm_users();
	//die(print_r($pmcounts));

	print_form_header('', '', 0, 1, 'allusershavepmsForm');
	print_table_header('List Users With PMs');

	// assign the counts
	$pmtotals = array();
	while ($currentpmcount = $db->sql_fetchrow($pmcounts))
	{
		$pmtotals["$currentpmcount[total]"]++;
	}
	// construct & display the rows
	foreach ($pmtotals AS $pmtotal => $totalusers)
	{
		if ($totalusers != 1)
		{
			$usertext = 'There are ' . $totalusers .' users';
		}
		else
		{
			$usertext = 'There is ' . $totalusers .' user';
		}
		$link = THIS_SCRIPT . '.php?do=havepms&totalpms=' . $pmtotal;
		$row = '<span style="float:right">[<a href="' . $link . '">List All Users</a>]</span>';
		$row .= $usertext . ' with ' . $pmtotal . ' PMs' ;
		print_description_row($row);
	}
	print_table_footer(2, '<input class="button" value="Go Back" title="" tabindex="1" onclick="window.location=\'javascript:history.back(1)\';" type="button">');
}
// ############################# READ PMs #################################
if ($_REQUEST['do'] == 'list')
{
	// if no userid or username entered
	if (empty($_REQUEST['userid']))
	{
		print('You need to enter a User ID or Username.');
	}
	
	// if it is a username
	if (!is_numeric($_REQUEST['userid']))
	{
		// check the username exists and assign it
		$userid = rpm_username_exists($_REQUEST['userid']);
		
		// if username does not exist
		if (empty($userid))
		{
			print('User <b>' . $_REQUEST['userid'] . '</b> does not exist.' . $userid);
			die();
		}
	}
	else // if userid
	{
		// if userid does not exist
		if (!rpm_user_exists($_REQUEST['userid']))
		{
			print('User ID: <b>' . $_REQUEST['userid'] . '</b> does not exist.');
			die();
		}
		
		// assign the userid
		$userid = $_REQUEST['userid'];
	}
	
	// get all PMs for the user
	$pms = rpm_get_pms($userid);
	
	// if there are no PMs
	if (empty($pms))
	{
		print('User <b>' . $_REQUEST['userid'] . '</b> has no PMs.');
		die();
	}
	
	// get the username
	$name = rpm_get_name($userid);
	
	// seperate sent and recieved PMs
	$sent = array();
	$received = array();
	foreach ($pms AS $pm)
	{
		// seperate sent and recieved PMs (also takes into account user sending to self via to or bcc)
		if ($pm['sender'] == $userid)
		{
			$sent[] = $pm;
		}
		else
		{
			$received[] = $pm;
		}
	}
	
	// display list of sent PMs
	print_form_header('', '', 0, 1, 'sentpmlistForm');
	print_table_header(count($sent) . ' PMs sent from ' . $name . ' (Userid: ' . $userid . ')', 4);
	if (empty($sent))
	{
		print_description_row('<center>There are no sent PMs to view.</center>');
	}
	else
	{
		print_cells_row(array('pmtextid', 'PM Title', 'Date', ''), 1);
		foreach ($sent AS $pm)
		{
			$date = $pm['sent'];
			$link = THIS_SCRIPT . '.php?do=read&pmtextid=' . $pm['id'];
			$row = array();
			$row[] = '<div class="smallfont">' . $pm['id'] . '</div>';
			$row[] = '<div class="smallfont"><span style="float:left">' . $pm['subject'] . '</span></div>';
			$row[] = '<div class="smallfont">' . $date . '';
			$row[] = '<div class="smallfont">[<a href="' . $link . '">View Private Message</a>]</div>';
			print_cells_row($row);
		}
	}	
	print_table_footer(4, '<input class="button" value="Go Back" title="" tabindex="1" onclick="window.location=\'javascript:history.back(1)\';" type="button">');
	
	// display list of recieved PMs
	print_form_header('', '', 0, 1, 'receivedpmlistForm');
	print_table_header(count($received) . ' PMs recieved for ' . $name . ' (Userid: ' . $userid . ')', 5);
	if (empty($received))
	{
		print_description_row('<center>There are no recieved PMs to view.</center>');
	}
	else
	{
		print_cells_row(array('pmtextid', 'PM Title', 'From', 'Date', ''), 1);
		foreach ($received AS $pm)
		{
			$date = $pm['sent'];
			$link = THIS_SCRIPT . '.php?do=read&pmtextid=' . $pm['id'];
			$row = array();
			$row[] = '<div class="smallfont">' . $pm['id'] . '</div>';
			$row[] = '<div class="smallfont"><span style="float:left">' . $pm['subject'] . '</span></div>';
			$row[] = '<div class="smallfont">' . $pm['sender'] . '</div>';
			$row[] = '<div class="smallfont">' . $date . '';
			$row[] = '<div class="smallfont">[<a href="' . $link . '">View Private Message</a>]</div>';
			print_cells_row($row);
		}
	}
	print_table_footer(5, '<input class="button" value="Go Back" title="" tabindex="1" onclick="window.location=\'javascript:history.back(1)\';" type="button">');
}
if ($_REQUEST['do'] == 'read')
{
	// no pmtextid
	if (empty($_REQUEST['pmtextid']))
	{
		print('Need a pmtextid.');
		die();
	}
	
	// if pmtext is not a number or number < 1
	if (!is_numeric($_REQUEST['pmtextid']) OR $_REQUEST['pmtextid'] < 1)
	{
		print('Pmtextid must be a positive number.');
		die();
	}
	
	// get the requested PM
	$pm = rpm_get_pm($_REQUEST['pmtextid']);
	
	// PM does not exist
	if (empty($pm))
	{
		print('Pmtextid <b>' . $_REQUEST['pmtextid'] . '</b> does not exist.');
		die();
	}
	
	// get all userids for the users that still have the PM with pmtextid
	$userids = $db->sql_fetchrow($db->sql_query("
		SELECT DISTINCT `sender`
		FROM `".$db_prefix."_private_messages`
		WHERE `id` = " . $_REQUEST['pmtextid'] . "
	"));
	
	// If there are no userids then the PM does not exist (this handles the last x PMs)
	if (empty($userids))
	{
		print('
			<center>Pmtextid <b>' . $_REQUEST['pmtextid'] . '</b> has been deleted and can not be recovered.
			<br />The non-existant entry will be automatically removed within the hour by the
			<br /><b>Hourly Cleanup #2</b> scheduled task.</center>
		');
		die();
	}
	
	// grab array of to and bcc users
	//$toarray = array_values(unserialize($pm['touserarray']));

	// convert date to readable format
	$date = $pm['sent'];
	
	// show PM contents
	print_form_header('', '', 0, 1, 'pmlistForm');
	print_table_header('Private Message Text ID : ' . $pm['id'],2);
	print_label_row('<b>From:</b></b><dfn>Link goes to users Details.</dfn>', $pm['sender'] . ' (<a href = "user.php?op=profile&id=' . $pm['sender'] . '">userid: ' . $pm['sender'] . '</a>)');
	if (is_array($toarray[0]))
	{
		print_label_row('<b>To:</b><dfn>Link(s) goes to users Details.</dfn>' , rpm_display_recipients_with_links($toarray[0]));
	}
	if (is_array($toarray[1]))
	{
		print_label_row('<b>BCC:</b></b><dfn>Link(s) goes to users Details.</dfn>' , rpm_display_recipients_with_links($toarray[1]));
	}
	print_label_row('<b>PM Title:</b>', $pm['subject']);
	print_label_row('<b>Date:</b>', $date);
	
								$message = format_comment($pm['text'], false, true);
                                parse_smiles($message);
	print_label_row('<b>Message:', '<div class="smallfont">' . $message . '</div>');
	print_table_footer(2, '<input class="button" value="Go Back" title="" tabindex="1" onclick="window.location=\'javascript:history.back(1)\';" type="button">');
}
// ############################### SEARCH #################################
if ($_REQUEST['do'] == 'search')
{
	// if no search terms have been entered
	if (empty($_REQUEST['search']))
	{
		rpm_print_stop_back('You must type in at least one word to search for.');
	}
	// assign and make search terms safe
	$search_for = $_REQUEST['search'];
	
	// see if any of the search terms is lower than the minimum length 
	$words = explode(" ", $search_for);
	foreach ($words AS $current)
	{
		if (strlen($current) < MIN_SEARCH_WORD_LENGTH)
		{
			rpm_print_stop_back('At least one of your search terms was less than ' . MIN_SEARCH_WORD_LENGTH .' characters long.');
		}
	}
	
	// assign the type of match
	$match = $_REQUEST['match'];
	
	// conduct the search
	$pms = rpm_search_pms($search_for, $match);
	
	// format search words for display purposes
	switch ($match)
	{
		case 'exact':
			$search_words = str_replace(" ", " + ", $search_for);
			$search_wording = 'the exact text';
			break;

		case 'all':
			$search_words = str_replace(" ", " and ", $search_for);
			$search_wording = 'all of the following words';
			break;

		case 'atleastone':
			$search_words = str_replace(" ", " or ", $search_for);
			$search_wording = 'at least one of the following words';
			break;
	}

	// display list of PMs found
	print_form_header('', '', 0, 1, 'pmlistForm');
	print_table_header('Search Results for ' . $search_wording . ': ' . $search_words . '', 4);
	if (empty($pms))
	{
		print_description_row('<center>There are no results to view for the search text.</center>');
	}
	else
	{
		print_cells_row(array('pmtextid', 'PM Title', 'Date', ''), 1);
		foreach ($pms AS $pm)
		{
			$date = $pm['sent'];
			$link = THIS_SCRIPT . '.php?do=read&pmtextid=' . $pm['id'];
			$row = array();
			$row[] = '<div class="smallfont">' . $pm['id'] . '</div>';
			$row[] = '<div class="smallfont"><span style="float:left">' . $pm['subject'] . '</span></div>';
			$row[] = '<div class="smallfont">' . $date . '';
			$row[] = '<div class="smallfont">[<a href="' . $link . '">View Private Message</a>]</div>';
			print_cells_row($row);
		}
	}
	print_table_footer(4, '<input class="button" value="Go Back" title="" tabindex="1" onclick="window.location=\'javascript:history.back(1)\';" type="button">');
}

// ########################### LATEST X PMs ###############################
if ($_REQUEST['do'] == 'latest')
{
	// if nothing entered or zero entered
	if (empty($_REQUEST['showlatest']))
	{
		rpm_print_stop_back('Enter a positive number greater than 0.');
	}

	// if non-numeric or negative number entered
	if (!is_numeric($_REQUEST['showlatest']) OR $_REQUEST['showlatest'] < 1)
	{
		rpm_print_stop_back('Enter a positive number greater than 0.');
	}
	
	// get the PM list
	$pms = rpm_get_latest_pms($_REQUEST['showlatest']);
	
	// if no PMs
	if (empty($pms))
	{
		rpm_print_stop_back('There are no PMs to view.');
	}
	
	// display PM list
	print_form_header('', '', 0, 1, 'pmlistForm');
	print_table_header('Show Last ' . $_REQUEST['showlatest'] . ' PMs', 5);
	print_cells_row(array('pmtextid', 'PM Title', 'From', 'Date', ''), 1);
	foreach ($pms AS $pm)
	{
		$date = $pm['sent'];
		$link = THIS_SCRIPT . '.php?do=read&pmtextid=' . $pm['id'];
		$row = array();
		$row[] = '<div class="smallfont">' . $pm['id'] . '</div>';
		$row[] = '<div class="smallfont"><span style="float:left">' . $pm['subject'] . '</span></div>';
		$row[] = '<div class="smallfont">' . $pm['sender'] . '</div>';
		$row[] = '<div class="smallfont">' . $date . '';
		$row[] = '<div class="smallfont">[<a href="' . $link . '">View Private Message</a>]</div>';
		print_cells_row($row);
	}
	print_table_footer(5, '<input class="button" value="Go Back" title="" tabindex="1" onclick="window.location=\'javascript:history.back(1)\';" type="button">');
}

//$byuser = "WHERE username ='".escape($userid)."' OR name = '".escape($userid)."' OR clean_username = '".escape(strtolower($userid))."' OR id = ".escape($userid)."";
//////////END PAGER///////////
$res = $db->sql_query("SELECT * FROM torrent_private_messages $byuser ORDER BY id DESC $limit") or sqlerr(__FILE__, __LINE__);
if (empty($_REQUEST['do']))
{

?>
<!-- form started:6 queries executed -->
<form action="admin_pms.php?do=list" method="post" name="listForm" id="listForm">
<input type="hidden" name="do" value="list" />
<input type="hidden" name="adminhash" value="3e73dc37dcedd5625580f2b3003a7c54" />
<input type="hidden" name="securitytoken" value="1246320728-ece494df92d839cbf13763b1e8d2fd3fdae46f8c" />

<br />
<table cellpadding="4" cellspacing="0" border="0" align="center" width="90%" style="border-collapse:separate" class="tborder" id="listForm_table">
<tr>
	<td class="tcat" align="center" colspan="2"><b>Read PMs</b></td>
</tr>
<tr valign="top">
	<td class="alt1">User ID or Username</td>
	<td class="alt1"><div id="ctrl_userid"><input type="text" class="bginput" name="userid" id="it_userid_1" value="" size="35" dir="ltr" tabindex="1" /></div></td>
</tr>
<tr>
	<td class="tfoot" colspan="2" align="center">	<input type="submit" id="submit0" class="button" tabindex="1" value="Read PMs" accesskey="s" />

</td>
</tr>
</table>
</form>
<!-- form ended: 6 queries executed -->


<!-- form started:6 queries executed -->
<form action="admin_pms.php?do=havepms" method="post" name="resetForm" id="resetForm">
<input type="hidden" name="do" value="allusershavepms" />
<input type="hidden" name="adminhash" value="3e73dc37dcedd5625580f2b3003a7c54" />
<input type="hidden" name="securitytoken" value="1246320728-ece494df92d839cbf13763b1e8d2fd3fdae46f8c" />
<br />
<table cellpadding="4" cellspacing="0" border="0" align="center" width="90%" style="border-collapse:separate" class="tborder" id="resetForm_table">
<tr>
	<td class="tfoot" colspan="2" align="center">	<input type="submit" id="submit1" class="button" tabindex="1" value="List Users with PMs" accesskey="s" />

</td>
</tr>
</table>
</form>
<!-- form ended: 6 queries executed -->


<!-- form started:6 queries executed -->
<form action="admin_pms.php?do=search" method="post" name="searchForm" id="searchForm">
<input type="hidden" name="do" value="search" />
<input type="hidden" name="adminhash" value="3e73dc37dcedd5625580f2b3003a7c54" />
<input type="hidden" name="securitytoken" value="1246320728-ece494df92d839cbf13763b1e8d2fd3fdae46f8c" />
<br />
<table cellpadding="4" cellspacing="0" border="0" align="center" width="90%" style="border-collapse:separate" class="tborder" id="searchForm_table">
<tr>
	<td class="tcat" align="center" colspan="2"><b>Search for PMs</b></td>

</tr>
<tr valign="top">
	<td class="alt1">Search for<p><input type="button" unselectable="on" value="Large Edit Box" class="button" style="font-weight:normal" onclick="window.open('textarea.php?dir=ltr&name=search','textpopup','resizable=yes,scrollbars=yes,width=' + (screen.width - (screen.width/10)) + ',height=600');" /></p></td>
	<td class="alt1"><div id="ctrl_search"><textarea name="search" id="ta_search_2" rows="4" cols="40" wrap="virtual" dir="ltr" tabindex="1"></textarea><div class="smallfont"><a href="#"  onclick="return resize_textarea(1, 'ta_search_2')">Increase Size</a> <a href="#"  onclick="return resize_textarea(-1, 'ta_search_2')">Decrease Size</a></div></div></td>
</tr>
<tr valign="top">
	<td class="alt2">Match</td>
	<td class="alt2"><div class="normal">

<div class="ctrl_">		<label for="rb_matchexact_3"><input type="radio" name="match" id="rb_matchexact_3" tabindex="1" value="exact" checked="checked" />exact text</label><br />
		<label for="rb_matchall_3"><input type="radio" name="match" id="rb_matchall_3" tabindex="1" value="all" />all words</label><br />
		<label for="rb_matchatleastone_3"><input type="radio" name="match" id="rb_matchatleastone_3" tabindex="1" value="atleastone" />at least one of the words</label><br />
</div>	</div></td>
</tr>
<tr>
	<td class="tfoot" colspan="2" align="center">	<input type="submit" id="submit2" class="button" tabindex="1" value="Search for PMs" accesskey="s" />
</td>

</tr>
</table>
</form>
<!-- form ended: 6 queries executed -->


<!-- form started:6 queries executed -->
<form action="admin_pms.php?do=latest" method="post" name="latestForm" id="latestForm">
<input type="hidden" name="do" value="latest" />
<input type="hidden" name="adminhash" value="3e73dc37dcedd5625580f2b3003a7c54" />
<input type="hidden" name="securitytoken" value="1246320728-ece494df92d839cbf13763b1e8d2fd3fdae46f8c" />
<br />
<table cellpadding="4" cellspacing="0" border="0" align="center" width="90%" style="border-collapse:separate" class="tborder" id="latestForm_table">
<tr>
	<td class="tcat" align="center" colspan="2"><b>Latest PMs</b></td>

</tr>
<tr valign="top">
	<td class="alt1">Number of PMs to show</td>
	<td class="alt1"><div id="ctrl_showlatest"><input type="text" class="bginput" name="showlatest" id="it_showlatest_4" value="100" size="35" dir="ltr" tabindex="1" /></div></td>
</tr>
<tr>
	<td class="tfoot" colspan="2" align="center">	<input type="submit" id="submit3" class="button" tabindex="1" value="Latest PMs" accesskey="s" />
</td>
</tr>
</table>
</form>
<!-- form ended: 6 queries executed -->
<?php
}
include("footer.php");
?>

                echo "\"  title=\"".$dispname."\">".((strlen($dispname) <= 71) ? search_word($dispname, $search): search_word(substr($dispname,0,70)."...", $search))."</a></p>";

        <!-- IF postrow.POSTER_POSTS != '' --><dd><strong>{L_POSTS}:</strong> {postrow.POSTER_POSTS}</dd><!-- ENDIF -->
        <!-- IF postrow.POSTER_JOINED --><dd><strong>{L_JOINED}:</strong> {postrow.POSTER_JOINED}</dd><!-- ENDIF -->
        <!-- IF postrow.POSTER_FROM --><dd><strong>{L_LOCATION}:</strong> {postrow.POSTER_FROM}</dd><!-- ENDIF -->

                    <!-- IF postrow.POSTER_UPLOAD != '' --><dd><strong>Uploaded:</strong> {postrow.POSTER_UPLOAD}</dd><!-- ENDIF -->
                    <!-- IF postrow.POSTER_DOWN_LOAD != '' --><dd><strong>Downloaded:</strong> {postrow.POSTER_DOWN_LOAD}</dd><!-- ENDIF -->
                    <!-- IF postrow.POSTER_RATIO != '' --><dd><strong>Ratio:</strong> {postrow.POSTER_RATIO}</dd><!-- ENDIF -->

#User Class

if(($user->admin)){

echo "<tr><td><p>Last IP</p></td>\n";
echo "<td><p>".long2ip($userrow["lastip"])."</p></td>\n";
}

if (eregi("(Mozilla|Opera|Lynx|Netscape)",$HTTP_SERVER_VARS["HTTP_USER_AGENT"])) {
        die("<html><head><title>Error!</title></head><body><h3>Sorry, but this file is not suitable for browsers.</h3></body></html>");
}

    $headers = getallheaders();
    if (isset($headers["Cookie"]) || isset($headers["Accept-Language"]) || isset($headers["Accept-Charset"])) {
    die("<html><head><title>Error!</title></head><body><h3>Sorry, but this file is not suitable for browsers.</h3></body></html>");
    }
    unset($headers);

if (!function_exists('getallheaders'))
{
    function getallheaders()
    {
       foreach ($_SERVER as $name => $value)
       {
           if (substr($name, 0, 5) == 'HTTP_')
           {
               $headers[str_replace(' ', '-', ucwords(strtolower(str_replace('_', ' ', substr($name, 5)))))] = $value;
           }
       }
       return $headers;
    }
}

."        window.scroll(0, 3000);\n"

."        window.scroll(1,199999);\n"

."        window.scroll(1,1);\n"

$sql = "SELECT S.*, U.id as uid, U.avatar as avat, IF(U.name IS NULL, U.username, U.name) as user_name FROM ".$db_prefix."_shouts S LEFT JOIN ".$db_prefix."_users U ON S.user = U.id ORDER BY posted ASC;";

$sql = "SELECT S.*, U.id as uid, U.avatar as avat, IF(U.name IS NULL, U.username, U.name) as user_name FROM ".$db_prefix."_shouts S LEFT JOIN ".$db_prefix."_users U ON S.user = U.id ORDER BY posted DESC;";

$startpagetime = microtime();

include("offline.php");

<?php
if ($_SERVER["REMOTE_ADDR"] != 'xxx.xxx.xxx.xxx')
#header( 'Location: http://www.xxxxxxxxxxx.com/maintain/index.html');
?>

<body bgcolor="#000000">

<p align="center">
<img border="0" src="http://www.xxxxxxxxxxxxxxxxx.com/maintain/logo.gif" width
="800" height="121"></p>
<p>&nbsp;</p>
<p align="center"><font color="#FFFFFF"><b>We are performing site maintenance. W
e'll be back soon.</font></b>
</p>

</body>

$s .= _btpercent."

$perc=sprintf("%.2f%%", (1 - ($row["to_go"] / $row["torrent_size"])) * 100);

echo $usertxt;

$usertxt.="<center><font size='1'><br><table class=main border=0 width=100><tr><td style='p
adding: 0px; background-image: url(images/loadbarbg.gif); background-repeat: repeat-x'>";
$pic = "loadbargreen.gif";
$width = round(1 * $perc);
$usertxt.="<img height=15 width=$width src=\"images/$pic\" alt='$donatein)%'><br><font size
='1'color=\"white\"><center>$perc</center></font></td></tr></table>";