Search found 530 matches

by Marcus Wendel
Mon Sep 16, 2013 6:15 pm
Forum: phpBB Discussion
Topic: Spiders & bots to add to phpBB
Replies: 901
Views: 517621

Re: Spiders & bots to add to phpBB

Bot name: SEOkicks [Bot] Agent match: SEOkicks User agent string: Mozilla/5.0 (compatible; SEOkicks-Robot +http://www.seokicks.de/robot.html) Website: http://www.seokicks.de/robot.html Bot name: UberMetrics [Bot] Agent match: ubermetrics User agent string: Mozilla/5.0 (compatible; uMBot-LN/1.0; mail...
by Marcus Wendel
Sun Sep 08, 2013 9:03 am
Forum: phpBB Discussion
Topic: Spiders & bots to add to phpBB
Replies: 901
Views: 517621

Re: Spiders & bots to add to phpBB

Bot name: ADmantX [Bot]
Agent match: ADmantX
User agent string: ADmantX Platform Semantic Analyzer - ADmantX Inc. - www.admantx.com - support@admantx.com
Website: http://www.admantx.com

/Marcus
by Marcus Wendel
Fri Aug 16, 2013 3:02 pm
Forum: phpBB Discussion
Topic: Spiders & bots to add to phpBB
Replies: 901
Views: 517621

Re: Spiders & bots to add to phpBB

Bot name: Yunyun [Bot]
Agent match: YRSpider
User agent string: Mozilla/5.0 (compatible; YRSpider; +http://www.yunyun.com/SiteInfo.php?r=about)
Website: http://www.yunyun.com
by Marcus Wendel
Sun Aug 11, 2013 5:46 pm
Forum: phpBB Discussion
Topic: Spiders & bots to add to phpBB
Replies: 901
Views: 517621

Re: Spiders & bots to add to phpBB

Bot name: Easou [Bot]
Agent match: EasouSpider
User agent string: Mozilla/5.0 (compatible; EasouSpider; +http://www.easou.com/search/spider.html)
Website: http://www.easou.com

/Marcus
by Marcus Wendel
Fri Apr 26, 2013 8:52 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: Posts per month?
Replies: 16
Views: 1508

Re: Posts per month?

This is the query I use to grab weekly post counts: SELECT yearweek(date(from_unixtime(post_time))) AS week, COUNT(*) AS num_posts FROM phpbb_posts GROUP BY yearweek(date(from_unixtime(post_time))) On a board with slightly over one million posts, the query takes roughly 6 seconds to run. It would b...
by Marcus Wendel
Mon Apr 22, 2013 1:18 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: Posts per month?
Replies: 16
Views: 1508

Re: Posts per month?

Lumpy Burgertushie wrote:I believe he only wants to know how many posts were made.
Correct.

Something that I can use a basis for a statistics like:
2013
January - 100 posts
Febuary - 102 posts
March - 110 posts

/Marcus
by Marcus Wendel
Mon Apr 22, 2013 10:43 am
Forum: [3.0.x] MOD Writers Discussion
Topic: Posts per month?
Replies: 16
Views: 1508

Re: Posts per month?

I now realize I was not very clear, I wanted to have something showing the post for each month, for example January 2013 100, February 2013 104, March 2013 114. and not just an average for all years. Sorry.

/Marcus
by Marcus Wendel
Mon Apr 22, 2013 9:40 am
Forum: [3.0.x] MOD Writers Discussion
Topic: Posts per month?
Replies: 16
Views: 1508

Re: Posts per month?

No modification, just help with the actual query that I can run in phpmyadmin.

/Marcus
by Marcus Wendel
Mon Apr 22, 2013 9:22 am
Forum: [3.0.x] MOD Writers Discussion
Topic: Posts per month?
Replies: 16
Views: 1508

Re: Posts per month?

Not really, a MySQL-query is what I need. I only want to be able to get this data on a few occassions so there is no need for a mod.

/Marcus
by Marcus Wendel
Mon Apr 22, 2013 8:36 am
Forum: [3.0.x] MOD Writers Discussion
Topic: Posts per month?
Replies: 16
Views: 1508

Posts per month?

I want to see the posts per month in the boards I manage and I assume that I need to run a MySQL-query to see that? Unfortunately I know almost nothing about MySQL-queries so I would appreciate help with this, thanks.

/Marcus
by Marcus Wendel
Fri Mar 29, 2013 8:09 pm
Forum: phpBB Discussion
Topic: Spiders & bots to add to phpBB
Replies: 901
Views: 517621

Re: Spiders & bots to add to phpBB

Pony99CA wrote:
Marcus Wendel wrote:This bot was not so helpful:
Guest IP: 173.231.146.52 » Whois
Crawler
Yeah, that's not very useful.

Did you check the IP address?

Steve
Nothing helpful, it apparently belongs to www.voxel.net.

/Marcus
by Marcus Wendel
Fri Mar 29, 2013 6:35 pm
Forum: phpBB Discussion
Topic: Spiders & bots to add to phpBB
Replies: 901
Views: 517621

Re: Spiders & bots to add to phpBB

This bot was not so helpful:
Guest IP: 173.231.146.52 » Whois
Crawler
/Marcus
by Marcus Wendel
Thu Mar 28, 2013 8:54 pm
Forum: phpBB Discussion
Topic: Spiders & bots to add to phpBB
Replies: 901
Views: 517621

Re: Spiders & bots to add to phpBB

Bot name: Google+ Snippet [Bot]
Agent match: developers.google.com/+/web/snippet/
User agent string: Mozilla/5.0 (Windows NT 6.1; rv:6.0) Gecko/20110814 Firefox/6.0 Google (+https://developers.google.com/+/web/snippet/)
Website: https://developers.google.com/+/web/snippet/

/Marcus
by Marcus Wendel
Sun Mar 24, 2013 6:16 am
Forum: phpBB Discussion
Topic: Spiders & bots to add to phpBB
Replies: 901
Views: 517621

Re: Spiders & bots to add to phpBB

Bot name: Akregator [Bot] Agent match: Akregator User agent string: Akregator/4.10.1; syndication Website: http://akregator.sourceforge.net/index.php Bot name: Grapeshot [Bot] Agent match: Grapeshot User agent string: Mozilla/5.0 (compatible; GrapeshotCrawler/2.0; +http://www.grapeshot.co.uk/crawler...
by Marcus Wendel
Thu Mar 07, 2013 7:28 pm
Forum: phpBB Discussion
Topic: Spiders & bots to add to phpBB
Replies: 901
Views: 517621

Re: Spiders & bots to add to phpBB

Bot name: Tweeted Times [Bot] Agent match: TweetedTimes User agent string: Mozilla/5.0 (compatible; TweetedTimes Bot/1.0; +http://tweetedtimes.com) Website: http://www.tweetedtimes.com Bot name: Bing Preview [Bot] Agent match: BingPreview User agent string: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleW...

Go to advanced search