/** * Returns the category and tag for the current object * * @return array an associativ array with the category and tag */ public function get_category_and_tag() { global $wpdb; $table_name = Ai1ec_Facebook_Factory::get_plugin_table(); $query = $wpdb->prepare("SELECT category, tag, comments_enabled, map_display_enabled\r\n\t\t\t FROM {$table_name}\r\n\t\t\t WHERE user_id = %s", $this->_id); return $wpdb->get_row($query, ARRAY_A); }
/** * Loads data about subscription, tag and category in the object. */ private function check_if_user_is_subscribed() { global $wpdb; $table_name = Ai1ec_Facebook_Factory::get_plugin_table(); $query = $wpdb->prepare("SELECT subscribed, category, tag FROM {$table_name} WHERE user_id = %s", $this->_id); $user = $wpdb->get_row($query, ARRAY_A); $this->_subscribed = (int) $user['subscribed'] === 1 ? TRUE : FALSE; $this->_tag = $user['tag']; $this->_category = $user['category']; }
/** * Gets the subscribers data from the db * * @param string $type the type to get * * @param $current_id The id of the currently logged on user which must be excluded from subscribers and multiselects * * @return array the results */ private function get_data_for_subscribed_items($type, $current_id) { global $wpdb; $table_name = Ai1ec_Facebook_Factory::get_plugin_table(); $data = $wpdb->get_results($wpdb->prepare("\n\t\t\t\tSELECT\n\t\t\t\t\tuser_id,\n\t\t\t\t\tuser_name,\n\t\t\t\t\tuser_pic,\n\t\t\t\t\tcategory,\n\t\t\t\t\ttag,\n\t\t\t\t\tcomments_enabled,\n\t\t\t\t\tmap_display_enabled\n\t\t\t\tFROM\n\t\t\t\t\t{$table_name}\n\t\t\t\tWHERE\n\t\t\t\t\tsubscribed = 1 AND\n\t\t\t\t\ttype = %s AND\n\t\t\t\t\tuser_id != %s\n\t\t\t\tORDER BY\n\t\t\t\t\tuser_name ASC\n\t\t\t\t", $type, $current_id), ARRAY_A); return $data; }
/** * (non-PHPdoc) * @see Ai1ec_Connector_Plugin::run_uninstall_procedures() */ public function run_uninstall_procedures() { // delete our scheduled crons $this->disable_cron_functions(); // Clean up opions delete_option(self::FB_OPTION_DB_VERSION); delete_option(self::FB_OPTION_CRON_VERSION); delete_option(self::FB_OPTION_CRON_NOTICE); // Delete tables global $wpdb; $plugin_table = Ai1ec_Facebook_Factory::get_plugin_table(); $user_events_table = Ai1ec_Facebook_Factory::get_user_events_table(); $wpdb->query("DROP TABLE IF EXISTS {$plugin_table}"); $wpdb->query("DROP TABLE IF EXISTS {$user_events_table}"); }
/** * Loads the ids of the user that are subscribed for the current type. This is used by the CRON * * @return TRUE if at least one fgo was loaded, false otherwise */ public function load_subscribers_for_type() { global $wpdb; $table_name = Ai1ec_Facebook_Factory::get_plugin_table(); $query = $wpdb->prepare("SELECT user_id\n\t\t\t\t\t\t\t\t\tFROM {$table_name}\n\t\t\t\t\t\t\t\t\tWHERE subscribed = 1 AND type = %s", $this->_type); $ids = $wpdb->get_col($query); $this->_ids = $ids; if (count($ids) > 0) { return TRUE; } else { return FALSE; } }
/** * Loads the ids of the user that are subscribed for the current type. This is used by the CRON * * @return TRUE if at least one fgo was loaded, false otherwise */ public function load_subscribers_for_type() { global $wpdb; $table_name = Ai1ec_Facebook_Factory::get_plugin_table(); $query = $wpdb->prepare('SELECT user_id FROM ' . $table_name . ' WHERE subscribed = 1 AND type = %s', $this->_type); $ids = $wpdb->get_col($query); $this->_ids = $ids; if (count($ids) > 0) { return true; } return false; }