/**
* Saves an event, or create a new one
**/
function saveEvent()
{
$raid_id = JRequest::getVar('raid_id', null, 'INT');
if (!$this->userIsOfficer($raid_id)) {
return false;
}
$user = JFactory::getUser();
$user_id = $user->id;
$db = JFactory::getDBO();
if ($raid_id == -1) {
// insert an empty record first
$query = "INSERT INTO #__raidplanner_raid (profile_id) VALUES (" . $user_id . ")";
$db->setQuery($query);
$db->query();
$raid_id = $db->insertid();
}
$location = JRequest::getVar('location', null, 'default', 'STRING');
$description = JRequest::getVar('description', null, 'default', 'STRING');
$start_time = RaidPlannerHelper::getDate(implode(" ", JRequest::getVar('start_time', null, 'default', 'ARRAY')));
$duration_mins = JRequest::getVar('duration_mins', 0, 'default', 'INT');
$invite_time = RaidPlannerHelper::getDate(implode(" ", JRequest::getVar('invite_time', null, 'default', 'ARRAY')));
$freeze_time = JRequest::getVar('freeze_time', null, 'default', 'INT');
$minimum_level = JRequest::getVar('minimum_level', null, 'default', 'INT');
$maximum_level = JRequest::getVar('maximum_level', null, 'default', 'INT');
$minimum_rank = JRequest::getVar('minimum_rank', null, 'default', 'INT');
$icon_name = JRequest::getVar('icon_name', null, 'default', 'STRING');
$guild_id = JRequest::getVar('guild_id', null, 'default', 'INT');
$invited_group_id = JRequest::getVar('invited_group_id', null, 'default', 'INT');
// update the record
$query = "UPDATE #__raidplanner_raid SET" . " location=" . $db->Quote($location) . ",description=" . $db->Quote($description) . ",raid_leader=" . $db->Quote($user->name) . ",invite_time='" . RaidPlannerHelper::date2Sql($invite_time) . "'" . ",start_time='" . RaidPlannerHelper::date2Sql($start_time) . "'" . ",duration_mins=" . intval($duration_mins) . ",freeze_time=" . intval($freeze_time) . ",profile_id=" . intval($user_id) . ",icon_name=" . $db->Quote($icon_name) . ",minimum_level=" . ($minimum_level == '' ? "NULL" : intval($minimum_level)) . ",maximum_level=" . ($maximum_level == '' ? "NULL" : intval($maximum_level)) . ",minimum_rank=" . ($minimum_rank == '' ? "NULL" : intval($minimum_rank)) . ",guild_id=" . ($guild_id == '' ? "NULL" : intval($guild_id)) . ",invited_group_id=" . ($invited_group_id == '' ? "NULL" : intval($invited_group_id)) . " WHERE raid_id=" . intval($raid_id);
$db->setQuery($query);
$db->query();
$query = "UPDATE #__raidplanner_raid SET" . " raid_leader=" . $db->Quote($user->name) . " WHERE raid_id=" . intval($raid_id) . " AND raid_leader=''";
$db->setQuery($query);
$db->query();
return $raid_id;
}
