|
From: Jon O. <jon...@us...> - 2005-04-11 17:55:53
|
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"> <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> <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> <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> </span></td> </tr> # #-----[ AFTER, ADD ]------------------------------------------ # <tr> <td height="25" align="center" nowrap class="mainmenu" valign="top"> <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> </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 © 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 © 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] |