Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > TBDev > Mods & Themes
Reply
  #1  
Old 15th October 2008, 11:46
Bigjoos's Avatar
Bigjoos Bigjoos is offline
U-232 Dev
 
Join Date: May 2008
United Kingdom
Posts: 244
Talking 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.. 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 $_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 $_POST['ticket'];
    print 
"<font size=3 color=lightblue>You have " $ticket " help ticket's to close.";
    print 
"<br><br>";
    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 $_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 $_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 $_POST['user_id'];
    
$ticket $_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 "<br>";

    
$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 
"<br>";
        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 
"<br><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><br>";
        }

    
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 $_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><br>";

    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><br>";
        }

    
$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 
"&nbsp;&nbsp;&nbsp;<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 "&nbsp;&nbsp;&nbsp;<font color=red>unread</font>";
                else
                    
$extra_text "&nbsp;&nbsp;&nbsp;<font color=red>read by " get_username($row['userid']) . "  " convertdate($row2['read_date']) . " </font>";
                print 
"<br>";
                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 
"&nbsp;&nbsp;&nbsp;<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%>&nbsp;</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><br>";
            }
        }
    
        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 
"<br>";
    
    print 
"</td></tr></table>";
    print 
"</td></table><br>";
    
    
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><br>";
    
$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><br><br>";
        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>&nbsp;&nbsp;&nbsp;");
// .stripslashes(substr($row['message'],0,100))
//print("<div id=\"ka".$row['id']."\" style=\"display: block;\"> 22".stripslashes($row['message'])." </div><br> ");
//print("<div id=\"ka".$row['id']."\" style=\"display: block;\"> 33".stripslashes($row['message'])." </div><br> ");

            
print htmlspecialchars(stripslashes(substr($row['message'],0,400))) . " -=>";
            print 
"</td>";
            print 
"<td class=test align=center>";
            print 
$reacties "&nbsp;&nbsp;<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 
"<br></td></tr></table>";
    print 
"</td></table><br>";
    
    
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><br>";
$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><br>";
            }
                                   
$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 
"&nbsp;&nbsp;&nbsp;<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 "&nbsp;&nbsp;&nbsp;<font color=red>Unread</font>";
                else
                    
$extra_text "&nbsp;&nbsp;&nbsp;<font color=red>viewed by " get_username($row['userid']) . "  " convertdate($row2['read_date']) . " </font>";
                print 
"<br>";
                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 
"&nbsp;&nbsp;&nbsp;<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%>&nbsp;</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><br>";
            }
        }
    }

    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 
"<br>";

print 
"</td></tr></table>";
print 
"</td></table><br>";

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><br>";
    print 
"<center><font size=2 color=$color><b>" $text "</b></font></center><br>";
    print 
"</td></tr></table>";
    print 
"</td></tr></table><br>";
    
stdfoot();
    die;
    }

function 
page_end()
    {
    print 
"</td></tr></table><br>\n";
    }

function 
table_end()
    {
    print 
"</td></tr></table><br>";
    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><br>");
    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>&nbsp;&nbsp;$msg</td>";
    else
        print 
"<td class=top_site><font size=3 color=white><div align=" $align ">&nbsp;&nbsp;$msg&nbsp;&nbsp;</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.<br />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

Last edited by Bigjoos; 16th October 2008 at 20:52. Reason: Secured the class checks on actions on Helpdesk.php - To be tested..
Reply With Quote
The Following 5 Users Say Thank You to Bigjoos For This Useful Post:
burnt2 (7th February 2012), d6bmg (21st March 2011), Fynnon (15th October 2008), Islander (18th October 2008), Tibys08 (29th May 2011)
  #2  
Old 15th October 2008, 13:13
wMan wMan is offline
Banned
 
Join Date: Feb 2008
P2P
Posts: 1,433
Thumbs up
kool bigjoos
Reply With Quote
  #3  
Old 15th October 2008, 14:11
Dragan3591's Avatar
Dragan3591 Dragan3591 is offline
Senior Member
 
Join Date: Oct 2008
United States
Posts: 168
Default
This is great mod!!
I'm redoing it for FTS if necessary!
__________________
CLICK HERE FOR IMPORTANT NEWS FROM BVLIST!!

"Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut."
Ernest Hemingway.

"A positive attitude will not solve all your problems, but it will annoy enough people to make it worth the effort."
Herm Albright.
Reply With Quote
  #4  
Old 15th October 2008, 15:41
wMan wMan is offline
Banned
 
Join Date: Feb 2008
P2P
Posts: 1,433
Default
wonder if helpdesk,bugs,and contactstaff be ok all together in 1

Code:
SQL Error

Table 'tehrootc_root.helpdesk' doesn't exist
in /home/tehrootc/public_html/helpesk.php, line 437

Last edited by wMan; 15th October 2008 at 17:47.
Reply With Quote
  #5  
Old 15th October 2008, 20:03
Bigjoos's Avatar
Bigjoos Bigjoos is offline
U-232 Dev
 
Join Date: May 2008
United Kingdom
Posts: 244
Default Combining 3 mods ?
Well putting three systems into one would get a tad messy to say the least .. Could it be done .. ? Hell yeah - its code so any code can be manipulated/edited restructed if you dont mind your head being busted in the process kidding well i wouldnt do it myself i like to keep things un-complicated as possible but if your brave and can handle heavy debugging sessions i would say go for it and try ! -- Your sql error is telling you the problem clock

Last edited by Bigjoos; 16th October 2008 at 12:26.
Reply With Quote
  #6  
Old 15th October 2008, 20:13
wMan wMan is offline
Banned
 
Join Date: Feb 2008
P2P
Posts: 1,433
Default
fixed doh!!!

hmm dont get this all i see is no description box nothing else??

Ticket overview

Old to new is from bottom to top..

## By Date Question Answers Open

Last edited by wMan; 15th October 2008 at 20:21.
Reply With Quote
  #7  
Old 15th October 2008, 22:38
Bigjoos's Avatar
Bigjoos Bigjoos is offline
U-232 Dev
 
Join Date: May 2008
United Kingdom
Posts: 244
Default LoL
Enter the helpdesk as a user then you can set a ticket...
Reply With Quote
  #8  
Old 18th October 2008, 10:01
Kotafi Kotafi is offline
Senior Member
 
Join Date: Jan 2008
Posts: 139
Red face cool
This is nice but im having fev problems tho :)

the big red box wont disappear even if i answer teh ticket and the edit button at helpdesk.php results just a white page, could u help me fix this?

and the pics are still missing :P
Reply With Quote
  #9  
Old 18th October 2008, 12:26
vertex vertex is offline
Senior Member
 
Join Date: Mar 2008
Posts: 46
Default
Add please screenshot!
Reply With Quote
  #10  
Old 18th October 2008, 15:52
Bigjoos's Avatar
Bigjoos Bigjoos is offline
U-232 Dev
 
Join Date: May 2008
United Kingdom
Posts: 244
Default ??
@hatchet - the tickets need to be closed before that notification goes - i mean you only need to look at the query where ticket =1 and closed = no ..... that explains it all - the white page on edit well not sure i'll look

@vertex - lmao yeah ok then i'll waste my time screenshoting a mod thats 2 files sql and a slight mod to stdhead - get a grip and install the bloody thing then you get the best screen shot ever
Reply With Quote
Reply

Tags
advanced , helpdesk , system , ticket

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Passkey System kovsza Mods & Themes 3 22nd May 2013 00:44
SYSTEM HELPER crowni Community Cafe 0 18th October 2009 08:26
Which operating system you use? kp380lv Community Cafe 19 12th October 2009 10:01
IP value ban system Muikku Template Shares 2 2nd July 2009 15:03
helpdesk wMan Community Cafe 5 10th February 2009 10:25



All times are GMT +2. The time now is 21:24. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.