OSDN Git Service

Fix revision 1155, not to include itemid in sent message.
[nucleus-jp/nucleus-jp-ancient.git] / utf8 / nucleus / libs / BLOG.php
1 <?php
2
3 /*
4  * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)
5  * Copyright (C) 2002-2011 The Nucleus Group
6  *
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)
12  */
13 /**
14  * A class representing a blog and containing functions to get that blog shown
15  * on the screen
16  *
17  * @license http://nucleuscms.org/license.txt GNU General Public License
18  * @copyright Copyright (C) 2002-2011 The Nucleus Group
19  * @version $Id$
20  * $NucleusJP: BLOG.php,v 1.12.2.2 2007/08/08 05:26:22 kimitake Exp $
21  */
22
23 if ( !function_exists('requestVar') ) exit;
24 require_once dirname(__FILE__) . '/ITEMACTIONS.php';
25
26 class BLOG {
27
28         // blog id
29         var $blogid;
30
31         // ID of currently selected category
32         var $selectedcatid;
33
34         // After creating an object of the blog class, contains true if the BLOG object is
35         // valid (the blog exists)
36         var $isValid;
37
38         // associative array, containing all blogsettings (use the get/set functions instead)
39         var $settings;
40
41         /**
42          * Creates a new BLOG object for the given blog
43          *
44          * @param $id blogid
45          */
46         function BLOG($id) {
47                 $this->blogid = intval($id);
48                 $this->readSettings();
49
50                 // try to set catid
51                 // (the parse functions in SKIN.php will override this, so it's mainly useless)
52                 global $catid;
53                 $this->setSelectedCategory($catid);
54         }
55
56         /**
57          * Shows the given amount of items for this blog
58          *
59          * @param $template
60          *        String representing the template _NAME_ (!)
61          * @param $amountEntries
62          *        amount of entries to show
63          * @param $startpos
64          *        offset from where items should be shown (e.g. 5 = start at fifth item)
65          * @returns int
66          *        amount of items shown
67          */
68         function readLog($template, $amountEntries, $offset = 0, $startpos = 0) {
69                 return $this->readLogAmount($template,$amountEntries,'','',1,1,$offset, $startpos);
70         }
71
72         /**
73          * Shows an archive for a given month
74          *
75          * @param $year
76          *        year
77          * @param $month
78          *        month
79          * @param $template
80          *        String representing the template name to be used
81          */
82         function showArchive($templatename, $year, $month = 0, $day = 0) {
83
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
91                 } else {
92                         $timestamp_start = mktime(0,0,0,$month,$day,$year);
93                         $timestamp_end = mktime(0,0,0,$month,$day+1,$year);
94                 }
95                 $extra_query = ' and i.itime>=' . mysqldate($timestamp_start)
96                                          . ' and i.itime<' . mysqldate($timestamp_end);
97
98
99                 $this->readLogAmount($templatename,0,$extra_query,'',1,1);
100
101         }
102
103
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);
108         }
109
110         function setSelectedCategoryByName($catname) {
111                 $this->setSelectedCategory($this->getCategoryIdFromName($catname));
112         }
113
114         function getSelectedCategory() {
115                 return $this->selectedcatid;
116         }
117
118         /**
119          * Shows the given amount of items for this blog
120          *
121          * @param $template
122          *        String representing the template _NAME_ (!)
123          * @param $amountEntries
124          *        amount of entries to show (0 = no limit)
125          * @param $extraQuery
126          *        extra conditions to be added to the query
127          * @param $highlight
128          *        contains a query that should be highlighted
129          * @param $comments
130          *        1=show comments 0=don't show comments
131          * @param $dateheads
132          *        1=show dateheads 0=don't show dateheads
133          * @param $offset
134          *        offset
135          * @returns int
136          *        amount of items shown
137          */
138         function readLogAmount($template, $amountEntries, $extraQuery, $highlight, $comments, $dateheads, $offset = 0, $startpos = 0) {
139
140                 $query = $this->getSqlBlog($extraQuery);
141
142                 if ($amountEntries > 0) {
143                                 // $offset zou moeten worden:
144                                 // (($startpos / $amountentries) + 1) * $offset ... later testen ...
145                            $query .= ' LIMIT ' . intval($startpos + $offset).',' . intval($amountEntries);
146                 }
147                 return $this->showUsingQuery($template, $query, $highlight, $comments, $dateheads);
148         }
149
150         function showUsingQuery($templateName, $query, $highlight = '', $comments = 0, $dateheads = 1) {
151                 global $CONF, $manager;
152
153                 $lastVisit = cookieVar($CONF['CookiePrefix'] .'lastVisit');
154                 if ($lastVisit != 0)
155                         $lastVisit = $this->getCorrectTime($lastVisit);
156
157                 // set templatename as global variable (so plugins can access it)
158                 global $currentTemplateName;
159                 $currentTemplateName = $templateName;
160
161                 $template =& $manager->getTemplate($templateName);
162
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);
171
172                 // execute query
173                 $items = sql_query($query);
174
175                 // loop over all items
176                 $old_date = 0;
177                 while ($item = sql_fetch_object($items)) {
178
179                         $item->timestamp = strtotime($item->itime); // string timestamp -> unix timestamp
180
181                         // action handler needs to know the item we're handling
182                         $actions->setCurrentItem($item);
183
184                         // add date header if needed
185                         if ($dateheads) {
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 = strftimejp(isset($template['DATE_FOOTER'])?$template['DATE_FOOTER']:'', $oldTS);
194                                                 $parser->parse($tmp_footer);
195                                                 $manager->notify('PostDateFoot',array('blog' => &$this, 'timestamp' => $oldTS));
196                                         }
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 = strftimejp((isset($template['DATE_HEADER']) ? $template['DATE_HEADER'] : null), $timestamp);
201                                         $parser->parse($tmp_header);
202                                         $manager->notify('PostDateHead',array('blog' => &$this, 'timestamp' => $timestamp));
203                                 }
204                                 $old_date = $new_date;
205                         }
206
207                         // parse item
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']);
213
214                 }
215
216                 $numrows = sql_num_rows($items);
217
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)));
223                 }
224
225                 sql_free_result($items);        // free memory
226
227                 return $numrows;
228
229         }
230
231         function showOneitem($itemid, $template, $highlight) {
232                 $extraQuery = ' and inumber=' . intval($itemid);
233
234                 return $this->readLogAmount($template, 1, $extraQuery, $highlight, 0, 0);
235         }
236
237
238         /**
239           * Adds an item to this blog
240           */
241         function additem($catid, $title, $body, $more, $blogid, $authorid, $timestamp, $closed, $draft, $posted='1') {
242                 global $manager;
243
244                 $blogid  = intval($blogid);
245                 $authorid   = intval($authorid);
246                 $title    = $title;
247                 $body      = $body;
248                 $more      = $more;
249                 $catid    = intval($catid);
250
251                 // convert newlines to <br />
252                 if ($this->convertBreaks()) {
253                         $body = addBreaks($body);
254                         $more = addBreaks($more);
255                 }
256
257                 if ($closed != '1') $closed = '0';
258                 if ($draft != '0') $draft = '1';
259
260                 if (!$this->isValidCategory($catid))
261                         $catid = $this->getDefaultCategory();
262
263                 if ($timestamp > $this->getCorrectTime())
264                         $isFuture = 1;
265
266                 $timestamp = date('Y-m-d H:i:s',$timestamp);
267
268                 $manager->notify('PreAddItem',array('title' => &$title, 'body' => &$body, 'more' => &$more, 'blog' => &$this, 'authorid' => &$authorid, 'timestamp' => &$timestamp, 'closed' => &$closed, 'draft' => &$draft, 'catid' => &$catid));
269
270                 $ititle = sql_real_escape_string($title);
271                 $ibody = sql_real_escape_string($body);
272                 $imore = sql_real_escape_string($more);
273
274                 $query = 'INSERT INTO '.sql_table('item').' (ITITLE, IBODY, IMORE, IBLOG, IAUTHOR, ITIME, ICLOSED, IDRAFT, ICAT, IPOSTED) '
275                            . "VALUES ('$ititle', '$ibody', '$imore', $blogid, $authorid, '$timestamp', $closed, $draft, $catid, $posted)";
276                 sql_query($query);
277                 $itemid = sql_insert_id();
278
279                 $manager->notify('PostAddItem',array('itemid' => $itemid));
280
281                 if (!$draft)
282                         $this->updateUpdateFile();
283
284                 // send notification mail
285                 if (!$draft && !$isFuture && $this->getNotifyAddress() && $this->notifyOnNewItem())
286                         $this->sendNewItemNotification($itemid, $title, $body);
287
288                         return $itemid;
289         }
290
291         function sendNewItemNotification($itemid, $title, $body) {
292                 global $CONF, $member;
293
294                 // create text version of html post
295                 $ascii = toAscii($body);
296
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";
302                 } else {
303                         $tempurl = $this->getURL();
304                         if (substr($tempurl, -1) == '/' || substr($tempurl, -4) == '.php') {
305                                 $mailto_msg .= $tempurl . '?itemid=' . $itemid . "\n\n";
306                         } else {
307                                 $mailto_msg .= $tempurl . '/?itemid=' . $itemid . "\n\n";
308                         }
309                 }
310                 $mailto_msg .= _NOTIFY_TITLE . ' ' . strip_tags($title) . "\n";
311                 $mailto_msg .= _NOTIFY_CONTENTS . "\n " . $ascii . "\n";
312                 $mailto_msg .= getMailFooter();
313
314                 $mailto_title = $this->getName() . ': ' . _NOTIFY_NI_TITLE;
315
316                 $frommail = $member->getNotifyFromMailAddress();
317
318                 $notify =& new NOTIFICATION($this->getNotifyAddress());
319                 $notify->notify($mailto_title, $mailto_msg , $frommail);
320
321
322
323         }
324
325
326         /**
327           * Creates a new category for this blog
328           *
329           * @param $catName
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'
334           *
335           * @returns
336           *      the new category-id in case of success.
337           *      0 on failure
338           */
339         function createNewCategory($catName = '', $catDescription = _CREATED_NEW_CATEGORY_DESC) {
340                 global $member, $manager;
341
342                 if ($member->blogAdminRights($this->getID())) {
343                         // generate
344                         if ($catName == '')
345                         {
346                                 $catName = _CREATED_NEW_CATEGORY_NAME;
347                                 $i = 1;
348
349                                 $res = sql_query('SELECT * FROM '.sql_table('category')." WHERE cname='".$catName.$i."' and cblog=".$this->getID());
350                                 while (sql_num_rows($res) > 0)
351                                 {
352                                         $i++;
353                                         $res = sql_query('SELECT * FROM '.sql_table('category')." WHERE cname='".$catName.$i."' and cblog=".$this->getID());
354                                 }
355
356                                 $catName = $catName . $i;
357                         }
358
359                         $manager->notify(
360                                 'PreAddCategory',
361                                 array(
362                                         'blog' => &$this,
363                                         'name' => &$catName,
364                                         'description' => $catDescription
365                                 )
366                         );
367
368                         $query = 'INSERT INTO '.sql_table('category').' (cblog, cname, cdesc) VALUES (' . $this->getID() . ", '" . sql_real_escape_string($catName) . "', '" . sql_real_escape_string($catDescription) . "')";
369                         sql_query($query);
370                         $catid = sql_insert_id();
371
372                         $manager->notify(
373                                 'PostAddCategory',
374                                 array(
375                                         'blog' => &$this,
376                                         'name' => $catName,
377                                         'description' => $catDescription,
378                                         'catid' => $catid
379                                 )
380                         );
381
382                         return $catid;
383                 } else {
384                         return 0;
385                 }
386
387         }
388
389
390         /**
391          * Searches all months of this blog for the given query
392          *
393          * @param $query
394          *        search query
395          * @param $template
396          *        template to be used (__NAME__ of the template)
397          * @param $amountMonths
398          *        max amount of months to be search (0 = all)
399          * @param $maxresults
400          *        max number of results to show
401          * @param $startpos
402          *        offset
403          * @returns
404          *        amount of hits found
405          */
406         function search($query, $template, $amountMonths, $maxresults, $startpos) {
407                 global $CONF, $manager;
408
409                 $highlight  = '';
410                 $sqlquery   = $this->getSqlSearch($query, $amountMonths, $highlight);
411
412                 if ($sqlquery == '')
413                 {
414                         // no query -> show everything
415                         $extraquery = '';
416                         $amountfound = $this->readLogAmount($template, $maxresults, $extraQuery, $query, 1, 1);
417                 } else {
418
419                         // add LIMIT to query (to split search results into pages)
420                         if (intval($maxresults > 0))
421                                 $sqlquery .= ' LIMIT ' . intval($startpos).',' . intval($maxresults);
422
423                         // show results
424                         $amountfound = $this->showUsingQuery($template, $sqlquery, $highlight, 1, 1);
425
426                         // when no results were found, show a message
427                         if ($amountfound == 0)
428                         {
429                                 $template =& $manager->getTemplate($template);
430                                 $vars = array(
431                                         'query'  => htmlspecialchars($query),
432                                         'blogid'        => $this->getID()
433                                 );
434                                 echo TEMPLATE::fill($template['SEARCH_NOTHINGFOUND'],$vars);
435                         }
436                 }
437
438                 return $amountfound;
439         }
440
441         /**
442          * Returns an SQL query to use for a search query
443          *
444          * @param $query
445          *        search query
446          * @param $amountMonths
447          *        amount of months to search back. Default = 0 = unlimited
448          * @param $mode
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)
452          * @returns
453          *        either a full SQL query, or an empty string (if querystring empty)
454          * @note
455          *        No LIMIT clause is added. (caller should add this if multiple pages are requested)
456          */
457         function getSqlSearch($query, $amountMonths = 0, &$highlight, $mode = '')
458         {
459                 $searchclass =& new SEARCH($query);
460
461                 $highlight      = $searchclass->inclusive;
462
463                 // if querystring is empty, return empty string
464                 if ($searchclass->inclusive == '')
465                         return '';
466
467
468                 $where  = $searchclass->boolean_sql_where('ititle,ibody,imore');
469                 $select = $searchclass->boolean_sql_select('ititle,ibody,imore');
470
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
475                 $selectblogs = '';
476                 if (count($blogs) > 0)
477                         $selectblogs = ' and i.iblog in (' . implode(',', $blogs) . ')';
478
479                 if ($mode == '')
480                 {
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';
482                         if ($select)
483                                 $query .= ', '.$select. ' as score ';
484                 } else {
485                         $query = 'SELECT COUNT(*) as result ';
486                 }
487
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
492                            . $selectblogs
493                                         // don't show future items
494                            . ' and i.itime<=' . mysqldate($this->getCorrectTime())
495                            . ' and '.$where;
496
497                 // take into account amount of months to search
498                 if ($amountMonths > 0)
499                 {
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);
503                 }
504
505                 if ($mode == '')
506                 {
507                         if ($select)
508                                 $query .= ' ORDER BY score DESC';
509                         else
510                                 $query .= ' ORDER BY i.itime DESC ';
511                 }
512
513                 return $query;
514         }
515
516         /**
517          * Returns the SQL query that's normally used to display the blog items on the index type skins
518          *
519          * @param $mode
520          *        either empty, or 'count'. In this case, the query will be a SELECT COUNT(*) query
521          * @returns
522          *        either a full SQL query, or an empty string
523          * @note
524          *        No LIMIT clause is added. (caller should add this if multiple pages are requested)
525          */
526         function getSqlBlog($extraQuery, $mode = '')
527         {
528                 if ($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';
530                 else
531                         $query = 'SELECT COUNT(*) as result ';
532
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());
540
541                 if ($this->getSelectedCategory())
542                         $query .= ' and i.icat=' . $this->getSelectedCategory() . ' ';
543
544
545                 $query .= $extraQuery;
546
547                 if ($mode == '')
548                         $query .= ' ORDER BY i.itime DESC';
549
550                 return $query;
551         }
552
553         /**
554           * Shows the archivelist using the given template
555           */
556         function showArchiveList($template, $mode = 'month', $limit = 0) {
557                 global $CONF, $catid, $manager;
558
559                 if (!isset ($linkparams)) {
560                 $linkparams = array();
561                 }
562
563                 if ($catid) {
564                         $linkparams = array('catid' => $catid);
565                 }
566
567                 $template =& $manager->getTemplate($template);
568                 $data['blogid'] = $this->getID();
569
570                 $tplt = isset($template['ARCHIVELIST_HEADER']) ? $template['ARCHIVELIST_HEADER']
571                                                                                                            : '';
572                 echo TEMPLATE::fill($tplt, $data);
573
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
578
579                 if ($catid)
580                         $query .= ' and icat=' . intval($catid);
581
582                 $query .= ' GROUP BY Year';
583                 if ($mode == 'month' || $mode == 'day')
584                         $query .= ', Month';
585                 if ($mode == 'day')
586                         $query .= ', Day';
587
588                 $query .= ' ORDER BY itime DESC';
589
590                 if ($limit > 0)
591                         $query .= ' LIMIT ' . intval($limit);
592
593                 $res = sql_query($query);
594
595                 while ($current = sql_fetch_object($res)) {
596                         $current->itime = strtotime($current->itime);   // string time -> unix timestamp
597
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);
606                                 $data['day']      = '';
607                                 $data['month']  = '';
608                                 $archive['day']   = '';
609                                 $archive['month'] = '';
610                         } else {
611                                 $archivedate = date('Y-m',$current->itime);
612                                 $data['month'] = date('m',$current->itime);
613                                 $archive['month'] = $data['month'];
614                                 $data['day'] = '';
615                                 $archive['day'] = '';
616                         }
617
618                         $data['year'] = date('Y',$current->itime);
619                         $archive['year'] = $data['year'];
620                         $data['archivelink'] = createArchiveLink($this->getID(),$archivedate,$linkparams);
621
622                         $manager->notify(
623                                 'PreArchiveListItem',
624                                 array(
625                                         'listitem' => &$data
626                                 )
627                         );
628
629                         $temp = TEMPLATE::fill($template['ARCHIVELIST_LISTITEM'],$data);
630                         echo strftimejp($temp,$current->itime);
631
632                 }
633
634                 sql_free_result($res);
635
636                 $tplt = isset($template['ARCHIVELIST_FOOTER']) ? $template['ARCHIVELIST_FOOTER']
637                                                                                                            : '';
638                 echo TEMPLATE::fill($tplt, $data);
639         }
640
641
642         /**
643           * Shows the list of categories using a given template
644           */
645         function showCategoryList($template) {
646                 global $CONF, $manager;
647
648                 // determine arguments next to catids
649                 // I guess this can be done in a better way, but it works
650                 global $archive, $archivelist;
651
652                 $linkparams = array();
653                 if ($archive) {
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;
660                 } else {
661                         $blogurl = createBlogidLink($this->getID(), '');
662                         $linkparams['blogid'] = $this->getID();
663                 }
664
665                 //$blogurl = $this->getURL() . $qargs;
666                 //$blogurl = createBlogLink($this->getURL(), $linkparams);
667
668                 $template =& $manager->getTemplate($template);
669
670                 //: Change: Set nocatselected variable
671                 if ($this->getSelectedCategory()) {
672                         $nocatselected = 'no';
673                 }
674                 else {
675                         $nocatselected = 'yes';
676                 } 
677
678                 echo TEMPLATE::fill((isset($template['CATLIST_HEADER']) ? $template['CATLIST_HEADER'] : null),
679                                                         array(
680                                                                 'blogid' => $this->getID(),
681                                                                 'blogurl' => $blogurl,
682                                                                 'self' => $CONF['Self'],
683                                                                 //: Change: Set catiscurrent template variable for header
684                                                                 'catiscurrent' => $nocatselected,
685                                                                 'currentcat' => $nocatselected 
686                                                         ));
687
688                 $query = 'SELECT catid, cdesc as catdesc, cname as catname FROM '.sql_table('category').' WHERE cblog=' . $this->getID() . ' ORDER BY cname ASC';
689                 $res = sql_query($query);
690
691
692                 while ($data = sql_fetch_assoc($res)) {
693                         $data['blogid'] = $this->getID();
694                         $data['blogurl'] = $blogurl;
695                         $data['catlink'] = createLink(
696                                                                 'category',
697                                                                 array(
698                                                                         'catid' => $data['catid'],
699                                                                         'name' => $data['catname'],
700                                                                         'extra' => $linkparams
701                                                                 )
702                                                         );
703                         $data['self'] = $CONF['Self'];
704                         
705                         //catiscurrent
706                         //: Change: Bugfix for catiscurrent logic so it gives catiscurrent = no when no category is selected.
707                         $data['catiscurrent'] = 'no';
708                         $data['currentcat'] = 'no'; 
709                         if ($this->getSelectedCategory()) {
710                                 if ($this->getSelectedCategory() == $data['catid']) {
711                                         $data['catiscurrent'] = 'yes';
712                                         $data['currentcat'] = 'yes';
713                                 }
714                                 /*else {
715                                         $data['catiscurrent'] = 'no';
716                                         $data['currentcat'] = 'no';
717                                 }*/
718                         }
719                         else {
720                                 global $itemid;
721                                 if (intval($itemid) && $manager->existsItem(intval($itemid),0,0)) {
722                                         $iobj =& $manager->getItem(intval($itemid),0,0);
723                                         $cid = $iobj['catid'];
724                                         if ($cid == $data['catid']) {
725                                                 $data['catiscurrent'] = 'yes';
726                                                 $data['currentcat'] = 'yes';
727                                         }
728                                         /*else {
729                                                 $data['catiscurrent'] = 'no';
730                                                 $data['currentcat'] = 'no';
731                                         }*/
732                                 }
733                         }
734
735                         $manager->notify(
736                                 'PreCategoryListItem',
737                                 array(
738                                         'listitem' => &$data
739                                 )
740                         );
741
742                         echo TEMPLATE::fill((isset($template['CATLIST_LISTITEM']) ? $template['CATLIST_LISTITEM'] : null), $data);
743                         //$temp = TEMPLATE::fill((isset($template['CATLIST_LISTITEM']) ? $template['CATLIST_LISTITEM'] : null), $data);
744                         //echo strftime($temp, $current->itime);
745
746                 }
747
748                 sql_free_result($res);
749
750                 echo TEMPLATE::fill((isset($template['CATLIST_FOOTER']) ? $template['CATLIST_FOOTER'] : null),
751                                                         array(
752                                                                 'blogid' => $this->getID(),
753                                                                 'blogurl' => $blogurl,
754                                                                 'self' => $CONF['Self']
755                                                         ));
756         }
757
758         /**
759           * Shows a list of all blogs in the system using a given template
760           * ordered by  number, name, shortname or description
761           * in ascending or descending order
762           */
763         function showBlogList($template, $bnametype, $orderby, $direction) {
764                 global $CONF, $manager;
765
766                 switch ($orderby) {
767                         case 'number':
768                                 $orderby='bnumber';
769                                 break;
770                         case 'name':
771                                 $orderby='bname';
772                                 break;
773                         case 'shortname':
774                                 $orderby='bshortname';
775                                 break;
776                         case 'description':
777                                 $orderby='bdesc';
778                                 break;
779                         default:
780                                 $orderby='bnumber';
781                                 break;
782                 }
783
784                 $direction=strtolower($direction);
785                 switch ($direction) {
786                         case 'asc':
787                                 $direction='ASC';
788                                 break;
789                         case 'desc':
790                                 $direction='DESC';
791                                 break;
792                         default:
793                                 $direction='ASC';
794                                 break;
795                 }
796
797                 $template =& $manager->getTemplate($template);
798
799                 echo TEMPLATE::fill((isset($template['BLOGLIST_HEADER']) ? $template['BLOGLIST_HEADER'] : null),
800                                                         array(
801                                                                 'sitename' => $CONF['SiteName'],
802                                                                 'siteurl' => $CONF['IndexURL']
803                                                         ));
804
805                 $query = 'SELECT bnumber, bname, bshortname, bdesc, burl FROM '.sql_table('blog').' ORDER BY '.$orderby.' '.$direction;
806                 $res = sql_query($query);
807
808                 while ($data = sql_fetch_assoc($res)) {
809
810                         $list = array();
811
812 //                      $list['bloglink'] = createLink('blog', array('blogid' => $data['bnumber']));
813                         $list['bloglink'] = createBlogidLink($data['bnumber']);
814
815                         $list['blogdesc'] = $data['bdesc'];
816
817                         $list['blogurl'] = $data['burl'];
818
819                         if ($bnametype=='shortname') {
820                                 $list['blogname'] = $data['bshortname'];
821                         }
822                         else { // all other cases
823                                 $list['blogname'] = $data['bname'];
824                         }
825
826                         $manager->notify(
827                                 'PreBlogListItem',
828                                 array(
829                                         'listitem' => &$list
830                                 )
831                         );
832
833                         echo TEMPLATE::fill((isset($template['BLOGLIST_LISTITEM']) ? $template['BLOGLIST_LISTITEM'] : null), $list);
834
835                 }
836
837                 sql_free_result($res);
838
839                 echo TEMPLATE::fill((isset($template['BLOGLIST_FOOTER']) ? $template['BLOGLIST_FOOTER'] : null),
840                                                         array(
841                                                                 'sitename' => $CONF['SiteName'],
842                                                                 'siteurl' => $CONF['IndexURL']
843                                                         ));
844
845         }
846
847         /**
848           * Blogsettings functions
849           */
850
851         function readSettings() {
852                 $query =  'SELECT *'
853                            . ' FROM '.sql_table('blog')
854                            . ' WHERE bnumber=' . $this->blogid;
855                 $res = sql_query($query);
856
857                 $this->isValid = (sql_num_rows($res) > 0);
858                 if (!$this->isValid)
859                         return;
860
861                 $this->settings = sql_fetch_assoc($res);
862         }
863
864         function writeSettings() {
865
866                 // (can't use floatval since not available prior to PHP 4.2)
867                 $offset = $this->getTimeOffset();
868                 if (!is_float($offset))
869                         $offset = intval($offset);
870
871                 $query =  'UPDATE '.sql_table('blog')
872                            . " SET bname='" . sql_real_escape_string($this->getName()) . "',"
873                            . "   bshortname='". sql_real_escape_string($this->getShortName()) . "',"
874                            . "   bcomments=". intval($this->commentsEnabled()) . ","
875                            . "   bmaxcomments=" . intval($this->getMaxComments()) . ","
876                            . "   btimeoffset=" . $offset . ","
877                            . "   bpublic=" . intval($this->isPublic()) . ","
878                            . "   breqemail=" . intval($this->emailRequired()) . ","
879                            . "   bconvertbreaks=" . intval($this->convertBreaks()) . ","
880                            . "   ballowpast=" . intval($this->allowPastPosting()) . ","
881                            . "   bnotify='" . sql_real_escape_string($this->getNotifyAddress()) . "',"
882                            . "   bnotifytype=" . intval($this->getNotifyType()) . ","
883                            . "   burl='" . sql_real_escape_string($this->getURL()) . "',"
884                            . "   bupdate='" . sql_real_escape_string($this->getUpdateFile()) . "',"
885                            . "   bdesc='" . sql_real_escape_string($this->getDescription()) . "',"
886                            . "   bdefcat=" . intval($this->getDefaultCategory()) . ","
887                            . "   bdefskin=" . intval($this->getDefaultSkin()) . ","
888                            . "   bincludesearch=" . intval($this->getSearchable())
889                            . " WHERE bnumber=" . intval($this->getID());
890                 sql_query($query);
891
892         }
893
894
895
896         // update update file if requested
897         function updateUpdatefile() {
898                  if ($this->getUpdateFile()) {
899                         $f_update = fopen($this->getUpdateFile(),'w');
900                         fputs($f_update,$this->getCorrectTime());
901                         fclose($f_update);
902                  }
903
904         }
905
906         function isValidCategory($catid) {
907                 $query = 'SELECT * FROM '.sql_table('category').' WHERE cblog=' . $this->getID() . ' and catid=' . intval($catid);
908                 $res = sql_query($query);
909                 return (sql_num_rows($res) != 0);
910         }
911
912         function getCategoryName($catid) {
913                 $res = sql_query('SELECT cname FROM '.sql_table('category').' WHERE cblog='.$this->getID().' and catid=' . intval($catid));
914                 $o = sql_fetch_object($res);
915                 return $o->cname;
916         }
917
918         function getCategoryDesc($catid) {
919                 $res = sql_query('SELECT cdesc FROM '.sql_table('category').' WHERE cblog='.$this->getID().' and catid=' . intval($catid));
920                 $o = sql_fetch_object($res);
921                 return $o->cdesc;
922         }
923
924         function getCategoryIdFromName($name) {
925                 $res = sql_query('SELECT catid FROM '.sql_table('category').' WHERE cblog='.$this->getID().' and cname="' . sql_real_escape_string($name) . '"');
926                 if (sql_num_rows($res) > 0) {
927                         $o = sql_fetch_object($res);
928                         return $o->catid;
929                 } else {
930                         return $this->getDefaultCategory();
931                 }
932         }
933
934         function convertBreaks() {
935                 return $this->getSetting('bconvertbreaks');
936         }
937
938         function insertJavaScriptInfo($authorid = '') {
939                 global $member, $CONF;
940
941                 if ($authorid == '')
942                         $authorid = $member->getID();
943
944                 ?>
945                 <script type="text/javascript">
946                         setConvertBreaks(<?php echo  $this->convertBreaks() ? 'true' : 'false' ?>);
947                         setMediaUrl("<?php echo $CONF['MediaURL']?>");
948                         setAuthorId(<?php echo $authorid?>);
949                 </script><?php  }
950
951         function setConvertBreaks($val) {
952                 $this->setSetting('bconvertbreaks',$val);
953         }
954         function setAllowPastPosting($val) {
955                 $this->setSetting('ballowpast',$val);
956         }
957         function allowPastPosting() {
958                 return $this->getSetting('ballowpast');
959         }
960
961         function getCorrectTime($t=0) {
962                 if ($t == 0) $t = time();
963                 return ($t + 3600 * $this->getTimeOffset());
964         }
965
966         function getName() {
967                 return $this->getSetting('bname');
968         }
969
970         function getShortName() {
971                 return $this->getSetting('bshortname');
972         }
973
974         function getMaxComments() {
975                 return $this->getSetting('bmaxcomments');
976         }
977
978         function getNotifyAddress() {
979                 return $this->getSetting('bnotify');
980         }
981
982         function getNotifyType() {
983                 return $this->getSetting('bnotifytype');
984         }
985
986         function notifyOnComment() {
987                 $n = $this->getNotifyType();
988                 return (($n != 0) && (($n % 3) == 0));
989         }
990
991         function notifyOnVote() {
992                 $n = $this->getNotifyType();
993                 return (($n != 0) && (($n % 5) == 0));
994         }
995
996         function notifyOnNewItem() {
997                 $n = $this->getNotifyType();
998                 return (($n != 0) && (($n % 7) == 0));
999         }
1000
1001         function setNotifyType($val) {
1002                 $this->setSetting('bnotifytype',$val);
1003         }
1004
1005
1006         function getTimeOffset() {
1007                 return $this->getSetting('btimeoffset');
1008         }
1009
1010         function commentsEnabled() {
1011                 return $this->getSetting('bcomments');
1012         }
1013
1014         function getURL() {
1015                 return $this->getSetting('burl');
1016         }
1017
1018         function getDefaultSkin() {
1019                 return $this->getSetting('bdefskin');
1020         }
1021
1022         function getUpdateFile() {
1023                 return $this->getSetting('bupdate');
1024         }
1025
1026         function getDescription() {
1027                 return $this->getSetting('bdesc');
1028         }
1029
1030         function isPublic() {
1031                 return $this->getSetting('bpublic');
1032         }
1033
1034         function emailRequired() {
1035                 return $this->getSetting('breqemail');
1036         }
1037
1038         function getSearchable() {
1039                 return $this->getSetting('bincludesearch');
1040         }
1041
1042         function getDefaultCategory() {
1043                 return $this->getSetting('bdefcat');
1044         }
1045
1046         function setPublic($val) {
1047                 $this->setSetting('bpublic',$val);
1048         }
1049
1050         function setSearchable($val) {
1051                 $this->setSetting('bincludesearch',$val);
1052         }
1053
1054         function setDescription($val) {
1055                 $this->setSetting('bdesc',$val);
1056         }
1057
1058         function setUpdateFile($val) {
1059                 $this->setSetting('bupdate',$val);
1060         }
1061
1062         function setDefaultSkin($val) {
1063                 $this->setSetting('bdefskin',$val);
1064         }
1065
1066         function setURL($val) {
1067                 $this->setSetting('burl',$val);
1068         }
1069
1070         function setName($val) {
1071                 $this->setSetting('bname',$val);
1072         }
1073
1074         function setShortName($val) {
1075                 $this->setSetting('bshortname',$val);
1076         }
1077
1078         function setCommentsEnabled($val) {
1079                 $this->setSetting('bcomments',$val);
1080         }
1081
1082         function setMaxComments($val) {
1083                 $this->setSetting('bmaxcomments',$val);
1084         }
1085
1086         function setNotifyAddress($val) {
1087                 $this->setSetting('bnotify',$val);
1088         }
1089
1090         function setEmailRequired($val) {
1091                 $this->setSetting('breqemail',$val);
1092         }
1093
1094         function setTimeOffset($val) {
1095                 // check validity of value
1096                 // 1. replace , by . (common mistake)
1097                 $val = str_replace(',','.',$val);
1098                 // 2. cast to float or int
1099                 if (is_numeric($val) && strstr($val,'.5')) {
1100                         $val = (float) $val;
1101                 } else {
1102                         $val = intval($val);
1103                 }
1104
1105                 $this->setSetting('btimeoffset',$val);
1106         }
1107
1108         function setDefaultCategory($val) {
1109                 $this->setSetting('bdefcat',$val);
1110         }
1111
1112         function getSetting($key) {
1113                 return $this->settings[$key];
1114         }
1115
1116         function setSetting($key,$value) {
1117                 $this->settings[$key] = $value;
1118         }
1119
1120
1121         // tries to add a member to the team. Returns false if the member was already on
1122         // the team
1123         function addTeamMember($memberid, $admin) {
1124                 global $manager;
1125
1126                 $memberid = intval($memberid);
1127                 $admin = intval($admin);
1128
1129                 // check if member is already a member
1130                 $tmem = MEMBER::createFromID($memberid);
1131
1132                 if ($tmem->isTeamMember($this->getID()))
1133                         return 0;
1134
1135                 $manager->notify(
1136                         'PreAddTeamMember',
1137                         array(
1138                                 'blog' => &$this,
1139                                 'member' => &$tmem,
1140                                 'admin' => &$admin
1141                         )
1142                 );
1143
1144                 // add to team
1145                 $query = 'INSERT INTO '.sql_table('team').' (TMEMBER, TBLOG, TADMIN) '
1146                            . 'VALUES (' . $memberid .', '.$this->getID().', "'.$admin.'")';
1147                 sql_query($query);
1148
1149                 $manager->notify(
1150                         'PostAddTeamMember',
1151                         array(
1152                                 'blog' => &$this,
1153                                 'member' => &$tmem,
1154                                 'admin' => $admin
1155                         )
1156
1157                 );
1158
1159                 $logMsg = sprintf(_TEAM_ADD_NEWTEAMMEMBER, $tmem->getDisplayName(), $memberid, $this->getName());
1160                 ACTIONLOG::add(INFO, $logMsg);
1161
1162                 return 1;
1163         }
1164
1165         function getID() {
1166                 return intVal($this->blogid);
1167         }
1168
1169         // returns true if there is a blog with the given shortname (static)
1170         function exists($name) {
1171                 $r = sql_query('select * FROM '.sql_table('blog').' WHERE bshortname="'.sql_real_escape_string($name).'"');
1172                 return (sql_num_rows($r) != 0);
1173         }
1174
1175         // returns true if there is a blog with the given ID (static)
1176         function existsID($id) {
1177                 $r = sql_query('select * FROM '.sql_table('blog').' WHERE bnumber='.intval($id));
1178                 return (sql_num_rows($r) != 0);
1179         }
1180
1181                 // flag there is a future post pending
1182                 function setFuturePost() {
1183                 $query =  'UPDATE '.sql_table('blog')
1184                            . " SET bfuturepost='1' WHERE bnumber=" . $this->getID();
1185                 sql_query($query);
1186                 }
1187
1188         // clear there is a future post pending
1189         function clearFuturePost() {
1190                 $query =  'UPDATE '.sql_table('blog')
1191                            . " SET bfuturepost='0' WHERE bnumber=" . $this->getID();
1192                 sql_query($query);
1193         }
1194
1195         // check if we should throw justPosted event
1196         function checkJustPosted() {
1197                 global $manager;
1198
1199                 if ($this->settings['bfuturepost'] == 1) {
1200                         $blogid = $this->getID();
1201                         $result = sql_query("SELECT * FROM " . sql_table('item')
1202                                           . " WHERE iposted=0 AND iblog=" . $blogid . " AND itime<NOW()");
1203                         if (sql_num_rows($result) > 0) {
1204                                 // This $pinged is allow a plugin to tell other hook to the event that a ping is sent already
1205                                 // Note that the plugins's calling order is subject to thri order in the plugin list
1206                                 $pinged = false;
1207                                 $manager->notify(
1208                                                 'JustPosted',
1209                                                 array('blogid' => $blogid,
1210                                                 'pinged' => &$pinged
1211                                                 )
1212                                 );
1213
1214                                 // clear all expired future posts
1215                                 sql_query("UPDATE " . sql_table('item') . " SET iposted='1' WHERE iblog=" . $blogid . " AND itime<NOW()");
1216
1217                                 // check to see any pending future post, clear the flag is none
1218                                 $result = sql_query("SELECT * FROM " . sql_table('item')
1219                                                   . " WHERE iposted=0 AND iblog=" . $blogid);
1220                                 if (sql_num_rows($result) == 0) {
1221                                         $this->clearFuturePost();
1222                                 }
1223                         }
1224                 }
1225         }
1226
1227         /**
1228          * Shows the given list of items for this blog
1229          *
1230          * @param $itemarray
1231          *        array of item numbers to be displayed
1232          * @param $template
1233          *        String representing the template _NAME_ (!)
1234          * @param $highlight
1235          *        contains a query that should be highlighted
1236          * @param $comments
1237          *        1=show comments 0=don't show comments
1238          * @param $dateheads
1239          *        1=show dateheads 0=don't show dateheads
1240          * @param $showDrafts
1241          *              0=do not show drafts 1=show drafts
1242          * @param $showFuture
1243          *              0=do not show future posts 1=show future posts
1244          * @returns int
1245          *        amount of items shown
1246          */
1247         function readLogFromList($itemarray, $template, $highlight = '', $comments = 1, $dateheads = 1,$showDrafts = 0, $showFuture = 0) {
1248                 
1249                 $query = $this->getSqlItemList($itemarray,$showDrafts,$showFuture);
1250                 
1251                 return $this->showUsingQuery($template, $query, $highlight, $comments, $dateheads);
1252         }
1253
1254         /**
1255          * Returns the SQL query used to fill out templates for a list of items
1256          *
1257          * @param $itemarray
1258          *        an array holding the item numbers of the items to be displayed
1259          * @param $showDrafts
1260          *              0=do not show drafts 1=show drafts
1261          * @param $showFuture
1262          *              0=do not show future posts 1=show future posts
1263          * @returns
1264          *        either a full SQL query, or an empty string
1265          * @note
1266          *        No LIMIT clause is added. (caller should add this if multiple pages are requested)
1267          */
1268         function getSqlItemList($itemarray,$showDrafts = 0,$showFuture = 0)
1269         {
1270                 if (!is_array($itemarray)) return '';
1271                 $showDrafts = intval($showDrafts);
1272                 $showFuture = intval($showFuture);
1273                 $items = array();
1274                 foreach ($itemarray as $value) {
1275                         if (intval($value)) $items[] = intval($value);
1276                 }
1277                 if (!count($items)) return '';
1278                 //$itemlist = implode(',',$items);
1279                 $i = count($items);
1280                 $query = '';
1281                 foreach ($items as $value) {
1282                         $query .= '('
1283                                         .   'SELECT'
1284                                         .   ' i.inumber as itemid,'
1285                                         .   ' i.ititle as title,'
1286                                         .   ' i.ibody as body,'
1287                                         .   ' m.mname as author,'
1288                                         .   ' m.mrealname as authorname,'
1289                                         .   ' i.itime,'
1290                                         .   ' i.imore as more,'
1291                                         .   ' m.mnumber as authorid,'
1292                                         .   ' m.memail as authormail,'
1293                                         .   ' m.murl as authorurl,'
1294                                         .   ' c.cname as category,'
1295                                         .   ' i.icat as catid,'
1296                                         .   ' i.iclosed as closed';
1297
1298                         $query .= ' FROM '
1299                                         . sql_table('item') . ' as i, '
1300                                         . sql_table('member') . ' as m, '
1301                                         . sql_table('category').' as c'
1302                                         . ' WHERE'
1303                                         .        ' i.iblog   = ' . $this->blogid
1304                                         . ' and i.iauthor = m.mnumber'
1305                                         . ' and i.icat  = c.catid';
1306                         
1307                         if (!$showDrafts) $query .= ' and i.idraft=0';  // exclude drafts
1308                         if (!$showFuture) $query .= ' and i.itime<=' . mysqldate($this->getCorrectTime()); // don't show future items
1309
1310                         //$query .= ' and i.inumber IN ('.$itemlist.')';
1311                         $query .= ' and i.inumber = '.intval($value);
1312                         $query .= ')';
1313                         $i--;
1314                         if ($i) $query .= ' UNION ';
1315                 }
1316
1317                 return $query;
1318         }
1319
1320 }
1321
1322 ?>