vb3 Statistic Version 1.01

vb3 Statistic

Many people had ask me when i release this hack?

The problem is, my english is bad and its hard for me, write a installations text.
So everyone feel free to help me with the instructions.

A live demo you found:
http://at-lantis.de/statistik.php

OK. Now we come to the hack.

Please make a backup of your database, before installing this hack

This hack will show you an extra side with some Stats.

- show Summary stats
- show the Browser/Os System of the users
- show the countrys (countrys by Hoster and Countries by browserlanguage)
- show the last 10 threads
- show the last 20 top referers
- show spiders and crawlers
- Forum book of records (new)
- Statistic for the last ten days (new)

and many, many other interesting counts

Files to edit
Just one template

New files
4 new php files
6 templates
a lot (but very small) images

Database changes
six new tables

I will try to give support for this hack

BIG UPDATE ( to version 1.01)

Upload a new zipfile 11. June 2004
Reason
I have fix some bugs

The images Bhutan will show now. (If you install the old version you must change in table _statistik_laender under id 31 the flagge_link for Bhutan from images/statistik/flaggen/butan.gif to images/statistik/flaggen/bhutan.gif manuelly)
some templates are optimzed (Thank you obsidian and Zelda King)
I have modified the code for the last 10 threads (thanks go to Mystics from vBulletin Germany)
Now theads just show from the forum ids for all forums user is allowed to view.
fix some other little bugs

PcFreak

New

Statistic Version 2.0 is finish.
I will release the new version later this day.
I give no more support for the Version 1.01.

[Wachtmeister]

I've renamed the tables to fix the table-prefix problem.

Now, when running http://........../statistik.php i get the following:


Database error in vBulletin 3.0.1:

Invalid SQL:
SELECT threadid, title, lastpost, postusername,lastposter,dateline
FROM vb3_thread
WHERE forumid IN(1, 2, 7, 67, 9, 69, 70, 65, 66, 3, 4, 5, 6, 71, 73, 76, 77, 78, 79, 80, 72, 64, 41, 44, 57, 60, 61, 43, 62, 63, 40, 59, 45, 46, 47, 56, 53, 52, 55, 54, 58, 74, 75, 42, 48, 49, 50, 51, 12, 13, 14)
AND thread.open <> 10
AND thread.visible = '1'
ORDER BY lastpost
DESC LIMIT 10

mysql error: Unknown table 'thread' in where clause

mysql error number: 1109

Date: Sunday 13th of June 2004 09:18:01 PM
Script: http://www.webgurus.de/forum/statistik.php
Referer:
Username:
IP Address: 217.231.170.193

Can someone help?

[RapCheck]

I've been waiting since vb3 came out for this hack, users always ask for the stats back!

But, I wish wish wish it was 100% english. I just dont feel comfortable with this one yet

[Wachtmeister]

I'll do the translation, but i want to get it running first....

Doesn't this hack work with vb's using table prefix?

[killervette]

The last 10 days is still not showing up for me...anyone else??

[Mijae]

I'd install this, but I checked and some parts of the template arent working properly

[Natch]

Originally Posted by Wachtmeister

I've renamed the tables to fix the table-prefix problem.

Now, when running http://........../statistik.php i get the following:


Database error in vBulletin 3.0.1:

Invalid SQL:
SELECT threadid, title, lastpost, postusername,lastposter,dateline
FROM vb3_thread
WHERE forumid IN(1, 2, 7, 67, 9, 69, 70, 65, 66, 3, 4, 5, 6, 71, 73, 76, 77, 78, 79, 80, 72, 64, 41, 44, 57, 60, 61, 43, 62, 63, 40, 59, 45, 46, 47, 56, 53, 52, 55, 54, 58, 74, 75, 42, 48, 49, 50, 51, 12, 13, 14)
AND thread.open <> 10
AND thread.visible = '1'
ORDER BY lastpost
DESC LIMIT 10

mysql error: Unknown table 'thread' in where clause

mysql error number: 1109

Date: Sunday 13th of June 2004 09:18:01 PM
Script: http://www.webgurus.de/forum/statistik.php
Referer:
Username:
IP Address: 217.231.170.193

Can someone help?

With your renamed tables, you need to make it

FROM vb3_thread as thread

- then your script will work as normal ...

[PcFreak]

@all
I am now finished with the statistics version 1.5
The new version is full XHTML coded



All other code is optimized and i have fix some bugs.
I have mad an another Statistic Module for the Arcade Hack
Top Level Domains now showing.
The statistic have a navigationbar now.

At moment i don?t release this hack, because the hack is in testing mode.

But feel free to check the new statistic here:

http://at-lantis.de/statistik.php

Improvement suggestions and criticism are welcome

PcFreak

[Intex]

PCFreak - Looks great. Let me know if you want someone to test it on a separate system.

Originally Posted by PcFreak

@all
I am now finished with the statistics version 1.5
The new version is full XHTML coded



All other code is optimized and i have fix some bugs.
I have mad an another Statistic Module for the Arcade Hack
Top Level Domains now showing.
The statistic have a navigationbar now.

At moment i don?t release this hack, because the hack is in testing mode.

But feel free to check the new statistic here:

http://at-lantis.de/statistik.php

Improvement suggestions and criticism are welcome

PcFreak

[SaN-DeeP]

weird but i am getting this error:

 Database error in vBulletin 3.0.0: 
Invalid SQL: 
SELECT threadid, title, lastpost, postusername,lastposter,dateline 
FROM vb3_thread 
WHERE forumid IN(3, 4, 44, 5, 45, 6, 14, 52, 11, 10, 46, 13, 30, 33, 43, 34, 32, 31, 37, 38, 40, 42, 39, 41, 15, 16, 17, 18, 19, 7, 36, 21, 24, 35, 20, 22, 47, 48, 53, 49, 50, 51, 25, 26, 27)
AND thread.open <> 10
AND thread.visible = '1'		
ORDER BY lastpost 
DESC LIMIT 10 
 
mysql error: Unknown table 'thread' in where clause
mysql error number: 1109

changing few lines make it work:

 $getbeitraege= $DB_site->query("
  SELECT threadid, title, lastpost, postusername,lastposter,dateline  
  FROM " . TABLE_PREFIX . "thread 
  WHERE forumid IN(" . implode(', ', $forumids) . ")
  AND vb3_thread.open <> 10
  AND vb3_thread.visible = '1'		
  ORDER BY lastpost 
  DESC  LIMIT $limit 
 ");

[esnecca]

It looks beautiful, PcFreak. You might consider removing the word statistic/s from every category heading except "General Statistics". You already have two titles without the word statistic/s in them, and I think it might read a little more smoothly. Just an idea...

Thank you for such a great hack.