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