Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Full Releases
FAQ Community Calendar Today's Posts Search

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
  #152  
Old 06-13-2004, 06:22 PM
Wachtmeister's Avatar
Wachtmeister Wachtmeister is offline
 
Join Date: Apr 2004
Location: West-Berlin, Germany
Posts: 190
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #153  
Old 06-13-2004, 06:31 PM
RapCheck RapCheck is offline
 
Join Date: Nov 2001
Location: CA
Posts: 74
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #154  
Old 06-13-2004, 06:34 PM
Wachtmeister's Avatar
Wachtmeister Wachtmeister is offline
 
Join Date: Apr 2004
Location: West-Berlin, Germany
Posts: 190
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

Doesn't this hack work with vb's using table prefix?
Reply With Quote
  #155  
Old 06-13-2004, 06:34 PM
killervette killervette is offline
 
Join Date: Nov 2003
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The last 10 days is still not showing up for me...anyone else??
Reply With Quote
  #156  
Old 06-17-2004, 02:15 AM
Mijae's Avatar
Mijae Mijae is offline
 
Join Date: Nov 2001
Location: Russia
Posts: 523
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'd install this, but I checked and some parts of the template arent working properly
Reply With Quote
  #157  
Old 06-17-2004, 02:57 AM
Natch's Avatar
Natch Natch is offline
 
Join Date: Nov 2002
Location: Australia
Posts: 851
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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
Code:
FROM vb3_thread as thread
- then your script will work as normal ...
Reply With Quote
  #158  
Old 06-17-2004, 12:10 PM
PcFreak's Avatar
PcFreak PcFreak is offline
 
Join Date: May 2003
Posts: 205
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

@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
Reply With Quote
  #159  
Old 06-17-2004, 06:06 PM
Intex Intex is offline
 
Join Date: Apr 2002
Posts: 576
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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



Quote:
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
Reply With Quote
  #160  
Old 06-17-2004, 11:30 PM
SaN-DeeP's Avatar
SaN-DeeP SaN-DeeP is offline
 
Join Date: Jun 2002
Location: Mumbai, India
Posts: 1,195
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

weird but i am getting this error:

Code:
 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:

Code:
 $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 
 ");
Reply With Quote
  #161  
Old 06-18-2004, 12:26 AM
esnecca esnecca is offline
 
Join Date: Apr 2004
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
Reply


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 09:38 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.10213 seconds
  • Memory Usage 2,317KB
  • 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
  • (3)bbcode_code
  • (2)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_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