vBSupport v2.0.0 Beta 2

[JamieLee2k]

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 _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,27)

ORDER BY post.dateline;

MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054
Date : Sunday, January 28th 2007 @ 01:39:19 PM
Script : http://www.xleagues.net/forum/vbsupport.php?do=viewthread&tid=19
Referrer : http://www.xleagues.net/forum/vbsupport.php
IP Address : xx.xx.xx.xx
Username : JamieLee2k
Classname : vb_database

This was fine before and now something changed it

[sinisterpain]

If you refer to the edits I supplied. I did not change anything more than adding the ability to read the datastore properly and one phrase add. All other info is the authors.
Are you using table prefix?

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)


The code should not look like that

[nymyth]

sinister...i downloaded your version, but i still cannot see the categorys....any ideas?

if it turn off the option of categorys...and submit an issue, i get this error before the redirect:

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

and after the redirect the following....I AM NOT USING TABLE PREFIXES....

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

ORDER BY post.dateline;

MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054
Date : Monday, January 29th 2007 @ 11:53:37 AM
Script : http://www.fsenyc.com/forum/vbsupport.php?do=viewthread&tid=1
Referrer : http://www.fsenyc.com/forum/vbsupport.php
IP Address : xxx.xx.xx.xxx
Username : nymyth
Classname : vb_database

Peace

[sinisterpain]

Check you vbsupport.php file and tell me if it looks like this:

// build the $emailids
$vbulletin->datastore->do_db_fetch("'vbs_category'");
$pmids = explode(',', $vbulletin->vbs_category["$categoryid"]['adminpmusers']);
$vbulletin->datastore->do_db_fetch("'vbs_category'");
$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)
{

Also have you tryed to install without my edits first.

[nymyth]

yeah it looks the same....i havent tried without the edits, seeing im running 3.6.4

Peace

[nymyth]

when i installed the original one i see the categorys fine, however when submitting the ticket i now get 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,1)

ORDER BY post.dateline;

MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054
Date : Monday, January 29th 2007 @ 05:24:24 PM
Script : http://www.fsenyc.com/forum/vbsupport.php?do=viewthread&tid=1
Referrer : http://www.fsenyc.com/forum/vbsupport.php?do=newthread
IP Address : xx.xxx.xx.xxx
Username : nymyth
Classname : vb_database

Peace

[nymyth]

OK NEVERMIND...lol...i ran this query ALTER TABLE user ADD level INT UNSIGNED NOT NULL DEFAULT '0' with the original install and it works fine now....hmmmm...thanks anyway

Peace

[fib]

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

I wanted to say thankyou for all your work as I thought everything was looking great

but I am afraid on testing I do have an issue or 2

Looking in the DB all seems well the 3 tables are there and are accepting messages etc
the install has been done as per your download above

I followed all and all seems great but when I list the messages I get "there were no tickets found" for open, closed and list any.
this is as a registered user who has submitted tickets and for the admin. The "your Ticket Information" is correct and updates if I change the ticket in the DB to closed. Admin can only see the number of the tickets admin has submitted not the others needing replied to.

Am I missing an obvious marker?

thank you for your time we all appreciate it.

[sinisterpain]

I wanted to say thankyou for all your work as I thought everything was looking great

but I am afraid on testing I do have an issue or 2

Looking in the DB all seems well the 3 tables are there and are accepting messages etc
the install has been done as per your download above

I followed all and all seems great but when I list the messages I get "there were no tickets found" for open, closed and list any.
this is as a registered user who has submitted tickets and for the admin. The "your Ticket Information" is correct and updates if I change the ticket in the DB to closed. Admin can only see the number of the tickets admin has submitted not the others needing replied to.

Am I missing an obvious marker?

thank you for your time we all appreciate it.

Make sure that you make the template edits as per the author except the navbar, make sure that the permisions are set for each user group both in the support catergories that you add and the usergroups in the admincp.

[fib]

this is great although I was going to use the system for unregistered aswell and do not seem to be able to get that to work -
I suppose it would need to ask for an email address too.

The only other thing (I hope) is that my forum is 800 wide and the create new ticket / reply is pushed off the main block by the menu on the left. Is there any way to overcome this

maybe move the menu to be above rather than at the side? Where would I find this in a template as I may look at this myself.

thank you:)
I appreciate your help

[sinisterpain]

this is great although I was going to use the system for unregistered aswell and do not seem to be able to get that to work -
I suppose it would need to ask for an email address too.

The only other thing (I hope) is that my forum is 800 wide and the create new ticket / reply is pushed off the main block by the menu on the left. Is there any way to overcome this

maybe move the menu to be above rather than at the side? Where would I find this in a template as I may look at this myself.

thank you:)
I appreciate your help

As far as the unregistered go, look a few threads back I believe that amy posted a fix for this. All the templates are in your style you installed them to. there is an option in the admincp that needs to be set dont quite remember now which one.

[fib]

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.

Hi as mentioned I am trying to sort this too
did you get any joy?
Really hoping to use this ticket system for unregistered

thank you

[snobird1211]

got it working but am now facing a problem

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

there is no option to choose a caotogorey and when u enter the message it says that im using 3.6.4 and have done all extra edits u have mentioned

[snobird1211]

ok i got it fixed but now the system is longer than the fixed with of my forums like when you submit a message the message intereface is longer than the fixed width

[Techno05]

This may have been mentioned on one of these pages but I can not seem to find it. Could someone please explain how I have it all working with no errors coming up except that I can not ASSIGN tickets to any staff. Yes, the options are selected in the admin cp. Thank you for your time.

[sinisterpain]

This may have been mentioned on one of these pages but I can not seem to find it. Could someone please explain how I have it all working with no errors coming up except that I can not ASSIGN tickets to any staff. Yes, the options are selected in the admin cp. Thank you for your time.
did you use my edits? or the author's install files.
Also you say the options are selected, make sure that you have set the permisions for assigning tickets.

[snobird1211]

can any one explain how to make it for fixed width and not fluid

[John Diver]

Can this be set so certain usergroups can view / reply to tickets in specific categories instead of being able to access tickets in all categories?

[dip1232001]

OK NEVERMIND...lol...i ran this query with the original install and it works fine now....hmmmm...thanks anyway
ALTER TABLE user ADD level INT UNSIGNED NOT NULL DEFAULT '0'
Peace
worked for me too.... thanks

[John Diver]

Can this be set so certain usergroups can view / reply to tickets in specific categories instead of being able to access tickets in all categories?

Great hack, hope this can be done :)

Thanks

[gullystation]

When Im editing the navbar and I put this code in :

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

then this comes up:

The following error occurred when attempting to evaluate this template:

Parse error: parse error, unexpected T_CHARACTER, expecting ']' in /var/www/vhosts/GullyStation.com/httpdocs/forum/includes/adminfunctions_template.php(3596) : 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 someone help me please?

[sinisterpain]

When Im editing the navbar and I put this code in :

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

then this comes up:



Can someone help me please?
You appear to be missing something. Are you putting the navbar edit in the correct place in the edit

[gullystation]

Yes! I'm really sorry. This is my mistake. I've just released that I have 3.6.5 and this is for 3.5. Oh man! lol

[John Diver]

sinisterpain, do you know about my question?

Thanks :)

[sinisterpain]

Can this be set so certain usergroups can view / reply to tickets in specific categories instead of being able to access tickets in all categories?

Great hack, hope this can be done :)

Thanks
yes once the categories are set up there are usergroup permissions withing the categories created which must be checked for allowed and denied

[RichieBoy67]

Will this work with 3.6.4 or 3.6.5??? If not does anyone know of a system that will???

[John Diver]

Thanks very much! :)

[sinisterpain]

Will this work with 3.6.4 or 3.6.5??? If not does anyone know of a system that will???
I have it working on 3.6.4 dont know about 3.6.5

[RichieBoy67]

Great, I have not upgraded to ,5 yet. I figure that the day I upgrade they will release another upgrade so why bother??? lol

I am just waiting....

That is good news though!! "clicks install" Thanks

[Vault_Dweller]

How can i make attachments work?

[sinisterpain]

How can i make attachments work?
I do not allow attachments on my board so its not an issue. It would need a code fix.

[shungo]

Hi,

Thanks to original coder for this nice hack and really big thanks to you sinisterpain for helping us to have it working on VB 3.6.4, all work very well on my board since i upgraded with your own fixed product :)

Best regards

[RichieBoy67]

I love this hack but I am not ready to upgrade yet... Is there any way you can hook me up with the modifcations to get it to work in 3.6.4

Thanks

[sinisterpain]

Hi,

Thanks to original coder for this nice hack and really big thanks to you sinisterpain for helping us to have it working on VB 3.6.4, all work very well on my board since i upgraded with your own fixed product :)

Best regards
Your very welcome

[sinisterpain]

I love this hack but I am not ready to upgrade yet... Is there any way you can hook me up with the modifcations to get it to work in 3.6.4

Thanks
If you read the threads this should work for 3.6.4 there are some edits that will need to be made which are also located here

[RichieBoy67]

Ahhh, One of those deals...lol Read this thread, 36 pages..... I will do so when I have time but if anyone happens to have these edits bookmarked and can point me in the right direction I would sure appreciate it...


Thanks

[sinisterpain]

Ahhh, One of those deals...lol Read this thread, 36 pages..... I will do so when I have time but if anyone happens to have these edits bookmarked and can point me in the right direction I would sure appreciate it...


Thanks
No I do not know if its appropriate for me to upload the complete hack in the authors thread

[RichieBoy67]

I don't know what you mean?? I thought you said if I search I will find it. I just wanted the link to where the info is or a fix so I can get this working with 3.6.4... If you have the fix and can pm me that would help me a great deal....

Thanks...

[sinisterpain]

I don't know what you mean?? I thought you said if I search I will find it. I just wanted the link to where the info is or a fix so I can get this working with 3.6.4... If you have the fix and can pm me that would help me a great deal....

Thanks...

You can try my files here https://vborg.vbsupport.ru/showpost.php?p=1166692&postcount=500 if they do not work for you then you will have to use the authors files and make the edits on page 28 on that quarterbore suggested for PMs.

[RichieBoy67]

Thanks,

I appreciate the help... :)

Rich

[David-Parker]

i have installed the BETA version adn i get this lovely error

Database error in vBulletin 3.6.5:

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

ORDER BY post.dateline;

MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054
Date : Thursday, April 19th 2007 @ 10:27:34 AM
Script : http://teenbase.org.uk/vbsupport.php?do=viewthread&tid=1
Referrer : http://teenbase.org.uk/vbsupport.php?do=newthread
IP Address : 194.66.175.81
Username : David
Classname : vB_Database

[sinisterpain]

i have installed the BETA version adn i get this lovely error

Database error in vBulletin 3.6.5:

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

ORDER BY post.dateline;

MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054
Date : Thursday, April 19th 2007 @ 10:27:34 AM
Script : http://teenbase.org.uk/vbsupport.php?do=viewthread&tid=1
Referrer : http://teenbase.org.uk/vbsupport.php?do=newthread
IP Address : 194.66.175.81
Username : David
Classname : vB_Database


Just add this to your tables
ALTER TABLE user ADD level INT UNSIGNED NOT NULL DEFAULT '0'

[Ultimative]

nvm :P sorted <3

[cocker]

nvm

[TheJackal56]

Has anyone got a fix or hack to allow user to submit attachments for 3.6.5?

[Datenpapst]

how about a transformation into 3.5.6?

[masons]

When we post a ticket, nothing shows once you open the ticket.

It just has two reply buttons with no tickets in between.

Any ideas?

[masons]

Database error in vBulletin 3.6.5:

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 : Monday, May 7th 2007 @ 10:40:30 AM
Script : http://www.novusordosaeculorum.com/vbsupport.php?do=newreply&noquote=1&pid=
Referrer : http://www.novusordosaeculorum.com/vbsupport.php?do=viewthread&tid=1
IP Address : 122.26.174.160
Username : Mike
Classname : vB_Database

[Datenpapst]

Its not working for 3.6.5 isnt it?

[Ultimative]

Once a user posts a ticket, when you open the ticket nothing appears.

However you can reply and the reply appears, but still no ticket.

Any help?

[masons]

Same problem as Ultimative.. PLEASE HELP
Will pay for a fix!

[rowlandc]

Looks like a very good mod. I'll install it when the mod is fixed :)

- i've did some searching and i think the developer is occupied in rl. So he doesn't have time to work on the mod.

[carmichael1973]

Well, this hack is no longer for me. I'd love to have it but unfortunately it looks abandoned by the original author.

Thanks for all the help from everyone and I wish you all luck with this.

Carmichael1973 clicks UNINSTALLED!

[Delphiprogrammi]

hi folks,

This does work fine ..... wanna know how i did that ? allthroug it looks like smilies are not working.Problems i noticed with the system and fixed while i whas busy anyway

The MySQL error "unknown column 'level' in field list
Fixed Problem with AJAX inline threadtitle editing
Fixed Problem with AJAX open/close threads
Fixed the admincp part "categorys" (wrong MySQL query) The datastore is function correctly now and no longer give errors
....The admincp error is not a mistake by the developer.vBulletin changed the way the datastore works between versions 3.5.x and 3.6.x that's why it no longer worked

don't ask me why i put so much time in a hack that's not even mine.This hack whas (is) to good to let it go away and die ! anybody with me on this one ?

[beduino]

the last version is 1.1a? 2.0.0 beta2???
anybody tests - what version? - with 3.6.7.pl1 version?
sorry a lot of questions...but i receive a email of update.
all the best
beduino

[sinisterpain]

If I understand the email I recieved, the update applies if you have version 1.1 installed and not the 2.0 beta version. If you have version 1.1 installed you should install the 1.1a version. If Im wrong then the vb.org admins need to clarify things since their is a 2.0 version that was released.

[sinisterpain]

hi folks,

This does work fine ..... wanna know how i did that ? allthroug it looks like smilies are not working.Problems i noticed with the system and fixed while i whas busy anyway

The MySQL error "unknown column 'level' in field list
Fixed Problem with AJAX inline threadtitle editing
Fixed Problem with AJAX open/close threads
Fixed the admincp part "categorys" (wrong MySQL query) The datastore is function correctly now and no longer give errors
....The admincp error is not a mistake by the developer.vBulletin changed the way the datastore works between versions 3.5.x and 3.6.x that's why it no longer worked

don't ask me why i put so much time in a hack that's not even mine.This hack whas (is) to good to let it go away and die ! anybody with me on this one ?

Why dont you post up your changes? I had already posted that the problem was with the datastore so I made a post here with some changes but it did not seem to work for all.

[beduino]

Hello sinisterpain,
tks for your answer, first of all!
In fact i don't install vbsupport yet, because the possible problems in security. But I'm interested in install, of course. If i undertand [i think you're right :)] the update was in version 1.1 [even i don't seeing any new file in package...]
Anyway,
tks
Beduino
ps. you have install 1.1 version in vb 367?

[puertoblack2003]

thanks for th eupdate works well for 6.7

[Guest201202001]

I have this problem at the top of the page I have 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

I don't knoe why the line 116 and 117 is:$vbulletin->vbs_category = unserialize($vbulletin->vbs_category);
$vbulletin->vbs_admin = unserialize($vbulletin->vbs_admin);
I tried to disable the necessary of a category but nothing

[Delphiprogrammi]

Why dont you post up your changes? I had already posted that the problem was with the datastore so I made a post here with some changes but it did not seem to work for all.

i'm not allowed to post them according by the rules.The original seems to be busy with other things but that doesn't mean i can go ahead and violate the rules

[sinisterpain]

i'm not allowed to post them according by the rules.The original seems to be busy with other things but that doesn't mean i can go ahead and violate the rules
Not sure I follow you, If the author basically abandoned the hack and you have some code changes that fix problems how is that a violation of the rules?

[Delphiprogrammi]

Not sure I follow you, If the author basically abandoned the hack and you have some code changes that fix problems how is that a violation of the rules?


This modification may not be copied, reproduced or published elsewhere without author's permission.
and vBulletin (.org) is pretty strict in that policy.I'll give you a hint through look at your database table named datastore then look in /includes/functions_vbsupport.php update_datastore() function that table contains two fields data and serialize however in that function is only one (requirerd) parameter set / updated so an error will occour

[NineVB]

When Im editing the navbar and I put this code in :

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

then this comes up:



Can someone help me please?
I found this problem too. The code as from the readme file, is missing a closing ].
<a href="vbsupport.php$session[sessionurl_q">
should be
<a href="vbsupport.php$session[sessionurl_q]">
Hope this helps.

[sinisterpain]

This modification may not be copied, reproduced or published elsewhere without author's permission.
and vBulletin (.org) is pretty strict in that policy.I'll give you a hint through look at your database table named datastore then look in /includes/functions_vbsupport.php update_datastore() function that table contains two fields data and serialize however in that function is only one (requirerd) parameter set / updated so an error will occour

If your posting on vb.org within the author's mod for a fix of problems, what you quoted does not apply since you are not redistributing, copying or publishing elsewhere.

[shungo]

Hey,

Since upgrade to 3.6.7, ajax functions seem not working at all.

And if i click on advanced edit, nothing appears in message box.

Anyone for help please ? :)

Best regards :)

[DigitalXWeb]

Has anyone got a fix or hack to allow user to submit attachments for 3.6.5?

I would be interested in having attachments working as well in 3.6.7, I have everything else working fine except those.

[silvermerc]

So this doesnt work on 3.6.7?

[DigitalXWeb]

So this doesnt work on 3.6.7?

Not 100%. Most of the the things work but there are a few glitches due to version differences.

[LewisAinslie]

Does this work? I keep getting Error when trying to access the view thread

http://community.gamerjuice.co.uk/vbsupport.php?do=viewthread&tid=3

Thats the error

[InTheBox]

Does this work? I keep getting Error when trying to access the view thread

http://community.gamerjuice.co.uk/vbsupport.php?do=viewthread&tid=3

Thats the error

I am assuming you are trying this as an unregistered user as that is how I am seeing it following the link above.

The "Guest" access is a bit broken (at least in my opinion) it is possible to get it somewhat working however it doesnt work correctly.

To activate Guest access make sure the vbSupport Unregistered Access setting under ACP->vbSupport-> Manage settings is set to "No" (this is a bug that was pointed out elsewhere in the thread) you also need to set the appropriate vbSupport permissions for the group as well. Note: There is quite a few permission problems / checks with the current code in regards to Guest access. At least with 3.6.7

[RedGTiVR6]

without reading through the 39 pages of this thread...
does this work on 3.6.8?
I cannot find a demo of this anywhere, just screen shots.
The big red bold text at the top of the mod bothers me a bit...is it safe to install now? Has anyone run into any issues?

[RedGTiVR6]

Fresh install on 3.6.8.

Go to manage categories and there are two errors (the same error shows up twice) on this page:

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

What does this mean?

EDIT: This post has the solution:

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.

[RedGTiVR6]

got it working but am now facing a problem

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

there is no option to choose a caotogorey and when u enter the message it says that im using 3.6.4 and have done all extra edits u have mentioned

What was your solution for this? I'm running into the same problem.

Nevermind: Post 500 contained the fixed code.

Now, I really need attachments to work as this is critical for our use. Every bug report needs to have a log.txt file with it....

[yoyoyoyo]

Ok - this is really weird - I uploaded the files to my server, imported the product, and then refreshed the ACP before doing the template edits, and found no vbSupport CP nav listed - I double-checked that all of the files went to the right folder, especially that the cpnav_vbsupport.xml went to "/public_html/forum/includes/xml" but it is see it is still not there.

http://img297.imageshack.us/img297/641/errorzj7.jpg

I am running 3.6.8 - any ideas?

[WarLion]

go to your plugins and product and enable the product is disable by default

[yahoooh]

pm not work , i did the fix codes but not work
when the ticket close , the quick reply show and work even the ticket is closed
attachement is not wrok

vb:3.6.8
php:5.2.4

[Iskib]

So any word on a full port to 3.6.8 with all features working ?

[Lionel]

I managed to get attachments to display, but I am having a hard time with editpost (when greater than post id#1)

I am also having a hard time with permissions. I thought of disabling editpost but it goes thru

[dodgeuk19]

nm,

sorted it

thanks

dodge

[Delphiprogrammi]

I managed to get attachments to display, but I am having a hard time with editpost (when greater than post id#1)

I am also having a hard time with permissions. I thought of disabling editpost but it goes thru

look at newattachment.php and attachment.php if the editpost method is used vBulletin wants a postid ($postid) i think you somehow need to pass that variable in the newattachment template there's a hidden variable called edittpost (coming from a form) so i guess something like


$vbulletin->input->clean_gpc('p','editpost',TYPE_BOOL);


would be needed.Also in the editpost method you need to pass this to newattachment.php?$session[sessionurl]&p=$postinfo[postid]&editpost=1&postsstarttime=$poststarttime&posthash=$posthash

in the admincp file (vbsupport.php) are to manny security holes $_REQUEST values being used directly(they must be cleaned).The database being queried directly etc etc
this needs a start from scratch otherwise some holes will manage to slip in

[Lionel]

@delphiprogram Agreed! I gave up on this. The more I am fixing, the more other problems pop up.

[Lionel]

For those who are having problems with deleting a post, this seems to do the job for me. Not the most elegant, but hey it seems to work.

in plugins/vbsupport_inlinemod.php replace the foreach loop with

$post['firstpostid'] = false;
$gotothread = true;
foreach ($postarray AS $postid => $post)
{
if($post['firstpostid'] == $post['postid'])
{
$postman =& datamanager_init('Ticket_Thread', $vbulletin, ERRTYPE_SILENT, 'ticketpost');
}else{
$postman =& datamanager_init('Ticket_Post', $vbulletin, ERRTYPE_SILENT, 'ticketpost');
}
$postman->set_existing($post);
$postman->delete($post['postid'], $post['firstpostid'], array(
'userid' => $vbulletin->userinfo['userid'],
'username' => $vbulletin->userinfo['username'],
'reason' => $vbulletin->GPC['deletereason'],
'keepattachments' => $vbulletin->GPC['keepattachments']
));


unset($postman);

[Delphiprogrammi]

ey....


$show['attachments'] = (vbsupport_can_moderate('canviewattachments')) ? true : false;


but still they won't display and you get the "no permissions" screen when clicking any attachment.While attachments do work fine in 1.1a

[Lionel]

Attachments display for me ... I don't remember what I did but they display just fine

[Lionel]

I did a beyond compare to view my changes. I am very busy, so I am putting this up like that.

Here is what I found in the main file.

1-Replace below with $threadid

$getpost = $vbulletin->db->query_first("
SELECT postid
FROM " . TABLE_PREFIX . "vbs_ticket_post
WHERE threadid = $threadinfo[threadid]
ORDER BY dateline LIMIT 1

replace below with

$attachurl = "p=$postinfo[postid]";

$attachurl = "t=1";
$newpost_attachmentbit = prepare_newpost_attachmentbit();
eval('$attachmentoption = "' . fetch_template('newpost_attachment') . '";');

$attach_editor['hash'] = $postinfo['postid'];
$attach_editor['url'] = "newattachment.php?$session[sessionurl]p=$postinfo[postid]&amp;editpost=1&amp;poststarttime=$poststarttime&amp;posthash= $posthash";
}
else
{
$attachmentoption = '';
}


replace below with

$newpost['message']


$editorid = construct_edit_toolbar(
$postinfo['message'],
0,
'',
true,


replace below with (twice)


$attachurl = "f=2";



$attachurl = "t=1";
$newpost_attachmentbit = prepare_newpost_attachmentbit();
eval('$attachmentoption = "' . fetch_template('newpost_attachment') . '";');

$attach_editor['hash'] = $foruminfo['forumid'];
$attach_editor['url'] = "newattachment.php?$session[sessionurl]f=$foruminfo[forumid]&amp;poststarttime=$poststarttime&amp;posthash=$posthas h";


And if you do my change above, all the bugs are done as far as I could tell. If someone finds more, then let me know.

[DarkLord7854]

Hey,

Was wondering if there's a simple way I can add another drop-down menu category selection, or add a small input box which would add whatever text was put into it and make it the topic/ticket description, or add the text after the title seperated by a hyphen?

Ninja Edit:
Can't download attachments, says permissions ain't set right even though they are >.<

[Takamine334]

So, users can create a ticket. However, when submitting, it says they are not authorized to view the page. If they go to their ticket listings, it shows 1, but they cannot see the ticket.

[Takamine334]

the Quick Reply is very small. How do I make it the size of a normal quick reply?

[Solja-Mike]

Is there any type of reporting feature for this addon?

[jschvili]

Can anyone offer a demo or screenshots? Sounds like a perfect hack, but I like to SEE how it work and look like before I install it. Thank you, guys!

[yahoooh]

any update?

[steven1091]

"Database error in vBulletin 3.6.8:

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 : Tuesday, February 26th 2008 @ 12:20:29 AM
Script : http://habbovalley.com/vbsupport.php?do=viewthread&tid=11
Referrer : http://habbovalley.com/vbsupport.php?do=newthread
IP Address : 82.20.36.29
Username : Blured"


Get that when i try to submit a ticket?

[Shawn Yue]

Warning: require_once(/home/shawnyue/public_html/forum/includes/functions_vbsupport.php) [function.require-once]: failed to open stream: No such file or directory in /admincp/plugin.php(1970) : eval()'d code on line 173

Fatal error: require_once() [function.require]: Failed opening required '/home/shawnyue/public_html/forum/includes/functions_vbsupport.php' (include_path='.:/x10hosting/php2/pear/PEAR') in /home/shawnyue/public_html/forum/admincp/plugin.php(1970) : eval()'d code on line 173

This Error Appear When I Upload The Vbsupport xml file at the admin cp panel....And Never Successfully Install The Software......

and I Dun knwo I uPLOAD THE FILE CORRECTLY SOMEONE PLS GUILD ME....

[Shawn Yue]

What Does this Mean WHEN I INSTALLL

ADD NAVBAR CODE IN IT

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting ']' in /home/shawnyue/public_html/forum/includes/adminfunctions_template.php(3596) : eval()'d code on line 88

[Meestor_X]

Where can I see what this mod looks like?

I went to the cmgsccc (http://www.cmgsccc.com/) web site and even registered to the forums, but I can't see any forum with vbsupport, or any screenshots....

Is this the most current and best mod for creating support tickets on vb? (I know, vague question, but I'd like to know if it's any good...)

Thanks in advance!

-Andy.

[Shawn Yue]

need help read my above post pls

[flasher33]

same here

Parse error: syntax error, unexpected T_CHARACTER, expecting ']' in /home/pclink4/public_html/vb/includes/adminfunctions_template.php(3587) : eval()'d code on line 82

[Shawn Yue]

Warning: require_once(/home/shawnyue/public_html/forum/includes/functions_vbsupport.php) [function.require-once]: failed to open stream: No such file or directory in /admincp/plugin.php(1970) : eval()'d code on line 173

Fatal error: require_once() [function.require]: Failed opening required '/home/shawnyue/public_html/forum/includes/functions_vbsupport.php' (include_path='.:/x10hosting/php2/pear/PEAR') in /home/shawnyue/public_html/forum/admincp/plugin.php(1970) : eval()'d code on line 173

This Error Appear When I Upload The Vbsupport xml file at the admin cp panel....And Never Successfully Install The Software......

and I Dun knwo I uPLOAD THE FILE CORRECTLY SOMEONE PLS GUILD ME....

And

What Does this Mean WHEN I INSTALLL

ADD NAVBAR CODE IN IT

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting ']' in /home/shawnyue/public_html/forum/includes/adminfunctions_template.php(3596) : eval()'d code on line 88

Please Someone Guild Me With tHE iNSTALL I THINK INSTALL WRONGLY OR WHAT....

[SEOvB]

Are you guys using vBulletin 3.5?

If you are using 3.6 or 3.7 then this probably doesnt work on it

[Shawn Yue]

..........I Using 3.6.8...SO IT DOESNT WORK

[flasher33]

yah seems to be that way
will try to find my old 3.5.x and see if it works

[Shawn Yue]

how i wish it work on 3.6.8 and 3.7...

[koke]

work in 3.7 ???

[Ekin Cheng]

No IT Does Not Work In 3.7

[TheInsaneManiac]

It works in 3.6.8. I figured out the problem guys. For some reason when you install it, it automatically is disabled? Why I have no clue. Just enable it and enjoy the modification.

Although if I post a ticket I get this:

Database error in vBulletin 3.6.8:

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 vb_vbs_ticket_post AS post
LEFT JOIN vb_user AS user ON(user.userid = post.userid)
LEFT JOIN vb_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vb_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN vb_reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
WHERE post.postid IN (0,1)

ORDER BY post.dateline;

[technom8t]

I have this working in VB 3.6.8 patch level 2, i did have to mix and match some of the file, but i do not have any issues with it so far...........

[Shawn Yue]

Hope This Work For 3.7X AnyBody Can get This Work???

[Wayne2k1.com]

Hope This Work For 3.7X AnyBody Can get This Work???

Using 3.7.1-PL1

Works like a charm :)

[NexVision]

Using 3.7.1-PL1

Works like a charm :)
Care to share how u got it working without error as none of the the other help center add ons are comprehensive enough.

[OPsNaStYM0FO]

Anyone get this working on a new version ?

[OPsNaStYM0FO]

I have this working now on vbulletin 3.8.4 Patch level 1 .

You will need to open vbsupport.php and find

customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight

then under it there is level remove the whole line starting with "and ending with "

there is a few lines I think 3 and you can then save it and no errors

[root's]

<a href="https://vborg.vbsupport.ru/showpost.php?p=1231471&postcount=542" target="_blank">https://vborg.vbsupport.ru/showp...&postcount=542</a>

[blind-eddie]

I have vbsupport v2.0.0 Beta working with 3.8.4 but, attachments is not working.
Anyone still using this?
If so, do you have attachments working & how did you do it?
This mod works better then any support/help desk mod I have found, just need to work out a few bugs.

Thanks.