0, "post_types" => array(), "comment" => 0, "controller" => '' ); /** * undocumented class variable * * @var array */ var $option; /** * Message for admin panel * @var array */ var $message = array(); /** * Error message for admin panel */ var $error = array(); /** * Retrieve data from table * @param int $object_id * @param string $post_type * @return object */ function get($object_id, $post_type = "post"){ global $wpdb; return $wpdb->get_row($wpdb->prepare("SELECT * FROM {$this->table} WHERE object_id = %d AND post_type = %s", $object_id, $post_type)); } /** * Retrieve all type of data * @param string $post_type * @return array */ function get_all($post_type = "post"){ global $wpdb; if($post_type == "comment"){ $sql = <<table} AS afb LEFT JOIN {$wpdb->comments} AS comment ON afb.object_id = comment.comment_ID LEFT JOIN {$wpdb->posts} AS post ON comment.comment_post_ID = post.ID WHERE afb.post_type = %s ORDER BY (afb.positive + afb.negative) DESC EOS; return $wpdb->get_results($wpdb->prepare($sql, $post_type)); }else{ $sql = <<table} AS afb LEFT JOIN {$wpdb->posts} AS post ON afb.object_id = post.ID WHERE afb.post_type = %s ORDER BY (afb.positive + afb.negative) DESC EOS; return $wpdb->get_results($wpdb->prepare($sql, $post_type)); } } /** * Retrieve recorded post_types * @return array */ function recorded_post_types(){ $recorded = array(); global $wpdb; $sql = <<table} GROUP BY post_type EOS; foreach($wpdb->get_results($sql) as $r){ $recorded[] = $r->post_type; } sort($recorded); return $recorded; } /** * Retrive statistic inforamtion * @param string $case * @param mixed $post_type string or array * @return mixed */ function statistic($case, $post_type = ""){ global $wpdb; switch($case){ case "total": $sql = <<table} EOS; break; } if(empty($post_type)){ }elseif(is_array($post_type)){ $where = " WHERE post_type IN ("; $counter = 0; foreach($post_type as $p){ $where .= $wpdb->prepare("%s", $p); $counter++; } $where .= ")"; $sql .= $where; }else{ $sql .= $wpdb->prepare(" WHERE post_type = %s", $post_type); } return $wpdb->get_row($sql); } /** * Add new data * * @param int $oject_id * @param string $post_type (optional) * @param boolean $affirmative (optional) if false,negative. default true. * @return int */ function add($object_id, $post_type = "post", $affirmative = true){ global $wpdb; $data = array( "object_id" => $object_id, "post_type" => $post_type, "updated" => date("Y-m-d H:i:s") ); if($affirmative){ $data["positive"] = 1; }else{ $data["negative"] = 1; } $result = $wpdb->insert($this->table, $data, array("%d", "%s", "%s", "%d") ); if($result){ return $wpdb->insert_id; }else{ return 0; } } /** * Update data * * @param int $oject_id * @param string $post_type (optional) * @param boolean $affirmative (optional) if false,negative. default true. * @return boolean */ function update($object_id, $post_type = "post", $affirmative = true){ global $wpdb; $column = $affirmative ? "positive" : "negative"; $sql = <<table} SET `$column` = {$column}+1, `updated` = %s WHERE `object_id` = %d AND `post_type` = %s EOS; //Try updating and get updated rows. $result = $wpdb->query($wpdb->prepare($sql, date("Y-m-d H:i:s"), $object_id, $post_type)); return (boolean) $result; } /** * Delete Data * @param int $object_id * @param string $post_type * @return booelan */ function delete($object_id, $post_type = "post"){ global $wpdb; $sql = <<table} WHERE object_id = %d AND post_type = %s EOS; return (boolean) $wpdb->query($sql, $object_id, $post_type); } /** * Check version and table structure on Plugin Activation * @return void */ function activate(){ global $wpdb; //Check if the database exists. $is_db_exists = $wpdb->get_var($wpdb->prepare("SHOW TABLES LIKE %s", $this->table)); if($is_db_exists){ //Check if the database is old. if($this->db_version >= $this->version){ //Exit and do nothing. return; } } //Here starts database update! //Load required files. require_once ABSPATH."wp-admin/includes/upgrade.php"; //Do dbDelta! dbDelta($this->sql()); //And save current db version update_option("afb_db_version", $this->version); } /** * Return Query to create table * @return string */ function sql(){ //Set character set $char = defined("DB_CHARSET") ? DB_CHARSET : "utf8"; return <<table} ( `ID` BIGINT(11) NOT NULL AUTO_INCREMENT, `object_id` BIGINT(11) NOT NULL, `post_type` VARCHAR(45) NOT NULL, `positive` BIGINT(11) NOT NULL, `negative` BIGINT(11) NOT NULL, `updated` DATETIME NOT NULL, UNIQUE(`ID`) ) ENGINE = MyISAM DEFAULT CHARSET = {$char} ; EOS; } /** * Constructor for PHP4 * @param float $version * @return void */ function Anyway_Feedback(){ $this->__construct(); } /** * Constructor for PHP5 * @param float $version * @return void */ function __construct(){ global $wpdb; //Start Session if(!isset($_SESSION)){ session_start(); } if(!isset($_SESSION[$this->session]) || empty($_SESSION[$this->session])){ $_SESSION[$this->session] = array(); } //Set directory $this->dir = dirname(__FILE__); //option $this->option = get_option('afb_setting', $this->default_option); //Set required options for upgrade if(count($this->option) != count($this->default_option)){ foreach($this->default_option as $key => $val){ if(!isset($this->option[$key])){ $this->option[$key] = $val; } } } //Strip slashed if(!empty($this->option["controller"])){ $this->option["controller"] = stripslashes($this->option["controller"]); } //Set Text Domain load_plugin_textdomain(self::$domain, false, basename($this->dir).DIRECTORY_SEPARATOR."language"); //Define table name. $this->table = $wpdb->prefix.$this->table; //Get installed version $this->db_version = get_option('afb_db_version', 0); //Add action hook to load assets. add_action("wp_enqueue_scripts", array($this, "load_asset")); //Register Widgets add_action("widgets_init", array($this, "register_widgets")); //Add ajax handler //TODO: Despite Ajax request, this use init hook because Theme My Login prepend. add_action('init', array($this, "ajax")); //Add admin menu add_action('admin_menu', array($this, "create_admin")); //Add contorller if(!empty($this->option["post_types"])){ //...to post add_filter("the_content", array($this, "the_content")); //...to comment if($this->option["comment"]){ add_filter("comment_text", array($this, "comment_text"), 10, 2); } } } /** * Handling Ajax * * @return void */ function ajax(){ if(isset($_POST["action"]) && $_POST["action"] == "anyway_feedback"){ $nonce = isset($_REQUEST["nonce"]) ? $_REQUEST["nonce"] : "boo!"; $response = array( "success" => true, "message" => $this->_("Thank you for your feedback.") ); if(wp_verify_nonce($nonce, "anyway_feedback") && !$this->does_current_user_posted($_REQUEST['post_type'], $_REQUEST['object_id'])){ //Feedback request is valid. switch($_POST["class_name"]){ case "good": $affirmative = true; break; case "bad": $affirmative = false; break; default: $response["success"] = false; $response["message"] = $this->_("Request is invalid."); break; } //If no error, try updating if($response["success"]){ if(!$this->update($_POST["object_id"], $_POST["post_type"], $affirmative)){ $this->add($_POST["object_id"], $_POST["post_type"], $affirmative); } $_SESSION[$this->session][] = (string)$_POST['post_type'].'_'.$_POST['object_id']; } }else{ //Error. $response["success"] = false; $response["message"] = $this->_("Request is invalid."); } //Output result as JSON. header("Content-Type: application/json"); echo json_encode($response); //Don't forget exit. exit; } } /** * Create Admin Panel * @return void */ function create_admin(){ //Create Page add_options_page($this->_("Anyway Feedback Option: "), $this->_('Anyway Feedback'), 8, "anyway-feedback", array($this, "render_admin"), plugin_dir_url(__FILE__)."assets/undo.png"); //Add admin action add_action("admin_init", array($this, "admin_header")); //Load Assets for admin add_action("admin_enqueue_scripts", array($this, "admin_assets")); //Show message for Admin Panel add_action("admin_notice", array($this, "admin_notice")); } /** * Render admin panel * @return void */ function render_admin(){ require_once dirname(__FILE__).DIRECTORY_SEPARATOR."admin".DIRECTORY_SEPARATOR."admin-template.php"; } /** * Load header file for admin panel * @return void */ function admin_header(){ if(isset($_GET["page"]) && $_GET["page"] == "anyway-feedback"){ require_once dirname(__FILE__).DIRECTORY_SEPARATOR."admin".DIRECTORY_SEPARATOR."admin-header.php"; } } /** * Load assets for admin panel * @return void */ function admin_assets(){ if(isset($_GET["page"]) && $_GET["page"] == "anyway-feedback"){ $asset_dir = plugin_dir_url(__FILE__)."assets"; //Main Style sheet wp_enqueue_style('afb-admin', $asset_dir."/admin-style.css", false, $this->version, 'screen'); //jQuery-UI-Tabs wp_enqueue_style('afb-jquery-ui-tabs', $asset_dir."/smoothness/jquery-ui-1.8.13.custom.css", false, "1.8.13", 'screen'); wp_enqueue_script( "afb-util", $asset_dir."/admin-script.js", array('jquery-ui-tabs'), $this->version ); } } /** * Show notice on admin panel * @return void */ function admin_notice(){ if(isset($_GET["page"]) && $_GET["page"] == "anyway-feedback"){ if(!empty($this->error)){ ?>

message)){ ?>

version, true ); //Load CSS if(!is_admin() && $this->option["style"]){ wp_enqueue_style( 'afb-controller', plugin_dir_url(__FILE__).'assets/afb-style.css', false, $this->version, 'screen' ); } } /** * Make controller * @param int $object_id * @param string $post_type * @return string */ function get_conroller_tag($object_id, $post_type){ global $wp_post_types; $nonce = wp_create_nonce("anyway_feedback"); $post_type_name = ($post_type == "comment") ? __("Comment") : $wp_post_types[$post_type]->labels->name; $message = sprintf($this->_("Is this %s usefull?"), $post_type_name); $status = sprintf($this->_("%1\$d of %2\$d people say this %3\$s is usefull."), afb_affirmative(false, $object_id, $post_type), afb_total(false, $object_id, $post_type), $post_type_name); $usefull = $this->_("Usefull"); $userless = $this->_("Useless"); $url = $post_type == "comment" ? get_permalink() : get_permalink($object_id); $already_posted = $this->does_current_user_posted($post_type, $object_id) ? ' afb_posted' : ''; $before = <<

EOS; if(empty($this->option["controller"])){ $before .= <<{$message} {$usefull} {$userless} {$status} EOS; }else{ $replaces = array( "POST_TYPE" => $post_type_name, "LINK" => $url, "POSITIVE" => afb_affirmative(false, $object_id, $post_type), "TOTAL" => afb_total(false, $object_id, $post_type), "NEGATIVE" => afb_negative(false, $object_id, $post_type) ); $content = $this->option["controller"]; foreach($replaces as $needle => $repl){ $content = str_replace("%{$needle}%", $repl, $content); } $before .= $content; } $after = <<

EOS; return $before.$after; } /** * 現在のユーザーが回答済みか否か * @param string $post_type * @param int $object_id * @return boolean */ function does_current_user_posted($post_type, $object_id){ if(isset($_SESSION[$this->session])){ return (false !== array_search("{$post_type}_{$object_id}", $_SESSION[$this->session])); }else{ return false; } } /** * Add controller panel to the_content() * * @param string $content * @return string */ function the_content($content){ if(false !== array_search(get_post_type(), $this->option["post_types"])){ $content .= $this->get_conroller_tag(get_the_ID(), get_post_type()); } return $content; } /** * */ function comment_text($comment_text, $comment){ if(false !== array_search(get_post_type(), $this->option["post_types"])){ $comment_text .= str_replace("¥n", "", $this->get_conroller_tag($comment->comment_ID, "comment")); } return $comment_text; } /** * Alias for gettext _e function * @param string $string * @return void */ function e($string){ _e($string, self::$domain); } /** * Alias for gettext __ function * @param string $string * @return string */ function _($string){ return __($string, self::$domain); } /** * register widgets * * @return void */ function register_widgets(){ return register_widget('Anyway_Feedback_Popular'); } }