Changeset 189 for trunk/aktuality/news.php

Timestamp:

Apr 12, 2009, 5:40:08 PM (16 years ago)

Author:

george

Message:

• Upraveno: Údaje uživatele jméno a příjmení bylo sloušeno do údaje Zobrazované jméno. Upraveny patřičné sloupce a odkazy ze skriptů.
• Opraveno: Registrace nových uživatelů.

File:

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

trunk/aktuality/news.php

@@ -27 +27 @@
       $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`.`Nick` 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['Nick'] == '') $Author = $Row['author'];
-          else $Author = $Row['Nick'];
+        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'];