Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.5 > vBulletin 3.5 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vBSupport v2.0.0 Beta 2 Details »»
vBSupport v2.0.0 Beta 2
Version: 2.0.0 B2, by CMX_CMGSCCC CMX_CMGSCCC is offline
Developer Last Online: Sep 2014 Show Printable Version Email this Page

Version: 3.5.4 Rating:
Released: 08-09-2005 Last Update: 06-10-2007 Installs: 276
DB Changes Uses Plugins Template Edits
Additional Files Is in Beta Stage  
No support by the author.

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]&amp;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

Supporters / CoAuthors

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #482  
Old 01-15-2007, 06:56 PM
Takamine334 Takamine334 is offline
 
Join Date: Aug 2004
Posts: 175
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

When users try to submit a ticket, they get this:

You did not specify a Category for your Thread. You are required to enter a Category.

I have created categories, but I don't see where the user is supposed to select one prior to submitting a ticket.
Reply With Quote
  #483  
Old 01-15-2007, 09:00 PM
sinisterpain's Avatar
sinisterpain sinisterpain is offline
 
Join Date: Feb 2006
Location: New Hampshire
Posts: 571
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Takamine334 View Post
When users try to submit a ticket, they get this:

You did not specify a Category for your Thread. You are required to enter a Category.

I have created categories, but I don't see where the user is supposed to select one prior to submitting a ticket.
Are you running Vb3.6.4, if so try the edits I have given a few threads back. https://vborg.vbsupport.ru/showpost....&postcount=476
Reply With Quote
  #484  
Old 01-16-2007, 01:08 PM
amykhar's Avatar
amykhar amykhar is offline
 
Join Date: Oct 2001
Location: PA
Posts: 4,438
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Here is a fix that allows unregistered users to SEE the ticket system.

In vbsupport.php Find:

Code:
if ($vbulletin->options['vbsupport_unregistered_access'] > 0)
Replace with:

Code:
if ($vbulletin->options['vbsupport_unregistered_access']==0)
and guests can view. I'm working now on getting guests to be able to actually submit a ticket.
Reply With Quote
  #485  
Old 01-17-2007, 09:38 PM
TotalTorque.net TotalTorque.net is offline
 
Join Date: Dec 2006
Location: UK
Posts: 59
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ok, I've installed v2 but have problems.

Whenever I try to go to vbSupport in the navbar it says I am not authorized to create tickets.

That is despite being logged in as a Mod or Admin.

So, I set it to a public system.

It then allowed me to create a ticket, but when I went to submit it, it said I did not have sufficient permissions. Yet, it showed 1 open ticket...but wouldn't display it!

So, as a Mod/Admin I can do nothing, but as a standard user I can...but only get so far!

Very odd indeed? Help!
Reply With Quote
  #486  
Old 01-17-2007, 10:32 PM
sinisterpain's Avatar
sinisterpain sinisterpain is offline
 
Join Date: Feb 2006
Location: New Hampshire
Posts: 571
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by TotalTorque.net View Post
Ok, I've installed v2 but have problems.

Whenever I try to go to vbSupport in the navbar it says I am not authorized to create tickets.

That is despite being logged in as a Mod or Admin.

So, I set it to a public system.

It then allowed me to create a ticket, but when I went to submit it, it said I did not have sufficient permissions. Yet, it showed 1 open ticket...but wouldn't display it!

So, as a Mod/Admin I can do nothing, but as a standard user I can...but only get so far!

Very odd indeed? Help!
The author's navbar edit has an error
try this instead:
Code:
<if condition="$vboptions['vbsupport_enabled']"><td class="vbmenu_control"><a href="vbsupport.php$session[sessionurl_q]">$vbphrase[vbsupport_title]</a></td></if>
Reply With Quote
  #487  
Old 01-21-2007, 02:26 AM
tank14 tank14 is offline
 
Join Date: Oct 2006
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

OK so is any one getting a completely corrupt view when you are in postbit legacy?
Reply With Quote
  #488  
Old 01-22-2007, 05:49 AM
Bahawolf2 Bahawolf2 is offline
 
Join Date: Apr 2003
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Obtained this error when I went to: AdminCP -> vbSupport -> Manage Categories -> Clicked on its Category name 'Forums Problem' (default category)
Note: it shows this error message twice though it shows all the categories settings...
Warning: Invalid argument supplied for foreach() in /admincp/vbsupport.php on line 40

vbsupport.php line 40 = foreach($vbulletin->vbs_admin AS $userid => $user)

After clicking new thread (to send a new ticket) I filled out all the ticket info and hit send... it loads a screen for about 5 seconds saying
Warning: Invalid argument supplied for foreach() in /vbsupport.php on line 391
Then proceeds to a permissions page saying I don't have permission to access it....

vbsupport.php line 391 = foreach($vbulletin->vbs_admin AS $userid => $user)

Any Clue?
Other info----
Running VB 3.6.4 (recently upgraded from 3.5.3)
Tryed running: vbsupport_v2.0.0_Beta_2
I also tryed the install tips from this website:
https://vborg.vbsupport.ru/showpost....&postcount=476

Thanks in advance for any help.
Reply With Quote
  #489  
Old 01-22-2007, 08:19 PM
sinisterpain's Avatar
sinisterpain sinisterpain is offline
 
Join Date: Feb 2006
Location: New Hampshire
Posts: 571
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You did not do the other edit below that post which is edit for vbsupport.php in the admincp folder. See post https://vborg.vbsupport.ru/showpost....&postcount=478.
Also in the main vbsupport.php (one not in admincp folder)I forgot another edit I think

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

// check if the user is an admin
$show['useradmin'] = false;
if (vbsupport_can_moderate('canadminsupport'))
{
Change too:
Code:
// unserialize the datastore
$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);

// check if the user is an admin
$show['useradmin'] = false;
if (vbsupport_can_moderate('canadminsupport'))
{
also for pms to work:
find in vbsupport.php:
Code:
 // build the $emailids
 
    $pmids = explode(',', $vbulletin->vbs_category["$categoryid"]['adminpmusers']);
    $emailids = explode(',', $vbulletin->vbs_category["$categoryid"]['adminemailusers']);

    // check for email notifications
    if (is_array($emailids) && is_array($pmids))
    {
      // process add admins

      foreach($vbulletin->vbs_admin AS $userid => $user)
      {
Change too:
Code:
 // build the $emailids
    $vbulletin->datastore->do_db_fetch("'vbs_category'");
    $pmids = explode(',', $vbulletin->vbs_category["$categoryid"]['adminpmusers']);
    $emailids = explode(',', $vbulletin->vbs_category["$categoryid"]['adminemailusers']);

    // check for email notifications
    if (is_array($emailids) && is_array($pmids))
    {
      // process add admins
      $vbulletin->datastore->do_db_fetch("'vbs_admin'");
      foreach($vbulletin->vbs_admin AS $userid => $user)
      {
Quaterbore posted a phrase add which must be done for pms regards to a support ticket being deleted by another admin and then clicking on the link in the PM that was sent by that ticket will cause an error since no phrase exists to handle this particular case.
Reply With Quote
  #490  
Old 01-22-2007, 09:08 PM
Techno05 Techno05 is offline
 
Join Date: Nov 2005
Posts: 59
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

When posting a reply to a ticket we get a

Code:
Database error in vBulletin 3.6.4:

Invalid SQL:
INSERT INTO pm (pmid, pmtextid, userid, folderid, messageread) VALUES (0, , 402, 0, 0);

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 ' 402, 0, 0)' at line 1
Error Number : 1064
Date         : Monday, January 22nd 2007 @ 11:05:56 PM
Script       : http://www.sigrequest.com/forums/vBSupport.php
Referrer     : http://www.sigrequest.com/forums/vBSupport.php?do=newreply&noquote=1&ticketreplyid=28
IP Address   : 83.100.224.13
Username     : Techno
Classname    : vB_Database_MySQLi
Error, any suggestions?
Reply With Quote
  #491  
Old 01-22-2007, 10:13 PM
sinisterpain's Avatar
sinisterpain sinisterpain is offline
 
Join Date: Feb 2006
Location: New Hampshire
Posts: 571
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Techno05 View Post
When posting a reply to a ticket we get a

Code:
Database error in vBulletin 3.6.4:

Invalid SQL:
INSERT INTO pm (pmid, pmtextid, userid, folderid, messageread) VALUES (0, , 402, 0, 0);

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 ' 402, 0, 0)' at line 1
Error Number : 1064
Date         : Monday, January 22nd 2007 @ 11:05:56 PM
Script       : http://www.sigrequest.com/forums/vBSupport.php
Referrer     : http://www.sigrequest.com/forums/vBSupport.php?do=newreply&noquote=1&ticketreplyid=28
IP Address   : 83.100.224.13
Username     : Techno
Classname    : vB_Database_MySQLi
Error, any suggestions?
You installed version 1.1, need to install version 2.0.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 08:54 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05719 seconds
  • Memory Usage 2,340KB
  • 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
  • (14)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_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