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.

[Chadi]

Had already tried that also, but did not work

<tr>
<td class="alt2" align="center"><a href="helpcenter.php?$session[sessionurl]do=ticket&tid=$ticket1[ticketid]">$ticketid</a></td>
        <td class="alt2" align="left"><b>$ticket1[tickettitle]</b> ($ticket1[department])</td>
<td class="alt2" align="center">$priority</td>
<td class="alt2" align="center"><a href="member.php?$session[sessionurl]u=$ticket1[ownerid]">$ticket1[ownerusername]</a></td>
        
        <td class="alt2" align="center">$ticket1[datelogged]</td>
        <td class="alt2" align="center"><phrase 1="$ticket1[datelastupdate]" 2="$ticket1[lastreplyusername]" 3="$ticket1[lastreplyuserid]"
>$vbphrase[last_update_by]</phrase></td>
</tr>

[PaulSonny]

Ah, just identified the problem, and thanks for bringing this to my attention.

Go to hcenter_message and change the colspan from 5, to 7.

Thanks, Paul.

[Chadi]

Thanks, that worked

[Goomzee]

it;s not workinh for me it's show permission error

[ahayat]

Originally Posted by PaulSonny

Thanks for nominating us. If tickets are posted into a forum upon ticket creation and someone replies to the ticket then the reply is added to that original thread created.

If you reply to the thread and not the actual ticket, then im afraid it doesnt update the ticket at present.

Thanks, Paul.

u wc, someone posted a ticket, That ticket went to a specific Forum, but when i replied to that ticket (not to thread) it didnt go to that Thread.
What should i do ?

[PaulSonny]

Originally Posted by Goomzee

it;s not workinh for me it's show permission error

If you read original post it tells, you need to update your Usergroup Permissions.

Originally Posted by ahayat

u wc, someone posted a ticket, That ticket went to a specific Forum, but when i replied to that ticket (not to thread) it didnt go to that Thread.
What should i do ?

Ah right, I will double check and make sure it is working and fix for next release if neccessary.

On another note, I go away on holiday today and will be away for 2 weeks, Jase2 will be offering support while im away but nothing is likely to be released until I return.

Thanks, Paul.

[joe1989]

Originally Posted by PaulSonny

Can you please tell us what the error is? Is it something like unknown column?

Thanks, Paul.

Paul, I receive a database error when I try to change usergroup permissions. Here's the error message I receive:

Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Administrators',
	`description` = '',
	`usertitle` = 'Administrator',
	`opentag` = '<span style=\"font-weight: bold; color: red;\">',
	`closetag` = '</span>',
	`passwordexpires` = '0',
	`passwordhistory` = '360',
	`forumpermissions` = '8388607',
	`genericpermissions` = '2113929151',
	`attachlimit` = '0',
	`pmquota` = '500',
	`pmpermissions` = '7',
	`pmsendmax` = '5',
	`calendarpermissions` = '63',
	`wolpermissions` = '31',
	`adminpermissions` = '3',
	`genericpermissions2` = '1',
	`genericoptions` = '55',
	`profilepicmaxwidth` = '100',
	`profilepicmaxheight` = '100',
	`profilepicmaxsize` = '65535',
	`avatarmaxwidth` = '80',
	`avatarmaxheight` = '80',
	`avatarmaxsize` = '20000',
	`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',
	`ugphelpcenter` = '8191',
	`mgc_cb_evo_permissions` = '0',
	`mgc_cb_evo_nbmsg_show` = '',
	`mgc_cb_evo_nbmsg_perday_show` = ''
WHERE usergroupid=6;

MySQL Error   : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number  : 1054
Request Date  : Thursday, June 12th 2008 @ 01:13:42 PM
Error Date    : Thursday, June 12th 2008 @ 01:13:42 PM
Script        : http://www.supportingteens.net/forum....php?do=update
Referrer      : http://www.supportingteens.net/forum...&usergroupid=6
IP Address    : 66.97.118.166
Username      : Joe
Classname     : vB_Database
MySQL Version : 5.0.27

[Jase2]

Not from our product you don't.

MySQL Error : Unknown column 'mgc_cb_evo_permissions'

I think that is from the MGC Chatbox Evo: https://vborg.vbsupport.ru/showthrea...hlight=chatbox

[joe1989]

Originally Posted by Jase2

Not from our product you don't.

MySQL Error : Unknown column 'mgc_cb_evo_permissions'

I think that is from the MGC Chatbox Evo: https://vborg.vbsupport.ru/showt...hlight=chatbox

Well i don't even have the chatbox installed anymore. I removed that a while ago. How can I remove it from the permissions?

[Jase2]

Please ask in that chatbox thread. But, you will need to remove the bitfield which is located in: /includes/xml