View Full Version : vBSupport v2.0.0 Beta 2
CMX_CMGSCCC
08-09-2005, 10:00 PM
vbSupport v2.0.0 BETA 2 by CMX (http://www.cmgsccc.com)
Official Homepage - http://www.vbplaza.com
v1.1 of this modification was found to contain an SQL injection. If you run v1.1 of this modification, you are hereby advised to update to v1.1a of this modification. To update from v1.1 to v1.1a, grab the v1.1a ZIP and overwrite the vBSupport.php file on your server with the new version.
Note that while no other vulnerabilities were noticed by vBorg Staff, this does not mean that such things do not exist. vBorg Staff fixed the one SQL injection according to these (https://vborg.vbsupport.ru/info.php?do=security) rules. Any other fixes that may be needed now or in the future are left to the original author.
-- vBorg Staff
Welcome to the latest hack by CMX for your vBulletin Message Board. This is a fully featured Ticket based support system for you website. If you had installed the older version of vBSupport v1.1, then you already have an idea what this sytem is all about.
Basically, this system will allow your Forum Members to create new support tickets using the same login as your vBulletin forums login for your users. There have been many improvements from the older v1.1 vBSupport System I made a while back.
New Features for v2.0.0+:
1) Permission Checks are better implemented and are more useful now.
2) AJAX Open/Closing tickets by double clicking the thread icon when listing tickets.
3) AJAX Ticket Title editing just like the forums Thread editing as well.
4) Post Quick Reply is now using the AJAX system where possible to post replies to tickets.
5) You can now Edit posts inline using the AJAX system as well.
6) Inline Moderation when listing tickets includes Delete Ticket, Open Ticket, Close Ticket.
7) You can now delete individual Posts from Tickets via the Inline Moderation as well.
8) MASSIVE performance load improvements. On my forums with 200,000 members, it would take 4 seconds to view a ticket due to a very strenuous query. Now it loads tickets in 0.13 seconds.
9) Category Administration has now been moved into the Admin CP instead of on the vbSupport page itself.
10) Everything should be fully phrased now as well.
Other Features:
1) IF you have installed the older vBSupport version, it will auto uninstall it for you. (It will NOT delete the old tickets!)
2) Admin CP -> vbSupport Maintenance -> Import Old Tickets is now in and working to import the old tickets if you had vBSupport installed.
3) A ton of permissions per Usergroup to set the settings up the way you want them.
vbSupport v2.0.0 BETA 2 Updates:
1) Bugfix: Quick Reply functions properly when you have the Quick Reply option enabled for Yes - Click Required.
2) Bugfix: Normal Reply/Closed button is there when viewing a ticket.
3) Bugfix: Admin CP Deleting a ticket now functions properly.
4) Bugfix: AJAX Edit feature does not display an alert(postid) anymore.
5) Bugfix: Active On/Off works for each category when enabled/disabled from the Admin CP.
6) Bugfix: Usergroup Permissions are now working for Allowed Usergroups & Denied Usergroups.
7) Bugfix: Changed some templates that linked to the wrong PHP files.
8) Bugfix: New Thread template is cleaned up a bit and it displays properly in Firefox too now.
9) Bugfix: Active phrase now is installed as a vbSupport phrase.
PLEASE NOTE: This is the very first release of vbSupport 2.0.0. Which means that this is a BETA release. I will try to correct any issues found ASAP.
I have vbSupport v2.0.0 BETA 1 running on my production site at www.cmgsccc.com, so I should be able to find most bugs since there are over 200,000 registers members there and it will get put to the test quite a bit. However, if you find something, please post it here.
By installing this BETA version, it will uninstall the previous vBSupport system automatically. It will leave the old ticket tables upon installation. It should import the older Ticket Categories that you had before as well.
I would also like to recommend that you backup your MySQL database, just in case a mishap occurs as this is BETA.
ALSO: The older version vBSupport v1.1 will be here for download until v2.0.0 comes out of BETA. vBSupport v1.1 is NOT in the BETA stage, only vbSupport v2.0.0 is in the BETA stage.
Upgrading Instructions From vBSupport v1.x
NOTE: These are ONLY applicable if you are upgrading from vBSupport v1.x!
1) Delete all of the older vBSupport files from your server. If you are not sure which files they are, the vBSupport v1.1 is still available for download here so you can download that and look at the files in there.
2) Upload all of the files in the upload folder to your forums ROOT folder. Make sure that if it asks about any files, that you set Overwrite to overwrite all files as well.
3) In your Admin CP, goto Plugin System -> Manage Products -> Add/Import Products at the bottom -> Select the XML file that you have downloaded in the package named product-vbsupport.xml -> Set Allow Overwrite to YES -> Import.
4) Perform the template edits below and you have vbSupport v2.0.0 up and running!
5) Refresh your forums Admin CP page.
6) Admin CP -> vbSupport Maintenance -> Import Old Tickets if you want to save the older tickets. Otherwise you can skip this feature.
New Installation Instructions:
1) Upload all of the files in the upload folder to your forums ROOT folder. Make sure that if it asks about any files, that you set Overwrite to overwrite all files as well.
2) In your Admin CP, goto Plugin System -> Manage Products -> Add/Import Products at the bottom -> Select the XML file that you have downloaded in the package named product-vbsupport.xml -> Set Allow Overwrite to YES -> Import.
3) Perform the template edits below and you have vbSupport v2.0.0 up and running!
Template Edits:
A) Template 'navbar':
Find:
<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>
Add Below:
<!-- 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 -->
B) Template 'postbit_legacy':
Find:
<if condition="$show['postcount']">#<a href="showpost.php?$session[sessionurl]p=$post[postid]&postcount=$post[postcount]" target="new" rel="nofollow" id="postcount$post[postid]" name="$post[postcount]"><strong>$post[postcount]</strong></a></if>
[code]
Add Above:
[code]
<!-- vbSupport start -->
<if condition="$show['ticketcount']">#<a href="vbsupport.php?$session[sessionurl]do=viewpost&pid=$post[postid]&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]&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&pid=$post[postid]&postcount=$post[postcount]" target="new" rel="nofollow" id="postcount$post[postid]" name="$post[postcount]"><strong>$post[postcount]</strong></a> </if>
<!-- vbSupport end -->
ENJOY!!
-CMX
nexialys
08-10-2005, 07:25 PM
<a href="https://vborg.vbsupport.ru/showthread.php?t=77155" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=77155</a> ... kinda like the same as this one, isn't it ?!
... btw, good to have a variety of tools!
Rover416
08-10-2005, 07:26 PM
I get this error when i click on ticket system
Database error in vBulletin 3.5.0 Release Candidate 2:
Invalid SQL:
SELECT ticket.*
,icon.title AS icontitle, icon.iconpath
FROM vbticket AS ticket
LEFT JOIN vbicon AS icon ON(icon.iconid = ticket.iconid)
WHERE postuserid = 1 AND open = 1
ORDER BY dateline DESC;
MySQL Error : Table 'elite_forum.vbticket' doesn't exist
Error Number : 1146
I have checked and the other tables are there but this on isnt,I uninstalled and reinstalled and still had the same problem.
CMX_CMGSCCC
08-10-2005, 07:34 PM
Oops, I forgot to put the TABLE_PREFIX into the mysql create table installation code.
Its fixed in vBSupportv0.1a.zip
Also the Helpdesk looks nice too, I never seen it before. But its not converted to v3.5 yet?
-CMX
If you need to remove the old tables, run the 2 queries below.
DROP TABLE IF EXISTS forums_ticket;
DROP TABLE IF EXISTS forums_ticketreply;
Rover416
08-10-2005, 07:39 PM
That fixed it,thank you.
Have been waiting for something like this. :D
Rover416
08-10-2005, 08:00 PM
Sorry,another problem.
When you submit,reply or delete a ticket it tells you "cannot find phrase xxxxxx".
The phrases are in the phrase manager and it does what its supposed to,it just does not seem to be picking up on the phrases.
Jedi Blaze
08-10-2005, 09:17 PM
Works fine for me. /me clicks install
Nice job! :)
CMX_CMGSCCC
08-11-2005, 02:13 AM
Sorry,another problem.
When you submit,reply or delete a ticket it tells you "cannot find phrase xxxxxx".
The phrases are in the phrase manager and it does what its supposed to,it just does not seem to be picking up on the phrases.
Did it install the phrases to GLOBAL?
-CMX
FASherman
08-11-2005, 02:21 AM
https://vborg.vbsupport.ru/showthread.php?t=77155 ... kinda like the same as this one, isn't it ?!
... btw, good to have a variety of tools!
Hardly. Thats kind of like claiming that a 'vette and a Viper are the same.
That one is a 3.0.X hack. This is a 3.5 plugin. That in itself is enough of a difference.
Sovereign
08-11-2005, 02:05 PM
Nice hack. Grr, just installed 0.1 yesterday, must upgrade!
Neal-UK
08-11-2005, 02:56 PM
Nice hack. Grr, just installed 0.1 yesterday, must upgrade!
my permission are not saving, any ideas?
Neal-UK
08-11-2005, 03:00 PM
my permission are not saving, any ideas?
Just reinstalled again and selected overwrite, seems to be doing it now. My forum is being weird today!
Does it support attachments?? That is a definitely useful option.
CMX_CMGSCCC
08-11-2005, 04:18 PM
Just reinstalled again and selected overwrite, seems to be doing it now. My forum is being weird today!
I was going to say that it has to recreate the bitfields, thats probably why it wasnt saving. In any case you can rebuild the bitfields manually by uploading the bitfield xml file to /includes/xml and then going to the URL /admincp/index.php?do=buildbitfields
About adding attachments, they are not supported yet. This is my first hack for vB 3.5.0, so I'm still kind of in the learning process. I could probably allow attachments in a future version.
-CMX
Creed
08-11-2005, 09:06 PM
Is there no file attachment of v0.2 or am I missing something?
CMX_CMGSCCC
08-11-2005, 09:17 PM
Is there no file attachment of v0.2 or am I missing something?
Right, file attachments was added in the v0.3 version per request.
So you should upgrade from v0.2 to v0.3. You do not need to uinstall it, just add the product-vBSupport.xml file and set "Allow Overwrite" to Yes and it should install properly.
Once you install v0.3, goto the Usergroup permissions and set "Can Post Attachements" and "Can View Attachments" for the usergroups you want to allow them for.
-CMX
Neal-UK
08-11-2005, 11:44 PM
Right, file attachments was added in the v0.3 version per request.
So you should upgrade from v0.2 to v0.3. You do not need to uinstall it, just add the product-vBSupport.xml file and set "Allow Overwrite" to Yes and it should install properly.
Once you install v0.3, goto the Usergroup permissions and set "Can Post Attachements" and "Can View Attachments" for the usergroups you want to allow them for.
-CMX
Excellent mod and installed thankyou
Neal-UK
08-11-2005, 11:49 PM
Getting this error when trying to attach something:
Database error in vBulletin 3.5.0 Release Candidate 2:
Invalid SQL:
UPDATE FORUMticketreply SET attach=1 WHERE ticketreplyid=1;
MySQL Error : Unknown column 'attach' in 'field list'
Error Number : 1054
Date : Friday, August 12th 2005 @ 12:48:20 AM
Script : http://www.*******.com/forum/vBSupport.php
Referrer : http://www.***.com/forum/vBSupport.php?do=newticket
And this with no attachment:
Database error in vBulletin 3.5.0 Release Candidate 2:
Invalid SQL:
UPDATE FORUMticketreply SET attach=0 WHERE ticketreplyid=2;
MySQL Error : Unknown column 'attach' in 'field list'
Error Number : 1054
Date : Friday, August 12th 2005 @ 12:50:29 AM
Script : http://www.************.com/forum/vBSupport.php
Referrer : http://www.********.com/forum/vBSupport.php?do=newticket
Neal-UK
08-11-2005, 11:53 PM
Getting this error when trying to attach something:
And this with no attachment:
Also getting a db error trying to delete them too
CMX_CMGSCCC
08-12-2005, 12:03 AM
Oops, I forgot to add the upgrade option to add the attach column to the table. Going to update the file to v0.3b very shortly.
You can fix this error by running the following query:
ALTER TABLE (TABLE_PREFIX)ticketreply ADD COLUMN attach SMALLINT UNSIGNED NOT NULL DEFAULT '0';
Obviously replace the entire string "(TABLE_PREFIX)" with your table prefix, or remove "(TABLE_PREFIX)" entirely if you dont have one.
-CMX
Neal-UK
08-12-2005, 12:03 AM
Also getting a db error trying to delete them too
I find that by uninstalling and reinstalling, the system works 100% as it is doing now. For some reason, the upgrade option isn't working with this mod.
Still a good mod though, well done!
Neal-UK
08-12-2005, 12:04 AM
I find that by uninstalling and reinstalling, the system works 100% as it is doing now. For some reason, the upgrade option isn't working with this mod.
Still a good mod though, well done!
Posted at the same time, my above message was posted before CMX_CMGSCCC released the fix.
nine45
08-12-2005, 12:09 AM
I get this message when used by a member, not posting just visiting the ticket system, the Warning appears at the top but otherwise seems to be working: Invalid argument supplied for foreach() in /includes/functions.php on line 327 but it works fine for the admin. Puzzled..help
CMX_CMGSCCC
08-12-2005, 12:34 AM
I get this message when used by a member, not posting just visiting the ticket system, the Warning appears at the top but otherwise seems to be working: Invalid argument supplied for foreach() in /includes/functions.php on line 327 but it works fine for the admin. Puzzled..help
Not 100% sure what is causing that, but I added a couple extra checks for the is_member_of call to verify that some admins were found, as well as verifying that an array exists to this call. (I created a new user account, but I unable to replicate this problem.)
Hopefully that will fix your problem.
If you have downloaded and installed v0.3b, you just need to upload the vBSupport.php file.
-CMX
nine45
08-12-2005, 12:43 AM
Done that, it didn't fix it, I also now get this message when a member clicks the send new ticket link: Could not find phrase 'no_permission_create_tickets
CMX_CMGSCCC
08-12-2005, 12:48 AM
Done that, it didn't fix it, I also now get this message when a member clicks the send new ticket link: Could not find phrase 'no_permission_create_tickets
It sounds like the installation is not 100%. Because it would be very odd that that phrase doesnt exist. If you edit the product-vBSupport.xml file, the phrase is there. When you are installing the file, did you try to "Allow Overwrite"?
-CMX
nine45
08-12-2005, 12:58 AM
Yes I allowed overwrite, just tried un-installing and re-uploading all the new files and still have the same errors, I checked the file and no_permission_create_tickets exists in the XML and it is also present in phrases, just did a search for it...even more confused.
CMX_CMGSCCC
08-12-2005, 03:47 AM
What group/category is the no_permission_create_tickets phrase in?
-CMX
gldtn
08-12-2005, 09:58 PM
https://vborg.vbsupport.ru/showthread.php?t=77155 ... kinda like the same as this one, isn't it ?!
... btw, good to have a variety of tools!
Same idea, but the other one is not upgraded to the lastest vB version nor does it support attachments.
CMX_CMGSCCC,
Sorry if I missed it, but does this allow the administrator, mods, to be notified in any way of new tickets or does it let the "ticket owner" know that there has been a reply? Thru PMs, Email? Also is the usergroup permissions set thru the default usergroup permissions on the admincp?
nine45
08-12-2005, 10:14 PM
The phrase is in the error messages phrases
What group/category is the no_permission_create_tickets phrase in?
-CMX
CMX_CMGSCCC
08-12-2005, 11:20 PM
Maybe there has to be something in the PHP to cache the error messages properly for some vB setups. Maybe KirbyDE can help here, I will try to PM him about it.
As of right now it does not allow the support admins to be notified of new tickets. But its on the list of stuff to do at the moment. I want to add the following options to it before it goes to version 1.0
1) Option to be notified via PM/Email (probably check boxes)
a) For all new tickets.
b) For replies to only tickets that you are assigned to.
c) For all replies no matter who is assigned (not sure this is necessary though).
These options will apply to not only the support admins, but even for the users if they want to receive a PM/Email upon a reply to their ticket too.
2) Ability for admins to search for tickets. i.e. Search for all new tickets since your last visit, or search all tickets / replies in a category for usernames or userids and more.
3) More navbar options like listing new tickets, or tickets with replies since your last visit.
And anything else I can think of along the way. The dev on these features will be done over time, as I'm really busy as of late with my webpage http://www.cmgsccc.com and moving to our new house this coming week as well.
-CMX
Sovereign
08-15-2005, 01:08 AM
I have this after upgrading (I did rebuild bitfields, what is happening???)
Creed
08-15-2005, 08:44 AM
Make sure you've re-uploaded all the files in the "upload" folder.
Rover416
08-15-2005, 09:07 AM
Sorted it.
Sovereign
08-15-2005, 03:36 PM
Now I can't admin cats...I set all Administrator Usergroup permissions to "Yes" but vB unset these (see attached).
Rover416
08-15-2005, 04:34 PM
Now I can't admin cats...I set all Administrator Usergroup permissions to "Yes" but vB unset these (see attached).
I had to run
URL/admincp/index.php?do=buildbitfields
For my before my settings would save.
Sovereign
08-15-2005, 05:07 PM
Funny thing. That fixed it, but I did rebuild bitfields before I tried that...
CMX_CMGSCCC
08-15-2005, 06:26 PM
Is there any way to put in <upgradecode> instead of <installcode> into product xmls? That would solve problems for upgrader's if I could include code in there to do for "updating"?
-CMX
GiJoe
08-15-2005, 07:53 PM
Great mod... :D Anyway to create a block or something to display when new tickets are present or submitted?
Thanks
CMX_CMGSCCC
08-15-2005, 08:26 PM
Yeah, thats one of the things I will be adding before version 1.0. Some more nav buttons to find all new tickets since your last visit and replied tickets since your last visit. As well as the upcoming search for tickets to search by category, time posted, time replied to, words in the title and/or posts as well.
Thanx to the others for helping some users with problems. If I could figure out how to make upgrade code it would go smoother for the upgraders. I have it to rebuild the bitfields when you install it. But I'm not sure if the install code is run when you upgrade. If it is, I wonder if there is an MySQL error and that halts the rest of the install code from running and doesnt rebuild the bitfields?
-CMX
Andreas
08-15-2005, 09:36 PM
I don't see a reason why the Phrase shouldn't be there.
Installcodes are being run if the Version Number of the Installcode is higher then the Installed Version.
So if there is no new Code necessary for a new Version, leave the Version Number of the Install Code as it is.
If there is new Code necessary, create a new Installcode-Block with the New Version Number - or make the install-Code the the installed Version.
As you are truning off mySQL Errors, those (if they happen) will not stop Execution.
Btw: You got some fubar Hook calls in your Classes ;)
CMX_CMGSCCC
08-15-2005, 10:45 PM
I don't see a reason why the Phrase shouldn't be there.
Installcodes are being run if the Version Number of the Installcode is higher then the Installed Version.
So if there is no new Code necessary for a new Version, leave the Version Number of the Install Code as it is.
If there is new Code necessary, create a new Installcode-Block with the New Version Number - or make the install-Code the the installed Version.
As you are truning off mySQL Errors, those (if they happen) will not stop Execution.
Btw: You got some fubar Hook calls in your Classes ;)
I commented all of the hook calls out for now. As I wasnt sure if I should create new hook calls and if I did create new hook calls, how do I add them to the hooks system?
-CMX
RoryF
08-16-2005, 07:42 AM
I unistalled in my localhost, went to update usergroup permissions and i got this error.
Database error in vBulletin 3.5.0 Release Candidate 2:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Fusion City Staff',
`description` = '',
`usertitle` = 'Fusion City Staff',
`opentag` = '<b><font color=#336600>',
`closetag` = '</b></font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`forumpermissions` = '1048575',
`attachlimit` = '0',
`pmquota` = '5000',
`pmpermissions` = '3',
`pmsendmax` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '1',
`genericpermissions` = '4194303',
`genericoptions` = '31',
`profilepicmaxwidth` = '120',
`profilepicmaxheight` = '120',
`profilepicmaxsize` = '20000000',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '20000000',
`profileviewpermissions` = '15',
`supportpermissions` = '0'
WHERE usergroupid=13;
MySQL Error : Unknown column 'supportpermissions' in 'field list'
Error Number : 1054
Date : Tuesday, August 16th 2005 @ 04:37:40 AM
Script : http://fusion-city.net/forum/admincp/usergroup.php
Referrer : http://fusion-city.net/forum/admincp/usergroup.php?do=edit&usergroupid=13
IP Address : 217.44.9.153
Username : Rory
Classname : vB_Database
Some stuff from the support system is still there, and i had to drop the tables in the database manually.
jesus likes pie
08-16-2005, 12:26 PM
Is there a way that a popup pops up when you get a new ticket? Like with PMs...
if not, it would be an awesome addition.
jesus likes pie
08-19-2005, 09:27 PM
bump
lamilein
08-24-2005, 05:56 PM
heya, i hope your move went along good :)
nice plugin i have to say, trying it atm and found something that bothers me:
http://localhost/vb35rc2/vBSupport.php?do=newticket
Fatal error: Cannot redeclare vB_DataManager_Ticket::$ticket in C:\Programme\xampp\htdocs\vb35rc2\includes\class_d m_ticket.php on line 110
got it running on w2k advanced sp4 using xampp (www.apachefriends.org) 1.4.15 std install
(contains:
+ Apache 2.0.54
+ MySQL 4.1.13
+ PHP 5.0.4 + PHP 4.4.0 + PEAR
+ eAccelerator 0.9.3 (PHP5) / 0.9.4-dev(PHP4)
+ Zend Optimizer 2.5.10a )
and using IE5.00
maybe you've got an idea :)
CMX_CMGSCCC
08-24-2005, 06:21 PM
heya, i hope your move went along good :)
nice plugin i have to say, trying it atm and found something that bothers me:
http://localhost/vb35rc2/vBSupport.php?do=newticket
Fatal error: Cannot redeclare vB_DataManager_Ticket::$ticket in C:\Programme\xampp\htdocs\vb35rc2\includes\class_d m_ticket.php on line 110
got it running on w2k advanced sp4 using xampp (www.apachefriends.org) 1.4.15 std install
(contains:
+ Apache 2.0.54
+ MySQL 4.1.13
+ PHP 5.0.4 + PHP 4.4.0 + PEAR
+ eAccelerator 0.9.3 (PHP5) / 0.9.4-dev(PHP4)
+ Zend Optimizer 2.5.10a )
and using IE5.00
maybe you've got an idea :)
I have fixed this bug, it was declaring $ticket twice inside class_dm_ticket.php.
I'm working on version v0.5 at the moment. I was trying to find a way to do the a popup like the pmpopup. I'll have to research some more of the plugin hooks to get that working, but it seems possible.
The stuff I have done for v0.5 right now are as follows:
1) Added new admin feature to 'List New Tickets'.
2) Updated the installer to verify the fields exist before
trying to create them.
3) Fixed the replycount increment code when people reply to
a ticket.
4) Added vBSupport.php?do=rebuildreplycount to rebuild the
ticket reply counts.
5) Fixed a redeclaration bug inside class_dm_ticket.php.
I want to add a couple more features for v0.5 before releasing it.
1) The admin feature to search for tickets. (i.e. search for tickets containing words, or search for tickets in a specified category, or search the titles only, and some more options for the search.)
2) I want to add pages to the ticketlisting. Right now it displays all of the tickets on the same page, I want to fix that and add the page system like vB has for the threads and such. (As well as add an admin option to specify how many tickets you want to list per page for users and for admins.)
The search feature I have started and got a basis 'search' function added, just need to get a good template for the searching options and it should be finished.
The pages I havent started yet, but it should be easy. I hope to have the new version out by this Friday. But I've been really busy as of late, we have just moved into our new home my in-laws are visiting from Germany until September 3rd, so I may not hit the Friday date, but I'm trying :)
-CMX
The Geek
08-24-2005, 06:37 PM
keep up the great work. Its coming along quite nicely. The only thing I would like to see is some initial entry boxes for things like url, ftp, admin account access, that are availible for certain categories of tickets.
The only sketchy thing is handling that kind of sensitive data (ie. md5 it and delete it when ticket closes). I would still be happy as larry without it - its just a suggestion ;)
CMX_CMGSCCC
08-24-2005, 09:39 PM
keep up the great work. Its coming along quite nicely. The only thing I would like to see is some initial entry boxes for things like url, ftp, admin account access, that are availible for certain categories of tickets.
The only sketchy thing is handling that kind of sensitive data (ie. md5 it and delete it when ticket closes). I would still be happy as larry without it - its just a suggestion ;)
It could probably be done, but creating a new ticketfields table. It would obviously add more queries as well. I might look into it when I get some free time.
-CMX
Neal-UK
08-24-2005, 10:13 PM
It could probably be done, but creating a new ticketfields table. It would obviously add more queries as well. I might look into it when I get some free time.
-CMX
An option that sends a PM or e-mail to the user when ticket replied too, and when a new ticket created the admin / mods are notified. Very good mod though.
Xplorer4x4
08-25-2005, 05:02 PM
An option that sends a PM or e-mail to the user when ticket replied too, and when a new ticket created the admin / mods are notified. Very good mod though.
I second that motion. Some sort of notifcation system should be implied at the very least.
*instaled* :)
Xplorer4x4
08-25-2005, 06:15 PM
V0.6 already?????? That was quick. :-p
mikexxx
08-26-2005, 06:03 PM
An option that when a new ticket created the admin / mods are notified. Very good mod though.I agree, this will be nice.
WhisperPntr
08-27-2005, 05:46 PM
Very nice script! I'm currently modifying it to include status (like pending, approved, etc) and also added the quick template organization plugin.
If you want me to show the code for adding the status, or you don't want me working on it, please pm me. :) Thanks again.
<plugin active="1">
<title>vBSupport Template Grouping</title>
<hookname>template_groups</hookname>
<phpcode><![CDATA[$only = array_merge($only, array('support' => 'vBSupport')); ]]></phpcode>
</plugin>
GiJoe
08-28-2005, 01:53 AM
this rocks! Thank you for the time and effort of making this available to us! :D
Xplorer4x4
08-28-2005, 05:06 AM
The only thing this majorly lacks now, as mentioned above, is a system to notify the staff. An option like WhisperPntr said would be nice but a notifcation system is vital to this system IMO.
WhisperPntr
08-28-2005, 05:41 AM
Hi there CMX, I am almost done adding a status option to the script. If you're interested in the small add ons, please pm me or post back here.
Xplorer, the staff member are notified by pms and emails last I checked.
CMX_CMGSCCC
08-28-2005, 06:39 AM
Very nice script! I'm currently modifying it to include status (like pending, approved, etc) and also added the quick template organization plugin.
If you want me to show the code for adding the status, or you don't want me working on it, please pm me. :) Thanks again.
<plugin active="1">
<title>vBSupport Template Grouping</title>
<hookname>template_groups</hookname>
<phpcode><![CDATA[$only = array_merge($only, array('support' => 'vBSupport')); ]]></phpcode>
</plugin>
In this game, the more eyes/help on the coding the better. I have just used the microstats plugin to see that there were a lot of uncached templates. In the v0.7 version, that will be fixed, there should be 0 uncached templates when v0.7 is out.
I'll add your plugin code to the installer for v0.7 as well. I have just changed the ticketlistbit template to show the data like this as well.
I also have done the followint stuff for v0.7:
1) Used the microstats hack to see that some templates were
uncached. Added lines to the PHP to cache them, it should
speed up the load times of 'showticket' dramatically.
2) Updated the ticketlistbit template a bit to be more useful.
a) It shows tickets with no replies in BOLD.
b) It shows the category under the ticket / ticket starter.
c) It shows the open/closed status.
d) It shows the last poster to the ticket.
e) It shows the number of replies to the ticket.
f) It shows an open/closed icon in addition to the ticket
icon. (It will use new icons if the ticket has been
updated since your last visit.)
3) It now lists the tickets in the order they have been
created / replied to.
4) Rebuild Reply Count has been changed to Rebuild Info.
a) It updates the replycount.
b) It updates the lastposter.
c) It sets replydateline to dateline if equal to 0.
NOTE: If you are upgrading, you should run Rebuild Info after
you have installed the product XML.
There are a few more things I want to get into v0.7, then a release will happen. (Like the notification thing, it will require a new flag to the "user" table so it can be enabled per user basis and not via usergroup.)
-CMX
Xplorer4x4
08-28-2005, 07:10 AM
Xplorer, the staff member are notified by pms and emails last I checked.
I see that the person submiting the ticket is able to be notfied via email and/or PM but i do not get a notification when somone posts a ticket.
WhisperPntr
08-28-2005, 12:18 PM
Hey CMX,
That sounds great and it would be great to work alongside you as well as develop an extra plugin to have this interface with Ron1n's vbpurchase (a hack which I already have his permission to update and use).
Here are some screens of the changes that I've done, as well as a modification of the ticket template.
If you're interested in seeing the code changes, I'll modify the script I have to use your 0.7 version and then send the changes I added to you. They're very rudimentary and are based on the category updates.
Cheers!
~Whisper
CMX_CMGSCCC
08-28-2005, 03:21 PM
Hey CMX,
That sounds great and it would be great to work alongside you as well as develop an extra plugin to have this interface with Ron1n's vbpurchase (a hack which I already have his permission to update and use).
Here are some screens of the changes that I've done, as well as a modification of the ticket template.
If you're interested in seeing the code changes, I'll modify the script I have to use your 0.7 version and then send the changes I added to you. They're very rudimentary and are based on the category updates.
Cheers!
~Whisper
Sounds good, I'll release v0.7 now so you can add the stuff. The other feature I want to add will take a little longer than I have today. And I'm going on a mini-vacation with the family this Monday to Thursday. So better to release v0.7 now and save the "notification per user" til I get back.
-CMX
Xplorer4x4
08-28-2005, 06:09 PM
I have found a few bugs. First off if you only upload the product XML file your system will look like this:
http://img174.imageshack.us/img174/5592/newbitmapimage22og.png
I uploaded all the file over writing the old ones and it fixed it.
The only other bug I see is there is no post icon asigned for a closed ticket. I just see a red X linked to www.yoursite.com/forums (http://www.yoursite.com/forums)
Wasn;t sure if you guys were aware of that or not so figuered I would make note of it.
I would still love to see a staff notifcation method. :p
CMX_CMGSCCC
08-28-2005, 08:49 PM
I have found a few bugs. First off if you only upload the product XML file your system will look like this:
http://img174.imageshack.us/img174/5592/newbitmapimage22og.png
I uploaded all the file over writing the old ones and it fixed it.
The only other bug I see is there is no post icon asigned for a closed ticket. I just see a red X linked to www.yoursite.com/forums (http://www.yoursite.com/forums)
Wasn;t sure if you guys were aware of that or not so figuered I would make note of it.
I would still love to see a staff notifcation method. :p
The first bug was because the files were not all uploaded I would have guessed. The second was a bug in the way the double icon system was working. I have fixed that in v0.7b, and added a quick notification to notify the assigned tech that the ticket was replied to. Later on, I will make it more elaborate so each admin can choose if they want to get notified or not, and via PM or Email too.
-CMX
Xplorer4x4
08-28-2005, 09:04 PM
The first bug was because the files were not all uploaded I would have guessed.
Nope all the files were uploaded as I have been runing this since version 0.5. Plus wouldn't the hack itself be usless with out all the files?
CMX_CMGSCCC
08-28-2005, 09:23 PM
Nope all the files were uploaded as I have been runing this since version 0.5. Plus wouldn't the hack itself be usless with out all the files?
Yes, but between versions sometimes the class_*.php files do not get changed unless a new feature was added to the database. So I imagine some people were just uploading the vBSupport.php file. The class_ files have been updated to add a couple new features, and to get the replydateline working as well.
Do you still have this problem with the v0.7b zip?
-CMX
WhisperPntr
08-29-2005, 09:29 AM
Thanks CMX. I'll be working on the changes now and send you a zip file sometime my tonight or tomorrow. I will mark the changes I've made with either a <!-- WhisperPntr //--> or a ##WhisperPntr both of which you may feel free to delete once the code is to your liking.
Sounds good, I'll release v0.7 now so you can add the stuff. The other feature I want to add will take a little longer than I have today. And I'm going on a mini-vacation with the family this Monday to Thursday. So better to release v0.7 now and save the "notification per user" til I get back.
-CMX
Xplorer4x4
08-29-2005, 06:33 PM
Yes, but between versions sometimes the class_*.php files do not get changed unless a new feature was added to the database. So I imagine some people were just uploading the vBSupport.php file. The class_ files have been updated to add a couple new features, and to get the replydateline working as well.
Do you still have this problem with the v0.7b zip?
-CMX
When I said I had to reupload the PHP files I was upgrading to 6.0 or 7.0. Sorry I can't recall which one specifacly as you have released like 3 versions in the past week. It was proabbly the orignal 7.0 upgrade.
Your upgrade instructions say upload the new XML file, yet here you say we need to upload the PHP files sometimes. Make up your mind. :p
WhisperPntr
08-30-2005, 12:30 AM
When I said I had to reupload the PHP files I was upgrading to 6.0 or 7.0. Sorry I can't recall which one specifacly as you have released like 3 versions in the past week. It was proabbly the orignal 7.0 upgrade.
Your upgrade instructions say upload the new XML file, yet here you say we need to upload the PHP files sometimes. Make up your mind. :p
When in doubt upload ALL the files from the UPLOAD directory over the other ones. Also through the admin panel, choose to OVERWRITE the xml file. This is the way to update the xml file. As for "making up [his] mind" that's not particularily nice way to address this. Even if you mean no harm out of it, consider saving the developer's time when it is working well for other people but not for you.
In other developments, CMX I fixed a conditional so that pms are no longer sent to you if you are the replyer to the ticket (in other words, it doesn't send a pm about your own reply).
In addition, I am adding a very simple method of notification that is reliant on who replied to the ticket. It sends a notification pm about a non-self reply to all who replied in the ticket as well as whomever is assigned ONCE until another reply is made.
Let me know how you feel about this notification method.
Xplorer4x4
08-30-2005, 06:59 PM
When in doubt upload ALL the files from the UPLOAD directory over the other ones. Also through the admin panel, choose to OVERWRITE the xml file. This is the way to update the xml file.
When I upgraded, I had no doubts because the instructions say XML file only.
As for "making up [his] mind" that's not particularily nice way to address this. Even if you mean no harm out of it, consider saving the developer's time when it is working well for other people but not for you.
Well I personally do not find it very nice that you feel the need to criticize the way I comunicate with CMX. IF CMX feels it would of been more appropriate to simply say his upgrade isntructions were slighlty inadequate, then it his his place to do so and I aplogize.
Well seeing as I reported that with in about 30 minuetes of the hack being released, there is no need for anyone else to report it unless they have a fix correct? CMX resolved the issue.
Can we leave it at that please and move on as I was simply trying to help out you the codders?
mikexxx
09-02-2005, 06:28 AM
If a user create a new ticket and no post icon is selected I get a red cross. If I look into the code there is no default icon.
<td class="alt1"><img src="" alt="" border="0" /></td>
peterska2
09-03-2005, 11:06 PM
/me clicks install
mikexxx
09-04-2005, 10:14 AM
In this style: support_ticketlistnone
The text in that style isnt in the language phrases. So when somebody (like me) translate all the phrase to another language the is still text in the style. Maybe you chance that for future release.
CMX_CMGSCCC
09-04-2005, 03:12 PM
If a user create a new ticket and no post icon is selected I get a red cross. If I look into the code there is no default icon.
<td class="alt1"><img src="" alt="" border="0" /></td>
Did you reupload all of the files in the /UPLOAD folder and when you imported the product file did you select Allow Overwrite to Yes?
As far as the support_ticketlistnone phrase, I will add that for v0.8.
I'm waiting for the code from WhisperPntr to finalize v0.8.
Send me the updates if you see this WhisperPntr.
As far as the upgrade instructions go, I thought it was obvious to reupload all of the files, but in any case, I have added that to the instructions for the upgrade at the bottom of the readme and the post.
-CMX
CMX_CMGSCCC
09-14-2005, 03:42 AM
I guess WhisperPntr is MIA, I'll start looking into the update v0.8 when I get time. Its getting to the busy season of the year, 10-15 PS2 games a week until thanksgiving, and I have to hack code breaker codes for all of them, so time might be a bit limited. But I'll see what I can do.
-CMX
hydrostatic
09-17-2005, 09:29 PM
Is it possible to do a Who's Online integration for this?
CMX_CMGSCCC
09-21-2005, 12:43 AM
Updated to v0.8:
1) Bugfix: It doesnt send the assigned tech a PM if they reply.
2) Bugfix: Rebuild Info didnt work for names with ' in them.
3) Template support_listbitnone uses a phrase now.
4) Added Custom WOL hooks to show up in the WOL info.
5) Added some hook locations to vBSupport.php, more could be
added over time as well.
NOTE: The hook locations are inside the included file:
/UPLOAD/includes/xml/hooks_support.xml
-CMX
Delphiprogrammi
09-21-2005, 04:51 PM
i always get "you are not authorized to manage xxxx" and i'm logged in as admin .... now what the heck ?
Xplorer4x4
09-21-2005, 10:36 PM
i always get "you are not authorized to manage xxxx" and i'm logged in as admin .... now what the heck ?
Did you go into user group settings and assign permsions for all the usergroups?
Thanks for the hack,
I got this error when using a single or double quotation in the search field:
Database error in vBulletin 3.5.0 Release Candidate 3:
Invalid SQL:
SELECT COUNT(*) AS tickets
FROM ticket AS ticket
WHERE (ticket.categoryid = '1') AND (ticket.title like '%'%');
MySQL Error : You have an error in your SQL syntax near '')
' at line 4
Error Number : 1064
Date : Thursday, September 22nd 2005 @ 10:21:28 AM
Script : http://vb/vBSupport.php
Referrer : http://vb/vBSupport.php?do=newsearch
IP Address : 127.0.0.1
Username : admin
Classname : vb_database
Delphiprogrammi
09-22-2005, 10:41 AM
Did you go into user group settings and assign permsions for all the usergroups?
done & problem solved working fine now
kylek
09-22-2005, 06:24 PM
Quick question,
I am the only admin on my board and want to set the settings so that I am the only one who will deal with support issues. When editing a category, do I need to check the box "administrators" under the allowed technicians usergroup list or just leave none checked?
Also wondering when notifications to admins will be added.
Thanks for this support system by the way!!
mikexxx
09-24-2005, 10:48 AM
I get this when i reply to a ticket:
Fatal error: Cannot redeclare vB_DataManager_TicketReply::$ticketreply in /home/.sites/xxx/xxxxxxxxx/web/includes/class_dm_ticketreply.php on line 132
LoOnEyToOnZ
09-25-2005, 08:21 AM
Hi im using RC3 and i get this when i try to post an attachment
"Invalid Post specified. If you followed a valid link, please notify the administrator"
CMX_CMGSCCC
09-25-2005, 05:20 PM
uae: I see the problem there and will post a v0.8a soon.
kylek: By default Admin has access to all features even if the settings are not set I believe.
If you want to get rid of this feature, look inside vBSupport.php inside the function get_admingroup_ids().
Remove the following code:
// make sure admins are in the group
if (!in_array(6, $admingroupids))
{
$adminsfound++;
$admingroupids[] = 6;
}
Then it will only use the settings set in the Usergroup settings.
mikexxx: Did you reupload the entire /UPLOAD folder to your server?
LoOnEyToOnZ: Did you choose allow overwrite when installing the plugin? It sounds like one of the queries didnt get ran properly.
Try to run this query:
ALTER TABLE " . TABLE_PREFIX . "attachment ADD COLUMN ticketreplyid INT UNSIGNED NOT NULL DEFAULT '0';
-CMX
BradE
09-25-2005, 05:52 PM
Love this hack, so many uses for this system.
The only problem is have is what others have noted, if no post icon is selected it gives a red x. It isn't an overwrite problem because this was a fresh install on my part. The red x points to http://www.yourforum.com/forum
TruthElixirX
09-25-2005, 06:56 PM
I like it. Thanks. :D. Using it to report bugs for our 3.5 upgrade.
Very nice
I want to see some more administrative functions:
- Category's moderator(s). Moderator will receive PM and/or email when there's new ticket in the category (maybe option to turn it on/off too)
Display ticket lists (all kind of list): (ref - vb bug tracker (http://www.vbulletin.com/forum/bugs35.php))
Display Assigntech person in ticket list (if none, says unassigned)
Display ticketID could help, when member have question about some specific ticket
Admin Support
- List Open Tickets
- List Closed Tickets
- Search ticket by ticketid, assign person
optional: browse tickets by category, just like in the forum/post relationship
- User can change type of subscription on his ticket
- Admin can edit preposted ticket (with permission allow editting on)
LoOnEyToOnZ
09-26-2005, 08:01 AM
Hi CMX
I tried running that query and got this error
"#1064 - 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 '" . TABLE_PREFIX . "attachment ADD COLUMN ticketreplyid INT UNS "
peterska2
09-26-2005, 08:16 AM
LoOnEy, replace the " . TABLE_PREFIX . " with your table prefix, if you have one.
eg
ALTER TABLE vb35_attachment ADD COLUMN ticketreplyid INT UNSIGNED NOT NULL DEFAULT '0';
or
ALTER TABLE attachment ADD COLUMN ticketreplyid INT UNSIGNED NOT NULL DEFAULT '0';
LoOnEyToOnZ
09-26-2005, 09:06 AM
Ok i tried and i get this
"#1060 - Duplicate column name 'ticketreplyid' "
Seems like i that column is already there...and btw i go to this URL when i click to add attachments "http://<domain>/forums/newattachment.php?t=1&specialattachment=1&poststarttime=1127743923&posthash=20e4 18899d84f43e9169841589b95117"
Hiho,,
great Plugin i use it in my vB and it works great :D
CMX_CMGSCCC do you mind if i Translate it into german?
regards
Disi
Cyricx
09-26-2005, 11:39 AM
Great hack :)
One suggestion for ya :)
Have it send a PM to a specific user depending on what category it is that a new ticket has been submitted.
Or even just make the email be based on what category it is, rather the one global address that it sends an email to :)
* Cyricx clicks install!
hydrostatic
09-29-2005, 01:13 AM
When clicking Quick Reply in FF, it leads to full reply instead of Quick Reply.
Hiho,
great Plugin i use it in my vB and it works great :D
CMX_CMGSCCC do you mind if i Translate it into german?
regards
Disi
Ok here's the Translation for the German ones
->kick<- (http://www.vbhacks-germany.com/forum/showthread.php?p=9675)
Maybee you can include in the later version, every language thing into a seperate file so its easier to translate :)
ufff, got an error after qick replaying:
Fatal error: Cannot redeclare vB_DataManager_TicketReply::$ticketreply in includes/class_dm_ticketreply.php on line 132
Mone'
09-30-2005, 12:22 PM
ufff, got an error after qick replaying:
Fatal error: Cannot redeclare vB_DataManager_TicketReply::$ticketreply in includes/class_dm_ticketreply.php on line 132
same here just after posting a ticket
Database error in vBulletin 3.5.0:
Invalid SQL:
SELECT ticket.*
,icon.title AS icontitle, icon.iconpath
FROM ticket AS ticket
LEFT JOIN icon AS icon ON(icon.iconid = ticket.iconid)
WHERE postuserid = 1 AND open = 1
ORDER BY replydateline DESC
LIMIT 0, 20;
MySQL Error : Unknown column 'ticket.iconid' in 'on clause'
Any ideas how to fix this?
CMX_CMGSCCC
10-01-2005, 11:23 AM
I see the bug for the ticketreply redeclaration. I will fix it now and release shortly.
As far as the ticket.iconid, I have no idea as iconid has always been a part of the ticket MySQL table. Maybe try uinstalling and reinstalling.
-CMX
Well i got a little idea :)
How about moving the Text-things (like email) from the .php into a phrase?
Is it possible?
regards
Disi
jluerken
10-02-2005, 09:27 AM
Is this hack working with table prefixes?
Is this hack working with table prefixes?
Short answere, Yes :)
I want to change the postbit template, how can I do that? it doesnt use vB's postbit/postbit_legacy
jluerken
10-04-2005, 04:01 PM
Is this hack working with table prefixes?
It would be wonderful to get an answer on this :D
Also I would like to see a running demo without the need to register somewhere :D
csidlernet
10-05-2005, 02:36 AM
Thanks!!!
/me hits install
eMike
10-05-2005, 04:31 AM
Amazing hack!
But I get the exact same problem as this guy did (https://vborg.vbsupport.ru/showpost.php?p=766806&postcount=70).
Everything else works great and I did the "Overwrite" even if i did not upgrade from any previous versions.
Can I manually edit something to fix this?
mariannet
10-05-2005, 08:01 AM
Hi
I'm missing an image in the ticket list:
DGoulden
10-05-2005, 01:40 PM
great system thanks!
mikexxx
10-05-2005, 02:24 PM
Hi
I'm missing an image in the ticket list:I have the same problem. https://vborg.vbsupport.ru/showpost.php?p=766806&postcount=70
CMX_CMGSCCC
10-05-2005, 04:47 PM
I have looked at the posts here and implemented some of the ideas for v0.9.
I have also looked at the bug reports, but the only one I cant seem to figure out is the one that kall is reporting because ticket.iconid should be a valid column. (It does have the TABLE_PREFIX for the query as well.)
The bug after posting should have been fixed since v0.8b.
jluerken: Yes, it does support TABLE_PREFIX's.
mtha: If you want to change the postbit, edit the postbit_ticket to your liking.
Disi: It should be possible, using a form and an ereg_replace to add the links to the sites. I'll look into that for a future version.
But for now, I will release v0.9 with the new features as follows:
1) Added ID to ticket list for easier reference.
2) Added categoryadmins for add/updating categories.
NOTE: Enter the userid's of the users you want to be
notified upon a new ticket creation for the specified
category. Separate entries with a comma (',') and do
not put any spaces either.
3) Added admin options for List Open/Closed Tickets.
4) Added ability to search for tickets by assigned tech.
-CMX
jluerken
10-05-2005, 04:54 PM
CMX, many thanks for the answer.
One more question.
Is there a list of the used phrases available?
I want to have the user section in english and german.
The admin part can stay in english.
Now I need to know if there is any hard coded phrases in v0.9 in the user front end and which phrases do I all have to translate?
eMike
10-05-2005, 05:37 PM
Upgraded to 0.9 and still missing the posticon image in the ticket list.
Is there any file / template I can edit to remove it completely or add a permanent default posticon?
Database error in vBulletin 3.5.0:
Invalid SQL:
INSERT INTO pm (pmid, pmtextid, userid, folderid, messageread) VALUES (0, 67818, , 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 ' 0, 0)' at line 1
Error Number : 1064
For category doesnt have $categoryadmin => ERROR
For category doesnt have $categoryadmin => ERROR[/QUOTE]
fix:
in VBSupport.php
Look for
// get the category info
if ($category = $db->query_first("
SELECT *
FROM " . TABLE_PREFIX . "ticketcategory
WHERE categoryid = " . $vbulletin->GPC['categoryid'] . "
"))
REPLACE WITH
// get the category info
$category = $db->query_first("
SELECT categoryadmins
FROM " . TABLE_PREFIX . "ticketcategory
WHERE categoryid = " . $vbulletin->GPC['categoryid'] . "
");
if (!empty($category['categoryadmins']))
{
Upgraded to 0.9 and still missing the posticon image in the ticket list.
Is there any file / template I can edit to remove it completely or add a permanent default posticon?
support_ticketlistbit
look for
<if condition="$show['messageicon']">
<td class="alt1"><img src="$ticket[iconpath]" alt="$ticket[icontitle]" border="0" /></td>
</if>
replace with
<if condition="$show['messageicon']">
<td class="alt1">
<if condition="$ticket[iconpath]"><img src="$ticket[iconpath]" alt="$ticket[icontitle]" border="0" /></if>
</td>
</if>
mtha: If you want to change the postbit, edit the postbit_ticket to your liking.
Wow, too far from the rest :) You should have named it support_postbit or support_postbit_ticket or something like that
- Category's moderator(s).
Display ticket lists
Display Assigntech person in ticket list (if none, says unassigned)
Admin Support
- Search ticket by ticketid
optional: browse tickets by category, just like in the forum/post relationship
- User can change type of subscription on his ticket
- Admin can edit ticket (with permission allow editting on)
add to the list:
- Display CatID before editing category name
<td>[$category[categoryid]] <input type="hidden" name="category[$category[categoryid]]" value="$category[categoryid]"><input type="text" name="categoryname[$category[categoryid]]" value="$category[categoryname]" size=50></td>
- newticket in predefined category
could be "vBSupport.php?do=newticket&catid=xxx" it will select the catid by default, or only display that specific catid
- Search ticket by ticketid, postuserid, open status (open or closed)
Question:
When you create or edit a category, there're options for
Allowed Usergroups
Allowed Technician Usergroups
What is the function of these usergroups?
Xplorer4x4
10-06-2005, 12:25 AM
Whene ever I open the drop down menu for ticket catagoreys, the catgoreys do not show up. Only the user IDs asigned to those catgories do.
Xplorer4x4
10-06-2005, 12:28 AM
Question:
When you create or edit a category, there're options for
Allowed Usergroups
Allowed Technician Usergroups
What is the function of these usergroups?
Allowed Usergroups are the groups allowed to post tickets.
Allowed Technician Usergroups are the groups that can assign tickets and so forth I believe.
CMX_CMGSCCC
10-06-2005, 12:38 AM
Question:
When you create or edit a category, there're options for
Allowed Usergroups
Allowed Technician Usergroups
What is the function of these usergroups?
Allowed Usergroups mean that those usergroups can create a new ticket in that category. (This is so your admins can create tickets in a specified category that normal users cant create. Like how do we handle X user inside a category named 'Problem Users', etc..)
Allowed Technician Usergroup is the usergroups that are allowed to be assigned to the ticket in that category.
-CMX
CMX_CMGSCCC
10-06-2005, 12:40 AM
Wow, too far from the rest :) You should have named it support_postbit or support_postbit_ticket or something like that
add to the list:
- Display CatID before editing category name
<td>[$category[categoryid]] <input type="hidden" name="category[$category[categoryid]]" value="$category[categoryid]"><input type="text" name="categoryname[$category[categoryid]]" value="$category[categoryname]" size=50></td>
- newticket in predefined category
could be "vBSupport.php?do=newticket&catid=xxx" it will select the catid by default, or only display that specific catid
- Search ticket by ticketid, postuserid, open status (open or closed)
I have added those search options and ID displayed to the category lists.
As far as postbit_ticket, it has to be named that way to be able to use the class_postbit.php I think. I think that was the reason I chose postbit_ticket, because new_postbit(...) or something has to use the word 'ticket' and it puts postbit_ before the ticket word..
-CMX
Xplorer4x4
10-06-2005, 12:42 AM
Database error in vBulletin 3.5.0:
Invalid SQL:
INSERT INTO pm (pmid, pmtextid, userid, folderid, messageread) VALUES (0, 575, , 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 ' 0, 0)' at line 1
Error Number : 1064
Date : Wednesday, October 5th 2005 @ 08:41:22 PM
Script : /forums/vBSupport.php
Referrer : /forums/vBSupport.php?do=newticket
IP Address :
Username :
Classname : vb_database
I can not post a ticket.
EDIT: using 0.9
eMike
10-06-2005, 12:58 AM
Could be me that is doing something majorly wrong here, but I still do not see that icon image - same red X as before. (After upgrading to 09a)
Is it me?
Xplorer4x4
10-06-2005, 01:01 AM
@eMike I believe this has bee nadressed many times before. Try those methods.
@CMX I upgraded .9A and have no DB problem, but the catgoreys are still showing up as the User Id's assigned to be notified.
- newticket in predefined category
could be "vBSupport.php?do=newticket&categoryid=xxx" it will select the catid by default, or only display that specific catid
to do this:
in vBSupport.php
LOOK FOR
// start creating a new ticket "
if ($_REQUEST['do'] == 'newticket')
{
ADD BELLOW
$vbulletin->input->clean_array_gpc('r', array(
'categoryid' => TYPE_UINT,
));
LOOK FOR
while ($category = $db->fetch_array($categories))
{
$categorybits .= "<option value=$category[categoryid]>$category[categoryname]</option>";
}
REPLACE BY
while ($category = $db->fetch_array($categories))
{
$categorybits .= "<option value=$category[categoryid] " . iif($category[categoryid] == $vbulletin->GPC['categoryid'],'selected') . ">$category[categoryname]</option>";
}
Display assigned user (if any) in ticket list
In vBSupport.php
search for
// start getting the support tickets
$tickets = $db->query_read("
SELECT ticket.*
" . iif($vbulletin->options['privallowicons'], ",icon.title AS icontitle, icon.iconpath") . "
FROM " . TABLE_PREFIX . "ticket AS ticket
" . iif($vbulletin->options['privallowicons'], "LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON(icon.iconid = ticket.iconid)") . "
$listtype
ORDER BY replydateline DESC
$limitstr
");
by
// start getting the support tickets
$tickets = $db->query_read("
SELECT ticket.*, user.username AS assignedtechusername
" . iif($vbulletin->options['privallowicons'], ",icon.title AS icontitle, icon.iconpath") . "
FROM " . TABLE_PREFIX . "ticket AS ticket
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = ticket.assignedtechid)
" . iif($vbulletin->options['privallowicons'], "LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON(icon.iconid = ticket.iconid)") . "
$listtype
ORDER BY replydateline DESC
$limitstr
");
template edit: support_ticketlistbit
<span class="smallfont" style="float:$stylevar[right]"><strong>$ticket[status]</span>
replate with
<span class="smallfont" style="float:$stylevar[right]">
<div align="right"><strong>$ticket[status]</strong>
<br><i><a href="member.php?$session[sessionurl]u=$ticket[assignedtechid]">$ticket[assignedtechusername]</a></i>
</div>
</span>
edit template SUPPORTCP
look for
<td class="thead" width="100%">
$vbphrase[support_ticket_open_status] / $vbphrase[support_ticket_starter]
</td>
replace with
<td class="thead" width="100%">
<span class="smallfont" style="float:$stylevar[right]">
$vbphrase[status]/$vbphrase[support_assign_ticket]
</span>
$vbphrase[support_ticket_open_status] / $vbphrase[support_ticket_starter]
</td>
https://vborg.vbsupport.ru/showpost.php?p=764653&postcount=60
Hey CMX,
That sounds great and it would be great to work alongside you as well as develop an extra plugin to have this interface with Ron1n's vbpurchase (a hack which I already have his permission to update and use).
Here are some screens of the changes that I've done, as well as a modification of the ticket template.
If you're interested in seeing the code changes, I'll modify the script I have to use your 0.7 version and then send the changes I added to you. They're very rudimentary and are based on the category updates.
Cheers!
~Whisper
CMX, do you have any plan to change your "Open status" to a Full integrated status", which would be something like this
https://vborg.vbsupport.ru/attachment.php?attachmentid=33920
Allowed Usergroups mean that those usergroups can create a new ticket in that category. (This is so your admins can create tickets in a specified category that normal users cant create. Like how do we handle X user inside a category named 'Problem Users', etc..)
Allowed Technician Usergroup is the usergroups that are allowed to be assigned to the ticket in that category.
-CMX
How about Support Admin Permissions in usergroup bitfield?
it looks like that I have to checl "This usergroup can Admin Support Tickets" to allow in tech assigned list.
and if I check so, i can assign to anyone in the list? isnt that right or i am missing something?
what is the combination/relationship between them?
........
and your PM template is hardcoded? :( i think you can use vB's pmdm too
Updated and Translated into german :)
http://www.vbhacks-germany.com/forum/showthread.php?p=9675
btw
CMX could you manage to put every language specific thinks, like email, pm announcment or the states (open close) into the XML file?
It would be much easier to translate them :) and i wouldn't miss things :bunny: :p
Blackhat
10-06-2005, 06:30 PM
There is a bug. When you add persons to manage tickets from the specific section those ID's are also added as name of the section so you have to edit each sections name after you have created it.
kylek
10-06-2005, 07:53 PM
Sorry but this really needs to be checked out by the person who made this. There are too many bugs that should not have to be edited in bits and pieces.
1 - Same as Blackhats post above this one - "There is a bug. When you add persons to manage tickets from the specific section those ID's are also added as name of the section so you have to edit each sections name after you have created it."
2 - eMike's post - icon missing
3 - Xplorer4x4 - cannot post a ticket - still getting database error
I am uninstalling the latest version 9.a until hopefully all of these get looked at.
eMike
10-06-2005, 08:52 PM
@eMike I believe this has bee nadressed many times before. Try those methods.
Yes iI know it has been adressed, but CMX indicated that he fixed it in the upgrade. Just trying to do my part an inform about bugs.
I dont make this ext, but trying to help out
1 - Same as Blackhats post above this one - "There is a bug. When you add persons to manage tickets from the specific section those ID's are also added as name of the section so you have to edit each sections name after you have created it."
somehow I cant see it in my version, :). it'd help if you can give step-by-step on how to generate the bug, and screencapture too?
CMX, do you know this bug?
2 - eMike's post - icon missing
i think it was fixed. if not, you might have customized template? if you want, you can use my fix few post above
3 - Xplorer4x4 - cannot post a ticket - still getting database error
:) I dont :D, or did I fix it? did you upload the new files? what is the db error again?
DGoulden
10-07-2005, 01:09 PM
I have vB 3.5.0 (Gold) set to use SMTP but this script dosn't want to use it, it defaults to sendmail, can i change this?
CMX_CMGSCCC
10-09-2005, 03:16 AM
I am looking at the bugs here.
1) I am not experiencing this problem, so either the uploaded v0.9a zip is not the same version as I have on my server or somehow the template didnt get overwritten. I goto List Categories, then click on Edit, type in a userid of 1 for my user id, and press Update and then reedit it from List Categories and the category name is fine for me. (I'll add a comple small changes and reupload a v0.9b to make sure the zip has the exact files on my server that I do the testing/debugging on later tonight.)
2) Not 100% sure why this is happening, but I'm going to do something in v0.9b that might fix it. (I think somehow iconpath is not being filled in, so in v0.9b, gonna set $show[messageicon] true or falsed based on if iconpath is filled in or not and redo the template to accomodate this.)
3) Can not post a ticket should have been fixed in v0.9a, it was a small bug of a variable getting declared twice that I removed the second declaration in v0.9a.
Now to address the other comments:
Disi: I have added the phrases for open/close and I will change the "Open" and "Closed" inside the php file for the v0.9b I post later tonight. The emails and pm's could be changed as well, I guess it would use an preg_replace to replace {1} with the site name, and stuff as well. I will have to look into that in a future update as that is a bit more time consuming than the open/closed phrase uses.
DGoulden: It does use the php function mail(...), I'm not familiar with how to use the SMTP server from PHP, but if vBulletin can do it, I could probably research it further when I can find some more time.
-CMX
clearchannel
10-09-2005, 02:40 PM
Is there something missing in the install instructions? I do not see any mention of running quaries or a self install. I uploaded the files according to the install instructions, made the template change in the nav bar and added the slm accoring to instuructions and it is not working.
Thanks in advance.
clearchannel
10-09-2005, 02:44 PM
I uninstalled and reinstalled and it appears to be working now.
Nice script thanks
xscape2me
10-09-2005, 06:57 PM
Is there a way to have it so that when an admin or something signs on it gives a little box up top, or maybe on the front page of vbadvanced cmps, showing how many trouble tickets are open?
eMike
10-09-2005, 09:40 PM
Things appear to work great with the 09b version :)
How can I change the postbit? Cant seem to find any templates that controls that particular feature
CMX_CMGSCCC
10-09-2005, 09:47 PM
xscape2me: Probably, I'm not familiar with vbadvanced, but I'm sure it would add a query.
eMike: Great. You can edit the postbit_ticket to change the postbit there. (the class_postbit.php file requires it to be postbit_xxx to open properly, so thats why it's named postbit_ticket)
-CMX
attroll
10-10-2005, 05:06 AM
Is there a way to have non registered members submit trouble tickets?
hydrostatic
10-10-2005, 06:16 AM
Good work.
Two bugs I found:
1). On vBSupport.php?do=list, when the user didn't submit any Tickets, the format of "There are currently no tickets to view." is weird.
2). "Quick Reply" button doesn't work in FireFox.
Disi: I have added the phrases for open/close and I will change the "Open" and "Closed" inside the php file for the v0.9b I post later tonight. The emails and pm's could be changed as well, I guess it would use an preg_replace to replace {1} with the site name, and stuff as well. I will have to look into that in a future update as that is a bit more time consuming than the open/closed phrase uses.
Great but you missed 2 things :)
the listboxes with 'No Category selected' and Assigned 'None'
btw
Translated and can be found under http://www.vbhacks-germany.com/forum/showthread.php?t=1683&page=1&pp=10
It would be really cool if there was an "Add to FAQ' Button, that would automatically add a ticket to the FAQ.
mikexxx
10-10-2005, 04:11 PM
The is still no option that a mod get a waring on a new ticket?!
Xplorer4x4
10-11-2005, 12:00 PM
@Mike i believe you have to type in there user ids in "Category Admin User ID's".
@CMX I think it would be alot easier to make the "Category Admin User ID's" to work by user groups instead.
Also, would there be anyway to keep the permisions from reseting everytime I have to upgrade? Same question aplies for the catgoreys.
Last suggestions would be a drop down menu to asign priority.
jluerken
10-11-2005, 05:09 PM
Ok I installed this hack and started playing with it.
A little documentation would be nice cause I am already lost in the settings.
Here what I tried.
1. I gave the Admingroup all rights
2. I created a category called test
3. Category adminID is the id of the user test.
As far as I know all members listed there will get a message if a user opens a ticket for their group or?
4. I created a usergroup called testgroup and put a user in this group
5. Allowed Usergroups are:
Admins, testgroup
This means to mee that members of this group can SEE calls of the category test or?
6. Allowed technician Usergroups
This means to me that you can only assign calls of the category test to members of the usergroup Admins and testgroup or?
So far I was not able to find out how the rights system is working within this hack.
The only way to assign a call to a user is to give the group where the user is in the right: This usergroup can Admin Support Tickets
But this does mean for me that this group can always see all calls.
Can someone please describe this rights settings a little bit more for me?
Andreas
10-12-2005, 07:30 PM
@CMX_CMGSCCC
I've noticed that there are hardcoded Texts in the PHP Files.
It would be nice if those could be converted to phrases as well; would make translations easier :)
I also got a feature request:
Add fields for username/password/host details that will be automatically cleared when the Ticket gets closed (eg. like vbadvanced.com ticket system).
That would be great (and save me some time coding it myself) :)
timetunnel
10-12-2005, 09:30 PM
Hello.
Does this Helpdesk software utilize the 'image security' feature like for 'Contact Us' in vB or is it not necessary?
jluerken
10-13-2005, 11:25 AM
Hi,
When I try yo upload an attachment I get the following error message:
Admin, you do not have permission to access this page. This could be due to one of several reasons:
1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
The Usergroup has the rights to upload and view attachments so whats wrong?
jluerken
10-20-2005, 11:18 AM
Still the attachment option is not working for me. I get the error message posted above
gsnindia
10-21-2005, 03:27 PM
getting this erro please help
Database error in vBulletin 3.5.0:
Invalid SQL:
SELECT ticket.*, user.username AS assignedtechusername
,icon.title AS icontitle, icon.iconpath
FROM ticket AS ticket
LEFT JOIN user AS user ON (user.userid = ticket.assignedtechid)
LEFT JOIN icon AS icon ON(icon.iconid = ticket.iconid)
WHERE postuserid = 1 AND open = 1
ORDER BY replydateline DESC
LIMIT 0, 20;
MySQL Error : Unknown column 'ticket.assignedtechid' in 'on clause'
Error Number : 1054
CMX_CMGSCCC
10-22-2005, 12:20 AM
Hi,
When I try yo upload an attachment I get the following error message:
The Usergroup has the rights to upload and view attachments so whats wrong?
This is a vB error message, if you are getting this, there is another vB permission that you have disabled.
v1.0 released soon, hopefully it will fix the bugs found.
v1.0 Updates:
1) Bugfix: No new tickets displayed improperly.
2) Added feature to put a check next to tickets to delete them.
3) Added a couple more ticket search features.
4) Various sql query strings updated.
-CMX
jluerken
10-22-2005, 06:44 AM
Thanks for the update man.
Attachments are still an open point and not working :D
Omranic
10-22-2005, 10:26 AM
Installed
Now Testing
Hope never found errors or bugs
thanks man
CMX_CMGSCCC
10-22-2005, 01:41 PM
jluerken: Attachments are working fine for me, I really dont know what the problem would be. It must be something with your setup, you must have a vB attachment setting shut off somewhere else.
-CMX
Is there anyway to allow non-registered users to submit tickets?
The unregistered users with problems are realy the most important ones to support.
gsnindia
10-23-2005, 04:01 AM
You are not authorized to create tickets.
getting this error
Please help
klaush
10-23-2005, 11:27 AM
as an admin assign or reaasign an open ticket to one of my staff member?
Thanks for your fast answer and
thanks for this great and needed module! :-)
ERRORS:
1. users who doesnt have permission to delete should not be able to check delete option (The action column), nor delete button (Delete selected ticket)
2. when click Delete Selected Ticket, there's an error:
Error: vB_Editor[''] has no properties
3. If no ticket selected, it shouldnt say ticket deleted.
evenmonkeys
10-24-2005, 09:18 PM
Is there a place that describes how to use this? I'm a little confused on the Add Category part. "Allowed Usergroups" "Allowed Technician Usergroups" It's all too confusing for my feeble mind.
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.
klaush
10-27-2005, 01:39 PM
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.
Could you please name the files, where are these changes to do.
Not everybody here is an advanced coder.
Thank you!
I basically post the above msg for CMX, so that he can make the changes.
ok. here's what you need to do
Edit vBSupport.php
line 854 + 855:
Remove (or comment) these line:
$vbulletin->url = 'vBSupport.php?' . $vbulletin->session->vars['sessionurl_q'];
eval(print_standard_redirect('support_ticket_close d', true, true));
Line 891, 892:
Remove (or comment) these line:
$vbulletin->url = 'vBSupport.php?' . $vbulletin->session->vars['sessionurl_q'] . 'do=showticket&ticketid=' . $vbulletin->GPC['ticketid'];
eval(print_standard_redirect('support_ticket_opene d', true, true));
Line 924+925
Remove (or comment) these line:
$vbulletin->url = 'vBSupport.php?' . $vbulletin->session->vars['sessionurl_q'];
eval(print_standard_redirect('support_ticket_assig ned', true, true));
Line 940 + 941
replace
// reshow the ticket
$_REQUEST['do'] = 'showticket';
by
// reshow the ticket
// $_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 '));
rubzebest
10-30-2005, 02:43 AM
Is there anyway to allow non-registered users to submit tickets?
The unregistered users with problems are realy the most important ones to support.
I agree, for the registered users I can just as well create a private forum :ermm: ...
It seems in category permissions I can add the "unregistered" usergroup, so why can't they post?
I agree, for the registered users I can just as well create a private forum :ermm: ...
It seems in category permissions I can add the "unregistered" usergroup, so why can't they post?
In general helpdesk system, people usually use EMAIL and ticketid, to login and check status for some ticket.
Assume that guest can post ticket (with their email), they, at a later time, can check back the ticket, with the email they entered, and ticket id number (sent to their email).
that's the idea to go with.
rubzebest
11-01-2005, 12:05 PM
In general helpdesk system, people usually use EMAIL and ticketid, to login and check status for some ticket.
Assume that guest can post ticket (with their email), they, at a later time, can check back the ticket, with the email they entered, and ticket id number (sent to their email).
that's the idea to go with.
Actually I don't seem to be able to post a ticket as guest :ermm:. IMHO that doesn't make sense.
CommuneZoom
11-03-2005, 01:49 AM
I was testing this out and on install, it seems the phrases are installed, although the options do not appear when choosing a usergroup in the admin CP to edit ho can do what.
Any ideas?
hydrostatic
11-03-2005, 02:26 AM
This hack does not work for vBulletin 3.5.1. At least the usergroup permission system does not.
CommuneZoom
11-03-2005, 04:18 AM
This hack does not work for vBulletin 3.5.1. At least the usergroup permission system does not.
Yeah, that is what I was gathering. Imay have to check the systems. I didn't really look at the coding before checking whether it would comply with 3.5.1 or not. Needless to say, it doesn't hurt anything, it just doesn't work yet :).
jluerken
11-03-2005, 08:32 AM
Usergroup permissions are not working for 3.5.1 and I don't see the vBSupport Menu in the admincp anymore :-(
CommuneZoom
11-03-2005, 10:15 AM
This hack does not work for vBulletin 3.5.1. At least the usergroup permission system does not.
See the above, in the same boat :).
We'll see if an update is released.
Omranic
11-04-2005, 08:49 AM
Usergroup permissions are not working for 3.5.1 and I don't see the vBSupport Menu in the admincp anymore :-(
This hack does not work for vBulletin 3.5.1. At least the usergroup permission system does not.
Any update ??
Thanks for the mod,
I haven?t read the whole thread by now (getting waaay toooo long), but is there an option to send a email or PN to $selectedusergroups[e.g mods/admins] at the time a new ticket has been created ? So the response time could by cut down to a minimum. Today it?s like google?s "I feel lucky"-option wether you had a look into the helpdesk and found a new ticket (and had to recognize uhh..surprise, surprise - it?s two weeks old) - or not.
Is this already implemented? As it seems it doesn?t send those eMails actual (or I have done something completly wrong ;) )
Any chance to get this feature ?
Xplorer4x4
11-05-2005, 09:30 AM
Ummj just a thought but try reinstalling the product :ermm:
Neofreaks
11-05-2005, 11:42 AM
This will get it to work for 3.5.1:
Replace the contents of includes\xml\bitfield_support.xml with the following:
<?xml version="1.0" encoding="ISO-8859-1"?>
<bitfields product="vBSupport">
<bitfielddefs>
<group name="ugp">
<group name="supportpermissions">
<bitfield name="canadminsupport" group="support_admin_permissions" phrase="support_can_admin_support_tickets" install="2,3,4,5,6,7">1</bitfield>
<bitfield name="cancreatetickets" group="support_admin_permissions" phrase="support_can_create_tickets" install="2,3,4,5,6,7">2</bitfield>
<bitfield name="canreplytoowntickets" group="support_admin_permissions" phrase="support_can_reply_to_own_tickets" install="2,3,4,5,6,7">4</bitfield>
<bitfield name="canreplytoalltickets" group="support_admin_permissions" phrase="support_can_reply_to_all_tickets" install="2,3,4,5,6,7">8</bitfield>
<bitfield name="candeleteowntickets" group="support_admin_permissions" phrase="support_can_delete_own_tickets" install="2,3,4,5,6,7">16</bitfield>
<bitfield name="candeleteanyticket" group="support_admin_permissions" phrase="support_can_delete_any_ticket" install="2,3,4,5,6,7">32</bitfield>
<bitfield name="cancloseowntickets" group="support_admin_permissions" phrase="support_can_close_own_tickets" install="2,3,4,5,6,7">64</bitfield>
<bitfield name="cancloseanyticket" group="support_admin_permissions" phrase="support_can_close_any_ticket" install="2,3,4,5,6,7">128</bitfield>
<bitfield name="canopenowntickets" group="support_admin_permissions" phrase="support_can_open_own_tickets" install="2,3,4,5,6,7">256</bitfield>
<bitfield name="canopenanyticket" group="support_admin_permissions" phrase="support_can_open_any_ticket" install="2,3,4,5,6,7">512</bitfield>
<bitfield name="canassigntickets" group="support_admin_permissions" phrase="support_can_assign_tickets" install="2,3,4,5,6,7">1024</bitfield>
<bitfield name="canreassigntickets" group="support_admin_permissions" phrase="support_can_reassign_tickets" install="2,3,4,5,6,7">2048</bitfield>
<bitfield name="canpostattachments" group="support_admin_permissions" phrase="support_can_post_attachments" install="2,3,4,5,6,7">4096</bitfield>
<bitfield name="canviewattachments" group="support_admin_permissions" phrase="support_can_view_attachments" install="2,3,4,5,6,7">8192</bitfield>
<bitfield name="canmanagecategories" group="support_admin_permissions" phrase="support_can_manage_categories" install="2,3,4,5,6,7">16384</bitfield>
<bitfield name="canupdatecategorytype" group="support_admin_permissions" phrase="support_can_update_categorytype" install="2,3,4,5,6,7">32768</bitfield>
</group>
</group>
</bitfielddefs>
</bitfields>
<!-- CVS: $RCSfile: bitfield_support.xml,v $ - $Revision: 1.0 $ -->
LiQuid ArroW
11-05-2005, 11:51 AM
It doesn't seem to work me either, when I set the permission stuff I get a mysql error, but it says that it have saved the permission settings.
mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635
Any help is appreciated.
hydrostatic
11-06-2005, 02:48 AM
LiQuid ArroW: Try rebuilding bitfields.
jimmyboy
11-06-2005, 08:23 PM
not working. with 351.....
Omranic
11-07-2005, 09:11 AM
<?xml version="1.0" encoding="ISO-8859-1"?>
<bitfields product="vBSupport">
<bitfielddefs>
<group name="ugp">
<group name="supportpermissions">
<bitfield name="canadminsupport" group="support_admin_permissions" phrase="support_can_admin_support_tickets" install="2,3,4,5,6,7">1</bitfield>
<bitfield name="cancreatetickets" group="support_admin_permissions" phrase="support_can_create_tickets" install="2,3,4,5,6,7">2</bitfield>
<bitfield name="canreplytoowntickets" group="support_admin_permissions" phrase="support_can_reply_to_own_tickets" install="2,3,4,5,6,7">4</bitfield>
<bitfield name="canreplytoalltickets" group="support_admin_permissions" phrase="support_can_reply_to_all_tickets" install="2,3,4,5,6,7">8</bitfield>
<bitfield name="candeleteowntickets" group="support_admin_permissions" phrase="support_can_delete_own_tickets" install="2,3,4,5,6,7">16</bitfield>
<bitfield name="candeleteanyticket" group="support_admin_permissions" phrase="support_can_delete_any_ticket" install="2,3,4,5,6,7">32</bitfield>
<bitfield name="cancloseowntickets" group="support_admin_permissions" phrase="support_can_close_own_tickets" install="2,3,4,5,6,7">64</bitfield>
<bitfield name="cancloseanyticket" group="support_admin_permissions" phrase="support_can_close_any_ticket" install="2,3,4,5,6,7">128</bitfield>
<bitfield name="canopenowntickets" group="support_admin_permissions" phrase="support_can_open_own_tickets" install="2,3,4,5,6,7">256</bitfield>
<bitfield name="canopenanyticket" group="support_admin_permissions" phrase="support_can_open_any_ticket" install="2,3,4,5,6,7">512</bitfield>
<bitfield name="canassigntickets" group="support_admin_permissions" phrase="support_can_assign_tickets" install="2,3,4,5,6,7">1024</bitfield>
<bitfield name="canreassigntickets" group="support_admin_permissions" phrase="support_can_reassign_tickets" install="2,3,4,5,6,7">2048</bitfield>
<bitfield name="canpostattachments" group="support_admin_permissions" phrase="support_can_post_attachments" install="2,3,4,5,6,7">4096</bitfield>
<bitfield name="canviewattachments" group="support_admin_permissions" phrase="support_can_view_attachments" install="2,3,4,5,6,7">8192</bitfield>
<bitfield name="canmanagecategories" group="support_admin_permissions" phrase="support_can_manage_categories" install="2,3,4,5,6,7">16384</bitfield>
<bitfield name="canupdatecategorytype" group="support_admin_permissions" phrase="support_can_update_categorytype" install="2,3,4,5,6,7">32768</bitfield>
</group>
</group>
</bitfielddefs>
</bitfields>
<!-- CVS: $RCSfile: bitfield_support.xml,v $ - $Revision: 1.0 $ -->
any one tried this solve & vbsupport works fine without any problems with 3.5.1 ?
SB2002
11-07-2005, 12:05 PM
I've got it working on 3.5.1 using the above edit. seems to work just fine. Thanks Neofreaks Check Here (http://www.rearrangedwebdesigns.co.uk/forum/vBSupport.php)
Detomah
11-08-2005, 09:56 AM
I've got it working on 3.5.1 using the above edit. seems to work just fine. Thanks Neofreaks Check Here (http://www.rearrangedwebdesigns.co.uk/forum/vBSupport.php)
Indeed, same here, works fine for me after that edit.
slvr ralliart
11-08-2005, 04:23 PM
I installed this and followd the instructions to a T and I get this error msg:
Parse error: parse error, unexpected $ in /home/slvrra/public_html/forums/vBSupport.php on line 1034
please help
slvr ralliart
11-08-2005, 06:34 PM
anyone wanna help?
slvr ralliart
11-08-2005, 10:05 PM
hellllooooooooo??
anyone want to give a helping hand here?
COBRAws
11-09-2005, 01:49 AM
Can I select certain usergroups to have support? I dont want everybody sending tickets.
Thanks in advance.
CMX, please put this one into a bitfield_support.xml file, and upload to your release, for vB3.5.1
https://vborg.vbsupport.ru/showpost.php?p=813140&postcount=176
it does work.
I installed this and followd the instructions to a T and I get this error msg:
Parse error: parse error, unexpected $ in /home/slvrra/public_html/forums/vBSupport.php on line 1034
please help
what does "to a T" mean?
Did you make any modification to the vBSupport.php file?
my line 1034 is like this
// check if this user is allowed to reassign tickets
thereis NO $ in there.
if you have different, you might want to download the file again, and reinstall it.
Can I select certain usergroups to have support? I dont want everybody sending tickets.
Thanks in advance.
Yes, you actually have to set so that which group can do what.
D|ver
11-11-2005, 09:23 AM
still not working for me on 3.5.1 even after doing the changes in the bitfield_support.xml
flosoft
11-12-2005, 09:32 AM
This will get it to work for 3.5.1:
Replace the contents of includes\xml\bitfield_support.xml with the following:
<?xml version="1.0" encoding="ISO-8859-1"?>
<bitfields product="vBSupport">
<bitfielddefs>
<group name="ugp">
<group name="supportpermissions">
<bitfield name="canadminsupport" group="support_admin_permissions" phrase="support_can_admin_support_tickets" install="2,3,4,5,6,7">1</bitfield>
<bitfield name="cancreatetickets" group="support_admin_permissions" phrase="support_can_create_tickets" install="2,3,4,5,6,7">2</bitfield>
<bitfield name="canreplytoowntickets" group="support_admin_permissions" phrase="support_can_reply_to_own_tickets" install="2,3,4,5,6,7">4</bitfield>
<bitfield name="canreplytoalltickets" group="support_admin_permissions" phrase="support_can_reply_to_all_tickets" install="2,3,4,5,6,7">8</bitfield>
<bitfield name="candeleteowntickets" group="support_admin_permissions" phrase="support_can_delete_own_tickets" install="2,3,4,5,6,7">16</bitfield>
<bitfield name="candeleteanyticket" group="support_admin_permissions" phrase="support_can_delete_any_ticket" install="2,3,4,5,6,7">32</bitfield>
<bitfield name="cancloseowntickets" group="support_admin_permissions" phrase="support_can_close_own_tickets" install="2,3,4,5,6,7">64</bitfield>
<bitfield name="cancloseanyticket" group="support_admin_permissions" phrase="support_can_close_any_ticket" install="2,3,4,5,6,7">128</bitfield>
<bitfield name="canopenowntickets" group="support_admin_permissions" phrase="support_can_open_own_tickets" install="2,3,4,5,6,7">256</bitfield>
<bitfield name="canopenanyticket" group="support_admin_permissions" phrase="support_can_open_any_ticket" install="2,3,4,5,6,7">512</bitfield>
<bitfield name="canassigntickets" group="support_admin_permissions" phrase="support_can_assign_tickets" install="2,3,4,5,6,7">1024</bitfield>
<bitfield name="canreassigntickets" group="support_admin_permissions" phrase="support_can_reassign_tickets" install="2,3,4,5,6,7">2048</bitfield>
<bitfield name="canpostattachments" group="support_admin_permissions" phrase="support_can_post_attachments" install="2,3,4,5,6,7">4096</bitfield>
<bitfield name="canviewattachments" group="support_admin_permissions" phrase="support_can_view_attachments" install="2,3,4,5,6,7">8192</bitfield>
<bitfield name="canmanagecategories" group="support_admin_permissions" phrase="support_can_manage_categories" install="2,3,4,5,6,7">16384</bitfield>
<bitfield name="canupdatecategorytype" group="support_admin_permissions" phrase="support_can_update_categorytype" install="2,3,4,5,6,7">32768</bitfield>
</group>
</group>
</bitfielddefs>
</bitfields>
<!-- CVS: $RCSfile: bitfield_support.xml,v $ - $Revision: 1.0 $ -->
Great! Finally mine works again on 3.5.1 . Big THX for the piece of code
cd1986
11-12-2005, 03:26 PM
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 :)
Detomah
11-13-2005, 01:36 PM
Also, your users must be signed in, it will print the log
in screen if they are not.
Is this actually still the case that none registered people automatically see the register page and not the actual support system?
If so, i'm confused, why have usergroups allowed to post tickets if they can't see the the support system in the first place, it kinda defeats the whole reason for the system and why I installed it in the first place if it is the case, as I want to use it for such things as login and registration support, which would seem the obvious reason for it?
If it is the case, is there any chance this could be updated to allow guests to see the thing, so they can actually post?
Or is someone gonna put me in my place and tell me I must be doing something wrong or have this set up wrong or something?
Oblivion Knight
11-16-2005, 12:54 PM
This is awesome, thank you for sharing it with the community.! :)
There's a small typo that I noticed in your vBSupport.php file, however:
$ticketcategorydm->setr('categoryname', $vbulletin->GPC['categoryadmins']);Should be:
$ticketcategorydm->setr('categoryadmins', $vbulletin->GPC['categoryadmins']);
Some of the templates also leave something to be desired.. I'll be having a play around with them later and may post them here if you're interested? I don't want to be treading on any toes..
Mastar
11-17-2005, 06:45 PM
Works Great so far.
Are they any settings in the ACP?
vtx1800
11-19-2005, 04:40 AM
Installed, seems to be good.
Where are the config settings? I see the ACP setting in VBulletin Options > vBSupport Settings. Are there others? I can't send a ticket in right now... where else do I look for settings on the system?
Installed, seems to be good.
Where are the config settings? I see the ACP setting in VBulletin Options > vBSupport Settings. Are there others? I can't send a ticket in right now... where else do I look for settings on the system?
ACP/UserGroup/edit usergroup permisison. you need to set usergroup permission to be able to create tickets
jimmyboy
11-20-2005, 05:26 PM
is there a newer version?????
is there a newer version?????
Yes :) there's a newer version, newer than ... 'older' versions (0.9, 0.8 ...)
jimmyboy
11-23-2005, 10:44 PM
Yes :) there's a newer version, newer than ... 'older' versions (0.9, 0.8 ...)
:devious: ....
i mean is ther gonna have 1.1?
....
i mean is ther gonna have 1.1?
At present: No. The current version is 1.0
In the future: YES
When in the future: Not know yet.
:cheeky::D
jimmyboy
11-25-2005, 11:24 PM
good,good, thx
At present: No. The current version is 1.0
In the future: YES
When in the future: Not know yet.
:cheeky::D
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.
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.
Is anyone else experiencing this with 3.5.1 or is the problem on my end?
Daniel
12-02-2005, 01:14 AM
It's now showing up in the usergroup permissions. I'm using 3.5.0. Any idea what's wrong? I rebuilt my bitfields aswell.
matthias.m
12-04-2005, 11:40 AM
I have installed your Hack (the German Translation wich is v0.9b) but I have got some Problems whith the Attachments I think: They aren`t shown in the Tickets?
Is this a known Bug or a Misconfiguration from me?
Greetings
Matthias
bitblaster
12-04-2005, 01:06 PM
I am using vBulletin 3.5.1.
It is not working, it will not let me save any permissions on who can use the helpdesk.
Any ideas?
bitblaster
12-04-2005, 01:09 PM
Ok, just read about the bitfields... is working now.
dc3dreamer
12-05-2005, 02:45 AM
[stupid idea removed!]
I love vBSupport!!!!! It's working perfectly and my users love it too.
jesse
12-09-2005, 12:59 AM
Assign Ticket:
how about have a default technician so when a member post a ticket it is assigned to a certain user automatically
and make post in a category instead of no category selected
jimmyboy
12-10-2005, 02:36 AM
can someone update it to 3.52?
mholtum
12-13-2005, 05:14 PM
I get this when attemping to hit the VBsupport.php file:
Database error in vBulletin 3.5.2:
Invalid SQL:
SELECT ticket.*, user.username AS assignedtechusername
, icon.title AS icontitle, icon.iconpath
FROM vb3_ticket AS ticket
LEFT JOIN vb3_user AS user ON (user.userid = ticket.assignedtechid)
LEFT JOIN vb3_icon AS icon ON(icon.iconid = ticket.iconid)
WHERE ticket.postuserid = 1 AND open = 1
ORDER BY ticket.replydateline DESC
LIMIT 0, 20;
MySQL Error : Unknown column 'ticket.assignedtechid' in 'on clause'
Error Number : 1054
Date : Tuesday, December 13th 2005 @ 11:13:42 AM
Script : http://www.theflyfishingforum.com/forums/vBSupport.php
Referrer : http://www.theflyfishingforum.com/
IP Address : 70.162.7.101
Username : fshfanatic
Classname : vb_database
Smiry Kin's
12-18-2005, 03:34 AM
doesnt work with 3.5.2 doesnt add the user group permissions, section for them all,
please tell us how to add it manual.
thank you.
Hostboard
12-18-2005, 05:54 PM
Hopefully this will get updated to work with 3.5.2
kylek
12-18-2005, 09:09 PM
This will get it to work for 3.5.1:
Replace the contents of includes\xml\bitfield_support.xml with the following:
<?xml version="1.0" encoding="ISO-8859-1"?>
<bitfields product="vBSupport">
<bitfielddefs>
<group name="ugp">
<group name="supportpermissions">
<bitfield name="canadminsupport" group="support_admin_permissions" phrase="support_can_admin_support_tickets" install="2,3,4,5,6,7">1</bitfield>
<bitfield name="cancreatetickets" group="support_admin_permissions" phrase="support_can_create_tickets" install="2,3,4,5,6,7">2</bitfield>
<bitfield name="canreplytoowntickets" group="support_admin_permissions" phrase="support_can_reply_to_own_tickets" install="2,3,4,5,6,7">4</bitfield>
<bitfield name="canreplytoalltickets" group="support_admin_permissions" phrase="support_can_reply_to_all_tickets" install="2,3,4,5,6,7">8</bitfield>
<bitfield name="candeleteowntickets" group="support_admin_permissions" phrase="support_can_delete_own_tickets" install="2,3,4,5,6,7">16</bitfield>
<bitfield name="candeleteanyticket" group="support_admin_permissions" phrase="support_can_delete_any_ticket" install="2,3,4,5,6,7">32</bitfield>
<bitfield name="cancloseowntickets" group="support_admin_permissions" phrase="support_can_close_own_tickets" install="2,3,4,5,6,7">64</bitfield>
<bitfield name="cancloseanyticket" group="support_admin_permissions" phrase="support_can_close_any_ticket" install="2,3,4,5,6,7">128</bitfield>
<bitfield name="canopenowntickets" group="support_admin_permissions" phrase="support_can_open_own_tickets" install="2,3,4,5,6,7">256</bitfield>
<bitfield name="canopenanyticket" group="support_admin_permissions" phrase="support_can_open_any_ticket" install="2,3,4,5,6,7">512</bitfield>
<bitfield name="canassigntickets" group="support_admin_permissions" phrase="support_can_assign_tickets" install="2,3,4,5,6,7">1024</bitfield>
<bitfield name="canreassigntickets" group="support_admin_permissions" phrase="support_can_reassign_tickets" install="2,3,4,5,6,7">2048</bitfield>
<bitfield name="canpostattachments" group="support_admin_permissions" phrase="support_can_post_attachments" install="2,3,4,5,6,7">4096</bitfield>
<bitfield name="canviewattachments" group="support_admin_permissions" phrase="support_can_view_attachments" install="2,3,4,5,6,7">8192</bitfield>
<bitfield name="canmanagecategories" group="support_admin_permissions" phrase="support_can_manage_categories" install="2,3,4,5,6,7">16384</bitfield>
<bitfield name="canupdatecategorytype" group="support_admin_permissions" phrase="support_can_update_categorytype" install="2,3,4,5,6,7">32768</bitfield>
</group>
</group>
</bitfielddefs>
</bitfields>
<!-- CVS: $RCSfile: bitfield_support.xml,v $ - $Revision: 1.0 $ -->
Couldn't find usergroup permissions for 3.5.2 until I reread the posts here, did the above edit and it adds the usergroup permissions section into 3.5.2.
Now to see if everything else works!!
FD929
12-18-2005, 09:15 PM
Believe it or not, the only error is in includes/xml/bitfield_support.xml
<bitfields product="vBulletin"> should not be capitalized.
It should be <bitfields product="vbulletin">
This will add the options to usergroup permissions as it is intended to rather than adding another cp module.
P.S. You may need to rebuild bitfields. /admincp/index.php?do=buildbitfields
fusiongoddess
12-20-2005, 12:02 PM
The category names are all showing up as the number one for me. How can I fix this?
Thanks!
Player-63
12-20-2005, 09:38 PM
I followed the install to the letter...all went find, "except" I cannot see the "permissions" area and I am getting this as I try to add categories "You are not authorized to manage ticket categories."
I also get this message and i have changed the bitfield_support file
silurius
12-20-2005, 10:45 PM
I also get this message and i have changed the bitfield_support file
Is the bitfield_support file a valid product or plugin? I get "Invalid File Specified" when I try to install it.
Wildthinks
12-21-2005, 09:38 AM
Hi,
i have test under 3.52 german and it's wonderfull...but a small bugs/questions.
Questions/bugs...
1. How can all User (specificate in userperm that allow) list and search all tickets? (open/closed)
2. How can i implement that a email/pm is send to the staff which have assign to a ticket?
3. Seems a small bug, when admin open ticket the categorie and save it - cat is lost... where can i change it? In the dropdown are the default value not the selected cat...
4. Is there a plan to make a directory to select first the cat for ticket and then add a ticket... all tickets are listen for this cat and the new ticket assign automaticly the cat and a little bit better, when i set a default user - also assign the user...
Yes of course I will use it and also donate...when is done...
Thomas
Player-63
12-21-2005, 11:41 AM
Is the bitfield_support file a valid product or plugin? I get "Invalid File Specified" when I try to install it.
just edited the file in incudes/xml folder and reinstalled plugin and still nothink :( dont know if i done it right.
selven12
12-21-2005, 05:04 PM
I can't find anyway to set the permissions!! I installed everything correctly but when I go into user group permissions there is no section for the support system. So when I try to create a new category or post a support ticket It says I don't have permission to use the support system and my members are having the same problem too!! But I can't change it!! So I really need help!! I've uploaded all files to the correct directories and everything and it still won't work!! So can someone help me??
selven12
12-21-2005, 05:07 PM
I can't find anyway to set the permissions!! I installed everything correctly but when I go into user group permissions there is no section for the support system. So when I try to create a new category or post a support ticket It says I don't have permission to use the support system and my members are having the same problem too!! But I can't change it!! So I really need help!! I've uploaded all files to the correct directories and everything and it still won't work!! So can someone help me??
Never mind!! I just found out that it doesn't work with 3.5.2, That's the ersion that I have. Let me know when it is compatible with it though!!
FD929
12-22-2005, 04:46 AM
Never mind!! I just found out that it doesn't work with 3.5.2, That's the ersion that I have. Let me know when it is compatible with it though!!
Note the vB 3.5.2 under my avatar. :) It works fine. I'm using it as we speak.
https://vborg.vbsupport.ru/showpost.php?p=851785&postcount=215
selven12
12-22-2005, 06:39 AM
Hmm...then how come I can't change the permissions or anything? Nothing has changed since I uploaded all of the files. It just won't work!! Can you tell me why?? hmm??
selven12
12-22-2005, 07:19 AM
Note the vB 3.5.2 under my avatar. :) It works fine. I'm using it as we speak.
https://vborg.vbsupport.ru/showpost.php?p=851785&postcount=215
Thanks for the new XML file!! It really helped!! Your a life saver!!
Smiry Kin's
12-22-2005, 04:09 PM
wow just changed vBulletin to vbulletin, n works, cheers :)
Julie
12-24-2005, 10:59 PM
Damn... For me it's still showing the DB errors specified above here somewhere... And I'm sure I've changed vBulletin to vbulletin in the xml file, and uploaded that. I even rebuilt the bitfields...
harry1951
12-25-2005, 09:36 AM
I just installed it but can't create categories :(
All admin permissions are set to yes.
I added an name in the namefield, selected the userpermissions and tech's but after hitting the add button I get this errormessage:
Please complete the category name field to add a category.
Somebody any idea???
docvader
12-26-2005, 04:48 AM
I just installed it but can't create categories :(
All admin permissions are set to yes.
I added an name in the namefield, selected the userpermissions and tech's but after hitting the add button I get this errormessage:
Please complete the category name field to add a category.
Somebody any idea???
Yea, I get that also.
In the box below the supposed category name, it asks for a user admin ID. I put in "1", which is me, along with a name for the category, it's listing rank to the right, and the permissions for the groups below. Then, submit it.
You'll get the category installed, with the name "1".
OK, then edit that category, and put in the name that you want. It should load up just fine then.
Bizarre. Not sure why it does that. Seems to read the admin ID as the category name.
divided_by_fear
12-29-2005, 01:25 AM
is there any plans on caching the templates? cause there is some major non cached templates going on here
Uncached templates: editor_clientscript (1)
Uncached templates: editor_jsoptions_font (1)
Uncached templates: editor_jsoptions_size (1)
Uncached templates: editor_smilie (11)
Uncached templates: editor_smiliebox (1)
Uncached templates: editor_smiliebox_row (4)
Uncached templates: editor_smiliebox_straggler (1)
Uncached templates: editor_toolbar_on (1)
Uncached templates: forumrules (1)
Uncached templates: newpost_attachment (1)
Uncached templates: newpost_disablesmiliesoption (1)
Uncached templates: newpost_errormessage (1)
Uncached templates: newpost_preview (1)
Uncached templates: posticonbit (14)
Uncached templates: posticons (1)
Uncached templates: support_newreply (1)
Hostboard
12-29-2005, 11:26 AM
Have you read post #215 of this thread? This does work under 3.5.2 as long as you make the noted change in that post.
lanc3lot
12-29-2005, 12:43 PM
I have an error, that as i searched this thread, occured in many ppl but there was no solution till now (strange).
What i get when i hit vbsupport.php is:
Database error in vBulletin 3.5.0:
Invalid SQL:
SELECT ticket.*, user.username AS assignedtechusername
, icon.title AS icontitle, icon.iconpath
FROM vb3new_ticket AS ticket
LEFT JOIN vb3new_user AS user ON (user.userid = ticket.assignedtechid)
LEFT JOIN vb3new_icon AS icon ON(icon.iconid = ticket.iconid)
WHERE ticket.postuserid = 597 AND open = 1
ORDER BY ticket.replydateline DESC
LIMIT 0, 20;
MySQL Error : Unknown column 'ticket.assignedtechid' in 'on clause'
Error Number : 1054
Date : Thursday, December 29th 2005 @ 04:37:11 PM
Script : http://www.gamers.gr/forums/vbsupport.php
Referrer :
IP Address : 62.1.106.241
Username : lancelot
Classname : vb_database
Can anyone help of what to do?
divided_by_fear
12-29-2005, 02:14 PM
Have you read post #215 of this thread? This does work under 3.5.2 as long as you make the noted change in that post.
what does post 215 have to do with cached templates? i have it working... i made the change i read before i post... i was wondering if they plan on cacheing it.... or if someone has already....
obsidian
01-02-2006, 04:39 AM
I am not seeing the issue with uncached templates on mine. I just installed on 3.52 with no issues after making the bitfield_support.xml change listed on the previous page.
I did have to edit the category the category name after creating it because it takes the userid instead of the name I put in.
Great hack though. Perfect for use during an upgrade.
lanc3lot
01-03-2006, 08:45 AM
Apparently, there is no fix for my prob yet, :(
Snake
01-03-2006, 12:07 PM
What a hack!
Thanks.
FD929
01-03-2006, 04:06 PM
I have an error, that as i searched this thread, occured in many ppl but there was no solution till now (strange).
What i get when i hit vbsupport.php is:
1 - Do you have access to phpmyadmin? If so, verify that the tables ticket, ticketcategory, and ticketreply exist.
lanc3lot
01-03-2006, 05:35 PM
Hello again, yes the tables u mentioned, exist.
Any more hints?:D
lanc3lot
01-03-2006, 06:00 PM
Hm, uninstalled and installed again and it fixed:)
Strangeeeeeeeeeeee
Anyway, thnx:)
Julie
01-03-2006, 08:56 PM
When you set the usergroup permissions, it would be great if it overwrote the ones in the AdminCP. I've made a test category, and allowed almost all usergroups in it, and Admins as tech groups. But when I try to log in as a Full Member (which should have access according to vbsupport.php, categories, permissions there), it says I'm not authorized.
It would be good if the permissions you set up on vbsupport.php overpowered the ones on the AdminCP.
Other than that, *installed* :)
godknows168
01-03-2006, 09:32 PM
the code to deal with the sending of the pm is buggy. It might be a good idea to use the DM.
Wildthinks
01-04-2006, 10:39 AM
Hi,
i have test under 3.52 german and it's wonderfull...but a small bugs/questions.
Questions/bugs...
1. How can all User (specificate in userperm that allow) list and search all tickets? (open/closed)
2. How can i implement that a email/pm is send to the staff which have assign to a ticket?
3. Seems a small bug, when admin open ticket the categorie and save it - cat is lost... where can i change it? In the dropdown are the default value not the selected cat...
4. Is there a plan to make a directory to select first the cat for ticket and then add a ticket... all tickets are listen for this cat and the new ticket assign automaticly the cat and a little bit better, when i set a default user - also assign the user...
Yes of course I will use it and also donate...when is done...
Thomas
seems nobody interest it? Can help anyone?
Thanks Tom
Xplorer4x4
01-06-2006, 07:23 AM
I do not see the usergroup settings in the Admin CP on 3.5.3.
Julie
01-06-2006, 11:55 AM
I do not see the usergroup settings in the Admin CP on 3.5.3.
It should be in the actual usergroup settings, f.ex Moderators group and then at the bottom...
Xplorer4x4
01-06-2006, 06:29 PM
Yes I am aware of that, and it does not show up there.
Julie
01-06-2006, 08:07 PM
Try uninstalling it, and then re-installing it. That worked for me, as I had some database errors...
Xplorer4x4
01-06-2006, 08:28 PM
It installs fine(no db errors), and i can acess the vBsupport.php script but i can not do anything in it because of the inability to set permisions for each usergroup.
JamesHarrison
01-07-2006, 03:19 AM
Yeah, same problem here. Tried a reinstall. No errors, the table schema and data looks fine.
tomshawk
01-07-2006, 11:43 AM
Yeah, same problem here. Tried a reinstall. No errors, the table schema and data looks fine.
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
rlamego
01-08-2006, 06:10 AM
Installed it, changed the faulty line Tomshawk pointed and everything is kind of fine except the userid -> category name switch bug (resolved editing each category) and that category usergroup settings that are not respected.
For example, my "forums" category should be accessible to paid members only but everyone can submit a tick to it!
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.