functions.address_rewriting.inc.php 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486
  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. $ids = (array)$_data['id'];
  229. foreach ($ids as $id) {
  230. if (!is_numeric($id)) {
  231. return false;
  232. }
  233. try {
  234. $stmt = $pdo->prepare("SELECT `domain` FROM `bcc_maps` WHERE id = :id");
  235. $stmt->execute(array(':id' => $id));
  236. $domain = $stmt->fetch(PDO::FETCH_ASSOC)['domain'];
  237. if (!hasDomainAccess($_SESSION['mailcow_cc_username'], $_SESSION['mailcow_cc_role'], $domain)) {
  238. $_SESSION['return'][] = array(
  239. 'type' => 'danger',
  240. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  241. 'msg' => 'access_denied'
  242. );
  243. continue;
  244. }
  245. $stmt = $pdo->prepare("DELETE FROM `bcc_maps` WHERE `id`= :id");
  246. $stmt->execute(array(':id' => $id));
  247. }
  248. catch (PDOException $e) {
  249. $_SESSION['return'][] = array(
  250. 'type' => 'danger',
  251. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  252. 'msg' => array('mysql_error', $e)
  253. );
  254. continue;
  255. }
  256. $_SESSION['return'][] = array(
  257. 'type' => 'success',
  258. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  259. 'msg' => array('bcc_deleted', $id)
  260. );
  261. }
  262. break;
  263. }
  264. }
  265. function recipient_map($_action, $_data = null, $attr = null) {
  266. global $pdo;
  267. global $lang;
  268. if ($_SESSION['mailcow_cc_role'] != "admin") {
  269. return false;
  270. }
  271. switch ($_action) {
  272. case 'add':
  273. $old_dest = strtolower(trim($_data['recipient_map_old']));
  274. if (substr($old_dest, 0, 1) == '@') {
  275. $old_dest = substr($old_dest, 1);
  276. }
  277. $new_dest = strtolower(trim($_data['recipient_map_new']));
  278. $active = intval($_data['active']);
  279. if (is_valid_domain_name($old_dest)) {
  280. $old_dest_sane = '@' . idn_to_ascii($old_dest);
  281. }
  282. elseif (filter_var($old_dest, FILTER_VALIDATE_EMAIL)) {
  283. $old_dest_sane = $old_dest;
  284. }
  285. else {
  286. $_SESSION['return'][] = array(
  287. 'type' => 'danger',
  288. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  289. 'msg' => array('invalid_recipient_map_old', htmlspecialchars($old_dest))
  290. );
  291. return false;
  292. }
  293. if (!filter_var($new_dest, FILTER_VALIDATE_EMAIL)) {
  294. $_SESSION['return'][] = array(
  295. 'type' => 'danger',
  296. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  297. 'msg' => array('invalid_recipient_map_new', htmlspecialchars($new_dest))
  298. );
  299. return false;
  300. }
  301. $rmaps = recipient_map('get');
  302. foreach ($rmaps as $rmap) {
  303. $old_dests_existing[] = recipient_map('details', $rmap)['recipient_map_old'];
  304. }
  305. if (in_array($old_dest_sane, $old_dests_existing)) {
  306. $_SESSION['return'][] = array(
  307. 'type' => 'danger',
  308. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  309. 'msg' => array('recipient_map_entry_exists', htmlspecialchars($old_dest))
  310. );
  311. return false;
  312. }
  313. try {
  314. $stmt = $pdo->prepare("INSERT INTO `recipient_maps` (`old_dest`, `new_dest`, `active`) VALUES
  315. (:old_dest, :new_dest, :active)");
  316. $stmt->execute(array(
  317. ':old_dest' => $old_dest_sane,
  318. ':new_dest' => $new_dest,
  319. ':active' => $active
  320. ));
  321. }
  322. catch (PDOException $e) {
  323. $_SESSION['return'][] = array(
  324. 'type' => 'danger',
  325. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  326. 'msg' => array('mysql_error', $e)
  327. );
  328. return false;
  329. }
  330. $_SESSION['return'][] = array(
  331. 'type' => 'success',
  332. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  333. 'msg' => array('recipient_map_entry_saved', htmlspecialchars($old_dest_sane))
  334. );
  335. break;
  336. case 'edit':
  337. $ids = (array)$_data['id'];
  338. foreach ($ids as $id) {
  339. $is_now = recipient_map('details', $id);
  340. if (!empty($is_now)) {
  341. $active = (isset($_data['active'])) ? intval($_data['active']) : $is_now['active_int'];
  342. $new_dest = (!empty($_data['recipient_map_new'])) ? $_data['recipient_map_new'] : $is_now['recipient_map_new'];
  343. $old_dest = (!empty($_data['recipient_map_old'])) ? $_data['recipient_map_old'] : $is_now['recipient_map_old'];
  344. if (substr($old_dest, 0, 1) == '@') {
  345. $old_dest = substr($old_dest, 1);
  346. }
  347. }
  348. else {
  349. $_SESSION['return'][] = array(
  350. 'type' => 'danger',
  351. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  352. 'msg' => 'access_denied'
  353. );
  354. continue;
  355. }
  356. if (is_valid_domain_name($old_dest)) {
  357. $old_dest_sane = '@' . idn_to_ascii($old_dest);
  358. }
  359. elseif (filter_var($old_dest, FILTER_VALIDATE_EMAIL)) {
  360. $old_dest_sane = $old_dest;
  361. }
  362. else {
  363. $_SESSION['return'][] = array(
  364. 'type' => 'danger',
  365. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  366. 'msg' => array('invalid_recipient_map_old', htmlspecialchars($old_dest))
  367. );
  368. continue;
  369. }
  370. $active = intval($_data['active']);
  371. if (!filter_var($new_dest, FILTER_VALIDATE_EMAIL)) {
  372. $_SESSION['return'][] = array(
  373. 'type' => 'danger',
  374. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  375. 'msg' => array('invalid_recipient_map_new', htmlspecialchars($new_dest))
  376. );
  377. continue;
  378. }
  379. $rmaps = recipient_map('get');
  380. foreach ($rmaps as $rmap) {
  381. $old_dests_existing[] = recipient_map('details', $rmap)['recipient_map_old'];
  382. }
  383. if (in_array($old_dest_sane, $old_dests_existing) &&
  384. recipient_map('details', $id)['recipient_map_old'] != $old_dest_sane) {
  385. $_SESSION['return'][] = array(
  386. 'type' => 'danger',
  387. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  388. 'msg' => array('recipient_map_entry_exists', htmlspecialchars($old_dest_sane))
  389. );
  390. continue;
  391. }
  392. try {
  393. $stmt = $pdo->prepare("UPDATE `recipient_maps` SET
  394. `old_dest` = :old_dest,
  395. `new_dest` = :new_dest,
  396. `active` = :active
  397. WHERE `id`= :id");
  398. $stmt->execute(array(
  399. ':old_dest' => $old_dest_sane,
  400. ':new_dest' => $new_dest,
  401. ':active' => $active,
  402. ':id' => $id
  403. ));
  404. }
  405. catch (PDOException $e) {
  406. $_SESSION['return'][] = array(
  407. 'type' => 'danger',
  408. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  409. 'msg' => array('mysql_error', $e)
  410. );
  411. return false;
  412. }
  413. $_SESSION['return'][] = array(
  414. 'type' => 'success',
  415. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  416. 'msg' => array('recipient_map_entry_saved', htmlspecialchars($old_dest_sane))
  417. );
  418. }
  419. break;
  420. case 'details':
  421. $mapdata = array();
  422. $id = intval($_data);
  423. $stmt = $pdo->prepare("SELECT `id`,
  424. `old_dest` AS `recipient_map_old`,
  425. `new_dest` AS `recipient_map_new`,
  426. `active` AS `active_int`,
  427. CASE `active` WHEN 1 THEN '".$lang['mailbox']['yes']."' ELSE '".$lang['mailbox']['no']."' END AS `active`,
  428. `created`,
  429. `modified` FROM `recipient_maps`
  430. WHERE `id` = :id");
  431. $stmt->execute(array(':id' => $id));
  432. $mapdata = $stmt->fetch(PDO::FETCH_ASSOC);
  433. return $mapdata;
  434. break;
  435. case 'get':
  436. $mapdata = array();
  437. $all_items = array();
  438. $id = intval($_data);
  439. $stmt = $pdo->query("SELECT `id` FROM `recipient_maps`");
  440. $all_items = $stmt->fetchAll(PDO::FETCH_ASSOC);
  441. foreach ($all_items as $i) {
  442. $mapdata[] = $i['id'];
  443. }
  444. $all_items = null;
  445. return $mapdata;
  446. break;
  447. case 'delete':
  448. $ids = (array)$_data['id'];
  449. foreach ($ids as $id) {
  450. if (!is_numeric($id)) {
  451. return false;
  452. }
  453. try {
  454. $stmt = $pdo->prepare("DELETE FROM `recipient_maps` WHERE `id`= :id");
  455. $stmt->execute(array(':id' => $id));
  456. }
  457. catch (PDOException $e) {
  458. $_SESSION['return'][] = array(
  459. 'type' => 'danger',
  460. 'log' => array(__FUNCTION__, $_action, $_data, $_attr),
  461. 'msg' => array('mysql_error', $e)
  462. );
  463. return false;
  464. }
  465. }
  466. $_SESSION['return'][] = array(
  467. 'type' => 'success',
  468. 'msg' => array('recipient_map_entry_deleted', htmlspecialchars($old_dest))
  469. );
  470. return true;
  471. break;
  472. }
  473. }