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)

I get this when attemping to hit the VBsupport.php file:

Code:

Database error in vBulletin 3.5.2:



Invalid SQL:



                SELECT ticket.*, user.username AS assignedtechusername

                , icon.title AS icontitle, icon.iconpath

                FROM vb3_ticket AS ticket

                LEFT JOIN vb3_user AS user ON (user.userid = ticket.assignedtechid)

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

                WHERE ticket.postuserid = 1 AND open = 1

                ORDER BY ticket.replydateline DESC

                LIMIT 0, 20;



MySQL Error  : Unknown column 'ticket.assignedtechid' in 'on clause'

Error Number : 1054

Date         : Tuesday, December 13th 2005 @ 11:13:42 AM

Script       : http://www.theflyfishingforum.com/forums/vBSupport.php

Referrer     : http://www.theflyfishingforum.com/

IP Address   : 70.162.7.101

Username     : fshfanatic

Classname    : vb_database

doesnt work with 3.5.2 doesnt add the user group permissions, section for them all,

please tell us how to add it manual.

thank you.

Hopefully this will get updated to work with 3.5.2

Quote:

Originally Posted by Neofreaks

This will get it to work for 3.5.1:

Replace the contents of includes\xml\bitfield_support.xml with the following:

Code:

<?xml version="1.0" encoding="ISO-8859-1"?>



<bitfields product="vBSupport">

        <bitfielddefs>

                <group name="ugp">

                        <group name="supportpermissions">

                                <bitfield name="canadminsupport" group="support_admin_permissions" phrase="support_can_admin_support_tickets" install="2,3,4,5,6,7">1</bitfield>

                                <bitfield name="cancreatetickets" group="support_admin_permissions" phrase="support_can_create_tickets" install="2,3,4,5,6,7">2</bitfield>

                                <bitfield name="canreplytoowntickets" group="support_admin_permissions" phrase="support_can_reply_to_own_tickets" install="2,3,4,5,6,7">4</bitfield>

                                <bitfield name="canreplytoalltickets" group="support_admin_permissions" phrase="support_can_reply_to_all_tickets" install="2,3,4,5,6,7">8</bitfield>

                                <bitfield name="candeleteowntickets" group="support_admin_permissions" phrase="support_can_delete_own_tickets" install="2,3,4,5,6,7">16</bitfield>

                                <bitfield name="candeleteanyticket" group="support_admin_permissions" phrase="support_can_delete_any_ticket" install="2,3,4,5,6,7">32</bitfield>

                                <bitfield name="cancloseowntickets" group="support_admin_permissions" phrase="support_can_close_own_tickets" install="2,3,4,5,6,7">64</bitfield>

                                <bitfield name="cancloseanyticket" group="support_admin_permissions" phrase="support_can_close_any_ticket" install="2,3,4,5,6,7">128</bitfield>

                                <bitfield name="canopenowntickets" group="support_admin_permissions" phrase="support_can_open_own_tickets" install="2,3,4,5,6,7">256</bitfield>

                                <bitfield name="canopenanyticket" group="support_admin_permissions" phrase="support_can_open_any_ticket" install="2,3,4,5,6,7">512</bitfield>

                                <bitfield name="canassigntickets" group="support_admin_permissions" phrase="support_can_assign_tickets" install="2,3,4,5,6,7">1024</bitfield>

                                <bitfield name="canreassigntickets" group="support_admin_permissions" phrase="support_can_reassign_tickets" install="2,3,4,5,6,7">2048</bitfield>

                                <bitfield name="canpostattachments" group="support_admin_permissions" phrase="support_can_post_attachments" install="2,3,4,5,6,7">4096</bitfield>

                                <bitfield name="canviewattachments" group="support_admin_permissions" phrase="support_can_view_attachments" install="2,3,4,5,6,7">8192</bitfield>

                                <bitfield name="canmanagecategories" group="support_admin_permissions" phrase="support_can_manage_categories" install="2,3,4,5,6,7">16384</bitfield>

                                <bitfield name="canupdatecategorytype" group="support_admin_permissions" phrase="support_can_update_categorytype" install="2,3,4,5,6,7">32768</bitfield>

                        </group>

                </group>

        </bitfielddefs>

</bitfields>

<!-- CVS: $RCSfile: bitfield_support.xml,v $ - $Revision: 1.0 $ -->

Couldn't find usergroup permissions for 3.5.2 until I reread the posts here, did the above edit and it adds the usergroup permissions section into 3.5.2.

Now to see if everything else works!!

Believe it or not, the only error is in includes/xml/bitfield_support.xml
<bitfields product="vBulletin"> should not be capitalized.
It should be <bitfields product="vbulletin">

This will add the options to usergroup permissions as it is intended to rather than adding another cp module.

P.S. You may need to rebuild bitfields. /admincp/index.php?do=buildbitfields

The category names are all showing up as the number one for me. How can I fix this?

Thanks!

Quote:

Originally Posted by lsmba

I followed the install to the letter...all went find, "except" I cannot see the "permissions" area and I am getting this as I try to add categories "You are not authorized to manage ticket categories."

I also get this message and i have changed the bitfield_support file

Quote:

Originally Posted by Player-63

I also get this message and i have changed the bitfield_support file

Is the bitfield_support file a valid product or plugin? I get "Invalid File Specified" when I try to install it.

Hi,

i have test under 3.52 german and it's wonderfull...but a small bugs/questions.

Questions/bugs...
1. How can all User (specificate in userperm that allow) list and search all tickets? (open/closed)
2. How can i implement that a email/pm is send to the staff which have assign to a ticket?
3. Seems a small bug, when admin open ticket the categorie and save it - cat is lost... where can i change it? In the dropdown are the default value not the selected cat...
4. Is there a plan to make a directory to select first the cat for ticket and then add a ticket... all tickets are listen for this cat and the new ticket assign automaticly the cat and a little bit better, when i set a default user - also assign the user...

Yes of course I will use it and also donate...when is done...
Thomas

Quote:

Originally Posted by silurius

Is the bitfield_support file a valid product or plugin? I get "Invalid File Specified" when I try to install it.

just edited the file in incudes/xml folder and reinstalled plugin and still nothink :( dont know if i done it right.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01502 seconds Memory Usage 1,756KB 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 (2)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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: