Changeset 583 for trunk/inc/html.php

Timestamp:

May 7, 2009, 9:15:17 AM (15 years ago)

Author:

george

Message:

• Opraveno: Chyba v CSS stylech způsobovala špatné zobrazení rámečků tabulek a stylů dalších prvnků.
• Upraveno: Sjednocen styl různých tabulek.
• Upraveno: Přepis nejednotného přístupu k databázi přes jiné proměnné a konstanty než dle konfigurace proměnné $Config.

File:

• trunk/inc/html.php (modified) (4 diffs)

trunk/inc/html.php

@@ -195 +195 @@
   public function ShowNews($kategorie)
   {
-          include('inc/db.php');
-                global $db_webu;
+          global $Config;
                 
     echo('<table class="NewsCategoryTable">'.
@@ -208 +207 @@
     $this->QuickNew();
 
-    if($kategorie == "all")
-    {
-      $where = " ";
-    } else
-    {
-      $where = "WHERE `category` = '".$kategorie."'";
+    if($kategorie == 'all')
+    {
+      $where = '';
+    } else
+    {
+      $where = 'WHERE `category` = "'.$kategorie.'"';
     } 
                 
-    mysql_connect($db_server, $db_user, $db_pass);
-    mysql_select_db($db_webu);
+    $this->db->select_db($Config['Database']['Database']);
     $limit = 5;
     
-    $pocet = mysql_num_rows(mysql_query("SELECT id FROM `articles`".$where."ORDER BY `date` DESC;"));
-    $offset = (isset($_GET["offset"]) ? $_GET["offset"] : $pocet);
+    $DbResult = $this->db->query('SELECT id FROM `articles` '.$where.' ORDER BY `date` DESC;');
+    $pocet = $DbResult->num_rows;
+    $offset = (isset($_GET['offset']) ? $_GET['offset'] : $pocet);
 
     if($pocet != 0)
     {
-                  mysql_query('SET NAMES utf8');
-      $result = mysql_query("SELECT * FROM articles $where ORDER BY date DESC, id DESC LIMIT $limit OFFSET " . ($pocet - $offset));
-      while($row = mysql_fetch_array($result))
+      $result = $this->db->query('SELECT * FROM articles '.$where.' ORDER BY date DESC, id DESC LIMIT '.$limit.' OFFSET '.($pocet - $offset));
+      while($row = $result->fetch_array())
       {
         $row['text'] = str_replace('<br>', '<br />', $row['text']);
-        switch ($row["category"]) 
+        switch($row['category']) 
         {
           case 1:
-            $cat = "Server novinky";
-            $link = "servernews";
+            $cat = 'Server novinky';
+            $link = 'servernews';
             break;
           case 2:
-            $cat = "GM novinky";
-            $link = "gmnews";
+            $cat = 'GM novinky';
+            $link = 'gmnews';
             break;
           case 3:
-            $cat = "In-game novinky";
-            $link = "gamenews";
+            $cat = 'In-game novinky';
+            $link = 'gamenews';
             break;
           case 4:
-            $cat = "Články";
-            $link = "articles";
+            $cat = 'Články';
+            $link = 'articles';
             break;
         }
@@ -252 +250 @@
         $date = explode('-', $date_arr[0]);
         $time = mktime(0, 0, 0, $date[1], $date[2], $date[0]);
-        $human_date = date ("d.m.Y", $time);
+        $human_date = date('d.m.Y', $time);
         echo('<table class="NewsQuickInfoTable">'.
           '<tr>'.
-          '<td><strong>'.$row["title"].'</strong></td>'.
+          '<td><strong>'.$row['title'].'</strong></td>'.
           '<td style="width: 100px">'.$human_date.'</td>'.
           '</tr>'.
           '<tr>'.
-          '<td colspan="2">'.$row["text"].'</td>'.
+          '<td colspan="2">'.$row['text'].'</td>'.
           '</tr>'.
           '<tr>'.
@@ -271 +269 @@
       if($offset < $pocet)
       {
-        echo("<a href='$_SERVER[PHP_SELF]" . ($offset + $limit < $pocet ? "?offset=" . ($offset + $limit) : "") . "'><-- novější</a>\n &nbsp;");
+        echo('<a href="'.$_SERVER['PHP_SELF'].($offset + $limit < $pocet ? '?offset='.($offset + $limit) : '').'"><-- novější</a>\n &nbsp;');
       }
       if($offset > $limit)