function generate_rss2() { global $hp_url, $hp_title; global $rss_default_language; $_language = new Language(); $_language->set_language($rss_default_language); $_language->read_module('feeds'); $date = safe_query("SELECT `date` FROM " . PREFIX . "news WHERE published = '1' AND intern=0 ORDER BY date DESC LIMIT 0,1"); if (mysql_num_rows($date)) { $date = mysql_fetch_assoc($date); $updated = $date['date']; } else { $updated = time(); } $xmlstring = '<?xml version="1.0" encoding="UTF-8"?> <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom"> <channel> <title>' . $hp_title . ' ' . $_language->module['news_feed'] . '</title> <link>http://' . $hp_url . '</link> <atom:link href="http://' . $hp_url . '/tmp/rss.xml" rel="self" type="application/rss+xml" /> <description>' . $_language->module['latest_news_from'] . ' http://' . $hp_url . '</description> <language>' . $rss_default_language . '-' . $rss_default_language . '</language> <pubDate>' . date('D, d M Y h:i:s O', $updated) . '</pubDate> '; $db_news = safe_query("SELECT * FROM " . PREFIX . "news WHERE published = '1' AND intern=0 ORDER BY date DESC LIMIT 0,10"); $any_news = mysql_num_rows($db_news); if ($any_news) { while ($news = mysql_fetch_array($db_news)) { $db_newscontent = safe_query("SELECT * FROM " . PREFIX . "news_contents WHERE newsID = '" . $news['newsID'] . "' AND language='" . $rss_default_language . "'"); $any_newscontent = mysql_num_rows($db_newscontent); if ($any_newscontent) { $newscontent = mysql_fetch_array($db_newscontent); $cat = safe_query('SELECT category FROM ' . PREFIX . 'news_category WHERE categoryID=' . $news['category']); $cat = mysql_fetch_array($cat); $xmlstring .= '<item> <title>' . htmlspecialchars($newscontent['headline']) . '</title> <description><![CDATA[' . (strlen(htmloutput($newscontent['content'])) >= 250 ? substr(htmloutput($newscontent['content']), 0, 245) . '[...]' : htmloutput($newscontent['content'])) . ']]></description> <author>' . getemail($news['poster']) . ' (' . getfirstname($news['poster']) . ' ' . getlastname($news['poster']) . ')</author> <guid><![CDATA[http://' . $hp_url . '/' . $cat['category'] . '/' . $news['newsID'] . '/]]></guid> <link><![CDATA[http://' . $hp_url . '/' . $cat['category'] . '/' . $news['newsID'] . '/]]></link> </item> '; } else { continue; } } } $xmlstring .= '</channel> </rss>'; $rss_xml = fopen("tmp/rss.xml", "w"); fwrite($rss_xml, $xmlstring); fclose($rss_xml); }
} if (sizeof($allmembers) != 0) { ?> <table cellspacing="0" cellpadding="4" border="1"> <?php foreach ($allmembers as $member) { ?> <tr> <td><?php echo getfirstname($member); ?> <?php echo getlastname($member); ?> </td> <td><i><?php echo getuserrole($member); ?> </i></td> </tr> <?php } ?> </table>
$pollID = mysql_fetch_array(safe_query("SELECT titel FROM " . PREFIX . "poll WHERE pollID='" . $pollID . "'")); define('PAGETITLE', settitle($_language->module['polls'] . ' » ' . $pollID['titel'])); } else { define('PAGETITLE', settitle($_language->module['polls'])); } break; case 'profile': if (isset($_GET['id'])) { $id = (int) $_GET['id']; } else { $id = ''; } if (isset($_GET['username'])) { $id = getuserid($_GET['username']); } define('PAGETITLE', settitle(getfirstname($id) . ' "' . getnickname($id) . '" ' . getlastname($id))); break; case 'register': define('PAGETITLE', settitle('Create Account')); break; case 'registered_users': define('PAGETITLE', settitle($_language->module['registered_users'])); break; case 'search': define('PAGETITLE', settitle($_language->module['search'])); break; case 'server': define('PAGETITLE', settitle($_language->module['server'])); break; case 'shoutbox': define('PAGETITLE', settitle($_language->module['shoutbox']));