* */ /** * Class ReopenMail : Contains all the specific functions to reopen a mail * * @author Claire Figueras * @license GPL * @package Maarch LetterBox 2.0 * @version 2.0 */ class ReopenMail extends dbquery { /** * Redefinition of the LetterBox object constructor */ function __construct() { parent::__construct(); } /** * Checks the res_id * * @param string $mode add or up */ public function reopen_mail_check() { if (empty($_REQUEST['id'])) { $_SESSION['error'] = _ID . ' ' . _IS_EMPTY; } else { $_SESSION['m_admin']['reopen_mail']['ID'] = $this->wash( $_REQUEST['id'], 'num', _ID . ' '); } } /** * Update databse * */ public function update_db() { // add ou modify users in the database $this->reopen_mail_check(); if (! empty($_SESSION['error'])) { header( 'location: ' . $_SESSION['config']['businessappurl'] . 'index.php?page=reopen_mail&id=' . $_SESSION['m_admin']['reopen_mail']['ID'] . '&admin=reopen_mail' ); exit(); } else { require_once 'core/class/class_security.php'; $sec = new security(); $ind_coll = $sec->get_ind_collection('letterbox_coll'); $table = $_SESSION['collections'][$ind_coll]['table']; $this->connect(); $this->query( 'select res_id from ' . $table . ' where res_id = ' . $_SESSION['m_admin']['reopen_mail']['ID'] ); if ($this->nb_result() == 0) { $_SESSION['error'] = _NUM_GED . ' ' . _UNKNOWN; header( 'location: ' . $_SESSION['config']['businessappurl'] . 'index.php?page=reopen_mail&id=' . $_SESSION['m_admin']['reopen_mail']['ID'] . '&admin=reopen_mail' ); exit(); } $this->query( 'update ' . $table . " set status = 'COU' where res_id = " . $_SESSION['m_admin']['reopen_mail']['ID'] ); if ($_SESSION['history']['resup'] == true) { require_once 'core/class/class_history.php'; $hist = new history(); $hist->add( $table, $_SESSION['m_admin']['reopen_mail']['ID'], 'UP', _REOPEN_THIS_MAIL . ' : ' . $_SESSION['m_admin']['reopen_mail']['ID'], $_SESSION['config']['databasetype'], 'apps' ); } $_SESSION['error'] = _REOPEN_THIS_MAIL . ' : ' . $_SESSION['m_admin']['reopen_mail']['ID']; unset($_SESSION['m_admin']); header( 'location: ' . $_SESSION['config']['businessappurl'] . 'index.php?page=admin' ); exit(); } } /** * Form to reopen a mail * */ public function formreopenmail() { ?>