Here is my code below:
Code: Select all
if (!function_exists('MyGetModuleInstance'))
{
function &MyGetModuleInstance($module)
{
$gCms = cmsms();
if (isset($gCms->modules[$module]) &&
$gCms->modules[$module]['installed'] == true &&
$gCms->modules[$module]['active'] == true)
{
return $gCms->modules[$module]['object'];
}
// Fix only variable references should be returned by reference
$tmp = FALSE;
return $tmp;
}
}
global $gCms;
$db =& $gCms->GetDb();
$ob = MyGetModuleInstance('Olu_Banner');
if ($ob == FALSE)
return false;
$query4 = "SELECT * FROM " . cms_db_prefix() . "module_Olu_Banner_banneradvert WHERE bannerimage != '' AND active = '1' ";
$dbresult4 = $db->Execute( $query4);
if(!$dbresult4) {
echo "DB Error: " . $db->ErrorMsg();
} elseif ($dbresult4->RecordCount() > 0) {
echo "<div id=\"banner_scroll\">";
while ($dbresult4 && $row4 = $dbresult4->FetchRow()) {
echo "<a href=\"http://$row4[website]\" target=\"_blank\" \><img src=\"$row4[bannerimage]\" style=\"border:0px\"/></a>";
}
echo "</div>";
}