############################################################## 
##
## MOD Title:		  Helpdesk Mod
##
## MOD Author:		  aUsTiN => austin_inc@hotmail.com
##
## MOD Description:       This adds an ACP configured Helpdesk mod to your phpbb.
##			  From the ACP you add emails & their shortcuts so members
##			  can select where they want to send the mail to. It offers
##			  a drop down with the emails, a drop down with the Importance,
##			  a drop down with a contact, Email - YIM - MSNM - None - Etc..
##
## MOD Version:           1.0.1
##
## MOD Help:		  http://austin-inc.com/Blend/
## 
## Installation Level:    Simple
##
## Installation Time:     2 Minutes
##
## Files To Edit:         2
##
## Included Files:        4
##
############################################################## 
############################################################## 
##
## Author Notes: 
##
##	Copyright © aUsTiN-Inc, 2003/4
##
##	ALL FILES WERE DOWNLOADED DIRECTLY FROM MY SITE TO BUILD THIS INSTALL.
##
##	Tested versions:
##
##	phpBB:
##
##		2.0.4 - 2.0.8
##
##	phpMyAdmin Versions:
##
##		2.5.6-rc1
##
##	MySql Versions:
##
##		4.0.18-standard
##
##	PHP Versions:
##
##		4.3.3 - 4.3.4
##
##	Feel free to see it in action at http://austin-inc.com/pm/helpdesk.php
##
############################################################## 
##
## MOD History: 
## 
##	June 21st 2004 - Version 1.0.0
##      	- Beta Released
## 
##	June 27th 2004 - Version 1.0.1
##      	- Released
##
############################################################## 
##
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
##
##############################################################
##
##	Definitions:
##
##		Root: Folder your config.php is located
##		/*/: Your default
##
##############################################################

#-----------------------------------#
#----[ DROP FILES ]-----------------#
#-----------------------------------#

root/helpdesk.php
language/*/lang_helpdesk.php
admin/admin_helpdesk.php
templates/*/helpdesk_body.tpl

#-----------------------------------#
#----[ SQL CHANGES ]----------------#
#-----------------------------------#

#
# Table structure for table `phpbb_helpdesk_emails`
#

CREATE TABLE `phpbb_helpdesk_emails` (
  `e_id` int(10) default '0',
  `e_addr` varchar(255) default NULL
) TYPE=MyISAM;

#
# Dumping data for table `phpbb_helpdesk_emails`
#

INSERT INTO `phpbb_helpdesk_emails` VALUES (3, 'owner@your-site.com');
INSERT INTO `phpbb_helpdesk_emails` VALUES (2, 'forums@your-site.com');

# --------------------------------------------------------

#
# Table structure for table `phpbb_helpdesk_importance`
#

CREATE TABLE `phpbb_helpdesk_importance` (
  `value` int(10) default '0',
  `data` text
) TYPE=MyISAM;

#
# Dumping data for table `phpbb_helpdesk_importance`
#

INSERT INTO `phpbb_helpdesk_importance` VALUES (5, 'Urgent');
INSERT INTO `phpbb_helpdesk_importance` VALUES (4, '');
INSERT INTO `phpbb_helpdesk_importance` VALUES (3, '');
INSERT INTO `phpbb_helpdesk_importance` VALUES (2, '');
INSERT INTO `phpbb_helpdesk_importance` VALUES (1, 'Not Important');

# --------------------------------------------------------

#
# Table structure for table `phpbb_helpdesk_msgs`
#

CREATE TABLE `phpbb_helpdesk_msgs` (
  `e_id` int(10) default '0',
  `e_msg` varchar(255) default NULL
) TYPE=MyISAM;

#
# Dumping data for table `phpbb_helpdesk_msgs`
#

INSERT INTO `phpbb_helpdesk_msgs` VALUES (2, 'Forum Issues');
INSERT INTO `phpbb_helpdesk_msgs` VALUES (3, 'Email The Board Owner');

# --------------------------------------------------------

#
# Table structure for table `phpbb_helpdesk_reply`
#

CREATE TABLE `phpbb_helpdesk_reply` (
  `value` int(10) default '0',
  `data` text
) TYPE=MyISAM;

#
# Dumping data for table `phpbb_helpdesk_reply`
#

INSERT INTO `phpbb_helpdesk_reply` VALUES (1, 'None');
INSERT INTO `phpbb_helpdesk_reply` VALUES (2, 'Email Me');
INSERT INTO `phpbb_helpdesk_reply` VALUES (3, 'Prv Msg');
INSERT INTO `phpbb_helpdesk_reply` VALUES (4, 'YIM');
INSERT INTO `phpbb_helpdesk_reply` VALUES (5, 'MSNM');
INSERT INTO `phpbb_helpdesk_reply` VALUES (6, 'AIM');
INSERT INTO `phpbb_helpdesk_reply` VALUES (7, 'ICQ');
    

#-----------------------------------#
#----[ FILE CHANGES ]---------------#
#-----------------------------------#

-----------------------------------
----[ OPEN ]-----------------------
-----------------------------------

includes/constants.php

-----------------------------------
----[ FIND ]-----------------------
-----------------------------------

?>

-----------------------------------
----[ ADD, BEFORE ]----------------
-----------------------------------

/* Start Helpdesk By aUsTiN */
define('HELPDESK_E', $table_prefix.'helpdesk_emails');
define('HELPDESK_I', $table_prefix.'helpdesk_importance');
define('HELPDESK_M', $table_prefix.'helpdesk_msgs');
define('HELPDESK_R', $table_prefix.'helpdesk_reply');
/* End Helpdesk By aUsTiN */

-----------------------------------
----[ CLOSE & SAVE ]---------------
-----------------------------------

-----------------------------------
----[ OPEN ]-----------------------
-----------------------------------

templates/*/overall_header.tpl

-----------------------------------
----[ FIND SIMILAR ]---------------
-----------------------------------

<a href="{U_FAQ}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_faq.gif" width="12" height="13" border="0" alt="{L_FAQ}" hspace="3" />{L_FAQ}</a>

-----------------------------------
----[ ADD, AFTER ]-----------------
-----------------------------------

    <a href="helpdesk.php" class="mainmenu"><img src="templates/subSilver/images/icon_mini_faq.gif" width="12" height="13" border="0" alt="Visit Our Helpdesk" hspace="3" />Site Helpdesk</a>

-----------------------------------
----[ CLOSE & SAVE ]---------------
-----------------------------------

EoM