|
|
|
Mosets Reviews Plugin
|
|
Date: 2006/02/02 21:22
|
By: Dehaw
|
Status: 
|
|
|
Karma: 1
|
|
Fresh Joomlapolitan
| Posts: 12 |   |
|
|
I found a bug with the sql statement within the reviews plugin today, it currently reads:
| Code: |
$database->setQuery( "SELECT r.*, l.* FROM #__mt_reviews AS r, #__mt_links AS l "
. "WHERE r.link_id = l.link_id AND l.link_published='1' AND l.link_approved='1' AND r.rev_approved='1'
AND r.user_id='".$user->id."'"
. "ORDER BY r.rev_date DESC"«»);
|
It should read:
| Code: |
$database->setQuery( "SELECT r.*, l.* FROM #__mt_reviews AS r, #__mt_links AS l "
. "WHERE r.link_id = l.link_id AND l.link_published='1' AND l.link_approved='1' AND r.rev_approved='1'
AND l.user_id='".$user->id."'"
. "ORDER BY r.rev_date DESC"«»);
|
I changed:
| Code: |
r.user_id='".$user->id."
|
With:
| Code: |
l.user_id='".$user->id."
|
and now it shows the correct reviews that relates to that users links.
I hope this helps someone.
|
|
The administrator has disabled public write access. |
|
 |
|
Re:Mosets Reviews Plugin
|
|
Date: 2006/02/03 02:12
|
By: gotMoxie
|
Status:
|
|
|
Karma: 5
|
|
Fresh Joomlapolitan
| Posts: 13 | |
|
|
By changing that 'r.user_id' to 'l.user_id' you are now pulling the Links that the profiled user Owns with hrefs to the reviews of their Link.
The plug-in was written to pull the Reviews that the profiled user has written (about other people's Links).
Does that make sense?
I'm not sure I see the use in the revision that you made as the My Links plug-in already pulls the profiled user's Links.
I guess with the change you made the plug-in could be called "Reviews of My Links".
If that is what you are after, I'm glad it works for you. But the original code works the way I had envisioned the plug-in.
Sam Lewis
Moxie Media, LLC
Sam Lewis
Moxie Media, LLC
CB3PD
|
|
|
The administrator has disabled public write access. |
|
|
