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
39
40
41
42
43
44
45
46
47
48
49
50
51
<?php
require_once('inc/db_connect.php');
require_once('mail.php');
function customer_with_email($email)
{
  $email = mysql_real_escape_string($email);
  $result = db_query("SELECT id FROM kundendaten.kunden WHERE email='{$email}' OR email_rechnung='{$email}' OR email_extern='{$email}' LIMIT 1;");
  if (mysql_num_rows($result) == 0)
    return NULL;
  else
    return mysql_fetch_object($result)->id;
}
function create_customer($data)
{
  if (customer_with_email($data['email']) !== NULL)
  {
    logger(LOG_WARNING, 'modules/register/include/register', 'register', "Attempt to create customer with duplicate email »{$data['email']}«");
    return NULL;
  }
  $anrede = mysql_escape_string($data['anrede']);
  $firma = mysql_escape_string($data['firma']);
  $vorname = mysql_escape_string($data['vorname']);
  $nachname = mysql_escape_string($data['nachname']);
  $email = mysql_escape_string($data['email']);
  logger(LOG_INFO, 'modules/register/include/register', 'register', "Creating new account: {$anrede} / {$firma} / {$vorname} / {$nachname} / {$email}");
  
  $anrede = maybe_null($anrede);
  $firma = maybe_null($firma);
  $vorname = maybe_null($vorname);
  $nachname = maybe_null($nachname);
  db_query("BEGIN");
  db_query("INSERT INTO kundendaten.kunden (firma, nachname, vorname, anrede, email, erstellungsdatum,status) VALUES ({$firma}, {$nachname}, {$vorname}, {$anrede}, {$email}, CURDATE(), 3)");
  $customerno = mysql_insert_id();
  db_query("COMMIT");
  return $customerno;
}
function send_initial_customer_token($customerno)
{
  $customerno = (int) $customerno;
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX