Link Blog and Top Commentators for Drupal
I want to point out a few new features added to this blog in the past few days.
Link Blog
The first is the addition of a link blog. I track hundreds of feeds everyday, so of course I see a lot of great posts that I never get a chance to blog about. From now on, the best of these posts will go into the link blog. You can see the most recent additions in the sidebar under the heading "Great Posts Elsewhere". Clicking the "more" link under those posts will take you to an archive of all links (I just started this, so there's no much in the archive yet). There's also a feed available if anyone's interested.
Notice I didn't go the usual route of creating a shared feed through Google Reader, although that's certainly the easiest way to create a link blog. Google Reader is great, but I prefer to use an offline reader. Also, if I used Google's javascript widget to publish those links here, it wouldn't pass any link love. I'm only linking to posts that really deserve the attention, so I want those links to be visible to both users and search engines.
Top Commentators
The second addition is the "top commentators" block, which rewards those who've commented here in the past 30 days. Right now it lists the top 6 contributors. Wordpress users can accomplish this easily with a plugin, but this blog is powered by Drupal, which has no such plugin. Still, I was able to implement something similar with a bit of PHP. If you're blogging with Drupal and want to add this, here's the code I'm using in that block:
<?php$users = db_query("SELECT COUNT(cid) AS count, mail, name, homepage FROM {comments} WHERE uid != 1 And timestamp > (unix_timestamp(now()) - 3600*24*30) GROUP BY mail ORDER BY count DESC LIMIT 6");print "<ul>";while ($user = db_fetch_object($users)) {print "<li>".l($user->name,"$user->homepage")." ($user->count)</li>";}print "</ul>";?>
Note that this assumes your comments are from anonymous users (without an account on your drupal installation). If you have a mix of anonymous and registered users (other than yourself) you'll need to do some tweaking to make it work.










Matthew wrote:
Interesting additions, i like both features. I just got into feedreading myself, much easier that way
Suhaimi wrote:
Awesome, that'll help a Drupal site as active in comments as in a Wordpress system.
Everyday Weekender wrote:
I think you'll find that these will help drive visitors to you're site.. at least that's what I was told :)
good luck!
Dave wrote:
I like the idea of adding a link blog in addition to a normal blog, like you said, it's an easy way to share the items that you think are interesting.
I'm doing a similar thing using Google Reader's shared items. You can generate an embed script for putting your links into a page and then just click "Share" on any items that you want to add. It's nice and easy.
J.B.Slife wrote:
I think the "link blog" is a great idea. Something that I'm going to have to try on my blog.
Aniela wrote:
The linkblog is a good ideea. I'm sure the blogs you're reading will appreciate the link back as well. As for the top commentators, it's been proven to increase comments a lot !
origami rose wrote:
This will definitely improve blog participation, good going.
Web Designer wrote:
Adding this plugin really does help people commenting. It is a good way to motivate your readers to add a comment. I added it to my blog and saw an immediate increase in comments.
make money online wrote:
i will implement this on my blog! it seems to work, you get more people commenting!
TOM wrote:
This will definitely improve blog participation, good going.
The linkblog is a good idea. I'm sure the blogs you're reading will appreciate the link back as well. As for the top commentators, it's been proven to increase comments a lot !
SimonB wrote:
Thanks for sharing the Top Commenters code. I've added it to my site and it works great!
Joseph The Google Adwords Guru wrote:
Hi,
I'm Joseph the google adwords guru personally feels that the linkblog is a great idea. Such a unique feature helps people to comment. A large number of google reader are being motivated to comment on the blog. It's really nice and easy.
seo wrote:
it works for me too, thanks
Mohammad Reza Mousavi wrote:
Add my weblog to your directory
http://onlykhatami.persianblog.ir/
Dennis Good wrote:
Nice tip, Kevin. This will be of great help to us bloggers. Cheers!
Women's Clothes wrote:
Hope this works well for you.
Anonymous wrote:
It's very usefule.
???????
Agence communication wrote:
Where can I find top commentators code please??
Agence communication Montreal
?????? wrote:
???????? ??????????, ??? ??????? ????? ?????? ??? ??? ?????????. ?????-?????? ???????-????? ????? ????????? ???? ?????????? ???????????, ? ?????? ? ????, ? ??-???? ????? ??????????? ??? ??? ?????? ??? ? ???????. ??? ????? ????? ???????? ? ?????????? ???????????
revizyon matbaacilik wrote:
Thanks, great.
Jordan wrote:
Very Useful information , this is both good reading for, have quite a few good key points, and I learn some new stuff from it too, thanks for sharing your information.
regards,
handbags
haber wrote:
Thank you very rich indeed a site
Al kabin wrote:
konteyner, prefabrik, kabin, su deposu uret?m? ve sat?m?
site survey wrote:
I would put my tail between my legs and beg joomla to take me back. Joomla is really nice, she is readily cusomizable. You need just a day of reading one of the books on her, and she will treat you well. You seem like a tech guy. Read a joomla book to famililize with creating custome html, etc.
haber wrote:
Thankyou for sharing..
Pranburi wrote:
it works for me too, thanks
Sandra wrote:
What I find so itnerseitng is you could never find this anywhere else.
dzcxvq wrote:
u9KJ4C busqougxhkzg
ccvlgubu wrote:
86Mb8p uxjeunhwepgi
Oto Kiralama wrote:
Thanks for sharing the Top Commenters code. I've added it to my site and it works great!
AOL Directory wrote:
Read it all! Nice information, many thanks to the author. It is incomprehensible to me now, but in general, the usefulness and significance is overwhelming. Thanks again and good luck!
essay writer wrote:
IMHO, ut's easier to build a view using Views module with the core Statistic module enabled. Create a view for comments, sort them by Most viewed, descending, and limit your list to, say, 10. You'll be able to add whatever fields you deem necessary, such as title of a commented node, or user's comments count, or user's URL…
essay writer wrote:
Top Commentator surely helps to attract good non-spammy comments to your website. This in turns helps you with new and original content. Thus even if you don't post too often, your web page is continuously renewed which is a good sign for Google.
AdSeo - SEO - Promoting business wrote:
We will explode your mega income by promoting your site Worldwide.
I offer full advertising and optimization to boost your business up on top for only $99! contact me office@adseo.org (www.adseo.org)
GSA Schedules wrote:
I have seen here the article and i read your drupal code which is very good. It is very helpful to many persons.
Hernan | como adelgazar barriga wrote:
Genial entrada me encanta tu manera de escribir. He leído rápidamente sus mensajes y puedo ver que su sitio web tiene un potencial enorme para ayudar a muchas personas que buscan este tipo de soluciones. Sin embargo todos los que trabamos en internet tenemos necesidades para mejorar nuestros negocios y esta es una buena manera de hacerlo.
Gracias por dejarme escribir aqui en su pagina.
Gsa Schedule Services wrote:
I will be implementing it on my site and really it is very helpful to me and thanks for sharing this code.
Post new comment