<?
include('faqsetup.inc');
//$usertype = 'admin';
$usertype = 'user';

?>
<HTML>
<HEAD>
<TITLE><? echo($faqtitle); ?></TITLE>
</HEAD>
<BODY background="<? echo($backgroundimage);?>">
<?
require($headerfile);

	// Get list of folders...
 	$link = sybase_pconnect ( $databaseserver, $databaseuser, $databasepassword) ;   
	sybase_select_db($databasename, $link);
#	$res = sybase_query("SELECT * FROM $docclasstable ORDER BY ClassName",$link);
	$res = sybase_query("SELECT * FROM $docclasstable",$link);
	if  ($res )  {   
         $nrows = sybase_num_rows ($res ) ;   
         $nfields = sybase_num_fields ($res ) ;   
         $rowarr = sybase_fetch_array ($res ) ;
	}  else  {  
          echo  (  "<BR>Your query did not find any folders Try again<BR>\n" ) ;   
	}
	
	//get list of faq's...
	$resqa = sybase_query("SELECT * FROM $faqtable ORDER BY Question",$link);
	if  ($resqa )  {   
         $qanrows = sybase_num_rows ($resqa ) ;   
         $qanfields = sybase_num_fields ($resqa ) ;   
         $qarowarr = sybase_fetch_array ($resqa ) ;
	}  else  {  
          echo  (  "<BR>Your query did not find any Documents Try again<BR>\n" ) ;   
	}
?>
<div align="center">
<?
// DISPLAY THE ADD LINKS
	if ( $usertype == 'admin') {	?> 
  <p align="right"><A HREF='folderedit.php?action=edit&amp;add=1&amp;id=0'>[Add 
    Folder]</A><A HREF='faqedit.php?action=edit&amp;add=1&amp;id=0'>[Add FAQ]</A></p>
  <p>
    <?	}

//  End of header stuff
function drawfolder ($classid, $nrows, $res,$ind,$resqa,$qanrows, $usertype) {
	$ind=$ind + 1;
	for ($k=0 ; $k < $nrows ; $k++ ) {
		sybase_data_seek ($res, $k);
		$rowarr = sybase_fetch_array ($res ) ;
		if( doubleval ($rowarr[ParentID]) == doubleval ($classid) ) { 
			echo ("<B>");
			for ($i=2 ; $i < $ind ; $i++ ) {
				?>&nbsp &nbsp &nbsp <?
			}
			// DRAW THE FOLDER LEAF
			echo ("<IMG align=bottom SRC='./fc.gif'> &nbsp ");
			echo ($rowarr[ClassName]);
			if ( $usertype == 'admin') {
				echo ("\n&nbsp&nbsp<A HREF='folderedit.php?action=edit&id=".doubleval ($rowarr[ClassID]) ."'>[Edit]</A>");
			}
			echo ("</B><BR>");

			for ($qai=0 ; $qai < $qanrows ; $qai++ ) {
				sybase_data_seek ($resqa, $qai);
				$qarowarr = sybase_fetch_array ($resqa ) ;
				sybase_data_seek ($res, $k);
				$rowarr = sybase_fetch_array ($res ) ;
					if ( doubleval ($qarowarr[1]) == doubleval ($rowarr[0])) {
						for ($i=2 ; $i < $ind ; $i++ ) {
						?>&nbsp &nbsp &nbsp <?
					}	
					echo ("\n&nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp<A HREF='faqview.php?ParentID=" .doubleval ($rowarr[ClassID]) ."#" .doubleval ($qarowarr[0]) ."'>" .$qarowarr[2] ."</A><BR>");
					}
			} 
			drawfolder($rowarr[ClassID],$nrows,$res,$ind,$resqa,$qanrows, $usertype);
		}
}
} // End of Draw Folder
//DISPLAY THE TABLE HEADER	?> </p>
  <TABLE width=600 cellspacing="1" CELLPADDING="3" BORDER=0>
    <TR BGCOLOR="#000000"> 
      <TD> <FONT color=white><B><? echo ($faqtitle); ?></B></FONT> </TD>
    </TR>
  </TABLE>
  <? //END OF TABLE HEADER
//DISPLAY THE TREE ?> 
  <TABLE width=600 cellspacing="1" CELLPADDING="3" BORDER=0>
    <TR BGCOLOR="#ffffff"> 
      <TD align=left> <? drawfolder(1,$nrows,$res,1,$resqa,$qanrows, $usertype); ?> </TD>
    </TR>
  </TABLE>
  <? //END OF DISPLAY TREE ?> </div>
<? require($footerfile) ?>
</BODY>
</HTML>














