Nice hack ,

Need some help.
is there any way to change color of ´HelpCenter´ title in navbar.

Thanks

Yes.

Change:
To:

Ooops, just remembered we now have the automatic template edit hehe. You can use above if you made your own edit.

Thanks alot......

Fine Jase. Don't acuse people of being cocky after you have been a rather rude person to them and they didn't do anything but ask a valid question you took offense to and then give feedback about a support link being down that you evidently didn't like the manner it which it was given. That shows lack of customer service representation and it sure shows up front the type of support you intend on giving when the going gets tough later. I hate seeing a good mod/thread busted with junk like this so back off and allow me to participate in the manner I should have been afforded to start with minus your attitude kind sir.

Just to bring everyone into the picture. I have had problems with my hosting and it seems they have had their account suspended so I have no alternative but to find another hosting company, which I have done.

The site PaulSonny.com is now back up, but things are not like they were before and it will take me a day or two to get myself back up and running properly.

I hope everyone is patient enough and any members who previously registered before would like to re-register I would be very grateful.

I wish to thank everyone for their kind words and support through the development of HelpCenter.

Thanks, Paul.

Thanks Paul. Sorry for the issues.

Well cmms stands for "computerized maintenance management software". Lets say you had departments for buildings or different processes in a manufacturing facility. Then say you had different forums for each department. Then you had a prefix for each piece of equipment in that department. You could use helpcenter to create a work order for a specified piece of equipment within a department. The next evolution would be Scheduled maintenance (preventative maintenance) where you create some of the tickets (work orders) by cron. Then some graphs would be a nice touch. If you are planning to make money at this mod I would like to say a cmms would be very valuable.
Or it could be an AMS "asset management system" which is pretty much the same as an cmms.

Ty!!!!!!!!!!!!

Just so you know, it still says beta 5. I just want to make sure that the one that is up right now is the latest, most secure version, correct?

Good point..Please advise...

Database error in vBulletin 3.7.0:

Invalid SQL:
INSERT INTO helpcenter_department (departmentid,department,status,displayorder,forum id) VALUES ('','Hosting','0','1','78');

MySQL Error : Unknown column 'forumid' in 'field list'
Error Number : 1054
Request Date : Saturday, May 10th 2008 @ 09:17:35 AM
Error Date : Saturday, May 10th 2008 @ 09:17:35 AM
Script : http://****.com/forums/admincp/helpc...=adddepartment
Referrer : http://***.com/forums/admincp/helpce...=departmentadd
IP Address : //////////
Username : Lindsey
Classname : vB_Database
MySQL Version : 5.0.51a-community

Same error here after fresh install of todays release.

Yeah I am getting that error... *sigh*

Same error as the ones above.

Uploaded new package which will fix the above issue, sorry about that. I added a new field and stupidly forgot to add it to the installation code of the product.

Anyway should be fixed now.

Uninstall & Reinstall.

Thanks, Paul.

Hi Paul, great to have mod back :)

Ive just installed the new product however I have a problem!

When I create new departements, they remain closed. Ive updated them to be open but this dosent seem to make any difference.

Edit -

Ive added an attachment - Where abouts do I need to look to edit the CSS for the "Ticket ID" and "Posted By" - At the moment there the same colour as the backgroud so only show up when you put your mouse over them.

The other question is regarding the "Admin" link on the left hand side, should there be anything underneath that?

i also have this problem. how can we solve it?

I have fixed the department error, I had mis-typed the word status in the admin file so it wasnt finding the value from the form correctly.

With regards to the CSS, if you look in the hcenter_ticketlist template each <td> tag will have a class, just remove that class.

Thanks, Paul.

Thank you Paul

Brillaint.

Now its in RC stage do we still need to uninstall and then install or can we just upload and overwrite now?

It fixed the error, but now when I make departments, it isn't showing in the "Add new Ticket" area.

set the permissions again

I did, and still nothing.

Is it possible for admins to get a notification (“Your Notifications”) when there are open tickets?

Ive had a look, but the only CSS I can see relates to the actual headings, not for the information underneath.

I need to alter the CSS for the username that posts and also for the generated ticket ID.

You should be able to just overwrite now.

I have just tested adding a new department and testing whether it appears in the Drop Down Menu on the Add New Ticket form and it does.

Make sure you have set the permissions to add a new ticket, and also make sure the Department itself is not closed?

Thanks, Paul.

Not at the minute, will take this onboard though.

Sorry I mentioned wrong template, try hcenter_ticket instead.

Thanks, Paul.

Ive tried editing the bit in bold, but it dosent seem to make any difference.
They still show as invisable until you put the cursor over them.

Try replacing the hcenter_ticket template with this:

Thanks, Paul.

Thanks paul,

dosent appear to change anything afterwords. Ive refreshed and logged out and it but it still remains the same.

Well im afraid it isnt HelpCenter causing the problem, because that template above has no style at all, just alignment.

If you want me to log in and check for you please PM details me.

Thanks, Paul.

I get a Database Error when I create a ticket :(

Database error in vBulletin 3.7.0 Release Candidate 1:

Invalid SQL:
INSERT INTO helpcenter_ticket(departmentid, tickettitle, message, priority, ticketview, ownerid, ownerusername, lastreplyusername, lastreplyuserid, datelogged, datelastupdate, ipaddress, threadnum) VALUES ('1','Testticket','Nur ein testthread :D','2','0','1',','1','1210415000','1210415000','9 1.17.202.83','0');

MySQL Error : Unknown column 'ticketview' in 'field list'
Error Number : 1054
Date : Saturday, May 10th 2008 @ 12:23:20 PM
Script : http://www.anonym.com/helpcenter.php
Referrer : http://www.anonym.com/helpcenter.php?do=newticket

Did you have a previous installation installed? If so please uninstall and then reinstall to see if this corrects your problem. Can I ask why your still using RC1 of vBulletin 3.7? Why not upgrade?

Thanks, Paul.

Ok I will test it, I will upgrade my board to RC3, because I use a lot of Hackz which dont have the security Update. I will wait a little to upgrade to 3.7 Gold.

This modification will work fine with RC1, I just wondered why you hadnt updated to Gold. No problem.

Thanks, Paul.

Yes now it works fine after uninstall first.

Thanks ;)

No problem, glad it works.

Thanks, Paul.

Do we need to overwrite all the files, including the php ones or just overwrite the product?

If you have a previous installation (I.e. Beta Release) then you need to uninstall and then re-install. I believe this will be for the final time.

Thanks, Paul.

choccyclaire, you will need to re-upload all files, including re-installing the product.