############################################################# 
## MOD Title: Admin Ideas
## MOD Author: FuNEnD3R < admin@funender.com > (Thomas Jonas) http://www.funender.com 
## MOD Description: This mod will allow admins to communicate via the admin panel. 
## MOD Version: 1.0.1 
## 
## Installation Level: Easy 
## Installation Time: 3 Minutes 
## Files To Edit: N/A
## 
## Included Files: admin/admin_ideas.php
##                 language/lang_english/lang_admin_ideas.php
##                 templates/subSilver/admin/admin_ideas.tpl
##                 templates/subSilver/admin/admin_ideas_edit.tpl
##
##
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2 
############################################################## 
## For security purposes, please check: http://www.phpbb.com/mods/ 
## for the latest version of this MOD. Although MODs are checked 
## before being allowed in the MODs Database there is no guarantee 
## that there are no security problems within the MOD. No support 
## will be given for MODs not found within the MODs Database which 
## can be found at http://www.phpbb.com/mods/
############################################################## 
## Author Notes: I originally created this script since one
## of my forums had other programmers as admins and we would like to share ideas
## on a daily basis.  Since we sometimes lost or forgot about useful private messages, 
## having a "To Do" list kept things more organized.  This mod is
## very easy to install and comes in handy :)
##
## Since this is the first version I may add additional features in the future
## such as pagination, smileys, and displaying replies within the original poster table.
############################################################## 
## MOD History: 
## 
##   2007-28-07 - Version 1.0.1 
##      - First Release 
## 
##
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
############################################################## 

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

CREATE TABLE `phpbb_newideas` (
  `idea_id` smallint(5) unsigned NOT NULL auto_increment,
  `idea_text` text NOT NULL,
  `idea_time` int(10) NOT NULL default '0',
  `idea_status` smallint(1) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (`idea_id`)
);
 
# 
#-----[ COPY ]------------------------------------------ 
# 

copy admin/admin_ideas.php to admin/admin_ideas.php
copy language/lang_english/lang_admin_ideas.php to language/lang_english/lang_admin_ideas.php
copy language/lang_spanish/lang_admin_ideas.php to language/lang_english/lang_admin_ideas.php
copy templates/subSilver/admin/admin_ideas.tpl to templates/subSilver/admin/admin_ideas.tpl
copy templates/subSilver/admin/admin_ideas_edit.tpl to templates/subSilver/admin/admin_ideas_edit.tpl

# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM