X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fsurfbar_functions.php;h=0a404409889307001f540de5bdd5c47da6afd272;hb=0cbf3444544a6e3307e8da3af785da677688eba3;hp=e235ce19cbab6d757e6c18abaa248044bef81720;hpb=78dc19b40041f126eede57575484c684d5fd0ddb;p=mailer.git

diff --git a/inc/libs/surfbar_functions.php b/inc/libs/surfbar_functions.php
index e235ce19cb..0a40440988 100644
--- a/inc/libs/surfbar_functions.php
+++ b/inc/libs/surfbar_functions.php
@@ -430,10 +430,10 @@ function SURFBAR_IF_USER_BOOK_MORE_URLS ($uid=0) {
 	global $_CONFIG;
 
 	// Is this admin and userid is zero or does the user has some URLs left to book?
-	return ((($uid == 0) && (IS_ADMIN())) || (SURFBAR_GET_TOTAL_USER_URLS($uid) < $_CONFIG['surfbar_max_order']));
+	return ((($uid == 0) && (IS_ADMIN())) || (SURFBAR_GET_TOTAL_USER_URLS($uid, "", array("REJECTED")) < $_CONFIG['surfbar_max_order']));
 }
 // Get total amount of URLs of given status for current user
-function SURFBAR_GET_TOTAL_USER_URLS ($uid=0, $status="") {
+function SURFBAR_GET_TOTAL_USER_URLS ($uid=0, $status="",$exclude="") {
 	global $_CONFIG;
 
 	// Is the user 0 and user is logged in?
@@ -449,9 +449,19 @@ function SURFBAR_GET_TOTAL_USER_URLS ($uid=0, $status="") {
 	$ADD = "";
 
 	// Is the status set?
-	if (!empty($status)) {
+	if (is_array($status)) {
+		// Only URLs with these status
+		$ADD = sprintf(" AND status IN('%s')", implode("','", $status));
+	} elseif (!empty($status)) {
+		// Only URLs with this status
 		$ADD = sprintf(" AND status='%s'", $status);
-	} // END - if
+	} elseif (is_array($exclude)) {
+		// Exclude URLs with these status
+		$ADD = sprintf(" AND status NOT IN('%s')", implode("','", $exclude));
+	} elseif (!empty($exclude)) {
+		// Exclude URLs with this status
+		$ADD = sprintf(" AND status != '%s'", $exclude);
+	}
 
 	// Get amount from database
 	$result = SQL_QUERY_ESC("SELECT COUNT(id) AS cnt
@@ -911,7 +921,7 @@ function SURFBAR_GET_USER_URLS () {
 	// Begin the query
 	$result = SQL_QUERY_ESC("SELECT u.id, u.url, u.views_total, u.status, UNIX_TIMESTAMP(u.registered) AS registered, UNIX_TIMESTAMP(u.last_locked) AS last_locked, u.lock_reason AS lock_reason
 FROM "._MYSQL_PREFIX."_surfbar_urls AS u
-WHERE u.userid=%s
+WHERE u.userid=%s AND u.status != 'DELETED'
 ORDER BY u.id ASC",
 		array($GLOBALS['userid']), __FILE__, __LINE__);
 
@@ -930,6 +940,51 @@ ORDER BY u.id ASC",
 	// Return the array
 	return $URLs;
 }
+// "Getter" for member action array for given status
+function SURFBAR_GET_ACTION_ARRAY ($status) {
+	// Init array
+	$returnArray = array();
+
+	// Get all assigned actions
+	$result = SQL_QUERY_ESC("SELECT action FROM "._MYSQL_PREFIX."_surfbar_actions WHERE status='%s' ORDER BY id ASC",
+		array($status), __FILE__, __LINE__);
+
+	// Some entries there?
+	if (SQL_NUMROWS($result) > 0) {
+		// Load all actions
+		while (list($action) = SQL_FETCHROW($result)) {
+			$returnArray[] = $action;
+		} // END - if
+	} // END - if
+
+	// Free result
+	SQL_FREERESULT($result);
+
+	// Return result
+	return $returnArray;
+}
+// Create list of actions depending on status for the user
+function SURFBAR_MEMBER_ACTIONS ($id, $status) {
+	// Load all actions in an array for given status
+	$actionArray = SURFBAR_GET_ACTION_ARRAY($status);
+
+	// Init HTML code
+	$OUT = "";
+
+	// "Walk" through all actions and create forms
+	foreach ($actionArray as $action) {
+		// Add form for this action
+		$OUT .= sprintf("<form action=\"".URL."/modules.php?module=login&amp;what=surfbar_list\" method=\"post\" style=\"padding-bottom:0px\">
+<input type=\"submit\" name=\"%s\" value=\"{--MEMBER_SURFBAR_ACTION_%s_SUBMIT--}\" />
+</form>",
+			$action,
+			strtoupper($action)
+		);
+	} // END - if
+
+	// Return code
+	return $OUT;
+}
 // Determine next id for surfbar or get data for given id, always call this before you call other
 // getters below this function!!!
 function SURFBAR_DETERMINE_NEXT_ID ($id = 0) {