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.

[Natch]

Originally Posted by 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 
 ");

You would be better off doing

FROM " . TABLE_PREFIX . "thread as thread

which would make the

... thread.open ... thread.visible ...

work regardless of the PREFIX value

[Eagle Creek]

Supercool!
*hitting download link*

[Eagle Creek]

HELP!

Systeem Bericht
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';


INSERT INTO _statistik_browser_os VALUES ('total','hits

[Vivi Ornitier]

I installed the hack but it looks nothing like the one you have on your demo. I don't see the sidebar to go to all those side things either. Besides htat it's great but i like the x days part and the other small parts. help!!

http://forums.squareultima.com/statistik.php

[Vivi Ornitier]

oh wait nm, lol. didn't even read the entire first post, hope you can release all those goodies soon!

[Romeos Tune]

I seem to be having a problem with all the stats displaying. The countries, browsers, and bots aren't showing up. Have a look at: http://stormchat.com/statistik.php

Anyone know what the reason might be? Thanks!

[marcel-ea]

if have the same problem no links no countries

[Intex]

PCFreak - any ideas on the 1.5 release?

[Romeos Tune]

Anyone?

[Sam FT]

I found a problem with how you count your threads in this hack. The thread counter is counting all the threads included "soft deleted" thread and redirects thread as well. The vBulletin Statisics at the bottom of the forum home page is only counting real threads. So you may want to update your thread count code because your thread counter isn't counting right.