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

Magnetism · #**472** 12-14-2006, 07:41 AM

Getting the error

Warning: Invalid argument supplied for foreach() in /vbsupport.php on line 391

When posting a new ticket, any ideas on how to fix this?

sinisterpain · #**473** 12-24-2006, 01:19 PM

Has anyone found or resolved the problem with Categorys not working in 3.6.4. Is CMX still working on this hack since it is a useful tool for a lot of forums.

sinisterpain · #**474** 12-31-2006, 09:03 PM

It appears to me just going thru the code in functions_vbsupport that some thing here is not right. It will not read the datastore for the variables. Not a coder so I can not figure out why the categories are not displaying. The author seems to have disapeared and while it its functional in 3.6.4 without categories it much more beneficial if they were too work. Would greatly appreciate any help. If its wrong to post this, I appologize

Code:

 // function to build the category options
function vbsupport_build_category_options($selcatid)
{
  global $vbulletin, $vbphrase, $show;

  // clear out $categoryoptions
  $categoryoptions = '';
  //check if they are allowed to change ticket categories
    $show['category'] = false;
  if (!empty($vbulletin->vbs_category) && is_array($vbulletin->vbs_category))
      {

    // always set this first value
    $categoryoptions = "<option value=0>" . $vbphrase['vbsupport_none'] . "</option>";

    // process all of the vbs_category
    foreach($vbulletin->vbs_category AS $categoryid => $category)
    {
      // check if this category is accessible
      if (($category['active'] > 0) AND vbsupport_check_allowed($vbulletin->userinfo, $category['allowedgroups'], $category['deniedgroups']))
      {
        // check if its integrated with vbbux / vbplaza
        if ($vbulletin->options['vbsupport_vbbuxplaza_integrate'] > 0)
        {
          // check if the cost is more than 0
          if ($category['cost'] > 0)
          {
            // format the cost properly
            $category['cost'] = vb_number_format($category['cost'], $vbulletin->options['vbbux_decimalplaces']);

            // update the $category['name'] to show the cost
            $category['name'] .= " (" . $category['cost'] . " " . $vbphrase['vbbux_name'] . " " . $vbphrase['vbbux_points'] . ")";
          }
        }

        // check if this is the one assigned
        if ($categoryid == $selcatid)
        {
          $categoryoptions .= "<option value=" . $categoryid . " selected>" . $category['name'] . "</option>";
        }
        else
        {
          $categoryoptions .= "<option value=" . $categoryid . ">" . $category['name'] . "</option>";
        }
      }
    }

    // set it so this user can set a category
    $show['category'] = true;
  }

  // return the $categoryoptions
  return $categoryoptions;
}

sinisterpain · #**475** 01-04-2007, 02:54 AM

Ok, with some research I finally got this to show the categories and assigned admins in both the support thread created and in creating a new ticket in vB 3.6.4.

you need to edit the author's files in the upload folder includes/vbsupport_functions.php file and the vbsupport.php file as follows:

vbsupport_functions.php

find:

Code:

// function to build the category options
function vbsupport_build_category_options($selcatid)
{
  global $vbulletin, $vbphrase, $show;

  // clear out $categoryoptions
  $categoryoptions = '';

  // check if they are allowed to change ticket categories
  $show['category'] = false;
  if (!empty($vbulletin->vbs_category) && is_array($vbulletin->vbs_category))
 {

change to:

Code:

// function to build the category options
function vbsupport_build_category_options($selcatid)
{
  global $vbulletin, $vbphrase, $show;

  // clear out $categoryoptions
  $categoryoptions = '';

  // check if they are allowed to change ticket categories
  $show['category'] = false;
  $vbulletin->datastore->do_db_fetch("'vbs_category'");
  if (!empty($vbulletin->vbs_category) && is_array($vbulletin->vbs_category))
  {

In vbsupport.php

find:

Code:

  // build the assigned user (if any)
      $show['assigned'] = true;
      $assigned = $vbulletin->vbs_admin[$thread['assigneduserid']];
      if (!empty($assigned) && is_array($assigned))
      {

change to:

Code:

 // build the assigned user (if any)
      $show['assigned'] = true;
      $vbulletin->datastore->do_db_fetch("'vbs_admin'");
      $assigned = $vbulletin->vbs_admin[$thread['assigneduserid']];
      if (!empty($assigned) && is_array($assigned))
      {

find:

Code:

 // build the category (if any)
      $category = $vbulletin->vbs_category[$thread['categoryid']];
      if (!empty($category) && is_array($category))
      {

change to:

Code:

 // build the category (if any)
      $vbulletin->datastore->do_db_fetch("'vbs_category'");
      $category = $vbulletin->vbs_category[$thread['categoryid']];
      if (!empty($category) && is_array($category))
      {

I am posting this fix since no word or activity has come from the author since July 2006. I feel that alot of members could really use this hack for their boards. The call for the datastore was not working which required a do_db_fetch since it did not recognize the vbs_category and would only see the datastore folder in the data base when using the call $vbulletin->vbs_categaory. These edits may not be needed by everyone, if you did a fresh install of 3.6.4 and not the upgrade the authors files may work without the edits you need to try the authors file and if categorys do not work then use the edits.

tank14 · #**476** 01-05-2007, 12:39 AM

Quote:

Originally Posted by sam anders

i know the coder of this mod is having issues with pc but wondering if any one as any ideas on the above?

Same issue here.

sinisterpain · #**477** 01-05-2007, 12:43 AM

Forgot another edit which must be made to the admincp/vbsupport.php file inorder for emails and pms to work with the categorys. Since the pm and emails get sent based on the individual category set up. Once the file edit is made in the admincp-> manage categorys select a category for edit and at the bottom you should see check boxes with administators listed for email and PM option. Select the admin and save this will send a pm based on who is selected for a specific category.

in the folder admincp/vbsupport.php

find:

Code:

function print_admin_user_row($title, $name = 'multibox', $columns = 0, $userlist)
{
  global $vbulletin;

  // build $userids
  if (empty($userlist))
  {
    // build an empty $userlist
    $userlist = '0';
  }
  $ids = explode(',', $userlist);

  // build the options
  $options = array();
  foreach($vbulletin->vbs_admin AS $userid => $user)
{

change to:

Code:

function print_admin_user_row($title, $name = 'multibox', $columns = 0, $userlist)
{
  global $vbulletin;

  // build $userids
  if (empty($userlist))
  {
    // build an empty $userlist
    $userlist = '0';
  }
  $ids = explode(',', $userlist);

  // build the options
  $options = array();
  $vbulletin->datastore->do_db_fetch("'vbs_admin'");
  foreach($vbulletin->vbs_admin AS $userid => $user)
  {

find:

Code:

// unserialize the datastore
$vbulletin->vbs_category = unserialize($vbulletin->vbs_category);
$vbulletin->vbs_admin = unserialize($vbulletin->vbs_admin);

change to:

Code:

$vbulletin->datastore->do_db_fetch("'vbs_category'");
$vbulletin->vbs_category = unserialize($vbulletin->vbs_category);
$vbulletin->datastore->do_db_fetch("'vbs_admin'");
$vbulletin->vbs_admin = unserialize($vbulletin->vbs_admin);

sinisterpain · #**478** 01-07-2007, 01:19 PM

Quote:

Originally Posted by tank14

Same issue here.

Your case is unique as we discussed on MSN, you are running a 3.6.4 install on a 3.5.4 skin, with a fresh install of 3.6.4. You do not require most if not any edits that I supplied. But you need to be sure that all of your permisions are set properly. Also you need to explain your problem in detail not just quote another thread.

BigJohnny · #**479** 01-09-2007, 01:43 PM

the zip for 2.0 is corrupt...

sinisterpain · #**480** 01-09-2007, 08:10 PM

Quote:

Originally Posted by BigJohnny

the zip for 2.0 is corrupt...

I just downloaded it and it works fine for me

BigJohnny · #**481** 01-09-2007, 09:58 PM

yup your right... it was a problemwith me.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05977 seconds Memory Usage 2,349KB Queries Executed 28 (?)
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 (16)bbcode_code (3)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_postinfo_query fetch_postinfo 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!