Changeset 3598
- Timestamp:
- 07/05/07 01:05:54 (3 years ago)
- Location:
- trunk
- Files:
-
- 4 modified
-
blog/owner/entry/preview/item.php (modified) (1 diff)
-
lib/model/blog.entry.php (modified) (3 diffs)
-
lib/model/blog.trackback.php (modified) (2 diffs)
-
lib/piece/blog/begin.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
trunk/blog/owner/entry/preview/item.php
r3124 r3598 4 4 /// See the GNU General Public License for more details. (/doc/LICENSE, /doc/COPYRIGHT) 5 5 define('ROOT', '../../../..'); 6 require ROOT . '/lib/includeForBlogOwner.php'; 6 require ROOT . '/lib/includeForBlog.php'; 7 requireModel('blog.entry'); 7 8 $entries = array(); 8 if (!$entry = getEntry($ owner, $suri['id'], true))9 $entry = getEntry($ owner, $suri['id'], false);9 if (!$entry = getEntry($blogid, $suri['id'], true)) 10 $entry = getEntry($blogid, $suri['id'], false); 10 11 if ($entry && ($entry['category'] >= 0)) { 11 12 if (isset($entry['appointed'])) 12 13 $entry['published'] = $entry['appointed']; 13 $entry['categoryLabel'] = getCategoryLabelById($ owner, $entry['category']);14 $entry['categoryLabel'] = getCategoryLabelById($blogid, $entry['category']); 14 15 $entries[0] = $entry; 15 16 } -
trunk/lib/model/blog.entry.php
r3547 r3598 23 23 function getEntry($blogid, $id, $draft = false) { 24 24 global $database; 25 requireModel('blog.attachment'); 25 26 if ($id == 0) { 26 27 if ($draft) { … … 31 32 return; 32 33 deleteAttachments($blogid, 0); 33 return array('id' => 0, 'userid' => 0, 'draft' => 0, 'visibility' => 0, 'category' => 0, 'location' => '', 'title' => '', 'content' => '', 'contentFormatter' => getDefaultFormatter(), 'contentEditor' => getDefaultEditor(), 'acceptComment' => 1, 'acceptTrackback' => 1, 'published' => time(), 'slogan' => ''); 34 return array('id' => 0, 35 'userid' => 0, 36 'draft' => 0, 37 'visibility' => 0, 38 'category' => 0, 39 'location' => '', 40 'title' => '', 41 'content' => '', 42 'contentFormatter' => getDefaultFormatter(), 43 'contentEditor' => getDefaultEditor(), 44 'acceptComment' => 1, 45 'acceptTrackback' => 1, 46 'published' => time(), 47 'slogan' => ''); 34 48 } 35 49 } 36 50 if ($draft) { 37 $entry = DBQuery::queryRow("SELECT * FROM {$database['prefix']}Entries WHERE owner = $blogid AND id = $id AND draft = 1"); 51 $entry = DBQuery::queryRow("SELECT * FROM {$database['prefix']}Entries 52 WHERE owner = $blogid 53 AND id = $id 54 AND draft = 1"); 38 55 if (!$entry) 39 56 return; … … 43 60 $entry['appointed'] = $entry['published']; 44 61 if ($id != 0) 45 $entry['published'] = DBQuery::queryCell("SELECT published FROM {$database['prefix']}Entries WHERE owner = $blogid AND id = $id AND draft = 0"); 62 $entry['published'] = DBQuery::queryCell("SELECT published 63 FROM {$database['prefix']}Entries 64 WHERE owner = $blogid AND id = $id AND draft = 0"); 46 65 return $entry; 47 66 } else { 48 67 $visibility = doesHaveOwnership() ? '' : 'AND visibility > 0'; 49 $entry = DBQuery::queryRow("SELECT * FROM {$database['prefix']}Entries WHERE owner = $blogid AND id = $id AND draft = 0 $visibility"); 68 $entry = DBQuery::queryRow("SELECT * 69 FROM {$database['prefix']}Entries 70 WHERE owner = $blogid AND id = $id AND draft = 0 $visibility"); 50 71 if (!$entry) 51 72 return; -
trunk/lib/model/blog.trackback.php
r3476 r3598 10 10 11 11 $postfix = ''; 12 $sql = "SELECT t.*, c.name categoryName FROM {$database['prefix']}Trackbacks t LEFT JOIN {$database['prefix']}Entries e ON t.owner = e.owner AND t.entry = e.id AND e.draft = 0 LEFT JOIN {$database['prefix']}Categories c ON t.owner = c.owner AND e.category = c.id WHERE t.owner = $blogid AND t.isFiltered = 0"; 12 $sql = "SELECT t.*, c.name categoryName 13 FROM {$database['prefix']}Trackbacks t 14 LEFT JOIN {$database['prefix']}Entries e ON t.owner = e.owner AND t.entry = e.id AND e.draft = 0 15 LEFT JOIN {$database['prefix']}Categories c ON t.owner = c.owner AND e.category = c.id 16 WHERE t.owner = $blogid AND t.isFiltered = 0"; 13 17 if ($category > 0) { 14 18 $categories = DBQuery::queryColumn("SELECT id FROM {$database['prefix']}Categories WHERE owner = $blogid AND parent = $category"); … … 42 46 global $database; 43 47 $trackbacks = array(); 44 $result = DBQuery::query("select * from {$database['prefix']}Trackbacks where owner = ".getBlogId()." AND entry = $entry AND isFiltered = 0 order by written"); 48 $result = DBQuery::query("select * 49 from {$database['prefix']}Trackbacks 50 where owner = ".getBlogId()." 51 AND entry = $entry 52 AND isFiltered = 0 53 order by written"); 45 54 while ($trackback = mysql_fetch_array($result)) 46 55 array_push($trackbacks, $trackback); -
trunk/lib/piece/blog/begin.php
r3476 r3598 5 5 6 6 $blogid = getBlogId(); 7 requireModel('blog.statistics'); 7 8 8 9 updateVisitorStatistics($blogid);
