Addon: Commenter URLs

[tinyblob]

Just finished a quick new addon. Can't remember where it was requested, but i'll find that thread and post there too!

This addon gives you access to a new tag:
<COMMENT_URLS>

This tag produces a list of names and urls relating to people who have commented on your photoblog.

The entries are in this format:

Name [Domain]

The whole entry is a hyperlink to the full specified url of that commenter.

You can see what this addon produces at my website:
over here (http://www.touchnothing.net/blog/index.php?x=links)

UPDATED:
You can download the addon here:
comment_urls v0.5 (http://www.touchnothing.net/files/comment_urls_v0.5.zip)

A couple of things to note:

The entries are formatted in an unordered list, with the id of "comment-urls". So you can define that in your CSS if you don't like the default formatting.

If like me you don't want bullet points use the following:


#comment-urls {
list-style:none;
margin:0;
padding:0;
}


In future versions i'll add further formatting options.

Also beware of commenters who don't enter absolute urls (i.e they omit the http:// part). This should be error corrected at the commenting stage, but isn't. This will be rectified in v1.5.

Update: No longer displays duplicate urls.
Update: Prefixes http:// to all urls which don't include it already.

[blinking8s]

coolness....

[cbtoday]

Nice, thankyou!

cbtoday,
todayistoday.com

[tinyblob]

Updated

[Dan]

Right on, this is great. Thanks!

I've just downloaded the update which says it stops duplicates from appearing. For some reason, I'm still getting duplication (http://genestho.ca/genestho/index.php?x=links) which I think is cause by the absolute URL vs. those missing the http://

Any thoughts to band-aid this issue prior to version 1.5?

[tinyblob]

Yep, dan you're correct.
For example:

owl and dragon [owlanddragon.com]
owl and dragon [owlnaddragon.com]
owl and dragon [owlanddragon.com]
owl and dragon [owlanddragon.com]

taken from your site

and the links those comments go to:

http://www.owlanddragon.com/pixelpost
http://www.owlnaddragon.com/pixelpost/
http://www.owlanddragon.com/pixelpost/
http://www.owlanddragon.com/pixelpost/admin/index.php


First one is the correct url, second one is also correct and has a trailing slash, third one is spelt wrong, fourth one is a link to that persons administration section (!!!!).

The duplication update isn't intelligent, it just ignores exact duplicates in the URL field.

What i do is log in with phpmyadmin and moderate the urls myself, but i don't have anywhere near as many commenters as you do :D

[Dan]

Right. Good call, but a time consuming process. I've at least removed the link to the admin section (little oops on an auto-fill I bet)!

I've also noticed some get a 404 because the addon concatenates a "www" to the front where as some links are to subdomain links e.g. :Fjona [thisbirdseyeview.blogspot.com] and fjona [thisbirdseyeview.com], which both give 404's...

Not a huge issue, but perhaps something to think about for future version.

Again, thank you soooo much for this. It's great!

[tinyblob]

actually, both the Fjona links 404 because they don't have http://.

Hyperlinks with http:// = Absolute urls.
Hyperlinks without http:// = Relative urls.

Not my fault :)

[tinyblob]

To help you out, i'm going to make the addon ADD http:// if it's not present.
2 mins.

[tinyblob]

Dan. haha. Your comment was perfect!
Just as i wanted to test it, you commented, and didn't type http://!!

Download the new version, it'll sort your problems.... Well, at least one of them ;)

[Dan]

HA! Ya, I noticed that too!! Dude, you're awesome. Thanks for this. :D

[Sergio de la Torre]

Looks fine! I have a question: ¿How can I show only the commenters with a minimum number of commentaries?

Sergio

[Sergio de la Torre]

If you want that this appears only the commenters with more than "X" comments

$query = mysql_query("select url, name from (select distinct(url) as url,sum(1) as comentarios, name as name from pixelpost_comments group by url order by name) as tabla where comentarios > 'X'");

instead of (line 49)

$query = mysql_query("select distinct(url),name from ".$pixelpost_db_prefix."comments group by url order by name");


Put the minimum number of comments instead the "X"

http://www.sergiodelatorre.com/photoblog/enlaces

Sergio

[raminia]

Security alert:
Be aware of spams. This addon could grab new spammer bots to your site. You should use it if your comments are spam free or asking people for entering a code before submitting the comments (captcha)

[tinyblob]

addons should always be implemented at the users discretion ;)

[sal]

Hi tinyblob,
I just added your "Comment Urls" addon to my links page.
And again it is working fine.
Thanks a lot.

I made a very little mod:
instead of "order by name" i changed this line with "order by datetime desc" and added "limit 3", so that only the last three commenters will be shown.
The complete line now goes like this:
$query = mysql_query("select distinct(url),name from ".$pixelpost_db_prefix."comments group by url order by datetime desc limit 3");


I think it's valuable addition, but i know there is a danger of spam.
I would like to use it as long as possible. When I notice it might be abused by spammers I will delete it. Hope it will never happen...

Thank you, tinyblob.

regards
sal

[tinyblob]

I'll be re-writing this with the launch of Pixelpost v1.5.
If necessary, i'll re-write it to help avoid spammers, but till then, just keep your eye on your commenters.

[unseen]

do you think there's a way to have it list the top five (or ten or whatever) commenters overall? also, if someone doesn't type in a url, can it still list the name? or is this already going to be written into 1.5?

[tinyblob]

i can make the addon do anything you want.
the "problem" with the commenting system is that it doesn't rely on usernames/passwords. commenters are not designated users. the reason for the speech marks around problem is that this is intentional, and not actually an issue in the global scheme of things (who wants to register just to leave a comment on a photoblog!?), but as far as addons like this go, it's not easy to associate returning users unless they provide exactly the same details.
when i re-write this addon for v1.5, i'll include configuration options. i'll allow you to list the top x number of visitors. the issue with this is that they MUST have the same details for it to work. right now i'm grouping by the web address, rather than the name. the problem is that people forget to type http:// a lot of the time. we check for this in Pixelpost 1.5, but we don't prefix it if it's missing, because who's to say their url doesn't start with https://? unlikely, but still an issue.
anyway. i've added "http://" as the starting value for the url field in my comments template, and i examine comments as they come in for inconsistencies.
as for the lack of urls, yeah, okay i add that flexibility. i didn't in this release because it's really intended for links pages, but sure. if you want that feature now jade, pester me on msn later.

[heatheranne]

Does anyone have the addon for this? I've been trying to get it the past week and the links are dead for the addon site and the download.

[Dan]

Heartheranne,
Check your personal messages. Just posted a link for you.

[heatheranne]

Thanks. Got it.

[Personne]

Dan I'm interested too ;) can you please give me a link to download this great addon ?

Thanks a lot.

[DikkieBurger]

Does anyone has this addon for me so I can download it????

[namaste]

It should be great this plugin!
Where is it?

[Ubbe]

bump..? could anybody post a link?

[Dan]

Here ya go mates:

http://www.processinteractive.ca/comment_urls.zip

Special thanks to tinyblob for having written this fab pluggin.

Enjoy!
Dan

[Dennis]

Awesome: I'll be sure to check it out!

[Dan]

No probs.

Hit the processinteractive URL right above your post.

D

[kheops]

oh sorry Dan i deleted my post cause i've found it stupid
for one reason the most recent post is on page 1 and oldest on page 3
i'll investigate the link, for now i have a blank page when comment_urls.php is uploaded

[Dan]

Heh, ya you were quick!

Let me know if you still have trouble. Might be able to help.

D

[kheops]

thanks Dan, i uploaded the content of http://www.processinteractive.ca/comment_urls.zip in the addons folder, but get a blank page of my blog
in the "admin" page, the new addon doesn't shows up

if you have any idea ?

[Dan]

Okay to clarify, you've uploaded the comment_urls.php file into your addons folder, ya?

Then, on the page you want commentators to show up, you've added the <COMMENT_URLS> tag, right?

If that's all good, in your admin area you should see:
Commenters Websites (comment_urls - version 0.5) - status: ON
(BUT you might have to turn it on if it's read as OFF).

If you're still not seeing it, you may be experiencing some sort of conflict between two addons. Double-check that the PHP file has made its way onto your web server.

Let's start there.
D

[kheops]

yes the php is uploaded well
date is 14 july 2006
i didn't even try to add the tag, since as soon as the file is uploaded, i get a blank page on the index
looking further, thanks for your support :)

Okay to clarify, you've uploaded the comment_urls.php file into your addons folder, ya?

Then, on the page you want commentators to show up, you've added the <COMMENT_URLS> tag, right?

If that's all good, in your admin area you should see:
Commenters Websites (comment_urls - version 0.5) - status: ON
(BUT you might have to turn it on if it's read as OFF).

If you're still not seeing it, you may be experiencing some sort of conflict between two addons. Double-check that the PHP file has made its way onto your web server.

Let's start there.
D

[benalika]

Hi,
The link on the first post for this addon is broken, does anyone can post a link where I can find it?

Thank you

Ali.

[Dkozikowski]

Hi,
The link on the first post for this addon is broken, does anyone can post a link where I can find it?

Thank you

Ali.

Looks like it may be 4 posts up from this one :)