Add Gallery Stats to Home Statistics

[InterFX]

http://www.vbadvanced.com/forum/showthread.php?t=3558

You helped me do this for the links module, but how do I do this for the gallery program...

I'm not sure of what the query should be...

Thanks for your help...

InterFX

[InterFX]

This is how Brian suggested it in VBaLinks...

$totallinks = $DB_site->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "links WHERE valid = 1 AND suspended = 0");

$totallinks = number_format($totallinks['count']);

Anyone understand this enough, and table structure for Gallery?

Any ideas?

InterFX

[ConqSoft]

Try:

$totalimages= $DB_site->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "images WHERE valid = 1");

$totalimages= number_format($totalimages['count']);

[InterFX]

I tried that, but it didn't work... It seems the table is called something else than "xxxxxx.images"... I'll keep trying if you have other ideas...

Thanks -
InterFX

Database error in vBulletin 3.0.6:

Invalid SQL: SELECT COUNT(*) AS count FROM images WHERE valid = 1
mysql error: Table 'xxxxxx.images' doesn't exist

mysql error number: 1146

[ConqSoft]

It's called adv_gallery_images by default. Not sure about the prefix part with Gallery, so you should be able to hard code the table name.

$totalimages= $DB_site->query_first("SELECT COUNT(*) AS count FROM adv_gallery_images WHERE valid = 1");

[InterFX]

Hey, that worked GREAT!!!

Thanks for your help...