vBSupport v2.0.0 Beta 2

[Xplorer4x4]

Bitfield support

download this
https://vborg.vbsupport.ru/showpost.php?p=851785&postcount=215

and upload it to your includes\xml folder, then refresh the admincp

Works like a champ

Thanks

[TeaTree]

Okay I may sound totally stupid but how do I set permissions for it? As the options in cpanel only have four options and when I got to the forum and click on Add category it does you dont have permission to add a category :surprised:

[Kmaster]

Small bug:

When UPDATE a ticket, if both "Close/Open ticket" AND "Assignment" AND Category are checked, only one of them work.

I'd remove the standard_redirect in the following sections:
if ($vbulletin->GPC['closeticket'])
if ($vbulletin->GPC['openticket'])
if ($vbulletin->GPC['assignedtechid'] != $ticket['assignedtechid'])

// $_REQUEST['do'] = 'newreply';
$vbulletin->url = 'vBSupport.php?' . $vbulletin->session->vars['sessionurl_q'] . 'do=showticket&ticketid=' . $vbulletin->GPC['ticketid'];
eval(print_standard_redirect('support_rebuilt_info '));

Also, the $_REQUEST['do'] = 'newreply'; need to be replaces by

// $_REQUEST['do'] = 'newreply';
$vbulletin->url = 'vBSupport.php?' . $vbulletin->session->vars['sessionurl_q'] . 'do=showticket&ticketid=' . $vbulletin->GPC['ticketid'];
eval(print_standard_redirect('support_rebuilt_info '));


otherwise, there'll be alot of templates not cached.


Also, Close/Open and Delete ticket can not be check both at the same time. if you delete ticket, close and open mean nothing, so, you may just want to make it Radio or dropdown instead of checkboxes



In tickets list, only those who have permission to delete ticket can see the delete selected ticket options
Should have additional options to open/close tickets there, for those who has permission to mass close/open tickets.


I hope mtha can show a way how to make "In tickets list, only those who have permission to delete ticket can see the delete selected ticket options"

Thanks in advacne

[Kmaster]

Using vB 3.50 and the latest version (v1.0) of the mod, i get the following message everytime anyone tries to post an attachment:

"Invalid Post specified. If you followed a valid link, please notify the administrator"

I also have the PM attachments hack installed, where i changed $_pmt = 1 to a particular locked thread on the forum, so attachments could be sent. Can i do the same here, and if so where do i find the correct bit of code?

EDIT: nevermind, just edited a threadid to 1 in mysql db to get around it :)

It seem I got same prolbem like you, can you share how get this solve?

[ndahiya]

Wonder if this can be extended to process Emails as well ? (eg: email based support questions to a pre-specified email address)...

TIA.

[CMX_CMGSCCC]

I'm not sure how to set it up to receive emails as replies to the tickets, if some Advanced Coders have some ideas on how to do it, maybe it could be done.

Also, I'm looking into replacing the insert private message script with the Data Manager version.

As far as that bug in the attachments, I'm unable to replicate it, so I cant figure out what is causing that bug.

-CMX

[LiQuid ArroW]

Great job, finally working properly for me ;).

[Kmaster]

thanks for updated.
is it possible add an feature for doing quick post reply at same time also closed the ticket by doing only one click, save my time come back again update ticket options.

[ndahiya]

I'm not sure how to set it up to receive emails as replies to the tickets, if some Advanced Coders have some ideas on how to do it, maybe it could be done.

-CMX


This hack (for an older version for vb) could process emails. maybe this can give you some idea ??

https://vborg.vbsupport.ru/showthread.php?t=77155

[akanevsky]

Very nice hack, installed.

[puertoblack2003]

upgrade with no proms...thanks :rolleyes:

[HO3R]

Great work bro

Will install this tomorrow, but will already click install ;)
Great work

Greetz

[CBE]

thank u for the very nice hack,,,
i have some quistion plzzz::

1- How can I turn of the private message for the support system (when there is a reply)
2- How can I make the post more then 5000 letters
3- i got this error if i enable the attachment to any usetgroup


Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE ticketreply SET attach=0 WHERE ticketreplyid=81;

MySQL Error : Unknown column 'attach' in 'field list'
Error Number : 1054
Date : Sunday, January 22nd 2006 @ 01:50:11 PM
Script : http://***************/vb/vBSupport.php
Referrer : http://***************/vb/vBSupport.php?do=newreply&noquote=1&ticketreplyid=80
IP Address :
Username : CBE
Classname : vb_database

[CBE]

no body gonna reply to us ???

[Derekclarke]

When i try to add Catagorys i get.

You are not authorized to manage ticket categories.

When i try to send a new ticket i get.

You are not authorized to create tickets.

I tryed the send ticket with a user (Not Admin) and still get the same.

Any suggestions.

I am using vb 3.5.3

[lanc3lot]

Go to your admincp, and add in your usergroup the right to make changes :)

[Derekclarke]

Sorted Thanks.

Is their a way for it to tell you how many tickets are still open or new next to the relevent text i.e list all tickets, list new tickets, List open tickets etc so it is easier to see if their are tickets awaiting help?

@ CMX_CMGSCCC

Can I change this so the bit in the Navbar says SWS Support.?

Thought id ask before doing it.

Thanks
Derek

[biagrin]

this is an amazing hack and its perfect for my site.

however if anybody could do a little extra code for me id be very grateful.

ill use an example: lets say there are 4 usergroups assigned to be working the support system. 1, 2, 3 and 4. in each group lets say there are 3 people. so thats 12 people working the support system. my question is how do you set it up so that when somebody opens a ticket for usergroup 2 then the ticket is automatically sent to one of the users in that group instead of each ticket having to be assigned indvidually.

if that cant be done how would i set it up so that the drop down menu displays which user group each support group member is part of. or even better - rather than having to go into each ticket individually to asign it - could i set it up so that a drop down box displaying the members in each support usergroup would be shown on the ticket title area and then mass processed by clicking assign at the bottom of the page

does any of that make any sense????

[Derekclarke]

hi,

when someone submits a ticket can it be set so the admin or a Mod gets a P.M informing that a Support ticket has been submitted.
Also when a ticket is assigned to a Mod, this could do with a P.M informing the Mod.

I thought as it was P.M Bassed it would do it as std, but i have tested it with a test username and it does not send a P.M

[biagrin]

i have a bit of a style problem.

on the vbsupport main page ( forum/vbsupport ) the list where the tickets appear is black because the code uses the table border for the colour. i need to keep the table border black otherwise the skin looks stupid so ho do i change where the vbsupport calls the colour from. (if that makes sense)

[Allan]

Thanks :)

click Install ;)

File Attach: French Language (By Nerilka)

[MorrisMcD]

Works for me except one small thing.. Not really minor though...

On the ticket list, I see everything fine, except, what should probably be buttons for actions, I only see one button without anything written in it.. When I click it, it deletes the ticket.. No button for closing or reassigning or whatever..

Any ideas?

[ndahiya]

Installed... Thanks!!!

but one small prob (?)

CMX_CMGSCCC : when a unregistered user creates a ticket, the ticket is visible to ALL unregistered users ??? Also, an unregistered user does not have an email address in the db, so can it ask for one ?

[ndahiya]

Feature Request: When there are tickets waiting, can there be a alert like the new PM alert on the mainpage??? will be greatly helpful to the mods.

[Bigasses]

Very nice, would be even nicer if it did a bit of email alerting when someone gets assigned a ticket.

[Derekclarke]

Very nice, would be even nicer if it did a bit of email alerting when someone gets assigned a ticket.


iirc this was suggested before, and it was said it would be difficult as the system is PM based.

However, i am sure one of the coders can do it so you recieve a PM and in turn a PM should send you an email alerting you of the PM.

I want this too as, i keep forgetting to check for tickets.

Derek

[Poggyuk]

When i turn on the unregistered access, it displays this messsage "You are not authorized to create tickets." - and thats when im logged in as an admin!

[mholtum]

Have you checked your usergroup permissions?

[MorrisMcD]

Works for me except one small thing.. Not really minor though...

On the ticket list, I see everything fine, except, what should probably be buttons for actions, I only see one button without anything written in it.. When I click it, it deletes the ticket.. No button for closing or reassigning or whatever..

Any ideas?

Does anyone have any ideas about my problem? I really want to use this :(

[---MAD---]

The phrase is in the error messages phrases

can you add some screen shots please?

[Diggazz]

Works for me except one small thing.. Not really minor though...

On the ticket list, I see everything fine, except, what should probably be buttons for actions, I only see one button without anything written in it.. When I click it, it deletes the ticket.. No button for closing or reassigning or whatever..

Any ideas?

I have this as well

Plus

I have setup a category assigned an admin

Now I would assume that this function is here so when that category is sellected that admin would have the ticked assigned to them

however even if a category is selected by the person raising the ticket its still sits in the system as unassigned

If im on the wrong track here can you please explain the usage of categories

Thanks in advance

[MorrisMcD]

I have this as well

Plus

I have setup a category assigned an admin

Now I would assume that this function is here so when that category is sellected that admin would have the ticked assigned to them

however even if a category is selected by the person raising the ticket its still sits in the system as unassigned

If im on the wrong track here can you please explain the usage of categories

Thanks in advance


He seems to have put this hack on the back burner.. But I cant complain.. He has been releasing features for the estore left and right.. If you end up figuring out the problem though, I am still having the issue.. :(

[Diggazz]

I found some radio buttons to close it just scroll down in the thread but yeah the button by itself with no name is dangerous seeing how it deletes the ticket

still no joy with assigning the ticket to the category admin though

and as a few others have requested some sort of notification that a ticket is created would be good

PM would be the best but email would do

Great hack but could be an Awesome one with a little polishing

[MorrisMcD]

I found some radio buttons to close it just scroll down in the thread but yeah the button by itself with no name is dangerous seeing how it deletes the ticket

still no joy with assigning the ticket to the category admin though

and as a few others have requested some sort of notification that a ticket is created would be good

PM would be the best but email would do

Great hack but could be an Awesome one with a little polishing

Yea.. I wonder if that is like that for everyone..

But as for your category issue.. I think that you have all tickets unassigned by default.. There needs to be a notification pm for this and it would rule.. And if a specific category is selected, it would be cool if it either a) defaulted to a user and b) radomiz or cycle through a usergroup...

That would be sweet...

Thanks for the heads up on where I can reassign these tix.. I will just keep the delete option off for the mods.. and I wont have to worry about the delete button

[AFMichael]

The delete button appears, but the value/text for this button is blank. Where would I go to correct this?

-see attached image-

[akanevsky]

Are there any screenshots for this?

[AFMichael]

I've corrected this problem by removing "$vbphrase[support_delete_selected_tickets]" and replacing it with "Delete"

[MorrisMcD]

I've corrected this problem by removing "$vbphrase[support_delete_selected_tickets]" and replacing it with "Delete"

Brilliant.. Just a missing phrase... I'm learning

To fix it another way, just add a phrase

Phrase Type: vBSupport Phrases
Product: vBSupport System
Varname: support_delete_selected_tickets
Text: Delete Selected Tickets

[Deimos]

Staff notification is a must imo
Is this going in at anytime?

[MorrisMcD]

Staff notification is a must imo
Is this going in at anytime?
Maybe you should slide that question in at the ebux thread... haha

He has been living there for awhile. I wouldnt expect much on this project until that slows down.

[creedmaniac]

I have this slight problem where i tend to read to far into things...so i was wondering if someone coculd help me out with exactly what all these option do?

IE...if i select yes for the first option...does that mean this group can do anything they want...or do i still need to select yes for the others?

Reply to own tickets...does this mean that this user can't reply to a moderators answer if i set to no?

This usergroup can Admin Support Tickets Yes No
Can Create Tickets Yes No
Can Reply to Own Tickets Yes No
Can Reply to All Tickets Yes No
Can Delete Own Tickets Yes No
Can Delete Any Tickets Yes No
Can Close Own Tickets Yes No
Can Close Any Tickets Yes No
Can Open Own Tickets Yes No
Can Open Any Tickets Yes No
Can Assign Tickets Yes No
Can Reassign Tickets Yes No
Can Post Attachments Yes No
Can View Attachments Yes No
Can Manage Categories Yes No
Can Update Ticket Category Type Yes No

[Smiry Kin's]

for admin, your self, and moderators if you trust them, select them all. for users, and unregistered people do

Can Create Tickets Yes
Can Reply to Own Tickets Yes
Can Open Own Tickets Yes

[MorrisMcD]

I noticed one little quirk about this hack..

When you get sent an update about a ticket, it checks the pop up notification option in usercp... Any ideas how to stop this?

[username12]

Nevermind. Guess rebuilding all plugins fixes all my woes.

[lanc3lot]

I think that without the pm feature, its useless for at least big forums like mine...
Pity :(

[Thanatos]

I just did the update and it seems like this isn't working for me.

It can't find any of the phrases. In the Settings Group under VBOptions, its all blank.

All the phrases are installed, it just doesn't seem to 'see' them and reports them as it can't find them.

Not sure how to proceeed. I have installed and uninstalled numerous times.

[Reeve of shinra]

Is anyone using this as a task manager for your staff?

[Diggazz]

Yes we use it as a todo list for staff as well as a support system

Its an excellent mod

It would be a brilliant mod if it had notification though

[Derekclarke]

i agree notification would change this from a Great Mod to a Superb mod.

had not thought of using it to task mods, but half of them do not check the support, so it would be no good without notification.

[apokphp]

Has anyone figured out how to stop the member's pm notification that they themself, replied to their own ticket?

I concur about needing STAFF notification...it's a must have for this feature in order for it to be as useful as it should. I didn't think that it would be that difficult to do though.

[bashy]

Hi

I have installed...
Looks great thanks

[bashy]

HI

Please help, this is not alerting admin or supermods?
How do i enable alerts please?

Also how does this sound....

When an unregistered user uses the system, they have to
include a name and email addy, if they dont they cant proceed?

[Overseer]

A couple of problems...probably my install...

This is a fresh VB install, nothing has been touched..
Everthing appears to install fine...no noticed errors
The usergroup does not appear, and because of that I am getting errors as admin that I don't have permissions to do anything related to the tickets.

I am green at all this so I think I can safely assume that I have done something wrong. Any direction would be appriciated.

[Xtrato]

Did you go to the Usergroups area and edit the permissions for the usergroups?

[Overseer]

One of the issues I am having is that the usergroups do not appear at all. I can't edit the permissions because I don't see them anywhere.

[vBSEO]

Very consistent with vB's native functionality. Amazing script. ~Installed @ vBSEO.com :)

Thanks!

[MorrisMcD]

attachments do not work on support tickets for me.. I get the following error...

Invalid Post specified. If you followed a valid link, please notify the administrator

[bashy]

Hi

Are we supposed to got an email or PM when a ticket has been posted?
If so its not working..

If not can this be implemented very soon?

[MorrisMcD]

Hi

Are we supposed to got an email or PM when a ticket has been posted?
If so its not working..

If not can this be implemented very soon?

Its been asked quite a few times... Its not part of the hack yet.. No response from the author... Who is probably too busy with vbplaza.. and I cant complain :D

[Hamma]

When a user creates a ticket for some reason it is sending a PM to myself (UserID 1) and User ID 2 - makes no sense? I have not entered 2 anywhere.

[creedmaniac]

When a user creates a ticket for some reason it is sending a PM to myself (UserID 1) and User ID 2 - makes no sense? I have not entered 2 anywhere.

at least you get a pm :D

[Hamma]

hehe - I removed the 3 userid's I had listed as the group admins and it stopped doing it.

[BrandiDup]

Installed and working perfectly.

Two features I would LOVE to see added:

Staff Notification
and
Unregistered Users must fill in at least an email address to proceed. It would be nice to have an extra spot for their username also (since I have a lot of current members who email me constantly about log in problems).


I'm anxious to see both things incoorporated but I can't complain that the author is spending so much time on vbPlaza because I'm enjoying that one quite a bit ;)

[Julie]

I did the uninstall in order for me to do a fresh install of this, but then when I go to edit a usergroup, the vbsupport part is still in there, only with no text, just the radio buttons... Then, if I try to save, I get this;

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE vb3_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'MV Jury Members',
`description` = '',
`usertitle` = 'MV Jury Member',
`opentag` = '<span style=\"font-weight: bold; color: green;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '1',
`canoverride` = '1',
`forumpermissions` = '774399',
`attachlimit` = '1000000',
`pmquota` = '50',
`pmpermissions` = '1',
`pmsendmax` = '5',
`calendarpermissions` = '49',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions` = '2628679',
`genericoptions` = '30',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '50',
`avatarmaxheight` = '50',
`avatarmaxsize` = '20000',
`supportpermissions` = '0',
`quickclip` = '0',
`quickclip_max_clips` = '0',
`quickclip_max_folders` = '0'
WHERE usergroupid=24;

MySQL Error : Unknown column 'supportpermissions' in 'field list'
Error Number : 1054
Date : Monday, March 20th 2006 @ 10:02:28 PM
Script : http://*****/admincp/usergroup.php
Referrer : http://***/admincp/usergroup.php?do=edit&usergroupid=24
IP Address : **
Username : Julie
Classname : vb_database

Anyone know how to fix this? Where can I find the usergroup template thing so I can remove it completely?

[fluentdesigns]

I uninstalled this mod and now I am getting this error in my email every day.

Invalid SQL:

SELECT languageid,
phrasegroup_support AS phrasegroup_support,
phrasegroup_posting AS phrasegroup_posting,
phrasegroup_postbit AS phrasegroup_postbit,
phrasegroup_global AS phrasegroup_global,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_support' in 'field list'
Error Number : 1054
Date : Monday, March 20th 2006 @ 02:36:42 PM
Script : http://www.planetminis.com/vBSupport.php

[RMS-Chef]

Great product so far, thanks.

Does this log IP addresses like regular forum posts do?
Would be a great addition if it does not.

[dboogie2288]

Howdy-

Quick question, I was running vbsupport for a few months on 3.5.0, but when I upgraded to 3.5.4, all my vbsupport permissions are jacked. I can't even add categories or anything like that and I cant seem to find what I am missing on the ACP that I need to possibly reset. Any ideas??

Thanks!

<edit>
n/m I reuploaded my files manually and got it..thanks!

[Stone Cold 3:16]

Great product so far, thanks.

Does this log IP addresses like regular forum posts do?
Would be a great addition if it does not.

Why would you need that exactly?

[paulfletcher]

I've installed this system, but I'm not seeing this option. Can my support group assign themselves, and only themselves to the question... Like MacOSX.com If you see you can answer a question, you go ahead and assign your self to it (claim ownership)... Can this system do this?

Has there been any word from the Author whether he's going to update this Hack with new features?

Thanks,
Paul

[Julie]

I did the uninstall in order for me to do a fresh install of this, but then when I go to edit a usergroup, the vbsupport part is still in there, only with no text, just the radio buttons... Then, if I try to save, I get this;

(lots of mysql, look at page 8 for it)

Anyone know how to fix this? Where can I find the usergroup template thing so I can remove it completely?

I got it... Just deleted bitfields_support.xml from includes/xml/ ....

[gcphost]

paul I dont see an option to assign tickets, 2 things im really interested are that and the ability to e-mail a support email to create new tickets.

[paulfletcher]

If the ticket is assigned to a tech person, the tech person will receive an email when the person needing help responds... The person needing help will also receive a P/M if they choose the notification option... Did this answer your question?

Thanks,
Paul

[TKlingler]

Hello, a gerat Hack.

I have made a translation into germany.

If sombody find a mistake pleas contact me.

In the ZIP-File is only the tranlated xml File

[sydude]

None of the usergroup settings seem to be working with 3.5.1

Checking or unchecking the "Allowed Usergroups" and "Allowed Technician Usergroups" makes no difference whatsoever in who is allowed to submit tickets or reply to tickets or have tickets assigned to them or any of the other functions associated with ticket processing.
I'm having the same problem. It doesn't matter what usergoup or technician usergroup I assign to a category, every usergroup can see it and use it. Can someone please help me with what I should do to get this function to work correctly? It's a great feature that is instrumental for my use.

Thanks.

Sy

[gavinzac]

I've installed this system, but I'm not seeing this option. Can my support group assign themselves, and only themselves to the question... Like MacOSX.com If you see you can answer a question, you go ahead and assign your self to it (claim ownership)... Can this system do this?

Has there been any word from the Author whether he's going to update this Hack with new features?

Thanks,
Paulyes, you can assign yourself or others to the tickets. under the post there should be options to allow you to do this, alongside options to close or delete the ticket.

[kofoid]

GREEEEAAAAT HACK, AGAIN!!! CMX you rock!

I am getting the following error when I try to view a ticket:
Fatal error: vB_Postbit_Factory::fetch_postbit(): Invalid postbit type. in /includes/class_postbit.php on line 142

Any ideas?

[sydude]

Is MTHA still helping out on this hack? It would be greatly appreciated if someone could help me with my problems. This is a great hack, it would be a shame to stop its development now.

Thanks

S

[KenB]

Suggestion - Is there anyway to allow the admin to reply with an attachment? Sometimes users need a new updated file from me and I need to reply with that file.

Working good otherwise!

Ken

[kurtbarker]

is there any support for this hack? coz I have a question...

I use the red2black skin, and the messages , for example "There are currently no tickets to view." are in black text, and I can't see it because the background in this skin is black...

So, is there any way to change the colour on that text on a particular skin, or globally on all skins?

Thanks

[CMX_CMGSCCC]

EDIT: CUT OFF POINT FOR SUPPORT FOR vBSupport v1.1

All support issues I will be addressing will need to pertain to vbSupport v2.0.0!

-CMX

[Cajun]

I just updated to vbSupport v2.0.0. Now I can not reply to any ticket. Users can post a ticket but my support team can not reply to them. All the usergroup settings are updated.

Also quick reply is not working for the support ticket and has also stopped working in the fourms.

I removed the file: vbulletin_quick_ticket_reply.js and the quick reply started working on the ticket system but not the forums.

What could be causing this problem?

Thanks

[Chris M]

Just a note to the author - Its usually best not to include a version number in the thread title, so if you'd like to PM me the title you wish to change it to (I've changed it to vBsupport v2.0.0 Beta 1) for now I will change it to the new title :)

Chris

[kurtbarker]

I only just installed the old version a day or 2 ago... I might give it a while before updating to see if anyone has probs

[CMX_CMGSCCC]

I just updated to vbSupport v2.0.0. Now I can not reply to any ticket. Users can post a ticket but my support team can not reply to them. All the usergroup settings are updated.

Also quick reply is not working for the support ticket and has also stopped working in the fourms.

I removed the file: vbulletin_quick_ticket_reply.js and the quick reply started working on the ticket system but not the forums.

What could be causing this problem?

Thanks

Did u set up the permissions for all the usergroups? There are a lot of settings in the Usergroup Manager. Also, try to do Admin CP -> vbSupport Maintenance -> Rebuild Datastore as well. If it's still not working, it must be an obscure bug that I have overlooked. I would be interested in getting it fixed. Which part does it fail at for them and does it give an error message? If so, what does it say.

As far as the quick reply, it should require that file to be there. It sounds like it could be something I've overlooked too.

Just a note to the author - Its usually best not to include a version number in the thread title, so if you'd like to PM me the title you wish to change it to (I've changed it to vBsupport v2.0.0 Beta 1) for now I will change it to the new title :)

Chris

I tried to do it, but there was no place for me to edit it. I changed it when doing "Edit Modifications", but it did not save the new thread title.

I even reported the issue by using the report link that I probably wasnt supposed to as well lol

I figured one of the hacks was making it so it didnt update properly inside of the "thread" table.

-CMX

[Cajun]

Did u set up the permissions for all the usergroups? There are a lot of settings in the Usergroup Manager. Also, try to do Admin CP -> vbSupport Maintenance -> Rebuild Datastore as well. If it's still not working, it must be an obscure bug that I have overlooked. I would be interested in getting it fixed. Which part does it fail at for them and does it give an error message? If so, what does it say.

As far as the quick reply, it should require that file to be there. It sounds like it could be something I've overlooked too.



1. Yes all usergroup premissions are set.

2. Yes Rebuild Datastore.

Do not even see a reply button in any support ticket just quick reply. And the only way quick reply works is to remove the vbulletin_quick_ticket_reply.js file.



Thanks

[Cajun]

Ok found the problem with support ticket quick reply. If you have the Quick Reply option set to Yes - Click Required in the vb admin control panel under Message Posting and Editing Options this will happen.

If you change the setting to: Yes - Click Not Required then it works ok.

Now the reply button is still missing in the ticket system.

[RMS-Chef]

I am having issues with categories. I have upgraded from the previous version.

I can add cats. I cannot delete cats. Also as a work around, I tried setting all usergroups as denied for a category yet I and regular registered users can still view the category as an option. Also, when setting the display order of the cats they still seem to be sorted by creation ID on the front end.

Second, when using AJAX quick edit, when I hit the EDIT button, I get an error type popup the the text "67" in it? I click OK and the quick edit editor displays as it should.

Third, I am not sure what the Yes/No drop down for each category is for. I assumed it was to set if that category is active but it seems to have no effect.

Fourth, thanks for the hack.

[dilbert]

This looks like a terrific tool.

I installed it and got an error. I uploaded a new set of files and imported the product again, and still I can't post a new ticket.

I get this error:

Invalid SQL:

SELECT post.postid, IF(post.userid = 0, post.username, user.username) AS username,
post.pagetext, post.allowsmilie, post.userid, post.dateline
FROM vb3_vbs_ticket_post AS post
LEFT JOIN vb3_user AS user ON(user.userid = post.userid)
WHERE post.visible = 1

AND post.threadid =
ORDER BY dateline DESC, postid DESC
LIMIT 41;

Is there a know issue about this? I tried searching and it seems a few others had a similar problem, but I didn't see a fix for it anwhere.

Best regards,
Cliff

[mtha]

very good upgrade CMX,

few things to check:

1. the edit window is not aligned well in Firefox (see attachment)

2. In Manage Settings:
"Enter the email address you wish to have all of the Email's sent from. If you do not specify one, it uses your contact email address. (Default is 1)"

default is not 1.

3. dont think $vbphrase['active'] is a GLOBAL phrase, (not so sure, just dont display in my vB)

[Chris M]

Did u set up the permissions for all the usergroups? There are a lot of settings in the Usergroup Manager. Also, try to do Admin CP -> vbSupport Maintenance -> Rebuild Datastore as well. If it's still not working, it must be an obscure bug that I have overlooked. I would be interested in getting it fixed. Which part does it fail at for them and does it give an error message? If so, what does it say.

As far as the quick reply, it should require that file to be there. It sounds like it could be something I've overlooked too.



I tried to do it, but there was no place for me to edit it. I changed it when doing "Edit Modifications", but it did not save the new thread title.

I even reported the issue by using the report link that I probably wasnt supposed to as well lol

I figured one of the hacks was making it so it didnt update properly inside of the "thread" table.

-CMX
The ability to edit a thread title expires after a certain period of time, which is why we suggest not having a version number in the thread title :)

Chris

[CMX_CMGSCCC]

Ok found the problem with support ticket quick reply. If you have the Quick Reply option set to Yes - Click Required in the vb admin control panel under Message Posting and Editing Options this will happen.

If you change the setting to: Yes - Click Not Required then it works ok.

Now the reply button is still missing in the ticket system.

Thanx for figuring out the issue, I'll look into this very soon and I'll add the "reply" button without the quick reply in the next beta release.

I am having issues with categories. I have upgraded from the previous version.

I can add cats. I cannot delete cats. Also as a work around, I tried setting all usergroups as denied for a category yet I and regular registered users can still view the category as an option. Also, when setting the display order of the cats they still seem to be sorted by creation ID on the front end.

Second, when using AJAX quick edit, when I hit the EDIT button, I get an error type popup the the text "67" in it? I click OK and the quick edit editor displays as it should.

Third, I am not sure what the Yes/No drop down for each category is for. I assumed it was to set if that category is active but it seems to have no effect.

Fourth, thanks for the hack.

I'll check into the deletion of categories and see about a fix for Beta 2. The usergroups for allowed/denied do not function yet, that will be added again in the Beta 2 release. I forgot to do that part and then forgot until u just mentioned it that it needed going back to.. lol

Second, thats an "alert" box that was in the .js file, that will be removed in the Beta 2.

The Active I also will look into the issue as it sounds like its not working.

This looks like a terrific tool.

I installed it and got an error. I uploaded a new set of files and imported the product again, and still I can't post a new ticket.

I get this error:

Invalid SQL:

SELECT post.postid, IF(post.userid = 0, post.username, user.username) AS username,
post.pagetext, post.allowsmilie, post.userid, post.dateline
FROM vb3_vbs_ticket_post AS post
LEFT JOIN vb3_user AS user ON(user.userid = post.userid)
WHERE post.visible = 1

AND post.threadid =
ORDER BY dateline DESC, postid DESC
LIMIT 41;

Is there a know issue about this? I tried searching and it seems a few others had a similar problem, but I didn't see a fix for it anwhere.

Best regards,
Cliff

Could you give a little more information? Did it say what PHP file/link this was coming from? If not, I could probably find it, but it would be easier to look into that way.

very good upgrade CMX,


few things to check:

1. the edit window is not aligned well in Firefox (see attachment)

2. In Manage Settings:
"Enter the email address you wish to have all of the Email's sent from. If you do not specify one, it uses your contact email address. (Default is 1)"

default is not 1.

3. dont think $vbphrase['active'] is a GLOBAL phrase, (not so sure, just dont display in my vB)

1) Yeah, I noticed that too, but I'm not sure what the problem is there.

2) That will be fixed in the next Beta 2.

3) I'll check into that as well.

The ability to edit a thread title expires after a certain period of time, which is why we suggest not having a version number in the thread title :)

Chris

Yeah, but its so much nicer having it there too hehe.

-CMX

[dilbert]

Could you give a little more information? Did it say what PHP file/link this was coming from? If not, I could probably find it, but it would be easier to look into that way.


Sorry about that, here is the whole error:


Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT post.postid, IF(post.userid = 0, post.username, user.username) AS username,
post.pagetext, post.allowsmilie, post.userid, post.dateline
FROM vb3_vbs_ticket_post AS post
LEFT JOIN vb3_user AS user ON(user.userid = post.userid)
WHERE post.visible = 1

AND post.threadid =
ORDER BY dateline DESC, postid DESC
LIMIT 41;

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 'ORDER BY dateline DESC, postid DESC
LIMIT 41' at line 8
Error Number : 1064
Date : Monday, May 8th 2006 @ 11:27:28 AM
Script : http://www.bloodbanktalk.com/forum/vbsupport.php
Referrer : http://www.bloodbanktalk.com/forum/vbsupport.php?do=newthread
IP Address : 170.223.146.48
Username : Cliff
Classname : vb_database

[mtha]

Sorry about that, here is the whole error:


Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT post.postid, IF(post.userid = 0, post.username, user.username) AS username,
post.pagetext, post.allowsmilie, post.userid, post.dateline
FROM vb3_vbs_ticket_post AS post
LEFT JOIN vb3_user AS user ON(user.userid = post.userid)
WHERE post.visible = 1

AND post.threadid =
ORDER BY dateline DESC, postid DESC
LIMIT 41;


I got that error twice, but I cant replicate it now,

Seems that the error is from line 1928, do=newreply, where $threadinfo[threadid] is empty.
Just dont understand why it got executed.

[mtha]

very good upgrade CMX,


few things to check:

1. the edit window is not aligned well in Firefox (see attachment)


Because you are missing a wrapping table outside messagearea
EDIT TEMPLATE: vbsupport_newthread

line 36-41

<!-- message area -->
<div class="smallfont">$vbphrase[message]:</div>
$messagearea
<!-- / message area -->

$posticons


REPLACE WITH


<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td>

<!-- message area -->
<div class="smallfont">$vbphrase[message]:</div>
$messagearea
<!-- / message area -->

$posticons

</td>
</tr>
</table>

[CMX_CMGSCCC]

Because you are missing a wrapping table outside messagearea
EDIT TEMPLATE: vbsupport_newthread

line 36-41

<!-- message area -->
<div class="smallfont">$vbphrase[message]:</div>
$messagearea
<!-- / message area -->

$posticons


REPLACE WITH


<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td>

<!-- message area -->
<div class="smallfont">$vbphrase[message]:</div>
$messagearea
<!-- / message area -->

$posticons

</td>
</tr>
</table>


BETA 2 Released now. Please read the Updates to identify the bugs fixed.

-CMX

[dxguru]

CMX ... A quick question about the Beta release.

Once the Beta is complete and v2 is released, will the upgrade process from v1.x be easier than v1.x >> Beta?

I would like to do the upgrade to the Beta to help out in testing, but have rather a lot on my plate at the moment :)

[Derekclarke]

went to upgrade from, 1.1 to beta 2, deleted all files from server, and uploaded all new ones, uploaded and over wrote the product.

all ok.

went to do the template mods, and on the first template i get the following message when i go to save the template.

The following error occurred when attempting to evaluate this template:

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

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.

any ideas?

[87accordlxi]

I get the same error as above. I replaced the navbar link with a generic link to get to vbsupport (I simply call it "Site Support" on my board):
<td class="vbmenu_control"><a href="vbsupport.php$session[sessionurl_q]">Site Support</a></td>

I went in, and all that came up was an error saying that I was not authorized to create tickets, even though I was just accessing the vbsupport main page, not creating a ticket.

I went into the settings and checked "Yes" for "vbSupport Unregistered Access." This allows me to get to the main vbsupport page and create tickets, but now I do not have permission to view the tickets once I've created them. I get a "87accordlxi, you do not have permission to access this page. This could be due to one of several reasons..."

[CMX_CMGSCCC]

CMX ... A quick question about the Beta release.

Once the Beta is complete and v2 is released, will the upgrade process from v1.x be easier than v1.x >> Beta?

I would like to do the upgrade to the Beta to help out in testing, but have rather a lot on my plate at the moment :)

It should be the same for the upgrade procedure.

went to upgrade from, 1.1 to beta 2, deleted all files from server, and uploaded all new ones, uploaded and over wrote the product.

all ok.

went to do the template mods, and on the first template i get the following message when i go to save the template.

The following error occurred when attempting to evaluate this template:


any ideas?

Which template edit were u doing when u got this error?

I get the same error as above. I replaced the navbar link with a generic link to get to vbsupport (I simply call it "Site Support" on my board):
<td class="vbmenu_control"><a href="vbsupport.php$session[sessionurl_q]">Site Support</a></td>

I went in, and all that came up was an error saying that I was not authorized to create tickets, even though I was just accessing the vbsupport main page, not creating a ticket.

I went into the settings and checked "Yes" for "vbSupport Unregistered Access." This allows me to get to the main vbsupport page and create tickets, but now I do not have permission to view the tickets once I've created them. I get a "87accordlxi, you do not have permission to access this page. This could be due to one of several reasons..."

The Unregistered access is hazy at best, I need to do more testing on it to verify all permissions are functioning properly for it.

In the end, it will use the Usergroup settings that you have specified for Unregistered inside the Usergroup Manager.

The other settings u need to setup inside Admin CP -> Usergroups -> Usergroup Manager -> And set the vbSupport Permissions for each usergroup you want to access the system and what features they are allowed to do.

-CMX

[Derekclarke]

I was doing the first one.

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

I have done the other templates, just this one that has the error.

[87accordlxi]

It should be the same for the upgrade procedure.



Which template edit were u doing when u got this error?



The Unregistered access is hazy at best, I need to do more testing on it to verify all permissions are functioning properly for it.

In the end, it will use the Usergroup settings that you have specified for Unregistered inside the Usergroup Manager.

The other settings u need to setup inside Admin CP -> Usergroups -> Usergroup Manager -> And set the vbSupport Permissions for each usergroup you want to access the system and what features they are allowed to do.

-CMX


Ah thanks. Fixed the permission issue. I'm still getting some database errors though. When I'm in a ticket and click the check box next to "Delete this Ticket," I get this:
Fatal error: Registry object is not an object in /includes/class_dm.php on line 177

Other than that, I believe I've sorted everything out.

[mtha]

6) Bugfix: Usergroup Permissions are now working for Allowed Usergroups & Denied Usergroups.

It should take DEFAULT permission (usergroup permission) if group permissions for individual category it not set.

Now you have to set permission in Group Manager, then in Category manager, isnt it a duplication?

[ndahiya]

I was doing the first one.

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

I have done the other templates, just this one that has the error.


think it should be

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

[FireFish]

I noticed that in Beta 2; I cannot control the Assign To drop-down list.

Used to be that if a user was part of a usergroup that had Admin Ticket rights, their name was there. You could also add by UserID.

Now, I cannot get anyone else's name onto that list; mine is the only one there.

Any thoughts?

[dethfire]

permissions seem messed up, after upgrading to beta 2 I get "You are not authorized to create". I am admin and have all permissions set correctly in admincp

[EasyTarget]

awesome hack.

Just installed from scratch.. 1st hack on the forum and, besides the missing "]" in the navbar template edit that ndahiya pointed out, it seems to be working fine.

created, assigned, closed, edited and deleted tickets just fine.

some ideas:
have some sort of deletion verification so that if you mark a bunch of tickets and then accidentally choose delete that you don't lose them all.

for listing tickets maybe have the option to list them by category.

option to auto assign tickets according to the category they're placed in.

ability to assign tickets to usergroups.

ability to view who the ticket is assigned to/category while you're viewing the ticket/thread (maybe add categories in the navbit?).

*edit*
got this error when submitting a blank ticket:Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT post.postid, IF(post.userid = 0, post.username, user.username) AS username,
post.pagetext, post.allowsmilie, post.userid, post.dateline
FROM vbs_ticket_post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
WHERE post.visible = 1

AND post.threadid =
ORDER BY dateline DESC, postid DESC
LIMIT 11;

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 'ORDER BY dateline DESC, postid DESC
LIMIT 11' at line 8
Error Number : 1064
Date : Wednesday, May 17th 2006 @ 09:33:17 PM
Script : XXX/vbsupport.php
Referrer : XXX/vbsupport.php?do=newthread
IP Address : XXX.XXX.XXX.XXX
Username : XXXX
Classname : vb_database

[zooman]

I have installed the beta 2 hack today, very good just what I need.

One thing when members go to post the Receive PM Upon Reply is not displayed (or any other notification option). I can not find any options for this. Where am I going wrong?

<if condition="$show['misc_options']">
<fieldset class="fieldset">
<legend>$vbphrase[miscellaneous_options]</legend>
<div style="padding:$stylevar[formspacer]px">
<if condition="$bbuserinfo['signature'] != ''"><div><label for="cb_signature"><input type="checkbox" name="signature" value="1" id="cb_signature" tabindex="1" $checked[signature] />$vbphrase[show_your_signature]</label></div></if>
<if condition="$show['parseurl']"><div><label for="cb_parseurl"><input type="checkbox" name="parseurl" value="1" id="cb_parseurl" tabindex="1" $checked[parseurl] />$vbphrase[automatically_parse_links_in_text]</label></div></if>
$disablesmiliesoption
</div>
</fieldset>
</if>

[Bigasses]

Does the new beta have the ability to send pm/email on assign user?
I think this is the killer feature this new version needs, otherwise, new version is much nicer

[Antivirus]

Does the new beta have the ability to send pm/email on assign user? I think this is the killer feature this new version needs, otherwise, new version is much nicer

It's a good idea, but I would prefer for it to be a variable setting within vboptions so admin has a choice of whether or not to PM/email the staff member upon assigning the ticket.

[kurtbarker]

PMing staff on assign would be great, so that they know that a ticket is waiting for them in particular...

but something I wanted to ask about... When using 1.1, the member that created the ticket got a PM when it was replied to... This isn't happening on version 2... Was it an option I missed, or isn't it included in this version?

[Brandon Sheley]

nice hack, I'll try to find a use for this :)

[lamilein]

great work :) you should add the information that you need to set the proper usergroup-permissions first and then the users will be allowed to use the system :)

also a nasty bug in beta 2:
you need to set "vbSupport Unregistered Access" to NO if you want it to be enabled. just switch the functions for yes/no :)
damn, it took me 15 minutes to find the reason why i wasn't allowed to post tickets even though i set unregistered access to "yes" :D

[mtha]

When using 1.1, the member that created the ticket got a PM when it was replied to... This isn't happening on version 2... Was it an option I missed, or isn't it included in this version?

yes, NOTICE ticket sender is a MUST feature, did you forget or something?

[Bhuwan]

great heack ;; but i think there might be a permission problem -- I am tryin got get unregistered users to view the tickets but it keeps saying no access

[dazh]

Hi excellent mod, just one question can you change this "Welcome to vbSupport. You have a problem with our site? You can get your answers here!" if so where can I change it?

[JayJay]

You can change this in the Phrase Manager (AdminCP -> Language & Phrases -> Phrase Manager) or you can search for the phrase.

The first part can be changed in the phrase vbsupport_title.

The latter part of the statement can be changed by changing the phrase vbsupport_welcome_message.

[dazh]

Thanks for that. Two more things

1) I get an error when trying to upload at attachment
2) Admin arent notified when a ticket is submitted

should these both work or have I configured it wrong

[JayJay]

1) What error are you receiving when trying to upload an attachment? Have you changed the relevant permissions for the usergroup to allow for attachments?

2) Have you ticked the relevant boxes in the Categories to notify the administrators?

[dazh]

When I try and upload an attachment I click on manage attachments and it opens up a new window and says this inside it:

Invalid Post specified. If you followed a valid link, please notify the administrator

[JayJay]

Which version have you attempted to install out of interest? vbsupport v2.0.0 Beta 2?

[dazh]

the latest one just downloaded it yesterday

[bashy]

Hi

I also cannot get guest to access the system, their usergroup is anabled to use and also the support settings have been set for unregistered access!

Also it dont show the posted information see image

Please advise?

using v2 beta

[Bhuwan]

Hi

I also cannot get guest to access the system, their usergroup is anabled to use and also the support settings have been set for unregistered access!

Also it dont show the posted information see image

Please advise?

using v2 betaI hope to find a resolution for this soon,

[bashy]

Ok cheers m8, look forward to the resolution :)

[GamerzWorld]

Hey, another great hack CMX :) I have just installed this on my site and wondered if there was anyway of sending a private message when a ticket is added? Cant see in settings, I seem to remember this was in the first version. Any help would be apprechiated

[Nathan2006]

Hi,

Does anyone know what this error is which I'm getting when trying to delete a ticket?

Fatal error: Registry object is not an object in /includes/class_dm.php on line 177


Thank you for any help :)

[Tyegurl]

missing table?

[richiepearce]

Any idea as to when this will be out of the beta stage.

[Antivirus]

Any idea as to when this will be out of the beta stage.

vBSupport v1.1 is NOT in the BETA stage

[richiepearce]

Thanks for the reply :)

[Antivirus]

it's only the latest version 2.0.0 which is still in beta.

[utw-Mephisto]

Damn I would love to use it but it seems that the author has vanished :(

[Tyegurl]

not vanished just busy i am sure. he gives the best support so he must be really busy

[Spandauer]

Hello,

at first be patient with me, my english is not perfect but i try to to my best... lets go

i have a problem with the suport system. i still had the problem with version 1.1 and now with 2.0.0 beta 2. i hoped i get it fixed with an update and with deinstallation/new installation but the problem keeps alive...

when i use the support-system as admin i dont have problems with attachments.
when i use an user-account and i want to attach a file the system wants to know the password of some of my private and password-protected forums. i removed the password-protection just for testing and see - now it works... but i cannot let these forums open so i had do protect these forums again and the support-system wants to know the password again when i try to attach a file.

when i want to attach a file in the public area of the forum its works well.. just the support-system wants to know this password...

second failure:

when i try to delete a ticket with the "Delete Ticket" Checkbox then i get this message:
Schwerer Fehler: Registry object is not an object in /includes/class_dm.php (Zeile 177)

at the end, a last question:
why exist in the admincp "manage categories" the two options
allowed usergroups and denied usergroups?
are the not-checked allowed usergroups not automatically denied? :)

thanks for your help
Dirk

[Jasiu]

Hi,

Well I was getting the same error so I decided to investigate the problem and I've came up with a solution that works.

In the forums root directory of the file vbsupport.php and find:

// delete ticket
$threadman =& datamanager_init('Ticket_Thread', $this->registry, ERRTYPE_SILENT, 'ticketpost');

And replace that with:

// delete ticket
$threadman =& datamanager_init('Ticket_Thread', $vbulletin, ERRTYPE_SILENT, 'ticketpost');

Hello,

at first be patient with me, my english is not perfect but i try to to my best... lets go

i have a problem with the suport system. i still had the problem with version 1.1 and now with 2.0.0 beta 2. i hoped i get it fixed with an update and with deinstallation/new installation but the problem keeps alive...

when i use the support-system as admin i dont have problems with attachments.
when i use an user-account and i want to attach a file the system wants to know the password of some of my private and password-protected forums. i removed the password-protection just for testing and see - now it works... but i cannot let these forums open so i had do protect these forums again and the support-system wants to know the password again when i try to attach a file.

when i want to attach a file in the public area of the forum its works well.. just the support-system wants to know this password...

second failure:

when i try to delete a ticket with the "Delete Ticket" Checkbox then i get this message:
Schwerer Fehler: Registry object is not an object in /includes/class_dm.php (Zeile 177)

at the end, a last question:
why exist in the admincp "manage categories" the two options
allowed usergroups and denied usergroups?
are the not-checked allowed usergroups not automatically denied? :)

thanks for your help
Dirk

[utw-Mephisto]

@ Spandauer (OT):

Spandauer as in Berlin Spandau ? I used to live in the Sandstrasse / Heerstrasse :)

[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

[Murty]

i also get the error when i try to delete or close a ticket.

Fatal error: Registry object is not an object in /includes/class_dm.php on line 177

really need some help

[Derekclarke]

I had an error while updating the templates on VB 3.6 Beta 4

Template Edits:

A) Template 'navbar':

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

[sessionurl_q"> was wrong had to change to [sessionurl]">


<!-- vbSupport start -->
<if condition="$vboptions['vbsupport_enabled']"><td class="vbmenu_control"><a href="vbsupport.php$session[sessionurl]">$vbphrase[vbsupport_title]</a></td></if>
<!-- vbSupport end -->

Now works Perfect for me so far.

Derek

[kall]

You need to use $session[sessionurl_q].

*edit* .. if you want your non-cookied users to not be logged out that is.

If you don't mind, then by all means, use $session[sessionurl]. :)

[Derekclarke]

Thanks i will change it.

Derek

[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.
Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT post.postid, IF(post.userid = 0, post.username, user.username) AS username,
post.pagetext, post.allowsmilie, post.userid, post.dateline
FROM vbs_ticket_post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
WHERE post.visible = 1

AND post.threadid =
ORDER BY dateline DESC, postid DESC
LIMIT 16;

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 'ORDER BY dateline DESC, postid DESC
LIMIT 16' at line 8

Any help is appreciated...

[jugo]

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


Same error here as well...

vBulletin Version 3.5.4

UPDATE: i did a fresh install of the whole forums and it seemed to work. I am slowly reinstalling the hacks I had on the site and as soon as I figure out which one screws up the support system, I will post it here.

[Derekclarke]

can you tell me how i can change the vbsupport title to a more suitable one.

i have had people tell me they thought this took them direct to vb for support and now our own support issue area.

Thanks

[Murty]

can you tell me how i can change the vbsupport title to a more suitable one.

i have had people tell me they thought this took them direct to vb for support and now our own support issue area.

Thanks

Search phrases for 'vbsupport_title' and tick 'Phrase Variable Name Only'.
ensure the one you are about to edit is under the title 'GLOBAL Phrases Containing 'vbsupport_title''. The edit the text to what you want.

[Synergy]

I had an error while updating the templates on VB 3.6 Beta 4

Template Edits:

A) Template 'navbar':

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

[sessionurl_q"> was wrong had to change to [sessionurl]">


<!-- vbSupport start -->
<if condition="$vboptions['vbsupport_enabled']"><td class="vbmenu_control"><a href="vbsupport.php$session[sessionurl]">$vbphrase[vbsupport_title]</a></td></if>
<!-- vbSupport end -->

Now works Perfect for me so far.

Derek


Thanks friend

[PcGamer]

Same error here as well...

vBulletin Version 3.5.4

UPDATE: i did a fresh install of the whole forums and it seemed to work. I am slowly reinstalling the hacks I had on the site and as soon as I figure out which one screws up the support system, I will post it here.

Thanks... I'm still stuck and not in a position to re-install forums. Hope you can help.

[Code Monkey]

Is this still in developement?

[Cajun]

I upgraded my forums to 3.6 now my support system is not working. I also can not add admin to the system. When I look at Manage Categories and try to edit a categorie I see this message at the top of the screen:

Warning: Invalid argument supplied for foreach() in /dcmain/vbsupport.php on line 40
Notify Admin by Email on New Ticket


Warning: Invalid argument supplied for foreach() in /dcmain/vbsupport.php on line

[Antivirus]

From the author's website...
PC's are crazy as hell sometime, it's shutting off and restarting whenever it wants now all of a sudden. I've tried changing power supplies, checking the fans, etc, etc.. but it only runs for about 30 minutes at a time these days. SO expect a little more delays unfortunately due to the circumstances. I apologize for any inconvenience this may have caused!

Hopefully he's back with an update soon.

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

i hope this will work with 3.6....

[TKlingler]

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]

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]

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.


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]

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.

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

[Dark Riku]

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]

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]

Ok it look like this line:
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]

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]

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]

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:



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/vbsupport.php?do=viewthread&tid=5
Referrer : http://www.MYDOMAIN.com/forums/private.php?do=showpm&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:


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


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]

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]

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]

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:


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:


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:


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]

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:

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


Replace With:

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

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

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

<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

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

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]

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

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:


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:

A new support ticket has been submitted by {1}.
Please click here to view the ticket ({2})

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:


{
// 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:



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


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


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

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:


// ### NOT PREVIEW - ACTUAL POST ###
if ($vbulletin->GPC['ajax'])
{



Add:




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

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/showthread.php?t=10&page=2
http://www.mydomain.com/forums/showthread.php?t=10&page=3

These should go to urls as follow:

http://www.mydomain.com/forums/vbsupport.php?do=viewthread&tid=10
http://www.mydomain.com/forums/vbsupport.php?do=viewthread&tid=10&page=2
http://www.mydomain.com/forums/vbsupport.php?do=viewthread&tid=10&page=3

[Quarterbore]

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]

Has CMX_CMGSCCC left the scene?

[Quarterbore]

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]

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]

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:

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

[Quarterbore]

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]

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

[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)?

[Hornstar]

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]

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.

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]

try this for the navbar


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

[chefsache]

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]

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.

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]

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]

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

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

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

[codemoxie]

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]

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/vbsupport.php?do=viewthread&tid=2
Referrer : http://www.excalibursystems.net/vb36/vbsupport.php?do=newthread
IP Address : [IP hidden]
Username : [User Hidden]
Classname : vb_database

It did work fine with the default install on 3.6.0

[soletrader]

Can anyone post the working vbsupport.php for 3.6? I would appreciate it. Thank you

[codemoxie]

Anyone have a solution to the above bug? Support has been dead on our site for the last week :(

[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

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

[precharge]

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;

[Derekclarke]

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

[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

[CypherSTL]

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

[JulianWolf]

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!

[Jealousy10312]

I would not use this hack. There are so many flaws with it, it's insane.

[CypherSTL]

I would not use this hack. There are so many flaws with it, it's insane.

The hack works flawlessly with it's intended install on 3.5.4, however it does work flawlessly on 3.6.0, the problem is that many of us love this hack but are on 3.6.1 or 3.6.2 and there have been many changes since 3.6.0 that the hack is "broke" in newer versions than 3.6.0. Once this can be ported correctly to these version that it is broke in it will again work flawlessly.

[soletrader]

It doesnt work with 3.6

[CypherSTL]

I have had it installed on 3.6.0 since it went gold with no problems, it broke when I upgraded to 3.6.1

[JamieLee2k]

here see for yourself http://82.16.74.99/forum/vbsupport.php? This is on my PC at the moment running latest versions of MySQL, PHP and Apache

username and pass is test/test

[mtha]

CMX, any plan to upgrade this one to work with 3.6.2 and release next version?

[Intex]

When submitting a ticket is the admin and the member supposed to get an email / PM notifying that a new ticket has been received / submitted?

[EasyTarget]

CMX, any plan to upgrade this one to work with 3.6.2 and release next version?
CMX_CMGSCCC
Coder

Last Online:
Jul 2006

[bhall23]

I am using v2.0.0 beta 1. is there a way to do this with 2.0.0 https://vborg.vbsupport.ru/showpost.php?p=787855&postcount=125 ?

or, if not, is there a way to have the drop down of categories be in the same order as they are set to display order in the admin?

[Sabrina2007]

Good day, First times apology for my very bad English. I built myself today into vBulletion 3.6.2. Now there are there however somehow problems, if I liked to attach at a provided ticket an appendix come the PopUp window where one the appendix to select and can high-load, only in the window appears my starting side of the board. Desweitern inserted SMI-read not plotted. A Mailbenachrichtig or a pn do not get I also if a ticket were provided. Now my Fragem goes it at all with 3.6.2. And here times a Fehlmeldung also times repeatedly appears: Data base error in vBulletin 3.6.2: Invalid SQL: SELECT post.postid, IF (post.userid = 0, post office username, user username) AS username, post office PAGE text, post.allowsmilie, post.userid, post office DATE LINE FROM vb3_vbs_ticket_post AS post office LEFT JOIN vb3_user AS user ON (user.userid = post.userid) WHERE post.visible = 1 AND post.threadid = ORDER BY DATE LINE DESC, postid DESC LIMIT 11; MySQL error: You have at error in your SQL syntax. Check the manual that corresponds tons your MySQL server version for the right syntax ton use near 'ORDER BY DATE LINE DESC, postid DESC LIMIT 11 ' RK LINE 8 Error no. : 1064 Date: Wednesday, November 1st 2006 @ 08:21: 17 PM Script: http://www.xxxxxx/vbu.../vbsupport.php Referrer: http://www.xxxxxxx/vbu...p?do=newthread IP address: xxxxxx User name: sabrina Class name: vb_database For an assistance like I the error behebn can would be very grateful I. MFG Sabrina

[nymyth]

Sabrina,

This mod has a lot of problems with 3.6.2, id uninstall if i were you....

[CypherSTL]

If you wish to use this mod and are 3.6.x it is best to stick with 3.6.0 as 3.6.1 and 3.6.2 are not compatable, there where to many code changes in 3.6.1 and even more in 3.6.2

Also remember this mod IS for 3.5.4 anyways, so it is just by chance it even works with 3.6.0

[dethfire]

bump for conversion

[JamieLee2k]

Trying to put in the template change in the navbar

The following error occurred when attempting to evaluate this template:

Parse error: syntax error, unexpected T_CHARACTER, expecting ']' in xxxxxx/xxxxxxx/xxxxxxxx/xxxxxxx/xxxxxx/forum/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.

Can anyone tell me why this might be wrong, it has worked fine in other styles I have done just not this new one

[DS MrSinister]

yes its missing a ] after the q.

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

[MrPHD]

Installed and working nice.Thanks

[erkme73]

Your website needs just a few more pop-ups... Any chance this will be modded to work on 3.6.x?

[BobbyBig]

Please make that workable for 3.6.4 - Because this is really great mod

[Guest201202001]

for the version 3.6.4??? this is a good mod

[erkme73]

I just got done reading about 80% of the posts in this thread. It's pretty clear that the problem isn't specifically 3.6.x - it's only if you UPGRADE from an older version to a newer version of vBulletin that the line40 error pops up. I would have hoped this would not have been too challenging to solve, but clearly either the interest or technical level isn't there to beat the bug out of the code.

I would really like to install this, or something like it. Has anyone been able to install this mod on an upgraded 3.6.4 version of vBulletin? Are there any comparable mods/hacks that would offer the same features?

TIA...

[Guest201202001]

works very well with 3.6.4

if u r going to take an error: like this
Database error in vBulletin 3.6.4:

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


jusd add this query at your forum DB:
ALTER TABLE user ADD level INT UNSIGNED NOT NULL DEFAULT '0'



this worked to me.

[Magnetism]

Getting the error

Warning: Invalid argument supplied for foreach() in /vbsupport.php on line 391

When posting a new ticket, any ideas on how to fix this?

[sinisterpain]

Has anyone found or resolved the problem with Categorys not working in 3.6.4. Is CMX still working on this hack since it is a useful tool for a lot of forums.

[sinisterpain]

It appears to me just going thru the code in functions_vbsupport that some thing here is not right. It will not read the datastore for the variables. Not a coder so I can not figure out why the categories are not displaying. The author seems to have disapeared and while it its functional in 3.6.4 without categories it much more beneficial if they were too work. Would greatly appreciate any help. If its wrong to post this, I appologize

// function to build the category options
function vbsupport_build_category_options($selcatid)
{
global $vbulletin, $vbphrase, $show;

// clear out $categoryoptions
$categoryoptions = '';
//check if they are allowed to change ticket categories
$show['category'] = false;
if (!empty($vbulletin->vbs_category) && is_array($vbulletin->vbs_category))
{

// always set this first value
$categoryoptions = "<option value=0>" . $vbphrase['vbsupport_none'] . "</option>";

// process all of the vbs_category
foreach($vbulletin->vbs_category AS $categoryid => $category)
{
// check if this category is accessible
if (($category['active'] > 0) AND vbsupport_check_allowed($vbulletin->userinfo, $category['allowedgroups'], $category['deniedgroups']))
{
// check if its integrated with vbbux / vbplaza
if ($vbulletin->options['vbsupport_vbbuxplaza_integrate'] > 0)
{
// check if the cost is more than 0
if ($category['cost'] > 0)
{
// format the cost properly
$category['cost'] = vb_number_format($category['cost'], $vbulletin->options['vbbux_decimalplaces']);

// update the $category['name'] to show the cost
$category['name'] .= " (" . $category['cost'] . " " . $vbphrase['vbbux_name'] . " " . $vbphrase['vbbux_points'] . ")";
}
}

// check if this is the one assigned
if ($categoryid == $selcatid)
{
$categoryoptions .= "<option value=" . $categoryid . " selected>" . $category['name'] . "</option>";
}
else
{
$categoryoptions .= "<option value=" . $categoryid . ">" . $category['name'] . "</option>";
}
}
}

// set it so this user can set a category
$show['category'] = true;
}

// return the $categoryoptions
return $categoryoptions;
}

[sinisterpain]

Ok, with some research I finally got this to show the categories and assigned admins in both the support thread created and in creating a new ticket in vB 3.6.4.

you need to edit the author's files in the upload folder includes/vbsupport_functions.php file and the vbsupport.php file as follows:

vbsupport_functions.php

find:
// function to build the category options
function vbsupport_build_category_options($selcatid)
{
global $vbulletin, $vbphrase, $show;

// clear out $categoryoptions
$categoryoptions = '';

// check if they are allowed to change ticket categories
$show['category'] = false;
if (!empty($vbulletin->vbs_category) && is_array($vbulletin->vbs_category))
{

change to:

// function to build the category options
function vbsupport_build_category_options($selcatid)
{
global $vbulletin, $vbphrase, $show;

// clear out $categoryoptions
$categoryoptions = '';

// check if they are allowed to change ticket categories
$show['category'] = false;
$vbulletin->datastore->do_db_fetch("'vbs_category'");
if (!empty($vbulletin->vbs_category) && is_array($vbulletin->vbs_category))
{

In vbsupport.php

find:
// build the assigned user (if any)
$show['assigned'] = true;
$assigned = $vbulletin->vbs_admin[$thread['assigneduserid']];
if (!empty($assigned) && is_array($assigned))
{

change to:
// build the assigned user (if any)
$show['assigned'] = true;
$vbulletin->datastore->do_db_fetch("'vbs_admin'");
$assigned = $vbulletin->vbs_admin[$thread['assigneduserid']];
if (!empty($assigned) && is_array($assigned))
{

find:
// build the category (if any)
$category = $vbulletin->vbs_category[$thread['categoryid']];
if (!empty($category) && is_array($category))
{

change to:
// build the category (if any)
$vbulletin->datastore->do_db_fetch("'vbs_category'");
$category = $vbulletin->vbs_category[$thread['categoryid']];
if (!empty($category) && is_array($category))
{

I am posting this fix since no word or activity has come from the author since July 2006. I feel that alot of members could really use this hack for their boards. The call for the datastore was not working which required a do_db_fetch since it did not recognize the vbs_category and would only see the datastore folder in the data base when using the call $vbulletin->vbs_categaory. These edits may not be needed by everyone, if you did a fresh install of 3.6.4 and not the upgrade the authors files may work without the edits you need to try the authors file and if categorys do not work then use the edits.

[tank14]

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

[sinisterpain]

Forgot another edit which must be made to the admincp/vbsupport.php file inorder for emails and pms to work with the categorys. Since the pm and emails get sent based on the individual category set up. Once the file edit is made in the admincp-> manage categorys select a category for edit and at the bottom you should see check boxes with administators listed for email and PM option. Select the admin and save this will send a pm based on who is selected for a specific category.

in the folder admincp/vbsupport.php

find:

function print_admin_user_row($title, $name = 'multibox', $columns = 0, $userlist)
{
global $vbulletin;

// build $userids
if (empty($userlist))
{
// build an empty $userlist
$userlist = '0';
}
$ids = explode(',', $userlist);

// build the options
$options = array();
foreach($vbulletin->vbs_admin AS $userid => $user)
{


change to:

function print_admin_user_row($title, $name = 'multibox', $columns = 0, $userlist)
{
global $vbulletin;

// build $userids
if (empty($userlist))
{
// build an empty $userlist
$userlist = '0';
}
$ids = explode(',', $userlist);

// build the options
$options = array();
$vbulletin->datastore->do_db_fetch("'vbs_admin'");
foreach($vbulletin->vbs_admin AS $userid => $user)
{

find:
// unserialize the datastore
$vbulletin->vbs_category = unserialize($vbulletin->vbs_category);
$vbulletin->vbs_admin = unserialize($vbulletin->vbs_admin);

change to:
$vbulletin->datastore->do_db_fetch("'vbs_category'");
$vbulletin->vbs_category = unserialize($vbulletin->vbs_category);
$vbulletin->datastore->do_db_fetch("'vbs_admin'");
$vbulletin->vbs_admin = unserialize($vbulletin->vbs_admin);

[sinisterpain]

Same issue here.

Your case is unique as we discussed on MSN, you are running a 3.6.4 install on a 3.5.4 skin, with a fresh install of 3.6.4. You do not require most if not any edits that I supplied. But you need to be sure that all of your permisions are set properly. Also you need to explain your problem in detail not just quote another thread.

[BigJohnny]

the zip for 2.0 is corrupt... :(

[sinisterpain]

the zip for 2.0 is corrupt... :(

I just downloaded it and it works fine for me

[BigJohnny]

yup your right... it was a problemwith me.

[Takamine334]

When users try to submit a ticket, they get this:

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

I have created categories, but I don't see where the user is supposed to select one prior to submitting a ticket.

[sinisterpain]

When users try to submit a ticket, they get this:

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

I have created categories, but I don't see where the user is supposed to select one prior to submitting a ticket.

Are you running Vb3.6.4, if so try the edits I have given a few threads back. https://vborg.vbsupport.ru/showpost.php?p=1150362&postcount=476

[amykhar]

Here is a fix that allows unregistered users to SEE the ticket system.

In vbsupport.php Find:

if ($vbulletin->options['vbsupport_unregistered_access'] > 0)

Replace with:

if ($vbulletin->options['vbsupport_unregistered_access']==0)

and guests can view. I'm working now on getting guests to be able to actually submit a ticket.

[TotalTorque.net]

Ok, I've installed v2 but have problems.

Whenever I try to go to vbSupport in the navbar it says I am not authorized to create tickets.

That is despite being logged in as a Mod or Admin.

So, I set it to a public system.

It then allowed me to create a ticket, but when I went to submit it, it said I did not have sufficient permissions. Yet, it showed 1 open ticket...but wouldn't display it!

So, as a Mod/Admin I can do nothing, but as a standard user I can...but only get so far!

Very odd indeed? Help!

[sinisterpain]

Ok, I've installed v2 but have problems.

Whenever I try to go to vbSupport in the navbar it says I am not authorized to create tickets.

That is despite being logged in as a Mod or Admin.

So, I set it to a public system.

It then allowed me to create a ticket, but when I went to submit it, it said I did not have sufficient permissions. Yet, it showed 1 open ticket...but wouldn't display it!

So, as a Mod/Admin I can do nothing, but as a standard user I can...but only get so far!

Very odd indeed? Help!

The author's navbar edit has an error
try this instead:
<if condition="$vboptions['vbsupport_enabled']"><td class="vbmenu_control"><a href="vbsupport.php$session[sessionurl_q]">$vbphrase[vbsupport_title]</a></td></if>

[tank14]

OK so is any one getting a completely corrupt view when you are in postbit legacy?

[Bahawolf2]

Obtained this error when I went to: AdminCP -> vbSupport -> Manage Categories -> Clicked on its Category name 'Forums Problem' (default category)
Note: it shows this error message twice though it shows all the categories settings...
Warning: Invalid argument supplied for foreach() in /admincp/vbsupport.php on line 40

vbsupport.php line 40 = foreach($vbulletin->vbs_admin AS $userid => $user)

After clicking new thread (to send a new ticket) I filled out all the ticket info and hit send... it loads a screen for about 5 seconds saying
Warning: Invalid argument supplied for foreach() in /vbsupport.php on line 391
Then proceeds to a permissions page saying I don't have permission to access it....

vbsupport.php line 391 = foreach($vbulletin->vbs_admin AS $userid => $user)

Any Clue?
Other info----
Running VB 3.6.4 (recently upgraded from 3.5.3)
Tryed running: vbsupport_v2.0.0_Beta_2
I also tryed the install tips from this website:
https://vborg.vbsupport.ru/showpost.php?p=1150362&postcount=476

Thanks in advance for any help.

[sinisterpain]

You did not do the other edit below that post which is edit for vbsupport.php in the admincp folder. See post https://vborg.vbsupport.ru/showpost.php?p=1151031&postcount=478.
Also in the main vbsupport.php (one not in admincp folder)I forgot another edit I think

Find :
// unserialize the datastore
$vbulletin->vbs_category = unserialize($vbulletin->vbs_category);
$vbulletin->vbs_admin = unserialize($vbulletin->vbs_admin);

// check if the user is an admin
$show['useradmin'] = false;
if (vbsupport_can_moderate('canadminsupport'))
{

Change too:
// unserialize the datastore
$vbulletin->datastore->do_db_fetch("'vbs_category'");
$vbulletin->vbs_category = unserialize($vbulletin->vbs_category);
$vbulletin->datastore->do_db_fetch("'vbs_admin'");
$vbulletin->vbs_admin = unserialize($vbulletin->vbs_admin);

// check if the user is an admin
$show['useradmin'] = false;
if (vbsupport_can_moderate('canadminsupport'))
{

also for pms to work:
find in vbsupport.php:
// build the $emailids

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

// check for email notifications
if (is_array($emailids) && is_array($pmids))
{
// process add admins

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

Change too:
// build the $emailids
$vbulletin->datastore->do_db_fetch("'vbs_category'");
$pmids = explode(',', $vbulletin->vbs_category["$categoryid"]['adminpmusers']);
$emailids = explode(',', $vbulletin->vbs_category["$categoryid"]['adminemailusers']);

// check for email notifications
if (is_array($emailids) && is_array($pmids))
{
// process add admins
$vbulletin->datastore->do_db_fetch("'vbs_admin'");
foreach($vbulletin->vbs_admin AS $userid => $user)
{

Quaterbore posted a phrase add which must be done for pms regards to a support ticket being deleted by another admin and then clicking on the link in the PM that was sent by that ticket will cause an error since no phrase exists to handle this particular case.

[Techno05]

When posting a reply to a ticket we get a

Database error in vBulletin 3.6.4:

Invalid SQL:
INSERT INTO pm (pmid, pmtextid, userid, folderid, messageread) VALUES (0, , 402, 0, 0);

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 ' 402, 0, 0)' at line 1
Error Number : 1064
Date : Monday, January 22nd 2007 @ 11:05:56 PM
Script : http://www.sigrequest.com/forums/vBSupport.php
Referrer : http://www.sigrequest.com/forums/vBSupport.php?do=newreply&noquote=1&ticketreplyid=28
IP Address : 83.100.224.13
Username : Techno
Classname : vB_Database_MySQLi

Error, any suggestions?

[sinisterpain]

When posting a reply to a ticket we get a

Database error in vBulletin 3.6.4:

Invalid SQL:
INSERT INTO pm (pmid, pmtextid, userid, folderid, messageread) VALUES (0, , 402, 0, 0);

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 ' 402, 0, 0)' at line 1
Error Number : 1064
Date : Monday, January 22nd 2007 @ 11:05:56 PM
Script : http://www.sigrequest.com/forums/vBSupport.php
Referrer : http://www.sigrequest.com/forums/vBSupport.php?do=newreply&noquote=1&ticketreplyid=28
IP Address : 83.100.224.13
Username : Techno
Classname : vB_Database_MySQLi

Error, any suggestions?

You installed version 1.1, need to install version 2.0.

[Techno05]

Now that I have the new version I am not seeing any categorys I have created and also getting this...


Warning: unserialize() expects parameter 1 to be string, array given in /vbsupport.php on line 116

Warning: unserialize() expects parameter 1 to be string, array given in /vbsupport.php on line 117

[Techno05]

Anyone have any idea on the above post...

[sinisterpain]

Now that I have the new version I am not seeing any categorys I have created and also getting this...


Warning: unserialize() expects parameter 1 to be string, array given in /vbsupport.php on line 116

Warning: unserialize() expects parameter 1 to be string, array given in /vbsupport.php on line 117

Is that with or without the edits

[Techno05]

Is that with or without the edits


This was with out the edits. But here is the thing. When I try to find some of that code its not even there which I find rather strange. Any idea?

[sinisterpain]

This was with out the edits. But here is the thing. When I try to find some of that code its not even there which I find rather strange. Any idea?

What version of this hack are you using? Use version 2.0 not 1.1

[Techno05]

What version of this hack are you using? Use version 2.0 not 1.1

Yes I have installed Version 2 now. And those are the errors I am getting. The site is http://sigrequest.com

[sinisterpain]

Yes I have installed Version 2 now. And those are the errors I am getting. The site is http://sigrequest.com

Make sure you read my edits closely, there are two files called vbsupport.php. One in the root forum and one in the admincp folder. Both of these files require edits and the vbsupport_functions file as well. The code is there if you have 2.0 installed.

[sinisterpain]

Ok since I have been recieving pms regards to this hack, and there has been confusion over the file edits to make. I have decided to upload the package with all the edits I have made to date. Please be sure that you read the included "readme file edits.txt". There are still issues with this hack in 3.6.4 but with the edits this should provide most admins with what they want to use the system for. I can not guarentee this will work for everyone, but it works on my 3.6.4 forum. Good luck!:D

[alfaowner]

Ok since I have been recieving pms regards to this hack, and there has been confusion over the file edits to make. I have decided to upload the package with all the edits I have made to date. Please be sure that you read the included "readme file edits.txt". There are still issues with this hack in 3.6.4 but with the edits this should provide most admins with what they want to use the system for. I can not guarentee this will work for everyone, but it works on my 3.6.4 forum. Good luck!:D

Thats very good of you, will it still be fine on 3.5.4

[sinisterpain]

Thats very good of you, will it still be fine on 3.5.4

You may not need the edits for version 3.5.4 since the original hack was targeting that.