';
$staticHeader = @file_get_contents('http://static.a1.ro/header/header.php?search=0');
if($staticHeader !== false)
$groupHeader = $staticHeader;
$query = 'SELECT e.NumeEmisiune, c.NumeConcurs, c.DataStart, c.DataFinal, c.DataValabilitate, c.Regulament, c.Castigatori
FROM ConcursuriSMS c, EmisiuniConcursuri e
WHERE c.Emisiune = e.EmisiuniConcursuriID
AND DataStart < "' . date('Y-m-d H:i:s') . '"
AND DataValabilitate > "' . date('Y-m-d H:i:s') . '"
AND c.CMSstatus = 2
ORDER BY c.CMSord ASC';
$concursuri = $db->getAllRowsQuery($query);
foreach ($concursuri as $key => $concurs) {
if ( isset($concurs['Regulament']) && $concurs['Regulament'] ){
$file = $db->getRowByValue('Media', 'id', $concurs['Regulament']);
$concursuri[$key]['FileRegulament'] = $file_root . $file['filename'];
}
if ( isset($concurs['Castigatori']) && $concurs['Castigatori'] ){
$file = $db->getRowByValue('Media', 'id', $concurs['Castigatori']);
$concursuri[$key]['FileCastigatori'] = $file_root . $file['filename'];
}
}
?>
Concursuri a1.ro
Concursuri si regulamente pe a1.ro
$concurs):?>