query_fetchDB(" SELECT id FROM ot_users WHERE user_realname = '" . stripslashes($_POST['archive_author']) . "' LIMIT 1 "); // Fetch author's ID if((defined("USER_LEVEL_ADMINISTRATOR") OR defined("USER_LEVEL_EDITOR")) OR ($AuthorId['0']['id'] = USER_ID)) { // Set type if(stripslashes($_POST['archive_type']) == "Bericht") // Post? { $_POST['archive_type'] = "post"; } elseif(stripslashes($_POST['archive_type']) == "Pagina") // Page? { $_POST['archive_type'] = "page"; } // Fetch archive from DB if(stripslashes($_POST['archive_status'] != "--- Geen ---")) // Check if message has a status { $Archive = $DB->query_fetchDB(" SELECT id, post_title, post_date, post_status FROM ot_posts WHERE (post_title LIKE '%" . stripslashes($_POST['archive_search']) . "%' OR post_content LIKE '%" . stripslashes($_POST['archive_search']) . "%') AND post_author = '" . $AuthorId['0']['id'] . "' AND post_type = '" . $_POST['archive_type'] . "' AND post_status = '" . stripslashes($_POST['archive_status']) . "' ORDER BY id DESC "); // Search archive } else // No status { $Archive = $DB->query_fetchDB(" SELECT id, post_title, post_date, post_status FROM ot_posts WHERE (post_title LIKE '%" . stripslashes($_POST['archive_search']) . "%' OR post_content LIKE '%" . stripslashes($_POST['archive_search']) . "%') AND post_author = '" . $AuthorId['0']['id'] . "' AND post_type = '" . $_POST['archive_type'] . "' ORDER BY id DESC "); // Search archive } } else { header("Location: archive-list.php?error=true"); // Error } } else { header("Location: archive-list.php?error=true"); // Error } } // Create drop-down box with authors if(defined("USER_LEVEL_ADMINISTRATOR") OR defined("USER_LEVEL_EDITOR")) // Administrator or editor? { $Authors = $DB->query_fetchDB(" SELECT u.id, u.user_realname FROM ot_users AS u INNER JOIN ot_users_level AS l WHERE u.id = l.user_id AND u.user_status = 'active' AND (l.level_key = 'administrator' OR l.level_key = 'editor' OR l.level_key = 'author') "); } $PageTitle = " » Schrijven » Archief"; // Set page title include("admin-header.php"); // Load header ?>
Zoekterm: | Type: | 'Bericht'), array('type' => 'Pagina')), "type", 7, "Bericht"); ?> | Auteur: | USER_REALNAME)), "author", 20, USER_REALNAME); } ?> | Status: | '--- Geen ---'), array('status' => 'Gepubliceerd'), array('status' => 'Klad'), array('status' => 'Privé'), array('status' => 'Toekomst'), array('status' => 'Goedkeuring')), "status", 12, "--- Geen ---"); ?> |
---|
ID | Titel | Datum | Opties | ||
---|---|---|---|---|---|
Geen zoekresultaten.
|