Files
Testing/bwadmin/admin_ads.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

135 lines
3.7 KiB
PHP

<?php
/* $Id: admin_ads.php 8 2009-01-11 06:02:53Z john $ */
$page = "admin_ads";
include "admin_header.php";
if(isset($_POST['task'])) { $task = $_POST['task']; } elseif(isset($_GET['task'])) { $task = $_GET['task']; } else { $task = "main"; }
if(isset($_POST['ad_id'])) { $ad_id = $_POST['ad_id']; } elseif(isset($_GET['ad_id'])) { $ad_id = $_GET['ad_id']; } else { $ad_id = 0; }
if(isset($_POST['s'])) { $s = $_POST['s']; } elseif(isset($_GET['s'])) { $s = $_GET['s']; } else { $s = "id"; }
// PAUSE AN AD CAMPAIGN
if($task == "pause") {
// CHECK IF AD CAMPAIGN EXISTS AND PAUSE
$ad_query = $database->database_query("SELECT ad_id FROM se_ads WHERE ad_id='$ad_id' LIMIT 1");
if($database->database_num_rows($ad_query) == 1) {
$database->database_query("UPDATE se_ads SET ad_paused='1' WHERE ad_id='$ad_id' LIMIT 1");
}
// UNPAUSE AN AD CAMPAIGN
} elseif($task == "unpause") {
// CHECK IF AD CAMPAIGN EXISTS AND UNPAUSE
$ad_query = $database->database_query("SELECT ad_id FROM se_ads WHERE ad_id='$ad_id' LIMIT 1");
if($database->database_num_rows($ad_query) == 1) {
$database->database_query("UPDATE se_ads SET ad_paused='0' WHERE ad_id='$ad_id' LIMIT 1");
}
// DELETE A SINGLE AD CAMPAIGN
} elseif($task == "delete") {
$ad_query = $database->database_query("SELECT ad_id, ad_filename FROM se_ads WHERE ad_id='$ad_id' LIMIT 1");
if($database->database_num_rows($ad_query) == 1) {
$database->database_query("DELETE FROM se_ads WHERE ad_id='$ad_id' LIMIT 1");
$ad_info = $database->database_fetch_assoc($ad_query);
$bannerfile = "../uploads_admin/ads/$ad_info[ad_filename]";
if(@file_exists($bannerfile)) {
@unlink($bannerfile);
}
}
}
// SET AD CAMPIGN SORT-BY VARIABLES FOR HEADING LINKS
$i = "id"; // AD_ID
$n = "n"; // AD_NAME
$v = "vd"; // NUMBER OF VIEWS
$c = "cd"; // NUMBER OF CLICKS
// SET SORT VARIABLE FOR DATABASE QUERY
if($s == "i") {
$sort = "ad_id";
$i = "id";
} elseif($s == "id") {
$sort = "ad_id DESC";
$i = "i";
} elseif($s == "n") {
$sort = "ad_name";
$n = "nd";
} elseif($s == "nd") {
$sort = "ad_name DESC";
$n = "n";
} elseif($s == "v") {
$sort = "ad_total_views";
$v = "vd";
} elseif($s == "vd") {
$sort = "ad_total_views DESC";
$v = "v";
} elseif($s == "c") {
$sort = "ad_total_clicks";
$c = "cd";
} elseif($s == "cd") {
$sort = "ad_total_clicks DESC";
$c = "c";
} else {
$sort = "ad_id DESC";
$i = "i";
}
// GET ADS FOR MAIN LIST
$ads = $database->database_query("SELECT * FROM se_ads ORDER BY $sort");
$ad_array = Array();
while($ad_info = $database->database_fetch_assoc($ads)) {
// DETERMINE CTR
if($ad_info[ad_total_clicks] == 0) {
$ad_info[ad_ctr] = "0.00%";
} elseif($ad_info[ad_total_clicks] > 0) {
$ad_info[ad_ctr] = round($ad_info[ad_total_clicks] / $ad_info[ad_total_views], 4) * 100;
if(strlen($ad_info[ad_ctr]) == 1 || strlen($ad_info[ad_ctr]) == 2) {
$ad_info[ad_ctr] .= ".00";
}
$ad_info[ad_ctr] .= "%";
}
$ad_array[] = Array('ad_id' => $ad_info[ad_id],
'ad_name' => $ad_info[ad_name],
'ad_status' => $ad_status,
'ad_paused' => $ad_info[ad_paused],
'ad_total_views' => $ad_info[ad_total_views],
'ad_total_clicks' => $ad_info[ad_total_clicks],
'ad_ctr' => $ad_info[ad_ctr],
'ad_date_start' => $ad_info[ad_date_start],
'ad_date_end' => $ad_info[ad_date_end]);
}
// ASSIGN VARIABLES AND SHOW ADMIN ADS PAGE
$smarty->assign('s', $s);
$smarty->assign('i', $i);
$smarty->assign('n', $n);
$smarty->assign('v', $v);
$smarty->assign('c', $c);
$smarty->assign('ads', $ad_array);
$smarty->assign('nowdate', time());
include "admin_footer.php";
?>