Changeset 196


Ignore:
Timestamp:
Apr 27, 2009, 8:00:50 AM (15 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.
Location:
trunk
Files:
1 added
6 edited

Legend:

Unmodified
Added
Removed

  • trunk/aktuality/import_zdechov_cz_aktuality.php

    r151 r196  
    3131*/
    3232
    33   $DbResult = $Database->select('news', 'id', '`title`="'.$Title.'" AND `date`="'.$Date.'" AND `category`='.$Category);
     33  $DbResult = $Database->select('News', 'Id', '`Title`="'.$Title.'" AND `Date`="'.$Date.'" AND `Category`='.$Category);
    3434  //echo($Database->LastQuery);
    3535  if($DbResult->num_rows == 0)
    3636  {
    37     $Database->insert('news', array('title' => $Title, 'date' => $Date, 'author' => 'zdechov.cz', 'category' => $Category, 'content' => addslashes($Description)));
     37    $Database->insert('News', array('Title' => $Title, 'Date' => $Date, 'Author' => 'zdechov.cz', 'Category' => $Category, 'Content' => addslashes($Description)));
    3838    echo($Database->insert_id.',');
    3939  }

  • trunk/aktuality/import_zdechov_cz_zapisy.php

    r151 r196  
    3030*/
    3131
    32   $DbResult = $Database->select('news', 'id', '`title`="'.$Title.'" AND `date`="'.$Date.'" AND `category`='.$Category);
     32  $DbResult = $Database->select('News', 'Id', '`Title`="'.$Title.'" AND `Date`="'.$Date.'" AND `Category`='.$Category);
    3333  //echo($Database->LastQuery);
    3434  if($DbResult->num_rows == 0)
    3535  {
    36     $Database->insert('news', array('title' => $Title, 'date' => $Date, 'author' => 'zdechov.cz', 'category' => $Category, 'content' => $Description));
     36    $Database->insert('News', array('Title' => $Title, 'Date' => $Date, 'Author' => 'zdechov.cz', 'Category' => $Category, 'Content' => $Description));
    3737    echo($Database->insert_id.',');
    3838  }

  • trunk/aktuality/index.php

    r189 r196  
    1616    if(array_key_exists('category', $_GET)) $Category = $_GET['category'] * 1;
    1717    if(array_key_exists('category', $_POST)) $Category = $_POST['category'] * 1;
    18     $DbResult = $this->Database->select('news_category', '*', 'id='.$Category);
     18    $DbResult = $this->Database->select('NewsCategory', '*', 'Id='.$Category);
    1919    if($DbResult->num_rows > 0)
    2020    {
    2121      $Row = $DbResult->fetch_array();
    22       $CategoryName = $Row['caption'];
     22      $CategoryName = $Row['Caption'];
    2323    }
    2424
    … …  
    3131        {
    3232          if(array_key_exists('id', $_GET)) $Id = $_GET['id'] * 1;
    33           $DbResult = $this->Database->query('SELECT `news`.*, `User`.`Name` FROM `news` LEFT JOIN `User` ON `User`.`Id`=`news`.`User` WHERE  `news`.`id`='.$Id);
     33          $DbResult = $this->Database->query('SELECT `News`.*, `User`.`Name` FROM `News` LEFT JOIN `User` ON `User`.`Id`=`News`.`User` WHERE  `News`.`Id`='.$Id);
    3434          if($DbResult->num_rows > 0)
    3535          {
    3636            $Row = $DbResult->fetch_array();
    37             if($Row['Name'] == '') $Author = $Row['author'];
     37            if($Row['Name'] == '') $Author = $Row['Author'];
    3838              else $Author = $Row['Name'];
    39             $Output .= '<div style="border: thin dotted #97ADFF;        background: #F6F7FF; margin-top: 5px; padding: 0px 5px 5px 5px;"><div style="padding-bottom: 1px; border-bottom-width: 1; border-bottom-style: solid; border-bottom-color: silver;"><strong>'.$Row['title'].' ('.HumanDate($Row['date']).', '.$Author.')</strong>';
     39            $Output .= '<div style="border: thin dotted #97ADFF;        background: #F6F7FF; margin-top: 5px; padding: 0px 5px 5px 5px;"><div style="padding-bottom: 1px; border-bottom-width: 1; border-bottom-style: solid; border-bottom-color: silver;"><strong>'.$Row['Title'].' ('.HumanDate($Row['Date']).', '.$Author.')</strong>';
    4040            if($this->System->Modules['User']->User['Id'] == $Row['User'])
    4141            {
    42               $Output .= '&nbsp;<a href="index.php?action=del&amp;category='.$Category.'&amp;id='.$Row['id'].'">Smazat</a>';
    43               $Output .= '&nbsp;<a href="index.php?action=edit&amp;category='.$Category.'&amp;id='.$Row['id'].'">Editovat</a>';
    44             }
    45             $Output .= '</div>'.$Row['content'].'<br />';
    46             if($Row['enclosure'] != '')
     42              $Output .= '&nbsp;<a href="index.php?action=del&amp;category='.$Category.'&amp;id='.$Row['Id'].'">Smazat</a>';
     43              $Output .= '&nbsp;<a href="index.php?action=edit&amp;category='.$Category.'&amp;id='.$Row['Id'].'">Editovat</a>';
     44            }
     45            $Output .= '</div>'.$Row['Content'].'<br />';
     46            if($Row['Enclosure'] != '')
    4747            {
    4848              $Output .= '<br />Přílohy: ';
    49               $Enclosures = explode(';', $Row['enclosure']);
     49              $Enclosures = explode(';', $Row['Enclosure']);
    5050              foreach($Enclosures as $Enclosure)
    5151              {
    … …  
    6262        $Output .= '<form enctype="multipart/form-data" action="?action=add2" method="post">'.
    6363    'Kategorie: <select name="category">';
    64         $DbResult = $this->Database->select('news_category', '*');
     64        $DbResult = $this->Database->select('NewsCategory', '*');
    6565        while($DbRow = $DbResult->fetch_array())
    6666        {
    67           if($this->System->Modules['User']->CheckPermission('News', 'Insert', 'Group', $DbRow['id']))
    68           {
    69             if($DbRow['id'] == $Category) $Selected = ' selected="1"'; else $Selected = '';
    70             $Output .= '<option value="'.$DbRow['id'].'"'.$Selected.'>'.$DbRow['caption'].'</option>';
     67          if($this->System->Modules['User']->CheckPermission('News', 'Insert', 'Group', $DbRow['Id']))
     68          {
     69            if($DbRow['Id'] == $Category) $Selected = ' selected="1"'; else $Selected = '';
     70            $Output .= '<option value="'.$DbRow['Id'].'"'.$Selected.'>'.$DbRow['Caption'].'</option>';
    7171          }
    7272        }
    … …  
    105105
    106106          $_POST['content'] = str_replace("\n",'<br />',$_POST['content']);
    107           $this->Database->insert('news',array('category' => $Category, 'title' => $_POST['title'], 'content' => $_POST['content'], 'date' => 'NOW()', 'ip' => $RemoteAddr, 'enclosure' => $Enclosures, 'author' => $this->System->Modules['User']->User['Name'], 'User' => $this->System->Modules['User']->User['Id']));
     107          $this->Database->insert('News',array('Category' => $Category, 'Title' => $_POST['title'], 'Content' => $_POST['content'], 'Date' => 'NOW()', 'IP' => $RemoteAddr, 'Enclosure' => $Enclosures, 'Author' => $this->System->Modules['User']->User['Name'], 'User' => $this->System->Modules['User']->User['Id']));
    108108          $Output .= 'Aktualita přidána!<br />Pokud budete chtít vaši aktualitu smazat, klikněte na odkaz Smazat v seznamu všech aktualit v kategorii.<br /><br />';
    109109          $Output .= '<a href="index.php?category='.$_POST['category'].'">Zpět na seznam aktualit</a>';
    … …  
    112112        break;
    113113      case 'edit':
    114         $DbResult = $this->Database->query('SELECT * FROM news WHERE id='.$_GET['id']);
     114        $DbResult = $this->Database->query('SELECT * FROM News WHERE Id='.$_GET['id']);
    115115        $Row = $DbResult->fetch_array();
    116116        if($this->System->Modules['User']->User['Id'] == $Row['User'])
    117117        {
    118           $Row['content'] = str_replace('<br />', "", $Row['content']);
     118          $Row['Content'] = str_replace('<br />', '', $Row['Content']);
    119119          $Output .= '<strong>Editace aktuality v kategorii '.$CategoryName.':</strong><br />';
    120120          $Output .= '<form action="index.php?action=update" method="post">'.
    121121          '<input type="hidden" value="'.$_GET['id'].'" name="id">'.
    122           'Nadpis:<br /><input type="text" size="54" name="title" value="'.$Row['title'].'"><br />'.
    123           'Obsah:<br /><textarea name="content" rows="20" cols="40">'.$Row['content'].'</textarea><br />'.
     122          'Nadpis:<br /><input type="text" size="54" name="title" value="'.$Row['Title'].'"><br />'.
     123          'Obsah:<br /><textarea name="content" rows="20" cols="40">'.$Row['Content'].'</textarea><br />'.
    124124          '<input type="hidden" name="category" value="'.$Category.'"><br />'.
    125125          '<input type="submit" value="Uložit">'.
    … …  
    130130        $RemoteAddr = GetRemoteAddress(); 
    131131        $_POST['id'] = $_POST['id'] * 1;
    132         $DbResult = $this->Database->select('news', '*', 'id='.$_POST['id']);
     132        $DbResult = $this->Database->select('News', '*', 'Id='.$_POST['id']);
    133133        if($DbResult->num_rows > 0)
    134134        {
    … …  
    136136          if($this->System->Modules['User']->User['Id'] == $Row['User'])
    137137          {
    138             $_POST['content'] = str_replace("\n",'<br />',$_POST['content']);
    139             $this->Database->update('news', 'id='.$_POST['id'], array('title' => $_POST['title'], 'content' => $_POST['content']));
     138            $_POST['content'] = str_replace("\n", '<br />', $_POST['content']);
     139            $this->Database->update('News', 'Id='.$_POST['id'], array('Title' => $_POST['title'], 'Content' => $_POST['content']));
    140140            $Output .= 'Aktualita uložena!<br />';
    141141            $Output .= '<a href="index.php?category='.$Category.'">Zpět na seznam aktualit</a>';
    … …  
    144144        break;
    145145      case 'del':
    146         $DbResult = $this->Database->query('SELECT * FROM news WHERE id='.$_GET['id']);
     146        $DbResult = $this->Database->query('SELECT * FROM News WHERE Id='.$_GET['id']);
    147147        $Row = $DbResult->fetch_array();
    148148        if($this->System->Modules['User']->User['Id'] == $Row['User'])
    149149        {
    150           if($Row['enclosure'] != '')
     150          if($Row['Enclosure'] != '')
    151151          {
    152152            $Output .= '<br />Přílohy: ';
    153             $Enclosures = explode(';', $Row['enclosure']);
     153            $Enclosures = explode(';', $Row['Enclosure']);
    154154                  foreach($Enclosures as $Enclosure)
    155155                  {
    … …  
    157157                  }
    158158          }
    159           $this->Database->query('DELETE FROM news WHERE id='.$_GET['id']);
     159          $this->Database->query('DELETE FROM News WHERE Id='.$_GET['id']);
    160160          $Output .= 'Aktualita smazána!<br /><a href="index.php?category='.$Category.'">Zpět na seznam aktualit</a>';
    161161        } else $Output .= 'Nemáte oprávnění.';
    … …  
    165165        {
    166166          $PerPage = 20;
    167           $DbResult = $this->Database->select('news', 'COUNT(*)', ' category='.$Category);
     167          $DbResult = $this->Database->select('News', 'COUNT(*)', ' Category='.$Category);
    168168          $RowTotal = $DbResult->fetch_array();
    169169          $PageMax = $RowTotal[0];
    170           if(array_key_exists('page', $_GET)) $Page = $_GET['page']; else $Page = 0; //round($PageMax/$PerPage);
     170          if(array_key_exists('page', $_GET)) $Page = $_GET['page'];
     171            else $Page = 0; //round($PageMax/$PerPage);
    171172          $Output .= '<strong>Seznam aktualit kategorie '.$CategoryName.':</strong><div style="font-size: small;">';
    172           $Output .= PagesList('?category='.$Category.'&amp;page=',$Page,$PageMax,$PerPage);
     173          $Output .= PagesList('?category='.$Category.'&amp;page=', $Page, $PageMax, $PerPage);
    173174
    174175          //echo(GetRemoteAddress().','.$_SERVER['HTTP_X_FORWARDED_FOR'].'<br />');
    175           $DbResult = $this->Database->query('SELECT `news`.*, `User`.`Name` FROM `news` LEFT JOIN `User` ON `User`.`Id`=`news`.`User` WHERE `category`='.$Category.' ORDER BY `news`.`id` DESC LIMIT '.($Page * $PerPage).','.$PerPage);
     176          $DbResult = $this->Database->query('SELECT `News`.*, `User`.`Name` FROM `News` LEFT JOIN `User` ON `User`.`Id`=`News`.`User` WHERE `Category`='.$Category.' ORDER BY `News`.`Id` DESC LIMIT '.($Page * $PerPage).','.$PerPage);
    176177          while($Row = $DbResult->fetch_array())
    177178          {
    178             if($Row['Name'] == '') $Author = $Row['author'];
     179            if($Row['Name'] == '') $Author = $Row['Author'];
    179180              else $Author = $Row['Name'];
    180             $Output .= '<div style="border: thin dotted #97ADFF; background: #F6F7FF; margin-top: 5px; padding: 0px 5px 5px 5px;"><div style="padding-bottom: 1px; border-bottom-width: 1; border-bottom-style: solid; border-bottom-color: silver;"><strong><a href="?action=view&id='.$Row['id'].'">'.$Row['title'].'</a> ('.HumanDate($Row['date']).', '.$Author.')</strong>';
     181            $Output .= '<div style="border: thin dotted #97ADFF; background: #F6F7FF; margin-top: 5px; padding: 0px 5px 5px 5px;"><div style="padding-bottom: 1px; border-bottom-width: 1; border-bottom-style: solid; border-bottom-color: silver;"><strong><a href="?action=view&id='.$Row['Id'].'">'.$Row['Title'].'</a> ('.HumanDate($Row['Date']).', '.$Author.')</strong>';
    181182            if($this->System->Modules['User']->User['Id'] == $Row['User'])
    182183            {
    183               $Output .= '&nbsp;<a href="index.php?action=del&amp;category='.$Category.'&amp;id='.$Row['id'].'">Smazat</a>';
    184               $Output .= '&nbsp;<a href="index.php?action=edit&amp;category='.$Category.'&amp;id='.$Row['id'].'">Editovat</a>';
    185             }
    186             $Output .= '</div>'.$Row['content'].'<br />';
    187             if($Row['enclosure'] != '')
     184              $Output .= '&nbsp;<a href="index.php?action=del&amp;category='.$Category.'&amp;id='.$Row['Id'].'">Smazat</a>';
     185              $Output .= '&nbsp;<a href="index.php?action=edit&amp;category='.$Category.'&amp;id='.$Row['Id'].'">Editovat</a>';
     186            }
     187            $Output .= '</div>'.$Row['Content'].'<br />';
     188            if($Row['Enclosure'] != '')
    188189            {
    189190              $Output .= '<br />Přílohy: ';
    190               $Enclosures = explode(';', $Row['enclosure']);
     191              $Enclosures = explode(';', $Row['Enclosure']);
    191192                    foreach($Enclosures as $Enclosure)
    192193              {

  • trunk/aktuality/news.php

    r189 r196  
    1919    $ItemCount = abs($ItemCount);
    2020    $DaysAgo = abs($DaysAgo);
    21     $DbResult = $Database->select('news_category', '*', 'id='.$Category);
     21    $DbResult = $Database->select('NewsCategory', '*', 'Id='.$Category);
    2222    $Row = $DbResult->fetch_array();
    2323    $Output = '<table cellspacing="0" cellpadding="0" border="0" width="100%" style="font-size: small; padding-bottom: 5px;"><tr>';
    24     $Output .= '<td>'.$Row['caption'].'</td><td align="right">';
     24    $Output .= '<td>'.$Row['Caption'].'</td><td align="right">';
    2525    $Output .= '<a href="aktuality/index.php?category='.$Category.'">Zobrazit všechny aktuality</a>&nbsp;';
    2626    if($this->System->Modules['User']->CheckPermission('News', 'Insert', 'Group', $Category))
    2727      $Output .= '<a href="aktuality/index.php?action=add&amp;category='.$Category.'">Přidat aktualitu</a>&nbsp;';
    2828    $Output .= '</td></tr><tr><td colspan="2">';
    29     $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);
     29    $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);
    3030    //echo($Database->error.'<br />');
    3131    //echo($Database->LastQuery.'<br />');
    … …  
    3838      while($Row = $DbResult->fetch_array())
    3939      {
    40         if($Row['Name'] == '') $Author = $Row['author'];
     40        if($Row['Name'] == '') $Author = $Row['Author'];
    4141          else $Author = $Row['Name'];
    42         $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>';
    43         $Output .= '<div id="new'.$Category.$Index.'" class="NewsTableItem">'.$Row['content'];
     42        $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>';
     43        $Output .= '<div id="new'.$Category.$Index.'" class="NewsTableItem">'.$Row['Content'];
    4444
    45         if($Row['enclosure'] != '')
     45        if($Row['Enclosure'] != '')
    4646        {
    4747          $Output .= '<br />Přílohy: ';
    48           $Enclosures = explode(';', $Row['enclosure']);
     48          $Enclosures = explode(';', $Row['Enclosure']);
    4949                foreach($Enclosures as $Enclosure)
    5050                {
    … …  
    6767    $this->NewsSetting = array();
    6868    $I = 1;
    69     $DbResult = $this->Database->select('news_category', '*');
     69    $DbResult = $this->Database->select('NewsCategory', '*');
    7070    while($NewsCategory = $DbResult->fetch_array())
    7171    {
    72       $this->NewsSetting[] = array('CategoryId' => $NewsCategory['id'], 'Index' => $I, 'Enabled' => 1, 'ItemCount' => $this->System->Config['Web']['News']['Count'], 'DaysAgo' => $this->System->Config['Web']['News']['DaysAgo']);
     72      $this->NewsSetting[] = array('CategoryId' => $NewsCategory['Id'], 'Index' => $I, 'Enabled' => 1, 'ItemCount' => $this->System->Config['Web']['News']['Count'], 'DaysAgo' => $this->System->Config['Web']['News']['DaysAgo']);
    7373      $I++;
    7474    }
    … …  
    118118    foreach($this->NewsSetting as $SettingItem)
    119119    {
    120       $DbResult = $this->Database->select('news_category', '*', 'id='.$SettingItem['CategoryId']);
     120      $DbResult = $this->Database->select('NewsCategory', '*', 'Id='.$SettingItem['CategoryId']);
    121121      $NewsCategory = $DbResult->fetch_array();
    122       $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.'"';
     122      $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.'"';
    123123      if($SettingItem['Enabled'] == 1) $Output .= ' checked="checked"';
    124124      $Output .= ' /></td>'.
    … …  
    156156    setcookie('NewsSetting', $_COOKIE['NewsSetting'], time() + 60 * 60 * 24 * 365);
    157157  }
    158 
    159158}
    160159
    161 
    162160?>

  • trunk/aktuality/rss.php

    r187 r196  
    11<?php
    22
    3 Header("Content-Type: text/xml");
     3Header('Content-Type: text/xml');
    44
    55include_once('../global.php');
    … …  
    2828// Get category names
    2929$Categories = array();
    30 $DbResult = $Database->select('news_category', '*');
     30$DbResult = $Database->select('NewsCategory', '*');
    3131while($Category = $DbResult->fetch_array())
    3232{
    33   $Categories[$Category['id']] = $Category['caption'];
     33  $Categories[$Category['Id']] = $Category['Caption'];
    3434}
    3535
    … …  
    6161  $Database->select_db('forum');
    6262}
     63$Database->select_db('is');
    6364*/
    64 $Database->select_db('is');
    6565
    6666// Get news from database by selected categories
    6767$UploadedFilesFolder = 'uploads/';
    68 $DbResult = $Database->query('SELECT enclosure,category,title,content,UNIX_TIMESTAMP(date),author FROM news WHERE '.$Where.' ORDER BY date DESC LIMIT 0,'.$NewsCount);
    69 while($Row = $DbResult->fetch_array())
     68$DbResult = $Database->query('SELECT *, UNIX_TIMESTAMP(Date) FROM News LEFT JOIN `User` ON `User`.`Id`=`News`.`User` WHERE '.$Where.' ORDER BY News.Date DESC LIMIT 0,'.$NewsCount);
     69while($Row = $DbResult->fetch_assoc())
    7070{
    7171  $EnclosuresText = '';
    72   if($Row['enclosure'] != '')
     72  if($Row['Enclosure'] != '')
    7373  {
    7474    $EnclosuresText .= '<br />Přílohy: ';
    75     $Enclosures = explode(';', $Row['enclosure']);
     75    $Enclosures = explode(';', $Row['Enclosure']);
    7676    foreach($Enclosures as $Enclosure)
    7777    {
    … …  
    7979    }
    8080  }
     81  if($Row['Name'] == '') $Author = $Row['Author'];
     82    else $Author = $Row['Name'];
    8183  $Items[] = array(
    82     'Title' => $Categories[$Row['category']].' - '.$Row['title'],
    83     'Link' => 'http://centrala.zdechov.net/aktuality/index.php?category='.$Row['category'],
    84     'Description' => $Row['content']." (".$Row['author'].")".$EnclosuresText,
    85     'Time' => $Row['UNIX_TIMESTAMP(date)'],
     84    'Title' => $Categories[$Row['Category']].' - '.$Row['Title'],
     85    'Link' => 'http://centrala.zdechov.net/aktuality/index.php?category='.$Row['Category'],
     86    'Description' => $Row['Content'].' ('.$Author.')'.$EnclosuresText,
     87    'Time' => $Row['UNIX_TIMESTAMP(Date)'],
    8688  );
    8789}
    … …  
    9395  'WebmasterEmail' => $Config['Web']['AdminEmail'],
    9496  'Items' => $Items)));
     97 
    9598?>

  • trunk/aktuality/subscription.php

    r151 r196  
    2020      $Output = 'Výsledný RSS kanál: <a href="'.$Select.'">'.$Select.'</a>';
    2121    } else
    22         {
     22    {
    2323      $Output = 'Vytvořte si vlastní RSS kanál, díky kterému budete moci automaticky sledovat novinky pomocí vaší RSS čtečky. Informace o technologii RSS a programech pro čtení kanálů najdete např. <a href="http://www.lupa.cz/clanky/prehled-rss-ctecek/">zde</a><br />'.
    2424      '<br />Kategorie:<br />';
    2525      $Output .= '<form action="subscription.php?build=1" method="post">';
    26       $DbResult = $this->Database->select('news_category', '*', '1 ORDER BY caption');
     26      $DbResult = $this->Database->select('NewsCategory', '*', '1 ORDER BY Caption');
    2727      while($Category = $DbResult->fetch_array())
    2828      {
    29         $Output .= '<input type="checkbox" name="category'.$Category['id'].'" />'.$Category['caption'].'<br />';
     29        $Output .= '<input type="checkbox" name="category'.$Category['Id'].'" />'.$Category['Caption'].'<br />';
    3030      }
    3131      $Output.= '<input type="submit" value="Sestavit " />'.
    3232        '</form>';
    3333    } 
    34         return($Output);
     34    return($Output);
    3535  }
    3636}
Note: See TracChangeset for help on using the changeset viewer.