//$rs = mysql_query($sql,$conn);
$rs = executeSelect($sql, $conn);
$cnt = 1;
while ($row = mysql_fetch_array($rs)) {
?>
<tr align="left" class="whitebasic">
<td align="center"><input type="checkbox" name="chk[]" id="c<?php
echo $cnt;
?>
" value="<?php
echo $row["nDLId"];
?>
" class="checkbox"></td>
<td><?php
echo htmlentities(trim_the_string($row["vDescription"]));
?>
</td>
<td><?php
echo date("m/d/Y", strtotime($row["dPostdate"]));
?>
</td>
<td><?php
echo $row["vURL"];
?>
</td>
<td width="7%" align="center"><a href="editdownloads.php?id=<?php
echo $row["nDLId"];
?>
&stylename=STYLEDOWNLOADS&styleminus=minus12&styleplus=plus12&"><img src="././../images/edit.gif" width="13" height="13" border="0" title="<?php
echo TEXT_TITLE_EDIT;
<a href="<?php
echo SITE_URL . 'categories.php';
?>
"><?php
echo KB_CATEGORIES;
?>
</a> >>
<a href="<?php
echo SITE_URL . 'kb/' . $seolinkKb . '/catid=' . $kbData['nCatId'];
?>
"><?php
echo $kbData['vCatDesc'];
?>
</a> >>
<span><?php
echo trim_the_string($kbData['vKBTitle'], 50);
?>
</span>
</div>
<div class="content_section_title">
<h3><?php
echo TEXT_KNOWLEDGEBASE;
?>
</h3>
</div>
<div class="content_section">
<div class="content_section_data">
<?php
if ($error) {
echo "<div class='msg_error'>" . $errormessage . "</div>";
?>
<tr align="left" class="whitebasic">
<td align="center"><input type="checkbox" name="chk[]" id="c<?php
echo $cnt;
?>
" value="<?php
echo $row["vLangCode"];
?>
" class="checkbox" ></td>
<td><?php
echo htmlentities(trim_the_string($row["vLangCode"]));
?>
</td>
<td><?php
echo htmlentities(trim_the_string($row["vLangDesc"]));
?>
</td>
<!--<td width="6%"><a href="editlang.php?id=<?php
echo $row["vLangCode"];
?>
&stylename=<?php
echo $var_stylename;
?>
&styleminus=<?php
echo $var_styleminus;
?>
&styleplus=<?php
echo $var_styleplus;
?>
&"><img src="././../images/edit.gif" width="13" height="13" border="0" title="<?php
echo $cnt;
?>
" value="<?php
echo $row["nPNId"];
?>
" class="checkbox"></td>
<td><?php
echo htmlentities(trim_the_string($row["vPNTitle"]));
?>
</td>
<td><?php
echo htmlentities(trim_the_string($row["vRefNo"]));
?>
</td>
<td><?php
echo htmlentities(trim_the_string($row["vLogin"]));
?>
</td>
<td width="8%" align="center"><a href="editpersonalnotes.php?id=<?php
echo $row["nPNId"];
?>
&stylename=STYLEPERSONALNOTES&styleminus=minus16&styleplus=plus16&"><img src="././../images/edit.gif" width="13" height="13" border="0" title="<?php
echo TEXT_TITLE_EDIT;
?>
"></a></td>
<td width="8%" align="center"><a href="javascript:deleted('<?php
echo $row["nPNId"];
?>
');"><img src="././../images/delete.gif" width="13" height="13" border="0" title="<?php
echo TEXT_TITLE_DELETE;
?>
?>
<tr align="left" class="whitebasic">
<td align="center"><input type="checkbox" name="chk[]" id="c<?php
echo $cnt;
?>
" value="<?php
echo $row["nRuleId"];
?>
" class="checkbox">
<td width="45%"><?php
echo htmlentities(trim_the_string($row["vRuleName"]));
?>
</td>
<td><?php
echo htmlentities(trim_the_string($row["vStaffName"]));
?>
</td>
<td><?php
echo $row["dDate"];
?>
</td>
<td width="6%" align="center"><a href="editrules.php?id=<?php
echo $row["nRuleId"];
?>
&stid=<?php
echo $row["nStaffId"];
?>
&stylename=STYLERULES&styleminus=minus23&styleplus=plus23&"><img src="././../images/edit.gif" width="13" height="13" border="0" title="<?php
echo TEXT_TITLE_EDIT;
?>
?>
<tr align="left" class="listingmaintext">
<td width="3%"><input type="checkbox" name="chk[]" id="c<?php
echo $cnt;
?>
" value="<?php
echo $row["vLookUpValue"];
?>
" class="checkbox" ></td>
<td width="48%"><?php
echo htmlentities(trim_the_string($file_ext_name));
?>
</td>
<td width="34%" align="center"><?php
echo htmlentities(trim_the_string($file_ext_type));
?>
</td>
<td align="center"><a href="javascript:deleted('<?php
echo $row["vLookUpValue"];
?>
');"><img src="././../images/delete.gif" width="13" height="13" border="0" title="<?php
echo TITLE_DELETE_ATTACHMENT;
?>
"></a></td>
</tr>
<?php
$cnt++;
}
mysql_free_result($rs);
?>
// | Authors: johnson<*****@*****.**> |
// +----------------------------------------------------------------------+
require_once "./includes/applicationheader.php";
include "languages/" . $_SP_language . "/knowledgebase.php";
if (!userLoggedIn()) {
require_once "./includes/withoutlogindata.php";
}
$conn = getConnection();
include "./includes/docheader.php";
include "./includes/functions/functions.php";
$kbId = $_REQUEST['id'];
if ($kbId > 0) {
$kbDataRes = getKbData($kbId);
$kbData = mysql_fetch_assoc($kbDataRes);
}
$title = $kbData['vKBTitle'] ? $kbData['vCatDesc'] . ' - ' . trim_the_string($kbData['vKBTitle'], 70) : HEADER_KB;
?>
<title><?php
echo $title;
?>
</title>
<?php
//include("./includes/headsettings.php");
include "./includes/setkbmetatag.php";
?>
<!---------------------------------------RATING POP UP STYLE AND SCRIPT------------------------------->
<script language="javascript" src="<?php
echo SITE_URL;
?>
echo $cnt;
?>
" value="<?php
echo $row["nLabelId"];
?>
" class="checkbox">
</td>
<td>
<a href="labeltickets.php?id=<?php
echo $row["nLabelId"];
?>
&label=<?php
echo htmlentities(trim_the_string($row["vLabelname"]));
?>
&stylename=STYLELABELS&styleminus=minus11&styleplus=plus11&" class="listing"><?php
echo htmlentities(trim_the_string($row["vLabelname"]));
?>
</a>
</td>
<td><?php
echo $row["vLogin"] == "" ? "Administrator" : $row['vLogin'];
?>
</td>
<td width="6%"><a href="editlabels.php?id=<?php
echo $row["nLabelId"];
?>
&stylename=STYLELABELS&styleminus=minus11&styleplus=plus11&"><img src="././../images/edit.gif" width="13" height="13" border="0" title="<?php
echo TEXT_TITLE_EDIT;
?>
"></a></td>
//$rs = mysql_query($sql,$conn);
$rs = executeSelect($sql, $conn);
$cnt = 1;
while ($row = mysql_fetch_array($rs)) {
?>
<tr align="left" class="whitebasic">
<td align="center"><input type="checkbox" name="chk[]" id="c<?php
echo $cnt;
?>
" value="<?php
echo $row["nNewsId"];
?>
" class="checkbox"></td>
<td><?php
echo htmlentities(trim_the_string($row["vTitle"]));
?>
</td>
<td><?php
echo datetimefrommysql($row["dPostdate"]);
?>
</td>
<td><?php
echo datetimefrommysql($row["dVaildDate"]);
?>
</td>
<td width="6%" align="center"><a href="editnews.php?id=<?php
echo $row["nNewsId"];
?>
&stylename=STYLENEWS&styleminus=minus11&styleplus=plus11&"><img src="././../images/edit.gif" width="13" height="13" border="0" title="<?php
echo TEXT_TITLE_EDIT;
//$rs = mysql_query($sql,$conn);
$rs = executeSelect($sql, $conn);
$cnt = 1;
while ($row = mysql_fetch_array($rs)) {
?>
<tr align="left" class="whitebasic">
<td align="center"><input type="checkbox" name="chk[]" id="c<?php
echo $cnt;
?>
" value="<?php
echo $row["nCSSId"];
?>
" class="checkbox"></td>
<td><?php
echo htmlentities(trim_the_string($row["vCSSName"]));
?>
</td>
<td><?php
echo date("m/d/Y", strtotime($row["dDate"]));
?>
</td>
<td><?php
echo basename($row["vCSSURL"]);
?>
</td>
<td width="7%" align="center"><a href="editdisplay.php?id=<?php
echo $row["nCSSId"];
?>
&stylename=STYLEDISPLAY1&styleminus=minus3&styleplus=plus3&"><img src="././../images/edit.gif" width="13" height="13" border="0" title="<?php
echo TEXT_TITLE_EDIT;
echo $cnt;
?>
" value="<?php
echo $row["nDeptId"];
?>
" class="checkbox"></td>
<td><?php
echo htmlentities(trim_the_string($row["vCompName"]));
?>
</td>
<td><?php
echo htmlentities(trim_the_string($row["vDeptDesc"]));
?>
</td>
<td><?php
echo htmlentities(trim_the_string($row["vDeptMail"]));
?>
</td>
<td width="7%" align="center"><a href="editdepartments.php?id=<?php
echo $row["nDeptId"];
?>
&stylename=STYLEDEPARTMENTS&styleminus=minus6&styleplus=plus6&"><img src="././../images/edit.gif" width="13" height="13" border="0" title="<?php
echo TEXT_TITLE_EDIT;
?>
"></a></td>
<td width="7%" align="center"><a href="javascript:deleted('<?php
echo $row["nDeptId"];
?>
');"><img src="././../images/delete.gif" width="13" height="13" border="0" title="<?php
echo TEXT_TITLE_DELETE;
?>
<?php
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
//echo '<pre>'; print_r($kbData); echo '</pre>';
if ($kbData["vMetaTage_desc"]) {
$metaTagDesc = $kbData["vMetaTage_desc"];
} else {
$metaTagDesc = trim_the_string($kbData["vKBTitle"], 75) . ' - ' . trim_the_string(strip_tags($kbData["tKBDesc"]), 220);
}
$metaTagKeyword = $kbData["vMetaTage_keyword"] == "" ? $kbData["vCatDesc"] : $kbData["vMetaTage_keyword"];
?>
<style type="text/css">
<!--
body {
/* font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
background-color:#EDEBEB;
margin-top:0px;
margin-left:10px;
margin-right:10px;
margin-bottom:0px;*/
}
-->
</style>
<?php
$_SESSION["sess_cssurl"] = $_SESSION["sess_cssurl"] == "" ? "styles/AquaBlue/style.css" : $_SESSION["sess_cssurl"];
?>
</td>
<td><?php
if ($row['dTimeEnd'] == '0000-00-00 00:00:00') {
echo "Not Completed";
} else {
echo date("m/d/Y H:i:s", strtotime($row['dTimeEnd']));
}
// echo $row['dTimeEnd'];}
?>
</td>
<td><?php
echo htmlentities(trim_the_string($row["user_staff"]));
?>
</td>
<td><?php
echo htmlentities(trim_the_string($row["staffname"]));
?>
</td>
<td ><a href="javascript:viewChatLog(<?php
echo $row['nChatId'];
?>
,'<?php
echo $row['chat_flg'];
?>
');"><?php
echo TEXT_VIEW_LOG;
?>
</a></td>
</tr>
<?php
$cnt++;
$prior_icon = "../ticketPriorLogo/noicon.jpg";
}
?>
<img src="<?php
echo $prior_icon;
?>
" alt="icon" height="50" width="50" >
</td>
<td align="center" width="15%" >
<a class="miniColors-trigger" style="cursor: default; background-color: <?php
echo htmlentities(trim_the_string($row["vTicketColor"]));
?>
"></a>
</td>
<td align="center" width="15%" ><?php
echo htmlentities(trim_the_string($row["nPriorityValue"]));
?>
</td>
<td width="9%" align="center"><a href="priority.php?id=<?php
echo $row["nPriorityId"];
?>
&stylename=STYLETICKETS&styleminus=minus9&styleplus=plus9&"><img src="././../images/edit.gif" width="13" height="13" border="0" title="<?php
echo TEXT_EDIT_PRIORITY;
?>
"></a></td>
<td width="10%" align="center">
<?php
if ($row["nPriorityValue"] != "0") {
?>
<a href="javascript:deleted('<?php
echo $row["nPriorityId"];
//echo "<br>".time();
//$rs = mysql_query($sql,$conn);
$rs = executeSelect($sql, $conn);
$cnt = 1;
while ($row = mysql_fetch_array($rs)) {
?>
<tr align="left" class="listingmaintext"><td align="center"><input type="checkbox" name="chk[]" id="c<?php
echo $cnt;
?>
" value="<?php
echo $row["vLookUpValue"];
?>
" class="checkbox" >
<td width="81%"><?php
echo htmlentities(trim_the_string($row["vLookUpValue"]));
?>
</td>
<td width="15%" align="center"><a href="javascript:deleted('<?php
echo mysql_real_escape_string($row["vLookUpValue"]);
?>
');"><img src="././../images/delete.gif" width="13" height="13" border="0" title="<?php
echo TEXT_DELETE_STATUS;
?>
"></a></td>
</tr>
<?php
$cnt++;
}
mysql_free_result($rs);
?>
while ($recentlyAddedVal = mysql_fetch_assoc($recentlyAddedKbs)) {
$seolink = str_replace(" ", "-", stripslashes($recentlyAddedVal['vKBTitle']));
$seolink = preg_replace('/[^a-zA-Z0-9__.-]/s', '', $seolink);
$seolink = strtolower($seolink);
$seolink = substr($seolink, 0, 100);
$viewkbentry_seo_link = SITE_URL . "kb/" . str_replace("?", "", $seolink) . "/" . $recentlyAddedVal["nKBID"];
?>
<li>
<a href="<?php
echo $viewkbentry_seo_link;
?>
"><span><?php
echo $recentlyAddedVal['vCatDesc'];
?>
-</span><?php
echo trim_the_string($recentlyAddedVal['vKBTitle'], 100);
?>
</a>
</li>
<?php
}
?>
</ul>
</div>
<?php
}
?>
</div>
