<?php
function set_newsletter_address($address) {
$cid = $_SESSION['customerinfo']['customerno'];
db_query("UPDATE kundendaten.kunden SET email_newsletter=:address WHERE id=:cid", array(":address" => $address, ":cid" => $cid));
}
function get_newsletter_address() {
$cid = $_SESSION['customerinfo']['customerno'];
$result = db_query("SELECT email_newsletter FROM kundendaten.kunden WHERE id=?", array($cid));
$r = $result->fetch();
return $r['email_newsletter'];
}
function get_latest_news() {
$result = db_query("SELECT id, date, subject, content FROM misc.news WHERE date > CURDATE() - INTERVAL 2 YEAR ORDER BY date DESC");
$ret = array();
while ($item = $result->fetch()) {
$ret[] = $item;
}
DEBUG($ret);
return $ret;
}
function get_news_item($id) {
$id = (int) $id;
$result = db_query("SELECT date, subject, content FROM misc.news WHERE id=?", array($id));
$ret = $result->fetch();
DEBUG($ret);
return $ret;
}