Changeset 365 for trunk/index.php

Timestamp:

Mar 9, 2010, 11:29:05 AM (14 years ago)

Author:

george

Message:

• Upraveno: Jména tabulek v databází upraveny na stejná s prvními velkými písmeny.
• Upraveno: Doplněny SQL uvozovky do mnoha SQL dotazů.

File:

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

trunk/index.php

@@ -8 +8 @@
 
   $Output = '<strong>Změny systému:</strong><div class="NewsBox">';
-  $DbResult = $Database->SQLCommand('SELECT news.Time, user.user, news.Text FROM news JOIN user ON user.ID = news.User ORDER BY Time DESC LIMIT 10');
+  $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))
-    $Output .= '<div><strong>'.$DbRow['user'].' ('.date('d.m.Y', MysqlDateTimeToTime($DbRow['Time'])).')</strong> <br />'.$DbRow['Text'].'</div>';  
+    $Output .= '<div><strong>'.$DbRow['Name'].' ('.date('d.m.Y', MysqlDateTimeToTime($DbRow['Time'])).')</strong> <br />'.$DbRow['Text'].'</div>';  
   $Output .= '<a href="action.php?action=news">Všechny zprávy</a>';
   $Output .= '</div>';
@@ -21 +21 @@
 
   $Output = '<br /><strong>Poslední překlady:</strong><div class="NewsBox">';
-  $DbResult = $Database->SQLCommand('SELECT date,user.user,text FROM log JOIN user ON user.ID = log.User WHERE type = 1 ORDER BY date DESC LIMIT 20');
+  $DbResult = $Database->SQLCommand('SELECT `Date`, `User`.`Name`, `Text` FROM `Log` JOIN `User` ON `User`.`ID` = `Log`.`User` WHERE `Type` = 1 ORDER BY `Date` DESC LIMIT 20');
   while($DbRow = mysql_fetch_assoc($DbResult))
-    $Output .= '<strong>'.$DbRow['user'].' ('.date('d.m.Y', MysqlDateTimeToTime($DbRow['date'])).')</strong>
-    '.$DbRow['text'].' <br />';  
+    $Output .= '<strong>'.$DbRow['Name'].' ('.date('d.m.Y', MysqlDateTimeToTime($DbRow['Date'])).')</strong>
+    '.$DbRow['Text'].' <br />';  
   $Output .= '</div>';
   return($Output);
@@ -36 +36 @@
   if($_GET['rss'] == 'news')
   {
-    $DbResult = $Database->SQLCommand('SELECT UNIX_TIMESTAMP(news.Time), news.Time, user.user, news.Text FROM news JOIN user ON user.ID = news.User ORDER BY Time DESC LIMIT 10');
+    $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)) 
     {
       $Items[] = array
     (
-        'Title' => $DbRow['user'].'('.date('d.m.Y', MysqlDateTimeToTime($DbRow['Time'])).')',
+        'Title' => $DbRow['Name'].'('.date('d.m.Y', MysqlDateTimeToTime($DbRow['Time'])).')',
         'Link' =>  $Config['Web']['BaseURL'],
         'Description' => $DbRow['Text'],
-        'Time' => $DbRow['UNIX_TIMESTAMP(news.Time)'],
+        'Time' => $DbRow['UnixTime'],
       );
     } 
@@ -58 +58 @@
   if($_GET['rss'] == 'translation')
   {
-    $DbResult = $Database->SQLCommand('SELECT UNIX_TIMESTAMP(date), date, user.user, text FROM log JOIN user ON user.ID = log.User WHERE type = 1 ORDER BY date DESC LIMIT 100');
+    $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)) 
     {
       $Items[] = array
     (
-        'Title' => strip_tags($DbRow['text'].' ('.$DbRow['user'].')'),
+        'Title' => strip_tags($DbRow['Text'].' ('.$DbRow['UserName'].')'),
         'Link' =>  $Config['Web']['BaseURL'],
-        'Description' => $DbRow['text'],
-        'Time' => $DbRow['UNIX_TIMESTAMP(date)'],
+        'Description' => $DbRow['Text'],
+        'Time' => $DbRow['Date'],
       );
     } 
@@ -82 +82 @@
   $TitleLength = 50;
   mb_internal_encoding('utf-8');
-    $DbResult = $Database->SQLCommand('SELECT UNIX_TIMESTAMP(date), user, text FROM shoutbox ORDER BY ID DESC LIMIT 20');
+    $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)) 
     {
@@ -89 +89 @@
       $Items[] = array
     (
-        'Title' => $DbRow['user'].': '.$Title,
+        'Title' => $DbRow['User'].': '.$Title,
         'Link' =>  $Config['Web']['BaseURL'],
-        'Description' => $DbRow['text'],
-        'Time' => $DbRow['UNIX_TIMESTAMP(date)'],
+        'Description' => $DbRow['Text'],
+        'Time' => $DbRow['UnixDate'],
       );
     }