Changeset 636
- Timestamp:
- Sep 14, 2009, 3:30:10 PM (15 years ago)
- Location:
- trunk
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/rss.php
r631 r636 18 18 { 19 19 $Config['Web']['Title'] .= ' - články'; 20 $DbResult = $db->query('SELECT UNIX_TIMESTAMP( date), articles.* FROM articles ORDER BY date DESC LIMIT '.$NewsCount);20 $DbResult = $db->query('SELECT UNIX_TIMESTAMP(Time), Article.* FROM Article ORDER BY Time DESC LIMIT '.$NewsCount); 21 21 while($Row = $DbResult->fetch_assoc()) 22 22 { 23 23 $Items[] = array( 24 'Title' => $Row[' title'],24 'Title' => $Row['Title'], 25 25 'Link' => 'http://'.$_SERVER['SERVER_NAME'].$Config['Web']['BaseURL'], 26 'Description' => $Row[' text'].' ('.$Row['autor'].')',27 'Time' => $Row['UNIX_TIMESTAMP( date)'],26 'Description' => $Row['Text'].' ('.$Row['Author'].')', 27 'Time' => $Row['UNIX_TIMESTAMP(Time)'], 28 28 ); 29 29 } -
trunk/sql/updates/635.sql
r635 r636 23 23 (4, 'Články'); 24 24 25 ALTER TABLE `Article` ADD FOREIGN KEY ( `Category` ) REFERENCES ` wow`.`ArticleCategory` (`Id`);25 ALTER TABLE `Article` ADD FOREIGN KEY ( `Category` ) REFERENCES `ArticleCategory` (`Id`);
Note:
See TracChangeset
for help on using the changeset viewer.