webinterface.git

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
<?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;
}
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX