 Skrá nýja tónleika! |
 |
||
";
echo "| ";
include("news.inc");
include_once("database.inc.php");
if (($show_news!="all"))
{
if (isset($start) && !$prev)
{
$start_row=$start;
$start=$start+$show_news;
}
else if (!$start && !$prev)
{
$start=0;
$start_row=0;
}
if ($prev)
{
$start_row=$prev;
$start=$prev-$show_news;
}
if (!$end)
{
$end=$show_news;
}
$limit="Limit $start,$end";
}
$sql="select count(*) from tonleikar";
$result=mysql_query($sql,$db);
$myrow=mysql_fetch_array($result);
$num_rows=$myrow[0];
$data = fread(fopen($show_tonleikar_template, "r"), filesize($show_tonleikar_template));
$amorgun = mktime(0, 0, 0, date("m") , date("d")+1, date("Y"));
$idag = mktime(0, 0, 0, date("m") , date("d"), date("Y"));
$igaer = mktime(0, 0, 0, date("m") , date("d")-1, date("Y"));
$today = strftime("%e. %B %Y (%A)", $idag);
$tomorrow = strftime("%e. %B %Y (%A)", $amorgun);
$yesterday = strftime("%Y-%m-%d", $igaer);
$sql="select n_id,UNIX_TIMESTAMP(n_date) as my_date ,n_title, showorhide, tonleikarinfo,pic_link,n_pic, n_domari, n_file, UNIX_TIMESTAMP(n_stadur) as gig_date, n_hljomsveitir from tonleikar where showorhide=0 order by n_stadur desc,n_id desc $limit";
$result=@mysql_query($sql,$db);
while ($myrow=mysql_fetch_array($result))
{
$n_id=$myrow["n_id"];
$n_date=date($date_format,$myrow["my_date"]);
$end_date=$myrow["end_date"];
$showorhide=$myrow["showorhide"];
$tonleikarinfo=$myrow["tonleikarinfo"];
$pic_link=$myrow["pic_link"];
$news_hold=explode("\n",$tonleikarinfo);
$picture=$myrow["n_pic"];
$n_hljomsveitir=$myrow["n_hljomsveitir"];
$band_hold=explode("\n",$n_hljomsveitir);
// $stadurdate=$myrow["n_stadur"];
$stadurdate=date("Y-m-d",$myrow["gig_date"]);
$n_stadur=strftime("%e. %B %Y (%A)", $myrow["gig_date"]);;
$n_domari=$myrow["n_domari"];
$n_title=$myrow["n_title"];
for ($i=0;$i | ";
$stop=$start+$show_news;
if ($stop>$num_rows)
{
$stop=$num_rows;
}
$start_point=$start+1;
$showing="Samtals skráðir tónleikar: $num_rows | "; echo " | |
