Changeset 129 for www/aktuality/rss.php
- Timestamp:
- Jan 5, 2009, 7:31:45 AM (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
www/aktuality/rss.php
r4 r129 21 21 foreach($Parts as $Part) 22 22 { 23 $Where .= 'OR (category='.($Part * 1).')'; 23 $Where .= 'OR (category='.($Part * 1).')'; 24 24 } 25 25 $Where = substr($Where, 2); … … 35 35 36 36 // Update news from discussion forum 37 $ForumCategory = 4; 37 $ForumCategory = 4; 38 38 $Database->select_db('forum'); 39 39 $DbResult = $Database->query('SELECT posts.post_time, posts_text.post_subject, posts_text.post_text, users.username, topics.topic_title FROM posts JOIN posts_text ON posts.post_id = posts_text.post_id JOIN users ON users.user_id = posts.poster_id JOIN topics ON topics.topic_id= posts.topic_id ORDER BY post_time DESC LIMIT '.$NewsCount); 40 40 41 $Index = 0; 41 42 //echo(DB_NumRows().','); 42 43 while($Row = $DbResult->fetch_array()) 43 44 { 44 $Row['post_text'] = StrTr($Row['post_text'], "\x8A\x8D\x8E\x9A\x9D\x9E", "\xA9\xAB\xAE\xB9\xBB\xBE"); 45 $Row['post_text'] = str_replace("\n","<br>", $Row['post_text']); 46 $Row['post_subject'] = StrTr($Row['post_subject'], "\x8A\x8D\x8E\x9A\x9D\x9E", "\xA9\xAB\xAE\xB9\xBB\xBE"); 47 $Row['topic_title'] = StrTr($Row['topic_title'], "\x8A\x8D\x8E\x9A\x9D\x9E", "\xA9\xAB\xAE\xB9\xBB\xBE"); 48 $Index = $Index + 1; 49 45 $Row['post_text'] = StrTr($Row['post_text'], "\x8A\x8D\x8E\x9A\x9D\x9E", "\xA9\xAB\xAE\xB9\xBB\xBE"); 46 $Row['post_text'] = str_replace("\n","<br>", $Row['post_text']); 47 $Row['post_subject'] = StrTr($Row['post_subject'], "\x8A\x8D\x8E\x9A\x9D\x9E", "\xA9\xAB\xAE\xB9\xBB\xBE"); 48 $Row['topic_title'] = StrTr($Row['topic_title'], "\x8A\x8D\x8E\x9A\x9D\x9E", "\xA9\xAB\xAE\xB9\xBB\xBE"); 49 $Index = $Index + 1; 50 50 51 $Title = $Row['topic_title'].'-'.$Row['post_subject']; 51 52 $Content = $Row['post_text'];
Note:
See TracChangeset
for help on using the changeset viewer.