--- wap.php 2001/03/05 18:49:13 1.6 +++ wap.php 2001/03/17 16:17:07 1.7 @@ -12,66 +12,88 @@ $dbh->dbh_do("insert into wap_ua (ua,referer,url,accept) values ('$HTTP_USER_AGENT','$HTTP_REFERER','$QUERY_STRING','$HTTP_ACCEPT')"); -$on_page=5; +require("Smarty.class.php"); +$smarty = new Smarty; -$sql_where="where visible is true"; +if ($part && file_exists("templates/wap-$part.tpl")) { + $dbh->dbh_do("set datestyle='german'"); -if (!isset($s)) { - $sql_limit="limit $on_page"; -} elseif (isset($s)) { - $sql_limit="limit $on_page,$s"; -} + $sql="select date(date),time(date),type,current,change,high,low,open from stocks order by stocks.date desc,stocks.insert_date asc limit 2"; + $sth = $dbh->prepare("$sql"); + $sth->execute(); + while ($row=$sth->fetchrow_hash()) { + $stock[]=$row; + $time=$row[time]; + $date=$row[date]; + } -if (isset($id)) { - $sql_where.=" and id=$id "; -} + if ($time == "23:23:23") $time="CLOSE"; + + $smarty->assign(array(stock=>$stock, date=>$date, time=>$time)); + $wml=$smarty->fetch("wap-$part.tpl"); -$num_selected=0; +} else { -$sql="select - id,title,town_date,body,more,pdf, - (date-now()::date) as comming,type - from news $sql_where order by priority desc,date desc $sql_limit"; -$sth = $dbh->prepare("$sql"); -$sth->execute(); - -function fixup($html) { - if (strip_tags($html)) { - $tmp=strip_tags($html); - } else { - $tmp=$html; + $on_page=5; + + $sql_where="where visible is true"; + + if (!isset($s)) { + $sql_limit="limit $on_page"; + } elseif (isset($s)) { + $sql_limit="limit $on_page,$s"; } - return utf8_encode(htmlspecialchars($tmp)); -} -require("Smarty.class.php"); -$smarty = new Smarty; + if (isset($id)) { + $sql_where.=" and id=$id "; + } -while ($row=$sth->fetchrow_hash()) { - $row[title]=fixup($row[title]); - $row[body]=fixup($row[body]); - $row[town_date]=fixup($row[town_date]); - $data[]=$row; + $num_selected=0; - $num_selected++; -} + $sql="select + id,title,town_date,body,more,pdf, + (date-now()::date) as comming,type + from news $sql_where + order by priority desc,date desc $sql_limit"; + $sth = $dbh->prepare("$sql"); + $sth->execute(); + + function fixup($html) { + if (strip_tags($html)) { + $tmp=strip_tags($html); + } else { + $tmp=$html; + } + return utf8_encode(htmlspecialchars($tmp)); + } -if ($num_selected == $on_page) { - $next=$s+$on_page; -} -if ($s && $s >= $on_page) { - $prev=$s-$on_page; -} + while ($row=$sth->fetchrow_hash()) { + $row[title]=fixup($row[title]); + $row[body]=fixup($row[body]); + $row[town_date]=fixup($row[town_date]); + $data[]=$row; + + $num_selected++; + } -$smarty->assign( array ( - data=>$data, - body=>$wml_body, - prev=>$prev, next=>$next, - num_selected=>$num_selected, - on_page=>$on_page - ) ); -$wml=$smarty->fetch("wap.tpl"); + + if ($num_selected == $on_page) { + $next=$s+$on_page; + } + if ($s && $s >= $on_page) { + $prev=$s-$on_page; + } + + $smarty->assign( array ( + data=>$data, + body=>$wml_body, + prev=>$prev, next=>$next, + num_selected=>$num_selected, + on_page=>$on_page + ) ); + $wml=$smarty->fetch("wap.tpl"); +} print ' '.$wml;