67d3ffab626b1f3cd94864ec65b8e26b41567d94
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

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) 
bernd Bugfix: Funktion-Dopplung v...

bernd authored 17 years ago

modules/vmail/include/vmail.php   5) require_once('hasdomain.php');
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php   6) 
bernd Alles in das email-modul ve...

bernd authored 16 years ago

modules/email/include/vmail.php   7) require_once('common.php');
modules/email/include/vmail.php   8) 
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

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,
bernd Neues VMail-Interface (funk...

bernd authored 16 years ago

modules/vmail/include/vmail.php  15) 		'password' => NULL,
bernd Spam- und viren nur noch ei...

bernd authored 17 years ago

modules/vmail/include/vmail.php  16) 		'spamfilter' => 'folder',
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php  17) 		'spamexpire' => 7,
bernd Mailaccount-Quota auch bei...

bernd authored 13 years ago

modules/email/include/vmail.php  18)                 'quota' => 256,
bernd Anpassung auf neues Interface

bernd authored 16 years ago

modules/vmail/include/vmail.php  19) 		'forwards' => array()
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php  20) 		);
modules/vmail/include/vmail.php  21) 	return $account;
modules/vmail/include/vmail.php  22) 
modules/vmail/include/vmail.php  23) }
modules/vmail/include/vmail.php  24) 
bernd VMail-accounts können sich...

bernd authored 16 years ago

modules/vmail/include/vmail.php  25) function get_account_details($id, $checkuid = true)
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php  26) {
modules/vmail/include/vmail.php  27) 	$id = (int) $id;
modules/vmail/include/vmail.php  28) 	$uid = (int) $_SESSION['userinfo']['uid'];
bernd VMail-accounts können sich...

bernd authored 16 years ago

modules/vmail/include/vmail.php  29) 	$uid_check = ($checkuid ? "useraccount='{$uid}' AND " : "");
bernd Zeige vmail-Quota im Webint...

bernd authored 13 years ago

modules/email/include/vmail.php  30) 	$result = db_query("SELECT id, local, domain, password, spamfilter, forwards, quota, quota_used from mail.v_vmail_accounts WHERE {$uid_check}id={$id} LIMIT 1");
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php  31) 	if (mysql_num_rows($result) == 0)
modules/vmail/include/vmail.php  32) 		system_failure('Ungültige ID oder kein eigener Account');
bernd Anpassung auf neues Interface

bernd authored 16 years ago

modules/vmail/include/vmail.php  33) 	$acc = empty_account();
modules/vmail/include/vmail.php  34) 	$res = mysql_fetch_assoc($result);
modules/vmail/include/vmail.php  35) 	foreach ($res AS $key => $value) {
modules/vmail/include/vmail.php  36) 	  if ($key == 'forwards')
modules/vmail/include/vmail.php  37) 	    continue;
modules/vmail/include/vmail.php  38) 	  $acc[$key] = $value;
modules/vmail/include/vmail.php  39) 	}
modules/vmail/include/vmail.php  40) 	if ($acc['forwards'] > 0) {
modules/vmail/include/vmail.php  41) 	  $result = db_query("SELECT id, spamfilter, destination FROM mail.vmail_forward WHERE account={$acc['id']};");
modules/vmail/include/vmail.php  42) 	  while ($item = mysql_fetch_assoc($result)){
modules/vmail/include/vmail.php  43) 	    array_push($acc['forwards'], array("id" => $item['id'], 'spamfilter' => $item['spamfilter'], 'destination' => $item['destination']));
modules/vmail/include/vmail.php  44) 	  }
modules/vmail/include/vmail.php  45) 	}
modules/vmail/include/vmail.php  46) 	return $acc;
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php  47) }
modules/vmail/include/vmail.php  48) 
modules/vmail/include/vmail.php  49) function get_vmail_accounts()
modules/vmail/include/vmail.php  50) {
modules/vmail/include/vmail.php  51) 	$uid = (int) $_SESSION['userinfo']['uid'];
bernd Sortiere VMail-Anzeige alph...

bernd authored 14 years ago

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

bernd authored 17 years ago

modules/vmail/include/vmail.php  53) 	$ret = array();
modules/vmail/include/vmail.php  54) 	while ($line = mysql_fetch_assoc($result))
modules/vmail/include/vmail.php  55) 	{
modules/vmail/include/vmail.php  56) 		array_push($ret, $line);
modules/vmail/include/vmail.php  57) 	}
modules/vmail/include/vmail.php  58) 	DEBUG($ret);
modules/vmail/include/vmail.php  59) 	return $ret;
modules/vmail/include/vmail.php  60) }
modules/vmail/include/vmail.php  61) 
modules/vmail/include/vmail.php  62) 
modules/vmail/include/vmail.php  63) 
modules/vmail/include/vmail.php  64) function get_vmail_domains()
modules/vmail/include/vmail.php  65) {
modules/vmail/include/vmail.php  66) 	$uid = (int) $_SESSION['userinfo']['uid'];
modules/vmail/include/vmail.php  67) 	$result = db_query("SELECT id, domainname FROM mail.v_vmail_domains WHERE useraccount='{$uid}'");
modules/vmail/include/vmail.php  68) 	if (mysql_num_rows($result) == 0)
modules/vmail/include/vmail.php  69) 		system_failure('Sie haben keine Domains für virtuelle Mail-Verarbeitung');
modules/vmail/include/vmail.php  70) 	$ret = array();
modules/vmail/include/vmail.php  71) 	while ($tmp = mysql_fetch_object($result))
modules/vmail/include/vmail.php  72) 		array_push($ret, $tmp);
modules/vmail/include/vmail.php  73) 	return $ret;
modules/vmail/include/vmail.php  74) }
modules/vmail/include/vmail.php  75) 
modules/vmail/include/vmail.php  76) 
bernd VMail-accounts können sich...

bernd authored 16 years ago

modules/vmail/include/vmail.php  77) function find_account_id($accname)
modules/vmail/include/vmail.php  78) {
modules/vmail/include/vmail.php  79)   $accname = mysql_real_escape_string($accname);
modules/vmail/include/vmail.php  80)   DEBUG($accname);
modules/vmail/include/vmail.php  81)   $tmp = explode('@', $accname, 2);
modules/vmail/include/vmail.php  82)   DEBUG($tmp);
modules/vmail/include/vmail.php  83)   if (count($tmp) != 2)
modules/vmail/include/vmail.php  84)     system_failure("Der Account hat nicht die korrekte Syntax");
modules/vmail/include/vmail.php  85)   list( $local, $domainname) = $tmp;
modules/vmail/include/vmail.php  86) 
modules/vmail/include/vmail.php  87)   $result = db_query("SELECT id FROM mail.v_vmail_accounts WHERE local='{$local}' AND domainname='{$domainname}' LIMIT 1");
modules/vmail/include/vmail.php  88)   if (mysql_num_rows($result) == 0)
modules/vmail/include/vmail.php  89)     system_failure("Der Account konnte nicht gefunden werden");
modules/vmail/include/vmail.php  90)   $tmp = mysql_fetch_array($result);
modules/vmail/include/vmail.php  91)   return $tmp[0];
modules/vmail/include/vmail.php  92) }
modules/vmail/include/vmail.php  93) 
modules/vmail/include/vmail.php  94) 
modules/vmail/include/vmail.php  95) function change_vmail_password($accname, $newpass)
modules/vmail/include/vmail.php  96) {
modules/vmail/include/vmail.php  97)   $accid = find_account_id($accname);
modules/vmail/include/vmail.php  98)   $encpw = mysql_real_escape_string(encrypt_mail_password($newpass));
modules/vmail/include/vmail.php  99)   db_query("UPDATE mail.vmail_accounts SET password='{$encpw}' WHERE id={$accid} LIMIT 1;");
modules/vmail/include/vmail.php 100) }
modules/vmail/include/vmail.php 101) 
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php 102) 
modules/vmail/include/vmail.php 103) function domainselect($selected = NULL, $selectattribute = '')
modules/vmail/include/vmail.php 104) {
bernd Bugfix: Funktion-Dopplung v...

bernd authored 17 years ago

modules/vmail/include/vmail.php 105)   $domainlist = get_vmail_domains();
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php 106)   $selected = (int) $selected;
modules/vmail/include/vmail.php 107) 
modules/vmail/include/vmail.php 108)   $ret = '<select id="domain" name="domain" size="1" '.$selectattribute.' >';
modules/vmail/include/vmail.php 109)   foreach ($domainlist as $dom)
modules/vmail/include/vmail.php 110)   {
modules/vmail/include/vmail.php 111)     $s = ($selected == $dom->id) ? ' selected="selected" ': '';
modules/vmail/include/vmail.php 112)     $ret .= "<option value=\"{$dom->id}\"{$s}>{$dom->domainname}</option>\n";
modules/vmail/include/vmail.php 113)   }
modules/vmail/include/vmail.php 114)   $ret .= '</select>';
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) 
modules/vmail/include/vmail.php 120) 
modules/vmail/include/vmail.php 121) function save_vmail_account($account)
modules/vmail/include/vmail.php 122) {
modules/vmail/include/vmail.php 123)   $uid = (int) $_SESSION['userinfo']['uid'];
modules/vmail/include/vmail.php 124)   $id = $account['id'];
modules/vmail/include/vmail.php 125)   if ($id != NULL)
modules/vmail/include/vmail.php 126)   {
modules/vmail/include/vmail.php 127)     $id = (int) $id;
modules/vmail/include/vmail.php 128)     $oldaccount = get_account_details($id);
modules/vmail/include/vmail.php 129)     // Erzeugt einen system_error() wenn ID ungültig
modules/vmail/include/vmail.php 130)   }
modules/vmail/include/vmail.php 131)   // Ab hier ist $id sicher, entweder NULL oder eine gültige ID des aktuellen users
modules/vmail/include/vmail.php 132) 
modules/vmail/include/vmail.php 133)   $account['local'] = filter_input_username($account['local']);
modules/vmail/include/vmail.php 134)   if ($account['local'] == '')
modules/vmail/include/vmail.php 135)   {
bernd Nicht behebbare Fehlermeldu...

bernd authored 14 years ago

modules/email/include/vmail.php 136)     system_failure('Die E-Mail-Adresse braucht eine Angabe vor dem »@«!');
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php 137)     return false;
modules/vmail/include/vmail.php 138)   }
modules/vmail/include/vmail.php 139)   $account['domain'] = (int) $account['domain'];
modules/vmail/include/vmail.php 140)   $domainlist = get_vmail_domains();
modules/vmail/include/vmail.php 141)   $valid_domain = false;
bernd Benachrichtige vmail-userac...

bernd authored 17 years ago

modules/vmail/include/vmail.php 142)   $domainname = NULL;
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php 143)   foreach ($domainlist as $dom)
modules/vmail/include/vmail.php 144)   {
modules/vmail/include/vmail.php 145)     if ($dom->id == $account['domain'])
modules/vmail/include/vmail.php 146)     {
bernd Benachrichtige vmail-userac...

bernd authored 17 years ago

modules/vmail/include/vmail.php 147)       $domainname = $dom->domainname;
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php 148)       $valid_domain = true;
modules/vmail/include/vmail.php 149)       break;
modules/vmail/include/vmail.php 150)     }
modules/vmail/include/vmail.php 151)   }
modules/vmail/include/vmail.php 152)   if (($account['domain'] == 0) || (! $valid_domain))
modules/vmail/include/vmail.php 153)   {
bernd Nicht behebbare Fehlermeldu...

bernd authored 14 years ago

modules/email/include/vmail.php 154)     system_failure('Bitte wählen Sie eine Ihrer Domains aus!');
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php 155)     return false;
modules/vmail/include/vmail.php 156)   }
bernd Anpassung auf neues Interface

bernd authored 16 years ago

modules/vmail/include/vmail.php 157)   
modules/vmail/include/vmail.php 158)   $forwards = array();
modules/vmail/include/vmail.php 159)   if (count($account['forwards']) > 0) 
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php 160)   {
bernd Anpassung auf neues Interface

bernd authored 16 years ago

modules/vmail/include/vmail.php 161)     for ($i=0;$i < count($account['forwards']); $i++)
modules/vmail/include/vmail.php 162)     {
modules/vmail/include/vmail.php 163)       if ($account['forwards'][$i]['spamfilter'] != 'tag' && $account['forwards'][$i]['spamfilter'] != 'delete')
modules/vmail/include/vmail.php 164)         $account['forwards'][$i]['spamfilter'] = '';
modules/vmail/include/vmail.php 165)       $account['forwards'][$i]['destination'] = filter_input_general($account['forwards'][$i]['destination']);
modules/vmail/include/vmail.php 166)       if (! check_emailaddr($account['forwards'][$i]['destination']))
modules/vmail/include/vmail.php 167)         system_failure('Das Weiterleitungs-Ziel »'.$account['forwards'][$i]['destination'].'« ist keine E-Mail-Adresse!');
modules/vmail/include/vmail.php 168)     }
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php 169)   }
bernd Anpassung auf neues Interface

bernd authored 16 years ago

modules/vmail/include/vmail.php 170)     
modules/vmail/include/vmail.php 171)   $password='NULL';
modules/vmail/include/vmail.php 172)   if ($account['password'] != '')
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php 173)   {
bernd Anpassung auf neues Interface

bernd authored 16 years ago

modules/vmail/include/vmail.php 174)     $account['password'] = stripslashes($account['password']);
modules/vmail/include/vmail.php 175)     $crack = strong_password($account['password']);
modules/vmail/include/vmail.php 176)     if ($crack !== true)
modules/vmail/include/vmail.php 177)     {
bernd Nicht behebbare Fehlermeldu...

bernd authored 14 years ago

modules/email/include/vmail.php 178)       system_failure('Ihr Passwort ist zu einfach. bitte wählen Sie ein sicheres Passwort!'."\nDie Fehlermeldung lautet: »{$crack}«");
bernd Anpassung auf neues Interface

bernd authored 16 years ago

modules/vmail/include/vmail.php 179)       return false;
modules/vmail/include/vmail.php 180)     }
modules/vmail/include/vmail.php 181)     $password = "'".encrypt_mail_password($account['password'])."'";
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php 182)   }
bernd Anpassung auf neues Interface

bernd authored 16 years ago

modules/vmail/include/vmail.php 183)   $set_password = ($id == NULL || $password != 'NULL');
modules/vmail/include/vmail.php 184)   if ($account['password'] === NULL)
modules/vmail/include/vmail.php 185)     $set_password=true;
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php 186) 
modules/vmail/include/vmail.php 187)   $spam = 'NULL';
modules/vmail/include/vmail.php 188)   switch ($account['spamfilter'])
modules/vmail/include/vmail.php 189)   {
modules/vmail/include/vmail.php 190)     case 'folder':
modules/vmail/include/vmail.php 191)       $spam = "'folder'";
modules/vmail/include/vmail.php 192)       break;
modules/vmail/include/vmail.php 193)     case 'tag':
modules/vmail/include/vmail.php 194)       $spam = "'tag'";
modules/vmail/include/vmail.php 195)       break;
modules/vmail/include/vmail.php 196)     case 'delete':
modules/vmail/include/vmail.php 197)       $spam = "'delete'";
modules/vmail/include/vmail.php 198)       break;
modules/vmail/include/vmail.php 199)   }
modules/vmail/include/vmail.php 200) 
bernd Mailaccount-Quota auch bei...

bernd authored 13 years ago

modules/email/include/vmail.php 201)   $account['quota'] = max((int) config('vmail_basequota'), (int) $account['quota']);
modules/email/include/vmail.php 202) 
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php 203)   $account['local'] = mysql_real_escape_string($account['local']);
bernd Anpassung auf neues Interface

bernd authored 16 years ago

modules/vmail/include/vmail.php 204)   $account['password'] = mysql_real_escape_string($account['password']);
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php 205)   $account['spamexpire'] = (int) $account['spamexpire'];
modules/vmail/include/vmail.php 206) 
modules/vmail/include/vmail.php 207)   $query = '';
modules/vmail/include/vmail.php 208)   if ($id == NULL)
modules/vmail/include/vmail.php 209)   {
bernd Mailaccount-Quota auch bei...

bernd authored 13 years ago

modules/email/include/vmail.php 210)     $query = "INSERT INTO mail.vmail_accounts (local, domain, spamfilter, spamexpire, password, quota) VALUES ";
modules/email/include/vmail.php 211)     $query .= "('{$account['local']}', {$account['domain']}, {$spam}, {$account['spamexpire']}, {$password}, {$account['quota']});";
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php 212)   }
modules/vmail/include/vmail.php 213)   else
modules/vmail/include/vmail.php 214)   {
bernd Anpassung auf neues Interface

bernd authored 16 years ago

modules/vmail/include/vmail.php 215)     if ($set_password)
modules/vmail/include/vmail.php 216)       $password=", password={$password}";
modules/vmail/include/vmail.php 217)     else
modules/vmail/include/vmail.php 218)       $password='';
modules/vmail/include/vmail.php 219)     $query = "UPDATE mail.vmail_accounts SET local='{$account['local']}', domain={$account['domain']}{$password}, ";
bernd Mailaccount-Quota auch bei...

bernd authored 13 years ago

modules/email/include/vmail.php 220)     $query .= "spamfilter={$spam}, spamexpire={$account['spamexpire']}, quota={$account['quota']} ";
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php 221)     $query .= "WHERE id={$id} LIMIT 1;";
modules/vmail/include/vmail.php 222)   }
modules/vmail/include/vmail.php 223)   db_query($query); 
bernd Bugfixes

bernd authored 16 years ago

modules/vmail/include/vmail.php 224)   if ($id)
modules/vmail/include/vmail.php 225)     db_query("DELETE FROM mail.vmail_forward WHERE account={$id}");
bernd VMail-accounts können sich...

bernd authored 16 years ago

modules/vmail/include/vmail.php 226)   else
modules/vmail/include/vmail.php 227)     $id = mysql_insert_id();
modules/vmail/include/vmail.php 228) 
bernd Anpassung auf neues Interface

bernd authored 16 years ago

modules/vmail/include/vmail.php 229)   if (count($account['forwards']) > 0)
modules/vmail/include/vmail.php 230)   {
modules/vmail/include/vmail.php 231)     $forward_query = "INSERT INTO mail.vmail_forward (account,spamfilter,destination) VALUES ";
modules/vmail/include/vmail.php 232)     $first = true;
modules/vmail/include/vmail.php 233)     for ($i=0;$i < count($account['forwards']); $i++)
modules/vmail/include/vmail.php 234)     { 
modules/vmail/include/vmail.php 235)       if ($first)
modules/vmail/include/vmail.php 236)         $first = false;
modules/vmail/include/vmail.php 237)       else
modules/vmail/include/vmail.php 238)         $forward_query .= ', ';
modules/vmail/include/vmail.php 239)       $forward_query .= "({$id}, ".maybe_null($account['forwards'][$i]['spamfilter']).", '{$account['forwards'][$i]['destination']}')";
modules/vmail/include/vmail.php 240)     }
modules/vmail/include/vmail.php 241)     db_query($forward_query);
modules/vmail/include/vmail.php 242)   }
bernd Mailaccount-Quota auch bei...

bernd authored 13 years ago

modules/email/include/vmail.php 243)   if ($password != 'NULL')
bernd Benachrichtige vmail-userac...

bernd authored 17 years ago

modules/vmail/include/vmail.php 244)   {
modules/vmail/include/vmail.php 245)     # notify the vmail subsystem of this new account
bernd Mehr config-optionen und co...

bernd authored 15 years ago

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

bernd authored 17 years ago

modules/vmail/include/vmail.php 247)   }
bernd Mailaccount-Quota auch bei...

bernd authored 13 years ago

modules/email/include/vmail.php 248) 
modules/email/include/vmail.php 249)   // Update Mail-Quota-Cache
modules/email/include/vmail.php 250)   $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 GROUP BY useraccount, server");
modules/email/include/vmail.php 251)   while ($line = mysql_fetch_assoc($result)) {
modules/email/include/vmail.php 252)     if ($line['quota'] !== NULL) {
modules/email/include/vmail.php 253)       db_query("REPLACE INTO mail.vmailquota (uid, server, quota, used) VALUES ('{$line['useraccount']}', '{$line['server']}', '{$line['quota']}', '{$line['used']}')");
modules/email/include/vmail.php 254)     }
modules/email/include/vmail.php 255)   }
modules/email/include/vmail.php 256) 
bernd Nicht behebbare Fehlermeldu...

bernd authored 14 years ago

modules/email/include/vmail.php 257)   return true;
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php 258) }
modules/vmail/include/vmail.php 259) 
modules/vmail/include/vmail.php 260) 
modules/vmail/include/vmail.php 261) 
bernd Löschen geht jetzt auch

bernd authored 17 years ago

modules/vmail/include/vmail.php 262) function delete_account($id)
modules/vmail/include/vmail.php 263) {
modules/vmail/include/vmail.php 264)   $account = get_account_details($id);
bernd Anpassung auf neues Interface

bernd authored 16 years ago

modules/vmail/include/vmail.php 265)   db_query("DELETE FROM mail.vmail_accounts WHERE id={$account['id']};");
bernd Löschen geht jetzt auch

bernd authored 17 years ago

modules/vmail/include/vmail.php 266) }
modules/vmail/include/vmail.php 267) 
bernd Erste Version des vmail-Modul

bernd authored 17 years ago

modules/vmail/include/vmail.php 268) 
bernd Großer VMail-move

bernd authored 16 years ago

modules/email/include/vmail.php 269) 
modules/email/include/vmail.php 270) function domainsettings($only_domain=NULL) {
modules/email/include/vmail.php 271)   $uid = (int) $_SESSION['userinfo']['uid'];
bernd Subdomains und Domains bess...

bernd authored 15 years ago

modules/email/include/vmail.php 272)   if ($only_domain)
bernd Großer VMail-move

bernd authored 16 years ago

modules/email/include/vmail.php 273)     $only_domain = (int) $only_domain;
modules/email/include/vmail.php 274)   $domains = array();
modules/email/include/vmail.php 275)   $subdomains = array();
bernd Subdomains und Domains bess...

bernd authored 15 years ago

modules/email/include/vmail.php 276) 
modules/email/include/vmail.php 277)   // Domains
modules/email/include/vmail.php 278)   $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 279) 
bernd Großer VMail-move

bernd authored 16 years ago

modules/email/include/vmail.php 280)   while ($mydom = mysql_fetch_assoc($result)) {
modules/email/include/vmail.php 281)     if (! array_key_exists($mydom['id'], $domains)) {
bernd Subdomains und Domains bess...

bernd authored 15 years ago

modules/email/include/vmail.php 282)       if ($mydom['v_id'])
bernd Großer VMail-move

bernd authored 16 years ago

modules/email/include/vmail.php 283)         $mydom['mail'] = 'virtual';
modules/email/include/vmail.php 284)       $domains[$mydom['id']] = array(
modules/email/include/vmail.php 285)         "name" => $mydom['name'],
modules/email/include/vmail.php 286)         "type" => $mydom['mail']
modules/email/include/vmail.php 287)         );
modules/email/include/vmail.php 288)       if ($only_domain && $only_domain == $mydom['id'])
modules/email/include/vmail.php 289)         return $domains[$only_domain];
modules/email/include/vmail.php 290)     }
bernd Subdomains und Domains bess...

bernd authored 15 years ago

modules/email/include/vmail.php 291)   }      
modules/email/include/vmail.php 292) 
modules/email/include/vmail.php 293)   // Subdomains
bernd Subdomains nur auslesen wo...

bernd authored 15 years ago

modules/email/include/vmail.php 294)   $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};");
bernd Subdomains und Domains bess...

bernd authored 15 years ago

modules/email/include/vmail.php 295)   while ($mydom = mysql_fetch_assoc($result)) {
modules/email/include/vmail.php 296)     if (! array_key_exists($mydom['id'], $subdomains))
modules/email/include/vmail.php 297)       $subdomains[$mydom['id']] = array();
bernd Großer VMail-move

bernd authored 16 years ago

modules/email/include/vmail.php 298)         
bernd Subdomains und Domains bess...

bernd authored 15 years ago

modules/email/include/vmail.php 299)     $type = 'auto';
modules/email/include/vmail.php 300)     if ($mydom['v_id'])
modules/email/include/vmail.php 301)       $type = 'virtual';
modules/email/include/vmail.php 302)     $subdomains[$mydom['id']][] = array(
modules/email/include/vmail.php 303)       "name" => $mydom['hostname'],
modules/email/include/vmail.php 304)       "type" => $type
modules/email/include/vmail.php 305)       );
bernd Großer VMail-move

bernd authored 16 years ago

modules/email/include/vmail.php 306)   }
modules/email/include/vmail.php 307)   return array("domains" => $domains, "subdomains" => $subdomains);
modules/email/include/vmail.php 308) }
modules/email/include/vmail.php 309) 
modules/email/include/vmail.php 310) 
modules/email/include/vmail.php 311) function domain_has_vmail_accounts($domid)
modules/email/include/vmail.php 312) {
modules/email/include/vmail.php 313)   $domid = (int) $domid;
modules/email/include/vmail.php 314)   $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 315)   return (mysql_num_rows($result) > 0);
modules/email/include/vmail.php 316) }
modules/email/include/vmail.php 317) 
modules/email/include/vmail.php 318) 
modules/email/include/vmail.php 319) function change_domain($id, $type)
modules/email/include/vmail.php 320) {
modules/email/include/vmail.php 321)   $id = (int) $id;
modules/email/include/vmail.php 322)   $type = mysql_real_escape_string($type);
modules/email/include/vmail.php 323)   if (domain_has_vmail_accounts($id))
modules/email/include/vmail.php 324)     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 325)   
modules/email/include/vmail.php 326)   if (! in_array($type, array('none','auto','virtual')))
modules/email/include/vmail.php 327)     system_failure("Ungültige Aktion");
modules/email/include/vmail.php 328)   
modules/email/include/vmail.php 329)   $old = domainsettings($id);
modules/email/include/vmail.php 330)   if ($old['type'] == $type)
modules/email/include/vmail.php 331)     system_failure('Domain ist bereits so konfiguriert');
modules/email/include/vmail.php 332) 
modules/email/include/vmail.php 333)   if ($type == 'none') {
modules/email/include/vmail.php 334)     db_query("DELETE FROM mail.virtual_mail_domains WHERE domain={$id} AND hostname IS NULL LIMIT 1;");
modules/email/include/vmail.php 335)     db_query("DELETE FROM mail.custom_mappings WHERE domain={$id} AND subdomain IS NULL LIMIT 1;");
bernd lastchange immer setzen

bernd authored 16 years ago

modules/email/include/vmail.php 336)     db_query("UPDATE kundendaten.domains SET mail='none', lastchange=NOW() WHERE id={$id} LIMIT 1;");
bernd Großer VMail-move

bernd authored 16 years ago

modules/email/include/vmail.php 337)   }
modules/email/include/vmail.php 338)   elseif ($type == 'virtual') {
bernd Info-Seite über Mail-Login-...

bernd authored 13 years ago

modules/email/include/vmail.php 339)     $vmailserver = (int) $_SESSION['userinfo']['server'];
bernd Großer VMail-move

bernd authored 16 years ago

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

bernd authored 16 years ago

modules/email/include/vmail.php 341)     db_query("UPDATE kundendaten.domains SET mail='auto', lastchange=NOW() WHERE id={$id} LIMIT 1;");
bernd Server bei vmail-domain mit...

bernd authored 13 years ago

modules/email/include/vmail.php 342)     db_query("INSERT INTO mail.virtual_mail_domains (domain, server) VALUES ({$id}, {$vmailserver});");
bernd Großer VMail-move

bernd authored 16 years ago

modules/email/include/vmail.php 343)   }
modules/email/include/vmail.php 344)   elseif ($type == 'auto') {
modules/email/include/vmail.php 345)     db_query("DELETE FROM mail.virtual_mail_domains WHERE domain={$id} AND hostname IS NULL LIMIT 1;");
modules/email/include/vmail.php 346)     db_query("DELETE FROM mail.custom_mappings WHERE domain={$id} AND subdomain IS NULL LIMIT 1;");
bernd lastchange immer setzen

bernd authored 16 years ago

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