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
  #122  
Old 10-06-2005, 12:40 AM
CMX_CMGSCCC CMX_CMGSCCC is offline
 
Join Date: Sep 2003
Posts: 1,218
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by mtha
Wow, too far from the rest You should have named it support_postbit or support_postbit_ticket or something like that




add to the list:

- Display CatID before editing category name
Code:
	<td>[$category[categoryid]] <input type="hidden" name="category[$category[categoryid]]" value="$category[categoryid]"><input type="text" name="categoryname[$category[categoryid]]" value="$category[categoryname]" size=50></td>

- newticket in predefined category
could be "vBSupport.php?do=newticket&catid=xxx" it will select the catid by default, or only display that specific catid

- Search ticket by ticketid, postuserid, open status (open or closed)
I have added those search options and ID displayed to the category lists.

As far as postbit_ticket, it has to be named that way to be able to use the class_postbit.php I think. I think that was the reason I chose postbit_ticket, because new_postbit(...) or something has to use the word 'ticket' and it puts postbit_ before the ticket word..

-CMX
Reply With Quote
  #123  
Old 10-06-2005, 12:42 AM
Xplorer4x4 Xplorer4x4 is offline
 
Join Date: Apr 2005
Posts: 938
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PHP Code:
Database error in vBulletin 3.5.0:
Invalid SQL:
INSERT INTO pm (pmidpmtextiduseridfolderidmessagereadVALUES (0575, , 00);
MySQL Error You have an error in your SQL syntaxCheck the manual that corresponds to your MySQL server version for the right syntax to use near ' 0, 0)' at line 1
Error Number 
1064
Date         
WednesdayOctober 5th 2005 08:41:22 PM
Script     
: /forums/vBSupport.php
Referrer     
: /forums/vBSupport.php?do=newticket
IP Address 

Username     
Classname    vb_database 
I can not post a ticket.

EDIT: using 0.9
Reply With Quote
  #124  
Old 10-06-2005, 12:58 AM
eMike eMike is offline
 
Join Date: Nov 2002
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Could be me that is doing something majorly wrong here, but I still do not see that icon image - same red X as before. (After upgrading to 09a)

Is it me?
Reply With Quote
  #125  
Old 10-06-2005, 01:01 AM
Xplorer4x4 Xplorer4x4 is offline
 
Join Date: Apr 2005
Posts: 938
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

@CMX I upgraded .9A and have no DB problem, but the catgoreys are still showing up as the User Id's assigned to be notified.
Reply With Quote
  #126  
Old 10-06-2005, 01:03 AM
mtha's Avatar
mtha mtha is offline
 
Join Date: Jul 2002
Location: US
Posts: 775
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by mtha
- newticket in predefined category
could be "vBSupport.php?do=newticket&categoryid=xxx" it will select the catid by default, or only display that specific catid

to do this:

in vBSupport.php

LOOK FOR
PHP Code:
// start creating a new ticket "
if ($_REQUEST['do'] == 'newticket')

ADD BELLOW

PHP Code:
    $vbulletin->input->clean_array_gpc('r', array(
        
'categoryid'            => TYPE_UINT,
    )); 
LOOK FOR
PHP Code:
                while ($category $db->fetch_array($categories))
                {
                 
$categorybits .= "<option value=$category[categoryid]>$category[categoryname]</option>";
                } 
REPLACE BY
PHP Code:
                while ($category $db->fetch_array($categories))
                {
                 
$categorybits .= "<option value=$category[categoryid] " iif($category[categoryid] == $vbulletin->GPC['categoryid'],'selected') . ">$category[categoryname]</option>";
                } 
Reply With Quote
  #127  
Old 10-06-2005, 02:01 AM
mtha's Avatar
mtha mtha is offline
 
Join Date: Jul 2002
Location: US
Posts: 775
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Display assigned user (if any) in ticket list

In vBSupport.php
search for

PHP Code:
    // start getting the support tickets
    
$tickets $db->query_read("
        SELECT ticket.*
        " 
iif($vbulletin->options['privallowicons'], ",icon.title AS icontitle, icon.iconpath") . "
        FROM " 
TABLE_PREFIX "ticket AS ticket
        " 
iif($vbulletin->options['privallowicons'], "LEFT JOIN " TABLE_PREFIX "icon AS icon ON(icon.iconid = ticket.iconid)") . "
        
$listtype
        ORDER BY replydateline DESC
        
$limitstr
    "
); 

by

PHP Code:
    // start getting the support tickets
    
$tickets $db->query_read("
        SELECT ticket.*, user.username AS assignedtechusername
        " 
iif($vbulletin->options['privallowicons'], ",icon.title AS icontitle, icon.iconpath") . "
        FROM " 
TABLE_PREFIX "ticket AS ticket
        LEFT JOIN " 
TABLE_PREFIX "user AS user ON(user.userid = ticket.assignedtechid)
        " 
iif($vbulletin->options['privallowicons'], "LEFT JOIN " TABLE_PREFIX "icon AS icon ON(icon.iconid = ticket.iconid)") . "
        
$listtype
        ORDER BY replydateline DESC
        
$limitstr
    "
); 


template edit: support_ticketlistbit

HTML Code:
			<span class="smallfont" style="float:$stylevar[right]"><strong>$ticket[status]</span>
replate with

HTML Code:
			<span class="smallfont" style="float:$stylevar[right]">
		    	<div align="right"><strong>$ticket[status]</strong>
		    	<br><i><a href="member.php?$session[sessionurl]u=$ticket[assignedtechid]">$ticket[assignedtechusername]</a></i>
				</div>
			</span>
edit template SUPPORTCP
look for
HTML Code:
		<td class="thead" width="100%">
		    $vbphrase[support_ticket_open_status] / $vbphrase[support_ticket_starter]
		</td>
replace with

HTML Code:
		<td class="thead" width="100%">
			<span class="smallfont" style="float:$stylevar[right]">
				$vbphrase[status]/$vbphrase[support_assign_ticket]
			</span>
		    $vbphrase[support_ticket_open_status] / $vbphrase[support_ticket_starter]
		</td>
Reply With Quote
  #128  
Old 10-06-2005, 02:12 AM
mtha's Avatar
mtha mtha is offline
 
Join Date: Jul 2002
Location: US
Posts: 775
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

https://vborg.vbsupport.ru/showpost....3&postcount=60
Quote:
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
CMX, do you have any plan to change your "Open status" to a Full integrated status", which would be something like this

Reply With Quote
  #129  
Old 10-06-2005, 02:41 AM
mtha's Avatar
mtha mtha is offline
 
Join Date: Jul 2002
Location: US
Posts: 775
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by CMX_CMGSCCC
Allowed Usergroups mean that those usergroups can create a new ticket in that category. (This is so your admins can create tickets in a specified category that normal users cant create. Like how do we handle X user inside a category named 'Problem Users', etc..)

Allowed Technician Usergroup is the usergroups that are allowed to be assigned to the ticket in that category.

-CMX
How about Support Admin Permissions in usergroup bitfield?

it looks like that I have to checl "This usergroup can Admin Support Tickets" to allow in tech assigned list.

and if I check so, i can assign to anyone in the list? isnt that right or i am missing something?

what is the combination/relationship between them?





........

and your PM template is hardcoded? i think you can use vB's pmdm too
Reply With Quote
  #130  
Old 10-06-2005, 01:42 PM
Disi Disi is offline
 
Join Date: Aug 2005
Location: Germany
Posts: 62
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Updated and Translated into german

http://www.vbhacks-germany.com/forum...ead.php?p=9675

btw

CMX could you manage to put every language specific thinks, like email, pm announcment or the states (open close) into the XML file?

It would be much easier to translate them and i wouldn't miss things :bunny:
Reply With Quote
  #131  
Old 10-06-2005, 06:30 PM
Blackhat's Avatar
Blackhat Blackhat is offline
 
Join Date: Mar 2005
Posts: 323
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
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 02:54 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.09160 seconds
  • Memory Usage 2,378KB
  • 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
  • (6)bbcode_code
  • (4)bbcode_html
  • (7)bbcode_php
  • (4)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