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 echo TEMPLATE::fill($template['ARCHIVELIST_HEADER'],$data);
572 $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')
573 . ' WHERE iblog=' . $this->getID()
574 . ' and itime <=' . mysqldate($this->getCorrectTime()) // don't show future items!
575 . ' and idraft=0'; // don't show draft items
578 $query .= ' and icat=' . intval($catid);
580 $query .= ' GROUP BY Year';
581 if ($mode == 'month' || $mode == 'day')
586 $query .= ' ORDER BY itime DESC';
589 $query .= ' LIMIT ' . intval($limit);
591 $res = sql_query($query);
593 while ($current = sql_fetch_object($res)) {
594 $current->itime = strtotime($current->itime); // string time -> unix timestamp
596 if ($mode == 'day') {
597 $archivedate = date('Y-m-d',$current->itime);
598 $archive['day'] = date('d',$current->itime);
599 $data['day'] = date('d',$current->itime);
600 $data['month'] = date('m',$current->itime);
601 $archive['month'] = $data['month'];
602 } elseif ($mode == 'year') {
603 $archivedate = date('Y',$current->itime);
606 $archive['day'] = '';
607 $archive['month'] = '';
609 $archivedate = date('Y-m',$current->itime);
610 $data['month'] = date('m',$current->itime);
611 $archive['month'] = $data['month'];
613 $archive['day'] = '';
616 $data['year'] = date('Y',$current->itime);
617 $archive['year'] = $data['year'];
618 $data['archivelink'] = createArchiveLink($this->getID(),$archivedate,$linkparams);
621 'PreArchiveListItem',
627 $temp = TEMPLATE::fill($template['ARCHIVELIST_LISTITEM'],$data);
628 echo strftime($temp,$current->itime);
632 sql_free_result($res);
634 echo TEMPLATE::fill($template['ARCHIVELIST_FOOTER'],$data);
639 * Shows the list of categories using a given template
641 function showCategoryList($template) {
642 global $CONF, $manager;
644 // determine arguments next to catids
645 // I guess this can be done in a better way, but it works
646 global $archive, $archivelist;
648 $linkparams = array();
650 $blogurl = createArchiveLink($this->getID(), $archive, '');
651 $linkparams['blogid'] = $this->getID();
652 $linkparams['archive'] = $archive;
653 } else if ($archivelist) {
654 $blogurl = createArchiveListLink($this->getID(), '');
655 $linkparams['archivelist'] = $archivelist;
657 $blogurl = createBlogidLink($this->getID(), '');
658 $linkparams['blogid'] = $this->getID();
661 //$blogurl = $this->getURL() . $qargs;
662 //$blogurl = createBlogLink($this->getURL(), $linkparams);
664 $template =& $manager->getTemplate($template);
666 echo TEMPLATE::fill((isset($template['CATLIST_HEADER']) ? $template['CATLIST_HEADER'] : null),
668 'blogid' => $this->getID(),
669 'blogurl' => $blogurl,
670 'self' => $CONF['Self']
673 $query = 'SELECT catid, cdesc as catdesc, cname as catname FROM '.sql_table('category').' WHERE cblog=' . $this->getID() . ' ORDER BY cname ASC';
674 $res = sql_query($query);
677 while ($data = sql_fetch_assoc($res)) {
678 $data['blogid'] = $this->getID();
679 $data['blogurl'] = $blogurl;
680 $data['catlink'] = createLink(
683 'catid' => $data['catid'],
684 'name' => $data['catname'],
685 'extra' => $linkparams
688 $data['self'] = $CONF['Self'];
691 'PreCategoryListItem',
697 echo TEMPLATE::fill((isset($template['CATLIST_LISTITEM']) ? $template['CATLIST_LISTITEM'] : null), $data);
698 //$temp = TEMPLATE::fill((isset($template['CATLIST_LISTITEM']) ? $template['CATLIST_LISTITEM'] : null), $data);
699 //echo strftime($temp, $current->itime);
703 sql_free_result($res);
705 echo TEMPLATE::fill((isset($template['CATLIST_FOOTER']) ? $template['CATLIST_FOOTER'] : null),
707 'blogid' => $this->getID(),
708 'blogurl' => $blogurl,
709 'self' => $CONF['Self']
714 * Shows a list of all blogs in the system using a given template
715 * ordered by number, name, shortname or description
716 * in ascending or descending order
718 function showBlogList($template, $bnametype, $orderby, $direction) {
719 global $CONF, $manager;
729 $orderby='bshortname';
739 $direction=strtolower($direction);
740 switch ($direction) {
752 $template =& $manager->getTemplate($template);
754 echo TEMPLATE::fill((isset($template['BLOGLIST_HEADER']) ? $template['BLOGLIST_HEADER'] : null),
756 'sitename' => $CONF['SiteName'],
757 'siteurl' => $CONF['IndexURL']
760 $query = 'SELECT bnumber, bname, bshortname, bdesc, burl FROM '.sql_table('blog').' ORDER BY '.$orderby.' '.$direction;
761 $res = sql_query($query);
763 while ($data = sql_fetch_assoc($res)) {
767 // $list['bloglink'] = createLink('blog', array('blogid' => $data['bnumber']));
768 $list['bloglink'] = createBlogidLink($data['bnumber']);
770 $list['blogdesc'] = $data['bdesc'];
772 $list['blogurl'] = $data['burl'];
774 if ($bnametype=='shortname') {
775 $list['blogname'] = $data['bshortname'];
777 else { // all other cases
778 $list['blogname'] = $data['bname'];
788 echo TEMPLATE::fill((isset($template['BLOGLIST_LISTITEM']) ? $template['BLOGLIST_LISTITEM'] : null), $list);
792 sql_free_result($res);
794 echo TEMPLATE::fill((isset($template['BLOGLIST_FOOTER']) ? $template['BLOGLIST_FOOTER'] : null),
796 'sitename' => $CONF['SiteName'],
797 'siteurl' => $CONF['IndexURL']
803 * Blogsettings functions
806 function readSettings() {
808 . ' FROM '.sql_table('blog')
809 . ' WHERE bnumber=' . $this->blogid;
810 $res = sql_query($query);
812 $this->isValid = (sql_num_rows($res) > 0);
816 $this->settings = sql_fetch_assoc($res);
819 function writeSettings() {
821 // (can't use floatval since not available prior to PHP 4.2)
822 $offset = $this->getTimeOffset();
823 if (!is_float($offset))
824 $offset = intval($offset);
826 $query = 'UPDATE '.sql_table('blog')
827 . " SET bname='" . addslashes($this->getName()) . "',"
828 . " bshortname='". addslashes($this->getShortName()) . "',"
829 . " bcomments=". intval($this->commentsEnabled()) . ","
830 . " bmaxcomments=" . intval($this->getMaxComments()) . ","
831 . " btimeoffset=" . $offset . ","
832 . " bpublic=" . intval($this->isPublic()) . ","
833 . " breqemail=" . intval($this->emailRequired()) . ","
834 . " bconvertbreaks=" . intval($this->convertBreaks()) . ","
835 . " ballowpast=" . intval($this->allowPastPosting()) . ","
836 . " bnotify='" . addslashes($this->getNotifyAddress()) . "',"
837 . " bnotifytype=" . intval($this->getNotifyType()) . ","
838 . " burl='" . addslashes($this->getURL()) . "',"
839 . " bupdate='" . addslashes($this->getUpdateFile()) . "',"
840 . " bdesc='" . addslashes($this->getDescription()) . "',"
841 . " bdefcat=" . intval($this->getDefaultCategory()) . ","
842 . " bdefskin=" . intval($this->getDefaultSkin()) . ","
843 . " bincludesearch=" . intval($this->getSearchable())
844 . " WHERE bnumber=" . intval($this->getID());
851 // update update file if requested
852 function updateUpdatefile() {
853 if ($this->getUpdateFile()) {
854 $f_update = fopen($this->getUpdateFile(),'w');
855 fputs($f_update,$this->getCorrectTime());
861 function isValidCategory($catid) {
862 $query = 'SELECT * FROM '.sql_table('category').' WHERE cblog=' . $this->getID() . ' and catid=' . intval($catid);
863 $res = sql_query($query);
864 return (sql_num_rows($res) != 0);
867 function getCategoryName($catid) {
868 $res = sql_query('SELECT cname FROM '.sql_table('category').' WHERE cblog='.$this->getID().' and catid=' . intval($catid));
869 $o = sql_fetch_object($res);
873 function getCategoryDesc($catid) {
874 $res = sql_query('SELECT cdesc FROM '.sql_table('category').' WHERE cblog='.$this->getID().' and catid=' . intval($catid));
875 $o = sql_fetch_object($res);
879 function getCategoryIdFromName($name) {
880 $res = sql_query('SELECT catid FROM '.sql_table('category').' WHERE cblog='.$this->getID().' and cname="' . addslashes($name) . '"');
881 if (sql_num_rows($res) > 0) {
882 $o = sql_fetch_object($res);
885 return $this->getDefaultCategory();
889 function convertBreaks() {
890 return $this->getSetting('bconvertbreaks');
893 function insertJavaScriptInfo($authorid = '') {
894 global $member, $CONF;
897 $authorid = $member->getID();
900 <script type="text/javascript">
901 setConvertBreaks(<?php echo $this->convertBreaks() ? 'true' : 'false' ?>);
902 setMediaUrl("<?php echo $CONF['MediaURL']?>");
903 setAuthorId(<?php echo $authorid?>);
906 function setConvertBreaks($val) {
907 $this->setSetting('bconvertbreaks',$val);
909 function setAllowPastPosting($val) {
910 $this->setSetting('ballowpast',$val);
912 function allowPastPosting() {
913 return $this->getSetting('ballowpast');
916 function getCorrectTime($t=0) {
917 if ($t == 0) $t = time();
918 return ($t + 3600 * $this->getTimeOffset());
922 return $this->getSetting('bname');
925 function getShortName() {
926 return $this->getSetting('bshortname');
929 function getMaxComments() {
930 return $this->getSetting('bmaxcomments');
933 function getNotifyAddress() {
934 return $this->getSetting('bnotify');
937 function getNotifyType() {
938 return $this->getSetting('bnotifytype');
941 function notifyOnComment() {
942 $n = $this->getNotifyType();
943 return (($n != 0) && (($n % 3) == 0));
946 function notifyOnVote() {
947 $n = $this->getNotifyType();
948 return (($n != 0) && (($n % 5) == 0));
951 function notifyOnNewItem() {
952 $n = $this->getNotifyType();
953 return (($n != 0) && (($n % 7) == 0));
956 function setNotifyType($val) {
957 $this->setSetting('bnotifytype',$val);
961 function getTimeOffset() {
962 return $this->getSetting('btimeoffset');
965 function commentsEnabled() {
966 return $this->getSetting('bcomments');
970 return $this->getSetting('burl');
973 function getDefaultSkin() {
974 return $this->getSetting('bdefskin');
977 function getUpdateFile() {
978 return $this->getSetting('bupdate');
981 function getDescription() {
982 return $this->getSetting('bdesc');
985 function isPublic() {
986 return $this->getSetting('bpublic');
989 function emailRequired() {
990 return $this->getSetting('breqemail');
993 function getSearchable() {
994 return $this->getSetting('bincludesearch');
997 function getDefaultCategory() {
998 return $this->getSetting('bdefcat');
1001 function setPublic($val) {
1002 $this->setSetting('bpublic',$val);
1005 function setSearchable($val) {
1006 $this->setSetting('bincludesearch',$val);
1009 function setDescription($val) {
1010 $this->setSetting('bdesc',$val);
1013 function setUpdateFile($val) {
1014 $this->setSetting('bupdate',$val);
1017 function setDefaultSkin($val) {
1018 $this->setSetting('bdefskin',$val);
1021 function setURL($val) {
1022 $this->setSetting('burl',$val);
1025 function setName($val) {
1026 $this->setSetting('bname',$val);
1029 function setShortName($val) {
1030 $this->setSetting('bshortname',$val);
1033 function setCommentsEnabled($val) {
1034 $this->setSetting('bcomments',$val);
1037 function setMaxComments($val) {
1038 $this->setSetting('bmaxcomments',$val);
1041 function setNotifyAddress($val) {
1042 $this->setSetting('bnotify',$val);
1045 function setEmailRequired($val) {
1046 $this->setSetting('breqemail',$val);
1049 function setTimeOffset($val) {
1050 // check validity of value
1051 // 1. replace , by . (common mistake)
1052 $val = str_replace(',','.',$val);
1053 // 2. cast to float or int
1054 if (is_numeric($val) && strstr($val,'.5')) {
1055 $val = (float) $val;
1057 $val = intval($val);
1060 $this->setSetting('btimeoffset',$val);
1063 function setDefaultCategory($val) {
1064 $this->setSetting('bdefcat',$val);
1067 function getSetting($key) {
1068 return $this->settings[$key];
1071 function setSetting($key,$value) {
1072 $this->settings[$key] = $value;
1076 // tries to add a member to the team. Returns false if the member was already on
1078 function addTeamMember($memberid, $admin) {
1081 $memberid = intval($memberid);
1082 $admin = intval($admin);
1084 // check if member is already a member
1085 $tmem = MEMBER::createFromID($memberid);
1087 if ($tmem->isTeamMember($this->getID()))
1100 $query = 'INSERT INTO '.sql_table('team').' (TMEMBER, TBLOG, TADMIN) '
1101 . 'VALUES (' . $memberid .', '.$this->getID().', "'.$admin.'")';
1105 'PostAddTeamMember',
1114 $logMsg = sprintf(_TEAM_ADD_NEWTEAMMEMBER, $tmem->getDisplayName(), $memberid, $this->getName());
1115 ACTIONLOG::add(INFO, $logMsg);
1121 return intVal($this->blogid);
1124 // returns true if there is a blog with the given shortname (static)
1125 function exists($name) {
1126 $r = sql_query('select * FROM '.sql_table('blog').' WHERE bshortname="'.addslashes($name).'"');
1127 return (sql_num_rows($r) != 0);
1130 // returns true if there is a blog with the given ID (static)
1131 function existsID($id) {
1132 $r = sql_query('select * FROM '.sql_table('blog').' WHERE bnumber='.intval($id));
1133 return (sql_num_rows($r) != 0);
1136 // flag there is a future post pending
1137 function setFuturePost() {
1138 $query = 'UPDATE '.sql_table('blog')
1139 . " SET bfuturepost='1' WHERE bnumber=" . $this->getID();
1143 // clear there is a future post pending
1144 function clearFuturePost() {
1145 $query = 'UPDATE '.sql_table('blog')
1146 . " SET bfuturepost='0' WHERE bnumber=" . $this->getID();
1150 // check if we should throw justPosted event
1151 function checkJustPosted() {
1154 if ($this->settings['bfuturepost'] == 1) {
1155 $blogid = $this->getID();
1156 $result = sql_query("SELECT * FROM " . sql_table('item')
1157 . " WHERE iposted=0 AND iblog=" . $blogid . " AND itime<NOW()");
1158 if (sql_num_rows($result) > 0) {
1159 // This $pinged is allow a plugin to tell other hook to the event that a ping is sent already
1160 // Note that the plugins's calling order is subject to thri order in the plugin list
1164 array('blogid' => $blogid,
1165 'pinged' => &$pinged
1169 // clear all expired future posts
1170 sql_query("UPDATE " . sql_table('item') . " SET iposted='1' WHERE iblog=" . $blogid . " AND itime<NOW()");
1172 // check to see any pending future post, clear the flag is none
1173 $result = sql_query("SELECT * FROM " . sql_table('item')
1174 . " WHERE iposted=0 AND iblog=" . $blogid);
1175 if (sql_num_rows($result) == 0) {
1176 $this->clearFuturePost();
1183 * Shows the given list of items for this blog
1186 * array of item numbers to be displayed
1188 * String representing the template _NAME_ (!)
1190 * contains a query that should be highlighted
1192 * 1=show comments 0=don't show comments
1194 * 1=show dateheads 0=don't show dateheads
1196 * amount of items shown
1198 function readLogFromList($itemarray, $template, $highlight = '', $comments = 1, $dateheads = 1) {
1200 $query = $this->getSqlItemList($itemarray);
1202 return $this->showUsingQuery($template, $query, $highlight, $comments, $dateheads);
1206 * Returns the SQL query used to fill out templates for a list of items
1209 * an array holding the item numbers of the items to be displayed
1211 * either a full SQL query, or an empty string
1213 * No LIMIT clause is added. (caller should add this if multiple pages are requested)
1215 function getSqlItemList($itemarray)
1217 if (!is_array($itemarray)) return '';
1219 foreach ($itemarray as $value) {
1220 if (intval($value)) $items[] = intval($value);
1222 if (!count($items)) return '';
1223 //$itemlist = implode(',',$items);
1226 foreach ($items as $value) {
1229 . ' i.inumber as itemid,'
1230 . ' i.ititle as title,'
1231 . ' i.ibody as body,'
1232 . ' m.mname as author,'
1233 . ' m.mrealname as authorname,'
1235 . ' i.imore as more,'
1236 . ' m.mnumber as authorid,'
1237 . ' m.memail as authormail,'
1238 . ' m.murl as authorurl,'
1239 . ' c.cname as category,'
1240 . ' i.icat as catid,'
1241 . ' i.iclosed as closed';
1244 . sql_table('item') . ' as i, '
1245 . sql_table('member') . ' as m, '
1246 . sql_table('category').' as c'
1248 . ' i.iblog = ' . $this->blogid
1249 . ' and i.iauthor = m.mnumber'
1250 . ' and i.icat = c.catid'
1251 . ' and i.idraft = 0' // exclude drafts
1252 // don't show future items
1253 . ' and i.itime <= ' . mysqldate($this->getCorrectTime());
1255 //$query .= ' and i.inumber IN ('.$itemlist.')';
1256 $query .= ' and i.inumber = '.intval($value);
1259 if ($i) $query .= ' UNION ';