Changeset 462

Timestamp:

Mar 1, 2009, 3:42:55 PM (16 years ago)

Author:

amun

Message:

 

File:

• branches/beta/inc/html.php (modified) (4 diffs)

branches/beta/inc/html.php

@@ -62 +62 @@
   <meta name=\"keywords\" content=\"".$this->CfgChck("keywords")."\" />
   <link rel=\"stylesheet\" type=\"text/css\" href=\"styles/style.css\" />
-  <script type=\"text/javascript\" src=\"styles/global.js\"></script>
   <!--[if IE]><link rel=\"stylesheet\" type=\"text/css\" href=\"styles/ie.css\" /><![endif]-->
   </head>
@@ -208 +207 @@
       public function ShowNews ($kategorie)
       {
-                global $db_webu;
-                
         if ($kategorie == "all")
         {
@@ -218 +215 @@
           $where = "WHERE `category` = '".$kategorie."'";
         }
- mysql_connect($db_server, $db_user, $db_pass);
-  mysql_select_db($db_webu);
-  $limit = 5;
-    
-        
-$pocet = mysql_num_rows(mysql_query("SELECT id FROM `articles`".$where."ORDER BY `date` DESC;"));
-$offset = ($_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)){
- switch ($row["category"]) 
+        $this -> db -> select_db($db_webu);
+        $sql = $this -> db -> query("SELECT * FROM `articles`".$where."ORDER BY `date` DESC;");
+        if ($sql -> num_rows > 0)
+        {
+        // TODO !!
+          while ($row = $sql -> fetch_array())
+          {
+            switch ($row["category"]) 
             {
               case 1:
@@ -267 +258 @@
               <tr>
                 <td>Sekce : <a href=\"?page=".$link."\">".$cat."</a></td>
-                <td>".$row["autor"]."</td>
+                <td>Zork</td>
               </tr>
             </table>
             <br />
             ";
-}
-if ($offset < $pocet) {
-    echo "<a href='$_SERVER[PHP_SELF]" . ($offset + $limit < $pocet ? "?offset=" . ($offset + $limit) : "") . "'>zpět</a>\n";
-}
-if ($offset > $limit) {
-    echo "<a href='$_SERVER[PHP_SELF]?offset=" . ($offset - $limit) . "'>vpřed</a>\n";
-}
-
-
-
-
-  
-        
+          }
         }
         else