Changeset 455 for trunk/index.php

Timestamp:

Apr 13, 2010, 10:03:12 AM (15 years ago)

Author:

george

Message:

• Upraveno: Přístup k databázi převeden na objektový pomocí rozšířené PHP třídy mysqli. Při práci s databází použít globální objekt $System a jeho prvek $Database ($System->Database->query("SELECT ...");.
• Upraveno: Při vkládání nové zprávy do Kecátka neprovádět přesměrování, ale rovnou zobrazit výpis. U některých překladatelů toto způsobovalo opakované vložení zprávy.

File:

• trunk/index.php (modified) (4 diffs)

trunk/index.php

@@ -13 +13 @@
 function ShowNews()
 {
-  global $Database;
+  global $System;
 
   $Output = '<strong>Změny systému:</strong><div class="NewsBox">';
-  $DbResult = $Database->SQLCommand('SELECT `News`.`Time`, `User`.`Name`, `News`.`Text` FROM `News` JOIN `User` ON `User`.`ID` = `News`.`User` ORDER BY `Time` DESC LIMIT 10');
-  while($DbRow = mysql_fetch_assoc($DbResult))
+  $DbResult = $System->Database->query('SELECT `News`.`Time`, `User`.`Name`, `News`.`Text` FROM `News` JOIN `User` ON `User`.`ID` = `News`.`User` ORDER BY `Time` DESC LIMIT 10');
+  while($DbRow = $DbResult->fetch_assoc())
     $Output .= '<div><strong>'.$DbRow['Name'].' ('.HumanDate($DbRow['Time']).')</strong> <br />'.$DbRow['Text'].'</div>';  
   $Output .= '<a href="action.php?action=news">Všechny zprávy</a>';
@@ -56 +56 @@
 function ShowRSSChannel()
 {
-  global $Database, $Config, $System;
+  global $System, $Config, $System;
   
   $Items = array();  
   if($_GET['rss'] == 'news')
   {
-    $DbResult = $Database->SQLCommand('SELECT UNIX_TIMESTAMP(`News`.`Time`) AS `UnixTime`, `News`.`Time`, `User`.`Name`, `News`.`Text` FROM `News` JOIN `User` ON `User`.`ID` = `News`.`User` ORDER BY `Time` DESC LIMIT 10');
-    while($DbRow = mysql_fetch_assoc($DbResult)) 
+    $DbResult = $System->Database->query('SELECT UNIX_TIMESTAMP(`News`.`Time`) AS `UnixTime`, `News`.`Time`, `User`.`Name`, `News`.`Text` FROM `News` JOIN `User` ON `User`.`ID` = `News`.`User` ORDER BY `Time` DESC LIMIT 10');
+    while($DbRow = $DbResult->fetch_assoc()) 
     {
       $Items[] = array
@@ -83 +83 @@
   if($_GET['rss'] == 'translation')
   {
-    $DbResult = $Database->SQLCommand('SELECT UNIX_TIMESTAMP(`Date`) AS `Date`, `User`.`Name` AS `UserName`, `Text` FROM `Log` JOIN `User` ON `User`.`ID` = `Log`.`User` WHERE `Type` = 1 ORDER BY `Date` DESC LIMIT 100');
-    while($DbRow = mysql_fetch_assoc($DbResult)) 
+    $DbResult = $System->Database->query('SELECT UNIX_TIMESTAMP(`Date`) AS `Date`, `User`.`Name` AS `UserName`, `Text` FROM `Log` JOIN `User` ON `User`.`ID` = `Log`.`User` WHERE `Type` = 1 ORDER BY `Date` DESC LIMIT 100');
+    while($DbRow = $DbResult->fetch_assoc()) 
     {
       $Items[] = array
@@ -107 +107 @@
     $TitleLength = 50;
     mb_internal_encoding('utf-8');
-    $DbResult = $Database->SQLCommand('SELECT UNIX_TIMESTAMP(`Date`) AS `UnixDate`, `User`, `Text` FROM `ShoutBox` ORDER BY `ID` DESC LIMIT 20');
-    while($DbRow = mysql_fetch_assoc($DbResult)) 
+    $DbResult = $Sytem->Database->query('SELECT UNIX_TIMESTAMP(`Date`) AS `UnixDate`, `User`, `Text` FROM `ShoutBox` ORDER BY `ID` DESC LIMIT 20');
+    while($DbRow = $DbResult->fetch_assoc()) 
     {
       $Title = mb_substr($DbRow['Text'], 0, $TitleLength);