Signature Stats v3.04

VERSION 3.04
[05/09/2004]

-----------------------------------------------

This Hack is released under an EverythingvB.com FullAttribution-LimitedDerivs-LimitedTranslation License
-----------------------------------------------

This hack allows you to display your forum statistics in an image,whichyou can use as your signature in most forums (like mine).

If you have any trouble, please post here or in my forum for a good response. Please Click INSTALL, otherwise if an important fix becomes available, you will not be notified.

Now with truetype font support and line breaks. Fixed online userscode(was resetting 'most users online'). New easy support for GD2 andbelow.

Attached pixel font for use in your signatures, must be in all capitals, at size 6 to work appropriately.

New! Attached signature colourgenerator application. Useful to work out the colour scheme of yoursignature. Displays the RGB code for picked colour, and also allows forHEX to RGB conversion.

Popular modifications:

• Show newest user in Signature Stats
  https://vborg.vbsupport.ru/showpost.php?p=544875&postcount=245
  
  
• Amount of games in v3Arcade in signature
  https://vborg.vbsupport.ru/showpost....&postcount=225

If you are upgrading please carry out steps two to four of the instructions.

[DWard]

Originally Posted by bigreefer

Hmm the Online User-Counter counts not correct.
It shows 66 User Online but realy there are only 21 online.

Any Idea ?

Ps. the new verion did not run

Did not run (need some more info!)

I will look into the user count, I know it's slightly out, will take a look later today and release the fixed version.

[DWard]

Originally Posted by SaN-DeeP

i get this
Could not select database

When i run
www.yourdomain.com/forums/signature.php

what am i missing.

thnx for hack

Sandy...

Try the latest version to see if that works. Go pack to the first page, just updated to version 2.02.

Also the online user count is fixed.

[DWard]

Any feedback?

[bigreefer]

Sorry,

if i use the first Verion it runs without problems.
If I use the latest version i saw no Picture.



The FilePath and SQL login ist 100% the same as in the first Version.

[DWard]

Are you sure the filepaths are correct and you have CHMOD the files?

[DWard]

Try selecting the default font option in the code. You need to uncomment one line and comment the one below it.

[bigreefer]

Yes 100%

The Path the Pictures are ist alwas the Same.
If i upload the Version SIGNATURE STATS V1.01 the Sig runs without Probs.
If i upload the new Version i saw nothing.

SIGNATURE STATS V1.01

//full path to empty signature image (input image)
$vorlagedatei = "/var/www/web1/html/vB/signatur/sig2.jpg";

//full path to signare image with forum data (output image)
$ausgabedatei = "/var/www/web1/html/vB/signatur/sig1.jpg";

SIGNATURE STATS V2.01

//full path to empty signature image (input image)
$vorlagedatei = "/var/www/web1/html/vB/signatur/sig2.jpg";

//full path to signare image with forum data (output image)
$ausgabedatei = "/var/www/web1/html/vB/signatur/sig1.jpg";

Ps. kannst du auch deutsch und hast ICQ ?

[DWard]

Cant realy speak German, even though I have german family!

Is the database info correct and have u trued the different font option near the bottom of the script?

[bigreefer]

Originally Posted by DWard

Try selecting the default font option in the code. You need to uncomment one line and comment the one below it.

k, but no efect

DateBase Info 100% correct. Font near the buttom ist switched.

And now ?

The old Script runs :/

// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'sig_stats');

// ######################### REQUIRE BACK-END ############################
require_once('./global.php');

// #######################################################################
// ######################## START MAIN SCRIPT ############################
// #######################################################################

// #################### ENTER DATABASE INFORMATION #######################
//DB-Servername
$host = "localhost";

//DB-Username
$user= "web1";

//DB-Password
$password= "*********";

//vbulletin database name
$database="usr_web1_1";

//E-Mail Address where MySQL Error Messages are sent to
$adminemail = "admin@celebritymarkt.de";

// ###################### ENTER IMAGE INFORMATION #########################

//Width of banner image
$width = 300;

//Height of banner image
$height = 60;

//Left text-margin
$left = 13;

//text-margin from top
$top = 70;

//Font Size
$fontsize = 7;

//Line-spacing of text
$zeilenabstand = 15;

//full path to empty signature image (input image)
$vorlagedatei = "/var/www/web1/html/vB/signatur/sig2.jpg";

//full path to signare image with forum data (output image)
$ausgabedatei = "/var/www/web1/html/vB/signatur/sig1.jpg";

//Compression of output image
$komprimierung = 95;

//debug mode
$debug = 0;

// ######################### DO NOT EDIT BELOW ############################

function mysql_query_eval($query, $database) {
    $mysql_eval_error="";
    $mysql_eval_result = mysql_query($query, $database) or $mysql_eval_error = mysql_error();
    if ($mysql_eval_error) {
        if ( $debug == 1 ) {
            $letter = "An error was encountered during execution of the query:\n\n";
            $letter .= $query."\n\n";
            $letter .="The query returned with an errorcode of: \n\n$mysql_eval_error\n\n";
			$letter .="To turn this email off set debug=0 in signature.php\n\n";
            $email_from = "From: ".$adminemail;
            $subject="Subject: Signature Error Report";
            $subject=trim($subject);
            mail( $email, $subject, $letter, $email_from );
        } elseif ( $debug == 2 ) {
        dieWell( "MySQL error reported!<p>Query: $query<p>Result: $mysql_eval_error<p>Database handle: $database" );
        exit;
        }
        return FALSE;
    } else {
     return $mysql_eval_result;
   }
}

// CONNECTING TO DATABASE
$link = mysql_connect ("$host", "$user", "$password") or die ('I cannot connect to the database.');
mysql_select_db ("$database")or die("Could not select database");

// GETTING FORUM MEMBERS
$querya="SELECT COUNT(*) AS users, MAX(userid) AS max FROM " . TABLE_PREFIX . "user WHERE usergroupid!=4";
$numa = mysql_query_eval($querya,$link);
$numb = mysql_fetch_array($numa);
$numbermembers=number_format($numb['users']);
mysql_free_result($numa);

// GETTING TOTAL MEMBERS ONLINE

	$datecut = TIMENOW - $vboptions['cookietimeout'];
	$numbervisible = 0;
	$numberregistered = 0;
	$numberguest = 0;

	$forumusers = $DB_site->query("
		SELECT
			user.username, (user.options & $_USEROPTIONS[invisible]) AS invisible, user.usergroupid,
			session.userid, session.inforum, session.lastactivity,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
		FROM " . TABLE_PREFIX . "session AS session
		LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = session.userid)
		WHERE session.lastactivity > $datecut
		ORDER BY " . iif($permissions['genericpermissions'] & CANSEEHIDDEN, 'invisible ASC, ') . "username ASC, lastactivity DESC
	");

	if ($bbuserinfo['userid'])
	{
		// fakes the user being online for an initial page view of index.php
		$bbuserinfo['joingroupid'] = iif($bbuserinfo['displaygroupid'], $bbuserinfo['displaygroupid'], $bbuserinfo['usergroupid']);
		$userinfos = array
		(
			$bbuserinfo['userid'] => array
			(
				'userid' => $bbuserinfo['userid'],
				'username' => $bbuserinfo['username'],
				'invisible' => $bbuserinfo['invisible'],
				'inforum' => 0,
				'lastactivity' => TIMENOW,
				'musername' => fetch_musername($bbuserinfo, 'joingroupid')
			)
		);
		$numberregistered = 1;
		$numbervisible = 1;
		$loggedin = $userinfos["$bbuserinfo[userid]"];
		eval('$activeusers = ", ' . fetch_template('forumhome_loggedinuser') . '";');
	}
	else
	{
		$userinfos = array();
	}
	$inforum = array();

	while ($loggedin = $DB_site->fetch_array($forumusers))
	{
		$userid = $loggedin['userid'];
		if (!$userid)
		{	// Guest
			$numberguest++;
			$inforum["$loggedin[inforum]"]++;
		}
		else if (empty($userinfos["$userid"]['lastactivity']) OR ($userinfos["$userid"]['lastactivity'] < $loggedin['lastactivity']))
		{
			$userinfos["$userid"] = $loggedin;
			$numberregistered++;
			if ($userid != $bbuserinfo['userid'])
			{
				$inforum["$loggedin[inforum]"]++;
			}
			$loggedin['musername'] = fetch_musername($loggedin);

			//if (fetch_online_status($loggedin))
			//{
			//	$numbervisible++;
			//	eval('$activeusers .= ", ' . fetch_template('forumhome_loggedinuser') . '";');
			//}
		}
	}

	// memory saving
	unset($userinfos, $loggedin);

	$activeusers = substr($activeusers , 2); // get rid of initial comma

	$DB_site->free_result($loggedins);

	$totalonline = $numberregistered + $numberguest;
	$numberinvisible = $numberregistered - $numbervisible;

	// ### MAX LOGGEDIN USERS ################################
	$maxusers = unserialize($datastore['maxloggedin']);
	if (intval($maxusers['maxonline']) <= $totalonline)
	{
		$maxusers['maxonline'] = $totalonline;
		$maxusers['maxonlinedate'] = TIMENOW;
		build_datastore('maxloggedin', serialize($maxusers));
	}

	$recordusers = $maxusers['maxonline'];
	$recorddate = vbdate($vboptions['dateformat'], $maxusers['maxonlinedate'], true);
	$recordtime = vbdate($vboptions['timeformat'], $maxusers['maxonlinedate']);

//////////////////////////////////////////////////////////////////////////////////////////////////

// GETTING TOTAL POSTS AND THREADS
include_once('./includes/functions_forumlist.php');
cache_ordered_forums(1, 0, 0);
if (is_array($forumcache))
{
	foreach ($forumcache AS $forum)
	{
		$nthreads += $forum['threadcount'];
		$nposts += $forum['replycount'];
		$totalthreads = number_format($nthreads);
		$totalposts = number_format($nposts);
	}
}

// ########################### OUTPUT TEXT ###############################
// Use \n\r to make a line break (only for use with truetype font SO FAR)
// Will be developed to use with default font soon :)

$output = "Members: $numbermembers Threads: $totalthreads Posts: $totalposts Online: $totalonline";

$vorlage = imagecreatefromjpeg("$vorlagedatei");
$img = imagecreate($width,$height);

// ########################## TEXT FORMATTING ############################

// A PNG uses ImageColorAllocate instead of ImageColorClosest like jpeg uses

//background white
$bg_color = imagecolorallocate ($img, 255, 255, 255);

//black text
$text_color = imagecolorallocate ($img, 19, 36, 161);

imagefilledrectangle ($img, 0, 0, $width, $height, $bg_color);

// ######################### DO NOT EDIT BELOW ############################

imagecopy ($img, $vorlage, 0, 0, 0, 0, $width, $height); // copy empty banner

imagecolortransparent($img, $bg_color);  // set dummybg transparent

// the distance is in pixels and the font # is 1 through 5
$i = 0;
while($i < count($output)){

// ######################### CHANGE FONT BELOW ############################
// Uncomment LINE1+LINE12 and comment LINE2+LINE22 to use default font.
// Replace "verdana.ttf" with the URL to your .ttf font
//
imagestring($img, $fontsize, $left, (($i * $zeilenabstand) - $zeilenabstand + $top), $output, $text_color);  // LINE1
//imagettftext($img, $fontsize, 0, $left, (($i * $zeilenabstand) - $zeilenabstand + $top), $text_color, "verdana.ttf", $output); // LINE2
$i++;
}

header("Content-Type: image/png");
imagepng($img);
imagejpeg($img, "$ausgabedatei",$komprimierung); //Write jpg to folder and set compression
imagedestroy($img); // get the image out of memory

[DWard]

I really can't tell what's happening, everybody else seems to have no problem. And I cannot tell of any problems with this script, as I personally am not having any problems.