<?
error_reporting(0);

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

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

$sql ="CALL `get_NextUserStatus_From_Slideserve_User_Status`(@p0)"; 
$conn->execute($sql);

$sql ="SELECT @p0 AS `_status`";
$rs = $conn->execute($sql);

$status = $rs->fields['_status'];

$status =27;
$sql = "CALL `get_NextLink_From_slideserve_links_ByStatus`(".$status.",@p0, @p1, @p2, @p3)";
if($status>30)
    $sql = "CALL `get_NextLink_From_slideserve_links_ByStatus1`(".$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'];
$query ="https://www.google.com/search?num=100&q=site:http://www.slideserve.com/".$username."/*";
if($status>30)
    $query ="https://www.google.com/search?num=100&q=site:".$linkOut;

switch ($status) {
    case 1:
        $query ="https://www.google.com/search?num=100&q=site:http://www.slideserve.com/".$username."/*";
        break;
    case 2:
       $query ="https://www.google.com/search?num=100&q=site:http://www.slideserve.com/".$username."/*";
        break;
    case 3://url the
         $query ="https://www.google.com/search?num=100&as_qdr=all&q=allinurl%3A+@the@+site%3Ahttp://www.slideserve.com/".$username."/*";
        break;
    case 4://url a
        $query ="https://www.google.com/search?num=100&as_qdr=all&q=allinurl%3A+@a@+site%3Ahttp://www.slideserve.com/".$username."/*";
        break;
    case 5://url and
       $query ="https://www.google.com/search?num=100&as_qdr=all&q=allinurl%3A+@and@+site%3Ahttp://www.slideserve.com/".$username."/*";
        break;
    case 6://url of
       $query ="https://www.google.com/search?num=100&as_qdr=all&q=allinurl%3A+@of@+site%3Ahttp://www.slideserve.com/".$username."/*";
        break;
    case 7://url to
        $sql = "CALL `get_nextKeyWordByUserId`(".$uid.",@p0, @p1)";
        $conn->execute($sql);
        $sql = "SELECT @p0 AS `_keyword`, @p1 AS `_count`";
        $rs     = $conn->execute($sql);
        $keyword = $rs->fields['_keyword'];
        //$query ="https://www.google.com/search?num=100&as_qdr=all&q=allinurl%3A+@to@+site%3Ahttp://www.slideserve.com/".$username."/*";
        $query ="https://www.google.com/search?num=100&as_qdr=all&q=allinurl%3A+@".$username."/".$keyword."*@+site%3Ahttp://www.slideserve.com/".$username."/*";
        break;
     case 8://url to
     case 11://url to
     case 12://url to
     case 13://url to
     case 14://url to
     case 15://url to
     case 16://url to
     case 17://url to
     case 18://url to
     case 19://url to
     case 20://url to
        $sql = "CALL `get_nextKeyWord_byUserIdAndStatus`(".$uid.",".$status.",@p0, @p1)";
        $conn->execute($sql);
        $sql = "SELECT @p0 AS `_keyword`, @p1 AS `_count`";
        $rs     = $conn->execute($sql);
        $keyword = $rs->fields['_keyword'];
        //$query ="https://www.google.com/search?num=100&as_qdr=all&q=allinurl%3A+@to@+site%3Ahttp://www.slideserve.com/".$username."/*";
        $query ="https://www.google.com/search?num=100&as_qdr=all&q=allinurl%3A+@".$username."/".$keyword."*@+site%3Ahttp://www.slideserve.com/".$username."/*";
        break;
    case 21://url to
    case 22://url to
    case 23://url to
    case 24://url to
    case 25://url to
    case 26://url to
    case 27://url to
    case 28://url to
    case 29://url to
    case 30://url to
        $sql = "CALL `get_nextKeyWord_byUserIdAndStatus`(".$uid.",".$status.",@p0, @p1)";
        if($status>24)
          $sql = "CALL `get_nextKeyWords_byUserIdAndStatus`(".$uid.",".$status.",@p0, @p1)";
        $conn->execute($sql);
        $sql = "SELECT @p0 AS `_keyword`, @p1 AS `_count`";
        $rs     = $conn->execute($sql);
        $keyword = $rs->fields['_keyword'];
        //$query ="https://www.google.com/search?num=100&as_qdr=all&q=allinurl%3A+@to@+site%3Ahttp://www.slideserve.com/".$username."/*";
        $query ="https://www.google.com/search?num=100&as_qdr=all&q=allinurl%3A+@".$keyword."*@+site%3Ahttp://www.slideserve.com/".$username."/*";
        if($status >26)
            $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
        else if($status >24)
            $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."/*";
        //$query ="https://www.google.com/search?num=100&as_epq=&as_oq=".$keyword."&as_eq=&as_nlo=&as_nhi=&lr=&cr=&as_qdr=all&as_sitesearch=http://www.slideserve.com/".$username."/*";
            //$query ="https://www.google.com/search?num=100&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
        break;
    case 9://url to
       $query ="https://www.google.com/search?num=100&as_qdr=all&q=allinurl%3A+@to@+site%3Ahttp://www.slideserve.com/".$username."/*";
        break;
    case 10://url in
       $query ="https://www.google.com/search?num=100&as_qdr=all&q=allinurl%3A+@in@+site%3Ahttp://www.slideserve.com/".$username."/*";
        break;
    
}


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