From 24503e3abe705acde2df159aeae61be0d009f92e Mon Sep 17 00:00:00 2001 From: Starla Insigna Date: Wed, 19 Nov 2008 17:27:03 -0500 Subject: Imported sources --- includes/footer.php | 198 ++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 198 insertions(+) create mode 100644 includes/footer.php (limited to 'includes/footer.php') diff --git a/includes/footer.php b/includes/footer.php new file mode 100644 index 0000000..e4c88c8 --- /dev/null +++ b/includes/footer.php @@ -0,0 +1,198 @@ +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-%\" ORDER BY id DESC LIMIT 0,5"; + $getcomments2 = mysql_query($getcomments); + $i=0; + while ($getcomments3[$i] = mysql_fetch_array($getcomments2)) + { + $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); + + $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']; + } + } + + + $template->adds_block('COMMENTS', array( 'CODED' => $getpost3['slug'], + 'TITLE' => stripslashes($getpost3['title']), + '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; + } + + if ($name != 'Pingback') + { + $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'])); + } +} + +$template->display(); + +?> -- cgit 1.4.1