1: <?php
  2: /**
  3:  * This file contains the collection class for userforum plugin.
  4:  *
  5:  * @package Plugin
  6:  * @subpackage UserForum
  7:  * @version SVN Revision $Rev:$
  8:  *
  9:  * @author Claus Schunk
 10:  * @copyright four for business AG <www.4fb.de>
 11:  * @license http://www.contenido.org/license/LIZENZ.txt
 12:  * @link http://www.4fb.de
 13:  * @link http://www.contenido.org
 14:  */
 15: defined('CON_FRAMEWORK') || die('Illegal call: Missing framework initialization - request aborted.');
 16: 
 17: /**
 18:  * This class contains functions for dB manipulations and for the interaction
 19:  * between the frontend module
 20:  * content_user_forum and the backend plugin.
 21:  *
 22:  * @package Plugin
 23:  * @subpackage UserForum
 24:  */
 25: class ArticleForumCollection extends ItemCollection {
 26: 
 27:     /**
 28:      *
 29:      * @var array
 30:      */
 31:     protected $cfg = 0;
 32: 
 33:     /**
 34:      *
 35:      * @var cDb
 36:      */
 37:     protected $db = 0;
 38: 
 39:     /**
 40:      *
 41:      * @var ArticleForumItem
 42:      */
 43:     protected $item = 0;
 44: 
 45:     // contents array of translations from frontend module
 46:     /**
 47:      *
 48:      * @var array
 49:      */
 50:     protected $languageSync = 0;
 51: 
 52:     /**
 53:      *
 54:      * @var int
 55:      */
 56:     protected $idContentType = 0;
 57: 
 58:     /**
 59:      */
 60:     public function __construct() {
 61:         // sync time
 62:         date_default_timezone_set('Europe/Berlin');
 63:         $this->db = cRegistry::getDb();
 64:         $this->cfg = cRegistry::getConfig();
 65: 
 66:         parent::__construct($this->cfg['tab']['user_forum'], 'id_user_forum');
 67:         $this->_setItemClass('ArticleForum');
 68:         $this->item = new ArticleForumItem();
 69:         $this->idContentType = $this->getIdUserForumContenType();
 70:     }
 71: 
 72:     /**
 73:      *
 74:      * @return array
 75:      */
 76:     public function getAllCommentedArticles() {
 77: 
 78:         $idclient = cRegistry::getClientId();
 79: 
 80: 
 81:         $this->db->query("-- ArticleForumCollection->getAllCommentedArticles()
 82:             SELECT DISTINCT
 83:                 art_lang.title
 84:                 , art_lang.idart
 85:                 , f.idcat
 86:             FROM
 87:                 `{$this->cfg['tab']['art_lang']}` AS art_lang
 88:                 , `$this->table` AS  f
 89:             WHERE
 90:                 art_lang.idart = f.idart
 91:                 AND art_lang.idlang = f.idlang
 92:                 AND idclient = ".$idclient."
 93:             ORDER BY
 94:                 id_user_forum ASC
 95:             ;");
 96: 
 97:         $data = array();
 98:         while ($this->db->nextRecord()) {
 99:             array_push($data, $this->db->toArray());
100:         }
101: 
102:         return $data;
103:     }
104: 
105:     /**
106:      * deletes comment with all subcomments from this comment
107:      *
108:      * @param $keyPost
109:      * @param $level
110:      * @param $idart
111:      * @param $idcat
112:      * @param $lang
113:      */
114:     public function deleteHierarchie($keyPost, $level, $idart, $idcat, $lang) {
115:         $comments = $this->_getCommentHierachrie($idcat, $idart, $lang);
116: 
117:         $arri = array();
118: 
119:         foreach ($comments as $key => $com) {
120:             $com['key'] = $key;
121:             $arri[] = $com;
122:         }
123:         $idEntry = 0;
124:         $id_user_forum = array();
125:         $lastLevel = 0;
126:         for ($i = 0; $i < count($arri); $i++) {
127:             // select Entry
128:             if ($arri[$i]['key'] == $keyPost) {
129:                 $idEntry = $arri[$i]['id_user_forum'];
130:                 if ($arri[$i]['level'] < $arri[$i + 1]['level']) {
131:                     // check for more subcomments
132:                     for ($j = $i + 1; $j < $arri[$j]; $j++) {
133:                         if ($arri[$i]['level'] < $arri[$j]['level']) {
134:                             $id_user_forum[] = $arri[$j]['id_user_forum'];
135:                         }
136:                     }
137:                 }
138:             }
139:         }
140: 
141:         if (empty($id_user_forum)) {
142:             $this->deleteBy('id_user_forum', $idEntry);
143:         } else {
144:             $this->deleteBy('id_user_forum', $idEntry);
145:             foreach ($id_user_forum as $com) {
146:                 $this->deleteBy('id_user_forum', $com);
147:             }
148:         }
149:     }
150: 
151:     /**
152:      *
153:      * @param int $id_cat
154:      * @param int $id_art
155:      * @param int $id_lang
156:      * @return array
157:      */
158:     protected function _getCommentHierachrie($id_cat, $id_art, $id_lang) {
159:         $this->query();
160:         while (false != $field = $this->next()) {
161:             $arrUsers[$field->get('userid')]['email'] = $field->get('email');
162:             $arrUsers[$field->get('userid')]['realname'] = $field->get('realname');
163:         }
164:         $arrforum = array();
165:         $this->getTreeLevel($id_cat, $id_art, $id_lang, $arrUsers, $arrforum);
166:         $result = array();
167:         $this->normalizeArray($arrforum, $result);
168: 
169:         return $result;
170:     }
171: 
172:     /**
173:      *
174:      * @param array $arrforum
175:      * @param array $result
176:      * @param int $level
177:      */
178:     public function normalizeArray($arrforum, &$result, $level = 0) {
179:         if (is_array($arrforum)) {
180:             foreach ($arrforum as $key => $value) {
181:                 $value['level'] = $level;
182:                 unset($value['children']);
183:                 $result[$key] = $value;
184:                 $this->normalizeArray($arrforum[$key]['children'], $result, $level + 1);
185:             }
186:         }
187:     }
188: 
189:     /**
190:      *
191:      * @param int $id_cat
192:      * @param int $id_art
193:      * @param int $id_lang
194:      * @param array $arrUsers
195:      * @param array $arrforum
196:      * @param int $parent
197:      * @param bool $frontend
198:      */
199:     public function getTreeLevel($id_cat, $id_art, $id_lang, &$arrUsers, &$arrforum, $parent = 0, $frontend = false) {
200:         $db = cRegistry::getDb();
201:         if ($frontend) {
202:             // select only comments that are marked visible in frontendmode.
203:             $db->query("-- ArticleForumCollection->getTreeLevel()
204:                 SELECT
205:                     *
206:                 FROM
207:                     `{$this->cfg['tab']['user_forum']}`
208:                 WHERE
209:                     idart = $id_art
210:                     AND idcat = $id_cat
211:                     AND idlang = $id_lang
212:                     AND id_user_forum_parent = $parent
213:                     AND online = 1
214:                 ORDER BY
215:                     timestamp DESC
216:                 ;");
217:         } else {
218:             // select all comments -> used in backendmode.
219:             $db->query("-- ArticleForumCollection->getTreeLevel()
220:                 SELECT
221:                     *
222:                 FROM
223:                     `{$this->cfg['tab']['user_forum']}`
224:                 WHERE
225:                     idart = $id_art
226:                     AND idcat = $id_cat
227:                     AND idlang = $id_lang
228:                     AND id_user_forum_parent = $parent
229:                 ORDER BY
230:                     timestamp DESC
231:                 ;");
232:         }
233: 
234:         while ($db->nextRecord()) {
235:             $arrforum[$db->f('id_user_forum')]['userid'] = $db->f('userid');
236: 
237:             if (array_key_exists($db->f('userid'), $arrUsers)) {
238:                 $arrforum[$db->f('id_user_forum')]['email'] = $arrUsers[$db->f('userid')]['email'];
239:                 $arrforum[$db->f('id_user_forum')]['realname'] = $arrUsers[$db->f('userid')]['realname'];
240:             } else {
241:                 $arrforum[$db->f('id_user_forum')]['email'] = $db->f('email');
242:                 $arrforum[$db->f('id_user_forum')]['realname'] = $db->f('realname');
243:             }
244:             $arrforum[$db->f('id_user_forum')]['forum'] = str_replace(chr(13) . chr(10), '<br />', $db->f('forum'));
245:             $arrforum[$db->f('id_user_forum')]['forum_quote'] = str_replace(chr(13) . chr(10), '<br />', $db->f('forum_quote'));
246:             $arrforum[$db->f('id_user_forum')]['timestamp'] = $db->f('timestamp');
247:             $arrforum[$db->f('id_user_forum')]['like'] = $db->f('like');
248:             $arrforum[$db->f('id_user_forum')]['dislike'] = $db->f('dislike');
249: 
250:             $arrforum[$db->f('id_user_forum')]['editedat'] = $db->f('editedat');
251:             $arrforum[$db->f('id_user_forum')]['editedby'] = $db->f('editedby');
252: 
253:             // Added values to array for allocation
254:             $arrforum[$db->f('id_user_forum')]['idcat'] = $db->f('idcat');
255:             $arrforum[$db->f('id_user_forum')]['idart'] = $db->f('idart');
256:             $arrforum[$db->f('id_user_forum')]['id_user_forum'] = $db->f('id_user_forum');
257:             $arrforum[$db->f('id_user_forum')]['online'] = $db->f('online');
258:             $arrforum[$db->f('id_user_forum')]['editedat'] = $db->f('editedat');
259:             $arrforum[$db->f('id_user_forum')]['editedby'] = $db->f('editedby');
260: 
261:             $this->getTreeLevel($id_cat, $id_art, $id_lang, $arrUsers, $arrforum[$db->f('id_user_forum')]['children'], $db->f('id_user_forum'), $frontend);
262:         }
263:     }
264: 
265:     /**
266:      *
267:      * @param unknown_type $id_user_forum
268:      * @param unknown_type $name
269:      * @param unknown_type $email
270:      * @param unknown_type $like
271:      * @param unknown_type $dislike
272:      * @param unknown_type $forum
273:      * @param unknown_type $online
274:      * @param unknown_type $checked
275:      */
276:     public function updateValues($id_user_forum, $name, $email, $like, $dislike, $forum, $online, $checked) {
277:         $uuid = cRegistry::getAuth()->isAuthenticated();
278: 
279:         $this->item->loadByPrimaryKey($id_user_forum);
280: 
281:         if ($this->item->getField('realname') == $name && $this->item->getField('email') == $email && $this->item->getField('forum') == $forum) {
282: 
283:             // load timestamp from db to check if the article was already
284:             // edited.
285:             if ($this->item->getField('editedat') === "0000-00-00 00:00:00") {
286:                 // case : never edited
287:                 $timeStamp = "0000-00-00 00:00:00";
288:             } else {
289:                 $timeStamp = $this->item->getField('editedat');
290:             }
291:         } else {
292:             // actual timestamp: Content was edited
293:             $timeStamp = date('Y-m-d H:i:s', time());
294:         }
295: 
296:         if (preg_match('/\D/', $like)) {
297:             $like = $this->item->getField('like');
298:         }
299: 
300:         if (preg_match('/\D/', $dislike)) {
301:             $dislike = $this->item->getField('dislike');
302:         }
303: 
304:         // check for negative inputs
305:         // does not work with php 5.2
306:         // (!preg_match('/\D/', $like)) ? : $like =
307:         // $this->item->getField('like');
308:         // (!preg_match('/\D/', $dislike)) ? : $dislike =
309:         // $this->item->getField('dislike');
310: 
311:         $fields = array(
312:             'realname' => $name,
313:             'editedby' => $uuid,
314:             'email' => $email,
315:             'forum' => $forum,
316:             'editedat' => $timeStamp,
317:             'like' => $like,
318:             'dislike' => $dislike,
319:             'online' => $online
320:         );
321: 
322:         $whereClauses = array(
323:             'id_user_forum' => $id_user_forum
324:         );
325:         $statement = $this->db->buildUpdate($this->table, $fields, $whereClauses);
326:         $this->db->query($statement);
327:     }
328: 
329:     /**
330:      * toggles the given input with update in db.
331:      *
332:      * @param $onlineState
333:      * @param int $id_user_forum primary key
334:      */
335:     public function toggleOnlineState($onlineState, $id_user_forum) {
336:         // toggle state
337:         $onlineState = ($onlineState == 0) ? 1 : 0;
338: 
339:         $fields = array(
340:             'online' => $onlineState
341:         );
342:         $whereClauses = array(
343:             'id_user_forum' => (int) $id_user_forum
344:         );
345:         $statement = $this->db->buildUpdate($this->table, $fields, $whereClauses);
346:         $this->db->query($statement);
347:     }
348: 
349:     /**
350:      * email notification for registred moderator.
351:      * before calling this function it is necessary to receive the converted
352:      * language string from frontend module.
353:      *
354:      * @param unknown_type $realname
355:      * @param unknown_type $email
356:      * @param unknown_type $forum
357:      * @param unknown_type $idart
358:      * @param unknown_type $lang
359:      * @param unknown_type $forum_quote
360:      */
361:     public function mailToModerator($realname, $email, $forum, $idart, $lang, $forum_quote = 0) {
362: 
363:         // get article name
364:         $ar = $this->getArticleTitle($idart, $lang);
365: 
366:         $mail = new cMailer();
367:         $mail->setCharset('UTF-8');
368: 
369:         // build message content
370:         $message = $this->languageSync['NEWENTRYTEXT'] . " " . $this->languageSync['ARTICLE'] . $ar[0]["title"] . "\n" . "\n";
371:         $message .= $this->languageSync['USER'] . ' : ' . $realname . "\n";
372:         $message .= $this->languageSync['EMAIL'] . ' : ' . $email . "\n" . "\n";
373:         $message .= $this->languageSync['COMMENT'] . ' : ' . "\n" . $forum . "\n";
374:         if ($forum_quote != 0) {
375:             $message .= UserForum::i18n('QUOTE') . ' : ' . $forum_quote . "\n";
376:         }
377: 
378:         // send mail only if modEmail is set -> minimize traffic.
379:         if ($this->getModEmail($idart) != NULL) {
380:             $mail->sendMail(getEffectiveSetting("userforum", "mailfrom"), $this->getModEmail($idart), $this->languageSync['NEWENTRY'], $message);
381:         }
382:     }
383: 
384:     /**
385:      *
386:      * @param int $idart
387:      * @param int $idlang
388:      * @return array
389:      */
390:     public function getArticleTitle($idart, $idlang) {
391:         $this->db->query("-- ArticleForumCollection->getArticleTitle()
392:             SELECT DISTINCT
393:                 title
394:             FROM
395:                 `{$this->cfg['tab']['art_lang']}` AS art_lang
396:             WHERE
397:                 idart = $idart
398:                 AND idlang = $idlang
399:             ;");
400: 
401:         $data = array();
402:         while ($this->db->nextRecord()) {
403:             array_push($data, $this->db->toArray());
404:         }
405: 
406:         return $data;
407:     }
408: 
409:     /**
410:      *
411:      * @param $id_cat
412:      * @param $id_art
413:      * @param $id_lang
414:      * @return ArticleForumRightBottom
415:      */
416:     public function getExistingforum($id_cat, $id_art, $id_lang) {
417:         $userColl = new cApiUserCollection();
418:         $userColl->query();
419: 
420:         while (($field = $userColl->next()) != false) {
421:             $arrUsers[$field->get('user_id')]['email'] = $field->get('email');
422:             $arrUsers[$field->get('user_id')]['realname'] = $field->get('realname');
423:         }
424:         return $arrUsers;
425:     }
426: 
427:     /**
428:      *
429:      * @param unknown_type $idquote
430:      * @return multitype:NULL
431:      */
432:     function selectNameAndNameByForumId($idquote) {
433:         $ar = array();
434:         $this->item->loadByPrimaryKey($this->db->escape($idquote));
435:         $ar[] = $this->item->get('realname');
436:         return $ar;
437:     }
438: 
439:     /**
440:      *
441:      * @param unknown_type $userid
442:      */
443:     public function selectUser($userid) {
444:         return $this->item->loadByPrimaryKey($this->db->escape($userid));
445:     }
446: 
447:     /**
448:      * this function increments the actual value of likes from a comment and
449:      * persists it.
450:      *
451:      * @param $forum_user_id identifies a comment.
452:      */
453:     public function incrementLike($forum_user_id) {
454:         $db = cRegistry::getDb();
455:         $ar = array();
456:         // load actual value
457:         $this->item->loadByPrimaryKey($db->escape($forum_user_id));
458:         $ar = $this->item->toArray();
459:         $current = $ar['like'];
460:         // increment value
461:         $current += 1;
462: 
463:         $fields = array(
464:             'like' => $current
465:         );
466:         $whereClauses = array(
467:             'id_user_forum' => $forum_user_id
468:         );
469:         // persist inkremented value
470:         $statement = $this->db->buildUpdate($this->table, $fields, $whereClauses);
471:         $this->db->query($statement);
472:     }
473: 
474:     /**
475:      * this function inkrements the actual value of dislikes from a comment and
476:      * persists it.
477:      *
478:      * @param $forum_user_id identifies a comment.
479:      */
480:     public function incrementDislike($forum_user_id) {
481:         $db = cRegistry::getDb();
482:         $ar = array();
483:         // load actual value
484:         $this->item->loadByPrimaryKey($db->escape($forum_user_id));
485:         $ar = $this->item->toArray();
486:         $current = $ar['dislike'];
487:         // increment value
488:         $current += 1;
489: 
490:         $fields = array(
491:             'dislike' => $current
492:         );
493:         $whereClauses = array(
494:             'id_user_forum' => $forum_user_id
495:         );
496:         // persist inkremented value
497:         $statement = $this->db->buildUpdate($this->table, $fields, $whereClauses);
498:         $this->db->query($statement);
499:     }
500: 
501:     /**
502:      * persists a new comment created at the frontend module.
503:      *
504:      * @param $parent
505:      * @param $idart
506:      * @param $idcat
507:      * @param $lang
508:      * @param $userid
509:      * @param $email
510:      * @param $realname
511:      * @param $forum
512:      * @param $forum_quote
513:      */
514:     public function insertValues($parent, $idart, $idcat, $lang, $userid, $email, $realname, $forum, $forum_quote) {
515:         $db = cRegistry::getDb();
516: 
517:         // comments are marked as offline if the moderator mode is turned on.
518:         $modCheck = $this->getModeModeActive($idart);
519:         $online = $modCheck? 0 : 1;
520: 
521:         // build array for sql statemant
522:         $fields = array(
523:             'id_user_forum' => NULL,
524:             'id_user_forum_parent' => $db->escape($parent),
525:             'idart' => $db->escape($idart),
526:             'idcat' => $db->escape($idcat),
527:             'idlang' => $db->escape($lang),
528:             'userid' => $db->escape($userid),
529:             'email' => $db->escape($email),
530:             'realname' => $db->escape($realname),
531:             'forum' => ($forum),
532:             'forum_quote' => ($forum_quote),
533:             'idclient' => cRegistry::getClientId(),
534:             'like' => 0,
535:             'dislike' => 0,
536:             'editedat' => NULL,
537:             'editedby' => NULL,
538:             'timestamp' => date('Y-m-d H:i:s'),
539:             'online' => $online
540:         );
541: 
542:         $db->insert($this->table, $fields);
543: 
544:         // if moderator mode is turned on the moderator will receive an email
545:         // with the new comment and is able to
546:         // change the online state in the backend.
547:         if ($modCheck) {
548:             $this->mailToModerator($realname, $email, $forum, $idart, $lang, $forum_quote = 0);
549:         }
550:     }
551: 
552:     /**
553:      * this function deletes all comments related to the same articleId
554:      *
555:      * @param articleId $idart
556:      */
557:     public function deleteAllCommentsById($idart) {
558:         $this->deleteBy('idart', (int) $idart);
559:     }
560: 
561:     /**
562:      *
563:      * @param unknown_type $id_cat
564:      * @param unknown_type $id_art
565:      * @param unknown_type $id_lang
566:      * @param unknown_type $frontend
567:      * @return multitype:
568:      */
569:     public function getExistingforumFrontend($id_cat, $id_art, $id_lang, $frontend) {
570:         // $cfg = cRegistry::getConfig();
571:         // $db = cRegistry::getDb();
572:         $userColl = new cApiUserCollection();
573:         $userColl->query();
574: 
575:         while (($field = $userColl->next()) != false) {
576:             $arrUsers[$field->get('user_id')]['email'] = $field->get('email');
577:             $arrUsers[$field->get('user_id')]['realname'] = $field->get('realname');
578:         }
579: 
580:         $arrforum = array();
581:         $this->getTreeLevel($id_cat, $id_art, $id_lang, $arrUsers, $arrforum, 0, $frontend);
582: 
583:         $result = array();
584:         $this->normalizeArray($arrforum, $result);
585:         return $result;
586:     }
587: 
588:     /**
589:      * returns the emailadress from the moderator for this article
590:      *
591:      * @param articleid $idart
592:      * @return string
593:      */
594:     public function getModEmail($idart) {
595:         $data = $this->readXML();
596:         for ($i = 0; $i < count($data); $i++) {
597:             if ($data[$i]['idart'] == $idart) {
598:                 return $data[$i]["email"];
599:             }
600:         }
601:         return NULL;
602:     }
603: 
604:     /**
605:      * returns if moderator mode is actice for this article
606:      *
607:      * @param articleid $idart
608:      * @return bool
609:      */
610:     public function getModeModeActive($idart) {
611:         $data = $this->readXML();
612:         for ($i = 0; $i < count($data); $i++) {
613:             if ($data[$i]['idart'] == $idart) {
614:                 if ($data[$i]["modactive"] === 'false') {
615:                     return false;
616:                 }
617:             }
618:         }
619:         return true;
620:     }
621: 
622:     /**
623:      * returns if quotes for comments are allowed in this article
624:      *
625:      * @param articleid $idart
626:      * @return bool
627:      */
628:     public function getQuoteState($idart) {
629:         // get content from con_type
630:         $data = $this->readXML();
631:         for ($i = 0; $i < count($data); $i++) {
632:             if ($data[$i]['idart'] == $idart) {
633:                 if ($data[$i]["subcomments"] === 'false') {
634:                     return false;
635:                 }
636:             }
637:         }
638:         return true;
639:     }
640: 
641:     /**
642:      * This function loads and returns the xml content from the contentType
643:      * aditionally the return array implies the articleId because of an easier
644:      * mapping in the frontend.
645:      *
646:      * @return array
647:      */
648:     public function readXML() {
649:         // get variables from global context
650:         $catId = cRegistry::getCategoryId();
651:         $idclient = cRegistry::getClientId();
652:         $cfgClient = cRegistry::getClientConfig();
653:         $idtype = $this->idContentType;
654: 
655:         try {
656:             $this->db->query("-- ArticleForumCollection->readXML()
657:                 SELECT
658:                     art_lang.idart
659:                     , content.value
660:                 FROM
661:                     `{$this->cfg[tab][art_lang]}` AS art_lang
662:                     , `{$this->cfg[tab][content]}` AS content
663:                 WHERE
664:                     art_lang.idartlang = content.idartlang
665:                     AND content.idtype = $idtype
666:                 ;");
667: 
668:             $data = array();
669:             while ($this->db->nextRecord()) {
670:                 array_push($data, $this->db->toArray());
671:             }
672: 
673:             $array = array();
674:             for ($i = 0; $i < count($data); $i++) {
675:                 $array[$i] = cXmlBase::xmlStringToArray($data[$i]['value']);
676:                 // add articleId
677:                 $array[$i]['idart'] = $data[$i]['idart'];
678:             }
679:         } catch (Exception $e) {
680: 
681:         }
682: 
683:         return $array;
684:     }
685: 
686:     /**
687:      * this function is used to get translations from the language of the
688:      * frontend module for example to generate
689:      * the e-mail text with correct language settings.
690:      *
691:      * @param array $str
692:      */
693:     public function languageSync(array &$str) {
694:         $this->languageSync = $str;
695:     }
696: 
697:     /**
698:      *
699:      * @return unknown_type multitype:
700:      */
701:     public function getlanguageSync() {
702:         if ($this->languageSync != 0) {
703:             return $this->languageSync;
704:         } else {
705:             return array();
706:         }
707:     }
708: 
709:     /**
710:      *
711:      * @param unknown_type $id_user_forum
712:      * @return multitype:NULL Ambigous <mixed, boolean>
713:      */
714:     public function getCommentContent($id_user_forum) {
715:         $item = $this->loadItem($id_user_forum);
716:         return array(
717:             'name' => $item->get("realname"),
718:             'content' => $item->get("forum")
719:         );
720:     }
721: 
722:     /**
723:      *
724:      * @return Ambigous <mixed, unknown>|boolean
725:      */
726:     protected function getIdUserForumContenType() {
727:         $this->db->query("-- ArticleForumCollection->getIdUserForumContenType()
728:             SELECT
729:                 idtype
730:             FROM
731:                 `{$this->cfg[tab][type]}`
732:             WHERE
733:                 type = 'CMS_USERFORUM'
734:             ;");
735:         if ($this->db->nextRecord()) {
736:             return $this->db->f('idtype');
737:         } else {
738:             return false;
739:         }
740:     }
741: }
742: 
743: ?>