php forum
php mysql forum
php mysql smarty
 
Topic Options
#243632 - 04/22/03 10:28 PM stats....
Allusivekudos Offline
Junior Member

Registered: 05/26/02
Posts: 378
Loc: Na
Would there be any way to pull/log some of the stats already generated? Like, I'd love to know how many members join each month and how many logged in on a monthly basis. <br /><br />As it stands now, I have to copy and past it at the end of every month, but it's a pain.<br /><br />Any way to pull this info and store it?<br /><br />-peter

Top
#243633 - 04/23/03 05:02 AM Re: stats.... [Re: adrienne48]
omegatron Offline
Member

Registered: 04/05/01
Posts: 3440
Loc: abingdon,md
Do you use IIP by JustDave. His IIP script will do this for you. You can get it HERE! One of the scripts that gets called in there is called shortstatspal.php and that is the one that does what you want.
_________________________
Chuck S

DIVE IN AND VISIT ME:

Omegatron\'s Reefs

Administrator at ReefTalk

Top
#243634 - 04/23/03 10:14 AM Re: stats.... [Re: sf49rminer]
Medar Offline
Junior Member

Registered: 03/19/00
Posts: 571
Out of curiosity (as I have not yet tried), can you pull the individual pals out of IIP and use them as stand-alones? I know they call a few pages, so a bit of it would need to be re-written in that regard for certain.<br /><br />Anyone ever messed with this? Just curious if it was time-intensive or something that wasn't too consuming.<br /><br />I ask because it would be nice to display a few pals on regular pages outside of IIP.

Top
#243635 - 04/23/03 11:05 AM Re: stats.... [Re: Intel -*RW*-]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
Yeah.... especially if you are using the index page and caching it, you can read the cached info on other pages (like the sidebar does here). <img src="/forum/images/graemlins/smile.gif" alt="" />
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#243636 - 04/23/03 11:24 AM Re: stats.... [Re: Daine]
Allusivekudos Offline
Junior Member

Registered: 05/26/02
Posts: 378
Loc: Na
Omegatron - yes, I have IIP! Maybe I wasn't clear, or I'm not reading the IIP stuff correctly. I'd like to somehow store a cumulative stats things, where it automatically stores/displays every month.<br /><br />So, for instance, it'd store April : New Members and How many members logged in then, May: Same stats, June: Same stats....<br /><br />Does that make more sense, and/or is this already done somewhere?<br /><br />-peter

Top
#243637 - 04/23/03 03:06 PM Re: stats.... [Re: adrienne48]
omegatron Offline
Member

Registered: 04/05/01
Posts: 3440
Loc: abingdon,md
Okay I know what your saying now. Cummulate stats are given by IIP pal and also this is done by threads itself in the admin panel. As far as by month each month that would require a hack to be written for this. Threads by default displays last week month and cummulative total. This is the place to suggest it. Now if you would like one of our developers to personally write this hack for you for a modest fee if no one here is interesting in writing this up any time soon feel free to post in the Developers for Hire forum. I am sure someone can help you out.
_________________________
Chuck S

DIVE IN AND VISIT ME:

Omegatron\'s Reefs

Administrator at ReefTalk

Top
#243638 - 04/23/03 05:13 PM Re: stats.... [Re: sf49rminer]
Allusivekudos Offline
Junior Member

Registered: 05/26/02
Posts: 378
Loc: Na
Thanks omeg!<br /><br />I was actually just suggesting it..... I'll look, think, and ponder for a while and maybe take on doing it myself. I thought I'd suggest it first though. <br /><br />It just seems like threads generates lot's of stats, and it's a shame that they are lost after the end of the month.<br /><br />-peter

Top
#243639 - 04/23/03 05:33 PM Re: stats.... [Re: adrienne48]
omegatron Offline
Member

Registered: 04/05/01
Posts: 3440
Loc: abingdon,md
It is not that they are lost. The date is stored in the tables.
_________________________
Chuck S

DIVE IN AND VISIT ME:

Omegatron\'s Reefs

Administrator at ReefTalk

Top
#243640 - 04/23/03 07:25 PM Re: stats.... [Re: sf49rminer]
Allusivekudos Offline
Junior Member

Registered: 05/26/02
Posts: 378
Loc: Na
Oh, so then this mod could be really easy? If you're saying the data is stored, just not displayed? Did I understand that correctly?<br /><br />-peter

Top
#243641 - 04/23/03 07:39 PM Re: stats.... [Re: adrienne48]
omegatron Offline
Member

Registered: 04/05/01
Posts: 3440
Loc: abingdon,md
Well the fields if I understand what your asking are going to be the following<br /><br /><br /> For the posts the date is stored in the B_Posted table<br /><br /> For the users the registered date is stored in in U_Registered and the last time they were on is stored in U_Laston.<br /><br /> These are all saved as a Unix Timestamp. The timestamp is the current time measured in the number of seconds since the Unix Epoch (January 1 1970 00:00:00 GMT).
_________________________
Chuck S

DIVE IN AND VISIT ME:

Omegatron\'s Reefs

Administrator at ReefTalk

Top
#243642 - 04/23/03 07:41 PM Re: stats.... [Re: sf49rminer]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
Here is a utility to help you figure out what the date is in epoch time. <img src="/forum/images/graemlins/smile.gif" alt="" /> The time.php script is posted here somewhere by me:<br /><br />http://www.joshuapettit.com/time.php
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top



Latest Posts
[7.2.1] - Naked shoutbox
by bellaonline
05/05/12 05:00 PM
[7.x] Stop Forum Spam Integration v0.4
by bellaonline
05/05/12 03:53 PM
Shout Box

(Views)Popular Topics
Known public proxy servers 1689885
Integrated Index Page (IIP) 5.3.1 555705
Finished-[6.5.2] Games Arcade Deluxe v1.9 501236
Integrated Index Page (IIP) 5.1.1 415112
TLD Bv2.1 Released - Threads Links Directory 396822
[6.0x] Who's Online 4.0.0 [Finished] 389412
Finished-[6.5.1] Integrated Index Page (IIP) 6.5 330423
Q & A 298663
Slash UBB 266936
[6.3.x] [beta] Hit Hack 2.0 227970
Forum Stats
13621 Members
59 Forums
37191 Topics
295716 Posts

Max Online: 686 @ 06/28/07 07:04 AM

 

 

 
fusionbb message board php hacks