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

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

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

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.

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;

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

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

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

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

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

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:

Is all that solvable? And, what do you think? Is it usefull?

Best wishes, Julian!

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