本文整理汇总了PHP中hesk_dbEscape函数的典型用法代码示例。如果您正苦于以下问题:PHP hesk_dbEscape函数的具体用法?PHP hesk_dbEscape怎么用?PHP hesk_dbEscape使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了hesk_dbEscape函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: hesk_dbFormatEmail
function hesk_dbFormatEmail($email, $field = 'email')
{
global $hesk_settings;
$email = hesk_dbLike($email);
if ($hesk_settings['multi_eml']) {
return " (`" . hesk_dbEscape($field) . "` LIKE '" . hesk_dbEscape($email) . "' OR `" . hesk_dbEscape($field) . "` LIKE '%," . hesk_dbEscape($email) . "' OR `" . hesk_dbEscape($field) . "` LIKE '" . hesk_dbEscape($email) . ",%' OR `" . hesk_dbEscape($field) . "` LIKE '%," . hesk_dbEscape($email) . ",%') ";
} else {
return " `" . hesk_dbEscape($field) . "` LIKE '" . hesk_dbEscape($email) . "' ";
}
}
开发者ID:ermedita-xhafaj,项目名称:support,代码行数:10,代码来源:database_mysqli.inc.php
示例2: removeOtherColumns
function removeOtherColumns()
{
executeQuery("ALTER TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "users` DROP COLUMN `autorefresh`");
executeQuery("ALTER TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "tickets` DROP COLUMN `parent`");
executeQuery("ALTER TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "users` DROP COLUMN `can_manage_settings`");
executeQuery("ALTER TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "users` DROP COLUMN `active`");
executeQuery("ALTER TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "users` DROP COLUMN `notify_note_unassigned`");
executeQuery("ALTER TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "users` DROP COLUMN `can_change_notification_settings`");
executeQuery("DROP TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "settings`");
executeQuery("DROP TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "verified_emails`");
executeQuery("DROP TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "pending_verification_emails`");
executeQuery("DROP TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "stage_tickets`");
executeQuery("ALTER TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "service_messages` DROP COLUMN `icon`");
executeQuery("ALTER TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "tickets` DROP COLUMN `latitude`");
executeQuery("ALTER TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "tickets` DROP COLUMN `longitude`");
executeQuery("ALTER TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "stage_tickets` DROP COLUMN `latitude`");
executeQuery("ALTER TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "stage_tickets` DROP COLUMN `longitude`");
executeQuery("ALTER TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "categories` DROP COLUMN `manager`");
executeQuery("ALTER TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "users` DROP COLUMN `permission_template`");
executeQuery("DROP TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "permission_templates`");
// These queries are ran in case someone used an unfortunate installation they may have not properly cleaned up tables
executeQuery('DROP TABLE IF EXISTS `' . hesk_dbEscape($hesk_settings['db_pfix']) . 'denied_ips`');
executeQuery('DROP TABLE IF EXISTS `' . hesk_dbEscape($hesk_settings['db_pfix']) . 'denied_emails`');
}
开发者ID:Orgoth,项目名称:Mods-for-HESK,代码行数:24,代码来源:uninstallSql.php
示例3: hesk_printCustomerReplyForm
</tr>
<tr>
<td><img src="img/roundcornerslb.jpg" width="7" height="7" alt="" /></td>
<td class="roundcornersbottom"></td>
<td width="7" height="7"><img src="img/roundcornersrb.jpg" width="7" height="7" alt="" /></td>
</tr>
</table>
<?php
/* Print "Submit a reply" form? */
if ($ticket['locked'] != 1 && $ticket['status'] != 3 && !$hesk_settings['reply_top']) {
hesk_printCustomerReplyForm();
}
/* If needed update unread replies as read for staff to know */
if (count($unread_replies)) {
hesk_dbQuery("UPDATE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "replies` SET `read` = '1' WHERE `id` IN ('" . implode("','", $unread_replies) . "')");
}
/* Clear unneeded session variables */
hesk_cleanSessionVars('ticket_message');
require_once HESK_PATH . 'inc/footer.inc.php';
/*** START FUNCTIONS ***/
function print_form()
{
global $hesk_settings, $hesklang;
global $hesk_error_buffer, $my_email, $trackingID, $do_remember, $display;
/* Print header */
$hesk_settings['tmp_title'] = $hesk_settings['hesk_title'] . ' - ' . $hesklang['view_ticket'];
require_once HESK_PATH . 'inc/header.inc.php';
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
开发者ID:riansopian,项目名称:hesk,代码行数:31,代码来源:ticket.php
示例4: update_profile
function update_profile()
{
global $hesk_settings, $hesklang, $can_view_unassigned;
/* A security check */
hesk_token_check('POST');
$sql_pass = '';
$sql_username = '';
$hesk_error_buffer = '';
$_SESSION['new']['name'] = hesk_input(hesk_POST('name')) or $hesk_error_buffer .= '<li>' . $hesklang['enter_your_name'] . '</li>';
$_SESSION['new']['email'] = hesk_validateEmail(hesk_POST('email'), 'ERR', 0) or $hesk_error_buffer = '<li>' . $hesklang['enter_valid_email'] . '</li>';
$_SESSION['new']['signature'] = hesk_input(hesk_POST('signature'));
/* Signature */
if (strlen($_SESSION['new']['signature']) > 255) {
$hesk_error_buffer .= '<li>' . $hesklang['signature_long'] . '</li>';
}
/* Admins can change username */
if ($_SESSION['isadmin']) {
$_SESSION['new']['user'] = hesk_input(hesk_POST('user')) or $hesk_error_buffer .= '<li>' . $hesklang['enter_username'] . '</li>';
/* Check for duplicate usernames */
$result = hesk_dbQuery("SELECT `id` FROM `" . hesk_dbEscape($hesk_settings['db_pfix']) . "users` WHERE `user`='" . hesk_dbEscape($_SESSION['new']['user']) . "' AND `id`!='" . intval($_SESSION['id']) . "' LIMIT 1");
if (hesk_dbNumRows($result) != 0) {
$hesk_error_buffer .= '<li>' . $hesklang['duplicate_user'] . '</li>';
} else {
$sql_username = ",`user`='" . hesk_dbEscape($_SESSION['new']['user']) . "'";
}
}
/* Change password? */
$newpass = hesk_input(hesk_POST('newpass'));
$passlen = strlen($newpass);
if ($passlen > 0) {
/* At least 5 chars? */
if ($passlen < 5) {
$hesk_error_buffer .= '<li>' . $hesklang['password_not_valid'] . '</li>';
} else {
$newpass2 = hesk_input(hesk_POST('newpass2'));
if ($newpass != $newpass2) {
$hesk_error_buffer .= '<li>' . $hesklang['passwords_not_same'] . '</li>';
} else {
$v = hesk_Pass2Hash($newpass);
if ($v == '499d74967b28a841c98bb4baaabaad699ff3c079') {
define('WARN_PASSWORD', true);
}
$sql_pass = ',`pass`=\'' . $v . '\'';
}
}
}
/* After reply */
$_SESSION['new']['afterreply'] = intval(hesk_POST('afterreply'));
if ($_SESSION['new']['afterreply'] != 1 && $_SESSION['new']['afterreply'] != 2) {
$_SESSION['new']['afterreply'] = 0;
}
/* Auto-start ticket timer */
$_SESSION['new']['autostart'] = isset($_POST['autostart']) ? 1 : 0;
/* Notifications */
$_SESSION['new']['notify_new_unassigned'] = empty($_POST['notify_new_unassigned']) || !$can_view_unassigned ? 0 : 1;
$_SESSION['new']['notify_new_my'] = empty($_POST['notify_new_my']) ? 0 : 1;
$_SESSION['new']['notify_reply_unassigned'] = empty($_POST['notify_reply_unassigned']) || !$can_view_unassigned ? 0 : 1;
$_SESSION['new']['notify_reply_my'] = empty($_POST['notify_reply_my']) ? 0 : 1;
$_SESSION['new']['notify_assigned'] = empty($_POST['notify_assigned']) ? 0 : 1;
$_SESSION['new']['notify_note'] = empty($_POST['notify_note']) ? 0 : 1;
$_SESSION['new']['notify_pm'] = empty($_POST['notify_pm']) ? 0 : 1;
/* Any errors? */
if (strlen($hesk_error_buffer)) {
/* Process the session variables */
$_SESSION['new'] = hesk_stripArray($_SESSION['new']);
$hesk_error_buffer = $hesklang['rfm'] . '<br /><br /><ul>' . $hesk_error_buffer . '</ul>';
hesk_process_messages($hesk_error_buffer, 'NOREDIRECT');
} else {
/* Update database */
hesk_dbQuery("UPDATE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "users` SET\r\n\t `name`='" . hesk_dbEscape($_SESSION['new']['name']) . "',\r\n\t `email`='" . hesk_dbEscape($_SESSION['new']['email']) . "',\r\n\t\t`signature`='" . hesk_dbEscape($_SESSION['new']['signature']) . "'\r\n {$sql_username}\r\n\t\t{$sql_pass} ,\r\n\t `afterreply`='" . intval($_SESSION['new']['afterreply']) . "' ,\r\n `autostart`='" . intval($_SESSION['new']['autostart']) . "' ,\r\n\t `notify_new_unassigned`='" . intval($_SESSION['new']['notify_new_unassigned']) . "' ,\r\n `notify_new_my`='" . intval($_SESSION['new']['notify_new_my']) . "' ,\r\n `notify_reply_unassigned`='" . intval($_SESSION['new']['notify_reply_unassigned']) . "' ,\r\n `notify_reply_my`='" . intval($_SESSION['new']['notify_reply_my']) . "' ,\r\n `notify_assigned`='" . intval($_SESSION['new']['notify_assigned']) . "' ,\r\n `notify_pm`='" . intval($_SESSION['new']['notify_pm']) . "',\r\n `notify_note`='" . intval($_SESSION['new']['notify_note']) . "'\r\n\t WHERE `id`='" . intval($_SESSION['id']) . "' LIMIT 1");
/* Process the session variables */
$_SESSION['new'] = hesk_stripArray($_SESSION['new']);
/* Update session variables */
foreach ($_SESSION['new'] as $k => $v) {
$_SESSION[$k] = $v;
}
unset($_SESSION['new']);
hesk_process_messages($hesklang['profile_updated_success'], 'profile.php', 'SUCCESS');
}
}
开发者ID:riansopian,项目名称:hesk,代码行数:80,代码来源:profile.php
示例5: define
define('HESK_PATH', '../');
/* Get all the required files and functions */
require HESK_PATH . 'hesk_settings.inc.php';
require HESK_PATH . 'inc/common.inc.php';
require HESK_PATH . 'inc/admin_functions.inc.php';
hesk_load_database_functions();
hesk_session_start();
hesk_dbConnect();
hesk_isLoggedIn();
/* Check permissions for this feature */
hesk_checkPermission('can_view_tickets');
hesk_checkPermission('can_reply_tickets');
hesk_checkPermission('can_edit_tickets');
/* A security check */
hesk_token_check();
/* Ticket ID */
$trackingID = hesk_cleanID() or die($hesklang['int_error'] . ': ' . $hesklang['no_trackID']);
/* New archived status */
if (empty($_GET['locked'])) {
$status = 0;
$tmp = $hesklang['tunlock'];
$revision = sprintf($hesklang['thist6'], hesk_date(), $_SESSION['name'] . ' (' . $_SESSION['user'] . ')');
} else {
$status = 1;
$tmp = $hesklang['tlock'];
$revision = sprintf($hesklang['thist5'], hesk_date(), $_SESSION['name'] . ' (' . $_SESSION['user'] . ')');
}
/* Update database */
hesk_dbQuery("UPDATE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "tickets` SET `status`='3',`locked`='{$status}', `history`=CONCAT(`history`,'" . hesk_dbEscape($revision) . "') WHERE `trackid`='" . hesk_dbEscape($trackingID) . "' LIMIT 1");
/* Back to ticket page and show a success message */
hesk_process_messages($tmp, 'admin_ticket.php?track=' . $trackingID . '&Refresh=' . rand(10000, 99999), 'SUCCESS');
开发者ID:riansopian,项目名称:hesk,代码行数:31,代码来源:lock.php
示例6: array
// array me vlerat e ticket_id
$params = array();
// array me vlerat e reply_message
$params1[0] = $ticket['id'];
$data = $oeapi->search_helpdeskID($valid_services["PIS"], $ticket['id']);
// gjejme ceshtjen ky helpdesk_id = ticket_id
//Ermedita - lista e emaileve te staffit qe jan te lidhur me ceshtjen
$issue_id = hesk_dbQuery("SELECT `contract_ticket_id` FROM `" . hesk_dbEscape($hesk_settings['db_pfix']) . "tickets` WHERE `id`=" . $ticket['id']);
$i_id = mysqli_fetch_array($issue_id);
$users = hesk_dbQuery("SELECT `userId` FROM `" . hesk_dbEscape($hesk_settings['db_pfix']) . "userforcontract` WHERE `contractId`=" . $i_id[0]);
$u = array();
while ($user = mysqli_fetch_array($users)) {
$u[] = $user['userId'];
}
$ulist = implode(',', $u);
$u_emails = hesk_dbQuery("SELECT `email` FROM `" . hesk_dbEscape($hesk_settings['db_pfix']) . "users` WHERE `id` IN (" . $ulist . ")");
$array_email = array();
while ($e = mysqli_fetch_array($u_emails)) {
$array_email[] = $e['email'];
}
$ulist_emails = implode(',', $array_email);
//var_dump($ulist_emails);
//exit();
$params['subject'] = $ticket['subject'];
$params['user_id'] = 11;
// Do krijohet nga ERP nje user default dhe do vendosim ID e tij
$params['body_text'] = stripslashes($message);
$params['date'] = hesk_date($ticket['dt'], true);
$params['res_id'] = $data[0];
$params['model'] = "project.issue";
$params['email_from'] = $ticket['email'];
开发者ID:ermedita-xhafaj,项目名称:support,代码行数:31,代码来源:reply_ticket.php
示例7: forgot_tid
function forgot_tid()
{
global $hesk_settings, $hesklang;
require HESK_PATH . 'inc/email_functions.inc.php';
$email = hesk_validateEmail(hesk_POST('email'), 'ERR', 0) or hesk_process_messages($hesklang['enter_valid_email'], 'ticket.php?remind=1');
if (isset($_POST['open_only'])) {
$hesk_settings['open_only'] = $_POST['open_only'] == 1 ? 1 : 0;
}
/* Prepare ticket statuses */
$my_status = array(0 => $hesklang['open'], 1 => $hesklang['wait_staff_reply'], 2 => $hesklang['wait_cust_reply'], 3 => $hesklang['closed'], 4 => $hesklang['in_progress'], 5 => $hesklang['on_hold']);
/* Get ticket(s) from database */
hesk_load_database_functions();
hesk_dbConnect();
// Get tickets from the database
$res = hesk_dbQuery('SELECT * FROM `' . hesk_dbEscape($hesk_settings['db_pfix']) . 'tickets` FORCE KEY (`statuses`) WHERE ' . ($hesk_settings['open_only'] ? "`status` IN ('0','1','2','4','5') AND " : '') . ' ' . hesk_dbFormatEmail($email) . ' ORDER BY `status` ASC, `lastchange` DESC ');
$num = hesk_dbNumRows($res);
if ($num < 1) {
if ($hesk_settings['open_only']) {
hesk_process_messages($hesklang['noopen'], 'ticket.php?remind=1&e=' . $email);
} else {
hesk_process_messages($hesklang['tid_not_found'], 'ticket.php?remind=1&e=' . $email);
}
}
$tid_list = '';
$name = '';
$email_param = $hesk_settings['email_view_ticket'] ? '&e=' . rawurlencode($email) : '';
while ($my_ticket = hesk_dbFetchAssoc($res)) {
$name = $name ? $name : hesk_msgToPlain($my_ticket['name'], 1, 0);
$tid_list .= "\n{$hesklang['trackID']}: " . $my_ticket['trackid'] . "\n{$hesklang['subject']}: " . hesk_msgToPlain($my_ticket['subject'], 1, 0) . "\n{$hesklang['status']}: " . $my_status[$my_ticket['status']] . "\n{$hesk_settings['hesk_url']}/ticket.php?track={$my_ticket['trackid']}{$email_param}\n";
}
/* Get e-mail message for customer */
$msg = hesk_getEmailMessage('forgot_ticket_id', '', 0, 0, 1);
$msg = str_replace('%%NAME%%', $name, $msg);
$msg = str_replace('%%NUM%%', $num, $msg);
$msg = str_replace('%%LIST_TICKETS%%', $tid_list, $msg);
$msg = str_replace('%%SITE_TITLE%%', hesk_msgToPlain($hesk_settings['site_title'], 1), $msg);
$msg = str_replace('%%SITE_URL%%', $hesk_settings['site_url'], $msg);
$subject = hesk_getEmailSubject('forgot_ticket_id');
/* Send e-mail */
hesk_mail($email, $subject, $msg);
/* Show success message */
$tmp = '<b>' . $hesklang['tid_sent'] . '!</b>';
$tmp .= '<br /> <br />' . $hesklang['tid_sent2'] . '.';
$tmp .= '<br /> <br />' . $hesklang['check_spambox'];
hesk_process_messages($tmp, 'ticket.php?e=' . $email, 'SUCCESS');
exit;
}
开发者ID:abuhannan,项目名称:aduan,代码行数:47,代码来源:index.php
示例8: define
define('IN_SCRIPT', 1);
define('HESK_PATH', '../');
/* Get all the required files and functions */
require HESK_PATH . 'hesk_settings.inc.php';
require HESK_PATH . 'inc/common.inc.php';
require HESK_PATH . 'inc/admin_functions.inc.php';
hesk_load_database_functions();
hesk_session_start();
hesk_dbConnect();
hesk_isLoggedIn();
/* Print XML header */
header('Content-Type: text/html; charset=' . $hesklang['ENCODING']);
/* Get the search query composed of the subject and message */
$query = hesk_REQUEST('q') or die('');
/* Get relevant articles from the database, include private ones */
$res = hesk_dbQuery("SELECT `id`, `subject`, `content` FROM `" . hesk_dbEscape($hesk_settings['db_pfix']) . "kb_articles` WHERE `type` IN ('0','1') AND MATCH(`subject`,`content`,`keywords`) AGAINST ('" . hesk_dbEscape($query) . "') LIMIT " . intval($hesk_settings['kb_search_limit']));
$num = hesk_dbNumRows($res);
/* Solve some spacing issues */
if (hesk_isREQUEST('p')) {
echo ' <br />';
}
/* Return found articles */
?>
<div class="conatiner notice">
<span style="font-size:12px;font-weight:bold"><?php
echo $hesklang['sc'];
?>
:</span><br /> <br />
<?php
if (!$num) {
echo '<i>' . $hesklang['nsfo'] . '</i>';
开发者ID:ermedita-xhafaj,项目名称:support,代码行数:31,代码来源:admin_suggest_articles.php
示例9: hesk_dbEscape
break;
case 'subject':
$sql .= "`subject` LIKE '%" . hesk_dbEscape($q) . "%' COLLATE '" . hesk_dbEscape($hesklang['_COLLATE']) . "' ";
break;
case 'message':
$sql .= " ( `message` LIKE '%" . hesk_dbEscape($q) . "%' COLLATE '" . hesk_dbEscape($hesklang['_COLLATE']) . "'\n \t\tOR\n `id` IN (\n \t\tSELECT DISTINCT `replyto`\n \tFROM `" . hesk_dbEscape($hesk_settings['db_pfix']) . "replies`\n \tWHERE `message` LIKE '%" . hesk_dbEscape($q) . "%' COLLATE '" . hesk_dbEscape($hesklang['_COLLATE']) . "' )\n )\n ";
break;
case 'seqid':
$sql .= "`id` = '" . intval($q) . "' ";
break;
case 'notes':
$sql .= "`id` IN (\n \t\tSELECT DISTINCT `ticket`\n \tFROM `" . hesk_dbEscape($hesk_settings['db_pfix']) . "notes`\n \tWHERE `message` LIKE '%" . hesk_dbEscape($q) . "%' COLLATE '" . hesk_dbEscape($hesklang['_COLLATE']) . "' )\n \t";
break;
default:
if (isset($hesk_settings['custom_fields'][$what]) && $hesk_settings['custom_fields'][$what]['use']) {
$sql .= "`" . hesk_dbEscape($what) . "` LIKE '%" . hesk_dbEscape($q) . "%' COLLATE '" . hesk_dbEscape($hesklang['_COLLATE']) . "' ";
} else {
$hesk_error_buffer .= '<br />' . $hesklang['invalid_search'];
}
}
}
// Owner
if ($tmp = intval(hesk_GET('owner', 0))) {
$sql .= " AND `owner`={$tmp} ";
$owner_input = $tmp;
$hesk_error_buffer = str_replace($hesklang['fsq'], '', $hesk_error_buffer);
} else {
$owner_input = 0;
}
/* Date */
/* -> Check for compatibility with old date format */
开发者ID:ermedita-xhafaj,项目名称:support,代码行数:31,代码来源:find_tickets.php
示例10: mail_list_messages
function mail_list_messages()
{
global $hesk_settings, $hesklang, $admins;
$href = 'mail.php';
$query = '';
if ($hesk_settings['mailtmp']['folder'] == 'outbox') {
$query .= 'folder=outbox&';
}
$query .= 'page=';
$maxresults = 30;
$tmp = intval(hesk_POST('page', 1));
$page = $tmp > 1 ? $tmp : 1;
/* List of private messages */
$res = hesk_dbQuery("SELECT COUNT(*) FROM `" . hesk_dbEscape($hesk_settings['db_pfix']) . "mail` WHERE `" . hesk_dbEscape($hesk_settings['mailtmp']['this']) . "`='" . intval($_SESSION['id']) . "' AND `deletedby`!='" . intval($_SESSION['id']) . "'");
$total = hesk_dbResult($res, 0, 0);
if ($total > 0) {
$pages = ceil($total / $maxresults) or $pages = 1;
if ($page > $pages) {
$page = $pages;
}
$limit_down = $page * $maxresults - $maxresults;
$prev_page = $page - 1 <= 0 ? 0 : $page - 1;
$next_page = $page + 1 > $pages ? 0 : $page + 1;
if ($pages > 1) {
echo $hesklang['pg'] . ': ';
/* List pages */
if ($pages >= 7) {
if ($page > 2) {
echo '<a href="' . $href . '?' . $query . '1"><b>«</b></a> ';
}
if ($prev_page) {
echo '<a href="' . $href . '?' . $query . $prev_page . '"><b>‹</b></a> ';
}
}
for ($i = 1; $i <= $pages; $i++) {
if ($i <= $page + 5 && $i >= $page - 5) {
if ($i == $page) {
echo ' <b>' . $i . '</b> ';
} else {
echo ' <a href="' . $href . '?' . $query . $i . '">' . $i . '</a> ';
}
}
}
if ($pages >= 7) {
if ($next_page) {
echo ' <a href="' . $href . '?' . $query . $next_page . '"><b>›</b></a> ';
}
if ($page < $pages - 1) {
echo ' <a href="' . $href . '?' . $query . $pages . '"><b>»</b></a>';
}
}
echo '<br /> ';
}
// end PAGES > 1
// Get messages from the database
$res = hesk_dbQuery("SELECT `id`, `from`, `to`, `subject`, `dt`, `read` FROM `" . hesk_dbEscape($hesk_settings['db_pfix']) . "mail` WHERE `" . hesk_dbEscape($hesk_settings['mailtmp']['this']) . "`='" . intval($_SESSION['id']) . "' AND `deletedby`!='" . intval($_SESSION['id']) . "' ORDER BY `id` DESC LIMIT " . intval($limit_down) . " , " . intval($maxresults) . " ");
?>
<form action="mail.php<?php
if ($hesk_settings['mailtmp']['folder'] == 'outbox') {
echo '?folder=outbox';
}
?>
" name="form1" method="post">
<div class="container table-responsive">
<table class="table table-bordered table-hover" style="background: #E0EEEE;">
<tr>
<th class="admin_white" style="width:1px"><input type="checkbox" name="checkall" value="2" onclick="hesk_changeAll(this)" /></th>
<th class="admin_white" style="text-align:left; white-space:nowrap;"><?php
echo $hesklang['m_sub'];
?>
</th>
<th class="admin_white" style="text-align:left; white-space:nowrap;"><?php
echo $hesk_settings['mailtmp']['m_from'];
?>
</th>
<th class="admin_white" style="text-align:left; white-space:nowrap;"><?php
echo $hesklang['date'];
?>
</th>
</tr>
<?php
$i = 0;
while ($pm = hesk_dbFetchAssoc($res)) {
if ($i) {
$color = "admin_gray";
$i = 0;
} else {
$color = "admin_white";
$i = 1;
}
$pm['subject'] = '<a href="mail.php?a=read&id=' . $pm['id'] . '">' . $pm['subject'] . '</a>';
if ($hesk_settings['mailtmp']['this'] == 'to' && !$pm['read']) {
$pm['subject'] = '<b>' . $pm['subject'] . '</b>';
}
$pm['name'] = isset($admins[$pm[$hesk_settings['mailtmp']['other']]]) ? '<a href="mail.php?a=new&id=' . $pm[$hesk_settings['mailtmp']['other']] . '">' . $admins[$pm[$hesk_settings['mailtmp']['other']]] . '</a>' : ($pm['from'] == 9999 ? '<a href="http://www.hesk.com" target="_blank">HESK.com</a>' : $hesklang['e_udel']);
$pm['dt'] = hesk_dateToString($pm['dt'], 0, 0, 0, true);
echo <<<EOC
//.........这里部分代码省略.........
开发者ID:ermedita-xhafaj,项目名称:support,代码行数:101,代码来源:mail.php
示例11: toggle_type
function toggle_type()
{
global $hesk_settings, $hesklang;
/* A security check */
hesk_token_check();
$catid = intval(hesk_GET('catid')) or hesk_error($hesklang['cat_move_id']);
$_SESSION['selcat2'] = $catid;
if (intval(hesk_GET('s'))) {
$type = 1;
$tmp = $hesklang['cpriv'];
} else {
$type = 0;
$tmp = $hesklang['cpub'];
}
/* Update auto-assign settings */
hesk_dbQuery("UPDATE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "categories` SET `type`='{$type}' WHERE `id`='" . intval($catid) . "' LIMIT 1");
if (hesk_dbAffectedRows() != 1) {
hesk_process_messages($hesklang['int_error'] . ': ' . $hesklang['cat_not_found'], './manage_categories.php');
}
hesk_process_messages($tmp, './manage_categories.php', 'SUCCESS');
}
开发者ID:Eximagen,项目名称:helpdesk,代码行数:21,代码来源:manage_categories.php
示例12: hesk_iTables
function hesk_iTables()
{
global $hesk_settings;
// -> Attachments
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "attachments` (\n `att_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\n `ticket_id` varchar(13) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `saved_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `real_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `size` int(10) unsigned NOT NULL DEFAULT '0',\n `type` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',\n PRIMARY KEY (`att_id`),\n KEY `ticket_id` (`ticket_id`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci\n");
// -> Banned emails
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "banned_emails` (\n `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,\n `email` varchar(255) NOT NULL,\n `banned_by` smallint(5) unsigned NOT NULL,\n `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n PRIMARY KEY (`id`),\n KEY `email` (`email`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8\n");
// -> Banned IPs
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "banned_ips` (\n `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,\n `ip_from` int(10) unsigned NOT NULL DEFAULT '0',\n `ip_to` int(10) unsigned NOT NULL DEFAULT '0',\n `ip_display` varchar(100) NOT NULL,\n `banned_by` smallint(5) unsigned NOT NULL,\n `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n PRIMARY KEY (`id`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8\n");
// -> Categories
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "categories` (\n `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,\n `name` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `cat_order` smallint(5) unsigned NOT NULL DEFAULT '0',\n `autoassign` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',\n `type` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',\n `priority` enum('0','1','2','3') COLLATE utf8_unicode_ci NOT NULL DEFAULT '3',\n PRIMARY KEY (`id`),\n KEY `type` (`type`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci\n");
// ---> Insert default category
hesk_dbQuery("INSERT INTO `" . hesk_dbEscape($hesk_settings['db_pfix']) . "categories` (`id`, `name`, `cat_order`) VALUES (1, 'General', 10)");
// -> KB Articles
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "kb_articles` (\n `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,\n `catid` smallint(5) unsigned NOT NULL,\n `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n `author` smallint(5) unsigned NOT NULL,\n `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,\n `content` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `keywords` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `rating` float NOT NULL DEFAULT '0',\n `votes` mediumint(8) unsigned NOT NULL DEFAULT '0',\n `views` mediumint(8) unsigned NOT NULL DEFAULT '0',\n `type` enum('0','1','2') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',\n `html` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',\n `sticky` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',\n `art_order` smallint(5) unsigned NOT NULL DEFAULT '0',\n `history` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `attachments` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n PRIMARY KEY (`id`),\n KEY `catid` (`catid`),\n KEY `sticky` (`sticky`),\n KEY `type` (`type`),\n FULLTEXT KEY `subject` (`subject`,`content`,`keywords`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci\n");
// -> KB Attachments
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "kb_attachments` (\n `att_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\n `saved_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `real_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `size` int(10) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`att_id`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci\n");
// -> KB Categories
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "kb_categories` (\n `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,\n `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,\n `parent` smallint(5) unsigned NOT NULL,\n `articles` smallint(5) unsigned NOT NULL DEFAULT '0',\n `articles_private` smallint(5) unsigned NOT NULL DEFAULT '0',\n `articles_draft` smallint(5) unsigned NOT NULL DEFAULT '0',\n `cat_order` smallint(5) unsigned NOT NULL,\n `type` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `type` (`type`),\n KEY `parent` (`parent`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci\n");
// ---> Insert default KB category
hesk_dbQuery("INSERT INTO `" . hesk_dbEscape($hesk_settings['db_pfix']) . "kb_categories` (`id`, `name`, `parent`, `cat_order`, `type`) VALUES (1, 'Knowledgebase', 0, 10, '0')");
// -> Login attempts
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "logins` (\n `ip` varchar(45) COLLATE utf8_unicode_ci NOT NULL,\n `number` tinyint(3) unsigned NOT NULL DEFAULT '1',\n `last_attempt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n UNIQUE KEY `ip` (`ip`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci\n");
// -> Private messages
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "mail` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `from` smallint(5) unsigned NOT NULL,\n `to` smallint(5) unsigned NOT NULL,\n `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,\n `message` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n `read` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',\n `deletedby` smallint(5) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `from` (`from`),\n KEY `to` (`to`,`read`,`deletedby`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci\n");
// ---> Insert rate this script email
hesk_dbQuery("INSERT INTO `" . hesk_dbEscape($hesk_settings['db_pfix']) . "mail` (`id`, `from`, `to`, `subject`, `message`, `dt`, `read`, `deletedby`) VALUES (1, 9999, 1, 'Rate this script', '<div style=\"text-align:justify;padding:3px\">\r\n\r\n<p style=\"color:green;font-weight:bold\">Enjoy using HESK? Please let others know!</p>\r\n\r\n<p>You are invited to rate HESK or even write a short review here:<br /> <br /><img src=\"../img/link.png\" width=\"16\" height=\"16\" border=\"0\" alt=\"\" style=\"vertical-align:text-bottom\" /> <a href=\"http://www.hotscripts.com/Detailed/46973.html\" target=\"_blank\">Rate this script @ Hot Scripts</a><br /> <br /><img src=\"../img/link.png\" width=\"16\" height=\"16\" border=\"0\" alt=\"\" style=\"vertical-align:text-bottom\" /> <a href=\"http://php.resourceindex.com/detail/04946.html\" target=\"_blank\">Rate this script @ The PHP Resource Index</a></p>\r\n\r\n<p>Thank you,<br /> <br />Klemen,<br />\r\n<a href=\"http://www.hesk.com/\" target=\"_blank\">www.hesk.com</a>\r\n\r\n<p> </p>', NOW(), '0', 9999)");
// ---> Insert welcome email
hesk_dbQuery("INSERT INTO `" . hesk_dbEscape($hesk_settings['db_pfix']) . "mail` (`id`, `from`, `to`, `subject`, `message`, `dt`, `read`, `deletedby`) VALUES (2, 9999, 1, 'Welcome to HESK! Here are some quick tips...', '<p style=\"color:green;font-weight:bold\">HESK quick "Getting Started" tips:<br /> </p>\r\n\r\n<ol style=\"padding-left:20px;padding-right:10px;text-align:justify\">\r\n<li>Click the Profile link to set your name, email, signature and password.<br /> </li>\r\n<li>Click the Settings link in the top menu to get to the Settings page. For additional information about each setting, click the [?] link.<br /> </li>\r\n<li>Add new categories (departments) on the Categories page. The default category cannot be deleted, but it can be renamed.<br /> </li>\r\n<li>Create new staff accounts on the Users page. You can give them unlimited (Administrator) or restricted (Staff) access.<br /> </li>\r\n<li>Use the integrated Knowledgebase. A comprehensive and well-written knowledgebase can drastically reduce the number of support tickets you receive and save a lot of your time in the long run.<br /> </li>\r\n<li>You can create response and new ticket templates on the Canned page.<br /> </li>\r\n<li>Subscribe to the <a href=\"http://www.hesk.com/newsletter.php\" target=\"_blank\">HESK Newsletter</a> to be notified of updates and new versions.<br /> </li>\r\n<li>You should follow HESK on Twitter <a href=\"https://twitter.com/HESKdotCOM\" target=\"_blank\">here</a>.<br /> </li>\r\n<li>To remove the "<span class=\"smaller\">Powered by Help Desk Software HESK</span>" links from the bottom of your help desk <a href=\"https://www.hesk.com/buy.php\" target=\"_blank\">buy a license here</a>.<br /> </li></ol>\r\n\r\n<p>Enjoy using HESK and please feel free to share your constructive feedback and feature suggestions.</p>\r\n\r\n<p>Klemen Stirn<br />\r\nHESK owner and author<br />\r\n<a href=\"http://www.hesk.com/\" target=\"_blank\">www.hesk.com</a>', NOW(), '0', 9999)");
// -> Notes
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "notes` (\n `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\n `ticket` mediumint(8) unsigned NOT NULL,\n `who` smallint(5) unsigned NOT NULL,\n `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n `message` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `attachments` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n PRIMARY KEY (`id`),\n KEY `ticketid` (`ticket`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci\n");
// -> Online
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "online` (\n `user_id` smallint(5) unsigned NOT NULL,\n `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n `tmp` int(11) unsigned NOT NULL DEFAULT '0',\n UNIQUE KEY `user_id` (`user_id`),\n KEY `dt` (`dt`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci\n");
// -> Pipe loops
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "pipe_loops` (\n `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,\n `hits` smallint(1) unsigned NOT NULL DEFAULT '0',\n `message_hash` char(32) COLLATE utf8_unicode_ci NOT NULL,\n `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n KEY `email` (`email`,`hits`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci\n");
// -> Replies
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "replies` (\n `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\n `replyto` mediumint(8) unsigned NOT NULL DEFAULT '0',\n `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `message` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n `attachments` mediumtext COLLATE utf8_unicode_ci,\n `staffid` smallint(5) unsigned NOT NULL DEFAULT '0',\n `rating` enum('1','5') COLLATE utf8_unicode_ci DEFAULT NULL,\n `read` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `replyto` (`replyto`),\n KEY `dt` (`dt`),\n KEY `staffid` (`staffid`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci\n");
// -> Reply drafts
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "reply_drafts` (\n `owner` smallint(5) unsigned NOT NULL,\n `ticket` mediumint(8) unsigned NOT NULL,\n `message` mediumtext CHARACTER SET utf8 NOT NULL,\n `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n KEY `owner` (`owner`),\n KEY `ticket` (`ticket`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci\n");
// -> Reset password
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "reset_password` (\n `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\n `user` smallint(5) unsigned NOT NULL,\n `hash` char(40) NOT NULL,\n `ip` varchar(45) NOT NULL,\n `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n PRIMARY KEY (`id`),\n KEY `user` (`user`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\n");
// -> Service messages
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "service_messages` (\n `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,\n `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n `author` smallint(5) unsigned NOT NULL,\n `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,\n `message` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `style` enum('0','1','2','3','4') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',\n `type` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',\n `order` smallint(5) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `type` (`type`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n");
// -> Canned Responses
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "std_replies` (\n `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `message` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `reply_order` smallint(5) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci\n");
// -> Tickets
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "tickets` (\n `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\n `trackid` varchar(13) COLLATE utf8_unicode_ci NOT NULL,\n `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `email` varchar(1000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `category` smallint(5) unsigned NOT NULL DEFAULT '1',\n `priority` enum('0','1','2','3') COLLATE utf8_unicode_ci NOT NULL DEFAULT '3',\n `subject` varchar(70) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `message` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `dt` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',\n `lastchange` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n `firstreply` timestamp NULL DEFAULT NULL,\n `closedat` timestamp NULL DEFAULT NULL,\n `articles` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,\n `ip` varchar(45) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `language` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,\n `status` enum('0','1','2','3','4','5') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',\n `openedby` smallint(5) unsigned DEFAULT '0',\n `firstreplyby` smallint(8) unsigned DEFAULT NULL,\n `closedby` smallint(5) unsigned DEFAULT NULL,\n `replies` smallint(5) unsigned NOT NULL DEFAULT '0',\n `staffreplies` smallint(5) unsigned NOT NULL DEFAULT '0',\n `owner` smallint(5) unsigned NOT NULL DEFAULT '0',\n `time_worked` time NOT NULL DEFAULT '00:00:00',\n `lastreplier` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',\n `replierid` smallint(5) unsigned DEFAULT NULL,\n `archive` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',\n `locked` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',\n `attachments` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `merged` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `history` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom1` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom2` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom3` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom4` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom5` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom6` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom7` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom8` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom9` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom10` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom11` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom12` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom13` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom14` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom15` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom16` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom17` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom18` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom19` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `custom20` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n PRIMARY KEY (`id`),\n KEY `trackid` (`trackid`),\n KEY `archive` (`archive`),\n KEY `categories` (`category`),\n KEY `statuses` (`status`),\n KEY `owner` (`owner`),\n KEY `openedby` (`openedby`,`firstreplyby`,`closedby`),\n KEY `dt` (`dt`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci\n");
// -> Ticket templates
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "ticket_templates` (\n `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `message` mediumtext COLLATE utf8_unicode_ci NOT NULL,\n `tpl_order` smallint(5) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci\n");
// -> Users
hesk_dbQuery("\nCREATE TABLE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "users` (\n `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,\n `user` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `pass` char(40) COLLATE utf8_unicode_ci NOT NULL,\n `isadmin` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',\n `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `signature` varchar(1000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `language` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,\n `categories` varchar(500) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `afterreply` enum('0','1','2') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',\n `autostart` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',\n `notify_customer_new` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',\n `notify_customer_reply` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',\n `show_suggested` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',\n `notify_new_unassigned` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',\n `notify_new_my` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',\n `notify_reply_unassigned` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',\n `notify_reply_my` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',\n `notify_assigned` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',\n `notify_pm` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',\n `notify_note` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',\n `default_list` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n `autoassign` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',\n `heskprivileges` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,\n `ratingneg` mediumint(8) unsigned NOT NULL DEFAULT '0',\n `ratingpos` mediumint(8) unsigned NOT NULL DEFAULT '0',\n `rating` float NOT NULL DEFAULT '0',\n `replies` mediumint(8) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `autoassign` (`autoassign`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci\n");
hesk_dbQuery("INSERT INTO `" . hesk_dbEscape($hesk_settings['db_pfix']) . "users` (`id`, `user`, `pass`, `isadmin`, `name`, `email`, `heskprivileges`) VALUES (1, '" . hesk_dbEscape($_SESSION['admin_user']) . "', '" . hesk_dbEscape($_SESSION['admin_hash']) . "', '1', 'Yo
|
请发表评论