Mysidia Adoptables Support Forum

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..