4 * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)
\r
5 * Copyright (C) 2002-2012 The Nucleus Group
\r
7 * This program is free software; you can redistribute it and/or
\r
8 * modify it under the terms of the GNU General Public License
\r
9 * as published by the Free Software Foundation; either version 2
\r
10 * of the License, or (at your option) any later version.
\r
11 * (see nucleus/documentation/index.html#license for more info)
\r
14 * A class representing an item
\r
16 * @license http://nucleuscms.org/license.txt GNU General Public License
\r
17 * @copyright Copyright (C) 2002-2012 The Nucleus Group
\r
19 * $NucleusJP: ITEM.php,v 1.7.2.3 2008/02/07 06:13:30 kimitake Exp $
\r
26 * Constructor of an ITEM object
\r
28 * @param integer $itemid id of the item
\r
30 function ITEM($itemid) {
\r
31 $this->itemid = $itemid;
\r
35 * Returns one item with the specific itemid
\r
37 * @param integer $itemid id of the item
\r
38 * @param boolean $allowdraft
\r
39 * @param boolean $allowfuture
\r
42 function getitem($itemid, $allowdraft, $allowfuture) {
\r
45 $itemid = intval($itemid);
\r
47 $query = 'SELECT i.idraft as draft, i.inumber as itemid, i.iclosed as closed, '
\r
48 . ' i.ititle as title, i.ibody as body, m.mname as author, '
\r
49 . ' i.iauthor as authorid, i.itime, i.imore as more, i.ikarmapos as karmapos, '
\r
50 . ' i.ikarmaneg as karmaneg, i.icat as catid, i.iblog as blogid '
\r
51 . ' FROM '.sql_table('item').' as i, '.sql_table('member').' as m, ' . sql_table('blog') . ' as b '
\r
52 . ' WHERE i.inumber=' . $itemid
\r
53 . ' and i.iauthor=m.mnumber '
\r
54 . ' and i.iblog=b.bnumber';
\r
57 $query .= ' and i.idraft=0';
\r
59 if (!$allowfuture) {
\r
60 $blog =& $manager->getBlog(getBlogIDFromItemID($itemid));
\r
61 $query .= ' and i.itime <=' . mysqldate($blog->getCorrectTime());
\r
64 $query .= ' LIMIT 1';
\r
66 $res = sql_query($query);
\r
68 if (sql_num_rows($res) == 1)
\r
70 $aItemInfo = sql_fetch_assoc($res);
\r
71 $aItemInfo['timestamp'] = strtotime($aItemInfo['itime']);
\r
80 * Tries to create an item from the data in the current request (comes from
\r
81 * bookmarklet or admin area
\r
83 * Returns an array with status info:
\r
84 * status = 'added', 'error', 'newcategory'
\r
88 function createFromRequest() {
\r
89 global $member, $manager;
\r
91 $i_author = $member->getID();
\r
92 $i_body = postVar('body');
\r
93 $i_title = postVar('title');
\r
94 $i_more = postVar('more');
\r
95 $i_actiontype = postVar('actiontype');
\r
96 $i_closed = intPostVar('closed');
\r
97 $i_hour = intPostVar('hour');
\r
98 $i_minutes = intPostVar('minutes');
\r
99 $i_month = intPostVar('month');
\r
100 $i_day = intPostVar('day');
\r
101 $i_year = intPostVar('year');
\r
103 $i_catid = postVar('catid');
\r
105 $i_draftid = intPostVar('draftid');
\r
107 if (!$member->canAddItem($i_catid))
\r
108 return array('status' => 'error', 'message' => _ERROR_DISALLOWED);
\r
110 if (!$i_actiontype) $i_actiontype = 'addnow';
\r
112 switch ($i_actiontype) {
\r
122 if (!trim($i_body))
\r
123 return array('status' => 'error', 'message' => _ERROR_NOEMPTYITEMS);
\r
125 // create new category if needed
\r
126 if (strstr($i_catid,'newcat')) {
\r
128 list($i_blogid) = sscanf($i_catid,"newcat-%d");
\r
131 $blog =& $manager->getBlog($i_blogid);
\r
132 $i_catid = $blog->createNewCategory();
\r
134 // show error when sth goes wrong
\r
136 return array('status' => 'error','message' => 'Could not create new category');
\r
138 // force blogid (must be same as category id)
\r
139 $i_blogid = getBlogIDFromCatID($i_catid);
\r
140 $blog =& $manager->getBlog($i_blogid);
\r
143 if ($i_actiontype == 'addfuture') {
\r
144 $posttime = mktime($i_hour, $i_minutes, 0, $i_month, $i_day, $i_year);
\r
146 // make sure the date is in the future, unless we allow past dates
\r
147 if ((!$blog->allowPastPosting()) && ($posttime < $blog->getCorrectTime()))
\r
148 $posttime = $blog->getCorrectTime();
\r
150 // time with offset, or 0 for drafts
\r
151 $posttime = $i_draft ? 0 : $blog->getCorrectTime();
\r
154 if ($posttime > $blog->getCorrectTime()) {
\r
156 $blog->setFuturePost();
\r
162 $itemid = $blog->additem($i_catid, $i_title,$i_body,$i_more,$i_blogid,$i_author,$posttime,$i_closed,$i_draft,$posted);
\r
164 //Setting the itemOptions
\r
165 $aOptions = requestArray('plugoption');
\r
166 NucleusPlugin::_applyPluginOptions($aOptions, $itemid);
\r
168 'context' => 'item',
\r
169 'itemid' => $itemid,
\r
171 'title' => $i_title,
\r
174 'closed' => $i_closed,
\r
175 'catid' => $i_catid)
\r
177 $manager->notify('PostPluginOptionsUpdate', $param);
\r
179 if ($i_draftid > 0) {
\r
180 // delete permission is checked inside ITEM::delete()
\r
181 ITEM::delete($i_draftid);
\r
185 if ($i_catid != intRequestVar('catid'))
\r
186 return array('status' => 'newcategory', 'itemid' => $itemid, 'catid' => $i_catid);
\r
188 return array('status' => 'added', 'itemid' => $itemid);
\r
197 function update($itemid, $catid, $title, $body, $more, $closed, $wasdraft, $publish, $timestamp = 0) {
\r
200 $itemid = intval($itemid);
\r
202 // make sure value is 1 or 0
\r
203 if ($closed != 1) $closed = 0;
\r
205 // get destination blogid
\r
206 $new_blogid = getBlogIDFromCatID($catid);
\r
207 $old_blogid = getBlogIDFromItemID($itemid);
\r
209 // move will be done on end of method
\r
210 if ($new_blogid != $old_blogid)
\r
213 // add <br /> before newlines
\r
214 $blog =& $manager->getBlog($new_blogid);
\r
215 if ($blog->convertBreaks()) {
\r
216 $body = addBreaks($body);
\r
217 $more = addBreaks($more);
\r
222 ' itemid' => $itemid,
\r
223 'title' => &$title,
\r
227 'closed' => &$closed,
\r
230 $manager->notify('PreUpdateItem', $param);
\r
232 // update item itsself
\r
233 $query = 'UPDATE '.sql_table('item')
\r
235 . " ibody='". sql_real_escape_string($body) ."',"
\r
236 . " ititle='" . sql_real_escape_string($title) . "',"
\r
237 . " imore='" . sql_real_escape_string($more) . "',"
\r
238 . " iclosed=" . intval($closed) . ","
\r
239 . " icat=" . intval($catid);
\r
241 // if we received an updated timestamp in the past, but past posting is not allowed,
\r
242 // reject that date change (timestamp = 0 will make sure the current date is kept)
\r
243 if ( (!$blog->allowPastPosting()) && ($timestamp < $blog->getCorrectTime()))
\r
246 if ($timestamp > $blog->getCorrectTime(time())) {
\r
248 $query .= ', iposted=0';
\r
252 $query .= ', iposted=1';
\r
255 if ($wasdraft && $publish) {
\r
256 // set timestamp to current date only if it's not a future item
\r
257 // draft items have timestamp == 0
\r
258 // don't allow timestamps in the past (unless otherwise defined in blogsettings)
\r
259 $query .= ', idraft=0';
\r
261 if ($timestamp == 0)
\r
262 $timestamp = $blog->getCorrectTime();
\r
264 // send new item notification
\r
265 if (!$isFuture && $blog->getNotifyAddress() && $blog->notifyOnNewItem())
\r
266 $blog->sendNewItemNotification($itemid, $title, $body);
\r
269 // save back to drafts
\r
270 if (!$wasdraft && !$publish) {
\r
271 $query .= ', idraft=1';
\r
272 // set timestamp back to zero for a draft
\r
273 $query .= ", itime=" . mysqldate($timestamp);
\r
276 // update timestamp when needed
\r
277 if ($timestamp != 0)
\r
278 $query .= ", itime=" . mysqldate($timestamp);
\r
280 // make sure the correct item is updated
\r
281 $query .= ' WHERE inumber=' . $itemid;
\r
286 $param = array('itemid' => $itemid);
\r
287 $manager->notify('PostUpdateItem', $param);
\r
289 // when needed, move item and comments to new blog
\r
291 ITEM::move($itemid, $catid);
\r
293 //update the itemOptions
\r
294 $aOptions = requestArray('plugoption');
\r
295 NucleusPlugin::_applyPluginOptions($aOptions);
\r
297 'context' => 'item',
\r
298 'itemid' => $itemid,
\r
303 'closed' => $closed,
\r
307 $manager->notify('PostPluginOptionsUpdate', $param);
\r
312 * Move an item to another blog (no checks)
\r
316 function move($itemid, $new_catid) {
\r
319 $itemid = intval($itemid);
\r
320 $new_catid = intval($new_catid);
\r
322 $new_blogid = getBlogIDFromCatID($new_catid);
\r
325 'itemid' => $itemid,
\r
326 'destblogid' => $new_blogid,
\r
327 'destcatid' => $new_catid
\r
329 $manager->notify('PreMoveItem', $param);
\r
332 // update item table
\r
333 $query = 'UPDATE '.sql_table('item')." SET iblog=$new_blogid, icat=$new_catid WHERE inumber=$itemid";
\r
337 $query = 'UPDATE '.sql_table('comment')." SET cblog=" . $new_blogid." WHERE citem=" . $itemid;
\r
341 'itemid' => $itemid,
\r
342 'destblogid' => $new_blogid,
\r
343 'destcatid' => $new_catid
\r
345 $manager->notify('PostMoveItem', $param);
\r
351 function delete($itemid) {
\r
352 global $manager, $member;
\r
354 $itemid = intval($itemid);
\r
356 // check to ensure only those allow to alter the item can
\r
358 if (!$member->canAlterItem($itemid)) {
\r
362 $param = array('itemid' => $itemid);
\r
363 $manager->notify('PreDeleteItem', $param);
\r
366 $query = 'DELETE FROM '.sql_table('item').' WHERE inumber=' . $itemid;
\r
369 // delete the comments associated with the item
\r
370 $query = 'DELETE FROM '.sql_table('comment').' WHERE citem=' . $itemid;
\r
373 // delete all associated plugin options
\r
374 NucleusPlugin::_deleteOptionValues('item', $itemid);
\r
376 $param = array('itemid' => $itemid);
\r
377 $manager->notify('PostDeleteItem', $param);
\r
383 * Returns true if there is an item with the given ID
\r
387 function exists($id,$future,$draft) {
\r
392 $r = 'select * FROM '.sql_table('item').' WHERE inumber='.$id;
\r
394 $bid = getBlogIDFromItemID($id);
\r
395 if (!$bid) return 0;
\r
396 $b =& $manager->getBlog($bid);
\r
397 $r .= ' and itime<='.mysqldate($b->getCorrectTime());
\r
400 $r .= ' and idraft=0';
\r
402 $r = sql_query($r);
\r
404 return (sql_num_rows($r) != 0);
\r
408 * Tries to create an draft from the data in the current request (comes from
\r
409 * bookmarklet or admin area
\r
411 * Returns an array with status info:
\r
412 * status = 'added', 'error', 'newcategory'
\r
416 * Used by xmlHTTPRequest AutoDraft
\r
418 function createDraftFromRequest() {
\r
419 global $member, $manager;
\r
421 $i_author = $member->getID();
\r
422 $i_body = postVar('body');
\r
423 $i_title = postVar('title');
\r
424 $i_more = postVar('more');
\r
426 if(strtoupper(_CHARSET) != 'UTF-8'){
\r
427 $i_body = mb_convert_encoding($i_body, _CHARSET, "UTF-8");
\r
428 $i_title = mb_convert_encoding($i_title, _CHARSET, "UTF-8");
\r
429 $i_more = mb_convert_encoding($i_more, _CHARSET, "UTF-8");
\r
431 //$i_actiontype = postVar('actiontype');
\r
432 $i_closed = intPostVar('closed');
\r
433 //$i_hour = intPostVar('hour');
\r
434 //$i_minutes = intPostVar('minutes');
\r
435 //$i_month = intPostVar('month');
\r
436 //$i_day = intPostVar('day');
\r
437 //$i_year = intPostVar('year');
\r
438 $i_catid = postVar('catid');
\r
440 $type = postVar('type');
\r
441 if ($type == 'edit') {
\r
442 $i_blogid = getBlogIDFromItemID(intPostVar('itemid'));
\r
445 $i_blogid = intPostVar('blogid');
\r
447 $i_draftid = intPostVar('draftid');
\r
449 if (!$member->canAddItem($i_catid)) {
\r
450 return array('status' => 'error', 'message' => _ERROR_DISALLOWED);
\r
453 if (!trim($i_body)) {
\r
454 return array('status' => 'error', 'message' => _ERROR_NOEMPTYITEMS);
\r
457 // create new category if needed
\r
458 if (strstr($i_catid, 'newcat')) {
\r
459 // Set in default category
\r
460 $blog =& $manager->getBlog($i_blogid);
\r
461 $i_catid = $blog->getDefaultCategory();
\r
464 // force blogid (must be same as category id)
\r
465 $i_blogid = getBlogIDFromCatID($i_catid);
\r
466 $blog =& $manager->getBlog($i_blogid);
\r
471 if ($i_draftid > 0) {
\r
472 ITEM::update($i_draftid, $i_catid, $i_title, $i_body, $i_more, $i_closed, 1, 0, 0);
\r
473 $itemid = $i_draftid;
\r
476 $itemid = $blog->additem($i_catid, $i_title, $i_body, $i_more, $i_blogid, $i_author, $posttime, $i_closed, $i_draft);
\r
480 // No plugin support in AutoSaveDraft yet
\r
481 //Setting the itemOptions
\r
482 $aOptions = requestArray('plugoption');
\r
483 NucleusPlugin::_applyPluginOptions($aOptions, $itemid);
\r
485 'context' => 'item',
\r
486 'itemid' => $itemid,
\r
488 'title' => $i_title,
\r
491 'closed' => $i_closed,
\r
492 'catid' => $i_catid
\r
495 $manager->notify('PostPluginOptionsUpdate', $param);
\r
499 return array('status' => 'added', 'draftid' => $itemid);
\r