function show_announcements($template_name) { $current_user =& singleton("current_user"); global $TPL; $query = "SELECT *\n FROM announcement \n WHERE displayFromDate <= CURDATE() AND displayToDate >= CURDATE()\n ORDER BY displayFromDate desc"; $db = new db_alloc(); $db->query($query); while ($db->next_record()) { $announcement = new announcement(); $announcement->read_db_record($db); $announcement->set_tpl_values(); $person = $announcement->get_foreign_object("person"); $TPL["personName"] = $person->get_name(); include_template($this->get_template_dir() . $template_name); } }
function show_announcements($template_name) { global $TPL; $people =& get_cached_table("person"); $query = "SELECT announcement.* \n FROM announcement \n ORDER BY displayFromDate DESC"; $db = new db_alloc(); $db->query($query); while ($db->next_record()) { $announcement = new announcement(); $announcement->read_db_record($db); $announcement->set_values(); $TPL["personName"] = $people[$announcement->get_value("personID")]["name"]; $TPL["odd_even"] = $TPL["odd_even"] == "odd" ? "even" : "odd"; include_template($template_name); } }