[ABD] Board Statistics

Any abandoned Extensions will be moved to this forum.

WARNING: Extensions in this forum are not currently being supported or maintained by the original Extension author. Proceed at your own risk.
Forum rules
IMPORTANT: Extension Development Forum rules

WARNING: Extensions in this forum are not currently being supported nor updated by the original Extension author. Proceed at your own risk.
Locked
User avatar
Stoker 4.0
Registered User
Posts: 1483
Joined: Sun Feb 13, 2011 1:33 pm
Location: Funen, Denmark
Name: Ulrik Christensen
Contact:

Re: [DEV] Board Statistics

Post by Stoker 4.0 » Fri Nov 28, 2014 9:09 am

Yahoo! Slurp and Yahoo! DE Slurp seems to be the problem.
Probably the ! in both matches.

User avatar
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John
Contact:

Re: [DEV] Board Statistics

Post by John P » Fri Nov 28, 2014 10:28 am

I also think this and read about problems in bot update.
How is this name saved in botstable?
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign

User avatar
Stoker 4.0
Registered User
Posts: 1483
Joined: Sun Feb 13, 2011 1:33 pm
Location: Funen, Denmark
Name: Ulrik Christensen
Contact:

Re: [DEV] Board Statistics

Post by Stoker 4.0 » Fri Nov 28, 2014 10:33 am

bot_name = Yahoo [Bot]
bot_agent = Yahoo! Slurp

User avatar
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John
Contact:

Re: [DEV] Board Statistics

Post by John P » Fri Nov 28, 2014 10:45 am

The query concats bot_name so why do you have bot _agent in where statement?
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign

User avatar
Stoker 4.0
Registered User
Posts: 1483
Joined: Sun Feb 13, 2011 1:33 pm
Location: Funen, Denmark
Name: Ulrik Christensen
Contact:

Re: [DEV] Board Statistics

Post by Stoker 4.0 » Fri Nov 28, 2014 10:56 am

John P wrote:The query concats bot_name so why do you have bot _agent in where statement?
Not sure I understand your question?

User avatar
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John
Contact:

Re: [DEV] Board Statistics

Post by John P » Fri Nov 28, 2014 11:10 am

The query concats bot_name from your bots_table.
So the result should be " Yahoo [Bot]", etc.

Why is the bot_agent name in the result?
Value's twisted or something else?
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign

User avatar
Stoker 4.0
Registered User
Posts: 1483
Joined: Sun Feb 13, 2011 1:33 pm
Location: Funen, Denmark
Name: Ulrik Christensen
Contact:

Re: [DEV] Board Statistics

Post by Stoker 4.0 » Fri Nov 28, 2014 11:35 am

John P wrote:The query concats bot_name from your bots_table.
So the result should be " Yahoo [Bot]", etc.

Why is the bot_agent name in the result?
Value's twisted or something else?
I dint make the database call ;)
Here is s screenie from phpmyadmin:
http://easycaptures.com/fs/uploaded/932/2802408844.png
Looks as it should

User avatar
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John
Contact:

Re: [DEV] Board Statistics

Post by John P » Fri Nov 28, 2014 11:40 am

Will you send me a dump of your bots table so I can look at it?
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign

User avatar
Stoker 4.0
Registered User
Posts: 1483
Joined: Sun Feb 13, 2011 1:33 pm
Location: Funen, Denmark
Name: Ulrik Christensen
Contact:

Re: [DEV] Board Statistics

Post by Stoker 4.0 » Fri Nov 28, 2014 3:19 pm

John P wrote:Will you send me a dump of your bots table so I can look at it?
Sent by PM

User avatar
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John
Contact:

Re: [DEV] Board Statistics

Post by John P » Fri Nov 28, 2014 8:14 pm

Thanks Stoker, a lot of bots while concat is standard limited to 1024 characters.
Solution on github download
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign

leschek
Registered User
Posts: 789
Joined: Tue Jul 18, 2006 12:49 pm
Contact:

Re: [DEV] Board Statistics

Post by leschek » Fri Nov 28, 2014 11:19 pm

Very useful extension. Here are some issues I have:

In "Users Stats Graphs" it shows time based on server time, but not board time (based on admin's time zone). In my case I use hosting in Canada, but my forum is for users in time zone UTC +1 (and I set that time zone for me), so it make difference 6 hours.

Screen resolution is just wrong: I have two monitors (1600x900 (downscaled from 1920x1080) and 1280x1024), but I use internet browser only on one monitor (1600x900). Statistics shows me 1920x1080x24 and 1307x735x24. I installed "Board statistics" on test board, and there weren't other users.

User avatar
Stoker 4.0
Registered User
Posts: 1483
Joined: Sun Feb 13, 2011 1:33 pm
Location: Funen, Denmark
Name: Ulrik Christensen
Contact:

Re: [DEV] Board Statistics

Post by Stoker 4.0 » Sat Nov 29, 2014 6:40 am

Found another bug when You ban an IP. Take a look at this topic: viewtopic.php?f=466&t=2279061

User avatar
KlausiMaus
Registered User
Posts: 128
Joined: Sat Nov 15, 2014 4:55 pm

Re: [DEV] Board Statistics

Post by KlausiMaus » Sun Nov 30, 2014 2:25 pm

Just one thing, I get no results for
  • •Referrer overview
    •Search engines overview
    •Search terms overview
but there should be some.
Klaus (http://forum.kuhnert.ch/) :: Keep it simple, stupid :!:

rxu
Extensions Development Team
Posts: 2932
Joined: Wed Oct 25, 2006 12:46 pm
Location: Siberia, Russian Federation
Name: Ruslan
Contact:

Re: [DEV] Board Statistics

Post by rxu » Sat Dec 06, 2014 10:55 am

It seems that 'VCHAR:500' is not enough for the referer field. If a user clicks the link from the search results? there can be referers like that (real example):

Code: Select all

http://yandex.ru/clck/jsredir?from=yandex.ru%3byandsearch%3bweb%3b%3b&text=&etext=530.xubkzojhx6eud8qsjfgvx3rncl51g16fitjw40cd1hcidfdte8gcchy9h2nh87znmmiwd5iwazx85kdleo6sgt6lvwc__5lk7dafybogdmqujx2d--ldiflgdmznjmmvmxetdjrerc8lfjba1babuq.64a7df4f390fa20a31ddd5ccd379c9f4acd41eae&uuid=&state=aiuy0dbwfj4epaese6rgeajgs2pi3dw99kudgowt9xsmcv5tmmn9utqsqbnfqxrfmqmbq4byd1xrkwnohyy_xkakq5cbepwdwj_azkkpnycom0cz8sbwrukjaxxsroz6r6xg03o4ebmseaotpqqbumfraojd9txhj0uawwfol2loio8bm6w58foze3nlblqlnqkcfht6ondphwejhmroi8tg0ikhpt3vwcdr7qh2xcm&data=ulnrnmk5wktyejr0ewjfyk1ldmtxddbodkp1mezntwdsx3ndvutjukxfverryvg3vefkrdkydmzhtggxavlusg1jsvl0bjv4rjz3shlqwmr2awjab3zssfa1edjiyknqyjfod2rym084cgs&b64e=2&sign=6c5ab699ccf9443da929002c644c3994&keyno=0&l10n=ru&ref=https%3a%2f%2fyandex.ru%2fyandsearch%3fclid%3d2186618%26text%3d%25d1%2580%25d1%2583%25d0%25b1%25d1%2586%25d0%25be%25d0%25b2%25d1%2581%25d0%25ba%2b%25d1%2581%25d0%25b8%25d1%2582%25d0%25b8%26lr%3d11251&cts=1417855095279&mc=3.521640636343319
which is 1027 chars long. In this case it causes SQL error: Data too long for column 'referer' at row 1 [1406].

User avatar
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John
Contact:

Re: [DEV] Board Statistics

Post by John P » Sun Dec 07, 2014 9:03 am

I looked up the max length a url can be, seems 2083 characters and changed the field.
The extension should be installed again.

@KlausMaus, is your browser sending the referrer? Some browser don't send it.
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign

Locked

Return to “Abandoned Extensions”