functions.address_rewriting.inc.php 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494
  1. <?php
  2. function bcc($_action, $_data = null, $attr = null) {
  3. global $pdo;
  4. global $lang;
  5. if ($_SESSION['mailcow_cc_role'] != "admin" && $_SESSION['mailcow_cc_role'] != "domainadmin") {
  6. return false;
  7. }
  8. switch ($_action) {
  9. case 'add':
  10. if (!isset($_SESSION['acl']['bcc_maps']) || $_SESSION['acl']['bcc_maps'] != "1" ) {
  11. $_SESSION['return'][] = array(
  12. 'type' => 'danger',
  13. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  14. 'msg' => 'access_denied'
  15. );
  16. return false;
  17. }
  18. $local_dest = strtolower(trim($_data['local_dest']));
  19. $bcc_dest = $_data['bcc_dest'];
  20. $active = intval($_data['active']);
  21. $type = $_data['type'];
  22. if ($type != 'sender' && $type != 'rcpt') {
  23. $_SESSION['return'][] = array(
  24. 'type' => 'danger',
  25. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  26. 'msg' => 'invalid_bcc_map_type'
  27. );
  28. return false;
  29. }
  30. if (empty($bcc_dest)) {
  31. $_SESSION['return'][] = array(
  32. 'type' => 'danger',
  33. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  34. 'msg' => 'bcc_empty'
  35. );
  36. return false;
  37. }
  38. if (is_valid_domain_name($local_dest)) {
  39. if (!hasDomainAccess($_SESSION['mailcow_cc_username'], $_SESSION['mailcow_cc_role'], $local_dest)) {
  40. $_SESSION['return'][] = array(
  41. 'type' => 'danger',
  42. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  43. 'msg' => 'access_denied'
  44. );
  45. return false;
  46. }
  47. $domain = idn_to_ascii($local_dest);
  48. $local_dest_sane = '@' . idn_to_ascii($local_dest);
  49. }
  50. elseif (filter_var($local_dest, FILTER_VALIDATE_EMAIL)) {
  51. if (!hasMailboxObjectAccess($_SESSION['mailcow_cc_username'], $_SESSION['mailcow_cc_role'], $local_dest)) {
  52. $_SESSION['return'][] = array(
  53. 'type' => 'danger',
  54. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  55. 'msg' => 'access_denied'
  56. );
  57. return false;
  58. }
  59. $domain = mailbox('get', 'mailbox_details', $local_dest)['domain'];
  60. if (empty($domain)) {
  61. return false;
  62. }
  63. $local_dest_sane = $local_dest;
  64. }
  65. else {
  66. return false;
  67. }
  68. if (!filter_var($bcc_dest, FILTER_VALIDATE_EMAIL)) {
  69. $_SESSION['return'][] = array(
  70. 'type' => 'danger',
  71. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  72. 'msg' => 'bcc_must_be_email'
  73. );
  74. return false;
  75. }
  76. $stmt = $pdo->prepare("SELECT `id` FROM `bcc_maps`
  77. WHERE `local_dest` = :local_dest AND `type` = :type");
  78. $stmt->execute(array(':local_dest' => $local_dest_sane, ':type' => $type));
  79. $num_results = count($stmt->fetchAll(PDO::FETCH_ASSOC));
  80. if ($num_results != 0) {
  81. $_SESSION['return'][] = array(
  82. 'type' => 'danger',
  83. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  84. 'msg' => array('bcc_exists', htmlspecialchars($local_dest_sane), $type)
  85. );
  86. return false;
  87. }
  88. try {
  89. $stmt = $pdo->prepare("INSERT INTO `bcc_maps` (`local_dest`, `bcc_dest`, `domain`, `active`, `type`) VALUES
  90. (:local_dest, :bcc_dest, :domain, :active, :type)");
  91. $stmt->execute(array(
  92. ':local_dest' => $local_dest_sane,
  93. ':bcc_dest' => $bcc_dest,
  94. ':domain' => $domain,
  95. ':active' => $active,
  96. ':type' => $type
  97. ));
  98. }
  99. catch (PDOException $e) {
  100. $_SESSION['return'][] = array(
  101. 'type' => 'danger',
  102. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  103. 'msg' => array('mysql_error', $e)
  104. );
  105. return false;
  106. }
  107. $_SESSION['return'][] = array(
  108. 'type' => 'success',
  109. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  110. 'msg' => 'bcc_saved'
  111. );
  112. break;
  113. case 'edit':
  114. if (!isset($_SESSION['acl']['bcc_maps']) || $_SESSION['acl']['bcc_maps'] != "1" ) {
  115. $_SESSION['return'][] = array(
  116. 'type' => 'danger',
  117. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  118. 'msg' => 'access_denied'
  119. );
  120. return false;
  121. }
  122. $ids = (array)$_data['id'];
  123. foreach ($ids as $id) {
  124. $is_now = bcc('details', $id);
  125. if (!empty($is_now)) {
  126. $active = (isset($_data['active'])) ? intval($_data['active']) : $is_now['active_int'];
  127. $bcc_dest = (!empty($_data['bcc_dest'])) ? $_data['bcc_dest'] : $is_now['bcc_dest'];
  128. $local_dest = $is_now['local_dest'];
  129. $type = (!empty($_data['type'])) ? $_data['type'] : $is_now['type'];
  130. }
  131. else {
  132. $_SESSION['return'][] = array(
  133. 'type' => 'danger',
  134. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  135. 'msg' => 'access_denied'
  136. );
  137. continue;
  138. }
  139. $active = intval($_data['active']);
  140. if (!filter_var($bcc_dest, FILTER_VALIDATE_EMAIL)) {
  141. $_SESSION['return'][] = array(
  142. 'type' => 'danger',
  143. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  144. 'msg' => array('bcc_must_be_email', $bcc_dest)
  145. );
  146. continue;
  147. }
  148. if (empty($bcc_dest)) {
  149. $_SESSION['return'][] = array(
  150. 'type' => 'danger',
  151. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  152. 'msg' => array('bcc_must_be_email', $bcc_dest)
  153. );
  154. continue;
  155. }
  156. try {
  157. $stmt = $pdo->prepare("SELECT `id` FROM `bcc_maps`
  158. WHERE `local_dest` = :local_dest AND `type` = :type");
  159. $stmt->execute(array(':local_dest' => $local_dest, ':type' => $type));
  160. $id_now = $stmt->fetch(PDO::FETCH_ASSOC)['id'];
  161. if (isset($id_now) && $id_now != $id) {
  162. $_SESSION['return'][] = array(
  163. 'type' => 'danger',
  164. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  165. 'msg' => array('bcc_exists', htmlspecialchars($local_dest), $type)
  166. );
  167. continue;
  168. }
  169. $stmt = $pdo->prepare("UPDATE `bcc_maps` SET `bcc_dest` = :bcc_dest, `active` = :active, `type` = :type WHERE `id`= :id");
  170. $stmt->execute(array(
  171. ':bcc_dest' => $bcc_dest,
  172. ':active' => $active,
  173. ':type' => $type,
  174. ':id' => $id
  175. ));
  176. }
  177. catch (PDOException $e) {
  178. $_SESSION['return'][] = array(
  179. 'type' => 'danger',
  180. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  181. 'msg' => array('mysql_error', $e)
  182. );
  183. continue;
  184. }
  185. $_SESSION['return'][] = array(
  186. 'type' => 'success',
  187. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  188. 'msg' => array('bcc_edited', $bcc_dest)
  189. );
  190. }
  191. break;
  192. case 'details':
  193. $bccdata = array();
  194. $id = intval($_data);
  195. $stmt = $pdo->prepare("SELECT `id`,
  196. `local_dest`,
  197. `bcc_dest`,
  198. `active` AS `active_int`,
  199. CASE `active` WHEN 1 THEN '".$lang['mailbox']['yes']."' ELSE '".$lang['mailbox']['no']."' END AS `active`,
  200. `type`,
  201. `created`,
  202. `domain`,
  203. `modified` FROM `bcc_maps`
  204. WHERE `id` = :id");
  205. $stmt->execute(array(':id' => $id));
  206. $bccdata = $stmt->fetch(PDO::FETCH_ASSOC);
  207. if (!hasDomainAccess($_SESSION['mailcow_cc_username'], $_SESSION['mailcow_cc_role'], $bccdata['domain'])) {
  208. $bccdata = null;
  209. return false;
  210. }
  211. return $bccdata;
  212. break;
  213. case 'get':
  214. $bccdata = array();
  215. $all_items = array();
  216. $id = intval($_data);
  217. $stmt = $pdo->query("SELECT `id`, `domain` FROM `bcc_maps`");
  218. $all_items = $stmt->fetchAll(PDO::FETCH_ASSOC);
  219. foreach ($all_items as $i) {
  220. if (hasDomainAccess($_SESSION['mailcow_cc_username'], $_SESSION['mailcow_cc_role'], $i['domain'])) {
  221. $bccdata[] = $i['id'];
  222. }
  223. }
  224. $all_items = null;
  225. return $bccdata;
  226. break;
  227. case 'delete':
  228. if (!isset($_SESSION['acl']['bcc_maps']) || $_SESSION['acl']['bcc_maps'] != "1" ) {
  229. $_SESSION['return'][] = array(
  230. 'type' => 'danger',
  231. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  232. 'msg' => 'access_denied'
  233. );
  234. return false;
  235. }
  236. $ids = (array)$_data['id'];
  237. foreach ($ids as $id) {
  238. if (!is_numeric($id)) {
  239. return false;
  240. }
  241. try {
  242. $stmt = $pdo->prepare("SELECT `domain` FROM `bcc_maps` WHERE id = :id");
  243. $stmt->execute(array(':id' => $id));
  244. $domain = $stmt->fetch(PDO::FETCH_ASSOC)['domain'];
  245. if (!hasDomainAccess($_SESSION['mailcow_cc_username'], $_SESSION['mailcow_cc_role'], $domain)) {
  246. $_SESSION['return'][] = array(
  247. 'type' => 'danger',
  248. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  249. 'msg' => 'access_denied'
  250. );
  251. continue;
  252. }
  253. $stmt = $pdo->prepare("DELETE FROM `bcc_maps` WHERE `id`= :id");
  254. $stmt->execute(array(':id' => $id));
  255. }
  256. catch (PDOException $e) {
  257. $_SESSION['return'][] = array(
  258. 'type' => 'danger',
  259. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  260. 'msg' => array('mysql_error', $e)
  261. );
  262. continue;
  263. }
  264. $_SESSION['return'][] = array(
  265. 'type' => 'success',
  266. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  267. 'msg' => array('bcc_deleted', $id)
  268. );
  269. }
  270. break;
  271. }
  272. }
  273. function recipient_map($_action, $_data = null, $attr = null) {
  274. global $pdo;
  275. global $lang;
  276. if ($_SESSION['mailcow_cc_role'] != "admin") {
  277. return false;
  278. }
  279. switch ($_action) {
  280. case 'add':
  281. $old_dest = strtolower(trim($_data['recipient_map_old']));
  282. if (substr($old_dest, 0, 1) == '@') {
  283. $old_dest = substr($old_dest, 1);
  284. }
  285. $new_dest = strtolower(trim($_data['recipient_map_new']));
  286. $active = intval($_data['active']);
  287. if (is_valid_domain_name($old_dest)) {
  288. $old_dest_sane = '@' . idn_to_ascii($old_dest);
  289. }
  290. elseif (filter_var($old_dest, FILTER_VALIDATE_EMAIL)) {
  291. $old_dest_sane = $old_dest;
  292. }
  293. else {
  294. $_SESSION['return'][] = array(
  295. 'type' => 'danger',
  296. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  297. 'msg' => array('invalid_recipient_map_old', htmlspecialchars($old_dest))
  298. );
  299. return false;
  300. }
  301. if (!filter_var($new_dest, FILTER_VALIDATE_EMAIL)) {
  302. $_SESSION['return'][] = array(
  303. 'type' => 'danger',
  304. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  305. 'msg' => array('invalid_recipient_map_new', htmlspecialchars($new_dest))
  306. );
  307. return false;
  308. }
  309. $rmaps = recipient_map('get');
  310. foreach ($rmaps as $rmap) {
  311. $old_dests_existing[] = recipient_map('details', $rmap)['recipient_map_old'];
  312. }
  313. if (in_array($old_dest_sane, $old_dests_existing)) {
  314. $_SESSION['return'][] = array(
  315. 'type' => 'danger',
  316. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  317. 'msg' => array('recipient_map_entry_exists', htmlspecialchars($old_dest))
  318. );
  319. return false;
  320. }
  321. try {
  322. $stmt = $pdo->prepare("INSERT INTO `recipient_maps` (`old_dest`, `new_dest`, `active`) VALUES
  323. (:old_dest, :new_dest, :active)");
  324. $stmt->execute(array(
  325. ':old_dest' => $old_dest_sane,
  326. ':new_dest' => $new_dest,
  327. ':active' => $active
  328. ));
  329. }
  330. catch (PDOException $e) {
  331. $_SESSION['return'][] = array(
  332. 'type' => 'danger',
  333. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  334. 'msg' => array('mysql_error', $e)
  335. );
  336. return false;
  337. }
  338. $_SESSION['return'][] = array(
  339. 'type' => 'success',
  340. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  341. 'msg' => array('recipient_map_entry_saved', htmlspecialchars($old_dest_sane))
  342. );
  343. break;
  344. case 'edit':
  345. $ids = (array)$_data['id'];
  346. foreach ($ids as $id) {
  347. $is_now = recipient_map('details', $id);
  348. if (!empty($is_now)) {
  349. $active = (isset($_data['active'])) ? intval($_data['active']) : $is_now['active_int'];
  350. $new_dest = (!empty($_data['recipient_map_new'])) ? $_data['recipient_map_new'] : $is_now['recipient_map_new'];
  351. $old_dest = (!empty($_data['recipient_map_old'])) ? $_data['recipient_map_old'] : $is_now['recipient_map_old'];
  352. if (substr($old_dest, 0, 1) == '@') {
  353. $old_dest = substr($old_dest, 1);
  354. }
  355. }
  356. else {
  357. $_SESSION['return'][] = array(
  358. 'type' => 'danger',
  359. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  360. 'msg' => 'access_denied'
  361. );
  362. continue;
  363. }
  364. if (is_valid_domain_name($old_dest)) {
  365. $old_dest_sane = '@' . idn_to_ascii($old_dest);
  366. }
  367. elseif (filter_var($old_dest, FILTER_VALIDATE_EMAIL)) {
  368. $old_dest_sane = $old_dest;
  369. }
  370. else {
  371. $_SESSION['return'][] = array(
  372. 'type' => 'danger',
  373. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  374. 'msg' => array('invalid_recipient_map_old', htmlspecialchars($old_dest))
  375. );
  376. continue;
  377. }
  378. $active = intval($_data['active']);
  379. if (!filter_var($new_dest, FILTER_VALIDATE_EMAIL)) {
  380. $_SESSION['return'][] = array(
  381. 'type' => 'danger',
  382. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  383. 'msg' => array('invalid_recipient_map_new', htmlspecialchars($new_dest))
  384. );
  385. continue;
  386. }
  387. $rmaps = recipient_map('get');
  388. foreach ($rmaps as $rmap) {
  389. $old_dests_existing[] = recipient_map('details', $rmap)['recipient_map_old'];
  390. }
  391. if (in_array($old_dest_sane, $old_dests_existing) &&
  392. recipient_map('details', $id)['recipient_map_old'] != $old_dest_sane) {
  393. $_SESSION['return'][] = array(
  394. 'type' => 'danger',
  395. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  396. 'msg' => array('recipient_map_entry_exists', htmlspecialchars($old_dest_sane))
  397. );
  398. continue;
  399. }
  400. try {
  401. $stmt = $pdo->prepare("UPDATE `recipient_maps` SET
  402. `old_dest` = :old_dest,
  403. `new_dest` = :new_dest,
  404. `active` = :active
  405. WHERE `id`= :id");
  406. $stmt->execute(array(
  407. ':old_dest' => $old_dest_sane,
  408. ':new_dest' => $new_dest,
  409. ':active' => $active,
  410. ':id' => $id
  411. ));
  412. }
  413. catch (PDOException $e) {
  414. $_SESSION['return'][] = array(
  415. 'type' => 'danger',
  416. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  417. 'msg' => array('mysql_error', $e)
  418. );
  419. return false;
  420. }
  421. $_SESSION['return'][] = array(
  422. 'type' => 'success',
  423. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  424. 'msg' => array('recipient_map_entry_saved', htmlspecialchars($old_dest_sane))
  425. );
  426. }
  427. break;
  428. case 'details':
  429. $mapdata = array();
  430. $id = intval($_data);
  431. $stmt = $pdo->prepare("SELECT `id`,
  432. `old_dest` AS `recipient_map_old`,
  433. `new_dest` AS `recipient_map_new`,
  434. `active` AS `active_int`,
  435. CASE `active` WHEN 1 THEN '".$lang['mailbox']['yes']."' ELSE '".$lang['mailbox']['no']."' END AS `active`,
  436. `created`,
  437. `modified` FROM `recipient_maps`
  438. WHERE `id` = :id");
  439. $stmt->execute(array(':id' => $id));
  440. $mapdata = $stmt->fetch(PDO::FETCH_ASSOC);
  441. return $mapdata;
  442. break;
  443. case 'get':
  444. $mapdata = array();
  445. $all_items = array();
  446. $id = intval($_data);
  447. $stmt = $pdo->query("SELECT `id` FROM `recipient_maps`");
  448. $all_items = $stmt->fetchAll(PDO::FETCH_ASSOC);
  449. foreach ($all_items as $i) {
  450. $mapdata[] = $i['id'];
  451. }
  452. $all_items = null;
  453. return $mapdata;
  454. break;
  455. case 'delete':
  456. $ids = (array)$_data['id'];
  457. foreach ($ids as $id) {
  458. if (!is_numeric($id)) {
  459. return false;
  460. }
  461. try {
  462. $stmt = $pdo->prepare("DELETE FROM `recipient_maps` WHERE `id`= :id");
  463. $stmt->execute(array(':id' => $id));
  464. }
  465. catch (PDOException $e) {
  466. $_SESSION['return'][] = array(
  467. 'type' => 'danger',
  468. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  469. 'msg' => array('mysql_error', $e)
  470. );
  471. return false;
  472. }
  473. }
  474. $_SESSION['return'][] = array(
  475. 'type' => 'success',
  476. 'msg' => array('recipient_map_entry_deleted', htmlspecialchars($old_dest))
  477. );
  478. return true;
  479. break;
  480. }
  481. }