addLocale("housekeeping.campaigns"); $page['name'] = $lang->loc['pagename.campaigns']; $page['category'] = "tools"; require_once('./templates/housekeeping_header.php'); if(isset($_GET['do']) && $_GET['do'] == "save"){ $row = $_POST; $row['image'] = str_replace("%path%",PATH,$row['image']); $row['url'] = str_replace("%path%",PATH,$row['url']); $selected[(int) $row['visible']] = ' checked="true"'; if(empty($row['order'])){ $error = $lang->loc['error.no.order']."
"; } if(!isset($row['visible'])){ $error = $lang->loc['error.no.status']."
"; } if(empty($row['image'])){ $error = $lang->loc['error.no.image']; } if(empty($error)){ if(!empty($row['id'])){ $db->query("UPDATE ".PREFIX."campaigns SET id = '".$input->FilterText($row['order'])."', url = '".$input->FilterText($row['url'])."', image = '".$input->FilterText($row['image'])."', name = '".$input->FilterText($row['name'])."', `desc` = '".nl2br($input->FilterText($row['desc']))."', visible = '".$input->FilterText($row['visible'])."' WHERE id = '".$input->FilterText($row['id'])."' LIMIT 1"); $message = $lang->loc['message.campaign.modified']; }else{ $db->query("INSERT INTO ".PREFIX."campaigns (id,url,image,name,`desc`,visible) VALUES ('".$input->FilterText($row['order'])."','".$input->FilterText($row['url'])."','".$input->FilterText($row['image'])."','".$input->FilterText($row['name'])."','".nl2br($input->FilterText($row['desc']))."','".$input->FilterText($row['visible'])."')"); $message = $lang->loc['message.campaign.created']; } unset($_POST); unset($_GET); }else{ $_GET['do'] = "create"; } }elseif($_GET['do'] == "remove"){ if(isset($_POST['id']) && isset($_POST['remove'])){ $db->query("DELETE FROM ".PREFIX."campaigns WHERE id = '".$input->FilterText($_POST['id'])."' LIMIT 1"); unset($_POST); unset($_GET); $message = $lang->loc['message.campaign.removed']; } } if((isset($_GET['id']) || isset($_POST['id'])) && empty($row)){ $sql = $db->query("SELECT * FROM ".PREFIX."campaigns WHERE id = '".$input->FilterText($_GET['id'])."' LIMIT 1"); $row = $db->fetch_assoc($sql); $selected[(int) $row['visible']] = ' checked="true"'; $row['order'] = $row['id']; }elseif(empty($row)){ $row['order'] = (int) $db->result($db->query("SELECT MAX(id) FROM ".PREFIX."campaigns LIMIT 1")) + 1; $row['visible'] = "1"; $selected[1] = ' checked="true"'; } switch($_GET['do']){ case "create": $lang->addLocale("housekeeping.campaigns.create"); $icon = "campaigns_create.png"; $description = $lang->loc['campaigns.create.desc']; $content = ""; if(!empty($error)){ $content .= '
'.$error.'
'; } $content .= '
'; if(!empty($row['id'])){ $content .= ''; } $content .= '


'.$lang->loc['on'].' '.$lang->loc['off'].'








'; break; case "remove": $lang->addLocale("housekeeping.campaigns.remove"); $icon = "campaigns_remove.png"; $description = $lang->loc['campaigns.remove.desc']; $content = '
'.$lang->loc['confirm.remove'].' "'.$input->HoloText($row['name']).'"?
'; break; default: $lang->addLocale("housekeeping.campaigns.display"); $icon = "campaigns.png"; $description = $lang->loc['campaigns.display.desc']; $content = ""; if(isset($message) && !empty($message)){ $content .= '
'.$message.'
'; } $content .= '
'; $sql = $db->query("SELECT * FROM ".PREFIX."campaigns ORDER BY id ASC"); $i = 0; while($row = $db->fetch_assoc($sql)){ $i++; if($input->IsEven($i)){ $even = ' class="even"'; }else{ $even = ''; } $content .= ' '; $content .= ''; } $content .= '
'.$lang->loc['order'].' '.$lang->loc['name'].' '.$lang->loc['status'].' '.$lang->loc['actions'].'
'.$row['id'].' '.$row['name'].''.$row['visible'].' '.$lang->loc['edit'].''.$lang->loc['remove'].'
'; break; } ?>
loc['pagename.campaigns']; ?> loc['pagename.campaigns']; ?>