Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
HelpDesk v1.63 Details »»
HelpDesk v1.63
Version: 1.63, by WhSox21 WhSox21 is offline
Developer Last Online: Apr 2014 Show Printable Version Email this Page

Version: 3.0.7 Rating:
Released: 02-26-2005 Last Update: 04-29-2005 Installs: 230
DB Changes
 
No support by the author.

Feature Request...
If you're interested in requesting a feature please use the form on this page:
http://www.hackvb.com/helpdesk.php

Description:
This is a ticket support system. Your members can now open up tickets rather than email you all the time.

Features
  • No File Edits!
  • Ability to turn the HelpDesk off.
  • Ability to turn the New Ticket option off.
  • Automated Response to users when tickets are submitted by email or private message.
  • Ability to select which usergroups have access to creating Departments and managing the other usergroup's HelpDesk settings.
  • Departments / Ticket Categories.
  • Limit usergroups to handle certain department tickets.
  • Limit usergroups by the following actions: new tickets, edit tickets, delete tickets, resolve / unresolve tickets, claim/unclaim ownership of tickets.
  • New Tickets since last visit to forums.
  • New Replies since last visit to forums.
  • Unresolved / Resolved Tickets.
  • WYSIWYG Editor for replies.
No File Edits!
When upgrading your forums there will be no problems. This will not give you any headaches because it almost runs separate of vBulletin..

1 Template Modification
This only has one template modification and that is to the navbar if you want a link there.

How-tos:
Giving Access to the Departments and Usergroup Settings
Usergroup Settings
Managing Departments

Installed?
Please click install if you install so you get notifications of all the latest bug fixes and feature addons.


Bug Fixes / Feature Additions:
v1.00 - Initial Release
v1.01 - Added template caching for a slight performance increase. Thanks to: princeton
v1.02 - Install script updated to create databases with table prefixes. Also added the ability to select which usergroups have access to the administer options.
v1.03 - Uninstall section added to the install script.
v1.50 - Ton of features added. Will update this with a link to the post where I named all the features added.
v1.51 - Bug fix. This fixes the problem with sending PMs for the auto responder.
v1.52 - Bug fix. This fixes the problem where the creator of tickets cannot reply to the ticket and a cosmetic fix to the installer.
v1.53 - Bug fixes. Fixes the problem with the PM pop-up, database errors for some people and the delete errors.
v1.54 - Bug fixes. Fixes the problem with the install script with one table.
v1.55 - Bug fixes. Fixes the problem with the Usergroup Settings page loading half the way down the page in IE.
v1.60 - Bug fixes. Fixes the security hole pointed out by xYarub. This also adds the send a new PM on ticket update feature.
v1.61 - Bug fixes.
v1.62 - Parse error fix.
v1.63 - Really fixed the permission errors.

Donations:
Hacks like these takes up enormous amounts of time and energy. This hack is entirely free to use. Please help me, help the vBulletin community by donating. Donations will keep me releasing hacks for free rather than doing custom work. A donation of any amount is much appreciated! Tell me this hack isn't work a couple bucks?

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #137  
Old 03-05-2005, 07:14 PM
MissKalunji's Avatar
MissKalunji MissKalunji is offline
 
Join Date: Aug 2003
Location: Canada
Posts: 2,845
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

THANK YOUUUUUUUUUUUU
i been waiting so long to have it for vb 3xx
wicked works perfectly if you need a site as example

http://www.dancehallareaz.com/forum/helpdesk.php

:nervous:
Reply With Quote
  #138  
Old 03-05-2005, 07:16 PM
WhSox21 WhSox21 is offline
 
Join Date: Feb 2004
Posts: 328
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MissKalunji
THANK YOUUUUUUUUUUUU
i been waiting so long to have it for vb 3xx
wicked works perfectly if you need a site as example

http://www.dancehallareaz.com/forum/helpdesk.php

:nervous:
You must be registered for this version!
Reply With Quote
  #139  
Old 03-05-2005, 07:24 PM
Challenge Challenge is offline
 
Join Date: Jan 2005
Location: Denmark
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Found out... thanks
(thought the department usergroups was the usergroups eho was able to use it... Dumb me )
Reply With Quote
  #140  
Old 03-05-2005, 07:32 PM
MissKalunji's Avatar
MissKalunji MissKalunji is offline
 
Join Date: Aug 2003
Location: Canada
Posts: 2,845
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by WhSox21
You must be registered for this version!

im lost :nervous:
Reply With Quote
  #141  
Old 03-05-2005, 07:34 PM
WhSox21 WhSox21 is offline
 
Join Date: Feb 2004
Posts: 328
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MissKalunji
im lost :nervous:
People can't check out the helpdesk on your site because it requires registration! :lick:
Reply With Quote
  #142  
Old 03-05-2005, 07:48 PM
MissKalunji's Avatar
MissKalunji MissKalunji is offline
 
Join Date: Aug 2003
Location: Canada
Posts: 2,845
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by WhSox21
People can't check out the helpdesk on your site because it requires registration! :lick:
oh mah bad
that means
unregistered cant use it?
Reply With Quote
  #143  
Old 03-05-2005, 07:50 PM
WhSox21 WhSox21 is offline
 
Join Date: Feb 2004
Posts: 328
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MissKalunji
changing now...
You can't change that unless you edit the file. This version of the helpdesk requires registration. That's why you don't see the unregistered usergroup in the usergroup settings section!
Reply With Quote
  #144  
Old 03-05-2005, 07:51 PM
MissKalunji's Avatar
MissKalunji MissKalunji is offline
 
Join Date: Aug 2003
Location: Canada
Posts: 2,845
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by WhSox21
You can't change that unless you edit the file. This version of the helpdesk requires registration. That's why you don't see the unregistered usergroup in the usergroup settings section!
oh oops

[high]* MissKalunji feels dumb :nervous:[/high]
Reply With Quote
  #145  
Old 03-05-2005, 07:53 PM
MissKalunji's Avatar
MissKalunji MissKalunji is offline
 
Join Date: Aug 2003
Location: Canada
Posts: 2,845
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by WhSox21
Not sure what you mean exactly. After setting the usergroup settings everything should be alright. Only usergroups that "Can ____ Any Ticket" will be able to see most of the tickets. Then you must set the usergroups who can edit the departments seperated by commas.

Every regular user can only see their own tickets.
so about hte departement what the usergroup for?
Reply With Quote
  #146  
Old 03-05-2005, 08:11 PM
WhSox21 WhSox21 is offline
 
Join Date: Feb 2004
Posts: 328
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MissKalunji
so about hte departement what the usergroup for?
The department usergroup gives those usergroups access to the tickets in the department. The usergroup settings is where you can limit the usergroups abilities.
Reply With Quote
  #147  
Old 03-05-2005, 08:27 PM
MissKalunji's Avatar
MissKalunji MissKalunji is offline
 
Join Date: Aug 2003
Location: Canada
Posts: 2,845
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by WhSox21
The department usergroup gives those usergroups access to the tickets in the department. The usergroup settings is where you can limit the usergroups abilities.

Thank you so much!!!!!!!!!!!!!
Reply With Quote
  #148  
Old 03-05-2005, 08:33 PM
T3MEDIA T3MEDIA is offline
 
Join Date: Dec 2004
Posts: 944
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

so what is new with this baby?
Reply With Quote
  #149  
Old 03-05-2005, 08:43 PM
ChrisBaktis ChrisBaktis is offline
 
Join Date: Mar 2004
Location: CT
Posts: 409
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Im getting many database errors - if I click on my tickets, or unresolved tickets, I get a database error.

Code:
Database error in vBulletin 3.0.7:

Invalid SQL: SELECT ticketid, title, postusername, dateline, lastposter, lastupdate, department FROM ticket AS ticket JOIN ticketdepartment AS ticketdepartment ON (ticketdepartment.departmentid = ticket.departmentid) WHERE open = 1 AND ownerid = 0 AND dateline >= 1110062033 AND ticketdepartment.departmentid IN (3)
mysql error: You have an error in your SQL syntax near 'ON (ticketdepartment.departmentid = ticket.departmentid) WHERE open = 1 AND owne' at line 1

mysql error number: 1064

Date: Saturday 05th of March 2005 05:42:39 PM
Script: http://rustysoaptraders.com/forums/helpdesk.php?do=newtickets
Referer: http://rustysoaptraders.com/forums/helpdesk.php?do=departments
Username: poongamer
I was able to setup departments.

Get a database error if I go to www.mysite.com/forums/helpdesk.php
Reply With Quote
  #150  
Old 03-05-2005, 08:51 PM
WhSox21 WhSox21 is offline
 
Join Date: Feb 2004
Posts: 328
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by T3MEDIA
so what is new with this baby?
Departments
Usergroup Settings
PM / Email on new ticket (to ticket creator).
Master Switch
Turn off accepting new tickets.
Can see resolved tickets.

Quote:
Originally Posted by ChrisBaktis
Im getting many database errors - if I click on my tickets, or unresolved tickets, I get a database error.

I was able to setup departments.

Get a database error if I go to www.mysite.com/forums/helpdesk.php
I don't see anything wrong with that. What I would do if you don't have any tickets yet is use the install script and click the uninstall link and go through everything then go back and use the install link. This should fix everything if not let me know.

gr33tz - I got an email saying you replied with a problem. Did you fix your problem?
Reply With Quote
  #151  
Old 03-05-2005, 09:00 PM
ChrisBaktis ChrisBaktis is offline
 
Join Date: Mar 2004
Location: CT
Posts: 409
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Still getting many database errors.

Only two things work:

Setting up Departments, and New Tickets under User Control - All other links generate Database error.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 02:28 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.10101 seconds
  • Memory Usage 2,371KB
  • Queries Executed 30 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (11)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (16)post_thanks_box
  • (16)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (16)post_thanks_postbit_info
  • (15)postbit
  • (16)postbit_onlinestatus
  • (16)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete