Dynamic Sig stopped working after phpbb2.08 upgrade

gsicard · Posted: Tue Jul 27, 2004 8:33 am

Hey all,
My dynamic signature stopped working after I did the 2.08 forum upgrade. I now have the 2.10 installed and still the dynamic sig does not work. Was there a code change or something. Here is my signature.php

Code:

<?php

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

$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() - 3600 ) . "
$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'];
}
}

$image = "images/signature.png";
$im = imagecreatefrompng($image);
$tc = ImageColorAllocate ($im, 0, 0, 0);
$red = ImageColorAllocate ($im, 255, 0, 0);
$version = '2'.$board_config['version'];
$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, "Statistics for $sitename", $tc);
ImageString($im, 2, 148, 15, "phpBB Version: $version", $tc);
ImageString($im, 2, 148, 25, "Members: $total_users - ", $tc);
ImageString($im, 2, $leerzeichen, 25, "Online: $logged_online", $red);
ImageString($im, 2, 148, 35, "Total Posts: $total_posts Posts in $total_topics Topics", $tc);
ImageString($im, 2, 148, 45, "Newest Member: $newest_user", $tc);
header("Content-Type: image/png");
Imagepng($im,'',100);
ImageDestroy ($im);
?>

Gary

Only registered users can see links on this board!
Get registered or login to the forums!

chatserv · Posted: Tue Jul 27, 2004 9:40 am

Where can i get this mod to test it?

gsicard · Posted: Tue Jul 27, 2004 11:33 am

Hi Chatserv,
There is a file called signature.png in my /images folder. It is the graphic for the signature background.

The code above it the one I had to pull the info onto the graphic. Not sure where I got the code from.. There is a thread about it

Only registered users can see links on this board!
Get registered or login to the forums!

.

Your access info is still the same. I'll pm it to you just in case.

Only registered users can see links on this board!
Get registered or login to the forums!

Gary

tix · Hangin' Around Joined: Jun 05, 2004 Posts: 41

if the image is calles as .php file phpbb 2.08 doesnt accept it.

PhpBB 2.08 changes wrote:

Limited allowed images in img bbcode tag to jpg, jpeg, gif and png

If it is a .jpg Chat should look it
If it is what i said you could easily use the rewrite function by apache.
Just place an .htacces file in the directory that contains

Code:

RewriteEngine on
RewriteRule ^signature.gif /signature.php
RewriteRule ^signature.jpg /signature.php

chatserv · Posted: Wed Jul 28, 2004 12:01 am

I believe tix is correct, the phpBB group hardened the image filter in 2.0.8 because of an attack that placed a broken image in forum posts and private messages that when viewed by the forum admin would execute arbitrary code.

GanjaUK · Posted: Wed Jul 28, 2004 6:27 am

I noticed my dynamic signature broke ages ago when I upgraded to 2.0.8 so all I did was add a Mod Rewrite to my .htaccess file and problem solved.

Add this to a .htaccess in your nuke route (assuming your server supports .htaccess):

Code:

#Signature
RewriteRule ^signature.png signature.php

Now just change your signature extension in all forums to .png

edit: Just noticed what tix wrote. Laughing

Still waking up...

gsicard · Posted: Wed Jul 28, 2004 9:18 am

Thanks all - I have placed the RewriteRule in my htaccess and now will try to get the sig to work. All the best.

Gary

dean · Worker Joined: Apr 14, 2004 Posts: 193

Added rewrite rules as suggested and changed extension of signature.php to png in my profile. Does it work?

EDIT: Yes it works here but not on my own site?

shotokan · Worker Joined: Aug 27, 2006 Posts: 172

I was having exactly the same issue and the fixing did the trick. Thank you guys.