Example #1
0
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);
}
Example #2
0
    }
    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>
Example #3
0
         $pollID = mysql_fetch_array(safe_query("SELECT titel FROM " . PREFIX . "poll WHERE pollID='" . $pollID . "'"));
         define('PAGETITLE', settitle($_language->module['polls'] . '&nbsp; &raquo; &nbsp;' . $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']));