prefix}sd_ajax_admin_notes` (`id` INT(20) NOT NULL AUTO_INCREMENT, `head` TEXT NOT NULL, `content` LONGTEXT NOT NULL, `user_id` BIGINT(20) NOT NULL, `share_id` BIGINT(20) NOT NULL, PRIMARY KEY (`id`)) ENGINE = MyISAM;";
$wpdb->query($sd_install_note_sql);
global $user_ID;
$info1 = base64_decode("QWJvdXQgdGhpcyBQbHVnaW4=");
$info2 = base64_decode("VGhpcyBwbHVnaW4gaXMgd3JpdHRlbiBieSBEYW5pZWwgU3RyYXViLiBWaXNpdCBteSBCbG9nIGF0IHd3dy5rYXR6ZW5oaXJuLmNvbSBvciBmb2xsb3cgbWUgb24gVHdpdHRlcjogd3d3LnR3aXR0ZXIuY29tL0Q0TjEzTC4gSWYgeW91IGZpbmQgYSBidWcgbGV0IG1lIGtub3cu");
$wpdb->query( $wpdb->prepare ("INSERT INTO {$wpdb->prefix}sd_ajax_admin_notes (head, content, user_id) VALUES ('%s', '%s', '%d')", $info1, $info2, $user_ID));
}
function sd_admin_note_deactivation()
{
global $wpdb;
$sd_uninstall_note_sql = "DROP TABLE `{$wpdb->prefix}sd_ajax_admin_notes`";
$wpdb->query($sd_uninstall_note_sql);
}
/* ####################################### */
// Activation and Deactivation Ende
/* ####################################### */
/* ####################################### */
// Globale Variablen + Textdomain
/* ####################################### */
// Globale Variablen
$admin_note_plugin_path = WP_PLUGIN_URL.'/'.str_replace(basename( __FILE__),"",plugin_basename(__FILE__));
$admin_note_plugin_path_lang = dirname( plugin_basename( __FILE__ ) ) ."/";
//load_textdomain('sd_admin_note', $admin_note_plugin_path);
load_plugin_textdomain( 'sd_admin_note',false, $admin_note_plugin_path_lang);
$sd_admin_note_sharing = sd_admin_note_sharing();
/* ####################################### */
// Globale Variablen + Textdomain Ende
/* ####################################### */
function sd_admin_note()
{
global $user_ID;
$sd_get_note_data = sd_admin_notes_get_note();
foreach ($sd_get_note_data as $sd_get_note_data) {
$admin_note_author = get_userdata($sd_get_note_data->user_id);
$admin_note_author_name = $admin_note_author->user_login;
if($sd_get_note_data->share_id == "-1")
{
$admin_note_share_name = "all";
}
else
{
$admin_note_share = get_userdata($sd_get_note_data->share_id);
$admin_note_share_name = $admin_note_share->user_login;
}
$admin_note_share = get_userdata($sd_get_note_data->share_id);
?>
content; ?>
user_id == $user_ID)
{ ?>
share_id != '0')
{
?>
prefix}sd_ajax_admin_notes ";
$sd_get_menu_sql .= "WHERE user_id = '$user_ID' ";
$sd_get_menu_sql .= "OR share_id = '-1' ";
$sd_get_menu_sql .= "OR share_id = '$user_ID' ";
return $wpdb->get_results($sd_get_menu_sql);
}
function sd_admin_notes_get_note()
{
global $wpdb;
global $user_ID;
$sd_get_note_sql = "SELECT id, head, content, user_id, share_id ";
$sd_get_note_sql .= "FROM {$wpdb->prefix}sd_ajax_admin_notes ";
$sd_get_note_sql .= "WHERE user_id = '$user_ID' ";
$sd_get_note_sql .= "OR share_id = '-1' ";
$sd_get_note_sql .= "OR share_id = '$user_ID'";
return $wpdb->get_results($sd_get_note_sql);
}
function sd_admin_note_sql_new_note($head, $content, $share)
{
global $wpdb;
global $user_ID;
$head = htmlspecialchars($head);
$content = htmlspecialchars($content);
$wpdb->query( $wpdb->prepare ("INSERT INTO {$wpdb->prefix}sd_ajax_admin_notes (head, content, user_id, share_id) VALUES ('%s', '%s', '%d', '%d')", $head, $content, $user_ID, $share));
$new_id = mysql_insert_id();
echo $new_id;
}
function sd_admin_note_sql_update_note($id, $head, $content, $share)
{
global $wpdb;
global $user_ID;
$head = htmlspecialchars($head);
$content = htmlspecialchars($content);
$wpdb->query( $wpdb->prepare ("UPDATE {$wpdb->prefix}sd_ajax_admin_notes SET head = '%s', content = '%s', share_id = '%d' WHERE id = '%d' AND user_id = '$user_ID'", $head, $content, $share, $id));
}
function sd_admin_note_sql_delete_note($id)
{
global $wpdb;
global $user_ID;
$wpdb->query( $wpdb->prepare ("DELETE FROM {$wpdb->prefix}sd_ajax_admin_notes WHERE id = '%d' AND user_id = '%d'", $id, $user_ID));
}
function sd_admin_note_sec($id)
{
global $wpdb;
global $user_ID;
$sd_admin_note_edit_note_sec_id = $wpdb->get_results($wpdb->prepare("SELECT user_id FROM {$wpdb->prefix}sd_ajax_admin_notes WHERE id = '%d'", $id));
foreach ($sd_admin_note_edit_note_sec_id as $sd_admin_note_edit_note_sec_id)
{
if($sd_admin_note_edit_note_sec_id->user_id == $user_ID)
{
return true;
}
else
{
return false;
}
}
}
function sd_admin_note_sharing()
{
global $wpdb;
global $blog_id;
$count_user = $wpdb->get_var("SELECT COUNT(umeta_id) FROM $wpdb->usermeta WHERE meta_key = 'primary_blog' AND meta_value = '$blog_id'");
if($count_user == 0) {
$count_user = $wpdb->get_var("SELECT COUNT(id) FROM $wpdb->users");
}
if($count_user > 1) {
return true;
}
else {
return false;
}
}
/* ####################################### */
// Datenbankquerys Ende
/* ####################################### */
/* ####################################### */
// Actions + Filters
/* ####################################### */
add_action('wp_ajax_admin_notes', 'sd_admin_notes_ajax_script');
add_action('admin_notices', 'sd_admin_note_mini');
add_action('admin_footer', 'sd_admin_note');
if(is_admin()) {
add_action('init', 'load_aan_script_and_style');
}
/* ####################################### */
// Actions + Filters Ende
/* ####################################### */
// Vielen Dank fŸr die Nutzung meines Plugins
// Mehr von mir auf katzenhirn.com
// oder auf twitter.com/D4N13L
// Freue mich auf eure Bugs, VerbesserungsvorschlŠge und Feedback
?>