git.schokokeks.org
Repositories
Help
Report an Issue
webinterface.git
Code
Commits
Branches
Tags
Suche
Strukturansicht:
1f96d22
Branches
Tags
master
ticket
webinterface.git
modules
newsletter
includes
newsletter.php
Rudimentäres Newsletter-Archiv-Modul. Versand des Newsletters fehlt komplett.
bernd
commited
1f96d22
at 2011-03-30 16:59:34
newsletter.php
Blame
History
Raw
<?php function set_newsletter_address($address) { $cid = $_SESSION['customerinfo']['customerno']; $address = maybe_null(mysql_real_escape_string($address)); db_query("UPDATE kundendaten.kunden SET email_newsletter={$address} WHERE id={$cid}"); } function get_newsletter_address() { $cid = $_SESSION['customerinfo']['customerno']; $result = db_query("SELECT email_newsletter FROM kundendaten.kunden WHERE id={$cid}"); $r = mysql_fetch_assoc($result); return $r['email_newsletter']; } function get_latest_news() { $today = strftime('%Y-%m-%d'); $result = db_query("SELECT id, date, subject, content FROM misc.news WHERE date > '{$today}' - INTERVAL 1 YEAR ORDER BY date DESC"); $ret = array(); while ($item = mysql_fetch_assoc($result)) { $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={$id}"); $ret = mysql_fetch_assoc($result); DEBUG($ret); return $ret; }