<?
ob_start();
session_start();
if($_SESSION['uname']=='' || $_SESSION['pwd']=='')
		{
			header("location:login.php");
		}
 include("../include/db.inc.php");
 include("../include/pager.php"); 
 include("../include/bit_functions.inc.php");
   $db1=new db;
   $db1->open();
    mysql_query("SET NAMES 'utf8'");
   
   
   if(isset($_GET['blocked']))
{
$blocked=$_GET['blocked'];

if($blocked==1)
$blocked=0;
else
$blocked=1;
$idea_id=$_GET['idea_id'];
$sql="update idea set blocked='$blocked' where idea_id='$idea_id'";
mysql_query($sql);
header("location:show_ideas.php");
exit();
}
   	if($_GET['del']){
		
		   $del_query=mysql_query("delete from idea where idea_id=".$_GET['del']);
			
		}
		
		
	

?>

<!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>NEWADMIN</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link href="../css/stylesheet.css" rel="stylesheet" type="text/css">

<script language="JavaScript" src="../js/common.js"></script>
<script language="JavaScript">
function veiwmem(id){
			window.open('view_user.php?id='+id,'','width=800,height=800,top=5,left=180');		
	}	
	
	function veiwideas(id){
			window.open('view_ideas.php?idea_id='+id,'','width=800,height=800,top=5,left=180');		
	}	
	</script>
<style type="text/css">
<!--
.style1 {color: #093A9C}
.style2 {color: #FE6905}
-->
</style>
</head>
<body bgcolor="#ffffff">
<div class="admin_wrapper">
<div class="logo_show"><? include("minorlogout.php");?></div>
<div style="float:left; width:200px">
<div class="topg_links_show"><? include("left.php");	?></div>
<div class="top_links_show"><? include("belowleft1.php");	?></div></div>
<div style="float:left; width:800px">
<div class="maximum">


<!--::::::::::::::::::::::::::::::::::::::::::::::::::::::::::center starts:::::::::::::::::::::::::::::::::::::::::::::::::::::-->





	  <table  width="100%" border="0" cellpadding="0" cellspacing="0" class="bodytxt">
  <tr> 
    <td width="15" 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>USER IDEAS LIST </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" height="185" valign="top" background="img/tbl-left04.gif">
          <img border='0' src="img/tbl-left04.gif" width="22" height="13"></td>
          <td valign="top" align="center"><br>		  		  		             
	
                   <form action="" method="post" enctype="multipart/form-data" name="form1">
                    <table width="100%" border="1" cellspacing="1" cellpadding="1" style="border-collapse:collapse; border-color:#FED267">
                      <tr bgcolor="#FED267"> 
					   <td width="4%"  align="center"><strong><font color="#FFFFFF">ID</font></strong></td>
                        <td width="31%" >&nbsp;&nbsp;<strong><font color="#FFFFFF">Ideas Title</font></strong></td>
                        <td width="21%" >&nbsp;&nbsp;<strong><font color="#FFFFFF">Username</font></strong></td>
                        <td width="13%" ><strong><font color="#FFFFFF">Points</font></strong></td>
                        <td width="16%" height="21" align="center"><font color="#FFFFFF"><strong>Ideas Action</strong></font></td>
                        <td width="9%" height="21" align="center"><strong><font color="#FFFFFF">Delete</font></strong></td>
                      </tr>
					  
					  <?
					  
					  $i=1;
					  $sel_query=mysql_query(dopaging("select * from idea",10)) or die(mysql_error());
					  
                      while($myrow=mysql_fetch_array($sel_query)){  ?>
                      <tr <?php /*?><? if($i%2==0)echo 'bgcolor="#E6E4E3"';?><?php */?> onMouseOver="this.style.backgroundColor='#FFECBF'" onMouseOut="this.style.backgroundColor='#ffffff'"> 
					  <td  align="center"><?=$myrow['idea_id'];?></td>
                      <td > <a class="link5" style="font-size:12px;"  href="javascript:veiwideas(<?=$myrow['idea_id']?>)" title="Click To View Ideas Information" >
					  <?=$myrow['title']?></a></td>	
                              
                        <td >&nbsp;&nbsp;
						<a class="link5" style="font-size:12px;"  href="javascript:veiwmem(<?=$myrow['publisher_id']?>)" title="Click To View User Information" >
						<?=get_fieldval(id,uname,user,$myrow['publisher_id'])?></a></td>
                       
                        <td style="padding-left:5px;"><?=$myrow['points'];?></td>
                       
                        <td >&nbsp;&nbsp;&nbsp;&nbsp;
						<?
						if($myrow['blocked']=='1')
						{
						?>
		<a href="show_ideas.php?blocked=<?=$myrow['blocked'];?>&idea_id=<?=$myrow['idea_id']?>">
		<input  name="chk[]" type="checkbox" checked 
        onClick="window.location='show_ideas.php?blocked=<?=$myrow['blocked'];?>&idea_id=<?=$myrow['idea_id']?>'" >
        </a>
		                 <?
                            }
						else
						
						   {
						   ?>
		<a href="show_ideas.php?blocked=<?=$myrow['blocked'];?>&idea_id=<?=$myrow['idea_id']?>">
        <input  name="chk[]" type="checkbox" 
        onClick="window.location='show_ideas.php?blocked=<?=$myrow['blocked'];?>&idea_id=<?=$myrow['idea_id']?>'" >
		</a>
                             <?
						   }	
						
						?>
						</td>
                      
                        <td align="center">
						  <table><tr><td></td>
						  
          <td><a href="show_ideas.php?del=<?=$myrow['idea_id']?>"  onClick="return confirm('Are you sure to delete this Ideas ?');"><img src="../images/category/imgdelete.gif" border="0"></a></td></tr></table>
                        </td>
                      </tr>
                      <? $i++;
									} if(rightpaging())?>
				<tr><td colspan=3 align=center><br><?=rightpaging()?></td></tr>
                    </table>
                 </form>
      </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>
  </tr>
  
</table>



<!--::::::::::::::::::::::::::::::::::::::::::::::::::::::::::center ends:::::::::::::::::::::::::::::::::::::::::::::::::::::
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::footer starts:::::::::::::::::::::::::::::::::::::::::::::::::::::-->
</div></div>
<div class="bottom_links_show"><? include("footer.php");	?></div>
</div>
<!--::::::::::::::::::::::::::::::::::::::::::::::::::::::::::footer ends:::::::::::::::::::::::::::::::::::::::::::::::::::::-->
</body>
</html>