vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - psiStats 2006 (The New vBStats for vBulletin 3.5.x - 3.8.x) (https://vborg.vbsupport.ru/showthread.php?t=127980)

furst 12-03-2006 03:52 PM

Quote:

So you would prefer a javascript or and xml feed, right?
Yeah, that would work best for me.

nocte 12-04-2006 07:59 PM

Hi,

I upgraded to PHP 5.2.0-0 - now i see a blank page, wenn i open psistats.php

I had Problems with vB CMPS too after upgrading, so i think it's the new PHP Version.

akanevsky 12-04-2006 08:18 PM

Quote:

Originally Posted by nocte (Post 1131890)
Hi,

I upgraded to PHP 5.2.0-0 - now i see a blank page, wenn i open psistats.php

I had Problems with vB CMPS too after upgrading, so i think it's the new PHP Version.

Unfortunately, I cannot help you if you see a blank page (which means that error display is suppressed). I need an error messge...

blogtorank 12-04-2006 08:18 PM

Quote:

Originally Posted by Psionic Vision (Post 1129363)




Voted and also will be putting a list here for you to do ;) then you can take the rest of the coders out with this list I'm coming up for new add-ins for you as I'm a person that lives off stats, breathes stats, eats stats and sleeps with stats as you can see the screenshot below why I do ;)

So hopefully your fingers are rested cause I have many options for you to add in!!!

blogtorank 12-04-2006 08:20 PM

Quote:

Originally Posted by nocte (Post 1131890)
Hi,

I upgraded to PHP 5.2.0-0 - now i see a blank page, wenn i open psistats.php

I had Problems with vB CMPS too after upgrading, so i think it's the new PHP Version.

You need to check your error_log files wherever on your server and it's pretty early isn't it to be upgrading to a recent PHP? How many other things are broken too is my question? LOL

nocte 12-04-2006 08:53 PM

Quote:

Originally Posted by Psionic Vision (Post 1131899)
Unfortunately, I cannot help you if you see a blank page (which means that error display is suppressed). I need an error messge...

error reporting is on!

On vB CMPS i got this error: http://www.vbadvanced.com/forum/showthread.php?t=18878

akanevsky 12-04-2006 09:15 PM

Quote:

Originally Posted by blogtorank (Post 1131901)
Voted and also will be putting a list here for you to do ;) then you can take the rest of the coders out with this list I'm coming up for new add-ins for you as I'm a person that lives off stats, breathes stats, eats stats and sleeps with stats as you can see the screenshot below why I do ;)

So hopefully your fingers are rested cause I have many options for you to add in!!!

Can you please post suggestions at visionscripts? Cause this thread is way too long to track suggestions otherwise. Thanks. (for voting too)

711 12-05-2006 01:47 AM

I have installed this mod, and really like it.

One thing I would like to change is this:

In the Top threads and posts section, rather than show the All Time leaders, I'd love to show the most popular threads and posts from the last 24 hours.

I would imagine this would require a WHERE clause added here:

Code:

// top threads by views
        $getthreads = $db->query_read("
                SELECT threadid, title, views
                FROM " . TABLE_PREFIX . "thread
                WHERE visible = 1
                AND forumid NOT IN (0$limitfids)
                ORDER BY views DESC
                LIMIT " . $vbulletin->options['psistats_toptflimit'] . "
        ");

and here:

Code:

// top threads by replies
        $getthreads = $db->query_read("
                SELECT threadid, title, replycount
                FROM " . TABLE_PREFIX . "thread
                WHERE visible = 1
                AND replycount > 0
                AND forumid NOT IN (0$limitfids)
                ORDER BY replycount DESC
                LIMIT " . $vbulletin->options['psistats_toptflimit'] . "
        ");


but I am not familar enough with SQL to do this.

Im guessing it's something close to this:

Code:

WHERE lastpost >= (curdate() - 24*60)
but that produces an error.

Any suggestions?

Thanks!

akanevsky 12-05-2006 05:58 PM

It would be an:
AND lastpost >= " . TIMENOW - 86400 . "
Add it right under the row that says WHERE.

711 12-06-2006 04:11 AM

Quote:

Originally Posted by Psionic Vision (Post 1132598)
It would be an:
AND lastpost >= " . TIMENOW - 86400 . "
Add it right under the row that says WHERE.

I tried that edit, which produces this error:

Code:

Database error in vBulletin 3.6.4:

Invalid SQL:
-86400
                AND forumid NOT IN (0)
                ORDER BY views DESC
                LIMIT 10;

MySQL Error  : 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 '-86400
                AND forumid NOT IN (0)
                ORDER BY views DESC
                LIMIT 10
Error Number : 1064


nonet 12-06-2006 04:27 PM

Excellent Hack!

Installed flawlessly but the "Active", "Non-Active", and "Activity Level" stats don't show. Anybody know if I missed something?

akanevsky 12-06-2006 05:09 PM

Quote:

Originally Posted by 711 (Post 1132982)
I tried that edit, which produces this error:

Code:

Database error in vBulletin 3.6.4:

Invalid SQL:
-86400
                AND forumid NOT IN (0)
                ORDER BY views DESC
                LIMIT 10;

MySQL Error  : 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 '-86400
                AND forumid NOT IN (0)
                ORDER BY views DESC
                LIMIT 10
Error Number : 1064


Try replacing:
TIMENOW - 86400
with:
(TIMENOW - 86400)

Quote:

Originally Posted by nonet (Post 1133288)
Excellent Hack!

Installed flawlessly but the "Active", "Non-Active", and "Activity Level" stats don't show. Anybody know if I missed something?



Check vBulletin user activity settings. Perhaps they are off or set to 0.

711 12-06-2006 06:03 PM

Quote:

Originally Posted by Psionic Vision (Post 1133318)
Try replacing:
TIMENOW - 86400
with:
(TIMENOW - 86400)





Check vBulletin user activity settings. Perhaps they are off or set to 0.


That worked great, thanks!

I just noticed that this query as edited doesn't pull the threads with the most views or replies in the last 24 hours, but rather pulls the threads with the most view or replies all-time that were active in the last 24 hours (lastpost).

But it's close enough :)


Thanks again.

Great work on this hack, my members love it.

Makc666 12-07-2006 09:17 AM

I was wrong in my description.
On the main stats page (psistats.php) the date is displayed in correct format:
dd/mm/yyyy

But in ACP in psiStats 2006 section there is a BUG with how a date must be entered.

As description says:
Quote:

Date of Creation of Your Board
... please specify the correct date here is dd/mm/yyyy format.
But for now that field is parsed in format:
mm/dd/yyyy

In other words on the main page is:
25.10.2002

And in ACP you have to enter for now:
10/25/2002

Please, can you update it to correct format:
dd/mm/yyyy

Thanks :)

aggiefan 12-08-2006 02:23 AM

great script.... its very cool to track the stats.

one request and i dont even know if it is possible but 98% of our requests are from within the US so that doesnt help us a whole lot. Would it be possible to break that down by state (start with the US and add other countries when needed). Im sure this is something we would all love is a breakdown of even more specific data. (maybe replace the country info link with a state breakdown) or add a small link next to it with each countries hits broken down by area (ie states for the US)

AzH 12-13-2006 11:26 AM

Quote:

Originally Posted by Psionic Vision (Post 1125625)
The reason it is not updated is because when user chooses a style using the switcher, it is not saved to his or her account. It is only stored in his or her cookie. The only way to fix this would be to have vBulletin save the style to database, but I am not sure that alterting vBulletin's behavior is the best way to go in this case.

https://vborg.vbsupport.ru/showthread.php?p=1137190 - Possible fix for this issue. It might be something you can incorporate. I'm going to re-install psiStats to see what happens. Will let you know.

halpern 12-15-2006 10:38 AM

Is there a stats pluggin that can be placed in a vbadvanced module? Can this one?

Cybershaolin 12-17-2006 12:18 AM

Excellent mod. :cool:

My moderating team is showing correct but with this mod, I get all my supermods as admins because I let them use some parts of the admincp.

I also noticed many other users having problems with the different part of moderators or supermods.

One suggestion: Why don't you use the same settings than the mod team page use in order to reflect exactly the same information?

McCarroll21 12-17-2006 08:53 AM

This is a great mod, my only problem is getting screen resolutions and color depths to show up. Everything else is working, and I waited the 15 minutes to see if that would help but nothing is happening.

Any help?

Betablocker 12-18-2006 03:38 AM

I to am having problems with screen resolutions and colour depths showing

i have 5 people with 1024x768 showing and with 32 bit
but there are like 80 members a day logging in + who ever else coming to the site. And i use 1280x768 myself and that dont show either.

i am on 1.4.3 and has been running a while on 3 of my sites but the screen resolutions and colour depths don't seem to be right on any of them.

Any idea how i can fix this ?

Great hack and thanks in advance

deeoo 12-18-2006 02:36 PM

Great mod! Installed!
Would be nice to have some stats (like screen-res) clickable to show which users still use 800x600.

ps.
I have 1 Admin, 2 Mods and 1 S-mod, but Psi says just 4 Admins.

akanevsky 12-18-2006 06:09 PM

Quote:

Originally Posted by Betablocker (Post 1140770)
I to am having problems with screen resolutions and colour depths showing

i have 5 people with 1024x768 showing and with 32 bit
but there are like 80 members a day logging in + who ever else coming to the site. And i use 1280x768 myself and that dont show either.

i am on 1.4.3 and has been running a while on 3 of my sites but the screen resolutions and colour depths don't seem to be right on any of them.

Any idea how i can fix this ?

Great hack and thanks in advance

Make sure to enable javascript in your browsers. And, if you use some less known browser, there may be problems too. Works fine in IE, Opera and Firefox.

Quote:

I have 1 Admin, 2 Mods and 1 S-mod, but Psi says just 4 Admins.
Perhaps all have admincp access rights?

Cybershaolin 12-18-2006 06:38 PM

Well, don't you use the same disposition than the moderating team page?

Wouldn't it be more simple in order to reflect the same team like the one we actually have?

Betablocker 12-19-2006 04:40 AM

Quote:

Originally Posted by Psionic Vision (Post 1141105)
Make sure to enable javascript in your browsers. And, if you use some less known browser, there may be problems too. Works fine in IE, Opera and Firefox.

Yes all enabled, i use IE7 and firefox 2 and i can see the stats on some other users sites so not a java problem.

Everything else works perfect.

Cheers

akanevsky 12-20-2006 08:50 PM

Quote:

Originally Posted by Betablocker (Post 1141420)
Yes all enabled, i use IE7 and firefox 2 and i can see the stats on some other users sites so not a java problem.

Everything else works perfect.

Cheers

IE7 is not a stable browser and I cannot provide support for javascript-related stats if you use that.

Betablocker 12-21-2006 08:37 AM

Quote:

Originally Posted by Psionic Vision (Post 1142437)
IE7 is not a stable browser and I cannot provide support for javascript-related stats if you use that.

lol

i use Firefox 2 99% of the time and use IE7 to make sure things look right in both, seen as IE6 & IE7 is used by most the population. And it shows the same in all 3.

Thanks

akanevsky 12-21-2006 06:05 PM

Quote:

Originally Posted by Betablocker (Post 1142700)
lol

i use Firefox 2 99% of the time and use IE7 to make sure things look right in both, seen as IE6 & IE7 is used by most the population. And it shows the same in all 3.

Thanks

It works correctly in firefox 2 on my installation.

Mupetz 12-21-2006 06:21 PM

Quote:

Originally Posted by Betablocker (Post 1142700)
seen as IE6 & IE7 is used by most the population.

ROFL, nobody use IE :tired: , even my grandma has firefox
Maybe microbsoft use it

akanevsky 12-21-2006 06:32 PM

Quote:

ROFL, nobody use IE
Oh? Show me some statistical proof, please, or withdraw your comment (that is, by the way, completely irrelevant to this thread). Thanks.

akanevsky 12-21-2006 09:43 PM

Quote:

Sorry for off topic Psionic
That is a very sincere statement, indeed.

Bison 12-22-2006 12:26 AM

Quote:

Originally Posted by deeoo (Post 1140986)
Great mod! Installed!
Would be nice to have some stats (like screen-res) clickable to show which users still use 800x600.

If he added that feature to this great hack, he might as well put this hack up for sale. I believe that would require a lot of code to tie an individual to a screen setting.

Bison 12-22-2006 12:45 AM

Psionic Vision, What's the list of operating systems and browsers does this program detect?

Betablocker 12-22-2006 08:08 AM

Quote:

Originally Posted by Bison (Post 1143190)
Psionic Vision, What's the list of operating systems and browsers does this program detect?

I am not Psionic Vision as you know:D but hope this helps a little, as seen on one of my sites.

Browsers:
Bot (Ask Jeeves) (0.01%) - 2
Bot (Google) (9.76%) - 1734
Bot (MSN) (1.69%) - 301
Bot (Unknown) (1.4%) - 249
Bot (Yahoo! Slurp) (18.11%) - 3217
Firefox 0.8 (0.01%) - 1
Firefox 0.9 (0.01%) - 1
Firefox 1.0 (0.87%) - 154
Firefox 1.5 (9.58%) - 1702
Firefox 2.0 (12.49%) - 2218
Galeon 1.3 (0.03%) - 5
Internet Explorer 5.0 (0.05%) - 8
Internet Explorer 5.5 (0.17%) - 31
Internet Explorer 6.0 (26.54%) - 4714
Internet Explorer 7.0 (17.67%) - 3139
Netscape 7.0 (0.01%) - 1
Netscape 8.1 (0.01%) - 2
Opera 8 (0.32%) - 56
Opera 9 (0.07%) - 12
Safari (0.24%) - 43
Unknown (0.97%) - 172

Operating Systems:
Free BSD (0.02%) - 2
Linux (0.19%) - 17
Mac OS X (0.54%) - 49
Macintosh (0.02%) - 2
Unknown (38.19%) - 3488
Windows 2000 (4.34%) - 396
Windows 2003 Server (0.86%) - 79
Windows 98 (0.96%) - 88
Windows ME (0.01%) - 1
Windows Vista (1.26%) - 115
Windows XP (53.61%) - 4897

akanevsky 12-22-2006 06:18 PM

Quote:

Originally Posted by Bison (Post 1143185)
I believe that would require a lot of code to tie an individual to a screen setting.

Not really.

Quote:

Psionic Vision, What's the list of operating systems and browsers does this program detect?
You can see that for yourself by exploring the ./includes/psistats/ folder. :)

Quote:

hope this helps a little, as seen on one of my sites.
That is not a full list, but thanks for trying. :)

DementedMindz 12-27-2006 10:27 AM

here is a little gif for OmniWeb's browser just upload it to /includes/psistats/database_agent and it will pick it up auto.

Attachment 58166

cupra 12-27-2006 10:47 AM

wow that is very very cool thing, thx a lot installd!

TheWhite 12-28-2006 03:53 AM

great mod

enrique007 12-28-2006 09:24 AM

I Just installed the mod and I have a couple of questions. are the stats reset every month? how can you tell what your stats are daily, weekly or monthly?

and another thing, how can I tell how many vistors i have recieved on my site?

thanks

akanevsky 12-28-2006 10:43 PM

Quote:

I Just installed the mod and I have a couple of questions. are the stats reset every month? how can you tell what your stats are daily, weekly or monthly?
No, the stats are not reset.

Quote:

and another thing, how can I tell how many vistors i have recieved on my site?
I am sorry, I don't understand the question.

Bison 12-28-2006 10:56 PM

Quote:

Originally Posted by Psionic Vision (Post 1146607)
No, the stats are not reset.



I am sorry, I don't understand the question.

I think he means "how many *un-registered* visitors" have viewed his site.


All times are GMT. The time now is 01:56 PM.

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.03006 seconds
  • Memory Usage 1,854KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_code_printable
  • (29)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete