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, 2u.install_hash, 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_results = $db->query($user_sql);
$user_row = $user_results->fetch_assoc();
if (!empty($user_row['url']))
$slack = new Slack($user_row['url']);
if ($_GET ['edit_aff_network_id']) {
$editing = true;
}
if ($_SERVER ['REQUEST_METHOD'] == 'POST') {
$aff_network_name = trim ( $_POST ['aff_network_name'] );
if (empty ( $aff_network_name )) {
$error ['aff_network_name'] = 'Type in the name of your campaign\'s category.
';
}
//if editing, check to make sure the own the network they are editing
if ($editing == true) {
$mysql ['aff_network_id'] = $db->real_escape_string ( $_GET ['edit_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 edit another users network
';
} else {
$aff_network_row = $aff_network_result->fetch_assoc();
}
}
if (! $error) {
$mysql ['aff_network_name'] = $db->real_escape_string ( $_POST ['aff_network_name'] );
$mysql ['user_id'] = $db->real_escape_string ( $_SESSION ['user_id'] );
$mysql ['aff_network_time'] = time ();
if ($editing == true) {
$aff_network_sql = "UPDATE `202_aff_networks` SET";
} else {
$aff_network_sql = "INSERT INTO `202_aff_networks` SET";
}
$aff_network_sql .= "`user_id`='" . $mysql ['user_id'] . "',
`aff_network_name`='" . $mysql ['aff_network_name'] . "',
`aff_network_time`='" . $mysql ['aff_network_time'] . "'";
if ($editing == true) {
$aff_network_sql .= "WHERE `aff_network_id`='" . $mysql ['aff_network_id'] . "'";
}
$aff_network_result = $db->query ( $aff_network_sql ) or record_mysql_error ( $aff_network_sql );
$add_success = true;
if ($slack) {
if ($editing == true) {
$slack->push('campaign_category_name_changed', array('old_name' => $aff_network_row['aff_network_name'], 'new_name' => $_POST['aff_network_name'], 'user' => $user_row['username']));
} else {
$slack->push('campaign_category_created', array('name' => $_POST['aff_network_name'], 'user' => $user_row['username']));
}
}
}
tagUserByNetwork($user_row['install_hash'], 'affiliate-networks', $_POST['aff_network_name']);
}
if ($_GET ['edit_aff_network_id']) {
$mysql ['user_id'] = $db->real_escape_string ( $_SESSION ['user_id'] );
$mysql ['aff_network_id'] = $db->real_escape_string ( $_GET ['edit_aff_network_id'] );
$aff_network_sql = "SELECT *
FROM `202_aff_networks`
WHERE `aff_network_id`='" . $mysql ['aff_network_id'] . "'
AND `user_id`='" . $mysql ['user_id'] . "'";
$aff_network_result = $db->query ( $aff_network_sql ) or record_mysql_error ( $aff_network_sql );
$aff_network_row = $aff_network_result->fetch_assoc();
$html = array_map ( 'htmlentities', $aff_network_row );
$html['aff_network_id'] = htmlentities ( $_GET ['edit_aff_network_id'], ENT_QUOTES, 'UTF-8' );
$autocomplete_aff_network_name = $html['aff_network_name'];
}
//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 );
}
if (isset ( $_GET ['delete_aff_network_id'] )) {
if ($userObj->hasPermission("remove_campaign_category")) {
$mysql ['user_id'] = $db->real_escape_string ( $_SESSION ['user_id'] );
$mysql ['aff_network_id'] = $db->real_escape_string ( $_GET ['delete_aff_network_id'] );
$mysql ['aff_network_time'] = time ();
$delete_sql = " UPDATE `202_aff_networks`
SET `aff_network_deleted`='1',
`aff_network_time`='" . $mysql ['aff_network_time'] . "'
WHERE `user_id`='" . $mysql ['user_id'] . "'
AND `aff_network_id`='" . $mysql ['aff_network_id'] . "'";
if ($delete_result = $db->query ( $delete_sql ) or record_mysql_error ( $delete_result )) {
$delete_success = true;
if ($slack)
$slack->push('campaign_category_deleted', array('name' => $_GET['delete_aff_network_name'], 'user' => $user_row['username']));
}
} else {
header('location: '.get_absolute_url().'tracking202/setup/aff_networks.php');
}
}
template_top ( 'Campaign Category Setup', NULL, NULL, NULL );
?>
Campaign Category Setup
pull-right" style="margin-top: 20px;">
Add categories for the offer you will you work with here. For example you may enter in the affiliate networks you work or you could enter in different categories/niches such as "Lead Gen", "Mobile CPI", "CPA" or "CPS".
Add Campaign Category What Campaign Categories do you want to use? Some examples include Commission Junction or Mobile etc.
My Campaign Categories
real_escape_string ( $_SESSION ['user_id'] );
$aff_network_sql = "SELECT * FROM `202_aff_networks` WHERE `user_id`='" . $mysql ['user_id'] . "' AND `aff_network_deleted`='0' ORDER BY `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 added any networks. fetch_array (MYSQLI_ASSOC) ) {
$html ['aff_network_name'] = htmlentities ( $aff_network_row ['aff_network_name'], ENT_QUOTES, 'UTF-8' );
$html ['aff_network_id'] = htmlentities ( $aff_network_row ['aff_network_id'], ENT_QUOTES, 'UTF-8' );
$html ['network_logo'] = '';
if(!empty($aff_network_row ['dni_network_id']))
$html ['network_logo']= '%s %s - edit - remove ', $html ['network_logo'], $html ['aff_network_name'], $html ['aff_network_id'], $html ['aff_network_id'],$html ['aff_network_name'] );
} else {
printf ( '%s %s - edit ', $html ['network_logo'], $html ['aff_network_name'], $html ['aff_network_id']);
}
}
?>
'; //replace with actual logo from db
if ($userObj->hasPermission("remove_campaign_category")) {
printf ( '