<?
ob_start();
session_start();
 include("../include/db.inc.php"); 
 include("../include/bit_functions.inc.php"); 
   $db1=new db;
   $db1->open();
    mysql_query("SET NAMES 'utf8'");  	
   if($_SESSION['uname']=='' || $_SESSION['pwd']=='')
		{
			header("location:login.php");
		}
$idea_id=$_GET['idea_id'];
$sql_qry=mysql_query("select * from idea where idea_id=".$idea_id);	
$mypro=mysql_fetch_array($sql_qry);
?> 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

  <title><?=_TITLE1_?> ADMINISTRATOR</title>  
<link href="../css/stylesheet.css" rel="stylesheet" type="text/css">
</head>
<style type="text/css">
<!--
.style1 {color: #093A9C}
.style2 {color: #FE6905}
-->
</style>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="98%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr>    
    <td width="10" align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top"><table  width="100%" border="0" cellpadding="0" cellspacing="0" class="bodytxt">
        <tr> 
          <td width="1" valign="top">&nbsp;</td>
          <td valign="top"><br> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="bodytxt">
              <tr> 
                <td width="33" valign="top"><img src="img/03.gif" width="33" height="23"></td>
                <td background="img/bg01.gif"><strong>&nbsp;VIEW IDEAS</strong></td>
                <td width="35"><img src="img/04.gif" width="35" height="23"></td>
              </tr>
            </table>
            <table  width="100%" border="0" cellpadding="0" cellspacing="0" class="bodytxt">
              <tr> 
                <td width="22" valign="top" background="img/tbl-left04.gif"><img src="img/tbl-left04.gif" width="22" height="13"></td>
                <td valign="top" align="center"> <br> 
                  <br> 
                    <table width="90%"  border="0" cellpadding="2" cellspacing="1" bgcolor="#CCCCCC">
                    
                      <tr bgcolor="#FFFFFF"> 
                        <td width="15%" class="txt" style="padding-left:10px;">Idea Action Show</td>
                        <td width="54%" style="padding-left:10px;">
						<? if($mypro['blocked']==1){
								echo "Yes";
								}else{
								echo "No";
								}
							
							?>
                            
                          </td>
                      </tr>
                      <tr bgcolor="#FFFFFF"> 
                        <td class="txt" style="padding-left:10px;">Idea Title :</td>
                        <td style="padding-left:10px;"><?=$mypro['title']?></td>
                      </tr>
                      <tr bgcolor="#FFFFFF"> 
                        <td height="28" class="txt" style="padding-left:10px;">User :</td>
                        <td style="padding-left:10px;"><?=get_fieldval(id,uname,user,$mypro['publisher_id'])?></td>
                      </tr>
                      <tr bgcolor="#FFFFFF"> 
                        <td class="txt" style="padding-left:10px;">Points :</td>
                        <td style="padding-left:10px;"><?=$mypro['points'];?></td>
                      </tr>
					  <tr bgcolor="#FFFFFF"> 
					<?  $s2=mysql_query("select id from idea_comment where idea_id='$mypro[idea_id]'");
						$comment=mysql_num_rows($s2);
						?>
                        <td class="txt" style="padding-left:10px;">Comments :</td>
                        <td style="padding-left:10px;"><?=$comment?>&nbsp;Comments</td>
                      </tr>
                     
                      <tr bgcolor="#FFFFFF"> 
                        <td class="txt" style="padding-left:10px;">Description 
                          :</td>
                        <td style="padding-left:10px;"><?=$mypro['body']?></td>
                      </tr>
                    </table>
                    <br>
                  
                  <br> </td>
                <td width="19" valign="top" background="img/tbl-right04.gif"><img src="img/tbl-right04.gif" width="19" height="9"></td>
              </tr>
            </table>
            <table width="100%" border="0" cellpadding="0" cellspacing="0" class="bodytxt">
              <tr> 
                <td width="33"><img src="img/tbl-bot01.gif" width="33" height="12"></td>
                <td  width="709" align="right" background="img/tbl-bg.gif"></td>
                <td width="33"><img src="img/tbl-right05.gif" width="35" height="12"></td>
              </tr>
            </table></td>
          <td width="20" valign="top">&nbsp;</td>
        </tr>
      </table>
      <br>
      <br>
      <br>
    
    </td>
  </tr>
</table>
</body>
</html>
