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 <> 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 7";
		 $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 <>) AS combined_history GROUP BY user_id ORDER BY total_amount DESC LIMIT 7";
		 $query = $this->db->query($sql, array($start_date, $start_date, $start_date, $start_date, $start_date, $start_date));
		 return $query->result();
		 
	}
	 
}