function gwolle_gb_adminmenu()
{
/*
* How to add new menu-entries:
* add_menu_page( $page_title, $menu_title, $access_level, $file, $function = '', $icon_url = '' )
*/
// Counter
$count_unchecked = gwolle_gb_get_entry_count(array('checked' => 'unchecked', 'trash' => 'notrash', 'spam' => 'nospam'));
// Main navigation entry
// Admin page: admin/welcome.php
add_menu_page(__('Guestbook', GWOLLE_GB_TEXTDOMAIN), __('Guestbook', GWOLLE_GB_TEXTDOMAIN) . "<span class='update-plugins count-" . $count_unchecked . "'><span class='theme-count'>" . $count_unchecked . "</span></span>", 'moderate_comments', GWOLLE_GB_FOLDER . '/gwolle-gb.php', 'gwolle_gb_welcome', 'dashicons-admin-comments');
// Admin page: admin/entries.php
add_submenu_page(GWOLLE_GB_FOLDER . '/gwolle-gb.php', __('Entries', GWOLLE_GB_TEXTDOMAIN), __('Entries', GWOLLE_GB_TEXTDOMAIN) . "<span class='update-plugins count-" . $count_unchecked . "'><span class='theme-count'>" . $count_unchecked . "</span></span>", 'moderate_comments', GWOLLE_GB_FOLDER . '/entries.php', 'gwolle_gb_page_entries');
// Admin page: admin/editor.php
add_submenu_page(GWOLLE_GB_FOLDER . '/gwolle-gb.php', __('Entry editor', GWOLLE_GB_TEXTDOMAIN), __('New entry', GWOLLE_GB_TEXTDOMAIN), 'moderate_comments', GWOLLE_GB_FOLDER . '/editor.php', 'gwolle_gb_page_editor');
// Admin page: admin/settings.php
add_submenu_page(GWOLLE_GB_FOLDER . '/gwolle-gb.php', __('Settings', GWOLLE_GB_TEXTDOMAIN), __('Settings', GWOLLE_GB_TEXTDOMAIN), 'manage_options', GWOLLE_GB_FOLDER . '/settings.php', 'gwolle_gb_page_settings');
// Admin page: admin/import.php
add_submenu_page(GWOLLE_GB_FOLDER . '/gwolle-gb.php', __('Import', GWOLLE_GB_TEXTDOMAIN), __('Import', GWOLLE_GB_TEXTDOMAIN), 'manage_options', GWOLLE_GB_FOLDER . '/import.php', 'gwolle_gb_page_import');
// Admin page: admin/export.php
add_submenu_page(GWOLLE_GB_FOLDER . '/gwolle-gb.php', __('Export', GWOLLE_GB_TEXTDOMAIN), __('Export', GWOLLE_GB_TEXTDOMAIN), 'manage_options', GWOLLE_GB_FOLDER . '/export.php', 'gwolle_gb_page_export');
// Load Admin CSS
wp_enqueue_style('gwolle-gb-css', WP_PLUGIN_URL . '/' . GWOLLE_GB_FOLDER . '/admin/style.css', false, GWOLLE_GB_VER, 'all');
// Load JavaScript for Admin
wp_enqueue_script('gwolle-gb-entries', WP_PLUGIN_URL . '/' . GWOLLE_GB_FOLDER . '/admin/js/admin.js', 'jquery', GWOLLE_GB_VER, true);
}
function gwolle_gb_page_export()
{
if (function_exists('current_user_can') && !current_user_can('manage_options')) {
die(__('Cheatin’ uh?', GWOLLE_GB_TEXTDOMAIN));
}
/*
* Build the Page and the Form
*/
?>
<div class="wrap gwolle_gb">
<div id="icon-gwolle-gb"><br /></div>
<h1><?php
_e('Export guestbook entries.', GWOLLE_GB_TEXTDOMAIN);
?>
</h1>
<form name="gwolle_gb_export" id="gwolle_gb_export" method="POST" action="#" accept-charset="UTF-8">
<input type="hidden" name="gwolle_gb_page" value="gwolle_gb_export" />
<div id="poststuff" class="metabox-holder">
<div id="post-body">
<div id="post-body-content">
<div id='normal-sortables' class='meta-box-sortables'>
<div id="gwolle_gb_export_postbox" class="postbox">
<div class="handlediv"></div>
<h3 class='hndle' title="<?php
esc_attr_e('Click to open or close', GWOLLE_GB_TEXTDOMAIN);
?>
"><?php
_e('Export guestbook entries from Gwolle-GB', GWOLLE_GB_TEXTDOMAIN);
?>
</h3>
<div class="inside">
<div>
<?php
$count = gwolle_gb_get_entry_count(array('all' => 'all'));
if ($count == 0) {
?>
<p>
<?php
_e("No entries were found.", GWOLLE_GB_TEXTDOMAIN);
?>
</p><?php
} else {
?>
<p>
<?php
echo sprintf(__("%d entries were found and will be exported.", GWOLLE_GB_TEXTDOMAIN), $count);
?>
</p>
<p>
<?php
_e('The exporter will preserve the following data per entry:', GWOLLE_GB_TEXTDOMAIN);
?>
</p>
<ul class="ul-disc">
<li><?php
_e('Name', GWOLLE_GB_TEXTDOMAIN);
?>
</li>
<li><?php
_e('E-Mail address', GWOLLE_GB_TEXTDOMAIN);
?>
</li>
<li><?php
_e('URL/Website', GWOLLE_GB_TEXTDOMAIN);
?>
</li>
<li><?php
_e('Origin', GWOLLE_GB_TEXTDOMAIN);
?>
</li>
<li><?php
_e('Date of the entry', GWOLLE_GB_TEXTDOMAIN);
?>
</li>
<li><?php
_e('IP address', GWOLLE_GB_TEXTDOMAIN);
?>
</li>
<li><?php
_e('Host address', GWOLLE_GB_TEXTDOMAIN);
?>
</li>
<li><?php
_e('Message', GWOLLE_GB_TEXTDOMAIN);
?>
</li>
<li><?php
_e('"is checked" flag', GWOLLE_GB_TEXTDOMAIN);
?>
</li>
<li><?php
_e('"is spam" flag', GWOLLE_GB_TEXTDOMAIN);
?>
</li>
<li><?php
_e('"is trash" flag', GWOLLE_GB_TEXTDOMAIN);
?>
</li>
</ul>
<?php
_e('The exporter does not delete any data, so your data will still be here.', GWOLLE_GB_TEXTDOMAIN);
?>
<p>
<label for="start_export_enable" class="selectit">
<input id="start_export_enable" name="start_export_enable" type="checkbox" />
<?php
_e('Export all entries from this website.', GWOLLE_GB_TEXTDOMAIN);
?>
</label>
</p>
<p>
<input name="gwolle_gb_start_export" id="gwolle_gb_start_export" type="submit" class="button" disabled value="<?php
esc_attr_e('Start export', GWOLLE_GB_TEXTDOMAIN);
?>
">
</p>
<?php
}
?>
</div>
</div>
</div>
</div><!-- 'normal-sortables' -->
</div><!-- 'post-body-content' -->
</div>
</div>
</div>
</form>
</div>
<?php
}
function gwolle_gb_admin_bar_menu($wp_admin_bar)
{
if (!current_user_can('moderate_comments')) {
return;
}
// Counter
$count_unchecked = gwolle_gb_get_entry_count(array('checked' => 'unchecked', 'trash' => 'notrash', 'spam' => 'nospam'));
if ($count_unchecked == 1) {
$awaiting_title = esc_attr(sprintf(__('%s guestbook entry awaiting moderation', 'gwolle-gb'), number_format_i18n($count_unchecked)));
} else {
if ($count_unchecked > 1) {
$awaiting_title = esc_attr(sprintf(__('%s guestbook entries awaiting moderation', 'gwolle-gb'), number_format_i18n($count_unchecked)));
}
}
if ($count_unchecked > 0) {
$icon = '<span class="ab-icon"></span>';
$title = '<span id="ab-unchecked-entries" class="ab-label awaiting-mod pending-count count-' . $count_unchecked . '">' . number_format_i18n($count_unchecked) . '</span>';
$wp_admin_bar->add_menu(array('id' => 'gwolle-gb', 'title' => $icon . $title, 'href' => admin_url('admin.php?page=' . GWOLLE_GB_FOLDER . '/entries.php&show=unchecked'), 'meta' => array('title' => $awaiting_title)));
}
}
function gwolle_gb_page_entries()
{
if (function_exists('current_user_can') && !current_user_can('moderate_comments')) {
die(__('Cheatin’ uh?', GWOLLE_GB_TEXTDOMAIN));
}
if (!get_option('gwolle_gb_version')) {
// FIXME: do this on activation
gwolle_gb_installSplash();
} else {
$gwolle_gb_errors = '';
$gwolle_gb_messages = '';
if (isset($_POST['gwolle_gb_page']) && $_POST['gwolle_gb_page'] == 'entries') {
$action = '';
if (isset($_POST['massEditAction1']) && $_POST['massEditAction1'] == 'check' || isset($_POST['massEditAction2']) && $_POST['massEditAction2'] == 'check') {
$action = 'check';
} else {
if (isset($_POST['massEditAction1']) && $_POST['massEditAction1'] == 'uncheck' || isset($_POST['massEditAction2']) && $_POST['massEditAction2'] == 'uncheck') {
$action = 'uncheck';
} else {
if (isset($_POST['massEditAction1']) && $_POST['massEditAction1'] == 'spam' || isset($_POST['massEditAction2']) && $_POST['massEditAction2'] == 'spam') {
$action = 'spam';
} else {
if (isset($_POST['massEditAction1']) && $_POST['massEditAction1'] == 'no-spam' || isset($_POST['massEditAction2']) && $_POST['massEditAction2'] == 'no-spam') {
$action = 'no-spam';
} else {
if (isset($_POST['massEditAction1']) && $_POST['massEditAction1'] == 'akismet' || isset($_POST['massEditAction2']) && $_POST['massEditAction2'] == 'akismet') {
$action = 'akismet';
} else {
if (isset($_POST['massEditAction1']) && $_POST['massEditAction1'] == 'trash' || isset($_POST['massEditAction2']) && $_POST['massEditAction2'] == 'trash') {
$action = 'trash';
} else {
if (isset($_POST['massEditAction1']) && $_POST['massEditAction1'] == 'untrash' || isset($_POST['massEditAction2']) && $_POST['massEditAction2'] == 'untrash') {
$action = 'untrash';
} else {
if (isset($_POST['massEditAction1']) && $_POST['massEditAction1'] == 'remove' || isset($_POST['massEditAction2']) && $_POST['massEditAction2'] == 'remove') {
$action = 'remove';
}
}
}
}
}
}
}
}
if ($action != '') {
// Initialize variables to generate messages with
$entries_handled = 0;
$entries_not_handled = 0;
$akismet_spam = 0;
$akismet_not_spam = 0;
$akismet_already_spam = 0;
$akismet_already_not_spam = 0;
/* Handle the $_POST entries */
foreach (array_keys($_POST) as $postElementName) {
if (strpos($postElementName, 'check') > -1 && !strpos($postElementName, '-all-') && $_POST[$postElementName] == 'on') {
$entry_id = str_replace('check-', '', $postElementName);
$entry_id = intval($entry_id);
if (isset($entry_id) && $entry_id > 0) {
$entry = new gwolle_gb_entry();
$result = $entry->load($entry_id);
if ($result) {
if ($action == 'check') {
if ($entry->get_ischecked() == 0) {
$entry->set_ischecked(true);
$user_id = get_current_user_id();
// returns 0 if no current user
$entry->set_checkedby($user_id);
gwolle_gb_add_log_entry($entry->get_id(), 'entry-checked');
$result = $entry->save();
if ($result) {
$entries_handled++;
} else {
$entries_not_handled++;
}
} else {
$entries_not_handled++;
}
} else {
if ($action == 'uncheck') {
if ($entry->get_ischecked() == 1) {
$entry->set_ischecked(false);
$user_id = get_current_user_id();
// returns 0 if no current user
$entry->set_checkedby($user_id);
gwolle_gb_add_log_entry($entry->get_id(), 'entry-unchecked');
$result = $entry->save();
if ($result) {
$entries_handled++;
} else {
$entries_not_handled++;
}
} else {
$entries_not_handled++;
}
} else {
if ($action == 'spam') {
if ($entry->get_isspam() == 0) {
$entry->set_isspam(true);
if (get_option('gwolle_gb-akismet-active', 'false') == 'true') {
gwolle_gb_akismet($entry, 'submit-spam');
}
gwolle_gb_add_log_entry($entry->get_id(), 'marked-as-spam');
$result = $entry->save();
if ($result) {
$entries_handled++;
} else {
$entries_not_handled++;
}
} else {
$entries_not_handled++;
}
} else {
if ($action == 'no-spam') {
if ($entry->get_isspam() == 1) {
$entry->set_isspam(false);
if (get_option('gwolle_gb-akismet-active', 'false') == 'true') {
gwolle_gb_akismet($entry, 'submit-ham');
}
gwolle_gb_add_log_entry($entry->get_id(), 'marked-as-not-spam');
$result = $entry->save();
if ($result) {
$entries_handled++;
} else {
$entries_not_handled++;
}
} else {
$entries_not_handled++;
}
} else {
if ($action == 'akismet') {
/* Check for spam and set accordingly */
if (get_option('gwolle_gb-akismet-active', 'false') == 'true') {
$isspam = gwolle_gb_akismet($entry, 'comment-check');
if ($isspam) {
// Returned true, so considered spam
if ($entry->get_isspam() == 0) {
$entry->set_isspam(true);
gwolle_gb_add_log_entry($entry->get_id(), 'marked-as-spam');
$result = $entry->save();
if ($result) {
$akismet_spam++;
} else {
$akismet_not_spam++;
}
} else {
$akismet_already_spam++;
}
} else {
if ($entry->get_isspam() == 1) {
$entry->set_isspam(false);
gwolle_gb_add_log_entry($entry->get_id(), 'marked-as-not-spam');
$result = $entry->save();
if ($result) {
$akismet_not_spam++;
} else {
$akismet_spam++;
}
} else {
$akismet_already_not_spam++;
}
}
}
} else {
if ($action == 'trash') {
if ($entry->get_istrash() == 0) {
$entry->set_istrash(true);
gwolle_gb_add_log_entry($entry->get_id(), 'entry-trashed');
$result = $entry->save();
if ($result) {
$entries_handled++;
} else {
$entries_not_handled++;
}
} else {
$entries_not_handled++;
}
} else {
if ($action == 'untrash') {
if ($entry->get_istrash() == 1) {
$entry->set_istrash(false);
gwolle_gb_add_log_entry($entry->get_id(), 'entry-untrashed');
$result = $entry->save();
if ($result) {
$entries_handled++;
} else {
$entries_not_handled++;
}
} else {
$entries_not_handled++;
}
} else {
if ($action == 'remove') {
$result = $entry->delete();
if ($result) {
$entries_handled++;
} else {
$entries_not_handled++;
}
}
}
}
}
}
}
}
}
} else {
// no result on load()
$entries_not_handled++;
}
} else {
// entry_id is not set or not > 0
$entries_not_handled++;
}
}
// no entry with the check-'entry_id' input, continue
}
// foreach
/* Construct Message */
if ($action == 'check') {
if ($entries_handled == 1) {
$gwolle_gb_messages .= '<p>' . $entries_handled . " " . __('entry checked.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
if ($entries_handled > 1) {
$gwolle_gb_messages .= '<p>' . $entries_handled . " " . __('entries checked.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
$gwolle_gb_messages .= '<p>' . __('No entries checked.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
}
}
} else {
if ($action == 'uncheck') {
if ($entries_handled == 1) {
$gwolle_gb_messages .= '<p>' . $entries_handled . " " . __('entry unchecked.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
if ($entries_handled > 1) {
$gwolle_gb_messages .= '<p>' . $entries_handled . " " . __('entries unchecked.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
$gwolle_gb_messages .= '<p>' . __('No entries unchecked.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
}
}
} else {
if ($action == 'spam') {
if ($entries_handled == 1) {
$gwolle_gb_messages .= '<p>' . $entries_handled . " " . __('entry marked as spam and submitted to Akismet as spam (if Akismet was enabled).', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
if ($entries_handled > 1) {
$gwolle_gb_messages .= '<p>' . $entries_handled . " " . __('entries marked as spam and submitted to Akismet as spam (if Akismet was enabled).', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
$gwolle_gb_messages .= '<p>' . __('No entries marked as spam.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
}
}
} else {
if ($action == 'no-spam') {
if ($entries_handled == 1) {
$gwolle_gb_messages .= '<p>' . $entries_handled . " " . __('entry marked as not spam and submitted to Akismet as ham (if Akismet was enabled).', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
if ($entries_handled > 1) {
$gwolle_gb_messages .= '<p>' . $entries_handled . " " . __('entries marked as not spam and submitted to Akismet as ham (if Akismet was enabled).', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
$gwolle_gb_messages .= '<p>' . __('No entries marked as not spam.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
}
}
} else {
if ($action == 'akismet') {
if ($akismet_spam == 1) {
$gwolle_gb_messages .= '<p>' . $akismet_spam . " " . __('entry considered spam and marked as such.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
if ($akismet_spam > 1) {
$gwolle_gb_messages .= '<p>' . $akismet_spam . " " . __('entries considered spam and marked as such.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
}
}
if ($akismet_not_spam == 1) {
$gwolle_gb_messages .= '<p>' . $akismet_not_spam . " " . __('entry not considered spam and marked as such.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
if ($akismet_not_spam > 1) {
$gwolle_gb_messages .= '<p>' . $akismet_not_spam . " " . __('entries not considered spam and marked as such.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
}
}
if ($akismet_already_spam == 1) {
$gwolle_gb_messages .= '<p>' . $akismet_already_spam . " " . __('entry already considered spam and not changed.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
if ($akismet_already_spam > 1) {
$gwolle_gb_messages .= '<p>' . $akismet_already_spam . " " . __('entries already considered spam and not changed.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
}
}
if ($akismet_already_not_spam == 1) {
$gwolle_gb_messages .= '<p>' . $akismet_already_not_spam . " " . __('entry already considered not spam and not changed.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
if ($akismet_already_not_spam > 1) {
$gwolle_gb_messages .= '<p>' . $akismet_already_not_spam . " " . __('entries already considered not spam and not changed.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
}
}
} else {
if ($action == 'trash') {
if ($entries_handled == 1) {
$gwolle_gb_messages .= '<p>' . $entries_handled . " " . __('entry moved to trash.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
if ($entries_handled > 1) {
$gwolle_gb_messages .= '<p>' . $entries_handled . " " . __('entries moved to trash.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
$gwolle_gb_messages .= '<p>' . __('No entries moved to trash.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
}
}
} else {
if ($action == 'untrash') {
if ($entries_handled == 1) {
$gwolle_gb_messages .= '<p>' . $entries_handled . " " . __('entry recovered from trash.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
if ($entries_handled > 1) {
$gwolle_gb_messages .= '<p>' . $entries_handled . " " . __('entries recovered from trash.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
$gwolle_gb_messages .= '<p>' . __('No entries recovered from trash.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
}
}
} else {
if ($action == 'remove') {
if ($entries_handled == 1) {
$gwolle_gb_messages .= '<p>' . $entries_handled . " " . __('entry removed permanently.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
if ($entries_handled > 1) {
$gwolle_gb_messages .= '<p>' . $entries_handled . " " . __('entries removed permanently.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
$gwolle_gb_messages .= '<p>' . __('No entries permanently removed.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
}
}
}
}
}
}
}
}
}
}
}
if (isset($_POST['delete_all']) || isset($_POST['delete_all2'])) {
// Delete all entries in spam or trash
if (isset($_POST['show']) && in_array($_POST['show'], array('spam', 'trash'))) {
$delstatus = $_POST['show'];
$deleted = gwolle_gb_del_entries($delstatus);
if ($deleted == 1) {
$gwolle_gb_messages .= '<p>' . $deleted . " " . __('entry removed permanently.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
if ($deleted > 1) {
$gwolle_gb_messages .= '<p>' . $deleted . " " . __('entries removed permanently.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
} else {
$gwolle_gb_messages .= '<p>' . __('No entries permanently removed.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
}
}
}
}
}
// Get entry counts
$count = array();
$count['checked'] = gwolle_gb_get_entry_count(array('checked' => 'checked', 'trash' => 'notrash', 'spam' => 'nospam'));
$count['unchecked'] = gwolle_gb_get_entry_count(array('checked' => 'unchecked', 'trash' => 'notrash', 'spam' => 'nospam'));
$count['spam'] = gwolle_gb_get_entry_count(array('spam' => 'spam'));
$count['trash'] = gwolle_gb_get_entry_count(array('trash' => 'trash'));
$count['all'] = gwolle_gb_get_entry_count(array('all' => 'all'));
$show = isset($_REQUEST['show']) && in_array($_REQUEST['show'], array('checked', 'unchecked', 'spam', 'trash')) ? $_REQUEST['show'] : 'all';
$entries_per_page = get_option('gwolle_gb-entries_per_page', 20);
// If Akimet has not been activated yet and the user is looking at the spam tell him to activate Akismet.
if ($show == 'spam' && get_option('gwolle_gb-akismet-active', 'false') != 'true') {
$gwolle_gb_messages .= '<p>' . __('Please activate Akismet if you want to battle spam.', GWOLLE_GB_TEXTDOMAIN) . '</p>';
}
// Check if the requested page number is an integer > 0
$pageNum = isset($_REQUEST['pageNum']) && $_REQUEST['pageNum'] && (int) $_REQUEST['pageNum'] > 0 ? (int) $_REQUEST['pageNum'] : 1;
// Pagination: Calculate the number of pages.
$countPages = ceil($count[$show] / $entries_per_page);
if ($pageNum > $countPages) {
$pageNum = 1;
// page doesnot exist, return to first page
}
// Calculate Query
if ($pageNum == 1 && $count[$show] > 0) {
$mysqlFirstRow = 0;
} elseif ($count[$show] == 0) {
$mysqlFirstRow = 0;
} else {
$firstEntryNum = ($pageNum - 1) * $entries_per_page + 1;
$mysqlFirstRow = $firstEntryNum - 1;
}
// Get the entries
if ($show == 'checked') {
$entries = gwolle_gb_get_entries(array('num_entries' => $entries_per_page, 'offset' => $mysqlFirstRow, 'checked' => 'checked', 'trash' => 'notrash', 'spam' => 'nospam'));
} else {
if ($show == 'unchecked') {
$entries = gwolle_gb_get_entries(array('num_entries' => $entries_per_page, 'offset' => $mysqlFirstRow, 'checked' => 'unchecked', 'trash' => 'notrash', 'spam' => 'nospam'));
} else {
if ($show == 'spam') {
$entries = gwolle_gb_get_entries(array('num_entries' => $entries_per_page, 'offset' => $mysqlFirstRow, 'spam' => 'spam'));
} else {
if ($show == 'trash') {
$entries = gwolle_gb_get_entries(array('num_entries' => $entries_per_page, 'offset' => $mysqlFirstRow, 'trash' => 'trash'));
} else {
$entries = gwolle_gb_get_entries(array('num_entries' => $entries_per_page, 'offset' => $mysqlFirstRow, 'all' => 'all'));
}
}
}
}
?>
<div class="wrap gwolle_gb">
<div id="icon-gwolle-gb"><br /></div>
<h1><?php
_e('Guestbook entries', GWOLLE_GB_TEXTDOMAIN);
?>
</h1>
<?php
if ($gwolle_gb_messages) {
echo '
<div id="message" class="updated fade notice is-dismissible ' . $gwolle_gb_errors . ' ">' . $gwolle_gb_messages . '</div>';
}
// FIXME: add a searchform someday?
?>
<form name="gwolle_gb_entries" id="gwolle_gb_entries" action="" method="POST" accept-charset="UTF-8">
<input type="hidden" name="gwolle_gb_page" value="entries" />
<!-- the following fields give us some information we're going to use processing the mass edit -->
<input type="hidden" name="pageNum" value="<?php
echo $pageNum;
?>
">
<input type="hidden" name="entriesOnThisPage" value="<?php
echo count($entries);
?>
">
<input type="hidden" name="show" value="<?php
echo $show;
?>
">
<ul class="subsubsub">
<li><a href='admin.php?page=<?php
echo GWOLLE_GB_FOLDER;
?>
/entries.php' <?php
if ($show == 'all') {
echo 'class="current"';
}
?>
>
<?php
_e('All', GWOLLE_GB_TEXTDOMAIN);
?>
<span class="count">(<?php
echo $count['all'];
?>
)</span></a> |
</li>
<li><a href='admin.php?page=<?php
echo GWOLLE_GB_FOLDER;
?>
/entries.php&show=checked' <?php
if ($show == 'checked') {
echo 'class="current"';
}
?>
>
<?php
_e('Unlocked', GWOLLE_GB_TEXTDOMAIN);
?>
<span class="count">(<?php
echo $count['checked'];
?>
)</span></a> |
</li>
<li><a href='admin.php?page=<?php
echo GWOLLE_GB_FOLDER;
?>
/entries.php&show=unchecked' <?php
if ($show == 'unchecked') {
echo 'class="current"';
}
?>
><?php
_e('New', GWOLLE_GB_TEXTDOMAIN);
?>
<span class="count">(<?php
echo $count['unchecked'];
?>
)</span></a> |
</li>
<li><a href='admin.php?page=<?php
echo GWOLLE_GB_FOLDER;
?>
/entries.php&show=spam' <?php
if ($show == 'spam') {
echo 'class="current"';
}
?>
><?php
_e('Spam', GWOLLE_GB_TEXTDOMAIN);
?>
<span class="count">(<?php
echo $count['spam'];
?>
)</span></a> |
</li>
<li><a href='admin.php?page=<?php
echo GWOLLE_GB_FOLDER;
?>
/entries.php&show=trash' <?php
if ($show == 'trash') {
echo 'class="current"';
}
?>
><?php
_e('Trash', GWOLLE_GB_TEXTDOMAIN);
?>
<span class="count">(<?php
echo $count['trash'];
?>
)</span></a>
</li>
</ul>
<div class="tablenav">
<div class="alignleft actions">
<?php
$massEditControls_select = '<select name="massEditAction1">';
$massEditControls = '<option value="-1" selected="selected">' . __('Mass edit actions', GWOLLE_GB_TEXTDOMAIN) . '</option>';
if ($show == 'trash') {
$massEditControls .= '
<option value="untrash">' . __('Recover from trash', GWOLLE_GB_TEXTDOMAIN) . '</option>
<option value="remove">' . __('Remove permanently', GWOLLE_GB_TEXTDOMAIN) . '</option>';
} else {
if ($show != 'checked') {
$massEditControls .= '<option value="check">' . __('Mark as checked', GWOLLE_GB_TEXTDOMAIN) . '</option>';
}
if ($show != 'unchecked') {
$massEditControls .= '<option value="uncheck">' . __('Mark as not checked', GWOLLE_GB_TEXTDOMAIN) . '</option>';
}
if ($show != 'spam') {
$massEditControls .= '<option value="spam">' . __('Mark as spam', GWOLLE_GB_TEXTDOMAIN) . '</option>';
}
$massEditControls .= '<option value="no-spam">' . __('Mark as not spam', GWOLLE_GB_TEXTDOMAIN) . '</option>';
if (get_option('gwolle_gb-akismet-active', 'false') == 'true') {
$massEditControls .= '<option value="akismet">' . __('Check with Akismet', GWOLLE_GB_TEXTDOMAIN) . '</option>';
}
$massEditControls .= '<option value="trash">' . __('Move to trash', GWOLLE_GB_TEXTDOMAIN) . '</option>';
if ($show == 'spam') {
$massEditControls .= '<option value="remove">' . __('Remove permanently', GWOLLE_GB_TEXTDOMAIN) . '</option>';
}
}
$massEditControls .= '</select>';
$massEditControls .= '<input type="submit" value="' . esc_attr__('Apply', GWOLLE_GB_TEXTDOMAIN) . '" name="doaction" id="doaction" class="button-secondary action" />';
$empty_button = '';
if ($show == 'spam') {
$empty_button = '<input type="submit" name="delete_all" id="delete_all" class="button apply" value="' . esc_attr__('Empty Spam', GWOLLE_GB_TEXTDOMAIN) . '" />';
} else {
if ($show == 'trash') {
$empty_button = '<input type="submit" name="delete_all" id="delete_all" class="button apply" value="' . esc_attr__('Empty Trash', GWOLLE_GB_TEXTDOMAIN) . '" />';
}
}
// Only show controls when there are entries
if (is_array($entries) && !empty($entries)) {
echo $massEditControls_select . $massEditControls . $empty_button;
}
?>
</div>
<?php
$pagination = gwolle_gb_pagination_admin($pageNum, $countPages, $count, $show);
echo $pagination;
?>
</div>
<div>
<table class="widefat">
<thead>
<tr>
<th scope="col" class="manage-column column-cb check-column"><input name="check-all-top" id="check-all-top" type="checkbox"></th>
<th scope="col"><?php
_e('ID', GWOLLE_GB_TEXTDOMAIN);
?>
</th>
<?php
if (get_option('gwolle_gb-showEntryIcons', 'true') === 'true') {
?>
<th scope="col"> </th><!-- this is the icon-column -->
<?php
}
?>
<th scope="col"><?php
_e('Date', GWOLLE_GB_TEXTDOMAIN);
?>
</th>
<th scope="col"><?php
_e('Author', GWOLLE_GB_TEXTDOMAIN);
?>
</th>
<th scope="col"><?php
_e('Entry (excerpt)', GWOLLE_GB_TEXTDOMAIN);
?>
</th>
<th scope="col"><?php
_e('Action', GWOLLE_GB_TEXTDOMAIN);
?>
</th>
</tr>
</thead>
<tfoot>
<tr>
<th scope="col" class="manage-column column-cb check-column"><input name="check-all-bottom" id="check-all-bottom" type="checkbox"></th>
<th scope="col"><?php
_e('ID', GWOLLE_GB_TEXTDOMAIN);
?>
</th>
<?php
if (get_option('gwolle_gb-showEntryIcons', 'true') === 'true') {
?>
<th scope="col"> </th><!-- this is the icon-column -->
<?php
}
?>
<th scope="col"><?php
_e('Date', GWOLLE_GB_TEXTDOMAIN);
?>
</th>
<th scope="col"><?php
_e('Author', GWOLLE_GB_TEXTDOMAIN);
?>
</th>
<th scope="col"><?php
_e('Entry (excerpt)', GWOLLE_GB_TEXTDOMAIN);
?>
</th>
<th scope="col"><?php
_e('Action', GWOLLE_GB_TEXTDOMAIN);
?>
</th>
</tr>
</tfoot>
<tbody>
<?php
$rowOdd = true;
$html_output = '';
if (!is_array($entries) || empty($entries)) {
$colspan = get_option('gwolle_gb-showEntryIcons', 'true') === 'true' ? 7 : 6;
$html_output .= '
<tr>
<td colspan="' . $colspan . '" align="center">
<strong>' . __('No entries found.', GWOLLE_GB_TEXTDOMAIN) . '</strong>
</td>
</tr>';
} else {
foreach ($entries as $entry) {
// rows have a different color.
if ($rowOdd) {
$rowOdd = false;
$class = ' alternate';
} else {
$rowOdd = true;
$class = '';
}
// Attach 'spam' to class if the entry is spam
if ($entry->get_isspam() === 1) {
$class .= ' spam';
} else {
$class .= ' nospam';
}
// Attach 'trash' to class if the entry is in trash
if ($entry->get_istrash() === 1) {
$class .= ' trash';
} else {
$class .= ' notrash';
}
// Attach 'checked/unchecked' to class
if ($entry->get_ischecked() === 1) {
$class .= ' checked';
} else {
$class .= ' unchecked';
}
// Attach 'visible/invisible' to class
if ($entry->get_isspam() === 1 || $entry->get_istrash() === 1 || $entry->get_ischecked() === 0) {
$class .= ' invisible';
} else {
$class .= ' visible';
}
// Add admin-entry class to an entry from an admin
$author_id = $entry->get_author_id();
$is_moderator = gwolle_gb_is_moderator($author_id);
if ($is_moderator) {
$class .= ' admin-entry';
}
// Checkbox and ID columns
$html_output .= '
<tr id="entry_' . $entry->get_id() . '" class="entry ' . $class . '">
<td class="check">
<input name="check-' . $entry->get_id() . '" id="check-' . $entry->get_id() . '" type="checkbox">
</td>
<td class="id">' . $entry->get_id() . '</td>';
// Optional Icon column where CSS is being used to show them or not
if (get_option('gwolle_gb-showEntryIcons', 'true') === 'true') {
$html_output .= '
<td class="entry-icons">
<span class="visible-icon"></span>
<span class="invisible-icon"></span>
<span class="spam-icon"></span>
<span class="trash-icon"></span>
<span class="gwolle_gb_ajax"></span>
</td>';
}
// Date column
$html_output .= '
<td class="entry-date">' . date_i18n(get_option('date_format'), $entry->get_datetime()) . ', ' . date_i18n(get_option('time_format'), $entry->get_datetime()) . '</td>';
// Author column
$author_name_html = gwolle_gb_get_author_name_html($entry);
$html_output .= '
<td class="entry-author-name"><span class="author-name">' . $author_name_html . '</span><br />' . '<span class="author-email">' . $entry->get_author_email() . '</span>' . '</td>';
// Excerpt column
$html_output .= '
<td class="entry-content">
<label for="check-' . $entry->get_id() . '">';
$entry_content = gwolle_gb_get_excerpt($entry->get_content(), 17);
if (get_option('gwolle_gb-showSmilies', 'true') === 'true') {
$entry_content = convert_smilies($entry_content);
}
$html_output .= $entry_content . '</label>
</td>';
// Actions column
$html_output .= '
<td class="gwolle_gb_actions">
<span class="gwolle_gb_edit">
<a href="admin.php?page=' . GWOLLE_GB_FOLDER . '/editor.php&entry_id=' . $entry->get_id() . '" title="' . __('Edit entry', GWOLLE_GB_TEXTDOMAIN) . '">' . __('Edit', GWOLLE_GB_TEXTDOMAIN) . '</a>
</span>
<span class="gwolle_gb_check"> |
<a id="check_' . $entry->get_id() . '" href="#" class="vim-a" title="' . __('Check entry', GWOLLE_GB_TEXTDOMAIN) . '">' . __('Check', GWOLLE_GB_TEXTDOMAIN) . '</a>
</span>
<span class="gwolle_gb_uncheck"> |
<a id="uncheck_' . $entry->get_id() . '" href="#" class="vim-u" title="' . __('Uncheck entry', GWOLLE_GB_TEXTDOMAIN) . '">' . __('Uncheck', GWOLLE_GB_TEXTDOMAIN) . '</a>
</span>
<span class="gwolle_gb_spam"> |
<a id="spam_' . $entry->get_id() . '" href="#" class="vim-s vim-destructive" title="' . __('Mark entry as spam.', GWOLLE_GB_TEXTDOMAIN) . '">' . __('Spam', GWOLLE_GB_TEXTDOMAIN) . '</a>
</span>
<span class="gwolle_gb_unspam"> |
<a id="unspam_' . $entry->get_id() . '" href="#" class="vim-a" title="' . __('Mark entry as not-spam.', GWOLLE_GB_TEXTDOMAIN) . '">' . __('Not spam', GWOLLE_GB_TEXTDOMAIN) . '</a>
</span>
<span class="gwolle_gb_trash"> |
<a id="trash_' . $entry->get_id() . '" href="#" class="vim-d vim-destructive" title="' . __('Move entry to trash.', GWOLLE_GB_TEXTDOMAIN) . '">' . __('Trash', GWOLLE_GB_TEXTDOMAIN) . '</a>
</span>
<span class="gwolle_gb_untrash"> |
<a id="untrash_' . $entry->get_id() . '" href="#" class="vim-d" title="' . __('Recover entry from trash.', GWOLLE_GB_TEXTDOMAIN) . '">' . __('Untrash', GWOLLE_GB_TEXTDOMAIN) . '</a>
</span>
<span class="gwolle_gb_ajax"> |
<a id="ajax_' . $entry->get_id() . '" href="#" class="ajax vim-d vim-destructive" title="' . __('Please wait...', GWOLLE_GB_TEXTDOMAIN) . '">' . __('Wait...', GWOLLE_GB_TEXTDOMAIN) . '</a>
</span>
</td>
</tr>';
}
}
echo $html_output;
?>
</tbody>
</table>
</div>
<div class="tablenav">
<div class="alignleft actions">
<?php
$massEditControls_select = '<select name="massEditAction2">';
$empty_button = '';
if ($show == 'spam') {
$empty_button = '<input type="submit" name="delete_all2" id="delete_all2" class="button apply" value="' . esc_attr__('Empty Spam', GWOLLE_GB_TEXTDOMAIN) . '" />';
} else {
if ($show == 'trash') {
$empty_button = '<input type="submit" name="delete_all2" id="delete_all2" class="button apply" value="' . esc_attr__('Empty Trash', GWOLLE_GB_TEXTDOMAIN) . '" />';
}
}
// Only show controls when there are entries
if (is_array($entries) && !empty($entries)) {
echo $massEditControls_select . $massEditControls . $empty_button;
}
?>
</div>
<?php
echo $pagination;
?>
</div>
</form>
</div>
<?php
}
}
function gwolle_gb_overview()
{
// Calculate the number of entries
$count = array();
$count['checked'] = gwolle_gb_get_entry_count(array('checked' => 'checked', 'trash' => 'notrash', 'spam' => 'nospam'));
$count['unchecked'] = gwolle_gb_get_entry_count(array('checked' => 'unchecked', 'trash' => 'notrash', 'spam' => 'nospam'));
$count['spam'] = gwolle_gb_get_entry_count(array('spam' => 'spam'));
$count['trash'] = gwolle_gb_get_entry_count(array('trash' => 'trash'));
$count['all'] = gwolle_gb_get_entry_count(array('all' => 'all'));
?>
<div class="table table_content gwolle_gb">
<h3><?php
_e('Overview', 'gwolle-gb');
?>
</h3>
<table>
<tbody>
<tr class="first">
<td class="first b">
<a href="admin.php?page=<?php
echo GWOLLE_GB_FOLDER;
?>
/entries.php">
<?php
echo $count['all'];
?>
</a>
</td>
<td class="t" style="color:#0000f0;">
<?php
if ($count['all'] == 1) {
_e('Entry total', 'gwolle-gb');
} else {
_e('Entries total', 'gwolle-gb');
}
?>
</td>
<td class="b"></td>
<td class="last"></td>
</tr>
<tr>
<td class="first b">
<a href="admin.php?page=<?php
echo GWOLLE_GB_FOLDER;
?>
/entries.php&show=checked">
<?php
echo $count['checked'];
?>
</a></td>
<td class="t" style="color:#008000;">
<?php
if ($count['checked'] == 1) {
_e('Unlocked entry', 'gwolle-gb');
} else {
_e('Unlocked entries', 'gwolle-gb');
}
?>
</td>
<td class="b"></td>
<td class="last"></td>
</tr>
<tr>
<td class="first b">
<a href="admin.php?page=<?php
echo GWOLLE_GB_FOLDER;
?>
/entries.php&show=unchecked">
<?php
echo $count['unchecked'];
?>
</a></td>
<td class="t" style="color:#ff6f00;">
<?php
if ($count['unchecked'] == 1) {
_e('New entry', 'gwolle-gb');
} else {
_e('New entries', 'gwolle-gb');
}
?>
</td>
<td class="b"></td>
<td class="last"></td>
</tr>
<tr>
<td class="first b">
<a href="admin.php?page=<?php
echo GWOLLE_GB_FOLDER;
?>
/entries.php&show=spam">
<?php
echo $count['spam'];
?>
</a></td>
<td class="t" style="color:#FF0000;">
<?php
if ($count['spam'] == 1) {
_e('Spam entry', 'gwolle-gb');
} else {
_e('Spam entries', 'gwolle-gb');
}
?>
</td>
<td class="b"></td>
<td class="last"></td>
</tr>
<tr>
<td class="first b">
<a href="admin.php?page=<?php
echo GWOLLE_GB_FOLDER;
?>
/entries.php&show=trash">
<?php
echo $count['trash'];
?>
</a></td>
<td class="t" style="color:#FF0000;">
<?php
if ($count['trash'] == 1) {
_e('Trashed entry', 'gwolle-gb');
} else {
_e('Trashed entries', 'gwolle-gb');
}
?>
</td>
<td class="b"></td>
<td class="last"></td>
</tr>
</tbody>
</table>
</div><!-- Table-DIV -->
<div class="versions">
<p>
<?php
$postid = gwolle_gb_get_postid();
if ($postid) {
$permalink = get_bloginfo('url') . '?p=' . $postid;
?>
<a class="button rbutton button button-primary" href="<?php
echo $permalink;
?>
"><?php
esc_attr_e('View Guestbook', 'gwolle-gb');
?>
</a>
<?php
}
?>
<a class="button rbutton button button-primary" href="admin.php?page=<?php
echo GWOLLE_GB_FOLDER;
?>
/editor.php"><?php
esc_attr_e('Write admin entry', 'gwolle-gb');
?>
</a>
</p>
</div>
<?php
}
function gwolle_gb_frontend_read($shortcode_atts)
{
$output = '';
$entriesPerPage = (int) get_option('gwolle_gb-entriesPerPage', 20);
$entriesCount = gwolle_gb_get_entry_count(array('checked' => 'checked', 'trash' => 'notrash', 'spam' => 'nospam', 'book_id' => $shortcode_atts['book_id']));
$countPages = ceil($entriesCount / $entriesPerPage);
$pageNum = 1;
if (isset($_GET['pageNum']) && is_numeric($_GET['pageNum'])) {
$pageNum = intval($_GET['pageNum']);
}
if ($pageNum > $countPages) {
// Page doesnot exist
$pageNum = 1;
}
if ($pageNum == 1 && $entriesCount > 0) {
$firstEntryNum = 1;
$mysqlFirstRow = 0;
} elseif ($entriesCount == 0) {
$firstEntryNum = 0;
$mysqlFirstRow = 0;
} else {
$firstEntryNum = ($pageNum - 1) * $entriesPerPage + 1;
$mysqlFirstRow = $firstEntryNum - 1;
}
/* Get the entries for the frontend */
if (isset($_GET['show_all']) && $_GET['show_all'] == 'true') {
$entries = gwolle_gb_get_entries(array('offset' => 0, 'num_entries' => -1, 'checked' => 'checked', 'trash' => 'notrash', 'spam' => 'nospam', 'book_id' => $shortcode_atts['book_id']));
$pageNum = 0;
// do not have it set to 1, this way the '1' will be clickable too.
} else {
$entries = gwolle_gb_get_entries(array('offset' => $mysqlFirstRow, 'num_entries' => $entriesPerPage, 'checked' => 'checked', 'trash' => 'notrash', 'spam' => 'nospam', 'book_id' => $shortcode_atts['book_id']));
}
/* Page navigation on top */
$pagination = gwolle_gb_pagination_frontend($pageNum, $countPages);
$output .= $pagination;
/* Entries from the template */
if (!is_array($entries) || empty($entries)) {
$output .= __('(no entries yet)', 'gwolle-gb');
} else {
$first = true;
$output .= '<div id="gwolle_gb_entries">';
// Try to load and require_once the template from the themes folders.
if (locate_template(array('gwolle_gb-entry.php'), true, true) == '') {
$output .= '<!-- Gwolle-GB Entry: Default Template Loaded -->
';
// No template found and loaded in the theme folders.
// Load the template from the plugin folder.
require_once 'gwolle_gb-entry.php';
} else {
$output .= '<!-- Gwolle-GB Entry: Custom Template Loaded -->
';
}
$counter = 0;
foreach ($entries as $entry) {
$counter++;
// Run the function from the template to get the entry.
$entry_output = gwolle_gb_entry_template($entry, $first, $counter);
$first = false;
// Add a filter for each entry, so devs can add or remove parts.
$output .= apply_filters('gwolle_gb_entry_read', $entry_output, $entry);
}
$output .= '</div>';
}
/* Page navigation on bottom */
$output .= $pagination;
// Add filter for the complete output.
$output = apply_filters('gwolle_gb_entries_read', $output);
return $output;
}
