X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_surfbar_urls.php;h=3f739df7892e7af2241facb6c686539d91423073;hp=49d6eb6914e3b2c59ed3f5ff3727b4525c4a4de4;hb=64c8349613addc3da2242c5cd6b99d64e3fb5f8e;hpb=c72c89ffa5f7f5444d7fd47021db520b77738d9e

diff --git a/inc/modules/admin/what-list_surfbar_urls.php b/inc/modules/admin/what-list_surfbar_urls.php
index 49d6eb6914..3f739df789 100644
--- a/inc/modules/admin/what-list_surfbar_urls.php
+++ b/inc/modules/admin/what-list_surfbar_urls.php
@@ -10,9 +10,14 @@
  * -------------------------------------------------------------------- *
  * Kurzbeschreibung  : Alle URLs in Surfbar auflisten und syncen        *
  * -------------------------------------------------------------------- *
- *                                                                      *
+ * $Revision::                                                        $ *
+ * $Date::                                                            $ *
+ * $Tag:: 0.2.1-FINAL                                                 $ *
+ * $Author::                                                          $ *
+ * Needs to be in all Files and every File needs "svn propset           *
+ * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
- * Copyright (c) 2003, 2004, 2005, 2006, 2007 by Roland Haeder          *
+ * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -32,15 +37,148 @@
  ************************************************************************/
 
 // Some security stuff...
-if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!is_admin())) {
-	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
-	require($INC);
-}
+if ((!defined('__SECURITY')) || (!isAdmin())) {
+	die();
+} // END - if
 
 // Add description as navigation point
-ADD_DESCR("admin", basename(__FILE__));
+addMenuDescription('admin', __FILE__);
+
+// By default show the list...
+$show = true;
+
+// Check for 'id' element
+if ((countRequestPost() > 0) && ((!isPostRequestElementSet('id')) || (!is_array(postRequestElement('id'))) || (count(postRequestElement('id')) == 0))) {
+	// Not found so output message
+	loadTemplate('admin_settings_saved', false, getMessage('ADMIN_SURFBAR_NO_SELECTIONS'));
+
+	// Abort here
+	return;
+} // END - if
+
+// Edit or delete button hit?
+if (isPostRequestElementSet('edit')) {
+	// Show entries for editing
+	adminEditEntriesConfirm(
+		postRequestElement('id'),
+		'surfbar_urls',
+		array('id', 'userid', 'url'),
+		array('bigintval', 'addMemberSelectionBox', ''),
+		array('', array(false, true, true), '')
+	);
+	$show = false;
+} elseif (isPostRequestElementSet('do_edit')) {
+	// Change data of entries
+	adminEditEntriesConfirm(
+		postRequestElement('id'),
+		'surfbar_urls',
+		array(),
+		array(),
+		array(),
+		true
+	);
+} elseif (isPostRequestElementSet('delete')) {
+	// Show entries for deletion
+	adminDeleteEntriesConfirm(
+	postRequestElement('id'),
+		'surfbar_urls',
+		array('id', 'userid', 'url', 'registered'),
+		array('bigintval', 'generateUserProfileLink', 'FRAMETESTER', ''),
+		array('', '', '', '')
+	);
+	$show = false;
+} elseif (isPostRequestElementSet('do_delete')) {
+	// Remove entries from database
+	adminDeleteEntriesConfirm(postRequestElement('id'), 'surfbar_urls', array(), array(), array(), true);
+} elseif (isPostRequestElementSet('lock')) {
+	// Un-/lock selected URLs. This does not work for pending URLs
+	adminLockEntriesConfirm(
+		postRequestElement('id'),
+		'surfbar_urls',
+		array('id', 'userid', 'url', 'registered', 'status'),
+		array('bigintval', 'generateUserProfileLink', 'FRAMETESTER', '', 'translateSurfbarUrlStatus'),
+		array('', '', '', '', '')
+	);
+	$show = false;
+} elseif (isPostRequestElementSet('do_lock')) {
+	// Un-/lock selected URLs. This does not work for pending URLs
+	adminLockEntriesConfirm(
+		postRequestElement('id'),
+		'surfbar_urls',
+		array(),
+		array(),
+		array(),
+		array('status' => array('ACTIVE' => 'LOCKED', 'LOCKED' => 'ACTIVE')),
+		true
+	);
+} elseif (isPostRequestElementSet('undelete')) {
+	// Undelete selected URLs. This does only work for deleted URLs... ;-)
+	adminUndeleteEntriesConfirm(
+		postRequestElement('id'),
+		'surfbar_urls',
+		array('id', 'userid', 'url', 'registered', 'status'),
+		array('bigintval', 'generateUserProfileLink', 'FRAMETESTER', '', 'translateSurfbarUrlStatus'),
+		array('', '', '', '', '')
+	);
+	$show = false;
+} elseif (isPostRequestElementSet('do_undelete')) {
+	// Undelete selected URLs. This does only work for deleted URLs... ;-)
+	adminUndeleteEntriesConfirm(
+		postRequestElement('id'),
+		'surfbar_urls',
+		array(),
+		array(),
+		array(),
+		array('status' => array('DELETED' => 'ACTIVE')),
+		true
+	);
+}
+
+// Show entries?
+if ($show === false) return false;
+
+// List all URLs
+$result = SQL_QUERY("SELECT
+	`id`, `userid`, `url`, `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']      = generateUserProfileLink($content['userid']);
+		$content['url']         = generateFrametesterUrl($content['url']);
+		$content['views_total'] = translateComma($content['views_total']);
+		$content['status']      = translateSurfbarUrlStatus($content['status']);
+		$content['registered']  = generateDateTime($content['registered'], 2);
+		$content['last_locked'] = generateDateTime($content['last_locked'], 2);
+		if (empty($content['lock_reason'])) $content['lock_reason'] = '---';
+
+		// Load row template
+		$OUT .= loadTemplate('admin_list_surfbar_urls_row', true, $content);
+
+		// Switch color
+		$SW = 3 - $SW;
+	} // END - while
+
+	// Load main template
+	loadTemplate('admin_list_surfbar_urls', false, $OUT);
+} else {
+	// No URLs in surfbar
+	loadTemplate('admin_settings_saved', false, getMessage('ADMIN_SURFBAR_NO_URLS_FOUND'));
+}
 
-// First list all booked URLs (no bonus!)
+// Free result
+SQL_FREERESULT($result);
 
-//
+// [EOF]
 ?>