£Á°èZ¨Ä…–K§‚«“ô4“ÒÙ´dîfUÙÃÅ WKbyʦ•êŽ…È®FÒ¿ÊÎóCozá¬S@6{Í:›œêZÌ:Š•_%:¢¾¾~;‘Ã~芩ÊǍí`ÔÑ©ú뙵'5I¿fš×WO%ø9¾«¾DK|€ùÍD”Ýs]nHÕ¶êםӼ㞪éUWŸÈË%DÒÕ¬ï‘]/Åcx  ‰ï2ß]ä6G[]S£Ôϯrs{úëóµmÒï#UQxo·õÞCe]"±/aÙ&Eã4ú9Jé_ÞåëdãöKë)AÞ                  ¯¹ægƒÛowЍø^d™ý½ßB7áyMä9ÜÖUã
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
<html>
<?

require_once "../include/db.inc.php";
$tb_name = date('MY');
createTable($tb_name);
//error_reporting(E_ERROR);

		$videoCode = @$_REQUEST['video_id'];
		$event = @$_REQUEST['event'];
		$ipAddress = getIP() ;
		$timeSpent = @$_REQUEST['timeSpent'];
		$session_key = trim(@$_REQUEST['session_key']);
		$referrer =  @$_REQUEST['referrer'];
		$videoLength = (isset($_REQUEST['videoLength']))? $_REQUEST['videoLength'] : '0';
		$videoIndex = (isset($_REQUEST['videoIndex']))? $_REQUEST['videoIndex'] : '0';
		
		$sql = "select VideoTracking,id from videos where code ='$videoCode'";
		$resT = mysql_query($sql) or die(mysql_error());
		$rowT = mysql_fetch_array($resT);
		$video_id = $rowT['id'];

	mysql_free_result($resT);
		
	if($rowT['VideoTracking'] == 'Y') 
	{	
		if($event != 'videoLength' && $video_id != '')
		{
			if($event == "ping")
			{		
					$sql2 = "update stat_$tb_name set timeSpent = '$timeSpent' where session_key='$session_key' and video_id='$video_id' and event = 'play' and videoIndex = '$videoIndex'";
					$result2 = mysql_query($sql2);
					if($result2) { $returnData['flag'] = TRUE; $returnData['msg'] = "Video time updated Successfully";  }

				else{$returnData['flag'] = FALSE; $returnData['msg'] = "Video time updated Failed.";  }
					
			}
			else if($event == 'complete')

	  	{
				  $sqlC = "update stat_$tb_name set isCompleted='Y',timeSpent='$timeSpent' where video_id='$video_id' and session_key='$session_key' and event='play' and videoIndex = '$videoIndex'";
				  $resC = mysql_query($sqlC) or die(mysql_error());
				  if($resC) {

				  $returnData['flag'] = TRUE;
					  $returnData['msg'] = "Video Completion Successfully"; 
				  }
				  else {

				  $returnData['flag'] = FALSE;
					  $returnData['msg'] = "Video Completion Failed";  
				  }

		}
			else 
			{
				$sql = "select * from stat_$tb_name where video_id = '$video_id' and session_key='$session_key' and event = '$event' and videoIndex = '$videoIndex'";
				$result = mysql_query($sql) or die(mysql_error());

			
				if(mysql_num_rows($result) == 0)
				{	

				$sql1 = "insert into stat_$tb_name (video_id,videoIndex,event,ipAddress,timeSpent,session_key,referrer,time) values ('$video_id' , '$videoIndex' , '$event' , '$ipAddress' , '$timeSpent' , '$session_key', '$referrer','".date('Y-m-d')."')";
					
					$result1 = mysql_query($sql1) or die(mysql_error());

					if(!$result1)
						{
							$returnData['flag'] = FALSE;
							$returnData['msg'] = "Sql Error : insert query of insert is failed.";

					}
						else 
						{ 

						$returnData['flag'] = TRUE; 
							$returnData['msg'] = "New analytics entered successfully."; 
						}
				}
				mysql_free_result($result);

		}
		
		}

	else
		{
		  if($video_id != 0)
			{
				$res = mysql_query("update videos set videoLength='$videoLength' where id='$video_id'") or die(mysql_error());

			if($res) { $returnData['flag'] = TRUE;
						$returnData['msg'] = "VideoLength Saved Successfully.";  }
				else { $returnData['flag'] = FALSE;
						$returnData['msg'] = "VideoLength: SQL error occured."; }

		}
			  
		  }

	  DbClose();
	}
		//print_r($returnData);
		
	

	function getIP()
	{
		if (!empty($_SERVER['HTTP_CLIENT_IP']))   //check ip from share internet
		  $ip=$_SERVER['HTTP_CLIENT_IP'];
	
		elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))   //to check ip is pass from proxy
			  $ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
		else
		  $ip=$_SERVER['REMOTE_ADDR'];
	
		return $ip;
	}
	
	
	function generateSession($length=24,$level=2){
	   list($usec, $sec) = explode(' ', microtime());
	   srand((float) $sec + ((float) $usec * 100000));
	
	   $validchars[1] = "0123456789abcdfghjkmnpqrstvwxyz";
	   $validchars[2] = "0123456789abcdfghjkmnpqrstvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";
	   $validchars[3] = "0123456789_!@#$%&*()-=+/abcdfghjkmnpqrstvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_!@#$%&*()-=+/";
	
	   $password  = "";
	   $counter   = 0;
	
	   while ($counter < $length) {
		 $actChar = substr($validchars[$level], rand(0, strlen($validchars[$level])-1), 1);
	
		 // All character must be different
		 if (!strstr($password, $actChar)) {
			$password .= $actChar;
			$counter++;
		 }
	   }
	   return $password;
	}
	function createTable($tb_name)
		{
			$sql = "CREATE TABLE IF NOT EXISTS `stat_$tb_name` (
		  `track_id` int(11) NOT NULL auto_increment COMMENT 'auto increment id',
		  `video_id` int(11) NOT NULL COMMENT 'video id of video which is tracked',
		  `videoIndex` int(3) NOT NULL COMMENT 'video index for sub videos',
		  `event` varchar(11) NOT NULL COMMENT 'Play , stop and ping',
		  `ipAddress` varchar(20) NOT NULL COMMENT 'request from this ip',
		  `timeSpent` varchar(20) NOT NULL COMMENT 'time upto which user has seen video',
		  `session_key` varchar(50) NOT NULL COMMENT 'unique session key to track how many times video played.',
		  `referrer` varchar(500) NOT NULL COMMENT 'reference url from video has been played.',
		  `time` date NOT NULL,
		  `isCompleted` char(1) NOT NULL default 'N' COMMENT '''Y ''- video is completed &'' N'' video incomplete',
		  PRIMARY KEY  (`track_id`),
		  KEY `time` (`time`)
		) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1562745";
		
			mysql_query($sql) or die(mysql_error());
		}



?>