Support Desk

[Maniak]

Okay, since the Forum switch there was some problems with the code. I fixed them to find a 10,000 Character limit, so I have had to upload the files in a Zip folder.

What is in the Folder:

- support.php

- staff_support.php

- SQL's.txt

- Instructions.txt

Support Desk.zip

Edited April 19, 2011 by Maniak
Errors in code from Forum Switch.

[Artemis]

I think someone read my mind with this mod ;)

Nice job and Thank you!!!

[Maniak]

I have got to add the Staff Panel side to this mod.. Shouldn't take me long.

But thank you ;)

[rulerofzu]

You will have an issue when people install this as your asking for an ID on line 61 in support home which will error as the table is empty.

You should on things like this check if its empty first to avoid sql errors.

if($db->num_rows($query)==0){ echo "no tickets"; return; }

[Maniak]

@Zu: Line 61 to 64:

$query = $db->query('SELECT * FROM `support` WHERE (`sUser`='.abs(intval($ir['userid'])).')');

if(!$db->num_rows($query)) {

echo '<tr><td colspan="4" align="center">You currently have no outstanding Support Tickets</td></tr>';

} else {

[rulerofzu]

K the error must be from somewhere then when i tested it :P

didnt really look at the code before i replied

[Maniak]

Hmm, on my XAMPP there is no error :S I'll look over the code now and see if I can see anything that will cause an error.

[Artemis]

I installed and had no issues.. Only thing it seems to be lacking is the ability to 'close' a ticket once replied and dealt with.

But this mod is exactly what I had been wanting.. a simple bug reporting just didnt rock my boat.. but this mod sure does ;)

[Maniak]

@Artemis, I still got to post the staff side to this, I got sidetracked by a film last night. I will post it up as soon as I get home from work :)

[Danny.W]

Well done Maniak, Nice modification... Simular to the support system i use on my upcoming game!, Well done.

[Maniak]

Thank you Danny.W.

[Maniak]

The Staff side has been done! Post any errors here and I will fix them :)

[JohnGato]

Awesome mod..... so far so good

[Maniak]

If anyone could give me a link that'd be great...

[bineye]

Nice mod. I added it, and tweaked the menu bar to show red if a player has an open ticket, and also added a link in staff part to show red if a new ticket has been opened.

With regards to closing a ticket, I think I'll add a section to show closed tickets, because if not, we have to leave the ticket open until they acknowledge they have seen the reply, and if they don't, the ticket could be open for a long time, then they come back a week later saying "i didn't see what you wrote", so I'll probably add in a section for closed ones.

Thanks for all the hard work Maniak, works great.

[Maniak]

In the users side the Ticket will stay there whether it is Open or Closed. It only "disappears" on the Staff side when it is Closed (to save clogging up on the staff side).

I was thinking of adding a Cron OR timestamp for this to delete any Closed tickets that have a last reply time of > 30 days. Would this be useful or not?

By the way, if you have this online, could you give me the Link to the website (so I can post here as an example)?

[bineye]

It's not online just yet, but soon :)

EDIT: ah yes, just saw the ticket is not deleted user side

[Aderik]

Added, I like, very professional looking!

[Maniak]

Thank you, Aderik!

[The Bonded Game]

Added, I love the look of it and the style of it. Plus one for you.

[Curt]

Want to say nice mod.

I added this to Thug Battle with no problems at all.

Nice work :)

cheers,

Curt

[Maniak]

Thank you very much, Curt!

[gideon prewett]

addition to this mod

im thinking somthing like a event add would be good so the member knows when the staff have replyed to there ticket

i may add it myself and post when i have the time but what do u guys think? :thumbsup:

[Curt]

ah gideon prewett yea thats a good idea...lol...i updated mine to do this already :P

[Maniak]

Yeah, I thought I added that, aha.. Adding now :D