### Board mmajunke.de ###

Board zu Themen der Website www.mmajunke.de
Aktuelle Zeit: Do 17. Aug 2017, 00:41

Alle Zeiten sind UTC + 1 Stunde




Ein neues Thema erstellen Auf das Thema antworten  [ 5 Beiträge ] 
Autor Nachricht
 Betreff des Beitrags: showing to much visitors
Ungelesener BeitragVerfasst: So 19. Mai 2013, 21:58 
Offline
Power-User
Power-User

Registriert: Fr 15. Mär 2013, 23:03
Beiträge: 33
Hello Micha,

I have a question, i had the parameter "Count Ip as new" on Locktime ( locktime = 15)
, with this setting we had normally between 30 and 90 visitors a day,
i changed it couple of days ago the parameter to Daily and i see now the last couple of days amount of visitors is between 200 end 350 a day,

I checked also the table vvisitcounter and while i expected only 1 IP adres stored in the table for example 85.150.149.xxx ( edited last number in xxx)
i see with this sql :
SELECT ID, FROM_UNIXTIME(tm) , Ipraw FROM `jos_vvisitcounter` WHERE FROM_UNIXTIME(tm ,"%Y-%m-%d")= "2013-05-19" and ipraw = "85.150.149.xxx" order by tm
result is this:
3220 2013-05-19 14:34:04 85.150.149.xxx
3226 2013-05-19 14:49:06 85.150.149.xxx
3234 2013-05-19 15:17:06 85.150.149.xxx
3244 2013-05-19 15:45:06 85.150.149.xxx
3251 2013-05-19 16:13:05 85.150.149.xxx
3259 2013-05-19 16:41:05 85.150.149.xxx
3264 2013-05-19 17:09:05 85.150.149.xxx
3271 2013-05-19 17:37:05 85.150.149.xxx
3280 2013-05-19 18:05:05 85.150.149.xxx
3284 2013-05-19 18:33:05 85.150.149.xxx
3286 2013-05-19 19:01:05 85.150.149.xxx
3291 2013-05-19 19:29:05 85.150.149.xxx
3294 2013-05-19 19:57:05 85.150.149.xxx
3297 2013-05-19 20:25:05 85.150.149.xxx
3303 2013-05-19 20:53:05 85.150.149.xxx
3307 2013-05-19 21:21:05 85.150.149.xxx
3312 2013-05-19 21:49:05 85.150.149.xxx
3318 2013-05-19 22:17:05 85.150.149.xxx
3323 2013-05-19 22:45:04 85.150.149.xxx

How is this possible? , or did i do something wrong?


Thanks
Jac


Nach oben
 Profil  
Mit Zitat antworten  
 Betreff des Beitrags: Re: showing to much visitors
Ungelesener BeitragVerfasst: Mo 20. Mai 2013, 10:26 
Offline
Moderator
Moderator
Benutzeravatar

Registriert: Di 4. Mai 2010, 18:44
Beiträge: 639
Wohnort: Hennigsdorf
Hi Jac,

You choose Locktime = 15. This means: the counter counts a IP after 15 minutes as new.

Let us check the timings:

jaccies hat geschrieben:
3220 2013-05-19 14:34:04 85.150.149.xxx
3226 2013-05-19 14:49:06 85.150.149.xxx
> 15 Min ( 49 - 34 ) +1
3234 2013-05-19 15:17:06 85.150.149.xxx
> 15 Min ( 17 - ... ) +1
3244 2013-05-19 15:45:06 85.150.149.xxx
> 15 Min ( 45 - 17 ) +1
3251 2013-05-19 16:13:05 85.150.149.xxx
> 15 Min ... +1
and so on..


Now, it is all correct.

The user with above ip adress comes often to your side. You should check whether it is a Bot. If so, then add them to the Filter list.

If there are many real "long time" users at your side, you should increase the locktime or set it to "daily".

Greetins
Micha


Nach oben
 Profil  
Mit Zitat antworten  
 Betreff des Beitrags: Re: showing to much visitors
Ungelesener BeitragVerfasst: So 26. Mai 2013, 09:02 
Offline
Power-User
Power-User

Registriert: Fr 15. Mär 2013, 23:03
Beiträge: 33
micha hat geschrieben:
Hi Jac,

You choose Locktime = 15. This means: the counter counts a IP after 15 minutes as new.

Let us check the timings:

jaccies hat geschrieben:
3220 2013-05-19 14:34:04 85.150.149.xxx
3226 2013-05-19 14:49:06 85.150.149.xxx
> 15 Min ( 49 - 34 ) +1
3234 2013-05-19 15:17:06 85.150.149.xxx
> 15 Min ( 17 - ... ) +1
3244 2013-05-19 15:45:06 85.150.149.xxx
> 15 Min ( 45 - 17 ) +1
3251 2013-05-19 16:13:05 85.150.149.xxx
> 15 Min ... +1
and so on..


Now, it is all correct.

The user with above ip adress comes often to your side. You should check whether it is a Bot. If so, then add them to the Filter list.

If there are many real "long time" users at your side, you should increase the locktime or set it to "daily".

Greetins
Micha


Hello Micha,
i dont think you understood what i did , for 2 months i had the parameter "Count Ip as new" on Locktime ( locktime = 15)
my amount of visitors was between 30 and 90
last week i changed the parameter "Count Ip as new" to DAILY , since then the amount of visitors is between 200 end 350 a day.
So that value is not possible, what could cause that high value?

In the mean time i have reset (truncate) the table and "Count Ip as new" on Locktime ( locktime = 120)
, counter value is realistic now, again between 30 and 90 visitors.

Question, can i change the value Locktime on the fly?, or change from Locktime to daily on the fly , or should this parameter be set only once when table is created?

Thanks
Jac
then i got suddenly visitors amount of 200 end 350 a day


Nach oben
 Profil  
Mit Zitat antworten  
 Betreff des Beitrags: Re: showing to much visitors
Ungelesener BeitragVerfasst: So 26. Mai 2013, 12:31 
Offline
Moderator
Moderator
Benutzeravatar

Registriert: Di 4. Mai 2010, 18:44
Beiträge: 639
Wohnort: Hennigsdorf
Hi Jac,

ah, yes.. i misunderstand. Then it would be really strange.

The parameter "Count Ip as new" can be changed at runtime (on the fly). Depending on the choosen value simply another SQL executed. With the table that should have nothing to do, except it is something wrong with the time of the database (but even then ..)

Code:
// Daily
$query = "SELECT COUNT(*) FROM " . $this->s_createtableName .
       " WHERE ip=UNHEX(SHA1('$ip')) AND" .
       " tm BETWEEN UNIX_TIMESTAMP(DATE(NOW())) AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)";

// By Locktime
$query = "SELECT COUNT(*) FROM " . $this->s_createtableName .
       " WHERE ip=UNHEX(SHA1('$ip')) AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '$this->locktime' ) ";


Therefore I have no idea about the cause of the problem.

A question. You have only one counter configured or more ?
( if more then one: others are readonly counters ? if not, they write in different tables ? )

Greetings
Micha

PS.: on my testsystem it works fine..


Nach oben
 Profil  
Mit Zitat antworten  
 Betreff des Beitrags: Re: showing to much visitors
Ungelesener BeitragVerfasst: So 26. Mai 2013, 22:27 
Offline
Power-User
Power-User

Registriert: Fr 15. Mär 2013, 23:03
Beiträge: 33
micha hat geschrieben:
Hi Jac,

ah, yes.. i misunderstand. Then it would be really strange.

The parameter "Count Ip as new" can be changed at runtime (on the fly). Depending on the choosen value simply another SQL executed. With the table that should have nothing to do, except it is something wrong with the time of the database (but even then ..)

Code:
// Daily
$query = "SELECT COUNT(*) FROM " . $this->s_createtableName .
       " WHERE ip=UNHEX(SHA1('$ip')) AND" .
       " tm BETWEEN UNIX_TIMESTAMP(DATE(NOW())) AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)";

// By Locktime
$query = "SELECT COUNT(*) FROM " . $this->s_createtableName .
       " WHERE ip=UNHEX(SHA1('$ip')) AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '$this->locktime' ) ";


Therefore I have no idea about the cause of the problem.

A question. You have only one counter configured or more ?
( if more then one: others are readonly counters ? if not, they write in different tables ? )

Greetings
Micha

PS.: on my testsystem it works fine..


Hello Micha,

thanks for answer.
I think that was the problem i have 2 counters with the same table and both set on read_only = NO
i changed only one counter from Locktime to Daily :?
After the reset ( truncate ) i have set one counter to Read_only = YES.
i will try to set the "Count Ip as new" to Daily only at the counter which is set to REad_only = NO ,
i think it will work now.

regards
Jac ( translation to dutch almost finished , when ready i will sent it to you )


Nach oben
 Profil  
Mit Zitat antworten  
Beiträge der letzten Zeit anzeigen:  Sortiere nach  
Ein neues Thema erstellen Auf das Thema antworten  [ 5 Beiträge ] 

Alle Zeiten sind UTC + 1 Stunde


Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 1 Gast


Du darfst keine neuen Themen in diesem Forum erstellen.
Du darfst keine Antworten zu Themen in diesem Forum erstellen.
Du darfst deine Beiträge in diesem Forum nicht ändern.
Du darfst deine Beiträge in diesem Forum nicht löschen.
Du darfst keine Dateianhänge in diesem Forum erstellen.

Suche nach:
Gehe zu:  
cron
Impressum
Powered by phpBB

Deutsche Übersetzung durch phpBB.de