[mxbb-commits] mx_pafiledb/pafiledb/docs index.htm,1.2,1.3 install.txt,1.2,1.3 pafiledb_installer.php,1.2,1.3 pafiledb_mysql.sql,1.2,1.3 update.txt,NONE,1.1 update_0.0.8_0.0.9a.txt,NONE,1.1 update_0.0.8_0.0.9b.txt,1.2,1.3 update_008_009d.sql,NONE,1.1 update_009a_009d.sql,NONE,1.1 update_009b_009d.sql,NONE,1.1 update_009d_mx10.sql,NONE,1.1 update_009d_mx201.sql,NONE,1.1 update_to_0.0.9d.txt,NONE,1.1 update_to_0.0.9d_mx_addon_1.0.txt,NONE,1.1

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_pafiledb/pafiledb/docs
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv2875/modules/mx_pafiledb/pafiledb/docs

Added Files:
	index.htm install.txt pafiledb_installer.php 
	pafiledb_mysql.sql update.txt update_0.0.8_0.0.9a.txt 
	update_0.0.8_0.0.9b.txt update_008_009d.sql 
	update_009a_009d.sql update_009b_009d.sql update_009d_mx10.sql 
	update_009d_mx201.sql update_to_0.0.9d.txt 
	update_to_0.0.9d_mx_addon_1.0.txt 
Log Message:
finally upgrading this module/mod
- merging phpBB mod, mxBB module (2.7.x and 2.8)
-.permissions reviewed
- pm notification added
- and many many minor fixes all over the place

--- NEW FILE: update_009b_009d.sql ---
CREATE TABLE phpbb_pa_auth (
   group_id mediumint(8) DEFAULT '0' NOT NULL,
   cat_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
   auth_view tinyint(1) DEFAULT '0' NOT NULL,
   auth_read tinyint(1) DEFAULT '0' NOT NULL,
   auth_view_file tinyint(1) DEFAULT '0' NOT NULL,
   auth_upload tinyint(1) DEFAULT '0' NOT NULL,
   auth_download tinyint(1) DEFAULT '0' NOT NULL,
   auth_rate tinyint(1) DEFAULT '0' NOT NULL,
   auth_email tinyint(1) DEFAULT '0' NOT NULL,
   auth_view_comment tinyint(1) DEFAULT '0' NOT NULL,
   auth_post_comment tinyint(1) DEFAULT '0' NOT NULL,
   auth_edit_comment tinyint(1) DEFAULT '0' NOT NULL,
   auth_delete_comment tinyint(1) DEFAULT '0' NOT NULL,
   auth_mod tinyint(1) DEFAULT '1' NOT NULL,
   auth_search tinyint(1) DEFAULT '1' NOT NULL,
   auth_stats tinyint(1) DEFAULT '1' NOT NULL,
   auth_toplist tinyint(1) DEFAULT '1' NOT NULL,
   auth_viewall tinyint(1) DEFAULT '1' NOT NULL,
   KEY group_id (group_id),
   KEY cat_id (cat_id)
);


CREATE TABLE phpbb_pa_mirrors (
  mirror_id mediumint(8) NOT NULL auto_increment, 
  file_id int(10) NOT NULL,
  unique_name varchar(255) NOT NULL default '',
  file_dir VARCHAR(255) NOT NULL, 
  file_dlurl varchar(255) NOT NULL default '',
  mirror_location VARCHAR(255) NOT NULL default '',
  PRIMARY KEY  (mirror_id),
  KEY file_id (file_id)
) TYPE=MyISAM;

ALTER TABLE phpbb_pa_cat 
ADD cat_files MEDIUMINT(8) DEFAULT '-1' NOT NULL AFTER cat_allow_file,
ADD cat_last_file_id MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL AFTER cat_files, 
ADD cat_last_file_name VARCHAR(255) NOT NULL AFTER cat_last_file_id,
ADD cat_last_file_time INT(50) UNSIGNED DEFAULT '0' NOT NULL AFTER cat_last_file_name; 

ALTER TABLE phpbb_pa_files 
ADD file_size INT(20) NOT NULL AFTER file_name,
ADD unique_name VARCHAR(255) NOT NULL AFTER file_size,
ADD real_name VARCHAR(255) NOT NULL AFTER unique_name,
ADD file_dir VARCHAR(255) NOT NULL AFTER real_name,
ADD file_broken TINYINT(1) DEFAULT '0' NOT NULL; 

INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('auth_search','0');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('auth_stats','0');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('auth_toplist','0');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('auth_viewall','0');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('max_file_size','262144');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('upload_dir','pafiledb/uploads/');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('screenshots_dir','pafiledb/images/screenshots/');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('forbidden_extensions','php, php3, php4, phtml, pl, asp, aspx, cgi');
--- NEW FILE: update_008_009d.sql ---
CREATE TABLE phpbb_pa_download_info ( 
    file_id MEDIUMINT(8) DEFAULT '0' NOT NULL, 
    user_id MEDIUMINT(8) DEFAULT '0' NOT NULL, 
    downloader_ip VARCHAR(8) NOT NULL, 
    downloader_os VARCHAR(8) NOT NULL, 
    downloader_browser VARCHAR(8) NOT NULL, 
    browser_version  VARCHAR(8) NOT NULL 
);

CREATE TABLE phpbb_pa_auth (
   group_id mediumint(8) DEFAULT '0' NOT NULL,
   cat_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
   auth_view tinyint(1) DEFAULT '0' NOT NULL,
   auth_read tinyint(1) DEFAULT '0' NOT NULL,
   auth_view_file tinyint(1) DEFAULT '0' NOT NULL,
   auth_upload tinyint(1) DEFAULT '0' NOT NULL,
   auth_download tinyint(1) DEFAULT '0' NOT NULL,
   auth_rate tinyint(1) DEFAULT '0' NOT NULL,
   auth_email tinyint(1) DEFAULT '0' NOT NULL,
   auth_view_comment tinyint(1) DEFAULT '0' NOT NULL,
   auth_post_comment tinyint(1) DEFAULT '0' NOT NULL,
   auth_edit_comment tinyint(1) DEFAULT '0' NOT NULL,
   auth_delete_comment tinyint(1) DEFAULT '0' NOT NULL,
   auth_mod tinyint(1) DEFAULT '1' NOT NULL,
   auth_search tinyint(1) DEFAULT '1' NOT NULL,
   auth_stats tinyint(1) DEFAULT '1' NOT NULL,
   auth_toplist tinyint(1) DEFAULT '1' NOT NULL,
   auth_viewall tinyint(1) DEFAULT '1' NOT NULL,
   KEY group_id (group_id),
   KEY cat_id (cat_id)
);

CREATE TABLE phpbb_pa_mirrors (
  mirror_id mediumint(8) NOT NULL auto_increment, 
  file_id int(10) NOT NULL,
  unique_name varchar(255) NOT NULL default '',
  real_name VARCHAR(255) NOT NULL default '',
  file_dir VARCHAR(255) NOT NULL, 
  file_dlurl varchar(255) NOT NULL default '',
  mirror_location VARCHAR(255) NOT NULL default '',
  PRIMARY KEY  (mirror_id),
  KEY file_id (file_id)
) TYPE=MyISAM;


CREATE TABLE phpbb_pa_config (
    config_name varchar(255) NOT NULL,
    config_value varchar(255) NOT NULL,
    PRIMARY KEY (config_name)
);


INSERT INTO phpbb_pa_config VALUES ('allow_comment_images', '0');
INSERT INTO phpbb_pa_config VALUES ('no_comment_image_message', '[No image please]');
INSERT INTO phpbb_pa_config VALUES ('allow_smilies', '1');
INSERT INTO phpbb_pa_config VALUES ('allow_comment_links', '1');
INSERT INTO phpbb_pa_config VALUES ('no_comment_link_message', '[No links please]');
INSERT INTO phpbb_pa_config VALUES ('settings_disable', '0');
INSERT INTO phpbb_pa_config VALUES ('allow_html', '1');
INSERT INTO phpbb_pa_config VALUES ('allow_bbcode', '1');
INSERT INTO phpbb_pa_config VALUES ('settings_topnumber', '10');
INSERT INTO phpbb_pa_config VALUES ('settings_newdays', '1');
INSERT INTO phpbb_pa_config VALUES ('settings_stats', '');
INSERT INTO phpbb_pa_config VALUES ('settings_viewall', '1');
INSERT INTO phpbb_pa_config VALUES ('settings_dbname', 'Download Database');
INSERT INTO phpbb_pa_config VALUES ('settings_dbdescription', '');
INSERT INTO phpbb_pa_config VALUES ('max_comment_chars', '5000');
INSERT INTO phpbb_pa_config VALUES ('tpl_php', '0');
INSERT INTO phpbb_pa_config VALUES ('settings_file_page', '20');
INSERT INTO phpbb_pa_config VALUES ('hotlink_prevent', '1');
INSERT INTO phpbb_pa_config VALUES ('hotlink_allowed', '');
INSERT INTO phpbb_pa_config VALUES ('sort_method', 'file_time');
INSERT INTO phpbb_pa_config VALUES ('sort_order', 'DESC');

INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('auth_search','0');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('auth_stats','0');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('auth_toplist','0');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('auth_viewall','0');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('max_file_size','262144');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('upload_dir','pafiledb/uploads/');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('screenshots_dir','pafiledb/images/screenshots/');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('forbidden_extensions','php, php3, php4, phtml, pl, asp, aspx, cgi');


ALTER TABLE phpbb_pa_cat 
DROP cat_files.
ADD parents_data TEXT NOT NULL AFTER cat_parent,
ADD cat_allow_file TINYINT(2) DEFAULT '0' NOT NULL, 
ADD auth_view TINYINT(2) DEFAULT '0' NOT NULL, 
ADD auth_read TINYINT(2) DEFAULT '0' NOT NULL, 
ADD auth_view_file TINYINT(2) DEFAULT '0' NOT NULL, 
ADD auth_upload TINYINT(2) DEFAULT '0' NOT NULL, 
ADD auth_download TINYINT(2) DEFAULT '0' NOT NULL, 
ADD auth_rate TINYINT(2) DEFAULT '0' NOT NULL, 
ADD auth_email TINYINT(2) DEFAULT '0' NOT NULL, 
ADD auth_view_comment TINYINT(2) DEFAULT '0' NOT NULL, 
ADD auth_post_comment TINYINT(2) DEFAULT '0' NOT NULL, 
ADD auth_edit_comment TINYINT(2) DEFAULT '0' NOT NULL, 
ADD auth_delete_comment TINYINT(2) DEFAULT '0' NOT NULL,
ADD cat_files MEDIUMINT(8) NOT NULL default '-1' AFTER cat_allow_file,
ADD cat_last_file_id MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL AFTER cat_files, 
ADD cat_last_file_name VARCHAR(255) NOT NULL AFTER cat_last_file_id,
ADD cat_last_file_time INT(50) UNSIGNED DEFAULT '0' NOT NULL AFTER cat_last_file_name, 
DROP cat_1xid;

ALTER TABLE phpbb_pa_files 
ADD user_id MEDIUMINT(8) DEFAULT '0' NOT NULL AFTER file_id,
ADD poster_ip VARCHAR(8) NOT NULL AFTER user_id,
ADD file_sshot_link TINYINT(2) DEFAULT '0' NOT NULL AFTER file_ssurl, 
ADD file_update_time INT(50) NOT NULL AFTER file_time,
ADD file_approved TINYINT(2) DEFAULT '0' NOT NULL,
ADD file_broken TINYINT(1) DEFAULT '0' NOT NULL,
ADD file_size INT(20) NOT NULL AFTER file_name,
ADD unique_name VARCHAR(255) NOT NULL AFTER file_size,
ADD real_name VARCHAR(255) NOT NULL AFTER unique_name
ADD file_dir VARCHAR(255) NOT NULL AFTER real_name,
DROP file_rating,
DROP file_totalvotes;

ALTER TABLE phpbb_pa_votes 
ADD user_id MEDIUMINT(8) DEFAULT '0' NOT NULL FIRST,
ADD rate_point tinyint(3) UNSIGNED NOT NULL AFTER votes_file,
ADD voter_os VARCHAR(255) NOT NULL, 
ADD voter_browser VARCHAR(255) NOT NULL,
ADD browser_version VARCHAR(8) NOT NULL;


ALTER TABLE phpbb_pa_custom 
ADD data text NOT NULL,
ADD regex VARCHAR(255) NOT NULL,
ADD field_order INT(20) NOT NULL, 
ADD field_type TINYINT(2) NOT NULL; 


DROP TABLE phpbb_pa_settings;

UPDATE phpbb_pa_files SET file_approved = 1, user_id = 2;
UPDATE phpbb_pa_cat SET cat_allow_file = 1;
DELETE FROM phpbb_pa_votes WHERE rate_point = '' OR rate_point = 0;


--- NEW FILE: update_009d_mx10.sql ---
ALTER TABLE phpbb_pa_cat 
ADD auth_edit_file tinyint(1) DEFAULT '0' NOT NULL AFTER auth_view_file,
ADD auth_delete_file tinyint(1) DEFAULT '0' NOT NULL AFTER auth_edit_file,
ADD cat_allow_ratings tinyint(2) NOT NULL default '1' AFTER cat_allow_file,
ADD cat_allow_comments tinyint(2) NOT NULL default '1' AFTER cat_allow_ratings;

ALTER TABLE phpbb_pa_auth 
ADD auth_edit_file tinyint(2) DEFAULT '0' NOT NULL AFTER auth_view_file,
ADD auth_delete_file tinyint(2) DEFAULT '0' NOT NULL AFTER auth_edit_file;

INSERT INTO phpbb_pa_config VALUES ('pm_notify', '0');
--- NEW FILE: update.txt ---
if you already have the version 0.0.9d (mxBB addon) you have to run the pafiledb_installer.php

Upload all new files, and run the installer from its location at 
pafiledb/docs/pafiledb_installer.php 

choose what version top update

and you need to chmod the following!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

## Create and CHMOD (0777) THE FOLLOWING DIRECTORIES:
## - pafiledb/uploads/
## - pafiledb/cache/
## - pafiledb/cache/templates/subSilver/
## - pafiledb/cache/templates/subSilver/admin
## - pafiledb/images/screenshots/

clear the directory pafiledb/cache/ from all the files but don't delete the folders in it

// Jon

--- NEW FILE: install.txt ---
############################################################## 
## MOD Title: Download Manager (mxBB pafiledb) integration
## MOD Version: 0.0.9d + mxBB 2.01
## MOD Original Author: squall < moh...@ya... > (Mohammed Al-Basri) www.mohd.tk 
##	       			MJ < mj...@ph... > www.phpbbfm.com
## MOD Current Author: _Haplo < jon...@ho... > www.mx-system.com 
## MOD Description: Integration of pafiledb (Database download manager) with phpBB.
##                  pafiledb use header, footer, session, template, and database system
##		    		of phpbb.
##					Only for phpBB 2.0.x+!
## 
## Installation Level: (easy) 
## Installation Time: 10-15 Minutes 
## Files To Edit (10) : 
##				admin/index.php
##		       	admin/admin_db_utilities.php
##		       	includes/page_header.php, 
##                     language/lang_english/lang_main.php,
##                     templates/subSilver/admin/page_header.tpl,
##                     templates/subSilver/overall_header.tpl,
##
## Included Files:     
##				dload.php,
##		       	admin/admin_*.php ( 8 )
##		       	language/*/lang_*.php ( 2 )
##		       	pafiledb/*.*,
##		       	templates/subSilver/pa_*.tpl ( 22 )
##		       	templates/subSilver/admin/pa_*.tpl ( 23 )
##		       	templates/subSilver/images/icon_mini_download.gif
##		       	templates/subSilver/images/lang_english/icon_pa_*.gif ( 9 )
##
##
############################################################## 
############################################################## 
## For Security Purposes, Please Check: http://www.phpbb.com/mods/downloads/ for the 
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code 
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered 
## in our MOD-Database, located at: http://www.phpbb.com/mods/downloads/ 
############################################################## 
############################################################## 
## Author Note: 
## follow all the instruction below first then upload and run from your browser, 
## pafiledb/docs/pafiledb_installer.php (choose new installation) and if you have the table already installed, 
## you won't need to change anything in them except that you won't need the admin table 
## since you are going to use ACP. 
##
## Create and CHMOD (0777) THE FOLLOWING DIRECTORIES:
## - pafiledb/uploads/
## - pafiledb/cache/
## - pafiledb/cache/templates/subSilver/
## - pafiledb/cache/templates/subSilver/admin
## - pafiledb/images/screenshots/	
##
## Change History:
##	0.0.9d + mxBB 2.0.1 : ADD/Fixed:
## 		- bugfixes 
## 		- PM/EMAIL notification done 
## 		- Permissions reviewed and "secured" 
## 		- Comments/ratings may be enabled/disabled 
## 		- Approval level per category 
## 		- ucp/mcp final 
##
##	0.0.9d + mxBB 1.0.1-3 : ADD/Fixed:
## 		- bugfixes  
## 		- need approval/validation on/off 
## 		- validator select: admin/mod 
## 		- PM notify to validator (not finished)
## 		- ucp: EDIT/DELETE buttons...and added permissions 
## 		- mcp (experimental) 
## 		- comments fix (now delete comments works...not edit)
## 		- and more 
##
##	0.0.9 : ADD/Fixed:
##		- THE WHOLE MOD IS RE WRITIEN 
##		- ADDED ALOT OF FEATURE
##		- FIXING ALOT OF SECURITY BUGS
##	0.0.8 : Added/Fixed:
##		- Fixed the global varaible problem. (you don't have to set global var to on)
##		- Changed the whole coding structure in all file.
##		- Comment viewing like the viewtopic.
##		- Added the file checker feature (beware if this one or you will end up erasing all file.)
##		- Changed some images and included them into templates/*/images/ folder.
##		- Main Templates cleaned up, added clickable folder icons.
##		- Fixed bug with category sort feature.
##		- Added edit download count when editing file.
##		- Added Dutch, German and Italian language support .
##
##	0.0.7 : Added/Fixed:
##		- Fixed bug with screen shot upload.
##		- Fixed bug with templates in ACP.
##		- Removed Variable $str found in search.php.
##		- Changed directory for images and icons.
##		- Changed all url and action to append_sid.
##
##	0.0.6 : Added/Fixed:
##		- Backupdb & restore to phpBB forum backup style
##		- Changed tables to phpbb style
##		- Show screenshots as image instead of link. (you may choose now either links or image).
##		- Long Description - Multiple line text area.
##		- Replaced pafiledb language with phpbb.
##		- Unlimited subCategories.
##		- Added Upload Screenshot feature (there is a small bugs on it)
##		- Added Disable "View All" link
##		- Added Disable Database feature
##		- comment feature (only registered users can post)
##		- Email is using phpBB class emailer.
##		- New File indicator you can now set the number of day to show that the file is new
##		- Added toplist file (you can now specify number of file that in toplist.
##		- Removed the following bugs:
##			* Replaced pafiledb Time Zone with phpbb.
##			* Replaced pafiledb Language with phpbb.
##			* Email fields can be left blank, but confirmation of email sent is returned. 
##			* Custom Field data not reading from db
##			* Time on posted comment
##			* Edit file (ACP), sub-cats & files not showing
##			* Backup Database screwed
##			* removing some un needed row from setting table like language and style.
##			* fixing the problem of jumpmenu fix in pafiledb.php file because file send the $str instead of $lang
##			* 'Comment Explain' text missing
##			* Title on posted comment
##			* max_comment_chars field in _settings table missing
##			* Javascript error when posting or previewing comment
##			* Email not actually sending to address ??? (Not for me anyway!)
##			* Time on file page
##
##	0.0.5 : - Re-packing of all working files
##     	 	- Changed paFileDB_installer.php
##
## 	0.0.4 : Fixed:
## 		- {dbname} showing in the email instead of the variable that should replace it.
## 		- Uploaded file not returning full URL.
## 		- Replaced pafiledb Time Zone with phpbb.
## 		- Email fields can be left blank, but confirmation of email sent is returned 
## 		- Fixed sort for viewall.. (sort according to rating not yet due to php version) 
## 		- Custom Field data not reading from db		
## 		- Added support for view online when some one in download page.
##
##	0.0.3 : - Fixed the editing file bug in ACP
##		- Fixed the the file in sub category bug.
##		- Fixed the uploading file url bug when uploading
##		- Changed message after rating or e-mail sending
##		- Made copywrite with phpbb copywrite only if you are in download database
##
##	0.0.2 : All templates made to fit phpBB default, clean up of code. 
##
## 	0.0.1 : First release, I need just to modify the *.tpl file in admin 
## 		section.
## 
##############################################################  
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
############################################################## 
# 
#-----[ COPY ]------------------------------------------ 
# 
copy dload.php to root 
copy admin/*.php to admin/ 
copy templates/subSilver/*.tpl to templates/subSilver/ 
copy templates/subSilver/images/*.gif to templates/subSilver/images
copy templates/subSilver/images/lang_english*.gif to templates/subSilver/images/lang_english
copy templates/subSilver/admin/*.tpl to templates/subSilver/admin/
copy pafiledb/*.* to pafiledb/
copy language/lang_english/* to language/lang_english/*

# 
#-----[ OPEN ]------------------------------------------ 
# 
admin/index.php

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

//
// End functions
// -------------
# 
#-----[ AFTER, ADD ]------------------------------------------ 
#  

include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin_pafiledb.' . $phpEx);
# 
#-----[ FIND ]------------------------------------------ 
# 

						case PAGE_FAQ:
							$location = $lang['Viewing_FAQ'];
							$location_url = "index.$phpEx?pane=right";
							break;
# 
#-----[ AFTER, ADD ]------------------------------------------ 
#  

						case PAGE_DOWNLOAD:
							$location = $lang['Viewing_Download'];
							$location_url = "../dload.$phpEx";
							break;            
# 
#-----[ FIND ]------------------------------------------ 
# 

					case PAGE_FAQ:
						$location = $lang['Viewing_FAQ'];
						$location_url = "index.$phpEx?pane=right";
						break;
# 
#-----[ AFTER, ADD ]------------------------------------------ 
#  

					case PAGE_DOWNLOAD:
						$location = $lang['Viewing_Download'];
						$location_url = "../dload.$phpEx";
						break;

# 
#-----[ OPEN ]------------------------------------------ 
# 
admin/admin_db_utilities.php
# 
#-----[ FIND ]------------------------------------------ 
# 
	include('./page_footer_admin.'.$phpEx);
}
$tables = array('auth_access', 'banlist', 'categories'....

# 
#-----[ FIND IN LINE ]------------------------------------------ 
# 
'forums', 'forum_prune', 

# 
#-----[ ADD INTO LINE ]------------------------------------------ 
# 
'pa_cat', 'pa_comments', 'pa_custom', 'pa_customdata', 'pa_files', 'pa_license', 'pa_config', 'pa_votes', 'pa_download_info', 'pa_mirros',


# 
#-----[ OPEN ]------------------------------------------ 
# 
templates/subSilver/overall_header.tpl

# 
#-----[ FIND ]------------------------------------------ 
#  	
					<tr>
						<td height="25" align="center" valign="top" nowrap="nowrap"><span class="mainmenu">&nbsp;<a href="{U_PROFILE}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_profile.gif" width="12" height="13" border="0" alt="{L_PROFILE}" hspace="3" />{L_PROFILE}</a>&nbsp; &nbsp;<a href="{U_PRIVATEMSGS}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_message.gif" width="12" height="13" border="0" alt="{PRIVATE_MESSAGE_INFO}" hspace="3" />{PRIVATE_MESSAGE_INFO}</a>&nbsp; &nbsp;<a href="{U_LOGIN_LOGOUT}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_login.gif" width="12" height="13" border="0" alt="{L_LOGIN_LOGOUT}" hspace="3" />{L_LOGIN_LOGOUT}</a>&nbsp;</span></td>
					</tr>
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
					<tr> 
						<td height="25" align="center" nowrap class="mainmenu" valign="top"> 
						&nbsp;<a href="{U_DOWNLOAD}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_download.gif" width="13" height="13" border="0" alt="{PRIVATE_MESSAGE_INFO}" title="{PRIVATE_MESSAGE_INFO}" hspace="3" align="top" />{L_DOWNLOAD}</a>&nbsp; 
						</td>
					</tr>
# 
#-----[ OPEN ]------------------------------------------ 
# 

language/lang_english/lang_main.php

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

$lang['FAQ'] = 'FAQ';

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

$lang['Download'] = 'Download'; 

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

$lang['Viewing_FAQ'] = 'Viewing FAQ';

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

$lang['Viewing_Download'] = 'Viewing Download';


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

includes/page_header.php

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

	'L_FAQ' => $lang['FAQ'],

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

	'L_DOWNLOAD' => $lang['Download'], 

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

	'U_FAQ' => append_sid('faq.'.$phpEx),

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

	'U_DOWNLOAD' => append_sid('dload.'.$phpEx),

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

viewonline.php

# 
#-----[ FIND ]------------------------------------------ 
# 
				case PAGE_FAQ:
					$location = $lang['Viewing_FAQ'];
					$location_url = "faq.$phpEx";
					break;
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 

				case PAGE_DOWNLOAD:
					$location = $lang['Viewing_Download'];
					$location_url = "dload.$phpEx";
					break;


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

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

Log in as admin!

run pafiledb/docs/pafiledb_installer.php or pafiledb_mysql.sql

# EoM  
--- NEW FILE: update_009d_mx201.sql ---
ALTER TABLE phpbb_pa_cat 
ADD auth_approval tinyint(1) DEFAULT '0' NOT NULL AFTER auth_delete_comment;

ALTER TABLE phpbb_pa_auth 
ADD auth_approval tinyint(2) DEFAULT '0' NOT NULL AFTER auth_delete_comment,
MODIFY auth_edit_file tinyint(2) DEFAULT '0' NOT NULL,
MODIFY auth_delete_file tinyint(2) DEFAULT '0' NOT NULL;

ALTER TABLE phpbb_kb_config 
MODIFY config_name VARCHAR(255) NOT NULL default '',
MODIFY config_value VARCHAR(255) NOT NULL default '',
DROP PRIMARY KEY, ADD PRIMARY KEY (config_name);

--- NEW FILE: update_009a_009d.sql ---
ALTER TABLE phpbb_pa_download_info 
CHANGE downloader_borwser downloader_browser VARCHAR(255) NOT NULL;

ALTER TABLE phpbb_pa_votes 
CHANGE voter_borwser voter_browser VARCHAR(255) NOT NULL;

CREATE TABLE phpbb_pa_auth (
   group_id mediumint(8) DEFAULT '0' NOT NULL,
   cat_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
   auth_view tinyint(1) DEFAULT '0' NOT NULL,
   auth_read tinyint(1) DEFAULT '0' NOT NULL,
   auth_view_file tinyint(1) DEFAULT '0' NOT NULL,
   auth_upload tinyint(1) DEFAULT '0' NOT NULL,
   auth_download tinyint(1) DEFAULT '0' NOT NULL,
   auth_rate tinyint(1) DEFAULT '0' NOT NULL,
   auth_email tinyint(1) DEFAULT '0' NOT NULL,
   auth_view_comment tinyint(1) DEFAULT '0' NOT NULL,
   auth_post_comment tinyint(1) DEFAULT '0' NOT NULL,
   auth_edit_comment tinyint(1) DEFAULT '0' NOT NULL,
   auth_delete_comment tinyint(1) DEFAULT '0' NOT NULL,
   auth_mod tinyint(1) DEFAULT '1' NOT NULL,
   auth_search tinyint(1) DEFAULT '1' NOT NULL,
   auth_stats tinyint(1) DEFAULT '1' NOT NULL,
   auth_toplist tinyint(1) DEFAULT '1' NOT NULL,
   auth_viewall tinyint(1) DEFAULT '1' NOT NULL,
   KEY group_id (group_id),
   KEY cat_id (cat_id)
);

CREATE TABLE phpbb_pa_mirrors (
  mirror_id mediumint(8) NOT NULL auto_increment, 
  file_id int(10) NOT NULL,
  unique_name varchar(255) NOT NULL default '',
  file_dir VARCHAR(255) NOT NULL, 
  file_dlurl varchar(255) NOT NULL default '',
  mirror_location VARCHAR(255) NOT NULL default '',
  PRIMARY KEY  (mirror_id),
  KEY file_id (file_id)
) TYPE=MyISAM;

ALTER TABLE phpbb_pa_cat 
ADD cat_files MEDIUMINT(8) DEFAULT '-1' NOT NULL AFTER cat_allow_file,
ADD cat_last_file_id MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL AFTER cat_files, 
ADD cat_last_file_name VARCHAR(255) NOT NULL AFTER cat_last_file_id,
ADD cat_last_file_time INT(50) UNSIGNED DEFAULT '0' NOT NULL AFTER cat_last_file_name; 

ALTER TABLE phpbb_pa_files 
ADD file_size INT(20) NOT NULL AFTER file_name,
ADD unique_name VARCHAR(255) NOT NULL AFTER file_size,
ADD real_name VARCHAR(255) NOT NULL AFTER unique_name
ADD file_dir VARCHAR(255) NOT NULL AFTER real_name,
ADD file_broken TINYINT(1) DEFAULT '0' NOT NULL;

INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('auth_search','0');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('auth_stats','0');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('auth_toplist','0');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('auth_viewall','0');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('max_file_size','262144');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('upload_dir','pafiledb/uploads/');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('screenshots_dir','pafiledb/images/screenshots/');
INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('forbidden_extensions','php, php3, php4, phtml, pl, asp, aspx, cgi');
--- NEW FILE: update_to_0.0.9d.txt ---
if you have the version 0.0.9c you don't have to run the pafiledb_installer.php

Upload all new files, and run the installer from its location at 
pafiledb/docs/pafiledb_installer.php choose to update your version

don't forget to see the new structure for the folders

and you need to chmod the following

## Create and CHMOD (0777) THE FOLLOWING DIRECTORIES:
## - pafiledb/uploads/
## - pafiledb/cache/
## - pafiledb/cache/templates/subSilver/
## - pafiledb/cache/templates/subSilver/admin
## - pafiledb/images/screenshots/

clear the directory pafiledb/cache/ from all the files but don't delete the folders on it

--- NEW FILE: update_0.0.8_0.0.9a.txt ---
############################################################## 
## MOD Title: pafiledb integration
## MOD Version: 0.0.9a
## MOD Author: squall < moh...@ya... > (Mohammed Al-Basri) www.mohd.tk 
##	       MJ < mj...@ph... > www.phpbbfm.com
## MOD Description: Integration of pafiledb (Database download manager) with phpbb.
##                  pafiledb use header, footer, session, template, and database system
##		    of phpbb.
##			Only for phpBB 2.0.4!
## 
## Installation Level: (easy) 
## Installation Time: 10-15 Minutes 
## Files To Edit (10) : admin/index.php
##			includes/constant.php
##		       admin/admin_db_utilities.php
##		       includes/page_header.php, 
##                     language/lang_english/lang_main.php,
##                     templates/subSilver/admin/page_header.tpl,
##                     templates/subSilver/overall_header.tpl,
##		       templates/subSilver/subSilver.cfg
##
## Included Files:     dload.php,
##		       admin/admin_pa_catauth.php
##		       admin/admin_pa_category.php,
##		       admin/admin_pa_custom.php,
##		       admin/admin_pa_file.php,
##		       admin/admin_pa_license.php,
##		       admin/admin_pa_settings.php,
##		       language/*/lang_admin_pafiledb.php
##		       language/*/lang_pafiledb.php
##		       pafiledb/*.*,
##		       templates/subSilver/pa_*.tpl ( 18 )
##		       templates/subSilver/admin/pa_*.tpl ( 19 )
##		       templates/subSilver/images/icon_mini_download.gif
##		       templates/subSilver/images/lang_english/icon_pa_*.gif ( 9 )
##
##
############################################################## 
############################################################## 
## For Security Purposes, Please Check: http://www.phpbb.com/mods/downloads/ for the 
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code 
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered 
## in our MOD-Database, located at: http://www.phpbb.com/mods/downloads/ 
############################################################## 
############################################################## 
## Author Note: 
## follow all the instruction below first then upload and run from your browser, 
## pafiledb/docs/pafiledb_installer.php (choose update from 0.0.8) and if you have the table already installed, 
## you won't need to change anything in them except that you won't need the admin table 
## since you are going to use ACP. 
##
## Create and CHMOD (0777) THE FOLLOWING DIRECTORIES:
## - pafiledb/uploads/
## - pafiledb/cache/
## - pafiledb/cache/file_size
## - pafiledb/cache/templates/subSilver/
## - pafiledb/cache/templates/subSilver/admin
## - pafiledb/explain
##	
##
## Change History:
##	0.0.9 : ADD/Fixed:
##		- THE WHOLE MOD IS RE WRITIEN 
##		- ADDED ALOT OF FEATURE
##		- FIXING ALOT OF SECURITY BUGS
##	0.0.8 : Added/Fixed:
##		- Fixed the global varaible problem. (you don't have to set global var to on)
##		- Changed the whole coding structure in all file.
##		- Comment viewing like the viewtopic.
##		- Added the file checker feature (beware if this one or you will end up erasing all file.)
##		- Changed some images and included them into templates/*/images/ folder.
##		- Main Templates cleaned up, added clickable folder icons.
##		- Fixed bug with category sort feature.
##		- Added edit download count when editing file.
##		- Added Dutch, German and Italian language support .
##
##	0.0.7 : Added/Fixed:
##		- Fixed bug with screen shot upload.
##		- Fixed bug with templates in ACP.
##		- Removed Variable $str found in search.php.
##		- Changed directory for images and icons.
##		- Changed all url and action to append_sid.
##
##	0.0.6 : Added/Fixed:
##		- Backupdb & restore to phpBB forum backup style
##		- Changed tables to phpbb style
##		- Show screenshots as image instead of link. (you may choose now either links or image).
##		- Long Description - Multiple line text area.
##		- Replaced pafiledb language with phpbb.
##		- Unlimited subCategories.
##		- Added Upload Screenshot feature (there is a small bugs on it)
##		- Added Disable "View All" link
##		- Added Disable Database feature
##		- comment feature (only registered users can post)
##		- Email is using phpBB class emailer.
##		- New File indicator you can now set the number of day to show that the file is new
##		- Added toplist file (you can now specify number of file that in toplist.
##		- Removed the following bugs:
##			* Replaced pafiledb Time Zone with phpbb.
##			* Replaced pafiledb Language with phpbb.
##			* Email fields can be left blank, but confirmation of email sent is returned. 
##			* Custom Field data not reading from db
##			* Time on posted comment
##			* Edit file (ACP), sub-cats & files not showing
##			* Backup Database screwed
##			* removing some un needed row from setting table like language and style.
##			* fixing the problem of jumpmenu fix in pafiledb.php file because file send the $str instead of $lang
##			* 'Comment Explain' text missing
##			* Title on posted comment
##			* max_comment_chars field in _settings table missing
##			* Javascript error when posting or previewing comment
##			* Email not actually sending to address ??? (Not for me anyway!)
##			* Time on file page
##
##	0.0.5 : - Re-packing of all working files
##     	 	- Changed paFileDB_installer.php
##
## 	0.0.4 : Fixed:
## 		- {dbname} showing in the email instead of the variable that should replace it.
## 		- Uploaded file not returning full URL.
## 		- Replaced pafiledb Time Zone with phpbb.
## 		- Email fields can be left blank, but confirmation of email sent is returned 
## 		- Fixed sort for viewall.. (sort according to rating not yet due to php version) 
## 		- Custom Field data not reading from db		
## 		- Added support for view online when some one in download page.
##
##	0.0.3 : - Fixed the editing file bug in ACP
##		- Fixed the the file in sub category bug.
##		- Fixed the uploading file url bug when uploading
##		- Changed message after rating or e-mail sending
##		- Made copywrite with phpbb copywrite only if you are in download database
##
##	0.0.2 : All templates made to fit phpBB default, clean up of code. 
##
## 	0.0.1 : First release, I need just to modify the *.tpl file in admin 
## 		section.
## 
##############################################################  
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
############################################################## 
# 
#-----[ COPY ]------------------------------------------ 
# 
copy dload.php to root 
copy admin/*.php to admin/ 
copy templates/subSilver/*.tpl to templates/subSilver/ 
copy templates/subSilver/admin/*.tpl to templates/subSilver/admin/
copy pafiledb/*.* to pafiledb/
copy language/lang_english/* to language/lang_english/*

# 
#-----[ SQL ]------------------------------------------ 
# 
run pafiledb/docs/pafiledb_installer.php or update.sql

# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/constants.php

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

define('PA_CATEGORY_TABLE', $table_prefix.'pa_cat');
define('PA_COMMENTS_TABLE', $table_prefix.'pa_comments');
define('PA_CUSTOM_TABLE', $table_prefix.'pa_custom');
define('PA_CUSTOM_DATA_TABLE', $table_prefix.'pa_customdata');
define('PA_FILES_TABLE', $table_prefix.'pa_files');
define('PA_LICENSE_TABLE', $table_prefix.'pa_license');
define('PA_SETTINGS_TABLE', $table_prefix.'pa_settings');
define('PA_VOTES_TABLE', $table_prefix.'pa_votes');

# 
#-----[ REPLACE, WITH ]------------------------------------------ 
#  

//REMOVED


# 
#-----[ OPEN ]------------------------------------------ 
# 
admin/index.php
# 
#-----[ FIND ]------------------------------------------ 
# 
//
// pafiledb
//
include_once($phpbb_root_path . 'pafiledb/includes/functions.' . $phpEx); 
$config = pafiledb_config();
include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin_pafiledb.' . $phpEx);
# 
#-----[ AFTER, ADD ]------------------------------------------ 
#  

// REMOVED

# 
#-----[ OPEN ]------------------------------------------ 
# 
admin/admin_db_utilities.php
# 
#-----[ FIND ]------------------------------------------ 
# 
	include('./page_footer_admin.'.$phpEx);
}
$tables = array('auth_access', 'banlist', 'categories'....

# 
#-----[ FIND IN LINE ]------------------------------------------ 
# 
'pa_cat', 'pa_comments', 'pa_custom', 'pa_customdata', 'pa_files', 'pa_license', 'pa_settings', 'pa_votes', 

# 
#-----[ REPLACE, WITH ]------------------------------------------ 
# 
'pa_cat', 'pa_comments', 'pa_custom', 'pa_customdata', 'pa_files', 'pa_license', 'pa_config', 'pa_votes', 'pa_download_info'


# 
#-----[ OPEN ]------------------------------------------ 
# 
templates/subSilver/overall_header.tpl

# 
#-----[ FIND ]------------------------------------------ 
#  
<script language="JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>
<SCRIPT LANGUAGE="JavaScript"> 
<!-- 
function mpFoto(img){ 
foto1= new Image(); 
foto1.src=(img); 
mpControl(img); 
} 
function mpControl(img){ 
if((foto1.width!=0)&&(foto1.height!=0)){ 
viewFoto(img); 
} 
else{ 
mpFunc="mpControl('"+img+"')"; 
intervallo=setTimeout(mpFunc,20); 
} 
} 
function viewFoto(img){ 
largh=foto1.width+20; 
altez=foto1.height+20; 
string="width="+largh+",height="+altez; 
finestra=window.open(img,"",string); 
} 
//--> 
</script> 
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
<!-- removed --!>

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

includes/page_tail.php

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

if ( defined('IN_DOWNLOAD') )
{
   $template->assign_block_vars("pa_copy", array());	
}

# 
#-----[ REPLACE, WITH ]------------------------------------------ 
# 

// Removed
# 
#-----[ OPEN ]------------------------------------------ 
#

templates/subSilver/overall_footer.tpl

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

<!-- BEGIN pa_copy -->
& <a href="http://www.phparena.net/" target="_phparena" class="copyright">PHP Arena</a> paFileDB 3.1 &copy; 2002, 2003
<!-- END pa_copy -->

# 
#-----[ REPLACE, WITH ]------------------------------------------ 
# 

<!-- removed -->

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

templates/subSilver/subSilver.cfg

# 
#-----[ FIND ]------------------------------------------ 
# 
$images['pa_search'] = "$current_template_images/{LANG}/icon_pa_search.gif";
$images['pa_stats'] = "$current_template_images/{LANG}/icon_pa_stats.gif";
$images['pa_toplist'] = "$current_template_images/{LANG}/icon_pa_toplist.gif";
$images['pa_download'] = "$current_template_images/icon_pa_download.gif";
$images['pa_rate'] = "$current_template_images/icon_pa_rate.gif";
$images['pa_email'] = "$current_template_images/icon_pa_email.gif";

# 
#-----[ REPLACE, WITH ]------------------------------------------ 
# 
$images['pa_search'] = "$current_template_images/{LANG}/icon_pa_search.gif";
$images['pa_stats'] = "$current_template_images/{LANG}/icon_pa_stats.gif";
$images['pa_toplist'] = "$current_template_images/{LANG}/icon_pa_toplist.gif";
$images['pa_upload'] = "$current_template_images/{LANG}/icon_pa_upload.gif";
$images['pa_viewall'] = "$current_template_images/{LANG}/icon_pa_viewall.gif";
$images['pa_download'] = "$current_template_images/{LANG}/icon_pa_download.gif";
$images['pa_rate'] = "$current_template_images/{LANG}/icon_pa_rate.gif";
$images['pa_email'] = "$current_template_images/{LANG}/icon_pa_email.gif";
$images['pa_comment_post'] = "$current_template_images/{LANG}/icon_pa_post_comment.gif";
$images['pa_file_new'] = "$current_template_images/icon_pa_new.gif";


# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM  
--- NEW FILE: pafiledb_installer.php ---
<?php
define( 'IN_PHPBB', true );
define( 'IN_DOWNLOAD', true );
$phpbb_root_path = './../../';
include( $phpbb_root_path . 'extension.inc' );
include( $phpbb_root_path . 'common.' . $phpEx );

// Start session management

$userdata = session_pagestart( $user_ip, PAGE_DOWNLOAD );
init_userprefs( $userdata );

// End session management

if ( $userdata['user_level'] != ADMIN )
{
	message_die( GENERAL_MESSAGE, $lang['Not_admin'] );
}

// Lets build a page ...


?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;">
<meta http-equiv="Content-Style-Type" content="text/css">
<style type="text/css">

</style>
</head>
<body bgcolor="#FFFFFF" text="#000000" link="#006699" vlink="#5584AA">

<table width="100%" border="0" cellspacing="0" cellpadding="10" align="center">
	<tr>
		<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
			<tr>
				<td align="center" width="100%" valign="middle"><span class="maintitle">Installing Download Manager (mxBB PaFileDB) for phpBB2</span></td>
			</tr>
		</table></td>
	</tr>
</table>

<br clear="all" />

<?php 

// Here we go

include( $phpbb_root_path . 'includes/sql_parse.' . $phpEx );

$available_dbms = array( "mysql" => array( "SCHEMA" => "pafiledb_mysql",
		"UPDATE008" => "update_008_009d",
		"UPDATE009A" => "update_009a_009d",
		"UPDATE009B" => "update_009b_009d",
		"UPDATE009DMX10" => "update_009d_mx10",
		"UPDATE009DMX201" => "update_009d_mx201",
		"DELIM" => ";",
		"DELIM_BASIC" => ";",
		"COMMENTS" => "remove_remarks" 
		),
	"mysql4" => array( "SCHEMA" => "pafiledb_mysql",
		"UPDATE008" => "update_008_009d",
		"UPDATE009A" => "update_009a_009d",
		"UPDATE009B" => "update_009b_009d",
		"UPDATE009DMX10" => "update_009d_mx10",
		"UPDATE009DMX201" => "update_009d_mx201",
		"DELIM" => ";",
		"DELIM_BASIC" => ";",
		"COMMENTS" => "remove_remarks" 
		),
	"mssql" => array( "SCHEMA" => "pafiledb_mssql",
		"UPDATE008" => "update_008_009c",
		"UPDATE009A" => "update_009a_009c",
		"UPDATE009B" => "update_009b_009c",
		"UPDATE009DMX10" => "update_009d_mx10",
		"UPDATE009DMX201" => "update_009d_mx201",
		"DELIM" => "GO",
		"DELIM_BASIC" => ";",
		"COMMENTS" => "remove_comments" 
		),
	"mssql-odbc" => array( "SCHEMA" => "pafiledb_mssql",
		"UPDATE008" => "update_008_009c",
		"UPDATE009A" => "update_009a_009c",
		"UPDATE009B" => "update_009b_009c",
		"UPDATE009DMX10" => "update_009d_mx10",
		"UPDATE009DMX201" => "update_009d_mx201",
		"DELIM" => "GO",
		"DELIM_BASIC" => ";",
		"COMMENTS" => "remove_comments" 
		),
	"postgres" => array( "LABEL" => "PostgreSQL 7.x",
		"SCHEMA" => "pafiledb_postgres",
		"UPDATE008" => "update_008_009c",
		"UPDATE009A" => "update_009a_009c",
		"UPDATE009B" => "update_009b_009c",
		"UPDATE009DMX10" => "update_009d_mx10",
		"UPDATE009DMX201" => "update_009d_mx201",
		"DELIM" => ";",
		"DELIM_BASIC" => ";",
		"COMMENTS" => "remove_comments" 
		) 
	);

if ( isset( $_REQUEST['action'] ) )
{
	if ( $_REQUEST['action'] == 'install' )
	{
		$dbms_file = $available_dbms[$dbms]['SCHEMA'] . '.sql';
	}
	elseif ( $_REQUEST['action'] == 'update008' )
	{
		$dbms_file = $available_dbms[$dbms]['UPDATE0008'] . '.sql';
	}
	elseif ( $_REQUEST['action'] == 'update009a' )
	{
		$dbms_file = $available_dbms[$dbms]['UPDATE009A'] . '.sql';
	}
	elseif ( $_REQUEST['action'] == 'update009b' )
	{
		$dbms_file = $available_dbms[$dbms]['UPDATE009B'] . '.sql';
	}
	elseif ( $_REQUEST['action'] == 'update009d_mx10' )
	{
		$dbms_file = $available_dbms[$dbms]['UPDATE009DMX10'] . '.sql';
	}
	elseif ( $_REQUEST['action'] == 'update009d_mx201' )
	{
		$dbms_file = $available_dbms[$dbms]['UPDATE009DMX201'] . '.sql';
	}
	else
	{
		die( 'INVALID ACTION' );
	}

	$remove_remarks = $available_dbms[$dbms]['COMMENTS'];;
	$delimiter = $available_dbms[$dbms]['DELIM'];
	$delimiter_basic = $available_dbms[$dbms]['DELIM_BASIC'];

	if ( !( $fp = @fopen( $dbms_file, 'r' ) ) )
	{
		message_die( GENERAL_MESSAGE, "Can't open " . $dbms_file );
	}

	fclose( $fp ); 
	
	// process db schema & basic
	
	$sql_query = @fread( @fopen( $dbms_file, 'r' ), @filesize( $dbms_file ) );
	$sql_query = preg_replace( '/phpbb_/', $table_prefix, $sql_query );

	$sql_query = $remove_remarks( $sql_query );
	$sql_query = split_sql_file( $sql_query, $delimiter );

	$sql_count = count( $sql_query );

	for( $i = 0; $i < $sql_count; $i++ )
	{
		echo "Running :: " . $sql_query[$i];
		@flush();

		if ( !( $result = $db->sql_query( $sql_query[$i] ) ) )
		{
			$errored = true;
			$error = $db->sql_error();
			echo " -> <b>FAILED</b> ---> <u>" . $error['message'] . "</u><br /><br />\n\n";
		}
		else
		{
			echo " -> <b><span class=\"ok\">COMPLETED</span></b><br /><br />\n\n";
		}
	}

	$message = '';

	if ( $errored )
	{
		$message .= '<br />Some queries failed. Please contact me at <a href="http://www.mx-system.com">www.mx-system.com</a> we may solve your problems...';
	}
	else
	{
		$message .= '<br />Pafiledb Tables generated successfully.';
	}

	echo "\n<br />\n<b>COMPLETE!</b><br />\n";
	echo $message . "<br />";
	echo "<br /><b>NOW DELETE THIS FILE</b><br />\n";
}
else
{
	echo '<center>
	<b><a href="pafiledb_installer.php?action=install">New Installation</a></b><br />
	<b><a href="pafiledb_installer.php?action=update008">Update From pafiledb 0.0.8</a></b><br />
	<b><a href="pafiledb_installer.php?action=update009a">Update From pafiledb 0.0.9a</a></b><br />
	<b><a href="pafiledb_installer.php?action=update009b">Update From pafiledb 0.0.9b</a></b><br />
	<b><a href="pafiledb_installer.php?action=update009d_mx10">Update From pafiledb 0.0.9d</a></b>
	<b><a href="pafiledb_installer.php?action=update009d_mx201">Update From pafiledb 0.0.9d + mxaddon 1.0.3</a></b>
	</center>';
}

echo "</body>";
echo "</html>";

?>

--- NEW FILE: update_0.0.8_0.0.9b.txt ---
############################################################## 
## MOD Title: pafiledb integration
## MOD Version: 0.0.9a
## MOD Author: squall < moh...@ya... > (Mohammed Al-Basri) www.mohd.tk 
##	       MJ < mj...@ph... > www.phpbbfm.com
## MOD Description: Integration of pafiledb (Database download manager) with phpbb.
##                  pafiledb use header, footer, session, template, and database system
##		    of phpbb.
##			Only for phpBB 2.0.4!
## 
## Installation Level: (easy) 
## Installation Time: 10-15 Minutes 
## Files To Edit (10) : admin/index.php
##			includes/constant.php
##		       admin/admin_db_utilities.php
##		       includes/page_header.php, 
##                     language/lang_english/lang_main.php,
##                     templates/subSilver/admin/page_header.tpl,
##                     templates/subSilver/overall_header.tpl,
##		       templates/subSilver/subSilver.cfg
##
## Included Files:     dload.php,
##		       admin/admin_pa_catauth.php
##		       admin/admin_pa_category.php,
##		       admin/admin_pa_custom.php,
##		       admin/admin_pa_file.php,
##		       admin/admin_pa_license.php,
##		       admin/admin_pa_settings.php,
##		       language/*/lang_admin_pafiledb.php
##		       language/*/lang_pafiledb.php
##		       pafiledb/*.*,
##		       templates/subSilver/pa_*.tpl ( 18 )
##		       templates/subSilver/admin/pa_*.tpl ( 19 )
##		       templates/subSilver/images/icon_mini_download.gif
##		       templates/subSilver/images/lang_english/icon_pa_*.gif ( 9 )
##
##
############################################################## 
############################################################## 
## For Security Purposes, Please Check: http://www.phpbb.com/mods/downloads/ for the 
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code 
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered 
## in our MOD-Database, located at: http://www.phpbb.com/mods/downloads/ 
############################################################## 
############################################################## 
## Author Note: 
## follow all the instruction below first then upload and run from your browser, 
## pafiledb/docs/pafiledb_installer.php (choose update from 0.0.8) and if you have the table already installed, 
## you won't need to change anything in them except that you won't need the admin table 
## since you are going to use ACP. 
##
## Create and CHMOD (0777) THE FOLLOWING DIRECTORIES:
## - pafiledb/uploads/
## - pafiledb/cache/
## - pafiledb/cache/file_size
## - pafiledb/cache/templates/subSilver/
## - pafiledb/cache/templates/subSilver/admin
## - pafiledb/explain
##	
##
## Change History:
##	0.0.9 : ADD/Fixed:
##		- THE WHOLE MOD IS RE WRITIEN 
##		- ADDED ALOT OF FEATURE
##		- FIXING ALOT OF SECURITY BUGS
##	0.0.8 : Added/Fixed:
##		- Fixed the global varaible problem. (you don't have to set global var to on)
##		- Changed the whole coding structure in all file.
##		- Comment viewing like the viewtopic.
##		- Added the file checker feature (beware if this one or you will end up erasing all file.)
##		- Changed some images and included them into templates/*/images/ folder.
##		- Main Templates cleaned up, added clickable folder icons.
##		- Fixed bug with category sort feature.
##		- Added edit download count when editing file.
##		- Added Dutch, German and Italian language support .
##
##	0.0.7 : Added/Fixed:
##		- Fixed bug with screen shot upload.
##		- Fixed bug with templates in ACP.
##		- Removed Variable $str found in search.php.
##		- Changed directory for images and icons.
##		- Changed all url and action to append_sid.
##
##	0.0.6 : Added/Fixed:
##		- Backupdb & restore to phpBB forum backup style
##		- Changed tables to phpbb style
##		- Show screenshots as image instead of link. (you may choose now either links or image).
##		- Long Description - Multiple line text area.
##		- Replaced pafiledb language with phpbb.
##		- Unlimited subCategories.
##		- Added Upload Screenshot feature (there is a small bugs on it)
##		- Added Disable "View All" link
##		- Added Disable Database feature
##		- comment feature (only registered users can post)
##		- Email is using phpBB class emailer.
##		- New File indicator you can now set the number of day to show that the file is new
##		- Added toplist file (you can now specify number of file that in toplist.
##		- Removed the following bugs:
##			* Replaced pafiledb Time Zone with phpbb.
##			* Replaced pafiledb Language with phpbb.
##			* Email fields can be left blank, but confirmation of email sent is returned. 
##			* Custom Field data not reading from db
##			* Time on posted comment
##			* Edit file (ACP), sub-cats & files not showing
##			* Backup Database screwed
##			* removing some un needed row from setting table like language and style.
##			* fixing the problem of jumpmenu fix in pafiledb.php file because file send the $str instead of $lang
##			* 'Comment Explain' text missing
##			* Title on posted comment
##			* max_comment_chars field in _settings table missing
##			* Javascript error when posting or previewing comment
##			* Email not actually sending to address ??? (Not for me anyway!)
##			* Time on file page
##
##	0.0.5 : - Re-packing of all working files
##     	 	- Changed paFileDB_installer.php
##
## 	0.0.4 : Fixed:
## 		- {dbname} showing in the email instead of the variable that should replace it.
## 		- Uploaded file not returning full URL.
## 		- Replaced pafiledb Time Zone with phpbb.
## 		- Email fields can be left blank, but confirmation of email sent is returned 
## 		- Fixed sort for viewall.. (sort according to rating not yet due to php version) 
## 		- Custom Field data not reading from db		
## 		- Added support for view online when some one in download page.
##
##	0.0.3 : - Fixed the editing file bug in ACP
##		- Fixed the the file in sub category bug.
##		- Fixed the uploading file url bug when uploading
##		- Changed message after rating or e-mail sending
##		- Made copywrite with phpbb copywrite only if you are in download database
##
##	0.0.2 : All templates made to fit phpBB default, clean up of code. 
##
## 	0.0.1 : First release, I need just to modify the *.tpl file in admin 
## 		section.
## 
##############################################################  
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
############################################################## 
# 
#-----[ COPY ]------------------------------------------ 
# 
copy dload.php to root 
copy admin/*.php to admin/ 
copy templates/subSilver/*.tpl to templates/subSilver/ 
copy templates/subSilver/admin/*.tpl to templates/subSilver/admin/
copy pafiledb/*.* to pafiledb/
copy language/lang_english/* to language/lang_english/*

# 
#-----[ SQL ]------------------------------------------ 
# 
run pafiledb/docs/pafiledb_installer.php or update.sql

# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/constants.php

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

define('PA_CATEGORY_TABLE', $table_prefix.'pa_cat');
define('PA_COMMENTS_TABLE', $table_prefix.'pa_comments');
define('PA_CUSTOM_TABLE', $table_prefix.'pa_custom');
define('PA_CUSTOM_DATA_TABLE', $table_prefix.'pa_customdata');
define('PA_FILES_TABLE', $table_prefix.'pa_files');
define('PA_LICENSE_TABLE', $table_prefix.'pa_license');
define('PA_SETTINGS_TABLE', $table_prefix.'pa_settings');
define('PA_VOTES_TABLE', $table_prefix.'pa_votes');

# 
#-----[ REPLACE, WITH ]------------------------------------------ 
#  

//REMOVED


# 
#-----[ OPEN ]------------------------------------------ 
# 
admin/index.php
# 
#-----[ FIND ]------------------------------------------ 
# 
//
// pafiledb
//
include_once($phpbb_root_path . 'pafiledb/includes/functions.' . $phpEx); 
$config = pafiledb_config();
include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin_pafiledb.' . $phpEx);
# 
#-----[ REPLACE, WITH ]------------------------------------------ 
#  

include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin_pafiledb.' . $phpEx);

# 
#-----[ OPEN ]------------------------------------------ 
# 
admin/admin_db_utilities.php
# 
#-----[ FIND ]------------------------------------------ 
# 
	include('./page_footer_admin.'.$phpEx);
}
$tables = array('auth_access', 'banlist', 'categories'....

# 
#-----[ FIND IN LINE ]------------------------------------------ 
# 
'pa_cat', 'pa_comments', 'pa_custom', 'pa_customdata', 'pa_files', 'pa_license', 'pa_settings', 'pa_votes', 

# 
#-----[ REPLACE, WITH ]------------------------------------------ 
# 
'pa_cat', 'pa_comments', 'pa_custom', 'pa_customdata', 'pa_files', 'pa_license', 'pa_config', 'pa_votes', 'pa_download_info',


# 
#-----[ OPEN ]------------------------------------------ 
# 
templates/subSilver/overall_header.tpl

# 
#-----[ FIND ]------------------------------------------ 
#  
<script language="JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>
<SCRIPT LANGUAGE="JavaScript"> 
<!-- 
function mpFoto(img){ 
foto1= new Image(); 
foto1.src=(img); 
mpControl(img); 
} 
function mpControl(img){ 
if((foto1.width!=0)&&(foto1.height!=0)){ 
viewFoto(img); 
} 
else{ 
mpFunc="mpControl('"+img+"')"; 
intervallo=setTimeout(mpFunc,20); 
} 
} 
function viewFoto(img){ 
largh=foto1.width+20; 
altez=foto1.height+20; 
string="width="+largh+",height="+altez; 
finestra=window.open(img,"",string); 
} 
//--> 
</script> 
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
<!-- removed --!>

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

includes/page_tail.php

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

if ( defined('IN_DOWNLOAD') )
{
   $template->assign_block_vars("pa_copy", array());	
}

# 
#-----[ REPLACE, WITH ]------------------------------------------ 
# 

// Removed
# 
#-----[ OPEN ]------------------------------------------ 
#

templates/subSilver/overall_footer.tpl

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

<!-- BEGIN pa_copy -->
& <a href="http://www.phparena.net/" target="_phparena" class="copyright">PHP Arena</a> paFileDB 3.1 &copy; 2002, 2003
<!-- END pa_copy -->

# 
#-----[ REPLACE, WITH ]------------------------------------------ 
# 

<!-- removed -->

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

templates/subSilver/subSilver.cfg

# 
#-----[ FIND ]------------------------------------------ 
# 
$images['pa_search'] = "$current_template_images/{LANG}/icon_pa_search.gif";
$images['pa_stats'] = "$current_template_images/{LANG}/icon_pa_stats.gif";
$images['pa_toplist'] = "$current_template_images/{LANG}/icon_pa_toplist.gif";
$images['pa_download'] = "$current_template_images/icon_pa_download.gif";
$images['pa_rate'] = "$current_template_images/icon_pa_rate.gif";
$images['pa_email'] = "$current_template_images/icon_pa_email.gif";

# 
#-----[ REPLACE, WITH ]------------------------------------------ 
# 
$images['pa_search'] = "$current_template_images/{LANG}/icon_pa_search.gif";
$images['pa_stats'] = "$current_template_images/{LANG}/icon_pa_stats.gif";
$images['pa_toplist'] = "$current_template_images/{LANG}/icon_pa_toplist.gif";
$images['pa_upload'] = "$current_template_images/{LANG}/icon_pa_upload.gif";
$images['pa_viewall'] = "$current_template_images/{LANG}/icon_pa_viewall.gif";
$images['pa_download'] = "$current_template_images/{LANG}/icon_pa_download.gif";
$images['pa_rate'] = "$current_template_images/{LANG}/icon_pa_rate.gif";
$images['pa_email'] = "$current_template_images/{LANG}/icon_pa_email.gif";
$images['pa_comment_post'] = "$current_template_images/{LANG}/icon_pa_post_comment.gif";
$images['pa_file_new'] = "$current_template_images/icon_pa_new.gif";


# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM  
--- NEW FILE: pafiledb_mysql.sql ---
# phpMyAdmin MySQL-Dump
# version 2.3.0-rc2
# http://phpwizard.net/phpMyAdmin/
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Jul 05, 2003 at 08:14 PM
# Server version: 4.00.01
# PHP Version: 4.2.2
# Database : `main`
# --------------------------------------------------------

#
# Table structure for table `phpbb_pa_cat`
#

CREATE TABLE phpbb_pa_cat (
  cat_id int(10) NOT NULL auto_increment,
  cat_name text,
  cat_desc text,
  cat_parent int(50) default NULL,
  parents_data text NOT NULL,
  cat_order int(50) default NULL,
  cat_allow_file tinyint(2) NOT NULL default '0',
  cat_allow_ratings tinyint(2) NOT NULL default '1',
  cat_allow_comments tinyint(2) NOT NULL default '1',
  cat_files mediumint(8) NOT NULL default '-1',
  cat_last_file_id mediumint(8) unsigned NOT NULL default '0',
  cat_last_file_name varchar(255) NOT NULL default '',
  cat_last_file_time INT(50) UNSIGNED DEFAULT '0' NOT NULL,
  auth_view tinyint(2) NOT NULL default '0',
  auth_read tinyint(2) NOT NULL default '0',
  auth_view_file tinyint(2) NOT NULL default '0',
  auth_edit_file tinyint(2) DEFAULT '0' NOT NULL,
  auth_delete_file tinyint(2) DEFAULT '0' NOT NULL,
  auth_upload tinyint(2) NOT NULL default '0',
  auth_download tinyint(2) NOT NULL default '0',
  auth_rate tinyint(2) NOT NULL default '0',
  auth_email tinyint(2) NOT NULL default '0',
  auth_view_comment tinyint(2) NOT NULL default '0',
  auth_post_comment tinyint(2) NOT NULL default '0',
  auth_edit_comment tinyint(2) NOT NULL default '0',
  auth_delete_comment tinyint(2) NOT NULL default '0',
  auth_approval tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (cat_id)
) TYPE=MyISAM;

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

INSERT INTO phpbb_pa_cat VALUES (1, 'My Category', '', 0, '', 1, 0, 1, 1, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO phpbb_pa_cat VALUES (2, 'Test Cagegory', 'Just a test category', 1, '', 2, 1, 1, 1, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);


CREATE TABLE phpbb_pa_auth (
   group_id mediumint(8) DEFAULT '0' NOT NULL,
   cat_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
   auth_view tinyint(1) DEFAULT '0' NOT NULL,
   auth_read tinyint(1) DEFAULT '0' NOT NULL,
   auth_view_file tinyint(1) DEFAULT '0' NOT NULL,
   auth_edit_file tinyint(1) DEFAULT '0' NOT NULL,
   auth_delete_file tinyint(1) DEFAULT '0' NOT NULL,
   auth_upload tinyint(1) DEFAULT '0' NOT NULL,
   auth_download tinyint(1) DEFAULT '0' NOT NULL,
   auth_rate tinyint(1) DEFAULT '0' NOT NULL,
   auth_email tinyint(1) DEFAULT '0' NOT NULL,
   auth_view_comment tinyint(1) DEFAULT '0' NOT NULL,
   auth_post_comment tinyint(1) DEFAULT '0' NOT NULL,
   auth_edit_comment tinyint(1) DEFAULT '0' NOT NULL,
   auth_delete_comment tinyint(1) DEFAULT '0' NOT NULL,
   auth_approval tinyint(1) DEFAULT '0' NOT NULL,
   auth_mod tinyint(1) DEFAULT '0' NOT NULL,
   auth_search tinyint(1) DEFAULT '1' NOT NULL,
   auth_stats tinyint(1) DEFAULT '1' NOT NULL,
   auth_toplist tinyint(1) DEFAULT '1' NOT NULL,
   auth_viewall tinyint(1) DEFAULT '1' NOT NULL,
   KEY group_id (grou...
 
[truncated message content]