Changeset 106 for www/sunrisechat

Timestamp:

Aug 10, 2008, 10:47:08 AM (16 years ago)

Author:

george

Message:

• Upraveno: Přejmenování databáze historie chatu na ChatHistory. Přejmenovány také názvy sloupců na velké počáteční písmena.

File:

• www/sunrisechat/history.php (modified) (2 diffs)

www/sunrisechat/history.php

@@ -8 +8 @@
 $DateParts = explode('-',$Date);
   
-$DbResult = $Database->select('sunrisechat_history','MAX(time), MIN(time)');
+$DbResult = $Database->select('ChatHistory','MAX(Time), MIN(Time)');
 $RowTotal = $DbResult->fetch_array();
   
-$StartDateTimeParts = explode(' ',$RowTotal['MIN(time)']);
+$StartDateTimeParts = explode(' ',$RowTotal['MIN(Time)']);
 $StartDateParts = explode('-',$StartDateTimeParts[0]);
-$EndDateTimeParts = explode(' ',$RowTotal['MAX(time)']);
+$EndDateTimeParts = explode(' ',$RowTotal['MAX(Time)']);
 $EndDateParts = explode('-',$EndDateTimeParts[0]);
   
@@ -65 +65 @@
   echo('</div><div style="border-style: solid; border-bottom-color: gray; border-width: 0 0 1 0; margin-bottom: 3px; padding-bottom: 2px;"></div>');
   
-    $DbResult = $Database->select('sunrisechat_history','nick,color,text,UNIX_TIMESTAMP(time)',"roomtype=0 AND time>'".$Date." 00:00:00' AND time<'".$Date." 23:59:59' ORDER BY time DESC");
+    $DbResult = $Database->select('ChatHistory','Nick,Color,Text,UNIX_TIMESTAMP(Time)',"RoomType=0 AND Time>'".$Date." 00:00:00' AND Time<'".$Date." 23:59:59' ORDER BY Time DESC");
     //echo('Vpis posledn�h 100 zpr�:<br>');
     echo('<div style="font-size: small;">');
     while($Row = $DbResult->fetch_array())
     {
-      $Text = $Row['text'];;
+      $Text = $Row['Text'];;
       // StrTr($Row['text'], "\x8A\x8D\x8E\x9A\x9D\x9E", "\xA9\xAB\xAE\xB9\xBB\xBE"); 
-      echo('['.date('d.m.Y H:i:s',$Row['UNIX_TIMESTAMP(time)']).'] <span style="color: #'.dechexr($Row['color']).'"><strong>&lt;'.$Row['nick'].'&gt;</strong> '.(htmlspecialchars($Text)).'</span><br>');
+      echo('['.date('d.m.Y H:i:s',$Row['UNIX_TIMESTAMP(Time)']).'] <span style="color: #'.dechexr($Row['Color']).'"><strong>&lt;'.$Row['Nick'].'&gt;</strong> '.(htmlspecialchars($Text)).'</span><br>');
       flush();
     }