PHP hesk_dbQuery函数代码示例

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中hesk_dbQuery函数的典型用法代码示例。如果您正苦于以下问题：PHP hesk_dbQuery函数的具体用法？PHP hesk_dbQuery怎么用？PHP hesk_dbQuery使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了hesk_dbQuery函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: hesk_iTestDatabaseConnection

function hesk_iTestDatabaseConnection()
{
    global $hesk_settings, $hesklang;
    $db_success = 1;
    $hesk_settings['db_host'] = hesk_input(hesk_POST('host'));
    $hesk_settings['db_name'] = hesk_input(hesk_POST('name'));
    $hesk_settings['db_user'] = hesk_input(hesk_POST('user'));
    $hesk_settings['db_pass'] = hesk_input(hesk_POST('pass'));
    // Allow & in password
    $hesk_settings['db_pass'] = str_replace('&amp;', '&', $hesk_settings['db_pass']);
    // Use MySQLi extension to connect?
    $use_mysqli = function_exists('mysqli_connect') ? true : false;
    // Start output buffering
    ob_start();
    // Connect to database
    if ($use_mysqli) {
        // Do we need a special port? Check and connect to the database
        if (strpos($hesk_settings['db_host'], ':')) {
            list($hesk_settings['db_host'], $hesk_settings['db_port']) = explode(':', $hesk_settings['db_host']);
            $hesk_db_link = mysqli_connect($hesk_settings['db_host'], $hesk_settings['db_user'], $hesk_settings['db_pass'], $hesk_settings['db_name'], intval($hesk_settings['db_port'])) or $db_success = 0;
        } else {
            $hesk_db_link = mysqli_connect($hesk_settings['db_host'], $hesk_settings['db_user'], $hesk_settings['db_pass'], $hesk_settings['db_name']) or $db_success = 0;
        }
    } else {
        $hesk_db_link = mysql_connect($hesk_settings['db_host'], $hesk_settings['db_user'], $hesk_settings['db_pass']) or $db_success = 0;
        // Select database works OK?
        if ($db_success == 1 && !mysql_select_db($hesk_settings['db_name'], $hesk_db_link)) {
            // No, try to create the database
            if (function_exists('mysql_create_db') && mysql_create_db($hesk_settings['db_name'], $hesk_db_link)) {
                if (mysql_select_db($hesk_settings['db_name'], $hesk_db_link)) {
                    $db_success = 1;
                } else {
                    $db_success = 0;
                }
            } else {
                $db_success = 0;
            }
        }
    }
    ob_end_clean();
    // Any errors?
    if (!$db_success) {
        global $mysql_log;
        $mysql_log = $use_mysqli ? mysqli_connect_error() : mysql_error();
        hesk_iDatabase(1);
    }
    // Check MySQL version
    define('MYSQL_VERSION', hesk_dbResult(hesk_dbQuery('SELECT VERSION() AS version')));
    if (version_compare(MYSQL_VERSION, REQUIRE_MYSQL_VERSION, '<')) {
        hesk_iDatabase(5);
    }
    return $hesk_db_link;
}

开发者ID:Orgoth，项目名称:Mods-for-HESK，代码行数:53，代码来源:install_functions.inc.php

示例2: 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

示例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: hesk_dbFetchAssoc

}
$ticket = hesk_dbFetchAssoc($res);
// Demo mode
if (defined('HESK_DEMO')) {
    $ticket['email'] = '[email protected]';
    $ticket['ip'] = '127.0.0.1';
}
/* Get category name and ID */
$res = hesk_dbQuery("SELECT * FROM `" . hesk_dbEscape($hesk_settings['db_pfix']) . "categories` WHERE `id`='{$ticket['category']}' LIMIT 1");
/* If this category has been deleted use the default category with ID 1 */
if (hesk_dbNumRows($res) != 1) {
    $res = hesk_dbQuery("SELECT * FROM `" . hesk_dbEscape($hesk_settings['db_pfix']) . "categories` WHERE `id`='1' LIMIT 1");
}
$category = hesk_dbFetchAssoc($res);
/* Get replies */
$res = hesk_dbQuery("SELECT * FROM `" . hesk_dbEscape($hesk_settings['db_pfix']) . "replies` WHERE `replyto`='{$ticket['id']}' ORDER BY `id` ASC");
$replies = hesk_dbNumRows($res);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title><?php 
echo $hesk_settings['hesk_title'];
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=<?php 
echo $hesklang['ENCODING'];
?>
">
<style type="text/css">
body, table, td, p

开发者ID:abuhannan，项目名称:aduan，代码行数:31，代码来源:print.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: hesk_profile_tab


//.........这里部分代码省略.........
        echo $hesklang['confirm_pass'];
        ?>
:</label>
				<input class="form-control" type="password" id="newpass2" name="newpass2" pattern="^\S{6,}$" onchange="this.setCustomValidity(this.validity.patternMismatch ? 'Please enter the same Password as above' : '');" autocomplete="off" size="40" />
				</div>
			<?php 
    }
    ?>
			<div class="form-inline" id="profile-information-pwdst-row">
				<label class="col-sm-2 control-label"><?php 
    echo $hesklang['pwdst'];
    ?>
:</label>
				<label style="vertical-align: top;">
				<div class="form-control" style="width: 336px;">
					<div id="progressBar" style="font-size: 1px; height: 20px; width: 0px; border: 1px solid white;"></div>
				</div>
				</label>
			</div>
			
			<div class="form-inline <?php 
    if (!isset($_GET['a']) || $_GET['a'] !== "editc") {
        echo "hidden";
    }
    ?>
" id="show-hide-kompani">
						<label class="col-sm-2 control-label" for=""><?php 
    echo $hesklang['company'];
    ?>
:<font class="important">*</font></label>
						<select class="form-control" id="select_company_manage_users" name="company_id" style="width: 336px;">
							<option></option>
							<?php 
    $res_comp = hesk_dbQuery('SELECT * FROM `' . hesk_dbEscape($hesk_settings['db_pfix']) . 'companies` ');
    while ($row_comp = mysqli_fetch_array($res_comp)) {
        if ($row_comp['active'] == 1) {
            $temp_data = array();
            $data_contract = hesk_dbQuery('SELECT id FROM `' . hesk_dbEscape($hesk_settings['db_pfix']) . 'contracts` WHERE active=1 AND company_id =' . $row_comp['id']);
            while ($row_contract = mysqli_fetch_array($data_contract)) {
                $temp_data[] = $row_contract['id'];
            }
            if (isset($_SESSION[$session_array]['company_id']) && $_SESSION[$session_array]['company_id'] == $row_comp['id']) {
                echo '<option value="' . $row_comp['id'] . '" contracts = "' . implode($temp_data, ",") . '" selected="selected">' . $row_comp['company_name'] . '</option>';
            } else {
                echo '<option value="' . $row_comp['id'] . '" contracts = "' . implode($temp_data, ",") . '" >' . $row_comp['company_name'] . '</option>';
            }
        } else {
            if (isset($_SESSION[$session_array]['company_id']) && $_SESSION[$session_array]['company_id'] == $row_comp['id']) {
                echo '<option  selected="selected" disabled>' . $row_comp['company_name'] . '</option>';
            }
        }
    }
    ?>
		
						</select>
			</div>
				
			<br/>
			
			<div class="form-inline <?php 
    if (!isset($_GET['a']) || $_GET['a'] !== "editc") {
        echo "hidden";
    }
    ?>
" id="show-hide-kontrata">
				<label class="col-sm-2 control-label" for="select-kontrata"><?php

开发者ID:ermedita-xhafaj，项目名称:support，代码行数:67，代码来源:profile_functions.inc.php

示例7: change_manager

function change_manager()
{
    global $hesklang, $hesk_settings;
    $catid = hesk_POST('catid');
    $newManagerId = hesk_POST('managerid');
    hesk_dbQuery('UPDATE `' . hesk_dbEscape($hesk_settings['db_pfix']) . 'categories` SET `manager` = ' . intval($newManagerId) . ' WHERE `id` = ' . intval($catid));
    if (hesk_dbAffectedRows() != 1) {
        hesk_process_messages($hesklang['int_error'] . ': ' . $hesklang['cat_not_found'], './manage_categories.php');
    }
    if ($newManagerId == 0) {
        // There is no new manager.
        return;
    }
    // Add the category to the user's categories list, if not already present
    $currentCatRs = hesk_dbQuery('SELECT `categories` FROM `' . hesk_dbEscape($hesk_settings['db_pfix']) . 'users` WHERE `id` = ' . intval($newManagerId));
    $currentCategories = hesk_dbFetchAssoc($currentCatRs);
    $categories = explode(',', $currentCategories['categories']);
    if (!in_array($catid, $categories)) {
        hesk_dbQuery('UPDATE `' . hesk_dbEscape($hesk_settings['db_pfix']) . 'users` SET `categories` = \'' . $currentCategories['categories'] . ',' . $catid . '\' WHERE `id` = ' . intval($newManagerId));
    }
    hesk_process_messages($hesklang['manager_updated'], './manage_categories.php', 'SUCCESS');
}

开发者ID:Orgoth，项目名称:Mods-for-HESK，代码行数:22，代码来源:manage_categories.php

示例8: 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

示例9: 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&amp;';
    }
    $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>&laquo;</b></a> &nbsp; ';
                }
                if ($prev_page) {
                    echo '<a href="' . $href . '?' . $query . $prev_page . '"><b>&lsaquo;</b></a> &nbsp; ';
                }
            }
            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 ' &nbsp; <a href="' . $href . '?' . $query . $next_page . '"><b>&rsaquo;</b></a> ';
                }
                if ($page < $pages - 1) {
                    echo ' &nbsp; <a href="' . $href . '?' . $query . $pages . '"><b>&raquo;</b></a>';
                }
            }
            echo '<br />&nbsp;';
        }
        // 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&amp;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&amp;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

示例10: hesk_dbQuery

			<input name="submitbutton_tickets" type="submit" class="btn btn-default filter-ticket-btn" value="Search"/>
			<button name="clearbutton_tickets" onclick="deleteticket_admin();return false;" class="btn btn-default filter-ticket-btn" value="">Clear</button>
		</form>
	</div> <!--end div i filtrave -->	
	<?php 
    if (!isset($_SESSION['hide']['ticket_list'])) {
        echo '<br/><br/>
        <div class="container open-new-ticket">
        <div class="form-inline col-sm-10"><img src="../img/open-tickets.png" alt="open-tickets" /><span id="openTicket">' . $hesklang['open_tickets'] . '</span></div>
        <span class="col-sm-2 newTicket"><a href="new_ticket.php"><button type="submit" class="btn btn-default new-ticket-btn">' . $hesklang['nti'] . '</button></a></span>
		</div>
        ';
    }
    /* Reset default settings? */
    if (isset($_GET['reset']) && hesk_token_check()) {
        $res = hesk_dbQuery("UPDATE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "users` SET `default_list`='' WHERE `id` = '" . intval($_SESSION['id']) . "' LIMIT 1");
        $_SESSION['default_list'] = '';
    } else {
        parse_str($_SESSION['default_list'], $defaults);
        $_GET = isset($_GET) && is_array($_GET) ? array_merge($_GET, $defaults) : $defaults;
    }
    /* Print the list of tickets */
    require HESK_PATH . 'inc/print_tickets.inc.php';
    /* Print forms for listing and searching tickets */
    /*require(HESK_PATH . 'inc/show_search_form.inc.php');*/
} else {
    echo '<p><i>' . $hesklang['na_view_tickets'] . '</i></p>';
}
/* Clean unneeded session variables */
hesk_cleanSessionVars('hide');
require_once HESK_PATH . 'inc/footer.inc.php';

开发者ID:ermedita-xhafaj，项目名称:support，代码行数:31，代码来源:admin_main.php

示例11: 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 />&nbsp;<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 />&nbsp;<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 />&nbsp;<br />Klemen,<br />\r\n<a href=\"http://www.hesk.com/\" target=\"_blank\">www.hesk.com</a>\r\n\r\n<p>&nbsp;</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 &quot;Getting Started&quot; tips:<br />&nbsp;</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 />&nbsp;</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 />&nbsp;</li>\r\n<li>Add new categories (departments) on the Categories page. The default category cannot be deleted, but it can be renamed.<br />&nbsp;</li>\r\n<li>Create new staff accounts on the Users page. You can give them unlimited (Administrator) or restricted (Staff) access.<br />&nbsp;</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 />&nbsp;</li>\r\n<li>You can create response and new ticket templates on the Canned page.<br />&nbsp;</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 />&nbsp;</li>\r\n<li>You should follow HESK on Twitter <a href=\"https://twitter.com/HESKdotCOM\" target=\"_blank\">here</a>.<br />&nbsp;</li>\r\n<li>To remove the &quot;<span class=\"smaller\">Powered by Help Desk Software HESK</span>&quot; links from the bottom of your help desk <a href=\"https://www.hesk.com/buy.php\" target=\"_blank\">buy a license here</a>.<br />&nbsp;</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', 'Your name', '[email protected]', '')");
    return true;
}

开发者ID:Orgoth，项目名称:Mods-for-HESK，代码行数:54，代码来源:install.php

示例12: hesk_ticketsByDay

function hesk_ticketsByDay()
{
    global $hesk_settings, $hesklang, $date_from, $date_to, $can_run_reports_full;
    $tickets = array();
    $totals = array('all' => 0, 'resolved' => 0, 'worked' => 0);
    $dt = DateArray($date_from, $date_to);
    // Pre-populate date values
    foreach ($dt as $day) {
        $tickets[$day] = array('all' => 0, 'resolved' => 0, 'worked' => '');
    }
    // SQL query for all
    $res = hesk_dbQuery("SELECT DATE(`dt`) AS `mydt`, COUNT(*) AS `cnt`" . ($hesk_settings['time_worked'] ? ", SUM( TIME_TO_SEC(`time_worked`) ) AS `seconds_worked`" : '') . " FROM `" . hesk_

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP hesk_dbResult函数代码示例发布时间：2022-05-15

PHP hesk_dbNumRows函数代码示例发布时间：2022-05-15

librespeed/speedtest: Self-hosted Speedt

avehtari/BDA_m_demos: Bayesian Data Anal

2022-08-17

四维彩超怎么看性别？四维看男孩女孩诀窍

2022-11-06

robotmedia/AndroidBillingLibrary: Androi

2022-08-15

medfreeman/markdown-it-toc-and-anchor: m

2022-08-18

在Delphi中使用C++对象（两种方法，但都要

2022-07-18

阅读排行榜

1 深入理解Delphi的消息机制（别人写的，简明

永远记住，无论你是用SDK还是借用VCL来创建窗口，都要遵循Windows的游戏规则，即先注

阅读：1199|2022-07-22

2 librespeed/speedtest: Self-hosted Speedt

librespeed/speedtest: Self-hosted Speedtest for HTML5 and more. Easy setup, exam

阅读：1210|2022-08-30

3 CVE-2022-34550

Sims v1.0 was discovered to contain a cross-site scripting (XSS) vulnerability v

阅读：701|2022-07-29

4 avehtari/BDA_m_demos: Bayesian Data Anal

avehtari/BDA_m_demos: Bayesian Data Analysis demos for Matlab/Octave

阅读：1116|2022-08-17

5 四维彩超怎么看性别？四维看男孩女孩诀窍

女人怀孕后，为了有一个健康聪明的宝宝，经历各种体检、筛查。其实这些体检和筛查中的

阅读：929|2022-11-06

6 medfreeman/markdown-it-toc-and-anchor: m

medfreeman/markdown-it-toc-and-anchor: markdown-it plugin to add a toc and ancho

阅读：1326|2022-08-18

7 sydney0zq/covid-19-detection: The implem

sydney0zq/covid-19-detection: The implementation of A Weakly-supervised Framewor

阅读：477|2022-08-16

8 CVE-2022-21564

Vulnerability in the Oracle WebLogic Server product of Oracle Fusion Middleware

阅读：878|2022-07-29

9 世界上哪个国家离中国最远？

离中国最远的国家是阿根廷。从太平洋直线计算，即往东线走，北京到阿根廷的布宜诺斯艾

阅读：625|2022-11-06

10 欠钱不还怎么办最有效的方法

钱，是这个社会必不可少的东西。因为钱，我们也能认清身边的人，借钱时见人心，还钱

阅读：777|2022-07-30

客服电话

电子邮件

PHP hesk_dbQuery函数代码示例

示例1: hesk_iTestDatabaseConnection

示例2: update_profile

示例3: hesk_printCustomerReplyForm

示例4: hesk_dbFetchAssoc

示例5: define

示例6: hesk_profile_tab

示例7: change_manager

示例8: toggle_type

示例9: mail_list_messages

示例10: hesk_dbQuery

示例11: hesk_iTables

示例12: hesk_ticketsByDay

请发表评论

全部评论

上一篇：

下一篇：

bradtraversy/iweather: Ionic 3 mobile we

joaomh/curso-de-matlab

断牙刷新位置时间（断牙属性及刷新位置介绍

MATLAB算术运算符和常用函数 - chloe_zhou

rugk/mastodon-simplified-federation: Sim

librespeed/speedtest: Self-hosted Speedt

avehtari/BDA_m_demos: Bayesian Data Anal

四维彩超怎么看性别？四维看男孩女孩诀窍

robotmedia/AndroidBillingLibrary: Androi

medfreeman/markdown-it-toc-and-anchor: m

在Delphi中使用C++对象（两种方法，但都要

关于我们

产品与服务

解决方案

139-2527-9053