phpBB.de

Code: Alles auswählen

$phpbb_root_path = './'; 

Code: Alles auswählen

$phpbb_root_path = '../'; 

Code: Alles auswählen

$image = "images/signature.png"; 

Code: Alles auswählen

$image = "../images/signature.png"; 

Code: Alles auswählen

[img]http://www.YOURSITE.com/FORUM/sig.gif[/img] 

Code: Alles auswählen

<?php

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

// Get basic (usernames + totals) online
// situation
//
$user_forum_sql = ( !empty($forum_id) ) ? "AND s.session_page = " . intval($forum_id) : '';
$sql = "SELECT u.username, u.user_id, s.session_logged_in, s.session_ip
	FROM ".USERS_TABLE." u, ".SESSIONS_TABLE." s
	WHERE u.user_id = s.session_user_id
		AND s.session_time >= ".( time() - 300 ) . "
		$user_forum_sql
	ORDER BY u.username ASC, s.session_ip ASC";
if( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Could not obtain user/online information', '', __LINE__, __FILE__, $sql);
}

$logged_online = 0;
$prev_user_id = 0;

while( $row = $db->sql_fetchrow($result) )
{
	// User is logged in and therefor not a guest
	if ( $row['session_logged_in'] )
	{
		// Skip multiple sessions for one user
		if ( $row['user_id'] != $prev_user_id )
		{
				$logged_online++;
		}

		$prev_user_id = $row['user_id'];
	}
}

$sql = 'SELECT max(topic_id)
FROM ' . TOPICS_TABLE;

if ( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Couldn\'t retrieve max of Topic_id data', '', __LINE__, __FILE__, $sql);
}

while ( $row = $db->sql_fetchrow($result))
{
	$max_topic_id = $row['max(topic_id)'];
}
$sql = 'SELECT topic_title
FROM ' . TOPICS_TABLE . '
WHERE topic_id = ' . $max_topic_id;

if ( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Couldn\'t retrieve Topic_id data', '', __LINE__, __FILE__, $sql);
}

while ( $row = $db->sql_fetchrow($result))
{
	$latest_topic = $row['topic_title'];
}

$image = "images/signature.png";
$im = imagecreatefrompng($image);
$tc  = ImageColorAllocate ($im, 176, 176, 176);
$red  = ImageColorAllocate ($im, 225, 0, 0);
$white  = ImageColorAllocate ($im, 225, 225, 225);
$sitename = $board_config['sitename'];
$total_users = get_db_stat('usercount');
$total_posts = get_db_stat('postcount');
$total_topics = get_db_stat('topiccount');
$j = strlen($total_users);
$leerzeichen = $j*6+237;
$newest_userdata = get_db_stat('newestuser');
$newest_user = $newest_userdata['username'];
ImageString($im, 3, 148, 2, "Forum Statistik @", $tc);
ImageString($im, 3, 278, 2, "$sitename", $white);
ImageString($im, 2, 148, 15, "Mitglieder: $total_users - ", $tc);
ImageString($im, 2, $leerzeichen, 15, "Online: $logged_online", $red);
ImageString($im, 2, 148, 25, "Letztes Thema:", $tc);
ImageString($im, 2, 238, 25, "$latest_topic", $white);
ImageString($im, 2, 148, 35, "Gepostet: $total_posts Beiträge in $total_topics Themen", $tc);
ImageString($im, 2, 148, 45, "Unser neuestes Mitglied:", $tc);
ImageString($im, 2, 298, 45, "$newest_user", $white);
header("Content-Type: image/png");
Imagepng($im,'',100);
ImageDestroy ($im);
?>

Code: Alles auswählen

ImageString($im, 2, 148, 25, "Letztes Thema:", $tc);
ImageString($im, 2, 238, 25, "$latest_topic", $white);

Code: Alles auswählen

#
#-----[ OPEN ]------------------------------------------
#
signature.php

#
#-----[ FIND ]------------------------------------------
#
$sql = 'SELECT max(topic_id) 
FROM ' . TOPICS_TABLE; 

if ( !($result = $db->sql_query($sql)) ) 
{ 
   message_die(GENERAL_ERROR, 'Couldn\'t retrieve max of Topic_id data', '', __LINE__, __FILE__, $sql); 
} 

while ( $row = $db->sql_fetchrow($result)) 
{ 
   $max_topic_id = $row['max(topic_id)']; 
} 
$sql = 'SELECT topic_title 
FROM ' . TOPICS_TABLE . ' 
WHERE topic_id = ' . $max_topic_id; 

if ( !($result = $db->sql_query($sql)) ) 
{ 
   message_die(GENERAL_ERROR, 'Couldn\'t retrieve Topic_id data', '', __LINE__, __FILE__, $sql); 
} 

while ( $row = $db->sql_fetchrow($result)) 
{ 
   $latest_topic = $row['topic_title']; 
} 

#
#-----[ REPLACE WITH ]------------------------------------------
#
$sql = "SELECT t.topic_title, p.post_time
	FROM " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p
	LEFT JOIN " . FORUMS_TABLE . " f
	ON t.forum_id = f.forum_id
	WHERE p.post_id = t.topic_last_post_id
	AND f.auth_view < 2
	ORDER BY t.topic_last_post_id DESC LIMIT 0,1";
if ( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Couldn\'t retrieve Topic_id data', '', __LINE__, __FILE__, $sql);
}
while ( $row = $db->sql_fetchrow($result))
{
	$latest_topic = $row['topic_title'];
}

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