Changeset 196 for trunk/aktuality/news.php

Timestamp:

Apr 27, 2009, 8:00:50 AM (16 years ago)

Author:

george

Message:

• Upraveno: Názvy tabulek a sloupců aktualit pozměněny na názvy se slovy začínající velkými písmeny.

File:

• trunk/aktuality/news.php (modified) (5 diffs)

trunk/aktuality/news.php

@@ -19 +19 @@
     $ItemCount = abs($ItemCount);
     $DaysAgo = abs($DaysAgo);
-    $DbResult = $Database->select('news_category', '*', 'id='.$Category);
+    $DbResult = $Database->select('NewsCategory', '*', 'Id='.$Category);
     $Row = $DbResult->fetch_array();
     $Output = '<table cellspacing="0" cellpadding="0" border="0" width="100%" style="font-size: small; padding-bottom: 5px;"><tr>';
-    $Output .= '<td>'.$Row['caption'].'</td><td align="right">';
+    $Output .= '<td>'.$Row['Caption'].'</td><td align="right">';
     $Output .= '<a href="aktuality/index.php?category='.$Category.'">Zobrazit všechny aktuality</a>&nbsp;';
     if($this->System->Modules['User']->CheckPermission('News', 'Insert', 'Group', $Category))
       $Output .= '<a href="aktuality/index.php?action=add&amp;category='.$Category.'">Přidat aktualitu</a>&nbsp;';
     $Output .= '</td></tr><tr><td colspan="2">';
-    $DbResult = $Database->query('SELECT `news`.*, `User`.`Name` FROM `news` LEFT JOIN `User` ON `User`.`Id`=`news`.`User` WHERE (`news`.`category`='.$Category.') AND (DATE_SUB(NOW(), INTERVAL '.$DaysAgo.' DAY) < `news`.`date`) ORDER BY `news`.`date` DESC LIMIT 0,'.$ItemCount);
+    $DbResult = $Database->query('SELECT `News`.*, `User`.`Name` FROM `News` LEFT JOIN `User` ON `User`.`Id`=`News`.`User` WHERE (`News`.`Category`='.$Category.') AND (DATE_SUB(NOW(), INTERVAL '.$DaysAgo.' DAY) < `News`.`Date`) ORDER BY `News`.`Date` DESC LIMIT 0,'.$ItemCount);
     //echo($Database->error.'<br />');
     //echo($Database->LastQuery.'<br />');
@@ -38 +38 @@
       while($Row = $DbResult->fetch_array())
       {
-        if($Row['Name'] == '') $Author = $Row['author'];
+        if($Row['Name'] == '') $Author = $Row['Author'];
           else $Author = $Row['Name'];
-        $Output .= '<tr><td onclick="window.location=\'aktuality/index.php?action=view&amp;id='.$Row['id'].'\'" onmouseover="zobraz('."'new".$Category.$Index."'".')" style="cursor: pointer; margin: 0px;"><table cellspacing="0" cellpadding="0" style="padding: 0px; margin: 0px; font-size: small; color: red;" width="100%"><tr><td style="font-size: '.$FontSize.'pt"><strong>'.$Row['title'].'</strong></td><td align="right" style="font-size: '.$FontSize.'pt">'.$Author.' ('.HumanDate($Row['date']).')</td></tr></table>';
-        $Output .= '<div id="new'.$Category.$Index.'" class="NewsTableItem">'.$Row['content'];
+        $Output .= '<tr><td onclick="window.location=\'aktuality/index.php?action=view&amp;id='.$Row['Id'].'\'" onmouseover="zobraz('."'new".$Category.$Index."'".')" style="cursor: pointer; margin: 0px;"><table cellspacing="0" cellpadding="0" style="padding: 0px; margin: 0px; font-size: small; color: red;" width="100%"><tr><td style="font-size: '.$FontSize.'pt"><strong>'.$Row['Title'].'</strong></td><td align="right" style="font-size: '.$FontSize.'pt">'.$Author.' ('.HumanDate($Row['Date']).')</td></tr></table>';
+        $Output .= '<div id="new'.$Category.$Index.'" class="NewsTableItem">'.$Row['Content'];
 
-        if($Row['enclosure'] != '')
+        if($Row['Enclosure'] != '')
         { 
           $Output .= '<br />Přílohy: ';
-          $Enclosures = explode(';', $Row['enclosure']);
+          $Enclosures = explode(';', $Row['Enclosure']);
                 foreach($Enclosures as $Enclosure)
                 {
@@ -67 +67 @@
     $this->NewsSetting = array();
     $I = 1;
-    $DbResult = $this->Database->select('news_category', '*');
+    $DbResult = $this->Database->select('NewsCategory', '*');
     while($NewsCategory = $DbResult->fetch_array())
     {
-      $this->NewsSetting[] = array('CategoryId' => $NewsCategory['id'], 'Index' => $I, 'Enabled' => 1, 'ItemCount' => $this->System->Config['Web']['News']['Count'], 'DaysAgo' => $this->System->Config['Web']['News']['DaysAgo']);
+      $this->NewsSetting[] = array('CategoryId' => $NewsCategory['Id'], 'Index' => $I, 'Enabled' => 1, 'ItemCount' => $this->System->Config['Web']['News']['Count'], 'DaysAgo' => $this->System->Config['Web']['News']['DaysAgo']);
       $I++;
     }
@@ -118 +118 @@
     foreach($this->NewsSetting as $SettingItem)
     {
-      $DbResult = $this->Database->select('news_category', '*', 'id='.$SettingItem['CategoryId']);
+      $DbResult = $this->Database->select('NewsCategory', '*', 'Id='.$SettingItem['CategoryId']);
       $NewsCategory = $DbResult->fetch_array();
-      $Output .= '<tr><td>'.$NewsCategory['caption'].'</td><td align="center"><input type="text" size="2" name="NewsCategoryIndex'.$I.'" value="'.$SettingItem['Index'].'" /></td><td align="center"><input type="checkbox" name="NewsCategoryEnabled'.$I.'"';
+      $Output .= '<tr><td>'.$NewsCategory['Caption'].'</td><td align="center"><input type="text" size="2" name="NewsCategoryIndex'.$I.'" value="'.$SettingItem['Index'].'" /></td><td align="center"><input type="checkbox" name="NewsCategoryEnabled'.$I.'"';
       if($SettingItem['Enabled'] == 1) $Output .= ' checked="checked"'; 
       $Output .= ' /></td>'.
@@ -156 +156 @@
     setcookie('NewsSetting', $_COOKIE['NewsSetting'], time() + 60 * 60 * 24 * 365);
   }
-
 }
 
-
 ?>