/**
* Save changes to a group
*
* @param mixed $groupid
* @param mixed $groupname
* @param mixed $permissions
* @return
*/
public static function editGroup($groupid, $groupname, $permissions)
{
$groupid = intval($groupid);
$groupname = DB::escape($groupname);
$sql = 'UPDATE ' . TABLE_PREFIX . "groups\n\t\t\t\tSET `name`='{$groupname}', `permissions`={$permissions}\n\t\t\t\tWHERE `groupid`={$groupid}";
$res = DB::query($sql);
if (DB::errno() != 0) {
return false;
}
CodonCache::delete('all_groups');
return true;
}
public static function deleteField($id)
{
$sql = 'DELETE FROM ' . TABLE_PREFIX . 'customfields WHERE `fieldid`=' . $id;
$res = DB::query($sql);
$sql = 'DELETE FROM ' . TABLE_PREFIX . 'fieldvalues WHERE `fieldid`=' . $id;
$res = DB::query($sql);
CodonCache::delete('allfields');
}
public static function removeAirport($icao)
{
$icao = DB::escape($icao);
$icao = strtoupper($icao);
$sql = "DELETE FROM " . TABLE_PREFIX . "airports WHERE `icao`='{$icao}'";
$res = DB::query($sql);
if (DB::errno() != 0) {
return false;
}
CodonCache::delete('get_airport_' . $icao);
CodonCache::delete('all_airports_json');
CodonCache::delete('all_airports');
return true;
}
/**
* Delete a rank, and then recalculate
*/
public static function deleteRank($rankid)
{
$sql = 'DELETE FROM ' . TABLE_PREFIX . 'ranks
WHERE rankid=' . $rankid;
DB::query($sql);
if (DB::errno() != 0) {
return false;
}
CodonCache::delete('all_ranks');
self::CalculatePilotRanks();
return true;
}
