rendered paste body<?
ob_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?
include("config.php");
include("includes/funcs.php");
include("includes/stats.php");
include ("includes/ubb.php");
$bbcode = new ubbParser();
$settings = mysql_query("select * from settings where id = '1'");
$settings = mysql_fetch_array($settings);
if($logged[username])
{
$query = mysql_query("update members set pages = pages+1 where username = '$logged[username]'");
}
?>
<?php
$ip = $_SERVER['REMOTE_ADDR'];
$getbanned = mysql_query("select * from ipban where ip = '$ip'");
$bannednum = mysql_num_rows($getbanned);
if($bannednum >= 1)
{
$bannedinfo = mysql_fetch_array($getbanned);
echo("<div align=\"center\"><b>You Are Banned!</b><br />
You have been banned for the following reason:<br />
<i>$bannedinfo[reason]</b></div>");
}
else
{
?>
<HTML>
<HEAD>
<TITLE>TechTuts.com - PHP, Photoshop, CSS, Bryce Tutorials and more</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Title" CONTENT="undefined">
<META NAME="Description" CONTENT="Web development tutorials, including HTML, PHP, CSS, Javascript, Photoshop and Bryce">
<META NAME="Keywords" CONTENT="tutorials, php, css, javascript, vb, visual basic, ps, photoshop, bryce, web, development, forum script, user management tutorial">
<style type="text/css">
body,div,table
{
font-size: 10px;
font-family: verdana;
}
.bar
{
color: #333333;
padding: 3px;
background: #D8E6FF;
margin: 0px;
}
.title
{
color: #EEE;
background: url(images/bar.jpg);
padding: 4px;
margin: 0px;
}
.textt
{
color: #333333;
font-size: 9px;
font-family: verdana;
DISPLAY: inline;
}
.bwrap2
{
margin-left: 10px;
margin-top: 5px;
margin-bottom: 5px;
margin-right: 10px;
font-size: 8px;
border: solid 1px #808080;
background: #efefef;
padding: 1px 1px 1px 1px;
}
A:link
{
color: #333333;
text-decoration: none;
}
A:visited
{
color: #333333;
text-decoration: none;
}
A:hover
{
color: #000000;
text-decoration: underline;
}
A:active
{
color: #333333;
text-decoration: none;
}
</style>
<script type="text/javascript">
function sendtext(e, text)
{
e.value += text
}
function showDiv(id)
{
var item = null;
item = document.getElementById(id);
if (item.style.display == "none")
{
item.style.display = "";
}
else
{
item.style.display = "none";
}
}
</script>
</HEAD>
<BODY BGCOLOR=#F1F1F1 LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0>
<TR>
<TD background="images/index_01_bg.jpg"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="268"><div align="left"><a href="?view=main"><img src="images/index_01.jpg" alt="" width="268" height="94" border="0" /></a></div></td>
<td><div align="right" style='padding-right: 8px;'>
<?
$random1 = mysql_query("select * from ad ORDER BY RAND() limit 1");
$random = mysql_fetch_array($random1);
if($random[id] == 1)
{
echo<<<EOF
<script language="JavaScript">
<!--
ctxt_ad_partner = "4278548190";
ctxt_ad_section = "19596";
ctxt_ad_bg = "";
ctxt_ad_width = 468;
ctxt_ad_height = 60;
ctxt_ad_bc = "B4D0DC";
ctxt_ad_cc = "ECF8FF";
ctxt_ad_lc = "FF6600";
ctxt_ad_tc = "000000";
ctxt_ad_uc = "000000";
// -->
</script>
<script language="JavaScript" src="http://ypn-js.overture.com/partner/js/ypn.js">
</script>
EOF;
}
else
{
echo<<<EOF
<a href="$random[url]" name="$random[alt]" target="_blank">
<img src="$random[banner]" border="0" alt="$random[alt]" /></a>
EOF;
}
?>
</div></td>
</tr>
</table></TD>
</TR>
<TR bgcolor="#D8E6FF">
<TD height="25" bgcolor="#D8E6FF">
<? include("includes/login2.php"); ?>
</TD>
</TR>
<TR>
<TD>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="200" bgcolor="#F1F1F1" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="6" style="font-size: 10px; font-family: verdana" id="table1">
<tr>
<td>
<TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0 style="font-size: 10px; font-family: verdana" id="table2">
<TR>
<TD width="4" height="26"> <IMG SRC="images/content_01.jpg" WIDTH=4 HEIGHT=26 ALT=""></TD>
<TD height="26" style="color: #ffffff; padding-left: 3px;" background="images/content_02.jpg">
Navigation</TD>
<TD width="4" height="26"> <IMG SRC="images/content_03.jpg" WIDTH=4 HEIGHT=26 ALT=""></TD>
</TR>
<TR>
<TD width="4" background="images/content_04.jpg"> </TD>
<TD bgcolor="#FFFFFF">
<div class="bar"><font color="#000000">Main Navigation</font></div> <div class="content"> <img src="images/rank/arrow.jpg" width="8" height="8" /><a href="?view=home">Home</a><br />
<img src="images/rank/arrow.jpg" width="8" height="8" /><a href="?view=affiliates">Affiliates</a><br />
<img src="images/rank/arrow.jpg" width="8" height="8" /><a href="?view=contact">Contact</a></div>
<div class="bar"><font color="#000000">Interaction</font></div>
<div class="content"> <img src="images/rank/arrow.jpg" width="8" height="8" /><a href="http://www.techtuts.com/forum.php">Forum</a><br>
<img src="images/rank/arrow.jpg" width="8" height="8" /><a href="?view=topsites">Topsites</a><br />
<img src="images/rank/arrow.jpg" width="8" height="8" /><a href="?view=plugger">Plug
Your Site</a><br />
<img src="images/rank/arrow.jpg" width="8" height="8" /><a href="?view=v3status">Version 3 Status </a> <br />
</div>
<div class="bar"><font color="#000000">Tutorials</font></div>
<div class="content">
<?
$getcats = mysql_query("SELECT * from tutcat order by 'id' asc");
echo(" <a href=\"?view=submittutorial\">Submit Tutorial</a><br />");
while($tutcat = mysql_fetch_array($getcats))
{
echo(" <img src='images/rank/arrow.jpg' width='8' height='8' /> <a href=\"?view=tutorials&act=cat&id=$tutcat[id]\">$tutcat[title]</a><br />");
}
?>
</TD>
<TD width="4" background="images/content_06.jpg"> </TD>
</TR>
<TR>
<TD width="4" height="4"> <IMG SRC="images/content_07.jpg" WIDTH=4 HEIGHT=4 ALT=""></TD>
<TD height="4" background="images/content_08.jpg"></TD>
<TD width="4" height="4"> <IMG SRC="images/content_09.jpg" WIDTH=4 HEIGHT=4 ALT=""></TD>
</TR>
</TABLE></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="6" style="font-size: 10px; font-family: verdana" id="table3">
<tr>
<td>
<TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0 style="font-size: 10px; font-family: verdana" id="table4">
<TR>
<TD width="4" height="26"> <IMG SRC="images/content_01.jpg" WIDTH=4 HEIGHT=26 ALT=""></TD>
<TD height="26" style="color: #ffffff; padding-left: 3px;" background="images/content_02.jpg">
New Tutorials</TD>
<TD width="4" height="26"> <IMG SRC="images/content_03.jpg" WIDTH=4 HEIGHT=26 ALT=""></TD>
</TR>
<TR>
<TD width="4" background="images/content_04.jpg"> </TD>
<TD bgcolor="#FFFFFF"> <div class="content">
<?
$tutnum = 0;
$gettuts = mysql_query("SELECT * from tutorials where active = 'yes' order by 'id' desc limit 7");
while($tuts = mysql_fetch_array($gettuts))
{
if ($tutnum == 0)
{
echo("<a href=\"?view=tutorials&act=tutorial&id=$tuts[id]\"><div class='textt'>$tuts[title]</div></a>");
}
else
{
echo("<br /><a href=\"?view=tutorials&act=tutorial&id=$tuts[id]\"><div class='textt'>$tuts[title]</div></a>");
}
$tutnum = $tutnum +1;
}
?>
</TD>
<TD width="4" background="images/content_06.jpg"> </TD>
</TR>
<TR>
<TD width="4" height="4"> <IMG SRC="images/content_07.jpg" WIDTH=4 HEIGHT=4 ALT=""></TD>
<TD height="4" background="images/content_08.jpg"></TD>
<TD width="4" height="4"> <IMG SRC="images/content_09.jpg" WIDTH=4 HEIGHT=4 ALT=""></TD>
</TR>
</TABLE></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="6" style="font-size: 10px; font-family: verdana" id="table9">
<tr>
<td> <table width="100%" border="0" cellpadding="0" cellspacing="0" style="font-size: 10px; font-family: verdana" id="table10">
<tr>
<td width="4" height="26"> <img src="images/content_01.jpg" width="4" height="26" alt="" /></td>
<td height="26" style="color: #ffffff; padding-left: 3px;" background="images/content_02.jpg">
Recent Comments</td>
<td width="4" height="26"> <img src="images/content_03.jpg" width="4" height="26" alt="" /></td>
</tr>
<tr>
<td width="4" background="images/content_04.jpg"> </td>
<td bgcolor="#FFFFFF">
<?
$color2 = "#D8E6FF";
$color1 = "#FFFFFF";
$row_count = 0;
$getcomments = mysql_query("Select * from tutcomments order by id desc limit 6");
while($comments= mysql_fetch_array($getcomments))
{
$row_color = ($row_count % 2) ? $color1 : $color2;
$row_count++;
$gettutorial = mysql_query("Select * from tutorials where id = '$comments[tut]'");
$tutorial = mysql_fetch_array($gettutorial);
$numbefore = mysql_query("select * from tutcomments where tut = '$tutorial[id]' AND id <= '$comments[id]'");
$numbefore = mysql_num_rows($numbefore);
$pagenum = $numbefore / 16;
$pagenum = ceil($pagenum);
echo("<div style=\"background: $row_color\">Comment by <a href=\"?view=members&user=$comments[author]\">$comments[author]</a><br />
<div class='textt'><i><a href=\"?view=tutorials&act=tutorial&id=$tutorial[id]&page=$pagenum#comment$comments[id]\">$tutorial[title]</a></i></div></div>");
}
?>
</td>
<td width="4" background="images/content_06.jpg"> </td>
</tr>
<tr>
<td width="4" height="4"> <img src="images/content_07.jpg" width="4" height="4" alt="" /></td>
<td height="4" background="images/content_08.jpg"></td>
<td width="4" height="4"> <img src="images/content_09.jpg" width="4" height="4" alt="" /></td>
</tr>
</table></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="6" style="font-size: 10px; font-family: verdana" id="table11">
<tr>
<td> <table width="100%" border="0" cellpadding="0" cellspacing="0" style="font-size: 10px; font-family: verdana" id="table12">
<tr>
<td width="4" height="26"> <img src="images/content_01.jpg" width="4" height="26" alt="" /></td>
<td height="26" style="color: #ffffff; padding-left: 3px;" background="images/content_02.jpg">
Poll</td>
<td width="4" height="26"> <img src="images/content_03.jpg" width="4" height="26" alt="" /></td>
</tr>
<tr>
<td width="4" background="images/content_04.jpg"> </td>
<td bgcolor="#FFFFFF">
<?
$getq1 = mysql_query("SELECT * from poll ORDER BY id DESC limit 1");
$getq = mysql_fetch_array($getq1);
echo("<div class=\"bar\"><center>$getq[question]</center></div>");
?>
<div class="content">
<?
//fill in the color variable with a hex code for a color.
$color = "#2956A9";
//For the lines below, use the following stuff...
//if you want to record peoples usernames when they vote..change $remote_addr to a variable with the user's
//username. $remote_addr is the users Ip address.
$ident = "$logged[username]";
//change the following line to where u want the user to be redirected
//after they vote
$ref = $_SERVER['HTTP_REFERER'];
if (!$ref)
{
$ref = "?view=home";
}
$redir = "$ref";
include ("config.php"); // the page that connects to the database
$checkvoted = mysql_query("SELECT * from poll_votes where ident = '$ident' AND poll_id = '$getq[id]'");
$voted = mysql_num_rows($checkvoted);
if ($voted == 0 && !$_POST[pollsubmit])
{
$getchoice1 = mysql_query("SELECT * from poll_choices WHERE pollid = '$getq[id]' order by 'id' asc");
echo ("
<table border=\"0\" align=\"center\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><form method=\"POST\">
");
while ($choices = mysql_fetch_array($getchoice1)){
echo ("<tr>
<td width=\"10\"><input type=\"radio\" value=\"$choices[id]\" name=\"choice\"></td><td align=\"left\">$choices[text]</td></tr>");
}
echo ("
<tr>
<td align=\"center\" colspan=\"2\"><input type=\"submit\" value=\"Submit\" name=\"pollsubmit\" style=\"font-family: Verdana; font-size: 10px; border: 1px solid #000000; background-color: #E6E6E6\">
</td>
</form>
</tr>
</table>");
}
if ($_POST[pollsubmit] && $voted == 0)
{
$pchoiceq= mysql_query("SELECT * from poll_choices WHERE pollid = '$getq[id]' order by 'id' asc");
while ($pchoices = mysql_fetch_array($pchoiceq)){
$choiceid = $pchoices[id];
if ($_POST[choice] == $choiceid && $voted == 0)
{
$update_votes = mysql_query("Update poll_choices set votes = votes + 1 where id = '$choiceid'");
$fvote = mysql_query("INSERT INTO `poll_votes` ( `poll_id`, `ident`, `choice`, `date` )VALUES ('$getq[id]', '$ident', '$choiceid', NOW())");
echo ("<meta http-equiv=\"Refresh\" content=\"0; URL=$redir\"/>Thank You for voting!");
}
}
}
if ($voted == 1)
{
$totalvotes = 0;
$getnumvotes = mysql_query("SELECT * from poll_choices where pollid = '$getq[id]' order by 'id' asc");
while($votes = mysql_fetch_array($getnumvotes))
{
$totalvotes = $totalvotes + $votes[votes];
}
$getpoll1 = mysql_query("SELECT * from poll_choices where pollid = '$getq[id]' order by 'id' asc");
while ($getpoll = mysql_fetch_array($getpoll1))
{
$numvotes = $getpoll[votes] / $totalvotes;
$numvotes2 = $numvotes * 100;
echo ("$getpoll[text]");
$round = ceil($numvotes2);
echo (" ($getpoll[votes] votes)
<table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">
<tr>
<td style=\"border: 1px solid #808080\">
<table width=\"$numvotes2%\" cellspacing=\"1\" cellpadding=\"0\">
<tr>
<td bgcolor=\"$color\" height=\"5\"> </td>
</tr>
</table>
</td>
</tr>
</table>
");
}
}
echo "<div align='right'><b>Total Votes:</b> <i>$totalvotes</i></div>";
?>
</div>
</td>
<td width="4" background="images/content_06.jpg"> </td>
</tr>
<tr>
<td width="4" height="4"> <img src="images/content_07.jpg" width="4" height="4" alt="" /></td>
<td height="4" background="images/content_08.jpg"></td>
<td width="4" height="4"> <img src="images/content_09.jpg" width="4" height="4" alt="" /></td>
</tr>
</table></td>
</tr>
</table>
</td>
<td bgcolor="#F1F1F1" valign="top">
<?
ob_start();
switch("$_GET[view]")
{
default:
include("includes/news.php");
break;
case 'register':
include("includes/register.php");
break;
case 'forum':
include("includes/newforum.php");
break;
case 'admin':
include("includes/admin.php");
break;
case 'contact':
include("includes/contact.php");
break;
case 'cpanel':
include("includes/cpanel.php");
break;
case 'members':
include("includes/members.php");
break;
case dev:
include("forumtest.php");
break;
case 'topsites':
include("includes/topsites.php");
break;
case 'plugger':
include("includes/plug.php");
break;
case 'plugger_action':
include("includes/plugger_action.php");
break;
case 'v3status':
include("includes/v3status.php");
break;
case 'logout':
ob_start();
setcookie("id", asdfasdfafdsadsf,time()+(60*60*24*5), "/", "");
setcookie("pass", asdfgasdfgadsgagds,time()+(60*60*24*5), "/", "");
boxtop("Thank You");
echo ("You are now logged out!");
endbox();
break;
case 'affiliates':
include("includes/affiliates.php");
break;
case 'tutorials':
include("includes/tutorial.php");
break;
case 'chat':
include("c4hat/index.php");
break;
case 'admin2':
include("includes/admin2.php");
break;
case 'submittutorial':
include("includes/submittut.php");
break;
case 'resetpass':
include("includes/passreset.php");
break;
case 'bbcode':
boxtop("BBCode");
echo("[b]Bold Text[/b] -- This makes text bold (Bold Text)<br />
[i]Italic Text[/i] -- This makes text italic (<i>Italic Text</i>)<br />
[u]Underlined Text[/u] -- This makes text underlined(<u>Underlined Text</u>)<br />
[s]Struck Through Text[/s] - This makes text struck through(<s>Stuck
Through Text</s>)<br />
1[sup]st[/sup] -- This makes text superscript (1<sup>st</sup>)<br />
H[sub]2[/sub]O -- This makes text subscript (H<sub>2</sub>O)<br />
[code]<HTML> Code Here[/code] -- Used for displaying code<br />
[php]<? echo("This is php code"); ?>[/php] -- Used for displaying php
code<br />
[quote by=username]I said this![/quote] -- Used to display what other
people said<br />
[img]http://techtuts.com/button.gif[/img] -- Used to display an image<br />
[url=http://techtuts.com]Awesome Site[/url] -- Used to display a link (<a href=\"http://techtuts.com\">Awesome
Site</a>)<br />
[url]http://techtuts.com[/url] -- Another way to display a link (<a href=\"http://techtuts.com\">http://techtuts.com</a>)<br />
");
endbox();
break;
}
?>
</td>
<td width="200" bgcolor="#F1F1F1" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="6" style="font-size: 10px; font-family: verdana" id="table7">
<tr>
<td> <table width="100%" border="0" cellpadding="0" cellspacing="0" style="font-size: 10px; font-family: verdana" id="table8">
<tr>
<td width="4" height="26"> <img src="images/content_01.jpg" width="4" height="26" alt="" /></td>
<td height="26" style="color: #ffffff; padding-left: 3px;" background="images/content_02.jpg">
Shoutbox</td>
<td width="4" height="26"> <img src="images/content_03.jpg" width="4" height="26" alt="" /></td>
</tr>
<tr>
<td width="4" background="images/content_04.jpg"> </td>
<td bgcolor="#FFFFFF">
<? include("shout.php"); ?>
</td>
<td width="4" background="images/content_06.jpg"> </td>
</tr>
<tr>
<td width="4" height="4"> <img src="images/content_07.jpg" width="4" height="4" alt="" /></td>
<td height="4" background="images/content_08.jpg"></td>
<td width="4" height="4"> <img src="images/content_09.jpg" width="4" height="4" alt="" /></td>
</tr>
</table></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="6" style="font-size: 10px; font-family: verdana" id="table9">
<tr>
<td> <table width="100%" border="0" cellpadding="0" cellspacing="0" style="font-size: 10px; font-family: verdana" id="table10">
<tr>
<td width="4" height="26"> <img src="images/content_01.jpg" width="4" height="26" alt="" /></td>
<td height="26" style="color: #ffffff; padding-left: 3px;" background="images/content_02.jpg">
Links</td>
<td width="4" height="26"> <img src="images/content_03.jpg" width="4" height="26" alt="" /></td>
</tr>
<tr>
<td width="4" background="images/content_04.jpg"> </td>
<td bgcolor="#FFFFFF">
<? include('includes/links.php'); ?></td>
<td width="4" background="images/content_06.jpg"> </td>
</tr>
<tr>
<td width="4" height="4"> <img src="images/content_07.jpg" width="4" height="4" alt="" /></td>
<td height="4" background="images/content_08.jpg"></td>
<td width="4" height="4"> <img src="images/content_09.jpg" width="4" height="4" alt="" /></td>
</tr>
</table></td>
</tr>
</table>
<?
if (!$logged[username]){
echo ("
<table width='100%' border='0' cellspacing='0' cellpadding='6' style='font-size: 10px; font-family: verdana' id='table7'>
<tr>
<td>
<TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0 style='font-size: 10px; font-family: verdana' id='table8'>
<TR>
<TD width='4' height='26'> <IMG SRC='images/content_01.jpg' WIDTH=4 HEIGHT=26 ALT=''></TD>
<TD height='26' style='color: #ffffff; padding-left: 3px;' background='images/content_02.jpg'>
Sign Up!</TD>
<TD width='4' height='26'> <IMG SRC='images/content_03.jpg' WIDTH=4 HEIGHT=26 ALT=''></TD>
</TR>
<TR>
<TD width='4' background='images/content_04.jpg'> </TD>
<TD bgcolor='#FFFFFF'><a href='http://www.techtuts.com/?view=register'><img src='http://www.techtuts.com/images/register.jpg' width='184' height='202' border='0' /></a>
</TD>
<TD width='4' background='images/content_06.jpg'> </TD>
</TR>
<TR>
<TD width='4' height='4'> <IMG SRC='images/content_07.jpg' WIDTH=4 HEIGHT=4 ALT=''></TD>
<TD height='4' background='images/content_08.jpg'></TD>
<TD width='4' height='4'> <IMG SRC='images/content_09.jpg' WIDTH=4 HEIGHT=4 ALT=''></TD>
</TR>
</TABLE></td>
</tr>
</table>
");
}
?>
<table width="100%" border="0" cellspacing="0" cellpadding="6" style="font-size: 10px; font-family: verdana" id="table9">
<tr>
<td> <table width="100%" border="0" cellpadding="0" cellspacing="0" style="font-size: 10px; font-family: verdana" id="table10">
<tr>
<td width="4" height="26"> <img src="images/content_01.jpg" width="4" height="26" alt="" /></td>
<td height="26" style="color: #ffffff; padding-left: 3px;" background="images/content_02.jpg">
Random Affiliates</td>
<td width="4" height="26"> <img src="images/content_03.jpg" width="4" height="26" alt="" /></td>
</tr>
<tr>
<td width="4" background="images/content_04.jpg"> </td>
<td bgcolor="#FFFFFF">
<div class="content"><?PHP
include("includes/random.php");
?></div>
<div class="bar" align="center"><a href="?view=affiliates">Apply / View All</a></div>
</div>
</td>
<td width="4" background="images/content_06.jpg"> </td>
</tr>
<tr>
<td width="4" height="4"> <img src="images/content_07.jpg" width="4" height="4" alt="" /></td>
<td height="4" background="images/content_08.jpg"></td>
<td width="4" height="4"> <img src="images/content_09.jpg" width="4" height="4" alt="" /></td>
</tr>
</table></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="6" style="font-size: 10px; font-family: verdana" id="table13">
<tr>
<td>
<TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0 style="font-size: 10px; font-family: verdana" id="table14">
<TR>
<TD width="4" height="26"> <IMG SRC="images/content_01.jpg" WIDTH=4 HEIGHT=26 ALT=""></TD>
<TD height="26" style="color: #ffffff; padding-left: 3px;" background="images/content_02.jpg">
Statistics</TD>
<TD width="4" height="26"> <IMG SRC="images/content_03.jpg" WIDTH=4 HEIGHT=26 ALT=""></TD>
</TR>
<TR>
<TD width="4" background="images/content_04.jpg"> </TD>
<TD bgcolor="#FFFFFF">
<div class="bar">Member Stats</div>
<div class="content"> Members:
<?
$get = mysql_query("SELECT * from members");
$memnum = mysql_num_rows($get);
echo("$memnum");
$latestmem = mysql_query("SELECT * from members order by 'id' desc limit 1");
$latestmem = mysql_fetch_array($latestmem);
?>
<br />
Latest Member: <? echo("$latestmem[username]");
$gettopics = mysql_query("select * from posts where iftopic = 'yes'");
$gettopics = mysql_num_rows($gettopics);
$getreplies = mysql_query("select * from posts where iftopic = 'no'");
$getreplies = mysql_num_rows($getreplies);
$getall = mysql_query("select * from posts");
$getall = mysql_num_rows($getall);
?></div>
<div class="bar">People Online</div>
<div class="content">
<? include("includes/online.php"); ?>
</div>
<div class="bar"> Forum Stats</div>
<div class="content"> Posts: <? echo("$getall"); ?><br />
Topics: <? echo("$gettopics"); ?><br />
Replies: <? echo("$getreplies"); ?></div>
<?
$pendingaff = mysql_query("select * from affiliates where active = 'no'");
$pendingaff = mysql_num_rows($pendingaff);
if($logged[username] && $logged[level] == 9)
{
echo("<div class=\"bar\">Admin Stats</div><div class=\"content\">Pending Affiliates: $pendingaff</div>");
}
?>
</TD>
<TD width="4" background="images/content_06.jpg"> </TD>
</TR>
<TR>
<TD width="4" height="4"> <IMG SRC="images/content_07.jpg" WIDTH=4 HEIGHT=4 ALT=""></TD>
<TD height="4" background="images/content_08.jpg"></TD>
<TD width="4" height="4"> <IMG SRC="images/content_09.jpg" WIDTH=4 HEIGHT=4 ALT=""></TD>
</TR>
</TABLE></td>
</tr>
</table></td>
</tr>
</table>
</div></TD>
</TR>
<TR bgcolor="E2E2E2">
<TD align="center" height="22" bgcolor="#E2E2E2">
<font size="1" face="Arial, Helvetica, sans-serif">All
Content Copyright 2005-2006 TechTuts.com or Respective Owners</font></div></TD>
</TR>
</TABLE>
</BODY>
</HTML>
<?
}
?>