Would it be possible for you to upgrade MySQL? If not I could probably get you a script that would work by tomorrow.

Unfortunatly I go through a hosting company so I would not be able to upgrade that.

That's alright, I really don't think that's the problem anyways. I'll look into it a bit more.

great - hack look great and Im looking forward to using it.

That's a good question. I'll find out and then update this post.

That wasn't directed at you. The post after it was! :lick:

Ooops. Thanks for responding. It's been a long day and my eyes are a little fuzzy. I can't wait to upgrade. This hack rocks! :smoke:

I already put in a ticket at my webhost to find out what version of mySQL I am running. Probably better that I know anyway.

See attachment. Instead of entering 1,3,8 for the usergroups when adding departments, for instance, maybe change it to be like the attached screenshot...

That would require file edits and I'm trying to stay away from those. :nervous:

Actually, this would be in HELPDESK.PHP is what I was thinking. I might take a wild stab at it to see if it is possible.

Great mod!

Actually that is possible, but don't expect it in this hack soon. By the way the only ones you should add to the admincp are the ones that have access to editing the department and usergroup settings. With the usergroup settings it uses the user's primary usergroup and not the ones they are members of.

already updated great job

Nice hack :D

JUst to inquiry.. i installed it and work fine.

1. User open a ticket.
2. Admin reply to the ticket.
3. However when a user try to reply back the ticket it gives me non-permission error:

I re-check the usergroup setting, it was fine. Any idea why WhSox21?

Are you saying you created the ticket fine. Then you used another user (an admin) and posted a reply? Then the regular user who originally posted the ticket got the error that said non-permission?

Yes, thats right. Ive tried several times and the results are the same though.

Nevermind my last post, I checked out the code and it's a bug. I have fixed the code and upgraded the hack this also includes a few other small fixes. This is a MUST do upgrade. All you have to do is overwrite the helpdesk.php file.

ok well i did before i read, so i like reinstalled/re-upgraded, but the db error hasnt effected... so i should be ok

Hi WhSox21 .. :)

I've now updated to 1.51 .. upgrade went smoothly ..

A few comments/suggestions/bugs ..

When looking at the list of tickets .. in the "When Logged" column could you put the date/time instead of just "Today" ..

When looking at the list of tickets .. can you show who has claimed ownership .. or not as the case might be ..

When looking at a ticket .. can you add the date/time to each post .. instead of "Today by .."

One thing I've found .. once a user creates a ticket, it seems they can't add another post? Can you change that? [Fixed in 1.52]

Whenever a user name is shown can you make it a link to the users profile page ..

Within the department page .. I take it the user groups option is for telling the system who can admin that department .. can you add another option for the user groups who can pick that department when creating a ticket ..

Again, within the department page .. can you make the usergroup option a list of tick boxes instead of putting numbers .. this would certainly aid the usability of the page ..

On the "Usergroup Settings" page .. there seems to be a bug where the Usergroup Settings table is pushed down the page .. see image to see what I mean ..

https://vborg.vbsupport.ru/external/2005/03/2.jpg

Slave - I'll take into consideration everything you said. The dates shouldn't be a problem as they are using vbulletin's date function. Usernames linked, again not a problem.

As for the departments, I think I'll be fixing this so it's a little bit easier to use. This won't happen until half way through this week. I'm going to be busy on other customer's projects. I'll be fixing bugs and small minor changes I'll be updating.

Cheers WhSox21 .. :)

BTW .. is the system meant to send emails/pm to admin to let them know a new ticket is there? .. I don't seem to be getting them if it is ..?

Seems I've found a bug ..

When you try to delete a ticket it comes up with a mysql error ..

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO domain_com_-_forums.ticketdeleted SELECT * FROM domain_com_-_forums.ticket WHERE ticketid = 3
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 '-_forums.ticketdeleted SELECT * FROM domain_com_-_forums.

mysql error number: 1064

Date: Sunday 06th of March 2005 06:42:38 AM
Script: http://www.domain.com/helpdesk.php?do=delete&tid=3
Referer: http://www.domain.com/helpdesk.php?do=ticket&tid=3
Username: Slave

Can you upload 1.5 igen is invalid link so I cant download the nev version please

I get this error when I try to go to helpdesk

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 postuserid = 1
mysql error: You have an error in your SQL syntax near 'ON (ticketdepartment.departmentid = ticket.departmentid) WHERE open = 1 AND post' at line 1

mysql error number: 1064

where shuld I change this ??
2. Add a department. (www.yoursite.com/helpdesk.php?do=departments)
I cant find this

Thanks WhSox21.. but seems the bugs is still there. I've rewrite the helpdesk.php file (1.52)

Shuld whe download the zip file nowe if you have put up the nw file there ??

BTW, to help with some speed, there are quite a few new templates that should be cached! To help out with query and server load, do this:

open helpdesk.php and find:
Add below:

I am receiving the following database error.

vBulletin v3.07

This is a clean install of version 1.52 I did set the departments. For testing purposes, I have only granted access to admins, moderators, and supermoderators (ID's 5,6,7)

Same database error as everyone else

funny everything works fine 4 me.... :surprised:

Hi again.
A bug here: Now, after installing the hack, every time i recheave a PM i get the popup. Even though i have set PM Popup to off. (3.0.7)

Challenge.

Hmm... Dosent do it anymore...Wierd :S

I have the query in the database to do the pop-up. I'll fix that so it is based on people's prefrences. Now I'm going to go through and try to fix these bugs everyone is having. It seems that the lower versions of MySQL is having the problems. I'll attach a file to a post below and anyone who wants to help out can.

Anyone having trouble with the database errors (not the delete error, that's next) try just uploading this helpdesk.php file and let me know if it works.

Try this file to fix your delete problem. I tested it and it worked for me so let me know if it works for you.

Not it's not supposed to yet. Only an auto-reply when you create tickets.

where do they go to get that error ? i wanna see if i got the problem to...

Just about any administer link will give you the error. I believe it's a problem with the syntax I used, it doesn't support the older versions of MySQL. I've changed it to do exactly how vBulletin does so it should work.

This will be fixed in the next version once I sort out all the other bugs.

Why do you want the older version? There is a newer version out download that as it fixes bugs.

I got the same database error with a CLEAN installation of 1.52 while running helpdesk.php.
my vb version is 3.06

MySQL 3.23.58