Forum stats on signature image

[high]Remember the forum rules here at vB.org and don't exceed the signature dimensions: https://vborg.vbsupport.ru/showthrea...threadid=50062 . Signatures in violation of the rules will be suspended. --filburt1[/high]

Hi all,

What this hack does:
Calls up your Forum statistics (like No. of Members, Threads and Posts) and creates a new image on your server using GD which you can use as a signature image, where ever you like - have a look at my signature and you'll see what I mean. This is only my 2nd hack - so be kind to me

In order to have the image created, say every 15 minutes you will need to set up a cronjob. Infos are provided in the instructions.txt, and alternatives for those who do not have access to crontab on their server.

Support:
Because I'm pretty busy, I will provide only limited support. Will look in here once a week or so.

Credits:
to kars10 for kicking me in the ass and getting me to code this - thanks karsten

greets
tina

Update 23.06.2003
- global.php no longer required, thus when signature image is being created it no longer shows up in "who is onlne"
- quality of image output improved
- debug modus with email notification integrated
- tested with gd2

[DannyBoy8406]

anyone know an update for this for VB3?

[StepFenz]

Hope not everybody is sick and tired of answering the question. But I've thoroughly searched the thread and I couldn't find the answer.

Q: I have GD2 installed (i.e. phpinfo says: GD Version bundled (2.0 compatible)) and I've chmodded my targetdir to 777. But the picture file doesn't show up. I can run the signature.php file and then I see what I would like to see. But I want the image-file.

Can anybody help me? I know there were people in this thread with similar problems and I can see by their signature they've solved that :laugh:

Tnx in advance

Idea: You can easiliy put the picture file on your Windows desktop and have it refreshed as much as you like.

[StepFenz]

Ok,

I've commented all kinds of lines out to try to focus on the wrong line. I cannot find it.
Problem: I can't generate a picturefile, not a jpg not a png.

But: I can run de php.file, and I can see the png-file, exactly the way I like it. There are no error messages.

System: I have GD2 and php 4.3.0 installed. And chmodded the picturedir to 777. I have Photopost working with GD as well.

These are my last 4 lines:
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

Firstly: I want to know how to fix this, but secondly: why is the png file swapped into a jpeg? Can I skip that?)

[StepFenz]

Solved it! Don't ask me how, but it works. In order to improve the interaction on this thread ;-) : I also added the total number of pictures of my photopost-section. Here it is (note that my photopost prefix is pp, if yours is different change that in the query below, eg. you have xx as photopost prefix, change ppphotos into xxphotos):

find:
mysql_free_result($threada);

after that add:

//get total photos
$queryd="SELECT COUNT(*) AS ppphotos FROM ppphotos";
$ppphotosa = mysql_query_eval($queryd,$link);
$ppphotosb = mysql_fetch_array($ppphotosa);
$totalphotos=number_format($ppphotosb['ppphotos']);
mysql_free_result($ppphotosa);

And replace:
$text = "Members: $numbermembers\nThreads: $totalthreads\nPosts: $totalposts\n";

Into:
$text = "Members: $numbermembers\nThreads: $totalthreads\nPosts: $totalposts\nPhoto's: $totalphotos\n";

I like this, because I now have immediately information on my frontpage about the status of all content, including photos.

[PranK]

this works without any dramas for VB3.

Christian

[dstruct2k]

Originally Posted by PranK

this works without any dramas for VB3.

Christian

Mine had to be altered, although it might be because my new host only has GD 1.

Meh, whatever, it works.

[kall]

I quite liked this hack over on Invision boards, and was all excited to see it here...unfortunately, when I call signature.php, all I get are lots of

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in

errors.

Any ideas?

[GoTTi]

not working for v3 for me...

can ne1 help me with it...

[GoTTi]

ne1 got this working on vb3??????

[DWard]

Yer I developed the script for vb3, search for Signature Stats and you should find it