1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
|
<?php
/*
* Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)
* Copyright (C) 2002-2005 The Nucleus Group
*
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License
* as published by the Free Software Foundation; either version 2
* of the License, or (at your option) any later version.
* (see nucleus/documentation/index.html#license for more info)
*/
/**
* A class representing an item
*
* @license http://nucleuscms.org/license.txt GNU General Public License
* @copyright Copyright (C) 2002-2005 The Nucleus Group
* @version $Id: ITEM.php,v 1.16.2.1 2005/08/15 10:50:12 dekarma Exp $
*/
class ITEM {
var $itemid;
function ITEM($itemid) {
$this->itemid = $itemid;
}
/**
* Returns one item with the specific itemid
* (static)
*/
function getitem($itemid, $allowdraft, $allowfuture) {
global $manager;
$itemid = intval($itemid);
$query = 'SELECT i.idraft as draft, i.inumber as itemid, i.iclosed as closed, '
. ' i.ititle as title, i.ibody as body, m.mname as author, '
. ' i.iauthor as authorid, i.itime, i.imore as more, i.ikarmapos as karmapos, '
. ' i.ikarmaneg as karmaneg, i.icat as catid, i.iblog as blogid '
. ' FROM '.sql_table('item').' as i, '.sql_table('member').' as m, ' . sql_table('blog') . ' as b '
. ' WHERE i.inumber=' . $itemid
. ' and i.iauthor=m.mnumber '
. ' and i.iblog=b.bnumber';
if (!$allowdraft)
$query .= ' and i.idraft=0';
if (!$allowfuture) {
$blog =& $manager->getBlog(getBlogIDFromItemID($itemid));
$query .= ' and i.itime <=' . mysqldate($blog->getCorrectTime());
}
$query .= ' LIMIT 1';
$res = sql_query($query);
if (mysql_num_rows($res) == 1)
{
$aItemInfo = mysql_fetch_assoc($res);
$aItemInfo['timestamp'] = strtotime($aItemInfo['itime']);
return $aItemInfo;
} else {
return 0;
}
}
/**
* Tries to create an item from the data in the current request (comes from
* bookmarklet or admin area
*
* Returns an array with status info (status = 'added', 'error', 'newcategory')
*
* (static)
*/
function createFromRequest() {
global $member, $manager;
$i_author = $member->getID();
$i_body = postVar('body');
$i_title = postVar('title');
$i_more = postVar('more');
$i_actiontype = postVar('actiontype');
$i_closed = intPostVar('closed');
$i_hour = intPostVar('hour');
$i_minutes = intPostVar('minutes');
$i_month = intPostVar('month');
$i_day = intPostVar('day');
$i_year = intPostVar('year');
$i_catid = postVar('catid');
if (!$member->canAddItem($i_catid))
return array('status' => 'error', 'message' => _ERROR_DISALLOWED);
if (!$i_actiontype) $i_actiontype = 'addnow';
switch ($i_actiontype) {
case 'adddraft':
$i_draft = 1;
break;
case 'addfuture':
case 'addnow':
default:
$i_draft = 0;
}
if (!trim($i_body))
return array('status' => 'error', 'message' => _ERROR_NOEMPTYITEMS);
// create new category if needed
if (strstr($i_catid,'newcat')) {
// get blogid
list($i_blogid) = sscanf($i_catid,"newcat-%d");
// create
$blog =& $manager->getBlog($i_blogid);
$i_catid = $blog->createNewCategory();
// show error when sth goes wrong
if (!$i_catid)
return array('status' => 'error','message' => 'Could not create new category');
} else {
// force blogid (must be same as category id)
$i_blogid = getBlogIDFromCatID($i_catid);
$blog =& $manager->getBlog($i_blogid);
}
if ($i_actiontype == 'addfuture') {
$posttime = mktime($i_hour, $i_minutes, 0, $i_month, $i_day, $i_year);
// make sure the date is in the future, unless we allow past dates
if ((!$blog->allowPastPosting()) && ($posttime < $blog->getCorrectTime()))
$posttime = $blog->getCorrectTime();
} else {
// time with offset, or 0 for drafts
$posttime = $i_draft ? 0 : $blog->getCorrectTime();
}
$itemid = $blog->additem($i_catid, $i_title,$i_body,$i_more,$i_blogid,$i_author,$posttime,$i_closed,$i_draft);
//Setting the itemOptions
$aOptions = requestArray('plugoption');
NucleusPlugin::_applyPluginOptions($aOptions, $itemid);
$manager->notify('PostPluginOptionsUpdate',array('context' => 'item', 'itemid' => $itemid, 'item' => array('title' => $i_title, 'body' => $i_body, 'more' => $i_more, 'closed' => $i_closed, 'catid' => $i_catid)));
// success
if ($i_catid != intRequestVar('catid'))
return array('status' => 'newcategory', 'itemid' => $itemid, 'catid' => $i_catid);
else
return array('status' => 'added', 'itemid' => $itemid);
}
/**
* Updates an item (static)
*/
function update($itemid, $catid, $title, $body, $more, $closed, $wasdraft, $publish, $timestamp = 0) {
global $manager;
$itemid = intval($itemid);
// make sure value is 1 or 0
if ($closed != 1) $closed = 0;
// get destination blogid
$new_blogid = getBlogIDFromCatID($catid);
$old_blogid = getBlogIDFromItemID($itemid);
// move will be done on end of method
if ($new_blogid != $old_blogid)
$moveNeeded = 1;
// add <br /> before newlines
$blog =& $manager->getBlog($new_blogid);
if ($blog->convertBreaks()) {
$body = addBreaks($body);
$more = addBreaks($more);
}
// call plugins
$manager->notify('PreUpdateItem',array('itemid' => $itemid, 'title' => &$title, 'body' => &$body, 'more' => &$more, 'blog' => &$blog, 'closed' => &$closed, 'catid' => &$catid));
// update item itsself
$query = 'UPDATE '.sql_table('item')
. ' SET'
. " ibody='". addslashes($body) ."',"
. " ititle='" . addslashes($title) . "',"
. " imore='" . addslashes($more) . "',"
. " iclosed=" . intval($closed) . ","
. " icat=" . intval($catid);
// if we received an updated timestamp in the past, but past posting is not allowed,
// reject that date change (timestamp = 0 will make sure the current date is kept)
if ( (!$blog->allowPastPosting()) && ($timestamp < $blog->getCorrectTime()))
$timestamp = 0;
if ($wasdraft && $publish) {
$query .= ', idraft=0';
// set timestamp to current date only if it's not a future item
// draft items have timestamp == 0
// don't allow timestamps in the past (unless otherwise defined in blogsettings)
if ($timestamp > $blog->getCorrectTime())
$isFuture = 1;
if ($timestamp == 0)
$timestamp = $blog->getCorrectTime();
// send new item notification
if (!$isFuture && $blog->getNotifyAddress() && $blog->notifyOnNewItem())
$blog->sendNewItemNotification($itemid, $title, $body);
}
// update timestamp when needed
if ($timestamp != 0)
$query .= ", itime=" . mysqldate($timestamp);
// make sure the correct item is updated
$query .= ' WHERE inumber=' . $itemid;
// off we go!
sql_query($query);
$manager->notify('PostUpdateItem',array('itemid' => $itemid));
// when needed, move item and comments to new blog
if ($moveNeeded)
ITEM::move($itemid, $catid);
//update the itemOptions
$aOptions = requestArray('plugoption');
NucleusPlugin::_applyPluginOptions($aOptions);
$manager->notify('PostPluginOptionsUpdate',array('context' => 'item', 'itemid' => $itemid, 'item' => array('title' => $title, 'body' => $body, 'more' => $more, 'closed' => $closed, 'catid' => $catid)));
}
// move an item to another blog (no checks, static)
function move($itemid, $new_catid) {
global $manager;
$itemid = intval($itemid);
$new_catid = intval($new_catid);
$new_blogid = getBlogIDFromCatID($new_catid);
$manager->notify(
'PreMoveItem',
array(
'itemid' => $itemid,
'destblogid' => $new_blogid,
'destcatid' => $new_catid
)
);
// update item table
$query = 'UPDATE '.sql_table('item')." SET iblog=$new_blogid, icat=$new_catid WHERE inumber=$itemid";
sql_query($query);
// update comments
$query = 'UPDATE '.sql_table('comment')." SET cblog=" . $new_blogid." WHERE citem=" . $itemid;
sql_query($query);
$manager->notify(
'PostMoveItem',
array(
'itemid' => $itemid,
'destblogid' => $new_blogid,
'destcatid' => $new_catid
)
);
}
/**
* Deletes an item
*/
function delete($itemid) {
global $manager;
$itemid = intval($itemid);
$manager->notify('PreDeleteItem', array('itemid' => $itemid));
// delete item
$query = 'DELETE FROM '.sql_table('item').' WHERE inumber=' . $itemid;
sql_query($query);
// delete the comments associated with the item
$query = 'DELETE FROM '.sql_table('comment').' WHERE citem=' . $itemid;
sql_query($query);
// delete all associated plugin options
NucleusPlugin::_deleteOptionValues('item', $itemid);
$manager->notify('PostDeleteItem', array('itemid' => $itemid));
}
// returns true if there is an item with the given ID (static)
function exists($id,$future,$draft) {
global $manager;
$id = intval($id);
$r = 'select * FROM '.sql_table('item').' WHERE inumber='.$id;
if (!$future) {
$bid = getBlogIDFromItemID($id);
if (!$bid) return 0;
$b =& $manager->getBlog($bid);
$r .= ' and itime<='.mysqldate($b->getCorrectTime());
}
if (!$draft) {
$r .= ' and idraft=0';
}
$r = sql_query($r);
return (mysql_num_rows($r) != 0);
}
}
?>
|