Show all hits on Forumhome

First,

I am Geman. My English is not very well and this is my first little hack.

If there a other kind of this hack, sorry.

What's it do?
This hack shows the sum of all hits in the Forum Statistics.

Files to edit.

index.php
Template: FORUMHOME
Add one new Phrase

PcFreak

[Kalipo]

Thanks Boofo and addon makerer thingy guy (Y)

Installed

[xscape2me]

I'm getting an sql error.

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT COUNT(*) ,
SUM(views) AS hits
FROM 600rr_ thread
mysql error: Table database.600rr_' doesn't exist

mysql error number: 1146

Date: Thursday 22nd of July 2004 12:52:54 PM
Script: http://www.miami600rr.com/forums/?

[royals]

Originally Posted by Boofo

I've been all wrong on this guys. Dohh!!! Here is the code you need for the commas.

PHP Code:

$totalhits = vb_number_format($totalhits); 


I get this on my page:

Total Hits: 250726 = vb_number_format(250726);



Otherwise this works like a charm - thanks!

[royals]

Nevermind!! I was adding in the template, not my index.php

Thanks Boofo - works!

[royals]

Qusetion - is this hits or visits? Daily? I have that many hits a day so I'm curious.

Thanks! (jeez I'm about to flood this thread)

[Hotte@gun]

Originally Posted by xscape2me

I'm getting an sql error.

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT COUNT(*) ,
SUM(views) AS hits
FROM 600rr_ thread
mysql error: Table database.600rr_' doesn't exist

mysql error number: 1146

Date: Thursday 22nd of July 2004 12:52:54 PM
Script: http://www.miami600rr.com/forums/?

There is an whitespace which schouldnt be there use the following code

// ### Anzeige aller Hits START ###
$totalhits = $DB_site->query_first("
		SELECT COUNT(*) ,
		SUM(views) AS hits
		FROM " . TABLE_PREFIX . "thread
			");

	$totalhits = vb_number_format($totalhits['hits']);
// ### Anzeige aller Hits ENDE ###

This includes Numberformating an the wrong set space after FROM " . TABLE_PREFIX . "

[italks]

how the phrase is added.

_______________
Add a new phrase
_______________

totalhits = Totalhits

[italks]

lolz i got it done....i almost forgotten it before.thanks for the hack its great.

[fiber1]

Anyone know how to fix this to work in 3.0.3?

[Hotte@gun]

Originally Posted by fiber1

Anyone know how to fix this to work in 3.0.3?

ehm... fix what ?