real_escape_string($_SESSION['user_own_id']); $user_sql = "SELECT 2u.user_name as username, 2up.user_slack_incoming_webhook AS url, maxmind_isp, user_time_register, 2up.user_auto_database_optimization_days FROM 202_users AS 2u INNER JOIN 202_users_pref AS 2up ON (2up.user_id = 1) WHERE 2u.user_id = '".$mysql['user_own_id']."'"; $user_results = $db->query($user_sql); $user_row = $user_results->fetch_assoc(); $username = $user_row['username']; $user_time_register = $user_row['user_time_register']; if (!empty($user_row['url'])) $slack = new Slack($user_row['url']); $cron_log_query = "SELECT last_execution_time FROM 202_cronjob_logs"; $cron_log_result = $db->query($cron_log_query); if ($cron_log_result->num_rows > 0) { $cron_log_row = $cron_log_result->fetch_assoc(); $last_cron_job_execution_time = CronJobLastExecution('@'.$cron_log_row['last_execution_time']); } else { $last_cron_job_execution_time = 'never'; } $de_query = "SELECT count(*) as total, sum(processed) as done FROM 202_dataengine_job"; $de_result = $db->query($de_query); $de_row = $de_result->fetch_assoc(); if ($de_result->num_rows && $de_row['total'] != 0) { $de_total = $de_row['total']; $de_done = $de_row['done']; $de_ratio = @round(($de_done / $de_total) * 100, 2); } else { $de_total = '0'; $de_done = '0'; $de_ratio = '0'; } $de_minutes = @round($de_total - $de_done, 0); $d = floor ($de_minutes / 1440); $h = floor (($de_minutes - $d * 1440) / 60); $m = $de_minutes - ($d * 1440) - ($h * 60); if (isset($_POST['autocron'])) { $autocron = false; if ($_POST['autocron'] == true) { $endpoint = 'register'; $sql = "SELECT * FROM 202_cronjob_logs"; $result = _mysqli_query($sql); if ($result->num_rows > 0) { $row = $result->fetch_assoc(); $last_five_minutes = time() - 300; if ($row['last_execution_time'] < $last_five_minutes) { $autocron = true; } } else { $autocron = true; } } else { $endpoint = 'deregister'; $autocron = true; } if ($autocron) { $cron = callAutoCron($endpoint); if ($cron['status'] == 'success') { $mysql['auto_cron'] = $db->real_escape_string($_POST['autocron']); $mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']); $sql = "UPDATE 202_users_pref SET auto_cron = '".$mysql['auto_cron']."' WHERE user_id = '".$mysql['user_id']."'"; $result = _mysqli_query($sql); } } die(); } if (isset($_POST['maxmind'])) { if($_POST['maxmind'] == "true") { if (file_exists(substr(dirname( __FILE__ ), 0,-12) . '/202-config/geo/GeoIPISP.dat')) { $mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']); $sql = "UPDATE 202_users_pref SET maxmind_isp='1' WHERE user_id='".$mysql['user_id']."'"; $result = _mysqli_query($sql); if ($slack) $slack->push('maxmind_isp_changed', array('user' => $username, 'type' => 'Activated')); } else { echo "ISP Database file doesn't exist. Make sure (GeoIPISP.dat file) is in /202-config/geo/ folder."; } } if($_POST['maxmind'] == "false") { $mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']); $sql = "UPDATE 202_users_pref SET maxmind_isp='0' WHERE user_id='".$mysql['user_id']."'"; $result = _mysqli_query($sql); if ($slack) $slack->push('maxmind_isp_changed', array('user' => $username, 'type' => 'Deactivated')); } die(); } template_top('Administration',NULL,NULL,NULL); $click_sql = "SELECT `AUTO_INCREMENT`-1 as clicks FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = '202_clicks_counter';"; $click_row = memcache_mysql_fetch_assoc($click_sql); $clicks = $click_row['clicks']; //$click_sql = "SELECT count(*) clicks FROM 202_clicks_total"; //$click_row = memcache_mysql_fetch_assoc($click_sql); //$clicks += $click_row['clicks']; if (isset($_POST['database_management'])) { $tables = is_array($tables) ? $tables : explode(',','202_clicks_advance,202_clicks_record,202_clicks_site,202_clicks_spy,202_clicks_tracking,202_clicks'); $click_timestamp = strtotime($_POST['database_management']. "00:00:00 ".date('T')); $clickid_sql= "SELECT click_id AS click_id FROM 202_clicks WHERE click_time <=". $click_timestamp." ORDER BY click_id DESC LIMIT 1"; $clickid_result = _mysqli_query($clickid_sql); $clickid_row = $clickid_result->fetch_assoc(); $mysql['user_delete_data_clickid'] = $db->real_escape_string($clickid_row['click_id']); $sql ="UPDATE 202_users_pref SET user_delete_data_clickid = '".$mysql['user_delete_data_clickid']."' WHERE user_id = '".$mysql['user_own_id']."'"; $db->query($sql); if ($slack) $slack->push('click_data_deleted', array('user' => $username, 'date' => $_POST['database_management'])); header('location: '.get_absolute_url().'202-account/administration.php'); } if (isset($_POST['auto_database_management'])) { $mysq['auto_database_management'] = $db->real_escape_string($_POST['auto_database_management']); $sql ="UPDATE 202_users_pref SET user_auto_database_optimization_days = '".$mysq['auto_database_management']."' WHERE user_id = '".$mysql['user_own_id']."'"; $db->query($sql); } function getClicksEraseDate(){ global $db,$mysql; $sql="SELECT click_time FROM `202_clicks` WHERE click_id <= (SELECT user_delete_data_clickid FROM `202_users_pref` WHERE user_id='".$mysql['user_own_id']."') ORDER BY click_id DESC LIMIT 1"; $result = $db->query($sql); $row = $result->fetch_array(MYSQLI_ASSOC); if($row){ return date('d-m-Y', $row['click_time']); } else{ return date('d-m-Y', time()); } } function database_size() { global $db; define('GIG', 1000000000); $MB= 1024*1024; $GB= 1024*1024*1024; $decimals = 2; $sql = $db->query("SHOW TABLE STATUS"); $size = 0; while($row = $sql->fetch_array(MYSQLI_ASSOC)) { $size += $row["Data_length"] + $row["Index_length"]; } if($size > GIG) { $mbytes = number_format($size/($GB),$decimals) . " GB"; }else{ $mbytes = number_format($size/($MB),$decimals) . " MB"; } return $mbytes; } function CronJobLastExecution($datetime) { $now = new DateTime; $ago = new DateTime($datetime); $diff = $now->diff($ago); $week =array('w'=>floor($diff->d / 7)); $diff->d -= $week->w * 7; $diff=(object) array_merge((array)$diff, $week); $string = array( 'y' => 'year', 'm' => 'month', 'w' => 'week', 'd' => 'day', 'h' => 'hour', 'i' => 'minute', 's' => 'second', ); foreach ($string as $k => &$v) { if ($diff->$k) { $v = $diff->$k . ' ' . $v . ($diff->$k > 1 ? 's' : ''); } else { unset($string[$k]); } } if (!$full) $string = array_slice($string, 0, 1); return $string ? implode(', ', $string) . ' ago' : 'just now'; } ?>
System Configuration
Tracking202 Stats
clicks recorded to date.
Database Management
Current Prosper202 Database Size:
Warning: This clears out everything except your setup data
Auto Database Optimization
Days
Warning: This deletes data about every click that occured before the specified number of days. (Enter 0 or leave blank if you don't want old data autormatically deleted)
AutoCron Settings
AutoCron is enabled by default, after you install Prosper202 Pro. You can change settings here.
MaxMind ISP/Carrier Lookup

To turn on ISP/Carrier lookup feature, you need to buy MaxMind ISP database and upload (GeoIPISP.dat file) to folder.
(Settings will take place after 5 minutes in live traffic)
Last 50 Login Attempts
fetch_assoc()) { $html['user_name'] = htmlentities($user_log_row['user_name'], ENT_QUOTES, 'UTF-8'); $html['ip_address'] = htmlentities($user_log_row['ip_address'], ENT_QUOTES, 'UTF-8'); $html['login_time'] = htmlentities(date('M d, y \a\t g:ia', $user_log_row['login_time']), ENT_QUOTES, 'UTF-8'); if ($user_log_row['login_success'] == 0) { $html['login_success'] = 'Failed'; } else { $html['login_success'] = 'Passed'; } printf('',$html['login_time'], $html['user_name'], $html['ip_address'], $html['ip_address'], $html['ip_address'], $html['login_success']); } ?>
Time Username IP Address Attempt
%s %s %s :: ARIN / RIPE %s