vB PHP Counter Script - almost ready

[Thomas P]

Hello,

I use the following script to show a counter in FORUMHOME or wherever I want:

PHP Code:

// ### Counter Hack by J. Schmidt ################################# 
$cquery = "SELECT A.title, A.data FROM ".TABLE_PREFIX."datastore AS A WHERE title = 'total_hits' OR title = 'daily_hits'"; 
$counter = $db->query_read($cquery); 
while ($res = $db->fetch_array($counter)) { 
  if($res['title'] == "total_hits") { 
    $total_hits = $res['data']; 
  } else if($res['title'] == "daily_hits") { 
    $daily_hits = $res['data']; 
  } 
} 
$cquery = "UPDATE ".TABLE_PREFIX."datastore SET data = '".++$total_hits."' WHERE title = 'total_hits'"; 
$counter = $db->query_write($cquery); 
$cquery = "UPDATE ".TABLE_PREFIX."datastore SET data = '".++$daily_hits."' WHERE title = 'daily_hits'"; 
$counter = $db->query_write($cquery); 
// ### Counter Hack END ################################################# 


Now I just insert $daily_hits into forumhome and I am all set.

Just one thing: The numbers are shown like this: 21458754 without a "." to mark a thousand - how can I change this?

Thanks,
-Tom

[Opserty]

$daily_hits = vb_number_format($daily_hits); should do the trick.

[Thomas P]

Hmm, now it get's reset when it reaches 1000

The data is stored in the datastore table, which is of type 'mediumtext', if this is any help...

[Opserty]

It only reaches a maximum of 1000 in your datastore table?

[Thomas P]

Only if I place the a.m. code

PHP Code:

$daily_hits = vb_number_format($daily_hits); 


[Opserty]

Are you placing that code before or after your update queries?

[Thomas P]

Ah - I see what you mean.

Now I placed the line at the very end and it works like a charm.

Good one - many thanks, that's great