Stuff

<?php 
//if(!empty($_GET)) extract($_GET);
$requiresession=1;
include 'global.php';

$title = "Your Music Reviews, News, and Discussion";
$genre=0;
$index=1;
$fullpage=1;
$showad=1;

$release = clean($_GET['release']);
$start = clean($_GET['start']);
$start2 = clean($_GET['start2']);
$start3 = clean($_GET['start3']);
$year = clean($_POST['year']);
$sort = clean($_GET['sort']);
if ($start2 < 0){ $start2 = 0;}

numcheck($release);
numcheck ($start);
numcheck ($start2);
numcheck ($start3);
numcheck ($year);
numcheck ($sort);

include 'reviewfunctions.php';
include 'genrefunctions.php';
include 'header.php';

if ($year == null){
		$year=2006;
	}
	
if ($start == null){
		$start=0;
}
if ($start2 == null){
		$start2=0;
}
if ($start3 == null){
		$start3=0;
}

if ($tag == null){
$tag = 0;
}

?>

 <table width="100%" border="0" cellspacing="0" cellpadding="12">
                <tr>
                  <td valign="top">
<?
                
$ismoderator = ismoderator();
if ($ismoderator == 1){
	// See if any tabs are in approval
	$query = "Select approved from reviews where approved=1";
	$result = mysql_query($query);
	$num_rows = mysql_num_rows($result);

	$query = "Select approved from bandmembers where approved=1";
	$result = mysql_query($query);
	$num_rows2 = mysql_num_rows($result);

	$query = "Select bandid from bqueue";
	$result = mysql_query($query);
	$num_rows3 = mysql_num_rows($result);

	$query = "Select approved from albums where approved=1";
	$result = mysql_query($query);
	$num_rows4 = mysql_num_rows($result);

	if ($num_rows > 0 || $num_rows2 > 0 || $num_rows4 > 0 || $num_rows3 > 0){
		echo "<p class=plaincontentbox><font size=1><b>Mod:</b> <A href=approval.php>" . $num_rows . " Reviews</a> / <A href=approval_album.php>" . $num_rows4 . " Albums</a> / <A href=modbandedit.php>" . $num_rows3 . " Bands</a> / <A href=modbandmemberedit.php>" . $num_rows2 . " Band Members</a></p>";
	}
}
?>

<?
if ($start2 < 0){ $start2=0; }

reviewlist_main(6,0,$start2,$release);


 ?>
<br>




				  <? reviewlist(12,0,$start,$tag,$sort); echo "<br>";  ?>

  <p class=profilebox2 style="padding:2px;" >
<?
include 'static/lists.html';
 ?>
</p>
<? include 'static/soundoff0.html'; ?>
 
                          </td>
                         <td valign="top" width=265 class="indexright">

                          <?

                          if ($_SESSION["uid"] == 0) {
?>
  <p align="left" class=contentbox>

  <font size=1>Sputnikmusic<font class=mediumtext size=1> isn't just another review site.
                            Here, <i>you</i> decide what's worth listening to. <A title="An example of how you can rate your music" target=_blank href=http://www.sputnikmusic.com/uservote.php?memberid=1><b>Rate your music</b></a>, write and read reviews, and talk about the albums that you love. While doing so, you'll create a <a title="an example music profile" target=_blank href="http://www.sputnikmusic.com/user/mx"><b>musical profile</b></a>, and find a lot of great music!<br>

                            <br><font size=1>
                             <font color="#999999"><a href="register.php"><b>Get Started</b></a></font><font color="#666666"> |
                            <font color="#999999"><a href="login.php">Login</a></font>
                            </p>
<? } ?>
<form name=form action=search_results.php>
<p style="margin-top:0px;" class=contentbox>
<input name="search_text" type="text" id="search_text" size="18" style="margin-bottom: 2px;" class="searchbox" onFocus="MM_setTextOfTextfield('search_text','','')" value="Find a Band">

                    <input type="hidden" name="genreid" value="<?php echo($genre); ?>">

                    <input type="hidden" name="search_in" value="Bands">
                    <input type="Submit" name="Go" value="Go" style="font-family: Verdana; font-size: 8pt;"><br>
                   <? vbsummary(); ?>
                    </p>
</form>
                          <?
                           
                          if ($_SESSION["uid"] == 0) {

//latestratings2(4);
party($genreid);
saying(0);
include 'static/newsnon.html';

 } else {

                        
party($genreid);
                          
include 'static/news.html';
                        
saying(0);

}

//rankings(0,$year,8);
weekdig(0);
                          ?>
                          <p class=contentbox>
                          <?
$array = array(23,25,24,4);
                     //vbthreads(8,$array);
    include 'static/journals.html';
                          ?>
</p>
                        </td>

                      </tr>
                    </table>
			  <?



include 'footer.php';



?>