<?
$link = mysql_pconnect("172.30.254.189:3306","in-code-rw","EDhdfjh58ayjioG");

echo "\nRan at: " . date("YmdHis") . "\n";
if (!$link)
{
            die('Could not connect: ' . mysql_error());
}
mysql_select_db('inrevampdb') or die(mysql_error());


$options = array(
                         CURLOPT_RETURNTRANSFER => true,     // return web page
                         CURLOPT_HEADER         => false,    // don't return headers
                         CURLOPT_FOLLOWLOCATION => true,     // follow redirects
                         CURLOPT_ENCODING       => "",       // handle all encodings
                         CURLOPT_USERAGENT      => "User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6)     Gecko/20070725 Firefox/2.0.0.6", // who am i
                         CURLOPT_AUTOREFERER    => true,     // set referer on redirect
                         CURLOPT_CONNECTTIMEOUT => 120,      // timeout on connect
                         CURLOPT_TIMEOUT        => 120,      // timeout on response
                         CURLOPT_MAXREDIRS      => 10,       // stop after 10 redirects
                );


 $sql_qr="SELECT id,microsite,name,image,entityId,data,flag,publishDate FROM ms_contenstants WHERE status=1";

        $result= mysql_query($sql_qr);

        if(!$result)
                echo mysql_error();
        else
        {
                while($row = mysql_fetch_assoc($result))
                {

                                 $id = $row['id']."\n";
                                 $microsite = $row['microsite'];
                                 $name = $row['name'];
                                 $image = $row['image'];
				 $entityId = $row['entityId'];
				 $data = $row['data'];
			         $flag = $row['flag'];
				 $publishdate = $row['publishDate'];		


			 insertintoSolr($id,$microsite,$name,$image,$entityId,$data,$flag,$publishdate);
			//exit;	
                }
               $link = mysql_pconnect("172.30.254.189:3306","in-code-rw","EDhdfjh58ayjioG");
               mysql_select_db('inrevampdb') or die(mysql_error());
}


function initializeCurl($link)
{
        $ch = curl_init();
        global $options;
        curl_setopt_array( $ch, $options );
        curl_setopt($ch, CURLOPT_URL, $link);
        $output = curl_exec($ch);
        curl_close($ch);
        return $output;
}


function insertintoSolr($id,$microsite,$name,$image,$entityId,$data,$flag,$publishdate){
                $ch     = curl_init ();
                global  $options;
                curl_setopt_array ($ch, $options);
                                $vars = $vars. "id=".urlencode($id);
                                $vars = $vars. "&microsite=".urlencode($microsite);
                                $vars = $vars. "&entity=".urlencode($name);
                                $vars = $vars. "&thumbnail=".urlencode($image);
                                $vars = $vars. "&entityId=".urlencode($entityId);
                                $vars = $vars. "&data=".urlencode($data);
                                $vars = $vars. "&flag=".urlencode($flag);
                                $vars = $vars. "&publishdate=".urlencode($publishdate);

               $url ="http://api.in.com/active18/solr/rewamp/color/solr_add_color_microsite_entity.php?".$vars;
		//echo "\n\n\n";
               //exit;
                curl_setopt($ch, CURLOPT_URL,$url);
                curl_setopt($ch,CURLOPT_POST,1);
                curl_setopt($ch, CURLOPT_POSTFIELDS, $vars);
                $con = curl_exec ($ch);
                echo $con . "\n\n";
               curl_close ($ch);
}
?>