Sandbox

Okey I want to get this module to display the author name and link back to their profile. Its a front page module used to display the X number latest mamblog posts. Iv been playing with it but Im only learning php at the moment and cant get it to work. As far as I can tell its only a matter of changing the query to look for the correct field then outputting it and concatenating it correctly.





[code:1]defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );

global $database, $mosConfig_offset;

$count = $params->get( 'count', 5 );
$section = $params->get( 'section', 'Mamblog' );
$now = date( "Y-m-d H:i:«»s", time()+$mosConfig_offset*60*60 );

$query = "SELECT id FROM #__sections WHERE title='$section'";
$database->setQuery($query);
$section_id = $database->LoadResult();

$query = "SELECT id FROM #__menu WHERE link='index.php?option=com_mamblog'";
$database->setQuery($query);
$Itemid = $database->LoadResult();

$query = "SELECT id, title"
. "\n FROM #__content"
. "\n WHERE sectionid='$section_id'"
. "\n AND state=1"
. "\n AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '$now'  )"
. "\n AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '$now' )"
. "\n ORDER BY created DESC"
. "\n LIMIT $count"
;
$database->setQuery($query);
$rows = $database->loadObjectList();
echo $database->getErrorMsg();

foreach($rows as $row) {
echo ''.$row->title.'
';
}
?>[/code:1]

Are you getting any specific error messages?

Also, you use '$database->LoadResult'. It should be '$database->loadResult' (note the lowercase L). That might be the initial cause of some problems. Besides that, an error message of some kind would do wonders.

Regards,
Nick

Hi mate thanks for answering. The code I posted is the original unmodified code from the original module. Its not meant to display the author name just the content item. So there is no errors with that. I never posted the changes I attempted to make as I really dont know what im doing Im still learning the very basics of PHP and programming in general. But I can see that it would'nt take much to make it do what I would like it to do and I was hoping somebody would Just add the few lines of code needed for me.


cheers

Modify the query like this:



Then you can use $row->username for links and $row->created_by can be used on profile links as user id. (Note that if you change u.username to u.name and $row->username to $row->name it just displays the real name of the author.

Btw, for the Community Builder profile link you can use this, I think.



Please don't forget that I didn't try these codes. So I can't take any responsibility.

Thanks man! 

I changed the code to this and it almost works. The only thing thats wrong is its not actually linking to the cb profiles, Im just getting the message back saying This profile does not exist or is no longer available. But the profiles do exist.

$query = "SELECT c.id, c.title, u.username"
  . "\n FROM #__content AS c"
  . "\n LEFT JOIN #__users AS u ON u.id = c.created_by"
. "\n WHERE sectionid='$section_id'"
. "\n AND state=1"
. "\n AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '$now'  )"
. "\n AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '$now' )"
. "\n ORDER BY created DESC"
. "\n LIMIT $count"
;
$database->setQuery($query);
$rows = $database->loadObjectList();
echo $database->getErrorMsg();

foreach($rows as $row) {
echo ''.$row->title.'
'.''.$row->username.'';
}

Hi, can you please add the html code generated by this module?

Okey this the HTML:

$query = 'SELECT c.id, c.title, c.created_by, u.username, cb.avatar, cb.avatarapproved'
      . 'FROM #__content AS c'
      . 'LEFT JOIN #__users AS u ON u.id = c.created_by'
      . 'INNER JOIN #__comprofiler AS cb ON u.id = cb.user_id'
      . 'WHERE sectionid=' (int) $section_id
      . 'AND state = 1'
      . 'AND ( publish_up = \'0000-00-00 00:00:00\' OR publish_up <= ' . $now . ') '
      . 'AND ( publish_down = \'0000-00-00 00:00:00\' OR publish_down >= ' . $now . ') '
      . 'ORDER BY created DESC'
      . 'LIMIT' . (int) $count;

<?php

if ($row->avatarapproved) {
    do something with $row->avatar;
}
 
?>

'WHERE sectionid=' [b].[/b] (int) $section_id