Pitäisi lisätä muutama table sinne mutten muista miten se tehtiinkään, olen
sen joskus tehnyt mutta siitö on aikaa...
Laitan asennusohjeen tähän luettavaksi
Koodi: Valitse kaikki
##############################################################
## 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.55
##
## 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
##
##############################################################
## 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.55');
#
#-----[ 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";
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";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not delete album 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 /> </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>
#
#-----[ 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