hasPermission("access_to_setup_section")) {
header('location: '.get_absolute_url().'tracking202/');
die();
}
$slack = false;
$mysql['user_id'] = $db->real_escape_string($_SESSION['user_own_id']);
$mysql['user_own_id'] = $db->real_escape_string($_SESSION['user_own_id']);
//$user_sql = "SELECT 2u.user_name as username, 2up.user_slack_incoming_webhook AS url 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_sql = "SELECT 202_users.user_name AS username, 202_users_pref.maxmind_isp, 202_users_pref.ipqs_api_key,202_users_pref.user_slack_incoming_webhook AS url FROM 202_users_pref LEFT JOIN 202_users ON (202_users.user_id = '".$mysql['user_own_id']."') WHERE 202_users_pref.user_id='1'";
$user_results = $db->query($user_sql);
$user_row = $user_results->fetch_assoc();
if (!empty($user_row['url']))
$slack = new Slack($user_row['url']);
if ($_POST['edit_rotator']) {
$editing = true;
}
if ($_GET['rules_added']) {
$add_success = true;
}
if ($_SERVER['REQUEST_METHOD'] == "POST") {
$rotator_name = trim($_POST['rotator_name']);
if (empty($rotator_name)) {
$error['rotator_name'] = 'Type in the name of your rotator!
';
}
if (!$error) {
$mysql['rotator_name'] = $db->real_escape_string ($_POST['rotator_name']);
$mysql['user_id'] = $db->real_escape_string ($_SESSION ['user_id']);
if ($editing == true) {
$sql = "UPDATE `202_aff_networks` SET";
} else {
$sql = "INSERT INTO 202_rotators SET name='".$mysql['rotator_name']."', user_id='".$mysql['user_id']."'";
}
$result = $db->query($sql);
$rotator_id = $db->insert_id;
$sql = "UPDATE 202_rotators SET public_id='".rand(1,9) . $rotator_id . rand(1,9)."' WHERE id='".$rotator_id."'";
$result = $db->query($sql);
$add_success = true;
if ($slack)
$slack->push('rotator_created', array('name' => $_POST['rotator_name'], 'user' => $user_row['username']));
}
}
if (isset($_GET['delete_rotator_id'])) {
if ($userObj->hasPermission("remove_rotator")) {
$mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']);
$mysql['rotator_id'] = $db->real_escape_string($_GET['delete_rotator_id']);
$delete_sql = "DELETE FROM 202_rotators WHERE id='".$mysql['rotator_id']."' AND user_id='".$mysql['user_id']."'";
if (_mysqli_query($delete_sql)) {
$rule_sql = "DELETE FROM 202_rotator_rules WHERE rotator_id='".$mysql['rotator_id']."'";
if (_mysqli_query($rule_sql)) {
$criteria_sql = "DELETE FROM 202_rotator_rules_criteria WHERE rotator_id='".$mysql['rotator_id']."'";
if (_mysqli_query($criteria_sql)) {
$delete_success = true;
if ($slack)
$slack->push('rotator_deleted', array('name' => $_GET['delete_rotator_name'], 'user' => $user_row['username']));
}
}
}
} else {
header('location: '.get_absolute_url().'tracking202/setup/rotator.php');
}
}
template_top('Smart Redirector',NULL,NULL,NULL); ?>
Smart Redirector Setup
Hey! Make sure all field are filled.
pull-right" id="form_response" style="margin-top: 20px;">
There were errors with your submission.
Your submission was successful. Your changes have been saved.
Your deletion was successful. You have successfully removed a redirector.
Setup Smart Redirector, to redirect visitors based on rules you define.
Add New Smart Redirector
Give a name for your redirector.
My Smart Redirectors
real_escape_string ( $_SESSION ['user_id'] );
$sql = "SELECT * FROM `202_rotators` WHERE `user_id`='" . $mysql ['user_id'] . "' ORDER BY `name` ASC";
$result = $db->query ( $sql ) or record_mysql_error ( $sql );
if ($result->num_rows == 0) {
?>- You have not added any redirectors.
fetch_array (MYSQLI_ASSOC) ) {
$html ['name'] = htmlentities ( $row ['name'], ENT_QUOTES, 'UTF-8' );
$html ['id'] = htmlentities ( $row ['id'], ENT_QUOTES, 'UTF-8' );
if ($userObj->hasPermission("remove_rotator")) {
printf ( '- %s - remove
', $html ['name'], $html ['id'], $html ['name'] );
} else {
printf ( '- %s
', $html ['name']);
}
$rule_sql = "SELECT * FROM `202_rotator_rules` WHERE `rotator_id`='" . $row['id'] . "' ORDER BY `id` ASC";
$rule_result = $db->query ( $rule_sql ) or record_mysql_error ( $rule_sql );
if ($rule_result->num_rows == 0) {
?>- You have not added any rules.
";
while ($rule_row = $rule_result->fetch_array()) {
$criteria_sql = "SELECT * FROM `202_rotator_rules_criteria` WHERE `rule_id`='" . $rule_row['id'] . "' ORDER BY `id` ASC";
$criteria_result = $db->query ( $criteria_sql ) or record_mysql_error ( $criteria_sql );
if ($criteria_result->num_rows > 0) {
$criteria = "You have ".$criteria_result->num_rows." criteria added";
} else {
$criteria = "No criteria added";
}
?>
- (Details)
";
?>
Add Rule to Your Smart Redirector
Select redirector, to add new rule. You can add as many rules as you want, for each redirector.