blogid = intval($id);
$this->readSettings();
// try to set catid
// (the parse functions in SKIN.php will override this, so it's mainly useless)
global $catid;
$this->setSelectedCategory($catid);
}
/**
* Shows the given amount of items for this blog
*
* @param $template
* String representing the template _NAME_ (!)
* @param $amountEntries
* amount of entries to show
* @param $startpos
* offset from where items should be shown (e.g. 5 = start at fifth item)
* @returns int
* amount of items shown
*/
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
*
*/
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;
}
/**
* Sets the selected category by id (only when category exists)
*/
function setSelectedCategory($catid) {
if ($this->isValidCategory($catid) || (intval($catid) == 0))
$this->selectedcatid = intval($catid);
}
/**
* Sets the selected category by name
*/
function setSelectedCategoryByName($catname) {
$this->setSelectedCategory($this->getCategoryIdFromName($catname));
}
/**
* Returns the selected category
*/
function getSelectedCategory() {
return $this->selectedcatid;
}
/**
* Shows the given amount of items for this blog
*
* @param $template
* String representing the template _NAME_ (!)
* @param $amountEntries
* amount of entries to show (0 = no limit)
* @param $extraQuery
* extra conditions to be added to the query
* @param $highlight
* contains a query that should be highlighted
* @param $comments
* 1=show comments 0=don't show comments
* @param $dateheads
* 1=show dateheads 0=don't show dateheads
* @param $offset
* offset
* @returns int
* amount of items shown
*/
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
*
*/
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 )
{
$item['timestamp'] = strtotime($item['itime']); // string timestamp -> unix timestamp
// 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);
$manager->notify('PreDateFoot',array('blog' => &$this, 'timestamp' => $oldTS));
if ( in_array('DATE_FOOTER', $template) && !empty($template['DATE_FOOTER']) )
{
$tmp_footer = i18n::formatted_datetime($template['DATE_FOOTER'], $oldTS);
}
else
{
$tmp_footer = '';
}
$parser->parse($tmp_footer);
$manager->notify('PostDateFoot',array('blog' => &$this, 'timestamp' => $oldTS));
}
$manager->notify('PreDateHead',array('blog' => &$this, 'timestamp' => $timestamp));
// 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 = i18n::formatted_datetime($template['DATE_HEADER'], $timestamp);
}
else
{
$tmp_header = '';
}
$parser->parse($tmp_header);
$manager->notify('PostDateHead',array('blog' => &$this, 'timestamp' => $timestamp));
}
$old_date = $new_date;
}
// parse item
$parser->parse($template['ITEM_HEADER']);
$manager->notify('PreItem', array('blog' => &$this, 'item' => &$item));
$parser->parse($template['ITEM']);
$manager->notify('PostItem', array('blog' => &$this, 'item' => &$item));
$parser->parse($template['ITEM_FOOTER']);
}
$numrows = $items->rowCount();
// add another date footer if there was at least one item
if ( ($numrows > 0) && $dateheads )
{
$manager->notify('PreDateFoot',array('blog' => &$this, 'timestamp' => strtotime($old_date)));
$parser->parse($template['DATE_FOOTER']);
$manager->notify('PostDateFoot',array('blog' => &$this, 'timestamp' => strtotime($old_date)));
}
$items->closeCursor();
return $numrows;
}
/**
* Simplified function for showing only one item
*/
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
*/
function additem($catid, $title, $body, $more, $blogid, $authorid, $timestamp, $closed, $draft, $posted='1')
{
global $manager;
$blogid = intval($blogid);
$authorid = intval($authorid);
$title = $title;
$body = $body;
$more = $more;
$catid = intval($catid);
// convert newlines to
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);
$manager->notify('PreAddItem',array('title' => &$title, 'body' => &$body, 'more' => &$more, 'blog' => &$this, 'authorid' => &$authorid, 'timestamp' => &$timestamp, 'closed' => &$closed, 'draft' => &$draft, 'catid' => &$catid));
$ititle = DB::quoteValue($title);
$ibody = DB::quoteValue($body);
$imore = DB::quoteValue($more);
$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();
$manager->notify('PostAddItem',array('itemid' => $itemid));
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
*/
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'
* @returns Integer the new category-id in case of success. 0 on failure
*/
function createNewCategory($catName = '', $catDescription = _CREATED_NEW_CATEGORY_DESC)
{
global $member, $manager;
if ( $member->blogAdminRights($this->getID()) )
{
// 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->getID());
while ( $res->rowCount() > 0 )
{
$i++;
$res = DB::getResult('SELECT * FROM '.sql_table('category')." WHERE cname='".$catName.$i."' and cblog=".$this->getID());
}
$catName = $catName . $i;
}
$manager->notify(
'PreAddCategory',
array(
'blog' => &$this,
'name' => &$catName,
'description' => $catDescription
)
);
$query = "INSERT INTO %s (cblog, cname, cdesc) VALUES (%d, %s, %s)";
$query = sprintf($query, sql_table('category'), (integer) $this->getID(), DB::quoteValue($catName), DB::quoteValue($catDescription));
DB::execute($query);
$catid = DB::getInsertId();
$manager->notify(
'PostAddCategory',
array(
'blog' => &$this,
'name' => $catName,
'description' => $catDescription,
'catid' => $catid
)
);
return $catid;
}
return 0;
}
/**
* Searches all months of this blog for the given query
*
* @param $query
* search query
* @param $template
* template to be used (__NAME__ of the template)
* @param $amountMonths
* max amount of months to be search (0 = all)
* @param $maxresults
* max number of results to show
* @param $startpos
* offset
* @returns
* amount of hits found
*/
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->getID()
);
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)
*/
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->getID(); // 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
*/
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'
// exclude drafts
. ' and i.idraft=0'
// don't show future items
. ' and i.itime<=' . DB::formatDateTime($this->getCorrectTime());
if ( $this->getSelectedCategory() )
{
$query .= ' and i.icat=' . $this->getSelectedCategory() . ' ';
}
$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
*/
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);
$data['blogid'] = $this->getID();
if ( !array_key_exists('ARCHIVELIST_HEADER', $template) || !$template['ARCHIVELIST_HEADER'] )
{
$tplt = '';
}
else
{
$tplt = $template['ARCHIVELIST_HEADER'];
}
echo Template::fill($tplt, $data);
$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->getID()
// don't show future items!
. ' AND itime <=' . DB::formatDateTime($this->getCorrectTime())
// don't show draft items
. ' AND idraft=0';
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']);
$data['day'] = date('d',$current['itime']);
$data['month'] = date('m',$current['itime']);
$archive['month'] = $data['month'];
}
elseif ( $mode == 'year' )
{
$archivedate = date('Y',$current['itime']);
$data['day'] = '';
$data['month'] = '';
$archive['day'] = '';
$archive['month'] = '';
}
else
{
$archivedate = date('Y-m',$current['itime']);
$data['month'] = date('m',$current['itime']);
$archive['month'] = $data['month'];
$data['day'] = '';
$archive['day'] = '';
}
$data['year'] = date('Y',$current['itime']);
$archive['year'] = $data['year'];
$data['archivelink'] = Link::create_archive_link($this->getID(),$archivedate,$linkparams);
$manager->notify(
'PreArchiveListItem',
array(
'listitem' => &$data
)
);
$temp = Template::fill($template['ARCHIVELIST_LISTITEM'],$data);
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, $data);
return;
}
/**
* Blog::showCategoryList()
* Shows the list of categories using a given template
*
* @param string $template Template Name
* @return void
*/
function showCategoryList($template)
{
global $CONF, $manager;
/*
* determine arguments next to catids
* I guess this can be done in a better way, but it works
*/
global $archive, $archivelist;
$linkparams = array();
if ( $archive )
{
$blogurl = Link::create_archive_link($this->getID(), $archive, '');
$linkparams['blogid'] = $this->getID();
$linkparams['archive'] = $archive;
}
else if ( $archivelist )
{
$blogurl = Link::create_archivelist_link($this->getID(), '');
$linkparams['archivelist'] = $archivelist;
}
else
{
$blogurl = Link::create_blogid_link($this->getID(), '');
$linkparams['blogid'] = $this->getID();
}
$template =& $manager->getTemplate($template);
//: Change: Set nocatselected variable
if ( $this->getSelectedCategory() )
{
$nocatselected = 'no';
}
else
{
$nocatselected = 'yes';
}
$args = array(
'blogid' => $this->getID(),
'blogurl' => $blogurl,
'self' => $CONF['Self'],
//: Change: Set catiscurrent template variable for header
'catiscurrent' => $nocatselected,
'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->getID());
$res = DB::getResult($query);
foreach ( $res as $data )
{
$args = array(
'catid' => $data['catid'],
'name' => $data['catname'],
'extra' => $linkparams
);
$data['blogid'] = $this->getID();
$data['blogurl'] = $blogurl;
$data['catlink'] = Link::create_link('category', $args);
$data['self'] = $CONF['Self'];
// this gives catiscurrent = no when no category is selected.
$data['catiscurrent'] = 'no';
$data['currentcat'] = 'no';
if ( $this->getSelectedCategory() )
{
if ( $this->getSelectedCategory() == $data['catid'] )
{
$data['catiscurrent'] = 'yes';
$data['currentcat'] = 'yes';
}
}
else
{
global $itemid;
if ( intval($itemid) && $manager->existsItem(intval($itemid), 0, 0) )
{
$iobj =& $manager->getItem(intval($itemid), 0, 0);
$cid = $iobj['catid'];
if ( $cid == $data['catid'] )
{
$data['catiscurrent'] = 'yes';
$data['currentcat'] = 'yes';
}
}
}
$manager->notify(
'PreCategoryListItem',
array(
'listitem' => &$data
));
if ( !array_key_exists('CATLIST_LISTITEM', $template) || empty($template['CATLIST_LISTITEM']))
{
echo Template::fill(NULL, $data);
}
else
{
echo Template::fill($template['CATLIST_LISTITEM'], $data);
}
}
$res->closeCursor();
$args = array(
'blogid' => $this->getID(),
'blogurl' => $blogurl,
'self' => $CONF['Self'],
//: Change: Set catiscurrent template variable for footer
'catiscurrent' => $nocatselected,
'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
*/
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);
echo Template::fill((isset($template['BLOGLIST_HEADER']) ? $template['BLOGLIST_HEADER'] : null),
array(
'sitename' => $CONF['SiteName'],
'siteurl' => $CONF['IndexURL']
)
);
$query = 'SELECT bnumber, bname, bshortname, bdesc, burl FROM '.sql_table('blog').' ORDER BY '.$orderby.' '.$direction;
$res = DB::getResult($query);
foreach ( $res as $data )
{
$list = array();
$list['bloglink'] = Link::create_blogid_link($data['bnumber']);
$list['blogdesc'] = $data['bdesc'];
$list['blogurl'] = $data['burl'];
if ( $bnametype == 'shortname' )
{
$list['blogname'] = $data['bshortname'];
}
else
{
/* all other cases */
$list['blogname'] = $data['bname'];
}
$manager->notify(
'PreBlogListItem',
array(
'listitem' => &$list
)
);
echo Template::fill((isset($template['BLOGLIST_LISTITEM']) ? $template['BLOGLIST_LISTITEM'] : null), $list);
}
$res->closeCursor();
echo Template::fill((isset($template['BLOGLIST_FOOTER']) ? $template['BLOGLIST_FOOTER'] : null),
array(
'sitename' => $CONF['SiteName'],
'siteurl' => $CONF['IndexURL']
)
);
return;
}
/**
* Read the blog settings
*/
function readSettings() {
$query = 'SELECT *'
. ' FROM '.sql_table('blog')
. ' WHERE bnumber=' . $this->blogid;
$res = DB::getResult($query);
$this->isValid = ($res->rowCount() > 0);
if (!$this->isValid)
return;
$this->settings = $res->fetch(PDO::FETCH_ASSOC);
}
/**
* Write the blog settings
*/
function writeSettings() {
// (can't use floatval since not available prior to PHP 4.2)
$offset = $this->getTimeOffset();
if (!is_float($offset))
$offset = intval($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->getID());
DB::execute($query);
}
/**
* Update the update file if requested
*/
function updateUpdatefile() {
if ($this->getUpdateFile()) {
$f_update = fopen($this->getUpdateFile(),'w');
fputs($f_update,$this->getCorrectTime());
fclose($f_update);
}
}
/**
* Check if a category with a given catid is valid
*
* @param $catid
* category id
*/
function isValidCategory($catid) {
$query = 'SELECT * FROM '.sql_table('category').' WHERE cblog=' . $this->getID() . ' and catid=' . intval($catid);
$res = DB::getResult($query);
return ($res->rowCount() != 0);
}
/**
* Get the category name for a given catid
*
* @param $catid
* category id
*/
function getCategoryName($catid) {
$res = DB::getValue('SELECT cname FROM '.sql_table('category').' WHERE cblog='.$this->getID().' and catid=' . intval($catid));
return $res;
}
/**
* Get the category description for a given catid
*
* @param $catid
* category id
*/
function getCategoryDesc($catid) {
$res = DB::getValue('SELECT cdesc FROM '.sql_table('category').' WHERE cblog='.$this->getID().' and catid=' . intval($catid));
return $res;
}
/**
* Get the category id for a given category name
*
* @param $name
* category name
*/
function getCategoryIdFromName($name) {
$res = DB::getValue('SELECT catid FROM '.sql_table('category').' WHERE cblog='.$this->getID().' and cname="' . DB::quoteValue($name) . '"');
if ( $res ) {
return $res;
} else {
return $this->getDefaultCategory();
}
}
/**
* Get the the setting for the line break handling
* [should be named as getConvertBreaks()]
*/
function convertBreaks() {
return $this->getSetting('bconvertbreaks');
}
/**
* Set the the setting for the line break handling
*
* @param $val
* new value for bconvertbreaks
*/
function setConvertBreaks($val) {
$this->setSetting('bconvertbreaks',$val);
}
/**
* Insert a javascript that includes information about the settings
* of an author: ConvertBreaks, MediaUrl and AuthorId
*
* @param $authorid
* id of the author
*/
function insertJavaScriptInfo($authorid = '') {
global $member, $CONF;
if ($authorid == '')
$authorid = $member->getID();
?>
setSetting('ballowpast',$val);
}
/**
* Get the the setting if it is allowed to publish postings in the past
* [should be named as getAllowPastPosting()]
*/
function allowPastPosting() {
return $this->getSetting('ballowpast');
}
function getCorrectTime($t=0) {
if ($t == 0) $t = time();
return ($t + 3600 * $this->getTimeOffset());
}
function getName() {
return $this->getSetting('bname');
}
function getShortName() {
return $this->getSetting('bshortname');
}
function getMaxComments() {
return $this->getSetting('bmaxcomments');
}
function getNotifyAddress() {
return $this->getSetting('bnotify');
}
function getNotifyType() {
return $this->getSetting('bnotifytype');
}
function notifyOnComment() {
$n = $this->getNotifyType();
return (($n != 0) && (($n % 3) == 0));
}
function notifyOnVote() {
$n = $this->getNotifyType();
return (($n != 0) && (($n % 5) == 0));
}
function notifyOnNewItem() {
$n = $this->getNotifyType();
return (($n != 0) && (($n % 7) == 0));
}
function setNotifyType($val) {
$this->setSetting('bnotifytype',$val);
}
function getTimeOffset() {
return $this->getSetting('btimeoffset');
}
function commentsEnabled() {
return $this->getSetting('bcomments');
}
function getURL() {
return $this->getSetting('burl');
}
function getDefaultSkin() {
return $this->getSetting('bdefskin');
}
function getUpdateFile() {
return $this->getSetting('bupdate');
}
function getDescription() {
return $this->getSetting('bdesc');
}
function isPublic() {
return $this->getSetting('bpublic');
}
function emailRequired() {
return $this->getSetting('breqemail');
}
function getSearchable() {
return $this->getSetting('bincludesearch');
}
function getDefaultCategory() {
return $this->getSetting('bdefcat');
}
function setPublic($val) {
$this->setSetting('bpublic',$val);
}
function setSearchable($val) {
$this->setSetting('bincludesearch',$val);
}
function setDescription($val) {
$this->setSetting('bdesc',$val);
}
function setUpdateFile($val) {
$this->setSetting('bupdate',$val);
}
function setDefaultSkin($val) {
$this->setSetting('bdefskin',$val);
}
function setURL($val) {
$this->setSetting('burl',$val);
}
function setName($val) {
$this->setSetting('bname',$val);
}
function setShortName($val) {
$this->setSetting('bshortname',$val);
}
function setCommentsEnabled($val) {
$this->setSetting('bcomments',$val);
}
function setMaxComments($val) {
$this->setSetting('bmaxcomments',$val);
}
function setNotifyAddress($val) {
$this->setSetting('bnotify',$val);
}
function setEmailRequired($val) {
$this->setSetting('breqemail',$val);
}
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;
}
function setDefaultCategory($val) {
$this->setSetting('bdefcat',$val);
}
function getSetting($key) {
return $this->settings[$key];
}
function setSetting($key,$value) {
$this->settings[$key] = $value;
}
/**
* 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
*/
function addTeamMember($memberid, $admin)
{
global $manager;
$memberid = intval($memberid);
$admin = intval($admin);
// check if member is already a member
$tmem = Member::createFromID($memberid);
if ( $tmem->isTeamMember($this->getID()) )
{
return 0;
}
$manager->notify(
'PreAddTeamMember',
array(
'blog' => &$this,
'member' => &$tmem,
'admin' => &$admin
)
);
// add to team
$query = "INSERT INTO %s (TMEMBER, TBLOG, TADMIN) VALUES (%d, %d, %d);";
$query = sprintf($query, sql_table('team'), (integer) $memberid, (integer) $this->getID(), (integer) $admin);
DB::execute($query);
$manager->notify(
'PostAddTeamMember',
array(
'blog' => &$this,
'member' => &$tmem,
'admin' => $admin
)
);
$logMsg = sprintf(_TEAM_ADD_NEWTEAMMEMBER, $tmem->getDisplayName(), $memberid, $this->getName());
ActionLog::add(INFO, $logMsg);
return 1;
}
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 $name
* blog shortname
*/
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 $id
* blog id
*/
function existsID($id) {
$r = DB::getResult('SELECT * FROM '.sql_table('blog').' WHERE bnumber='.intval($id));
return ($r->rowCount() != 0);
}
/**
* flag there is a future post pending
*/
function setFuturePost() {
$query = 'UPDATE '.sql_table('blog')
. " SET bfuturepost='1' WHERE bnumber=" . $this->getID();
DB::execute($query);
}
/**
* clear there is a future post pending
*/
function clearFuturePost() {
$query = 'UPDATE '.sql_table('blog')
. " SET bfuturepost='0' WHERE bnumber=" . $this->getID();
DB::execute($query);
}
/**
* check if we should throw justPosted event
*/
function checkJustPosted() {
global $manager;
if ($this->settings['bfuturepost'] == 1) {
$blogid = $this->getID();
$result = DB::getResult("SELECT * FROM " . sql_table('item')
. " WHERE iposted=0 AND iblog=" . $blogid . " AND itimerowCount() > 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;
$manager->notify(
'JustPosted',
array('blogid' => $blogid,
'pinged' => &$pinged
)
);
// clear all expired future posts
DB::execute("UPDATE " . sql_table('item') . " SET iposted='1' WHERE iblog=" . $blogid . " AND itime