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

[CMX_CMGSCCC]

Originally Posted by WhisperPntr

Hey CMX,

That sounds great and it would be great to work alongside you as well as develop an extra plugin to have this interface with Ron1n's vbpurchase (a hack which I already have his permission to update and use).

Here are some screens of the changes that I've done, as well as a modification of the ticket template.

If you're interested in seeing the code changes, I'll modify the script I have to use your 0.7 version and then send the changes I added to you. They're very rudimentary and are based on the category updates.

Cheers!
~Whisper

Sounds good, I'll release v0.7 now so you can add the stuff. The other feature I want to add will take a little longer than I have today. And I'm going on a mini-vacation with the family this Monday to Thursday. So better to release v0.7 now and save the "notification per user" til I get back.

-CMX

[Xplorer4x4]

I have found a few bugs. First off if you only upload the product XML file your system will look like this:
http://img174.imageshack.us/img174/5...pimage22og.png
I uploaded all the file over writing the old ones and it fixed it.

The only other bug I see is there is no post icon asigned for a closed ticket. I just see a red X linked to www.yoursite.com/forums

Wasn;t sure if you guys were aware of that or not so figuered I would make note of it.

I would still love to see a staff notifcation method.

[CMX_CMGSCCC]

Originally Posted by Xplorer4x4

I have found a few bugs. First off if you only upload the product XML file your system will look like this:
http://img174.imageshack.us/img174/5...pimage22og.png
I uploaded all the file over writing the old ones and it fixed it.

The only other bug I see is there is no post icon asigned for a closed ticket. I just see a red X linked to www.yoursite.com/forums

Wasn;t sure if you guys were aware of that or not so figuered I would make note of it.

I would still love to see a staff notifcation method.

The first bug was because the files were not all uploaded I would have guessed. The second was a bug in the way the double icon system was working. I have fixed that in v0.7b, and added a quick notification to notify the assigned tech that the ticket was replied to. Later on, I will make it more elaborate so each admin can choose if they want to get notified or not, and via PM or Email too.

-CMX

[Xplorer4x4]

Originally Posted by CMX_CMGSCCC

The first bug was because the files were not all uploaded I would have guessed.

Nope all the files were uploaded as I have been runing this since version 0.5. Plus wouldn't the hack itself be usless with out all the files?

[CMX_CMGSCCC]

Originally Posted by Xplorer4x4

Nope all the files were uploaded as I have been runing this since version 0.5. Plus wouldn't the hack itself be usless with out all the files?

Yes, but between versions sometimes the class_*.php files do not get changed unless a new feature was added to the database. So I imagine some people were just uploading the vBSupport.php file. The class_ files have been updated to add a couple new features, and to get the replydateline working as well.

Do you still have this problem with the v0.7b zip?

-CMX

[WhisperPntr]

Thanks CMX. I'll be working on the changes now and send you a zip file sometime my tonight or tomorrow. I will mark the changes I've made with either a

PHP Code:

<!-- WhisperPntr //--> 


or a

PHP Code:

##WhisperPntr 


both of which you may feel free to delete once the code is to your liking.

Originally Posted by CMX_CMGSCCC

Sounds good, I'll release v0.7 now so you can add the stuff. The other feature I want to add will take a little longer than I have today. And I'm going on a mini-vacation with the family this Monday to Thursday. So better to release v0.7 now and save the "notification per user" til I get back.

-CMX

[Xplorer4x4]

Originally Posted by CMX_CMGSCCC

Yes, but between versions sometimes the class_*.php files do not get changed unless a new feature was added to the database. So I imagine some people were just uploading the vBSupport.php file. The class_ files have been updated to add a couple new features, and to get the replydateline working as well.

Do you still have this problem with the v0.7b zip?

-CMX

When I said I had to reupload the PHP files I was upgrading to 6.0 or 7.0. Sorry I can't recall which one specifacly as you have released like 3 versions in the past week. It was proabbly the orignal 7.0 upgrade.

Your upgrade instructions say upload the new XML file, yet here you say we need to upload the PHP files sometimes. Make up your mind.

[WhisperPntr]

Originally Posted by Xplorer4x4

When I said I had to reupload the PHP files I was upgrading to 6.0 or 7.0. Sorry I can't recall which one specifacly as you have released like 3 versions in the past week. It was proabbly the orignal 7.0 upgrade.

Your upgrade instructions say upload the new XML file, yet here you say we need to upload the PHP files sometimes. Make up your mind.

When in doubt upload ALL the files from the UPLOAD directory over the other ones. Also through the admin panel, choose to OVERWRITE the xml file. This is the way to update the xml file. As for "making up [his] mind" that's not particularily nice way to address this. Even if you mean no harm out of it, consider saving the developer's time when it is working well for other people but not for you.

In other developments, CMX I fixed a conditional so that pms are no longer sent to you if you are the replyer to the ticket (in other words, it doesn't send a pm about your own reply).

In addition, I am adding a very simple method of notification that is reliant on who replied to the ticket. It sends a notification pm about a non-self reply to all who replied in the ticket as well as whomever is assigned ONCE until another reply is made.

Let me know how you feel about this notification method.

[Xplorer4x4]

Originally Posted by WhisperPntr

When in doubt upload ALL the files from the UPLOAD directory over the other ones. Also through the admin panel, choose to OVERWRITE the xml file. This is the way to update the xml file.

When I upgraded, I had no doubts because the instructions say XML file only.

As for "making up [his] mind" that's not particularily nice way to address this. Even if you mean no harm out of it, consider saving the developer's time when it is working well for other people but not for you.

Well I personally do not find it very nice that you feel the need to criticize the way I comunicate with CMX. IF CMX feels it would of been more appropriate to simply say his upgrade isntructions were slighlty inadequate, then it his his place to do so and I aplogize.

Well seeing as I reported that with in about 30 minuetes of the hack being released, there is no need for anyone else to report it unless they have a fix correct? CMX resolved the issue.

Can we leave it at that please and move on as I was simply trying to help out you the codders?

[mikexxx]

If a user create a new ticket and no post icon is selected I get a red cross. If I look into the code there is no default icon.

<td class="alt1"><img src="" alt="" border="0" /></td>