ADMIN_MEMBER_SELECTION_BOX() does now return a select-tag with the member list
[mailer.git] / inc / modules / admin / what-list_surfbar_urls.php
index 49d6eb6..37f4366 100644 (file)
@@ -12,7 +12,7 @@
  * -------------------------------------------------------------------- *
  *                                                                      *
  * -------------------------------------------------------------------- *
- * Copyright (c) 2003, 2004, 2005, 2006, 2007 by Roland Haeder          *
+ * Copyright (c) 2003 - 2008 by Roland Haeder                           *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
 if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!is_admin())) {
        $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
        require($INC);
-}
+} // END - if
 
 // Add description as navigation point
 ADD_DESCR("admin", basename(__FILE__));
 
-// First list all booked URLs (no bonus!)
+// By default show the list...
+$show = true;
+
+// Edit or delete button hit?
+if (isset($_POST['edit'])) {
+       // Delete entries (with confirmation)
+       ADMIN_EDIT_ENTRIES_CONFIRM(
+               $_POST['id'],
+               "surfbar_urls",
+               array("id", "userid", "url", "reward", "costs"),
+               array("bigintval", "ADD_MEMBER_SELECTION_BOX", "FRAMETESTER", "TRANSLATE_COMMA", "TRANSLATE_COMMA"),
+               array("", array(false, true), "", "", "")
+       );
+       $show = false;
+} elseif (isset($_POST['do_edit'])) {
+       // Delete entries (with confirmation)
+       ADMIN_EDIT_ENTRIES_CONFIRM($_POST['id'], "surfbar_urls", array(), array(), array(), true);
+} elseif (isset($_POST['delete'])) {
+       // Delete entries (with confirmation)
+       ADMIN_DELETE_ENTRIES_CONFIRM($_POST['id'], "surfbar_urls", array("id", "userid", "url", "registered"), array("bigintval", "ADMIN_USER_PROFILE_LINK", "FRAMETESTER", "MAKE_DATETIME"), array("", "", "", "2"));
+       $show = false;
+} elseif (isset($_POST['remove'])) {
+       // Delete entries (with confirmation)
+       ADMIN_DELETE_ENTRIES_CONFIRM($_POST['id'], "surfbar_urls", array(), array(), array(), true);
+}
+
+// Show entries?
+if (!$show) return false;
+
+// List all URLs
+$result = SQL_QUERY("SELECT id, userid, url, reward, costs, views_total, status, UNIX_TIMESTAMP(registered) AS registered, UNIX_TIMESTAMP(last_locked) AS last_locked, lock_reason
+FROM "._MYSQL_PREFIX."_surfbar_urls
+ORDER BY id ASC", __FILE__, __LINE__);
+
+// Do we have some URLs left?
+if (SQL_NUMROWS($result) > 0) {
+       // List all URLs
+       $OUT = ""; $SW = 2;
+       while ($content = SQL_FETCHARRAY($result)) {
+               // "Translate"/add content
+               $content['sw']          = $SW;
+               $content['userid']      = ADMIN_USER_PROFILE_LINK($content['userid']);
+               $content['url']         = FRAMETESTER($content['url']);
+               $content['reward']      = TRANSLATE_COMMA($content['reward']);
+               $content['costs']       = TRANSLATE_COMMA($content['costs']);
+               $content['views_total'] = TRANSLATE_COMMA($content['views_total']);
+               $content['status']      = SURFBAR_TRANSLATE_STATUS($content['status']);
+               $content['registered']  = MAKE_DATETIME($content['registered'], 2);
+               $content['last_locked'] = MAKE_DATETIME($content['last_locked'], 2);
+               if (empty($content['lock_reason'])) $content['lock_reason'] = "---";
+
+               // Load row template
+               $OUT .= LOAD_TEMPLATE("admin_list_surfbar_urls_row", true, $content);
+
+               // Switch color
+               $SW = 3 - $SW;
+       } // END - while
+
+       // Load main template
+       LOAD_TEMPLATE("admin_list_surfbar_urls", false, $OUT);
+} else {
+       // No URLs in surfbar
+       LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_SURFBAR_NO_URLS_FOUND);
+}
+
+// Free result
+SQL_FREERESULT($result);
 
 //
 ?>