£Á°è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áyMä9ÜÖUã !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! = '$i'")); if(empty($temp)) $max = 0; else $max = max($temp); if($max < 10) $max = 10; for($i=1;$i<=$len;$i++) { $arr = array(); $arr['second'] = $i; $arr['color'] = (round(($temp[$i]*100)/$max) == 0)?'':$colorArr[round(($temp[$i]*100)/$max)]; $arr['views'] = $temp[$i]; $returnData['data'][] = $arr; } $returnData['flag'] = TRUE; $returnData['msg'] = 'Successfully sended data'; return $returnData; } function getSessionData() { global $ping_tb_name,$tb_name,$dataArr; $returnData = array(); $colorArr = getColorSchemeArr1(); $res1 = DbQuery("select start_time,end_time from stat_time_".date('MY',strtotime($dataArr['timeStamp']))." where session_key = '".$dataArr['session_key']."'"); $temp = array(); if(count($res1) > 0 && $res1) { foreach($res1 as $row1) { $start = $row1['start_time']; while($start <= $row1['end_time']) $temp[] = $start++; } } $MainArr = array(); $te = array_count_values($temp); if(empty($te)) $max = 0; else $max = max($te); if($max < 5) $max = 5; for($i=0;$i<=$dataArr['video_length'];$i++) { $MainArr[$i]['views'] = ($te[$i]=='')?0:$te[$i]; $MainArr[$i]['second'] = $i; $MainArr[$i]['color'] = (round(($te[$i]*100)/$max) == 0)?'#ffffff':$colorArr[round(($te[$i]*100)/$max)]; } $returnData['data'] = $MainArr; $returnData['flag'] = TRUE; $returnData['msg'] = 'Successfully sended data'; return $returnData; } function getColorSchemeArr() { $color = array('', '#d5f46b', '#a4cc2b', '#f3bb5a', '#ffcc00', '#ff983d', '#D26900', '#FF7171', '#ff5400', '#FF1A1A', '#D50000'); $colorInterval = array(); for($i=1; $i<=100; $i++) $colorInterval[$i] = $color[floor($i/10)]; return $colorInterval; } function getColorSchemeArr1() { $color = array('', '#d5f46b', '#f3f357', '#f3bb5a', '#e1832b', '#e1832b'); $colorInterval = array(); for($i=1; $i<=100; $i++) $colorInterval[$i] = $color[floor($i/20)]; return $colorInterval; } function get_country_by_ip($ip) { //$ip =$_SERVER['REMOTE_ADDR']; $url='http://api.hostip.info/get_html.php?ip='.$ip.'&position=true'; $data=file_get_contents($url); $a=array(); $keys=array('Country','City','Latitude','Longitude','IP'); $keycount=count($keys); for ($r=0; $r < $keycount ; $r++) { $sstr= substr ($data, strpos($data, $keys[$r]), strlen($data)); if ( $r < ($keycount-1)) $sstr = substr ($sstr, 0, strpos($sstr,$keys[$r+1])); $s=explode (':',$sstr); $a[$keys[$r]] = trim($s[1]); } return $a; } function geoCheckIP($ip) { //check, if the provided ip is valid if(!filter_var($ip, FILTER_VALIDATE_IP)) { throw new InvalidArgumentException("IP is not valid"); } //contact ip-server $response=@file_get_contents('http://www.netip.de/search?query='.$ip); if (empty($response)) { throw new InvalidArgumentException("Error contacting Geo-IP-Server"); } //Array containing all regex-patterns necessary to extract ip-geoinfo from page $patterns=array(); $patterns["domain"] = '#Domain: (.*?) #i'; $patterns["country"] = '#Country: (.*?) #i'; $patterns["state"] = '#State/Region: (.*?) $pattern) { //store the result in array $ipInfo[$key] = preg_match($pattern,$response,$value) && !empty($value[1]) ? $value[1] : 'not found'; } return $ipInfo; } 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 createTable($tb_name,$ping_tb_name) { $sql = "CREATE TABLE IF NOT EXISTS $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, ping, pause and complete', `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.', `domain` varchar(60) NOT NULL COMMENT 'domain from where video is played', `city` varchar(50) NOT NULL COMMENT 'city where video is played', `country` varchar(50) NOT NULL COMMENT 'country where video is played', `device_name` varchar(10) NOT NULL COMMENT 'Windows,Mac,iPhone,iPad,Anroid,Other', `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created date', `created_on` datetime NOT NULL, `isCompleted` char(1) NOT NULL DEFAULT 'N' COMMENT '''Y ''- video is completed &'' N'' video incomplete', PRIMARY KEY (`track_id`), KEY `time` (`time`), KEY `video_id` (`video_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;"; mysql_query($sql) or die(mysql_error()); $sqll = "CREATE TABLE IF NOT EXISTS $ping_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', `session_key` varchar(50) NOT NULL COMMENT 'unique session key to track how many times video played.', `start_time` bigint(20) NOT NULL COMMENT 'start time of video in second', `end_time` bigint(20) NOT NULL COMMENT 'end time of video in second', `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created date', PRIMARY KEY (`track_id`), KEY `video_id` (`video_id`), KEY `start_time` (`start_time`), KEY `end_time` (`end_time`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;"; mysql_query($sqll) or die(mysql_error()); } ?>