ADDON: Advanced Pixelpost Comment Statistics

[Dkozikowski]

ADVANCED PIXELPOST COMMENT STATISTICS v1.01

http://pixelpost.org/v1/devfiles/197_commentStatsFAN.png
Last updated on: May 10th, 2007

FEATURES

Multi-lingual:

English
Polish
German
Dutch
Spanish
Persian
Italian

Email link that generates a thank you message
Pixelpost v1.5 & v1.6 compatible
Automatic database install and upgrade from v0.5
+ more . . .


LANGUAGE PAK's
Language file Updates:

Spanish, updated 04/17/2007. Download (http://www.dwilkinsjr.com/public/pixelpost/myaddons/lang_pak/apcs/comment_stats_lang_pak_spanish_v1.01.zip)
Italian, added 05/10/2007. Download (http://www.dwilkinsjr.com/public/pixelpost/myaddons/lang_pak/apcs/comment_stats_lang_pak_italian_v1.01.zip)


ADDON INFO
Addon Type:
Admin Addon

Description:
This admin addon allows you to view various tidbits of information pertaining to your photoblog comments and commenter's.

Addon Details:
Version: 1.01
Added: 2007-01-18
Updated: 2007-05-10
Requires Pixelpost: v1.5/1.6

SCREEN CAPTURES
Screen Captures:
Click each thumbnail for a better view!
IP and Email address have been pixelated to protect my commenter's privacy.

Main Breakdown Page:
The breakdown page allows you to view statistical data pertaining to your published and moderated comments!
You can choose to view only published or both published and moderated comments.

http://www.dwilkinsjr.com/public/pixelpost/screenshot/apcs_v_1_0/thumbnail/statsBreakdown_thumb.jpg (http://www.dwilkinsjr.com/public/pixelpost/screenshot/apcs_v_1_0/statsBreakdown.jpg)

Commenter's Page:
The Commenter's page allows you to see the total amount of comments per commenter and what their comment was for each image they have commented on!
By clicking on the total number of comments, their data will be displayed!
You can also choose to view only published or both published and moderated comments as well as enabling/disabling thumbnails and changing the date/time format output.
Note: moderated comments are shown with a yellow background

http://www.dwilkinsjr.com/public/pixelpost/screenshot/apcs_v_1_0/thumbnail/statsCommenters_thumb.jpg (http://www.dwilkinsjr.com/public/pixelpost/screenshot/apcs_v_1_0/statsCommenters.jpg)

Popular Page:
The Popular page allows you to view what images have the most comments. Again, click on the comment total and an "exploded" view will appear showing you all comments for that specific image!
You can also choose to view only published or both published and moderated comments as well as enabling/disabling thumbnails and changing the date/time format output.
On top of that, if a commenter has supplied an email address, you may click on their email to send a pre-formatted message thanking them for their comment!
Note: moderated comments are shown with a yellow background

http://www.dwilkinsjr.com/public/pixelpost/screenshot/apcs_v_1_0/thumbnail/statsPopular_thumb.jpg (http://www.dwilkinsjr.com/public/pixelpost/screenshot/apcs_v_1_0/statsPopular.jpg)

Newest Page:
The Newest page gives you a quick look at your newest comments.
You can also choose to view only published or both published and moderated comments as well as enabling/disabling thumbnails and changing the date/time format output.
On top of that, if a commenter has supplied an email address, you may click on their email to send a preformatted message thanking them for their comment!
Note: moderated comments are shown with a yellow background

http://www.dwilkinsjr.com/public/pixelpost/screenshot/apcs_v_1_0/thumbnail/statsNewest_thumb.jpg (http://www.dwilkinsjr.com/public/pixelpost/screenshot/apcs_v_1_0/statsNewest.jpg)

Comment Options Page:
The Comments Option page allows you to specify how many Top Commenter's, Most Popular, and Newest Comments to display.
You can also format the date/time output, show/hide thumbnails and show/hide moderated comments.
(The defaults are set to 7,7,7,Relative,Hide,Show)

http://www.dwilkinsjr.com/public/pixelpost/screenshot/apcs_v_1_0/thumbnail/statsComOpt_thumb.jpg (http://www.dwilkinsjr.com/public/pixelpost/screenshot/apcs_v_1_0/statsComOpt.jpg)

Language Options Page:
The Language Option page allows you to specify what language you would like to use.
Note: If you have translated or would like to translate to a new language, please contact me so I can add them to new releases.

http://www.dwilkinsjr.com/public/pixelpost/screenshot/apcs_v_1_0/thumbnail/statsLangOpt_thumb.jpg (http://www.dwilkinsjr.com/public/pixelpost/screenshot/apcs_v_1_0/statsLangOpt.jpg)

NEW INSTALLATION & UPGRADE from v0.5
Installation:

Extract archive and upload admin_comment_stat.php to your addons/ directory.
Upload the commentstats folder to your language/ directory.
Login to your pixelpost admin panel.
You're done!


UPGRADE from v0.1
IMPORTANT!
Upgrade from 0.1:

Login to your pixelpost admin panel.
Navigate to the menu item: Addons.
Find Advanced Pixelpost Stats and click the Remove APS button!
Goto your addons folder and DELETE admin_adv_stat.php from your addons directory
Now, follow installation instructions above!



UPGRADE from v1.0 to 1.01
Upgrade from 1.0 to 1.01:

Replace the old addon, admin_comment_stat.php with the new.
Replace the old commentstat language folder with the new.
You're done!


FINDING THE MENU
Use:

Pixelpost v1.5:

Login to your pixelpost admin panel.
Navigate to the new menu item: Stats

Pixelpost v1.6:

Login to your pixelpost admin panel.
Navigate to: General Info
Navigate to the new menu item: Stats



GET IT
Addon Page:
Visit (http://www.pixelpost.org/extend/addons/advanced-pixelpost-comment-statistics-1/)
Download:
Download (http://www.pixelpost.org/extend/addons/advanced-pixelpost-comment-statistics-1/download/)

VERSION HISTORY
Key:

[!]Important
[+]New
[-]Fixed error
Changes

Version 0.1

[!]Initial release.

Update to version 0.5:

[-]Fixed Breakdown calculations
[+]Added Options menu
[+]Added Commenter's submenu item
[+]Added Popular submenu item
[+]Added Newest submenu item
[+]Added Possibility to retrieve person details
[+]Added basic check to make sure the addon only runs while viewing the admin panel
[!]Changed name to Advanced Pixelpost Comment Stats from Advanced Pixelpost Stats

Update to version 1.0:

[+]Added multilingual support
[+]Added Language Options menu
[+]Added thumbnail display to Commenter' s submenu item
[+]Added date-time output switch
[+]Added Show / Hide thumbnails option
[+]Added Show / Hide moderated comments option
[+]Added RSS 2.0 feed for newest comments
Changed database install from manual to automatic
Changed Breakdown calculations to account for moderated comments
[+]Added support for pixelpost v1.6 General Info workspace

Update to version 1.01:

[+] Added Persian language support
[+] Added Spanish language support
[+] Added debug menu (http://www.yoursite.com/admin/?apcsdebug)
[+] Added ability to check for updates
[-] Altered CSS to match Pixelpost's v1.6 admin theme
Removed the comment RSS function. Pixelpost v1.6 supports this right out of the box
Cleaned more code and made some minor optimizations
Updated Spanish language file (04/17/2007) (no version change)

[Dennis]

Nice work: will definitely try this one out.

[Dkozikowski]

Thank you. Let me know how everything works for you.

For those of us who use a stats program called MINT and have the pepper called PCP have seen something like this before.

PCP does not however distinguish between published and moderated comments as the PCP peppers development stopped before the release of pixelpost 1.5x

I plan to port the PCP pepper for MINT into a pixelpost admin addon so those of you who do not use MINT can see cool statistics like the rest of us :)

[Dkozikowski]

v0.2 is available for testing.

The addon is not done my all means but it's getting there.

before i release it publicly, i'd like to get a few people running the addon and letting me know if any bugs exist.

Private message me or post here and let me know if you'd like to test this and i'll send you a message with a link.

[Dennis]

Hit me up, I'll can do some testing tonight or tomorrow at the latest.

[austriaka]

I tried your addon and it seems to work fine. But I cannot give very much information, because I have not much comments yet...

Two things to mention:
The name of your addon is a bit confusing, because there is a "advanced_stat.php" which comes with PP installation. Name of your "admin_adv_stat.php" is perhaps too similar, I suggest renaming it to "admin_comment_stat.php" or somewhat like that.

In line "Average published comments per person:" it says "1" here, but I have a few thousand visitors and exactly 7 comments. So rounding to ceiling is not very true when having low amount of total comments... Perhaps it would be better to show the "real" average which must be something like 0.000nnn

Thx for the idea
KArin

[Dkozikowski]

I tried your addon and it seems to work fine. But I cannot give very much information, because I have not much comments yet...
Which version did you test? v0.1 or the unreleased v0.2 i sent you a few minutes ago?


Two things to mention:
The name of your addon is a bit confusing, because there is a "advanced_stat.php" which comes with PP installation. Name of your "admin_adv_stat.php" is perhaps too similar, I suggest renaming it to "admin_comment_stat.php" or somewhat like that.

Yes, you are right and the final release will be changed.


In line "Average published comments per person:" it says "1" here, but I have a few thousand visitors and exactly 7 comments. So rounding to ceiling is not very true when having low amount of total comments... Perhaps it would be better to show the "real" average which must be something like 0.000nnn

Thx for the idea
KArin

Average published comments per person does not care how many visitors you have had. If you only have 7 comments then it saying 1 sounds about right.

Average published comments takes the total # of comments, in your case 7, and divides that by the total # of unique commenters (by name).

So what its doing is searching your database, pulling the total amount of comments out and dividing by the total amount of unique commenter names it also finds in your database.

So lets say you have 7 comments all by the same person, average published comments would say, 7.

[austriaka]

Which version did you test? v0.1 or the unreleased v0.2 i sent you a few minutes ago?
My last answer was for 0.1
Now I installed 0.2 and it is looking very good.
Average published comments per person does not care how many visitors you have had. If you only have 7 comments then it saying 1 sounds about right.
I have 7 comments fom 6 different people. So 1 is almost right ;-)
It is a cool addon (at least for the ones with more comments than me... Comeon people, leave a few comments so I can say more about that ;-)))

And yes, let us be collaborators!
KArin

[Dkozikowski]

My last answer was for 0.1
Now I installed 0.2 and it is looking very good.

Thank you :)


I have 7 comments fom 6 different people. So 1 is almost right ;-)

Thats why its called AVERAGE published comments and not exact published comments! ;)


And yes, let us be collaborators!
KArin

I agree, 100%

[Dkozikowski]

Version 0.5 released!

You can find the details within the first post :)

[Dennis]

Nice job :D

[Dkozikowski]

Thank you :D

Any other comments or suggestions?

[austriaka]

Just installed the latest version of Comment stats - Dave, you did a great job! I love the "flipping" of the comments very much. It gives a really good overview about commenters and most commented images.
Good work done, keep on! :)

KArin

[Dkozikowski]

Thank you Karin!

[Dkozikowski]

Updates are on the way!

The next version will include a few new features.

The main feature will be language file support!
So far, the following languages will be included:

English (default)
German (Thanks Karin)
Dutch (Thanks Schonhose)
Polish (Thanks Geos)


If anyone wishes to translate an english language file to their language to include in the next release, please get in contact with me as soon as possible!

Also, you will be able to switch between relative date times like Yesterday, Last Week, ect to the actual date time of the comment.

Besides this, a few bug fixes will have been made.

If anyone would like to see something else included, please leave some feedback!

[Dkozikowski]

ADVANCED PIXELPOST COMMENT STATISTICS v1.0 RELEASED!

See first post for details! (http://forum.pixelpost.org/showpost.php?p=41118&postcount=1)

[mike]

Nice work!
Now I need a little more comments ;)

Keep going on with your great work!

Cheers, Michael

[Dkozikowski]

Thanks Mike, enjoy :)

[Puffin]

This is a lot of information and fun! Thank you!! :)

[puzzled]

I just installed this - it was easy, and believe me, I know nothing! I really like this addon. Thank you very much for making it!

[noodles]

Thank you so much!!! It works and it's such a great addon. I've just uploaded it and am very happy with it. The easiest addon i've come accross with. Thank you very much.

Kudos.

Noodles :)

[Dkozikowski]

Thankyou for the feedback everyone!

It's nice to know my work is appreciated.

I already started on the next version which will address a few optimization issues and change the way the rss function works so it will be easier to share your comment feed with your viewers. I might even move the comment rss into its own addon.

Besides that, I might add search capabilities so you can search for a commenter by name (maybe IP too).

If there is anything else you can think of that will improve this addon, please share it with me. I'm running out of ideas :p

[FirstGateDreamer]

Love this addon. Thanks

I was wondering if maybe the next release can recognize IPs as a single user or have the option of doing so (incase you get different commenters from same IP).

The problem is that if a commenter doesn't enter their name properly they get ranked separately. One commenter I have tends to mix their upper/lowercase characters and I have another that slightly alters their name once and a while.

thanks
r.

[Dkozikowski]

This is a good point and it has not been overlooked.

Thanks for the feedback.

I will certainly fix the name case problem in the next version and I'll see what other verifications can be made if any.

[austriaka]

I was wondering if maybe the next release can recognize IPs as a single user or have the option of doing so (incase you get different commenters from same IP).
I have no dedicated IP (like most people in internet).
So if I do comments on different days it is very likely I never have the same IP adress.
The other way round many people use "my" IP adress because my phone provider is one of the biggest in Germany...

Dave, if you plan to do such a thing (what would be nice), you should consider some sort of a scoring system (similar to spam scoring) consisting of name, email, URI, user agent and IP for finding out identical persons. But I am afraid that would slow down the whole thing in a horrible way :-(

LG
KArin

[Dkozikowski]

Yes Karin. I am aware of the IP problem. That is why I did not choose to verify by IP.

It would be more accurate if I was able to verify against Name and Email but pixelpost only requires a name and comment to be filled in for submission.

I'll think about this more and I'm sure I'll come up with something :)

[austriaka]

I am sure you will ;-)
LG
KArin

[Dkozikowski]

Love this addon. Thanks

I was wondering if maybe the next release can recognize IPs as a single user or have the option of doing so (incase you get different commenters from same IP).

The problem is that if a commenter doesn't enter their name properly they get ranked separately. One commenter I have tends to mix their upper/lowercase characters and I have another that slightly alters their name once and a while.

thanks
r.

Ok, I have a little bit of time to work on this.

A users name is not case sensitive. So, for example, Dwlinkinsjr, dwilkinsjr, DwIlkiNsJR, etc will all be counted as the same person as long as there are no spaces within the name like dwilkins JR.

Also, can you give me an example of how some of your commenters alter their name from time to time?

Verifying by IP is useless as IP's are rarely static and adding an alternative check is useless unless your commenters enter in all info like email and url when making a comment.

I could write some code where you can append 2 commenters as 1 but this will require some time and most likely won't be included in the next version.

[boje]

Yeah, great addon, thanks. Any way of obtaining tags that allow me to display commenters' stats in a template? Like, top 25 commenters' names, and most commented-on images?

Or if anyone knows of an addon that allows this?

[boje]

Okay, sorry, I might've done well to check the addons section first :p

Though, it would be wicked if this addon could provide such tags, I reckon.

[inophoto]

This is great work. Thanks for sharing.

[XerXes]

I agree with everyone else. Nice addon.

[dhdesign]

Great job - thank you! :)

[nox]

Thank you very much!

[Dkozikowski]

Thanks everyone.

I'm currently busy with many other things at the moment but an update will be available soon with a few more options and tags that will be useable for your templates.

[FirstGateDreamer]

...users name is not case sensitive... Also, can you give me an example of how some of your commenters alter their name from time to time?
Sorry, my mistake. They would misspell their name, not just a different case (FLAVOR OF THE MINUTE, Flavour of the Minute). But I do have one commenter who changes their comment often depending on the content of my post (The Old Fart, The Dirty Old Fart, The Crazy Fart). Yes I have quite the eclectic audience!

I could write some code where you can append 2 commenters as 1...

Yes, I think this would be a great idea and the way to solve this.

Another suggestion...perhaps you can work with the Image Statistics Addon as well as the Comments section in Admin? Just an Idea. I really like this addon as is but I see a lot of potential. Thanks for the hard work.

[dhdesign]

A few observations about how this addon is working with v1.6beta:

1. In 1.5, the link for the comment stats was in the main menu at the top:
General Info -- AddOns -- Stats -- Image-Stats -- Logout

In v1.6beta, the link to the comment stats doesn't show up in the main menu at the top - you have to click General Info, and then it shows up in the submenu:
General -- Stats

Just wondering why this is happening? I installed the addon, then couldn't find it in the normal place I was used to looking for it.

2. The css in admin_comment_stat.php needs to be updated to match the new admin style in v1.6beta:

<style type=\"text/css\">
.apcsTable {
border-top: 1px dashed #ccc;
border-bottom: 1px dashed #ccc;
}

.apcsTableTop {
border-top: 1px dashed #ccc;
}

.apcsTableTopUnPub {
border-top: 1px dashed #ccc;
background-color: #fff;
}

.apcsTableBtm {
border-bottom: 1px dashed #ccc;
}

.apcsIMG {
border: 1px solid #000;
margin: 9px 2px 9px 0px;
height: 45px;
}

.apcsCaption {
border-top: 1px solid #ccc;
border-bottom: 1px solid #ccc;
margin: 0 0;
padding: 3px 0 3px 10px;
font-family: Helvetica, verdana, sans-serif;
font-size: 12px;
font-weight: bold;
letter-spacing: 1px;
color: #666;
background: url('img/back1.gif') repeat-x;
}

.submenu {
border-bottom: 1px solid #ccc;
border-top: 1px solid #ccc;
padding-top: 5px;
padding-bottom: 5px;
background-color: #fff;
color: #333;
font-weight: normal;
font-size: 10px;
margin: 10px auto;
text-align: center;
}

.submenu a {
padding: 5px;
}

.submenu a:hover {
background-color: #f4f4f4;
color: #666;
}
</style>
<!-- END AUTO GENERATED BY ADVANCED PIXELPOST COMMENT STATISTICS -->

3. When I click on RSS Feed, I am getting a page that displays the following error:

XML Parsing Error: no element found
Location: http://www.kpdesign.net/blog16/admin/index.php?view=info&infoview=stats&rssview=newestrss
Line Number 1, Column 1:
^

Any ideas on what's causing this issue?

-------------------------------------------

Other than the above issues, this addon seems to be working alright with the new PP version. :)

[Dennis]

A few observations about how this addon is working with v1.6beta:

1. In 1.5, the link for the comment stats was in the main menu at the top:
General Info -- AddOns -- Stats -- Image-Stats -- Logout

In v1.6beta, the link to the comment stats doesn't show up in the main menu at the top - you have to click General Info, and then it shows up in the submenu:
General -- Stats

Just wondering why this is happening? I installed the addon, then couldn't find it in the normal place I was used to looking for it.


Basically I'm to blame for that. Since it is general info we think this is a better place for such addons. We couldn't place it there under 1.5 so we used the old way.

If I get my way the addon_description var is only for a small description and all addon options should be under options.

[dhdesign]

Basically I'm to blame for that. Since it is general info we think this is a better place for such addons. We couldn't place it there under 1.5 so we used the old way.

If I get my way the addon_description var is only for a small description and all addon options should be under options.

That's cool - I was just wondering why it had switched places. Wanted to be sure it wasn't something that I had done incorrectly. ;)

Any ideas on why the RSS feed is throwing out that error?

[Dennis]

nope, it should work though. You better ask dwilkinsjr, he knows best.

[Dkozikowski]

As Dennis explained, I moved the menu item to the info page for 1.6 as this is technically where it should be.

There was no option to place it there using pixelpost v1.5 so for 1.6 i made sure it went into the new info workspace.

And I know about the CSS issue. Sorry, I just have not had time to update it yet.

As for the comment RSS not working, I'll have to take a look into this further. It could be due to a number of things. It most likely has to do with a comment containing a special character that for whatever reason is not being escaped.

Just for kicks, can you send me a copy of the comment stats addon you are using? PM me for my email or if you can host it on your website somewhere as a zip or change the php extension to phps.

Thanks.

I will be releasing v1.01 as soon as i can clear up your RSS issue.

[dhdesign]

I've sent you a PM with my email addy. Thanks!! :)

[Dkozikowski]

I sent you a couple PM's back ;)

It seems like the comment rss produces an error when no comments are present.

Thats my fault.

I made a test comment and it is working as it should now.

Anyway, the comment rss function will not be available is the next release as pixelpost will have this built in.

[Dkozikowski]

ADVANCED PIXELPOST COMMENT STATISTICS v1.01 RELEASED!

See first post for details! (http://forum.pixelpost.org/showpost.php?p=41118&postcount=1)

WHAT's NEW
Key:

[!]Important
[+]New
[-]Fixed error
Changes

Version 1.01:

[+] Added Persian language support
[+] Added Spanish language support
[+] Added debug menu (http://www.yoursite.com/admin/?apcsdebug)
[+] Added ability to check for updates
[-] Altered CSS to match Pixelpost's v1.6 admin theme
Removed the comment RSS function. Pixelpost v1.6 supports this right out of the box
Cleaned more code and made some minor optimizations

[dhdesign]

I upgraded to the new version this AM, and it works perfectly. Thanks!! :)

[QmQ]

i've tried out this addon, have to say, it is really nice work.

Thanks for your hard working.

[Dkozikowski]

I'm glad everyone is enjoying my addon.

Time spent coding is short these days.

When I get a chance, I'll throw out another update so people can append different commenter names as one.

Until then, enjoy.

[Dkozikowski]

ITALIAN LANGUAGE PAK RELEASED!


Italian language support added 05/10/2007. Download (http://www.dwilkinsjr.com/public/pixelpost/myaddons/lang_pak/apcs/comment_stats_lang_pak_italian_v1.01.zip)


Thanks to Tommaso ( http://www.tomsights.net/ )

Enjoy!

[Corve]

Hi, this is a very good addon...

So I make a french translation of it, are you interested?

[Dkozikowski]

Sure, translations are always welcome :)

[nims]

Are these stats available to the general visitors as well or just admin ?
Is there any addon (or can this be used) TO HAVE A SEPERATE PAGE on the photoblog that shows all the comments (with thumbnail of the image) at one place to general visitors sorted by date.

[Dkozikowski]

My Top Commenters Advanced addon displays the comments exactly like the APCS addon.

Check it out here, http://www.pixelpost.org/extend/addons/top-commenters-advanced/

[nims]

My Top Commenters Advanced addon displays the comments exactly like the APCS addon.

Check it out here, http://www.pixelpost.org/extend/addons/top-commenters-advanced/

Thanks. So does this addon (Top comm adv) allows to create a new page to display all the comments to general visitors ?

[Dkozikowski]

Yes.

[nims]

can u point me to documentation regarding creating a new page in Pixelpost. I cudnt find it
on http://www.pixelpost.org/docs/

[Dkozikowski]

Create a new template file and save it as (anything)_template.html and upload it to your current template folder.

Then you can access the template by visiting your site:

http://example.com/pixelpost/index.php?x=(anything)

[nims]

Wow thats great. Works like a charm.
Thanks for all the help and such a nice addon.

[Dkozikowski]

You're welcome

[bitus82]

You were saying that there can be an automated thank you message sent to commenters... would you explain how I can enable that feature?
Thank you
Titus

[Dkozikowski]

It's not automated per-say. If you click on their email link, it will open your mail program with a pre-defined message all filled out. you must hit the send button. I never got as far as to make it "automated" via php. someday soon i'd like to revamp this addon.