public function get_my_voices($bundle = array())
 {
     // set return result
     $result = array("status" => true, "message" => "", "is_data" => false, "is_more_data" => false, "data" => array());
     // get valid logging id
     $uid = $this->get_logged_uid();
     // first user is valid
     if ($uid) {
         $start = c_pick_param($bundle, "start", 0);
         $limit = c_pick_param($bundle, "limit", 10);
         // calculate start
         $next_start = ($start + 1) * $limit;
         $start = $start * $limit;
         $query = "SELECT * FROM user_voices WHERE user_id=%d AND is_blocked=0 ORDER BY id DESC LIMIT %d, %d";
         $sql = sprintf($query, $uid, $start, $limit);
         $bundle = array("sql" => $sql);
         // get voices
         $voices = $this->get_voices($bundle);
         $result["is_more_data"] = $this->is_more_data(sprintf($query, $uid, $next_start, $limit));
         $result["status"] = $voices["status"];
         $result["message"] = $voices["message"];
         $result["is_data"] = $voices["is_data"];
         $result["data"] = $voices["data"];
     } else {
         $result["status"] = false;
         $result["message"] = "User ID is not valid";
     }
     // return result with info
     return $result;
 }
Exemplo n.º 2
0
 public function get_feeds($bundle = array())
 {
     // set return result
     $result = array("status" => true, "message" => "", "is_data" => false, "is_more_data" => false, "data" => array());
     $start = c_pick_param($bundle, "start", 0);
     $limit = c_pick_param($bundle, "limit", 10);
     // calculate start
     $next_start = ($start + 1) * $limit;
     $start = $start * $limit;
     $query = "\n                SELECT \n\n                voices.`id` AS id, \n                voices.`user_id` AS user_id, \n                voices.`voice_cat_id` AS cat_id,\n                voices.`voice_tag_ids` AS tag_ids,\n                voices.`question_text` AS title,\n                voices.`voice_details` AS details,\n                voices.`voice_pic` AS eco_pic,\n                voices.`is_blocked` AS is_blocked,\n                voices.`added_on` AS created_on,\n                'voice' AS data_type\n                \n                FROM user_voices AS voices\n                WHERE voices.`is_blocked`=0\n                \n                UNION \n                SELECT \n                \n                streams.`id` AS id, \n                streams.`user_id` AS user_id,\n                streams.`voice_cat_id` AS cat_id,\n                streams.`voice_tag_ids` AS tag_ids,\n                streams.`question_text` AS title,\n                streams.`voice_details` AS details,\n                streams.`voice_pic` AS eco_pic,\n                streams.`is_blocked` AS is_blocked,\n                streams.`added_on` AS created_on,\n                'stream' AS data_type\n                \n                FROM streams_voice AS streams\n                WHERE streams.`is_blocked`=0\n                \n                UNION\n                SELECT\n                \n                eco.`id` AS id,\n                eco.`moderator_id` AS user_id,\n                eco.`voice_cat_id` AS cat_id,\n                eco.`voice_tag_ids` AS tag_ids,\n                eco.`title` AS title,\n                eco.`description` AS details,\n                eco.`eco_pic` AS eco_pic,\n                eco.`is_admin_blocked` AS is_blocked,\n                eco.`created_on` AS created_on,\n                CASE\n                  WHEN eco.`level`=1 THEN 'stream'\n                  WHEN eco.`level`=2 THEN 'river'\n                  WHEN eco.`level`=3 THEN 'ocean'\n                END\n                AS data_type\n                \n                FROM eco_system AS eco\n                \n                WHERE eco.`level`!=1\n                AND eco.`is_admin_blocked`=0\n                \n                ORDER BY created_on DESC\n                LIMIT %d, %d";
     $sql = sprintf($query, $start, $limit);
     $bundle = array("sql" => $sql);
     // get feeds
     $feeds = $this->get_voices($bundle);
     $result["is_more_data"] = $this->is_more_data(sprintf($query, $next_start, $limit));
     $result["status"] = $feeds["status"];
     $result["message"] = $feeds["message"];
     $result["is_data"] = $feeds["is_data"];
     $result["data"] = $feeds["data"];
     // return result with info
     return $result;
 }
 public function get_eco_comments($bundle = array())
 {
     // set return result
     $result = array("status" => true, "message" => "", "is_data" => false, "is_more_data" => false, "data" => array());
     $id = c_pick_param($bundle, "id", 0);
     $start = c_pick_param($bundle, "start", 0);
     $limit = c_pick_param($bundle, "limit", 10);
     if ($this->is_valid_river($id)) {
         // calculate start
         $next_start = ($start + 1) * $limit;
         $start = $start * $limit;
         $query = "SELECT * FROM eco_discussion_comments WHERE eco_sys_id=%d ORDER BY id DESC LIMIT %d, %d";
         $sql = sprintf($query, $id, $start, $limit);
         $bundle = array("sql" => $sql);
         // get comments
         $comments = $this->get_comments_data($bundle);
         $result["is_more_data"] = $this->is_more_data(sprintf($query, $id, $next_start, $limit));
         $result["status"] = $comments["status"];
         $result["message"] = $comments["message"];
         $result["is_data"] = $comments["is_data"];
         $result["data"] = $comments["data"];
     } else {
         $result['status'] = false;
         $result['message'] = "Invalid river id.";
     }
     // return result with info
     return $result;
 }
Exemplo n.º 4
0
 public function get_comments_data($bundle = array())
 {
     // set return result
     $result = array("status" => true, "message" => "", "is_data" => false, "data" => array());
     $sql = c_pick_param($bundle, "sql", "SELECT * FROM eco_discussion_comments");
     $query = $this->db->query($sql);
     // check query have data
     if ($query->num_rows() > 0) {
         $result["message"] = "Data successfully load.";
         $result["is_data"] = true;
         $result["data"] = $query->result_array();
     } else {
         $result["message"] = "There is no data available.";
     }
     // return result
     return $result;
 }