Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
vBSupport v2.0.0 Beta 2 Details »
vBSupport v2.0.0 Beta 2
Mod Version: 2.0.0 B2, by CMX_CMGSCCC (Member) CMX_CMGSCCC is offline
Developer Last Online: Sep 2014 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.5.4 Rating: (10 votes - 4.60 average) Installs: 276
Released: 10 Aug 2005 Last Update: 11 Jun 2007 Downloads: 1023
Not Supported DB Changes Uses Plugins Template Edits Additional Files Is in Beta Stage  

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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Add Below:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

C) Template 'postbit':

Find:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Add Above

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

ENJOY!!

-CMX

Download Now

Only licensed members can download files, Click Here for more information.

Supporters / CoAuthors

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
  #436  
Old 24 Sep 2006, 00:28
mschvili mschvili is offline
 
Join Date: Jul 2006
Question Coming closer..

I found the error at least. But since I am no can't write code I don't understand it.

in vbSupport.php I find the code:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

$threadinfo[threadid] seems to end up without any value and hence the error me, PcGamer and other are experience.

Do any of you php-coders see the connection?
Reply With Quote
  #437  
Old 29 Sep 2006, 18:24
Chicago_VLNU_4s Chicago_VLNU_4s is offline
 
Join Date: Mar 2006
Location: Chicago
Real name: Moreno 4
the sidebar isn't showing up in ACP.....????
Reply With Quote
  #438  
Old 30 Sep 2006, 10:26
JamieLee2k's Avatar
JamieLee2k JamieLee2k is offline
 
Join Date: Sep 2006
Real name: JamieLee2k
Right lets get this straight upto now.

What do we need to do to get this working right?

There seems to be so many people working on this support and I wondered what we really needs to do to get this working properly.
Reply With Quote
  #439  
Old 02 Oct 2006, 15:00
codemoxie codemoxie is offline
 
Join Date: Sep 2006
Does not appear to work with vbulletin 3.6.1

Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,

avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
level,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM vbs_ticket_post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
WHERE post.postid IN (0,141,153)

ORDER BY post.dateline;

MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054
Reply With Quote
  #440  
Old 02 Oct 2006, 22:00
CypherSTL's Avatar
CypherSTL CypherSTL is offline
 
Join Date: Mar 2006
Real name: Patrick
I get the same error:

Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,

avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
level,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM vbs_ticket_post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
WHERE post.postid IN (0,3)

ORDER BY post.dateline;

MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054
Date : Monday, October 2nd 2006 @ 06:44:07 PM
Script : http://www.excalibursystems.net/vb36...ewthread&tid=2
Referrer : http://www.excalibursystems.net/vb36...p?do=newthread
IP Address : [IP hidden]
Username : [User Hidden]
Classname : vb_database

It did work fine with the default install on 3.6.0

Last edited by CypherSTL; 02 Oct 2006 at 23:50.
Reply With Quote
  #441  
Old 03 Oct 2006, 22:59
soletrader soletrader is offline
 
Join Date: Jul 2006
Can anyone post the working vbsupport.php for 3.6? I would appreciate it. Thank you
Reply With Quote
  #442  
Old 04 Oct 2006, 12:56
codemoxie codemoxie is offline
 
Join Date: Sep 2006
Anyone have a solution to the above bug? Support has been dead on our site for the last week
Reply With Quote
  #443  
Old 07 Oct 2006, 10:39
JamieLee2k's Avatar
JamieLee2k JamieLee2k is offline
 
Join Date: Sep 2006
Real name: JamieLee2k
This is working for 3.6.1 but haven't tried it on 3.6.2 yet, can anyone tell me if I can assign admin/mod to a forum I create?

Example:
If I create 4 forums:
Premiership
championship
Div 1
Div 2

Now I want to assign say
john to Premiership
bob to Championship
Mark to Div 1
Jamie to Div 2

This is so they can look after there own tickets rather than looking at everyones tickets from all divisions
Reply With Quote
  #444  
Old 08 Oct 2006, 00:11
JamieLee2k's Avatar
JamieLee2k JamieLee2k is offline
 
Join Date: Sep 2006
Real name: JamieLee2k
I am testing this on my PC before I go live with it, I have installed it fine and it works like a dream apart from 2 things in which I think I am missing.

1. How do I assign an admin/mod to a category so they can sort tickets out in that category only?
2. How can I create a usergroup so they can post a thread in to any category they wish? at the moment a registered user can't post a ticket as there are no categorys to choose from yet there are categorys there.
Reply With Quote
  #445  
Old 09 Oct 2006, 08:32
precharge precharge is offline
 
Join Date: Jun 2006
I don't see an update for 3.6.1 ? I get the same error after an upgrade

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,

avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
level,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM vbs_ticket_post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
WHERE post.postid IN (0,3)

ORDER BY post.dateline;
Reply With Quote
  #446  
Old 09 Oct 2006, 13:22
Derekclarke's Avatar
Derekclarke Derekclarke is offline
 
Join Date: Dec 2005
Location: N.Devon
since upgrade to 3.6.2 this is not working, i have not had any reports of problems on any other 3.6.0 or 3.6.1 versions, and i did not test it so cannot comment.

however, i have tried to remove this adn drop all the tables from the databse and then re-install.

but when a new ticket is created, it doen not give an option to choose a catagory. and you cannot post a support ticket without selecting a catagory.

Any ideas with this?

Thanks
Derek
Reply With Quote
  #447  
Old 09 Oct 2006, 14:10
JamieLee2k's Avatar
JamieLee2k JamieLee2k is offline
 
Join Date: Sep 2006
Real name: JamieLee2k
I have tried this on my PC and it works on 3.6.1 for sure but that was using windows and not Unix or Linux
Reply With Quote
  #448  
Old 09 Oct 2006, 14:23
CypherSTL's Avatar
CypherSTL CypherSTL is offline
 
Join Date: Mar 2006
Real name: Patrick
Unix or Linux or Windows would not make any difference, I have tried, PHP is PHP no matter what OS it is installed on...not working on 3.6.1 nor 3.6.2, tried fresh install as well with no luck. There where alot of template changes in 3.6.1 from 3.6.0 and some more from 3.6.1. to 3.6.2 which i am sure you are aware of, it was somewhere in these changes that broke the hack.

I am running Versions:
PHP - 4.4.3
MySQL - 4.1.21
Reply With Quote
  #449  
Old 09 Oct 2006, 16:20
JulianWolf JulianWolf is offline
 
Join Date: Apr 2006
There are some little thinks Iīd like to have in this great hack. They really seam little to me, has anybody an Idea, how to?

First question

If a ticket-moderator has a new ticket assigned to him or a new answer to an existing ticket there should appear a little grafic in the nav-menu. Just like a sentance under the messages-sentence (navbar):

Welcome, JulianWolf.
You last visited: 21. Sep 2006 at 20:00
Private Messages: Unread 0, Total 57.
You have x new tickets to moderate
As far as this only affects the assigned tickets Iīd love to have another sentence just for a smaller group (only the support-admins, who can assign tickets):

Welcome, JulianWolf.
You last visited: 21. Sep 2006 at 20:00
Private Messages: Unread 0, Total 57.
You have x new tickets to moderate
There are x unassigned tickets in the system
This would completely solve the eMail-question. As long as I have a visual information on the navbar I donīt need another eMail-notification.

Second question, a little more complex

Can I directly assign tickets by the category? Means: A ticket from category x should always directly assigned to moderator a, a ticket from category y always to moderator b and so on.

Third question, a very easy one

How can I built up a link where the category is prechoiced? For example I like to have a link "Forum-Problems" which should automatically go to the "new ticket"-page with the link "http://www.nlp-deutschland.de/forum/vbsupport.php?do=newthread". This is easy, but how can I pre-choice that the link also puts the category "Forum-Problems" as the standart-choice in the form?

Last question

Iīm a little unsecure about "forgotten tickets". For example: If another moderator doesnīt answer on the ticket, is there a way to "warn" the moderators?

An example: If a ticket isnīt answered in 3 days there is a warning-message on every ticket-admin like that one:

Welcome, JulianWolf.
You last visited: 21. Sep 2006 at 20:00
Private Messages: Unread 0, Total 57.
You have x new tickets to moderate
There are x unassigned tickets in the system
There are x old tickets still open
Is all that solvable? And, what do you think? Is it usefull?

Best wishes, Julian!
Reply With Quote
  #450  
Old 09 Oct 2006, 17:52
Jealousy10312 Jealousy10312 is offline
 
Join Date: Aug 2006
I would not use this hack. There are so many flaws with it, it's insane.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

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


New To Site? Need Help?

All times are GMT. The time now is 13:25.

Layout Options | Width: Wide Color: