Show all hits on Forumhome

[PcFreak]

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

[Chris|vB]

great hack :)

[Gio Takahashi]

Just a question what you mean by HIt you mean Thread View count? I'm just a little confused.

[hitmanuk2k]

is it possible to insert comma's in the number?

2,134,114 instead of 2134114

[PcFreak]

Just a question what you mean by HIt you mean Thread View count? I'm just a little confused.

That is what I mean.
One "View" is one "Hit". (In Geman we call it Hit)

@hitmanuk2k
Sorry, i?m shure that is possible. But I don?t know how.

PcFreak

[assassingod]

Use this code to get commas in high numbers:

$totalhits = number_format($totalhits['hits']);

[insanctus]

That is what I mean.
One "View" is one "Hit". (In Geman we call it Hit)

@hitmanuk2k
Sorry, i?m shure that is possible. But I don?t know how.

PcFreak
Then mine must be off :( 297930 I know been more then that lmao.

[Boofo]

Use this code to get commas in high numbers:

$totalhits = number_format($totalhits['hits']);

For vB3, that should be:

$totalhits = vb_number_format($totalhits['hits']);

;)

[BoNfiRe]

clicks install thx for the hack, and thx for the mod Boofo

[Synicide]

this is awesome! thanks!

[Ted S]

Just a question what you mean by HIt you mean Thread View count? I'm just a little confused.

Looking at the code the actual value isn't page views or server hits but rather thread views so requests to search pages, arcade pages, tell a friend, profiles, etc... won't impact this data.

[jons5150]

I used the Vb3 "comma code", but no commas? Any help Boofo???

Thanks...

[Boofo]

You need to add that code right under this line:

$totalhits = intval($totalhits['hits']);

[Synicide]

You need to add that code right under this line:

$totalhits = intval($totalhits['hits']);
Actually Boofo, it didn't work for me unless I replaced your line with that line. Because I'm guessing those functions try to clash with each other to display the talley. Just my observation.

[jons5150]

Didn't work for me either boofo...made it worse. I think I'll just stick with no commas...

Thanks for trying....

[Boofo]

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

$totalhits = vb_number_format($totalhits);

[jons5150]

As a replacement or an addition???

[Boofo]

As a replacement or an addition???
As an addition right below the other piece of code.

[Synicide]

As an addition right below the other piece of code.
I replaced it and it worked fine for me too. o_O

[ChuanSE]

Doesn't seem to work for me :/

[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]

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

$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]

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]

Anyone know how to fix this to work in 3.0.3?
ehm... fix what ?

[fiber1]

ehm... fix what ?

I am not geting any hits showing up for this, and yes there are people hitting the board/threads/etc. Everything shows up except for the hit count.

[txbigguy]

I am getting the same thing.

[Kyoshiro]

well, i got the hit counts to show up, but apparently, it won't update. it just stays frozen as 58,199 hits. i tried refreshing my page, but nope, still 58,199 -_-

[Erwin]

From reading this thread and without looking at the code, I surmise that this totals up all the threadviews, not site hits.

As such, if you've set threadviews in your Admin CP to NOT update in real-time to conserve server load, this number will not update until your threadviews update.

This is just a guess anyway. :)

[Jolten]

From looking at the query it is indeed thread views not site hits, as Erwin posted.

[passionboss]

So is there any way to have the hits based on site hits since midnight on a daily basis???

No that would make this hake awsum :)

[PcFreak]

So is there any way to have the hits based on site hits since midnight on a daily basis???

Good idea, but i think it?s not possible without changed the database.
This kind of mod needs special counter (more querys) and a new field in the thread tabel.
May a crownjob to deleted the old entries.
That would be my solution.

PcFreak

[zendiz]

I have 3.05 and it does give a db error. cannot find vb3_ jabbedabi
Allthough it seems a great hack I pass, I got my index page down 3 times, which is not good

[EscortCossie]

how the phrase is added.

_______________
Add a new phrase
_______________


totalhits = Totalhits
I don't get this... how is the phrase added?

Sorry for my noob question.. :rolleyes:

EDIT: I found it.. sorry guys :o

[jamesyfx]

Worked great for me, although the number seems a little high.. nearly 2,000,000.

[Polo]

Is there any way we can make this code count real hits or views... an not just thread views... anyone?

[Polo]

anyone :ermm:

[loftyasianz]

Is there any way we can make this code count real hits or views... an not just thread views... anyone?
*bump*

[Snake]

Works fine on 3.5.2. :)

[Falcon Capt]

Anybody up for adjusting this code so it works for 3.6.0???

[Falcon Capt]

Anybody up for adjusting this code so it works for 3.6.0???Disregard, I adjusted the code and got it working for 3.6.0