function gwolle_gb_get_entries($args = array())
{
global $wpdb;
$where = " 1 = %d";
$values = array(1);
if (!is_array($args)) {
return false;
}
if (isset($args['checked'])) {
if ($args['checked'] == 'checked' || $args['checked'] == 'unchecked') {
$where .= "\n\t\t\t\tAND\n\t\t\t\tischecked = %d";
if ($args['checked'] == 'checked') {
$values[] = 1;
} else {
if ($args['checked'] == 'unchecked') {
$values[] = 0;
}
}
}
}
if (isset($args['spam'])) {
if ($args['spam'] == 'spam' || $args['spam'] == 'nospam') {
$where .= "\n\t\t\t\tAND\n\t\t\t\tisspam = %d";
if ($args['spam'] == 'spam') {
$values[] = 1;
} else {
if ($args['spam'] == 'nospam') {
$values[] = 0;
}
}
}
}
if (isset($args['trash'])) {
if ($args['trash'] == 'trash' || $args['trash'] == 'notrash') {
$where .= "\n\t\t\t\tAND\n\t\t\t\tistrash = %d";
if ($args['trash'] == 'trash') {
$values[] = 1;
} else {
if ($args['trash'] == 'notrash') {
$values[] = 0;
}
}
}
}
if (isset($args['author_id'])) {
$where .= "\n\t\t\tAND\n\t\t\tauthor_id = %d";
$values[] = (int) $args['author_id'];
}
if (isset($args['email'])) {
$where .= "\n\t\t\tAND\n\t\t\tauthor_email = %s";
$values[] = $args['email'];
}
if (isset($args['no_moderators'])) {
$no_moderators = $args['no_moderators'];
if ($no_moderators === 'true') {
$users = gwolle_gb_get_moderators();
if (is_array($users) && !empty($users)) {
foreach ($users as $user_info) {
$where .= "\n\t\t\t\t\t\tAND\n\t\t\t\t\t\tauthor_id != %d";
$values[] = $user_info->ID;
}
}
}
}
if (isset($args['book_id'])) {
$where .= "\n\t\t\tAND\n\t\t\tbook_id = %d";
$values[] = (int) $args['book_id'];
}
// Offset
$offset = " OFFSET 0 ";
// default
if (isset($args['offset']) && (int) $args['offset'] > 0) {
$offset = " OFFSET " . (int) $args['offset'];
}
// Limit
if (is_admin()) {
$perpage_option = (int) get_option('gwolle_gb-entries_per_page', 20);
} else {
$perpage_option = (int) get_option('gwolle_gb-entriesPerPage', 20);
}
$limit = " LIMIT " . $perpage_option;
// default
if (isset($args['num_entries']) && (int) $args['num_entries'] > 0) {
$limit = " LIMIT " . (int) $args['num_entries'];
} else {
if (isset($args['num_entries']) && (int) $args['num_entries'] == -1) {
$limit = ' LIMIT 999999999999999 ';
$offset = ' OFFSET 0 ';
}
}
$tablename = $wpdb->prefix . "gwolle_gb_entries";
$sql = "\n\t\t\tSELECT\n\t\t\t\t`id`,\n\t\t\t\t`author_name`,\n\t\t\t\t`author_id`,\n\t\t\t\t`author_email`,\n\t\t\t\t`author_origin`,\n\t\t\t\t`author_website`,\n\t\t\t\t`author_ip`,\n\t\t\t\t`author_host`,\n\t\t\t\t`content`,\n\t\t\t\t`datetime`,\n\t\t\t\t`ischecked`,\n\t\t\t\t`checkedby`,\n\t\t\t\t`istrash`,\n\t\t\t\t`isspam`,\n\t\t\t\t`admin_reply`,\n\t\t\t\t`admin_reply_uid`,\n\t\t\t\t`book_id`\n\t\t\tFROM\n\t\t\t\t" . $tablename . "\n\t\t\tWHERE\n\t\t\t\t" . $where . "\n\t\t\tORDER BY\n\t\t\t\tdatetime DESC\n\t\t\t" . $limit . " " . $offset . "\n\t\t\t;";
$sql = $wpdb->prepare($sql, $values);
$datalist = $wpdb->get_results($sql, ARRAY_A);
//$wpdb->print_error();
//echo "number of rows: " . $wpdb->num_rows;
if (is_array($datalist) && !empty($datalist)) {
$entries = array();
foreach ($datalist as $data) {
// Use the fields that the setter method expects
$item = array('id' => (int) $data['id'], 'author_name' => stripslashes($data['author_name']), 'author_id' => (int) $data['author_id'], 'author_email' => stripslashes($data['author_email']), 'author_origin' => stripslashes($data['author_origin']), 'author_website' => stripslashes($data['author_website']), 'author_ip' => $data['author_ip'], 'author_host' => $data['author_host'], 'content' => stripslashes($data['content']), 'datetime' => $data['datetime'], 'ischecked' => (int) $data['ischecked'], 'checkedby' => (int) $data['checkedby'], 'istrash' => (int) $data['istrash'], 'isspam' => (int) $data['isspam'], 'admin_reply' => stripslashes($data['admin_reply']), 'admin_reply_uid' => (int) $data['admin_reply_uid'], 'book_id' => (int) $data['book_id']);
$entry = new gwolle_gb_entry();
$entry->set_data($item);
// Add entry to the array of all entries
$entries[] = $entry;
}
return $entries;
}
return false;
}
function gwolle_gb_page_settingstab_email()
{
if (function_exists('current_user_can') && !current_user_can('manage_options')) {
die(__('Cheatin’ uh?', 'gwolle-gb'));
}
?>
<input type="hidden" id="gwolle_gb_tab" name="gwolle_gb_tab" value="gwolle_gb_mail" />
<?php
settings_fields('gwolle_gb_options');
do_settings_sections('gwolle_gb_options');
?>
<table class="form-table">
<tbody>
<tr valign="top">
<th scope="row"><label for="admin_mail_from"><?php
_e('Admin mail from address', 'gwolle-gb');
?>
</label></th>
<td>
<input type="email" name="admin_mail_from" id="admin_mail_from" class="regular-text" value="<?php
echo gwolle_gb_sanitize_output(get_option('gwolle_gb-mail-from', false));
?>
" placeholder="*****@*****.**" />
<br />
<span class="setting-description">
<?php
_e('You can set the email address that is used for the From header of the mail that a notification subscriber gets on new entries.', 'gwolle-gb');
echo '<br />';
_e('By default the main admin address is used from General >> Settings.', 'gwolle-gb');
?>
</span>
</td>
</tr>
<tr valign="top">
<th scope="row"><label for="unsubscribe"><?php
_e('Unsubscribe moderators', 'gwolle-gb');
?>
</label></th>
<td>
<?php
// Check if function mail() exists. If not, display a hint to the user.
if (!function_exists('mail')) {
echo '<p class="setting-description">' . __('Sorry, but the function <code>mail()</code> required to notify you by mail is not enabled in your PHP configuration. You might want to install a WordPress plugin that uses SMTP instead of <code>mail()</code>. Or you can contact your hosting provider to change this.', 'gwolle-gb') . '</p>';
}
?>
<select name="unsubscribe" id="unsubscribe">
<option value="0"><?php
_e('Unsubscribe User', 'gwolle-gb');
?>
</option>
<?php
$user_ids = get_option('gwolle_gb-notifyByMail');
if (strlen($user_ids) > 0) {
$user_ids = explode(",", $user_ids);
if (is_array($user_ids) && !empty($user_ids)) {
foreach ($user_ids as $user_id) {
$user_info = get_userdata($user_id);
if ($user_info === FALSE) {
// Invalid $user_id
continue;
}
$username = $user_info->first_name . ' ' . $user_info->last_name . ' (' . $user_info->user_email . ')';
if ($user_info->ID == get_current_user_id()) {
$username .= ' ' . __('You', 'gwolle-gb');
}
echo '<option value="' . $user_id . '">' . $username . '</option>';
}
}
}
?>
</select><br />
<label for="unsubscribe"><?php
_e('These users have subscribed to the notification emails.', 'gwolle-gb');
?>
<br />
<?php
_e('Select a user if you want that user to unsubscribe from the notification emails.', 'gwolle-gb');
?>
</label>
</td>
</tr>
<tr valign="top">
<th scope="row"><label for="subscribe"><?php
_e('Subscribe moderators', 'gwolle-gb');
?>
</label></th>
<td>
<select name="subscribe" id="subscribe">
<option value="0"><?php
_e('Subscribe User', 'gwolle-gb');
?>
</option>
<?php
$users = gwolle_gb_get_moderators();
if (is_array($users) && !empty($users)) {
foreach ($users as $user_info) {
// Test if already subscribed
if (is_array($user_ids) && !empty($user_ids)) {
if (in_array($user_info->ID, $user_ids)) {
continue;
}
}
$username = $user_info->first_name . ' ' . $user_info->last_name . ' (' . $user_info->user_email . ')';
if ($user_info->ID == get_current_user_id()) {
$username .= ' ' . __('You', 'gwolle-gb');
}
echo '<option value="' . $user_info->ID . '">' . $username . '</option>';
}
}
?>
</select><br />
<label for="subscribe"><?php
_e('You can subscribe a moderator to the notification emails.', 'gwolle-gb');
?>
<br />
<?php
_e('Select a user that you want subscribed to the notification emails.', 'gwolle-gb');
?>
<?php
_e("You will only see users with the roles of Administrator, Editor and Author, who have the capability 'moderate_comments' .", 'gwolle-gb');
?>
</label>
</td>
</tr>
<tr valign="top">
<th scope="row"><label for="adminMailContent"><?php
_e('Admin mail content', 'gwolle-gb');
?>
</label></th>
<td>
<?php
$mailText = gwolle_gb_sanitize_output(get_option('gwolle_gb-adminMailContent', false));
if (!$mailText) {
// No text set by the user. Use the default text.
$mailText = __("\nHello,\n\nThere is a new guestbook entry at '%blog_name%'.\nYou can check it at %entry_management_url%.\n\nHave a nice day.\nYour Gwolle-GB-Mailer\n\n\nWebsite address: %blog_url%\nUser name: %user_name%\nUser email: %user_email%\nEntry status: %status%\nEntry content:\n%entry_content%\n", 'gwolle-gb');
}
?>
<textarea name="adminMailContent" id="adminMailContent" style="width:400px;height:300px;" class="regular-text"><?php
echo $mailText;
?>
</textarea>
<br />
<span class="setting-description">
<?php
_e('You can set the content of the mail that a notification subscriber gets on new entries. The following tags are supported:', 'gwolle-gb');
echo '<br />';
$mailTags = array('user_email', 'user_name', 'entry_management_url', 'blog_name', 'blog_url', 'wp_admin_url', 'entry_content', 'status', 'author_ip');
for ($i = 0; $i < count($mailTags); $i++) {
if ($i != 0) {
echo ', ';
}
echo '%' . $mailTags[$i] . '%';
}
echo ".";
?>
</span>
</td>
</tr>
<tr valign="top">
<th scope="row"><label for="mail_author"><?php
_e('Mail Author', 'gwolle-gb');
?>
</label></th>
<td>
<input <?php
if (get_option('gwolle_gb-mail_author', 'false') == 'true') {
echo 'checked="checked"';
}
?>
type="checkbox" name="mail_author" id="mail_author">
<label for="mail_author">
<?php
_e('Mail the author with a confirmation email.', 'gwolle-gb');
?>
</label>
<br />
<span class="setting-description">
<?php
_e("The author of the guestbook entry will receive an email after posting. It will have a copy of the entry.", 'gwolle-gb');
?>
</span>
</td>
</tr>
<tr valign="top">
<th scope="row"><label for="authorMailContent"><?php
_e('Author mail content', 'gwolle-gb');
?>
</label></th>
<td>
<?php
$mailText = gwolle_gb_sanitize_output(get_option('gwolle_gb-authorMailContent', false));
if (!$mailText) {
// No text set by the user. Use the default text.
$mailText = __("\nHello,\n\nYou have just posted a new guestbook entry at '%blog_name%'.\n\nHave a nice day.\nThe editors at %blog_name%.\n\n\nWebsite address: %blog_url%\nUser name: %user_name%\nUser email: %user_email%\nEntry content:\n%entry_content%\n", 'gwolle-gb');
}
?>
<textarea name="authorMailContent" id="authorMailContent" style="width:400px;height:300px;" class="regular-text"><?php
echo $mailText;
?>
</textarea>
<br />
<span class="setting-description">
<?php
_e('You can set the content of the mail that the author of the entry will receive. The following tags are supported:', 'gwolle-gb');
echo '<br />';
$mailTags = array('user_email', 'user_name', 'blog_name', 'blog_url', 'entry_content');
for ($i = 0; $i < count($mailTags); $i++) {
if ($i != 0) {
echo ', ';
}
echo '%' . $mailTags[$i] . '%';
}
?>
</span>
</td>
</tr>
<tr valign="top">
<th scope="row"><label for="gwolle_gb-mail_admin_replyContent"><?php
_e('Admin Reply mail content', 'gwolle-gb');
?>
</label></th>
<td>
<?php
$mailText = gwolle_gb_sanitize_output(get_option('gwolle_gb-mail_admin_replyContent', false));
if (!$mailText) {
// No text set by the user. Use the default text.
$mailText = __("\nHello,\n\nAn admin has just added or changed a reply message to your guestbook entry at '%blog_name%'.\n\nHave a nice day.\nThe editors at %blog_name%.\n\n\nWebsite address: %blog_url%\nAdmin Reply:\n%admin_reply%\n", 'gwolle-gb');
}
?>
<textarea name="gwolle_gb-mail_admin_replyContent" id="gwolle_gb-mail_admin_replyContent" style="width:400px;height:300px;" class="regular-text"><?php
echo $mailText;
?>
</textarea>
<br />
<span class="setting-description">
<?php
_e('You can set the content of the mail that the author of the entry will receive when an Admin Reply is added. The following tags are supported:', 'gwolle-gb');
echo '<br />';
$mailTags = array('user_email', 'user_name', 'blog_name', 'blog_url', 'admin_reply');
for ($i = 0; $i < count($mailTags); $i++) {
if ($i != 0) {
echo ', ';
}
echo '%' . $mailTags[$i] . '%';
}
?>
</span>
</td>
</tr>
<tr>
<td colspan="2">
<p class="submit">
<input type="submit" name="gwolle_gb_settings_email" id="gwolle_gb_settings_email" class="button-primary" value="<?php
esc_attr_e('Save settings', 'gwolle-gb');
?>
" />
</p>
</td>
</tr>
</tbody>
</table>
<?php
}