Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Full Releases

Reply
 
Thread Tools
vb3 Statistic Version 1.01 Details »»
vb3 Statistic Version 1.01
Version: 1.00, by PcFreak PcFreak is offline
Developer Last Online: Mar 2015 Show Printable Version Email this Page

Version: 3.0.1 Rating:
Released: 06-06-2004 Last Update: Never Installs: 50
 
No support by the author.

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.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #82  
Old 06-10-2004, 01:47 AM
GamerJunk.net's Avatar
GamerJunk.net GamerJunk.net is offline
 
Join Date: Jan 2004
Posts: 457
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I keep getting a lot of errors when trying to run the queries
Reply With Quote
  #83  
Old 06-10-2004, 02:58 AM
PcFreak's Avatar
PcFreak PcFreak is offline
 
Join Date: May 2003
Posts: 205
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What kind of errors?
Witch tables or inserts?
Sorry but this is not a real good information to give support

Pxfreak
Reply With Quote
  #84  
Old 06-10-2004, 03:14 AM
Sam FT's Avatar
Sam FT Sam FT is offline
 
Join Date: Apr 2003
Posts: 119
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am having one problem with this hack. The thread count at the top is two more threads than I really have compared to my forumhome page at the bottom. Here is the stat page http://www.full-throttle.us/forums/statistik.php and forumhome http://www.full-throttle.us/forums. I install the hack as instructed and I havn't modified anything dealing with the thread counter.
Reply With Quote
  #85  
Old 06-10-2004, 04:47 AM
PcFreak's Avatar
PcFreak PcFreak is offline
 
Join Date: May 2003
Posts: 205
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Run this querie in your mysql:

SELECT COUNT( * ) FROM thread

Tell me what the count say.

And one © by PcFreak on your Statistik Side is not to mutch for this great hack I think.

PcFreak
Reply With Quote
  #86  
Old 06-10-2004, 04:53 AM
Sam FT's Avatar
Sam FT Sam FT is offline
 
Join Date: Apr 2003
Posts: 119
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by PcFreak
Run this querie in your mysql:

SELECT COUNT( * ) FROM thread

Tell me what the count say.

And one ? by PcFreak on your Statistik Side is not to mutch for this great hack I think.

PcFreak
Well the thread count I got back was the correct one on the stats page which was 126. Could the forumhome page stats at the bottom maybe not counting private threads and the statistic hack is counting the private threads?
Reply With Quote
  #87  
Old 06-10-2004, 05:01 AM
PcFreak's Avatar
PcFreak PcFreak is offline
 
Join Date: May 2003
Posts: 205
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

My Stats count every thread.
But is a good idea. I will change this in a future version.

PcFreak
Reply With Quote
  #88  
Old 06-10-2004, 05:04 AM
Sam FT's Avatar
Sam FT Sam FT is offline
 
Join Date: Apr 2003
Posts: 119
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by PcFreak
My Stats count every thread.
But is a good idea. I will change this in a future version.

PcFreak
After I asked the question I thought about it a little more. But you maybe want to have the stats only show non private threads, etc.

Sorry about the copyright. I am using the english updated in this thread and I don't like how that user had the copyright next to the title of every box. So what I am doing right now is putting a copyright at the bottom of the page just like what you had in the orginial one.
Reply With Quote
  #89  
Old 06-10-2004, 05:27 AM
PcFreak's Avatar
PcFreak PcFreak is offline
 
Join Date: May 2003
Posts: 205
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

There is a did not document funktion.

find in the statistik.php
PHP Code:
//4 ist das interne Forum
    
$getbeitraege$DB_site->query("
        SELECT threadid, title, lastpost, postusername,lastposter,dateline  
        FROM " 
TABLE_PREFIX "thread 
        WHERE forumid NOT IN ('4')                                
        ORDER BY lastpost 
        DESC  LIMIT 
$limit 
        "
); 
The number 4 in this part WHERE forumid NOT IN ('4') is my intern Forum.
Change this Number with the Forum ID?s you don?t want to show
for example WHERE forumid NOT IN ('4', '11', '22')

Sorry, but i have forgot this to explain in my instructions.

PcFreak
Reply With Quote
  #90  
Old 06-10-2004, 05:32 AM
Sam FT's Avatar
Sam FT Sam FT is offline
 
Join Date: Apr 2003
Posts: 119
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by PcFreak
There is a did not document funktion.

find in the statistik.php
PHP Code:
//4 ist das interne Forum
     
$getbeitraege$DB_site->query("
         SELECT threadid, title, lastpost, postusername,lastposter,dateline  
         FROM " 
TABLE_PREFIX "thread 
         WHERE forumid NOT IN ('4')                                
         ORDER BY lastpost 
         DESC  LIMIT 
$limit 
         "
); 
The number 4 in this part WHERE forumid NOT IN ('4') is my intern Forum.
Change this Number with the Forum ID?s you don?t want to show
for example WHERE forumid NOT IN ('4', '11', '22')

Sorry, but i have forgot this to explain in my instructions.

PcFreak
Cool I will check it out...and I added a copyright at the bottom of my stats page for you. Because I do what you to get the credit you desire for this awesome hack.
Reply With Quote
  #91  
Old 06-10-2004, 05:38 AM
Beermonster Beermonster is offline
 
Join Date: Dec 2003
Location: England
Posts: 362
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Everything was working perfect until I upgraded, now Top 20 Referers doesn't have anything nither does "book of records" and everyone either comes from Colombia or Ethiopia

http://www.scale-models.co.uk/statistik.php
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:06 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05277 seconds
  • Memory Usage 2,305KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_php
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete