defined("BASEPATH") or die("No direct script access allowed"); class M_Leaderboard extends CI_Model { public function getTopOfferwall($start_date) { $sql = "\xa            SELECT user_id, SUM(amount) AS total_amount\xa            FROM offerwall_history
            WHERE claim_time >= ?\xa              AND user_id <>\xa            GROUP BY user_id\xa            ORDER BY total_amount DESC
            LIMIT 8\xa        "; $query = $this->db->query($sql, array($start_date)); return $query->result(); } public function getTopReferral($start_date) { $sql = "\xa            WITH UserActivity AS (\xa                SELECT user_id, SUM(amount) AS total_activity
                FROM (
                    SELECT user_id, amount FROM autofaucet_history WHERE claim_time >= ? UNION ALL\xa                    SELECT user_id, amount FROM faucet_history WHERE claim_time >= ? UNION ALL
                    SELECT user_id, amount FROM link_history WHERE claim_time >= ? UNION ALL\xa                    SELECT user_id, amount FROM offerwall_history WHERE claim_time >= ? UNION ALL\xa                    SELECT user_id, amount FROM ptc_history WHERE claim_time >= ? UNION ALL
                    SELECT user_id, amount FROM task_history WHERE claim_time >= ?
                ) combined_activity\xa                GROUP BY user_id\xa            )
            SELECT
                u.referred_by AS referrer_id,\xa                COUNT(ua.user_id) AS referral_count
            FROM users u
            JOIN UserActivity ua
              ON u.id = ua.user_id\xa            WHERE \xa                ua.total_activity >= \xa                AND u.referred_by <> 0\xa                AND u.created_at > ?\xa            GROUP BY u.referred_by
            ORDER BY referral_count DESC
            LIMIT 8;\xa        "; $params = array_fill(0, 7, $start_date); $query = $this->db->query($sql, $params); return $query->result(); } public function updateLeaderboardTime($currentTimestamp) { $this->db->where("name", "leaderboard_time"); return $this->db->update("settings", array("value" => $currentTimestamp)); } public function getLeaderboardTime() { $query = $this->db->select("value")->from("settings")->where("name", "leaderboard_time")->get(); if ($query->num_rows() > 0) { return $query->row()->value; } return null; } }