Модуль-количество всего зарегистрированных??? и CB Last updatedusers - Модули и плагины

global $database;
$query = "SELECT COUNT(`id`) FROM `#__users`";
$database->setQuery($query);
$count_all_users = $database->loadResult();

$query = "SELECT COUNT(`id`) FROM `#__users` WHERE `usertype`<> 'Administrator' AND `usertype`<> 'Super Administrator' ";

$query = "SELECT COUNT(`id`) FROM `#__users` WHERE `usertype`= 'Registered'";

$query = "SELECT COUNT(`id`) FROM `#__users` WHERE `usertype`= 'Registered'";

$query = "SELECT COUNT(`id`) FROM `#__users` WHERE `usertype`<> 'Administrator' AND `usertype`<>

<?php
// Get paramets
$DisplayType = $params->get( 'DisplayType','1'); 	
$FilterBy = $params->get( 'FilterBy','0'); 	
$FilterValue = $params->get( 'FilterValue'); 	
$DisplayName = $params->get( 'DisplayName');
$DisplayUpdateDate = $params->get( 'DisplayUpdateDate');
$DisplayPortre = $params->get( 'DisplayPortre');
$DisplayCount = $params->get( 'DisplayCount');
$DisplayCountCOLS = $params->get( 'DisplayCountCOLS');

$DisplayGender = $params->get( 'DisplayGender');
$CBgenderName = $params->get( 'CBgenderName');
$CBgender = $params->get( 'CBgender');
$DisplayGenderPic = $params->get( 'DisplayGenderPic');
$GenderMale = $params->get( 'GenderMale');
$GenderFemale = $params->get( 'GenderFemale');
// Get costum field data
$DisplayCostum1 = $params->get( 'DisplayCostum1');
$DisplayCostumField1 = $params->get( 'DisplayCostumField1');
$DisplayCostumName1 = $params->get( 'DisplayCostumName1');

$DisplayCostum2 = $params->get( 'DisplayCostum2');
$DisplayCostumField2 = $params->get( 'DisplayCostumField2');
$DisplayCostumName2 = $params->get( 'DisplayCostumName2');

$DisplayCostum3 = $params->get( 'DisplayCostum3');
$DisplayCostumField3 = $params->get( 'DisplayCostumField3');
$DisplayCostumName3 = $params->get( 'DisplayCostumName3');



$newusers_web = $GLOBALS['mosConfig_live_site'].'/modules/mod_CB_updateusers';
global $mosConfig_live_site, $my;

// include the css for contnet
include_once("mod_CB_updateusers/css/content.css.html");

// FilterBy genering
if($FilterBy == 0) {
	// All - no filter
	$filter_by = '';
} elseif($FilterBy == 1) {
	// Gender
	$filter_by = $CBgender;
} elseif($FilterBy == 2) {
	// Costum 1
	$filter_by = $DisplayCostumField1;
} elseif($FilterBy == 3) {
	// Costum 2
	$filter_by = $DisplayCostumField2;	
} elseif($FilterBy == 4) {
	// Costum 3
	$filter_by = $DisplayCostumField3;
}

// Make nessery query
switch($DisplayType) {
	case 0:
		if($FilterBy == 0) {
			$query = "SELECT * FROM #__comprofiler  WHERE banned = '0' AND approved = '1' AND confirmed = '1' ORDER BY lastupdatedate DESC LIMIT  $DisplayCount";
		} else {
			$query = "SELECT * FROM #__comprofiler  WHERE $filter_by = '$FilterValue' AND banned = '0' AND approved = '1' AND confirmed = '1' ORDER BY lastupdatedate DESC LIMIT  $DisplayCount";
		}
	break;
	case 1:
		if($FilterBy == 0) {
			$query = "SELECT * FROM #__comprofiler  WHERE avatar != '' AND avatar NOT LIKE 'gallery%' AND banned = '0' AND approved = '1' AND confirmed = '1' ORDER BY lastupdatedate DESC LIMIT  $DisplayCount";
		} else {
			$query = "SELECT * FROM #__comprofiler  WHERE $filter_by = '$FilterValue' AND avatar != '' AND avatar NOT LIKE 'gallery%' AND banned = '0' AND approved = '1' AND confirmed = '1' ORDER BY lastupdatedate DESC LIMIT  $DisplayCount";
		}
	break;
}


$database->setQuery( $query );
$rows = $database->loadObjectList();


echo "<table border='0' cellpadding='2' cellspacing='2' width='100%' align='center'>"; 
echo "<tr>"; 



$k = 0;
for ($i=0, $n=count( $rows ); $i < $n; $i++) {
$row 	= &$rows[$i];

//foreach ( $rows as $row ) {
	
	$act_user = $row->id;
	$query2 = "SELECT * FROM #__comprofiler WHERE user_id = '$act_user' ";
	$database->setQuery( $query2 );
	$rows2 = $database->loadObjectList();
	
	foreach ( $rows2 as $row2 ) {
	
		$pic = $row2->avatar;
		$gen = $row2->$CBgender;
		$sexico = ($row2->{$CBgender} == $GenderFemale) ? 'female.gif' : 'male.gif';
		
		if ($row2->avatarapproved != 0) {
			if ($pic != '') {
				if (!stristr($pic, 'gallery/')) {
					$thumb_url = $mosConfig_live_site.'/images/comprofiler/'.$pic;
					$wid = "100";
				} else {
					$thumb_url = $mosConfig_live_site.'/images/comprofiler/'.$pic;
					$wid = "48";
				}
			} else {
				$thumb_url = $mosConfig_live_site.'/components/com_comprofiler/plugin/language/default_language/images/nophoto.jpg';
				$wid = "90";
			}
		} else {
				$thumb_url = $mosConfig_live_site.'/components/com_comprofiler/plugin/language/default_language/images/nophoto.jpg';
				$wid = "90";
		}
	}
	
		// Display picture and link to user profile
		switch($DisplayPortre) {
			case 0:
				$pic = "<a href='".sefRelToAbs("index.php?option=com_comprofiler&task=userProfile&user=$act_user")."'>";					
			break;
			case 1:
				$pic = "<div class='img-shadow'><a href='".sefRelToAbs("index.php?option=com_comprofiler&task=userProfile&user=$act_user")."'><img src='$thumb_url' border='0' width='$wid'></a></div><br>";				

			break;
		}	
		
		// Display user gender
		switch($DisplayGender) {
			case 0:
				$gender = "";
			break;
			case 1:
				$gender = "<br>$CBgenderName: $gen";
			break;
		}
		
		// Display user gender pic on front of users name
		switch($DisplayGenderPic) {
			case 0:
				$genderPic = "";
			break;
			case 1:
				$genderPic = "<img src='$mosConfig_live_site/modules/mod_CB_updateusers/images/$sexico' style='border:0px;' alt='$gen'/> ";
			break;
		}
		
		// Costum data handeling
		switch($DisplayCostum1) {
			case 0:
				$costumName1 = "";
				$costum1 = "";
			break;
			case 1:
				$costumName1 = '<br>'.$DisplayCostumName1.': ';
				$costum1 = ''.$row2->$DisplayCostumField1.'<br>';
			break;
		}
		switch($DisplayCostum2) {
			case 0:
				$costumName2 = "";
				$costum2 = "";
			break;
			case 1:
				$costumName2 = '<br>'.$DisplayCostumName2.': ';
				$costum2 = $row2->$DisplayCostumField2;
			break;
		}		
		switch($DisplayCostum3) {
			case 0:
				$costumName3 = "";
				$costum3 = "";
			break;
			case 1:
				$costumName3 = '<br>'.$DisplayCostumName3.': ';
				$costum3 = $row2->$DisplayCostumField3;
			break;
		}			

		$query3 = "SELECT * FROM #__users WHERE id = '$act_user' ";
		$database->setQuery( $query3 );
		$rows3 = $database->loadObjectList();
		
		foreach ( $rows3 as $row3 ) {
		
			switch($DisplayName) {
				case 0:
					$Name = $row3->name;
				break;
				case 1:
					$Name = $row3->username;
				break;
			}	

		
	
	//$regdate = $row->registerDate;
	$kp = explode(" ", $row2->lastupdatedate);
	$kuupaevake = explode("-", $kp[0]);
	$aasta = $kuupaevake[0];
	$kuu = $kuupaevake[1];
	$paev = $kuupaevake[2];
	
	}
	
	if ($DisplayUpdateDate == 0) {

		print "    <td width='".(100/$DisplayCountCOLS)."%' valign='top'><center><table><tr><td>";
		echo $pic."</td></tr>";
		echo "<tr><td>".$Name.' '.$genderPic;
		echo $gender;
		echo '</a>'.$costumName1.$costum1;
		echo $costumName2.$costum2;
		echo $costumName3.$costum3;
		print "    </td></tr></table></center></td>";

	} elseif ($DisplayUpdateDate == 1) {
		
		print "    <td width='".(100/$DisplayCountCOLS)."%'  valign='top'><center><table><tr><td>";
		echo $pic."</td></tr>";
		echo "<tr><td>".$Name.' '.$genderPic.'</a><br> '.$paev.'.'.$kuu.'.'.$aasta.' '.$kp[1].'';
		echo $gender;
		echo $costumName1.$costum1;
		echo $costumName2.$costum2;
		echo $costumName3.$costum3;
		print "    </td></tr></table></center></td>";
		
		
	}
$k++;
if ($DisplayCountCOLS == $k) {
	echo "</tr><tr>";
	$k = 0;
} //if  
} //for
print "</table>";
?>