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
  #52  
Old 06-09-2004, 11:25 AM
chet chet is offline
 
Join Date: Feb 2004
Location: Nottingham (UK)
Posts: 220
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Mine is sitting on my LAN so can not be accessed from the outside, but looking at the link from the other user, mine is just the same

Chet
Reply With Quote
  #53  
Old 06-09-2004, 12:38 PM
Intex Intex is offline
 
Join Date: Apr 2002
Posts: 576
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

English Template Update

PCFreak - I've updated the main template file (statistik_hauptseite), to correct all the grammatical, spelling and typos - I hope you don't mind. I've completely renamed some of the wording as well. Hope that's ok with you.

The only thing that remains is to change the wording of the countries / lauguage section, which are not in the templates themselves. PCFreak - perhaps you could do that (or somebody else)?

Feel free to include it in your main zip file . P.S. What's a 'side call'?


Quote:
Originally Posted by PcFreak
@chet and Intex
Can i get the links to yours statisticsite please.

PcFreak
Reply With Quote
  #54  
Old 06-09-2004, 01:23 PM
trackpads's Avatar
trackpads trackpads is offline
 
Join Date: Aug 2003
Location: Armyville
Posts: 1,074
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Awesome!!!! A++++
Reply With Quote
  #55  
Old 06-09-2004, 01:34 PM
The Geek's Avatar
The Geek The Geek is offline
 
Join Date: Sep 2003
Location: Behind you
Posts: 2,779
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I think I found the problem with the elongated bars... the calculations are not correct when you use results from number_format. I changed those to intval and it calculates correctly now:

Here is the area I changed... hope I havent missed any:

PHP Code:
//##################################################################################################
//## Auswertgung einger Top Resulte START
//##################################################################################################

    
$alle_beitraege $DB_site->query_first("SELECT COUNT(*) as beitraege FROM " TABLE_PREFIX "post    ");
    
$alle_beitraege    =    intval($alle_beitraege['beitraege']);                                //alle Beitr?ge

    
$alle_themen$DB_site->query_first("SELECT COUNT( * ) as themen FROM " TABLE_PREFIX "thread ");
    
$alle_themen    =    intval($alle_themen['themen']);                                        //alle Themen

    
$alle_user$DB_site->query_first("    SELECT COUNT( * ) as benutzer FROM " TABLE_PREFIX "user    ");
    
$alle_user    =    intval($alle_user['benutzer']);                                            //alle Benutzer

    
$alle_pm$DB_site->query_first("SELECT COUNT( * ) as pm FROM " TABLE_PREFIX "pm ");
    
$alle_pm    =    intval($alle_pm['pm']); 
Reply With Quote
  #56  
Old 06-09-2004, 02:18 PM
trackpads's Avatar
trackpads trackpads is offline
 
Join Date: Aug 2003
Location: Armyville
Posts: 1,074
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by the nail geek
I think I found the problem with the elongated bars... the calculations are not correct when you use results from number_format. I changed those to intval and it calculates correctly now:

Here is the area I changed... hope I havent missed any:

PHP Code:
//##################################################################################################
//## Auswertgung einger Top Resulte START
//##################################################################################################

    
$alle_beitraege $DB_site->query_first("SELECT COUNT(*) as beitraege FROM " TABLE_PREFIX "post    ");
    
$alle_beitraege    =    intval($alle_beitraege['beitraege']);                                //alle Beitr?ge

    
$alle_themen$DB_site->query_first("SELECT COUNT( * ) as themen FROM " TABLE_PREFIX "thread ");
    
$alle_themen    =    intval($alle_themen['themen']);                                        //alle Themen

    
$alle_user$DB_site->query_first("    SELECT COUNT( * ) as benutzer FROM " TABLE_PREFIX "user    ");
    
$alle_user    =    intval($alle_user['benutzer']);                                            //alle Benutzer

    
$alle_pm$DB_site->query_first("SELECT COUNT( * ) as pm FROM " TABLE_PREFIX "pm ");
    
$alle_pm    =    intval($alle_pm['pm']); 
Works great! Thanks!

Also, thanks alot Intex for the template update!!

-Jason

http://www.trackpads.com/forum/statistik.php
Reply With Quote
  #57  
Old 06-09-2004, 02:28 PM
Ming Keong's Avatar
Ming Keong Ming Keong is offline
 
Join Date: Apr 2004
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Great hack! I've just installed it and found that it shows the statistics two times on the same page. See http://www.pdatrends.com/statistics.php and wait for it to fully load.

It seems to be happening for the other statistics pages installed by other members. eg. http://www.celebritymarkt.de/statistik.php

How can this be fixed?
Reply With Quote
  #58  
Old 06-09-2004, 02:31 PM
The Geek's Avatar
The Geek The Geek is offline
 
Join Date: Sep 2003
Location: Behind you
Posts: 2,779
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Ming Keong
Great hack! I've just installed it and found that it shows the statistics two times on the same page. See http://www.pdatrends.com/statistics.php and wait for it to fully load.

It seems to be happening for the other statistics pages installed by other members. eg. http://www.celebritymarkt.de/statistik.php

How can this be fixed?
use the updated template that intex put up about 4 posts back... the reason is that the template is the english... then the german for some reason.
Intex's updated template has only the english.
Reply With Quote
  #59  
Old 06-09-2004, 03:10 PM
Intex Intex is offline
 
Join Date: Apr 2002
Posts: 576
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You're welcome .



Quote:
Originally Posted by trackpads
Works great! Thanks!

Also, thanks alot Intex for the template update!!

-Jason

http://www.trackpads.com/forum/statistik.php
Reply With Quote
  #60  
Old 06-09-2004, 03:10 PM
Intex Intex is offline
 
Join Date: Apr 2002
Posts: 576
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yup, I had the same problem and reported it as a problem, then two minutes later deleted my thread because I'd found that PCFreak had dupilcated the template.

The Engilsh template I submitted corrects everything as far as I can see and generally tidies things up. I changed the wording of some areas too, which I'm hoping PCFreak doesn't mind me doing.

We still need to change the country names. I'll do that later unless someone beats me to it


Quote:
Originally Posted by the nail geek
use the updated template that intex put up about 4 posts back... the reason is that the template is the english... then the german for some reason.
Intex's updated template has only the english.
Reply With Quote
  #61  
Old 06-09-2004, 03:35 PM
Zephanor Zephanor is offline
 
Join Date: Jul 2003
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks dude, I figured that out shortly after the post, I was up laaaate.



Can anyone give me direction or a place I can find on how to make changes to my database itself? I want to translate the countries and domains into english as well.

And I spent a lot of time combing through and changing the main template and I could have just waited a day for someone else to do it, lol!
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 05:01 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04728 seconds
  • Memory Usage 2,329KB
  • Queries Executed 27 (?)
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
  • (5)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
  • (1)pagenav_pagelinkrel
  • (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_postinfo_query
  • fetch_postinfo
  • 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