Add-On Releases - PS - HelpCenter

HelpCenter is the ultimate ticket support system for your vBulletin!

Click Here for vBulletin 3.6 Version

HelpCenter is a support ticket system made for vBulletin. It allows you to manage your members questions much easier, saving you the hassle of going through emails and private messages.

Visit PaulSonny for news, demos, screenshots, and more!

Demo: PaulSonny HelpCenter

Features

If you have any feature requests please make them known at PaulSonny.

* Automatic Template Edits
* Turn HelpCenter ON/OFF and display a custom message.
* Disallow New Tickets to be created and display a custom message.
* Give your Ticket ID's a Prefix.
* Auto Open closed tickets when a new reply is made. (Now an Admin Option)
* Add, Edit and Delete departments via AdminCP, view Tickets within a Department.
* Open/Closed ticket AdminCP Management.
* Make tickets public/private.
* Ticket Priorities. (Low/Medium/High)
* WOL: HelpCenter.
* View Statistics about HelpCenter in the AdminCP.

Installation Instructions

[] Upload all the files from the Upload folder.
[] Import product-helpcenter.xml via the AdminCP.
[] Set Permissions for each usergroup via the AdminCP for HelpCenter.
[] Set Departments up via the AdminCP for HelpCenter.

Footnotes

Please report all bugs, feature requests and comments here.

Version History:

Version 1.00 Beta 1:

Initial version for vBulletin 3.7.

Version 1.00 Beta 2:

Bug Fixes.

Version 1.00 Beta 3:

Database Errors Fixed.
Added Extra Usergroup Permissions.
Ticket Priority Added.
Ticket Number Prefix Added.
Plus Much More...

Version 1.00 Beta 4:

Added Some extra Admin Features.
Fixed some bugs.
Other small features added.

Version 1.00 Beta 4 Security Fix

Cross Site Request Forgery (CSRF) Fixed.

Version 1.00 Beta 5:

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.

Version 1.00 Beta 6:

Make tickets public/private.
Tidied up Admin Interface.
Fixed Phrases.
Tidied Up the Code.
It now parses smilies in your tickets. so you get !
Other small features added.

Version 1.00 Release Candidate 1:

Fixed SQL Vunerabilities
Fixed Phrases.
Tidied Up the Code.
Implemented Delete Confirmation Screens.
Improved CSRF Security.

Version 1.00:

Can View HelpCenter Permission Added.
Updated Delete Confirmations.
Fixed No Title Error.
Tidied Up the Code.

Version 1.01:

Minor Template Change for Version.
Standard Editor Error Fixed.
Improved Code Structure for Editors.

Please remember to click Mark As Installed if you use this modification.
If you use this plug-in, and find it useful, please support us by nominating us for Mod Of The Month (MOTM) in the top right corner of this thread, or feel free to donate.

You will get an email when a new version is released.

Thanks, PaulSonny & The Development Team.

[DssCrazy]

Problem found!

When i tried to edit the usergroups to make the ticket system work i got an error

this happend with beta 4

Thanks

[Jase2]

DssCrazy, what error? I don't get any errors when editing the usergroups. I suggest you try re-installing.

[DssCrazy]

This error

Database error in vBulletin 3.7.0 Release Candidate 3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<font color=\"#DF7E4E\">',
`closetag` = '</font>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`ugphelpcenter` = '1983',
`forumpermissions` = '8380415',
`genericpermissions` = '2147483583',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '55',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '120',
`avatarmaxheight` = '120',
`avatarmaxsize` = '40000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '31',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '511',
`mgc_cb_evo_permissions` = '255',
`mgc_cb_evo_nbmsg_show` = '0',
`mgc_cb_evo_nbmsg_perday_show` = '0',
`mgc_cb_evo_default_color` = '000000'
WHERE usergroupid=6;

MySQL Error : Unknown column 'ugphelpcenter' in 'field list'
Error Number : 1054
Date : Thursday, April 17th 2008 @ 07:26:07 PM
Script : http://www.xxxxxx.net/forum/admincp/....php?do=update
Referrer : http://www.xxxxx.net/forum/admincp/u...&usergroupid=6
IP Address : xxxxxx
Username : Hasselhoff
Classname : vB_Database
MySQL Version : 5.0.45-community-log

[Jase2]

DssCrazy, that was fixed in beta 3. Are you uninstalling the .xml product, then re-importing it, as overwriting will not work? If you still receive this error; download the package at our website and see if it corrects your problem: http://www.paulsonny.com/forum/showthread.php?p=172

[DssCrazy]

just tirend downloading from here and over at your site still get the saem error. i am doing everything right

[DssCrazy]

Here is the xml file i am using

[DssCrazy]

Do you think you will beable to fix this today so i can giver a try?

Thanks

[DssCrazy]

i also tried beta 3 and did the same thing

[Jase2]

Hi DSSCrazy,

I have to go soon; so Paul will be with you shortly. I still cannot reproduce that error.

Try the attached product. Remember to uninstall your previous one, before importing this. Although I don't think it will work, as they should both be the same. Are re-upload all files (overwriting the ones on your server) ?

[DssCrazy]

Here is what i did. i uploaded all files to ftp and inported the xml then when i go to set usergroup rights i get that error