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
  #47  
Old 02-28-2005, 08:28 AM
Slave's Avatar
Slave Slave is offline
 
Join Date: Nov 2001
Posts: 439
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by laeth
does this work with 3.0.3?
Yep .. that's what I've installed in on
Reply With Quote
  #48  
Old 02-28-2005, 08:30 AM
quachvu quachvu is offline
 
Join Date: Jun 2004
Posts: 53
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Creed
Go to your admincp, click usergroups. ==> usergroup manager. From that point you can edit the permissions of each usergroup. Just look for "Can create tickets"
well, i installed and eveything done, but i looked carefully in usergroupd manager and couldnt find "Can create tickets" to set permission who can creat tickets!
Reply With Quote
  #49  
Old 02-28-2005, 08:33 AM
laeth laeth is offline
 
Join Date: Aug 2004
Posts: 40
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Slave
Yep .. that's what I've installed in on
Ok, how do I make it so that the installer recognises my Table prefixes? At the moment it is installing them on there own. I have a vb3_ prefix on there as well.

hmmm....
Reply With Quote
  #50  
Old 02-28-2005, 08:55 AM
Slave's Avatar
Slave Slave is offline
 
Join Date: Nov 2001
Posts: 439
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by laeth
Ok, how do I make it so that the installer recognises my Table prefixes? At the moment it is installing them on there own. I have a vb3_ prefix on there as well.

hmmm....
hmm .. I've had a look though the code and it should cope with Table prefixes .. so not sure why it isn't working for you ..
Reply With Quote
  #51  
Old 02-28-2005, 08:57 AM
laeth laeth is offline
 
Join Date: Aug 2004
Posts: 40
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This is odd. I guess I'll have to wait for the guy who wrote it too show up
Reply With Quote
  #52  
Old 02-28-2005, 09:07 AM
laeth laeth is offline
 
Join Date: Aug 2004
Posts: 40
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

nvm I fixed it. I changed the querys to this instead, seemed to do the trick:


PHP Code:
$query['new'][] = "CREATE TABLE `".TABLE_PREFIX."ticketreply` (
  `replyid` int(10) unsigned NOT NULL auto_increment,
  `ticketid` int(10) unsigned NOT NULL default '0',
  `username` varchar(50) NOT NULL default '',
  `userid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `pagetext` mediumtext NOT NULL,
  `ipaddress` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`replyid`),
  KEY `userid` (`userid`),
  KEY `threadid` (`ticketid`,`userid`)
) TYPE=MyISAM AUTO_INCREMENT=1"
;

$query['new'][] = "CREATE TABLE `".TABLE_PREFIX."ticket` (
  `ticketid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(250) NOT NULL default '',
  `open` smallint(6) NOT NULL default '1',
  `ownerid` int(10) unsigned NOT NULL default '0',
  `replycount` int(10) unsigned NOT NULL default '0',
  `postusername` varchar(50) NOT NULL default '',
  `postuserid` int(10) unsigned NOT NULL default '0',
  `lastposter` varchar(50) NOT NULL default '',
  `lastupdate` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ticketid`),
  KEY `postuserid` (`postuserid`)
) TYPE=MyISAM AUTO_INCREMENT=1"

Reply With Quote
  #53  
Old 02-28-2005, 09:15 AM
computer1 computer1 is offline
 
Join Date: Feb 2005
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

And where shuld we put this ??
Reply With Quote
  #54  
Old 02-28-2005, 09:53 AM
laeth laeth is offline
 
Join Date: Aug 2004
Posts: 40
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Replace:

PHP Code:
$query['new'][] = "CREATE TABLE `ticketreply` (
  `replyid` int(10) unsigned NOT NULL auto_increment,
  `ticketid` int(10) unsigned NOT NULL default '0',
  `username` varchar(50) NOT NULL default '',
  `userid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `pagetext` mediumtext NOT NULL,
  `ipaddress` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`replyid`),
  KEY `userid` (`userid`),
  KEY `threadid` (`ticketid`,`userid`)
) TYPE=MyISAM AUTO_INCREMENT=1"
;

$query['new'][] = "CREATE TABLE `ticket` (
  `ticketid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(250) NOT NULL default '',
  `open` smallint(6) NOT NULL default '1',
  `ownerid` int(10) unsigned NOT NULL default '0',
  `replycount` int(10) unsigned NOT NULL default '0',
  `postusername` varchar(50) NOT NULL default '',
  `postuserid` int(10) unsigned NOT NULL default '0',
  `lastposter` varchar(50) NOT NULL default '',
  `lastupdate` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ticketid`),
  KEY `postuserid` (`postuserid`)
) TYPE=MyISAM AUTO_INCREMENT=1"

with:

PHP Code:
$query['new'][] = "CREATE TABLE `".TABLE_PREFIX."ticketreply` (
  `replyid` int(10) unsigned NOT NULL auto_increment,
  `ticketid` int(10) unsigned NOT NULL default '0',
  `username` varchar(50) NOT NULL default '',
  `userid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `pagetext` mediumtext NOT NULL,
  `ipaddress` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`replyid`),
  KEY `userid` (`userid`),
  KEY `threadid` (`ticketid`,`userid`)
) TYPE=MyISAM AUTO_INCREMENT=1"
;

$query['new'][] = "CREATE TABLE `".TABLE_PREFIX."ticket` (
  `ticketid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(250) NOT NULL default '',
  `open` smallint(6) NOT NULL default '1',
  `ownerid` int(10) unsigned NOT NULL default '0',
  `replycount` int(10) unsigned NOT NULL default '0',
  `postusername` varchar(50) NOT NULL default '',
  `postuserid` int(10) unsigned NOT NULL default '0',
  `lastposter` varchar(50) NOT NULL default '',
  `lastupdate` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ticketid`),
  KEY `postuserid` (`postuserid`)
) TYPE=MyISAM AUTO_INCREMENT=1"

In the helpdesk_install.php .

Hope it helps.
Reply With Quote
  #55  
Old 02-28-2005, 11:47 AM
computer1 computer1 is offline
 
Join Date: Feb 2005
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I get this error when I reinstall helpdesk howe can I fix this ??

Database error in vBulletin 3.0.7:

Invalid SQL: CREATE TABLE `ticketreply` (
`replyid` int(10) unsigned NOT NULL auto_increment,
`ticketid` int(10) unsigned NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`pagetext` mediumtext NOT NULL,
`ipaddress` varchar(15) NOT NULL default '',
PRIMARY KEY (`replyid`),
KEY `userid` (`userid`),
KEY `threadid` (`ticketid`,`userid`)
) TYPE=MyISAM AUTO_INCREMENT=1
mysql error: Table 'ticketreply' already exists

mysql error number: 1050
Reply With Quote
  #56  
Old 02-28-2005, 11:53 AM
nexialys
Guest
 
Posts: n/a
Default

question... is it possible to guests to create a new ticket ?!
[so guests would be asked to enter email and name...]

i'd like to use this system instead of the contact-us form...
Reply With Quote
  #57  
Old 02-28-2005, 12:29 PM
shadiguy1 shadiguy1 is offline
 
Join Date: Jul 2004
Location: Delco,Pa
Posts: 146
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

yes it works with 3.0.3
Reply With Quote
  #58  
Old 02-28-2005, 01:27 PM
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Location: Landen(Belgium)
Posts: 1,335
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

installed successfully on vbulletin 3.0.7 however i had to create the database tables by hand for some reason the tables where in my database but without the correct prefixes installer bug ? anyway nice hack

/me clicks install
Reply With Quote
  #59  
Old 02-28-2005, 02:45 PM
computer1 computer1 is offline
 
Join Date: Feb 2005
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Howe can I unistall this dont work for me :devious:
Reply With Quote
  #60  
Old 02-28-2005, 02:57 PM
Dan's Avatar
Dan Dan is offline
 
Join Date: Dec 2002
Location: Titusville, Florida
Posts: 1,787
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Interesting idea..... good job
Reply With Quote
  #61  
Old 02-28-2005, 03:13 PM
Lord Brar's Avatar
Lord Brar Lord Brar is offline
 
Join Date: Jul 2004
Posts: 102
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Wish, all hacks could be like this!

Thanks man! I am gonna install this one!
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 12:36 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.07332 seconds
  • Memory Usage 2,381KB
  • 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
  • (3)bbcode_php
  • (4)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
  • (15)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