Changeset 55 for administrace/george/gm_news.php

Timestamp:

Aug 21, 2007, 3:52:22 PM (17 years ago)

Author:

george

Message:

Oprava přístupu do databáze.

File:

• administrace/george/gm_news.php (modified) (3 diffs)

administrace/george/gm_news.php

@@ -1 @@
-<?
-include_once('db.php');
-include('../../config.php');
-DB_Init($DatabaseHost, $DatabaseUser, $DatabasePassword, 'wow');
-//DB_Query('SET CHARACTER SET cp1250');
+<?php
+$Database->select_db('wow');
 
 if(array_key_exists('action', $_GET))
@@ -11 +8 @@
     if(array_key_exists('message', $_POST) and array_key_exists('author', $_POST))
     {  
-      DB_Insert('gm_news', array('time' => 'NOW()', 'author' => $_POST['author'], 'text' => $_POST['message']));
+      $Database->insert('gm_news', array('time' => 'NOW()', 'author' => $_POST['author'], 'text' => $_POST['message']));
       echo('Zpráva byla pøidána!<br>Pokraèujte <a href="../master.php">zde</a>.');   
     } else echo('Nebyly zadány požadováné údaje pro pøidání aktuality!'); 
   } else if($_GET['action'] == 'show_all')
   {
-    DB_Select('gm_news', '*,UNIX_TIMESTAMP(time)', '1 ORDER BY time DESC');
-    while($Row = DB_Row())
+    $DbResult = $Database->select('gm_news', '*,UNIX_TIMESTAMP(time)', '1 ORDER BY time DESC');
+    while($Row = $DbResult->fetch_array())
     {
       echo('<span class="SpanAktuality">'.date('j.n.Y G:i', $Row['UNIX_TIMESTAMP(time)']).'</span> - '.$Row['author'].': '.$Row['text'].'<br>');
@@ -23 +20 @@
   } else echo('Neznámá akce!');
 } else {
-  DB_Select('gm_news', '*,UNIX_TIMESTAMP(time)', '1 ORDER BY time DESC LIMIT 0, 25');
-  while($Row = DB_Row())
+  $DbResult = $Database->select('gm_news', '*,UNIX_TIMESTAMP(time)', '1 ORDER BY time DESC LIMIT 0, 25');
+  while($Row = $DbResult->fetch_array())
   {
     echo('<span class="SpanAktuality">'.date('j.n.Y G:i', $Row['UNIX_TIMESTAMP(time)']).'</span> - '.$Row['author'].': '.$Row['text'].'<br>');