Ejemplo n.º 1
0
$template["biblio"] = "
<table cellpadding=3 cellspacing=1 border=0 width=100% align=center style='border:1px solid #cccccc;'>
<tr bgcolor=#eeeeee><td width='15%'><b>___Date___</b></td><td><b>___Title___</b></td></tr>
<tr><td colspan=2>___ShortContent___</td></tr>
<tr><td colspan=2><a href=___Url___ target=_blank>___Url___</a></td></tr>
</table>";

$template["advertise"] = "
<table cellpadding=3 cellspacing=1 border=0 width=100% align=center style='border:1px solid #cccccc;'>
<tr bgcolor=#eeeeee><td width='15%'><b>___Date___</b></td><td><b>___Fio___</b></td></tr>
<tr><td colspan=2>___ShortContent___</td></tr>
<tr><td colspan=2><a href=___Url___ target=_blank>___Url___</a></td></tr>
</table>";

//выбираем даты последних рассылок
$rows_info = $cron_class->getLastSubscribesystem();

$newsdate = $rows_info["news"];
//var_dump(date('d.m.Y H:i',$newsdate),$rows_info);
$tboarddate = $rows_info["tboard"];
$blacklistdate = $rows_info["blacklist"];
$buycoinsdate = $rows_info["buycoins"];
$bibliodate = $rows_info["biblio"];
$advertisedate = $rows_info["advertise"];


$sql = "select * from news where dateinsert > '$newsdate' and `check`=1 order by date desc limit 10;";
echo $sql;
$result = $cron_class->getDataSql($sql);