phpBB España Oficial

Código: Seleccionar todo

##############################################################
## MOD Title: Photo Album v2 for phpBB2
## MOD Author: Smartor < smartor_xp@hotmail.com > (Hoang Ngoc Tu) http://smartor.is-root.com
## MOD Description: This is a phpBB-based photo album/gallery management system. It is really powerful, stable, efficient, rich features and highly customizable. The version 2 was written from the scratch for more security, performance, etc. It is not really a MOD/hack, it is rather a phpBB-based system :)
## MOD Version: 2.0.56
## 
## Installation Level: Intermediate
## Installation Time: 14 minutes
## Files To Edit: admin/admin_users.php
##                includes/constants.php
##                includes/page_header.php
##                viewonline.php
##                admin/index.php
##                templates/subSilver/overall_header.tpl
##                templates/subSilver/subSilver.cfg
##                includes/usercp_viewprofile.php
##                templates/subSilver/profile_view_body.tpl
##                language/lang_english/lang_main.php
## Included Files: phpbb_root/*.php
##                 phpbb_root/admin/*.php
##                 phpbb_root/album_mod/*.*
##                 phpbb_root/language/lang_english/*.php
##                 phpbb_root/templates/subSilver/*.*
##                 phpbb_root/templates/subSilver/admin/*.*
##                 phpbb_root/templates/subSilver/images/*.*
##                 phpbb_root/templates/subSilver/images/lang_english/*.*
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2
## Generator: Phpbb.ModTeam.Tools
##############################################################
## For security purposes, please check: http://www.phpbb.com/mods/
## for the latest version of this MOD. Although MODs are checked
## before being allowed in the MODs Database there is no guarantee
## that there are no security problems within the MOD. No support
## will be given for MODs not found within the MODs Database which
## can be found at http://www.phpbb.com/mods/
##############################################################
## Author Notes: Features:
## - Fully integrated with phpBB2 backend (DB, session, template, multi languages, etc.)
## - Powerful and handy AdminCP
## - Auto-generated thumbnail (require GD)
## - Manual-uploaded thumbnail (for someone cannot install GD)
## - Thumbnail cache (for better performance)
## - Multi-categories
## - Powerfull and phpBB-like permissions system
## - ModeratorCP
## - Upload Quota
## - Pic Description
## - Recent pics
## - Personal galleries (for member-oriented boards)
## - Rate system
## - Comment system
## - Hotlink prevention (can set allowed domains)
## - Auto optimization for different GD versions
## - Pic view counter
## - Admin/Moderator pic approval
## - Probably uploadable in PHP Safe Mode
## - The rest is for your exploring ;)
## Requirements:
## A running phpBB 2.0.x (of course - recommend the lastest version)
## GD 1.8.x - 2.0 or higher (require for auto-thumbnail - more detail at http://www.boutell.com/gd)
## HTTP File Upload Enabled (this MOD can work with PHP Safe-Mode in some cases)
## MySQL 3.23.x or better
## A basic ability to follow my instructions (read this file carefully by letter and follow step-by-step)
## 
## Tested with:
## phpBB 2.0.4 - PHP 4 (I recommend the up-to-date version) - MySQL 3.23.x
## phpBB 2.0.20 - PHP 4.11 - MySQL 3.23.49
## phpBB 2.0.21 - PHP 5.1.4 - MySQL 5.0.21
## phpBB 2.0.22 - PHP 5.1.4 - MySQL 5.0.21
## 
##############################################################
## MOD History:
## 
##  See changelog.txt in the docs-subdir
## 
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
##############################################################

#
#-----[ COPY ]------------------------------------------
#
copy phpbb_root/*.php to *.php
copy phpbb_root/admin/*.php to admin/*.php
copy phpbb_root/album_mod/*.* to album_mod/*.*
copy phpbb_root/language/lang_english/*.php to language/lang_english/*.php
copy phpbb_root/templates/subSilver/*.* to templates/subSilver/*.*
copy phpbb_root/templates/subSilver/admin/*.* to templates/subSilver/admin/*.*
copy phpbb_root/templates/subSilver/images/*.* to templates/subSilver/images/*.*
copy phpbb_root/templates/subSilver/images/lang_english/*.* to templates/subSilver/images/lang_english/*.*
#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE phpbb_album (
	pic_id int(11) UNSIGNED NOT NULL auto_increment,
	pic_filename varchar(255) NOT NULL,
	pic_thumbnail varchar(255),
	pic_title varchar(255) NOT NULL,
	pic_desc text,
	pic_user_id mediumint(8) NOT NULL,
	pic_username varchar(32),
	pic_user_ip char(8) NOT NULL DEFAULT '0',
	pic_time int(11) UNSIGNED NOT NULL,
	pic_cat_id mediumint(8) UNSIGNED NOT NULL DEFAULT '1',
	pic_view_count int(11) UNSIGNED NOT NULL DEFAULT '0',
	pic_lock tinyint(3) NOT NULL DEFAULT '0',
	pic_approval tinyint(3) NOT NULL DEFAULT '1',
	PRIMARY KEY (pic_id),
	KEY pic_cat_id (pic_cat_id),
	KEY pic_user_id (pic_user_id),
	KEY pic_time (pic_time));

CREATE TABLE phpbb_album_rate (
	rate_pic_id int(11) UNSIGNED NOT NULL,
	rate_user_id mediumint(8) NOT NULL,
	rate_user_ip char(8) NOT NULL,
	rate_point tinyint(3) UNSIGNED NOT NULL,
	KEY rate_pic_id (rate_pic_id),
	KEY rate_user_id (rate_user_id),
	KEY rate_user_ip (rate_user_ip),
	KEY rate_point (rate_point));

CREATE TABLE phpbb_album_comment (
	comment_id int(11) UNSIGNED NOT NULL auto_increment,
	comment_pic_id int(11) UNSIGNED NOT NULL,
	comment_user_id mediumint(8) NOT NULL,
	comment_username varchar(32),
	comment_user_ip char(8) NOT NULL,
	comment_time int(11) UNSIGNED NOT NULL,
	comment_text TEXT,
	comment_edit_time int(11) UNSIGNED,
	comment_edit_count smallint(5) UNSIGNED NOT NULL DEFAULT '0',
	comment_edit_user_id mediumint(8),
	PRIMARY KEY(comment_id),
	KEY comment_pic_id (comment_pic_id),
	KEY comment_user_id (comment_user_id),
	KEY comment_user_ip (comment_user_ip),
	KEY comment_time (comment_time));

CREATE TABLE phpbb_album_cat (
	cat_id mediumint(8) UNSIGNED NOT NULL auto_increment,
	cat_title varchar(255) NOT NULL,
	cat_desc text,
	cat_order mediumint(8) NOT NULL,
	cat_view_level tinyint(3) NOT NULL DEFAULT '-1',
	cat_upload_level tinyint(3) NOT NULL DEFAULT '0',
	cat_rate_level tinyint(3) NOT NULL DEFAULT '0',
	cat_comment_level tinyint(3) NOT NULL DEFAULT '0',
	cat_edit_level tinyint(3) NOT NULL DEFAULT '0',
	cat_delete_level tinyint(3) NOT NULL DEFAULT '2',
	cat_view_groups varchar(255),
	cat_upload_groups varchar(255),
	cat_rate_groups varchar(255),
	cat_comment_groups varchar(255),
	cat_edit_groups varchar(255),
	cat_delete_groups varchar(255),
	cat_moderator_groups varchar(255),
	cat_approval tinyint(3) NOT NULL DEFAULT '0',
	PRIMARY KEY (cat_id),
	KEY cat_order (cat_order));

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

INSERT INTO phpbb_album_config VALUES ('max_pics', '1024');
INSERT INTO phpbb_album_config VALUES ('user_pics_limit', '50');
INSERT INTO phpbb_album_config VALUES ('mod_pics_limit', '250');
INSERT INTO phpbb_album_config VALUES ('max_file_size', '128000');
INSERT INTO phpbb_album_config VALUES ('max_width', '800');
INSERT INTO phpbb_album_config VALUES ('max_height', '600');
INSERT INTO phpbb_album_config VALUES ('rows_per_page', '3');
INSERT INTO phpbb_album_config VALUES ('cols_per_page', '4');
INSERT INTO phpbb_album_config VALUES ('fullpic_popup', '1');
INSERT INTO phpbb_album_config VALUES ('thumbnail_quality', '50');
INSERT INTO phpbb_album_config VALUES ('thumbnail_size', '125');
INSERT INTO phpbb_album_config VALUES ('thumbnail_cache', '1');
INSERT INTO phpbb_album_config VALUES ('sort_method', 'pic_time');
INSERT INTO phpbb_album_config VALUES ('sort_order', 'DESC');
INSERT INTO phpbb_album_config VALUES ('jpg_allowed', '1');
INSERT INTO phpbb_album_config VALUES ('png_allowed', '1');
INSERT INTO phpbb_album_config VALUES ('gif_allowed', '0');
INSERT INTO phpbb_album_config VALUES ('desc_length', '512');
INSERT INTO phpbb_album_config VALUES ('hotlink_prevent', '0');
INSERT INTO phpbb_album_config VALUES ('hotlink_allowed', 'smartor.is-root.com');
INSERT INTO phpbb_album_config VALUES ('personal_gallery', '0');
INSERT INTO phpbb_album_config VALUES ('personal_gallery_private', '0');
INSERT INTO phpbb_album_config VALUES ('personal_gallery_limit', '10');
INSERT INTO phpbb_album_config VALUES ('personal_gallery_view', '-1');
INSERT INTO phpbb_album_config VALUES ('rate', '1');
INSERT INTO phpbb_album_config VALUES ('rate_scale', '10');
INSERT INTO phpbb_album_config VALUES ('comment', '1');
INSERT INTO phpbb_album_config VALUES ('gd_version', '2');
INSERT INTO phpbb_album_config VALUES ('album_version', '.0.56');
#
#-----[ DIY INSTRUCTIONS ]------------------------------------------
#
Create folders:
album_mod/upload
album_mod/upload/cache

CHMOD 777 (with your FTP-client)
album_mod/upload
album_mod/upload/cache
#
#-----[ OPEN ]------------------------------------------
#
admin/admin_users.php
#
#-----[ FIND ]------------------------------------------
#
		if( $HTTP_POST_VARS['deleteuser'] && ( $userdata['user_id'] != $user_id ) )
		{
#
#-----[ AFTER, ADD ]------------------------------------------
#
	      $sql = "SELECT pic_filename, pic_thumbnail 
   	     	FROM " . ALBUM_TABLE . " 
	        	WHERE pic_user_id = $user_id
				  	AND pic_cat_id = 0"; 
   	   if( !($result = $db->sql_query($sql)) ) 
	      { 
   	     	message_die(GENERAL_ERROR, 'Could not obtain album information for this user', '', __LINE__, __FILE__, $sql); 
	      } 
	      while ($row = $db->sql_fetchrow($result)) 
   	   { 
	        	@unlink('../' . ALBUM_UPLOAD_PATH . $row['pic_filename']); 
   	     	@unlink('../' . ALBUM_CACHE_PATH . $row['pic_thumbnail']); 
      	} 
	      $sql = "DELETE 
   	     	FROM " . ALBUM_TABLE . " 
	        	WHERE pic_user_id = $user_id
			  		AND pic_cat_id = 0"; 
	      if( !($result = $db->sql_query($sql)) ) 
   	   { 
	        	message_die(GENERAL_ERROR, 'Could not delete album information for this user', '', __LINE__, __FILE__, $sql); 
   	   }

         $sql = "UPDATE " . ALBUM_TABLE . " 
				SET pic_user_id = -1               
         	WHERE pic_user_id = $user_id"; 
         if( !($result = $db->sql_query($sql)) ) 
         { 
            message_die(GENERAL_ERROR, 'Could not update album information for this user', '', __LINE__, __FILE__, $sql); 
         }
 
         $sql = "UPDATE " . ALBUM_COMMENT_TABLE . " 
				SET comment_user_id = -1               
         	WHERE comment_user_id = $user_id"; 
         if( !($result = $db->sql_query($sql)) ) 
         { 
            message_die(GENERAL_ERROR, 'Could not update album comment information for this user', '', __LINE__, __FILE__, $sql); 
         }
#
#-----[ OPEN ]------------------------------------------
#
includes/constants.php
#
#-----[ FIND ]------------------------------------------
#
if ( !defined('IN_PHPBB') )
{
	die("Hacking attempt");
}
#
#-----[ AFTER, ADD ]------------------------------------------
#
# No worries, this file is very lite.
// Album MOD
include($phpbb_root_path . 'album_mod/album_constants.' . $phpEx);
#
#-----[ OPEN ]------------------------------------------
#
includes/page_header.php
#
#-----[ FIND ]------------------------------------------
#
	'U_GROUP_CP' => append_sid('groupcp.'.$phpEx),
#
#-----[ AFTER, ADD ]------------------------------------------
#
	// Album MOD
	'L_ALBUM' => $lang['Album'],
	'U_ALBUM' => append_sid('album.'.$phpEx),
#
#-----[ OPEN ]------------------------------------------
#
viewonline.php
#
#-----[ FIND ]------------------------------------------
#
				case PAGE_FAQ:
					$location = $lang['Viewing_FAQ'];
					$location_url = "faq.$phpEx";
					break;
#
#-----[ AFTER, ADD ]------------------------------------------
#
				case PAGE_ALBUM:
					$location = $lang['Album'];
					$location_url = "album.$phpEx";
					break;
#
#-----[ OPEN ]------------------------------------------
#
admin/index.php
#
#-----[ FIND ]------------------------------------------
#
						case PAGE_FAQ:
							$location = $lang['Viewing_FAQ'];
							$location_url = "index.$phpEx?pane=right";
							break;
#
#-----[ AFTER, ADD ]------------------------------------------
#
						case PAGE_ALBUM:
							$location = $lang['Album'];
							$location_url = "index.$phpEx?pane=right";
							break;
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/overall_header.tpl
#
#-----[ FIND ]------------------------------------------
#
<td align="center" width="100%" valign="middle"><span class="maintitle">{SITENAME}</span><br /><span class="gen">{SITE_DESCRIPTION}<br />&nbsp; </span>
				<table cellspacing="0" cellpadding="2" border="0">
					<tr>
						<td align="center" valign="top" nowrap="nowrap"><span class="mainmenu">
#
#-----[ AFTER, ADD ]------------------------------------------
#
<a href="{U_ALBUM}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_album.gif" width="12" height="13" border="0" alt="{L_ALBUM}" hspace="3" />{L_ALBUM}</a>&nbsp;
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/subSilver.cfg
#
#-----[ FIND ]------------------------------------------
#
?>
#
#-----[ BEFORE, ADD ]------------------------------------------
#
// Album MOD
$images['upload_pic'] = "$current_template_images/{LANG}/upload_pic.gif";
$images['no_thumbnail'] = "$current_template_images/nothumbnail.jpg";
#
#-----[ OPEN ]------------------------------------------
#
includes/usercp_viewprofile.php
#
#-----[ FIND ]------------------------------------------
#
	'U_SEARCH_USER' => append_sid("search.$phpEx?search_author=" . $u_search_author),
#
#-----[ AFTER, ADD ]------------------------------------------
#
	// Photo Album Addon v2.x.x by Smartor
	'U_PERSONAL_GALLERY' => append_sid("album_personal.$phpEx?user_id=" . $profiledata['user_id']),
	'L_PERSONAL_GALLERY' => sprintf($lang['Personal_Gallery_Of_User'], $profiledata['username']),
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/profile_view_body.tpl
#
#-----[ FIND ]------------------------------------------
#
<td valign="top"><b><span class="gen">{POSTS}</span></b><br /><span class="genmed">[{POST_PERCENT_STATS} / {POST_DAY_STATS}]</span> <br /><span class="genmed"><a href="{U_SEARCH_USER}" class="genmed">{L_SEARCH_USER_POSTS}</a></span></td>
#
#-----[ IN-LINE FIND ]------------------------------------------
#
<a href="{U_SEARCH_USER}" class="genmed">{L_SEARCH_USER_POSTS}</a>
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
<br /><a href="{U_PERSONAL_GALLERY}" class="genmed">{L_PERSONAL_GALLERY}</a>
#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_main.php
#
#-----[ FIND ]------------------------------------------
#
//
// Errors (not related to a
// specific failure on a page)
//
$lang['Information'] = 'Information';
$lang['Critical_Information'] = 'Critical Information';
#
#-----[ BEFORE, ADD ]------------------------------------------
#
//
// Photo Album Addon v2.x.x by Smartor
//
$lang['Album'] = 'Album';
$lang['Personal_Gallery_Of_User'] = 'Personal Gallery of %s';
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM