PS - HelpCenter

[PaulSonny]

HelpCenter is the ultimate ticket support system for your vBulletin!

Click Here for vBulletin 3.6 Version (https://vborg.vbsupport.ru/showthread.php?t=176968)

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 (http://www.paulsonny.com/forum/helpcenter.php)

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 (http://www.paulsonny.com/forum/project.php?projectid=1).

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 (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=176367) 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.

[Lizard King]

Your demo page requires registration.

[John3971]

I was the first one to download this at the forum :)

Its a great modification.

[ChampTyler]

Hey there,

I will be testing this on my forum now - Thanks for this!

[Jase2]

Already confirmed a few bugs. Were working for an updated release. Please continue to report all bugs. :)

[auctionguy]

This is badly needed I think! I am going to wait until it is tested a bit because I am running 3.7 RC3 on a live board as it is but I can't wait to use this mod!

Excellent!

[TTG]

Demo database error .. obviously needs a little work 'eh !?
Think I'll wait for a stable release :D

[Jase2]

I aren't getting a database error. However, a few bugs have been fixed and we could see 'beta' 2 pretty soon.

[PaulSonny]

Released Beta 2.

Loads of fixes done, many thanks to John9371.

Keep them coming, bug reports, feature request, comments?

Thanks, Paul.

[PoetJA-1975]

Um - the demo link is not working...
Do you have screenshots? ALSO - can work on vB 3.6.8 PL2?

Thanx,

Jacquii.

[PaulSonny]

Um - the demo link is not working...
Do you have screenshots? ALSO - can work on vB 3.6.8 PL2?

Thanx,

Jacquii.

Sorry about the demo link, i've just been editing a template. Anyway its working now.

I am just in the middle of taking screenshots.

With regards to vBulletin 3.6.8 PL2, I believe it should work, although I have not tested.

Thanks, Paul.

[PaulSonny]

Screenshots Added.

Thanks, Paul.

[rob30UK]

paul, please dont require people to register to see the demo.... either make the demo public or post up screenshots - either one will make for a much more received mod and more downloads.

[rob30UK]

lol,you just posted as i did. thanks for the screenshots

[rob30UK]

Actually... where are the screenshots?

[PaulSonny]

They should be in the original modification post rob.

Thanks, Paul.

[rob30UK]

got them, cheers

edit: nice mod.... looks useful ;)

[DarkSorrowz]

Parse error: syntax error, unexpected $end in /home/tibiabid/wareznova/helpcenter.php on line 358

Helpp!! I uploaded everything.

[Stromba]

Parse error: syntax error, unexpected $end in /home/fxxxxx/public_html/forum/helpcenter.php on line 358

Same error here run the latest version Vb

[youradhere4222]

Are you planning on removing the requirement to register to view the demo?

[jerx]

Very useful mod!

Do you have to register to submit a ticket? Is it possible to let guests submit tickets and requiring them to input capture and email address (twice, to avoid typos). Some people might have problems with registration, so allowing guests to submit tickets would be helpful.

Thank you!

[PaulSonny]

Are you planning on removing the requirement to register to view the demo?

Sorry about the requirement to register, I have removed it and it should be ok now.

Thanks, Paul.

[Hornstar]

There IS a bLANK Option....

as the description of this thread says:

THIS IS BETA SOFTWARE.
WE STRONGLY RECOMMEND YOU DON'T INSTALL THIS ON A LIVE BOARD.


I suggest you just wait until it goes more stable

[PaulSonny]

There IS a bLANK Option....

Have sorted this error, it was a typo error with regards to a phrase.

Thanks, Paul.

[Subah]

Cool i like it , Thanks :)

[PaulSonny]

Updated the Download to fix the Department Database error when creating more than one department.

Thanks, Paul.

[PaulSonny]

Now fixed Bosco, sorry about that I forgot to update the product file, can happen when someone is sending 10 messages on msn a second.

Thanks, Paul.

[Paradigm]

This is exactly what I have been looking for. I will be watching the development of this one VERY closely. Great job and good luck in exterminating the bugs.

[PaulSonny]

Right, Bosco Wong if you give me chance to sort things out instead of bombarding me with MSN Messages I might be able to get a working product rather than error after error.

I have once again, updated the download, so please download and re-install.

Thanks, Paul.

[KURTZ]

Paul just wondering is possible to redirect a ticket to a different user which isn't an Admin?

[PaulSonny]

I dont understand what you mean Kurtz, do you mean can other users reply to tickets rather just admin usergroup?

Under usergroup options you are able to define who can manage tickets, if allowed, any usergroup can manage tickets.

Thanks, Paul.

[powerful_rogue]

Hi,

Thank you for this mod! Its a lifesaver! Up until now ive been using a shabby 3rd party script.

One problem ive got is I cant see the text in the Navigation or Administration section. Ive attached a screenshot.

Which template will I need to edit to change this?

Many Thanks

[PaulSonny]

The template is HCENTER_SHELL, I believe it is something to do with the style you are using.

Might just be a case of changing the id field of the links.

Thanks, Paul.

[powerful_rogue]

Thanks for the quick reply.

Im looking in the template but a bit stuck! Which part of the template refers to the css of the text colour in the navigation/Admin section

Thanks

[PaulSonny]

I am just guessing here because I cant replicate the bug, but in the HCENTER_SHELL template find class="$navclass[mytickets]" and remove it and see if the link appears?

Only do it for one link and test it, then you can update the rest if it works.

Thanks, Paul.

[powerful_rogue]

I am just guessing here because I cant replicate the bug, but in the HCENTER_SHELL template find class="$navclass[mytickets]" and remove it and see if the link appears?

Only do it for one link and test it, then you can update the rest if it works.

Thanks, Paul.

Thank you :)

I gave that a try but it didnt work. I did however change $navclass[mytickets] to vbmenu_option and it now shows up a treat :)

[PaulSonny]

Ok thanks for the reply powerful_rogue. I will update the templates now to avoid any future issues with other installations.

Edit: Updated for Next Release.

Thanks, Paul.

[KURTZ]

I dont understand what you mean Kurtz, do you mean can other users reply to tickets rather just admin usergroup?

Under usergroup options you are able to define who can manage tickets, if allowed, any usergroup can manage tickets.

Thanks, Paul.

i mean exactly this :)

anyway Paul, is possible to improve this hack with the possibility to give at a specific user(s) which can manage the tickets?

[PaulSonny]

Bosco Wong, if you read announcements and notifications, not all features are working, such as notifications.

Kurtz, I will try and work on a solution.

Thanks, Paul.

[KURTZ]

thanks mate :)

[mkinnov8]

Paul...

Thank you so much :), this helps a lot.

Cheers

[John3971]

i wOULD lIKE tO Add feature Close Ticket Open Ticket

Ticket Numbers

Auto Pm About Your Ticket

Automatic Ticket On The Thread Forum

Close Ticket and Open Tickets is already implented. but the names are Resolved and Unresolved

[PaulSonny]

I have added Ticket Number to the 'My Tickets' page, available in the next release.

Thanks, Paul.

[PaulSonny]

I have sorted out the Automatic New Thread Upon New Ticket feature and will be available in the next release.

Thanks, Paul.

[powerful_rogue]

Hi Paul.

the new additions sound great. When do you reckon the next release will be?

[Jase2]

Hello powerful_rogue,

At this moment in time, we cannot predict when a new 'beta' will be released. It depends on how many bug reports we receive ect. So, if you have a test board, please test and report any bugs you may find at: www.paulsonny.com

[fragumz.com]

Hello powerful_rogue,

At this moment in time, we cannot predict when a new 'beta' will be released. It depends on how many bug reports we receive ect. So, if you have a test board, please test and report any bugs you may find at: www.paulsonny.com

Jesse, Im going to be helping you guys out with this easy project here. I just got my vB Board back and my hours at work worked out so I can continue creating mods, styles and shell out some vBSupport. Check my profile for the web link.

[fragumz.com]

Check out the latest release here and grabe the beta 2 version. http://www.paulsonny.com/forum/showthread.php?p=68#post68

[Jase2]

fragumz.com, who is that directed too? Me I presume?

[Jase2]

I am aware that the notification option isn't working. As I said, it will be fixed for next release. In the meantime, hold tight why we fix current bugs, and report any new bugs if found. :)

[thunder_sti]

Does it work for: vb3.6.x ?

[Jase2]

It's made for 3.7, however it may work with 3.6 -- not counting on it. The best thing you can do, is try it on a test board running 3.6 and report back and let us know the outcome. :)

[PaulSonny]

Hi Paul.

the new additions sound great. When do you reckon the next release will be?

I have just updated the download to include these new features, feel free to test them out.

What the Update For This Now????

Ticket number Or Sort Thread???

Why Is There One HelpCenter Rar In The Folder Of uplaod What IS tHAT??? fOR

I really wish you would be patient, and as Jason said, stop posting post after post about the same thing. To avoid confusion, I have removed the secondary helpcenter file for you.

Does it work for: vb3.6.x ?

There is no real reason why this modification should not work with 3.6, although it has not been tested. Feel free to test and report back.

Thanks, Paul.

[DDolphins]

Really nice addon, my only request is if there's a way to do it, can you add an attachment area so people can attach a file or something to go along with their ticket?

[Jase2]

Really nice addon, my only request is if there's a way to do it, can you add an attachment area so people can attach a file or something to go along with their ticket?

I like that idea. Me and Paul will look into it.

EDIT: Although this will probably be in the 'paid' version, and not the 'lite' (free) version. :)

[RC Attacker]

I haven't had a chance to find any bugs yet but this is definitely one of my favorite hacks of all time.

[John3971]

Yea this is a great mod even if its a beta i nominated it for the mod of the month :)

[SuperDave71]

Is there a way to edit the Title of the ticket to be empty instead of "Social Groups"?

Every time I create a new ticket, the title automatically defaults to Social Groups.

Excellent Mod!

-Dave

[PaulSonny]

I haven't had a chance to find any bugs yet but this is definitely one of my favorite hacks of all time.

Thanks RC Attacker, further developments are already being made. For example we have updated it to use the vBulletin editor. (WYSIWYG).

Yea this is a great mod even if its a beta i nominated it for the mod of the month :)

Thanks John, very much appreciated.

Is there a way to edit the Title of the ticket to be empty instead of "Social Groups"?

Every time I create a new ticket, the title automatically defaults to Social Groups.

Excellent Mod!

-Dave

I cant replicate this error/bug. What actually happens, can you product a screenshot?

Thanks, Paul.

[fragumz.com]

fragumz.com, who is that directed too? Me I presume?
Yea sorry I spelled your name wrong fro mthe previous thread. But it was for you yes. :):rolleyes:

[SuperDave71]

Here is my screen Shot.

All I did was add the plug-in and add the appropriate permissions. When I click the Add ticket button...I get the title "Social Group" in the title field by default.

I just deleted the install and reinstalled it and got the same thing.

Hope this helps.

-Dave

[PaulSonny]

Ok SuperDave,

I am releasing a 3rd beta tomorrow, which includes loads of updates and some major bug fixes.

Once I release the beta, if this problem still occurs, I will try my best to find it.

Thanks, Paul.

[ZomgStuff]

I ran into problems running into changing usergroup permissions.
It looks like your install code did not run properly as I had to create the proper tables/columns manually.
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/usergroup.php?do=update
Referrer : http://www.xxxxx.net/forum/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : xxxxxx
Username : Hasselhoff
Classname : vB_Database
MySQL Version : 5.0.45-community-log

[PoetJA-1975]

You Did Not get WhAT I Mean What is the updated Folder What have paul Updated Is It Ticket Numbers Or New Automatic Thread And tHE Notificitaion System Not Working It Doesent Send Email Or Pm...

Oh GODDAMN! Please stop getting on everyone's LAST nerve = ERG!
ALSO - can you please stop the capitalization of each word in the sentence - This is so horridly annoying!

Jacquii.

[SuperDave71]

Thank you Paul....


I really appreciate it!



-Dave :)

[ZomgStuff]

Also the department display order does not work - it does not matter what you use, the system is still in alphabetical order.

[ZomgStuff]

Ticket number also isn't displaying in"my tickets" which is throwing off the entire row.

[ZomgStuff]

To fix the ticket display problem change your hcenter_ticket template to
<tr>
<td class="$bgcolor" align="center">$ticket[ticketid]</td>
<td class="$bgclass" align="left"><a href="helpcenter.php?$session[sessionurl]do=ticket&tid=$ticket[ticketid]">$ticket[title]</a></td>
<td class="$bgclass" align="center">$ticket[postusername]</td>
<td class="$bgclass" align="center">$ticket[dateline]</td>
<td class="$bgclass" align="center"><phrase 1="$ticket[lastupdate]" 2="$ticket[lastposter]">$vbphrase[last_update_by]</phrase></td>
</tr>

[ZomgStuff]

Users cannot see resolved tickets via "my tickets"

I get a SQL error when I try to delete a ticket and when i try to edit a ticket reply.

[ZomgStuff]

This is extremely buggy...

You need to force a title, because at this point you can create a ticket without one.
You should display what departtment a ticket is under "unresolved tickets"
Make unresolved tickets and resolved tickets viewable to the public so you don't have a bunch of duplicates.

[jerx]

Erm What the Feature Not Working And What the featured On this Updates Someone Tell Me Pls????

Hey, what' s wrong with you? Can' t you read? I know English is not your native tongue, but I am sure you have understood that everyone told you to stop spamming in this thread. It is freaking annoying. This is beta software and you should not use it on a live site. Therefore there is no need to rush things, especially not by posting every 3 minutes, private messaging other users and even contacting the developer on msn! This is just rude of you.

I have never ever ignored any user on any site till now, but I am about to use it to stop seeing your annoying posts.

You can see the latest version of this mod here:
http://www.paulsonny.com/forum/helpcenter.php

There you can test drive the mod and see what features the mod has. If you find any bugs on the development demo, you can post them in this thread, so that they can be fixed.

I advise you not to install this mod on your site yet. There seem to be too many bugs and you make the impression of being too inexperienced to handle it. Let more experienced users bug test on their own sites until this mod is classified as stable.

[Jase2]

As the desciption says, this is beta software. Unfortunately it will be buggy. However, we working as fast as we can to fix the bugs. Were releasing beta 3 later this evening, which fixes a lot of bugs reported, and some new features -- such as the WYSIWYG editor. Please remember, we cannot add every feature, since there will be a paid version, with more features. ;)

On the dev board, we haven't run into any problems with beta 3 -- however, as you and I both know, bugs can just popup. I suggest you all wait for beta 3 later this evening.

[Jase2]

This is extremely buggy...


You need to force a title, because at this point you can create a ticket without one.
You should display what departtment a ticket is under "unresolved tickets"
Make unresolved tickets and resolved tickets viewable to the public so you don't have a bunch of duplicates.

Were working to fix that ;)

[mat64]

This looks very interesting, I will be interested in watching this grow :).

[youradhere4222]

I wish a moderator would do something about Bosco - it's getting beyond ridiculous.

[DarkSorrowz]

Is beta 3 coming out this evening, because I mean its nearly 7pm.... Im pretty sure its this evening.

[Jase2]

DarkSorrowz, it has now been decided that it will be released tomorrow. There are just a few more things we need to do. However, I have no doubt that you're going to like beta 3 ;)

[Jase2]

Bosco, read my post above. I said it has been decided to be released tomorrow. It seems you are just posting for posts sake.

[DarkSorrowz]

Atleast release a beta 2.5, You don't know how bad I need this thing to work.. Come on!

[John3971]

DarkSorrowz they can´t just release a beta 2.5 because we have worked on beta 3 and it will be released today and its just a beta and should not be used on live sites.

[ZomgStuff]

I can help you develop this if you want, I think this is a great idea.

[Jase2]

Unfortunately, we are not looking for any developers at this moment in time.

[Marco van Herwaarden]

Thread cleaned.

[Jase2]

Thanks, Marco!

[lstintxs100]

I am looking forward to seeing where this goes.

I clicked install to be updated on your progress. This seems like what my members have been asking for in the next update.

good job so far.

[PaulSonny]

Thanks Marco, it is very much appreciated by me and i'm pretty sure many others.

Good news, Beta 3 has been released and the original post has been modified.

I must ask that for this release you uninstall any previous installations and do a clean install with this release. The reason being that this version has had a total database restructure.

Thanks, Paul.

[Jase2]

Please continue to report bugs over at: www.paulsonny.com

Thanks!

[GoTTi]

UGHHHHHHHHHH ITS ABOUT DAMN TIME SOME1 MADE A SUPPORT MOD!!!!

/me is happy now

[PaulSonny]

UGHHHHHHHHHH ITS ABOUT DAMN TIME SOME1 MADE A SUPPORT MOD!!!!

* GoTTi is happy now

Glad your happy bud, I hope you like it.

Thanks, Paul.

[GoTTi]

im about to check it out now. i am VERY excited about this, cuz i have asked OVER and OVER and OVER again for some1 to please make this since the 1 fell off in the 3.0 days, i dont remember which one it was, but we havent had one in a while that works with the forum....my goal is to have my users use a ticket system instead of posting problems with the site in threads in my problem forum...so ya im diggin this one. hoping it works the way i would like it to :)

if i think of ideas, be ready cuz i might come up with a sh!tstorm of em to add onto this thing.

[PaulSonny]

Thats what I like to here GoTTi, although we would appreciate it if you could please post any features requests or bug reports at PaulSonny, makes it easier for us to manage.

Thanks, Paul.

[GoTTi]

aww its easier for us as vb.org users to post problems with mods here. damn it :)

[GoTTi]

problem i see. when i post a reply to a ticket created as admin, i am getting wrap codes from the quick reply...

<P>closing ticket</P>

looks like that in the message.

please add in your readme file that the user needs to set usergroup permissions for using the help center per usergroup.

idea:

when logged in as admin, and we goto the main helpcenter.php page, we can see some tables/information if there are new tickets or ones being worked on, instead of having to click on Closed/Open tickets, it will auto be displayed to us on that page and inside the admincp pages

ok i am making some post on your bug tracker page :)

[Jase2]

problem i see. when i post a reply to a ticket created as admin, i am getting wrap codes from the quick reply...

<P>closing ticket</P>

looks like that in the message.

I cannot reproduce that. Please could you attach a screenshot?

please add in your readme file that the user needs to set usergroup permissions for using the help center per usergroup.

I'll add that in now.

when logged in as admin, and we goto the main helpcenter.php page, we can see some tables/information if there are new tickets or ones being worked on, instead of having to click on Closed/Open tickets, it will auto be displayed to us on that page and inside the admincp pages

Don't see the point in that. You only need to click either "Open Tickets" or "Closed Tickets" -- it really isn't that hard. :)

[GoTTi]

ya but u know how lazy us admins area :) we want everything as simple as possible, and the less clicks, the better.

[SuperDave71]

Thanks for all your had work. I just updated a fresh install and I am STILL getting the "Social Groups" in the title field by default when I create (add) a ticket.

I know you can find the issue. I appreciate this mod and hope we can get this resolved soon.

Take care and thanks again,

Dave

[Jase2]

Hi SuperDave,

I cannot reproduce that. Did you uninstall the previous product, before importing the new one?

[djlotus]

Thanks for all your hard work on this Mod. This hack will be a great add to my board. No longer do I need to answer quesions posted all over my board, I can use this feature. Many thanks for this, and future releases. I look forward to installing tomorrow, and helping to test for you.

INSTALLED

[JVSP]

Thanks for the great mod.

Also as for that Bisco wing kid, thanks for cleaning up the thread of his posts.....he does the same thing on vbulletin.com :mad:

[Jase2]

Thanks guys. The quicker you guys report bugs; the quicker we can release a 'stable' (gold) version. Please do check our bug tracker here (http://www.paulsonny.com/forum/project.php) before posting any bugs. It would be better if you could report bugs in our bug tracker, too.

[SuperDave71]

Hey Jase2,

Thank you for the response. Yes, I did an overwrite of the files and uninstalled the old and installed the new. Do you have any other reccomendations?

I will be happy to try them if you do. Thank you so much. I know this is got to be something easy to remedy.

Take care,

Dave

[Jase2]

Very strange. Not happening here.

Any chance you can set me an account at your board with admin privileges so that I can take a look? Other that, I can't suggest much more...

[SuperDave71]

Jase2,


This is what is conflicting with the title field. The reason I know this is I just added a new announcement with this product and it was called "Articles". Now the title field defaults to "Articles" instead of "Social Groups".


Just thought it might help with my issue.


Thanks in advance,


Dave



https://vborg.vbsupport.ru/showthread.php?t=172773&highlight=SmnLikQuick <---the plug in that is conflicts.

[Jase2]

Yes, that seems to be the issue. Me and paul will have to take a look at that hack, and see why it is conflicting. Thanks for reporting it.

[SuperDave71]

Thanks Jase!

I appreciate it!

-Dave

[PoetJA-1975]

Thanx so much PAULSONNY for this HelpCenter modification - Once it becomes stable it will be a winner no doubt! As others have stated - this has been very much need for a while! I certainly look forward to a gold version and will like to say thank you so much for you hard work and thanx to those who are beta testing to make this the best modification introduced on vB.org since the NoSpam! and/or Living Avatars modificaton!

Excellent work GUYS = Keep it up ;)

Jacquii.

[Jase2]

Thanks PoetJA-1975! That is a really nice comment, and makes the effort more worthwhile. :)

I'm sure Paul will be just as happy as I'm feeling right now :)

[macc]

hello!

i just installed your hack...very useful and thanks!

have two problem ... can not delete ticket (seen not that possibility), and when will write new ticket comes in title some like that "<b>NOVI SADRZAJI LIBRA</b>" (in every new ticket) "novi sadrzaji libra" is name of one of my forums (threads)??

have vbulletin 3.7 rc-3

some help or solutins?

regards

macc

[PaulSonny]

Thanx so much PAULSONNY for this HelpCenter modification - Once it becomes stable it will be a winner no doubt! As others have stated - this has been very much need for a while! I certainly look forward to a gold version and will like to say thank you so much for you hard work and thanx to those who are beta testing to make this the best modification introduced on vB.org since the NoSpam! and/or Living Avatars modificaton!

Excellent work GUYS = Keep it up ;)

Jacquii.

I agree with Jason, comments like these definately make it worth while and are very much appreciated. Thanks Jacquii.

hello!

i just installed your hack...very useful and thanks!

have two problem ... can not delete ticket (seen not that possibility), and when will write new ticket comes in title some like that "<b>NOVI SADRZAJI LIBRA</b>" (in every new ticket) "novi sadrzaji libra" is name of one of my forums (threads)??

have vbulletin 3.7 rc-3

some help or solutins?

regards

macc

Sorry Macc, im afraid I dont understand. With regards to cannot delete a ticket, are you sure you have set the correct Usergroup Permissions?

With regards to the second problem, are you able to produce a screenshot so we can identify the problem?

Thanks, Paul.

[macc]

link to my page www.belaplay.com/vb/libar (http://www.belaplay.com/vb/libar)

you can come ... to my page ... i will give you admin premissions... no problem ..


reg

macc

edit: now guests have prem. to use help desk ... you can use bosss username and pass you can read on chat

have upload picture

[PaulSonny]

From that screenshot it looks as though you are trying to make the title bold and the title field is not set to accept text formatting.

Thanks, Paul.

[macc]

that is problem ...that comes automaticly <b> and notice name "novi sadrzaji libra"... i did not do anything ... just come up in title box? can you explane how to delete tickets?


reg

macc

edit: now guest have possibility make tickets and full premisions ... just try... please..

macc

[PaulSonny]

ok I will look into that.

With regards to deleting a ticket, if you have set the usergroup permissions correctly then when you view a ticket, under the Ticket Options menu, select Delete Ticket.

Thanks, Paul.

[macc]

i set all premisions to yes ... for guests and admins ... you can use my another admin nik - bosss and will write pass on evo chat ... please ...

reg

macc

[Jase2]

Mac, you need to set the permissions in your ACP:

ACP --> Usergroups --> Usergroup Manager --> Your usergroup (GO) --> HelpCenter Usergroup Permissions

If that doesn't work, try re-uploading all files (overwriting the ones on your sever already) and re-importing the product. Just uninstall the product you have in, before re-importing.

If it's still the same, then you may have a conflicting hack/mod. Therefore, I would like you to disable the plugin/hook system, and see if the problem persists. Edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

Do you still have the same problem?

[Jase2]

Hi Mac,

I see you have this hack installed: https://vborg.vbsupport.ru/showthread.php?t=172773&highlight=SmnLikQuick

There is a compatibility issue, and we are working to fix this.

Thank you for your patience.

[macc]

yes from this hack comes in title box name of notice with bold codes ... and i can not see delete options in helpcenter ...


regards

macc

[futureye]

I use it in my 3-7 RC2
but it didn't show me the option of departments

[King Kovifor]

Hi Mac,

I see you have this hack installed: https://vborg.vbsupport.ru/showthread.php?t=172773&highlight=SmnLikQuick

There is a compatibility issue, and we are working to fix this.

Thank you for your patience.

What does the hack do that conflicts with this mod? I might be able to help fix it in the next release.

[macc]

that is some conflict..because i get in title box for helpcenter - bolded name of one of names in notices from another hack ... and can not delete tickets ...come not up in menu -delete !


reg

macc

www.belaplay.com/vb/libar (http://www.belaplay.com/vb/libar)

[Jase2]

What does the hack do that conflicts with this mod? I might be able to help fix it in the next release.

Hi King Kovifor,

It seems when you're using that hack, and go for a create a ticket in HelpCenter, it gives the title of whatever you did last with that hack. At least that is what has been reported.

[JVSP]

Any way to attach an image in a ticket, just in case a member wants to post an image of a problem?

[Jase2]

fxlr8, the attachment feature will be included into the paid' version.

[macc]

Jase2 have you some tips for my problem or i will wait next realese?

regards

macc

[PaulSonny]

Macc, I am currently working on a solution now.

Once I have one, I will add an updated version to this thread, but please try and be patient.

Thanks, Paul.

[macc]

Thanks ...no problem ... will wait!

regards

macc

[PaulSonny]

SuperDave and Macc, I have added an updated version for you to try and see whether this fixes your error.

I have no idea at the moment why this error is being caused and I have taken a total stab in the dark in the hope that it will sort it out.

Anyway, I ask that everyone else downloads the original helpcenter file and not the files meant for SuperDave and Macc.

Let me know how you guys get on please so I can update the original helpcenter release.

Thanks, Paul.

[macc]

hello!

just upload new files and product file but now get database error when should submit new ticket! in title box is ok ... no text and no bold codes!

Database error in vBulletin 3.7.0 Release Candidate 3:
Invalid SQL:
INSERT INTO vb_helpcenter_ticket(departmentid, tickettitle, message, priority, ownerid, ownerusername, lastreplyusername, lastreplyuserid, datelogged, datelastupdate, ipaddress) VALUES ('0','test','test test test','3','1','Admin','Admin','1','1208720898','12 08720898','81.235.161.10');
MySQL Error : Unknown column 'tickettitle' in 'field list'
Error Number : 1054
Date : Sunday, April 20th 2008 @ 03:48:18 PM
Script : http://belaplay.com/vb/libar/helpcenter.php
Referrer : http://belaplay.com/vb/libar/helpcenter.php?do=newticket
IP Address :Username : Admin
Classname : vB_Database
MySQL Version : 4.1.22-standard

reg
maccc

and thanks for your works

edit: no possibility to delete ticket!

[PaulSonny]

Macc I have just received your PM and logged into your website with the details given and was able to see the Delete Link from the Drop down menu Ticket Options.

With regards to the above error, I will sort it out now, it seems I have used invalida SQL syntax for changing one of the DB structures.

Thanks, Paul.

[PaulSonny]

Macc, Sorry about that, I have updated the download and would appreciate it if you could please re-download it and install it.

To make sure it works, please uninstall any previous versions and do a clean install.

Thanks, Paul.

[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.

[Jase2]

Thank you very much, Dave. It's the comments like that, that put a smile on my face! :)

[PaulSonny]

Update

Just to let everyone know, I have just released Beta 4. We have predicted this to be the final Beta, although it is not set in stone.

Thanks, Paul.

[PoetJA-1975]

Wow! I've been following this thread - getting a little excited ((blush))
Great work YAWL - I'm looking forward to installing this ;)

Jacquii.

[ZomgStuff]

Do you guys mind if I edit this modification a bit on my board? I shall keep it to myself and not distribute it.

[SuperDave71]

I certainly appreciate your hard work. I just had a quick question.

On the notification options, Where are those set? ( Meaning Who to notify ) If it isn't available yet, just say the word. I don't mean to be a bother.

Thanks in advance!

-Dave

[Jase2]

Do you guys mind if I edit this modification a bit on my board? I shall keep it to myself and not distribute it.

You are free to modify the code. However, we cannot support modified code. Once HelpCenter lite goes 'stable', we will open a hacks/mods forum -- where members can post their modfications for HelpCenter. :)

[Jase2]

I certainly appreciate your hard work. I just had a quick question.

On the notification options, Where are those set? ( Meaning Who to notify ) If it isn't available yet, just say the word. I don't mean to be a bother.


Thanks in advance!


-Dave

That is for the admin. The paid version will have a notification system for users; similar to vBulletin's.

[macc]

Hello!

just one questions .. should i update helcenter hack or not, because it shows me that is update possible?

just overwrite files or unistall first if i need or can update?(mean conflict with another hack before)
regards and thanks again

macc

[KURTZ]

Jason/Paul, when the final release is planned?

[futureye]

Database error in vBulletin 3.7.0 Release Candidate 3:

Invalid SQL:
SELECT * FROM helpcenter_ticket WHERE ticketstatus=1;

MySQL Error : Unknown column 'ticketstatus' in 'where clause'
Error Number : 1054
Date : Monday, April 21st 2008 @ 11:42:32 AM
Script : http://www.surcity.net/forums/Muap/helpcenter_admin.php?do=openticketmanage
Referrer : http://www.surcity.net/forums/admincp/index.php?do=nav
MySQL Version : 4.1.22-standard-

[Jase2]

Jason/Paul, when the final release is planned?

At this moment in time, we do not know. We will however make an announcement at paulsonny.com when we predict to release a 'stable', gold release.

[Jase2]

Database error in vBulletin 3.7.0 Release Candidate 3:

Invalid SQL:
SELECT * FROM helpcenter_ticket WHERE ticketstatus=1;

MySQL Error : Unknown column 'ticketstatus' in 'where clause'
Error Number : 1054
Date : Monday, April 21st 2008 @ 11:42:32 AM
Script : http://www.surcity.net/forums/Muap/helpcenter_admin.php?do=openticketmanage
Referrer : http://www.surcity.net/forums/admincp/index.php?do=nav
MySQL Version : 4.1.22-standard-

I'm afraid this isn't much help too me. What are the steps to reproduce this error?

[macc]

Just one question more .. why is message box for guest users so small? can we make this message box biger ? that is relplay message box - guest user

will attach picture

reg

macc

[JVSP]

When viewing the ticket reply window in IE I notice that the reply window is not fully open. In firefox it is fine.

http://i85.photobucket.com/albums/k46/FXLR8/Hcreply.jpg



Edit:::: didnt even see that someone just posted the same question..hehe

[Jase2]

Hi Macc,

It definitely isn't that small on our dev board. Do you have ads down FORUMHOME? Is your forums width shortened in anyway?

[macc]

no adds in forumhome ...and can just say that in firefox is ok (just what fxlr8 wrote before...)mean message box.. but in IE is so small!

edit: have IE 7 and windows vista SP1

regards

macc

[Jase2]

Please provide me a link to your HelpCenter installation.

[SuperDave71]

Hey Guys..

I created a test ticket and I was never notified that there was a ticket.

I set the admin to email and PM. Am I doing something wrong? I just want to make sure it's not on my end. I so love this mod!

Thanks Guys!

-Dave

[macc]

you can visit link www.belaplay.com/vb/libar (http://www.belaplay.com/vb/libar)


and like guest you can replay and see ...

installation link? what you mean with that? you can come and use admin account ... you know password and username!

reg

macc

[Jase2]

Hey Guys..


I created a test ticket and I was never notified that there was a ticket.


I set the admin to email and PM. Am I doing something wrong? I just want to make sure it's not on my end. I so love this mod!


Thanks Guys!



-Dave

I'm pretty sure Paul fixed that. He may have not, however. I'll have a word with him.

[Jase2]

Macc, by a link to your HelpCenter installation, I just meant a link to where HelpCenter is installed on your website :)

I have however confirmed the small text box in Internet Explorer 7. Will see what's wrong.

[macc]

ok ... www.belaplay.com/vb/libar/helpcenter (http://www.belaplay.com/vb/libar/helpcenter) is link (libar is my board)


reg macc

[DssCrazy]

Nice work i love this mod. 1 problem i found thow! i am using explorer as my browser and the ticket reply box is REALLY small can it be fixed this happend on your site when i tested the demo.

Here is the screen shot.

[DssCrazy]

Also for the paid version how much will it be? and what futures will it have that the free version does not have?

Thanks

[SuperDave71]

Thanks Jase...

I have NOT upgraded to the Updated one yet.

I knew you had Macc and me with a separate download so I was afraid I would mess up what you already fixed.

Let me know if it is ok to install the NEWEST one..

Thank you so much!

-Dave

[Jase2]

Also for the paid version how much will it be? and what futures will it have that the free version does not have?

Thanks

We haven't decided a price, yet. Once we release a 'stable', gold release of the lite version, we will get to work on the paid version. I have to balance my developing at the moment (other hacks and the paulsonny.com website), but HelpCenter paid version has my full priority.

We have decided some features, such as: Attachments, flagging to other department or person, ect. I think we will have some beta testers for it, however it will be encoded to stop functioning at a certain date.

[macc]

superdave i ask same before...i have not updated yet ..have "our" version...

reg

macc

[Jase2]

Thanks Jase...


I have NOT upgraded to the Updated one yet.

I knew you had Macc and me with a separate download so I was afraid I would mess up what you already fixed.


Let me know if it is ok to install the NEWEST one..


Thank you so much!



-Dave

Dave, please upgrade to the latest version - currently beta 4. This should fix your current problem.

[Jase2]

Nice work i love this mod. 1 problem i found thow! i am using explorer as my browser and the ticket reply box is REALLY small can it be fixed this happend on your site when i tested the demo.

Here is the screen shot.

Yes, this happens in Internet Explorer 7 for guests. We will see what can be done to correct this.

[macc]

i updated and now is replay message box ok (was before update also ok.. maybe jase2 done something ...!

regards and thanks for all help!

have nominated yesterday

macc

[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

[Jase2]

But that was fixed in beta 3. I may sound like I'm repeating myself, but are you uninstalling the old .xml and not doing an overwrite? This simply isn't happening for me; although I don't have the time to go over the product - as I've got too go.

[King Kovifor]

Hi King Kovifor,

It seems when you're using that hack, and go for a create a ticket in HelpCenter, it gives the title of whatever you did last with that hack. At least that is what has been reported.

Hm... That is definitely an odd conflict. Do you have any more details? Code, tables... etc.

[DssCrazy]

well i will repeat what i did. i tried both version beta3 and beta4 and uploaded all files to ftp and imported xml. i am not overwriting xml over xml i uninstall old and place new.

[Jase2]

Hm... That is definitely an odd conflict. Do you have any more details? Code, tables... etc.

Hi King,

This has now been corrected. Seems we were using the same fieldname. Thanks for showing an interest in helping us, though :)

[Jase2]

Is anyone else running beta 4 having the same problem has DssCrazy? We will then know whether it is user error, or a problem in the code :)

[ZomgStuff]

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

[DssCrazy]

ZomgStuff i seen that you were having the saem problem as i. can you please share with me how you fixed the problem?

Thanks buddy

[ZomgStuff]

ZomgStuff i seen that you were having the saem problem as i. can you please share with me how you fixed the problem?

Thanks buddy

Run the install queries located in the xml by hand via phpmyadmin.

[DssCrazy]

Run the install queries located in the xml by hand via phpmyadmin.You lost me lol

[abrecher]

This is a great mod! I really needed this since my forums have been growing. I can't wait until you have a stable version out.

[Jase2]

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]

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]

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]

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]

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

[Jase2]

Below, I have attached the updated helpcenter.php file. No changes, just added protection for the Cross Site Request Forgery (CSRF) -- recent security risk in vBulletin.

[IanW-GC8]

Thanks for that Jase :)

[PoetJA-1975]

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.

WONDERFUL!

Thanx so much PAUL, as I don't think I'll be upgrading to 3.7 anytime soon - we have waaaaay to many customizations on JPiC Forum to even consider it at the moment it goes gold - BUT at the same time - could really use the Help Center - so thanx for the 3.6.x version ;)

Jacquii.

[DubaiHost]

And now .. it's the best .. ;)
thank's for the great Mod.
Sure it's Installed .. :)

[Jase2]

Please report any bugs you find so we can make HelpCenter as bug free as possible! :)

[reifegerste]

Hi,

i have installed 3.7.0 RC4 and i get the following error:

Your submission could not be processed because a security token was missing or mismatched.

If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error.

Can anyone help me, please? Sorry my english is not so good :/

[Jase2]

Ok, try the following product file. Remember to uninstall your previous product file, before installing this one. Let me know how it goes.

[reifegerste]

Ahhh!!! great it works perfectly!

[Jase2]

That's great! I'll get Paul renew the product file.

[pow6713]

Ok, try the following product file. Remember to uninstall your previous product file, before installing this one. Let me know how it goes.


:up::up:
great thanks

[DubaiHost]

There is something wrong ..

all the words written in the support ticket apears in one line ..
( I mean when you write your post and press Enter ) ..

Exp :

Usual .. the result of ( Blah ,, Enter key ,, Blah ) :
Blah
Blah

But in the support system , the result of ( Blah ,, Enter key ,, Blah ) :
Blah Blah

Hope that this problem can be support ..

[PaulSonny]

I have updated the download to include Jason's latest product file, thanks Jason.

DubaiHost, I will try and replicate the bug now, if I am able to, I will try and find a solution.

Thanks, Paul.

Edit: I have just tried to re-create the problem and everything was ok, it displayed as it should, basically if you press the Enter key it display on the next line as it should.

Thanks, Paul.

[DubaiHost]

Edit: I have just tried to re-create the problem and everything was ok, it displayed as it should, basically if you press the Enter key it display on the next line as it should.
Thanks, Paul.

hmmm .. maybe because im using a toolbox ,
can you please allow users in your forum to submit tickets .. so i can try there .

and on which version you made your test , because im working on RC4 now .. and i uploaded the file posted by Jase2 ..

thanks in advance for your support .. :)

[PaulSonny]

Updated settings on PaulSonny so you should not be able to create a ticket.

Thanks, Paul.

[DubaiHost]

It's the same ..
check this ticket .. http://www.paulsonny.com/forum/helpcenter.php?do=ticket&tid=2
you will find all the words in the same line ..

[PaulSonny]

I dont understand, i've just edited one of the replies to that ticket above and pressed enter and hit save and its saved correctly.

I will ask Jason to see what he thinks. Is anybody else having this problem?

Thanks, Paul.

[DubaiHost]

I dont understand, i've just edited one of the replies to that ticket above and pressed enter and hit save and its saved correctly.

I will ask Jason to see what he thinks. Is anybody else having this problem?

Thanks, Paul.

Actually ,, i did the same thing but not with the same way .. i used the phpmyadmin , and it gave me a good result ..

so i think the problem is from the copy of helpcenter.php that i got .

Thanks for everything Paul.

[PaulSonny]

Try overwriting your existing helpcenter.php file with the one I have.

Thanks, Paul.

[DubaiHost]

Try overwriting your existing helpcenter.php file with the one I have.

Thanks, Paul.

I did, it's with the same result ,, nothing new ..

[PaulSonny]

very strange in deed.

Like I said, will see what Jason thinks.

Thanks, Paul.

[Jase2]

Hello,

I can confirm this. I noticed this a few betas back, but couldn't understand why the text wasn't formating correctly. If you make a space, it automatically puts the text onto the same line. Trying to find a fix for this in the next release.

[DubaiHost]

very strange in deed.

Like I said, will see what Jason thinks.

Thanks, Paul.

Hello,

I can confirm this. I noticed this a few betas back, but couldn't understand why the text wasn't formating correctly. If you make a space, it automatically puts the text onto the same line. Trying to find a fix for this in the next release.

Ok ,, then i will wait for the new release.
Even if it couldn't fixed, you did a great job with this Mod.
Really thanks for it and for the great support ..

thanks again.
IT TECH

[bahisyeri]

Dude its cool but if you can add attachment support it will be best...
PS: If you can add support for can not reply to closed tickets too.

[Jase2]

bahisyeri, the attachment feature will be included into the paid' version. :)

[bahisyeri]

bahisyeri, the attachment feature will be included into the paid' version. :)

Ah ok ty, i updated my reply:), btw how can we buy that pro/paid version and do we allowed to write our own addons for this free version?

[Jase2]

Paul is setting up the members area, where you will be able to download our software. Once HelpCenter goes gold, we'll start work on the 'paid version. Also, we will open a hacks/modfications forum, where members can submit their hacks/mods for HelpCenter. However, we will not be able to support modified code, in the event something goes wrong.

[sbarbz]

Database error in vBulletin 3.6.10:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'מנהלי אתר',
`description` = '<b>מנהל ומייסד האתר</b>',
`usertitle` = '<b>מנהל ומייסד האתר !</b>',
`opentag` = '<b><font color=\"#ff9933\">',
`closetag` = '</b></font>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`creditpermissions` = '628',
`credit_induction` = '21',
`credit_referral` = '0',
`credit_refbonus` = '0',
`credit_paycheck` = '0',
`credit_active` = '0',
`credit_birthday` = '0',
`credit_repgive` = '0',
`credit_reputation` = '0',
`credit_infraction` = '0',
`credit_thread` = '4',
`credit_threadrate` = '0',
`credit_post` = '0',
`credit_ownthreadpost` = '0',
`credit_postsize` = '0',
`credit_ownthreadview` = '0',
`credit_ownthreadrate` = '0',
`credit_ownthreadreply` = '0',
`credit_ownprofileview` = '0',
`credit_pollmake` = '0',
`credit_pollvote` = '0',
`credit_attachment` = '0',
`credit_sendpm` = '0',
`credit_addevent` = '0',
`credit_addprofpic` = '0',
`credit_profile` = '0',
`credit_donmaxuser` = '-1',
`credit_pastotpost` = '-1',
`credit_pastotuser` = '-1',
`credit_pasawuser` = '-1',
`credit_pasawthread` = '-1',
`credit_saveint` = '0.2',
`credit_maxsave` = '-1',
`credit_loanint` = '0.2',
`credit_maxloan` = '100',
`credit_totloan` = '5000',
`credit_goodgroup` = '0',
`credit_midgroup` = '0',
`credit_badgroup` = '0',
`credit_maxtickets` = '0',
`credit_lotdiscount` = '0',
`ugphelpcenter` = '1',
`forumpermissions` = '1048575',
`genericpermissions` = '503840447',
`solvedthreadpermissions` = '1',
`attachlimit` = '0',
`pmquota` = '65535',
`pmpermissions` = '7',
`pmsendmax` = '65535',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericoptions` = '55',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '100',
`avatarmaxheight` = '100',
`avatarmaxsize` = '20000',
`signaturepermissions` = '245759',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`awspermissions` = '15'
WHERE usergroupid=6;

MySQL Error : Unknown column 'ugphelpcenter' in 'field list'
Error Number : 1054
Date : Saturday, April 26th 2008 @ 08:35:33 PM
Script : http://****.co.il/admincp/usergroup.php?do=update
Referrer : http://****.co.il/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : ***
Username : ***
Classname : vb_database
in two Version

[PaulSonny]

It seems you are trying to use the package above on a vBulletin 3.6 Installation, when it is meant for 3.7.

I may suggest uninstalling and reinstalling with the 3.6 version.

Thanks, Paul.

[PaulSonny]

Beta 5 Released. We hope this to be the last beta.

With regards to the guests being able to view other guests ticket, I have made it so that it depends on IP address for the time being until I can come up with a more long term solution.

Thanks, Paul.

[powerful_rogue]

Hi,

I reuploaded all the new files, uinstalled the previous helpdesk and then imported the new one - however it looks like this :confused:

[Boosted Panda]

Same issue here as Powerful_Rogue

[PaulSonny]

Seems when I started another project I wasnt as careful as I thought I was and it mucked up a lot of phrases. (Transferred them to another product) Meaning the phrases did not export within the product.

Anyway, I'm not entirely sure whether I have caught all the phrases, so if anyone would be willing to try this product and tell if any further phrases are still missing and I will do my best to get everything back to normal.

I appreciate your patience.

Thanks, Paul.

[IR15H]

Thanks, that seems to have fixed most of them, but I found a couple;

ADMIN CP > HelpCenter> Department Management > Add New Department/Edit > Update returns Can not find phrase helpcenter_acp_redirect. It still works fine though.

Additionally, ADMIN CP > Usergroups > Usergroups manager > Edit user Group X

Can Manage Tickets
*BLANK*
Can Close Any Ticket

EDIT:

Also, when adding a new ticket, there is no Priority before the : Low/Medium/High.


EDIT 2:

I also now get a db error when I try to create a new ticket. it says the table helpcenter_department doesn't exist, it does. I have prefixes on my tables, so maybe that's causing the issue. Also, when I deleted all my departments, there is still a blank drop down box when adding a new ticket

[mikexxx]

vBulletin Options > [Also a blank line in the menu]

[PaulSonny]

Further update, try this one guys and let me know.

With regards to the DB error, remove previous version and import this as fresh.

Thanks, Paul.

[IR15H]

The phrases are fixed, but the DB error is still occurring for me.

I uninstalled the old product and checked the tables were dropped, they were. I installed the new product and the tables are back, but it still comes up saying it doesn't exist. The table it says doesn't exist, doesn't exist, as it doesn't have the prefix I've assigned it (it's databasename.helpcenter_department instead of databasename.prefix_helpcenter_department). If anyone else with table prefixes could post saying if they're getting errors too, or even if it's working for them that would help.

[PaulSonny]

Is it possible for me to test on your website?

Thanks, Paul.

[Hostboard]

Fresh install and was surprised to find everything is disaray. Read through and see there were some small complications. Will wait until things are back in sorts.

Thanx for a great modification.

[PaulSonny]

I have updated the original download to include the latest product file to fix a few errors I made.

With regards to your problem Irish, I have uninstall and re-install the HelpCenter product on PaulSonny.com and it worked without any Database Errors so i'm wondering if its something your doing. Can you provide me with a link?

Thanks, Paul.

[Hostboard]

In ACP > HelpCenter Main Settings I do not see any options to set up any departments. Maybe some place else?

NM see there is also a Help Center in the left menu. Can you possibly make all the configuration options in 1 location?

[Hostboard]

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

[mikexxx]

Further update, try this one guys and let me know.

With regards to the DB error, remove previous version and import this as fresh.

Thanks, Paul.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

[GoTTi]

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.

[GoTTi]

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.

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

[PaulSonny]

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.

[GoTTi]

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

[PaulSonny]

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

Thanks, Paul.

[IR15H]

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;
$departmenttitle = $vbulletin->db->query_read("SELECT department FROM helpcenter_department WHERE departmentid = '" . intval($_REQUEST['departmentid']) . "'");

REPLACE WITH;
$departmenttitle = $vbulletin->db->query_read("SELECT department FROM " . TABLE_PREFIX . "helpcenter_department WHERE departmentid = '" . intval($_REQUEST['departmentid']) . "'");

...or just wait for Paul to update the zip :).

[PaulSonny]

Thanks Irish I have fixed this for the next release.

Thanks, Paul.

[MikeHolohan]

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;
$departmenttitle = $vbulletin->db->query_read("SELECT department FROM helpcenter_department WHERE departmentid = '" . intval($_REQUEST['departmentid']) . "'");

REPLACE WITH;
$departmenttitle = $vbulletin->db->query_read("SELECT department FROM " . TABLE_PREFIX . "helpcenter_department WHERE departmentid = '" . intval($_REQUEST['departmentid']) . "'");

...or just wait for Paul to update the zip :).

Well done, works well... Mike.