Prosellers Shell V2.0

Editing: aff_networks.php

Cancel

<?php
include_once(str_repeat("../", 2).'202-config/connect.php');

AUTH::require_user();

if (!$userObj->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'] = '<div class="error">Type in the name of your campaign\'s category.</div>';
	}

//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'] = '<div class="error">You are not authorized to edit another users network</div>';
		} 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 );
?>

<div class="row" style="margin-bottom: 15px;">
	<div class="col-xs-12">
		<div class="row">
			<div class="col-xs-5">
				<h6>Campaign Category Setup <?php showHelp("step2"); ?></h6>
			</div>
			<div class="col-xs-8">
				<div class="<?php if($error) echo "error"; else echo "success";?> pull-right" style="margin-top: 20px;">
					<small>
						<?php if ($error) { ?> 
							<span class="fui-alert"></span> There were errors with your submission. <?php echo $error['token']; ?>
						<?php } ?>
						<?php if ($add_success == true) { ?>
								<?php if($editing == true) { ?>
									<span class="fui-check-inverted"></span> Your submission was successful. You have successfully edited category.
								<?php } else { ?>
									<span class="fui-check-inverted"></span> Your submission was successful. You have successfully added a category to your account.
								<?php } ?>
						<?php } ?>
						<?php if ($delete_success == true) { ?>
							<span class="fui-check-inverted"></span> You have successfully deleted a category from your account.
						<?php } ?>
						
					</small>
				</div>
			</div>
		</div>
	</div>
	<div class="col-xs-12">
		<small>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".</small>
	</div>
</div>

<div class="row">
	<div class="col-xs-7">
		<small><strong>Add Campaign Category</strong></small><br/>
		<span class="infotext">What Campaign Categories do you want to use? Some examples include Commission Junction or Mobile etc.</span>
				
		<form method="post" action="<?php echo $_SERVER ['REDIRECT_URL']; ?>" class="form-inline" role="form" style="margin:15px 0px;">
			<div class="form-group <?php if($error['aff_network_name']) echo "has-error";?>">
				<label class="sr-only" for="aff_network_name">Traffic source</label>
				<input type="text" class="form-control input-sm" id="aff_network_name" name="aff_network_name" placeholder="Campaign category" value="<?php echo $html['aff_network_name']; ?>">
			</div>
			<button type="submit" class="btn btn-xs btn-p202" <?php if ($network_editing != true) { echo 'id="addCategory"'; }?>><?php if ($network_editing == true) { echo 'Edit'; } else { echo 'Add'; } ?></button>
			<?php if ($editing == true) { ?>
				<button type="submit" class="btn btn-xs btn-danger" onclick="<?php echo get_absolute_url();?>tracking202/setup/aff_networks.php'; return false;">Cancel</button>
			<?php } ?>
		</form>
	</div>
	<div class="col-xs-4 col-xs-offset-1">
		<div class="panel panel-default">
			<div class="panel-heading">My Campaign Categories</div>
			<div class="panel-body">
			<div id="networkList">
			<input class="form-control input-sm fuzzy-search" style="margin-bottom: 10px; height: 30px;" placeholder="Filter">
				<ul class="list">		
					<?php
					$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_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) {
						?><li>You have not added any networks.</li><?php
					}
					
					while ( $aff_network_row = $aff_network_result->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']= '<img src="/202-img/favicon.gif" width=16>&nbsp;&nbsp;'; //replace with actual logo from db
						    
						if ($userObj->hasPermission("remove_campaign_category")) {
							printf ( '<li>%s <span class="filter_network_name">%s</span> - <a href="?edit_aff_network_id=%s">edit</a> - <a href="?delete_aff_network_id=%s&delete_aff_network_name=%s" onclick="return confirmSubmit(\'Are You Sure You Want To Delete This Campaign Category?\');">remove</a></li>', $html ['network_logo'], $html ['aff_network_name'], $html ['aff_network_id'], $html ['aff_network_id'],$html ['aff_network_name'] );
						} else {
							printf ( '<li>%s <span class="filter_network_name">%s</span> - <a href="?edit_aff_network_id=%s">edit</a></li>', $html ['network_logo'], $html ['aff_network_name'], $html ['aff_network_id']);
						}
					
					}
					?> 
				</ul>
				</div>
			</div>
		</div>
	</div>
</div>
<script type="text/javascript">
$(document).ready(function() {
	autocomplete_names('aff_network_name', 'affiliate-networks');
	<?php if($_GET['edit_aff_network_id']) { ?>
		$("#aff_network_name").tokenfield("setTokens", <?php print_r(json_encode(array('value' => $autocomplete_aff_network_name, 'label' => $autocomplete_aff_network_name)))?>);
	<?php } ?>

var networkOptions = {
	  valueNames: ['filter_network_name'],
	  plugins: [
	    ListFuzzySearch()
	  ]
	};

var networkList = new List('networkList', networkOptions);
});
</script>
<?php template_bottom (); ?>

Editing: aff_networks.php

Upload Files

Create New

Change Permissions

Change Date

Rename Item

Confirm Delete