+<<<<<<< HEAD
+<?php\r
+\r
+/*\r
+ * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)\r
+ * Copyright (C) 2002-2012 The Nucleus Group\r
+ *\r
+ * This program is free software; you can redistribute it and/or\r
+ * modify it under the terms of the GNU General Public License\r
+ * as published by the Free Software Foundation; either version 2\r
+ * of the License, or (at your option) any later version.\r
+ * (see nucleus/documentation/index.html#license for more info)\r
+ */\r
+/**\r
+ * A class representing a blog and containing functions to get that blog shown\r
+ * on the screen\r
+ *\r
+ * @license http://nucleuscms.org/license.txt GNU General Public License\r
+ * @copyright Copyright (C) 2002-2009 The Nucleus Group\r
+ * @version $Id: BLOG.php 1624 2012-01-09 11:36:20Z sakamocchi $\r
+ */\r
+\r
+if ( !function_exists('requestVar') ) exit;\r
+require_once dirname(__FILE__) . '/ITEMACTIONS.php';\r
+\r
+class Blog\r
+{\r
+ // blog id\r
+ public $blogid;\r
+ \r
+ // After creating an object of the blog class, contains true if the BLOG object is\r
+ // valid (the blog exists)\r
+ public $isValid;\r
+ \r
+ // associative array, containing all blogsettings (use the get/set functions instead)\r
+ private $settings;\r
+ \r
+ // ID of currently selected category\r
+ private $selectedcatid;\r
+ \r
+ /**\r
+ * Blog::_\construct()\r
+ * Creates a new BLOG object for the given blog\r
+ *\r
+ * @param integer $id blogid\r
+ * @return void\r
+ */\r
+ public function __construct($id)\r
+ {\r
+ global $catid;\r
+ \r
+ $this->blogid = (integer) $id;\r
+ $this->readSettings();\r
+ $this->setSelectedCategory($catid);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::readLog()\r
+ * Shows the given amount of items for this blog\r
+ *\r
+ * @param string $template String representing the template _NAME_ (!)\r
+ * @param integer $amountEntries amount of entries to show\r
+ * @param integer $startpos offset from where items should be shown (e.g. 5 = start at fifth item)\r
+ * @return integer amount of items shown\r
+ */\r
+ public function readLog($template, $amountEntries, $offset = 0, $startpos = 0)\r
+ {\r
+ return $this->readLogAmount($template,$amountEntries,'','',1,1,$offset, $startpos);\r
+ }\r
+ \r
+ /**\r
+ * Blog::showArchive()\r
+ * Shows an archive for a given month\r
+ *\r
+ * @param integer $year year\r
+ * @param integer $month month\r
+ * @param string $template String representing the template name to be used\r
+ * @return void\r
+ */\r
+ public function showArchive($templatename, $year, $month=0, $day=0)\r
+ {\r
+ // create extra where clause for select query\r
+ if ( $day == 0 && $month != 0 )\r
+ {\r
+ $timestamp_start = mktime(0,0,0,$month,1,$year);\r
+ // also works when $month==12\r
+ $timestamp_end = mktime(0,0,0,$month+1,1,$year);\r
+ }\r
+ elseif ( $month == 0 )\r
+ {\r
+ $timestamp_start = mktime(0,0,0,1,1,$year);\r
+ // also works when $month==12\r
+ $timestamp_end = mktime(0,0,0,12,31,$year);\r
+ }\r
+ else\r
+ {\r
+ $timestamp_start = mktime(0,0,0,$month,$day,$year);\r
+ $timestamp_end = mktime(0,0,0,$month,$day+1,$year);\r
+ }\r
+ $extra_query = " and i.itime>=%s and i.itime<%s";\r
+ $extra_query = sprintf($extra_query, DB::formatDateTime($timestamp_start), DB::formatDateTime($timestamp_end));\r
+ \r
+ $this->readLogAmount($templatename,0,$extra_query,'',1,1);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::setSelectedCategory()\r
+ * Sets the selected category by id (only when category exists)\r
+ * \r
+ * @param integer $catid ID for category\r
+ * @return void\r
+ */\r
+ public function setSelectedCategory($catid)\r
+ {\r
+ if ( $this->isValidCategory($catid) || (intval($catid) == 0) )\r
+ {\r
+ $this->selectedcatid = intval($catid);\r
+ }\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::setSelectedCategoryByName()\r
+ * Sets the selected category by name\r
+ * \r
+ * @param string $catname name of category\r
+ * @return void\r
+ */\r
+ public function setSelectedCategoryByName($catname)\r
+ {\r
+ $this->setSelectedCategory($this->getCategoryIdFromName($catname));\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::getSelectedCategory()\r
+ * Returns the selected category\r
+ * \r
+ * @param void\r
+ * @return integer\r
+ */\r
+ public function getSelectedCategory()\r
+ {\r
+ return $this->selectedcatid;\r
+ }\r
+ \r
+ /**\r
+ * Shows the given amount of items for this blog\r
+ *\r
+ * @param string $template string representing the template _NAME_ (!)\r
+ * @param integer $amountEntries amount of entries to show (0 = no limit)\r
+ * @param string $extraQuery extra conditions to be added to the query\r
+ * @param string $highlight contains a query that should be highlighted\r
+ * @param integer $comments 1=show comments 0=don't show comments\r
+ * @param integer $dateheads 1=show dateheads 0=don't show dateheads\r
+ * @param integer $offset offset\r
+ * @return integer amount of items shown\r
+ */\r
+ private function readLogAmount($template, $amountEntries, $extraQuery, $highlight, $comments, $dateheads, $offset = 0, $startpos = 0)\r
+ {\r
+ $query = $this->getSqlBlog($extraQuery);\r
+ \r
+ if ( $amountEntries > 0 )\r
+ {\r
+ // $offset zou moeten worden:\r
+ // (($startpos / $amountentries) + 1) * $offset ... later testen ...\r
+ $query .= ' LIMIT ' . intval($startpos + $offset).',' . intval($amountEntries);\r
+ }\r
+ return $this->showUsingQuery($template, $query, $highlight, $comments, $dateheads);\r
+ }\r
+ \r
+ /**\r
+ * Blog::showUsingQuery()\r
+ * Do the job for readLogAmmount\r
+ * \r
+ * @param string $templateName template name\r
+ * @param string $query string for query\r
+ * @param string $highlight string to be highlighted\r
+ * @param integer $comments the number of comments\r
+ * @param boolean $dateheads date header is needed or not\r
+ * @return integer the number of rows as a result of mysql query\r
+ */\r
+ private function showUsingQuery($templateName, $query, $highlight = '', $comments = 0, $dateheads = 1)\r
+ {\r
+ global $CONF, $manager, $currentTemplateName;\r
+ \r
+ $lastVisit = cookieVar($CONF['CookiePrefix'] .'lastVisit');\r
+ if ( $lastVisit != 0 )\r
+ {\r
+ $lastVisit = $this->getCorrectTime($lastVisit);\r
+ }\r
+ \r
+ // set templatename as global variable (so plugins can access it)\r
+ $currentTemplateName = $templateName;\r
+ $template =& $manager->getTemplate($templateName);\r
+ \r
+ // create parser object & action handler\r
+ $handler = new ItemActions($this);\r
+ $handler->setTemplate($template);\r
+ $handler->setHighlight($highlight);\r
+ $handler->setLastVisit($lastVisit);\r
+ $handler->setShowComments($comments);\r
+ \r
+ $parser = new Parser($handler);\r
+ \r
+ // execute query\r
+ $items = DB::getResult($query);\r
+ \r
+ // loop over all items\r
+ $old_date = 0;\r
+ foreach ( $items as $item )\r
+ {\r
+ // string timestamp -> unix timestamp\r
+ $item['timestamp'] = strtotime($item['itime']);\r
+ \r
+ // action handler needs to know the item we're handling\r
+ $handler->setCurrentItem($item);\r
+ \r
+ // add date header if needed\r
+ if ( $dateheads )\r
+ {\r
+ $new_date = date('dFY', $item['timestamp']);\r
+ if ( $new_date != $old_date )\r
+ {\r
+ // unless this is the first time, write date footer\r
+ $timestamp = $item['timestamp'];\r
+ if ( $old_date != 0 )\r
+ {\r
+ $oldTS = strtotime($old_date);\r
+ $manager->notify('PreDateFoot',array('blog' => &$this, 'timestamp' => $oldTS));\r
+ \r
+ if ( !in_array('DATE_FOOTER', $template) || empty($template['DATE_FOOTER']) )\r
+ {\r
+ $tmp_footer = '';\r
+ }\r
+ else\r
+ {\r
+ $tmp_footer = i18n::formatted_datetime($template['DATE_FOOTER'], $oldTS);\r
+ }\r
+ $parser->parse($tmp_footer);\r
+ $manager->notify('PostDateFoot',array('blog' => &$this, 'timestamp' => $oldTS));\r
+ }\r
+ \r
+ $manager->notify('PreDateHead',array('blog' => &$this, 'timestamp' => $timestamp));\r
+ \r
+ // note, to use templatvars in the dateheader, the %-characters need to be doubled in\r
+ // order to be preserved by strftime\r
+ if ( !in_array('DATE_HEADER', $template) || empty($template['DATE_HEADER']) )\r
+ {\r
+ $tmp_header = '';\r
+ }\r
+ else\r
+ {\r
+ $tmp_header = i18n::formatted_datetime($template['DATE_HEADER'], $timestamp);\r
+ }\r
+ $parser->parse($tmp_header);\r
+ $manager->notify('PostDateHead',array('blog' => &$this, 'timestamp' => $timestamp));\r
+ }\r
+ $old_date = $new_date;\r
+ }\r
+ \r
+ // parse item\r
+ $parser->parse($template['ITEM_HEADER']);\r
+ $manager->notify('PreItem', array('blog' => &$this, 'item' => &$item));\r
+ $parser->parse($template['ITEM']);\r
+ $manager->notify('PostItem', array('blog' => &$this, 'item' => &$item));\r
+ $parser->parse($template['ITEM_FOOTER']);\r
+ }\r
+ \r
+ $numrows = $items->rowCount();\r
+ \r
+ // add another date footer if there was at least one item\r
+ if ( ($numrows > 0) && $dateheads )\r
+ {\r
+ $manager->notify('PreDateFoot',array('blog' => &$this, 'timestamp' => strtotime($old_date)));\r
+ $parser->parse($template['DATE_FOOTER']);\r
+ $manager->notify('PostDateFoot',array('blog' => &$this, 'timestamp' => strtotime($old_date)));\r
+ }\r
+ \r
+ $items->closeCursor();\r
+ return $numrows;\r
+ }\r
+ \r
+ /**\r
+ * Blog::showOneitem()\r
+ * Simplified function for showing only one item\r
+ * \r
+ * @param integer $itemid ID for item\r
+ * @param array $template template for item\r
+ * @param string $highlight string for highlight\r
+ * @return integer 1\r
+ */\r
+ public function showOneitem($itemid, $template, $highlight)\r
+ {\r
+ $extraQuery = ' and inumber=' . intval($itemid);\r
+ \r
+ return $this->readLogAmount($template, 1, $extraQuery, $highlight, 0, 0);\r
+ }\r
+ \r
+ /**\r
+ * Blog::addItem()\r
+ * Adds an item to this blog\r
+ * \r
+ * @param integer $catid ID for category\r
+ * @param string $title ID for \r
+ * @param string $body text for body\r
+ * @param string $more text for more\r
+ * @param integer $blogid ID for blog\r
+ * @param integer $authorid ID for author\r
+ * @param timestamp $timestamp UNIX timestamp for post\r
+ * @param boolean $closed opened or closed\r
+ * @param boolean $draft draft or not\r
+ * @param boolean $posted posted or not\r
+ * @return integer ID for added item\r
+ */\r
+ function additem($catid, $title, $body, $more, $blogid, $authorid, $timestamp, $closed, $draft, $posted='1')\r
+ {\r
+ global $manager;\r
+ \r
+ $blogid = (integer) $blogid;\r
+ $authorid = (integer) $authorid;\r
+ $title = $title;\r
+ $body = $body;\r
+ $more = $more;\r
+ $catid = intval($catid);\r
+ \r
+ // convert newlines to <br />\r
+ if ( $this->convertBreaks() )\r
+ {\r
+ $body = addBreaks($body);\r
+ $more = addBreaks($more);\r
+ }\r
+\r
+ if ( $closed != '1' )\r
+ {\r
+ $closed = '0';\r
+ }\r
+ if ( $draft != '0' )\r
+ {\r
+ $draft = '1';\r
+ }\r
+ \r
+ if ( !$this->isValidCategory($catid) )\r
+ {\r
+ $catid = $this->getDefaultCategory();\r
+ }\r
+ \r
+ $isFuture = 0;\r
+ if ( $timestamp > $this->getCorrectTime() )\r
+ {\r
+ $isFuture = 1;\r
+ }\r
+ \r
+ $timestamp = date('Y-m-d H:i:s',$timestamp);\r
+ \r
+ $manager->notify('PreAddItem',array('title' => &$title, 'body' => &$body, 'more' => &$more, 'blog' => &$this, 'authorid' => &$authorid, 'timestamp' => &$timestamp, 'closed' => &$closed, 'draft' => &$draft, 'catid' => &$catid));\r
+ \r
+ $ititle = DB::quoteValue($title);\r
+ $ibody = DB::quoteValue($body);\r
+ $imore = DB::quoteValue($more);\r
+ $timestamp = DB::formatDateTime(strtotime($timestamp));\r
+ \r
+ $query = "INSERT INTO %s (ITITLE, IBODY, IMORE, IBLOG, IAUTHOR, ITIME, ICLOSED, IDRAFT, ICAT, IPOSTED) VALUES (%s, %s, %s, %d, %d, %s, %s, %s, %s, %s)";\r
+ $query = sprintf($query, sql_table('item'), $ititle, $ibody, $imore, $blogid, $authorid, $timestamp, $closed, $draft, $catid, $posted);\r
+ DB::execute($query);\r
+ $itemid = DB::getInsertId();\r
+ \r
+ $manager->notify('PostAddItem',array('itemid' => $itemid));\r
+ \r
+ if ( !$draft )\r
+ {\r
+ $this->updateUpdateFile();\r
+ }\r
+ // send notification mail\r
+ if ( !$draft && !$isFuture && $this->getNotifyAddress() && $this->notifyOnNewItem() )\r
+ {\r
+ $this->sendNewItemNotification($itemid, $title, $body);\r
+ }\r
+ return $itemid;\r
+ }\r
+ \r
+ /**\r
+ * Blog::sendNewItemNotification()\r
+ * Send a new item notification to the notification list\r
+ * \r
+ * @param string $itemid ID of the item\r
+ * @param string $title title of the item\r
+ * @param string $body body of the item\r
+ * @return void\r
+ */\r
+ public function sendNewItemNotification($itemid, $title, $body)\r
+ {\r
+ global $CONF, $member;\r
+ \r
+ $ascii = Entity::anchor_footnoting($body);\r
+ \r
+ $message = _NOTIFY_NI_MSG . " \n";\r
+ $temp = parse_url($CONF['Self']);\r
+ if ( $temp['scheme'] )\r
+ {\r
+ $message .= Link::create_item_link($itemid) . "\n\n";\r
+ }\r
+ else\r
+ {\r
+ $tempurl = $this->getURL();\r
+ if ( i18n::substr($tempurl, -1) == '/' || i18n::substr($tempurl, -4) == '.php' )\r
+ {\r
+ $message .= $tempurl . '?itemid=' . $itemid . "\n\n";\r
+ }\r
+ else\r
+ {\r
+ $message .= $tempurl . '/?itemid=' . $itemid . "\n\n";\r
+ }\r
+ }\r
+ $message .= _NOTIFY_TITLE . ' ' . strip_tags($title) . "\n";\r
+ $message .= _NOTIFY_CONTENTS . "\n " . $ascii . "\n";\r
+ $message .= NOTIFICATION::get_mail_footer();\r
+ \r
+ $subject = $this->getName() . ': ' . _NOTIFY_NI_TITLE;\r
+ \r
+ $from = $member->getNotifyFromMailAddress();\r
+ \r
+ NOTIFICATION::mail($this->getNotifyAddress(), $subject, $message, $from, i18n::get_current_charset());\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::createNewCategory()\r
+ * Creates a new category for this blog\r
+ *\r
+ * @param string $catName name of the new category. When empty, a name is generated automatically (starting with newcat)\r
+ * @param string $catDescription description of the new category. Defaults to 'New Category'\r
+ * @return integer ID for new category on success. 0 on failure\r
+ */\r
+ public function createNewCategory($catName = '', $catDescription = _CREATED_NEW_CATEGORY_DESC)\r
+ {\r
+ global $member, $manager;\r
+ \r
+ if ( !$member->blogAdminRights($this->blogid) )\r
+ {\r
+ return 0;\r
+ }\r
+ \r
+ // generate\r
+ if ( $catName == '' )\r
+ {\r
+ $catName = _CREATED_NEW_CATEGORY_NAME;\r
+ $i = 1;\r
+ \r
+ $res = DB::getResult('SELECT * FROM '.sql_table('category')." WHERE cname='".$catName.$i."' and cblog=".$this->blogid);\r
+ while ( $res->rowCount() > 0 )\r
+ {\r
+ $i++;\r
+ $res = DB::getResult('SELECT * FROM '.sql_table('category')." WHERE cname='".$catName.$i."' and cblog=".$this->blogid);\r
+ }\r
+ \r
+ $catName = $catName . $i;\r
+ }\r
+ \r
+ $data = array(\r
+ 'blog' => &$this,\r
+ 'name' => &$catName,\r
+ 'description' => $catDescription\r
+ );\r
+ $manager->notify('PreAddCategory', $data);\r
+ \r
+ $query = "INSERT INTO %s (cblog, cname, cdesc) VALUES (%d, %s, %s)";\r
+ $query = sprintf($query, sql_table('category'), (integer) $this->blogid, DB::quoteValue($catName), DB::quoteValue($catDescription));\r
+ DB::execute($query);\r
+ $catid = DB::getInsertId();\r
+ \r
+ $data = array(\r
+ 'blog' => &$this,\r
+ 'name' => $catName,\r
+ 'description' => $catDescription,\r
+ 'catid' => $catid\r
+ );\r
+ $manager->notify('PostAddCategory', $data);\r
+ \r
+ return $catid;\r
+ }\r
+ \r
+ /**\r
+ * Blog::search()\r
+ * Searches all months of this blog for the given query\r
+ *\r
+ * @param string $query search query\r
+ * @param array $template template to be used (__NAME__ of the template)\r
+ * @param integer $amountMonths max amount of months to be search (0 = all)\r
+ * @param integer $maxresults max number of results to show\r
+ * @param integer $startpos offset\r
+ * @return amount of hits found\r
+ */\r
+ public function search($query, $template, $amountMonths, $maxresults, $startpos) {\r
+ global $CONF, $manager;\r
+ \r
+ $highlight = '';\r
+ $sqlquery = $this->getSqlSearch($query, $amountMonths, $highlight);\r
+ \r
+ if ( $sqlquery == '' )\r
+ {\r
+ // no query -> show everything\r
+ $extraquery = '';\r
+ $amountfound = $this->readLogAmount($template, $maxresults, $extraQuery, $query, 1, 1);\r
+ }\r
+ else\r
+ {\r
+ // add LIMIT to query (to split search results into pages)\r
+ if ( intval($maxresults > 0) )\r
+ {\r
+ $sqlquery .= ' LIMIT ' . intval($startpos) . ',' . intval($maxresults);\r
+ }\r
+ \r
+ // show results\r
+ $amountfound = $this->showUsingQuery($template, $sqlquery, $highlight, 1, 1);\r
+ \r
+ // when no results were found, show a message\r
+ if ( $amountfound == 0 )\r
+ {\r
+ $template =& $manager->getTemplate($template);\r
+ $vars = array(\r
+ 'query' => Entity::hsc($query),\r
+ 'blogid' => $this->blogid\r
+ );\r
+ echo Template::fill($template['SEARCH_NOTHINGFOUND'], $vars);\r
+ }\r
+ }\r
+ return $amountfound;\r
+ }\r
+ \r
+ /**\r
+ * Blog::getSqlSearch()\r
+ * Returns an SQL query to use for a search query\r
+ * No LIMIT clause is added. (caller should add this if multiple pages are requested)\r
+ *\r
+ * @param string $query search query\r
+ * @param integer $amountMonths amount of months to search back. Default = 0 = unlimited\r
+ * @param string $mode either empty, or 'count'. In this case, the query will be a SELECT COUNT(*) query\r
+ * @return string $highlight words to highlight (out parameter)\r
+ * @return string either a full SQL query, or an empty string (if querystring empty)\r
+ */\r
+ public function getSqlSearch($query, $amountMonths = 0, &$highlight, $mode = '')\r
+ {\r
+ $searchclass = new Search($query);\r
+ \r
+ $highlight = $searchclass->inclusive;\r
+ \r
+ // if querystring is empty, return empty string\r
+ if ( $searchclass->inclusive == '' )\r
+ {\r
+ return '';\r
+ }\r
+ \r
+ $where = $searchclass->boolean_sql_where('ititle,ibody,imore');\r
+ $select = $searchclass->boolean_sql_select('ititle,ibody,imore');\r
+ \r
+ // get list of blogs to search\r
+ $blogs = $searchclass->blogs; // array containing blogs that always need to be included\r
+ $blogs[] = $this->blogid; // also search current blog (duh)\r
+ $blogs = array_unique($blogs); // remove duplicates\r
+ $selectblogs = '';\r
+ if ( count($blogs) > 0 )\r
+ {\r
+ $selectblogs = ' and i.iblog in (' . implode(',', $blogs) . ')';\r
+ }\r
+ \r
+ if ( $mode == '' )\r
+ {\r
+ $query = 'SELECT i.inumber as itemid, i.ititle as title, i.ibody as body, i.itime, i.imore as more, i.icat as catid, i.iclosed as closed,\r
+ m.mname as author, m.mrealname as authorname, m.mnumber as authorid, m.memail as authormail, m.murl as authorurl,\r
+ c.cname as category';\r
+ \r
+ if ( $select )\r
+ {\r
+ $query .= ', '.$select. ' as score ';\r
+ }\r
+ }\r
+ else\r
+ {\r
+ $query = 'SELECT COUNT(*) as result ';\r
+ }\r
+ \r
+ $query .= ' FROM '.sql_table('item').' as i, '.sql_table('member').' as m, '.sql_table('category').' as c'\r
+ . ' WHERE i.iauthor=m.mnumber'\r
+ . ' and i.icat=c.catid'\r
+ // exclude drafts\r
+ . ' and i.idraft=0'\r
+ . $selectblogs\r
+ // don't show future items\r
+ . ' and i.itime<=' . DB::formatDateTime($this->getCorrectTime())\r
+ . ' and '.$where;\r
+ \r
+ // take into account amount of months to search\r
+ if ( $amountMonths > 0 )\r
+ {\r
+ $localtime = getdate($this->getCorrectTime());\r
+ $timestamp_start = mktime(0,0,0,$localtime['mon'] - $amountMonths,1,$localtime['year']);\r
+ $query .= ' and i.itime>' . DB::formatDateTime($timestamp_start);\r
+ }\r
+ \r
+ if ( $mode == '' )\r
+ {\r
+ if ( $select )\r
+ {\r
+ $query .= ' ORDER BY score DESC';\r
+ }\r
+ else\r
+ {\r
+ $query .= ' ORDER BY i.itime DESC ';\r
+ }\r
+ }\r
+ \r
+ return $query;\r
+ }\r
+ \r
+ /**\r
+ * Blog::getSqlBlog()\r
+ * Returns the SQL query that's normally used to display the blog items on the index type skins\r
+ * No LIMIT clause is added. (caller should add this if multiple pages are requested)\r
+ *\r
+ * @param string $extraQuery extra query string\r
+ * @param string $mode either empty, or 'count'. In this case, the query will be a SELECT COUNT(*) query\r
+ * @return string either a full SQL query, or an empty string\r
+ */\r
+ public function getSqlBlog($extraQuery, $mode = '')\r
+ {\r
+ if ( $mode == '' )\r
+ {\r
+ $query = 'SELECT i.inumber as itemid, i.ititle as title, i.ibody as body, m.mname as author,\r
+ m.mrealname as authorname, i.itime, i.imore as more, m.mnumber as authorid, m.memail as authormail,\r
+ m.murl as authorurl, c.cname as category, i.icat as catid, i.iclosed as closed';\r
+ }\r
+ else\r
+ {\r
+ $query = 'SELECT COUNT(*) as result ';\r
+ }\r
+ \r
+ $query .= ' FROM '.sql_table('item').' as i, '.sql_table('member').' as m, '.sql_table('category').' as c'\r
+ . ' WHERE i.iblog='.$this->blogid\r
+ . ' and i.iauthor=m.mnumber'\r
+ . ' and i.icat=c.catid'\r
+ . ' and i.idraft=0' // exclude drafts\r
+ . ' and i.itime<=' . DB::formatDateTime($this->getCorrectTime()); // don't show future items\r
+ \r
+ if ( $this->selectedcatid )\r
+ {\r
+ $query .= ' and i.icat=' . $this->selectedcatid . ' ';\r
+ }\r
+ \r
+ $query .= $extraQuery;\r
+ \r
+ if ( $mode == '' )\r
+ {\r
+ $query .= ' ORDER BY i.itime DESC';\r
+ }\r
+ return $query;\r
+ }\r
+ \r
+ /**\r
+ * Blog::showArchiveList()\r
+ * Shows the archivelist using the given template\r
+ * \r
+ * @param string $template template name\r
+ * @param string $mode year/month/day\r
+ * @param integer $limit limit of record count\r
+ * @return void\r
+ */\r
+ public function showArchiveList($template, $mode = 'month', $limit = 0)\r
+ {\r
+ global $CONF, $catid, $manager;\r
+ \r
+ if ( !isset ($linkparams) )\r
+ {\r
+ $linkparams = array();\r
+ }\r
+ \r
+ if ( $catid )\r
+ {\r
+ $linkparams = array('catid' => $catid);\r
+ }\r
+ \r
+ $template =& $manager->getTemplate($template);\r
+ $data['blogid'] = $this->blogid;\r
+ \r
+ if ( !array_key_exists('ARCHIVELIST_HEADER', $template) || !$template['ARCHIVELIST_HEADER'] )\r
+ {\r
+ $tplt = '';\r
+ }\r
+ else\r
+ {\r
+ $tplt = $template['ARCHIVELIST_HEADER'];\r
+ }\r
+ \r
+ echo Template::fill($tplt, $data);\r
+ \r
+ $query = 'SELECT itime, SUBSTRING(itime,1,4) AS Year, SUBSTRING(itime,6,2) AS Month, SUBSTRING(itime,9,2) AS Day'\r
+ . ' FROM '.sql_table('item')\r
+ . ' WHERE iblog=' . $this->blogid\r
+ . ' AND itime <=' . DB::formatDateTime($this->getCorrectTime()) // don't show future items!\r
+ . ' AND idraft=0'; // don't show draft items\r
+ \r
+ if ( $catid )\r
+ {\r
+ $query .= ' and icat=' . intval($catid);\r
+ }\r
+ \r
+ $query .= ' GROUP BY Year';\r
+ if ( $mode == 'month' || $mode == 'day' )\r
+ {\r
+ $query .= ', Month';\r
+ }\r
+ if ( $mode == 'day' )\r
+ {\r
+ $query .= ', Day';\r
+ }\r
+ \r
+ $query .= ' ORDER BY itime DESC';\r
+ \r
+ if ( $limit > 0 )\r
+ {\r
+ $query .= ' LIMIT ' . intval($limit);\r
+ }\r
+ \r
+ $res = DB::getResult($query);\r
+ foreach ( $res as $current )\r
+ {\r
+ /* string time -> unix timestamp */\r
+ $current['itime'] = strtotime($current['itime']);\r
+ \r
+ if ( $mode == 'day' )\r
+ {\r
+ $archivedate = date('Y-m-d',$current['itime']);\r
+ $archive['day'] = date('d',$current['itime']);\r
+ $data['day'] = date('d',$current['itime']);\r
+ $data['month'] = date('m',$current['itime']);\r
+ $archive['month'] = $data['month'];\r
+ }\r
+ elseif ( $mode == 'year' )\r
+ {\r
+ $archivedate = date('Y',$current['itime']);\r
+ $data['day'] = '';\r
+ $data['month'] = '';\r
+ $archive['day'] = '';\r
+ $archive['month'] = '';\r
+ }\r
+ else\r
+ {\r
+ $archivedate = date('Y-m',$current['itime']);\r
+ $data['month'] = date('m',$current['itime']);\r
+ $archive['month'] = $data['month'];\r
+ $data['day'] = '';\r
+ $archive['day'] = '';\r
+ }\r
+ \r
+ $data['year'] = date('Y',$current['itime']);\r
+ $archive['year'] = $data['year'];\r
+ $data['archivelink'] = Link::create_archive_link($this->blogid,$archivedate,$linkparams);\r
+ \r
+ $manager->notify('PreArchiveListItem', array('listitem' => &$data));\r
+ \r
+ $temp = Template::fill($template['ARCHIVELIST_LISTITEM'],$data);\r
+ echo i18n::formatted_datetime($temp, $current['itime']);\r
+ return;\r
+ }\r
+ \r
+ $res->closeCursor();\r
+ \r
+ if ( !array_key_exists('ARCHIVELIST_FOOTER', $template) || !$template['ARCHIVELIST_FOOTER'] )\r
+ {\r
+ $tplt = '';\r
+ }\r
+ else\r
+ {\r
+ $tplt = $template['ARCHIVELIST_FOOTER'];\r
+ }\r
+ \r
+ echo Template::fill($tplt, $data);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::showCategoryList()\r
+ * Shows the list of categories using a given template\r
+ * \r
+ * @param string $template Template Name\r
+ * @return void\r
+ */\r
+ public function showCategoryList($template)\r
+ {\r
+ global $CONF, $archive, $archivelist, $manager;\r
+ \r
+ /*\r
+ * determine arguments next to catids\r
+ * I guess this can be done in a better way, but it works\r
+ */\r
+ $linkparams = array();\r
+ if ( $archive )\r
+ {\r
+ $blogurl = Link::create_archive_link($this->blogid, $archive, '');\r
+ $linkparams['blogid'] = $this->blogid;\r
+ $linkparams['archive'] = $archive;\r
+ }\r
+ else if ( $archivelist )\r
+ {\r
+ $blogurl = Link::create_archivelist_link($this->blogid, '');\r
+ $linkparams['archivelist'] = $archivelist;\r
+ }\r
+ else\r
+ {\r
+ $blogurl = Link::create_blogid_link($this->blogid, '');\r
+ $linkparams['blogid'] = $this->blogid;\r
+ }\r
+ \r
+ $template =& $manager->getTemplate($template);\r
+ \r
+ //: Change: Set nocatselected variable\r
+ if ( $this->selectedcatid )\r
+ {\r
+ $nocatselected = 'no';\r
+ }\r
+ else\r
+ {\r
+ $nocatselected = 'yes';\r
+ } \r
+ \r
+ $args = array(\r
+ 'blogid' => $this->blogid,\r
+ 'blogurl' => $blogurl,\r
+ 'self' => $CONF['Self'],\r
+ 'catiscurrent' => $nocatselected, // Change: Set catiscurrent template variable for header\r
+ 'currentcat' => $nocatselected \r
+ );\r
+ \r
+ /* output header of category list item */\r
+ if ( !array_key_exists('CATLIST_HEADER', $template) || empty($template['CATLIST_HEADER']) )\r
+ {\r
+ echo Template::fill(NULL, $args);\r
+ }\r
+ else\r
+ {\r
+ echo Template::fill($template['CATLIST_HEADER'], $args);\r
+ }\r
+ \r
+ $query = "SELECT catid, cdesc as catdesc, cname as catname FROM %s WHERE cblog=%d ORDER BY cname ASC;";\r
+ $query = sprintf($query, sql_table('category'), (integer) $this->blogid);\r
+ $res = DB::getResult($query);\r
+ \r
+ foreach ( $res as $data )\r
+ {\r
+ $args = array(\r
+ 'catid' => $data['catid'],\r
+ 'name' => $data['catname'],\r
+ 'extra' => $linkparams\r
+ );\r
+ \r
+ $data['blogid'] = $this->blogid;\r
+ $data['blogurl'] = $blogurl;\r
+ $data['catlink'] = Link::create_link('category', $args);\r
+ $data['self'] = $CONF['Self'];\r
+ \r
+ // this gives catiscurrent = no when no category is selected.\r
+ $data['catiscurrent'] = 'no';\r
+ $data['currentcat'] = 'no';\r
+ \r
+ if ( $this->selectedcatid )\r
+ {\r
+ if ( $this->selectedcatid == $data['catid'] )\r
+ {\r
+ $data['catiscurrent'] = 'yes';\r
+ $data['currentcat'] = 'yes';\r
+ }\r
+ }\r
+ else\r
+ {\r
+ global $itemid;\r
+ if ( intval($itemid) && $manager->existsItem(intval($itemid), 0, 0) )\r
+ {\r
+ $iobj =& $manager->getItem(intval($itemid), 0, 0);\r
+ $cid = $iobj['catid'];\r
+ \r
+ if ( $cid == $data['catid'] )\r
+ {\r
+ $data['catiscurrent'] = 'yes';\r
+ $data['currentcat'] = 'yes';\r
+ }\r
+ }\r
+ }\r
+ \r
+ $manager->notify('PreCategoryListItem', array('listitem' => &$data));\r
+ \r
+ if ( !array_key_exists('CATLIST_LISTITEM', $template) || empty($template['CATLIST_LISTITEM']))\r
+ {\r
+ echo Template::fill(NULL, $data);\r
+ }\r
+ else\r
+ {\r
+ echo Template::fill($template['CATLIST_LISTITEM'], $data);\r
+ }\r
+ }\r
+ \r
+ $res->closeCursor();\r
+ \r
+ $args = array(\r
+ 'blogid' => $this->blogid,\r
+ 'blogurl' => $blogurl,\r
+ 'self' => $CONF['Self'],\r
+ 'catiscurrent' => $nocatselected, //: Change: Set catiscurrent template variable for footer\r
+ 'currentcat' => $nocatselected\r
+ );\r
+ \r
+ if ( !array_key_exists('CATLIST_FOOTER', $template) || empty($template['CATLIST_FOOTER']))\r
+ {\r
+ echo Template::fill(NULL, $args);\r
+ }\r
+ else\r
+ {\r
+ echo Template::fill($template['CATLIST_FOOTER'], $args);\r
+ }\r
+ \r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::showBlogList()\r
+ * Shows a list of all blogs in the system using a given template\r
+ * ordered by number, name, shortname or description\r
+ * in ascending or descending order\r
+ * \r
+ * @param string $template tempalte name\r
+ * @param string $bnametype bname/bshortname\r
+ * @param string $orderby string for 'ORDER BY' SQL\r
+ * @param string $direction ASC/DESC\r
+ * @return void\r
+ */\r
+ public function showBlogList($template, $bnametype, $orderby, $direction)\r
+ {\r
+ global $CONF, $manager;\r
+ \r
+ switch ( $orderby )\r
+ {\r
+ case 'number':\r
+ $orderby='bnumber';\r
+ break;\r
+ case 'name':\r
+ $orderby='bname';\r
+ break;\r
+ case 'shortname':\r
+ $orderby='bshortname';\r
+ break;\r
+ case 'description':\r
+ $orderby='bdesc';\r
+ break;\r
+ default:\r
+ $orderby='bnumber';\r
+ break;\r
+ }\r
+ \r
+ $direction=strtolower($direction);\r
+ switch ( $direction )\r
+ {\r
+ case 'asc':\r
+ $direction='ASC';\r
+ break;\r
+ case 'desc':\r
+ $direction='DESC';\r
+ break;\r
+ default:\r
+ $direction='ASC';\r
+ break;\r
+ }\r
+ \r
+ $template =& $manager->getTemplate($template);\r
+ \r
+ if ( array_key_exists('BLOGLIST_HEADER', $template) && !empty($template['BLOGLIST_HEADER']) )\r
+ {\r
+ $vars = array(\r
+ 'sitename' => $CONF['SiteName'],\r
+ 'siteurl' => $CONF['IndexURL']\r
+ );\r
+ \r
+ echo Template::fill($template['BLOGLIST_HEADER'], $vars);\r
+ }\r
+ \r
+ if ( array_key_exists('BLOGLIST_LISTITEM', $template) && !empty($template['BLOGLIST_LISTITEM']) )\r
+ {\r
+ $query = 'SELECT bnumber, bname, bshortname, bdesc, burl FROM '.sql_table('blog').' ORDER BY '.$orderby.' '.$direction;\r
+ $res = DB::getResult($query);\r
+ \r
+ foreach ( $res as $data )\r
+ {\r
+ $list = array();\r
+ $list['bloglink'] = Link::create_blogid_link($data['bnumber']);\r
+ $list['blogdesc'] = $data['bdesc'];\r
+ $list['blogurl'] = $data['burl'];\r
+ \r
+ if ( $bnametype == 'shortname' )\r
+ {\r
+ $list['blogname'] = $data['bshortname'];\r
+ }\r
+ else\r
+ {\r
+ /* all other cases */\r
+ $list['blogname'] = $data['bname'];\r
+ }\r
+ \r
+ $manager->notify('PreBlogListItem',array('listitem' => &$list));\r
+ \r
+ echo Template::fill($template['BLOGLIST_LISTITEM'], $list);\r
+ }\r
+ \r
+ $res->closeCursor();\r
+ }\r
+ \r
+ \r
+ if ( array_key_exists('BLOGLIST_FOOTER', $template) && !empty($template['BLOGLIST_FOOTER']) )\r
+ {\r
+ $vars = array(\r
+ 'sitename' => $CONF['SiteName'],\r
+ 'siteurl' => $CONF['IndexURL']\r
+ );\r
+ echo Template::fill($template['BLOGLIST_FOOTER']);\r
+ }\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::readSettings()\r
+ * Read the blog settings\r
+ * \r
+ * @param void\r
+ * @return void\r
+ */\r
+ public function readSettings()\r
+ {\r
+ $query = 'SELECT * FROM %s WHERE bnumber=%d;';\r
+ $query = sprintf($query, sql_table('blog'), (integer) $this->blogid);\r
+ $res = DB::getResult($query);\r
+ \r
+ $this->isValid = ($res->rowCount() > 0);\r
+ if ( $this->isValid )\r
+ {\r
+ $this->settings = $res->fetch(PDO::FETCH_ASSOC);\r
+ }\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::writeSettings()\r
+ * Write the blog settings\r
+ */\r
+ public function writeSettings()\r
+ {\r
+ // (can't use floatval since not available prior to PHP 4.2)\r
+ $offset = $this->getTimeOffset();\r
+ if ( !is_float($offset) )\r
+ {\r
+ $offset = (integer) $offset;\r
+ }\r
+ \r
+ $query = 'UPDATE '.sql_table('blog')\r
+ . ' SET bname=' . DB::quoteValue($this->getName()) . ','\r
+ . ' bshortname='. DB::quoteValue($this->getShortName()) . ','\r
+ . ' bcomments='. intval($this->commentsEnabled()) . ','\r
+ . ' bmaxcomments=' . intval($this->getMaxComments()) . ','\r
+ . ' btimeoffset=' . $offset . ','\r
+ . ' bpublic=' . intval($this->isPublic()) . ','\r
+ . ' breqemail=' . intval($this->emailRequired()) . ','\r
+ . ' bconvertbreaks=' . intval($this->convertBreaks()) . ','\r
+ . ' ballowpast=' . intval($this->allowPastPosting()) . ','\r
+ . ' bnotify=' . DB::quoteValue($this->getNotifyAddress()) . ','\r
+ . ' bnotifytype=' . intval($this->getNotifyType()) . ','\r
+ . ' burl=' . DB::quoteValue($this->getURL()) . ','\r
+ . ' bupdate=' . DB::quoteValue($this->getUpdateFile()) . ','\r
+ . ' bdesc=' . DB::quoteValue($this->getDescription()) . ','\r
+ . ' bdefcat=' . intval($this->getDefaultCategory()) . ','\r
+ . ' bdefskin=' . intval($this->getDefaultSkin()) . ','\r
+ . ' bincludesearch=' . intval($this->getSearchable())\r
+ . ' WHERE bnumber=' . intval($this->blogid);\r
+ DB::execute($query);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::updateUpdatefile()\r
+ * Update the update file if requested\r
+ * \r
+ * @param void\r
+ * @return void\r
+ */\r
+ public function updateUpdatefile()\r
+ {\r
+ if ( $this->getUpdateFile() )\r
+ {\r
+ $f_update = fopen($this->getUpdateFile(), 'w');\r
+ fputs($f_update,$this->getCorrectTime());\r
+ fclose($f_update);\r
+ }\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::isValidCategory()\r
+ * Check if a category with a given catid is valid\r
+ * \r
+ * @param integer $catid ID for category\r
+ * @return boolean exists or not\r
+ */\r
+ public function isValidCategory($catid)\r
+ {\r
+ $query = 'SELECT * FROM %s WHERE cblog=%d and catid=%d;';\r
+ $query = sprintf($query, sql_table('category'), (integer) $this->blogid, (integer) $catid);\r
+ $res = DB::getResult($query);\r
+ return ($res->rowCount() != 0);\r
+ }\r
+ \r
+ /**\r
+ * Blog::getCategoryName()\r
+ * Get the category name for a given catid\r
+ * \r
+ * @param integer $catid ID for category\r
+ * @return string name of category\r
+ */\r
+ public function getCategoryName($catid)\r
+ {\r
+ $query = 'SELECT cname FROM %s WHERE cblog=%d and catid=%d;';\r
+ $query = sprintf($query, sql_table('category'), (integer) $this->blogid, (integer) $catid);\r
+ $res = DB::getValue($query);\r
+ return $res;\r
+ }\r
+ \r
+ /**\r
+ * Blog::getCategoryDesc()\r
+ * Get the category description for a given catid\r
+ * \r
+ * @param $catid\r
+ * category id\r
+ */\r
+ public function getCategoryDesc($catid)\r
+ {\r
+ $query = 'SELECT cdesc FROM %s WHERE cblog=%d and catid=%d;';\r
+ $query = sprintf($querym, sql_table('category'), (integer) $this->blogid, (integer) $catid);\r
+ $res = DB::getValue();\r
+ return $res;\r
+ }\r
+ \r
+ /**\r
+ * Blog::getCategoryIdFromName\r
+ * Get the category id for a given category name\r
+ * \r
+ * @param string $name category name\r
+ * @return ID for category\r
+ */\r
+ public function getCategoryIdFromName($name)\r
+ {\r
+ $query = 'SELECT catid FROM %s WHERE cblog=%d and cname=%s;';\r
+ $query = sprintf($query, sql_table('category'), (integer) $this->blogid, DB::quoteValue($name));\r
+ \r
+ $res = DB::getValue();\r
+ if ( !$res )\r
+ {\r
+ return $this->getDefaultCategory();\r
+ }\r
+ return $res;\r
+ }\r
+ \r
+ /**\r
+ * Blog::insertJavaScriptInfo()\r
+ * Insert a javascript that includes information about the settings\r
+ * of an author: ConvertBreaks, MediaUrl and AuthorId\r
+ * \r
+ * @param $authorid id of the author\r
+ */\r
+ public function insertJavaScriptInfo($authorid = '')\r
+ {\r
+ global $member, $CONF;\r
+ \r
+ if ( $authorid == '' )\r
+ {\r
+ $authorid = $member->getID();\r
+ }\r
+ \r
+ echo "<script type=\"text/javascript\">\n";\r
+ \r
+ if ( !$this->convertBreaks() )\r
+ {\r
+ echo "setConvertBreaks(false);\n";\r
+ }\r
+ else\r
+ {\r
+ echo "setConvertBreaks(true);\n";\r
+ }\r
+ echo "setMediaUrl('{$CONF['MediaURL']}');\n";\r
+ echo "setAuthorId('{$authorid}');\n";\r
+ echo "</script>\n";\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::setAllowPastPosting()\r
+ * Set the the setting for allowing to publish postings in the past\r
+ * \r
+ * @param boolean $val new value for ballowpast\r
+ * @return void\r
+ */\r
+ public function setAllowPastPosting($val)\r
+ {\r
+ $this->setSetting('ballowpast', $val);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::allowPastPosting()\r
+ * Get the the setting if it is allowed to publish postings in the past\r
+ * [should be named as getAllowPastPosting()]\r
+ * \r
+ * @param void\r
+ * @return boolean\r
+ */\r
+ public function allowPastPosting()\r
+ {\r
+ return $this->getSetting('ballowpast');\r
+ }\r
+ \r
+ /**\r
+ * Blog::getCorrectTime()\r
+ * \r
+ * @param integer $t\r
+ * @return integer\r
+ */\r
+ public function getCorrectTime($t=0)\r
+ {\r
+ if ( $t == 0 )\r
+ {\r
+ $t = time();\r
+ }\r
+ return ($t + 3600 * $this->getTimeOffset());\r
+ }\r
+ \r
+ /**\r
+ * Blog::getName()\r
+ * \r
+ * @param void\r
+ * @return string name of this weblog\r
+ */\r
+ public function getName()\r
+ {\r
+ return $this->getSetting('bname');\r
+ }\r
+ \r
+ /**\r
+ * Blog::getShortName()\r
+ * \r
+ * @param void\r
+ * @return string short name of this weblog\r
+ */\r
+ public function getShortName()\r
+ {\r
+ return $this->getSetting('bshortname');\r
+ }\r
+ \r
+ /**\r
+ * Blog::getMaxComments()\r
+ * \r
+ * @param void\r
+ * @return integer maximum number of comments\r
+ */\r
+ public function getMaxComments()\r
+ {\r
+ return $this->getSetting('bmaxcomments');\r
+ }\r
+ \r
+ /**\r
+ * Blog::getNotifyAddress()\r
+ * \r
+ * @param void\r
+ * @return string mail address for notifying\r
+ */\r
+ public function getNotifyAddress()\r
+ {\r
+ return $this->getSetting('bnotify');\r
+ }\r
+ \r
+ /**\r
+ * Blog::getNotifyType()\r
+ * \r
+ * @param void\r
+ * @return integer notifycation type\r
+ */\r
+ public function getNotifyType()\r
+ {\r
+ return $this->getSetting('bnotifytype');\r
+ }\r
+ \r
+ /**\r
+ * Blog::notifyOnComment()\r
+ * \r
+ * @param void\r
+ * @return boolean\r
+ */\r
+ public function notifyOnComment()\r
+ {\r
+ $n = $this->getNotifyType();\r
+ return (($n != 0) && (($n % 3) == 0));\r
+ }\r
+ \r
+ /**\r
+ * Blog::notifyOnVote()\r
+ * \r
+ * @param void\r
+ * @return boolean\r
+ */\r
+ public function notifyOnVote()\r
+ {\r
+ $n = $this->getNotifyType();\r
+ return (($n != 0) && (($n % 5) == 0));\r
+ }\r
+ \r
+ /**\r
+ * Blog::notifyOnNewItem()\r
+ * \r
+ * @param void\r
+ * @return boolean\r
+ */\r
+ public function notifyOnNewItem()\r
+ {\r
+ $n = $this->getNotifyType();\r
+ return (($n != 0) && (($n % 7) == 0));\r
+ }\r
+ \r
+ /**\r
+ * Blog::setNotifyType()\r
+ * \r
+ * @param integer $val\r
+ * @return void\r
+ */\r
+ public function setNotifyType($val)\r
+ {\r
+ $this->setSetting('bnotifytype',$val);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::getTimeOffset()\r
+ * @param void\r
+ * @return \r
+ */\r
+ public function getTimeOffset()\r
+ {\r
+ return $this->getSetting('btimeoffset');\r
+ }\r
+ \r
+ /**\r
+ * Blog::commentsEnabled()\r
+ * @param void\r
+ * @return integer enabled or not\r
+ */\r
+ public function commentsEnabled()\r
+ {\r
+ return $this->getSetting('bcomments');\r
+ }\r
+ \r
+ /**\r
+ * Blog::getURL()\r
+ * @param void\r
+ * @return string URI for this weblog\r
+ */\r
+ public function getURL()\r
+ {\r
+ return $this->getSetting('burl');\r
+ }\r
+ \r
+ /**\r
+ * Blog::getDefaultSkin()\r
+ * @param void\r
+ * @return name of skin as default for this weblog\r
+ */\r
+ public function getDefaultSkin()\r
+ {\r
+ return $this->getSetting('bdefskin');\r
+ }\r
+ \r
+ /**\r
+ * Blog::getUpdateFile()\r
+ * @param void\r
+ * @return string name of file to be updated when weblog is updated\r
+ */\r
+ public function getUpdateFile()\r
+ {\r
+ return $this->getSetting('bupdate');\r
+ }\r
+ \r
+ /**\r
+ * Blog::getDescription()\r
+ * @param void\r
+ * @return string description for this weblog\r
+ */\r
+ public function getDescription()\r
+ {\r
+ return $this->getSetting('bdesc');\r
+ }\r
+ \r
+ /**\r
+ * Blog::isPublic()\r
+ * @param void\r
+ * @return integer publlic or not\r
+ */\r
+ public function isPublic()\r
+ {\r
+ return $this->getSetting('bpublic');\r
+ }\r
+ \r
+ /**\r
+ * Blog::emailRequired()\r
+ * @param void\r
+ * @return integer email is required when posting comment or not\r
+ */\r
+ public function emailRequired()\r
+ {\r
+ return $this->getSetting('breqemail');\r
+ }\r
+ \r
+ /**\r
+ * Blog::getSearchable()\r
+ * @param void\r
+ * @return integer searchable or not\r
+ */\r
+ public function getSearchable()\r
+ {\r
+ return $this->getSetting('bincludesearch');\r
+ }\r
+ \r
+ /**\r
+ * Blog::getDefaultCategory()\r
+ * @param void\r
+ * @return ID for category as a default\r
+ */\r
+ public function getDefaultCategory()\r
+ {\r
+ return $this->getSetting('bdefcat');\r
+ }\r
+ \r
+ /**\r
+ * Blog::setPublic()\r
+ * @param integer $val allow comments by non-registered members or not\r
+ * @return void\r
+ */\r
+ public function setPublic($val)\r
+ {\r
+ $this->setSetting('bpublic', $val);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::setSearchable()\r
+ * @param integer $val searchable from the other blogs or not\r
+ * @return void\r
+ */\r
+ public function setSearchable($val)\r
+ {\r
+ $this->setSetting('bincludesearch', $val);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::setDescription\r
+ * @param string $val description for this weblog\r
+ * @return void\r
+ */\r
+ public function setDescription($val)\r
+ {\r
+ $this->setSetting('bdesc',$val);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::setUpdateFile()\r
+ * @param string $val name of file to beupdated when weblog is updated\r
+ * @return \r
+ */\r
+ public function setUpdateFile($val)\r
+ {\r
+ $this->setSetting('bupdate',$val);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::setDefaultSkin()\r
+ * @param integer $val ID for default skin to use when displaying this weblog\r
+ * @return void\r
+ */\r
+ public function setDefaultSkin($val)\r
+ {\r
+ $this->setSetting('bdefskin', $val);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::setURL()\r
+ * @param string $val URI for this weblog\r
+ * @return \r
+ */\r
+ public function setURL($val)\r
+ {\r
+ $this->setSetting('burl', $val);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::setName()\r
+ * @param string $val name of this weblog\r
+ * @return void\r
+ */\r
+ public function setName($val)\r
+ {\r
+ $this->setSetting('bname', $val);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::setShortName()\r
+ * @param string $val short name for this weblog\r
+ * @return void\r
+ */\r
+ public function setShortName($val)\r
+ {\r
+ $this->setSetting('bshortname', $val);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::setCommentsEnabled()\r
+ * @param integer $val enabling posting comment or not\r
+ * @return void\r
+ */\r
+ public function setCommentsEnabled($val)\r
+ {\r
+ $this->setSetting('bcomments',$val);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::setMaxComments()\r
+ * @param integer $val maximum number of comments for this weblog\r
+ * @return void\r
+ */\r
+ public function setMaxComments($val)\r
+ {\r
+ $this->setSetting('bmaxcomments', $val);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::setNotifyAddress()\r
+ * @param string $val email to be notified if weblog updated\r
+ * @return void\r
+ */\r
+ public function setNotifyAddress($val)\r
+ {\r
+ $this->setSetting('bnotify', $val);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::setEmailRequired()\r
+ * @param string requiring comments with email or not from non member\r
+ * @return void\r
+ */\r
+ public function setEmailRequired($val)\r
+ {\r
+ $this->setSetting('breqemail', $val);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::setTimeOffset()\r
+ * @param integer $val time offset\r
+ * @return void\r
+ */\r
+ public function setTimeOffset($val)\r
+ {\r
+ // check validity of value\r
+ // 1. replace , by . (common mistake)\r
+ $val = str_replace(',','.',$val);\r
+ \r
+ // 2. cast to float or int\r
+ if ( is_numeric($val) && (i18n::strpos($val, '.5') === (i18n::strlen($val) - 2)) )\r
+ {\r
+ $val = (float) $val;\r
+ }\r
+ else\r
+ {\r
+ $val = (integer) $val;\r
+ }\r
+ \r
+ $this->setSetting('btimeoffset',$val);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::setDefaultCategory()\r
+ * @param integer $val ID for default category for this weblog\r
+ * @return \r
+ */\r
+ public function setDefaultCategory($val)\r
+ {\r
+ $this->setSetting('bdefcat',$val);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::getSetting()\r
+ * @param string $key key for setting of this weblog\r
+ * @return mixed value for the setting\r
+ */\r
+ public function getSetting($key)\r
+ {\r
+ return $this->settings[$key];\r
+ }\r
+ \r
+ /**\r
+ * Blog::setSetting()\r
+ * @param string $key key for setting of this weblog\r
+ * @param mixed $value value for the key\r
+ * @return \r
+ */\r
+ public function setSetting($key, $value)\r
+ {\r
+ $this->settings[$key] = $value;\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::addTeamMember()\r
+ * Tries to add a member to the team. \r
+ * Returns false if the member was already on the team\r
+ * \r
+ * @param integer $memberid id for member\r
+ * @param boolean $admin super-admin or not\r
+ * @return boolean Success/Fail\r
+ */\r
+ public function addTeamMember($memberid, $admin)\r
+ {\r
+ global $manager;\r
+ \r
+ $memberid = intval($memberid);\r
+ $admin = intval($admin);\r
+ \r
+ // check if member is already a member\r
+ $tmem =& $manager->getMember($memberid);\r
+ \r
+ if ( $tmem->isTeamMember($this->blogid) )\r
+ {\r
+ return 0;\r
+ }\r
+ \r
+ $data = array(\r
+ 'blog' => &$this,\r
+ 'member' => &$tmem,\r
+ 'admin' => &$admin\r
+ );\r
+ $manager->notify('PreAddTeamMember', $data);\r
+ \r
+ // add to team\r
+ $query = "INSERT INTO %s (TMEMBER, TBLOG, TADMIN) VALUES (%d, %d, %d);";\r
+ $query = sprintf($query, sql_table('team'), (integer) $memberid, (integer) $this->blogid, (integer) $admin);\r
+ DB::execute($query);\r
+ \r
+ $data = array(\r
+ 'blog' => &$this,\r
+ 'member' => &$tmem,\r
+ 'admin' => $admin\r
+ );\r
+ $manager->notify('PostAddTeamMember', $data);\r
+ \r
+ $logMsg = sprintf(_TEAM_ADD_NEWTEAMMEMBER, $tmem->getDisplayName(), $memberid, $this->getName());\r
+ ActionLog::add(INFO, $logMsg);\r
+ \r
+ return 1;\r
+ }\r
+ \r
+ /**\r
+ * Blog::getID()\r
+ * @param void\r
+ * @return integer ID for this weblog\r
+ */\r
+ public function getID()\r
+ {\r
+ return (integer) $this->blogid;\r
+ }\r
+ \r
+ /**\r
+ * Checks if a blog with a given shortname exists \r
+ * Returns true if there is a blog with the given shortname (static)\r
+ * \r
+ * @param string $name blog shortname\r
+ * @return boolean exists or not\r
+ */\r
+ public function exists($name)\r
+ {\r
+ $r = DB::getResult('SELECT * FROM '.sql_table('blog').' WHERE bshortname='. DB::quoteValue($name));\r
+ return ($r->rowCount() != 0);\r
+ }\r
+ \r
+ /**\r
+ * Checks if a blog with a given id exists \r
+ * Returns true if there is a blog with the given ID (static)\r
+ * \r
+ * @param integer $id ID for searched weblog\r
+ * @return boolean exists or not\r
+ */\r
+ public function existsID($id)\r
+ {\r
+ $r = DB::getResult('SELECT * FROM '.sql_table('blog').' WHERE bnumber='.intval($id));\r
+ return ($r->rowCount() != 0);\r
+ }\r
+ \r
+ /**\r
+ * Blog::setFuturePost()\r
+ * flag there is a future post pending\r
+ * \r
+ * @param void\r
+ * @return void\r
+ */\r
+ public function setFuturePost()\r
+ {\r
+ $query = "UPDATE %s SET bfuturepost='1' WHERE bnumber=%d;";\r
+ $query = sprintf($query, sql_table('blog'), (integer) $this->blogid);\r
+ DB::execute($query);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::clearFuturePost()\r
+ * clear there is a future post pending\r
+ * \r
+ * @param void\r
+ * @return void\r
+ */\r
+ public function clearFuturePost()\r
+ {\r
+ $query = "UPDATE %s SET bfuturepost='0' WHERE bnumber=%d;";\r
+ $query = sprintf($query, sql_table('blog'), (integer) $this->blogid);\r
+ DB::execute($query);\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::checkJustPosted()\r
+ * check if we should throw justPosted event \r
+ * \r
+ * @param void\r
+ * @return void\r
+ */\r
+ public function checkJustPosted()\r
+ {\r
+ global $manager;\r
+ \r
+ if ( $this->settings['bfuturepost'] == 1 )\r
+ {\r
+ $query = "SELECT * FROM %s WHERE iposted=0 AND iblog=%d AND itime < NOW();";\r
+ $query = sprintf($query, sql_table('item'), (integer) $this->blogid);\r
+ \r
+ $result = DB::getResult($query);\r
+ if ( $result->rowCount() > 0 )\r
+ {\r
+ // This $pinged is allow a plugin to tell other hook to the event that a ping is sent already\r
+ // Note that the plugins's calling order is subject to thri order in the plugin list\r
+ $pinged = FALSE;\r
+ $manager->notify('JustPosted', array('blogid' => $this->blogid, 'pinged' => &$pinged));\r
+ \r
+ // clear all expired future posts\r
+ $query = "UPDATE %s SET iposted='1' WHERE iblog=%d AND itime < NOW();";\r
+ $query = spriintf($query, sql_table('item'), (integer) $this->blogid);\r
+ DB::execute($query);\r
+ \r
+ // check to see any pending future post, clear the flag is none\r
+ $query = "SELECT * FROM %s WHERE iposted=0 AND iblog=%d;";\r
+ $query = sprintf($query, sql_table('item'), (integer) $this->blogid);\r
+ \r
+ $result = DB::getResult($query);\r
+ if ( $result->rowCount() == 0 )\r
+ {\r
+ $this->clearFuturePost();\r
+ }\r
+ }\r
+ }\r
+ return;\r
+ }\r
+ \r
+ /**\r
+ * Blog::readLogFromList()\r
+ * Shows the given list of items for this blog\r
+ *\r
+ * @param array $itemarray array of item numbers to be displayed\r
+ * @param string $template string representing the template _NAME_ (!)\r
+ * @param string $highlight contains a query that should be highlighted\r
+ * @param boolean $comments 1=show comments 0=don't show comments\r
+ * @param boolean $dateheads 1=show dateheads 0=don't show dateheads\r
+ * @param boolean $showDrafts 0=do not show drafts 1=show drafts\r
+ * @param boolean $showFuture 0=do not show future posts 1=show future posts\r
+ * @return integer amount of items shown\r
+ */\r
+ public function readLogFromList($itemarray, $template, $highlight = '', $comments = 1, $dateheads = 1,$showDrafts = 0, $showFuture = 0)\r
+ {\r
+ $query = $this->getSqlItemList($itemarray,$showDrafts,$showFuture);\r
+ return $this->showUsingQuery($template, $query, $highlight, $comments, $dateheads);\r
+ }\r
+ \r
+ /**\r
+ * Blog::getSqlItemList()\r
+ * Returns the SQL query used to fill out templates for a list of items\r
+ * No LIMIT clause is added. (caller should add this if multiple pages are requested)\r
+ *\r
+ * @param array $itemarray an array holding the item numbers of the items to be displayed\r
+ * @param integer $showDrafts 0=do not show drafts 1=show drafts\r
+ * @param integer $showFuture 0=do not show future posts 1=show future posts\r
+ * @return string either a full SQL query, or an empty string\r
+ */\r
+ public function getSqlItemList($itemarray,$showDrafts = 0,$showFuture = 0)\r
+ {\r
+ if ( !is_array($itemarray) )\r
+ {\r
+ return '';\r
+ }\r
+ \r
+ $showDrafts = intval($showDrafts);\r
+ $showFuture = intval($showFuture);\r
+ $items = array();\r
+ \r
+ foreach ( $itemarray as $value )\r
+ {\r
+ if ( intval($value) )\r
+ {\r
+ $items[] = intval($value);\r
+ }\r
+ }\r
+ if ( !count($items) )\r
+ {\r
+ return '';\r
+ }\r
+ \r
+ $i = count($items);\r
+ $query = '';\r
+ foreach ( $items as $value )\r
+ {\r
+ $query .= '('\r
+ . 'SELECT'\r
+ . ' i.inumber as itemid,'\r
+ . ' i.ititle as title,'\r
+ . ' i.ibody as body,'\r
+ . ' m.mname as author,'\r
+ . ' m.mrealname as authorname,'\r
+ . ' i.itime,'\r
+ . ' i.imore as more,'\r
+ . ' m.mnumber as authorid,'\r
+ . ' m.memail as authormail,'\r
+ . ' m.murl as authorurl,'\r
+ . ' c.cname as category,'\r
+ . ' i.icat as catid,'\r
+ . ' i.iclosed as closed';\r
+ \r
+ $query .= ' FROM '\r
+ . sql_table('item') . ' as i, '\r
+ . sql_table('member') . ' as m, '\r
+ . sql_table('category') . ' as c'\r
+ . ' WHERE'\r
+ . ' i.iblog='.$this->blogid\r
+ . ' and i.iauthor=m.mnumber'\r
+ . ' and i.icat=c.catid';\r
+ \r
+ // exclude drafts \r
+ if ( !$showDrafts )\r
+ {\r
+ $query .= ' and i.idraft=0';\r
+ }\r
+ if ( !$showFuture )\r
+ {\r
+ // don't show future items\r
+ $query .= ' and i.itime<=' . DB::formatDateTime($this->getCorrectTime());\r
+ }\r
+ \r
+ $query .= ' and i.inumber='.intval($value);\r
+ $query .= ')';\r
+ $i--;\r
+ if ($i) $query .= ' UNION ';\r
+ }\r
+ \r
+ return $query;\r
+ }\r
+ \r
+ /**\r
+ * Blog::convertBreaks()\r
+ * Get the the setting for the line break handling\r
+ * [should be named as getConvertBreaks()]\r
+ * \r
+ * @deprecated\r
+ * @param void\r
+ * @return \r
+ */\r
+ public function convertBreaks()\r
+ {\r
+ return $this->getSetting('bconvertbreaks');\r
+ }\r
+ \r
+ /**\r
+ * Set the the setting for the line break handling\r
+ * \r
+ * @deprecated\r
+ * @param boolean $val new value for bconvertbreaks\r
+ * @return void\r
+ */\r
+ public function setConvertBreaks($val)\r
+ {\r
+ $this->setSetting('bconvertbreaks', $val);\r
+ return;\r
+ }\r
+}\r
+=======