<?
error_reporting(0);

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

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


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

$sql = "SELECT @p0 AS `_link`, @p1 AS `_uid`, @p2 AS `_username`, @p3 AS `_vid`";
$rs     = $conn->execute($sql);

$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;
?>