The Arcive of Official vBulletin Modifications Site.

vBSupport v2.0.0 Beta 2 · **Released**: 08-09-2005

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:

Code:

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

Add Below:

Code:

<!-- 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]&postcount=$post[postcount]" target="new" rel="nofollow" id="postcount$post[postid]" name="$post[postcount]"><strong>$post[postcount]</strong></a></if>
[code]

Add Above:

Code:

<!-- 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:

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> &nbsp;</if>

Add Above

Code:

<!-- 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 · #**342** 05-08-2006, 05:06 PM

Quote:

Originally Posted by Cajun

Ok found the problem with support ticket quick reply. If you have the Quick Reply option set to Yes - Click Required in the vb admin control panel under Message Posting and Editing Options this will happen.

If you change the setting to: Yes - Click Not Required then it works ok.

Now the reply button is still missing in the ticket system.

Thanx for figuring out the issue, I'll look into this very soon and I'll add the "reply" button without the quick reply in the next beta release.

Quote:

Originally Posted by RMS-Chef

I am having issues with categories. I have upgraded from the previous version.

I can add cats. I cannot delete cats. Also as a work around, I tried setting all usergroups as denied for a category yet I and regular registered users can still view the category as an option. Also, when setting the display order of the cats they still seem to be sorted by creation ID on the front end.

Second, when using AJAX quick edit, when I hit the EDIT button, I get an error type popup the the text "67" in it? I click OK and the quick edit editor displays as it should.

Third, I am not sure what the Yes/No drop down for each category is for. I assumed it was to set if that category is active but it seems to have no effect.

Fourth, thanks for the hack.

I'll check into the deletion of categories and see about a fix for Beta 2. The usergroups for allowed/denied do not function yet, that will be added again in the Beta 2 release. I forgot to do that part and then forgot until u just mentioned it that it needed going back to.. lol

Second, thats an "alert" box that was in the .js file, that will be removed in the Beta 2.

The Active I also will look into the issue as it sounds like its not working.

Quote:

Originally Posted by dilbert

This looks like a terrific tool.

I installed it and got an error. I uploaded a new set of files and imported the product again, and still I can't post a new ticket.

I get this error:

Code:

Invalid SQL:

        SELECT post.postid, IF(post.userid = 0, post.username, user.username) AS username,
            post.pagetext, post.allowsmilie, post.userid, post.dateline
        FROM vb3_vbs_ticket_post AS post
        LEFT JOIN vb3_user AS user ON(user.userid = post.userid)
        WHERE post.visible = 1
            
            AND post.threadid = 
        ORDER BY dateline DESC, postid DESC
        LIMIT 41;

Is there a know issue about this? I tried searching and it seems a few others had a similar problem, but I didn't see a fix for it anwhere.

Best regards,
Cliff

Could you give a little more information? Did it say what PHP file/link this was coming from? If not, I could probably find it, but it would be easier to look into that way.

Quote:

Originally Posted by mtha

very good upgrade CMX,

few things to check:

1. the edit window is not aligned well in Firefox (see attachment)

2. In Manage Settings:
"Enter the email address you wish to have all of the Email's sent from. If you do not specify one, it uses your contact email address. (Default is 1)"

default is not 1.

3. dont think $vbphrase['active'] is a GLOBAL phrase, (not so sure, just dont display in my vB)

1) Yeah, I noticed that too, but I'm not sure what the problem is there.

2) That will be fixed in the next Beta 2.

3) I'll check into that as well.

Quote:

Originally Posted by Chris M

The ability to edit a thread title expires after a certain period of time, which is why we suggest not having a version number in the thread title

Chris

Yeah, but its so much nicer having it there too hehe.

-CMX

dilbert · #**343** 05-08-2006, 05:29 PM

Quote:

Originally Posted by CMX_CMGSCCC

Could you give a little more information? Did it say what PHP file/link this was coming from? If not, I could probably find it, but it would be easier to look into that way.

Sorry about that, here is the whole error:

Code:

Database error in vBulletin 3.5.4:

Invalid SQL:

        SELECT post.postid, IF(post.userid = 0, post.username, user.username) AS username,
            post.pagetext, post.allowsmilie, post.userid, post.dateline
        FROM vb3_vbs_ticket_post AS post
        LEFT JOIN vb3_user AS user ON(user.userid = post.userid)
        WHERE post.visible = 1
            
            AND post.threadid = 
        ORDER BY dateline DESC, postid DESC
        LIMIT 41;

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 'ORDER BY dateline DESC, postid DESC
        LIMIT 41' at line 8
Error Number : 1064
Date         : Monday, May 8th 2006 @ 11:27:28 AM
Script       : http://www.bloodbanktalk.com/forum/vbsupport.php
Referrer     : http://www.bloodbanktalk.com/forum/vbsupport.php?do=newthread
IP Address   : 170.223.146.48
Username     : Cliff
Classname    : vb_database

mtha · #**344** 05-09-2006, 03:42 AM

Quote:

Originally Posted by dilbert

Sorry about that, here is the whole error:

Code:

Database error in vBulletin 3.5.4:

Invalid SQL:

        SELECT post.postid, IF(post.userid = 0, post.username, user.username) AS username,
            post.pagetext, post.allowsmilie, post.userid, post.dateline
        FROM vb3_vbs_ticket_post AS post
        LEFT JOIN vb3_user AS user ON(user.userid = post.userid)
        WHERE post.visible = 1
            
            AND post.threadid = 
        ORDER BY dateline DESC, postid DESC
        LIMIT 41;

I got that error twice, but I cant replicate it now,

Seems that the error is from line 1928, do=newreply, where $threadinfo[threadid] is empty.
Just dont understand why it got executed.

mtha · #**345** 05-09-2006, 04:15 AM

Quote:

Originally Posted by mtha

very good upgrade CMX,

few things to check:

1. the edit window is not aligned well in Firefox (see attachment)

Because you are missing a wrapping table outside messagearea
EDIT TEMPLATE: vbsupport_newthread

line 36-41

HTML Code:

        <!-- message area -->
        <div class="smallfont">$vbphrase[message]:</div>        
        $messagearea
        <!-- / message area -->
        
        $posticons

REPLACE WITH

HTML Code:

        <table cellpadding="0" cellspacing="0" border="0">
        <tr>
            <td>
                            
        <!-- message area -->
        <div class="smallfont">$vbphrase[message]:</div>        
        $messagearea
        <!-- / message area -->
        
        $posticons
        
            </td>
        </tr>
        </table>

CMX_CMGSCCC · #**346** 05-09-2006, 05:41 AM

Quote:

Originally Posted by mtha

Because you are missing a wrapping table outside messagearea
EDIT TEMPLATE: vbsupport_newthread

line 36-41

HTML Code:

        <!-- message area -->
        <div class="smallfont">$vbphrase[message]:</div>        
        $messagearea
        <!-- / message area -->
        
        $posticons

REPLACE WITH

HTML Code:

        <table cellpadding="0" cellspacing="0" border="0">
        <tr>
            <td>
                            
        <!-- message area -->
        <div class="smallfont">$vbphrase[message]:</div>        
        $messagearea
        <!-- / message area -->
        
        $posticons
        
            </td>
        </tr>
        </table>

BETA 2 Released now. Please read the Updates to identify the bugs fixed.

-CMX

dxguru · #**347** 05-09-2006, 08:21 AM

CMX ... A quick question about the Beta release.

Once the Beta is complete and v2 is released, will the upgrade process from v1.x be easier than v1.x >> Beta?

I would like to do the upgrade to the Beta to help out in testing, but have rather a lot on my plate at the moment

Derekclarke · #**348** 05-09-2006, 10:04 AM

went to upgrade from, 1.1 to beta 2, deleted all files from server, and uploaded all new ones, uploaded and over wrote the product.

all ok.

went to do the template mods, and on the first template i get the following message when i go to save the template.

The following error occurred when attempting to evaluate this template:

Quote:

Originally Posted by error message recieved

Parse error: parse error, unexpected T_CHARACTER, expecting ']' in /home/clarkoss/public_html/includes/adminfunctions_template.php(3537) : eval()'d code on line 99

This is likely caused by a malformed conditional statement. It is highly recommended that you fix this error before continuing, but you may continue as-is if you wish.

any ideas?

87accordlxi · #**349** 05-09-2006, 01:09 PM

I get the same error as above. I replaced the navbar link with a generic link to get to vbsupport (I simply call it "Site Support" on my board):

Code:

<td class="vbmenu_control"><a href="vbsupport.php$session[sessionurl_q]">Site Support</a></td>

I went in, and all that came up was an error saying that I was not authorized to create tickets, even though I was just accessing the vbsupport main page, not creating a ticket.

I went into the settings and checked "Yes" for "vbSupport Unregistered Access." This allows me to get to the main vbsupport page and create tickets, but now I do not have permission to view the tickets once I've created them. I get a "87accordlxi, you do not have permission to access this page. This could be due to one of several reasons..."

CMX_CMGSCCC · #**350** 05-09-2006, 03:16 PM

Quote:

Originally Posted by dxguru

CMX ... A quick question about the Beta release.

Once the Beta is complete and v2 is released, will the upgrade process from v1.x be easier than v1.x >> Beta?

I would like to do the upgrade to the Beta to help out in testing, but have rather a lot on my plate at the moment

It should be the same for the upgrade procedure.

Quote:

Originally Posted by Derekclarke

went to upgrade from, 1.1 to beta 2, deleted all files from server, and uploaded all new ones, uploaded and over wrote the product.

all ok.

went to do the template mods, and on the first template i get the following message when i go to save the template.

The following error occurred when attempting to evaluate this template:

any ideas?

Which template edit were u doing when u got this error?

Quote:

Originally Posted by 87accordlxi

I get the same error as above. I replaced the navbar link with a generic link to get to vbsupport (I simply call it "Site Support" on my board):

Code:

<td class="vbmenu_control"><a href="vbsupport.php$session[sessionurl_q]">Site Support</a></td>

I went in, and all that came up was an error saying that I was not authorized to create tickets, even though I was just accessing the vbsupport main page, not creating a ticket.

I went into the settings and checked "Yes" for "vbSupport Unregistered Access." This allows me to get to the main vbsupport page and create tickets, but now I do not have permission to view the tickets once I've created them. I get a "87accordlxi, you do not have permission to access this page. This could be due to one of several reasons..."

The Unregistered access is hazy at best, I need to do more testing on it to verify all permissions are functioning properly for it.

In the end, it will use the Usergroup settings that you have specified for Unregistered inside the Usergroup Manager.

The other settings u need to setup inside Admin CP -> Usergroups -> Usergroup Manager -> And set the vbSupport Permissions for each usergroup you want to access the system and what features they are allowed to do.

-CMX

Derekclarke · #**351** 05-09-2006, 03:19 PM

I was doing the first one.


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


I have done the other templates, just this one that has the error.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07364 seconds Memory Usage 2,364KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (10)bbcode_code (4)bbcode_html (13)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!