real_escape_string($_SESSION['user_id']);
$mysql['user_own_id'] = $db->real_escape_string($_SESSION['user_own_id']);
$user_sql = "SELECT 202_users.user_name AS username, 202_users_pref.maxmind_isp, 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_result = $db->query($user_sql);
$user_row = $user_result->fetch_assoc();
if (!empty($user_row['url']))
$slack = new Slack($user_row['url']);
$campaigns_sql = "SELECT aff_campaign_id, aff_campaign_name FROM 202_aff_campaigns LEFT JOIN 202_aff_networks using(aff_network_id) WHERE 202_aff_campaigns.user_id = '".$mysql['user_id']."' AND `aff_campaign_deleted`=0 AND `aff_network_deleted`=0 AND 202_aff_networks.user_id = 202_aff_campaigns.user_id";
$campaigns_result = $db->query($campaigns_sql);
$campaigns = array();
if ($campaigns_result->num_rows > 0) {
while ($campaigns_row = $campaigns_result->fetch_assoc()) {
$campaigns[] = array('id' => $campaigns_row['aff_campaign_id'], 'name' => $campaigns_row['aff_campaign_name']);
}
}
$lp_sql = "(SELECT landing_page_id,landing_page_nickname, landing_page_type FROM `202_landing_pages` AS 2lp JOIN 202_aff_campaigns using(aff_campaign_id) JOIN 202_aff_networks using(aff_network_id) WHERE 2lp.user_id='".$mysql['user_id']."' AND `landing_page_deleted`='0' AND aff_campaign_deleted='0' AND `aff_network_deleted`='0' ORDER BY `aff_campaign_id`, `landing_page_nickname` ASC) UNION (SELECT landing_page_id,landing_page_nickname,landing_page_type FROM `202_landing_pages` WHERE `user_id`='".$mysql['user_id']."' AND `landing_page_type`='1' AND `landing_page_deleted`='0' ORDER BY `landing_page_nickname` ASC)";
$lp_result = $db->query($lp_sql);
$lps = array();
if ($lp_result->num_rows > 0) {
while ($lp_row = $lp_result->fetch_assoc()) {
$lps[] = array('id' => $lp_row['landing_page_id'], 'name' => $lp_row['landing_page_nickname'], 'type' => $lp_row['landing_page_type']);
}
}
if (isset($_POST['add_more_redirects']) && $_POST['add_more_redirects'] == true) { ?>
weight
real_escape_string($_POST['rotator_id']);
$defaults = $db->real_escape_string($_POST['defaults']);
$rotator_sql = "SELECT
2ro.name,
2ro.default_campaign,
2ro.default_url,
2ro.default_lp,
2ro.auto_monetizer,
2ac.aff_campaign_name,
2lp.landing_page_nickname
FROM 202_rotators AS 2ro
LEFT JOIN 202_aff_campaigns AS 2ac ON (2ro.default_campaign = 2ac.aff_campaign_id)
LEFT JOIN 202_landing_pages AS 2lp ON (2ro.default_lp = 2lp.landing_page_id)
WHERE 2ro.id = '".$rotator_id."' AND 2ro.user_id = '".$mysql['user_id']."' AND 2lp.landing_page_deleted='0'";
$rotator_result = $db->query($rotator_sql);
$rotator_row = $rotator_result->fetch_assoc();
if ($slack) {
if (!$rotator_row['default_campaign'] && !$rotator_row['default_url'] && !$rotator_row['default_lp'] && !$rotator_row['auto_monetizer']) {
$defaults_added = true;
} else {
if ($rotator_row['default_campaign']) {
if ( (($_POST['default_type'] == 'campaign') && ($rotator_row['default_campaign'] != $_POST['defaults'])) || (($_POST['default_type'] != 'campaign') && ($rotator_row['default_campaign'] != $_POST['defaults']))) {
$default_from_type = "Campaign";
$default_from_value = $rotator_row['aff_campaign_name'];
$defaults_changed = true;
}
} else if ($rotator_row['default_url']) {
if (($rotator_row['default_url'] != $_POST['defaults']) && ($_POST['default_type'] != 'url')) {
$default_from_type = "URL";
$default_from_value = $rotator_row['default_url'];
$defaults_changed = true;
}
} else if ($rotator_row['default_lp']) {
if ( (($_POST['default_type'] == 'lp') && ($rotator_row['default_lp'] != $_POST['defaults'])) || (($_POST['default_type'] != 'lp') && ($rotator_row['default_lp'] != $_POST['defaults']))) {
$default_from_type = "Landing Page";
$default_from_value = $rotator_row['landing_page_nickname'];
$defaults_changed = true;
}
} else if ($rotator_row['auto_monetizer']) {
if (($rotator_row['auto_monetizer'] != $_POST['defaults']) && ($_POST['default_type'] != 'monetizer')) {
$default_from_type = "Auto Monetizer";
$defaults_changed = true;
}
}
}
}
switch ($_POST['default_type']) {
case 'campaign':
$default_sql = "default_campaign='".$defaults."', default_url=null, default_lp=null, auto_monetizer=null";
if ($slack) {
$default_campaign_id = $db->real_escape_string($defaults);
$default_campaign_sql = "SELECT aff_campaign_name FROM 202_aff_campaigns WHERE aff_campaign_id = '".$default_campaign_id."'";
$default_campaign_result = $db->query($default_campaign_sql);
$default_campaign_row = $default_campaign_result->fetch_assoc();
if ($defaults_added) {
$slack->push('rotator_defaults_added', array('name' => $rotator_row['name'], 'default_type' => 'Campaign', 'default_value' => $default_campaign_row['aff_campaign_name'], 'user' => $user_row['username']));
} else if ($defaults_changed) {
if ($default_from_type != "Auto Monetizer") {
$slack->push('rotator_defaults_changed', array('name' => $rotator_row['name'], 'default_from_type' => $default_from_type, 'default_from_value' => $default_from_value, 'default_to_type' => 'Campaign', 'default_to_value' => $default_campaign_row['aff_campaign_name'], 'user' => $user_row['username']));
} else if ($default_from_type == "Auto Monetizer"){
$slack->push('rotator_defaults_changed_from_monetizer', array('name' => $rotator_row['name'], 'default_to_type' => 'Campaign', 'default_to_value' => $default_campaign_row['aff_campaign_name'], 'user' => $user_row['username']));
}
}
}
break;
case 'url':
$default_sql = "default_url='".$defaults."', default_campaign=null, default_lp=null, auto_monetizer=null";
if ($slack) {
if ($defaults_added) {
$slack->push('rotator_defaults_added', array('name' => $rotator_row['name'], 'default_type' => 'URL', 'default_value' => $defaults, 'user' => $user_row['username']));
} else if ($defaults_changed) {
if ($default_from_type != "Auto Monetizer") {
$slack->push('rotator_defaults_changed', array('name' => $rotator_row['name'], 'default_from_type' => $default_from_type, 'default_from_value' => $default_from_value, 'default_to_type' => 'URL', 'default_to_value' => $defaults, 'user' => $user_row['username']));
} else {
$slack->push('rotator_defaults_changed_from_monetizer', array('name' => $rotator_row['name'], 'default_to_type' => 'URL', 'default_to_value' => $defaults, 'user' => $user_row['username']));
}
}
}
break;
case 'lp':
$default_sql = "default_lp='".$defaults."', default_campaign=null, default_url=null, auto_monetizer=null";
if ($slack) {
$default_lp_id = $db->real_escape_string($defaults);
$default_lp_sql = "SELECT landing_page_nickname FROM 202_landing_pages WHERE landing_page_id = '".$default_lp_id."' AND landing_page_deleted='0'";
$default_lp_result = $db->query($default_lp_sql);
$default_lp_row = $default_lp_result->fetch_assoc();
if ($defaults_added) {
$slack->push('rotator_defaults_added', array('name' => $rotator_row['name'], 'default_type' => 'Landing Page', 'default_value' => $default_lp_row['landing_page_nickname'], 'user' => $user_row['username']));
} else if ($defaults_changed) {
if ($default_from_type != "Auto Monetizer") {
$slack->push('rotator_defaults_changed', array('name' => $rotator_row['name'], 'default_from_type' => $default_from_type, 'default_from_value' => $default_from_value, 'default_to_type' => 'Landing Page', 'default_to_value' => $default_lp_row['landing_page_nickname'], 'user' => $user_row['username']));
} else {
$slack->push('rotator_defaults_changed_from_monetizer', array('name' => $rotator_row['name'], 'default_to_type' => 'Landing Page', 'default_to_value' => $default_lp_row['landing_page_nickname'], 'user' => $user_row['username']));
}
}
}
break;
case 'monetizer':
$default_sql = "default_lp=null, default_campaign=null, default_url=null, auto_monetizer='true'";
if ($slack) {
if ($defaults_added) {
$slack->push('rotator_defaults_added_to_monetizer', array('name' => $rotator_row['name'], 'user' => $user_row['username']));
} else if ($defaults_changed) {
if ($default_from_type != "Auto Monetizer") {
$slack->push('rotator_defaults_changed_to_monetizer', array('name' => $rotator_row['name'], 'default_from_type' => $default_from_type, 'default_from_value' => $default_from_value, 'user' => $user_row['username']));
}
}
}
break;
}
$sql = "UPDATE 202_rotators SET ".$default_sql." WHERE id='".$rotator_id."'";
$result = $db->query($sql);
if ($result) {
$rules_id = array();
$criteria_id = array();
$criteria_added = array();
$rules_added = array();
foreach ($_POST['data'] as $rule) {
$redirects_ids = array();
$redirect_changed = false;
$rule_name = $db->real_escape_string($rule['rule_name']);
if ($rule['status'] == 'active') {$status = 1;} else {$status = 0;}
if ($rule['split'] == 'true') {$splittest = 1;} else {$splittest = 0;}
if ($rule['rule_id'] != 'none') {
$rule_sql = "UPDATE 202_rotator_rules SET rotator_id='".$rotator_id."', rule_name='".$rule_name."', splittest='".$splittest."', status='".$status."' WHERE id='".$rule['rule_id']."'";
$rule_result = $db->query($rule_sql);
$rule_id = $rule['rule_id'];
$rules_id[] = $rule_id;
foreach ($rule['redirects'] as $redirect) {
$redirect_value = $db->real_escape_string($redirect['value']);
switch ($redirect['type']) {
case 'campaign':
$redirect_type_sql = "SELECT aff_campaign_name FROM 202_aff_campaigns WHERE aff_campaign_id = '".$redirect_value."'";
$redirect_type_result = $db->query($redirect_type_sql);
$redirect_type_row = $redirect_type_result->fetch_assoc();
$redirect_name = "Campaign: ".$redirect_type_row['aff_campaign_name'];
$redirect_sql = "redirect_campaign='".$redirect_value."', redirect_url=null, redirect_lp=null, auto_monetizer=null, name='".$redirect_name."'";
break;
case 'url':
$redirect_name = "URL: link";
$redirect_sql = "redirect_url='".$redirect_value."', redirect_campaign=null, redirect_lp=null, auto_monetizer=null, name='".$redirect_name."'";
break;
case 'lp':
$redirect_type_sql = "SELECT landing_page_nickname FROM 202_landing_pages WHERE landing_page_id = '".$redirect_value."' AND landing_page_deleted='0'";
$redirect_type_result = $db->query($redirect_type_sql);
$redirect_type_row = $redirect_type_result->fetch_assoc();
$redirect_name = "Landing page: ".$redirect_type_row['landing_page_nickname'];
$redirect_sql = "redirect_lp='".$redirect_value."', redirect_url=null, redirect_campaign=null, auto_monetizer=null, name='".$redirect_name."'";
break;
case 'monetizer':
$redirect_name = "Auto Monetizer";
$redirect_sql = "redirect_lp=null, redirect_url=null, redirect_campaign=null, auto_monetizer=true, name='".$redirect_name."'";
break;
}
if ($splittest) {
$redirect_weight = $db->real_escape_string($redirect['weight']);
$redirect_sql .= ", weight='".$redirect_weight."'";
}
if ($redirect['id'] != 'none') {
$rule_redirect_id = $db->real_escape_string($redirect['id']);
$rule_redirect_sql = "UPDATE 202_rotator_rules_redirects SET rule_id='".$rule_id."', ".$redirect_sql." WHERE id = '".$rule_redirect_id."'";
$rule_redirect_result = $db->query($rule_redirect_sql);
$redirects_ids[] = $redirect['id'];
} else {
$rule_redirect_sql = "INSERT INTO 202_rotator_rules_redirects SET rule_id='".$rule_id."', ".$redirect_sql."";
$rule_redirect_result = $db->query($rule_redirect_sql);
$redirects_ids[] = $db->insert_id;
}
}
if ($slack) {
if ($old_rule_row['rule_name'] != $rule_name) {
$slack->push('rotator_rule_name_changed', array('rotator' => $rotator_row['name'], 'old_name' => $old_rule_row['rule_name'], 'new_name' => $rule_name, 'user' => $user_row['username']));
}
if ($old_rule_row['status'] != $status) {
if ($old_rule_row['status'] == '1') {
$old_status = 'active';
} else if ($old_rule_row['status'] == '0') {
$old_status = 'inactive';
}
if ($status) {
$new_status = 'active';
} else {
$new_status = 'inactive';
}
$slack->push('rotator_rule_status_changed', array('rotator' => $rotator_row['name'], 'rule' => $rule_name, 'old_status' => $old_status, 'new_status' => $new_status, 'user' => $user_row['username']));
}
}
} else {
$rule_sql = "INSERT INTO 202_rotator_rules SET rotator_id='".$rotator_id."', rule_name='".$rule_name."', splittest='".$splittest."', status='".$status."'";
$rule_result = $db->query($rule_sql);
$rule_id = $db->insert_id;
$rules_id[] = $rule_id;
foreach ($rule['redirects'] as $redirect) {
$redirect_value = $db->real_escape_string($redirect['value']);
switch ($redirect['type']) {
case 'campaign':
$redirect_sql = "redirect_campaign='".$redirect_value."', redirect_url=null, redirect_lp=null, auto_monetizer=null";
break;
case 'url':
$redirect_sql = "redirect_url='".$redirect_value."', redirect_campaign=null, redirect_lp=null, auto_monetizer=null";
break;
case 'lp':
$redirect_type_sql = "SELECT landing_page_nickname FROM 202_landing_pages WHERE landing_page_id = '".$redirect_value."' AND landing_page_deleted='0'";
$redirect_type_result = $db->query($redirect_type_sql);
$redirect_type_row = $redirect_type_result->fetch_assoc();
$redirect_name = "Landing page: ".$redirect_type_row['landing_page_nickname'];
$redirect_sql = "redirect_lp='".$redirect_value."', redirect_url=null, redirect_campaign=null, auto_monetizer=null, name='".$redirect_name."'";
break;
case 'monetizer':
$redirect_sql = "redirect_lp=null, redirect_url=null, redirect_campaign=null, auto_monetizer=true";
break;
}
if ($splittest) {
$redirect_weight = $db->real_escape_string($redirect['weight']);
$redirect_sql .= ", weight='".$redirect_weight."'";
}
$rule_redirect_sql = "INSERT INTO 202_rotator_rules_redirects SET rule_id='".$rule_id."', ".$redirect_sql."";
$rule_redirect_result = $db->query($rule_redirect_sql);
$redirects_ids[] = $db->insert_id;
}
if ($slack)
$slack->push('rotator_rule_created', array('rotator' => $rotator_row['name'], 'rule' => $rule_name, 'user' => $user_row['username']));
}
if ($rule_result) {
foreach ($rule['criteria'] as $criteria) {
$type = $db->real_escape_string($criteria['type']);
$statement = $db->real_escape_string($criteria['statement']);
$value = $db->real_escape_string($criteria['value']);
if (strcasecmp("ALL", $value) == 0) {
$value = 'ALL'; //save ALL as uppercase to elimitate errors cause by how users typed the value
}
if ($criteria['criteria_id'] != 'none') {
$criteria_sql = "UPDATE 202_rotator_rules_criteria SET rotator_id='".$rotator_id."', rule_id='".$rule_id."', type='".$type."', statement='".$statement."', value='".$value."' WHERE id='".$criteria['criteria_id']."'";
$criteria_result = $db->query($criteria_sql);
$criteria_id[] = $criteria['criteria_id'];
} else {
$criteria_sql = "INSERT INTO 202_rotator_rules_criteria SET rotator_id='".$rotator_id."', rule_id='".$rule_id."', type='".$type."', statement='".$statement."', value='".$value."'";
$criteria_result = $db->query($criteria_sql);
$criteria_inserted_id = $db->insert_id;
$criteria_id[] = $criteria_inserted_id;
if ($slack) {
$criteria_value = $type." ".$statement." ".$value;
$slack->push('rotator_rules_criteria_created', array('rotator' => $rotator_row['name'], 'rule' => $rule_name, 'criteria' => $criteria_value, 'user' => $user_row['username']));
}
}
$criteria_added[] = $criteria['criteria_id'];
}
}
$redirects_ids = implode(', ', $redirects_ids);
$delete_redirects_sql = "DELETE FROM 202_rotator_rules_redirects WHERE id NOT IN (".$redirects_ids.") AND rule_id = '".$rule_id."'";
$delete_redirects_result = $db->query($delete_redirects_sql);
}
}
$criteria_id = implode(', ', $criteria_id);
$rules_id = implode(', ', $rules_id);
if ($slack) {
$sql = "SELECT rule_name FROM 202_rotator_rules WHERE id NOT IN (".$rules_id.") AND rotator_id='".$rotator_id."'";
$result = $db->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$slack->push('rotator_rule_deleted', array('rotator' => $rotator_row['name'], 'rule' => $row['rule_name'], 'user' => $user_row['username']));
}
}
}
$sql = "DELETE FROM `202_rotator_rules` WHERE `id` NOT IN (".$rules_id.") AND rotator_id='".$rotator_id."'";
$result = $db->query($sql);
if ($slack) {
$sql = "SELECT 2rc.id, 2rc.type, 2rc.statement, 2rc.value, 2rl.rule_name
FROM 202_rotator_rules_criteria AS 2rc
LEFT JOIN 202_rotator_rules AS 2rl ON (2rc.rule_id = 2rl.id)
WHERE 2rc.id NOT IN (".$criteria_id.") AND 2rc.rotator_id='".$rotator_id."'";
$result = $db->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
if (!in_array($row['id'], $criteria_added)) {
$criteria_value = $row['type']." ".$row['statement']." ".$row['value'];
$slack->push('rotator_rules_criteria_deleted', array('rotator' => $rotator_row['name'], 'rule' => $row['rule_name'], 'criteria' => $criteria_value, 'user' => $user_row['username']));
}
}
}
}
$sql = "DELETE FROM `202_rotator_rules_criteria` WHERE `id` NOT IN (".$criteria_id.") AND rotator_id='".$rotator_id."'";
$result = $db->query($sql);
if ($criteria_result == true) {
echo "DONE";
}
}
if (isset($_POST['rule_id']) && $_POST['rule_details'] == true) {
$id = $db->real_escape_string($_POST['rule_id']);
$rule_sql = "SELECT * FROM
202_rotator_rules AS ru
LEFT JOIN 202_rotator_rules_criteria AS cr ON ru.id = cr.rule_id
WHERE ru.id = '".$id."'";
$rule_result = $db->query($rule_sql);
$redirect_sql = "SELECT rr.redirect_url, rr.redirect_campaign, rr.redirect_lp, rr.weight, 202_aff_campaigns.aff_campaign_name, 202_landing_pages.landing_page_nickname FROM 202_rotator_rules_redirects AS rr
LEFT JOIN 202_aff_campaigns ON (rr.redirect_campaign = 202_aff_campaigns.aff_campaign_id)
LEFT JOIN 202_landing_pages ON (rr.redirect_lp = 202_landing_pages.landing_page_id)
WHERE rr.rule_id = '".$id."'";
$redirect_result = $db->query($redirect_sql);
?>
;?>202-img/loader-small.gif)