vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   HelpDesk v1.63 (https://vborg.vbsupport.ru/showthread.php?t=77155)

Blackbeard 03-09-2005 04:42 PM

i have installed this hack and have set it to be a helpdesk for all topics like pc as well as forum bugs, but i would like to make a suggestion for a future idea, if other people use this hack in this way, would it be possible to make it make a automatic post in a forum saying a member is asking for help, please proceed to the helpdesk and see if you can resolve their problem.

think this will make a super hack even better if thats possible.

PS does anyone have a guide on how to use this, what each thing does, that members can read - iam about to do one myself if i find a spare 5 mins.

WhSox21 03-09-2005 04:46 PM

Quote:

Originally Posted by WhSox21
What browser? Would you be willing to give me access to check this problem out?

Nevermind, it's IE specific and I figured out the problem. I'll release an update here shortly with instructions on how to fix the problem.

JayJay 03-09-2005 04:47 PM

Quote:

Originally Posted by Blackbeard
PS does anyone have a guide on how to use this, what each thing does, that members can read - iam about to do one myself if i find a spare 5 mins.

If you look up at the information about this modification then you will see the following:

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


Is this what you are looking for? Or are you looking for a user guide? One assumes that such a system is straightforward to submit a question, but if you really need a user guide then I don't believe there is one.

ESADCG 03-09-2005 04:49 PM

EDIT : Dismiss, I got it to work after doing another complete uninstall/re-install :nervous:



Quote:

Originally Posted by WhSox21
Run a full uninstall of the settings. Just click the link that says Uninstall Settings. Download verion 1.54 rather than version 1.53 and then try to install it. That error was the only fix of version 1.54.


Ok, did that. Made a little difference. But now I get this error when I try to re-install 1.54.

Invalid SQL: ALTER TABLE `vb3_usergroup` ADD `ticketpermissions` INT(10) UNSIGNED DEFAULT '0' NOT NULL
mysql error: Duplicate column name 'ticketpermissions'

mysql error number: 1060

Date: Wednesday 09th of March 2005 01:47:14 PM
Script: http://****/VB/admincp/helpdesk_inst...install&step=4
Referer: http://****/VB/admincp/helpdesk_inst...install&step=3

JayJay 03-09-2005 04:49 PM

Quote:

Originally Posted by WhSox21
Nevermind, it's IE specific and I figured out the problem. I'll release an update here shortly with instructions on how to fix the problem.

Thanks WhSox. I have the same thing, but I was happy to live with it, considering I'm not in and out of user permissions. It is merely a cosmetic afterall. However, fixing this would be excellent.

WhSox21 03-09-2005 04:53 PM

Quote:

Originally Posted by ESADCG
Ok, did that. Made a little difference. But now I get this error when I try to re-install 1.54.

Invalid SQL: ALTER TABLE `vb3_usergroup` ADD `ticketpermissions` INT(10) UNSIGNED DEFAULT '0' NOT NULL
mysql error: Duplicate column name 'ticketpermissions'

mysql error number: 1060

Date: Wednesday 09th of March 2005 01:47:14 PM
Script: http://****/VB/admincp/helpdesk_inst...install&step=4
Referer: http://****/VB/admincp/helpdesk_inst...install&step=3

You're fine. The install has ran everything that it really needs to run. If you still need to do the template edit to add it to your navbar change the step=4 to step=5 in the url. Then you'll be fine. Your helpdesk should be running fine now.

WhSox21 03-09-2005 04:58 PM

Ok, I have fixed the problem with the Usergroup Settings page in IE where it moves down half the page. To fix this problem it's rather simple.

1. Upload helpdesk_install.php to your admincp folder and run it.
2. Click on a link that says Install Templates.

You're done, don't go through any other steps, if you do then it will give you database errors.

Warning: This will update any HelpDesk templates. If you have made any changes save them first and then run this to prevent problems.

Slave 03-09-2005 05:35 PM

Quote:

Originally Posted by WhSox21
Ok, I have fixed the problem with the Usergroup Settings page in IE where it moves down half the page. To fix this problem it's rather simple.

1. Upload helpdesk_install.php to your admincp folder and run it.
2. Click on a link that says Install Templates.

You're done, don't go through any other steps, if you do then it will give you database errors.

Warning: This will update any HelpDesk templates. If you have made any changes save them first and then run this to prevent problems.

Lovely .. that did the trick .. thanks .. :)

LOTR 03-09-2005 05:52 PM

I cant find 2. Click on a link that says Install Templates. on the helpdesk_install.php, where is it actually?

Im using 1.54 now, is it Updates/Adds Templates?

LEAD_WEIGHT 03-09-2005 06:46 PM

Quote:

Originally Posted by LOTR
I cant find 2. Click on a link that says Install Templates. on the helpdesk_install.php, where is it actually?

Im using 1.54 now, is it Updates/Adds Templates?

Example
Code:

http://yourdomain/forums/admincp/helpdesk_install.php?

LOTR 03-09-2005 08:34 PM

LOL.. i know the file lead-weight but i was looking for the Install Templates on the
helpdesk_install file... :D

gldtn 03-09-2005 08:56 PM

Quote:

Originally Posted by LOTR
LOL.. i know the file lead-weight but i was looking for the Install Templates on the
helpdesk_install file... :D

Download the new version
v1.55 - Bug fixes. Fixes the problem with the Usergroup Settings page loading half the way down the page in IE.

WhSox21 03-09-2005 09:57 PM

Quote:

Originally Posted by LOTR
I cant find 2. Click on a link that says Install Templates. on the helpdesk_install.php, where is it actually?

Im using 1.54 now, is it Updates/Adds Templates?

Yes, sorry. That's the link.

org 03-10-2005 12:26 AM

First off WhSox21 - This is a great add-on! I for one appreciate your time and energy put into this!

Request:
Secondly a very userfriendly enhancement would be if you could see the actual number of tickets/replies to the right, for instance: Unresolved tickets (3)

That would make this, in addition to other requests Ive seen, furthermore complete.
Keep up the good work!

(I hope this hasnt been requested already, the thread now spans over 20 pages, so its hard to be certain..)

WhSox21 03-10-2005 12:34 AM

Quote:

Originally Posted by org
First off WhSox21 - This is a great add-on! I for one appreciate your time and energy put into this!

Request:
Secondly a very userfriendly enhancement would be if you could see the actual number of tickets/replies to the right, for instance: Unresolved tickets (3)

That would make this, in addition to other requests Ive seen, furthermore complete.
Keep up the good work!

(I hope this hasnt been requested already, the thread now spans over 20 pages, so its hard to be certain..)

Nope, not a request yet. I did have that in there before but it adds extra queries that I didn't think was necessary so I got rid of it. I also have the code for the average time of response which I also took out. I'll add it in as an option next update.

Blackbeard 03-10-2005 09:19 AM

Is it possible to set it so registered users can reply to anyones helpdesk post but dont have access to the settings section.

In the add depatments area i have put there usergroup in , they can post but not reply to other members post, just we have alot of helpful members and we want to use this as a general helpdesk aswell as a bug reporting center.

WhSox21 03-10-2005 09:25 AM

It would take a little bit of editing of the actual code to accomplish this. If you really wanted to do that you could modify the helpdesk.php file and remove the part of the queries where it checks for the userid. Depending on how tomorrow goes I'll see if I can help you out and post a file for you to use. I'll try to release this as a release too.

I really need to start a list of feature requests. I'll try to get something organized here shortly. This week is pretty hectic for me so once I do get something I'll let everyone know.

Blackbeard 03-10-2005 09:33 AM

Thankyou very much, this would make it so useful for everyone

gldtn 03-10-2005 11:14 AM

Sox,

Where can I increase the amount of character to be entered in the Deparment Name? What it's set to right now is too short..

Thank You!

WhSox21 03-10-2005 01:06 PM

On Template: helpdesk_departmentlist
Find:
name="department" size="35"

Replace with:
name="department" size="255"

gldtn 03-10-2005 01:51 PM

Quote:

Originally Posted by WhSox21
On Template: helpdesk_departmentlist
Find:
name="department" size="35"

Replace with:
name="department" size="255"


I was reffering to the maxlength= which it seems it uses the max username length. I just removed the variable and set it to the size I needed, thank you.

If I'm not asking for too much can you add to your "To Do List" a department description? Maybe something like a radio buttons instead of a dropdown menu? Also would be nice to be able to add "Unregistered / Not Logged In" usergroup settings to it.

thanks for your great support!

hondaprelude88 03-10-2005 02:48 PM

has anyone thought of the idea of having the system notify the admin or who ever has access to resolve tickets, when a user submits or replies to a ticket?

WhSox21 03-11-2005 01:34 PM

Quote:

Originally Posted by gldtn
I was reffering to the maxlength= which it seems it uses the max username length. I just removed the variable and set it to the size I needed, thank you.

If I'm not asking for too much can you add to your "To Do List" a department description? Maybe something like a radio buttons instead of a dropdown menu? Also would be nice to be able to add "Unregistered / Not Logged In" usergroup settings to it.

thanks for your great support!

Sorry for not getting back to you but you were right. Lack of sleep must have got to me! :nervous:

Yea I could pretty easily change the department list into a description using radio buttons rather than the drop down. As for the Unregistered usergroup, it was purposely taken off in this version as it takes a little extra special code for that.

Quote:

Originally Posted by hondaprelude88
has anyone thought of the idea of having the system notify the admin or who ever has access to resolve tickets, when a user submits or replies to a ticket?

This has been suggested and is in the next version plans.

T3MEDIA 03-12-2005 11:17 AM

Hey the demo dont work anymore. if you want you can put it up on my site.

WhSox21 03-12-2005 03:50 PM

Quote:

Originally Posted by T3MEDIA
Hey the demo dont work anymore. if you want you can put it up on my site.

Sure give me login details along with your domain info. Just PM me that info and I'll update the post. Thanks for being generous! ;)

Blootix 03-12-2005 10:35 PM

Quote:

Originally Posted by WhSox21
Sure give me login details along with your domain info. Just PM me that info and I'll update the post. Thanks for being generous! ;)

Hey.

In the installer, it says install v1.54 even though I'm installing v1.55. Also, I can be your demo link as well.

Domain: www.blootix.com/board
Username: test user
Password: test

Blackbeard 03-13-2005 06:57 AM

Quote:

Originally Posted by Blackbeard
Is it possible to set it so registered users can reply to anyones helpdesk post but dont have access to the settings section.

In the add depatments area i have put there usergroup in , they can post but not reply to other members post, just we have alot of helpful members and we want to use this as a general helpdesk aswell as a bug reporting center.

Quote:

Originally Posted by WhSox21
It would take a little bit of editing of the actual code to accomplish this. If you really wanted to do that you could modify the helpdesk.php file and remove the part of the queries where it checks for the userid. Depending on how tomorrow goes I'll see if I can help you out and post a file for you to use. I'll try to release this as a release too.

I really need to start a list of feature requests. I'll try to get something organized here shortly. This week is pretty hectic for me so once I do get something I'll let everyone know.

I know you not had much sleep but have you had any time to look into this m8 - Sorry for pushing my luck, but its such a great idea and hack want to use it to its full potential on my forum.

WhSox21 03-15-2005 06:48 AM

Quote:

Originally Posted by Blackbeard
I know you not had much sleep but have you had any time to look into this m8 - Sorry for pushing my luck, but its such a great idea and hack want to use it to its full potential on my forum.

I'll be able to help after tomorrow...

On another note... We made HotM for March! :)

I'd really appreciate the votes! That is if you absolutely love this hack! ;)

Vote Here!

MissKalunji 03-15-2005 07:10 AM

Quote:

Originally Posted by WhSox21
I'll be able to help after tomorrow...

On another note... We made HotM for March! :)

I'd really appreciate the votes! That is if you absolutely love this hack! ;)

Vote Here!


you got my vote :nervous:

Blackbeard 03-15-2005 12:17 PM

Got my vote m8, well done

red_baron2000 03-15-2005 12:24 PM

i made a litle mod that will allow given department mods to recieve pms about new tickets that submitted to their dep.

note
this mod will add a few queries .



run this query to add option to the CP:
Code:

INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('helpdesk_pm_notify', 'helpdesk', '1', '0', '<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">
<option value=\\\"0\\\" \" . iif($setting[\'value\']==0,\'selected=\"selected\"\') . \">$vbphrase[none]</option>
<option value=\\\"1\\\" \" . iif($setting[\'value\']==1,\'selected=\"selected\"\') . \">$vbphrase[private_message]</option>
<option value=\\\"2\\\" \" . iif($setting[\'value\']==2,\'selected=\"selected\"\') . \">$vbphrase[email]</option>
</select>'
,'51', '0', '0')

open helpdesk.php
find
Code:

        // lets send an email instead
$vboptions['helpdesk_auto_repsonse'] = 2;
}
}

add below it
Code:

if ($vboptions['helpdesk_pm_notify'] == 1)
{                // send PM to department group
        if ($bbuserinfo['permissions']['pmquota'] != 0)
{
$toemail = $bbuserinfo['email'];
                eval(fetch_email_phrases('helpdesk_auto_pm', iif(isset($newpost_lang["$toemail"]),                $newpost_lang["$toemail"], 0)));
        sendprivatemessage_group($vboptions['helpdesk_department_access'], $message, $subject);
}
}

find
Code:

$DB_site->shutdown_query("UPDATE ".TABLE_PREFIX."user SET pmtotal = pmtotal + 1, pmunread = pmunread + 1, pmpopup = " . $userinfo['pmpopup'] . " WHERE userid = '" . $userinfo['userid'] . "'");
}

add below it
Code:

function sendprivatemessage_group ($group_ids, $message, $subject)
{
global $DB_site;
$groups_ids = split(',', $group_ids);
foreach($groups_ids as $group_id)
        {
        $users_ret= $DB_site->query("SELECT username,userid,pmpopup FROM " . TABLE_PREFIX . "user where usergroupid='$group_id'");
while($users_arr=mysql_fetch_array($users_ret))
        sendprivatemessage ($users_arr, $message, $subject); //send pm to each user in the give group_id
        }
}

find
Code:

function sendprivatemessage_group ($group_ids, $message, $subject)
{
global $DB_site;
$groups_ids = split(',', $group_ids);
foreach($groups_ids as $group_id)
        {
        $users_ret= $DB_site->query("SELECT username,userid,pmpopup FROM " . TABLE_PREFIX . "user where usergroupid='$group_id'");
while($users_arr=mysql_fetch_array($users_ret))
        sendprivatemessage ($users_arr, $message, $subject); //send pm to each user in the give group_id
        }
}

add below it
Code:

        $bbuserinfo[m_subj]=addslashes(htmlspecialchars_uni($_REQUEST['title']));
        $bbuserinfo[messa]=addslashes($message);
        $bbuserinfo[tick_id]=$ticketid;

also create attached phrases .

enjoy

WhSox21 03-15-2005 06:34 PM

Live Demo has been updated.

red_baron2000 - I'll install this and see how she works. If it works good and if there is no way for me to optimize the code (which there might be) I'll release an update tomorrow.

Bloodlust 03-15-2005 09:17 PM

Wow that looks really good. Great work. Could be useful for me in the future.

HC. 03-16-2005 11:55 PM

ok,
coming in late on this hack
could some one tell me which one to install and what to edit
step by step please
thanks
hc

WhSox21 03-16-2005 11:58 PM

Obviously you're goign to want to download the latest version. I'll remove the old one. I left it up there for people before. Like stated in the first post there are no file edits! The installation can be found in the zip file.

mfowler70 03-17-2005 02:14 PM

I need to upgrade, but want to wait until the moderator notification from the last page is incorporated into the mod. Any idea when (if) that will be ready? Also, are there any other additions planned for the next rollout?

Awesome, awesome work.

TopeeGuy 03-17-2005 05:37 PM

Is it possible for the person who submitted the original ticket to receive an email when his or ticket receives a reply from a mod/admin?

Reef 03-22-2005 12:59 PM

Very nice addon WhSox21 but, I have a permissions problem I can't get sorted out... All members can see the Administer Block and view tickets other than their own.. Also Tickets that I have claimed ownership of are never listed in "My Tickets"

example:
My Registered Users Group permissions are set to only;

Can Create Tickets = Yes
Can Resolve Tickets = Yes
All others = No

Registered users can still view every ticket... Any Ideas??

Blackbeard 03-22-2005 04:09 PM

Quote:

Originally Posted by Blackbeard
Is it possible to set it so registered users can reply to anyones helpdesk post but dont have access to the settings section.

In the add depatments area i have put there usergroup in , they can post but not reply to other members post, just we have alot of helpful members and we want to use this as a general helpdesk aswell as a bug reporting center.


Quote:

Originally Posted by WhSox21
It would take a little bit of editing of the actual code to accomplish this. If you really wanted to do that you could modify the helpdesk.php file and remove the part of the queries where it checks for the userid. Depending on how tomorrow goes I'll see if I can help you out and post a file for you to use. I'll try to release this as a release too.

I really need to start a list of feature requests. I'll try to get something organized here shortly. This week is pretty hectic for me so once I do get something I'll let everyone know.
Quote:

Originally Posted by Blackbeard
I know you not had much sleep but have you had any time to look into this m8 - Sorry for pushing my luck, but its such a great idea and hack want to use it to its full potential on my forum.
Quote:

Originally Posted by WhSox21
I'll be able to help after tomorrow...

On another note... We made HotM for March!

I'd really appreciate the votes! That is if you absolutely love this hack!

Vote Here!
Have you had any luck on this topic m8, sorry to keep asking, bet u wish i would go away.

cheers for all the hard work

WhSox21 03-23-2005 04:26 AM

Quote:

Originally Posted by Reef
Very nice addon WhSox21 but, I have a permissions problem I can't get sorted out... All members can see the Administer Block and view tickets other than their own.. Also Tickets that I have claimed ownership of are never listed in "My Tickets"

example:
My Registered Users Group permissions are set to only;

Can Create Tickets = Yes
Can Resolve Tickets = Yes
All others = No

Registered users can still view every ticket... Any Ideas??

Are you using the latest version?

In your AdminCP then to vBulletin Options then HelpDesk...
Usergroups With Department Access - make sure this list (seperated by commas) only gives the usergroups you want to have access to those areas.


All times are GMT. The time now is 04:07 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01587 seconds
  • Memory Usage 1,867KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (8)bbcode_code_printable
  • (24)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete