hasPermission("access_to_update_section") || !$userObj->hasPermission("delete_individual_subids")) { header('location: '.get_absolute_url().'tracking202/'); die(); } if ($_SERVER['REQUEST_METHOD'] == 'POST') { $mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']); $subids = $_POST['subids']; $subids = trim($subids); $subids = explode("\r",$subids); $subids = str_replace("\n",'',$subids); foreach( $subids as $key => $click_id ) { $mysql['click_id'] = $db->real_escape_string($click_id); $click_sql = " SELECT 2c.click_id FROM 202_clicks AS 2c WHERE 2c.click_id ='". $mysql['click_id']."' AND 2c.user_id='".$mysql['user_id']."' "; $click_result = $db->query($click_sql) or record_mysql_error($click_sql); $click_row = $click_result->fetch_assoc(); $mysql['click_id'] = $db->real_escape_string($click_row['click_id']); $update_sql = " UPDATE 202_clicks SET click_lead='0', `click_filtered`='0' WHERE click_id='" . $mysql['click_id'] ."' AND user_id='".$mysql['user_id']."' "; $update_result = $db->query($update_sql) or die(mysql_error($update_sql)); $click_sql = " UPDATE 202_conversion_logs SET deleted=1 WHERE click_id='" . $mysql['click_id'] ."'"; $click_result = $db->query($click_sql); $de = new DataEngine(); $de->setDirtyHour($mysql['click_id']); } $success = true; } //show the template template_top('Delete Subids',NULL,NULL,NULL); ?>
Delete Individual Subids
Your submission was successful. Your account income now reflects the subids just deleted.
Ok, just like the upload subids but in reverse, upload the subids you want to delete instead!