<?
error_reporting(0);

include('../include/config.php');

/*$sql = "select * from video limit 5";
$rs = $conn->execute($sql);
echo $rs->fields['VID'];*/


$statusHTML =$_GET['statusHTML'];
$count =$_GET['count'];
if(!$statusHTML)
    $statusHTML =0;
if(!$count)
	$count = 10;
//$sql = "CALL `get_NextLink_From_slideserve_links_ByStatus`(".$status.",@p0, @p1, @p2, @p3)";
//$conn->execute($sql);

$sql = "SELECT CONCAT('http://www.slideserve.com/',u.username,'/',sl.link) AS _link,sl.VID As _vid, sl.UID AS _uid, u.username AS _username FROM `slideserve_links` AS sl, `signup` AS u WHERE sl.statusHTML =".statusHTML." AND sl.UID = u.UID limit ".count."";
//$sql = "SELECT @p0 AS `_link`, @p1 AS `_uid`, @p2 AS `_username`, @p3 AS `_vid`";
$rs     = $conn->execute($sql);
echo $rs->fields['_link'];
die();

$linkOut = $rs->fields['_link'];
$uid = $rs->fields['_uid'];
$username = $rs->fields['_username'];
$vid = $rs->fields['_vid'];


$str='{"link":"'.$linkOut.'","uid":"'.$uid.'","username":"'.$username.'","vid":"'.$vid.'"}';
echo $str;
?>