<?
error_reporting(0);

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


$status =0;
$sql = "CALL `get_NextLink_WithKeyWords_From_slideserve_links_ByStatus`(".$status.",@p1, @p2, @p3, @p4, @p5)";
$conn->execute($sql);
$sql = "SELECT @p1 AS `_uid`, @p2 AS `_vid`, @p3 AS `_username`, @p4 AS `_link`, @p5 AS `_keyword`";
$rs     = $conn->execute($sql);

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

$query ="https://www.google.com/search?num=100&q=site:".$linkOut;//For default query

//$query ="https://www.google.com/search?num=100&as_q=&as_epq=&as_oq=".$keyword."&as_eq=&as_nlo=&as_nhi=&lr=&cr=&as_qdr=all&as_sitesearch=http://www.slideserve.com/".$username."/*";//Anywhere in the page
if(!empty($keyword))
    $query ="https://www.google.com/search?num=100&as_q=&as_epq=&as_oq=".$keyword."&as_eq=&as_nlo=&as_nhi=&lr=&cr=&as_qdr=all&as_sitesearch=http://www.slideserve.com/".$username."/*&as_occt=url"; //from url
    
$str='{"link":"'.$linkOut.'","searchquery":"'.$query.'","uid":"'.$uid.'","username":"'.$username.'","vid":"'.$vid.'"}';
echo $str;

?>