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