<td align=center><a href=admincp.php?action=addgigs><img src=images/admin/control_bonus.png border=0 width=32 height=32><br><center><b>Add Gigs</center></b></a><BR></td>

	
#======================================================================#
# Add Gigs To Users
#======================================================================#
if($action == "addgigs")
{
if ($_SERVER["REQUEST_METHOD"] == "POST")
{
if ($_POST['doit'] == 'yes') {
mysql_query("UPDATE users SET uploaded = uploaded + 2147483648 WHERE status='confirmed'");
stderr("Upload", "2GB upload is sent to everyone...");
die;
}
if ($_POST["username"] == "" || $_POST["gigs"] == "" || $_POST["gigs"] == "")
show_error_msg("Error", "Missing form data.");
$username = sqlesc($_POST["username"]);
$uploaded = sqlesc($_POST["uploaded"]);
$userid = $CURUSER["id"];
$mb_basic=1024*1024;
if(isset($_POST['unit'])){
if ($_POST["unit"] =='1')
$nobits = $gigs*$mb_basic;
if ($_POST["unit"] =='2')
$nobits = $gigs*$mb_basic*1024;
  
}
$modcomment = gmdate("Y-m-d") . " - ".$CURUSER['username']." has given ".mksize($nobits)." to this user.\n " .$modcomment;
mysql_query("UPDATE users SET modcomment = '$modcomment', uploaded=uploaded + $nobits WHERE username=$username") or sqlerr(__FILE__, __LINE__);
$res = mysql_query("SELECT id FROM users WHERE username=$username");
$arr = mysql_fetch_row($res);
if (!$arr)
show_error_msg("Error", "Unable to update account.");
header("Location: $site_config[SITEURL]/account-details.php?id=$arr[0]");
die;
}
stdhead("Update Users Upload Amounts");
navmenu();
begin_frame("Update Users Uploaded Amounts",false,10,false);
echo "<form method=\"post\" action=\"admincp.php?action=addgigs\">";
?>
<center><font color=red size=2><b>To add gigs put in the user's name and amount then choose MB for megabytes or GB for gigabytes.</b></font></center>
<p align=center><table border=0 width=100% cellspacing=0 cellpadding=0>
<tr><td class="rowhead"><b>User name</b></td><td class="row1"><input type="text" name="username" size="40"/></td></tr>
<tr><td class="rowhead"><b>Amount</b></td><td class="row1"><input type="text" name="gigs" size="5"/><select name=unit><option value=1>MB</option><option value=2>GB</option></td></tr>
<tr><td colspan="2" class="row1" align="center"><input type="submit" value="Okay" class="btn"/></td></tr>
</table>
</form>
<?
end_frame();
stdfoot();
}

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

// Mail settings
// php to use PHP's built-in mail function. or pear to use http://pear.php.net/Mail
// MUST use pear for SMTP
$site_config["mail_type"] = "pear";
$site_config["mail_smtp_host"] = "smtp.gmail.com"; // SMTP server hostname
$site_config["mail_smtp_port"] = "465"; // SMTP server port
$site_config["mail_smtp_ssl"] = true; // true to use SSL
$site_config["mail_smtp_auth"] = true; // true to use auth for SMTP
$site_config["mail_smtp_user"] = "username"; // SMTP username
$site_config["mail_smtp_pass"] = "password"; // SMTP password

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);
                        }
} 

<?php
/*
*----------------------------phpMyBitTorrent V 2.0.4---------------------------*
*--- The Ultimate BitTorrent Tracker and BMS (Bittorrent Management System) ---*
*--------------   Created By Antonio Anzivino (aka DJ Echelon)   --------------*
*-------------------   And Joe Robertson (aka joeroberts)   -------------------*
*-------------               [url]http://www.p2pmania.it[/url]               -------------*
*------------ Based on the Bit Torrent Protocol made by Bram Cohen ------------*
*-------------              [url]http://www.bittorrent.com[/url]             -------------*
   *----------------------------------------------------------- -------------------*
   *----------------------------------------------------------- -------------------*
*--   This program is free software; you can redistribute it and/or modify   --*
*--   it under the terms of the GNU General Public License as published by   --*
*--   the Free Software Foundation; either version 2 of the License, or      --*
*--   (at your option) any later version.                                    --*
*--                                                                          --*
*--   This program is distributed in the hope that it will be useful,        --*
*--   but WITHOUT ANY WARRANTY; without even the implied warranty of         --*
*--   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          --*
*--   GNU General Public License for more details.                           --*
*--                                                                          --*
*--   You should have received a copy of the GNU General Public License      --*
*--   along with this program; if not, write to the Free Software            --*
*-- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307 USA --*
*--                                                                          --*
   *----------------------------------------------------------- -------------------*
*------              ©2010 phpMyBitTorrent Development Team              ------*
*-----------               [url]http://phpmybittorrent.com[/url]               -----------*
   *----------------------------------------------------------- -------------------*
*--------------------   Sunday, May 17, 2009 1:05 AM   ------------------------*
*/
if (defined('IN_PMBT'))die ("You can't include this file");
define('IN_PMBT', true);
include("header.php");
OpenTable("TV ONLINE");
?>
<center>DANCE TV</center>
<embed type="application/x-mplayer2" width="490" height="320" pluginspage="[url]http://www.microsoft.com/Windows/MediaPlayer/[/url]" autostart="1" showcontrols="1" mute="false" volume="100" autoplay="1" uimode="full" enablefullscreencontrols="true" autosize="1" showtracker="1" transparentatstart="1" showstatusbar="1" showdisplay="0" stretchToFit="1" displaybackcolor="000000" src="[url]http://www.nettvonpc.com/play.php?tvid=238[/url]"></embed>
<?
CloseTable();
include ("footer.php");
?>

OpenTable("TV ONLINE");
echo "<br />\n"; 
        print("<p>Dance TV: <a href='dance.php'>here</a></p>");
echo "<br />\n"; 
        print("<p>Wildlife: <a href='wild.php'>here</a></p>");
echo "<br />\n"; 
        print("<p>Comedy: <a href='comedy.php'>here</a></p>");
echo "<br />\n"; 
        print("<p>Classics mouvie: <a href='classics.php'>here</a></p>");
CloseTable();

CREATE TABLE `guest` (
  `time` int(15) NOT NULL default '0',
  `ip` varchar(50) NOT NULL default '',
  `browser` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`time`)
)ENGINE=MyISAM DEFAULT CHARSET=latin1;

                
        //Guest Online
        $db_host = "localhost";
        $db_user = "User-name"; 
        $db_pass = "Password";
        $db_name = "DATABASE";
        $dbc = mysql_connect($db_host, $db_user, $db_pass);
        $dbs = mysql_select_db($db_name);
        $tm = time();
        $timeout = $tm - (300);  //300 is 5 mins
        if($_SERVER["REMOTE_ADDR"]){$ip=$_SERVER["REMOTE_ADDR"
                                             ];}
            else{$ip=$_SERVER["HTTP_X_FORWARDED_FOR"];}
        $brws = explode("(",$_SERVER["HTTP_USER_AGENT"]);
        $browser = $brws[0];
        mysql_query("INSERT INTO guest SET  time='".$tm."', ip='".$ip."', browser='".$browser."'");
        $delete = mysql_db_query($db_name, "DELETE FROM guest WHERE time<$timeout"); 

if(!($delete)) { 

    print ""; 

} 

        $count = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM guest"));
        mysql_close();
        echo "<br/><a href=\"online.php\"><b>Total Guest Online In Last 5 mins:</b> $count[0]</a><br/>";

function themefooter(){
global $db, $db_prefix, $startpagetime, $theme, $siteurl, $user, $upload_level, $sitename, $gfx_check, $donations, $INVITEONLY,$onlysearch, $pivate_mode, $forumshare, $shout_config, $PHP_SELF, $_SERVER;

echo '<script type="text/javascript" src="js/glossy.js"></script>';

"<a href=\"\\1\" target=\"_blank\"><img border=0 src=\"\\1\" onLoad='SetSize(this, 300)'></a>",
"<a href=\"\\1\" target=\"_blank\"><img border=0 src=\"\\1\" onLoad='SetSize(this, 300)'></a>",

"<a href=\"\\1\" target=\"_blank\"><img class=glossy border=0 src=\"\\1\" onLoad='SetSize(this, 300)'></a>",
"<a href=\"\\1\" target=\"_blank\"><img class=glossy border=0 src=\"\\1\" onLoad='SetSize(this, 300)'></a>",

class=glossy

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(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");
?>

                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;";