webinterface.git

modules/vmail/include/vmail.php   1) <?php
modules/vmail/include/vmail.php   2) require_once('inc/base.php');
modules/vmail/include/vmail.php   3) require_once('inc/debug.php');
modules/vmail/include/vmail.php   4) 

modules/vmail/include/vmail.php   5) require_once('hasdomain.php');

modules/vmail/include/vmail.php   6) 

modules/email/include/vmail.php   7) require_once('common.php');
modules/email/include/vmail.php   8) 

modules/vmail/include/vmail.php   9) function empty_account()
modules/vmail/include/vmail.php  10) {
modules/vmail/include/vmail.php  11) 	$account = array(
modules/vmail/include/vmail.php  12) 		'id' => NULL,
modules/vmail/include/vmail.php  13) 		'local' => '',
modules/vmail/include/vmail.php  14) 		'domain' => NULL,

modules/vmail/include/vmail.php  15) 		'password' => NULL,

modules/vmail/include/vmail.php  16) 		'spamfilter' => 'folder',

modules/vmail/include/vmail.php  17) 		'spamexpire' => 7,

modules/email/include/vmail.php  18)     'quota' => config('vmail_basequota'),

modules/email/include/vmail.php  19)     'quota_threshold' => 20,

modules/email/include/vmail.php  20) 		'forwards' => array(),
modules/email/include/vmail.php  21) 		'autoresponder' => NULL

modules/vmail/include/vmail.php  22) 		);
modules/vmail/include/vmail.php  23) 	return $account;
modules/vmail/include/vmail.php  24) 
modules/vmail/include/vmail.php  25) }
modules/vmail/include/vmail.php  26) 

modules/email/include/vmail.php  27) function empty_autoresponder_config()
modules/email/include/vmail.php  28) {
modules/email/include/vmail.php  29)   $ar = array(
modules/email/include/vmail.php  30)     'valid_from' => date( 'Y-m-d H:i:s' ),
modules/email/include/vmail.php  31)     'valid_until' => NULL,
modules/email/include/vmail.php  32)     'fromname' => NULL,
modules/email/include/vmail.php  33)     'fromaddr' => NULL,
modules/email/include/vmail.php  34)     'subject' => NULL,
modules/email/include/vmail.php  35)     'message' => 'Danke für Ihre E-Mail.
modules/email/include/vmail.php  36) Ich bin aktuell nicht im Büro und werde Ihre Nachricht erst nach meiner Rückkehr beantworten.
modules/email/include/vmail.php  37) Ihre E-Mail wird nicht weitergeleitet.',
modules/email/include/vmail.php  38)     'quote' => NULL
modules/email/include/vmail.php  39)     );
modules/email/include/vmail.php  40)   return $ar;
modules/email/include/vmail.php  41) }
modules/email/include/vmail.php  42) 
modules/email/include/vmail.php  43) 

modules/email/include/vmail.php  44) function get_vmail_id_by_emailaddr($emailaddr) 
modules/email/include/vmail.php  45) {
modules/email/include/vmail.php  46)   $emailaddr = mysql_real_escape_string( $emailaddr );
modules/email/include/vmail.php  47)   $result = db_query("SELECT id FROM mail.v_vmail_accounts WHERE CONCAT(local, '@', domainname) = '{$emailaddr}'");
modules/email/include/vmail.php  48)   $entry = mysql_fetch_assoc($result);
modules/email/include/vmail.php  49)   return (int) $entry['id'];
modules/email/include/vmail.php  50) }
modules/email/include/vmail.php  51) 

modules/vmail/include/vmail.php  52) function get_account_details($id, $checkuid = true)

modules/vmail/include/vmail.php  53) {
modules/vmail/include/vmail.php  54) 	$id = (int) $id;

modules/email/include/vmail.php  55)   $uid_check = '';
modules/email/include/vmail.php  56)   DEBUG("checkuid: ".$checkuid);
modules/email/include/vmail.php  57)   if ($checkuid) {
modules/email/include/vmail.php  58)     $uid = (int) $_SESSION['userinfo']['uid'];
modules/email/include/vmail.php  59)     $uid_check = "useraccount='{$uid}' AND ";
modules/email/include/vmail.php  60)   }
modules/email/include/vmail.php  61)   $result = db_query("SELECT id, local, domain, password, spamfilter, forwards, autoresponder, server, quota, COALESCE(quota_used, 0) AS quota_used, quota_threshold from mail.v_vmail_accounts WHERE {$uid_check}id={$id} LIMIT 1");

modules/vmail/include/vmail.php  62) 	if (mysql_num_rows($result) == 0)
modules/vmail/include/vmail.php  63) 		system_failure('Ungültige ID oder kein eigener Account');

modules/vmail/include/vmail.php  64) 	$acc = empty_account();
modules/vmail/include/vmail.php  65) 	$res = mysql_fetch_assoc($result);
modules/vmail/include/vmail.php  66) 	foreach ($res AS $key => $value) {
modules/vmail/include/vmail.php  67) 	  if ($key == 'forwards')
modules/vmail/include/vmail.php  68) 	    continue;
modules/vmail/include/vmail.php  69) 	  $acc[$key] = $value;
modules/vmail/include/vmail.php  70) 	}
modules/vmail/include/vmail.php  71) 	if ($acc['forwards'] > 0) {
modules/vmail/include/vmail.php  72) 	  $result = db_query("SELECT id, spamfilter, destination FROM mail.vmail_forward WHERE account={$acc['id']};");
modules/vmail/include/vmail.php  73) 	  while ($item = mysql_fetch_assoc($result)){
modules/vmail/include/vmail.php  74) 	    array_push($acc['forwards'], array("id" => $item['id'], 'spamfilter' => $item['spamfilter'], 'destination' => $item['destination']));
modules/vmail/include/vmail.php  75) 	  }
modules/vmail/include/vmail.php  76) 	}

modules/email/include/vmail.php  77)   if ($acc['autoresponder'] > 0) {
modules/email/include/vmail.php  78)     $result = db_query("SELECT id, IF(valid_from IS NULL OR valid_from > NOW() OR valid_until < NOW(), 0, 1) AS active, valid_from, valid_until, fromname, fromaddr, subject, message, quote FROM mail.vmail_autoresponder WHERE account={$acc['id']}");
modules/email/include/vmail.php  79)     $item = mysql_fetch_assoc($result);
modules/email/include/vmail.php  80)     DEBUG($item);
modules/email/include/vmail.php  81)     $acc['autoresponder'] = $item;
modules/email/include/vmail.php  82)   } else {
modules/email/include/vmail.php  83)     $acc['autoresponder'] = NULL;
modules/email/include/vmail.php  84)   }

modules/email/include/vmail.php  85)   if ($acc['quota_threshold'] === NULL) {
modules/email/include/vmail.php  86)     $acc['quota_threshold'] = -1;
modules/email/include/vmail.php  87)   }

modules/vmail/include/vmail.php  88) 	return $acc;

modules/vmail/include/vmail.php  89) }
modules/vmail/include/vmail.php  90) 
modules/vmail/include/vmail.php  91) function get_vmail_accounts()
modules/vmail/include/vmail.php  92) {
modules/vmail/include/vmail.php  93) 	$uid = (int) $_SESSION['userinfo']['uid'];

modules/email/include/vmail.php  94) 	$result = db_query("SELECT * from mail.v_vmail_accounts WHERE useraccount='{$uid}' ORDER BY domainname,local ASC");

modules/vmail/include/vmail.php  95) 	$ret = array();
modules/vmail/include/vmail.php  96) 	while ($line = mysql_fetch_assoc($result))
modules/vmail/include/vmail.php  97) 	{
modules/vmail/include/vmail.php  98) 		array_push($ret, $line);
modules/vmail/include/vmail.php  99) 	}
modules/vmail/include/vmail.php 100) 	DEBUG($ret);
modules/vmail/include/vmail.php 101) 	return $ret;
modules/vmail/include/vmail.php 102) }
modules/vmail/include/vmail.php 103) 
modules/vmail/include/vmail.php 104) 
modules/vmail/include/vmail.php 105) 
modules/vmail/include/vmail.php 106) function get_vmail_domains()
modules/vmail/include/vmail.php 107) {
modules/vmail/include/vmail.php 108) 	$uid = (int) $_SESSION['userinfo']['uid'];

modules/email/include/vmail.php 109) 	$result = db_query("SELECT id, domainname, server FROM mail.v_vmail_domains WHERE useraccount='{$uid}'");

modules/vmail/include/vmail.php 110) 	if (mysql_num_rows($result) == 0)
modules/vmail/include/vmail.php 111) 		system_failure('Sie haben keine Domains für virtuelle Mail-Verarbeitung');
modules/vmail/include/vmail.php 112) 	$ret = array();
modules/vmail/include/vmail.php 113) 	while ($tmp = mysql_fetch_object($result))
modules/vmail/include/vmail.php 114) 		array_push($ret, $tmp);
modules/vmail/include/vmail.php 115) 	return $ret;
modules/vmail/include/vmail.php 116) }
modules/vmail/include/vmail.php 117) 
modules/vmail/include/vmail.php 118) 

modules/vmail/include/vmail.php 119) function find_account_id($accname)
modules/vmail/include/vmail.php 120) {
modules/vmail/include/vmail.php 121)   $accname = mysql_real_escape_string($accname);
modules/vmail/include/vmail.php 122)   DEBUG($accname);
modules/vmail/include/vmail.php 123)   $tmp = explode('@', $accname, 2);
modules/vmail/include/vmail.php 124)   DEBUG($tmp);
modules/vmail/include/vmail.php 125)   if (count($tmp) != 2)
modules/vmail/include/vmail.php 126)     system_failure("Der Account hat nicht die korrekte Syntax");
modules/vmail/include/vmail.php 127)   list( $local, $domainname) = $tmp;
modules/vmail/include/vmail.php 128) 
modules/vmail/include/vmail.php 129)   $result = db_query("SELECT id FROM mail.v_vmail_accounts WHERE local='{$local}' AND domainname='{$domainname}' LIMIT 1");
modules/vmail/include/vmail.php 130)   if (mysql_num_rows($result) == 0)
modules/vmail/include/vmail.php 131)     system_failure("Der Account konnte nicht gefunden werden");
modules/vmail/include/vmail.php 132)   $tmp = mysql_fetch_array($result);
modules/vmail/include/vmail.php 133)   return $tmp[0];
modules/vmail/include/vmail.php 134) }
modules/vmail/include/vmail.php 135) 
modules/vmail/include/vmail.php 136) 
modules/vmail/include/vmail.php 137) function change_vmail_password($accname, $newpass)
modules/vmail/include/vmail.php 138) {
modules/vmail/include/vmail.php 139)   $accid = find_account_id($accname);
modules/vmail/include/vmail.php 140)   $encpw = mysql_real_escape_string(encrypt_mail_password($newpass));
modules/vmail/include/vmail.php 141)   db_query("UPDATE mail.vmail_accounts SET password='{$encpw}' WHERE id={$accid} LIMIT 1;");
modules/vmail/include/vmail.php 142) }
modules/vmail/include/vmail.php 143) 

modules/vmail/include/vmail.php 144) 
modules/vmail/include/vmail.php 145) function domainselect($selected = NULL, $selectattribute = '')
modules/vmail/include/vmail.php 146) {

modules/vmail/include/vmail.php 147)   $domainlist = get_vmail_domains();

modules/vmail/include/vmail.php 148)   $selected = (int) $selected;
modules/vmail/include/vmail.php 149) 
modules/vmail/include/vmail.php 150)   $ret = '<select id="domain" name="domain" size="1" '.$selectattribute.' >';
modules/vmail/include/vmail.php 151)   foreach ($domainlist as $dom)
modules/vmail/include/vmail.php 152)   {
modules/vmail/include/vmail.php 153)     $s = ($selected == $dom->id) ? ' selected="selected" ': '';
modules/vmail/include/vmail.php 154)     $ret .= "<option value=\"{$dom->id}\"{$s}>{$dom->domainname}</option>\n";
modules/vmail/include/vmail.php 155)   }
modules/vmail/include/vmail.php 156)   $ret .= '</select>';
modules/vmail/include/vmail.php 157)   return $ret;
modules/vmail/include/vmail.php 158) }
modules/vmail/include/vmail.php 159) 
modules/vmail/include/vmail.php 160) 

modules/email/include/vmail.php 161) function get_max_mailboxquota($server, $oldquota) {
modules/email/include/vmail.php 162)   $uid = (int) $_SESSION['userinfo']['uid'];
modules/email/include/vmail.php 163)   $server = (int) $server;
modules/email/include/vmail.php 164)   $result = db_query("SELECT systemquota - (systemquota_used + mailquota) AS free FROM system.v_quota WHERE uid='{$uid}' AND server='{$server}'");
modules/email/include/vmail.php 165)   $item = mysql_fetch_assoc($result);
modules/email/include/vmail.php 166)   DEBUG("Free space: ".$item['free']." / Really: ".($item['free'] + ($oldquota - config('vmail_basequota'))));
modules/email/include/vmail.php 167)   return $item['free'] + ($oldquota - config('vmail_basequota'));
modules/email/include/vmail.php 168) }
modules/email/include/vmail.php 169) 
modules/email/include/vmail.php 170) 

modules/vmail/include/vmail.php 171) 
modules/vmail/include/vmail.php 172) 
modules/vmail/include/vmail.php 173) function save_vmail_account($account)
modules/vmail/include/vmail.php 174) {

modules/email/include/vmail.php 175)   $accountlogin = ($_SESSION['role'] == ROLE_VMAIL_ACCOUNT);

modules/vmail/include/vmail.php 176)   $id = $account['id'];
modules/vmail/include/vmail.php 177)   if ($id != NULL)
modules/vmail/include/vmail.php 178)   {
modules/vmail/include/vmail.php 179)     $id = (int) $id;

modules/email/include/vmail.php 180)     $oldaccount = get_account_details($id, !$accountlogin);

modules/vmail/include/vmail.php 181)     // Erzeugt einen system_error() wenn ID ungültig
modules/vmail/include/vmail.php 182)   }
modules/vmail/include/vmail.php 183)   // Ab hier ist $id sicher, entweder NULL oder eine gültige ID des aktuellen users

modules/email/include/vmail.php 184) 

modules/email/include/vmail.php 185)   $newaccount = false;
modules/email/include/vmail.php 186)   if ($id === NULL) {
modules/email/include/vmail.php 187)     $newaccount = true;
modules/email/include/vmail.php 188)   }

modules/email/include/vmail.php 189) 
modules/email/include/vmail.php 190)   if ($accountlogin) {
modules/email/include/vmail.php 191)     if ($account['domain'] != $oldaccount['domain'])
modules/email/include/vmail.php 192)       system_failure('Sie können die E-Mail-Adresse nicht ändern!');
modules/email/include/vmail.php 193)     if ($account['local'] != $oldaccount['local'])
modules/email/include/vmail.php 194)       system_failure('Sie können die E-Mail-Adresse nicht ändern!');
modules/email/include/vmail.php 195)     if ($account['quota'] != $oldaccount['quota'])
modules/email/include/vmail.php 196)       system_failure('Sie können Ihren eigenen Speicherplatz nicht verändern.');
modules/email/include/vmail.php 197)   } else {
modules/email/include/vmail.php 198)   
modules/email/include/vmail.php 199)     $account['local'] = filter_input_username($account['local']);
modules/email/include/vmail.php 200)     if ($account['local'] == '')

modules/vmail/include/vmail.php 201)     {

modules/email/include/vmail.php 202)       system_failure('Die E-Mail-Adresse braucht eine Angabe vor dem »@«!');
modules/email/include/vmail.php 203)       return false;
modules/email/include/vmail.php 204)     }
modules/email/include/vmail.php 205)     $account['domain'] = (int) $account['domain'];
modules/email/include/vmail.php 206)     $domainlist = get_vmail_domains();
modules/email/include/vmail.php 207)     $valid_domain = false;
modules/email/include/vmail.php 208)     $domainname = NULL;
modules/email/include/vmail.php 209)     $server = NULL;
modules/email/include/vmail.php 210)     foreach ($domainlist as $dom)
modules/email/include/vmail.php 211)     {
modules/email/include/vmail.php 212)       if ($dom->id == $account['domain'])
modules/email/include/vmail.php 213)       {
modules/email/include/vmail.php 214)         $domainname = $dom->domainname;
modules/email/include/vmail.php 215)         $server = $dom->server;
modules/email/include/vmail.php 216)         $valid_domain = true;
modules/email/include/vmail.php 217)         break;
modules/email/include/vmail.php 218)       }
modules/email/include/vmail.php 219)     }
modules/email/include/vmail.php 220)     if (($account['domain'] == 0) || (! $valid_domain))
modules/email/include/vmail.php 221)     {
modules/email/include/vmail.php 222)       system_failure('Bitte wählen Sie eine Ihrer Domains aus!');
modules/email/include/vmail.php 223)       return false;

modules/vmail/include/vmail.php 224)     }
modules/vmail/include/vmail.php 225)   }

modules/vmail/include/vmail.php 226)   
modules/vmail/include/vmail.php 227)   $forwards = array();
modules/vmail/include/vmail.php 228)   if (count($account['forwards']) > 0) 

modules/vmail/include/vmail.php 229)   {

modules/vmail/include/vmail.php 230)     for ($i=0;$i < count($account['forwards']); $i++)
modules/vmail/include/vmail.php 231)     {
modules/vmail/include/vmail.php 232)       if ($account['forwards'][$i]['spamfilter'] != 'tag' && $account['forwards'][$i]['spamfilter'] != 'delete')
modules/vmail/include/vmail.php 233)         $account['forwards'][$i]['spamfilter'] = '';
modules/vmail/include/vmail.php 234)       $account['forwards'][$i]['destination'] = filter_input_general($account['forwards'][$i]['destination']);
modules/vmail/include/vmail.php 235)       if (! check_emailaddr($account['forwards'][$i]['destination']))
modules/vmail/include/vmail.php 236)         system_failure('Das Weiterleitungs-Ziel »'.$account['forwards'][$i]['destination'].'« ist keine E-Mail-Adresse!');
modules/vmail/include/vmail.php 237)     }

modules/vmail/include/vmail.php 238)   }

modules/email/include/vmail.php 239) 

modules/email/include/vmail.php 240)   if ($accountlogin) {
modules/email/include/vmail.php 241)     $password = NULL; 
modules/email/include/vmail.php 242)     $set_password = false;
modules/email/include/vmail.php 243)   } else {
modules/email/include/vmail.php 244)     $password='NULL';
modules/email/include/vmail.php 245)     if ($account['password'] != '')

modules/vmail/include/vmail.php 246)     {

modules/email/include/vmail.php 247)       $account['password'] = stripslashes($account['password']);
modules/email/include/vmail.php 248)       $crack = strong_password($account['password']);
modules/email/include/vmail.php 249)       if ($crack !== true)
modules/email/include/vmail.php 250)       {
modules/email/include/vmail.php 251)         system_failure('Ihr Passwort ist zu einfach. bitte wählen Sie ein sicheres Passwort!'."\nDie Fehlermeldung lautet: »{$crack}«");
modules/email/include/vmail.php 252)         return false;
modules/email/include/vmail.php 253)       }
modules/email/include/vmail.php 254)       $password = "'".encrypt_mail_password($account['password'])."'";

modules/vmail/include/vmail.php 255)     }

modules/email/include/vmail.php 256)     $set_password = ($id == NULL || $password != 'NULL');
modules/email/include/vmail.php 257)     if ($account['password'] === NULL)
modules/email/include/vmail.php 258)       $set_password=true;
modules/email/include/vmail.php 259)   }  

modules/vmail/include/vmail.php 260) 
modules/vmail/include/vmail.php 261)   $spam = 'NULL';
modules/vmail/include/vmail.php 262)   switch ($account['spamfilter'])
modules/vmail/include/vmail.php 263)   {
modules/vmail/include/vmail.php 264)     case 'folder':
modules/vmail/include/vmail.php 265)       $spam = "'folder'";
modules/vmail/include/vmail.php 266)       break;
modules/vmail/include/vmail.php 267)     case 'tag':
modules/vmail/include/vmail.php 268)       $spam = "'tag'";
modules/vmail/include/vmail.php 269)       break;
modules/vmail/include/vmail.php 270)     case 'delete':
modules/vmail/include/vmail.php 271)       $spam = "'delete'";
modules/vmail/include/vmail.php 272)       break;
modules/vmail/include/vmail.php 273)   }

modules/email/include/vmail.php 274)   

modules/email/include/vmail.php 275)   if (!$accountlogin) {
modules/email/include/vmail.php 276)     $free = config('vmail_basequota');
modules/email/include/vmail.php 277)     if ($newaccount) {
modules/email/include/vmail.php 278)       // Neues Postfach
modules/email/include/vmail.php 279)       $free = get_max_mailboxquota($server, config('vmail_basequota'));
modules/email/include/vmail.php 280)     } else {
modules/email/include/vmail.php 281)       $free = get_max_mailboxquota($oldaccount['server'], $oldaccount['quota']);
modules/email/include/vmail.php 282)     }

modules/email/include/vmail.php 283)   

modules/email/include/vmail.php 284)     $newquota = max((int) config('vmail_basequota'), (int) $account['quota']);
modules/email/include/vmail.php 285)     if ($newquota > config('vmail_basequota') && $newquota > ($free+config('vmail_basequota'))) {
modules/email/include/vmail.php 286)       $newquota = $free + config('vmail_basequota');
modules/email/include/vmail.php 287)       warning("Ihr Speicherplatz reicht für diese Postfach-Größe nicht mehr aus. Ihr Postfach wurde auf {$newquota} MB reduziert. Bitte beachten Sie, dass damit Ihr Benutzerkonto keinen freien Speicherplatz mehr aufweist!");
modules/email/include/vmail.php 288)     }

modules/email/include/vmail.php 289)   

modules/email/include/vmail.php 290)     $account['quota'] = $newquota;
modules/email/include/vmail.php 291)   }  

modules/email/include/vmail.php 292) 

modules/email/include/vmail.php 293)   if ($account['quota_threshold'] == -1) {
modules/email/include/vmail.php 294)     $account['quota_threshold'] = 'NULL';
modules/email/include/vmail.php 295)   }
modules/email/include/vmail.php 296)   else {
modules/email/include/vmail.php 297)     $account['quota_threshold'] = min( (int) $account['quota_threshold'], (int) $account['quota'] );
modules/email/include/vmail.php 298)   }
modules/email/include/vmail.php 299)   

modules/vmail/include/vmail.php 300)   $account['local'] = mysql_real_escape_string($account['local']);

modules/vmail/include/vmail.php 301)   $account['password'] = mysql_real_escape_string($account['password']);

modules/vmail/include/vmail.php 302)   $account['spamexpire'] = (int) $account['spamexpire'];
modules/vmail/include/vmail.php 303) 
modules/vmail/include/vmail.php 304)   $query = '';

modules/email/include/vmail.php 305)   if ($newaccount)

modules/vmail/include/vmail.php 306)   {

modules/email/include/vmail.php 307)     $query = "INSERT INTO mail.vmail_accounts (local, domain, spamfilter, spamexpire, password, quota, quota_threshold) VALUES ";
modules/email/include/vmail.php 308)     $query .= "('{$account['local']}', {$account['domain']}, {$spam}, {$account['spamexpire']}, {$password}, {$account['quota']}, {$account['quota_threshold']});";

modules/email/include/vmail.php 309)     db_query($query); 

modules/email/include/vmail.php 310)     $id = mysql_insert_id();

modules/vmail/include/vmail.php 311)   }
modules/vmail/include/vmail.php 312)   else
modules/vmail/include/vmail.php 313)   {

modules/vmail/include/vmail.php 314)     if ($set_password)
modules/vmail/include/vmail.php 315)       $password=", password={$password}";
modules/vmail/include/vmail.php 316)     else
modules/vmail/include/vmail.php 317)       $password='';
modules/vmail/include/vmail.php 318)     $query = "UPDATE mail.vmail_accounts SET local='{$account['local']}', domain={$account['domain']}{$password}, ";

modules/email/include/vmail.php 319)     $query .= "spamfilter={$spam}, spamexpire={$account['spamexpire']}, quota={$account['quota']}, quota_threshold={$account['quota_threshold']} ";

modules/vmail/include/vmail.php 320)     $query .= "WHERE id={$id} LIMIT 1;";

modules/email/include/vmail.php 321)     db_query($query); 

modules/vmail/include/vmail.php 322)   }

modules/email/include/vmail.php 323) 
modules/email/include/vmail.php 324)   if (is_array($account['autoresponder'])) {
modules/email/include/vmail.php 325)     $ar = $account['autoresponder'];
modules/email/include/vmail.php 326)     $valid_from = maybe_null($ar['valid_from']);
modules/email/include/vmail.php 327)     $valid_until = maybe_null($ar['valid_until']);
modules/email/include/vmail.php 328)     $fromname = maybe_null( mysql_real_escape_string($ar['fromname']) );
modules/email/include/vmail.php 329)     $fromaddr = NULL;
modules/email/include/vmail.php 330)     if ($ar['fromaddr']) {
modules/email/include/vmail.php 331)       $fromaddr = mysql_real_escape_string(check_emailaddr($ar['fromaddr']));
modules/email/include/vmail.php 332)     }
modules/email/include/vmail.php 333)     $fromaddr = maybe_null( $fromaddr );
modules/email/include/vmail.php 334)     $subject = maybe_null( mysql_real_escape_string($ar['subject']));
modules/email/include/vmail.php 335)     $message = mysql_real_escape_string($ar['message']);
modules/email/include/vmail.php 336)     $quote = "'inline'";
modules/email/include/vmail.php 337)     if ($ar['quote'] == 'attach')
modules/email/include/vmail.php 338)       $quote = "'attach'";
modules/email/include/vmail.php 339)     elseif ($ar['quote'] == NULL)
modules/email/include/vmail.php 340)       $quote = 'NULL';
modules/email/include/vmail.php 341)     db_query("REPLACE INTO mail.vmail_autoresponder (account, valid_from, valid_until, fromname, fromaddr, subject, message, quote) ".
modules/email/include/vmail.php 342)              "VALUES ({$id}, {$valid_from}, {$valid_until}, {$fromname}, {$fromaddr}, {$subject}, '{$message}', {$quote})");
modules/email/include/vmail.php 343)   }
modules/email/include/vmail.php 344)     
modules/email/include/vmail.php 345) 
modules/email/include/vmail.php 346) 

modules/email/include/vmail.php 347)   if (! $newaccount)

modules/vmail/include/vmail.php 348)     db_query("DELETE FROM mail.vmail_forward WHERE account={$id}");

modules/vmail/include/vmail.php 349) 

modules/vmail/include/vmail.php 350)   if (count($account['forwards']) > 0)
modules/vmail/include/vmail.php 351)   {
modules/vmail/include/vmail.php 352)     $forward_query = "INSERT INTO mail.vmail_forward (account,spamfilter,destination) VALUES ";
modules/vmail/include/vmail.php 353)     $first = true;
modules/vmail/include/vmail.php 354)     for ($i=0;$i < count($account['forwards']); $i++)
modules/vmail/include/vmail.php 355)     { 
modules/vmail/include/vmail.php 356)       if ($first)
modules/vmail/include/vmail.php 357)         $first = false;
modules/vmail/include/vmail.php 358)       else
modules/vmail/include/vmail.php 359)         $forward_query .= ', ';
modules/vmail/include/vmail.php 360)       $forward_query .= "({$id}, ".maybe_null($account['forwards'][$i]['spamfilter']).", '{$account['forwards'][$i]['destination']}')";
modules/vmail/include/vmail.php 361)     }
modules/vmail/include/vmail.php 362)     db_query($forward_query);
modules/vmail/include/vmail.php 363)   }

modules/email/include/vmail.php 364)   if ($newaccount && $password != 'NULL')

modules/vmail/include/vmail.php 365)   {

modules/email/include/vmail.php 366)     $emailaddr = $account['local'].'@'.$domainname;
modules/email/include/vmail.php 367)     $webmailurl = config('webmail_url');

modules/email/include/vmail.php 368)     $servername = get_server_by_id($server);

modules/email/include/vmail.php 369)     $message = 'Ihr neues E-Mail-Postfach '.$emailaddr.' ist einsatzbereit!
modules/email/include/vmail.php 370) 
modules/email/include/vmail.php 371) Wenn Sie diese Nachricht sehen, haben Sie das Postfach erfolgreich 
modules/email/include/vmail.php 372) abgerufen. Sie können diese Nachricht nach Kenntnisnahme löschen.
modules/email/include/vmail.php 373) 
modules/email/include/vmail.php 374) Wussten Sie schon, dass Sie auf mehrere Arten Ihre E-Mails abrufen können?
modules/email/include/vmail.php 375) 
modules/email/include/vmail.php 376) - Für unterwegs: Webmail
modules/email/include/vmail.php 377)   Rufen Sie dazu einfach die Seite '.$webmailurl.' auf und 
modules/email/include/vmail.php 378)   geben Sie Ihre E-Mail-Adresse und das Passwort ein.
modules/email/include/vmail.php 379) 
modules/email/include/vmail.php 380) - Mit Ihrem Computer oder Smartphone: IMAP oder POP3
modules/email/include/vmail.php 381)   Tragen Sie bitte folgende Zugangsdaten in Ihrem Programm ein:

modules/email/include/vmail.php 382)     Server-Name: '.$servername.'

modules/email/include/vmail.php 383)     Benutzername: '.$emailaddr.'
modules/email/include/vmail.php 384)   (Achten Sie bitte darauf, dass die Verschlüsselung mit SSL oder TLS 
modules/email/include/vmail.php 385)   aktiviert ist.)
modules/email/include/vmail.php 386) ';
modules/email/include/vmail.php 387)     # send welcome message
modules/email/include/vmail.php 388)     mail($emailaddr, 'Ihr neues Postfach ist bereit', $message, "X-schokokeks-org-message: welcome\nFrom: ".config('company_name').' <'.config('adminmail').">\nMIME-Version: 1.0\nContent-Type: text/plain; charset=UTF-8\n");

modules/vmail/include/vmail.php 389)     # notify the vmail subsystem of this new account

modules/email/include/vmail.php 390)     #mail('vmail@'.config('vmail_server'), 'command', "user={$account['local']}\nhost={$domainname}", "X-schokokeks-org-message: command");

modules/vmail/include/vmail.php 391)   }

modules/email/include/vmail.php 392) 
modules/email/include/vmail.php 393)   // Update Mail-Quota-Cache

modules/email/include/vmail.php 394)   if ($_SESSION['role'] == ROLE_SYSTEMUSER) {
modules/email/include/vmail.php 395)     $uid = (int) $_SESSION['userinfo']['uid'];
modules/email/include/vmail.php 396)     $result = db_query("SELECT useraccount, server, SUM(quota-(SELECT value FROM misc.config WHERE `key`='vmail_basequota')) AS quota, SUM(GREATEST(quota_used-(SELECT value FROM misc.config WHERE `key`='vmail_basequota'), 0)) AS used FROM mail.v_vmail_accounts WHERE useraccount=".$uid." GROUP BY useraccount, server");
modules/email/include/vmail.php 397)     while ($line = mysql_fetch_assoc($result)) {
modules/email/include/vmail.php 398)       if ($line['quota'] !== NULL) {
modules/email/include/vmail.php 399)         db_query("REPLACE INTO mail.vmailquota (uid, server, quota, used) VALUES ('{$line['useraccount']}', '{$line['server']}', '{$line['quota']}', '{$line['used']}')");
modules/email/include/vmail.php 400)       }

modules/email/include/vmail.php 401)     }
modules/email/include/vmail.php 402)   }
modules/email/include/vmail.php 403) 

modules/email/include/vmail.php 404)   return true;

modules/vmail/include/vmail.php 405) }
modules/vmail/include/vmail.php 406) 
modules/vmail/include/vmail.php 407) 
modules/vmail/include/vmail.php 408) 

modules/vmail/include/vmail.php 409) function delete_account($id)
modules/vmail/include/vmail.php 410) {
modules/vmail/include/vmail.php 411)   $account = get_account_details($id);

modules/vmail/include/vmail.php 412)   db_query("DELETE FROM mail.vmail_accounts WHERE id={$account['id']};");

modules/vmail/include/vmail.php 413) }
modules/vmail/include/vmail.php 414) 

modules/vmail/include/vmail.php 415) 

modules/email/include/vmail.php 416) 
modules/email/include/vmail.php 417) function domainsettings($only_domain=NULL) {
modules/email/include/vmail.php 418)   $uid = (int) $_SESSION['userinfo']['uid'];

modules/email/include/vmail.php 419)   if ($only_domain)

modules/email/include/vmail.php 420)     $only_domain = (int) $only_domain;
modules/email/include/vmail.php 421)   $domains = array();
modules/email/include/vmail.php 422)   $subdomains = array();

modules/email/include/vmail.php 423) 
modules/email/include/vmail.php 424)   // Domains
modules/email/include/vmail.php 425)   $result = db_query("SELECT d.id, CONCAT_WS('.',d.domainname,d.tld) AS name, d.mail, m.id AS m_id, v.id AS v_id FROM kundendaten.domains AS d LEFT JOIN mail.virtual_mail_domains AS v ON (d.id=v.domain AND v.hostname IS NULL) LEFT JOIN mail.custom_mappings AS m ON (d.id=m.domain AND m.subdomain IS NULL) WHERE d.useraccount={$uid} OR m.uid={$uid};");
modules/email/include/vmail.php 426) 

modules/email/include/vmail.php 427)   while ($mydom = mysql_fetch_assoc($result)) {
modules/email/include/vmail.php 428)     if (! array_key_exists($mydom['id'], $domains)) {

modules/email/include/vmail.php 429)       if ($mydom['v_id'])

modules/email/include/vmail.php 430)         $mydom['mail'] = 'virtual';
modules/email/include/vmail.php 431)       $domains[$mydom['id']] = array(
modules/email/include/vmail.php 432)         "name" => $mydom['name'],
modules/email/include/vmail.php 433)         "type" => $mydom['mail']
modules/email/include/vmail.php 434)         );
modules/email/include/vmail.php 435)       if ($only_domain && $only_domain == $mydom['id'])
modules/email/include/vmail.php 436)         return $domains[$only_domain];
modules/email/include/vmail.php 437)     }

modules/email/include/vmail.php 438)   }      
modules/email/include/vmail.php 439) 
modules/email/include/vmail.php 440)   // Subdomains

modules/email/include/vmail.php 441)   $result = db_query("SELECT d.id, CONCAT_WS('.',d.domainname,d.tld) AS name, d.mail, m.id AS m_id, v.id AS v_id, IF(ISNULL(v.hostname),m.subdomain,v.hostname) AS hostname FROM kundendaten.domains AS d LEFT JOIN mail.virtual_mail_domains AS v ON (d.id=v.domain AND v.hostname IS NOT NULL) LEFT JOIN mail.custom_mappings AS m ON (d.id=m.domain AND m.subdomain IS NOT NULL) WHERE (m.id IS NOT NULL OR v.id IS NOT NULL) AND d.useraccount={$uid} OR m.uid={$uid};");

modules/email/include/vmail.php 442)   while ($mydom = mysql_fetch_assoc($result)) {
modules/email/include/vmail.php 443)     if (! array_key_exists($mydom['id'], $subdomains))
modules/email/include/vmail.php 444)       $subdomains[$mydom['id']] = array();

modules/email/include/vmail.php 445)         

modules/email/include/vmail.php 446)     $type = 'auto';
modules/email/include/vmail.php 447)     if ($mydom['v_id'])
modules/email/include/vmail.php 448)       $type = 'virtual';
modules/email/include/vmail.php 449)     $subdomains[$mydom['id']][] = array(
modules/email/include/vmail.php 450)       "name" => $mydom['hostname'],
modules/email/include/vmail.php 451)       "type" => $type
modules/email/include/vmail.php 452)       );

modules/email/include/vmail.php 453)   }
modules/email/include/vmail.php 454)   return array("domains" => $domains, "subdomains" => $subdomains);
modules/email/include/vmail.php 455) }
modules/email/include/vmail.php 456) 
modules/email/include/vmail.php 457) 
modules/email/include/vmail.php 458) function domain_has_vmail_accounts($domid)
modules/email/include/vmail.php 459) {
modules/email/include/vmail.php 460)   $domid = (int) $domid;
modules/email/include/vmail.php 461)   $result = db_query("SELECT dom.id FROM mail.vmail_accounts AS acc LEFT JOIN mail.virtual_mail_domains AS dom ON (dom.id=acc.domain) WHERE dom.domain={$domid}");
modules/email/include/vmail.php 462)   return (mysql_num_rows($result) > 0);
modules/email/include/vmail.php 463) }
modules/email/include/vmail.php 464) 
modules/email/include/vmail.php 465) 
modules/email/include/vmail.php 466) function change_domain($id, $type)
modules/email/include/vmail.php 467) {
modules/email/include/vmail.php 468)   $id = (int) $id;
modules/email/include/vmail.php 469)   $type = mysql_real_escape_string($type);
modules/email/include/vmail.php 470)   if (domain_has_vmail_accounts($id))
modules/email/include/vmail.php 471)     system_failure("Sie müssen zuerst alle E-Mail-Konten mit dieser Domain löschen, bevor Sie die Webinterface-Verwaltung für diese Domain abschalten können.");
modules/email/include/vmail.php 472)   
modules/email/include/vmail.php 473)   if (! in_array($type, array('none','auto','virtual')))
modules/email/include/vmail.php 474)     system_failure("Ungültige Aktion");
modules/email/include/vmail.php 475)   
modules/email/include/vmail.php 476)   $old = domainsettings($id);
modules/email/include/vmail.php 477)   if ($old['type'] == $type)
modules/email/include/vmail.php 478)     system_failure('Domain ist bereits so konfiguriert');
modules/email/include/vmail.php 479) 
modules/email/include/vmail.php 480)   if ($type == 'none') {
modules/email/include/vmail.php 481)     db_query("DELETE FROM mail.virtual_mail_domains WHERE domain={$id} AND hostname IS NULL LIMIT 1;");
modules/email/include/vmail.php 482)     db_query("DELETE FROM mail.custom_mappings WHERE domain={$id} AND subdomain IS NULL LIMIT 1;");

modules/email/include/vmail.php 483)     db_query("UPDATE kundendaten.domains SET mail='none', lastchange=NOW() WHERE id={$id} LIMIT 1;");

modules/email/include/vmail.php 484)   }
modules/email/include/vmail.php 485)   elseif ($type == 'virtual') {

modules/email/include/vmail.php 486)     $vmailserver = (int) $_SESSION['userinfo']['server'];

modules/email/include/vmail.php 487)     db_query("DELETE FROM mail.custom_mappings WHERE domain={$id} AND subdomain IS NULL LIMIT 1;");

modules/email/include/vmail.php 488)     db_query("UPDATE kundendaten.domains SET mail='auto', lastchange=NOW() WHERE id={$id} LIMIT 1;");

modules/email/include/vmail.php 489)     db_query("INSERT INTO mail.virtual_mail_domains (domain, server) VALUES ({$id}, {$vmailserver});");

modules/email/include/vmail.php 490)   }
modules/email/include/vmail.php 491)   elseif ($type == 'auto') {
modules/email/include/vmail.php 492)     db_query("DELETE FROM mail.virtual_mail_domains WHERE domain={$id} AND hostname IS NULL LIMIT 1;");
modules/email/include/vmail.php 493)     db_query("DELETE FROM mail.custom_mappings WHERE domain={$id} AND subdomain IS NULL LIMIT 1;");

modules/email/include/vmail.php 494)     db_query("UPDATE kundendaten.domains SET mail='auto', lastchange=NOW() WHERE id={$id} LIMIT 1;");