add('EXTRASIDEBARS',(isset($extraSidebars) ? $extraSidebars : ''));
if (isset($onFourm))
{
$template->adds_block('ONFOURM',array('exi'=>1));
}
if (!isset($noRightbar))
{
$template->adds_block('RIGHTBAR',array('exi'=>1));
if (!isset($noHatNav))
{
$template->adds_block('USEHATNAV', array('exi'=>1));
if (!isset($genHatNav))
{
$gethnis = 'SELECT * FROM hatnav WHERE category = "' .
$pageCategory . '"';
$gethnis2 = mysql_query($gethnis);
$i=0;
while ($gethnis3[$i] = mysql_fetch_array($gethnis2))
{
$template->adds_block('HATNAV', array( 'AID' => $gethnis3[$i]['AID'],
'HREF' => $gethnis3[$i]['href'],
'IMAGE' => '/theme/images/icons/' . $gethnis3[$i]['image'] . '.png',
'TEXT' => $gethnis3[$i]['text'],
'NEW' => dispIfNotOld($gethnis3[$i]['lastEdit'])));
$i++;
}
} else {
$i=0;
while ($i < $genHatNavNum)
{
$template->adds_block('HATNAV', array( 'AID' => 'post',
'HREF' => $genHatNav[$i]['href'],
'IMAGE' => '/theme/images/blue.PNG',
'TEXT' => $genHatNav[$i]['text'],
'NEW' => ''));
$i++;
}
}
}
include('pages/polloftheweek.php');
$getpopular = "SELECT * FROM updates ORDER BY popularity DESC LIMIT 0,5";
$getpopular2 = mysql_query($getpopular);
$i=0;
while ($getpopular3[$i] = mysql_fetch_array($getpopular2))
{
$template->adds_block('POPULAR', array( 'CODED' => $getpopular3[$i]['slug'],
'TITLE' => stripslashes($getpopular3[$i]['title'])));
$i++;
}
$getcomments = "SELECT * FROM comments WHERE page_id LIKE \"updates-%\" OR page_id LIKE \"quote-%\" ORDER BY id DESC LIMIT 0,5";
$getcomments2 = mysql_query($getcomments);
$i=0;
while ($getcomments3[$i] = mysql_fetch_array($getcomments2))
{
$getuser = "SELECT * FROM users WHERE username = \"" . $getcomments3[$i]['username'] . "\"";
$getuser2 = mysql_query($getuser);
$getuser3 = mysql_fetch_array($getuser2);
if ($getuser3['username'] == $getcomments3[$i]['username'])
{
$username = $getuser3['username'];
$website = $getuser3['website'];
} else {
$getanon = "SELECT * FROM anon_commenters WHERE username = \"" . $getcomments3[$i]['username'] . "\"";
$getanon2 = mysql_query($getanon);
$getanon3 = mysql_fetch_array($getanon2);
if ($getanon3['username'] == $getcomments3[$i]['username'])
{
$username = $getanon3['username'] . ' (Guest)';
$website = $getanon3['website'];
}
}
if (strpos($getcomments3[$i]['page_id'], 'updates') !== FALSE)
{
$getpost = "SELECT * FROM updates WHERE id = " . substr($getcomments3[$i]['page_id'],strpos($getcomments3[$i]['page_id'],'-')+1);
$getpost2 = mysql_query($getpost);
$getpost3 = mysql_fetch_array($getpost2);
$template->adds_block('COMMENTS', array( 'ID' => $getcomments3[$i]['id'],
'AREA' => 'blog',
'CODED' => $getpost3['slug'],
'ENDING' => '/',
'TITLE' => stripslashes($getpost3['title']),
'AUTHOR' => (($website != '') ? '' . $username . '' : $username)));
$i++;
} else if (strpos($getcomments3[$i]['page_id'], 'quote') !== FALSE)
{
$num = substr($getcomments3[$i]['page_id'],strpos($getcomments3[$i]['page_id'],'-')+1);
$template->adds_block('COMMENTS', array( 'ID' => $getcomments3[$i]['id'],
'AREA' => 'quotes',
'CODED' => $num,
'ENDING' => '.php',
'TITLE' => 'Quote #' . $num,
'AUTHOR' => (($website != '') ? '' . $username . '' : $username)));
$i++;
}
}
$getusers = "SELECT DISTINCT username FROM comments";
$getusers2 = mysql_query($getusers);
$i=0;
while ($getusers3[$i] = mysql_fetch_array($getusers2))
{
$getcount = "SELECT COUNT(*) FROM comments WHERE username = \"" . $getusers3[$i]['username'] . "\"";
$getcount2 = mysql_query($getcount);
$getcount3 = mysql_fetch_array($getcount2);
$getuser = "SELECT * FROM users WHERE username = \"" . $getusers3[$i]['username'] . "\"";
$getuser2 = mysql_query($getuser);
$getuser3 = mysql_fetch_array($getuser2);
if ($getuser3['username'] == $getusers3[$i]['username'])
{
$username = $getuser3['username'];
$website = $getuser3['website'];
} else {
$getanon = "SELECT * FROM anon_commenters WHERE username = \"" . $getusers3[$i]['username'] . "\"";
$getanon2 = mysql_query($getanon);
$getanon3 = mysql_fetch_array($getanon2);
if ($getanon3['username'] == $getusers3[$i]['username'])
{
$username = $getanon3['username'] . ' (Guest)';
$website = $getanon3['website'];
}
}
$name = (($website != '') ? '' . $username . '' : $username);
$users[$name] = $getcount3[0];
$i++;
}
arsort($users);
$i=0;
foreach ($users as $name => $count)
{
if ($i == 5)
{
break;
}
$template->adds_block('TOP', array( 'USERNAME' => $name,
'COUNT' => $count));
$i++;
}
$gethits = "SELECT * FROM config WHERE name = \"hits\"";
$gethits2 = mysql_query($gethits);
$gethits3 = mysql_fetch_array($gethits2);
$template->add('HITS', $gethits3['value']);
$gethits = "SELECT * FROM config WHERE name = \"todayHits\"";
$gethits2 = mysql_query($gethits);
$gethits3 = mysql_fetch_array($gethits2);
$template->add('TODAY', $gethits3['value']);
$getpost = "SELECT * FROM phpbb_posts ORDER BY post_id DESC LIMIT 0,5";
$getpost2 = mysql_query($getpost) or die($getpost);
$i=0;
while ($getpost3[$i] = mysql_fetch_array($getpost2))
{
$getuser = "SELECT * FROM phpbb_users WHERE user_id = " . $getpost3[$i]['poster_id'];
$getuser2 = mysql_query($getuser) or die($getuser);
$getuser3 = mysql_fetch_array($getuser2);
$template->adds_block('FOURM', array( 'SUBJECT' => $getpost3[$i]['post_subject'],
'TOPIC' => $getpost3[$i]['topic_id'],
'POST' => $getpost3[$i]['post_id'],
'USERNAME' => $getuser3['username']));
}
$gettags = "SELECT DISTINCT tag FROM tags WHERE post_type = \"published\"";
$gettags2 = mysql_query($gettags);
$i=0;
while ($gettags3[$i] = mysql_fetch_array($gettags2))
{
$cnttag = "SELECT COUNT(*) FROM tags WHERE tag = \"" . $gettags3[$i]['tag'] . "\"";
$cnttag2 = mysql_query($cnttag);
$cnttag3 = mysql_fetch_array($cnttag2);
$counts[$gettags3[$i]['tag']] = $cnttag3[0];
$i++;
}
$min_count = min($counts);
$spread = max($counts) - $min_count;
$spread = ($spread <= 0) ? 1 : $spread;
$font_step = 8 / $spread;
foreach ($counts as $tag => $count)
{
if ($count != $min_count)
{
$template->adds_block('TAGCLOUD', array( 'TAG' => $tag,
'SIZE' => (8 + (($count - $min_count) * $font_step)),
'COUNT' => $count));
}
}
}
$template->add('REDIRPAGE',rawurlencode($_SERVER['REQUEST_URI']));
$template->add('LOGDATA',echoLogData());
$template->display();
?>