function b_yogurt_lastpictures_show($options) { global $xoopsDB, $xoopsModule, $xoopsModuleConfig; $myts =& MyTextSanitizer::getInstance(); $block = array(); /** * Filter for fetch votes ishot and isnothot */ $criteria = new criteria('cod_img', 0, ">"); $criteria->setSort("cod_img"); $criteria->setOrder("DESC"); $criteria->setLimit($options[0]); /** * Creating factories of pictures and votes */ //$album_factory = new Xoopsyogurt_imagesHandler($xoopsDB); $pictures_factory = new Xoopsyogurt_imagesHandler($xoopsDB); $block = $pictures_factory->getLastPicturesForBlock($options[0]); return $block; }
include_once '../../mainfile.php'; $xoopsOption['template_main'] = 'yogurt_seutubo.html'; include_once '../../header.php'; include_once 'class/yogurt_controler.php'; $controler = new YogurtVideoControler($xoopsDB, $xoopsUser); /** * Fecthing numbers of tribes friends videos pictures etc... */ $nbSections = $controler->getNumbersSections(); $start = isset($_GET['start']) ? intval($_GET['start']) : 0; /** * Criteria for Videos */ $criteriaUidVideo = new criteria('uid_owner', $controler->uidOwner); $criteriaUidVideo->setStart($start); $criteriaUidVideo->setLimit($xoopsModuleConfig['videosperpage']); /** * Get all videos of this user and assign them to template */ $videos = $controler->getVideos($criteriaUidVideo); $videos_array = $controler->assignVideoContent($nbSections['nbVideos'], $videos); if (is_array($videos_array)) { $xoopsTpl->assign('videos', $videos_array); } else { $xoopsTpl->assign('lang_novideoyet', _MD_YOGURT_NOVIDEOSYET); } $pageNav = $controler->VideosNavBar($nbSections['nbVideos'], $xoopsModuleConfig['videosperpage'], $start, 2); /** * Adding to the module js and css of the lightbox and new ones */ $xoTheme->addStylesheet(XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/include/yogurt.css');
include_once '../../mainfile.php'; $xoopsOption['template_main'] = 'yogurt_audio.html'; include_once '../../header.php'; include_once 'class/yogurt_controler.php'; $controler = new YogurtAudioControler($xoopsDB, $xoopsUser); /** * Fecthing numbers of tribes friends videos pictures etc... */ $nbSections = $controler->getNumbersSections(); $start = isset($_GET['start']) ? intval($_GET['start']) : 0; /** * Criteria for Audio */ $criteriaUidAudio = new criteria('uid_owner', $controler->uidOwner); $criteriaUidAudio->setStart($start); $criteriaUidAudio->setLimit($xoopsModuleConfig['audiosperpage']); /** * Get all audios of this user and assign them to template */ $audios = $controler->getAudio($criteriaUidAudio); $audios_array = $controler->assignAudioContent($nbSections['nbAudio'], $audios); if (is_array($audios_array)) { $xoopsTpl->assign('audios', $audios_array); $audio_list = ''; foreach ($audios_array as $audio_item) { $audio_list .= '../../uploads/yogurt/mp3/' . $audio_item['url'] . ' | '; } //$audio_list = substr($audio_list,-2); $xoopsTpl->assign('audio_list', $audio_list); } else { $xoopsTpl->assign('lang_noaudioyet', _MD_YOGURT_NOAUDIOYET);
public static function getForExpertCategory($iCategoryId) { $c = new criteria(); $c->addJoin(UserPeer::ID, ExpertCategoryPeer::USER_ID, Criteria::JOIN); $c->add(ExpertCategoryPeer::CATEGORY_ID, $iCategoryId); $c->addDescendingOrderbyColumn(UserPeer::POINTS); $c->setLimit(5); $c->setDistinct(); return UserPeer::doSelect($c); }