/** * Slett søknad * @param integer $ds_id * @param boolean $force slette selv om den er behandlet */ public static function delete($ds_id, $force = false) { global $_base; $ds_id = (int) $ds_id; $where = $force ? '' : ' AND ds_reply_decision = 0'; // slett søknaden $a = \Kofradia\DB::get()->exec("DELETE FROM div_soknader WHERE ds_id = {$ds_id}{$where}"); if ($a == 0) { return false; } // oppdater cache tasks::set("soknader", \Kofradia\DB::get()->query("SELECT COUNT(ds_id) FROM div_soknader WHERE ds_reply_decision = 0")->fetchColumn(0)); return true; }
// opprette svar? $preview = false; if (isset($_POST['reply']) && (isset($_POST['add']) || isset($_POST['preview']))) { $content = trim(postval("content")); if (mb_strlen($content) == 0) { $_base->page->add_message("Mangler innhold.", "error"); } elseif (isset($_POST['preview'])) { $preview = true; $_base->page->add_message("Viser forhåndsvisning"); } else { \Kofradia\DB::get()->exec("INSERT INTO henvendelser_messages SET hm_h_id = {$h_id}, hm_time = " . time() . ", hm_ip = " . \Kofradia\DB::quote($_SERVER['REMOTE_ADDR']) . ", hm_up_id = " . (login::$logged_in ? login::$user->player->id : "NULL") . ", hm_browser = " . \Kofradia\DB::quote($_SERVER['HTTP_USER_AGENT']) . ", hm_content = " . \Kofradia\DB::quote($content)); $_base->page->add_message("Meldingen ble lagt til."); // oppdatere henvendelsen \Kofradia\DB::get()->exec("UPDATE henvendelser SET h_status = 0, h_hm_time = " . time() . " WHERE h_id = {$h_id}"); // oppdater cache tasks::set("henvendelser", \Kofradia\DB::get()->query("SELECT COUNT(h_id) FROM henvendelser WHERE h_status = 0")->fetchColumn(0)); // send e-post til henrik $mail = new email(); $mail->text = "Ny melding i henvendelse:\n\nNavn: {$h['h_name']}\nE-post: {$h['h_email']}\nTidspunkt: " . $_base->date->get()->format(date::FORMAT_SEC) . "\n\nIP-adresse: {$_SERVER['REMOTE_ADDR']}\nNettleser: {$_SERVER['HTTP_USER_AGENT']}\n\nDirektelink: {$__server['path']}/henvendelser?a&h_id={$h_id}\n\nKategori: {$h['h_category']}\nEmne: {$h['h_subject']}\n\n------\n{$content}\n------"; $mail->send("*****@*****.**", "Ny melding i henvendelse mottatt - {$h['h_category']}: {$h['h_subject']}"); redirect::handle("henvendelser?h_id={$h_id}"); } } // hent alle meldingene $result = \Kofradia\DB::get()->query("SELECT hm_time, hm_ip, hm_browser, hm_content, hm_crew FROM henvendelser_messages WHERE hm_h_id = {$h_id} AND hm_type = 0 ORDER BY hm_time"); echo ' <p class="h_info"><span class="h_title">' . htmlspecialchars($h['h_category']) . ': ' . htmlspecialchars($h['h_subject']) . '</span> ' . $status['other'][$h['h_status']] . '</p> <div class="henvendelser_meldinger">'; // forhåndsvisning? $preview_row = false; if ($preview) {
/** Oppdater cache */ public static function update_tasks() { tasks::set("support", \Kofradia\DB::get()->query("SELECT COUNT(su_id) FROM support WHERE su_solved = 0")->fetchColumn(0)); }