vb.org Archive - vBSupport v2.0.0 Beta 2

Page 11 of 16

« First

Last »

Show 40 post(s) from this thread on one page

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)

sam anders

08-14-2006 06:04 PM

Quote:

Originally Posted by sam anders

have installed but when i go to create a support ticket i receive this error:

You did not specify a Category for your Thread. You are required to enter a Category.

there are no categorys displays on the vbsupport page

any ideas

i know the coder of this mod is having issues with pc but wondering if any one as any ideas on the above?

futuredood

08-16-2006 12:46 PM

i hope this will work with 3.6....

TKlingler

08-17-2006 06:32 AM

Hello, some trubel with the Updat, I have installed the Version 1 with me germany tranlation afert the Updat the bitfiels in the admincp usergroups have no discription. Look at the picture in the attatchment. After deinstall and reinstall the bitfieldes work correct.

If it is ok for you a make a german translation for me and everybody how whant's it.

Thomas

TKlingler

08-17-2006 06:53 AM

Hello, I have also an error if I want to ad a new category it display

Warnung: Invalid argument supplied for foreach() in /admincp/vbsupport.php (Zeile 40)
Notify Admin by Email on New Ticket
Warnung: Invalid argument supplied for foreach() in /admincp/vbsupport.php (Zeile 40)
look at the picture at the attachment.

If I want to send a ticke I have no field for the category the if the setting is on you maust have a cotegiry I can not send a ticket.

Cajun

08-18-2006 03:21 AM

Quote:

Originally Posted by TKlingler

I am having the same problem. I had someone look at the problem and could not fix. Looks like this happens when up upgrade to vb 3.6. I know this mod works on a fresh install for vb 3.6 but not on a upgrade.

TKlingler

08-18-2006 05:58 AM

Quote:

Did you have an idea why? Because it is no way for me to delete the forum an reinstall;)

Dark Riku

08-20-2006 08:51 PM

Code:

Database error in vBulletin 3.6.0:



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 vbvbs_ticket_post AS post

                LEFT JOIN vbuser AS user ON(user.userid = post.userid)

                LEFT JOIN vbuserfield AS userfield ON(userfield.userid = user.userid)

                LEFT JOIN vbusertextfield AS usertextfield ON(usertextfield.userid = user.userid)

                

                LEFT JOIN vbavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vbcustomavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN vbreputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)

                WHERE post.postid IN (0,2)

                        

                ORDER BY post.dateline;



MySQL Error  : Unknown column 'level' in 'field list'

Error Number : 1054

Date         : Sunday, August 20th 2006 @ 02:43:12 PM

Script       : http://xxxxx.com/forums/vbsupport.php?do=viewthread&tid=2

Referrer     : http://xxxxx.com/forums/vbsupport.php?do=newthread

IP Address   : xxxxx

Username     : xxxx

Classname    : vB_Database

any idea's?

Cajun

08-20-2006 10:51 PM

Quote:

Originally Posted by Dark Riku

Code:

Database error in vBulletin 3.6.0:



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 vbvbs_ticket_post AS post

                LEFT JOIN vbuser AS user ON(user.userid = post.userid)

                LEFT JOIN vbuserfield AS userfield ON(userfield.userid = user.userid)

                LEFT JOIN vbusertextfield AS usertextfield ON(usertextfield.userid = user.userid)

                

                LEFT JOIN vbavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vbcustomavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN vbreputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)

                WHERE post.postid IN (0,2)

                        

                ORDER BY post.dateline;



MySQL Error  : Unknown column 'level' in 'field list'

Error Number : 1054

Date         : Sunday, August 20th 2006 @ 02:43:12 PM

Script       : http://xxxxx.com/forums/vbsupport.php?do=viewthread&tid=2

Referrer     : http://xxxxx.com/forums/vbsupport.php?do=newthread

IP Address   : xxxxx

Username     : xxxx

Classname    : vB_Database

any idea's?

Did you do a upgrade from 3.5.4? Looks like this happens only when you upgrade from vb 3.5.4. If you did a freash install of vb 3.6 you would not get this problem. I also have this same problem and can not find any help with the problem yet. I then the designer of the script is having computer problems at this time.

Cajun

08-21-2006 02:23 AM

Ok it look like this line:

Code:

foreach($vbulletin->vbs_admin AS $userid => $user)

in vbsupport.php and /admincp/vbsupport.php is what is causing the problem with people that upgrade from vb3.5 to vb 3.6.

Quarterbore

08-22-2006 02:22 PM

Can someone verify that if I did this with a fresh install of vB 3.6 Gold that this should work? I want to give this a try but I am anxious about any possible problems...

Thanks!

Cajun

08-22-2006 02:54 PM

I have installed this mod 3 times on my test site with a fresh install of vB 3.6 and it worked every time. I only get this problem on a upgrade to vB3.6.

Quarterbore

08-22-2006 04:48 PM

OK, I have installed it in a fresh install of 3.6 and it works good but I did find one rather significant bug. If an Admin deletes a classified, when one of the other staff clicks the link in the PM or E-mail they will get an ugly MYSQL error:

Quote:

Database error in vBulletin 3.6.0:

Invalid SQL:

SELECT postid
FROM PREFIXvbs_ticket_post AS post
WHERE threadid =
AND visible = 1
ORDER BY dateline
LIMIT 0, 10;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND visible = 1
ORDER BY dateline
LIMIT 0, 10' at line 4
Error Number : 1064
Date : Tuesday, August 22nd 2006 @ 12:41:53 PM
Script : http://www.MYDOMAIN.com/forums/vbsup...ewthread&tid=5
Referrer : http://www.MYDOMAIN.com/forums/priva...wpm&pmid=10490
IP Address : my ip address
Username : Quarterbore
Classname : vb_database

EDIT - HERE IS THE FIX FOR THE ABOVE ERROR (at least this works for me)

Open vbsupport.php

Find:

Code:

                // get the postids for this thread

                $getpostids = $vbulletin->db->query_read("

                        SELECT postid

                        FROM " . TABLE_PREFIX . "vbs_ticket_post AS post

                        WHERE threadid = $threadid

                                AND visible = 1

                        ORDER BY dateline

                        LIMIT $limitlower, $perpage

                ");

Before Add:

Code:

        if(empty($threadid)){

        eval(standard_error(fetch_error('vbsupport_thread_notexists')));

        }

Next, create phrase in vBulletin:

type: Error
Product: vBSupport
varName: vbsupport_thread_notexists
text: The requested ticket does not exist in the system. It is possible that the ticket has been deleted by an Admin.

Solves this issue on my site!

Quarterbore

08-22-2006 05:09 PM

OK, I found one more issue... Unregistered or People not logged in are not able to use this system on my board...

I have set the vBSupport for Unregistered to "Yes" and I have the given Unregistered group the appropriate permissions but I get a "No Permissions" error still...

EDIT FOR UPDATE:

When I set the Admin setting to "No" for allowing Unregistered users with the usergroup setting to "YES" to "Can Create Tickets", unregisteerd people can access the trouble Ticket System BUT on my board it is allowing them to see tickets entered by other members (or at least a test ticket I listed by my Admin account). So, I am confused but this looks like two seperate bugs affecting unregistered users in 3.6

RMS-Chef

08-23-2006 08:28 PM

I am hoping it is just a hook location change with v3.6 or something easy. Not sure how to replace this hack.

By not requiring a category seems to allow new tickets to be created even with the "foreach()" error.

CypherSTL

08-24-2006 11:47 PM

There is an error when installing on vB3.6.0, the error is when doing the navbar templete edit, other than that it does install, but and unable to access the ticket system.

This is the error I get when editing the navbar:

Code:

The following error occurred when attempting to evaluate this template:



Parse error: syntax error, unexpected T_CHARACTER, expecting ']' in /home/excalibu/public_html/testforum/includes/adminfunctions_template.php(3593) : eval()'d code on line 101



This is likely caused by a malformed conditional statement. It is highly recommended that you fix this error before continuing, but you may continue as-is if you wish.

Fixed where I could access the ticket system but get error when creating a ticket:

Code:

Database error in vBulletin 3.6.0:



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,14)

                        

                ORDER BY post.dateline;



MySQL Error  : Unknown column 'level' in 'field list'

Error Number : 1054

Date         : Thursday, August 24th 2006 @ 08:21:52 PM

Script       : http://www.excalibursystems.net/testforum/vbsupport.php?do=viewthread&tid=6

Referrer     : http://www.excalibursystems.net/testforum/vbsupport.php?do=newthread

IP Address   : xxx.xxx.xxx.xxx

Username     : Perry

Classname    : vb_database

although when I go back into the ticket system the ticket is there, and get another error when I click on the ticket itself:

Code:

Database error in vBulletin 3.6.0:



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,13)

                        

                ORDER BY post.dateline;



MySQL Error  : Unknown column 'level' in 'field list'

Error Number : 1054

Date         : Thursday, August 24th 2006 @ 08:23:44 PM

Script       : http://www.excalibursystems.net/testforum/vbsupport.php?do=viewthread&tid=5

Referrer     : http://www.excalibursystems.net/testforum/vbsupport.php

IP Address   : xxx.xxx.xxx.xxx

Username     : Perry

Classname    : vb_database

the excact same applies to upgrade from 1.1 and even a fresh install of 3.6.0. and version 2.0

CypherSTL

08-25-2006 05:19 AM

I fixed my issue, what I did was ignore the part of the instructions that mentioned to edit the "navbar" template, instead of useing the edit in version 2.0 I used the "navbar" edit in 1.1, this stopped the error I was getting when doing the edit and also stopped all other errors.

To get this plugin to work:
1. Upload all the from 2.0
2. import the product
3. use the following template edits:

Template Edits:

A) In Template navbar

Find:

Code:

                <if condition="$show['member']">

                        <td class="vbmenu_control"><a href="usercp.php$session[sessionurl_q]">$vbphrase[user_cp]</a></td>

                </if>

Replace With:

Code:

                <if condition="$show['member']">

                        <td class="vbmenu_control"><a href="usercp.php$session[sessionurl_q]">$vbphrase[user_cp]</a></td>

                        <td class="vbmenu_control"><a href="vbsupport.php$session[sessionurl_q]">vBSupport</a></td>

                </if>

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>

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

Quarterbore

08-25-2006 07:48 PM

Sorry, I forgot to post that I had the same issue as above with my 3.6 install...

Now, can I make a suggestion for an addition to this sript?

I have two big additions I would love to see:

One: If the person entering the trouble ticket is UNREGISTERED or perhaps not logged in, I would love to have a manditory field for them to add their e-mail address. The e-mail address could then be merged into the "POST" but too often we don't have a way to contact a person that enters a trouble ticket if we don't force them to give us a way.

Two: Add a option for users to receive an e-mail or PM or both or none (their choice) when an update is added to their trouble ticket. This way they will know when it has been updated. The notice should also likely include when the ticket is closed or deleted.

Lastly, I still have not figured out how to let unregistered users use this... I have not had a lot of time to work through all the code however...

lovejoy

08-26-2006 09:17 PM

Quote:

Originally Posted by Cajun

Same problem in here. The only solution for it to work until somebody can fix it is setting the "Categories Required for New Tickets?" field to no :(

At least you can use the VBSupport.

::LoVejoY::

Quarterbore

08-27-2006 10:13 AM

I was working on the code a little and I think there might be a couple bugs still...

When a new Ticket is entered by one of my members, I get a PM that says:

Quote:

Support Ticket Updated: Another test

--------------------------------------------------------------------------------

The support ticket has been replied to by testaccount.

Please click here to view the ticket

All the best,
Timeshare Forums

Shouldn't this PM have a subject or "NEW Support Ticket" with the text inside the PM saying "A new support ticket has been entered by ..."

I looked and there are no such phrases! I also checked the vBsupport.php file and in fact in the notify staff area it does use these "Update" phrases as opposed to a "New"!

So, I created two new phrases:

Phrase 1:
Phrase Type: vb_Support Phrases
Product: vbSupport
Varname: vbsupport_pm_new_message
Text (Note spacing matters below - ask me how I found out:

PHP Code:


		
			
A new support ticket has been submitted by {1}. 

[url={2}]Please click here to view the ticket[/url] 



All the best, 

{3}

Phrase 2:
Phrase Type: vb_Support Phrases
Product: vbSupport
Varname: vbsupport_pm_new_title
Text: New {1} {2} Added: {3}

Next, find:

PHP Code:


		
			
                {

                    // send a private message to the user

                    $pmtitle = construct_phrase($vbphrase['vbsupport_pm_update_title'], $vbphrase['vbsupport_title'], $vbphrase['vbsupport_ticket'], $newpost['title']);

                    $pmtext = construct_phrase($vbphrase['vbsupport_pm_update_message'], $vbulletin->userinfo['username'], $vbulletin->options['bburl'] . $linkurl, $vbulletin->options['bbtitle']);

                    vbsupport_send_pm(0, $touser, $pmtitle, $pmtext);

                }

Replace with:

PHP Code:


		
			


                // check if it should send a pm

                if (in_array($userid, $pmids))

                {

                    // send a private message to the Site Staff

                    $pmtitle = construct_phrase($vbphrase['vbsupport_pm_new_title'], $vbphrase['vbsupport_title'], $vbphrase['vbsupport_ticket'], $newpost['title']);

                    $pmtext = construct_phrase($vbphrase['vbsupport_pm_new_message'], $vbulletin->userinfo['username'], $vbulletin->options['bburl'] . $linkurl, $vbulletin->options['bbtitle']);

                    vbsupport_send_pm(0, $touser, $pmtitle, $pmtext);

                }

This is what the above generated for me!!!

New Support Ticket Added: Another trouble ticket test

--------------------------------------------------------------------------------

A new support ticket has been submitted by Site Staff.

Please click here to view the ticket

All the best,
Quarterbore

-------------------------------------------------------------------------------------------------
//////////// Next Issue \\\\\\\\\
-------------------------------------------------------------------------------------------------

Also, when an Admin or Mod does reply to a ticket the member that started the ticket is not getting a PM. I looked at the code and it looks like the code is written to do this...

See following in vbsupport.php:

PHP Code:


		
			
// check if it should send a private message

        if (($threadinfo['postuserid'] != $vbulletin->userinfo['userid']) && $threadinfo['replynotice'])

        {

            // fetch the $userinfo for this user

            $touser = fetch_userinfo($threadinfo['postuserid']);



            // build the $linkurl

            $touser['repliedby'] = $vbulletin->userinfo['username'];

            $linkurl = "/vbsupport.php?do=viewthread&tid=" . $threadinfo['threadid'];



            // check if it should send a pm

            if ($threadinfo['replynotice'] & 1)

            {

                // send a private message to the user

                $pmtitle = construct_phrase($vbphrase['vbsupport_pm_update_title'], $vbphrase['vbsupport_title'], $vbphrase['vbsupport_ticket'], $threadinfo['title']);

                $pmtext = construct_phrase($vbphrase['vbsupport_pm_update_message'], $vbulletin->userinfo['username'], $vbulletin->options['bburl'] . $linkurl, $vbulletin->options['bbtitle']);

                vbsupport_send_pm(0, $touser, $pmtitle, $pmtext);

             }



            // check if it should send an email

            if ($threadinfo['replynotice'] & 2)

            {

                // set the $title used in the email subject

                $emailtitle = $threadinfo['title'];



                // send an email to the user

                eval(fetch_email_phrases('ticketreplied', $touser['languageid']));

                vbmail($touser['email'], $subject, $message, true);

            }

        }

Now, when I change the above to as follows, the person that posts the trouble ticket gets a PM when a reply is posted!

PHP Code:


		
			
        // check if it should send a private message

        if ($threadinfo['postuserid'] != $vbulletin->userinfo['userid'])

        // if (($threadinfo['postuserid'] != $vbulletin->userinfo['userid']) && $threadinfo['replynotice'])

        {

            // fetch the $userinfo for this user

            $touser = fetch_userinfo($threadinfo['postuserid']);



            // build the $linkurl

            $touser['repliedby'] = $vbulletin->userinfo['username'];

            $linkurl = "/vbsupport.php?do=viewthread&tid=" . $threadinfo['threadid'];



            // check if it should send a pm

            // if ($threadinfo['replynotice'] & 1)

            // {

                // send a private message to the user

                $pmtitle = construct_phrase($vbphrase['vbsupport_pm_update_title'], $vbphrase['vbsupport_title'], $vbphrase['vbsupport_ticket'], $threadinfo['title']);

                $pmtext = construct_phrase($vbphrase['vbsupport_pm_update_message'], $vbulletin->userinfo['username'], $vbulletin->options['bburl'] . $linkurl, $vbulletin->options['bbtitle']);

                vbsupport_send_pm(0, $touser, $pmtitle, $pmtext);

            // }



            // check if it should send an email

            if ($threadinfo['replynotice'] & 2)

            {

                // set the $title used in the email subject

                $emailtitle = $threadinfo['title'];



                // send an email to the user

                eval(fetch_email_phrases('ticketreplied', $touser['languageid']));

                vbmail($touser['email'], $subject, $message, true);

            }

        }

So, this tells me that in vB 3.6 that the value of $threadinfo['replynotice'] is not "1" but I have no idea where that is set.... I want members to get a PM when their ticket is updated anyways so this works but I guess I should conditional out unregistered guests "userid = "0"" as I am not sure what that will cause... But, given unregistereds can not use the system yet I will waite on an update...

-------------------------------------------------------------------------------------------------
//////////// Next Issue \\\\\\\\\
-------------------------------------------------------------------------------------------------

There is no code in the script that will notify the staff when a member comes back and updates their ticket (or if it is there it doesn't work on my site and I don't see the code to do this).

EDIT - I did the code as in the following post!

Thanks!

Quarterbore

08-27-2006 11:24 AM

Following is the code needed to allow a PM to the appropriate members of the staff when the member comes back and replies to their trouble ticket! It is working on my site!

Before:

Code:

                // ### NOT PREVIEW - ACTUAL POST ###

                if ($vbulletin->GPC['ajax'])

                {

Add:

PHP Code:


		
			




        // check if it should send a private message to staff

        if ($threadinfo['postuserid'] == $vbulletin->userinfo['userid'])

        {



            // build the $linkurl

            $touser['repliedby'] = $vbulletin->userinfo['username'];

            $linkurl = "/vbsupport.php?do=viewthread&tid=" . $threadinfo['threadid'];





    $threadid = $threadinfo['threadid'];





    $getthreadids = $vbulletin->db->query_read("

        SELECT categoryid

        FROM " . TABLE_PREFIX . "vbs_ticket_thread AS thread

        WHERE threadid = $threadid

        LIMIT 1

    ");





    while ($thread = $vbulletin->db->fetch_array($getthreadids))

    {

        $categoryid = $thread['categoryid'];

    }





        // build the $emailids

        $pmids = explode(',', $vbulletin->vbs_category["$categoryid"]['adminpmusers']);

        $emailids = explode(',', $vbulletin->vbs_category["$categoryid"]['adminemailusers']);









            // check for PM notifications

            if (is_array($pmids))

            {

                // process add admins

                foreach($vbulletin->vbs_admin AS $userid => $user)

                {

                    // fetch the $userinfo for this user

                    $touser = fetch_userinfo($userid);

    

                    // build the $linkurl

                    $touser['repliedby'] = $vbulletin->userinfo['username'];

                    $linkurl = "/vbsupport.php?do=viewthread&tid=" . $threadid;

    

                    // check if it should send a pm

                    if (in_array($userid, $pmids))

                    {

                    // send a private message to the staff

                    $pmtitle = construct_phrase($vbphrase['vbsupport_pm_update_title'], $vbphrase['vbsupport_title'], $vbphrase['vbsupport_ticket'], $threadinfo['title']);

                    $pmtext = construct_phrase($vbphrase['vbsupport_pm_update_message'], $vbulletin->userinfo['username'], $vbulletin->options['bburl'] . $linkurl, $vbulletin->options['bbtitle']);

                    vbsupport_send_pm(0, $touser, $pmtitle, $pmtext);

                    }



                }

            }

        }

There may well be a better way to code this but it works on my site now... This took a lot of time for me to figure out... WOW! Also note I ONLY coded PMs as that is all I am using on my site!

Quarterbore

08-27-2006 01:34 PM

There is still another bug in the script... If you get enough replies to a ticket that it goes to multiple pages there are links off of the main vBsupport page. This main page link looks like the attached image and it takes us to URLs as follow:

http://www.mydomain.com/forums/showthread.php?t=10
http://www.mydomain.com/forums/showt...hp?t=10&page=2
http://www.mydomain.com/forums/showt...hp?t=10&page=3

These should go to urls as follow:

http://www.mydomain.com/forums/vbsup...wthread&tid=10
http://www.mydomain.com/forums/vbsup...&tid=10&page=2
http://www.mydomain.com/forums/vbsup...&tid=10&page=3

Quarterbore

08-27-2006 06:01 PM

Another bug... Can other people edit tickets?

When I click "edit" on a ticket I get taken to an empty window... I guess I will just disable the option to edit tickets for now but it is kind of ugly...

Code Monkey

08-27-2006 06:09 PM

Has CMX_CMGSCCC left the scene?

Quarterbore

08-27-2006 06:42 PM

Quote:

Originally Posted by Code Monkey

Has CMX_CMGSCCC left the scene?

According to his profile he has not been logged in since: Last Activity: 13. Jul 2006 20:10

That is why I spent the past two days fixing what I wanted myself... I need a trouble ticket system and fixing this one is easier then coding my own! I have not had a good run with waiting developers to fix things lately... :cool:

Cajun

08-27-2006 08:02 PM

I wish I could get this mod to work on my site. I am need of a working support ticket system for my xbox gaming site.

Code Monkey

08-27-2006 09:11 PM

Quote:

Originally Posted by Quarterbore

That's odd since he has always been known for outstanding support. I see on his site he mentions something about computer woes.

Quarterbore

08-28-2006 11:42 AM

Other then I can not use it with unregistered people and with the outstanding bugs I posted above, it is working great on my site...

I am using a fresh install of v3.6 and I have addeq quite a few mods now...

Quarterbore

09-01-2006 07:22 PM

I really wish we could get a couple of these fixed....

Quarterbore

09-08-2006 05:00 PM

I have another feature request for this mod... can we add a way to allow a Staff member to create a help ticket for another member (Say Admins and Supermods)?

Hornstar

09-15-2006 02:25 AM

Quote:

Originally Posted by Quarterbore

I have another feature request for this mod... can we add a way to allow a Staff member to create a help ticket for another member (Say Admins and Supermods)?

I have noticed you have fixed quite a few bug fixes. Any chance you could release your updated version in 1 plugin? and would that one be working in vb3.6.1?

I wonder where cmx has gone, I think a few of this products need updating.

Derekclarke

09-18-2006 12:17 PM

Can anyone help with this,

Just done a fresh forum install using 3.6.1 and when i try to implement the Navbar template change i get the following error.

Quote:

The following error occurred when attempting to evaluate this template:

Parse error: syntax error, unexpected T_CHARACTER, expecting ']' in /home/clarkoss/public_html/includes/adminfunctions_template.php(3593) : eval()'d code on line 102

This is likely caused by a malformed conditional statement. It is highly recommended that you fix this error before continuing, but you may continue as-is if you wish.

DS MrSinister

09-19-2006 03:10 AM

try this for the navbar

PHP Code:


		
			
            <if condition="$vboptions['vbsupport_enabled']"><td class="vbmenu_control"><a href="vbsupport.php$session[sessionurl_q]">$vbphrase[vbsupport_title]</a></td></if>

chefsache

09-20-2006 08:13 PM

Hi @all

my english is not so good but i?ll hope you understand my question ;)

I found nothing when i searched this thread....

but ss it possible to view the open tickets on forumhome?

Thanks
Andreas

Quarterbore

09-21-2006 01:52 AM

Quote:

Originally Posted by hornstar1337

I may but I am struggling with too many projects and too little time myself... I have fixed what is posted above but I made a lot of vixes to vbplaza/vbbux too... It really is a shame that these scripts are just not getting finished or debugged.

If I start a new thread with the fixes I am sure I will hear about it...

mschvili

09-23-2006 10:47 PM

Quote:

Originally Posted by PcGamer

I have two problems.

I've installed vBsupport 2.0.0 B2, (fresh install).

1. All tickets are blank. Tickets can be created and I can see the tickets... but when I click on them to view... the ticket is blank.... no text between the "New Reply" buttons.

and

2. I get this error when replying to the ticket.

Any help is appreciated...

I have the same problem as PcGamer. And been having it for a couple of weeks now. Would be so greatful if anyone had the solution.

Matti.

mschvili

09-23-2006 11:28 PM

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:

PHP Code:


		
			
SELECT post.postid, IF(post.userid = 0, post.username, user.username) AS username,

post.pagetext, post.allowsmilie, post.userid, post.dateline

FROM " . TABLE_PREFIX . "vbs_ticket_post AS post

LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = post.userid)

WHERE post.visible = 1

    $globalignore

    AND post.threadid = $threadinfo[threadid]

ORDER BY dateline DESC, postid DESC

LIMIT " . ($vbulletin->options['maxposts'] + 1)

$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?

Chicago_VLNU_4s

09-29-2006 05:24 PM

the sidebar isn't showing up in ACP.....????

JamieLee2k

09-30-2006 09:26 AM

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.

codemoxie

10-02-2006 02:00 PM

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

CypherSTL

10-02-2006 09:00 PM

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

All times are GMT. The time now is 09:45 AM.

Page 11 of 16

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02708 seconds Memory Usage 2,020KB 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 (15)bbcode_code_printable (8)bbcode_php_printable (13)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (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: