vb.org Archive

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)

CMX_CMGSCCC 10-06-2005 12:40 AM

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

Xplorer4x4 10-06-2005 12:42 AM

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

eMike 10-06-2005 12:58 AM

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?

Xplorer4x4 10-06-2005 01:01 AM

@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.

mtha 10-06-2005 01:03 AM

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>";
                } 


mtha 10-06-2005 02:01 AM

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>


mtha 10-06-2005 02:12 AM

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

https://vborg.vbsupport.ru/attachmen...chmentid=33920

mtha 10-06-2005 02:41 AM

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

Disi 10-06-2005 01:42 PM

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: :p

Blackhat 10-06-2005 06:30 PM

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.


All times are GMT. The time now is 08:08 AM.

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.01526 seconds
  • Memory Usage 1,790KB
  • 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
  • (1)bbcode_code_printable
  • (4)bbcode_html_printable
  • (7)bbcode_php_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