© 2011 AnnounceME - Version ".$version." | designed & coded by Bernhard Bücherl | Icons of omercetins free icon set PixeloPhilia
"; //Plugin-Install function announceme_install () { global $wpdb; $table_name = $wpdb->prefix . "announceme"; if($wpdb->get_var("show tables like '$table_name'") != $table_name) { $sql = "CREATE TABLE " . $table_name . " ( id mediumint(9) NOT NULL AUTO_INCREMENT, `announce` tinytext NOT NULL, `cat` int NOT NULL, `img` text NOT NULL, `active` int(1) DEFAULT '0', `author` int(9) NOT NULL, `date` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL, `c1` varchar(6) NULL, `c2` varchar(6) NULL, `c3` varchar(6) NULL, `dsa` int(1) DEFAULT '1' NOT NULL, UNIQUE KEY id (id) );"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); dbDelta($sql); } } register_activation_hook(__FILE__,'announceme_install'); //Admin-Actions //Add Admin Scripts add_action('admin_head','announcemeAdminHead'); function announcemeAdminHead() { ?> prefix."announceme WHERE id = '".$_GET['id']."'"); ?>prefix."announceme WHERE id = '".$id."'"); } ?>prefix."announceme SET active = '1' WHERE id = '".$_GET['id']."'"); ?>prefix."announceme SET active = '1' WHERE id = '".$id."'"); } ?>prefix."announceme SET active = '0' WHERE id = '".$_GET['id']."'"); ?>prefix."announceme SET active = '0' WHERE id = '".$id."'"); } ?>prefix."announceme"); $qp = mysql_query("SELECT * FROM ".$wpdb->prefix."announceme WHERE `active` = '1'"); $all_count = mysql_num_rows($qa); $pub_count = mysql_num_rows($qp); //Order General $fororder = "admin.php?page=AnnounceME&type=".$_GET['type']."&orderby="; if(!isset($_GET['orderby'])) { $_GET['orderby']="date"; } if(!isset($_GET['order'])) { $_GET['order']="desc"; } //Order Category if($_GET['orderby']=="cat") { if($_GET['order']=="desc") { $sortcat = "sorted desc"; } else { $sortcat = "sorted asc"; } } else { $sortcat = "sortable desc"; } $sortcat .= '">Category Author Date '; ?>

AnnounceME › Announcements + Add

prefix."announceme".$where." ORDER BY `".$_GET['orderby']."` ".strtoupper($_GET['order']); $q1 = mysql_query($q); if(mysql_num_rows($q1)==0) { ?> user_login; $date = $q2['date']; ?>
      No Announcements here.
Edit | Delete | UnpublishPublish
prefix."announceme (`announce`,`cat`,`img`,`active`,`author`,`date`,`c1`,`c2`,`c3`,`dsa`) VALUES ('".$_POST['announce']."', '".$_POST['cat']."', '".$img[$_POST['cat']]."', '".$act."', '".get_current_user_id()."', NOW(), '".$_POST['c1']."', '".$_POST['c2']."', '".$_POST['c3']."','".$_POST['dsa']."')") or die(mysql_error()); ?>prefix."announceme SET `announce` = '".$_POST['announce']."',`cat` = '".$_POST['cat']."',`img` = '".$img[$_POST['cat']]."',`active` = '".$act."',`author` = '".get_current_user_id()."', `c1` = '".$_POST['c1']."', `c2` = '".$_POST['c2']."', `c3` = '".$_POST['c3']."', `dsa` = '".$_POST['dsa']."' WHERE id = '".$_POST['id']."'"); ?>prefix."announceme WHERE id = '".$id."'")); $t = $q1['announce']; $c = $q1['cat']; $d = $q1['dsa']; } else { $title = "New Announcement"; $id = "new"; $t = ""; $c = "1"; $d = "1"; } ?>

AnnounceME ›

value="Announcement text goes here..."value="" style="color: #333; font: 1.7em Verdana; line-height: 32px;" title="Announcement text goes here..." id="announce-title" autocomplete="off" />

Choose Category

checked="checked" />
checked="checked" />
checked="checked" />
checked="checked" />
style="display: none;">


Publish

checked="checked" />
checked="checked" />
prefix."announceme WHERE active = '1'"); $t = 0; while($q2=mysql_fetch_array($q1)) { if(!isset($_COOKIE['announceme-'.$q2['id']])) { $t += 41; } } ?>
prefix."announceme WHERE active = '1'"); while($q2 = mysql_fetch_array($q1)) { if(!isset($_COOKIE['announceme-'.$q2['id']])) { ?>
style="background: #; border-bottom: 1px solid #; color: #;">
style="color: #;">X
Don't show this again