|
|
| Author |
Message |
blackbeltboy47
Well Known User
Joined: 03 Apr 2006
Posts: 105
Location: USA!
|
 Posted: July 20th 2007, 9:07 pm Post subject: [DEV] Support System |
 |
|
I am developing a support system for phpBB3.
DEMO Still in development
Here are my ideas and progress (Green = DONE Red = NOT DONE)
Features:
Ticket System
-Submit tickets through the support system module in the UCP.
-View tickets that you have submitted.
-All tickets be posted on a page for the support team.
Knowledge Base
-Viewable through the UCP. (only the category page is done at the moment)
-Knowledge base configured through the ACP.
-Add articles to the knowledge base through the ACP.
Support Team
-Set certain users to be support team members through the ACP.
-Display support team members on the team page.
-Support team members can view the number of total open tickets in the header.
-A Support Team Panel where team members can close and work on tickets. Also any tickets that are requested to be put in the knowledge base will be listed here.
Other Features
-Users can view the number of open tickets they have in the header.
-Users can request that their ticket be posted in the knowledge base.
As you can see I have a long way to go, but many of these features are currently in progress.
If this is a good idea let me know, also let me know of any features anyone would like to see that I forgot.
_________________
blackbeltboy47
Last edited by blackbeltboy47 on June 3rd 2008, 11:33 am; edited 9 times in total |
|
| Back to top |
|
 |
Patrick
Admin/Webmaster
Joined: 11 May 2001
Posts: 12407
Location: Harbinger, NC, U.S.A.
|
|
| Back to top |
|
|
blackbeltboy47
Well Known User
Joined: 03 Apr 2006
Posts: 105
Location: USA!
|
| Posted: July 21st 2007, 10:26 am Post subject: |
|
|
| Patrick wrote:
|
|
I think a cool thing to do would be to tie it in a post reporting system
|
I don't really understand this. Could you be more specific?
| Patrick wrote:
|
|
and make it so that the number of unresolved tickets can be seen in the header on a permissions basis.
|
That is a good idea, I will add it to the features list, but I don't understand the part about a permissions basis.
EDIT: I added a link to a demo to the first post
_________________
blackbeltboy47 |
|
| Back to top |
|
|
Patrick
Admin/Webmaster
Joined: 11 May 2001
Posts: 12407
Location: Harbinger, NC, U.S.A.
|
|
| Back to top |
|
|
blackbeltboy47
Well Known User
Joined: 03 Apr 2006
Posts: 105
Location: USA!
|
| Posted: July 22nd 2007, 12:16 pm Post subject: |
|
|
Ok, I think I'm going to take your idea and put a twist on it. I'm thinking of making it kind of like the post report system, but instead of reporting the post, its a button that will send the ticket to a support team member requesting that the topic be put into the knowledge base.
Does that sound like a good idea?
_________________
blackbeltboy47 |
|
| Back to top |
|
|
Patrick
Admin/Webmaster
Joined: 11 May 2001
Posts: 12407
Location: Harbinger, NC, U.S.A.
|
|
| Back to top |
|
|
blackbeltboy47
Well Known User
Joined: 03 Apr 2006
Posts: 105
Location: USA!
|
| Posted: August 1st 2007, 11:57 am Post subject: |
|
|
Ok, now I understand, that's a good idea. Added to the features list.
_________________
blackbeltboy47 |
|
| Back to top |
|
|
~HG~
Dedicated User
Joined: 08 Nov 2003
Posts: 3103
Location: Australia
|
|
| Back to top |
|
|
blackbeltboy47
Well Known User
Joined: 03 Apr 2006
Posts: 105
Location: USA!
|
| Posted: August 2nd 2007, 12:14 pm Post subject: |
|
|
I am trying to display team members on the support team page. I made a new field in the users table called support_team. Any user who has that set to 1 would be on the support team and displayed on the support team page.
I based this code off of other codes from phpBB pages and have no idea if it's even close to being right.
| Code:
|
$sql = 'SELECT *
FROM ' . USERS_TABLE . '
WHERE support_team = "1"';
$result = $db->sql_query($sql);
$members = array();
while ($row = $db->sql_fetchrow($result))
{
$members[$row['support_team']] = '1';
$support_team = $row['username'];
$template->assign_block_vars($which_row, array(
'TEAM_MEMBER' => $support_team)
);
}
$db->sql_freeresult($result);
|
I don't get any errors, but no members show up on the page..
I'm still pretty new to php and mysql, so if anyone could help me out, it would be greatly appreciated.
_________________
blackbeltboy47 |
|
| Back to top |
|
|
blackbeltboy47
Well Known User
Joined: 03 Apr 2006
Posts: 105
Location: USA!
|
| Posted: August 5th 2007, 12:25 pm Post subject: |
|
|
Alright I changed the way I am going to do the support team.
I am now using this code:
| Code:
|
$query = 'SELECT * FROM ' . SUPPORT_TEAM_TABLE . ' ORDER BY user_id';
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
$support_team = '<span class="gensmall">' . $row['username'] . '</span>';
$template->assign_block_vars('supportteam', array(
'TEAM_MEMBER' => $support_team)
);
}
|
I decided to make another table for the support team with fields user_id and username. The 2 users that I put into the table are now displaying on the support team page, but one of them is way off to the side rather than in the table. (view the pic below to see what I mean.)
(URL REMOVED)
Is this a problem with the php? If so, does anyone know how can I make it look right?
EDIT: Solved, the problem was in the html.
_________________
blackbeltboy47
Last edited by blackbeltboy47 on March 2nd 2008, 11:59 pm; edited 1 time in total |
|
| Back to top |
|
|
|
Forums
Home
Register
Profile
Log in to check your private messages
Log in
FAQ
Search
Contact
Us 
