Bigjoos |
15th October 2008 11:46 |
Advanced HelpDesk With Ticket System
Originally posted by decoder - this mod was in dutch and never had notification of new tickets ect - the functions have all been moddified by myself and placed onto there own file to be included on helpdesk only .. why process functions only required by one file eh.. :lol: then i translated the whole lot fixed some issues to the stage its running fine on my test code with no real bugs i've noticed - Any issues arise i'll try to assist but its not my creation....
Code:
CREATE TABLE `helpdesk` (
`id` int(10) unsigned NOT NULL auto_increment,
`closed` enum('yes','no') NOT NULL default 'no',
`message` varchar(255) NOT NULL default '',
`ticket` int(15) NOT NULL default '0',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`read_date` datetime NOT NULL default '0000-00-00 00:00:00',
`userid` int(11) NOT NULL default '0',
`edit_by` int(11) NOT NULL default '0',
`edit_date` datetime NOT NULL default '0000-00-00 00:00:00',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
helpesk.php
PHP Code:
<?php ob_start("ob_gzhandler"); require_once("include/bittorrent.php"); require_once("include/function_help.php"); dbconn(); loggedinorreturn();
if(isset($_POST['action'])) $action = $_POST['action']; else $action = "";
if ($action == "close_sure") { $ticket = 0 + $_POST['ticket']; mysql_query("UPDATE helpdesk SET closed='Yes' WHERE id=$ticket") or sqlerr(__FILE__, __LINE__); mysql_query("UPDATE helpdesk SET closed='Yes' WHERE ticket=$ticket") or sqlerr(__FILE__, __LINE__); } if ($action == "close") { stdhead("Helpdesk"); page_start(98); table_top("Ticket Close","center"); table_start(); $ticket = 0 + $_POST['ticket']; print "<font size=3 color=lightblue>You have " . $ticket . " help ticket's to close."; print ""; print "<table class=bottom width=30% border=0 cellspacing=0 cellpadding=4>"; print "<tr>"; print "<td class=embedded><div align=center>"; print "<form method=post action=helpdesk.php>"; print "<input type=hidden name=action value=close_sure>"; print "<input type=hidden name=ticket value=".$ticket.">"; print "<input type=submit class=btn style='height: 20px; width: 100px' value='Yes'>"; print "</form>"; print "</td>"; print "<td class=embedded><div align=center>"; print "<form method=post action=helpdesk.php>"; print "<input type=submit class=btn style='height: 20px; width: 100px' value='No'>"; print "</form>"; print "</td>"; print "</tr></table>";
table_end(); page_end(); stdfoot(); die; }
if ($action == "save_new") { $message = $_POST['message']; if (!$message) site_error_message("Error", "You must enter a description of your problem."); $user_id = 0 + $_POST['user_id']; $message = sqlesc($message); $added = sqlesc(get_date_time()); $res = mysql_query("SELECT * FROM helpdesk WHERE message=$message AND userid=$user_id") or sqlerr(__FILE__, __LINE__); $row = mysql_fetch_array($res); if ($row) site_error_message("Error", "You must enter a description of your problem."); mysql_query("INSERT INTO helpdesk (added, userid, message) VALUES ($added, $user_id, $message)"); }
if ($action == "save_edit") { $message = $_POST['message']; if (!$message) site_error_message("Error", "You must enter a description of your problem."); $ticket = 0 + $_POST['ticket']; $user_id = $CURUSER['id']; $message = sqlesc($message); $added = sqlesc(get_date_time()); mysql_query("UPDATE helpdesk SET edit_by = $user_id, edit_date = $added, message = $message WHERE id=$ticket") or sqlerr(__FILE__, __LINE__); }
if ($action == "save_anwser") { $message = $_POST['message']; $receiver = $_POST['receiver']; if (!$message) site_error_message("Error", "You must enter a description of your problem."); $user_id = 0 + $_POST['user_id']; $ticket = 0 + $_POST['ticket']; $message = sqlesc($message); $added = sqlesc(get_date_time()); $res = mysql_query("SELECT * FROM helpdesk WHERE message=$message AND userid=$user_id AND ticket=$ticket") or sqlerr(__FILE__, __LINE__); $row = mysql_fetch_array($res); if ($row) site_error_message("Error", "You can not have the same answer again send a new request."); mysql_query("INSERT INTO helpdesk (ticket, added, userid, message) VALUES ($ticket, $added, $user_id, $message)") or sqlerr(__FILE__, __LINE__); $message = "Hello " . get_username($receiver) . ",\n\n"; $message .= "A staff member has responded to your help request ticket.\n\n"; $message .= "Use the provided link to see the answer.\n\n"; $message .= $BASEURL."/helpdesk.php\n\n"; $message .= "Regards\n". $SITE_NAME ; $message = sqlesc($message); if ($receiver <> $user_id) mysql_query("INSERT INTO messages (sender, receiver, msg, added) VALUES (0, $receiver, $message, $added)") or sqlerr(__FILE__, __LINE__); }
if ($action == "edit") { $ticket = $_POST['ticket']; site_header("Helpdesk"); page_start(98); table_top("Ticket Edit","center"); table_start();
$res = mysql_query("SELECT * FROM helpdesk WHERE id=$ticket") or sqlerr(__FILE__, __LINE__); $row = mysql_fetch_array($res); if ($row) { $message = $row['message']; print "<font color=lightblue size=2><b>All question's which are already covered in our <a class=altlink_yellow href='faq.php'>Faq</a> Or our <a class=altlink_yellow href='forums.php'>Forum's</a> will be<font color=red><b> Ignored !</b></font></font>"; print "<hr>"; print "<font color=lightblue size=2><b>You should provide as much information as possible about your problem.</font>"; print "<hr>"; print "<table width=70% border=1 cellspacing=0 cellpadding=5>"; print "<form method=post action=helpdesk.php>"; print "<input type=hidden name=action value=save_edit>"; print "<input type=hidden name=ticket value=".$ticket.">"; print "<tr><td bgcolor=#242424><textarea name=message cols=225 rows=15>".htmlspecialchars($message)."</textarea></td></tr>"; print "<tr><td bgcolor=#242424 align=center><input type=submit class=btn style='height: 25px; width: 120px' value='Submit'></td></tr>"; print "</table>"; print "</form>"; } table_end(); page_end(); stdfoot(); die; } if ($action == "anwser") { $ticket = $_POST['ticket']; $receiver = $_POST['receiver']; stdhead("Helpdesk"); page_start(98); table_top("Ticket answer","center"); table_start(); print "<table width=70% border=1 cellspacing=0 cellpadding=5>"; print "<form name=hd_anwser method=post action=helpdesk.php>"; print "<input type=hidden name=action value=save_anwser>"; print "<input type=hidden name=ticket value=".$ticket.">"; print "<input type=hidden name=receiver value=".$receiver.">"; print "<input type=hidden name=user_id value=".$CURUSER['id'].">"; print "<tr><td bgcolor=#242424><textarea name=message cols=225 rows=15></textarea></td></tr>"; print "<tr><td bgcolor=#242424 align=center><input type=submit class=btn style='height: 25px; width: 120px' value='Submit'></td></tr>"; print "</table>"; print "</form>"; ?> <script LANGUAGE="JavaScript" type="text/javascript"> <!-- document.hd_anwser.message.focus(); //--> </script> <? print "";
$res = mysql_query("SELECT * FROM helpdesk WHERE id=$ticket") or sqlerr(__FILE__, __LINE__); while ($row = mysql_fetch_assoc($res)) { print "<table class=sitetable width=98% border=0 cellspacing=0 cellpadding=4>"; print "<tr><td class=colheadsite>"; print "Ticket - " . $row['id'] . " - Summary of answers (old to new from bottom to top)"; print "</td></tr><tr><td bgcolor=gray>";
$ticket = $row['id']; $res2 = mysql_query("SELECT * FROM helpdesk WHERE closed='no' AND ticket=$ticket ORDER BY added DESC") or sqlerr(__FILE__, __LINE__); while ($row2 = mysql_fetch_assoc($res2)) { print ""; print "<table class=sitetable width=100% border=0 cellspacing=0 cellpadding=4>"; print "<tr>"; print "<td class=colheadsite width=150>"; print "Added By: <a href=userdetails.php?id=".$row2['userid']."><font color=blue>".get_username($row2['userid'])."</font></a>"; print "</td>"; print "<td class=colheadsite>"; print "Date: " . convertdate($row2['added']); print "</td>"; print "</tr><tr>"; print "<td class=test colspan=2>"; $message = $row2['message']; if ($row2['edit_by'] > 0) $message .= "\n\n<font color=red> Last edited by " . get_username($row2['edit_by']) . " " . convertdate($row2['edit_date']); print stripslashes(nl2br($message)); print "</td></tr></table>"; } print "<table class=sitetable width=100% border=0 cellspacing=0 cellpadding=4>"; print "<tr>"; print "<td class=colheadsite width=150>"; print "Added by: <a href=userdetails.php?id=".$row['userid']."><font color=blue>".get_username($row['userid'])."</font></a>"; print "</td>"; print "<td class=colheadsite>"; print "Date: " . convertdate($row['added']); print "</td>"; print "</tr><tr>"; print "<td class=test colspan=2>"; $message = $row['message']; if ($row['edit_by'] > 0) $message .= "\n\n<font color=red>Last edited by " . get_username($row['edit_by']) . " " . convertdate($row['edit_date']); print stripslashes(nl2br($message)); print "</td></tr></table>"; print "</td></tr></table>"; }
table_end(); page_end(); stdfoot(); die; }
if ($action == "new") { stdhead("Helpdesk"); page_start(98); table_top("Ask new question","center"); table_start(); print "<font color=lightblue size=2><b>All question's which are already covered in our <a class=altlink_yellow href='faq.php'>Faq</a> Or our <a class=altlink_yellow href='forums.php'>Forum's</a> will be<font color=red><b> Ignored !</b></font></font>"; print "<hr>"; print "<font color=lightblue size=2><b>You should provide as much information as possible about your problem.</font>"; print "<hr>"; print "<table width=70% border=1 cellspacing=0 cellpadding=5>"; print "<form name=hd_new method=post action=helpdesk.php>"; print "<input type=hidden name=action value=save_new>"; print "<input type=hidden name=user_id value=".$CURUSER['id'].">"; print "<tr><td bgcolor=#242424><center><textarea name=message cols=125 rows=15></textarea></center></td></tr>"; print "<tr><td bgcolor=#242424 align=center><input type=submit class=btn style='height: 25px; width: 120px' value='Send'></td></tr>"; print "</table>"; print "</form>"; ?> <script LANGUAGE="JavaScript" type="text/javascript"> <!-- document.hd_new.message.focus(); //--> </script> <? table_end(); page_end(); stdfoot(); die; }
if ($action == "view") { $ticket = 0 + $_POST['ticket'];
stdhead("Helpdesk"); print "<table width=98% class=bottom border=0 cellspacing=0 cellpadding=0><tr><td class=embedded><center>"; table_top("Helpdesk","center"); print "<table background=pic/site/table_background.gif width=100% border=0 cellspacing=0 cellpadding=0>"; print "<tr>"; print "<td class=embedded align=center><center>";
if (get_user_class() > UC_MODERATOR) { print "<form method=post action=helpdesk.php>"; print "<input type=hidden name=action value=view_list>"; print "<input type=submit class=btn style='height: 24px; width: 150px' value='Overview'>"; print "</form>"; }
$current_user = $CURUSER['id']; $count = get_row_count("helpdesk", "WHERE closed='no' AND userid=$current_user"); if ($CURUSER['support'] == "yes") $count = 1; if (get_user_class() > UC_MODERATOR) $count = 1; if ($count > 0) { $res = mysql_query("SELECT * FROM helpdesk WHERE closed='no' AND id=$ticket") or sqlerr(__FILE__, __LINE__); while ($row = mysql_fetch_assoc($res)) { print "<table class=sitetable width=98% border=0 cellspacing=0 cellpadding=4>"; print "<tr><td class=colheadsite>"; print "Ticket - " . $row['id'] . " - made by: <a href=userdetails.php?id=".$row['userid']."><font color=yellow>".get_username($row['userid'])."</font></a> ".convertdate($row['added']); if ($row['userid'] == $CURUSER['id']) { print " edit"; } print "</td></tr><tr><td bgcolor=gray>"; print "<table class=sitetable width=100% border=0 cellspacing=0 cellpadding=4>"; print "<tr>"; print "<td class=test width=150>"; print "Sent By: <a href=userdetails.php?id=".$row['userid']."><font color=lime>".get_username($row['userid'])."</font></a>"; print "</td>"; if ($row['userid'] == $CURUSER['id']) { print "<td class=test>"; print "<form method=post action=helpdesk.php>"; print "<input type=hidden name=ticket value=".$row['id'].">"; print "<input type=hidden name=action value=edit>"; print "Date: " . convertdate($row['added']); print " <input type=submit class=btn style='height: 18px; width: 80px' value='edit'>"; print "</form>"; print "</td>"; } else { print "<td class=test>"; print "Date: " . convertdate($row['added']); print "</td>"; } print "</tr><tr>"; print "<td colspan=2 class=test>"; $message = $row['message']; if ($row['edit_by'] > 0) $message .= "\n\n<font color=red>Last edited by " . get_username($row['edit_by']) . " " . convertdate($row['edit_date']); print stripslashes(nl2br($message)); print "</td></tr></table>"; $ticket = $row['id']; $res2 = mysql_query("SELECT * FROM helpdesk WHERE closed='no' AND ticket=$ticket") or sqlerr(__FILE__, __LINE__); while ($row2 = mysql_fetch_assoc($res2)) { if ($row2['read_date'] == "0000-00-00 00:00:00") $extra_text = " <font color=red>unread</font>"; else $extra_text = " <font color=red>read by " . get_username($row['userid']) . " " . convertdate($row2['read_date']) . " </font>"; print ""; print "<table class=sitetable width=100% border=0 cellspacing=0 cellpadding=4>"; print "<tr>"; print "<td class=test width=150>"; print "Sent by: <a href=userdetails.php?id=".$row2['userid']."><font color=lime>".get_username($row2['userid'])."</font></a>"; print "</td>"; if ($row2['userid'] == $CURUSER['id']) { print "<td class=test>"; print "<form method=post action=helpdesk.php>"; print "<input type=hidden name=ticket value=".$row2['id'].">"; print "<input type=hidden name=action value=edit>"; print "Date: " . convertdate($row2['added']) . $extra_text; print " <input type=submit class=btn style='height: 18px; width: 80px' value='edit'>"; print "</form>"; print "</td>"; } else { print "<td class=test>"; print "Date: " . convertdate($row2['added']) . $extra_text; print "</td>"; } print "</tr><tr>"; print "<td class=test colspan=2>"; $message = $row2['message']; if ($row2['edit_by'] > 0) $message .= "\n\n<font color=red>Last edited by " . get_username($row2['edit_by']) . " " . convertdate($row2['edit_date']); print stripslashes(nl2br($message)); print "</td></tr></table>"; } print "<table class=bottom width=100% border=0 cellspacing=0 cellpadding=4>"; print "<tr>"; print "<td class=embedded width=99%> </td><td class=embedded>"; print "<form method=post action=helpdesk.php>"; print "<input type=hidden name=action value=anwser>"; print "<input type=hidden name=receiver value=".$row['userid'].">"; print "<input type=hidden name=ticket value=".$row['id'].">"; print "<input type=submit class=btn style='height: 20px; width: 100px' value='Answer'>"; print "</form>"; print "</td>"; if (get_user_class() >= UC_MODERATOR) { print "<td class=embedded>"; print "<form method=post action=helpdesk.php>"; print "<input type=hidden name=action value=close>"; print "<input type=hidden name=ticket value=".$row['id'].">"; print "<input type=submit class=btn style='height: 20px; width: 100px' value='Close'>"; print "</form>"; print "</td>"; } print "</tr></table>"; print "</td></tr></table>"; } } print "<form method=post action=helpdesk.php>"; print "<input type=hidden name=action value=new>"; print "<input type=submit class=btn style='height: 24px; width: 150px' value='Ask a new question'>"; print "</form>"; print ""; print "</td></tr></table>"; print "</td></table>"; stdfoot(); die; } if ($CURUSER['support'] == "yes" || get_user_class() > UC_MODERATOR) $action = "view_list";
if ($action == "view_list") { stdhead("Helpdesk"); print "<table width=98% class=bottom border=0 cellspacing=0 cellpadding=0><tr><td class=embedded><center>"; table_top("Ticket overview","center"); print "<table background=pic/site/table_background.gif width=100% border=0 cellspacing=0 cellpadding=0>"; print "<tr>"; print "<td class=embedded align=center><center>"; $current_user = $CURUSER['id']; if ($CURUSER['support'] == "yes") $count = 1; if (get_user_class() > UC_MODERATOR) $count = 1; if ($count > 0) { print "<font size=3 color=yellow><b>Old to new is from bottom to top..</b></font>"; print "<table class=sitetable width=98% border=0 cellspacing=0 cellpadding=4>"; print "<tr>"; print "<td class=colheadsite width=30 align=center>##</td>"; print "<td class=colheadsite width=80>By</td>"; print "<td class=colheadsite width=180>Date</td>"; print "<td class=colheadsite>Question</td>"; print "<td class=colheadsite width=50>Answers</td>"; print "<td class=colheadsite width=50>Open</td>"; print "</tr>"; $res = mysql_query("SELECT * FROM helpdesk WHERE closed='no' AND ticket='0' ORDER BY added DESC") or sqlerr(__FILE__, __LINE__); while ($row = mysql_fetch_assoc($res)) { $reacties = get_row_count("helpdesk", "WHERE closed='no' AND ticket=".$row['id']); $reacties_read = get_row_count("helpdesk", "WHERE read_date<>'0000-00-00 00:00:00' AND closed='no' AND ticket=".$row['id']); print "<tr>"; print "<td class=test width=30 align=center>"; print $row['id']; print "</td>"; print "<td class=test width=80>"; print get_username($row['userid']); print "</td>"; print "<td class=test width=180>"; print convertdate($row['added']); print "</td>"; print "<td class=test>";
//print("<a href=\"java script: klappe('a".$row['id']."')\"><img border=\"0\" src=\"pic/java/plus.gif\" id=\"pica".$row['id']."\" alt=\"Show/Hide\"></a> "); // .stripslashes(substr($row['message'],0,100)) //print("<div id=\"ka".$row['id']."\" style=\"display: block;\"> 22".stripslashes($row['message'])." </div> "); //print("<div id=\"ka".$row['id']."\" style=\"display: block;\"> 33".stripslashes($row['message'])." </div> ");
print htmlspecialchars(stripslashes(substr($row['message'],0,400))) . " -=>"; print "</td>"; print "<td class=test align=center>"; print $reacties . " <font color=red>(" . $reacties_read . ")</font>"; print "</td>"; print "<td class=test>";
print "<form method=post action=helpdesk.php>"; print "<input type=hidden name=action value=view>"; print "<input type=hidden name=ticket value=".$row['id'].">"; print "<input type=submit class=btn style='height: 20px; width: 50px;background: blue;color: yellow' value='Open'>"; print "</form>";
print "</td></tr>"; } print "</table>"; }
print "</td></tr></table>"; print "</td></table>"; stdfoot(); die; }
stdhead("Helpdesk"); print "<table width=98% class=bottom border=0 cellspacing=0 cellpadding=0><tr><td class=embedded><center>"; table_top("Helpdesk","center"); print "<table background=pic/site/table_background.gif width=100% border=0 cellspacing=0 cellpadding=0>"; print "<tr>"; print "<td class=embedded align=center><center>"; $current_user = $CURUSER['id'];
$res = mysql_query("SELECT id FROM helpdesk WHERE read_date='0000-00-00 00:00:00' AND ticket='0' AND closed='no' AND userid=$current_user") or sqlerr(__FILE__, __LINE__); $row = mysql_fetch_array($res); if ($row) { $ticket = $row['id']; $read_date = sqlesc(get_date_time()); mysql_query("UPDATE helpdesk SET read_date = $read_date WHERE read_date='0000-00-00 00:00:00' AND ticket=$ticket AND closed='no'") or sqlerr(__FILE__, __LINE__); }
$count = get_row_count("helpdesk", "WHERE ticket='0' AND closed='no'");
if ($CURUSER['support'] == "yes") $count = 1;
if (get_user_class() > UC_SYSOP) $count = 1; if ($count > 0) { if ($CURUSER['support'] == "yes" || get_user_class() > UC_MODERATOR) if (get_user_class() > 4) { print "<form method=post action=helpdesk.php>"; print "<input type=hidden name=action value=view_list>"; print "<input type=submit class=btn style='height: 24px; width: 150px' value='Overview'>"; print "</form>"; } $res = mysql_query("SELECT * FROM helpdesk WHERE closed='no' AND ticket='0'") or sqlerr(__FILE__, __LINE__); while ($row = mysql_fetch_assoc($res)) { if ($CURUSER['support'] == "yes" || get_user_class() > UC_MODERATOR) { print "<table class=sitetable width=98% border=0 cellspacing=0 cellpadding=4>"; print "<tr><td class=colheadsite>"; print "Ticket - " . $row['id'] . " - Posted by: <a href=userdetails.php?id=".$row['userid']."><font color=yellow>".get_username($row['userid'])."</font></a> ".convertdate($row['added']); print "</td></tr><tr><td bgcolor=gray>"; print "<table class=sitetable width=100% border=0 cellspacing=0 cellpadding=4>"; print "<tr>"; print "<td class=colheadsite width=250>"; print "Sent by: <a href=userdetails.php?id=".$row['userid']."><font color=lime>".get_username($row['userid'])."</font></a>"; print "</td>"; if ($row['userid'] == $CURUSER['id']) { print "<td class=colheadsite>"; print "<form method=post action=helpdesk.php>"; print "<input type=hidden name=ticket value=".$row['id'].">"; print "<input type=hidden name=action value=edit>"; print "date: " . convertdate($row['added']); print " <input type=submit class=btn style='height: 18px; width: 80px' value='Edit'>"; print "</form>"; print "</td>"; } else { print "<td class=colheadsite>"; print "Date: " . convertdate($row['added']); print "</td>"; } print "</tr><tr>"; print "<td colspan=2 bgcolor=#242424>"; $message = $row['message']; if ($row['edit_by'] > 0) $message .= "\n\n<font color=red>Last edited by " . get_username($row['edit_by']) . " " . convertdate($row['edit_date']); print stripslashes(nl2br($message)); print "</td></tr></table>"; $ticket = $row['id']; $res2 = mysql_query("SELECT * FROM helpdesk WHERE closed='no' AND ticket=$ticket") or sqlerr(__FILE__, __LINE__); while ($row2 = mysql_fetch_assoc($res2)) { if ($row2['read_date'] == "0000-00-00 00:00:00") $extra_text = " <font color=red>Unread</font>"; else $extra_text = " <font color=red>viewed by " . get_username($row['userid']) . " " . convertdate($row2['read_date']) . " </font>"; print ""; print "<table class=sitetable width=100% border=0 cellspacing=0 cellpadding=4>"; print "<tr>"; print "<td class=colheadsite width=250>"; print "Sent by: <a href=userdetails.php?id=".$row2['userid']."><font color=blue>".get_username($row2['userid'])."</font></a>"; print "</td>"; if ($row2['userid'] == $CURUSER['id']) { print "<td class=colheadsite>"; print "<form method=post action=helpdesk.php>"; print "<input type=hidden name=ticket value=".$row2['id'].">"; print "<input type=hidden name=action value=edit>"; print "Date: " . convertdate($row2['added']); print " <input type=submit class=btn style='height: 18px; width: 80px' value='Edit'>" . $extra_text; print "</form>"; print "</td>"; } else { print "<td class=colheadsite>"; print "Date: " . convertdate($row2['added']) . $extra_text; print "</td>"; } print "</tr><tr>"; print "<td class=test colspan=2>"; $message = $row2['message']; if ($row2['edit_by'] > 0) $message .= "\n\n<font color=red>Last edited by " . get_username($row2['edit_by']) . " " . convertdate($row2['edit_date']); print stripslashes(($message)); print "</td></tr></table>"; } if (get_user_class() >= UC_MODERATOR) { print "<table class=bottom width=100% border=0 cellspacing=0 cellpadding=4>"; print "<tr>"; print "<td class=embedded width=99%> </td><td class=embedded>"; print "<form method=post action=helpdesk.php>"; print "<input type=hidden name=action value=anwser>"; print "<input type=hidden name=receiver value=".$row['userid'].">"; print "<input type=hidden name=ticket value=".$row['id'].">"; print "<input type=submit class=btn style='height: 20px; width: 100px' value='Answer'>"; print "</form>"; print "</td>"; } if (get_user_class() >= UC_SYSOP) { print "<td class=embedded>"; print "<form method=post action=helpdesk.php>"; print "<input type=hidden name=action value=close>"; print "<input type=hidden name=ticket value=".$row['id'].">"; print "<input type=submit class=btn style='height: 20px; width: 100px' value='Close'>"; print "</form>"; print "</td>"; } print "</tr></table>"; print "</td></tr></table>"; } } }
print "<form method=post action=helpdesk.php>"; print "<input type=hidden name=action value=new>"; print "<input type=submit class=btn style='height: 30px; width: 200px' value='Ask a new question'>"; print "</form>"; print "";
print "</td></tr></table>"; print "</td></table>";
stdfoot();
?>
then function_help.php - put that in your includes folder or adjust the path on helpdesk.php
PHP Code:
<?php function site_error_message($heading, $text, $color="red") { stdhead(); print "<table class=main border=0 width=60% cellpadding=0 cellspacing=0><tr><td class=embedded>"; table_top ($heading); print "<table background=pic/site/table_background.jpg width=100% border=0 cellspacing=0 cellpadding=10><tr><td class=embedded align=center>"; print "<center><font size=2 color=$color><b>" . $text . "</b></font></center>"; print "</td></tr></table>"; print "</td></tr></table>"; stdfoot(); die; }
function page_end() { print "</td></tr></table>\n"; }
function table_end() { print "</td></tr></table>"; print "</td></tr></table>"; }
function table_start($width=98, $cellpadding=0,$table_width=100,$paddingmain=10) { print("<table align=center background=pic/site/table_background.jpg width=".$table_width."% border=0 cellspacing=0 ,$paddingmain><tr><td class=embedded>"); print("<table align=center class=bottom border=1 width=$width% cellspacing=0 cellpadding=$cellpadding><tr><td class=embedded><div align=center>"); }
function page_start($width=90) { print "<table class=bottom width=$width% border=0 cellspacing=0 cellpadding=0><tr><td class=embedded>\n"; }
function convertdate($date,$time="") { // Date function by XiniX modified by Bigjoos 2008 if (substr($date,5,1) == "0") $month = substr($date,6,1); else $month = substr($date,5,2); if (substr($date,8,1) == "0") $day = substr($date,9,1); else $day = substr($date,8,2); $year = substr($date,0,4); if (!$time == "no") $time = " At " . substr($date,11,8); else $time = ""; if ($month == "1") return $day . " january " . $year . $time; if ($month == "2") return $day . " february " . $year . $time; if ($month == "3") return $day . " march " . $year . $time; if ($month == "4") return $day . " april " . $year . $time; if ($month == "5") return $day . " may " . $year . $time; if ($month == "6") return $day . " june " . $year . $time; if ($month == "7") return $day . " july " . $year . $time; if ($month == "8") return $day . " august " . $year . $time; if ($month == "9") return $day . " september " . $year . $time; if ($month == "10") return $day . " october " . $year . $time; if ($month == "11") return $day . " november " . $year . $time; if ($month == "12") return $day . " december " . $year . $time; }
function get_username($id) { $res = mysql_query("SELECT username FROM users WHERE id = $id"); $row = mysql_fetch_array($res); if ($row) return $row['username']; }
function table_top($msg, $align="",$width=100) { print "<table align=center class=site border=0 width=".$width."% cellpadding=0 cellspacing=0>"; print "<tr><td class=embedded>"; print "<table width=100% class=bottom cellspacing=0 cellpadding=0><tr>"; if ($align == "") print "<td class=top_site><font size=3 color=white> $msg</td>"; else print "<td class=top_site><font size=3 color=white><div align=" . $align . "> $msg </td>"; print "</td></tr></table>"; print "</td></tr></table>"; } ?>[/code]
Add this to above your pm notification code or where you want
[code]//=== help desk message if ($CURUSER['support'] == "yes" || $CURUSER['class'] > UC_MODERATOR){ $resa = mysql_query("select count(id) as ticket from helpdesk WHERE ticket ='0' AND closed ='no'"); $arra = mysql_fetch_assoc($resa); $ticket = $arra[ticket]; if ($ticket > 0){ print("<table align=center border=0 cellspacing=0 cellpadding=10 bgcolor=red><tr><td style=\"padding: 10px; background:red\">\n"); print("<font color=teal>Hi <b>$CURUSER[username]</b>, there is <b>$ticket active ticket(s)</b> at the help desk that requires attention.Please click <b><a href=$BASEURL/helpdesk.php>Here</a></b> to check.</font>"); print("</td></tr></table></p>\n"); } } //===end
finally the css
Code:
table.test{
background: #262626;
}
td.colheadsite {
font-weight: bold;
color: #FFFF00;
background-color: #666666;
}
td.top_site {
font-weight: bold;
font-size: 7pt;
border: none;
padding: 2px;
text-align: left;
color: yellow;
}
td.tabel_top {
height: 35px;
font-weight: bold;
font-size: 9pt;
border: none;
padding: 4px;
text-align: left;
color: #000066;
/*background-image: url(pic/site/table_top.gif);*/
}
table.site {
background-color: #303030;
background-image: url(pic/site/table_top.gif);
border: 0;
border-color: #FFFFFF;
}
And thats all - like any mod ensure you check the security out .. thats your responsibility to do so -- oops - i'll post the gifs in an hour or two :whistle:
|