vBSupport v2.0.0 Beta 2

vbSupport v2.0.0 BETA 2 by CMX (http://www.cmgsccc.com)
Official Homepage - http://www.vbplaza.com


v1.1 of this modification was found to contain an SQL injection. If you run v1.1 of this modification, you are hereby advised to update to v1.1a of this modification. To update from v1.1 to v1.1a, grab the v1.1a ZIP and overwrite the vBSupport.php file on your server with the new version.

Note that while no other vulnerabilities were noticed by vBorg Staff, this does not mean that such things do not exist. vBorg Staff fixed the one SQL injection according to these rules. Any other fixes that may be needed now or in the future are left to the original author.

-- vBorg Staff


Welcome to the latest hack by CMX for your vBulletin Message Board. This is a fully featured Ticket based support system for you website. If you had installed the older version of vBSupport v1.1, then you already have an idea what this sytem is all about.

Basically, this system will allow your Forum Members to create new support tickets using the same login as your vBulletin forums login for your users. There have been many improvements from the older v1.1 vBSupport System I made a while back.

New Features for v2.0.0+:
1) Permission Checks are better implemented and are more useful now.
2) AJAX Open/Closing tickets by double clicking the thread icon when listing tickets.
3) AJAX Ticket Title editing just like the forums Thread editing as well.
4) Post Quick Reply is now using the AJAX system where possible to post replies to tickets.
5) You can now Edit posts inline using the AJAX system as well.
6) Inline Moderation when listing tickets includes Delete Ticket, Open Ticket, Close Ticket.
7) You can now delete individual Posts from Tickets via the Inline Moderation as well.
8) MASSIVE performance load improvements. On my forums with 200,000 members, it would take 4 seconds to view a ticket due to a very strenuous query. Now it loads tickets in 0.13 seconds.
9) Category Administration has now been moved into the Admin CP instead of on the vbSupport page itself.
10) Everything should be fully phrased now as well.

Other Features:
1) IF you have installed the older vBSupport version, it will auto uninstall it for you. (It will NOT delete the old tickets!)
2) Admin CP -> vbSupport Maintenance -> Import Old Tickets is now in and working to import the old tickets if you had vBSupport installed.
3) A ton of permissions per Usergroup to set the settings up the way you want them.

vbSupport v2.0.0 BETA 2 Updates:
1) Bugfix: Quick Reply functions properly when you have the Quick Reply option enabled for Yes - Click Required.
2) Bugfix: Normal Reply/Closed button is there when viewing a ticket.
3) Bugfix: Admin CP Deleting a ticket now functions properly.
4) Bugfix: AJAX Edit feature does not display an alert(postid) anymore.
5) Bugfix: Active On/Off works for each category when enabled/disabled from the Admin CP.
6) Bugfix: Usergroup Permissions are now working for Allowed Usergroups & Denied Usergroups.
7) Bugfix: Changed some templates that linked to the wrong PHP files.
8) Bugfix: New Thread template is cleaned up a bit and it displays properly in Firefox too now.
9) Bugfix: Active phrase now is installed as a vbSupport phrase.


PLEASE NOTE: This is the very first release of vbSupport 2.0.0. Which means that this is a BETA release. I will try to correct any issues found ASAP.

I have vbSupport v2.0.0 BETA 1 running on my production site at www.cmgsccc.com, so I should be able to find most bugs since there are over 200,000 registers members there and it will get put to the test quite a bit. However, if you find something, please post it here.

By installing this BETA version, it will uninstall the previous vBSupport system automatically. It will leave the old ticket tables upon installation. It should import the older Ticket Categories that you had before as well.

I would also like to recommend that you backup your MySQL database, just in case a mishap occurs as this is BETA.

ALSO: The older version vBSupport v1.1 will be here for download until v2.0.0 comes out of BETA. vBSupport v1.1 is NOT in the BETA stage, only vbSupport v2.0.0 is in the BETA stage.

Upgrading Instructions From vBSupport v1.x
NOTE: These are ONLY applicable if you are upgrading from vBSupport v1.x!

1) Delete all of the older vBSupport files from your server. If you are not sure which files they are, the vBSupport v1.1 is still available for download here so you can download that and look at the files in there.

2) Upload all of the files in the upload folder to your forums ROOT folder. Make sure that if it asks about any files, that you set Overwrite to overwrite all files as well.

3) In your Admin CP, goto Plugin System -> Manage Products -> Add/Import Products at the bottom -> Select the XML file that you have downloaded in the package named product-vbsupport.xml -> Set Allow Overwrite to YES -> Import.

4) Perform the template edits below and you have vbSupport v2.0.0 up and running!

5) Refresh your forums Admin CP page.

6) Admin CP -> vbSupport Maintenance -> Import Old Tickets if you want to save the older tickets. Otherwise you can skip this feature.


New Installation Instructions:

1) Upload all of the files in the upload folder to your forums ROOT folder. Make sure that if it asks about any files, that you set Overwrite to overwrite all files as well.

2) In your Admin CP, goto Plugin System -> Manage Products -> Add/Import Products at the bottom -> Select the XML file that you have downloaded in the package named product-vbsupport.xml -> Set Allow Overwrite to YES -> Import.

3) Perform the template edits below and you have vbSupport v2.0.0 up and running!


Template Edits:

A) Template 'navbar':

Find:

		<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>

Add Below:

<!-- vbSupport start -->
			<if condition="$vboptions['vbsupport_enabled']"><td class="vbmenu_control"><a href="vbsupport.php$session[sessionurl_q">$vbphrase[vbsupport_title]</a></td></if>
<!-- vbSupport end -->

B) Template 'postbit_legacy':

Find:
[code]
<if condition="$show['postcount']">#<a href="showpost.php?$session[sessionurl]p=$post[postid]&amp;postcount=$post[postcount]" target="new" rel="nofollow" id="postcount$post[postid]" name="$post[postcount]"><strong>$post[postcount]</strong></a></if>
[code]

Add Above:

<!-- vbSupport start -->
			<if condition="$show['ticketcount']">#<a href="vbsupport.php?$session[sessionurl]do=viewpost&amp;pid=$post[postid]&amp;postcount=$post[postcount]" target="new" rel="nofollow" id="postcount$post[postid]" name="$post[postcount]"><strong>$post[postcount]</strong></a></if>
<!-- vbSupport end -->

C) Template 'postbit':

Find:

			<if condition="$show['postcount']">#<a href="showpost.php?$session[sessionurl]p=$post[postid]&amp;postcount=$post[postcount]" target="new" rel="nofollow" id="postcount$post[postid]" name="$post[postcount]"><strong>$post[postcount]</strong></a> &nbsp;</if>

Add Above

<!-- vbSupport start -->
			<if condition="$show['ticketcount']">#<a href="vbsupport.php?$session[sessionurl]do=viewpost&amp;pid=$post[postid]&amp;postcount=$post[postcount]" target="new" rel="nofollow" id="postcount$post[postid]" name="$post[postcount]"><strong>$post[postcount]</strong></a> &nbsp;</if>
<!-- vbSupport end -->

ENJOY!!

-CMX

[kylek]

Sorry but this really needs to be checked out by the person who made this. There are too many bugs that should not have to be edited in bits and pieces.

1 - Same as Blackhats post above this one - "There is a bug. When you add persons to manage tickets from the specific section those ID's are also added as name of the section so you have to edit each sections name after you have created it."

2 - eMike's post - icon missing

3 - Xplorer4x4 - cannot post a ticket - still getting database error

I am uninstalling the latest version 9.a until hopefully all of these get looked at.

[eMike]

Originally Posted by Xplorer4x4

@eMike I believe this has bee nadressed many times before. Try those methods.

Yes iI know it has been adressed, but CMX indicated that he fixed it in the upgrade. Just trying to do my part an inform about bugs.

[mtha]

I dont make this ext, but trying to help out

Originally Posted by kylek

1 - Same as Blackhats post above this one - "There is a bug. When you add persons to manage tickets from the specific section those ID's are also added as name of the section so you have to edit each sections name after you have created it."

somehow I cant see it in my version, . it'd help if you can give step-by-step on how to generate the bug, and screencapture too?
CMX, do you know this bug?

2 - eMike's post - icon missing

i think it was fixed. if not, you might have customized template? if you want, you can use my fix few post above

3 - Xplorer4x4 - cannot post a ticket - still getting database error

I dont , or did I fix it? did you upload the new files? what is the db error again?

[DGoulden]

I have vB 3.5.0 (Gold) set to use SMTP but this script dosn't want to use it, it defaults to sendmail, can i change this?

[CMX_CMGSCCC]

I am looking at the bugs here.

1) I am not experiencing this problem, so either the uploaded v0.9a zip is not the same version as I have on my server or somehow the template didnt get overwritten. I goto List Categories, then click on Edit, type in a userid of 1 for my user id, and press Update and then reedit it from List Categories and the category name is fine for me. (I'll add a comple small changes and reupload a v0.9b to make sure the zip has the exact files on my server that I do the testing/debugging on later tonight.)

2) Not 100% sure why this is happening, but I'm going to do something in v0.9b that might fix it. (I think somehow iconpath is not being filled in, so in v0.9b, gonna set $show[messageicon] true or falsed based on if iconpath is filled in or not and redo the template to accomodate this.)

3) Can not post a ticket should have been fixed in v0.9a, it was a small bug of a variable getting declared twice that I removed the second declaration in v0.9a.

Now to address the other comments:

Disi: I have added the phrases for open/close and I will change the "Open" and "Closed" inside the php file for the v0.9b I post later tonight. The emails and pm's could be changed as well, I guess it would use an preg_replace to replace {1} with the site name, and stuff as well. I will have to look into that in a future update as that is a bit more time consuming than the open/closed phrase uses.

DGoulden: It does use the php function mail(...), I'm not familiar with how to use the SMTP server from PHP, but if vBulletin can do it, I could probably research it further when I can find some more time.

-CMX

[clearchannel]

Is there something missing in the install instructions? I do not see any mention of running quaries or a self install. I uploaded the files according to the install instructions, made the template change in the nav bar and added the slm accoring to instuructions and it is not working.

Thanks in advance.

[clearchannel]

I uninstalled and reinstalled and it appears to be working now.

Nice script thanks

[xscape2me]

Is there a way to have it so that when an admin or something signs on it gives a little box up top, or maybe on the front page of vbadvanced cmps, showing how many trouble tickets are open?

[eMike]

Things appear to work great with the 09b version

How can I change the postbit? Cant seem to find any templates that controls that particular feature

[CMX_CMGSCCC]

xscape2me: Probably, I'm not familiar with vbadvanced, but I'm sure it would add a query.

eMike: Great. You can edit the postbit_ticket to change the postbit there. (the class_postbit.php file requires it to be postbit_xxx to open properly, so thats why it's named postbit_ticket)

-CMX