Changeset 1020
- Timestamp:
- 02/25/08 02:39:40
(9 months ago)
- Author:
- joximu
- Message:
fixed several bugs, #747, #1047, #1068 a.o.
-
Files:
-
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
| r1019 |
r1020 |
|
| 2 | 2 | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|---|
| 3 | 3 | |
|---|
| 4 | | 2008-02-19 Christian Hernmarck |
|---|
| | 4 | 2008-02-25 Christian Hernmarck |
|---|
| | 5 | - GUI: |
|---|
| | 6 | * Fixed #1068: Patch to fix icon position in WebFTP |
|---|
| | 7 | * Fixed #1047: alias emails not deleted |
|---|
| | 8 | * Fixed #747: use of unused field mail_addr in table mail_users |
|---|
| | 9 | * Some smaller fixes (FTP_SHELL->CMD_SHELL, TR_MENU... missing string) |
|---|
| | 10 | |
|---|
| | 11 | 2008-02-25 Jochen Manz |
|---|
| | 12 | - GUI: |
|---|
| | 13 | * Corrected some small issues and increased the speed of the db update |
|---|
| | 14 | |
|---|
| | 15 | 2008-02-24 Christian Hernmarck |
|---|
| 5 | 16 | - GUI: |
|---|
| 6 | 17 | * Some small fixes: domain_statistics & some "remove this" messages |
|---|
| 7 | | |
|---|
| 8 | | 2008-02-25 Jochen Manz |
|---|
| 9 | | - GUI: |
|---|
| 10 | | * Corrected some small issues and increased the speed of the db update |
|---|
| 11 | 18 | |
|---|
| 12 | 19 | 2008-02-24 Benedikt Heintel |
|---|
| r1014 |
r1020 |
|
| 227 | 227 | $status = $cfg['ITEM_ORDERED_STATUS']; |
|---|
| 228 | 228 | |
|---|
| 229 | | $query = "insert into domain_aliasses(domain_id, alias_name, alias_mount, alias_status, alias_ip_id, url_forward) values (?, ?, ?, ?, ?, ?)"; |
|---|
| | 229 | $query = "insert into domain_aliasses(domain_id, alias_name, alias_mount, alias_status, alias_ip_id, url_forward) values (?, ?, ?, ?, ?, ?)"; |
|---|
| 230 | 230 | exec_query($sql, $query, array($cr_user_id, $alias_name, $mount_point, $status, $domain_ip, $forward)); |
|---|
| 231 | 231 | |
|---|
| 232 | 232 | $als_id = $sql->Insert_ID(); |
|---|
| 233 | 233 | |
|---|
| 234 | | if ($cfg['CREATE_DEFAULT_EMAIL_ADDRESSES']) { |
|---|
| | 234 | /* if ($cfg['CREATE_DEFAULT_EMAIL_ADDRESSES']) { |
|---|
| 235 | 235 | |
|---|
| 236 | 236 | $reseller_id = who_owns_this(who_owns_this($cr_user_id, 'dmn_id'), 'user'); |
|---|
| … | … | |
| 284 | 284 | '_no_')); |
|---|
| 285 | 285 | } |
|---|
| 286 | | |
|---|
| | 286 | */ |
|---|
| 287 | 287 | $admin_login = $_SESSION['user_logged']; |
|---|
| 288 | 288 | |
|---|
| r1014 |
r1020 |
|
| 412 | 412 | if ($ftp_uid == -1) return; |
|---|
| 413 | 413 | |
|---|
| 414 | | $ftp_shell = $cfg['FTP_SHELL']; |
|---|
| | 414 | $ftp_shell = $cfg['CMD_SHELL']; |
|---|
| 415 | 415 | $ftp_passwd = crypt_user_ftp_pass($_POST['pass']); |
|---|
| 416 | 416 | |
|---|
| r1014 |
r1020 |
|
| 3 | 3 | * ispCP ω (OMEGA) a Virtual Hosting Control System |
|---|
| 4 | 4 | * |
|---|
| 5 | | * @copyright 2001-2006 by moleSoftware GmbH |
|---|
| 6 | | * @copyright 2006-2008 by ispCP | http://isp-control.net |
|---|
| 7 | | * @version SVN: $ID$ |
|---|
| 8 | | * @link http://isp-control.net |
|---|
| 9 | | * @author ispCP Team |
|---|
| | 5 | * @copyright 2001-2006 by moleSoftware GmbH |
|---|
| | 6 | * @copyright 2006-2008 by ispCP | http://isp-control.net |
|---|
| | 7 | * @version SVN: $ID$ |
|---|
| | 8 | * @link http://isp-control.net |
|---|
| | 9 | * @author ispCP Team |
|---|
| 10 | 10 | * |
|---|
| 11 | 11 | * @license |
|---|
| … | … | |
| 208 | 208 | global $cfg; |
|---|
| 209 | 209 | |
|---|
| | 210 | // 20080218: added support for the mail_addr field: complete mail address in the db |
|---|
| | 211 | |
|---|
| 210 | 212 | // standard whithout encoding |
|---|
| 211 | 213 | // $mail_acc = $_POST['username']; |
|---|
| … | … | |
| 219 | 221 | } |
|---|
| 220 | 222 | $mail_auto_respond = '_no_'; |
|---|
| | 223 | $mail_addr = ''; |
|---|
| 221 | 224 | |
|---|
| 222 | 225 | if ($_POST['mail_type'] === 'normal') { |
|---|
| … | … | |
| 226 | 229 | $mail_type = 'normal_mail'; |
|---|
| 227 | 230 | $sub_id = '0'; |
|---|
| | 231 | $mail_addr = $mail_acc.'@'.$dmn_name; // the complete address |
|---|
| 228 | 232 | } |
|---|
| 229 | 233 | else if ($_POST['dmn_type'] === 'sub') { |
|---|
| … | … | |
| 232 | 236 | $mail_type = 'subdom_mail'; |
|---|
| 233 | 237 | $sub_id = $_POST['sub_id']; |
|---|
| | 238 | // search the complete address |
|---|
| | 239 | $query = <<<SQL_QUERY |
|---|
| | 240 | SELECT |
|---|
| | 241 | `subdomain_name` |
|---|
| | 242 | FROM |
|---|
| | 243 | `subdomain` |
|---|
| | 244 | WHERE |
|---|
| | 245 | `subdomain_id` = ? |
|---|
| | 246 | SQL_QUERY; |
|---|
| | 247 | $rs = exec_query($sql, $query, array($sub_id)); |
|---|
| | 248 | $mail_addr = $mail_acc.'@'.decode_idna($rs->fields['subdomain_name']).'.'.$dmn_name; // the complete address |
|---|
| 234 | 249 | } |
|---|
| 235 | 250 | else if ($_POST['dmn_type'] === 'als') { |
|---|
| … | … | |
| 238 | 253 | $mail_type = 'alias_mail'; |
|---|
| 239 | 254 | $sub_id = $_POST['als_id']; |
|---|
| | 255 | // search the complete address |
|---|
| | 256 | $query = <<<SQL_QUERY |
|---|
| | 257 | SELECT |
|---|
| | 258 | `alias_name` |
|---|
| | 259 | FROM |
|---|
| | 260 | `domain_aliasses` |
|---|
| | 261 | WHERE |
|---|
| | 262 | `alias_id` = ? |
|---|
| | 263 | SQL_QUERY; |
|---|
| | 264 | $rs = exec_query($sql, $query, array($sub_id)); |
|---|
| | 265 | $mail_addr = $mail_acc.'@'.decode_idna($rs->fields['alias_name']); // the complete address |
|---|
| 240 | 266 | } else { |
|---|
| 241 | 267 | set_page_message(tr('Unknown domain type')); |
|---|
| … | … | |
| 330 | 356 | sub_id, |
|---|
| 331 | 357 | status, |
|---|
| 332 | | mail_auto_respond) |
|---|
| | 358 | mail_auto_respond, |
|---|
| | 359 | mail_addr) |
|---|
| 333 | 360 | VALUES |
|---|
| 334 | | (?, ?, ?, ?, ?, ?, ?, ?) |
|---|
| | 361 | (?, ?, ?, ?, ?, ?, ?, ?, ?) |
|---|
| 335 | 362 | SQL_QUERY; |
|---|
| 336 | 363 | |
|---|
| … | … | |
| 342 | 369 | $sub_id, |
|---|
| 343 | 370 | $cfg['ITEM_ADD_STATUS'], |
|---|
| 344 | | $mail_auto_respond)); |
|---|
| 345 | | |
|---|
| 346 | | if ($_POST['dmn_type'] === 'als') { |
|---|
| 347 | | $query = <<<SQL_QUERY |
|---|
| 348 | | SELECT |
|---|
| 349 | | `alias_name` |
|---|
| 350 | | FROM |
|---|
| 351 | | `domain_aliasses` |
|---|
| 352 | | WHERE |
|---|
| 353 | | `alias_id` = ? |
|---|
| 354 | | LIMIT |
|---|
| 355 | | 1 |
|---|
| 356 | | SQL_QUERY; |
|---|
| 357 | | |
|---|
| 358 | | $rs = exec_query($sql, $query, array($sub_id)); |
|---|
| 359 | | $dmn_name = $rs->fields['alias_name']; |
|---|
| 360 | | } |
|---|
| 361 | | else if ($_POST['dmn_type'] === 'sub') { |
|---|
| 362 | | $query = <<<SQL_QUERY |
|---|
| 363 | | SELECT |
|---|
| 364 | | `subdomain_name` |
|---|
| 365 | | FROM |
|---|
| 366 | | `subdomain` |
|---|
| 367 | | WHERE |
|---|
| 368 | | `subdomain_id` = ? |
|---|
| 369 | | LIMIT |
|---|
| 370 | | 1 |
|---|
| 371 | | SQL_QUERY; |
|---|
| 372 | | |
|---|
| 373 | | $rs = exec_query($sql, $query, array($sub_id)); |
|---|
| 374 | | $dmn_name = $rs->fields['subdomain_name'].$dmn_name; |
|---|
| 375 | | } |
|---|
| 376 | | |
|---|
| 377 | | write_log($_SESSION['user_logged'] . ": add new mail account: " . $mail_acc . "@" . $dmn_name); |
|---|
| | 371 | $mail_auto_respond, |
|---|
| | 372 | $mail_addr)); |
|---|
| | 373 | |
|---|
| | 374 | write_log($_SESSION['user_logged'] . ": add new mail account: " . $mail_addr); |
|---|
| 378 | 375 | set_page_message(tr('Mail account scheduled for addition!')); |
|---|
| 379 | 376 | send_request(); |
|---|
| r1011 |
r1020 |
|
| 105 | 105 | 'TR_MENU_SERVER_STATUS' => tr('Server status'), |
|---|
| 106 | 106 | 'TR_MENU_ISPCP_UPDATE' => tr('ispCP updates'), |
|---|
| | 107 | 'TR_MENU_ISPCP_DATABASE_UPDATE' => tr('ispCP database updates'), |
|---|
| 107 | 108 | 'TR_MENU_ISPCP_DEBUGGER' => tr('ispCP debugger'), |
|---|
| 108 | 109 | 'TR_CUSTOM_MENUS' => tr('Custom menus'), |
|---|
| r1016 |
r1020 |
|
| 39 | 39 | require_once(INCLUDEPATH.'/sql.php'); |
|---|
| 40 | 40 | |
|---|
| 41 | | // variable for developmetn edition => shows all php variables under the pages |
|---|
| | 41 | // variable for development edition => shows all php variables under the pages |
|---|
| 42 | 42 | // false = disable, true = enable |
|---|
| 43 | 43 | $cfg['DUMP_GUI_DEBUG'] = false; |
|---|
| r1008 |
r1020 |
|
| 1661 | 1661 | } |
|---|
| 1662 | 1662 | |
|---|
| | 1663 | // add the 3 mail accounts/forwardings to a new domain... |
|---|
| | 1664 | function client_mail_add_default_accounts($dmn_id, $user_email, $dmn_part, $dmn_type = 'domain', $sub_id = 0) |
|---|
| | 1665 | { |
|---|
| | 1666 | global $cfg, $sql; |
|---|
| | 1667 | |
|---|
| | 1668 | if ($cfg['CREATE_DEFAULT_EMAIL_ADDRESSES']) { |
|---|
| | 1669 | |
|---|
| | 1670 | $forward_type = ($dmn_type == 'alias') ? 'alias_forward': 'normal_forward'; |
|---|
| | 1671 | |
|---|
| | 1672 | // prepare SQL |
|---|
| | 1673 | $query = <<<SQL_QUERY |
|---|
| | 1674 | INSERT INTO mail_users |
|---|
| | 1675 | (mail_acc, |
|---|
| | 1676 | mail_pass, |
|---|
| | 1677 | mail_forward, |
|---|
| | 1678 | domain_id, |
|---|
| | 1679 | mail_type, |
|---|
| | 1680 | sub_id, |
|---|
| | 1681 | status, |
|---|
| | 1682 | mail_auto_respond, |
|---|
| | 1683 | quota, |
|---|
| | 1684 | mail_addr) |
|---|
| | 1685 | VALUES |
|---|
| | 1686 | (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) |
|---|
| | 1687 | SQL_QUERY; |
|---|
| | 1688 | |
|---|
| | 1689 | // create default forwarder for webmaster@domain.tld to the account's owner |
|---|
| | 1690 | $rs = exec_query($sql, $query, |
|---|
| | 1691 | array('webmaster', |
|---|
| | 1692 | '_no_', |
|---|
| | 1693 | $user_email, |
|---|
| | 1694 | $dmn_id, |
|---|
| | 1695 | $forward_type, |
|---|
| | 1696 | $sub_id, |
|---|
| | 1697 | $cfg['ITEM_ADD_STATUS'], |
|---|
| | 1698 | '_no_', |
|---|
| | 1699 | 10485760, |
|---|
| | 1700 | 'webmaster@'.$dmn_part |
|---|
| | 1701 | ) |
|---|
| | 1702 | ); |
|---|
| | 1703 | |
|---|
| | 1704 | // create default forwarder for postmaster@domain.tld to the account's reseller |
|---|
| | 1705 | $rs = exec_query($sql, $query, |
|---|
| | 1706 | array('postmaster', |
|---|
| | 1707 | '_no_', |
|---|
| | 1708 | $_SESSION['user_email'], |
|---|
| | 1709 | $dmn_id, |
|---|
| | 1710 | $forward_type, |
|---|
| | 1711 | $sub_id, |
|---|
| | 1712 | $cfg['ITEM_ADD_STATUS'], |
|---|
| | 1713 | '_no_', |
|---|
| | 1714 | 10485760, |
|---|
| | 1715 | 'postmaster@'.$dmn_part |
|---|
| | 1716 | ) |
|---|
| | 1717 | ); |
|---|
| | 1718 | |
|---|
| | 1719 | // create default forwarder for abuse@domain.tld to the account's reseller |
|---|
| | 1720 | $rs = exec_query($sql, $query, |
|---|
| | 1721 | array('abuse', |
|---|
| | 1722 | '_no_', |
|---|
| | 1723 | $_SESSION['user_email'], |
|---|
| | 1724 | $dmn_id, |
|---|
| | 1725 | $forward_type, |
|---|
| | 1726 | $sub_id, |
|---|
| | 1727 | $cfg['ITEM_ADD_STATUS'], |
|---|
| | 1728 | '_no_', |
|---|
| | 1729 | 10485760, |
|---|
| | 1730 | 'abuse@'.$dmn_part |
|---|
| | 1731 | ) |
|---|
| | 1732 | ); |
|---|
| | 1733 | |
|---|
| | 1734 | } |
|---|
| | 1735 | |
|---|
| | 1736 | } // end client_mail_add_default_accounts |
|---|
| | 1737 | |
|---|
| | 1738 | |
|---|
| 1663 | 1739 | ?> |
|---|
| r1014 |
r1020 |
|
| 193 | 193 | $user_email = $rs->fields['email']; |
|---|
| 194 | 194 | |
|---|
| | 195 | // Create the 3 default addresses if wanted |
|---|
| | 196 | if ($cfg['CREATE_DEFAULT_EMAIL_ADDRESSES']) client_mail_add_default_accounts($cr_user_id, $user_email, $alias_name, 'alias', $als_id); |
|---|
| | 197 | /* |
|---|
| 195 | 198 | if ($cfg['CREATE_DEFAULT_EMAIL_ADDRESSES']) { |
|---|
| 196 | 199 | $query = <<<SQL_QUERY |
|---|
| … | … | |
| 238 | 241 | '_no_')); |
|---|
| 239 | 242 | } |
|---|
| 240 | | |
|---|
| | 243 | */ |
|---|
| 241 | 244 | send_request(); |
|---|
| 242 | 245 | $admin_login = $_SESSION['user_logged']; |
|---|
| r1014 |
r1020 |
|
| 57 | 57 | $query = "SELECT alias_name FROM domain_aliasses WHERE alias_id=?"; |
|---|
| 58 | 58 | $rs = exec_query($sql, $query, $act_id); |
|---|
| 59 | | if ($rs -> RecordCount() == 0) { |
|---|
| 60 | | header('Location: domain_alias.php'); |
|---|
| 61 | | die(); |
|---|
| 62 | | } |
|---|
| | 59 | if ($rs -> RecordCount() == 0) { |
|---|
| | 60 | header('Location: domain_alias.php'); |
|---|
| | 61 | die(); |
|---|
| | 62 | } |
|---|
| 63 | 63 | $alias_name = $rs -> fields['alias_name']; |
|---|
| 64 | 64 | |
|---|
| … | … | |
| 66 | 66 | $rs = exec_query($sql, $query, $act_id); |
|---|
| 67 | 67 | |
|---|
| | 68 | $domain_id = who_owns_this($act_id, 'als_id', true); |
|---|
| | 69 | $query = 'SELECT `email` FROM `admin`, `domain` WHERE `admin`.`admin_id` = `domain`.`domain_admin_id` AND `domain`.`domain_id`= ?'; |
|---|
| | 70 | $rs = exec_query($sql, $query, $domain_id); |
|---|
| | 71 | if ($rs -> RecordCount() == 0) { |
|---|
| | 72 | header('Location: domain_alias.php'); |
|---|
| | 73 | die(); |
|---|
| | 74 | } |
|---|
| | 75 | $user_email = $rs -> fields['email']; |
|---|
| | 76 | // Create the 3 default addresses if wanted |
|---|
| | 77 | if ($cfg['CREATE_DEFAULT_EMAIL_ADDRESSES']) client_mail_add_default_accounts($domain_id, $user_email, $alias_name, 'alias', $act_id); |
|---|
| | 78 | |
|---|
| 68 | 79 | // enable "ordered"/pending email accounts |
|---|
| 69 | | $domain_id = who_owns_this($act_id, 'als_id', true); |
|---|
| | 80 | // ??? are there pending mail_adresses ???, joximu |
|---|
| 70 | 81 | $query = "UPDATE mail_users SET status=? WHERE sub_id=? AND domain_id = ? AND status=? AND mail_type LIKE 'alias%'"; |
|---|
| 71 | 82 | $rs = exec_query($sql, $query, array($cfg['ITEM_ADD_STATUS'], $act_id, $domain_id, $cfg['ITEM_ORDERED_STATUS'])); |
|---|
| r1015 |
r1020 |
|
| 327 | 327 | $dmn_id = $sql->Insert_ID(); |
|---|
| 328 | 328 | |
|---|
| | 329 | // Create the 3 default addresses if wanted |
|---|
| | 330 | if ($cfg['CREATE_DEFAULT_EMAIL_ADDRESSES']) client_mail_add_default_accounts($dmn_id, $user_email, $dmn_name); // 'domain', 0 |
|---|
| | 331 | |
|---|
| | 332 | /* |
|---|
| 329 | 333 | if ($cfg['CREATE_DEFAULT_EMAIL_ADDRESSES']) { |
|---|
| 330 | 334 | $query = <<<SQL_QUERY |
|---|
| … | … | |
| 372 | 376 | '_no_')); |
|---|
| 373 | 377 | } |
|---|
| 374 | | |
|---|
| | 378 | */ |
|---|
| 375 | 379 | // add_domain_extras($dmn_id, $record_id, $sql); |
|---|
| 376 | 380 | // lets send mail to user |
|---|
| r371 |
r1020 |
|
| 363 | 363 | |
|---|
| 364 | 364 | #buttonsright { |
|---|
| 365 | | margin-top: 88px; |
|---|
| 366 | | |
|---|
| | 365 | position: relative; |
|---|
| | 366 | top: 68px; |
|---|
| 367 | 367 | } |
|---|
| 368 | 368 | .login { |
|---|
|