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.

[macc]

Hello!

i reinstall and update with zip file for mac and dave and get this database error

Database error in vBulletin 3.7.0 Release Candidate 3:
Invalid SQL:
SELECT * FROM vb_helpcenter_ticket WHERE ownerid='1' ORDER BY datelastupdate DESC LIMIT 0,;
MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number  : 1064
Date          : Sunday, April 20th 2008 @ 05:01:08 PM
Script        : http://belaplay.com/vb/libar/helpcenter.php
Referrer      : http://belaplay.com/vb/libar/index.php
IP Address    : 
Username      : Admin
Classname     : vB_Database
MySQL Version : 4.1.22-standard

on the top error page is

Warning: Division by zero in [path]/includes/functions.php on line 2212

shoud i use another zip file ?

regards

macc

[PaulSonny]

I suggest you overwrite all files again because the actual files themselves havent had any SQL changed, just a field title.

Thanks, Paul.

[SuperDave71]

I get the exact same error when I did a clean install as well.


I just overwrote the old files myself and I still got this error.



"Warning: Division by zero in [path]/includes/functions.php on line 2212"


Database error in vBulletin 3.7.0 Release Candidate 3:

Invalid SQL:
SELECT * FROM helpcenter_ticket WHERE ownerid='1' ORDER BY datelastupdate DESC LIMIT 0,;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number : 1064
Date : Sunday, April 20th 2008 @ 02:05:13 PM
Script : http://www.thelovelogic.com/forum/helpcenter.php
MySQL Version : 5.0.45-log


Thank you for all your hard work...



-Dave

[macc]

i do that - overwrote files again and get same error !

used dave and mac zip file!

imported product again ..and error comes up (same error like before)

reg

macc

[PaulSonny]

Sorry about this guys, it was a mistake on my part.

Please try again.

Thanks, Paul.

[macc]

Uraaaaaaaaa works perfect !!!!!!

Thanks Thanks


regards

macc

edit: no errors ..have submited tickets ..works perfect!
thanks again
macc

[PaulSonny]

Thanks Macc, so I can assume that you no longer get the <b></b> tags around your title?

Thanks, Paul.

[macc]

Yes ... title box is clean ...no text and no codes!

works great- thanks for help

regards

macc

[SuperDave71]

PaulSonny and Jase2,

Mine works perfectly as well. You guys, THANK YOU SOOO MUCH for all your hard work. My forum, like so many out there, certainly needs this particular mod and I want to personally thank you both for your dedication in make this work Macc and I.

You guys have been nominated!

Sincerely,

Dave

[PaulSonny]

Thanks ever so much to both you guys for actually co-operating with us and allowing us to test this product for bugs and other issues.

I'm just glad you managed to both get this sorted and i'm sure Jason will agree with me, thank you for your kind words.

Thanks, Paul.