Please Log in to join the conversation.
There is a couple of places in the code you have written, where you write $sphinxrow-http and row..
This might be a stupid ?, but since sphinx is your username, I was just wondering if I am suppose to change that when I put the code on my own site?
sphinx76 wrote:$query = "SELECT a.userid,b.username from jos_comprofiler_plug_profilegallery a inner join jos_users b on (a.userid=b.id) WHERE a.pgitemapproved=0";
if(!$database->setQuery($query)) print $database->getErrorMsg();
$sphinxrow = $database->loadAssocList();
Before line 148 (if($totaluserpendapproval > 0 && $ueConfig) I addes a new line with the content:
$sphinxhttp = "index.php?option=com_comprofiler&task=userProfile&user=";
foreach($sphinxrow as $r) {
echo "User: <a href=$sphinxhttp$r[userid]>$r[username]<a/><br>";
}
quote]
Please Log in to join the conversation.
Please Log in to join the conversation.