Plugin - Last Profile Visitors

Hello Trail!
i was just trying this nice plugin, and i found that on lastviews.php, line 32:
FROM `mos_comprofiler_views` v, `mos_comprofiler` c, `mos_users` u
i had to change it into:
FROM #__comprofiler_views v, #__comprofiler c, #__users u
because my web site uses jos_ prefix on tables, so this fix was necessary to keep it working on my web site

thank you!

Post edited by: viames, at: 2005/12/27 18:08

Nice catch Viames!

Replaced all mos_ to #__ and the plugin is now working on this site!

Trail - nice work!

Would love to have options to sort by date, hits, etc (like the joomlaboard plugin).

Big thanks!
That helped.

right!
i changed (but forgot to report in the post) also line 59 into:
$database->setQuery("SELECT count(viewer_id) FROM #__comprofiler_views WHERE profile_id ='$user->id' AND viewer_id=0");

cheers

Lol.. simple bug that got in there during testing of the queries in phpmyadmin.. oops.. thanks for reporting, i will upload a new fixed file.. v0.1.2beta

Post edited by: Trail, at: 2005/12/27 22:41

Trail,

Love the plugin and have contributed generously to the karma I have 2 problems and one suggestion. The problems:

1. The pictures that are supposed to be displayed are not working on my site. I notice that the link properties are going to www.mysite.com/images/comprofiler/mypic.jpg so it apears that the plugin is hardcoded to have the images directory in the root. My site set to where the pictures would work with the following link www.mysite.com/joomla/images/comprofiler/mypic.jpg as I have Joomla in a the folder called joomla in the root. Where do I need to go to fix this?

2. I like to show real names and not nicknames so I found that by changing 2 instances of username at lines 32 and 61 to name fixed that.

My sugestion is to add the previous Name issue as an option in the plugin.

Thanks,