FEATURES:
- Easy ability to add new catagories (Via Ticket Admin Panel)
- Assign tickets to users (Via user id)
- It's better than the existing ticket system
INSTALLATION HOW TO:
1) Download this file & extract to sections/tickets (need to delete old files or rename to 'file.old'):
https://dl.getdropbox.com/u/274817/tickets.tar.gz
2) In sections/user/edit.php:
Locate the Following:
Code:
                        <tr>
                                <td class="label"><strong>Download torrents as text files</strong></td>
                                <td>
                                        <input type="checkbox" name="downloadalt" id="downloadalt" <? if ($LoggedUser['DownloadAlt']) { ?>checked="checked"<? } ?> />
                                        <label for="downloadalt">For users whose ISP block the downloading of torrent files</label>
                                </td>
                        </tr>
                        <tr class="colhead_dark">
And replace with:
Code:
                        <tr>
                                <td class="label"><strong>Download torrents as text files</strong></td>
                                <td>
                                        <input type="checkbox" name="downloadalt" id="downloadalt" <? if ($LoggedUser['DownloadAlt']) { ?>checked="checked"<? } ?> />
                                        <label for="downloadalt">For users whose ISP block the downloading of torrent files</label>
                                </td>
                        </tr>
                        <tr>
                                <td class="lable"><strong>Notify on ticket replies</strong></td>
                                <td>
                                        <input type="checkbox" name="ticket_notify" id="ticket_notify" <? if($LoggedUser['TicketNotify']) { ?> checked="checked"<? } ?> />
                                        <label for="ticket_notify">Receive a PM when someone replies to one of your tickets</label>
                                </td>
                        </tr>
                        <tr class="colhead_dark">
3) In sections/user/index.php
Locate the following:
Code:
                                $DownloadAlt = (isset($_POST['downloadalt']))? 1:0;
And replace with:
Code:
                                $DownloadAlt = (isset($_POST['downloadalt']))? 1:0;
                                $TicketNotify = (isset($_POST['ticket_notify']))? 1:0;
Locate the following:
Code:
                               $SQL="UPDATE users_main AS m JOIN users_info AS i ON m.ID=i.UserID SET
                                        i.StyleID='".db_string($_POST['stylesheet'])."',
                                        i.StyleURL='".db_string($_POST['styleurl'])."',
                                        i.Avatar='".db_string($_POST['avatar'])."',
                                        i.SiteOptions='".db_string(serialize($Options))."',
                                        i.Info='".db_string($_POST['info'])."',
                                        i.DownloadAlt='$DownloadAlt',
                                        m.Email='".db_string($_POST['email'])."',
                                        m.IRCKey='".db_string($_POST['irckey'])."',
                                        m.Paranoia='".db_string($_POST['paranoia'])."'";
And replace with:
Code:
                                $SQL="UPDATE users_main AS m JOIN users_info AS i ON m.ID=i.UserID SET
                                        i.StyleID='".db_string($_POST['stylesheet'])."',
                                        i.StyleURL='".db_string($_POST['styleurl'])."',
                                        i.Avatar='".db_string($_POST['avatar'])."',
                                        i.SiteOptions='".db_string(serialize($Options))."',
                                        i.Info='".db_string($_POST['info'])."',
                                        i.DownloadAlt='$DownloadAlt',
                                        i.TicketNotify='$TicketNotify',
                                        m.Email='".db_string($_POST['email'])."',
                                        m.IRCKey='".db_string($_POST['irckey'])."',
                                        m.Paranoia='".db_string($_POST['paranoia'])."'";
4) In design/privateheader.php
Locate the following:
Code:
        if(check_perms('site_resolve_tickets')) {
                // Number of unresolved tickets
                $NumNewTickets = $Cache->get_value('numnewtickets');
                if($NumNewTickets === false){
                        $DB->query('SELECT COUNT(ID) FROM tickets WHERE Status = \'New\' OR Status = \'Reopened\'');
                        list($NumNewTickets) = $DB->next_record();
                        // The cached value is reset every hour, or when someone checks up on a user
                        $Cache->cache_value('numnewtickets', $NumNewTickets, 3600);
                }
        }
?>              <div class="alertbar blend">
                        <a href="tools.php">ToolBox</a> |
                        <a href="reports.php"><?=$NumReports?> Report<?=($NumReports != 1) ? 's' : ''?></a> |
                        <a href="tickets.php?action=browse&st[]=0&st[]=1"><?=$NumNewTickets?> Ticket<?= ($NumNewTickets != 1) ? 's' : ''?></a> |
                        <a href="watchlist.php"><?=$NumWatchedUsers?> Watched</a>
                </div>
<? } ?>
And replace with:
Code:
        if(check_perms('tickets_status_change')) {
                // Number of unresolved tickets
                $NumNewTickets = $Cache->get_value('numnewtickets');
                if($NumNewTickets === false){
                        $DB->query('SELECT COUNT(ID) FROM tickets WHERE Status=0 OR Status=2');
                        list($NumNewTickets) = $DB->next_record();
                        // The cached value is reset every hour, or when someone checks up on a user
                        $Cache->cache_value('numnewtickets', $NumNewTickets, 3600);
                }
        }
?>              <div class="alertbar blend">
                        <a href="tools.php">ToolBox</a> |
                        <a href="reports.php"><?=$NumReports?> Report<?=($NumReports != 1) ? 's' : ''?></a> |
                        <a href="tickets.php?ticket_stats[]=0&ticket_stats[]=2"><?=$NumNewTickets?> Ticket<?= ($NumNewTickets != 1) ? 's' : ''?></a> |
                        <a href="watchlist.php"><?=$NumWatchedUsers?> Watched</a>
                </div>
<? } ?>
5) Execute the following mysql query (erases old ticket system):
Code:
DROP TABLE IF EXISTS `tickets`;
CREATE TABLE `tickets` (
  `ID` int(10) NOT NULL auto_increment,
  `AuthorID` int(10) NOT NULL,
  `Category` int(3) NOT NULL default '1',
  `AssignedID` int(10) default NULL,
  `Name` varchar(40) default NULL,
  `Date` datetime default NULL,
  `LatestActivity` datetime default NULL,
  `Body` mediumtext,
  `EditedUserID` int(10) default NULL,
  `EditedTime` datetime default NULL,
  `Status` int(3) NOT NULL,
  `StatusSetBy` int(10) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tickets_replies`;
CREATE TABLE `tickets_replies` (
  `ID` int(10) NOT NULL auto_increment,
  `TicketID` int(10) NOT NULL,
  `AuthorID` int(10) NOT NULL,
  `Body` mediumtext,
  `EditedUserID` int(10) default NULL,
  `EditedTime` datetime default NULL,
  `AddedTime` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `TicketID` (`TicketID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tickets_categories`;
CREATE TABLE `tickets_categories` (
  `ID` int(3) NOT NULL auto_increment,
  `Name` varchar(40) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO tickets_categories (Name) VALUES ('Site: Bugs');
6) In classes/permissions_form.php
Remove the following:
Code:
                                        <? display_perm('site_resolve_tickets','Can resolve support tickets'); ?>
                                        <? display_perm('site_tickets_admin','Can manage the tickets system'); ?>
Locate the following:
Code:
        <div class="permission_container">
                <table>
                        <tr>
                                <td class="colhead">Administrative</td>
                        </tr>
                        <tr>
                                <td>
                                        <? display_perm('admin_manage_news','Can manage news'); ?>
                                        <? display_perm('admin_manage_polls','Can manage polls'); ?>
                                        <? display_perm('admin_manage_forums','Can manage forums (add/edit/delete)'); ?>
                                        <? display_perm('admin_manage_fls','Can manage FLS'); ?>
                                        <? display_perm('admin_reports','Can access reports system'); ?>
                                        <? display_perm('admin_watched_users','Can access "watched users" system'); ?>
                                        <? display_perm('admin_advanced_user_search','Can access advanced user search'); ?>
                                        <? display_perm('admin_create_users','Can create users through an administrative form'); ?>
                                        <? display_perm('admin_search_duplicate_ip','Can search for duplicate IPs'); ?>
                                        <? display_perm('admin_donor_log','Can view the donor log'); ?>
                                        <? display_perm('admin_manage_ipbans','Can manage IP bans'); ?>
                                        <? display_perm('admin_dnu','Can manage do not upload list'); ?>
                                        <? display_perm('admin_clear_cache','Can clear cached pages'); ?>
                                        <? display_perm('admin_whitelist','Can manage the list of allowed clients.'); ?>
                                        <? display_perm('admin_manage_permissions','Can edit permission classes/user permissions.'); ?>
                                        <? display_perm('admin_schedule','Can run the site schedule.'); ?>
                                        <? display_perm('admin_login_watch','Can manage login watch.'); ?>
                                </td>
                        </tr>
                </table>
        </div>
        <div class="submit_container"><input type="submit" name="submit" value="Save Permission Class" /></div>
And replace with:
Code:
        <div class="permission_container">
                <table>
                        <tr>
                                <td class="colhead">Administrative</td>
                        </tr>
                        <tr>
                                <td>
                                        <? display_perm('admin_manage_news','Can manage news'); ?>
                                        <? display_perm('admin_manage_polls','Can manage polls'); ?>
                                        <? display_perm('admin_manage_forums','Can manage forums (add/edit/delete)'); ?>
                                        <? display_perm('admin_manage_fls','Can manage FLS'); ?>
                                        <? display_perm('admin_reports','Can access reports system'); ?>
                                        <? display_perm('admin_watched_users','Can access "watched users" system'); ?>
                                        <? display_perm('admin_advanced_user_search','Can access advanced user search'); ?>
                                        <? display_perm('admin_create_users','Can create users through an administrative form'); ?>
                                        <? display_perm('admin_search_duplicate_ip','Can search for duplicate IPs'); ?>
                                        <? display_perm('admin_donor_log','Can view the donor log'); ?>
                                        <? display_perm('admin_manage_ipbans','Can manage IP bans'); ?>
                                        <? display_perm('admin_dnu','Can manage do not upload list'); ?>
                                        <? display_perm('admin_clear_cache','Can clear cached pages'); ?>
                                        <? display_perm('admin_whitelist','Can manage the list of allowed clients.'); ?>
                                        <? display_perm('admin_manage_permissions','Can edit permission classes/user permissions.'); ?>
                                        <? display_perm('admin_schedule','Can run the site schedule.'); ?>
                                        <? display_perm('admin_login_watch','Can manage login watch.'); ?>
                                </td>
                        </tr>
                </table>
        </div>
        <div class="permission_container">
                <table>
                        <tr>
                                <td class="colhead">Tickets</td>
                        </tr>
                        <tr>
                                <td>
                                        <? display_perm('tickets_browse','Can browse tickets'); ?>
                                        <? display_perm('tickets_create','Can create new tickets'); ?>
                                        <? display_perm('tickets_reply','Can reply to tickets'); ?>
                                        <? display_perm('tickets_delete','Can delete tickets'); ?>
                                        <? display_perm('tickets_edit','Can edit tickets'); ?>
                                        <? display_perm('tickets_status_change','Can set ticket status'); ?>
                                        <? display_perm('tickets_admin','Can administor tickets'); ?>
                                </td>
                        </tr>
                </table>
        </div>
        <div class="submit_container"><input type="submit" name="submit" value="Save Permission Class" /></div>
7) In static/functions/forums.js
Add the following functions (Just add to the top of the document):
Code:
function showHidden(divid) {
        if(document.getElementById(divid).style.display == 'none') {
                document.getElementById(divid).style.display = '';
        }
}

function hideShown(divid) {
        if(document.getElementById(divid).style.display != 'none'){
                document.getElementById(divid).style.display = 'none';
        }
}
Locate the following:
Code:
function Quote(postid, username) {
        try {
                quote = new XMLHttpRequest();
        } catch(e) {
                quote = new ActiveXObject("Microsoft.XMLHTTP")
        };

        quote.onreadystatechange = function() {
                if (quote.readyState == 4 && quote.status == 200) {
                        $('quickpost').value = "[quote=" + username + "]" + quote.responseText + "[/quote]";
                }
        };

        if (location.href.match(/forums\.php/)) {
                quote.open("GET", "forums.php?action=get_post&post=" + postid, true);
        } else {
                quote.open("GET", "torrents.php?action=get_post&post=" + postid, true);
        }

        quote.send(null);
}
And replace with:
Code:
function Quote(postid, username) {
        try {
                quote = new XMLHttpRequest();
        } catch(e) {
                quote = new ActiveXObject("Microsoft.XMLHTTP")
        };

        quote.onreadystatechange = function() {
                if (quote.readyState == 4 && quote.status == 200) {
                        $('quickpost').value = "[quote=" + username + "]" + quote.responseText + "[/quote]";
                }
        };

        if (location.href.match(/forums\.php/)) {
                quote.open("GET", "forums.php?action=get_post&post=" + postid, true);
        } else if (location.href.match(/torrents\.php/)) {
                quote.open("GET", "torrents.php?action=get_post&post=" + postid, true);
        } else {
                quote.open("GET", "tickets.php?action=get_post&post=" + postid, true);
        }

        quote.send(null);
}
Locate the following:
Code:
function Edit_Form(postid) {
        if (location.href.match(/forums\.php/)) {
                pageUrl="forums";
                boxWidth="80";
        } else {
                pageUrl="torrents";
                boxWidth="50";
        }

        $('bar' + postid).cancel = $('content' + postid).innerHTML;
        $('content' + postid).innerHTML = "<div id=\"preview" + postid + "\"></div><form id=\"form" + postid + "\" method=\"post\"><input type=\"hidden\" name=\"post\" value=\"" + postid + "\" /><textarea id=\"editbox" + postid + "\" name=\"body\" cols=\""+boxWidth+"\" rows=\"10\"></textarea></form>";
        $('bar' + postid).innerHTML = "<input type=\"button\" value=\"Preview\" onclick=\"Preview_Edit(" + postid + ");\" /><input type=\"button\" value=\"Post\" onclick=\"Save_Edit(" + postid + ")\" /><input type=\"button\" value=\"Cancel\" onclick=\"Cancel_Edit(" + postid + ");\" />";
        try {
                editform = new XMLHttpRequest();
        } catch(e) {
                editform = new ActiveXObject("Microsoft.XMLHTTP")
        };

        editform.onreadystatechange = function() {
                if (editform.readyState == 4 && editform.status == 200) {
                        $('editbox' + postid).value = editform.responseText;
                }
        };

        editform.open("GET", pageUrl+".php?action=get_post&post=" + postid, true);
        editform.send(null);
}
And replace with:
Code:
function Edit_Form(postid) {
        if (location.href.match(/forums\.php/)) {
                pageUrl="forums";
                boxWidth="80";
        } else if (location.href.match(/forums\.php/)) {
                pageUrl="torrents";
                boxWidth="50";
        } else {
                pageUrl="tickets";
                boxWidth="50";
        }

        $('bar' + postid).cancel = $('content' + postid).innerHTML;
        $('content' + postid).innerHTML = "<div id=\"preview" + postid + "\"></div><form id=\"form" + postid + "\" method=\"post\"><input type=\"hidden\" name=\"post\" value=\"" + postid + "\" /><textarea id=\"editbox" + postid + "\" name=\"body\" cols=\""+boxWidth+"\" rows=\"10\"></textarea></form>";
        $('bar' + postid).innerHTML = "<input type=\"button\" value=\"Preview\" onclick=\"Preview_Edit(" + postid + ");\" /><input type=\"button\" value=\"Post\" onclick=\"Save_Edit(" + postid + ")\" /><input type=\"button\" value=\"Cancel\" onclick=\"Cancel_Edit(" + postid + ");\" />";
        try {
                editform = new XMLHttpRequest();
        } catch(e) {
                editform = new ActiveXObject("Microsoft.XMLHTTP")
        };

        editform.onreadystatechange = function() {
                if (editform.readyState == 4 && editform.status == 200) {
                        $('editbox' + postid).value = editform.responseText;
                }
        };

        editform.open("GET", pageUrl+".php?action=get_post&post=" + postid, true);
        editform.send(null);
}
Locate the following:
Code:
function Delete(postid,authkey) {
        if (confirm('Are you sure you wish to delete this post?') == true) {
                try {
                        delpost = new XMLHttpRequest();
                } catch(e) {
                        delpost = new ActiveXObject("Microsoft.XMLHTTP")
                };

                delpost.onreadystatechange = function() {
                        if (delpost.readyState == 4 && delpost.status == 200) {
                                $('post' + postid).style.display = "none";
                        }
                };

                if (location.href.match(/forums\.php/)) {
                        delpost.open("GET", "forums.php?action=delete&auth=" + authkey + "&postid=" + postid, true);
                } else {
                        delpost.open("GET", "torrents.php?action=delete_post&auth=" + authkey + "&postid=" + postid, true);
                }
                delpost.send(null);
        }
}
And replace with:
Code:
function Delete(postid,authkey) {
        if (confirm('Are you sure you wish to delete this post?') == true) {
                try {
                        delpost = new XMLHttpRequest();
                } catch(e) {
                        delpost = new ActiveXObject("Microsoft.XMLHTTP")
                };

                delpost.onreadystatechange = function() {
                        if (delpost.readyState == 4 && delpost.status == 200) {
                                $('post' + postid).style.display = "none";
                        }
                };

                if (location.href.match(/forums\.php/)) {
                        delpost.open("GET", "forums.php?action=delete&auth=" + authkey + "&postid=" + postid, true);
                } else if (location.href.match(/torrents\.php/)) {
                        delpost.open("GET", "torrents.php?action=delete_post&auth=" + authkey + "&postid=" + postid, true);
                } else {
                        delpost.open("GET", "tickets.php?action=delete_post&auth=" + authkey + "&postid=" + postid, true);
                }
                delpost.send(null);
        }
}
Locate the following:
Code:
function Save_Edit(postid) {
        $('bar' + postid).innerHTML = "";
        var parameters = serialize('form' + postid);
    try {
        post_sub= new XMLHttpRequest();
        post_sub.overrideMimeType('text/html');
    } catch(e) {
        post_sub = new ActiveXObject("Microsoft.XMLHTTP")
    }

        post_sub.onreadystatechange = function() {
            if (post_sub.readyState == 4 && post_sub.status == 200) {
                        $('content' + postid).innerHTML = post_sub.responseText;
                }
        };

        if (location.href.match(/forums\.php/)) {
                post_sub.open('POST', 'forums.php?action=takeedit', true);
        } else {
                post_sub.open('POST', 'torrents.php?action=takeedit_post', true);
        }
    post_sub.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
    post_sub.setRequestHeader("Content-length", parameters.length);
    post_sub.setRequestHeader("Connection", "close");
    post_sub.send(parameters);
}
And replace with:
Code:
function Save_Edit(postid) {
        $('bar' + postid).innerHTML = "";
        var parameters = serialize('form' + postid);
    try {
        post_sub= new XMLHttpRequest();
        post_sub.overrideMimeType('text/html');
    } catch(e) {
        post_sub = new ActiveXObject("Microsoft.XMLHTTP")
    }

        post_sub.onreadystatechange = function() {
            if (post_sub.readyState == 4 && post_sub.status == 200) {
                        $('content' + postid).innerHTML = post_sub.responseText;
                }
        };

        if (location.href.match(/forums\.php/)) {
                post_sub.open('POST', 'forums.php?action=takeedit', true);
        } else if (location.href.match(/torrents\.php/)) {
                post_sub.open('POST', 'torrents.php?action=takeedit_post', true);
        } else {
                post_sub.open('POST', 'tickets.php?action=takeedit_post', true);
        }

    post_sub.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
    post_sub.setRequestHeader("Content-length", parameters.length);
    post_sub.setRequestHeader("Connection", "close");
    post_sub.send(parameters);
}
8) Append to all of your stylesheets (static/styles/*/style.css):
Code:
        .tickets_search {
                width: 800px;
                margin-left: auto;
                margin-right: auto;
                font-size: 8pt;
        }
        
        .tickets_categories {
                float: left;
                text-align: left;
                padding: .5em;
        }
        
        .tickets_status {
                float: right;
                padding: 0.5em;
                text-align: left;
        }
        
        .small_label {
                width: 0%;
                text-align: right;
                font-weight: bold;
        }
        
        .filter_tickets {
                width:850px;
                margin-left:auto;
                margin-right:auto;
                margin-bottom:15px;
        }
        
        .filter_tickets .submit {
                text-align:right;
                padding-top:5px;
        }
9) Associate the approiate permissions for the ticket system (Via Toolbox > Managers > Permissions