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.

[Jase2]

Originally Posted by ZomgStuff

Are the majority of the bugs worked out? Is it safe on a live site?

Most bugs have been fixed. Although there are still one or two things we need to do, as well as to fix a few bugs. I don't recommend having this installed on a production site; you can if you want, but we cannot be held responsible for problems that may arise. I suggest you wait for a 'stable', gold release, or at the very least a release candidate.

[PaulSonny]

Sorry about not replying sooner guys, I have had some problems with my ISP.

DSSCrazy, can you please confirm you are running vBulletin 3.7? Just the install code for HelpCenter relies on a fieldname only available in 3.7.

If you are running 3.7, then can you please confirm that before you import the product, you have already uninstalled the previous installation, and have not just overwritten the product, if you are still having trouble after this, send me a PM with your msn address and I will try my best to help.

As it says in the original post, for Beta 4 to function properly, you have to uninstall any previous versions and re-install Beta 4, almost like a new installation.

Macc & Superdave, I would recommend upgrading to the latest version. The seperate files I created for you both were to just confirm it worked before I went ahead and edited the original code. After you confirmed it work I went ahead and updated the original code and fixed/added one or two extra things so I would recommend upgrading.

With regards to the notification system via the Admin CP, that is still yet to be implemented, working on it in the next release. I originally planned to put it in sooner but time got away from me.

With regards to the paid version, features, prices and such things nothing has been decided, once information is available, I shall let you know.

Thanks everyone for your kind comments and supporting this product, Paul.

[regitbull]

Im getting this error to and it seems like ZomgStuff said the mod diddint add a table and that makes the error.

I think thoose 2 querys are the problem of the error:
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `ugphelpcenter` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `socialgrouppermissions`");
and
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "usergroup` DROP `ugphelpcenter`");

I cant find that ugphelpcenter in my usergroup table so i think thats the problem.
And if you check the error log then it says this:
MySQL Error : Unknown column 'ugphelpcenter' in 'field list'


So i think thats the whole problem.
Well i dont know much about mysql so could you guys post the manual query commands so we can manual add thoose querys because i dont know how to run thoose querys

Thanks and i hope this will fix the problem for me,DssCrazy and any others who get or will get this error.


Edit:
Ok i fixt the problem my self and i think it will help you to DssCrazy.
Go to phpmyadmin and run this query:
ALTER TABLE `usergroup` ADD `ugphelpcenter` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `forumpermissions`

Now try to update the usergoups in the vbulletin admin panel again.
If its right then it will just update the info now without showing a error

[DssCrazy]

Originally Posted by PaulSonny

Sorry about not replying sooner guys, I have had some problems with my ISP.

DSSCrazy, can you please confirm you are running vBulletin 3.7? Just the install code for HelpCenter relies on a fieldname only available in 3.7.

If you are running 3.7, then can you please confirm that before you import the product, you have already uninstalled the previous installation, and have not just overwritten the product, if you are still having trouble after this, send me a PM with your msn address and I will try my best to help.

As it says in the original post, for Beta 4 to function properly, you have to uninstall any previous versions and re-install Beta 4, almost like a new installation.

Macc & Superdave, I would recommend upgrading to the latest version. The seperate files I created for you both were to just confirm it worked before I went ahead and edited the original code. After you confirmed it work I went ahead and updated the original code and fixed/added one or two extra things so I would recommend upgrading.

With regards to the notification system via the Admin CP, that is still yet to be implemented, working on it in the next release. I originally planned to put it in sooner but time got away from me.

With regards to the paid version, features, prices and such things nothing has been decided, once information is available, I shall let you know.

Thanks everyone for your kind comments and supporting this product, Paul.

I am doing all things right. here is what i am doing.

1 uploaded all files to ftp
2 installed xml did not overwright.
Running 3.6.8

[Tom_S]

Installed. Very nice but it has a lot of rough edges in it yet though.

[John3971]

Originally Posted by DssCrazy

I am doing all things right. here is what i am doing.

1 uploaded all files to ftp
2 installed xml did not overwright.
Running 3.6.8

Well like PaulSonny said you must use 3.7 to have this work like it should because this mod is made for vB 3.7

[regitbull]

Originally Posted by John3971

Well like PaulSonny said you must use 3.7 to have this work like it should because this mod is made for vB 3.7

Like i said in my other post i got the same error as him and im also running 3.6.8 level 2.
I run the query i posted and everything worked fine after that.

So its running perfect on a 3.6.8 level 2 forum.

[Jase2]

As Paul has already mentioned too you, the code relies on a fieldname that is only available in 3.7. This is in the 3.7 forum, so unless you're running 3.7 -- you shouldn't be using this.

[PaulSonny]

I have realised how to make this work on vBulletin 3.6 and will release it once I have a stable internet connection in the 3.6 mod forum.

Thanks, Paul.

[DssCrazy]

Originally Posted by PaulSonny

I have realised how to make this work on vBulletin 3.6 and will release it once I have a stable internet connection in the 3.6 mod forum.

Thanks, Paul.

Ok cool.

Thanks so much