Thread: Avatar in menu
View Single Post
  #13  
Old 04-01-2012, 06:42 AM
solskenn's Avatar
solskenn solskenn is offline
Member
 
Join Date: Mar 2012
Location: Ankh-Morpork
Posts: 73
Gender: Female
Credits: 7,689
solskenn is on a distinguished road
Default

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..
Reply With Quote