Auto close after X amount of days of in activity as defined in the ACP? This would then generate a PM to the user...


Title: Your Support Ticket XXX is Now Closed
Body: AUTOMATED NOTICE: Your support ticket has been closed due to X days of inactivity. However, if you require any further assistance, please:

• Open a "link to new ticket", OR
• "Link to Re-open" your ticket.

Your Support Team:
Link to Profiles of Admin | Link to Profiles of Admin | And so on...

Links support team could also be a new user group "support team" or one defined in the ACP

Better ;)
In usergroep manger the name of the table is still missing.

And when i submit a new ticket i get a database error.

-----------------------

Database error in vBulletin 3.7.0 Release Candidate 4:

Invalid SQL:
INSERT INTO helpcenter_ticket(departmentid, tickettitle, message, priority, ownerid, ownerusername, lastreplyusername, lastreplyuserid, datelogged, datelastupdate, ipaddress, threadnum) VALUES ('1','test','test test test','3','1','Mike','Mike','1','1209449977','1209 449977','0.0.0.0','0');

MySQL Error : Unknown column 'threadnum' in 'field list'
Error Number : 1054
Request Date : Tuesday, April 29th 2008 @ 08:19:37 AM
Error Date : Tuesday, April 29th 2008 @ 08:19:38 AM
Script : http://www.xxxxxxxnl/helpcenter.php?do=newticket
Username : Mike
Classname : vB_Database
MySQL Version : 5.0.45-enterprise-gpl

i just upgraded to beta 5 due to a error, so i uninstalled and reinstalled the mod, and looking in the usergroup under admin, there is no title on the help center area of options, its blank. but the radio buttons and options are there.

i had this same error. i uninstalled the mod, and reinstalled it and the error is gone. i think if u upgrade to the current version you will get the error...

as far as the title bar in the usergroup missing, mine is missing also.

I will sort the HelpCenter table phrase when I get home, with regards to the "MySQL Error : Unknown column 'threadnum' in 'field list'" I think there is something wrong within the product file for altering the table.

I will update the product so that it creates the table with the new field name, but it may mean everyone has to uninstall and re-install to get it working correctly.

If anyone could have a look at the product file and check the SQL Query (version 0.5) then i'd be grateful.

Thanks, Paul.

paul that error is only duplicating itself on upgrade. i tested it on 2 forums. must uninstall and reinstall mod to not have errory.

ah right I understand now GoTTi and thanks for letting me know, I will fix the Usergroup phrase now.

Thanks, Paul.

I figured out the DB error. The problem occurred with reading the table, rather than creating it, so the problem wasn't in the product file. Once I realised that I stopped looking in the wrong place and had a quick look in helpcenter.php. I figured out the error, and managed to fix it myself :D. If anyone else has prefixes on their SQL tables then do the following in helpcenter.php

SEARCH FOR;
REPLACE WITH;
...or just wait for Paul to update the zip :).

Thanks Irish I have fixed this for the next release.

Thanks, Paul.

Well done, works well... Mike.

Thanks for the DB fix IR15H, and great Mod Paul!

My Helpcenter is now up and functional

What is the last update?

Further Enchanged Some Admin Functions.
Enhanced My Tickets Interface.
Paginated Results.
Fixed More bugs, such as Guest Tickets Problem. (Temporary Measure!)
Other small features added.

Kewl..thanks :)

Paul I have 1.0. Should I uninstall first or should I wait for your next update then uninstall and update? I think from what I read you already addressed all the 3.7.0 bug issues right?

A good suggestion / idea to this hack would be: Let the support Tickets goto a forum (so the mods and administrators) get notified. X (Forum ID) the tickets get placed in.

I strongly suggest uninstalling and updating to the latest version.

KeyStalker, this is already an implemented feature. You can define a Forum ID in the AdminCP settings.

Thanks, Paul.

Beta 6 Just Released!

This is going to be the final Beta for HelpCenter, from now it is just going to be bug fixes, if any.

I'm sorry, but for the final time, you are going to have to uninstall any previous version and re-install with Beta 6.

Thanks, Paul.

Reuploaded all files. Uninstall plugin, reinstall plugin. 2 problems...

1. HelpCenter Main settings appear under the left menu option "HelpCenter" as well as under VBulletin Options. Should it not be only in 1 place to avoid confusion?

2. Under HelpCenter Statistics Help Center Statistics Version is showing as 1.0 Beta 5

Is it possible to get an email when a ticket is submitted

Thanks, great mod.

Notifications are going to be a paid feature.

Thanks, Paul.

Screenshots have been updated.

Thanks, Paul.

paul can you update your main post, it says beta 6 is not released yet.

This looks as a great mod, even better then another alike mod I found here.
I've tagged it for now, but I'm sure I will install it when a stable release version is brought out.
My forums have a lot of mods and I can't have bugs at te moment or at least if possible.:)
But it already looks great!

Sorted, thanks GoTTi.

Paul.

Anyone else getting "Unknown column 'ticketview' in 'field list'" via the Database Error Script

I installed 1.5 and then re-installed 1.6.

Paul..I need to change font color Tickete ID. It dosen't show up the Ticket ID number on mine with my theme. I did that in the last version in the template but I can't find the one for this one. Or I'm blind..but that isn't new either LOL

the ticketview field is a new field in the ticket table, sounds like you havent uninstalled 1.5 before you installed 1.6.

I'm not entirely sure myself, ill have a good look later on today and find out for you and will send a PM and update my templates.

Thanks, Paul.

If you're talking about the "ABC1" Ticket ID on helpcenter home, then the colour is defined by your style's CSS. ADMIN CP > Styles & Templates > Style Manager > Main CSS > Body > Normal Links CSS/Visited Links CSS > Font Color.


EDIT: If you're talking about on an actual ticket, where it says Ticket ID: ABC1 then; ADMIN CP > Styles & Templates > Style Manager > Main CSS > Small Font > Font Color.

Is possible to use cache template??

Yes..the ABC1

Currently only 1 template is cached. I will cache the rest for the next release.

Thanks, Paul.

I was wondering, how do you set who post the thread when someone makes a support ticket?

What text could I insert under HelpCenter Main Settings for the Automatic Template edit if I wanted to include this within the quicklinks?

1 - When I go to helpcenter statistics it says its beta 5.

2 - Can I make the width of the navigation wider?

3 - When managing departments there is not a field for inserting a forumid. I would prefer to have it there rather than in the main settings.

I am using vb version 3.7.0 Gold
This is a fresh install done about an hour ago.

Suggestions:
1 - Replies made to the ticket should also post on the thread posted within the forum specified.
2 - A thread prefix should be created with the thread automatically. Should say Open/Closed or Open/Solved.
3 - An area for sensitive data should be submitted. When posted by the user this data should only be seen by the admin. This is very important. Some sites have online stores where issues with payment could arise...requiring credit card info. Many other examples too.

Footer credit reads beta 5 even when you have beta 6 installed.

Yes, sorry - seems that we forgot to update that. It will be fixed for next release.

Jase,
Will you consider the suggestions I made in my post earlier?

Also, How do I make the width of the navigation wider?

to make it wider edit the template named HCENTER_SHELL

I took a look at it and it says width=100%.

I don't see where I need to adjust it. I'd like to make it the same width as the navigation on usercp.

It's not a big deal, but I'd appreciate anyone's help with it.