SHOW NEW COMMENTS in user photos When LOGGED-IN

[adamastor]

that would be a really GREAT mod, I bet everybody would use it.
I've installed 4images last night, so far I'm very impressed, but sadly it doesn't have that feature... I'm a newbie at php, I've been trying to do this mod right now but as I said, I don't know much about php and I'm starting with 4images, so as you can imagine I'm not really familiar with the code...  


so the MOD would be something very simple BUT extremely useful , specially for big galleries where lot's of users get lot's of comments.

The MOD just would have to be something like this :


when user logs-in shows :

<b> you have comments on the following images : </b>

<a href="link to image">  [image id (1)]</a>
<a href="link to image">  [image id (2)]</a>
<a href="link to image">  [image id (3)]</a>
<a href="link to image">  [image id (4)]</a>
<a href="link to image">  [image id (5)]</a>
etc...
.
.
.

anyone can help ? please??? pleaaassse???I reallllly would like this mod, I think it's essential in a photo gallery.

thanks !! cheers !



did I say pleeeeaaasssseeeeeeee ?? PLEAAASSEEE !

[V@no]

I think there is alread some code that does it...but I thik it shows last XX comments, or last comments in last XX days / hours, but not "from your last visit"

[adamastor]

yes, I have seen that post, but I don't know how to change that to make the modification that I wanted... I think I would have to add a new column to the images table in Mysql and the image would have a "1" if it had new comments since the owner's last visit or a "0"  if not.
but I dont know where to insert the code that :

- would check the user id and run through all his images to check for new comments  ("1" in the image table)

- each time someone comments, update that images table with a "1", BUT don't update if it already has a "1".

where do I insert the coding? I'm thinking of doing this with (whiles) and (if's), I dont know much about mysql, so I think I could only do that this way...