Changeset 4 for www/aktuality/rss.php

Timestamp:

Jan 14, 2008, 9:48:39 PM (17 years ago)

Author:

george

Message:

Upraveno: Změna přístupu k databázi na třídu rozšířenou mysqli.
Upraveno: Sjednocení
Upraveno: Změna kódování všech stránek na UTF-8.
Odstraňeno: Staré nepotřebné soubory.

Location:

www

Files:

• . (modified) (1 prop)
• aktuality/rss.php (modified) (5 diffs)

www/aktuality/rss.php

@@ -1 @@
-<?
+<?php
 
 header("Content-Type: text/xml");
@@ -5 +5 @@
 include_once('../global.php');
 include_once('rss_generator.php');
-include_once('../is/db.php');
-DB_Init('localhost','root','','is');
-DB_Query('SET CHARACTER SET latin2');
 
 $NewsCount = 15;
@@ -18 +15 @@
 
 // Prepare WHERE condition 
-$Where = '';
 if(array_key_exists('select', $_GET)) 
 {
-  $Parts = explode('-', addslashes($_GET['select']));
+  $Where = '';
+  $Parts = explode('-', $_GET['select']);
   foreach($Parts as $Part)
   {
-    $Where .= ' OR (category='.($Part*1).')'; 
+    $Where .= 'OR (category='.($Part * 1).')'; 
   }
-}
+  $Where = substr($Where, 2);
+} else $Where = 1;
 
 // Get category names
 $Categories = array();
-DB_Select('news_category', '*');
-while($Category = DB_Row())
+$DbResult = $Database->select('news_category', '*');
+while($Category = $DbResult->fetch_array())
 {
   $Categories[$Category['id']] = $Category['caption'];
@@ -38 +36 @@
 // Update news from discussion forum
 $ForumCategory = 4;   
-DB_Change('forum');
-DB_Query('SELECT * FROM posts WHERE 1 ORDER BY post_time DESC LIMIT 0,'.$NewsCount);
+$Database->select_db('forum');
+$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);
 $Index = 0;
 //echo(DB_NumRows().',');
-while($Row2  = DB_Row())
+while($Row = $DbResult->fetch_array())
 {
-  DB_Save();
-  DB_Query('SELECT * FROM posts_text WHERE post_id='.$Row2['post_id']);
-  $Row = DB_Row();
   $Row['post_text'] = StrTr($Row['post_text'], "\x8A\x8D\x8E\x9A\x9D\x9E", "\xA9\xAB\xAE\xB9\xBB\xBE"); 
   $Row['post_text'] = str_replace("\n","<br>", $Row['post_text']); 
   $Row['post_subject'] = StrTr($Row['post_subject'], "\x8A\x8D\x8E\x9A\x9D\x9E", "\xA9\xAB\xAE\xB9\xBB\xBE"); 
-  DB_Query('SELECT * FROM users WHERE user_id='.$Row2['poster_id']);
-  $Row3 = DB_Row();
-  DB_Query('SELECT * FROM topics WHERE topic_id='.$Row2['topic_id']);
-  $Row4 = DB_Row();
-  $Row4['topic_title'] = StrTr($Row4['topic_title'], "\x8A\x8D\x8E\x9A\x9D\x9E", "\xA9\xAB\xAE\xB9\xBB\xBE"); 
+  $Row['topic_title'] = StrTr($Row['topic_title'], "\x8A\x8D\x8E\x9A\x9D\x9E", "\xA9\xAB\xAE\xB9\xBB\xBE"); 
   $Index = $Index + 1;    
   
-  $Title = $Row4['topic_title'].'-'.$Row['post_subject'];
+  $Title = $Row['topic_title'].'-'.$Row['post_subject'];
   $Content = $Row['post_text'];
-  $Date = date('Y-m-d H:i:s', $Row2['post_time']);
-  $Author = $Row3['username'];
-  DB_Change('is');
+  $Date = date('Y-m-d H:i:s', $Row['post_time']);
+  $Author = $Row['username'];
+  $Database->select_db('is');
   //echo('category='.$ForumCategory.' AND title="'.addslashes($Title).'" AND content="'.addslashes($Content).'" AND author="'.addslashes($Author).'" AND date="'.$Date.'"');
-  DB_Select('news', '*', 'category='.$ForumCategory.' AND title="'.addslashes($Title).'" AND content="'.addslashes($Content).'" AND author="'.addslashes($Author).'" AND date="'.$Date.'"');
-  if(DB_NumRows() == 0) //echo('.'); else echo('x'); 
-    DB_Insert('news', array('category' => $ForumCategory, 'title' => $Title, 'content' => $Content, 'author' => $Author, 'date' => $Date));
+  $DbResult2 = $Database->select('news', '*', 'category='.$ForumCategory.' AND title="'.addslashes($Title).'" AND content="'.addslashes($Content).'" AND author="'.addslashes($Author).'" AND date="'.$Date.'"');
+  if($DbResult2->num_rows == 0) //echo('.'); else echo('x'); 
+    $Database->insert('news', array('category' => $ForumCategory, 'title' => $Title, 'content' => $Content, 'author' => $Author, 'date' => $Date));
     //echo($Date);  
-  DB_Change('forum');
-  DB_Load();
+  $Database->select_db('forum');
 }
-DB_Change('is');
+$Database->select_db('is');
 
 // Get news from database by selected categories
 $UploadedFilesFolder = 'uploads/';
-DB_Query('SELECT enclosure,category,title,content,UNIX_TIMESTAMP(date),author FROM news WHERE 1'.$Where.' ORDER BY date DESC LIMIT 0,'.$NewsCount);
-while($Row = DB_Row())
+$DbResult = $Database->query('SELECT enclosure,category,title,content,UNIX_TIMESTAMP(date),author FROM news WHERE '.$Where.' ORDER BY date DESC LIMIT 0,'.$NewsCount);
+while($Row = $DbResult->fetch_array())
 {
   $EnclosuresText = '';
   if($Row['enclosure'] != '')
   { 
-    $EnclosuresText .= '<br>Pøílohy: ';
+    $EnclosuresText .= '<br>Přílohy: ';
     $Enclosures = explode(';', $Row['enclosure']);
     foreach($Enclosures as $Enclosure)
@@ -96 +86 @@
 
 echo(GenerateRSS(array(
-  'Title' => 'ZdìchovNET - Aktuality',
+  'Title' => 'ZděchovNET - Aktuality',
   'Link' => 'http://centrala.zdechov.net/',
-  'Description' => 'Aktuality komunitní poèítaèové sítì ZdìchovNET',
+  'Description' => 'Aktuality komunitní počítačové sítě ZděchovNET',
   'WebmasterEmail' => 'robie@centrum.cz',
   'Items' => $Items)));