HEX

File: /var/www/html/tmpr/../tmpr/..//tmpr/../tmpr/..//system/videos_ajx.php
<?php
if ($_POST['action'] == 'get_info' && (int)$_POST['id'] > 0) {

    require_once('../system/classes/CMySQL.php'); // include service classes to work with database and comments
    require_once('../system/classes/CMyComments.php');

include('../Connections/videoondemand.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 `usercontent` WHERE isdisplay=1 and `newsid` = '{$iPid}'");

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

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

    // Prev & Next navigation
    $sNext = $sPrev = '';
    $iPrev = (int)$GLOBALS['MySQL']->getOne("SELECT `newsid` FROM `usercontent` WHERE `newsid` < '{$iPid}' ORDER BY `newsid` DESC LIMIT 1");
    $iNext = (int)$GLOBALS['MySQL']->getOne("SELECT `newsid` FROM `usercontent` WHERE `newsid` > '{$iPid}' ORDER BY `newsid` ASC LIMIT 1");
  /*  $sPrevBtn = ($iPrev) ? '<div class="preview_prev" onclick="getVideoPreviewAjx(\''.$iPrev.'\')"><img src="system/template/images/prev.png" alt="prev" /></div>' : '';
    $sNextBtn = ($iNext) ? '<div class="preview_next" onclick="getVideoPreviewAjx(\''.$iNext.'\')"><img src="system/template/images/next.png" alt="next" /></div>' : '';*/
/*$ad = '<div class="preview_ad" ><img src="v/watermark2.png" width="665" alt="ADVERTISEMENT " /></div>';*/


$nameinfo2 = $db->getallugccatalogname();
if (!empty($nameinfo2)){
while (list($key,$val)=each($nameinfo2)) {
$tempcatalogid2 = stripslashes($val["catalogid"]);
$catalogname = stripslashes($val["catalogname"]);
if ($aImageInfo['catalogid']==$tempcatalogid2)
{
	$catalognameZ = " $catalogname ";
	
$catalognameX =  "<strong>Views:</strong> ".$aImageInfo['viewnum']." | <strong>By:</strong> ".$catalogname." |  
<strong>Link: </strong>$siteaddress2/ugcchannel.php?vid=".$iPid."&slug=MyStory";
}
} 
}


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

 

    require_once('../system/classes/Services_JSON.php');
    $oJson = new Services_JSON();
    header('Content-Type:text/javascript');
    echo $oJson->encode(array(
        'data1' => '<iframe width="1000" src="modalplay2.php?newsid='.$aImageInfo['newsid'].'"  height="600" frameborder="0" scrolling="no"></iframe>' . $sPrevBtn . $sNextBtn . $ad,
        'data2' => $sCommentsBlock,'data3' => $catalognameZ , 'data4' => $aImageInfo['content'] ,  'data5' => '' , 'data6' => $catalognameX, 'data7' => 'http://www.eziki.tv/'. $aImageInfo['slug'] , 'data8' =>  $episodenameX , 'data9' => ' '
    ));
    exit;
}

/*	 <object classid="clsid:d27cdb6e-ae6d-11cf-96b8-450053540000" style="-moz-border-radius:5px;-webkit-border-radius:5px;border-radius: 5px;" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0" name="channelplayer" width="1000" height="490" align="middle" id="channelplayer">
	<param name="allowScriptAccess" value="sameDomain" />
    <param name="FlashVars" value="videoXML='. $siteaddress2.'/addrivenplaylist?picha='.$iPid.'" />
	<param name="allowFullScreen" value="true" />
  
    
	<param name="movie" value="'. $siteaddress2.'/channelplayer.swf?var2=The page you are looking for is currently" /><param name="quality" value="high" /> 
		
	<embed src="'. $siteaddress2.'/channelplayer.swf" width="1000" height="490" align="middle" FlashVars="videoXML='. $siteaddress2.'/addrivenplaylist?picha='.$iPid.'" quality="high" name="channelplayer" allowScriptAccess="sameDomain" allowFullScreen="true" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer"    />
	</object>	*/