Логин вместо имени - Модули и плагины

$query = 'SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section,' .

$query = 'SELECT a.*, u.name AS author, u.id AS userid, u.username AS article_username, u.usertype, cc.title AS category, s.title AS section,' .

$query = 'SELECT a.id, a.title, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,' .

$query = 'SELECT a.id, a.title, a.title_alias, u.id AS userid, u.username AS article_username, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,' .

$query = 'SELECT cc.title AS category, a.id, a.title, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,' .

$query = 'SELECT cc.title AS category, a.id, u.id AS userid, u.username AS article_username, a.title, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,' .

<?php JText::printf( 'Written by', ($this->article->created_by_alias ? $this->article->created_by_alias : $this->article->author) ); ?>

<?php $cblink = '<a href="index.php?option=com_comprofiler&task=userProfile&user='.$this->article->userid.'">'.$this->article->article_username.'</a>'; JText::printf( 'Written by', ($cblink) );?>

<?php JText::printf( 'Written by', ($this->item->created_by_alias ? $this->item->created_by_alias : $this->item->author) ); ?>

<?php $cblink = '<a href="index.php?option=com_comprofiler&task=userProfile&user='.$this->item->userid.'">'.$this->item->article_username.'</a>'; JText::printf( 'Written by', ($cblink) );?>

$query = 'SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section,' .

LEFT JOIN #__tableCB_name as cb ON cb.field = a.created_by

$this->article->cbAvatar

		<table><tr><td><?php
		
if (($this->article->cbAvatar != ""))
		
		echo '<img style="width:67px;height:111px;" src="/images/comprofiler/'.$this->article->cbAvatar.'" />' ?>
		
		
		
		
		</td><td valign="top"><span class="createby">	<?php $cblink = '<a href="index.php?option=com_comprofiler&task=userProfile&user='.$this->article->userid.'">'.$this->article->article_username.'</a>'; JText::printf(($cblink) );?>
		</span>
	<?php endif; ?>

	<?php if ($this->params->get('show_create_date')) : ?>
		<span class="createdate">
			<?php echo JHTML::_('date', $this->article->created, JText::_('DATE_FORMAT_LC2')) ?> 
		</span><br />
		
		<div style="color:white;line-height:7px;"> <?php echo 
		
		'<br><div style="margin-bottom:3px;">- <strong>Asunto: </strong>'.$this->article->title.'</div></br>'?>
		
		<?php if (($this->article->cbEscena != "")) echo' <br><strong>- Escena Favorita:</strong> '.$this->article->cbEscena.'<br/>'?>
        <?php if (($this->article->cbEscena == "")) echo' <br><strong>- Escena Favorita:</strong> El usuario no ha especificado este dato<br/>'?>
		
		<?php if (($this->article->cbShichibukai != "")) echo '<br><strong>- Shichibukai Favorito:</strong> '.$this->article->cbShichibukai.'</br>' ?>
		<?php if (($this->article->cbShichibukai == "")) echo '<br><strong>- Shichibukai Favorito:</strong> El usuario no ha especificado este dato</br>' ?>
		
		
		
		</div>
	<?php endif; ?></td></tr></table>

$query = 'SELECT a.*, u.id AS userid, u.name AS author, u.usertype, cc.title AS category, s.title AS section,' .

$query = "SELECT count (*) AS userCountArticle FROM #__content WHERE created_by = '$this->item->userid' ";
$db->setQuery($query);
$row = $db->loadObject();

echo $row->userCountArticle;

echo $this->article->article_username.': '.$row->userCountArticle.' posts';

// Make a MySQL Connection
// Construct our join query
$query = "SELECT jos_users.id, jos_comprofiler.avatar ".
 "FROM jos_users, jos_comprofiler ".
	"WHERE jos_users.id = jos_comprofiler.id and jos_comprofiler.id= 62";
	 
$result = mysql_query($query) or die(mysql_error());


// Print out the contents of each row into a table 
while($row = mysql_fetch_array($result)){
	echo $row['id']. " - ". $row['avatar'];
	echo "<br />";
}

"WHERE jos_users.id = jos_comprofiler.id and jos_comprofiler.id= 62";

"WHERE jos_users.id = jos_comprofiler.id and jos_comprofiler.id= 62 and  jos_users.username= Protegon";