SQL query help

[emanuele]

Yep, I think Sorck is right, the join is not necessary.

But there is something that I'm not sure about.
How many time each user can like a certain message?

It's not that we are 24/7 at the computer.

I thought you lived in a computer.

[Neo_TE]

The easiest way will just be to try the queries out.

It looks as if it would do the job if you removed the JOIN from the query. The ORDER BY won't really affect it that much.

Yep, I think Sorck is right, the join is not necessary.

But there is something that I'm not sure about.
How many time each user can like a certain message?

Thanks for guiding me. Yes, the join query is unnecessary.

A user can like a post only once.

The 'like image/link' is displayed as default. If the user has liked the post, the 'like image/link' is replaced with an option to 'remove the like'.

I've thought of a new solution which should work properly. Ill post it soon.

[Arantor]

Seems to me you would have been better finding a likes mod rather than trying to rewrite an existing but totally unrelated mod. For example, http://smfhelp.org/index.php?topic=63.0

[Neo_TE]

Seems to me you would have been better finding a likes mod rather than trying to rewrite an existing but totally unrelated mod. For example, http://smfhelp.org/index.php?topic=63.0

[Arantor]

Sorry but that's how it is... the karma setup is really not the right base for this project. There are too many things karma doesn't do.

[Neo_TE]

I deleted the mod.