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_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_landing_page_id']) {
$editing = true;
}
if ($_GET['copy_landing_page_id']) {
$copying = true;
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if (($_POST['landing_page_type'] != '0') and ($_POST['landing_page_type'] != '1')) { $error['landing_page_type'] = 'What type of landing page is this?
'; }
//if this is a simple landing page
if ($_POST['landing_page_type'] == '0') {
$aff_campaign_id = trim($_POST['aff_campaign_id']);
if (empty($aff_campaign_id)) { $error['aff_campaign_id'] = 'What campaign is this landing page for?
'; }
}
$landing_page_nickname = trim($_POST['landing_page_nickname']);
if (empty($landing_page_nickname)) { $error['landing_page_nickname'] = 'Give this landing page a nickname
'; }
$landing_page_url = trim($_POST['landing_page_url']);
if (empty($landing_page_url)) { $error['landing_page_url'] = 'What is the URL of your landing page?
'; }
if ((substr($_POST['landing_page_url'],0,8) != 'https://')){
$error['landing_page_url'] .= 'Your Landing Page URL must start with https://
';
}
if (!filter_var($_POST['landing_page_url'], FILTER_VALIDATE_URL)){
$error['landing_page_url'] .= 'Your Landing Page URL must be valid
';
}
if ((substr($_POST['leave_behind_page_url'],0,8) != 'https://') && ($_POST['leave_behind_page_url'] != '')){
$error['leave_behind_page_url'] .= 'Your Leave Behind URL must start with https://
';
}
if (!filter_var($_POST['leave_behind_page_url'], FILTER_VALIDATE_URL) && ($_POST['leave_behind_page_url'] != '')){
$error['leave_behind_page_url'] .= 'Your Leave Behind URL must be valid
';
}
$mysql['facebook_pixel_assistant_status'] = '0';
if (isset($_POST['facebook_pixel_assistant']) && $_POST['facebook_pixel_assistant_status'] == 'on') {
$mysql['facebook_pixel_assistant_status'] = '1';
$facebook_pixel_assistant_content_name = $db->real_escape_string(trim($_POST['facebook_pixel_assistant_content_name']));
if (empty($facebook_pixel_assistant_content_name)) { $error['facebook_pixel_assistant_content_name'] = 'A Facebook Pixel Content Name is Needed
'; }
}
//if this is a simple landing page
if ($_POST['landing_page_type'] == '0') {
//check to see if they are the owners of this campaign
$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` WHERE `user_id`='".$mysql['user_id']."' AND `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 add a landing page to another users campaign
';
} else {
$aff_campaign_row = $aff_campaign_result->fetch_assoc();
}
}
//if editing, check to make sure the own the campaign they are editing
if ($editing == true) {
$mysql['landing_page_id'] = $db->real_escape_string($_POST['landing_page_id']);
$mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']);
$landing_page_sql = "SELECT * FROM 202_landing_pages LEFT JOIN 202_aff_campaigns USING (aff_campaign_id) WHERE 202_landing_pages.user_id='".$mysql['user_id']."' AND landing_page_id='".$mysql['landing_page_id']."'";
$landing_page_result = $db->query($landing_page_sql) or record_mysql_error($landing_page_sql);
if ($landing_page_result->num_rows == 0 ) {
$error['wrong_user'] .= 'You are not authorized to modify another users campaign
';
} else {
$landing_page_row = $landing_page_result->fetch_assoc();
}
}
if (!$error) {
if(isset($_POST['landing_page_id'])) {
$mysql['landing_page_id'] = $db->real_escape_string($_POST['landing_page_id']);
}
$mysql['aff_campaign_id'] = $db->real_escape_string($_POST['aff_campaign_id']);
$mysql['landing_page_nickname'] = $db->real_escape_string($_POST['landing_page_nickname']);
$mysql['landing_page_url'] = $db->real_escape_string($_POST['landing_page_url']);
$mysql['leave_behind_page_url'] = $db->real_escape_string($_POST['leave_behind_page_url']);
$mysql['landing_page_type'] = $db->real_escape_string($_POST['landing_page_type']);
$mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']);
$mysql['landing_page_time'] = time();
//If Facebook Pixel Assistant is on gather data
if(isset($mysql['facebook_pixel_assistant_status'])){
$mysql['facebook_pixel_assistant_status'] = 0;
$mysql['facebook_pixel_assistant_dynamic_epv'] = 0;
if ($_POST['facebook_pixel_assistant_status'] == 'on') {
$mysql['facebook_pixel_assistant_status'] = 1;
}
if ($_POST['facebook_pixel_assistant_dynamic_epv_status'] == 'on') {
$mysql['facebook_pixel_assistant_dynamic_epv'] = 1;
}
$mysql['facebook_pixel_assistant_content_name'] = $db->real_escape_string(trim($_POST['facebook_pixel_assistant_content_name']));
$mysql['facebook_pixel_assistant_content_type'] = $db->real_escape_string($_POST['facebook_pixel_assistant_content_type']);
$mysql['facebook_pixel_assistant_click_out'] = $db->real_escape_string($_POST['facebook_pixel_assistant_click_out']);
}
if ($editing == true) { $landing_page_sql = "UPDATE `202_landing_pages` SET"; }
else { $landing_page_sql = "INSERT INTO `202_landing_pages` SET"; }
$landing_page_sql .= "`aff_campaign_id`='".$mysql['aff_campaign_id']."',
`landing_page_nickname`='".$mysql['landing_page_nickname']."',
`landing_page_url`='".$mysql['landing_page_url']."'";
$landing_page_sql .= ", `leave_behind_page_url`='".$mysql['leave_behind_page_url']."' ";
$landing_page_sql .= " ,
`landing_page_type`='".$mysql['landing_page_type']."',
`user_id`='".$mysql['user_id']."',
`landing_page_time`='".$mysql['landing_page_time']."' ";
if ($editing == true) { $landing_page_sql .= "WHERE `landing_page_id`='".$mysql['landing_page_id']."'"; }
$landing_page_result = $db->query($landing_page_sql) or record_mysql_error($landing_page_sql);
if(isset($mysql['facebook_pixel_assistant_status']) && $editing == true){
if(isset($_POST['facebook_pixel_assistant_id']) && $_POST['facebook_pixel_assistant_id'] != ''){
$mysql['facebook_pixel_assistant_id'] = $db->real_escape_string($_POST['facebook_pixel_assistant_id']);
$facebook_pixel_assistant_sql = "UPDATE `202_bot202_facebook_pixel_assistant`
SET
`landing_page_id` = '".$mysql['landing_page_id']."',
`b202_fbpa_status` = '".$mysql['facebook_pixel_assistant_status']."',
`b202_fbpa_dynamic_epv` = '".$mysql['facebook_pixel_assistant_dynamic_epv']."',
`b202_fbpa_content_name` = '".$mysql['facebook_pixel_assistant_content_name']."',
`b202_fbpa_content_type` = '".$mysql['facebook_pixel_assistant_content_type']."',
`b202_fbpa_outbound_clicks` = '".$mysql['facebook_pixel_assistant_click_out']."'
WHERE `landing_page_id` = '".$mysql['landing_page_id']."'
";
}else{
$facebook_pixel_assistant_sql = "INSERT INTO `202_bot202_facebook_pixel_assistant`
SET
`landing_page_id` = '".$mysql['landing_page_id']."',
`b202_fbpa_status` = '".$mysql['facebook_pixel_assistant_status']."',
`b202_fbpa_dynamic_epv` = '".$mysql['facebook_pixel_assistant_dynamic_epv']."',
`b202_fbpa_content_name` = '".$mysql['facebook_pixel_assistant_content_name']."',
`b202_fbpa_content_type` = '".$mysql['facebook_pixel_assistant_content_type']."',
`b202_fbpa_outbound_clicks` = '".$mysql['facebook_pixel_assistant_click_out']."'
ON DUPLICATE KEY UPDATE
`b202_fbpa_status` = '".$mysql['facebook_pixel_assistant_status']."',
`b202_fbpa_dynamic_epv` = '".$mysql['facebook_pixel_assistant_dynamic_epv']."',
`b202_fbpa_content_name` = '".$mysql['facebook_pixel_assistant_content_name']."',
`b202_fbpa_content_type` = '".$mysql['facebook_pixel_assistant_content_type']."',
`b202_fbpa_outbound_clicks` = '".$mysql['facebook_pixel_assistant_click_out']."'
";
}
$facebook_pixel_assistant_result = $db->query($facebook_pixel_assistant_sql) or record_mysql_error($facebook_pixel_assistant_sql);
}
$add_success = true;
if ($editing == true) {
if ($slack) {
if ($_POST['landing_page_type'] == '0') {
if ($landing_page_row['aff_campaign_id'] != $_POST['aff_campaign_id']) {
$slack->push('simple_landing_page_campaign_changed', array('name' => $_POST['landing_page_nickname'], 'old_campaign' => $landing_page_row['aff_campaign_name'], 'new_campaign' => $aff_campaign_row['aff_campaign_name'], 'user' => $user_row['username']));
}
$lp_type = 'simple';
} else if ($_POST['landing_page_type'] == '1') {
$lp_type = 'advanced';
}
if ($landing_page_row['landing_page_nickname'] != $_POST['landing_page_nickname']) {
$slack->push($lp_type.'_landing_page_name_changed', array('name' => $_POST['landing_page_nickname'], 'old_name' => $landing_page_row['landing_page_nickname'], 'new_name' => $_POST['landing_page_nickname'], 'user' => $user_row['username']));
}
if ($landing_page_row['landing_page_url'] != $_POST['landing_page_url']) {
$slack->push($lp_type.'_landing_page_url_changed', array('name' => $_POST['landing_page_nickname'], 'old_url' => $landing_page_row['landing_page_url'], 'new_url' => $_POST['landing_page_url'], 'user' => $user_row['username']));
}
}
header('location: '.get_absolute_url().'tracking202/setup/landing_pages.php');
} else {
if ($slack) {
if ($_POST['landing_page_type'] == '0') {
$slack->push('simple_landing_page_created', array('name' => $_POST['landing_page_nickname'], 'user' => $user_row['username']));
} else if ($_POST['landing_page_type'] == '1') {
$slack->push('advanced_landing_page_created', array('name' => $_POST['landing_page_nickname'], 'user' => $user_row['username']));
}
}
}
if ($editing != true) {
//if this landing page is brand new, add on a landing_page_id_public
$landing_page_row['landing_page_id'] = $db->insert_id;
$landing_page_id_public = rand(1,9) . $landing_page_row['landing_page_id'] . rand(1,9);
$mysql['landing_page_id_public'] = $db->real_escape_string($landing_page_id_public);
$mysql['landing_page_id'] = $db->real_escape_string($landing_page_row['landing_page_id']);
$landing_page_sql = " UPDATE `202_landing_pages`
SET `landing_page_id_public`='".$mysql['landing_page_id_public']."'
WHERE `landing_page_id`='".$mysql['landing_page_id']."'";
$landing_page_result = $db->query($landing_page_sql) or record_mysql_error($landing_page_sql);
if($mysql['facebook_pixel_assistant_status'] == 1){
$facebook_pixel_assistant_sql = "INSERT INTO `202_bot202_facebook_pixel_assistant`
SET
`landing_page_id` = '".$mysql['landing_page_id']."',
`b202_fbpa_status` = '".$mysql['facebook_pixel_assistant_status']."',
`b202_fbpa_dynamic_epv` = '".$mysql['facebook_pixel_assistant_dynamic_epv']."',
`b202_fbpa_content_name` = '".$mysql['facebook_pixel_assistant_content_name']."',
`b202_fbpa_content_type` = '".$mysql['facebook_pixel_assistant_content_type']."',
`b202_fbpa_outbound_clicks` = '".$mysql['facebook_pixel_assistant_click_out']."'
ON DUPLICATE KEY UPDATE
`b202_fbpa_status` = '".$mysql['facebook_pixel_assistant_status']."',
`b202_fbpa_dynamic_epv` = '".$mysql['facebook_pixel_assistant_dynamic_epv']."',
`b202_fbpa_content_name` = '".$mysql['facebook_pixel_assistant_content_name']."',
`b202_fbpa_content_type` = '".$mysql['facebook_pixel_assistant_content_type']."',
`b202_fbpa_outbound_clicks` = '".$mysql['facebook_pixel_assistant_click_out']."'
";
$facebook_pixel_assistant_result = $db->query($facebook_pixel_assistant_sql) or record_mysql_error($facebook_pixel_assistant_sql);
}
}
}
}
if (isset($_GET['delete_landing_page_id'])) {
if ($userObj->hasPermission("remove_landing_page")) {
$mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']);
$mysql['landing_page_id'] = $db->real_escape_string($_GET['delete_landing_page_id']);
$mysql['landing_page_time'] = time();
$delete_sql = " UPDATE `202_landing_pages`
SET `landing_page_deleted`='1',
`landing_page_time`='".$mysql['landing_page_time']."'
WHERE `user_id`='".$mysql['user_id']."'
AND `landing_page_id`='".$mysql['landing_page_id']."'";
if ($delete_result = $db->query($delete_sql) or record_mysql_error($delete_result)) {
$delete_success = true;
if($slack)
if ($_GET['delete_landing_page_type'] == '0') {
$slack->push('simple_landing_page_deleted', array('name' => $_GET['delete_landing_page_name'], 'user' => $user_row['username']));
} else if ($_GET['delete_landing_page_type'] == '1') {
$slack->push('advanced_landing_page_deleted', array('name' => $_GET['delete_landing_page_name'], 'user' => $user_row['username']));
}
}
} else {
header('location: '.get_absolute_url().'tracking202/setup/landing_pages.php');
}
}
if (($_GET['edit_landing_page_id'] || $_GET['copy_landing_page_id']) and ($_SERVER['REQUEST_METHOD'] != 'POST')) {
$mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']);
if($_GET['edit_landing_page_id']){
$mysql['landing_page_id'] = $db->real_escape_string($_GET['edit_landing_page_id']);
$append= "";
}
else if($_GET['copy_landing_page_id']){
$mysql['landing_page_id'] = $db->real_escape_string($_GET['copy_landing_page_id']);
$append= " (Copy)";
}
$landing_page_sql = "SELECT *
FROM `202_landing_pages`
LEFT JOIN `202_bot202_facebook_pixel_assistant` USING(`landing_page_id`)
WHERE `landing_page_id`='".$mysql['landing_page_id']."'
AND `user_id`='".$mysql['user_id']."'";
$landing_page_result = $db->query($landing_page_sql) or record_mysql_error($landing_page_sql);
$landing_page_row = $landing_page_result->fetch_assoc();
$mysql['aff_campaign_id'] = $db->real_escape_string($landing_page_row['aff_campaign_id']);
$html['aff_campaign_id'] = htmlentities($landing_page_row['aff_campaign_id'], ENT_QUOTES, 'UTF-8');
$html['landing_page_id'] = htmlentities($_GET['edit_landing_page_id'], ENT_QUOTES, 'UTF-8');
$html['landing_page_type'] = htmlentities($landing_page_row['landing_page_type'], ENT_QUOTES, 'UTF-8');
$html['landing_page_nickname'] = htmlentities($landing_page_row['landing_page_nickname'], ENT_QUOTES, 'UTF-8').$append;
$html['landing_page_url'] = htmlentities($landing_page_row['landing_page_url'], ENT_QUOTES, 'UTF-8');
$html['leave_behind_page_url'] = htmlentities($landing_page_row['leave_behind_page_url'], ENT_QUOTES, 'UTF-8');
$html['b202_fbpa_id'] = htmlentities($landing_page_row['b202_fbpa_id'], ENT_QUOTES, 'UTF-8');
$html['b202_fbpa_status'] = htmlentities($landing_page_row['b202_fbpa_status'], ENT_QUOTES, 'UTF-8');
$html['b202_fbpa_dynamic_epv'] = htmlentities($landing_page_row['b202_fbpa_dynamic_epv'], ENT_QUOTES, 'UTF-8');
$html['b202_fbpa_content_name'] = htmlentities($landing_page_row['b202_fbpa_content_name'], ENT_QUOTES, 'UTF-8');
$html['b202_fbpa_content_type'] = htmlentities($landing_page_row['b202_fbpa_content_type'], ENT_QUOTES, 'UTF-8');
$html['b202_fbpa_outbound_clicks'] = htmlentities($landing_page_row['b202_fbpa_outbound_clicks'], ENT_QUOTES, 'UTF-8');
} elseif (($_SERVER['REQUEST_METHOD'] == 'POST') and ($add_success != true)) {
$mysql['aff_campaign_id'] = $db->real_escape_string($_POST['aff_campaign_id']);
$html['aff_network_id'] = htmlentities($_POST['aff_network_id'], ENT_QUOTES, 'UTF-8');
$html['aff_network_id'] = htmlentities($_POST['aff_network_id'], ENT_QUOTES, 'UTF-8');
$html['landing_page_type'] = htmlentities($_POST['landing_page_type'], ENT_QUOTES, 'UTF-8');
$html['landing_page_id'] = htmlentities($_POST['landing_page_id'], ENT_QUOTES, 'UTF-8');
$html['landing_page_nickname'] = htmlentities($_POST['landing_page_nickname'], ENT_QUOTES, 'UTF-8');
$html['landing_page_url'] = htmlentities($_POST['landing_page_url'], ENT_QUOTES, 'UTF-8');
$html['leave_behind_page_url'] = htmlentities($_POST['leave_behind_page_url'], ENT_QUOTES, 'UTF-8');
$html['b202_fbpa_id'] = htmlentities($_POST['facebook_pixel_assistant_id'], ENT_QUOTES, 'UTF-8');
$html['b202_fbpa_status'] = htmlentities($_POST['facebook_pixel_assistant_status'], ENT_QUOTES, 'UTF-8');
$html['b202_fbpa_dynamic_epv'] = htmlentities($_POST['facebook_pixel_assistant_dynamic_epv_status'], ENT_QUOTES, 'UTF-8');
$html['b202_fbpa_content_name'] = htmlentities($_POST['facebook_pixel_assistant_content_name'], ENT_QUOTES, 'UTF-8');
$html['b202_fbpa_content_type'] = htmlentities($_POST['facebook_pixel_assistant_content_type'], ENT_QUOTES, 'UTF-8');
$html['b202_fbpa_outbound_clicks'] = htmlentities($_POST['facebook_pixel_assistant_click_out'], ENT_QUOTES, 'UTF-8');
}
if ((($editing == true) or ($add_success != true)) and ($mysql['aff_campaign_id'])) {
//now grab the Category id, per campaign id
$aff_campaign_sql = "SELECT * FROM `202_aff_campaigns` WHERE `aff_campaign_id`='".$mysql['aff_campaign_id']."'";
$aff_campaign_result = $db->query($aff_campaign_sql) or record_mysql_error($aff_campaign_sql);
$aff_campaign_row = $aff_campaign_result->fetch_assoc();
$mysql['aff_network_id'] = $db->real_escape_string($aff_campaign_row['aff_network_id']);
$aff_network_sql = "SELECT * FROM `202_aff_networks` WHERE `aff_network_id`='".$mysql['aff_network_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['aff_network_id'] = htmlentities($aff_network_row['aff_network_id'], ENT_QUOTES, 'UTF-8');
}
template_top($server_row,'Landing Page Setup',NULL,NULL,NULL); ?>
Landing Page Setup (optional)
pull-right" style="margin-top: 20px;">
Please type in the URL addresses of the landing pages you plan on using.
Add A Landing Page (optional) You can add different landing pages you might use with your marketing here.
My Advanced Landing Pages
real_escape_string($_SESSION['user_id']);
$landing_page_sql = "SELECT * 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";
$landing_page_result = $db->query($landing_page_sql) or record_mysql_error($landing_page_sql);
if ($landing_page_result->num_rows == 0 ) {
?>You have no advanced landing page. fetch_array(MYSQLI_ASSOC)) {
$html['landing_page_nickname'] = htmlentities($landing_page_row['landing_page_nickname'], ENT_QUOTES, 'UTF-8');
$html['landing_page_id'] = htmlentities($landing_page_row['landing_page_id'], ENT_QUOTES, 'UTF-8');
if ($userObj->hasPermission("remove_landing_page")) {
printf('%s - edit - copy - remove %s - edit
My Simple Landing Pages
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 no simple landing page. 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']);
printf('%s ', $html['aff_network_name']);
?>real_escape_string($aff_network_row['aff_network_id']);
$aff_campaign_sql = "SELECT * FROM `202_aff_campaigns` WHERE `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');
printf('%s · $%s ', $html['aff_campaign_name'], $html['aff_campaign_payout']);
?>real_escape_string($aff_campaign_row['aff_campaign_id']);
$landing_page_sql = "SELECT * FROM `202_landing_pages` WHERE `aff_campaign_id`='".$mysql['aff_campaign_id']."' AND `landing_page_deleted`='0' AND landing_page_type='0'";
$landing_page_result = $db->query($landing_page_sql) or record_mysql_error($landing_page_sql);
while ($landing_page_row = $landing_page_result->fetch_array(MYSQLI_ASSOC)) {
$html['landing_page_nickname'] = htmlentities($landing_page_row['landing_page_nickname'], ENT_QUOTES, 'UTF-8');
$html['landing_page_id'] = htmlentities($landing_page_row['landing_page_id'], ENT_QUOTES, 'UTF-8');
if ($userObj->hasPermission("remove_landing_page")) {
printf('%s - edit - copy - remove ', $html['landing_page_nickname'], $html['landing_page_id'], $html['landing_page_id'], $html['landing_page_id'], $html['landing_page_nickname']);
} else {
printf('%s - edit ', $html['landing_page_nickname'], $html['landing_page_id'], $html);
}
}
?>