function send_mail($to, $subj, $msg)
{
global $CONF, $CONF_MAIL, $dbConnection;
if (get_conf_param('mail_type') == "sendmail") {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$mail->IsSendmail();
$mail->AddReplyTo($CONF_MAIL['from'], $CONF['name_of_firm']);
$mail->AddAddress($to, $to);
$mail->SetFrom($CONF_MAIL['from'], $CONF['name_of_firm']);
$mail->Subject = $subj;
$mail->AltBody = 'To view the message, please use an HTML compatible email viewer!';
$mail->MsgHTML($msg);
$mail->Send();
} else {
if (get_conf_param('mail_type') == "SMTP") {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$mail->IsSMTP();
$mail->SMTPAuth = $CONF_MAIL['auth'];
// enable SMTP authentication
if (get_conf_param('mail_auth_type') != "none") {
$mail->SMTPSecure = $CONF_MAIL['auth_type'];
}
$mail->Host = $CONF_MAIL['host'];
$mail->Port = $CONF_MAIL['port'];
$mail->Username = $CONF_MAIL['username'];
$mail->Password = $CONF_MAIL['password'];
$mail->AddReplyTo($CONF_MAIL['from'], $CONF['name_of_firm']);
$mail->AddAddress($to, $to);
$mail->SetFrom($CONF_MAIL['from'], $CONF['name_of_firm']);
$mail->Subject = $subj;
$mail->AltBody = 'To view the message, please use an HTML compatible email viewer!';
// optional - MsgHTML will create an alternate automatically
$mail->MsgHTML($msg);
$mail->Send();
}
}
}
?>
">
</div>
</div>
<div class="form-group">
<label for="password" class="col-sm-4 control-label"><small><?php
echo lang('CONF_mail_pass');
?>
</small></label>
<div class="col-sm-8">
<input type="password" class="form-control input-sm" id="password" placeholder="<?php
echo lang('CONF_mail_pass');
?>
" value="<?php
echo get_conf_param('mail_password');
?>
">
</div>
</div>
</div>
<div class="col-md-offset-3 col-md-6">
<center>
<button type="submit" id="conf_edit_mail" class="btn btn-success"><i class="fa fa-pencil"></i> <?php
echo lang('CONF_act_edit');
?>
</button>
} catch (Exception $e) {
echo $e->getMessage();
//Boring error messages from anything else!
}
} else {
if (get_conf_param('mail_type') == "SMTP") {
$mail = new PHPMailer(true);
// the true param means it will throw exceptions on errors, which we need to catch
$mail->IsSMTP();
// telling the class to use SMTP
try {
$mail->SMTPDebug = 2;
// enables SMTP debug information (for testing)
$mail->SMTPAuth = $CONF_MAIL['auth'];
// enable SMTP authentication
if (get_conf_param('mail_auth_type') != "none") {
$mail->SMTPSecure = $CONF_MAIL['auth_type'];
}
$mail->Host = $CONF_MAIL['host'];
$mail->Port = $CONF_MAIL['port'];
$mail->Username = $CONF_MAIL['username'];
$mail->Password = $CONF_MAIL['password'];
$mail->AddReplyTo($CONF_MAIL['from'], $CONF['name_of_firm']);
$mail->AddAddress($CONF['mail'], 'admin helpdesk');
$mail->SetFrom($CONF_MAIL['from'], $CONF['name_of_firm']);
$mail->Subject = 'test message via smtp';
$mail->AltBody = 'To view the message, please use an HTML compatible email viewer!';
// optional - MsgHTML will create an alternate automatically
$mail->MsgHTML("test message");
$mail->Send();
echo "Message Sent OK<p></p>\n";
<?php
include_once 'conf.php';
include_once 'sys/class.phpmailer.php';
include_once 'sys/Parsedown.php';
require 'library/HTMLPurifier.auto.php';
date_default_timezone_set('Europe/Kiev');
$dbConnection = new PDO('mysql:host=' . $CONF_DB['host'] . ';dbname=' . $CONF_DB['db_name'], $CONF_DB['username'], $CONF_DB['password'], array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
$dbConnection->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$dbConnection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$CONF = array('title_header' => get_conf_param('title_header'), 'hostname' => get_conf_param('hostname'), 'mail' => get_conf_param('mail'), 'days2arch' => get_conf_param('days2arch'), 'name_of_firm' => get_conf_param('name_of_firm'), 'fix_subj' => get_conf_param('fix_subj'), 'first_login' => get_conf_param('first_login'), 'file_uploads' => get_conf_param('file_uploads'), 'file_types' => '(' . get_conf_param('file_types') . ')', 'file_size' => get_conf_param('file_size'));
$CONF_MAIL = array('active' => get_conf_param('mail_active'), 'host' => get_conf_param('mail_host'), 'port' => get_conf_param('mail_port'), 'auth' => get_conf_param('mail_auth'), 'auth_type' => get_conf_param('mail_auth_type'), 'username' => get_conf_param('mail_username'), 'password' => get_conf_param('mail_password'), 'from' => get_conf_param('mail_from'), 'debug' => 'false');
if ($CONF_HD['debug_mode'] == false) {
error_reporting(E_ALL ^ E_NOTICE);
error_reporting(0);
}
include_once 'inc/mail.inc.php';
$forhostname = substr($CONF['hostname'], -1);
if ($forhostname == "/") {
$CONF['hostname'] = $CONF['hostname'];
} else {
if ($forhostname != "/") {
$CONF['hostname'] = $CONF['hostname'] . "/";
}
}
function get_user_lang()
{
global $dbConnection;
$mid = $_SESSION['helpdesk_user_id'];
$stmt = $dbConnection->prepare('SELECT lang from users where id=:mid');
$stmt->execute(array(':mid' => $mid));
{
$time = time() - $time;
return floor($time / 86400);
}
$dbConnection = new PDO('mysql:host=' . $CONF_DB['host'] . ';dbname=' . $CONF_DB['db_name'], $CONF_DB['username'], $CONF_DB['password'], array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
$dbConnection->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$dbConnection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
function get_conf_param($in)
{
global $dbConnection;
$stmt = $dbConnection->prepare('SELECT value FROM perf where param=:in');
$stmt->execute(array(':in' => $in));
$con = $stmt->fetch(PDO::FETCH_ASSOC);
return $con['value'];
}
$CONF = array('days2arch' => get_conf_param('days2arch'));
/*
5 0 * * * /usr/bin/php5 -f /var/www/hd_prod/sys/4cron.php > /var/www/hd_prod/4cron.log 2>&1
*/
$stmt = $dbConnection->prepare('SELECT id, ok_by, ok_date,date_create
from tickets
where arch=:n1 and ok_by !=:n2');
$stmt->execute(array(':n1' => '0', ':n2' => '0'));
$res1 = $stmt->fetchAll();
foreach ($res1 as $row) {
$m = $row['id'];
$td = humanTiming_old(strtotime($row['ok_date'])) . "<br>";
if ($td > $CONF['days2arch']) {
$stmt = $dbConnection->prepare('update tickets set arch=:n1, last_update=now() where id=:m');
$stmt->execute(array(':n1' => '1', ':m' => $m));
$stmt = $dbConnection->prepare('INSERT INTO ticket_log (msg, date_op, ticket_id)
