next »

[roguero]

Hi,
I have a little problem and try to find a solution. Can anybody tell me what file from aurora script must edit to reset my site stat at a 4:00 PM? Now my stats are resetting at 00:00 server time.
Have any idea ?

Thanks in advance,

[Origin]

settings and cron

[vasishta]

teh cronjobs.

put it as 4 instead of 0 i guess.

[NorthOwl]

As previous posters have said wwith aurora it is all in the crons. If you are using cpanel then click cron jobs/Standard and set the desired time from midnight to 4:00pm for both cron.php and cron2.php

[roguero]

I know about crons. they will reset my ads.
I want SITE STATS (today hits, New members) to reset at 4 pm. Now, those stats are resetting at 00:00 server time (GMT+8)

[NorthOwl]

I know about crons. they will reset my ads.
I want SITE STATS (today hits, New members) to reset at 4 pm. Now, those stats are resetting at 00:00 server time (GMT+8)

Yes daily site stats are also included in cron.php so when you set the cron to 4pm it also resets the site stats 

[Origin]

Agree, also you can set default time in setting, and modify a bit your admin parameter to set reset time at any time you want. That's why I mentioned settings.

[roguero]

Yes daily site stats are also included in cron.php so when you set the cron to 4pm it also resets the site stats 

i tried now, but still don't work. i changed crons time to do job now... but they reset only ads and daily clicks from users. General Site Stats are unchanged

[NorthOwl]

i tried now, but still don't work. i changed crons time to do job now... but they reset only ads and daily clicks from users. General Site Stats are unchanged

Oh yes your right about this, I totally forgot, general site stats are set to server clock. I forget which file needs to be modified.

[Delusional]

put this in cron.php around line 110

Code:

echo "<!-- Resetting user daily stats -->\n"; flush();
$sql=$Db1->query("UPDATE user SET clicked_today=0, ptphits_today=0, earned_today=0, ptra_clicks_today='0', emails_today='0', floodguard_today='0', ref_hits_unique='0', ref_hits_raw='0'");

$sql=$Db1->query("DELETE FROM dailyhits");

[roguero]

user stats are resetting well when my crons are running. my problem is General site stats (1,021    Members
22   New Today
81,294    Hits Today
4   Online
27   Payouts Made
$45   Total Paid ), like NorthOwl said, is something about server time... i must edit another file than cron.
BTW... how must be a command line to run crons?

[Delusional]

user stats are resetting well when my crons are running. my problem is General site stats (1,021    Members
22   New Today
81,294    Hits Today
4   Online
27   Payouts Made
$45   Total Paid ), like NorthOwl said, is something about server time... i must edit another file than cron.
BTW... how must be a command line to run crons?

look this is what shows the stats. add to cron the things to del and it should work.

Code:

if($settings[homepage_stats] == 1) {
$sql=$Db1->query("SELECT COUNT(userid) AS total FROM user");
$totalmembers=$Db1->fetch_array($sql);
$sql=$Db1->query("SELECT new_members, hits, clicked FROM stats WHERE date='$today_date'");
$todaystats=$Db1->fetch_array($sql);
$sql=$Db1->query("SELECT SUM(amount) AS total, COUNT(amount) AS amount FROM payment_history");
$totalpaid=$Db1->fetch_array($sql);

$homepagestats="
<div class=\"siteStats\">
<table border=\"0\"  bgcolor=\"#e8e8e8\" cellpadding=\"2\" cellspacing=\"2\" align=\"center\"><td align=\"center\">
".number_format($totalmembers[total])."</td><td align=\"center\"> Members</td></tr>
<td align=\"center\">".number_format($todaystats[new_members])."</td><td align=\"center\"> New Today</td></tr><td align=\"center\">
".number_format($todaystats[hits])." </td><td align=\"center\">Hits Today</td></tr>
<td align=\"center\"> ".number_format($total_online)."</td><td align=\"center\"> Online</td></tr>


<td align=\"center\"> ".number_format($totalpaid[amount])."</td><td align=\"center\"> Payouts Made</td></tr>
<td align=\"center\">$".number_format(round($totalpaid[total],2))."</td><td align=\"center\">Total Paid </td></tr>

</table>

<br />
</div>";
}

[NorthOwl]

Well I just did some research because I also have the issue of aurora being out of sync. Apparently php has a certain default time set on the server, and that is what part of Aurora is using.

[Delusional]

wouldn' be hard to change that, let me do some research on it and i will come up with a mod to take care of this issue, since it should ot go off of the server time.