HEX

File: /var/www/html/tmpr/..//tmpr/..//tmpr/../tmpr/..//tmpr/..//tmpr/..//system/mobiphotos_ajx.php
<?php
if ($_POST['action'] == 'get_info' && (int)$_POST['id'] > 0) {
	
	$catalogid = $_POST['catalogid'];
include('../Connections/videoondemand.php'); 
    require_once('../system/classes/CMySQL.php'); // include service classes to work with database and comments
    require_once('../system/classes/CMyComments.php');

 
require("../DbSql.inc.php");
require("../NewsSql.inc.php");

$db = new NewsSQL($DBName);

    // get photo info
    $iPid = (int)$_POST['id'];
    $aImageInfo = $GLOBALS['MySQL']->getRow("SELECT * FROM `reporta` WHERE catalogid=$catalogid and yanani != $catalogid  and `newsid` = '{$iPid}'");

    // prepare last 10 comments
    $sCommentsBlock = $GLOBALS['MyComments']->getComments($iPid);

    $aItems = $GLOBALS['MySQL']->getAll("SELECT * FROM `reporta` WHERE catalogid=$catalogid and yanani != $catalogid  ORDER by `when` ASC"); // get photos info

    // Prev & Next navigation
    $sNext = $sPrev = '';
    $iPrev = (int)$GLOBALS['MySQL']->getOne("SELECT `newsid` FROM `reporta`  WHERE catalogid=$catalogid and yanani != $catalogid  and `newsid` < '{$iPid}' ORDER BY `newsid` DESC LIMIT 1");
    $iNext = (int)$GLOBALS['MySQL']->getOne("SELECT `newsid` FROM `reporta`  WHERE catalogid=$catalogid and yanani != $catalogid  and `newsid` > '{$iPid}' ORDER BY `newsid` ASC LIMIT 1");
    $sPrevBtn = ($iPrev) ? '<div class="preview_prev" onclick="getPhotoPreviewAjx(\''.$iPrev.'\')"><img src="system/template/images/prev.png" width="50" alt="prev" /></div>' : '';
    $sNextBtn = ($iNext) ? '<div class="preview_next" onclick="getPhotoPreviewAjx(\''.$iNext.'\')"><img src="system/template/images/next.png" width="50" alt="next" /></div>' : '';



$nameinfo2 = $db->getallugccatalogname();
if (!empty($nameinfo2)){
while (list($key,$val)=each($nameinfo2)) {
$tempcatalogid2 = stripslashes($val["catalogid"]);
$catalogname = stripslashes($val["catalogname"]);
if ($aImageInfo['yanani']==$tempcatalogid2)
{
$catalognameX =  "<strong>:</strong> $catalogname <br />
";
}
} 
}


 
                $nameinfoE = $db->getepisode($aImageInfo['episodeid']); 
                if (!empty($nameinfoE)){
	            while (list($key,$val)=each($nameinfoE)) {
		    $catalogid = stripslashes($val["catalogid"]);
		    $episodename = stripslashes($val["catalogname"]);
		 			
		   $episodenameX =  "<strong>Filed Under:</strong> $episodename"; 
		     
		 }
		}
                



    require_once('../system/classes/Services_JSON.php');
    $oJson = new Services_JSON();
    header('Content-Type:text/javascript');
    echo $oJson->encode(array(
        'data1' => '<img class="fileUnitSpacer" width="100%" src="'. $siteaddress2.'/taswira.php?width=300&image=/v/uploads/picdir/'. $aImageInfo['original'] .'">' . $sPrevBtn . $sNextBtn,
        'data2' => $sCommentsBlock,'data3' => $aImageInfo['title'] , 'data4' => $aImageInfo['content'] ,  'data5' => '<strong>Link: </strong>$siteaddress2/ugcchannel.php?vid=".$iPid."&slug=SamanthaBridal <br />
Published:'.$aImageInfo['adddate'] , 'data6' => $catalognameX, 'data7' => 'http://www.eziki.tv/'. $aImageInfo['slug'] , 'data8' =>  $episodenameX , 'data9' => 'Comments('.$aImageInfo['comments_count'] .')'
    ));
    exit;
}