Aktuelle Kommentare in Tabelle "Neuste Fotos" anze

[Perlenhimmel]

...

[Markus67]

Hi ...

versuchs mal mit dem hier

Code: Alles auswählen

##############################################################
## MOD Title: Full Album Pack Portal Block
## MOD Author: Mighty Gorgon < mightygorgon@mightygorgon.com > (Luca Libralato) http://www.mightygorgon.com/
## MOD Description: This MOD adds a block to ez Portal for showing last and random pic in Album
##									
## MOD Version: 1.0.1
## 
## Installation Level: Easy
## Installation Time: 5 minutes
## Files To Edit: (3)
##                portal.php
##                language/lang_english/lang_main.php
##                templates/subSilver/portal_body.tpl
##                
##############################################################
## For Security Purposes, Please Check: http://www.phpbb.com/mods/ 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/ 
##############################################################
## Author Notes:
## 
## N/A
## 
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
##############################################################
#
#-----[ OPEN ]------------------------------------------------
#
portal.php
#
#-----[ FIND ]------------------------------------------------
#
$page_title = $lang['Home'];
#
#-----[ AFTER, ADD ]------------------------------------------
#
// For pictures in personal galleries add
//				AND c.cat_user_id > 0

// Mighty Gorgon - Full Album Pack - BEGIN
// Newest Pic
$sql = "SELECT *
				FROM " . ALBUM_TABLE . " AS a, " . ALBUM_CAT_TABLE . " AS c
				WHERE c.cat_id = a.pic_cat_id
				AND c.cat_view_level = -1
				ORDER BY pic_time DESC LIMIT 1";

if (!$result = $db->sql_query($sql))
{
	message_die(GENERAL_ERROR, 'Could not query album information', '', __LINE__, __FILE__, $sql);
}

$newpicrow = $db->sql_fetchrow($result);

// Random Pic
$sql = "SELECT *
				FROM " . ALBUM_TABLE . " AS a, " . ALBUM_CAT_TABLE . " AS c
				WHERE c.cat_id = a.pic_cat_id
				AND c.cat_view_level = -1
				ORDER BY RAND() LIMIT 1";

if (!$result = $db->sql_query($sql))
{
	message_die(GENERAL_ERROR, 'Could not query album information', '', __LINE__, __FILE__, $sql);
}

$randpicrow = $db->sql_fetchrow($result);
// Mighty Gorgon - Full Album Pack - END
#
#-----[ FIND ]------------------------------------------------
#
	'L_VOTE_BUTTON' => $lang['Vote'],
#
#-----[ AFTER, ADD ]------------------------------------------
#
	// Mighty Gorgon - Full Album Pack - BEGIN
	'L_NEWEST_PIC' => $lang['Newest_pic'],
	'NEW_PIC_IMAGE' => append_sid('album_thumbnail.'. $phpEx . '?pic_id=' . $newpicrow['pic_id']),
	'NEW_PIC_TITLE' => $newpicrow['pic_title'],
	'NEW_PIC_DESC' => $newpicrow['pic_desc'],
	'NEW_PIC_POSTER' => $newpicrow['pic_username'],
	'U_NEW_PIC_LINK' => append_sid('album_showpage.' . $phpEx . '?pic_id=' . $newpicrow['pic_id']),
	'NEW_PIC_TIME' => create_date($board_config['default_dateformat'], $newpicrow['pic_time'], $board_config['board_timezone']),
	'L_RANDOM_PIC' => $lang['Random_pic'],
	'RANDOM_PIC_IMAGE' => append_sid('album_thumbnail.'. $phpEx . '?pic_id=' . $randpicrow['pic_id']),
	'RANDOM_PIC_TITLE' => $randpicrow['pic_title'],
	'RANDOM_PIC_DESC' => $randpicrow['pic_desc'],
	'RANDOM_PIC_POSTER' => $randpicrow['pic_username'],
	'U_RANDOM_PIC_LINK' => append_sid('album_showpage.' . $phpEx . '?pic_id=' . $randpicrow['pic_id']),
	'RANDOM_PIC_TIME' => create_date($board_config['default_dateformat'], $randpicrow['pic_time'], $board_config['board_timezone']),
	// Mighty Gorgon - Full Album Pack - END
#
#-----[ OPEN ]------------------------------------------------
#
#
#-----[ OPEN ]------------------------------------------------
#
language/lang_english/lang_main.php
#
#-----[ FIND ]------------------------------------------------
#
?>
#
#-----[ BEFORE, ADD ]-----------------------------------------
#
// Mighty Gorgon - Full Album Pack - BEGIN
$lang['Newest_pic'] = 'Last Pic'; // Album Addon
$lang['Random_pic'] = 'Random Pic'; // Album Addon
// Mighty Gorgon - Full Album Pack - END
#
#-----[ OPEN ]------------------------------------------------
#
templates/subSilver/portal_body.tpl
#
#-----[ FIND ]------------------------------------------------
#
		  <tr>
			<td class="row1" align="left"><span class="gensmall">{TOTAL_USERS}<br />{NEWEST_USER}<br /><br/>{TOTAL_POSTS} {TOTAL_TOPICS}<br />&nbsp;</span></td>
		  </tr>
#
#-----[ AFTER, ADD ]------------------------------------------
#
<!-- Mighty Gorgon - Full Album Pack - BEGIN -->
			<tr><td height="15"></td></tr>
			<tr><td><span class="cattitle">{L_NEWEST_PIC}</span></td></tr>
			<tr>
				<td class="row6b" align="center">
					<span class="gensmall" style="line-height:150%">
						<br />
						<b>{NEW_PIC_TITLE}</b>
						<br />
						<a href="{U_NEW_PIC_LINK}" target="_pic"><img src="{NEW_PIC_IMAGE}" border="0"></a>
						<br />
						<b>{NEW_PIC_POSTER}</b>
						<br />
						{NEW_PIC_TIME}
						<br />
					</span>
				</td>
			</tr>
			<tr><td height="15"></td></tr>
			<tr><td><span class="cattitle">{L_RANDOM_PIC}</span></td></tr>
			<tr>
				<td class="row6b" align="center">
					<span class="gensmall" style="line-height:150%">
						<br />
						<b>{RANDOM_PIC_TITLE}</b>
						<br />
						<a href="{U_RANDOM_PIC_LINK}" target="_pic"><img src="{RANDOM_PIC_IMAGE}" border="0"></a>
						<br />
						<b>{RANDOM_PIC_POSTER}</b>
						<br />
						{RANDOM_PIC_TIME}
						<br />
					</span>
				</td>
			</tr>
<!-- Mighty Gorgon - Full Album Pack - END -->
#
#-----[ SAVE/CLOSE ALL FILES ]--------------------------------
#
# EoM

Markus

[Perlenhimmel]

Hallo Markus!

Vielen Dank für deine rasche Antwort!

Nur das ist ja ein ganzer Mod...oder? Eigentlich möchte ich ja "nur" die Zeile "Kommentare:" und die "aktuelle Anzahl" der Kommentare anzeigen lassen!

Vielleicht hast du dazu auch eine gute Idee!

Danke nochmal recht herzlich für die Hilfe!

Lg Michael

[LOLRainbow]

Das passt schon. Bau das mal ein.

Da werden einmal die Relevanten Daten in der Datenbank ausgelesen, dann muss natürlich die Template-Datei angepasst werden, und das Sprach-File.

Timo

[Perlenhimmel]

...

[Markus67]

Hi ...

dann schau es dir doch einfach an wie es in dem anderen MOD gelöst ist .. dann musst du nur noch den mit dem letzten Foto entsprechend erweitern.

Markus

[Perlenhimmel]

Ja....das hab ich ja eh schon versucht....aber das funktioniert leider nicht!!!

[Perlenhimmel]

...

[Markus67]

Hi ...

du hast die Änderungen ja auch nur in der tpl-Datei gemacht ... das muss aber auch in der portal.php entsprechend geändert werden.

Eine reine Templatevariable nützt dir ja nichts ... die muss in der php-Datei erstmal gefüllt werden

Markus

[Perlenhimmel]

...