Changes in [1441:fb59f706335a:1440:e17c74d9f5ae]
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
inc/core/class.dc.blog.php
r1262 r1261 203 203 @param ids <b>mixed</b> Comment(s) ID(s) 204 204 @param del <b>boolean</b> If comment is delete, set this to true 205 @param affected_posts <b>mixed</b> Posts(s) ID(s) 206 */ 207 public function triggerComments($ids, $del=false, $affected_posts=null) 205 */ 206 public function triggerComments($ids,$del=false) 208 207 { 209 208 $co_ids = dcUtils::cleanIds($ids); 210 $a_ids = dcUtils::cleanIds($affected_posts);211 $a_tbs = array();212 209 213 210 # a) Retrieve posts affected by comments edition 214 if (empty($a_ids)) { 215 $strReq = 216 'SELECT post_id, comment_trackback '. 217 'FROM '.$this->prefix.'comment '. 218 'WHERE comment_id'.$this->con->in($co_ids). 219 'GROUP BY post_id,comment_trackback'; 220 221 $rs = $this->con->select($strReq); 222 223 while ($rs->fetch()) { 224 $a_ids[] = (integer) $rs->post_id; 225 $a_tbs[] = (integer) $rs->comment_trackback; 226 } 211 $strReq = 212 'SELECT post_id, comment_trackback '. 213 'FROM '.$this->prefix.'comment '. 214 'WHERE comment_id'.$this->con->in($co_ids). 215 'GROUP BY post_id,comment_trackback'; 216 217 $rs = $this->con->select($strReq); 218 219 $a_ids = $a_tbs = array(); 220 while ($rs->fetch()) { 221 $a_ids[] = (integer) $rs->post_id; 222 $a_tbs[] = (integer) $rs->comment_trackback; 227 223 } 228 224 … … 259 255 { 260 256 $nb_comment = $nb_trackback = 0; 261 //$cur->nb_comment = $nb_comment;262 257 foreach($b_ids as $b_key => $b_id) 263 258 { … … 2192 2187 $co_ids = dcUtils::cleanIds($ids); 2193 2188 2194 if (empty($ co_ids)) {2189 if (empty($ids)) { 2195 2190 throw new Exception(__('No such comment ID')); 2196 }2197 2198 # Retrieve posts affected by comments edition2199 $affected_posts = array();2200 $strReq =2201 'SELECT distinct(post_id) '.2202 'FROM '.$this->prefix.'comment '.2203 'WHERE comment_id'.$this->con->in($co_ids);2204 2205 $rs = $this->con->select($strReq);2206 2207 while ($rs->fetch()) {2208 $affected_posts[] = (integer) $rs->post_id;2209 2191 } 2210 2192 … … 2236 2218 2237 2219 $this->con->execute($strReq); 2238 $this->triggerComments($co_ids, true, $affected_posts);2220 $this->triggerComments($co_ids,true); 2239 2221 $this->triggerBlog(); 2240 2222 }
Note: See TracChangeset
for help on using the changeset viewer.