TOPIC: very easy to count all comments a user made

function setUser()
    {
        $database =& JFactory::getDBO();
 
        /* also in post ! and notification */
        $query = "SELECT * FROM jos_users WHERE id='".$this->_userid."' LIMIT 1";
        $database->SetQuery($query);
        $result = $database->loadAssocList();
        if ($result) {
            $user = $result[0];
            $this->_usertype  = $user['usertype'];
            $this->_tname     = $this->_use_name ? $user['name'] : $user['username'];
            $this->_temail    = $user['email'];
            $this->_tcomments = $user['comments'];# added by zurli
        }
 
    }

#Commentscounter edit by zurli
		$this->_tcomments = $this->_tcomments+1;
		$query = "
			UPDATE jos_users SET
			comments=$this->_tcomments
			WHERE id=$userid";
        $database->SetQuery($query);
        $database->Query() or die(_JOOMLACOMMENT_EDITINGFAILED . "\n $query");
		#End Commentscounter edit by zurli
 
        $database->SetQuery("
            INSERT INTO jos_comment
            (contentid,component,ip,userid,usertype,date,name,email,website,notify,title,comment,published,voting_yes,voting_no,parentid)
            VALUES(
            '$this->_content_id',
            '$com',
            '$ip',
            '$userid',
            '',
            '$createdate',
            '$name',
            '$email',
            '$website',
            '$notify',
            '$title',
            '$comment',
            '$published',
            '0',
            '0',
            '$parent_id'
            )");
        $result=$database->Query() or die(_JOOMLACOMMENT_SAVINGFAILED); //.$database->getQuery());
 

<?xml version="1.0" encoding="utf-8"?>
<cbinstall version="4.5.3" type="plugin" group="user">
	<name>MyData</name>
	<description>Provides a User Tab for displaying some data.</description>
	<files>
		<filename plugin="mydata">mydata.php</filename>
		<filename>index.html</filename>
	</files>
    <params>
    </params>	    
	<tabs>
		<tab name="My Data" description="Provides a User Tab for displaying some data." class="getMyDataTab" fields="1" position="cb_tabmain" displaytype="tab">
			<params>
			</params>
		</tab>
	</tabs>
</cbinstall>

<?php
if ( ! ( defined( '_VALID_CB' ) || defined( '_JEXEC' ) || defined( '_VALID_MOS' ) ) ) { die( 'Direct Access to this location is not allowed.' ); }
 
 
class getMyDataTab extends cbTabHandler {
	/**
	* Constructor
	*/
	function getMyDataTab() {
		$this->cbTabHandler();
	}
 
	function getDisplayTab($tab,$user,$ui) {
		global $_CB_database;
		if ($user->id){
			$query = 'SELECT field FROM jos_users WHERE id='. $user->id;
			$_CB_database->setQuery( $query );
			$mydata = $_CB_database->loadResult();
			$return='<div><p>Fieldname: '.$mydata.'</p></div>';
		} else {
		    $return='';
		}
		return $return;
  }
}
?>

$_CB_database->setQuery("SELECT field1, field2 FROM jos_users WHERE id=$user->id");
$rows = $_CB_database->loadObjectList();
$row = $rows[0];
$field1 = $row->field1;
$field2 = $row->field2;
$return='<div><p>Name1: '.$field1.'</p><p>Name2: '.$field2.'</p></div>';