4 * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)
5 * Copyright (C) 2002-2007 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-2007 The Nucleus Group
19 * @version $Id: BLOG.php,v 1.10 2007-03-13 05:13:29 shizuki Exp $
20 * $NucleusJP: BLOG.php,v 1.9 2007/02/17 04:39:29 shizuki Exp $
23 // temporary: dirt way to separe class ITEMACTIONS from BLOG
24 require_once $DIR_LIBS . '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, $day=0) {
84 // create extra where clause for select query
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
89 $timestamp_start = mktime(0,0,0,$month,$day,$year);
90 $timestamp_end = mktime(0,0,0,$month,$day+1,$year);
92 $extra_query = ' and i.itime>=' . mysqldate($timestamp_start)
93 . ' and i.itime<' . mysqldate($timestamp_end);
96 $this->readLogAmount($templatename,0,$extra_query,'',1,1);
101 // sets/gets current category (only when category exists)
102 function setSelectedCategory($catid) {
103 if ($this->isValidCategory($catid) || (intval($catid) == 0))
104 $this->selectedcatid = intval($catid);
107 function setSelectedCategoryByName($catname) {
108 $this->setSelectedCategory($this->getCategoryIdFromName($catname));
111 function getSelectedCategory() {
112 return $this->selectedcatid;
116 * Shows the given amount of items for this blog
119 * String representing the template _NAME_ (!)
120 * @param $amountEntries
121 * amount of entries to show (0 = no limit)
123 * extra conditions to be added to the query
125 * contains a query that should be highlighted
127 * 1=show comments 0=don't show comments
129 * 1=show dateheads 0=don't show dateheads
133 * amount of items shown
135 function readLogAmount($template, $amountEntries, $extraQuery, $highlight, $comments, $dateheads, $offset = 0, $startpos = 0) {
137 $query = $this->getSqlBlog($extraQuery);
139 if ($amountEntries > 0) {
140 // $offset zou moeten worden:
141 // (($startpos / $amountentries) + 1) * $offset ... later testen ...
142 $query .= ' LIMIT ' . intval($startpos + $offset).',' . intval($amountEntries);
144 return $this->showUsingQuery($template, $query, $highlight, $comments, $dateheads);
147 function showUsingQuery($templateName, $query, $highlight = '', $comments = 0, $dateheads = 1) {
148 global $CONF, $manager;
150 $lastVisit = cookieVar($CONF['CookiePrefix'] .'lastVisit');
152 $lastVisit = $this->getCorrectTime($lastVisit);
154 // set templatename as global variable (so plugins can access it)
155 global $currentTemplateName;
156 $currentTemplateName = $templateName;
158 $template =& $manager->getTemplate($templateName);
160 // create parser object & action handler
161 $actions =& new ITEMACTIONS($this);
162 $parser =& new PARSER($actions->getDefinedActions(),$actions);
163 $actions->setTemplate($template);
164 $actions->setHighlight($highlight);
165 $actions->setLastVisit($lastVisit);
166 $actions->setParser($parser);
167 $actions->setShowComments($comments);
170 $items = sql_query($query);
172 // loop over all items
173 while ($item = mysql_fetch_object($items)) {
175 $item->timestamp = strtotime($item->itime); // string timestamp -> unix timestamp
177 // action handler needs to know the item we're handling
178 $actions->setCurrentItem($item);
180 // add date header if needed
183 $new_date = date('dFY',$item->timestamp);
184 if ($new_date != $old_date) {
185 // unless this is the first time, write date footer
186 $timestamp = $item->timestamp;
187 if ($old_date != 0) {
188 $oldTS = strtotime($old_date);
189 $manager->notify('PreDateFoot',array('blog' => &$this, 'timestamp' => $oldTS));
190 $tmp_footer = strftime($template['DATE_FOOTER'], $oldTS);
191 $parser->parse($tmp_footer);
192 $manager->notify('PostDateFoot',array('blog' => &$this, 'timestamp' => $oldTS));
194 $manager->notify('PreDateHead',array('blog' => &$this, 'timestamp' => $timestamp));
195 // note, to use templatvars in the dateheader, the %-characters need to be doubled in
196 // order to be preserved by strftime
197 $tmp_header = strftime((isset($template['DATE_HEADER']) ? $template['DATE_HEADER'] : null), $timestamp);
198 $parser->parse($tmp_header);
199 $manager->notify('PostDateHead',array('blog' => &$this, 'timestamp' => $timestamp));
201 $old_date = $new_date;
205 $parser->parse($template['ITEM_HEADER']);
206 $manager->notify('PreItem', array('blog' => &$this, 'item' => &$item));
207 $parser->parse($template['ITEM']);
208 $manager->notify('PostItem', array('blog' => &$this, 'item' => &$item));
209 $parser->parse($template['ITEM_FOOTER']);
213 $numrows = mysql_num_rows($items);
215 // add another date footer if there was at least one item
216 if (($numrows > 0) && $dateheads) {
217 $manager->notify('PreDateFoot',array('blog' => &$this, 'timestamp' => strtotime($old_date)));
218 $parser->parse($template['DATE_FOOTER']);
219 $manager->notify('PostDateFoot',array('blog' => &$this, 'timestamp' => strtotime($old_date)));
222 mysql_free_result($items); // free memory
228 function showOneitem($itemid, $template, $highlight) {
229 $extraQuery = ' and inumber=' . intval($itemid);
231 return $this->readLogAmount($template, 1, $extraQuery, $highlight, 0, 0);
236 * Adds an item to this blog
238 function additem($catid, $title, $body, $more, $blogid, $authorid, $timestamp, $closed, $draft) {
241 $blogid = intval($blogid);
242 $authorid = intval($authorid);
246 $catid = intval($catid);
248 // convert newlines to <br />
249 if ($this->convertBreaks()) {
250 $body = addBreaks($body);
251 $more = addBreaks($more);
254 if ($closed != '1') $closed = '0';
255 if ($draft != '0') $draft = '1';
257 if (!$this->isValidCategory($catid))
258 $catid = $this->getDefaultCategory();
260 if ($timestamp > $this->getCorrectTime())
263 $timestamp = date('Y-m-d H:i:s',$timestamp);
265 $manager->notify('PreAddItem',array('title' => &$title, 'body' => &$body, 'more' => &$more, 'blog' => &$this, 'authorid' => &$authorid, 'timestamp' => &$timestamp, 'closed' => &$closed, 'draft' => &$draft, 'catid' => &$catid));
267 $title = addslashes($title);
268 $body = addslashes($body);
269 $more = addslashes($more);
271 $query = 'INSERT INTO '.sql_table('item').' (ITITLE, IBODY, IMORE, IBLOG, IAUTHOR, ITIME, ICLOSED, IDRAFT, ICAT) '
272 . "VALUES ('$title', '$body', '$more', $blogid, $authorid, '$timestamp', $closed, $draft, $catid)";
274 $itemid = mysql_insert_id();
276 $manager->notify('PostAddItem',array('itemid' => $itemid));
279 $this->updateUpdateFile();
281 // send notification mail
282 if (!$draft && !$isFuture && $this->getNotifyAddress() && $this->notifyOnNewItem())
283 $this->sendNewItemNotification($itemid, stripslashes($title), stripslashes($body));
288 function sendNewItemNotification($itemid, $title, $body) {
289 global $CONF, $member;
291 // create text version of html post
292 $ascii = toAscii($body);
294 $mailto_msg = _NOTIFY_NI_MSG . " \n";
295 // $mailto_msg .= $CONF['IndexURL'] . 'index.php?itemid=' . $itemid . "\n\n";
296 $temp = parse_url($CONF['Self']);
297 if ($temp['scheme']) {
298 $mailto_msg .= createItemLink($itemid) . "\n\n";
300 $tempurl = $this->getURL();
301 if (substr($tempurl, -1) == '/' || substr($tempurl, -4) == '.php') {
302 $mailto_msg .= $tempurl . '?itemid=' . $itemid . "\n\n";
304 $mailto_msg .= $tempurl . '/?itemid=' . $itemid . "\n\n";
307 $mailto_msg .= _NOTIFY_TITLE . ' ' . strip_tags($title) . "\n";
308 $mailto_msg .= _NOTIFY_CONTENTS . "\n " . $ascii . "\n";
309 $mailto_msg .= getMailFooter();
311 $mailto_title = $this->getName() . ': ' . _NOTIFY_NI_TITLE;
313 $frommail = $member->getNotifyFromMailAddress();
315 $notify =& new NOTIFICATION($this->getNotifyAddress());
316 $notify->notify($mailto_title, $mailto_msg , $frommail);
324 * Creates a new category for this blog
327 * name of the new category. When empty, a name is generated automatically
328 * (starting with newcat)
329 * @param $catDescription
330 * description of the new category. Defaults to 'New Category'
333 * the new category-id in case of success.
336 function createNewCategory($catName = '', $catDescription = 'New category') {
337 global $member, $manager;
339 if ($member->blogAdminRights($this->getID())) {
346 $res = sql_query('SELECT * FROM '.sql_table('category')." WHERE cname='".$catName.$i."' and cblog=".$this->getID());
347 while (mysql_num_rows($res) > 0)
350 $res = sql_query('SELECT * FROM '.sql_table('category')." WHERE cname='".$catName.$i."' and cblog=".$this->getID());
353 $catName = $catName . $i;
361 'description' => $catDescription
365 $query = 'INSERT INTO '.sql_table('category').' (cblog, cname, cdesc) VALUES (' . $this->getID() . ", '" . addslashes($catName) . "', '" . addslashes($catDescription) . "')";
367 $catid = mysql_insert_id();
374 'description' => $catDescription,
388 * Searches all months of this blog for the given query
393 * template to be used (__NAME__ of the template)
394 * @param $amountMonths
395 * max amount of months to be search (0 = all)
397 * max number of results to show
401 * amount of hits found
403 function search($query, $template, $amountMonths, $maxresults, $startpos) {
404 global $CONF, $manager;
407 $sqlquery = $this->getSqlSearch($query, $amountMonths, $highlight);
411 // no query -> show everything
413 $amountfound = $this->readLogAmount($template, $maxresults, $extraQuery, $query, 1, 1);
416 // add LIMIT to query (to split search results into pages)
417 if (intval($maxresults > 0))
418 $sqlquery .= ' LIMIT ' . intval($startpos).',' . intval($maxresults);
421 $amountfound = $this->showUsingQuery($template, $sqlquery, $highlight, 1, 1);
423 // when no results were found, show a message
424 if ($amountfound == 0)
426 $template =& $manager->getTemplate($template);
428 'query' => htmlspecialchars($query),
429 'blogid' => $this->getID()
431 echo TEMPLATE::fill($template['SEARCH_NOTHINGFOUND'],$vars);
439 * Returns an SQL query to use for a search query
443 * @param $amountMonths
444 * amount of months to search back. Default = 0 = unlimited
446 * either empty, or 'count'. In this case, the query will be a SELECT COUNT(*) query
447 * @returns $highlight
448 * words to highlight (out parameter)
450 * either a full SQL query, or an empty string (if querystring empty)
452 * No LIMIT clause is added. (caller should add this if multiple pages are requested)
454 function getSqlSearch($query, $amountMonths = 0, &$highlight, $mode = '')
456 $searchclass =& new SEARCH($query);
458 $highlight = $searchclass->inclusive;
460 // if querystring is empty, return empty string
461 if ($searchclass->inclusive == '')
465 $where = $searchclass->boolean_sql_where('ititle,ibody,imore');
466 $select = $searchclass->boolean_sql_select('ititle,ibody,imore');
468 // get list of blogs to search
469 $blogs = $searchclass->blogs; // array containing blogs that always need to be included
470 $blogs[] = $this->getID(); // also search current blog (duh)
471 $blogs = array_unique($blogs); // remove duplicates
473 if (count($blogs) > 0)
474 $selectblogs = ' and i.iblog in (' . implode(',', $blogs) . ')';
478 $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';
480 $query .= ', '.$select. ' as score ';
482 $query = 'SELECT COUNT(*) as result ';
485 $query .= ' FROM '.sql_table('item').' as i, '.sql_table('member').' as m, '.sql_table('category').' as c'
486 . ' WHERE i.iauthor=m.mnumber'
487 . ' and i.icat=c.catid'
488 . ' and i.idraft=0' // exclude drafts
490 // don't show future items
491 . ' and i.itime<=' . mysqldate($this->getCorrectTime())
494 // take into account amount of months to search
495 if ($amountMonths > 0)
497 $localtime = getdate($this->getCorrectTime());
498 $timestamp_start = mktime(0,0,0,$localtime['mon'] - $amountMonths,1,$localtime['year']);
499 $query .= ' and i.itime>' . mysqldate($timestamp_start);
505 $query .= ' ORDER BY score DESC';
507 $query .= ' ORDER BY i.itime DESC ';
514 * Returns the SQL query that's normally used to display the blog items on the index type skins
517 * either empty, or 'count'. In this case, the query will be a SELECT COUNT(*) query
519 * either a full SQL query, or an empty string
521 * No LIMIT clause is added. (caller should add this if multiple pages are requested)
523 function getSqlBlog($extraQuery, $mode = '')
526 $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';
528 $query = 'SELECT COUNT(*) as result ';
530 $query .= ' FROM '.sql_table('item').' as i, '.sql_table('member').' as m, '.sql_table('category').' as c'
531 . ' WHERE i.iblog='.$this->blogid
532 . ' and i.iauthor=m.mnumber'
533 . ' and i.icat=c.catid'
534 . ' and i.idraft=0' // exclude drafts
535 // don't show future items
536 . ' and i.itime<=' . mysqldate($this->getCorrectTime());
538 if ($this->getSelectedCategory())
539 $query .= ' and i.icat=' . $this->getSelectedCategory() . ' ';
542 $query .= $extraQuery;
545 $query .= ' ORDER BY i.itime DESC';
551 * Shows the archivelist using the given template
553 function showArchiveList($template, $mode = 'month', $limit = 0) {
554 global $CONF, $catid, $manager;
557 $linkparams = array('catid' => $catid);
559 $template =& $manager->getTemplate($template);
560 $data['blogid'] = $this->getID();
562 echo TEMPLATE::fill($template['ARCHIVELIST_HEADER'],$data);
564 $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')
565 . ' WHERE iblog=' . $this->getID()
566 . ' and itime <=' . mysqldate($this->getCorrectTime()) // don't show future items!
567 . ' and idraft=0'; // don't show draft items
570 $query .= ' and icat=' . intval($catid);
572 $query .= ' GROUP BY Year, Month';
577 $query .= ' ORDER BY itime DESC';
580 $query .= ' LIMIT ' . intval($limit);
582 $res = sql_query($query);
584 while ($current = mysql_fetch_object($res)) {
585 $current->itime = strtotime($current->itime); // string time -> unix timestamp
587 if ($mode == 'day') {
588 $archivedate = date('Y-m-d',$current->itime);
589 $archive['day'] = date('d',$current->itime);
591 $archivedate = date('Y-m',$current->itime);
593 $data['month'] = date('m',$current->itime);
594 $data['year'] = date('Y',$current->itime);
595 $data['archivelink'] = createArchiveLink($this->getID(),$archivedate,$linkparams);
597 $temp = TEMPLATE::fill($template['ARCHIVELIST_LISTITEM'],$data);
598 echo strftime($temp,$current->itime);
602 mysql_free_result($res);
604 echo TEMPLATE::fill($template['ARCHIVELIST_FOOTER'],$data);
609 * Shows the list of categories using a given template
611 function showCategoryList($template) {
612 global $CONF, $manager;
614 // determine arguments next to catids
615 // I guess this can be done in a better way, but it works
616 global $archive, $archivelist;
618 $linkparams = array();
620 $blogurl = createArchiveLink($this->getID(), $archive, '');
621 $linkparams['blogid'] = $this->getID();
622 $linkparams['archive'] = $archive;
623 } else if ($archivelist) {
624 $blogurl = createArchiveListLink($this->getID(), '');
625 $linkparams['archivelist'] = $archivelist;
627 $blogurl = createBlogidLink($this->getID(), '');
628 $linkparams['blogid'] = $this->getID();
631 //$blogurl = $this->getURL() . $qargs;
632 //$blogurl = createBlogLink($this->getURL(), $linkparams);
634 $template =& $manager->getTemplate($template);
636 echo TEMPLATE::fill((isset($template['CATLIST_HEADER']) ? $template['CATLIST_HEADER'] : null),
638 'blogid' => $this->getID(),
639 'blogurl' => $blogurl,
640 'self' => $CONF['Self']
643 $query = 'SELECT catid, cdesc as catdesc, cname as catname FROM '.sql_table('category').' WHERE cblog=' . $this->getID() . ' ORDER BY cname ASC';
644 $res = sql_query($query);
647 while ($data = mysql_fetch_assoc($res)) {
648 $data['blogid'] = $this->getID();
649 $data['blogurl'] = $blogurl;
650 $data['catlink'] = createLink(
653 'catid' => $data['catid'],
654 'name' => $data['catname'],
655 'extra' => $linkparams
658 $data['self'] = $CONF['Self'];
660 echo TEMPLATE::fill((isset($template['CATLIST_LISTITEM']) ? $template['CATLIST_LISTITEM'] : null), $data);
661 //$temp = TEMPLATE::fill((isset($template['CATLIST_LISTITEM']) ? $template['CATLIST_LISTITEM'] : null), $data);
662 //echo strftime($temp, $current->itime);
666 mysql_free_result($res);
668 echo TEMPLATE::fill((isset($template['CATLIST_FOOTER']) ? $template['CATLIST_FOOTER'] : null),
670 'blogid' => $this->getID(),
671 'blogurl' => $blogurl,
672 'self' => $CONF['Self']
677 * Shows a list of all blogs in the system using a given template
679 function showBlogList($template, $bnametype) {
680 global $CONF, $manager;
682 $template =& $manager->getTemplate($template);
684 echo TEMPLATE::fill((isset($template['BLOGLIST_HEADER']) ? $template['BLOGLIST_HEADER'] : null),
686 'sitename' => $CONF['SiteName'],
687 'siteurl' => $CONF['IndexURL']
690 $query = 'SELECT bnumber, bname, bshortname, bdesc, burl FROM '.sql_table('blog').' ORDER BY bnumber ASC';
691 $res = sql_query($query);
693 while ($data = mysql_fetch_assoc($res)) {
697 $list['bloglink'] = createLink('blog', array('blogid' => $data['bnumber']));
699 $list['blogdesc'] = $data['bdesc'];
701 if ($bnametype=='shortname') {
702 $list['blogname'] = $data['bshortname'];
704 else { // all other cases
705 $list['blogname'] = $data['bname'];
708 echo TEMPLATE::fill((isset($template['BLOGLIST_LISTITEM']) ? $template['BLOGLIST_LISTITEM'] : null), $list);
712 mysql_free_result($res);
714 echo TEMPLATE::fill((isset($template['BLOGLIST_FOOTER']) ? $template['BLOGLIST_FOOTER'] : null),
716 'sitename' => $CONF['SiteName'],
717 'siteurl' => $CONF['IndexURL']
723 * Blogsettings functions
726 function readSettings() {
728 . ' FROM '.sql_table('blog')
729 . ' WHERE bnumber=' . $this->blogid;
730 $res = sql_query($query);
732 $this->isValid = (mysql_num_rows($res) > 0);
736 $this->settings = mysql_fetch_assoc($res);
739 function writeSettings() {
741 // (can't use floatval since not available prior to PHP 4.2)
742 $offset = $this->getTimeOffset();
743 if (!is_float($offset))
744 $offset = intval($offset);
746 $query = 'UPDATE '.sql_table('blog')
747 . " SET bname='" . addslashes($this->getName()) . "',"
748 . " bshortname='". addslashes($this->getShortName()) . "',"
749 . " bcomments=". intval($this->commentsEnabled()) . ","
750 . " bmaxcomments=" . intval($this->getMaxComments()) . ","
751 . " btimeoffset=" . $offset . ","
752 . " bpublic=" . intval($this->isPublic()) . ","
753 . " breqemail=" . intval($this->emailRequired()) . ","
754 . " bsendping=" . intval($this->pingUserland()) . ","
755 . " bconvertbreaks=" . intval($this->convertBreaks()) . ","
756 . " ballowpast=" . intval($this->allowPastPosting()) . ","
757 . " bnotify='" . addslashes($this->getNotifyAddress()) . "',"
758 . " bnotifytype=" . intval($this->getNotifyType()) . ","
759 . " burl='" . addslashes($this->getURL()) . "',"
760 . " bupdate='" . addslashes($this->getUpdateFile()) . "',"
761 . " bdesc='" . addslashes($this->getDescription()) . "',"
762 . " bdefcat=" . intval($this->getDefaultCategory()) . ","
763 . " bdefskin=" . intval($this->getDefaultSkin()) . ","
764 . " bincludesearch=" . intval($this->getSearchable())
765 . " WHERE bnumber=" . intval($this->getID());
772 // update update file if requested
773 function updateUpdatefile() {
774 if ($this->getUpdateFile()) {
775 $f_update = fopen($this->getUpdateFile(),'w');
776 fputs($f_update,$this->getCorrectTime());
783 * Sends a XML-RPC ping message to Userland, so the weblog can
784 * show up in the weblogs.com updates-list
786 function sendUserlandPing() {
787 global $php_errormsg;
789 if ($this->pingUserland()) {
790 // testmessage for adding an item
791 $message = new xmlrpcmsg('weblogUpdates.ping',array(
792 new xmlrpcval($this->getName(),'string'),
793 new xmlrpcval($this->getURL(),'string')
796 $c = new xmlrpc_client('/RPC2', 'rpc.weblogs.com', 80);
800 $r = $c->send($message,15); // 15 seconds timeout...
802 if (($r == 0) && ($r->errno || $r->errstring)) {
803 return 'Error ' . $r->errno . ' : ' . $r->errstring;
804 } elseif (($r == 0) && ($php_errormsg)) {
805 return 'PHP Error: ' . $php_errormsg;
807 return 'Error while trying to send ping. Sorry about that.';
808 } elseif ($r->faultCode() != 0) {
809 return 'Error: ' . $r->faultString();
811 $r = $r->value(); // get response struct
813 $flerror = $r->structmem('flerror');
814 $flerror = $flerror->scalarval();
817 $message = $r->structmem('message');
818 $message = $message->scalarval();
821 return 'Error (flerror=1): ' . $message;
823 return 'Success: ' . $message;
828 function isValidCategory($catid) {
829 $query = 'SELECT * FROM '.sql_table('category').' WHERE cblog=' . $this->getID() . ' and catid=' . intval($catid);
830 $res = mysql_query($query);
831 return (mysql_num_rows($res) != 0);
834 function getCategoryName($catid) {
835 $res = mysql_query('SELECT cname FROM '.sql_table('category').' WHERE cblog='.$this->getID().' and catid=' . intval($catid));
836 $o = mysql_fetch_object($res);
840 function getCategoryDesc($catid) {
841 $res = mysql_query('SELECT cdesc FROM '.sql_table('category').' WHERE cblog='.$this->getID().' and catid=' . intval($catid));
842 $o = mysql_fetch_object($res);
846 function getCategoryIdFromName($name) {
847 $res = mysql_query('SELECT catid FROM '.sql_table('category').' WHERE cblog='.$this->getID().' and cname="' . addslashes($name) . '"');
848 if (mysql_num_rows($res) > 0) {
849 $o = mysql_fetch_object($res);
852 return $this->getDefaultCategory();
856 function pingUserland() {
857 return $this->getSetting('bsendping');
860 function setPingUserland($val) {
861 $this->setSetting('bsendping',$val);
864 function convertBreaks() {
865 return $this->getSetting('bconvertbreaks');
868 function insertJavaScriptInfo($authorid = '') {
869 global $member, $CONF;
872 $authorid = $member->getID();
875 <script type="text/javascript">
876 setConvertBreaks(<?php echo $this->convertBreaks() ? 'true' : 'false' ?>);
877 setMediaUrl("<?php echo $CONF['MediaURL']?>");
878 setAuthorId(<?php echo $authorid?>);
881 function setConvertBreaks($val) {
882 $this->setSetting('bconvertbreaks',$val);
884 function setAllowPastPosting($val) {
885 $this->setSetting('ballowpast',$val);
887 function allowPastPosting() {
888 return $this->getSetting('ballowpast');
891 function getCorrectTime($t=0) {
892 if ($t == 0) $t = time();
893 return ($t + 3600 * $this->getTimeOffset());
897 return $this->getSetting('bname');
900 function getShortName() {
901 return $this->getSetting('bshortname');
904 function getMaxComments() {
905 return $this->getSetting('bmaxcomments');
908 function getNotifyAddress() {
909 return $this->getSetting('bnotify');
912 function getNotifyType() {
913 return $this->getSetting('bnotifytype');
916 function notifyOnComment() {
917 $n = $this->getNotifyType();
918 return (($n != 0) && (($n % 3) == 0));
921 function notifyOnVote() {
922 $n = $this->getNotifyType();
923 return (($n != 0) && (($n % 5) == 0));
926 function notifyOnNewItem() {
927 $n = $this->getNotifyType();
928 return (($n != 0) && (($n % 7) == 0));
931 function setNotifyType($val) {
932 $this->setSetting('bnotifytype',$val);
936 function getTimeOffset() {
937 return $this->getSetting('btimeoffset');
940 function commentsEnabled() {
941 return $this->getSetting('bcomments');
945 return $this->getSetting('burl');
948 function getDefaultSkin() {
949 return $this->getSetting('bdefskin');
952 function getUpdateFile() {
953 return $this->getSetting('bupdate');
956 function getDescription() {
957 return $this->getSetting('bdesc');
960 function isPublic() {
961 return $this->getSetting('bpublic');
964 function emailRequired() {
965 return $this->getSetting('breqemail');
968 function getSearchable() {
969 return $this->getSetting('bincludesearch');
972 function getDefaultCategory() {
973 return $this->getSetting('bdefcat');
976 function setPublic($val) {
977 $this->setSetting('bpublic',$val);
980 function setSearchable($val) {
981 $this->setSetting('bincludesearch',$val);
984 function setDescription($val) {
985 $this->setSetting('bdesc',$val);
988 function setUpdateFile($val) {
989 $this->setSetting('bupdate',$val);
992 function setDefaultSkin($val) {
993 $this->setSetting('bdefskin',$val);
996 function setURL($val) {
997 $this->setSetting('burl',$val);
1000 function setName($val) {
1001 $this->setSetting('bname',$val);
1004 function setShortName($val) {
1005 $this->setSetting('bshortname',$val);
1008 function setCommentsEnabled($val) {
1009 $this->setSetting('bcomments',$val);
1012 function setMaxComments($val) {
1013 $this->setSetting('bmaxcomments',$val);
1016 function setNotifyAddress($val) {
1017 $this->setSetting('bnotify',$val);
1020 function setEmailRequired($val) {
1021 $this->setSetting('breqemail',$val);
1024 function setTimeOffset($val) {
1025 // check validity of value
1026 // 1. replace , by . (common mistake)
1027 $val = str_replace(',','.',$val);
1028 // 2. cast to float or int
1029 if (is_numeric($val) && strstr($val,'.5')) {
1030 $val = (float) $val;
1032 $val = intval($val);
1035 $this->setSetting('btimeoffset',$val);
1038 function setDefaultCategory($val) {
1039 $this->setSetting('bdefcat',$val);
1042 function getSetting($key) {
1043 return $this->settings[$key];
1046 function setSetting($key,$value) {
1047 $this->settings[$key] = $value;
1051 // tries to add a member to the team. Returns false if the member was already on
1053 function addTeamMember($memberid, $admin) {
1056 $memberid = intval($memberid);
1057 $admin = intval($admin);
1059 // check if member is already a member
1060 $tmem = MEMBER::createFromID($memberid);
1062 if ($tmem->isTeamMember($this->getID()))
1075 $query = 'INSERT INTO '.sql_table('team').' (TMEMBER, TBLOG, TADMIN) '
1076 . 'VALUES (' . $memberid .', '.$this->getID().', "'.$admin.'")';
1080 'PostAddTeamMember',
1089 ACTIONLOG::add(INFO, 'Added ' . $tmem->getDisplayName() . ' (ID=' .
1090 $memberid .') to the team of blog "' . $this->getName() . '"');
1096 return intVal($this->blogid);
1099 // returns true if there is a blog with the given shortname (static)
1100 function exists($name) {
1101 $r = sql_query('select * FROM '.sql_table('blog').' WHERE bshortname="'.addslashes($name).'"');
1102 return (mysql_num_rows($r) != 0);
1105 // returns true if there is a blog with the given ID (static)
1106 function existsID($id) {
1107 $r = sql_query('select * FROM '.sql_table('blog').' WHERE bnumber='.intval($id));
1108 return (mysql_num_rows($r) != 0);