vb.org Archive - vBSupport v2.0.0 Beta 2

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - vBSupport v2.0.0 Beta 2 (https://vborg.vbsupport.ru/showthread.php?t=94023)

vBSupport v2.0.0 Beta 2

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

<a href="https://vborg.vbsupport.ru/showthread.php?t=77155" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=77155</a> ... kinda like the same as this one, isn't it ?!

... btw, good to have a variety of tools!

I get this error when i click on ticket system

Code:

Database error in vBulletin 3.5.0 Release Candidate 2:



Invalid SQL:



                SELECT ticket.*

                ,icon.title AS icontitle, icon.iconpath

                FROM vbticket AS ticket

                LEFT JOIN vbicon AS icon ON(icon.iconid = ticket.iconid)

                WHERE postuserid = 1 AND open = 1

                ORDER BY dateline DESC;



MySQL Error  : Table 'elite_forum.vbticket' doesn't exist

Error Number : 1146

I have checked and the other tables are there but this on isnt,I uninstalled and reinstalled and still had the same problem.

Oops, I forgot to put the TABLE_PREFIX into the mysql create table installation code.

Its fixed in vBSupportv0.1a.zip

Also the Helpdesk looks nice too, I never seen it before. But its not converted to v3.5 yet?

-CMX

If you need to remove the old tables, run the 2 queries below.

Code:

DROP TABLE IF EXISTS forums_ticket;

DROP TABLE IF EXISTS forums_ticketreply;

That fixed it,thank you.

Have been waiting for something like this. :D

Sorry,another problem.

When you submit,reply or delete a ticket it tells you "cannot find phrase xxxxxx".

The phrases are in the phrase manager and it does what its supposed to,it just does not seem to be picking up on the phrases.

Works fine for me. /me clicks install

Nice job! :)

Quote:

Originally Posted by Rover416

Did it install the phrases to GLOBAL?

-CMX

Quote:

Originally Posted by nexialys

https://vborg.vbsupport.ru/showthread.php?t=77155 ... kinda like the same as this one, isn't it ?!

... btw, good to have a variety of tools!

Hardly. Thats kind of like claiming that a 'vette and a Viper are the same.
That one is a 3.0.X hack. This is a 3.5 plugin. That in itself is enough of a difference.

Nice hack. Grr, just installed 0.1 yesterday, must upgrade!

Quote:

Originally Posted by Sovereign

Nice hack. Grr, just installed 0.1 yesterday, must upgrade!

my permission are not saving, any ideas?

Quote:

Originally Posted by nealparry

my permission are not saving, any ideas?

Just reinstalled again and selected overwrite, seems to be doing it now. My forum is being weird today!

Does it support attachments?? That is a definitely useful option.

Quote:

Originally Posted by nealparry

Just reinstalled again and selected overwrite, seems to be doing it now. My forum is being weird today!

I was going to say that it has to recreate the bitfields, thats probably why it wasnt saving. In any case you can rebuild the bitfields manually by uploading the bitfield xml file to /includes/xml and then going to the URL /admincp/index.php?do=buildbitfields

About adding attachments, they are not supported yet. This is my first hack for vB 3.5.0, so I'm still kind of in the learning process. I could probably allow attachments in a future version.

-CMX

Is there no file attachment of v0.2 or am I missing something?

Quote:

Originally Posted by Creed

Is there no file attachment of v0.2 or am I missing something?

Right, file attachments was added in the v0.3 version per request.

So you should upgrade from v0.2 to v0.3. You do not need to uinstall it, just add the product-vBSupport.xml file and set "Allow Overwrite" to Yes and it should install properly.

Once you install v0.3, goto the Usergroup permissions and set "Can Post Attachements" and "Can View Attachments" for the usergroups you want to allow them for.

-CMX

Quote:

Originally Posted by CMX_CMGSCCC

Excellent mod and installed thankyou

Getting this error when trying to attach something:

Quote:

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:
UPDATE FORUMticketreply SET attach=1 WHERE ticketreplyid=1;

MySQL Error : Unknown column 'attach' in 'field list'
Error Number : 1054
Date : Friday, August 12th 2005 @ 12:48:20 AM
Script : http://www.*******.com/forum/vBSupport.php
Referrer : http://www.***.com/forum/vBSupport.php?do=newticket

And this with no attachment:

Quote:

Database error in vBulletin 3.5.0 Release Candidate 2:
Invalid SQL:
UPDATE FORUMticketreply SET attach=0 WHERE ticketreplyid=2;
MySQL Error : Unknown column 'attach' in 'field list'
Error Number : 1054
Date : Friday, August 12th 2005 @ 12:50:29 AM
Script : http://www.************.com/forum/vBSupport.php
Referrer : http://www.********.com/forum/vBSupp...p?do=newticket

Quote:

Originally Posted by nealparry

Getting this error when trying to attach something:

And this with no attachment:

Also getting a db error trying to delete them too

Oops, I forgot to add the upgrade option to add the attach column to the table. Going to update the file to v0.3b very shortly.

You can fix this error by running the following query:

Code:

ALTER TABLE (TABLE_PREFIX)ticketreply ADD COLUMN attach SMALLINT UNSIGNED NOT NULL DEFAULT '0';

Obviously replace the entire string "(TABLE_PREFIX)" with your table prefix, or remove "(TABLE_PREFIX)" entirely if you dont have one.

-CMX

Quote:

Originally Posted by nealparry

Also getting a db error trying to delete them too

I find that by uninstalling and reinstalling, the system works 100% as it is doing now. For some reason, the upgrade option isn't working with this mod.

Still a good mod though, well done!

Quote:

Originally Posted by nealparry

I find that by uninstalling and reinstalling, the system works 100% as it is doing now. For some reason, the upgrade option isn't working with this mod.

Still a good mod though, well done!

Posted at the same time, my above message was posted before CMX_CMGSCCC released the fix.

I get this message when used by a member, not posting just visiting the ticket system, the Warning appears at the top but otherwise seems to be working: Invalid argument supplied for foreach() in /includes/functions.php on line 327 but it works fine for the admin. Puzzled..help

Quote:

Originally Posted by nine45

Not 100% sure what is causing that, but I added a couple extra checks for the is_member_of call to verify that some admins were found, as well as verifying that an array exists to this call. (I created a new user account, but I unable to replicate this problem.)

Hopefully that will fix your problem.

If you have downloaded and installed v0.3b, you just need to upload the vBSupport.php file.

-CMX

Done that, it didn't fix it, I also now get this message when a member clicks the send new ticket link: Could not find phrase 'no_permission_create_tickets

Quote:

Originally Posted by nine45

Done that, it didn't fix it, I also now get this message when a member clicks the send new ticket link: Could not find phrase 'no_permission_create_tickets

It sounds like the installation is not 100%. Because it would be very odd that that phrase doesnt exist. If you edit the product-vBSupport.xml file, the phrase is there. When you are installing the file, did you try to "Allow Overwrite"?

-CMX

Yes I allowed overwrite, just tried un-installing and re-uploading all the new files and still have the same errors, I checked the file and no_permission_create_tickets exists in the XML and it is also present in phrases, just did a search for it...even more confused.

What group/category is the no_permission_create_tickets phrase in?

-CMX

Quote:

Originally Posted by nexialys

https://vborg.vbsupport.ru/showthread.php?t=77155 ... kinda like the same as this one, isn't it ?!

... btw, good to have a variety of tools!

Same idea, but the other one is not upgraded to the lastest vB version nor does it support attachments.

CMX_CMGSCCC,

Sorry if I missed it, but does this allow the administrator, mods, to be notified in any way of new tickets or does it let the "ticket owner" know that there has been a reply? Thru PMs, Email? Also is the usergroup permissions set thru the default usergroup permissions on the admincp?

The phrase is in the error messages phrases

Quote:

Originally Posted by CMX_CMGSCCC

What group/category is the no_permission_create_tickets phrase in?

-CMX

Maybe there has to be something in the PHP to cache the error messages properly for some vB setups. Maybe KirbyDE can help here, I will try to PM him about it.

As of right now it does not allow the support admins to be notified of new tickets. But its on the list of stuff to do at the moment. I want to add the following options to it before it goes to version 1.0

1) Option to be notified via PM/Email (probably check boxes)
a) For all new tickets.
b) For replies to only tickets that you are assigned to.
c) For all replies no matter who is assigned (not sure this is necessary though).
These options will apply to not only the support admins, but even for the users if they want to receive a PM/Email upon a reply to their ticket too.

2) Ability for admins to search for tickets. i.e. Search for all new tickets since your last visit, or search all tickets / replies in a category for usernames or userids and more.

3) More navbar options like listing new tickets, or tickets with replies since your last visit.

And anything else I can think of along the way. The dev on these features will be done over time, as I'm really busy as of late with my webpage http://www.cmgsccc.com and moving to our new house this coming week as well.

-CMX

I have this after upgrading (I did rebuild bitfields, what is happening???)

Make sure you've re-uploaded all the files in the "upload" folder.

Now I can't admin cats...I set all Administrator Usergroup permissions to "Yes" but vB unset these (see attached).

Quote:

Originally Posted by Sovereign

Now I can't admin cats...I set all Administrator Usergroup permissions to "Yes" but vB unset these (see attached).

I had to run

Code:

URL/admincp/index.php?do=buildbitfields

For my before my settings would save.

Funny thing. That fixed it, but I did rebuild bitfields before I tried that...

Is there any way to put in <upgradecode> instead of <installcode> into product xmls? That would solve problems for upgrader's if I could include code in there to do for "updating"?

-CMX

Great mod... :D Anyway to create a block or something to display when new tickets are present or submitted?

Thanks

Yeah, thats one of the things I will be adding before version 1.0. Some more nav buttons to find all new tickets since your last visit and replied tickets since your last visit. As well as the upcoming search for tickets to search by category, time posted, time replied to, words in the title and/or posts as well.

Thanx to the others for helping some users with problems. If I could figure out how to make upgrade code it would go smoother for the upgraders. I have it to rebuild the bitfields when you install it. But I'm not sure if the install code is run when you upgrade. If it is, I wonder if there is an MySQL error and that halts the rest of the install code from running and doesnt rebuild the bitfields?

-CMX

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02307 seconds Memory Usage 1,861KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (9)bbcode_code_printable (17)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: