OSDN Git Service

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