Changeset 773 for trunk/Modules/Forum
- Timestamp:
- Jan 31, 2014, 12:17:43 PM (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/Modules/Forum/Forum.php
r767 r773 282 282 $TitleLength = 50; 283 283 mb_internal_encoding('utf-8'); 284 $DbResult = $this->Database->query('SELECT ` ID`, UNIX_TIMESTAMP(`Date`) AS `UnixDate`, '.284 $DbResult = $this->Database->query('SELECT `Thread`, `ID`, UNIX_TIMESTAMP(`Date`) AS `UnixDate`, '. 285 285 '`User`, `UserName`, `Text`, ( SELECT `Text` FROM `ForumThread` '. 286 'WHERE `ID` = `ForumText`.`Thread`) AS `Thread ` FROM `ForumText` ORDER BY `ID` DESC LIMIT 20');286 'WHERE `ID` = `ForumText`.`Thread`) AS `ThreadText` FROM `ForumText` ORDER BY `ID` DESC LIMIT 20'); 287 287 while($DbRow = $DbResult->fetch_assoc()) 288 288 { … … 291 291 $Items[] = array 292 292 ( 293 'Title' => $DbRow['Thread '].' - '.$DbRow['UserName'].': ',294 'Link' => 'http://'.$this->System->Config['Web']['Host'].$this->System->Link('/forum/?Thread='.$DbRow[' ID']),293 'Title' => $DbRow['ThreadText'].' - '.$DbRow['UserName'].': ', 294 'Link' => 'http://'.$this->System->Config['Web']['Host'].$this->System->Link('/forum/?Thread='.$DbRow['Thread']), 295 295 'Description' => $parser->qparse($DbRow['Text']), 296 296 'Time' => $DbRow['UnixDate'],
Note:
See TracChangeset
for help on using the changeset viewer.