Forum+ecDownloads Stats on Signature Image

If you like it click

Installation Time: <5 mins
Files: 1
Plugins: 1
VB Version: This actually works on 3.5.0 - 3.5.4 for 3.6.0 - 3.6.4 go here


Description:

This Hack will but your vb Forum stats (i.e. No. of Members, Threads and Posts) on your Signature Image. It uses the layout from sig.jpg, calls the stats from your Databank and creates a new images called signature.jpg

This hack uses the PHP-GD Function, so be shure you have this enabled on your server. If you don?t be shure about this, ask your host or look in your PHP-Info.

Installation Instructions:

1. Open signature.php in a text editor and set the variables at top according to your requirements (These are settings for stats text placement and with and height of signature image)
2. Upload signature.php to your forums directory
3. Open sig.jpg in your favourite Graphics Programm and make a real cool Signature image
4. Save it with the same name and upload it to your forum directory
5. Install the plugin and wait 5 mins

Examples:

FAQ: N/A

If you like it click


This hack was based on tkeil69575's hack.

To add extra stats look in the signature.php for more info.

[Mr Chad]

acutally install my new one. Updated it with EC stats. Any problems just reply.

[SupremeWeapon]

Fatal error: Call to a member function query_first() on a non-object in /forums/signature.php on line 18

line 18

$postcount = $vbulletin->db->query_first("SELECT COUNT(*) AS posts FROM " . TABLE_PREFIX . "post");

Latest Mysql
latest php
latest GD

[Smiry Kin's]

Originally Posted by Mr Chad

place it with your php file. where ever you put that.

place what? i downloaded the new version installed - same issues..

[Mr Chad]

hmm, ill look into this when i have time... (my site went down yesterday ><)

[imported_Visions]

I'm totally lost, I have installed the hack and went into vb schedualed taskes and ran the cron job and this is what I get.

Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT SUM(views) as pageviews FROMthread;

MySQL Error  : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROMthread' at line 1
Error Number : 1064
Date         : Monday, June 19th 2006 @ 02:55:38 AM
Script       : http://www.mmoupdate.com/admincp/cronadmin.php?do=runcron&cronid=14
Referrer     : http://www.mmoupdate.com/admincp/cronadmin.php?do=modify
IP Address   : 68.52.48.164
Username     : Administrator
Classname    : vb_database

Any Ideas. Is there any way to get clear directions on the install of this mod? The directions are very unclear and I am really lost. Any help would be appreciated.

[Smiry Kin's]

Originally Posted by imported_Visions

I'm totally lost, I have installed the hack and went into vb schedualed taskes and ran the cron job and this is what I get.

Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT SUM(views) as pageviews FROMthread;

MySQL Error  : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROMthread' at line 1
Error Number : 1064
Date         : Monday, June 19th 2006 @ 02:55:38 AM
Script       : http://www.mmoupdate.com/admincp/cronadmin.php?do=runcron&cronid=14
Referrer     : http://www.mmoupdate.com/admincp/cronadmin.php?do=modify
IP Address   : 68.52.48.164
Username     : Administrator
Classname    : vb_database

Any Ideas. Is there any way to get clear directions on the install of this mod? The directions are very unclear and I am really lost. Any help would be appreciated.

Donno but thats alot better error then just a few text words im getting..

[Mr Chad]

just comment out the pageviews bit...

[SupremeWeapon]

Originally Posted by SupremeWeapon

line 18



Latest Mysql
latest php
latest GD

Well any ideas yet?

[SupremeWeapon]

k, 9 days. what is up with this modification?

Still having the SAME issues

Fatal error: Call to a member function query_first() on a non-object in /forums/signature.php on line 18

[VBUsers]

can this work with 3.6 beta 3? hope so