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, 2u.install_hash, 2up.user_account_currency 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();
$user_account_currency = $user_row['user_account_currency'];
$dniNetworks = getAllDniNetworks($user_row['install_hash']);
$rotateUrlCampaignsSql = "SELECT * FROM 202_aff_campaigns WHERE user_id = '".$mysql['user_id']."' AND aff_campaign_deleted = 0 AND aff_campaign_rotate = 1";
$rotateUrlCampaignsResults = $db->query($rotateUrlCampaignsSql);
if (!empty($user_row['url']))
$slack = new Slack($user_row['url']);
if ($_GET ['edit_aff_campaign_id']) {
$editing = true;
}
if ($_GET ['copy_aff_campaign_id']) {
$copying = true;
}
if ($_SERVER ['REQUEST_METHOD'] == 'POST') {
$aff_network_id = trim ( $_POST ['aff_network_id'] );
if (empty ( $aff_network_id )) {
$error ['aff_network_id'] = 'Select a category.
';
}
$aff_campaign_name = trim ( $_POST ['aff_campaign_name'] );
if (empty ( $aff_campaign_name )) {
$error ['aff_campaign_name'] = 'What is the name of this campaign.
';
}
$aff_campaign_url = trim ( $_POST ['aff_campaign_url'] );
if (empty ( $aff_campaign_url )) {
$error ['aff_campaign_url'] = 'What is your affiliate link? Make sure subids can be added to it.
';
}
if ((strpos ( $_POST ['aff_campaign_url'], '://' ) === 'false')) {
$error ['aff_campaign_url'] .= 'Your Campaign URL be a valid webpage or deeplink
';
}
$aff_campaign_payout = trim ( $_POST ['aff_campaign_payout'] );
if (! is_numeric ( $aff_campaign_payout )) {
$error ['aff_campaign_payout'] .= 'Please enter in a numeric number for the payout.
';
}
//check to see if they are the owners of this affiliate network
$mysql ['aff_network_id'] = $db->real_escape_string ( $_POST ['aff_network_id'] );
$mysql ['user_id'] = $db->real_escape_string ( $_SESSION ['user_id'] );
$aff_network_sql = "SELECT * FROM `202_aff_networks` WHERE `user_id`='" . $mysql ['user_id'] . "' AND `aff_network_id`='" . $mysql ['aff_network_id'] . "'";
$aff_network_result = $db->query ( $aff_network_sql ) or record_mysql_error ( $aff_network_sql );
if ($aff_network_result->num_rows == 0) {
$error ['wrong_user'] = 'You are not authorized to add an campaign to another users network
';
} else {
$aff_network_row = $aff_network_result->fetch_assoc();
}
//if editing, check to make sure the own the campaign they are editing
if ($editing == true) {
$mysql ['aff_campaign_id'] = $db->real_escape_string ( $_POST ['aff_campaign_id'] );
$mysql ['user_id'] = $db->real_escape_string ( $_SESSION ['user_id'] );
$aff_campaign_sql = "SELECT * FROM 202_aff_campaigns AS 2cp LEFT JOIN 202_aff_networks AS 2an USING (aff_network_id) WHERE 2cp.user_id='" . $mysql ['user_id'] . "' AND 2cp.aff_campaign_id='" . $mysql ['aff_campaign_id'] . "'";
$aff_campaign_result = $db->query ( $aff_campaign_sql ) or record_mysql_error ( $aff_campaign_sql );
if ($aff_campaign_result->num_rows == 0) {
$error ['wrong_user'] .= 'You are not authorized to modify another users campaign
';
} else {
$aff_campaign_row = $aff_campaign_result->fetch_assoc();
}
}
if (! $error) {
$mysql ['aff_campaign_id'] = $db->real_escape_string ( $_POST ['aff_campaign_id'] );
$mysql ['aff_network_id'] = $db->real_escape_string ( $_POST ['aff_network_id'] );
$mysql ['aff_campaign_name'] = $db->real_escape_string ( trim($_POST ['aff_campaign_name']) );
$mysql ['aff_campaign_url'] = $db->real_escape_string ( trim($_POST ['aff_campaign_url']) );
$mysql ['aff_campaign_url_2'] = $db->real_escape_string ( trim($_POST ['aff_campaign_url_2']) );
$mysql ['aff_campaign_url_3'] = $db->real_escape_string ( trim($_POST ['aff_campaign_url_3']) );
$mysql ['aff_campaign_url_4'] = $db->real_escape_string ( trim($_POST ['aff_campaign_url_4']) );
$mysql ['aff_campaign_url_5'] = $db->real_escape_string ( trim($_POST ['aff_campaign_url_5']) );
$mysql ['aff_campaign_rotate'] = $db->real_escape_string ( $_POST ['aff_campaign_rotate'] );
$mysql ['aff_campaign_cloaking'] = $db->real_escape_string ( $_POST ['aff_campaign_cloaking'] );
$mysql ['user_id'] = $db->real_escape_string ( $_SESSION ['user_id'] );
$mysql ['aff_campaign_time'] = time ();
$mysql['aff_campaign_currency'] = $db->real_escape_string ( $_POST ['aff_campaign_currency'] );
if ($mysql['aff_campaign_currency'] != $user_account_currency) {
$exchangePayout = getForeignPayout($user_account_currency, $mysql['aff_campaign_currency'], trim($_POST['aff_campaign_payout']));
$mysql['aff_campaign_payout'] = $db->real_escape_string($exchangePayout['exchange_payout']);
$mysql['aff_campaign_foreign_payout'] = $db->real_escape_string(trim($_POST['aff_campaign_payout']));
} else {
$mysql['aff_campaign_payout'] = $db->real_escape_string(trim($_POST['aff_campaign_payout']));
}
if ($editing == true) {
$aff_campaign_sql = "UPDATE `202_aff_campaigns` SET";
} else {
$aff_campaign_sql = "INSERT INTO `202_aff_campaigns` SET";
}
$aff_campaign_sql .= "`aff_network_id`='" . $mysql ['aff_network_id'] . "',
`user_id`='" . $mysql ['user_id'] . "',
`aff_campaign_name`='" . $mysql ['aff_campaign_name'] . "',
`aff_campaign_url`='" . $mysql ['aff_campaign_url'] . "',
`aff_campaign_url_2`='" . $mysql ['aff_campaign_url_2'] . "',
`aff_campaign_url_3`='" . $mysql ['aff_campaign_url_3'] . "',
`aff_campaign_url_4`='" . $mysql ['aff_campaign_url_4'] . "',
`aff_campaign_url_5`='" . $mysql ['aff_campaign_url_5'] . "',
`aff_campaign_rotate`='" . $mysql ['aff_campaign_rotate'] . "',
`aff_campaign_payout`='" . $mysql ['aff_campaign_payout'] . "',
`aff_campaign_cloaking`='" . $mysql ['aff_campaign_cloaking'] . "',
`aff_campaign_time`='" . $mysql ['aff_campaign_time'] . "',
aff_campaign_currency = '".$mysql['aff_campaign_currency']."',
aff_campaign_foreign_payout = '".$mysql['aff_campaign_foreign_payout']."'";
if ($editing == true) {
$aff_campaign_sql .= "WHERE `aff_campaign_id`='" . $mysql ['aff_campaign_id'] . "'";
}
$aff_campaign_result = $db->query ( $aff_campaign_sql ) or record_mysql_error ( $aff_campaign_sql );
$add_success = true;
if ($slack) {
if ($editing == true) {
if ($aff_campaign_row['aff_campaign_name'] != $_POST['aff_campaign_name']) {
$slack->push('campaign_name_changed', array('old_name' => $aff_campaign_row['aff_campaign_name'], 'new_name' => $_POST['aff_campaign_name'], 'user' => $user_row['username']));
}
if ($aff_campaign_row['aff_network_id'] != $_POST['aff_network_id']) {
$slack->push('campaign_category_changed', array('name' => $_POST['aff_campaign_name'], 'old_category' => $aff_campaign_row['aff_network_name'], 'new_category' => $aff_network_row['aff_network_name'], 'user' => $user_row['username']));
}
if ($aff_campaign_row['aff_campaign_rotate'] != $_POST['aff_campaign_rotate']) {
if ($_POST['aff_campaign_rotate'] == true) {
$rotation_status = 'on';
} else {
$rotation_status = 'off';
}
$slack->push('campaign_category_rotation_changed', array('name' => $_POST['aff_campaign_name'], 'status' => $rotation_status, 'user' => $user_row['username']));
}
if ($aff_campaign_row['aff_campaign_url'] != $_POST['aff_campaign_url']) {
$slack->push('campaign_url_changed', array('name' => $_POST['aff_campaign_name'], 'old_url' => $aff_campaign_row['aff_campaign_url'], 'new_url' => $_POST['aff_campaign_url'], 'user' => $user_row['username']));
}
if ($aff_campaign_row['aff_campaign_payout'] != $_POST['aff_campaign_payout']) {
$slack->push('campaign_payout_changed', array('name' => $_POST['aff_campaign_name'], 'old_payout' => $aff_campaign_row['aff_campaign_payout'], 'new_payout' => $_POST['aff_campaign_payout'], 'user' => $user_row['username']));
}
if ($aff_campaign_row['aff_campaign_cloaking'] != $_POST['aff_campaign_cloaking']) {
if ($_POST['aff_campaign_cloaking'] == true) {
$claoking_status = 'on';
} else {
$claoking_status = 'off';
}
$slack->push('campaign_cloaking_changed', array('name' => $_POST['aff_campaign_name'], 'status' => $claoking_status, 'user' => $user_row['username']));
}
}
}
if ($editing != true) {
//if this landing page is brand new, add on a landing_page_id_public
$aff_campaign_row ['aff_campaign_id'] = $db->insert_id;
$aff_campaign_id_public = rand ( 1, 9 ) . $aff_campaign_row ['aff_campaign_id'] . rand ( 1, 9 );
$mysql ['aff_campaign_id_public'] = $db->real_escape_string ( $aff_campaign_id_public );
$mysql ['aff_campaign_id'] = $db->real_escape_string ( $aff_campaign_row ['aff_campaign_id'] );
$aff_campaign_sql = " UPDATE `202_aff_campaigns`
SET `aff_campaign_id_public`='" . $mysql ['aff_campaign_id_public'] . "'
WHERE `aff_campaign_id`='" . $mysql ['aff_campaign_id'] . "'";
$aff_campaign_result = $db->query ( $aff_campaign_sql ) or record_mysql_error ( $aff_campaign_sql );
if (isset($_POST['dni_id']) && isset($_POST['dni_offer_id'])) {
$ddlci = false;
if (isset($_GET['ddlci']) && is_numeric($_GET['ddlci'])) {
$ddlci = $_GET['ddlci'];
}
$mysql['dni_id'] = $db->real_escape_string($_POST['dni_id']);
$dniSql = 'SELECT networkId, apiKey, affiliateId FROM 202_dni_networks WHERE user_id = "'.$mysql['user_id'].'" AND id = "'.$mysql['dni_id'].'"';
$dniResult = $db->query($dniSql);
if ($dniResult->num_rows > 0) {
$dniRow = $dniResult->fetch_assoc();
setupDniOfferTrack($user_row['install_hash'], $dniRow['networkId'], $dniRow['apiKey'], $dniRow['affiliateId'], $_POST['dni_offer_id'], $ddlci);
}
}
if($slack)
$slack->push('campaign_created', array('name' => $_POST ['aff_campaign_name'], 'user' => $user_row['username']));
}
$_GET['copy_aff_campaign_id'] = false;
}
}
if (isset ( $_GET ['delete_aff_campaign_id'] )) {
if ($userObj->hasPermission("remove_campaign")) {
$mysql ['user_id'] = $db->real_escape_string ( $_SESSION ['user_id'] );
$mysql ['aff_campaign_id'] = $db->real_escape_string ( $_GET ['delete_aff_campaign_id'] );
$mysql ['date_deleted'] = time ();
$delete_sql = " UPDATE `202_aff_campaigns`
SET `aff_campaign_deleted`='1',
`aff_campaign_time`='" . $mysql ['aff_campaign_time'] . "'
WHERE `user_id`='" . $mysql ['user_id'] . "'
AND `aff_campaign_id`='" . $mysql ['aff_campaign_id'] . "'";
if ($delete_result = $db->query ( $delete_sql ) or record_mysql_error ( $delete_result )) {
$delete_success = true;
}
} else {
header('location: '.get_absolute_url().'tracking202/setup/aff_campaigns.php');
}
}
if ($_GET ['edit_aff_campaign_id']) {
$mysql ['user_id'] = $db->real_escape_string ( $_SESSION ['user_id'] );
$mysql ['aff_campaign_id'] = $db->real_escape_string ( $_GET ['edit_aff_campaign_id'] );
$aff_campaign_sql = "SELECT *
FROM `202_aff_campaigns`
WHERE `aff_campaign_id`='" . $mysql ['aff_campaign_id'] . "'
AND `user_id`='" . $mysql ['user_id'] . "'";
$aff_campaign_result = $db->query ( $aff_campaign_sql ) or record_mysql_error ( $aff_campaign_sql );
$aff_campaign_row = $aff_campaign_result->fetch_assoc();
$selected ['aff_network_id'] = $aff_campaign_row ['aff_network_id'];
$html = array_map ( 'htmlentities', $aff_campaign_row );
$html ['aff_campaign_id'] = htmlentities ( $_GET ['edit_aff_campaign_id'], ENT_QUOTES, 'UTF-8' );
if ($aff_campaign_row['aff_campaign_currency'] != $user_account_currency) {
$html['user_account_currency'] = $aff_campaign_row['aff_campaign_currency'];
$html['aff_campaign_payout'] = $aff_campaign_row['aff_campaign_foreign_payout'];
}
}
if ($_GET ['copy_aff_campaign_id']) {
$mysql ['user_id'] = $db->real_escape_string ( $_SESSION ['user_id'] );
$mysql ['aff_campaign_id'] = $db->real_escape_string ( $_GET ['copy_aff_campaign_id'] );
$aff_campaign_sql = "SELECT *
FROM `202_aff_campaigns`
WHERE `aff_campaign_id`='" . $mysql ['aff_campaign_id'] . "'
AND `user_id`='" . $mysql ['user_id'] . "'";
$aff_campaign_result = $db->query ( $aff_campaign_sql ) or record_mysql_error ( $aff_campaign_sql );
$aff_campaign_row = $aff_campaign_result->fetch_assoc();
$selected ['aff_network_id'] = $aff_campaign_row ['aff_network_id'];
$html = array_map ( 'htmlentities', $aff_campaign_row );
$html ['aff_campaign_id'] = htmlentities ( $_GET ['copy_aff_campaign_id'], ENT_QUOTES, 'UTF-8' );
$html ['aff_campaign_name'] .= " (Copy)"; //append (Copy) to the campaign name so the user knows its a copy
}
//this will override the edit, if posting and edit fail
if (($_SERVER ['REQUEST_METHOD'] == 'POST') and ($add_success != true)) {
$selected ['aff_network_id'] = $_POST ['aff_network_id'];
$html = array_map ( 'htmlentities', $_POST );
}
template_top ( 'Affiliate Campaigns Setup', NULL, NULL, NULL );
?>
Campaign Setup
pull-right" style="margin-top: 20px;">
Add the campaigns you want to run.
If you do not understand how subids work at your network, stop, and contact your affiliate manager.
Add A Campaign Here you add each of the campaigns you are running.
My Campaigns
real_escape_string ( $_SESSION ['user_id'] );
$aff_network_sql = "SELECT 2af.user_id, 2af.aff_network_id, 2dni.networkid, 2af.aff_network_name, 2af.dni_network_id, 2dni.favicon, 2dni.processed FROM 202_aff_networks AS 2af LEFT JOIN 202_dni_networks AS 2dni ON (2af.dni_network_id = 2dni.id) WHERE 2af.user_id='" . $mysql ['user_id'] . "' AND 2af.aff_network_deleted='0' ORDER BY 2af.dni_network_id desc,2af.aff_network_name ASC";
$aff_network_result = $db->query ( $aff_network_sql ) or record_mysql_error ( $aff_network_sql );
if ($aff_network_result->num_rows == 0) {
?>You have not activated any networks. fetch_array (MYSQLI_ASSOC) ) {
$html ['aff_network_name'] = htmlentities ( $aff_network_row ['aff_network_name'], ENT_QUOTES, 'UTF-8' );
$url ['aff_network_id'] = urlencode ( $aff_network_row ['aff_network_id'] );
if ($aff_network_row['dni_network_id'] != null) {
if ($aff_network_row['processed'] == false) {
$dni_is_live = "processing... ";
} else {
$dni_is_live = 'Search Offers ';
}
$dni_logo = '%s%s - %s ',$dni_logo, $html['aff_network_name'], $dni_is_live);
@array_walk($dniNetworks, 'checkNetworks', $aff_network_row ['networkid']);
} else {
printf ( '%s real_escape_string ( $aff_network_row ['aff_network_id'] );
$aff_campaign_sql = "SELECT * FROM `202_aff_campaigns` WHERE `user_id`='" . $mysql ['user_id'] . "' AND `aff_network_id`='" . $mysql ['aff_network_id'] . "' AND `aff_campaign_deleted`='0' ORDER BY `aff_campaign_name` ASC";
$aff_campaign_result = $db->query ( $aff_campaign_sql ) or record_mysql_error ( $aff_campaign_sql );
while ( $aff_campaign_row = $aff_campaign_result->fetch_array (MYSQLI_ASSOC) ) {
$html ['aff_campaign_name'] = htmlentities ( $aff_campaign_row ['aff_campaign_name'], ENT_QUOTES, 'UTF-8' );
$html ['aff_campaign_payout'] = htmlentities ( $aff_campaign_row ['aff_campaign_payout'], ENT_QUOTES, 'UTF-8' );
$html ['aff_campaign_url'] = htmlentities ( $aff_campaign_row ['aff_campaign_url'], ENT_QUOTES, 'UTF-8' );
$html ['aff_campaign_id'] = htmlentities ( $aff_campaign_row ['aff_campaign_id'], ENT_QUOTES, 'UTF-8' );
$html ['aff_campaign_rotate'] = htmlentities ( $aff_campaign_row ['aff_campaign_rotate'], ENT_QUOTES, 'UTF-8' );
$html ['aff_campaign_foreign_payout'] = htmlentities ( $aff_campaign_row ['aff_campaign_foreign_payout'], ENT_QUOTES, 'UTF-8' );
if ($aff_campaign_row['aff_campaign_currency'] != $user_account_currency) {
$aff_campaign_payout = dollar_format('', $user_account_currency) . $html ['aff_campaign_payout'] . ' ('.dollar_format('', $aff_campaign_row['aff_campaign_currency']) . $html ['aff_campaign_foreign_payout'].')';
} else {
$aff_campaign_payout = dollar_format('', $user_account_currency) . $html ['aff_campaign_payout'];
}
if($html ['aff_campaign_rotate']) {
if ($userObj->hasPermission("remove_campaign")) {
printf ( ' %s · %s - link - edit - copy - remove ', $html ['aff_campaign_name'], $aff_campaign_payout, $html ['aff_campaign_url'], $html ['aff_campaign_id'], $html ['aff_campaign_id'], $html ['aff_campaign_id'] );
} else {
printf ( ' %s · %s - link - edit - copy ', $html ['aff_campaign_name'], $aff_campaign_payout, $html ['aff_campaign_url'], $html ['aff_campaign_id'], $html ['aff_campaign_id']);
}
} else {
if ($userObj->hasPermission("remove_campaign")) {
printf ( '%s · %s - link - edit - copy - remove %s · %s - link - edit - copy ".$dninetwork['name']." (DNI) - Activate ";
}}
?>
ID
Name
Payout
Type
Preview
Status
real_escape_string($_GET['dl_dni']);
$getDlDniSql = "SELECT id FROM 202_dni_networks WHERE networkId = '".$mysql['dl_dni']."' AND user_id = '".$mysql['user_id']."'";
$getDlDniResult = $db->query($getDlDniSql);
if ($getDlDniResult->num_rows > 0) {
$getDlDniRow = $getDlDniResult->fetch_assoc();
}
} ?>
![](".get_absolute_url()."202-img/loader-small.gif)
";
} else {
$dni_is_live = 'Search Offers';
}
$dni_logo = ';?>202-img/loader-small.gif)