"); echo ($pagetitle . " "); printf (""); printf (""); printf (""); printf (""); printf (""); printf (""); printf (""); printf (""); echo (" Page "); } // FUNCTION DAY OFFSET ////////////////############## function day_offset(){ global $dayoffset; global $month; print_r ($month); if (empty($dayoffset)) {$dayoffset = 1; } $disdate = strtotime("-$dayoffset days"); $vday = date("j", $disdate); print_r ($vday); $vmonth = date("F", $disdate); print_r ($vmonth); $vyear = date("Y", $disdate); print_r ($vyear); //$gday = //$gmonth = //$gyear = echo ("
"); echo (" Page
"); } // FUNCTION TABLE STATZ ///////////////############## function table_statz() { include ("config.php"); global $large, $twidth; if (empty ($twidth)) { $twidth=720; } echo ""; echo ""; } // FUNCTION TIME NAME //////////////////################## function time_name($timestamp, $timestring) { $hour = substr($timestamp,8,2); $minute = substr($timestamp,10,2); $second = substr($timestamp,12,2); $month = substr($timestamp,4,2); $day = substr($timestamp,6,2); $year = substr($timestamp,0,4); $mktime = mktime($hour, $minute, $second, $month, $day, $year); $formatted = date($timestring,$mktime); return $formatted; } // FUNCTION WEEKDAY SORT ///////////////############## function weekday_sort($a,$b){ global $weekday; for ($i = 0; $i < array_count_values ($weekday); $i++) { if ($b ==$weekday[$i]) { return 1; } else if ($a == $weekday[$i]) { return -1; } } return ($a ==$b)?0 :(($a <$b)?-1 :1); } // FUNCTION MONTH SORT //////////////////############### function month_sort($a,$b){ global $month; for ($i = 0; $i < count ($month); $i++) { if ($b ==$month[$i]) { return 1; } else if ($a == $month[$i]) { return -1; } } return ($a ==$b)?0 :(($a <$b)?-1 :1); } // FUNCTION LEFT CONTROL PANEL /////////////////################### function left_control () { include ("config.php"); global $user_net, $date1, $date2; global $action; if (empty($action)) { $action = '0'; } if ($large != "1") { $query2 = "SELECT FROM_DAYS(d_now) FROM $table ORDER BY d_now ASC LIMIT 1"; $result2 = mysql_query($query2); if (empty($results2)) {print (NULL); }else{ while ($row = mysql_fetch_row ($result2)) $tracking_start = $row[0];} $ndate1 = $row[0]; $ndate2 = date ("Y-m-d"); if (empty($Array)) { $Array='%'; } if (empty($date1)) { $date1=$ndate1; } if (empty($date2)) { $date2=$ndate2; } }else{ $query2 = "SELECT FROM_DAYS(d_now) FROM $table ORDER BY d_now ASC LIMIT 1"; $result2 = mysql_query($query2); while ($row = mysql_fetch_row ($result2)) $tracking_start = $row[0]; $ndate1 = date ("Y-m-01"); $ndate2 = date ("Y-m-d"); if (empty($date1)) { $date1=$ndate1; } if (empty($date2)) { $date2=$ndate2; } } echo ""; } // FUNCTION SET COOKIE ///////////////############### function set_cookie () { } // FUNCTION CALENDAR ////////////////////################# function show_calendar () { global $action, $date1, $date2, $PHP_SELF, $usermask, $ppcall, $custall, $sterm, $offset; ?> "); printf (""); printf (""); printf (""); printf (""); printf (""); printf (""); ?>    
1){ $nmonth1 = (substr($date2,5,2)-1); $nday1 = '01'; $newyear1 = (substr($date2,0,4)); }else{ $newyear1 = (substr($date2,0,4)-1); $nmonth1 = '12'; $nday1 = '01'; } if (substr($date2,5,2)>1){ $nmonth2 = (substr($date2,5,2)-1); $newyear2 = (substr($date2,0,4)); if ($nmonth2==02){ $nday2 = '28'; }elseif (in_array($nmonth2, $month30)){ $nday2 = '30'; }else{ $nday2 = '31'; } }else{ $newyear2 = (substr($date2,0,4)-1); $nmonth2 = 12; if ($nmonth2==02){ $nday2 = '28'; }elseif (in_array($nmonth2, $month30)){ $nday2 = '30'; }else{ $nday2 = '31'; } } if (substr($date2,5,2)<12){ $nmonth3 = (substr($date2,5,2)+1); $nday3 = '01'; $newyear3 = (substr($date2,0,4)); }else{ $newyear3 = (substr($date2,0,4)+1); $nmonth3 = '01'; $nday3 = '01'; } if (substr($date2,5,2)<12){ $nmonth4 = (substr($date2,5,2)+1); $newyear4 = (substr($date2,0,4)); if ($nmonth4==02){ $nday4 = '28'; }elseif (in_array($nmonth4, $month30)){ $nday4 = '30'; }else{ $nday4 = '31'; } }else{ $newyear4 = (substr($date2,0,4)+1); $nmonth4 = 01; if ($nmonth4==02){ $nday4 = '28'; }elseif (in_array($nmonth4, $month30)){ $nday4 = '30'; }else{ $nday4 = '31'; } } printf ('<Last Month     ', $nmonth1, $nday1, $nmonth2, $nday2); printf ("For Time Period From " . substr($date1,5,2) . "-" . substr($date1,8,2) . "-" . substr($date1,0,4) . " Through " . substr($date2,5,2) . "-" . substr($date2,8,2) . "-" . substr($date2,0,4) . ""); printf ('     Next Month>', $nmonth3, $nday3, $nmonth4, $nday4); } } // FUNCTION CALENDAR SINGLE ////////////////////################# function show_calendar_2 () { global $action, $date1, $date2, $PHP_SELF, $usermask, $ppcall, $custall, $sterm; ?> "); printf (""); printf (""); printf (""); printf (""); printf (""); printf (""); ?>
For Day " . substr($date2,5,2) . "-" . substr($date2,8,2) . "-" . substr($date2,0,4) . ""); } } ## BEGIN_LOG_IN_0 ####################################################################################################################### function S_LOGIN () { } # CHECK_PASS function check_pass ($id, $pass) { include("config.php"); mysql_connect($mysql_address,$mysql_user,$mysql_pass) or die("Unable to Connect"); mysql_select_db($mysql_database) or die("Database selection failed"); $query = "SELECT user_name FROM statzpass WHERE user_name = '$id' AND password = password('$pass') AND status = 'active'"; if (!($result = mysql_query ($query))) die ("Failed to connect to database"); if (!($row = mysql_fetch_array ($result))) return (FALSE); return ($row[user_name] == $id); # TRUE if password matches } # CHECK_PASS ## BEGIN_SUMMARY_PAGE_1 ######################################################################################################################## function S_SUMMARY() { global $PHP_SELF; global $weekday, $date1, $date2; global $month; include("config.php"); if (empty ($large)) { $large=2; } global $username, $password, $large; $username = trim ($username); if (empty ($username)) die ("No Username Specified"); if (empty ($password)) die ("No password specified"); if (check_pass ($username, $password)); else die ("Invalid Login Information"); mysql_connect($mysql_address,$mysql_user,$mysql_pass) or die("Unable to Connect"); mysql_select_db($mysql_database) or die("Database selection failed"); $query = "SELECT DISTINCT page FROM $table ORDER BY page ASC"; $result = mysql_query($query); $page = array(); while ($data = mysql_fetch_array($result)) { array_push($page, $data['page']); } table_statz(); left_control(); ?>
SuperStat"; echo "Z TM   by "; echo "EW3D.com    Ver. 1.19"; if ($large != "1") { print (" Standard"); }else{print (" LS"); } echo "
"; if ($row = array("Visits Full Site","Visits Full Site","Daily","Weekly","Monthly","Yearly","All Referrers","Search Phrases","System Info","History","Custom Refs","User Admin","Search Words","Search Engines","Exit Pages","Site Referrers","Entry Pages","Time On Site","Write Config","Write Custom","Page Code","Remove/Rename Pages","Remove Page","Rename Page","Remove/Reset Data","Write to File","Delete Month","Delete Year","Reset Data","Last All Refs","Last Site Refs","Last Search Refs","Last Custom Refs","Single Visit","PPC Tracking","Last PPCs","PPC Detail","Write PPC","Custom Detail","All Search Term","All Search Word","Unique Custom","Download Data")) { if (empty($action)) { $action = '0'; } echo ""; } echo "
" . $fw1 . $row[$action] . $fx . "
"; echo "Visits Full Site
"; echo "
\"blueline.gif\"
"; echo "All Referrers
"; echo "Site Referrers
"; echo "Search Engines
"; echo "Custom Refs
"; echo "
\"blueline.gif\"
"; echo "Search Phrases
"; echo "Search Words
"; echo "PPC Tracking
"; echo "
\"blueline.gif\"
"; echo "History
"; echo "Entry Pages
"; echo "Exit Pages
"; echo "Time On Site
"; echo "
\"blueline.gif\"
"; echo "Daily
"; echo "Weekly
"; echo "Monthly
"; echo "Yearly
"; echo "
\"blueline.gif\"
"; echo "System Info.
"; echo "
\"blueline.gif\"
"; echo "User Admin
"; echo "
\"blueline.gif\"
"; echo "
"; echo ""; echo "
"; echo "\"blueline.gif\"
"; echo "Data Return is
Blocked From:

"; if ($user_net != "") { echo "" . $user_net . ""; }else{ echo "No Blocking"; } if (empty($tracking_start)) { print (NULL); }else{ echo "
\"blueline.gif\"
"; echo "Tracking Since:
" . substr($tracking_start,5,2) . "-" . substr($tracking_start,8,2) . "-" . substr($tracking_start,0,4) . "

";} echo "
\"blueline.gif\"
"; echo "Questions, Suggestions
or Bugs? Email

tech@SuperStatZ.com
"; echo "
\"blueline.gif\"
"; echo "Sign Up On The
SuperStatZ List Server:

Discussion List"; echo "
Last 30 Days"); }else{print (NULL); } ?> U"); }else{ print (NULL); } for ($i = 0; $i < count ($page); $i++) { if ($page[$i] != "") { echo ""; }else{ echo ""; } $query = "SELECT DISTINCT d_now, mask FROM $table WHERE mask NOT LIKE '$user_net' AND page LIKE '$page[$i]' AND d_now = TO_DAYS(NOW())"; $result = mysql_query($query); echo ""; $query = "SELECT d_now, mask FROM $table WHERE mask NOT LIKE '$user_net' AND page LIKE '$page[$i]' AND d_now = TO_DAYS(NOW())"; $result = mysql_query($query); echo ""; $query = "SELECT DISTINCT d_now, mask FROM $table WHERE mask NOT LIKE '$user_net' AND page LIKE '$page[$i]' AND d_now = TO_DAYS(NOW()) - 1"; $result = mysql_query($query); echo ""; $query = "SELECT d_now, mask FROM $table WHERE mask NOT LIKE '$user_net' AND page = '$page[$i]' AND d_now = TO_DAYS(NOW()) - 1"; $result = mysql_query($query); echo ""; $query = "SELECT DISTINCT d_now, mask FROM $table WHERE mask NOT LIKE '$user_net' AND page LIKE '$page[$i]' AND d_now >= TO_DAYS(NOW()) - 6"; $result = mysql_query($query); echo ""; $query = "SELECT d_now, mask FROM $table WHERE mask NOT LIKE '$user_net' AND page = '$page[$i]' AND d_now >= TO_DAYS(NOW()) - 6"; $result = mysql_query($query); echo ""; if ($large != "1") { $query = "SELECT DISTINCT d_now, mask FROM $table WHERE mask NOT LIKE '$user_net' AND page LIKE '$page[$i]' AND d_now >= TO_DAYS(NOW()) - 29"; $result = mysql_query($query); echo ""; $query = "SELECT d_now, mask FROM $table WHERE mask NOT LIKE '$user_net' AND page = '$page[$i]' AND d_now >= TO_DAYS(NOW()) - 29"; $result = mysql_query($query); echo ""; }else{ print (NULL); } echo ""; } echo "
colspan=" ">Unique|Total Visits Full Site for
Page Name>   Today   >Yesterday> Last 7 Days 
Unique|Total >U >T >U >T >U >T T
" . $page[$i] . "
Incomplete Data" . mysql_num_rows($result) . ""; echo "" . mysql_num_rows($result) . ""; echo "" . mysql_num_rows($result) . ""; echo "" . mysql_num_rows($result) . ""; echo "" . mysql_num_rows($result) . ""; echo "" . mysql_num_rows($result) . ""; echo "" . mysql_num_rows($result) . ""; echo "" . mysql_num_rows($result) . "
"; ?> $fw1Unique Site Visitors Last Seven Days$fx"; echo "$ff1 Days $fx$ff1 Visitors $fx$ff1 Percent $fx "; for ($i = 0; $i < count ($adate); $i++) { $adate[$i] = time_name ($adate[$i], "l"); } $temp = array_count_values($adate); uksort($temp, "weekday_sort"); while(list($key, $value) = each($temp)){ $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); if($width != 0){ echo(" $fs1$key$fx$fs1$value$fx$fs1$percent%$fx$percent%\n"); } else { echo("$fs1$key$fx$fs1$value$fx$fs1$percent%$fx"); } } echo("$fs1 Total $fx$fs1$visits$fx\n"); echo(" "); $query = "SELECT adate FROM $table WHERE TO_DAYS(NOW()) - TO_DAYS(adate) <= 6 AND mask NOT LIKE '$user_net'"; $result = mysql_query($query); $adate = array(); while ($data = mysql_fetch_array($result)) { array_push($adate, $data[0]); } $visits = count($adate); echo "$fw1Total Page Views Last Seven Days$fx"; echo "$ff1 Days $fx$ff1 Visitors $fx$ff1 Percent $fx "; for ($i = 0; $i < count ($adate); $i++) { $adate[$i] = time_name ($adate[$i], "l"); } $temp = array_count_values($adate); uksort($temp, "weekday_sort"); while(list($key, $value) = each($temp)){ $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); if($width != 0){ echo(" $fs1$key$fx$fs1$value$fx$fs1$percent%$fx$percent%\n"); } else { echo("$fs1$key$fx$fs1$value$fx$fs1$percent%$fx"); } } echo("$fs1 Total $fx$fs1$visits$fx\n"); echo(" "); $query = "SELECT DISTINCT DATE_FORMAT(adate, '%Y%m%d'), mask FROM $table WHERE mask NOT LIKE '$user_net'"; $result = mysql_query($query); $adate = array(); while ($data = mysql_fetch_array($result)) { array_push($adate, $data[0]); } $visits = count($adate); echo "$fw1Total Unique Site Visitors by Days$fx"; echo "$ff1 Days $fx$ff1 Visitors $fx$ff1 Percent $fx "; for ($i = 0; $i < count ($adate); $i++) { $adate[$i] = time_name ($adate[$i], "l"); } $temp = array_count_values($adate); uksort($temp, "weekday_sort"); while(list($key, $value) = each($temp)){ $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); if($width != 0){ echo(" $fs1$key$fx$fs1$value$fx$fs1$percent%$fx$percent%\n"); } else { echo("$fs1$key$fx$fs1$value$fx$fs1$percent%$fx"); } } echo("$fs1 Total $fx$fs1$visits$fx\n"); echo(" "); $query = "SELECT adate FROM $table WHERE mask NOT LIKE '$user_net'"; $result = mysql_query($query); $adate = array(); while ($data = mysql_fetch_array($result)) { array_push($adate, $data['adate']); } $visits = count($adate); echo "$fw1Total Page Views by Days$fx"; echo "$ff1 Days $fx$ff1 Visitors $fx$ff1 Percent $fx "; for ($i = 0; $i < count ($adate); $i++) { $adate[$i] = time_name ($adate[$i], "l"); } $temp = array_count_values($adate); uksort($temp, "weekday_sort"); while(list($key, $value) = each($temp)){ $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); if($width != 0){ echo(" $fs1$key$fx$fs1$value$fx$fs1$percent%$fx$percent%\n"); } else { echo("$fs1$key$fx$fs1$value$fx$fs1$percent%$fx"); } } echo("$fs1 Total $fx$fs1$visits$fx\n"); echo(" "); ?> $fw1Unique Site Visitors Weekly This Year$fx"; echo "$ff1 Week $fx$ff1 Visitors $fx$ff1 Percent $fx "; for ($i = 0; $i < count ($adate); $i++) { } $temp = array_count_values($adate); while(list($key, $value) = each($temp)){ $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); if($width != 0){ echo(" $fs1$key$fx$fs1$value$fx$fs1$percent%$fx$percent%\n"); } else { echo("$fs1$key$fx$fs1$value$fx$fs1$percent%$fx"); } } echo("$fs1 Total $fx$fs1$visits$fx\n"); echo(" "); $query = "SELECT WEEK((DATE_FORMAT(adate, '%Y-%m-%d')),2) FROM $table WHERE mask NOT LIKE '$user_net' AND EXTRACT(YEAR FROM (NOW())) = EXTRACT(YEAR FROM adate)"; $result = mysql_query($query); $adate = array(); while ($data = mysql_fetch_array($result)) { array_push($adate, $data[0]); } $visits = count($adate); echo "$fw1Total Page Views Weekly This Year$fx"; echo "$ff1 Week $fx$ff1 Visitors $fx$ff1 Percent $fx "; for ($i = 0; $i < count ($adate); $i++) { } $temp = array_count_values($adate); while(list($key, $value) = each($temp)){ $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); if($width != 0){ echo(" $fs1$key$fx$fs1$value$fx$fs1$percent%$fx$percent%\n"); } else { echo("$fs1$key$fx$fs1$value$fx$fs1$percent%$fx"); } } echo("$fs1 Total $fx$fs1$visits$fx\n"); echo(" "); $query = "SELECT DISTINCT WEEK((DATE_FORMAT(adate, '%Y-%m-%d')),2), mask FROM $table WHERE mask NOT LIKE '$user_net'"; $result = mysql_query($query); $adate = array(); while ($data = mysql_fetch_array($result)) { array_push($adate, $data[0]); } $visits = count($adate); echo "$fw1Unique Site Visitors Weekly All Years$fx"; echo "$ff1 Week $fx$ff1 Visitors $fx$ff1 Percent $fx "; for ($i = 0; $i < count ($adate); $i++) { } $temp = array_count_values($adate); while(list($key, $value) = each($temp)){ $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); if($width != 0){ echo(" $fs1$key$fx$fs1$value$fx$fs1$percent%$fx$percent%\n"); } else { echo("$fs1$key$fx$fs1$value$fx$fs1$percent%$fx"); } } echo("$fs1 Total $fx$fs1$visits$fx\n"); echo(" "); $query = "SELECT WEEK((DATE_FORMAT(adate, '%Y-%m-%d')),2) FROM $table WHERE mask NOT LIKE '$user_net'"; $result = mysql_query($query); $adate = array(); while ($data = mysql_fetch_array($result)) { array_push($adate, $data[0]); } $visits = count($adate); echo "$fw1Total Page Views Weekly All Years$fx"; echo "$ff1 Week $fx$ff1 Visitors $fx$ff1 Percent $fx "; for ($i = 0; $i < count ($adate); $i++) { } $temp = array_count_values($adate); while(list($key, $value) = each($temp)){ $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); if($width != 0){ echo(" $fs1$key$fx$fs1$value$fx$fs1$percent%$fx$percent%\n"); } else { echo("$fs1$key$fx$fs1$value$fx$fs1$percent%$fx"); } } echo("$fs1 Total $fx$fs1$visits$fx\n"); echo(" "); ?> $fw1Unique Site Visitors Monthly This Year$fx"; echo "$ff1 Month $fx$ff1 Visitors $fx$ff1 Percent $fx "; for ($i = 0; $i < count ($adate); $i++) { } $temp = array_count_values($adate); while(list($key, $value) = each($temp)){ $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); if($width != 0){ echo(" $fs1$key$fx$fs1$value$fx$fs1$percent%$fx$percent%\n"); } else { echo("$fs1$key$fx$fs1$value$fx$fs1$percent%$fx"); } } echo("$fs1 Total $fx$fs1$visits$fx\n"); echo(" "); $query = "SELECT MONTHNAME(DATE_FORMAT(adate, '%Y-%m-%d')) FROM $table WHERE mask NOT LIKE '$user_net' AND EXTRACT(YEAR FROM (NOW())) = EXTRACT(YEAR FROM adate)"; $result = mysql_query($query); $adate = array(); while ($data = mysql_fetch_array($result)) { array_push($adate, $data[0]); } $visits = count($adate); echo "$fw1Total Page Views Monthly This Year$fx"; echo "$ff1 Month $fx$ff1 Visitors $fx$ff1 Percent $fx "; for ($i = 0; $i < count ($adate); $i++) { } $temp = array_count_values($adate); while(list($key, $value) = each($temp)){ $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); if($width != 0){ echo(" $fs1$key$fx$fs1$value$fx$fs1$percent%$fx$percent%\n"); } else { echo("$fs1$key$fx$fs1$value$fx$fs1$percent%$fx"); } } echo("$fs1 Total $fx$fs1$visits$fx\n"); echo(" "); $query = "SELECT DISTINCT MONTHNAME(DATE_FORMAT(adate, '%Y-%m-%d')), mask FROM $table WHERE mask NOT LIKE '$user_net'"; $result = mysql_query($query); $adate = array(); while ($data = mysql_fetch_array($result)) { array_push($adate, $data[0]); } $visits = count($adate); echo "$fw1Unique Site Visitors Monthly All Years$fx"; echo "$ff1 Month $fx$ff1 Visitors $fx$ff1 Percent $fx "; for ($i = 0; $i < count ($adate); $i++) { } $temp = array_count_values($adate); while(list($key, $value) = each($temp)){ $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); if($width != 0){ echo(" $fs1$key$fx$fs1$value$fx$fs1$percent%$fx$percent%\n"); } else { echo("$fs1$key$fx$fs1$value$fx$fs1$percent%$fx"); } } echo("$fs1 Total $fx$fs1$visits$fx\n"); echo(" "); $query = "SELECT MONTHNAME(DATE_FORMAT(adate, '%Y-%m-%d')) FROM $table WHERE mask NOT LIKE '$user_net'"; $result = mysql_query($query); $adate = array(); while ($data = mysql_fetch_array($result)) { array_push($adate, $data[0]); } $visits = count($adate); echo "$fw1Total Page Views Monthly All Years$fx"; echo "$ff1 Month $fx$ff1 Visitors $fx$ff1 Percent $fx "; for ($i = 0; $i < count ($adate); $i++) { } $temp = array_count_values($adate); while(list($key, $value) = each($temp)){ $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); if($width != 0){ echo(" $fs1$key$fx$fs1$value$fx$fs1$percent%$fx$percent%\n"); } else { echo("$fs1$key$fx$fs1$value$fx$fs1$percent%$fx"); } } echo("$fs1 Total $fx$fs1$visits$fx\n"); echo(" "); echo ""; ?> $fw1Unique Site Visitors This Year$fx"; echo "$ff1 Year $fx$ff1 Visitors $fx$ff1 Percent $fx "; for ($i = 0; $i < count ($adate); $i++) { } $temp = array_count_values($adate); while(list($key, $value) = each($temp)){ $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); if($width != 0){ echo(" $fs1$key$fx$fs1$value$fx$fs1$percent%$fx$percent%\n"); } else { echo("$fs1$key$fx$fs1$value$fx$fs1$percent%$fx"); } } echo("$fs1 Total $fx$fs1$visits$fx\n"); echo(" "); $query = "SELECT YEAR(DATE_FORMAT(adate, '%Y-%m-%d')) FROM $table WHERE mask NOT LIKE '$user_net' AND EXTRACT(YEAR FROM (NOW())) = EXTRACT(YEAR FROM adate)"; $result = mysql_query($query); $adate = array(); while ($data = mysql_fetch_array($result)) { array_push($adate, $data[0]); } $visits = count($adate); echo "$fw1Total Page Views This Year$fx"; echo "$ff1 Year $fx$ff1 Visitors $fx$ff1 Percent $fx "; for ($i = 0; $i < count ($adate); $i++) { } $temp = array_count_values($adate); while(list($key, $value) = each($temp)){ $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); if($width != 0){ echo(" $fs1$key$fx$fs1$value$fx$fs1$percent%$fx$percent%\n"); } else { echo("$fs1$key$fx$fs1$value$fx$fs1$percent%$fx"); } } echo("$fs1 Total $fx$fs1$visits$fx\n"); echo(" "); $query = "SELECT DISTINCT YEAR(DATE_FORMAT(adate, '%Y-%m-%d')), mask FROM $table WHERE mask NOT LIKE '$user_net'"; $result = mysql_query($query); $adate = array(); while ($data = mysql_fetch_array($result)) { array_push($adate, $data[0]); } $visits = count($adate); echo "$fw1Unique Site Visitors All Years$fx"; echo "$ff1 Year $fx$ff1 Visitors $fx$ff1 Percent $fx "; for ($i = 0; $i < count ($adate); $i++) { } $temp = array_count_values($adate); while(list($key, $value) = each($temp)){ $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); if($width != 0){ echo(" $fs1$key$fx$fs1$value$fx$fs1$percent%$fx$percent%\n"); } else { echo("$fs1$key$fx$fs1$value$fx$fs1$percent%$fx"); } } echo("$fs1 Total $fx$fs1$visits$fx\n"); echo(" "); $query = "SELECT YEAR(DATE_FORMAT(adate, '%Y-%m-%d')) FROM $table WHERE mask NOT LIKE '$user_net'"; $result = mysql_query($query); $adate = array(); while ($data = mysql_fetch_array($result)) { array_push($adate, $data[0]); } $visits = count($adate); echo "$fw1Total Page Views All Years$fx"; echo "$ff1 Year $fx$ff1 Visitors $fx$ff1 Percent $fx "; for ($i = 0; $i < count ($adate); $i++) { } $temp = array_count_values($adate); while(list($key, $value) = each($temp)){ $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); if($width != 0){ echo(" $fs1$key$fx$fs1$value$fx$fs1$percent%$fx$percent%\n"); } else { echo("$fs1$key$fx$fs1$value$fx$fs1$percent%$fx"); } } echo("$fs1 Total $fx$fs1$visits$fx\n"); echo(" "); echo ""; ?> TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"; $result = mysql_query($query); $records_found = mysql_num_rows($result); $refers = array(); global $offset; if (empty($offset)) { $offset = 0; } while ($data = mysql_fetch_array($result)) { array_push($refers, $data['refers']); } $visits = count($refers); ?> 1){ echo("\n"); } else { echo(""); } } echo("
colspan="4" align="center">
colspan="4">Go To List Last All Referrers
width="500"> width='50'>Count colspan="2">Percent
$fs2" . (substr($key, 0, 70)) . "$fx$fs2$value$fx$fs2$percent%$fx$percent%
$fs2" . (substr($key, 0, 70)) . "$fx$fs2$value$fx$fs2<$percent%$fx$fs2 $fx
"); if ($offset != 0) { echo ("<<Prev 25   "); } echo ("Displaying " . ($offset+1) . "-" . ($offset+25) . " of " . count($temp) . " Total "); if ($offset + 25 < count($temp)){ echo ("  Next 25>>"); } echo ("
"); ?> TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"; $result = mysql_query($query); $records_found = mysql_num_rows($result); $terms = array(); global $offset; if (empty($offset)) { $offset = 0; } while ($data = mysql_fetch_array($result)) { array_push($terms, $data['terms']); } $visits = count($terms); ?> 1){ echo("\n"); } else { echo(""); } } echo("
colspan="4" align="center">
>Top 25 Search Phrases width='50'>Count colspan="2">Percent
$fs2$key$fx$fs2$value$fx$fs2$percent%$fx$percent%
$fs2$key$fx$fs2$value$fx$fs2<$percent%$fx$fs2 $fx
"); if ($offset != 0) { echo ("<<Prev 25   "); } echo ("Displaying " . ($offset+1) . "-" . ($offset+25) . " of " . count($temp) . " Total "); if ($offset + 25 < count($temp)){ echo ("  Next 25>>"); } echo ("
"); ?> TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"; $result = mysql_query($query); $records_found = mysql_num_rows($result); $field_name = array(); while ($data = mysql_fetch_array($result)) { $visits += 1; array_push($field_name, $data[$myvar]); } ?> > width='50'>Count colspan="2">Percent 1){ echo("$fs2$key$fx$fs2$value$fx$fs2$percent%$fx$percent%\n"); } else { echo("$fs2$key$fx$fs2$value$fx$fs2<$percent%$fx "); } } echo(" "); ?>
colspan="4" align="center" valign="top">
TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1 order by adate desc limit $offset,100"); $result2 = mysql_query("select adate from $table WHERE d_now > TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"); $numrows = mysql_num_rows($result2); echo (""); echo (""); if(!$ipnum) $ipnum=0; function alt_col($color1, $color2, $cpt) {$bg = ($cpt % 2) ? $color1 : $color2; return $bg; } while ($row = mysql_fetch_array($result)) { print ("\n"); if ($row[0] == $ipnum) { echo (""); $ipnum=($row[0]); }else{ $nb += 1; $bg = alt_col($bg1, $bg3, $nb); echo (""); $ipnum=($row[0]); } print ("\n"); } echo (""); ?>
colspan="4" align="center">
"); if (($offset-100) >= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+100) . " of " . $numrows . " "); if(($offset+100) < $numrows) { echo ("Next >>"); } echo ("
Click on Hostmask Below for Visitor Detail
IP
M/D Hr:Mi:Se
Page
$fs2" . (substr($row[3], -40)) . "$fx$fs2$row[0]$fx$fs2$row[1]$fx$fs2$row[2]$fx$fs2" . (substr($row[3], -40)) . "$fx$fs2$row[0]$fx$fs2$row[1]$fx$fs2$row[2]$fx
"); if (($offset-100) >= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+100) . " of " . $numrows . " "); if(($offset+100) < $numrows) { echo ("Next >>"); } echo ("
TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"; $result = mysql_query($query); $records_found = mysql_num_rows($result); $refers = array(); echo (""); while ($data = mysql_fetch_array($result)) { array_push($refers, $data['refers']); } $visits = count($refers); $temp = array_count_values($refers); arsort($temp); $i = 0; while($i >= 0 && list($key, $value) = each($temp)) { $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); $i++; if($width > 1) { echo("\n"); } else { echo(""); } } } } echo("
colspan="4" align="center">
colspan="4" align="top">Go To List Last Custom Referrers
width="500" align="center" colspan="4">
>Custom Referrer List width='50'>Count colspan="2">Percent
$fs2 Referrer Names Containing: " . $c_value . "$fx$fs2$records_found$fx" . $fs2 . " Show Unique Visits" . $fx . "
$fs2" . (substr($key, 0, 60)) . "$fx$fs2$value$fx$fs2$percent%$fx$percent%
$fs2" . (substr($key, 0, 60)) . "$fx$fs2$value$fx$fs2<$percent%$fx$fs2 $fx
"); }else{ $temp = array_count_values($c_file); $newtemp = array_slice($temp, $offset, 10); echo("
"); if ($offset != 0) { echo ("<<Prev 10   "); } echo ("Displaying " . ($offset+1) . "-" . ($offset+10) . " of " . count($temp) . " Total "); if ($offset + 10 < count($temp)){ echo ("  Next 10>>"); } echo ("
"); for ($k = 0; $k < count($c_file); $k++) { $c_value = trim($c_file[$k]); $i = 0; $j = 0; while($i < 10 && list($key2, $value2) = each($newtemp)){ $key2 = trim($key2); $c_value = trim($c_file[$k]); $k++; if(empty($c_value)) { break; } else { $query = "SELECT * FROM $table WHERE refers LIKE '%" . $key2 . "%' AND page LIKE '$Array' AND mask NOT LIKE '$user_net' AND d_now > TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"; $result = mysql_query($query); $records_found = mysql_num_rows($result); $refers = array(); echo ("$fs2 Referrer Names Containing: " . $key2 . "$fx$fs2$records_found$fx" . $fs2 . " Show Unique Visits" . $fx . ""); while ($data = mysql_fetch_array($result)) { array_push($refers, $data['refers']); } $visits = count($refers); $temp3 = array_count_values($refers); arsort($temp3); while($j >= 0 && list($key, $value) = each($temp3)) { $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); $j++; if($width > 1) { echo("$fs2" . (substr($key, 0, 60)) . "$fx$fs2$value$fx$fs2$percent%$fx$percent%\n"); } else { echo("$fs2" . (substr($key, 0, 60)) . "$fx$fs2$value$fx$fs2<$percent%$fx$fs2 $fx"); } } } } $i++; } echo("
"); if ($offset != 0) { echo ("<<Prev 10   "); } echo ("Displaying " . ($offset+1) . "-" . ($offset+10) . " of " . count($temp) . " Total "); if ($offset + 10 < count($temp)){ echo ("  Next 10>>"); } echo ("
"); echo(""); } ?> "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
All 'User Admin' functions are removed from this demo version.
In the full version you may:

Easily output the tracking code for your web pages.

Create your own 'Custom Referrer' list, making it easier to track particular click throughs

Input your own 'Pay Per Click' strings, so you can track all of your PPCs from one location.

Write your data to a spreadsheet file. Useful for data crunching years from now or to just run some custom scripts.

Set the width of the main table in SuperStatZ. Perhaps you are using a large monitor and have extra 'real estate' which you would like to use?

Turn on or off the blocking of your own hostmask. Hide your visits, which might skew the data.

Set the tracking time to your time zone.

Switch between the 'Standard' and 'Large Site' versions. The 'Large Site' version splits up some returns, making it run much faster.

This area also contains many other functions for data control, not listed here.

"; ?> TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"; $result = mysql_query($query); $records_found = mysql_num_rows($result); $terms = array(); global $offset; if (empty($offset)) { $offset = 0; } while ($data = mysql_fetch_array($result)) { array_push($terms, $data['terms']); } $fullterms = implode(',', $terms); if(strlen($fullterms) > 500000) { $fullterms = eregi_replace(' ',',',$fullterms); $fullterms = eregi_replace('\+',',',$fullterms); $fullterms = eregi_replace('\"',',',$fullterms); $fullterms = eregi_replace('\'',',',$fullterms); $fullterms = eregi_replace(',a,',',',$fullterms); $fullterms = eregi_replace(',and,',',',$fullterms); $fullterms = eregi_replace(',the,',',',$fullterms); $fullterms = eregi_replace(',in,',',',$fullterms); $fullterms = eregi_replace(',of,',',',$fullterms); $fullterms = eregi_replace('-',',',$fullterms); $fullterms = eregi_replace('_',',',$fullterms); $fullterms = eregi_replace(',,,,',',',$fullterms); $fullterms = eregi_replace(',,,',',',$fullterms); $fullterms = eregi_replace(',,',',',$fullterms); } else { $fullterms = str_replace(array(' ', '\+', '"', '\'', ',a,', ',and,', ',the,', ',in,', ',of,', '-', '_', ',,,,', ',,,', ',,'), array(',', ',', ',', ',', ',', ',', ',', ',', ',', ',', ',', ',', ',', ','), $fullterms); } $terms = explode(',', $fullterms); $visits = count($terms); ?> 1){ echo("\n"); } else { echo(""); } } echo("
colspan="4" align="center">
>Top 25 Search Words width='50'>Count colspan="2">Percent
$fs2$key$fx$fs2$value$fx$fs2$percent%$fx$percent%
$fs2$key$fx$fs2$value$fx$fs2<$percent%$fx$fs2 $fx
"); if ($offset != 0) { echo ("<<Prev 25   "); } echo ("Displaying " . ($offset+1) . "-" . ($offset+25) . " of " . count($temp) . " Total "); if ($offset + 25 < count($temp)){ echo ("  Next 25>>"); } echo ("
"); ?> TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"; $result = mysql_query($query); $records_found = mysql_num_rows($result); $refers = array(); global $offset; if (empty($offset)) { $offset = 0; } while ($data = mysql_fetch_array($result)) { array_push($refers, $data['refers']); } $visits = count($refers); ?> 1){ echo("\n"); } else { echo(""); } } echo("
colspan="4" align="center">
colspan="4" align="top">Go To List Last Search Referrers
> width='50'>Count colspan="2">Percent
$fs2" . (substr($key, 0, 70)) . "$fx$fs2$value$fx$fs2$percent%$fx$percent%
$fs2" . (substr($key, 0, 70)) . "$fx$fs2$value$fx$fs2<$percent%$fx$fs2 $fx
"); if ($offset != 0) { echo ("<<Prev 25   "); } echo ("Displaying " . ($offset+1) . "-" . ($offset+25) . " of " . count($temp) . " Total "); if ($offset + 25 < count($temp)){ echo ("  Next 25>>"); } echo ("
"); ?> "); //day_offset(); echo (""); $temparray = array(); while ($row = mysql_fetch_array($result)) { if (in_array($row[0], $temparray)) { echo (NULL); }else{ echo ("\n"); $temparray[]=($row[0]); } } echo (""); ?>
colspan="4" align="center">
Exit Pages for " . substr($date2,5,2) . "-" . substr($date2,8,2) . "-" . substr($date2,0,4) . "
Page
IP
Hostmask
Time
$fs2$row[3]$fx$fs2$row[1]$fx$fs2" . (substr($row[0], -30)) . "$fx$fs2$row[2]$fx
Exit Pages for " . substr($date2,5,2) . "-" . substr($date2,8,2) . "-" . substr($date2,0,4) . "
TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"; $result = mysql_query($query); $records_found = mysql_num_rows($result); $refers = array(); global $offset; if (empty($offset)) { $offset = 0; } while ($data = mysql_fetch_array($result)) { array_push($refers, $data['refers']); } $visits = count($refers); ?> 1){ echo("\n"); } else { echo(""); } } echo("
colspan="4" align="center">
colspan="4" align="top">Go To List Last Site Referrers
width="500" align="top"> width='50'>Count colspan="2">Percent
$fs2" . (substr($key, 0, 70)) . "$fx$fs2$value$fx$fs2$percent%$fx$percent%
$fs2" . (substr($key, 0, 70)) . "$fx$fs2$value$fx$fs2<$percent%$fx$fs2 $fx
"); if ($offset != 0) { echo ("<<Prev 25   "); } echo ("Displaying " . ($offset+1) . "-" . ($offset+25) . " of " . count($temp) . " Total "); if ($offset + 25 < count($temp)){ echo ("  Next 25>>"); } echo ("
"); ?> "); echo (""); $temparray = array(); while ($row = mysql_fetch_array($result)) { if (in_array($row[0], $temparray)) { echo (NULL); }else{ echo ("\n"); $temparray[]=($row[0]); } } echo (""); ?>
colspan="4" align="center">
Entry Pages for " . substr($date2,5,2) . "-" . substr($date2,8,2) . "-" . substr($date2,0,4) . "
Page
IP
Hostmask
Time
$fs2$row[3]$fx$fs2$row[1]$fx$fs2" . (substr($row[0], -30)) . "$fx$fs2$row[2]$fx
Entry Pages for " . substr($date2,5,2) . "-" . substr($date2,8,2) . "-" . substr($date2,0,4) . "
"); echo (""); $temparray = array(); while ($row = mysql_fetch_array($result)) { if (in_array($row[0], $temparray)) { echo (NULL); }else{ $thisip = $row[0]; $temparray[]=($row[0]); while ($row2 = mysql_fetch_row($result2)) {if (in_array($thisip, $row2)){ $exittime = $row2[2]; break; }else{ continue; } } $arrtime = date("F j, Y H:i:s", $row[2]); $timeonpage = ($exittime-$row[2]); $hrs = floor($timeonpage/3600); $mns = floor(($timeonpage%3600)/60); $scs = (($timeonpage%3600)%60); echo ("\n"); } } echo (""); ?>
colspan="4" align="center">
Visitor Time On Site To Exit Page for " . substr($date2,5,2) . "-" . substr($date2,8,2) . "-" . substr($date2,0,4) . "
IP
Hostmask
Hr:Mn:Sec
Visit Began
$fs2$row[1]$fx $fs2" . (substr($row[0], -30)) . "$fx$fs2 $hrs:$mns:$scs $fx$fs2 $arrtime $fx
Visitor Time On Site To Exit Page for " . substr($date2,5,2) . "-" . substr($date2,8,2) . "-" . substr($date2,0,4) . "
TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1 order by adate desc limit $offset,100"); $result2 = mysql_query("select adate from $table WHERE refers != 'Direct Hit' AND refers NOT LIKE '%$sitedomain%' AND page LIKE '$Array' AND mask NOT LIKE '$user_net' AND d_now > TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"); $numrows = mysql_num_rows($result2); ?>"); echo (""); while ($row = mysql_fetch_array($result)) { # if (empty($row[2])) { $row2[2]=" ";} print ("\n"); echo (""); print ("\n"); } echo (""); ?>
colspan="4" align="center">
width="500" colspan="4" align="center">
"); if (($offset-100) >= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+100) . " of " . $numrows . " "); if(($offset+100) < $numrows) { echo ("Next >>"); } echo ("
Referrer
M/D Hr:Mi:Se
Search Term
V
$fs2" . (substr($row[0], 0, 50)) . "$fx$fs2$row[1]$fx" . $fs2 . $row[2] . $fx . "\"Get
"); if (($offset-100) >= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+100) . " of " . $numrows . " "); if(($offset+100) < $numrows) { echo ("Next >>"); } echo ("
TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1 order by adate desc limit $offset,100"); $result2 = mysql_query("select adate from $table WHERE refers != 'Direct Hit' AND refers NOT LIKE '%$sitedomain%' AND page LIKE '$Array' AND terms = '' AND mask NOT LIKE '$user_net' AND d_now > TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"); $numrows = mysql_num_rows($result2); ?>"); echo (""); while ($row = mysql_fetch_array($result)) { print ("\n"); echo (""); print ("\n"); } echo (""); ?>
colspan="3" align="center">
width="500" align="center" colspan="3">
"); if (($offset-100) >= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+100) . " of " . $numrows . " "); if(($offset+100) < $numrows) { echo ("Next >>"); } echo ("
Referrer
M/D Hr:Mi:Se
V
$fs2" . (substr($row[0], 0, 50)) . "$fx$fs2$row[1]$fx\"Get
"); if (($offset-100) >= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+100) . " of " . $numrows . " "); if(($offset+100) < $numrows) { echo ("Next >>"); } echo ("
TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1 order by adate desc limit $offset,100"); $result2 = mysql_query("select adate from $table WHERE refers != 'Direct Hit' AND terms != '' AND refers NOT LIKE '%$sitedomain%' AND page LIKE '$Array' AND mask NOT LIKE '$user_net' AND d_now > TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"); $numrows = mysql_num_rows($result2); ?>"); echo (""); while ($row = mysql_fetch_array($result)) { print ("\n"); echo (""); print ("\n"); } echo (""); ?>
colspan="4" align="center">
width="500" align="center" colspan="4">
"); if (($offset-100) >= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+100) . " of " . $numrows . " "); if(($offset+100) < $numrows) { echo ("Next >>"); } echo ("
Referrer
M/D Hr:Mi:Se
Search Term
V
$fs2" . (substr($row[0], 0, 50)) . "$fx$fs2$row[1]$fx" . $fs2 . $row[2] . $fx . "\"Get
"); if (($offset-100) >= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+100) . " of " . $numrows . " "); if(($offset+100) < $numrows) { echo ("Next >>"); } echo ("
TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1 order by adate desc limit $rlimit"); $result2 = mysql_query("SELECT refers, DATE_FORMAT(adate, '%c/%e %H:%i:%s'), terms, mask FROM $table WHERE refers LIKE '%$c_value%' AND page LIKE '$Array' AND mask NOT LIKE '$user_net' AND d_now > TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"); $numrows = mysql_num_rows($result2); $records_found = mysql_num_rows($result2); $refers = array(); echo (""); while ($row = mysql_fetch_array($result)) { print ("\n"); echo (""); print ("\n"); } } } echo (""); ?>
colspan="4" align="center">
width="500" align="center" colspan="4">
>Last Custom Sites Visits width='50' align='center'>M/D Hr:Mi:Se align='center'>Search Terms align='center'>V
$fs2 Last $rlimit with Referrer Names Containing: " . $c_value . "$fx$fs2of $records_found Total$fx" . $fs2 . "Get All For '" . $c_value . "'" . $fx . "
$fs2" . (substr($row[0], 0, 60)) . "$fx$fs2$row[1]$fx" . $fs2 . $row[2] . $fx . "\"Get
"); if ($offset != 0) { echo ("<<Prev 10   "); } echo ("Displaying " . ($offset+1) . "-" . ($offset+10) . " of " . count($temp) . " Total "); if ($offset + 10 < count($temp)){ echo ("  Next 10>>"); } echo ("
"); $newtemp = array_slice($temp, $offset, 10); for ($k = $offset; $k < count($c_file); $k++) { $c_value = trim($c_file[$k]); $i = 0; while($i < 10 && list($key2, $value2) = each($newtemp)){ $c_value = trim($c_file[$k]); $k++; if(empty($c_value)) { break; } else { $result = mysql_query("SELECT refers, DATE_FORMAT(adate, '%c/%e %H:%i:%s'), terms, mask FROM $table WHERE refers LIKE '%$c_value%' AND page LIKE '$Array' AND mask NOT LIKE '$user_net' AND d_now > TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1 order by adate desc limit $rlimit"); $result2 = mysql_query("SELECT refers, DATE_FORMAT(adate, '%c/%e %H:%i:%s'), terms, mask FROM $table WHERE refers LIKE '%$c_value%' AND page LIKE '$Array' AND mask NOT LIKE '$user_net' AND d_now > TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"); $numrows = mysql_num_rows($result2); $records_found = mysql_num_rows($result2); $refers = array(); echo ("$fs2 Last $rlimit with Referrer Names Containing: " . $c_value . "$fx$fs2of $records_found Total$fx" . $fs2 . "Get All For '" . $c_value . "'" . $fx . ""); while ($row = mysql_fetch_array($result)) { print ("\n"); echo ("$fs2" . (substr($row[0], 0, 60)) . "$fx$fs2$row[1]$fx" . $fs2 . $row[2] . $fx . "\"Get"); print ("\n"); } } } } $i++; } echo("
"); if ($offset != 0) { echo ("<<Prev 10   "); } echo ("Displaying " . ($offset+1) . "-" . ($offset+10) . " of " . count($temp) . " Total "); if ($offset + 10 < count($temp)){ echo ("  Next 10>>"); } echo ("
"); ?> TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1 order by adate asc"); $numrows = mysql_num_rows($result); echo (""); while ($row = mysql_fetch_array($result)) { print ("\n"); echo (""); print ("\n"); } ?>
SuperStatZTM Single Visitor Information
"; echo ""; echo "
"; ?>
colspan="4" align="center">
Referrer
M/D Hr:Mi:Se
Page
Search Term
$fs2$row[2]$fx$fs2$row[0]$fx$fs2$row[4]$fx$fs2$row[3]$fx
TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"; $result = mysql_query($query); $records_found = mysql_num_rows($result); $fulladd = array(); echo (""); while ($data = mysql_fetch_array($result)) { array_push($fulladd, $data['refers']); } $visits = count($fulladd); $temp = array_count_values($fulladd); arsort($temp); $i = 0; while($i >= 0 && list($key, $value) = each($temp)) { $width = ($value / $visits) * 200; $percent = ceil(($value / $visits) * 100); $i++; if($width > 1) { echo("\n"); } else { echo(""); } } } } echo("
colspan="4" align="center">
colspan="4" align="top">Go To Last PPC Listings
>PPC Tracking width='50'>Count colspan="2">Percent
$fs2 PPCs Containing: " . $c_value . "$fx$fs2$records_found$fx 
$fs2" . (substr($key, 0, 60)) . "$fx$fs2$value$fx$fs2$percent%$fx$percent%
$fs2" . (substr($key, 0, 60)) . "$fx$fs2$value$fx$fs2<$percent%$fx$fs2 $fx
"); ?> TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1 order by adate desc limit $offset,20"); $result2 = mysql_query("SELECT refers, DATE_FORMAT(adate, '%c/%e %H:%i:%s'), terms, mask FROM $table WHERE fulladd LIKE '%$c_value%' AND terms NOT LIKE '' AND mask NOT LIKE '$user_net' AND d_now > TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"); $numrows = mysql_num_rows($result2); $records_found = mysql_num_rows($result2); $refers = array(); echo (""); while ($row = mysql_fetch_array($result)) { print ("\n"); echo (""); print ("\n"); } } } echo (""); ?>
colspan="4" align="center">
>Last PPC Visits width='50' align='center'>M/D Hr:Mi:Se align='center'>Search Terms colspan="2" align='center'>Hostmask
$fs2 Last 20 Search Referrers Containing: " . $c_value . "$fx$fs2of $records_found Total$fx" . $fs2 . "Get All For '" . $c_value . "'" . $fx . "
$fs2$row[0]$fx$fs2$row[1]$fx" . $fs2 . $row[2] . $fx . "$fs2" . (substr($row[3], -40)) . "$fx
TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1 order by adate desc limit $offset,50"); $result2 = mysql_query("SELECT refers, DATE_FORMAT(adate, '%c/%e %H:%i:%s'), terms, mask FROM $table WHERE fulladd LIKE '%$ppcall%' AND refers NOT LIKE 'Direct Hit' AND mask NOT LIKE '$user_net' AND terms NOT LIKE '' AND d_now > TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"); $numrows = mysql_num_rows($result2); $records_found = mysql_num_rows($result2); $refers = array(); ?> "); echo (""); while ($row = mysql_fetch_array($result)) { print ("\n"); echo (""); print ("\n"); } } echo (""); ?> "); ?>
colspan="4" align="center">
>
= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+50) . " of " . $numrows . " "); if(($offset+50) < $numrows) { echo ("Next >>"); } echo ("
$fs2 PPCs Containing: " . $ppcall . "$fx" . $fs2 . "M/D Hr:Mi:Se" . $fx . "$fs2Search Terms$fx$fs2Hostmask$fx
$fs2$row[0]$fx$fs2$row[1]$fx" . $fs2 . $row[2] . $fx . "$fs2" . (substr($row[3], -40)) . "$fx
>
= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+50) . " of " . $numrows . " "); if(($offset+50) < $numrows) { echo ("Next >>"); } echo ("
TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1 order by adate desc limit $offset,50"); $result2 = mysql_query("SELECT refers, DATE_FORMAT(adate, '%c/%e %H:%i:%s'), terms, mask FROM $table WHERE refers LIKE '%$custall%' AND refers NOT LIKE 'Direct Hit' AND mask NOT LIKE '$user_net' AND d_now > TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"); $numrows = mysql_num_rows($result2); $records_found = mysql_num_rows($result2); $refers = array(); ?> "); echo (""); while ($row = mysql_fetch_array($result)) { print ("\n"); echo (""); print ("\n"); } } echo (""); ?> "); ?>
colspan="4" align="center">
>
= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+50) . " of " . $numrows . " "); if(($offset+50) < $numrows) { echo ("Next >>"); } echo ("
$fs2 Custom List Containing: " . $custall . "$fx" . $fs2 . "M/D Hr:Mi:Se" . $fx . "$fs2Search Terms$fx$fs2Hostmask $fx " . $fs2 . " Show Unique Visits" . $fx . "
$fs2$row[0]$fx$fs2$row[1]$fx$fs2$row[2]$fx$fs2" . (substr($row[3], -40)) . "$fx
>
= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+50) . " of " . $numrows . " "); if(($offset+50) < $numrows) { echo ("Next >>"); } echo ("
TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1 order by adate desc limit $offset,50"); $result2 = mysql_query("SELECT refers, DATE_FORMAT(adate, '%c/%e %H:%i:%s'), terms, mask FROM $table WHERE terms LIKE '$sterm' AND refers NOT LIKE 'Direct Hit' AND mask NOT LIKE '$user_net' AND d_now > TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"); $numrows = mysql_num_rows($result2); $records_found = mysql_num_rows($result2); $refers = array(); ?> "); echo (""); while ($row = mysql_fetch_array($result)) { print ("\n"); echo (""); print ("\n"); } } echo (""); ?> "); ?>
colspan="3" align="center">
>
= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+50) . " of " . $numrows . " "); if(($offset+50) < $numrows) { echo ("Next >>"); } echo ("
$fs2 Visits Containing: " . $sterm . "$fx" . $fs2 . "M/D Hr:Mi:Se" . $fx . "$fs2Hostmask$fx
$fs2$row[0]$fx$fs2$row[1]$fx$fs2" . (substr($row[3], -40)) . "$fx
>
= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+50) . " of " . $numrows . " "); if(($offset+50) < $numrows) { echo ("Next >>"); } echo ("
TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1 order by adate desc limit $offset,50"); $result2 = mysql_query("SELECT refers, DATE_FORMAT(adate, '%c/%e %H:%i:%s'), terms, mask FROM $table WHERE terms LIKE '%$sterm%' AND refers NOT LIKE 'Direct Hit' AND mask NOT LIKE '$user_net' AND d_now > TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"); $numrows = mysql_num_rows($result2); $records_found = mysql_num_rows($result2); $refers = array(); ?> "); echo (""); while ($row = mysql_fetch_array($result)) { print ("\n"); echo (""); print ("\n"); } } echo (""); ?> "); ?>
colspan="3" align="center">
>
= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+50) . " of " . $numrows . " "); if(($offset+50) < $numrows) { echo ("Next >>"); } echo ("
$fs2 Visits Containing: " . $sterm . "$fx" . $fs2 . "M/D Hr:Mi:Se" . $fx . "$fs2Hostmask$fx
$fs2$row[0]$fx$fs2$row[1]$fx$fs2" . (substr($row[3], -40)) . "$fx
>
= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+50) . " of " . $numrows . " "); if(($offset+50) < $numrows) { echo ("Next >>"); } echo ("
TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1 order by adate desc limit $offset,50"); # $result2 = mysql_query("SELECT refers, DATE_FORMAT(adate, '%c/%e %H:%i:%s'), terms, mask FROM $table WHERE refers LIKE '%$custall%' AND refers NOT LIKE 'Direct Hit' AND mask NOT LIKE '$user_net' AND d_now > TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1 order by adate desc limit $offset,50"); $result2 = mysql_query("SELECT DISTINCT mask FROM $table WHERE refers LIKE '%$custall%' AND refers NOT LIKE 'Direct Hit' AND mask NOT LIKE '$user_net' AND d_now > TO_DAYS('$date1') - 1 AND d_now < TO_DAYS('$date2') + 1"); $numrows = mysql_num_rows($result2); $records_found = mysql_num_rows($result2); $refers = array(); ?> "); echo (""); while ($row = mysql_fetch_array($result)) { print ("\n"); echo (""); print ("\n"); } } echo (""); ?> "); ?>
SuperStatZTM Unique Visitor Information
"; echo ""; echo "
"; $query3 = "SELECT FROM_DAYS(d_now) FROM $table ORDER BY d_now ASC LIMIT 1"; $result3 = mysql_query($query3); while ($row = mysql_fetch_row ($result3)) $ndate1 = $row[0]; $ndate2 = date ("Y-m-d"); if (empty($Array)) { $Array='%'; } if (empty($date1)) { $date1=$ndate1; } if (empty($date2)) { $date2=$ndate2; } global $offset; if(!$offset) $offset=0; ?>
align="center">
>
= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+50) . " of " . $numrows . " "); if(($offset+50) < $numrows) { echo ("Next >>"); } echo ("
$fs2 Custom List Containing: " . $custall . "$fx
$fs2With Unique Hostmask$fx
$fs2" . (substr($row[0], -40)) . "$fx
>
= 0) { echo("<< Prev"); } echo (" " . $offset . "-" . ($offset+50) . " of " . $numrows . " "); if(($offset+50) < $numrows) { echo ("Next >>"); } echo ("
"; //html_end(); ?>