/** * 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; }