PDA

View Full Version : vBHelp Desk


zajako
03 Feb 2003, 08:23
This si a help desk program created to be integrated with your vbulletin. It allows people to make tickets, and tickets create new threads that are specialy decorated with a status box, that contains the status of the ticket. There are admin features to allow custimization of the words used for open, Resolved, and even the catagories and priorities too. you can close tickets from the post for it as well as reopen them, also you can do it from the admin panel as well.


NOTES:
When doing permissions remove the permission that says "Can Search" from non staff usergroups for the helpdesk forum.


Screenshots:
the help desk home page:
http://www.vbulletin.org/forum/attachment.php?s=&postid=349891

The new ticket page:
http://www.vbulletin.org/forum/attachment.php?s=&postid=349894

Thread with admin options in status bar:
http://www.vbulletin.org/forum/attachment.php?s=&postid=349897


the Zip

vbhelpdesk v1.2 (http://www.vbulletin.org/forum/attachment.php?s=&postid=358226)

mehungie2
03 Feb 2003, 08:25
sounds cool, i will install it after i see the screen shots. nice job

zajako
03 Feb 2003, 08:31
the main help desk page

zajako
03 Feb 2003, 08:34
the new ticket page

kmfdm_kid2000
03 Feb 2003, 08:35
This I want, and will be installing. Thanks Zaj ;)

zajako
03 Feb 2003, 08:37
here is the thread created by it.
it includes the status bar, and the options to the right side of it are the admin options, if non admin it just has the link to the help desk home page.

Sanni
03 Feb 2003, 08:50
is there any way we can see a working demo of this please? :)

and also is it possible for it to generate an email with the ticket contents and status?

zajako
03 Feb 2003, 08:54
i could make it generate an email, possibly for a future release.

for a working demo goto http://tfogame.com/helpdesk.php

for oyu to be able to see your ticket you must register before submitting a ticket.

Sanni
03 Feb 2003, 09:04
looks cool zajako :)

i've downloaded the zip and will probably install the hack later on this evening. I'll let you know how it goes :)

Slynderdale
03 Feb 2003, 09:05
hmm, i dont know if this is a bug or not, but when you search for posts by the user, the ticket posts get listed as well.

zajako
03 Feb 2003, 09:08
only for admins. It uses the vbulletin's default permissions. So it should only allow those permitted to view it.

Slynderdale
03 Feb 2003, 09:14
Hmm, I can see the post but not access it when i searched for posts by you on your forum, I'll post an attachment.

zajako
03 Feb 2003, 09:27
i found the problem for that. i had the ability to search on, for the permissions.

Be sure to remove that ability and i will note that in the first thread.

Graphics
03 Feb 2003, 10:06
nice hack *installs*

Floris
03 Feb 2003, 10:16
Looks promising!! :)

wooolF[RM]
03 Feb 2003, 10:23
the idea is great! SourceForge + CVS forever! O.o ;)

zajako
03 Feb 2003, 14:28
found a few bugs in the install file.

one of which prevents setting the forum id for the forum and the other was just letting you know how to make the templates

these are fixed

Dean C
03 Feb 2003, 15:37
Wow i've been waiting for a hack like this for SO long :p

Thanks buddy.

However are all your templates free of font tags because i see that horrible times new roman tag ;)?

Regards

- miSt

JulianD
03 Feb 2003, 15:59
Thanks for this hack. It looks like a good idea!

LOD-squa
03 Feb 2003, 21:18
I am havingf a problem or this is me on the open tickets I see nothing >.> when I opened one. Same with the acp and closed tickets.


Edit: Never mind fixed. But on the acp I cant see the tickets all I get is a white page.

bspiller82
04 Feb 2003, 03:47
Do only admins see this or does everyone see the tickets? The idea of ticket systems is to only alow certin people see it and not the entire public..

mcyates
04 Feb 2003, 09:59
I am having this problem also.


Originally posted by gohanssj2
I am havingf a problem or this is me on the open tickets I see nothing >.> when I opened one. Same with the acp and closed tickets.


Edit: Never mind fixed. But on the acp I cant see the tickets all I get is a white page.

zajako
04 Feb 2003, 19:49
bspiller only the person who created the ticket and the staff can see the tickets.

gohanssj and mcyates, im not sure what the problems is, could you post a screen shot for me?

Vile
05 Feb 2003, 05:17
This is a neat idea.
I'll test this out, thanks! :)

mcyates
05 Feb 2003, 07:30
The problem also is. This:

http://www.myfootballforum.com/discussion/showthread.php?s=&threadid=2855

That link above is to one of the posts made via:
http://www.myfootballforum.com/discussion/helpdesk.php

But when i got to http://www.myfootballforum.com/discussion/helpdesk.php its not in the open list? Only test ones which I put in, can be seen. Also the open list and the closed list in the admin cp just show a blank grey screen.

mcyates
05 Feb 2003, 07:34
Will this SQL have anything to do with it:

INSERT INTO setting VALUES (NULL,86,'Help Desk Forum','helpforum','72','The forum id for your help desk.','','1')

My help forum (support forum is) ID is 87 should I insert the support forum's id (87) into the sctring above?

mcyates
05 Feb 2003, 07:46
Open List | Closed List Don't Work

When i post a new ticket it goes into the open list on the site. But when someone else posts a new ticked it doesn't show.

mcyates
05 Feb 2003, 07:53
PLEASE NOTE, you will not be able to view these files as you will need the admins username and password

This shows the open tickes
http://www.myfootballforum.com/discussion/admin/adminhelpdesk.php?action=ticket&action2=open&s=

But this one in the admin panel does not:

http://www.myfootballforum.com/discussion/admin/adminhelpdesk.php?action=ticket&action2=open&s=


The difference is the last part of the string/url

ticket&action2=open&s=

tickes&action2=open&s= (this one is being used in admin panel

How can I change the string

mcyates
05 Feb 2003, 07:56
I'ver change the string in the admin panel. Just changed the tickets&action........ to ticket&action

And it now works. But the new tickes from the other members do not show on the helpdesk.php????? It says There are no current Tickets in this grouping. But there are open ticked shown in the admin panel.

mcyates
05 Feb 2003, 08:06
ALSO (sorry about this)

In your adminhelpdesk.php

Find this:
<td><div align=\"center\"><a href=\"../showtthread.php?s=&threadid=$lists[threadid]\"

This should be:

<td><div align=\"center\"><a href=\"../showthread.php?s=&threadid=$lists[threadid]\"

(I just changed showtthread.php to showthread.php)

And Also in adminhelpdesk.php Further down:

<td><div align=\"center\"><a href=\"../showtthread.php?s=threadid=$lists[threadid]\"

Change showtthread.php to showthread.php (Only 1 t)

kalin_AR
05 Feb 2003, 12:08
Hi

This hack looks good but I have a question.

I want to set up a user group for each of my customers. Each user group has its own set of private forums.

I would like each user group to be able to creat a ticket only in their forums and not in a public area or someone elses forum.

This was each customer can only see the tisckets relating to them.

Another question.

I would like to be able to allocate one OR more support people to each ticket to make them responsible for the life of that ticket.

And then of course to be able to view by support person the tickets assigned to them and their status.

And then to report by tickets by customer and support person by status too.

Of course it may be easier to pull a report from the database but howfar will your hack go?

Do you want to take it as far as I've listed and how much do I need to pay you to get it this far?


Sorry but I dont have time to beat about the bush here.


Thanks

Kalin

alkatraz
06 Feb 2003, 02:38
Great!!!

rrnolan
06 Feb 2003, 13:51
In the instructions it says to:

goto the option page and find the help desk settings section
now type the number we called x earlier in this box and hit submit.


I dont see any place to set this? I looked in Vbulliten Options and I looked on the left menu I dont see any help desk setting section. Can someone help me with this. I running version 1.1

rrnolan
06 Feb 2003, 14:19
for some reason the last two lines of the sql query were wrong

wajones
06 Feb 2003, 15:46
zajako

Thanks for the hack, I haven't tryed it yet but it may be just what I need with a few little enhancements to manage some of my headaches at vbportal.com, I'll let you know how it goes.

N9ne
06 Feb 2003, 19:40
Have the hardcoded font tags been fixed? Are there hardcoded colours in this hack? Have you made full use of vBs replacement feature?

GoTTi
07 Feb 2003, 01:52
found a error in the instructions:


admin/index.php

Find:
makenavselect("Options","<hr>");

Add Below:
makenavoption("Open List","adminhelpdesk.php?action=tickets&action2=open","|");
makenavoption("Closed List","adminhelpdesk.php?action=tickets&action2=closed");
makenavselect("Help Desk Tickets'");
makenavoption("Add","adminhelpdesk.php?action=cat&action2=add","|");
makenavoption("Modify","adminhelpdesk.php?action=cat&action2=list");
makenavselect("Help Desk Catagories");
makenavoption("Add","adminhelpdesk.php?action=status&action2=add","|");
makenavoption("Modify","adminhelpdesk.php?action=status&action2=list");
makenavselect("Help Desk Status'");
makenavoption("Add","adminhelpdesk.php?action=priority&action2=add","|");
makenavoption("Modify","adminhelpdesk.php?action=priority&action2=list");
makenavselect("Help Desk Priorities'");


first 2 lines should be:

makenavoption("Open List","adminhelpdesk.php?action=ticket&action2=open","|");
makenavoption("Closed List","adminhelpdesk.php?action=ticket&action2=closed");

not

makenavoption("Open List","adminhelpdesk.php?action=tickets&action2=open","|");
makenavoption("Closed List","adminhelpdesk.php?action=tickets&action2=closed");

ticket(S) is causing a wrong read error. S needs to be removed.

GoTTi
07 Feb 2003, 02:00
also, in the helpdesk template:


<a href="helpdesk.php">HelpDesk Main</a> | <a href="newticket.php">New Ticket</a> | <a href="http://www.tfogame.com/main/member.php?&action=logout">Log Out</a>


http://www.tfogame.com/main/ needs to be erased for users to logout from that page.

lalo landa
12 Feb 2003, 05:58
ALSO In your adminhelpdesk.php

change
<td><div align=\"center\"><a href=\"../members.php?action=

to
<td><div align=\"center\"><a href=\"../member.php?action=

vortech
12 Feb 2003, 16:45
Is there any way to do email to ticket in this hack. If so it would be a GREAT system then.

rrnolan
12 Feb 2003, 18:24
I have 4 moderators and 4 admins

Whenever anyone posts a ticket the only ticket that can be seen is the ones you yourself post. I can not see tickets that any of my other admins are posting and they can not see mine. Is this working right? Is there a way for us all to see eachothers tickets?

lalo landa
15 Feb 2003, 16:47
Originally posted by vortech
Is there any way to do email to ticket in this hack. If so it would be a GREAT system then.

That will be grate....
When i close the ticket the system send to the ticket author a new pm (advice).

Can anyone do that?

Zachery
15 Feb 2003, 22:31
zajako is unable to post here, however you can get ahold of him on aim: Zajako2

rrnolan
15 Feb 2003, 22:50
Originally posted by rrnolan
I have 4 moderators and 4 admins

Whenever anyone posts a ticket the only ticket that can be seen is the ones you yourself post. I can not see tickets that any of my other admins are posting and they can not see mine. Is this working right? Is there a way for us all to see eachothers tickets?

Anyone know the answer to this?

Xyphen
16 Feb 2003, 02:03
Originally posted by kalin_AR
Hi

This hack looks good but I have a question.

I want to set up a user group for each of my customers. Each user group has its own set of private forums.

I would like each user group to be able to creat a ticket only in their forums and not in a public area or someone elses forum.

This was each customer can only see the tisckets relating to them.

Another question.

I would like to be able to allocate one OR more support people to each ticket to make them responsible for the life of that ticket.

And then of course to be able to view by support person the tickets assigned to them and their status.

And then to report by tickets by customer and support person by status too.

Of course it may be easier to pull a report from the database but howfar will your hack go?

Do you want to take it as far as I've listed and how much do I need to pay you to get it this far?


Sorry but I dont have time to beat about the bush here.


Thanks

Kalin

I want something like this for my customers, so only the customers can see the ticket forum and create tickets. Another usergroup needs to be created such as Customer or Premium Member and then only them are allowed to see the tickets, post, edit them.

Another question:
How can I make it so, there is a list of all tickets, created by whomever, and it displays their information. and when a ticket is resolved, we pick resolved from the drop down menu, and when the tickets list is displayed, it shows [resolved] beside the title or [fixed] or something like that. This should be seeable by all customers or premium members.

Is it possible to do this??

A VERY GREAT HACK, VERY USEABLE FOR PEOPLE WHO OWN A HOSTING COMPANY AND A FORUM!!

Xyphen
16 Feb 2003, 02:07
I own a hosting company, i was wondering if you can make it so, that when a customer posts a ticket, they are asked to enter their site URL, such as sub.domain.com or www.domain.com
so its much easier for us to look into the ticket..

pattox
16 Feb 2003, 03:41
Its decent, Ive made a better one for 2.1x

Xyphen
16 Feb 2003, 13:53
Also, is this compatible with 2.3.0?

Xyphen
16 Feb 2003, 14:25
I get this error when I try to make a Ticket..

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT DISTINCT user.email FROM moderator,user WHERE moderator.userid=user.userid AND forumid IN () AND (newthreademail=1 OR newpostemail=1)
mysql error: You have an error in your SQL syntax near ') AND (newthreademail=1 OR newpostemail=1)' at line 1

mysql error number: 1064

Date: Sunday 16th of February 2003 07:16:27 PM
Script: http://www.solo-tech.net/forums/forums/newticket.php?action=donewticket
Referer: http://www.solo-tech.net/forums/newticket.php

C.Birch
16 Feb 2003, 15:07
Originally posted by AViO 07
Also, is this compatible with 2.3.0?

I have it running on 2.3.0 had no probs at all so nice hack beats trying to install pdesk again that you NOW have to buy.

Xyphen
16 Feb 2003, 15:25
Can you give me uninstall intructions, I am getting all kinds of weird errors..

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 49 bytes) in /home/virtual/site1/fst/var/www/html/forums/admin/functions.php on line 442

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 11 bytes) in Unknown on line 0

C.Birch
16 Feb 2003, 16:46
just do the install ones backwards.

Xyphen
16 Feb 2003, 17:28
nvm, i uninstalled it..

rrnolan
17 Feb 2003, 19:54
Originally posted by rrnolan
I have 4 moderators and 4 admins

Whenever anyone posts a ticket the only ticket that can be seen is the ones you yourself post. I can not see tickets that any of my other admins are posting and they can not see mine. Is this working right? Is there a way for us all to see eachothers tickets?

bump... can anyone help with this?

Eric1776
20 Feb 2003, 15:22
Even if I have the usergroup 'Unregistered' set so they shouldn't even be able to view the helpdesk, they can still access the main helpdesk page and even post a ticket. Is there a way to limit who can view the helpdesk and post a ticket to only certain groups?

zajako
25 Feb 2003, 13:38
rrnlolan give admins the ability to see them. in the instructions it says stet the permissions for all non admins.

AVIO 07 those errors are related to something else you did, cause i saw no signs of my hack in the sql error.

C.Birch glad you like it ^^\

eric1776, the unreged users should be able to post tickets, just should not be able to view them. if you have it set so that they can't view it permissions wise then they can only make new tickets. this is so people that are blocked outta the site cna let someone know. if you don't whant them to be able to in the begginging of the helpdesk.php and newticket.php add

if ($bbuserinfo[userid]==0){
shownopermissions();
)


also here is a file correcting all the previously mentioned errors, sorry bout those.

r1d4
14 Mar 2003, 01:54
is there billing available?

r1d4
14 Mar 2003, 01:55
sorry

GoTTi
25 Mar 2003, 01:36
.....

GoTTi
25 Mar 2003, 01:57
and in helpdesk and helpdesk_newticket templates, you might wanna remove the Always Web Hosting Header that is in there.

GoTTi
25 Mar 2003, 02:20
ALSO:

how do i make it where only registered users can create a ticket?

bandersen
27 Mar 2003, 19:14
Thank you Zajako!

bandersen
27 Mar 2003, 21:21
I do not get any tickets up (solved or open) on Main help desk (helpdesk.php), but do see them on the forumdisplay.php
(I am Admin.... and has yes on everything on permissions)

EDIT: I restarted the computer and everything worked ok!

Prankster
28 Mar 2003, 15:28
Yesterday at 10:21 PM bandersen said this in Post #63 (http://www.vbulletin.org/forum/showthread.php?postid=374214#post374214)
I do not get any tickets up (solved or open) on Main help desk (helpdesk.php), but do see them on the forumdisplay.php
(I am Admin.... and has yes on everything on permissions)

EDIT: I restarted the computer and everything worked ok!

i have the same Problem.
after restart its the same.

what can i do ?

bandersen
01 Apr 2003, 19:55
I have set unreg users permission to NO for "view forum" and "view others thread". Still I am able to see other unreg. users threads....and I am able to read them as soon as I log in as "anyone".
I have set permissions to NO for "post new thread"... and I am still able to post. I have restarted the computer without any changes.

Anyone else get this?

Kmaster
02 Apr 2003, 16:12
created time not same as original post time, any way to fix it? thx

Mathiau
03 Apr 2003, 08:33
kew hack - have to try this out.!

Asso
17 Apr 2003, 11:19
it's buggy but the idea is great

bandersen
17 Apr 2003, 12:35
If I enter that code (ending it with } though) I get this:

Fatal error: Call to undefined function: shownopermissions() in forums/helpdesk.php on line 12

Anyone know how to fix it? thank you!

[QUOTE]02-25-03 at 03:38 PM zajako said this in Post #56 (http://www.vbulletin.org/forum/showthread.php?postid=358226#post358226)


eric1776, the unreged users should be able to post tickets, just should not be able to view them. if you have it set so that they can't view it permissions wise then they can only make new tickets. this is so people that are blocked outta the site cna let someone know. if you don't whant them to be able to in the begginging of the helpdesk.php and newticket.php add

if ($bbuserinfo[userid]==0){
shownopermissions();
)

phill2003
18 Apr 2003, 14:30
AVIO 07 those errors are related to something else you did, cause i saw no signs of my hack in the sql error.





m8 i get the same sql error as avio and the error is in a query in the newticket.php if its something i've done i dont know what all i've got on is the vbhome light hack :(

bandersen
05 May 2003, 18:38
I wish the email feature was there - can someone code it please please?

Xyphen
09 May 2003, 01:43
I'm going to code my own helpdesk or integrate one into vBulletin.

Zachery
18 May 2003, 07:23
you might try gettin ahold of zajako on aim at zajako2 ill point this thread out to him asap :D

Asso
01 Jul 2003, 14:53
05-09-03 at 02:43 AM AViO 07 said this in Post #72 (http://www.vbulletin.org/forum/showthread.php?postid=393120#post393120)
I'm going to code my own helpdesk or integrate one into vBulletin.

ok but quick! :D

;)

chad
15 Jul 2003, 08:11
thanks very much
/me hits install

Cal Poly Forum
26 Aug 2003, 08:29
Compatible with version 2.3.2?

Wolverine
06 Sep 2003, 02:06
Hello.
Nice hack (my first complex install).

I seem to be all done except for setting my forum ID. I can find where I am supposed to make the setting (vboptions), and the description is there but where I should be able to specify the forum ID there is only '' and no ablilty to select or enter a value for the forum. I am running vB 2.3.0

Here is a ss of it. Thanks for any help you can offer.

Andrew111888
15 Sep 2003, 02:27
I want this hack but it says invalid attacment specified.:(

Rein Masamuri
23 Sep 2003, 08:28
Wolverine, I had the same problem
its in the vBulletin Options... make sure that you executed the vBulletin query that adds the option.

Wolverine
23 Sep 2003, 15:17
Thanks for the reply.
I got to messin with this the other day. I started playing around with the last field in the setting table ( INSERT INTO setting VALUES (NULL,86,'Help Desk Forum','helpforum','0','The forum id for your help desk.','','1') )

For some reason it didnt like the lastd field value. I got to looking at what was in similar fields till I found one that worked. Textfield did the trick though I dont like it as I know its not what was intended by the author.

If I was barking up the wrong tree feel free to redirect me :)

Asterik
21 Oct 2003, 21:52
Sorry if this has been said, but how can..........

the category name be removed in the breadcrumb like...

plugspark > categoryname > helpdeskpost

i don't want people clicking the category name because it'll show them every helpdesk post. But i only want this for the helpdesk, not any other categories or posts or n e thing... HELP!

Rein Masamuri
21 Oct 2003, 23:47
If you set up the permissions correctly they won't be able to see any threads they did not make.

Kaelon
24 Feb 2004, 20:51
Works with 2.3.2. Excellent modification!

Kaelon
24 Feb 2004, 20:54
Minor bug. In both newticket.php and helpdesk.php change:

require("./global.php");
if ($bbuserinfo == "0")
{
eval("dooutput(\"".gettemplate('helpdesk_register')."\");");
}


to

require("./global.php");
if ($bbuserinfo[userid] == "0")
{
eval("dooutput(\"".gettemplate('helpdesk_register')."\");");
}

EvilCrow
09 Apr 2004, 18:55
Will this be coded for VB 3 Gold?? :rolleyes:

Kaelon
11 Apr 2004, 13:34
I don't believe so, no. Considering that zajako has worked primarily in vB 2, I don't see why he'd want to port this to vB3.

surfhog
24 Apr 2004, 13:19
I don't believe so, no. Considering that zajako has worked primarily in vB 2, I don't see why he'd want to port this to vB3.
Well if you ask me and you didn't lol
That's a real shame :(

So many brilliant hacks for vb2 that are not being updated to vb3
I guess that if people want them, they will have to go backwards instead of forwards :(

Real Crying Shame!!!!!

TheMusicMan
17 Jun 2004, 09:47
... what would happen if I tried to install this using vB3.0.1 - would it fail?

MissKalunji
14 Jul 2004, 22:00
This si a help desk program created to be integrated with your vbulletin. It allows people to make tickets, and tickets create new threads that are specialy decorated with a status box, that contains the status of the ticket. There are admin features to allow custimization of the words used for open, Resolved, and even the catagories and priorities too. you can close tickets from the post for it as well as reopen them, also you can do it from the admin panel as well.


NOTES:
When doing permissions remove the permission that says "Can Search" from non staff usergroups for the helpdesk forum.


Screenshots:
the help desk home page:
http://www.vbulletin.org/forum/showpost.php?s=&postid=349891

The new ticket page:
http://www.vbulletin.org/forum/showpost.php?s=&postid=349894

Thread with admin options in status bar:
http://www.vbulletin.org/forum/showpost.php?s=&postid=349897


the Zip

vbhelpdesk v1.2 (http://www.vbulletin.org/forum/showpost.php?s=&postid=358226)


GREAT HACK WORKS PERFECTLY :nervous:

TheMusicMan
14 Jul 2004, 22:05
... on which vB version?

MissKalunji
14 Jul 2004, 23:06
... on which vB version?


vb 3.0

Kaelon
27 Aug 2004, 04:23
This hack is only intended for vB2. Trying to install it with vB3 will lead to certain disaster, as you're looking at completely different interfaces.

MissKalunji
04 Sep 2004, 02:26
IS this hack gon be converted for Vb 3???

chet
09 Sep 2004, 21:49
*bump*

freeshares1
05 Nov 2004, 10:39
*bump*

billywiz
21 Nov 2004, 02:37
yep is it going to be converted for vb3 as it looks like a good hack

:)

jugo
30 Nov 2004, 16:07
Any info on the vb3 release??

Zachery
30 Nov 2004, 16:14
Any info on the vb3 release??
Don't think Zaj's has any plans for it

AlienSector
01 Dec 2004, 07:09
Don't think Zaj's has any plans for it
Porting it over probably would not be that hard, just have to find someone to take on the project and ask Zaj's permission to release it here. While the structure of the hack may be a bit different, if you know the vB system well enough, converting the coding over would not be that large of a task I would not think.

MissKalunji
13 Jan 2005, 10:24
please someone take it over 3.0.x pretty please :nervous:

WhSox21
01 Mar 2005, 06:30
I just wanted to let anyone know if they are interested in this for vb 3.x I have released mine here:
http://www.vbulletin.org/forum/showthread.php?t=77155

MissKalunji
01 Mar 2005, 12:45
I just wanted to let anyone know if they are interested in this for vb 3.x I have released mine here:
http://www.vbulletin.org/forum/showthread.php?t=77155

Finally thank you!!!!!!!!!!!!