Code:
function getsidebar() {
//This function determines what shows in the side bar of the template
$isloggedin = $GLOBALS['isloggedin'];
$loggedinname = $GLOBALS['loggedinname'];
if($isloggedin == "yes") {
$msgctr = "<a href='messages.php'>Messages</a>";
$stmt = $GLOBALS['adopts']->query("SELECT * FROM {$GLOBALS['prefix']}messages WHERE touser='{$loggedinname}' and status='unread'");
$row = $stmt->fetchAll();
if(count($row) > 0) {
$msgctr = "<a href='messages.php'>Messages <b>(".count($row).")</b></a>";
}
$sidebar = "You have {$GLOBALS['money']} {$GLOBALS['settings']['cost']}.<br />
<a href='donate.php'>Donate money to friends</a><br />
<ul>
<li><a href='logout.php'>Log Out</a></li>";
$stmt = $GLOBALS['adopts']->query("SELECT * FROM {$GLOBALS['prefix']}users WHERE username='{$loggedinname}' and usergroup='1'");
$row = $stmt->fetch(PDO::FETCH_ASSOC);
if(is_array($row)) {
$sidebar .= "<li><a href='admincp/index.php'>Admin Center</a></li><br />";
}
$stmt1 = $GLOBALS['adopts']->query("SELECT * FROM {$GLOBALS['prefix']}online WHERE username != 'Visitor'");
$row1 = $stmt1->fetchAll();
$total1 = count($row1);
$stmt2 = $GLOBALS['adopts']->query("SELECT * FROM {$GLOBALS['prefix']}online WHERE username = 'Visitor'");
$row2 = $stmt2->fetchAll();
$total2 = count($row2);
$sidebar .= "<a href='online.php'>This site has {$total1} members and {$total2} guests online.</a></ul>";
}
else {
$sidebar = "<b><u>Member Login:</u></b><br />
<form name='form1' method='post' action='login.php'>
<p>Username:
<input name='username' type='text' id='username'>
</p>
<p>Password:
<p> <input name='password' type='password' id='password'>
</p>
<p>
<input type='submit' name='Submit' value='Log In'>
</p>
</form>Don't have an account?<br /><a href='register.php'>Register Free</a><br /><a href='forgotpass.php'>Forgot Password?</a>";
$stmt1 = $GLOBALS['adopts']->query("SELECT * FROM {$GLOBALS['prefix']}online WHERE username != 'Visitor'");
$row1 = $stmt1->fetchAll();
$total1 = count($row1);
$stmt2 = $GLOBALS['adopts']->query("SELECT * FROM {$GLOBALS['prefix']}online WHERE username = 'Visitor'");
$row2 = $stmt2->fetchAll();
$total2 = count($row2);
$sidebar .= "<br />This site currently has {$total1} members and {$total2} guests.";
}
return $sidebar;
}
I'm pretty sure this is all of it..