$EngCat = 5; //Promo Category ID English

$PTCat = 4; //Promo Category ID Portugese

$count = 0; //Set variable



if ($language_code == "en" ) //Get the frontend language (using JoomFish)

{

$db =& JFactory::getDBO(); //Connect to wright database

$query = "SELECT COUNT(catid) FROM #__content WHERE catid = $EngCat and state = 1";  //Count the published articles in defined category ID 

$db->setQuery($query); //Set the query

$count = $db->loadResult(); //Get the numbers!

if ($count == 0) {return 115;}  //Get another module when no promos active

else {return 124;} } //Display the promo module





//Same as before, just using new variables and language code



if ($language_code == "pt" ) {

$db =& JFactory::getDBO();

$query = "SELECT COUNT(catid) FROM `#__content` WHERE `catid` = $PTCat and `state` = 1";  

$db->setQuery($query);

$count = $db->loadResult();

if ($count == 0) {

return 115;}

else {return 124;}  }





return 90; //Fallback if no Language detected