defined("BASEPATH") or die("No direct script access allowed"); class M_Leaderboard extends CI_Model { public function getTopLink($start_date) { $sql = "SELECT user_id, SUM(amount) as total_amount FROM link_history WHERE claim_time >= ? AND user_id <> 0 GROUP BY user_id ORDER BY total_amount DESC LIMIT 7"; $query = $this->db->query($sql, array($start_date)); return $query->result(); } public function getTopReferral($start_date) { $sql = "SELECT referred_by, COUNT(*) as total_referral FROM users WHERE registered_at >= ? AND referred_by IS NOT NULL AND referred_by <> 0 GROUP BY referred_by ORDER BY total_referral DESC LIMIT"; $query = $this->db->query($sql, array($start_date)); return $query->result(); } public function getTopActivity($start_date) { $sql = "SELECT user_id, SUM(amount) AS total_amount FROM (SELECT user_id, amount FROM autofaucet_history WHERE claim_time >= ? AND user_id <> UNION ALL SELECT user_id, amount FROM faucet_history WHERE claim_time >= ? AND user_id <> UNION ALL SELECT user_id, amount FROM link_history WHERE claim_time >= ? AND user_id <> 0 UNION ALL SELECT user_id, amount FROM offerwall_history WHERE claim_time >= ? AND user_id <> UNION ALL SELECT user_id, amount FROM ptc_history WHERE claim_time >= ? AND user_id <> 0 UNION ALL SELECT user_id, amount FROM task_history WHERE claim_time >= ? AND user_id <> 0) AS combined_history GROUP BY user_id ORDER BY total_amount DESC LIMIT"; $query = $this->db->query($sql, array($start_date, $start_date, $start_date, $start_date, $start_date, $start_date)); return $query->result(); } public function getTopFaucet($start_date) { $sql = "SELECT user_id, SUM(amount) AS total_amount 
                FROM faucet_history \xa                WHERE claim_time >= ? \xa                AND user_id <> 0 \xa                GROUP BY user_id \xa                ORDER BY total_amount DESC \xa                LIMIT"; $query = $this->db->query($sql, array($start_date)); return $query->result(); } }