proggen.org

Code: Alles auswählen

<?php
   if (is_array($_GET))
   {
       $get=$_GET;
   }
   else
   {
       $get=$HTTP_GET_VARS;
   };
   if (array_key_exists("page", $get))
   {
       $page=$get["page"];
   }
   else
   {
       $page="overview";
   };
   if (array_key_exists("board", $get))
   {
       $board=$get["board"];
   }
   else
   {
       $board=NULL;
   };
   if (array_key_exists("thread", $get))
   {
       $thema=$get["thread"];
   }
   else
   {
       $thema=NULL;
   };
   if (array_key_exists("action", $get))
   {
       $action=$get["action"];
   }
   else
   {
       $action="overview";
   };
  
if ($login!=NULL)
{  
    if ($board==NULL and $thread==NULL)
    {
        echo('
	   <center>
	     <TABLE background="'.$mainbg.'" width="800px">
		      <TR>
		        <TD valign="top">
			       <!--Forum BEGIN -->
				   
				   ');
				   
				   
        $query="SELECT id, name FROM `forum-cat` ORDER BY `id` ASC";
        $abfrage=$db->query($query, MYSQLI_STORE_RESULT);
        $a=1;
        while ($res=$abfrage->fetch_assoc())
        {
            $id[$a]=$res["id"];
	        $name[$a]=$res["name"];
	        $a++;
        };
		
		echo('<H1>'.$name[$b].'</H1>');
		$query="SELECT id, name FROM `forum-board` WHERE `cat_id`=$b";
		$abfrage=$db->query($query, MYSQLI_STORE_RESULT);
		while ($res=$abfrage->fetch_assoc())
		{
		    echo('
			    <STRONG><A href="index.php?position=forum&board='.$res["id"].'">'.$res["name"].'</A></STRONG>
			');
		   	$query="SELECT id FROM `forum_thread` WHERE `board`=$b";
			$abfrage=$db->query($query, MYSQLI_STORE_RESULT);
			$a=0;
			while ($res=$abfrage->fetch_assoc())
			{
			    $a++;
			    $id[$a]=$res["id"];
			};
			$Xid=count($id);
			echo($Xid.'<BR />');
		};
		
        echo('  
	         <!--Forum END-->
	         </TD>
	       </TR>
		    </TABLE>
	   </center>
	  ');
    }
    else
    {
     
    };
}
else
{
    echo('
	
	<center>
	  <TABLE background="'.$mainbg.'" width="800px">
	    <TR>
		  <TD valign="top">
		    <center><P style="color: '.$errcolor.'">Sie haben keine Recht auf das Forum zuzugreifen. Bitte melden sie sich an, oder registrieren sie sich <A href="index.php?position=register" target="regsiter">hier</A>.</P></center>
		  </TD>
		</TR>
      </TABLE>
	</center>
	
	');
};
?>

Code: Alles auswählen

$query="SELECT b.id, b.name, COUNT(t.id) AS thread_count FROM `forum-board` b, `forum_thread` t WHERE b.`cat_id`=$b AND t.`board` = $b";