4 * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)
5 * Copyright (C) 2002-2009 The Nucleus Group
7 * This program is free software; you can redistribute it and/or
8 * modify it under the terms of the GNU General Public License
9 * as published by the Free Software Foundation; either version 2
10 * of the License, or (at your option) any later version.
11 * (see nucleus/documentation/index.html#license for more info)
14 * A class representing a blog and containing functions to get that blog shown
17 * @license http://nucleuscms.org/license.txt GNU General Public License
18 * @copyright Copyright (C) 2002-2009 The Nucleus Group
20 * $NucleusJP: BLOG.php,v 1.12.2.2 2007/08/08 05:26:22 kimitake Exp $
23 if ( !function_exists('requestVar') ) exit;
24 require_once dirname(__FILE__) . '/ITEMACTIONS.php';
31 // ID of currently selected category
34 // After creating an object of the blog class, contains true if the BLOG object is
35 // valid (the blog exists)
38 // associative array, containing all blogsettings (use the get/set functions instead)
42 * Creates a new BLOG object for the given blog
47 $this->blogid = intval($id);
48 $this->readSettings();
51 // (the parse functions in SKIN.php will override this, so it's mainly useless)
53 $this->setSelectedCategory($catid);
57 * Shows the given amount of items for this blog
60 * String representing the template _NAME_ (!)
61 * @param $amountEntries
62 * amount of entries to show
64 * offset from where items should be shown (e.g. 5 = start at fifth item)
66 * amount of items shown
68 function readLog($template, $amountEntries, $offset = 0, $startpos = 0) {
69 return $this->readLogAmount($template,$amountEntries,'','',1,1,$offset, $startpos);
73 * Shows an archive for a given month
80 * String representing the template name to be used
82 function showArchive($templatename, $year, $month = 0, $day = 0) {
84 // create extra where clause for select query
85 if ($day == 0 && $month != 0) {
86 $timestamp_start = mktime(0,0,0,$month,1,$year);
87 $timestamp_end = mktime(0,0,0,$month+1,1,$year); // also works when $month==12
88 } elseif ($month == 0) {
89 $timestamp_start = mktime(0,0,0,1,1,$year);
90 $timestamp_end = mktime(0,0,0,12,31,$year); // also works when $month==12
92 $timestamp_start = mktime(0,0,0,$month,$day,$year);
93 $timestamp_end = mktime(0,0,0,$month,$day+1,$year);
95 $extra_query = ' and i.itime>=' . mysqldate($timestamp_start)
96 . ' and i.itime<' . mysqldate($timestamp_end);
99 $this->readLogAmount($templatename,0,$extra_query,'',1,1);
104 // sets/gets current category (only when category exists)
105 function setSelectedCategory($catid) {
106 if ($this->isValidCategory($catid) || (intval($catid) == 0))
107 $this->selectedcatid = intval($catid);
110 function setSelectedCategoryByName($catname) {
111 $this->setSelectedCategory($this->getCategoryIdFromName($catname));
114 function getSelectedCategory() {
115 return $this->selectedcatid;
119 * Shows the given amount of items for this blog
122 * String representing the template _NAME_ (!)
123 * @param $amountEntries
124 * amount of entries to show (0 = no limit)
126 * extra conditions to be added to the query
128 * contains a query that should be highlighted
130 * 1=show comments 0=don't show comments
132 * 1=show dateheads 0=don't show dateheads
136 * amount of items shown
138 function readLogAmount($template, $amountEntries, $extraQuery, $highlight, $comments, $dateheads, $offset = 0, $startpos = 0) {
140 $query = $this->getSqlBlog($extraQuery);
142 if ($amountEntries > 0) {
143 // $offset zou moeten worden:
144 // (($startpos / $amountentries) + 1) * $offset ... later testen ...
145 $query .= ' LIMIT ' . intval($startpos + $offset).',' . intval($amountEntries);
147 return $this->showUsingQuery($template, $query, $highlight, $comments, $dateheads);
150 function showUsingQuery($templateName, $query, $highlight = '', $comments = 0, $dateheads = 1) {
151 global $CONF, $manager;
153 $lastVisit = cookieVar($CONF['CookiePrefix'] .'lastVisit');
155 $lastVisit = $this->getCorrectTime($lastVisit);
157 // set templatename as global variable (so plugins can access it)
158 global $currentTemplateName;
159 $currentTemplateName = $templateName;
161 $template =& $manager->getTemplate($templateName);
163 // create parser object & action handler
164 $actions =& new ITEMACTIONS($this);
165 $parser =& new PARSER($actions->getDefinedActions(),$actions);
166 $actions->setTemplate($template);
167 $actions->setHighlight($highlight);
168 $actions->setLastVisit($lastVisit);
169 $actions->setParser($parser);
170 $actions->setShowComments($comments);
173 $items = sql_query($query);
175 // loop over all items
177 while ($item = sql_fetch_object($items)) {
179 $item->timestamp = strtotime($item->itime); // string timestamp -> unix timestamp
181 // action handler needs to know the item we're handling
182 $actions->setCurrentItem($item);
184 // add date header if needed
186 $new_date = date('dFY',$item->timestamp);
187 if ($new_date != $old_date) {
188 // unless this is the first time, write date footer
189 $timestamp = $item->timestamp;
190 if ($old_date != 0) {
191 $oldTS = strtotime($old_date);
192 $manager->notify('PreDateFoot',array('blog' => &$this, 'timestamp' => $oldTS));
193 $tmp_footer = strftime(isset($template['DATE_FOOTER'])?$template['DATE_FOOTER']:'', $oldTS);
194 $parser->parse($tmp_footer);
195 $manager->notify('PostDateFoot',array('blog' => &$this, 'timestamp' => $oldTS));
197 $manager->notify('PreDateHead',array('blog' => &$this, 'timestamp' => $timestamp));
198 // note, to use templatvars in the dateheader, the %-characters need to be doubled in
199 // order to be preserved by strftime
200 $tmp_header = strftime((isset($template['DATE_HEADER']) ? $template['DATE_HEADER'] : null), $timestamp);
201 $parser->parse($tmp_header);
202 $manager->notify('PostDateHead',array('blog' => &$this, 'timestamp' => $timestamp));
204 $old_date = $new_date;
208 $parser->parse($template['ITEM_HEADER']);
209 $manager->notify('PreItem', array('blog' => &$this, 'item' => &$item));
210 $parser->parse($template['ITEM']);
211 $manager->notify('PostItem', array('blog' => &$this, 'item' => &$item));
212 $parser->parse($template['ITEM_FOOTER']);
216 $numrows = sql_num_rows($items);
218 // add another date footer if there was at least one item
219 if (($numrows > 0) && $dateheads) {
220 $manager->notify('PreDateFoot',array('blog' => &$this, 'timestamp' => strtotime($old_date)));
221 $parser->parse($template['DATE_FOOTER']);
222 $manager->notify('PostDateFoot',array('blog' => &$this, 'timestamp' => strtotime($old_date)));
225 sql_free_result($items); // free memory
231 function showOneitem($itemid, $template, $highlight) {
232 $extraQuery = ' and inumber=' . intval($itemid);
234 return $this->readLogAmount($template, 1, $extraQuery, $highlight, 0, 0);
239 * Adds an item to this blog
241 function additem($catid, $title, $body, $more, $blogid, $authorid, $timestamp, $closed, $draft, $posted='1') {
244 $blogid = intval($blogid);
245 $authorid = intval($authorid);
249 $catid = intval($catid);
251 // convert newlines to <br />
252 if ($this->convertBreaks()) {
253 $body = addBreaks($body);
254 $more = addBreaks($more);
257 if ($closed != '1') $closed = '0';
258 if ($draft != '0') $draft = '1';
260 if (!$this->isValidCategory($catid))
261 $catid = $this->getDefaultCategory();
263 if ($timestamp > $this->getCorrectTime())
266 $timestamp = date('Y-m-d H:i:s',$timestamp);
268 $manager->notify('PreAddItem',array('title' => &$title, 'body' => &$body, 'more' => &$more, 'blog' => &$this, 'authorid' => &$authorid, 'timestamp' => &$timestamp, 'closed' => &$closed, 'draft' => &$draft, 'catid' => &$catid));
270 $title = addslashes($title);
271 $body = addslashes($body);
272 $more = addslashes($more);
274 $query = 'INSERT INTO '.sql_table('item').' (ITITLE, IBODY, IMORE, IBLOG, IAUTHOR, ITIME, ICLOSED, IDRAFT, ICAT, IPOSTED) '
275 . "VALUES ('$title', '$body', '$more', $blogid, $authorid, '$timestamp', $closed, $draft, $catid, $posted)";
277 $itemid = sql_insert_id();
279 $manager->notify('PostAddItem',array('itemid' => $itemid));
282 $this->updateUpdateFile();
284 // send notification mail
285 if (!$draft && !$isFuture && $this->getNotifyAddress() && $this->notifyOnNewItem())
286 $this->sendNewItemNotification($itemid, stripslashes($title), stripslashes($body));
291 function sendNewItemNotification($itemid, $title, $body) {
292 global $CONF, $member;
294 // create text version of html post
295 $ascii = toAscii($body);
297 $mailto_msg = _NOTIFY_NI_MSG . " \n";
298 // $mailto_msg .= $CONF['IndexURL'] . 'index.php?itemid=' . $itemid . "\n\n";
299 $temp = parse_url($CONF['Self']);
300 if ($temp['scheme']) {
301 $mailto_msg .= createItemLink($itemid) . "\n\n";
303 $tempurl = $this->getURL();
304 if (substr($tempurl, -1) == '/' || substr($tempurl, -4) == '.php') {
305 $mailto_msg .= $tempurl . '?itemid=' . $itemid . "\n\n";
307 $mailto_msg .= $tempurl . '/?itemid=' . $itemid . "\n\n";
310 $mailto_msg .= _NOTIFY_TITLE . ' ' . strip_tags($title) . "\n";
311 $mailto_msg .= _NOTIFY_CONTENTS . "\n " . $ascii . "\n";
312 $mailto_msg .= getMailFooter();
314 $mailto_title = $this->getName() . ': ' . _NOTIFY_NI_TITLE;
316 $frommail = $member->getNotifyFromMailAddress();
318 $notify =& new NOTIFICATION($this->getNotifyAddress());
319 $notify->notify($mailto_title, $mailto_msg , $frommail);
327 * Creates a new category for this blog
330 * name of the new category. When empty, a name is generated automatically
331 * (starting with newcat)
332 * @param $catDescription
333 * description of the new category. Defaults to 'New Category'
336 * the new category-id in case of success.
339 function createNewCategory($catName = '', $catDescription = _CREATED_NEW_CATEGORY_DESC) {
340 global $member, $manager;
342 if ($member->blogAdminRights($this->getID())) {
346 $catName = _CREATED_NEW_CATEGORY_NAME;
349 $res = sql_query('SELECT * FROM '.sql_table('category')." WHERE cname='".$catName.$i."' and cblog=".$this->getID());
350 while (sql_num_rows($res) > 0)
353 $res = sql_query('SELECT * FROM '.sql_table('category')." WHERE cname='".$catName.$i."' and cblog=".$this->getID());
356 $catName = $catName . $i;
364 'description' => $catDescription
368 $query = 'INSERT INTO '.sql_table('category').' (cblog, cname, cdesc) VALUES (' . $this->getID() . ", '" . addslashes($catName) . "', '" . addslashes($catDescription) . "')";
370 $catid = sql_insert_id();
377 'description' => $catDescription,
391 * Searches all months of this blog for the given query
396 * template to be used (__NAME__ of the template)
397 * @param $amountMonths
398 * max amount of months to be search (0 = all)
400 * max number of results to show
404 * amount of hits found
406 function search($query, $template, $amountMonths, $maxresults, $startpos) {
407 global $CONF, $manager;
410 $sqlquery = $this->getSqlSearch($query, $amountMonths, $highlight);
414 // no query -> show everything
416 $amountfound = $this->readLogAmount($template, $maxresults, $extraQuery, $query, 1, 1);
419 // add LIMIT to query (to split search results into pages)
420 if (intval($maxresults > 0))
421 $sqlquery .= ' LIMIT ' . intval($startpos).',' . intval($maxresults);
424 $amountfound = $this->showUsingQuery($template, $sqlquery, $highlight, 1, 1);
426 // when no results were found, show a message
427 if ($amountfound == 0)
429 $template =& $manager->getTemplate($template);
431 'query' => htmlspecialchars($query),
432 'blogid' => $this->getID()
434 echo TEMPLATE::fill($template['SEARCH_NOTHINGFOUND'],$vars);
442 * Returns an SQL query to use for a search query
446 * @param $amountMonths
447 * amount of months to search back. Default = 0 = unlimited
449 * either empty, or 'count'. In this case, the query will be a SELECT COUNT(*) query
450 * @returns $highlight
451 * words to highlight (out parameter)
453 * either a full SQL query, or an empty string (if querystring empty)
455 * No LIMIT clause is added. (caller should add this if multiple pages are requested)
457 function getSqlSearch($query, $amountMonths = 0, &$highlight, $mode = '')
459 $searchclass =& new SEARCH($query);
461 $highlight = $searchclass->inclusive;
463 // if querystring is empty, return empty string
464 if ($searchclass->inclusive == '')
468 $where = $searchclass->boolean_sql_where('ititle,ibody,imore');
469 $select = $searchclass->boolean_sql_select('ititle,ibody,imore');
471 // get list of blogs to search
472 $blogs = $searchclass->blogs; // array containing blogs that always need to be included
473 $blogs[] = $this->getID(); // also search current blog (duh)
474 $blogs = array_unique($blogs); // remove duplicates
476 if (count($blogs) > 0)
477 $selectblogs = ' and i.iblog in (' . implode(',', $blogs) . ')';
481 $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';
483 $query .= ', '.$select. ' as score ';
485 $query = 'SELECT COUNT(*) as result ';
488 $query .= ' FROM '.sql_table('item').' as i, '.sql_table('member').' as m, '.sql_table('category').' as c'
489 . ' WHERE i.iauthor=m.mnumber'
490 . ' and i.icat=c.catid'
491 . ' and i.idraft=0' // exclude drafts
493 // don't show future items
494 . ' and i.itime<=' . mysqldate($this->getCorrectTime())
497 // take into account amount of months to search
498 if ($amountMonths > 0)
500 $localtime = getdate($this->getCorrectTime());
501 $timestamp_start = mktime(0,0,0,$localtime['mon'] - $amountMonths,1,$localtime['year']);
502 $query .= ' and i.itime>' . mysqldate($timestamp_start);
508 $query .= ' ORDER BY score DESC';
510 $query .= ' ORDER BY i.itime DESC ';
517 * Returns the SQL query that's normally used to display the blog items on the index type skins
520 * either empty, or 'count'. In this case, the query will be a SELECT COUNT(*) query
522 * either a full SQL query, or an empty string
524 * No LIMIT clause is added. (caller should add this if multiple pages are requested)
526 function getSqlBlog($extraQuery, $mode = '')
529 $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';
531 $query = 'SELECT COUNT(*) as result ';
533 $query .= ' FROM '.sql_table('item').' as i, '.sql_table('member').' as m, '.sql_table('category').' as c'
534 . ' WHERE i.iblog='.$this->blogid
535 . ' and i.iauthor=m.mnumber'
536 . ' and i.icat=c.catid'
537 . ' and i.idraft=0' // exclude drafts
538 // don't show future items
539 . ' and i.itime<=' . mysqldate($this->getCorrectTime());
541 if ($this->getSelectedCategory())
542 $query .= ' and i.icat=' . $this->getSelectedCategory() . ' ';
545 $query .= $extraQuery;
548 $query .= ' ORDER BY i.itime DESC';
554 * Shows the archivelist using the given template
556 function showArchiveList($template, $mode = 'month', $limit = 0) {
557 global $CONF, $catid, $manager;
559 if (!isset ($linkparams)) {
560 $linkparams = array();
564 $linkparams = array('catid' => $catid);
567 $template =& $manager->getTemplate($template);
568 $data['blogid'] = $this->getID();
570 $tplt = isset($template['ARCHIVELIST_HEADER']) ? $template['ARCHIVELIST_HEADER']
572 echo TEMPLATE::fill($tplt, $data);
574 $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')
575 . ' WHERE iblog=' . $this->getID()
576 . ' and itime <=' . mysqldate($this->getCorrectTime()) // don't show future items!
577 . ' and idraft=0'; // don't show draft items
580 $query .= ' and icat=' . intval($catid);
582 $query .= ' GROUP BY Year';
583 if ($mode == 'month' || $mode == 'day')
588 $query .= ' ORDER BY itime DESC';
591 $query .= ' LIMIT ' . intval($limit);
593 $res = sql_query($query);
595 while ($current = sql_fetch_object($res)) {
596 $current->itime = strtotime($current->itime); // string time -> unix timestamp
598 if ($mode == 'day') {
599 $archivedate = date('Y-m-d',$current->itime);
600 $archive['day'] = date('d',$current->itime);
601 $data['day'] = date('d',$current->itime);
602 $data['month'] = date('m',$current->itime);
603 $archive['month'] = $data['month'];
604 } elseif ($mode == 'year') {
605 $archivedate = date('Y',$current->itime);
608 $archive['day'] = '';
609 $archive['month'] = '';
611 $archivedate = date('Y-m',$current->itime);
612 $data['month'] = date('m',$current->itime);
613 $archive['month'] = $data['month'];
615 $archive['day'] = '';
618 $data['year'] = date('Y',$current->itime);
619 $archive['year'] = $data['year'];
620 $data['archivelink'] = createArchiveLink($this->getID(),$archivedate,$linkparams);
623 'PreArchiveListItem',
629 $temp = TEMPLATE::fill($template['ARCHIVELIST_LISTITEM'],$data);
630 echo strftime($temp,$current->itime);
634 sql_free_result($res);
636 $tplt = isset($template['ARCHIVELIST_FOOTER']) ? $template['ARCHIVELIST_FOOTER']
638 echo TEMPLATE::fill($tplt, $data);
643 * Shows the list of categories using a given template
645 function showCategoryList($template) {
646 global $CONF, $manager;
648 // determine arguments next to catids
649 // I guess this can be done in a better way, but it works
650 global $archive, $archivelist;
652 $linkparams = array();
654 $blogurl = createArchiveLink($this->getID(), $archive, '');
655 $linkparams['blogid'] = $this->getID();
656 $linkparams['archive'] = $archive;
657 } else if ($archivelist) {
658 $blogurl = createArchiveListLink($this->getID(), '');
659 $linkparams['archivelist'] = $archivelist;
661 $blogurl = createBlogidLink($this->getID(), '');
662 $linkparams['blogid'] = $this->getID();
665 //$blogurl = $this->getURL() . $qargs;
666 //$blogurl = createBlogLink($this->getURL(), $linkparams);
668 $template =& $manager->getTemplate($template);
670 echo TEMPLATE::fill((isset($template['CATLIST_HEADER']) ? $template['CATLIST_HEADER'] : null),
672 'blogid' => $this->getID(),
673 'blogurl' => $blogurl,
674 'self' => $CONF['Self']
677 $query = 'SELECT catid, cdesc as catdesc, cname as catname FROM '.sql_table('category').' WHERE cblog=' . $this->getID() . ' ORDER BY cname ASC';
678 $res = sql_query($query);
681 while ($data = sql_fetch_assoc($res)) {
682 $data['blogid'] = $this->getID();
683 $data['blogurl'] = $blogurl;
684 $data['catlink'] = createLink(
687 'catid' => $data['catid'],
688 'name' => $data['catname'],
689 'extra' => $linkparams
692 $data['self'] = $CONF['Self'];
695 'PreCategoryListItem',
701 echo TEMPLATE::fill((isset($template['CATLIST_LISTITEM']) ? $template['CATLIST_LISTITEM'] : null), $data);
702 //$temp = TEMPLATE::fill((isset($template['CATLIST_LISTITEM']) ? $template['CATLIST_LISTITEM'] : null), $data);
703 //echo strftime($temp, $current->itime);
707 sql_free_result($res);
709 echo TEMPLATE::fill((isset($template['CATLIST_FOOTER']) ? $template['CATLIST_FOOTER'] : null),
711 'blogid' => $this->getID(),
712 'blogurl' => $blogurl,
713 'self' => $CONF['Self']
718 * Shows a list of all blogs in the system using a given template
719 * ordered by number, name, shortname or description
720 * in ascending or descending order
722 function showBlogList($template, $bnametype, $orderby, $direction) {
723 global $CONF, $manager;
733 $orderby='bshortname';
743 $direction=strtolower($direction);
744 switch ($direction) {
756 $template =& $manager->getTemplate($template);
758 echo TEMPLATE::fill((isset($template['BLOGLIST_HEADER']) ? $template['BLOGLIST_HEADER'] : null),
760 'sitename' => $CONF['SiteName'],
761 'siteurl' => $CONF['IndexURL']
764 $query = 'SELECT bnumber, bname, bshortname, bdesc, burl FROM '.sql_table('blog').' ORDER BY '.$orderby.' '.$direction;
765 $res = sql_query($query);
767 while ($data = sql_fetch_assoc($res)) {
771 // $list['bloglink'] = createLink('blog', array('blogid' => $data['bnumber']));
772 $list['bloglink'] = createBlogidLink($data['bnumber']);
774 $list['blogdesc'] = $data['bdesc'];
776 $list['blogurl'] = $data['burl'];
778 if ($bnametype=='shortname') {
779 $list['blogname'] = $data['bshortname'];
781 else { // all other cases
782 $list['blogname'] = $data['bname'];
792 echo TEMPLATE::fill((isset($template['BLOGLIST_LISTITEM']) ? $template['BLOGLIST_LISTITEM'] : null), $list);
796 sql_free_result($res);
798 echo TEMPLATE::fill((isset($template['BLOGLIST_FOOTER']) ? $template['BLOGLIST_FOOTER'] : null),
800 'sitename' => $CONF['SiteName'],
801 'siteurl' => $CONF['IndexURL']
807 * Blogsettings functions
810 function readSettings() {
812 . ' FROM '.sql_table('blog')
813 . ' WHERE bnumber=' . $this->blogid;
814 $res = sql_query($query);
816 $this->isValid = (sql_num_rows($res) > 0);
820 $this->settings = sql_fetch_assoc($res);
823 function writeSettings() {
825 // (can't use floatval since not available prior to PHP 4.2)
826 $offset = $this->getTimeOffset();
827 if (!is_float($offset))
828 $offset = intval($offset);
830 $query = 'UPDATE '.sql_table('blog')
831 . " SET bname='" . addslashes($this->getName()) . "',"
832 . " bshortname='". addslashes($this->getShortName()) . "',"
833 . " bcomments=". intval($this->commentsEnabled()) . ","
834 . " bmaxcomments=" . intval($this->getMaxComments()) . ","
835 . " btimeoffset=" . $offset . ","
836 . " bpublic=" . intval($this->isPublic()) . ","
837 . " breqemail=" . intval($this->emailRequired()) . ","
838 . " bconvertbreaks=" . intval($this->convertBreaks()) . ","
839 . " ballowpast=" . intval($this->allowPastPosting()) . ","
840 . " bnotify='" . addslashes($this->getNotifyAddress()) . "',"
841 . " bnotifytype=" . intval($this->getNotifyType()) . ","
842 . " burl='" . addslashes($this->getURL()) . "',"
843 . " bupdate='" . addslashes($this->getUpdateFile()) . "',"
844 . " bdesc='" . addslashes($this->getDescription()) . "',"
845 . " bdefcat=" . intval($this->getDefaultCategory()) . ","
846 . " bdefskin=" . intval($this->getDefaultSkin()) . ","
847 . " bincludesearch=" . intval($this->getSearchable())
848 . " WHERE bnumber=" . intval($this->getID());
855 // update update file if requested
856 function updateUpdatefile() {
857 if ($this->getUpdateFile()) {
858 $f_update = fopen($this->getUpdateFile(),'w');
859 fputs($f_update,$this->getCorrectTime());
865 function isValidCategory($catid) {
866 $query = 'SELECT * FROM '.sql_table('category').' WHERE cblog=' . $this->getID() . ' and catid=' . intval($catid);
867 $res = sql_query($query);
868 return (sql_num_rows($res) != 0);
871 function getCategoryName($catid) {
872 $res = sql_query('SELECT cname FROM '.sql_table('category').' WHERE cblog='.$this->getID().' and catid=' . intval($catid));
873 $o = sql_fetch_object($res);
877 function getCategoryDesc($catid) {
878 $res = sql_query('SELECT cdesc FROM '.sql_table('category').' WHERE cblog='.$this->getID().' and catid=' . intval($catid));
879 $o = sql_fetch_object($res);
883 function getCategoryIdFromName($name) {
884 $res = sql_query('SELECT catid FROM '.sql_table('category').' WHERE cblog='.$this->getID().' and cname="' . addslashes($name) . '"');
885 if (sql_num_rows($res) > 0) {
886 $o = sql_fetch_object($res);
889 return $this->getDefaultCategory();
893 function convertBreaks() {
894 return $this->getSetting('bconvertbreaks');
897 function insertJavaScriptInfo($authorid = '') {
898 global $member, $CONF;
901 $authorid = $member->getID();
904 <script type="text/javascript">
905 setConvertBreaks(<?php echo $this->convertBreaks() ? 'true' : 'false' ?>);
906 setMediaUrl("<?php echo $CONF['MediaURL']?>");
907 setAuthorId(<?php echo $authorid?>);
910 function setConvertBreaks($val) {
911 $this->setSetting('bconvertbreaks',$val);
913 function setAllowPastPosting($val) {
914 $this->setSetting('ballowpast',$val);
916 function allowPastPosting() {
917 return $this->getSetting('ballowpast');
920 function getCorrectTime($t=0) {
921 if ($t == 0) $t = time();
922 return ($t + 3600 * $this->getTimeOffset());
926 return $this->getSetting('bname');
929 function getShortName() {
930 return $this->getSetting('bshortname');
933 function getMaxComments() {
934 return $this->getSetting('bmaxcomments');
937 function getNotifyAddress() {
938 return $this->getSetting('bnotify');
941 function getNotifyType() {
942 return $this->getSetting('bnotifytype');
945 function notifyOnComment() {
946 $n = $this->getNotifyType();
947 return (($n != 0) && (($n % 3) == 0));
950 function notifyOnVote() {
951 $n = $this->getNotifyType();
952 return (($n != 0) && (($n % 5) == 0));
955 function notifyOnNewItem() {
956 $n = $this->getNotifyType();
957 return (($n != 0) && (($n % 7) == 0));
960 function setNotifyType($val) {
961 $this->setSetting('bnotifytype',$val);
965 function getTimeOffset() {
966 return $this->getSetting('btimeoffset');
969 function commentsEnabled() {
970 return $this->getSetting('bcomments');
974 return $this->getSetting('burl');
977 function getDefaultSkin() {
978 return $this->getSetting('bdefskin');
981 function getUpdateFile() {
982 return $this->getSetting('bupdate');
985 function getDescription() {
986 return $this->getSetting('bdesc');
989 function isPublic() {
990 return $this->getSetting('bpublic');
993 function emailRequired() {
994 return $this->getSetting('breqemail');
997 function getSearchable() {
998 return $this->getSetting('bincludesearch');
1001 function getDefaultCategory() {
1002 return $this->getSetting('bdefcat');
1005 function setPublic($val) {
1006 $this->setSetting('bpublic',$val);
1009 function setSearchable($val) {
1010 $this->setSetting('bincludesearch',$val);
1013 function setDescription($val) {
1014 $this->setSetting('bdesc',$val);
1017 function setUpdateFile($val) {
1018 $this->setSetting('bupdate',$val);
1021 function setDefaultSkin($val) {
1022 $this->setSetting('bdefskin',$val);
1025 function setURL($val) {
1026 $this->setSetting('burl',$val);
1029 function setName($val) {
1030 $this->setSetting('bname',$val);
1033 function setShortName($val) {
1034 $this->setSetting('bshortname',$val);
1037 function setCommentsEnabled($val) {
1038 $this->setSetting('bcomments',$val);
1041 function setMaxComments($val) {
1042 $this->setSetting('bmaxcomments',$val);
1045 function setNotifyAddress($val) {
1046 $this->setSetting('bnotify',$val);
1049 function setEmailRequired($val) {
1050 $this->setSetting('breqemail',$val);
1053 function setTimeOffset($val) {
1054 // check validity of value
1055 // 1. replace , by . (common mistake)
1056 $val = str_replace(',','.',$val);
1057 // 2. cast to float or int
1058 if (is_numeric($val) && strstr($val,'.5')) {
1059 $val = (float) $val;
1061 $val = intval($val);
1064 $this->setSetting('btimeoffset',$val);
1067 function setDefaultCategory($val) {
1068 $this->setSetting('bdefcat',$val);
1071 function getSetting($key) {
1072 return $this->settings[$key];
1075 function setSetting($key,$value) {
1076 $this->settings[$key] = $value;
1080 // tries to add a member to the team. Returns false if the member was already on
1082 function addTeamMember($memberid, $admin) {
1085 $memberid = intval($memberid);
1086 $admin = intval($admin);
1088 // check if member is already a member
1089 $tmem = MEMBER::createFromID($memberid);
1091 if ($tmem->isTeamMember($this->getID()))
1104 $query = 'INSERT INTO '.sql_table('team').' (TMEMBER, TBLOG, TADMIN) '
1105 . 'VALUES (' . $memberid .', '.$this->getID().', "'.$admin.'")';
1109 'PostAddTeamMember',
1118 $logMsg = sprintf(_TEAM_ADD_NEWTEAMMEMBER, $tmem->getDisplayName(), $memberid, $this->getName());
1119 ACTIONLOG::add(INFO, $logMsg);
1125 return intVal($this->blogid);
1128 // returns true if there is a blog with the given shortname (static)
1129 function exists($name) {
1130 $r = sql_query('select * FROM '.sql_table('blog').' WHERE bshortname="'.addslashes($name).'"');
1131 return (sql_num_rows($r) != 0);
1134 // returns true if there is a blog with the given ID (static)
1135 function existsID($id) {
1136 $r = sql_query('select * FROM '.sql_table('blog').' WHERE bnumber='.intval($id));
1137 return (sql_num_rows($r) != 0);
1140 // flag there is a future post pending
1141 function setFuturePost() {
1142 $query = 'UPDATE '.sql_table('blog')
1143 . " SET bfuturepost='1' WHERE bnumber=" . $this->getID();
1147 // clear there is a future post pending
1148 function clearFuturePost() {
1149 $query = 'UPDATE '.sql_table('blog')
1150 . " SET bfuturepost='0' WHERE bnumber=" . $this->getID();
1154 // check if we should throw justPosted event
1155 function checkJustPosted() {
1158 if ($this->settings['bfuturepost'] == 1) {
1159 $blogid = $this->getID();
1160 $result = sql_query("SELECT * FROM " . sql_table('item')
1161 . " WHERE iposted=0 AND iblog=" . $blogid . " AND itime<NOW()");
1162 if (sql_num_rows($result) > 0) {
1163 // This $pinged is allow a plugin to tell other hook to the event that a ping is sent already
1164 // Note that the plugins's calling order is subject to thri order in the plugin list
1168 array('blogid' => $blogid,
1169 'pinged' => &$pinged
1173 // clear all expired future posts
1174 sql_query("UPDATE " . sql_table('item') . " SET iposted='1' WHERE iblog=" . $blogid . " AND itime<NOW()");
1176 // check to see any pending future post, clear the flag is none
1177 $result = sql_query("SELECT * FROM " . sql_table('item')
1178 . " WHERE iposted=0 AND iblog=" . $blogid);
1179 if (sql_num_rows($result) == 0) {
1180 $this->clearFuturePost();
1187 * Shows the given list of items for this blog
1190 * array of item numbers to be displayed
1192 * String representing the template _NAME_ (!)
1194 * contains a query that should be highlighted
1196 * 1=show comments 0=don't show comments
1198 * 1=show dateheads 0=don't show dateheads
1200 * amount of items shown
1202 function readLogFromList($itemarray, $template, $highlight = '', $comments = 1, $dateheads = 1) {
1204 $query = $this->getSqlItemList($itemarray);
1206 return $this->showUsingQuery($template, $query, $highlight, $comments, $dateheads);
1210 * Returns the SQL query used to fill out templates for a list of items
1213 * an array holding the item numbers of the items to be displayed
1215 * either a full SQL query, or an empty string
1217 * No LIMIT clause is added. (caller should add this if multiple pages are requested)
1219 function getSqlItemList($itemarray)
1221 if (!is_array($itemarray)) return '';
1223 foreach ($itemarray as $value) {
1224 if (intval($value)) $items[] = intval($value);
1226 if (!count($items)) return '';
1227 //$itemlist = implode(',',$items);
1230 foreach ($items as $value) {
1233 . ' i.inumber as itemid,'
1234 . ' i.ititle as title,'
1235 . ' i.ibody as body,'
1236 . ' m.mname as author,'
1237 . ' m.mrealname as authorname,'
1239 . ' i.imore as more,'
1240 . ' m.mnumber as authorid,'
1241 . ' m.memail as authormail,'
1242 . ' m.murl as authorurl,'
1243 . ' c.cname as category,'
1244 . ' i.icat as catid,'
1245 . ' i.iclosed as closed';
1248 . sql_table('item') . ' as i, '
1249 . sql_table('member') . ' as m, '
1250 . sql_table('category').' as c'
1252 . ' i.iblog = ' . $this->blogid
1253 . ' and i.iauthor = m.mnumber'
1254 . ' and i.icat = c.catid'
1255 . ' and i.idraft = 0' // exclude drafts
1256 // don't show future items
1257 . ' and i.itime <= ' . mysqldate($this->getCorrectTime());
1259 //$query .= ' and i.inumber IN ('.$itemlist.')';
1260 $query .= ' and i.inumber = '.intval($value);
1263 if ($i) $query .= ' UNION ';