/** * Returns a list of post items */ public static function getItems($raidshowNumber, $user_id) { // get a reference to the database $db = JFactory::getDBO(); // get a list of $raidshow_number ordered by start_time $query = "SELECT r.raid_id,r.location,r.start_time,s.confirmed,c.char_name,ro.role_name\n\t\t\t\t\tFROM `#__raidplanner_raid` AS r\n\t\t\t\t\tLEFT JOIN (`#__raidplanner_signups` AS s,`#__raidplanner_character` AS c) ON (s.raid_id = r.raid_id AND c.character_id = s.character_id AND c.profile_id = " . intval($user_id) . ")\n\t\t\t\t\tLEFT JOIN `#__raidplanner_role` AS ro ON ro.role_id = s.role_id\n\t\t\t\t\tWHERE DATE(DATE_ADD(start_time, INTERVAL " . intval(RaidPlannerHelper::getTimezone()) . " HOUR))>=NOW()\n\t\t\t\t\tGROUP BY r.raid_id\n\t\t\t\t\tORDER BY start_time ASC, location ASC LIMIT " . intval($raidshowNumber); $db->setQuery($query); $items = ($items = $db->loadObjectList()) ? $items : array(); return $items; }
/** * Returns a list of post items */ public static function getItems($user_id, $days = 1) { // get a reference to the database $db = JFactory::getDBO(); // get a list of raids ordered by start_time $query = "SELECT r.raid_id,r.location,r.start_time,s.confirmed,c.char_name,ro.role_name,(p.user_id = " . intval($user_id) . ") AS invited,(s.raid_id = r.raid_id) AS signed\r\n\t\t\t\t\tFROM `#__raidplanner_raid` AS r\r\n\t\t\t\t\tLEFT JOIN `#__user_usergroup_map` AS p ON p.group_id = r.invited_group_id AND p.user_id = " . intval($user_id) . "\r\n\t\t\t\t\tLEFT JOIN (`#__raidplanner_signups` AS s,`#__raidplanner_character` AS c) ON (s.raid_id = r.raid_id AND c.character_id = s.character_id AND c.profile_id = " . intval($user_id) . ")\r\n\t\t\t\t\tLEFT JOIN `#__raidplanner_role` AS ro ON ro.role_id = s.role_id\r\n\t\t\t\t\tWHERE DATE(DATE_ADD(start_time, INTERVAL " . intval(RaidPlannerHelper::getTimezone()) . " HOUR))>=DATE(NOW()) AND DATE(DATE_ADD(start_time, INTERVAL " . intval(RaidPlannerHelper::getTimezone()) . " HOUR))<DATE_ADD(DATE(NOW()), INTERVAL " . $days . " DAY) GROUP BY r.raid_id ORDER BY start_time ASC, location ASC"; $db->setQuery($query); $items = ($items = $db->loadObjectList()) ? $items : array(); return $items; }