File: /var/www/html/tmpr/..//tmpr/../tmpr/..//tmpr/..//tmpr/..//v/reports.php
<?php
function text_limit2($str,$limit)
{
if(stripos($str," "))
{
$ex_str=explode(" ",$str);
if(count($ex_str)>$limit)
{
for($i=0;$i<$limit;$i++)
{
$str_s.=$ex_str[$i]." ";
}
return $str_s;
}
else{
return $str;
}
}else{
return $str;
}
}
$page_limit = $record ;
if (!isset($_GET['spage']) )
{ $start=0; } else
{ $start = ($_GET['spage'] - 1) * $page_limit; }
$rs_all = mysqli_query("select count(*) as total_all from distributions where catalogid=$videouser") or die(mysql_error());
list($allvids) = mysql_fetch_row($rs_all);?>
<style type="text/css">
.style1 {
color: #009900;
font-weight: bold;
}
.style3 {font-size: 10px}
.even { background-color:#f2f2f2; background-color:transparent }
.odd { background-color:#E6E6E6;
color:#000000 }
.biger {
font-size: 16px;
}
</style>
<?php
if (empty($result2)) {
?>
No content has been submitted yet
<?php }
?>
<?php
if (!empty($result2)) {?>
<script type="text/javascript" src="scripts/multiple.js"> </script>
<table width="800" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td width="696" valign="top">
</td>
<td width="84" align="right" style="font-size:16px"><a href="javascript:goFeature()">Feature</a> | </td>
<td width="66" align="right" style="font-size:16px"><a href="javascript:goDelReport()"> Delete</a></td>
<td width="54" align="right" style="font-size:16px">
</td>
</tr>
</table>
<?php } ?>
<form action="" method="post">
<table width="800" border="0" cellpadding="2" cellspacing="1"<?php /*?> id="divReporta"<?php */?>>
<?php
if (!empty($result2)) {?>
<tr>
<td width="800" align="left">
<ul class="sort" style="padding-left:0px">
<table width="800" cellpadding="2" cellspacing="2" style="font-size:18px; color:#666; ">
<tr class="<?=($c++%2==1) ? 'odd' : 'even' ?>">
<td width="20" height="34"><input name="topcheckbox" type="checkbox" class="check" id="topcheckbox" onClick="selectall();" value="ON"></td>
<td width="83" align="left" valign="middle">
Picture
</td>
<td width="116" valign="middle" align="left"><p>Title<br />
</p></td>
<td width="133" valign="middle" align="left">Source</td>
<td width="87" valign="middle">Telephone</td>
<td width="68" align="center">Email</td>
<td width="54">Publish</td>
<td width="74">Download</td>
<td width="57" align="left" valign="middle">
Update </td>
<td width="44" valign="middle"> Location</td></tr></table>
<?php while ( list($key,$val)=each($result2) ) {
$newsid = stripslashes($val["newsid"]);
$catalogid = stripslashes($val["catalogid"]);
$title = stripslashes($val["title"]);
$picture = stripslashes($val["picture"]);
$viewnum = stripslashes($val["viewnum"]);
$isdisplay = stripslashes($val["isdisplay"]);
$yanani = stripslashes($val["yanani"]);
$video = stripslashes($val["video"]);
$adddate = stripslashes($val["adddate"]);
$original = stripslashes($val["original"]);
$latitude = stripslashes($val["latitude"]);
$longitude = stripslashes($val["longitude"]);
$vcat = stripslashes($val["vcat"]);
$cataname = $db->getcatalognamebyid($catalogid);
$newsid2 = $newsid;
?>
<div id="box<?php print "$newsid"; ?>">
<li id="<?php print "$newsid"; ?>" style=" width:900px; margin:0px; display:inline;border-bottom:dotted #666 1px; text-decoration:none">
<table width="800" cellpadding="2" cellspacing="2" style="font-size:12px">
<tr class="<?=($c++%2==1) ? 'odd' : 'even' ?>">
<td width="20"><input name="<?php print "$newsid"; ?>" type="checkbox" class="check"></td>
<td width="80" align="left" valign="middle">
<div class="img2">
<img src="../taswira.php?width=80&image=/v/uploads/raw/<?php print "$original"; ?>" width="80" height="40" vspace="5" alt="edit thumb"/></div>
</td>
<td width="112" valign="middle" align="left"><?php print text_limit2($title,20); ?>
<?php if($vcat == "1")
{ echo "Political";}
if($vcat == "0")
{ echo "General";}
if($vcat == "1")
{ echo "Political";}
if($vcat == "2")
{ echo "Business";}
if($vcat == "4")
{ echo "Crime";}
if($vcat == "5")
{ echo "Entertainment";}
if($vcat == "6")
{ echo "Technology";}
if($vcat == "7")
{ echo "Other";}
?> </td>
<td width="126" valign="middle" align="left"><?php $nameinfo2 = $db->getallugccatalogname();
if (!empty($nameinfo2)){
while (list($key,$val)=each($nameinfo2)) {
$tempcatalogid2 = stripslashes($val["catalogid"]);
$catalogname = stripslashes($val["catalogname"]);
if ($yanani==$tempcatalogid2){
print "$catalogname";
}
} } ?></td>
<td width="92"><?php $nameinfo2 = $db->getallugccatalogname();
if (!empty($nameinfo2)){
while (list($key,$val)=each($nameinfo2)) {
$tempcatalogid2 = stripslashes($val["catalogid"]);
$tel = stripslashes($val["tel"]);
if ($yanani==$tempcatalogid2){?>
<b title="<?php print "$tel";?>">t</b>
<?php }
} } ?></td>
<td width="78"><?php $nameinfo2 = $db->getallugccatalogname();
if (!empty($nameinfo2)){
while (list($key,$val)=each($nameinfo2)) {
$tempcatalogid2 = stripslashes($val["catalogid"]);
$user_email = stripslashes($val["user_email"]);
if ($yanani==$tempcatalogid2){
?>
<b title="<?php print "$user_email";?>">e</b>
<?php
}
} } ?></td><td width="49" valign="middle"><div align="center" class="style9"><span class="style6 style6">
<?php
switch($isdisplay){
case "1":
?>
<span id="unfeature<?php print "$newsid2"; ?>"> <a href="javascript:void(0);" onclick='$.get("ezikiframework.php",{ mode: "unfeature", newsid: "<?php print "$newsid2"; ?>" } ,function(data){ $("#unfeature<?php print "$newsid2"; ?>").html(data); });'><div class="style1">Yes</div></a></span>
<?php
break;
case "0":
?> <span id="feature<?php print "$newsid2"; ?>"> <a href="javascript:void(0);" onclick='$.get("ezikiframework.php",{ mode: "feature", newsid: "<?php print "$newsid2"; ?>" } ,function(data){ $("#feature<?php print "$newsid2"; ?>").html(data); });'><div class="">No</div></a></span> <?php
break;
case "3":
?> <span id="feature<?php print "$newsid2"; ?>"> <a href="javascript:void(0);" onclick='$.get("ezikiframework.php",{ mode: "feature", newsid: "<?php print "$newsid2"; ?>" } ,function(data){ $("#feature<?php print "$newsid2"; ?>").html(data); });'><div class="">No</div></a></span> <?php
break;
}
?>
</span></div></td>
<td width="71"><div align="center" class="style9"><span class="style6 style6"><a href="uploads/raw/<?php print "$original"; ?>">Download</a> </span></div></td> <td width="68" align="left" valign="middle">
<?php
$newsid = $db->base64url_encode($newsid); ?>
<?php
switch($isdisplay){
case "1":
?>
<a href="editreporta.php?newsid=<?php print "$newsid"; ?>" class="en_b style6 style6">Update</a>
<?php
break;
case "2":
?>
<a href="editreporta.php?newsid=<?php print "$newsid"; ?>" class="en_b style6 style6">Update</a>
<?php
break;
case "3":
?>
<a href="editreporta.php?newsid=<?php print "$newsid"; ?>" class="en_b style6 style6">Update</a>
<?php
break;
case "0":
?>
<a href="editreporta.php?newsid=<?php print "$newsid"; ?>" class="en_b style6 style6"><strong>Publish</strong></a>
<?php
break;
}
?>
</td>
<td width="40" valign="middle"> <a href="https://maps.google.com/?q=<?php print "$latitude"; ?>,<?php print "$longitude"; ?>" target="_blank" class="en_b style6 style6"><strong>Map</strong></a></td></tr></table>
</li> </div>
<?php
}
}
?>
</ul> </td>
</tr>
</table>
</form>
<h4>
<?php
$pagenext = $page+1;
$result21 = $db->submittedreports($pagenext,$record,$catid);
if ($page!=0)
{
$pagepre = $page-1;
print "<a href=\"$PHP_SELF?page=$pagepre&catid=$catid#a\">< Back </a> ";
}
if (!empty($result21))
{
print " <a href=\"$PHP_SELF?page=$pagenext&catid=$catid#a\">Next ></a> ";
}
?></h4>
</div>
<form action="javascript:sorteddata()" id="sform" method="post">
<input name="mode" type="hidden" value="sortdata" size="60" id="mode">
<input name="sortdata" id="sortdata" type="hidden" value="" />
</form>