Creating a counter

[WarriorDL]

Hi. I'm trying to create a counter that reads how many categories and images I have in my gallery.

The vB code for total threads and and posts is like what I want, as the category and image totals will replace the threads and posts totals.

$totalthreads = 0;
$totalposts = 0;
if (is_array($vbulletin->forumcache))
{
foreach ($vbulletin->forumcache AS $forum)
{
$totalthreads += $forum['threadcount'];
$totalposts += $forum['replycount'];
}
}
$totalthreads = vb_number_format($totalthreads);
$totalposts = vb_number_format($totalposts);

The original coding is from another script:

$total_images = 0;
$total_categories = 0;

$cache_id = create_cache_id(
'data.auth_and_info',
array($user_info[$user_table_fields['user_id']])
);

if (!$data = get_cache_file($cache_id, null)) {
if (!empty($cat_cache)) {
foreach ($cat_cache as $key => $val) {
if (check_permission("auth_viewcat", $key)) {
$total_categories++;
if (isset($val['num_images'])) {
$total_images += $val['num_images'];
}
else {
$cat_cache[$key]['num_images'] = 0;
}
$auth_cat_sql['auth_viewcat']['IN'] .= ", ".$key;
}
else {
$auth_cat_sql['auth_viewcat']['NOTIN'] .= ", ".$key;
}
}
}

$data = array();

$data['total_images'] = $total_images;
$data['total_categories'] = $total_categories;
$data['auth_viewcat']['IN'] = $auth_cat_sql['auth_viewcat']['IN'];
$data['auth_viewcat']['NOTIN'] = $auth_cat_sql['auth_viewcat']['NOTIN'];

save_cache_file($cache_id, serialize($data));

} else {
$data = unserialize($data);

$total_images = $data['total_images'];
$total_categories = $data['total_categories'];
$auth_cat_sql['auth_viewcat']['IN'] = $data['auth_viewcat']['IN'];
$auth_cat_sql['auth_viewcat']['NOTIN'] = $data['auth_viewcat']['NOTIN'];
}

It won't work in my non-forum vB generated page.

[Opserty]

What is the template code you are using to display it?

[WarriorDL]

It's just a phrase in there right now, not the phrase and variables.

It's in the "What's Happening" section of the FORUMHOME template. However, I have created a seperate template for my non-forum page to get that info.

If I switch the variable in the template back to the forum stats, it *does* work for that. But obviously this isn't a forums page. It's going to be a gallery page, thus wanting gallery stats, not forum stats :)

--------------- Added 1208643394 at 1208643394 ---------------

To get an idea of what I am doing over all, look here: http://www.colonialfleets.com/gallery/

The vB is vB 3.0 with 4Images using the user and groups from the forums.

However, with vB 3.6.x, 4Images won't work with it anymore.

So what I am going to try to do is create my own gallery system based on the "goodies" 4Images offers, but mine will be a plug-in to vB.

To do that, all of the coding has to be written in vB type, which means a complete over-haul. I'm willing to do that, but may need a directional point once in a while.

I've searched all over on how to create a totals counter, and all I can find is visitor counters, which do me no good.

--------------- Added 1208648270 at 1208648270 ---------------

Fixed it! Whoo Hooo!

$result = $db->query("SELECT * FROM " . TABLE_PREFIX . "my categories table here"); //Change the table name
$total_categories = mysql_num_rows($result);

$result = $db->query("SELECT * FROM " . TABLE_PREFIX . "my images table here"); //Change the table name
$total_images = mysql_num_rows($result);