function &getList($avatar_type = null, $avatar_display = null)
{
$criteria = new CriteriaCompo();
if (isset($avatar_type)) {
$avatar_type = ($avatar_type == 'C') ? 'C' : 'S';
$criteria->add(new Criteria('avatar_type', $avatar_type));
}
if (isset($avatar_display)) {
$criteria->add(new Criteria('avatar_display', intval($avatar_display)));
}
$avatars =& $this->getObjects($criteria, true);
$ret = array();
$ret[] = array(
'id' => 0,
'name' => _NONE,
'file' => 'blank.gif',
);
if(is_array($avatars)){
foreach ($avatars as $id => $obj) {
$ret[] = array(
'id' => $id,
'name' => $obj->getVar('avatar_name'),
'file' => $obj->getVar('avatar_file'),
);
}
}
return $ret;
}
function xoops_module_update_ckeditor4()
{
$module_handler = xoops_gethandler('module');
$Module = $module_handler->getByDirname('ckeditor4');
$config_handler = xoops_gethandler('config');
$mid = $Module->mid();
$ModuleConfig = $config_handler->getConfigsByCat(0, $mid);
if (substr($ModuleConfig['toolbar_user'], -4) === '""]]') {
//fix typo '""]]' to '"]]' for version <= 0.37
$criteria = new CriteriaCompo(new Criteria('conf_modid', $mid));
$criteria->add(new Criteria('conf_catid', 0));
$criteria->add(new Criteria('conf_name', 'toolbar_user'));
if ($configs = $config_handler->_cHandler->getObjects($criteria)) {
$val = str_replace('""]]', '"]]', $ModuleConfig['toolbar_user']);
$configs[0]->setVar('conf_value', $val, true);
$config_handler->insertConfig($configs[0]);
}
}
if (preg_match('/^head\\s*$/m', $ModuleConfig['contentsCss'])) {
//fix typo 'head' to '<head>' for version <= 0.38
$criteria = new CriteriaCompo(new Criteria('conf_modid', $mid));
$criteria->add(new Criteria('conf_catid', 0));
$criteria->add(new Criteria('conf_name', 'contentsCss'));
if ($configs = $config_handler->_cHandler->getObjects($criteria)) {
$val = preg_replace('/^head(\\s*)$/m', '<head>$1', $ModuleConfig['contentsCss']);
$configs[0]->setVar('conf_value', $val, true);
$config_handler->insertConfig($configs[0]);
}
}
return true;
}
/**
* @param int $uid
*
* @return int
*/
public function userPosts($uid)
{
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('content_status', 0, '!='));
$criteria->add(new Criteria('content_author', (int) $uid));
return Page::getInstance()->getContentHandler()->getCount($criteria);
}
/**
* @param int $uid
*
* @return int
*/
public function userPosts($uid)
{
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('content_status', 0, '!='));
$criteria->add(new Criteria('content_author', (int) $uid));
return \Xoops::getModuleHelper('page')->getContentHandler()->getCount($criteria);
}
function get_system_main_menu_show()
{
global $xoopsUser, $xoopsModule;
$block = array();
$block['lang_home'] = _MB_SYSTEM_HOME;
$block['lang_close'] = _CLOSE;
$module_handler =& xoops_gethandler('module');
$criteria = new CriteriaCompo(new Criteria('hasmain', 1));
$criteria->add(new Criteria('isactive', 1));
$criteria->add(new Criteria('weight', 0, '>'));
$modules = $module_handler->getObjects($criteria, true);
$moduleperm_handler =& xoops_gethandler('groupperm');
$groups = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;
$read_allowed = $moduleperm_handler->getItemIds('module_read', $groups);
foreach (array_keys($modules) as $i) {
if (in_array($i, $read_allowed)) {
$block['modules'][$i]['name'] = $modules[$i]->getVar('name');
$block['modules'][$i]['directory'] = $modules[$i]->getVar('dirname');
$sublinks = $modules[$i]->subLink();
if (count($sublinks) > 0) {
foreach ($sublinks as $sublink) {
$block['modules'][$i]['sublinks'][] = array('name' => $sublink['name'], 'url' => XOOPS_URL . '/modules/' . $modules[$i]->getVar('dirname') . '/' . $sublink['url']);
}
} else {
$block['modules'][$i]['sublinks'] = array();
}
}
}
return $block;
}
function checkRight($gperm_name, $gperm_itemid, $gperm_groupid, $gperm_modid = 1)
{
//ver3.0 by domifara
if (isset($this->gpermission[$gperm_name]) && isset($this->gpermission[$gperm_name][$gperm_itemid]) && isset($this->gpermission[$gperm_name][$gperm_itemid][serialize($gperm_groupid)]) && isset($this->gpermission[$gperm_name][$gperm_itemid][serialize($gperm_groupid)][$gperm_modid])) {
return $this->gpermission[$gperm_name][$gperm_itemid][serialize($gperm_groupid)][$gperm_modid];
}
$criteria = new CriteriaCompo(new Criteria('gperm_modid', $gperm_modid));
$criteria->add(new Criteria('gperm_name', $gperm_name));
$gperm_itemid = intval($gperm_itemid);
if ($gperm_itemid > 0) {
$criteria->add(new Criteria('gperm_itemid', $gperm_itemid));
}
if (is_array($gperm_groupid)) {
$criteria2 = new CriteriaCompo();
foreach ($gperm_groupid as $key => $gid) {
$criteria2->add(new Criteria('gperm_groupid', $gid), 'OR');
}
$criteria->add($criteria2);
} else {
$criteria->add(new Criteria('gperm_groupid', $gperm_groupid));
}
$ret = false;
if ($this->getCount($criteria) > 0) {
$ret = true;
}
$this->gpermission[$gperm_name][$gperm_itemid][serialize($gperm_groupid)][$gperm_modid] = $ret;
return $ret;
}
function about_block_page_edit($options)
{
@(include dirname(dirname(__FILE__)) . "/xoops_version.php");
$page_handler =& xoops_getmodulehandler('page', 'about');
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('page_status', 1), 'AND');
$criteria->add(new Criteria('page_type', 1));
$criteria->setSort('page_order');
$criteria->setOrder('ASC');
$fields = array("page_id", "page_title", "page_image");
$pages = $page_handler->getAll($criteria, $fields, false);
$page_title = '';
foreach ($pages as $k => $v) {
$page_title = '<a href="' . XOOPS_URL . '/modules/' . $modversion['dirname'] . '/index.php?page_id=' . $k . '" target="_blank">' . $v['page_title'] . '</a>';
$options_page[$k] = empty($v['page_image']) ? $page_title : $page_title . '<img src="' . XOOPS_URL . '/modules/' . $modversion['dirname'] . '/images/picture.png' . '" />';
}
include_once dirname(dirname(__FILE__)) . '/include/xoopsformloader.php';
$form = new XoopsBlockForm();
$page_select = new XoopsFormRadio(_MI_ABOUT_BLOCKPAGE, 'options[0]', $options[0], '<br />');
$page_select->addOptionArray($options_page);
$form->addElement($page_select);
$form->addElement(new XoopsFormText(_MI_ABOUT_TEXT_LENGTH, 'options[1]', 5, 5, $options[1]));
$form->addElement(new XoopsFormText(_MI_ABOUT_VIEW_MORELINKTEXT, 'options[2]', 30, 50, $options[2]));
$form->addElement(new XoopsFormRadioYN(_MI_ABOUT_DOTITLEIMAGE, 'options[3]', $options[3]));
return $form->render();
}
function &getModule()
{
global $xoopsUser;
$ret = NULL;
if(empty($this->module_dirname) || empty($this->user_blog_url)){
return $ret;
}
$criteria = new CriteriaCompo(new Criteria('hassearch', 1));
$criteria->add(new Criteria('isactive', 1));
$criteria->add(new Criteria('dirname', $this->module_dirname));
$module_handler =& xoops_gethandler('module');
$blog_module_list =& $module_handler->getList($criteria);
if(count($blog_module_list) != 1){
return $ret;
}
$blog_module =& $module_handler->getByDirName($this->module_dirname);
if(!is_object($blog_module) || strtolower(get_class($blog_module))!='xoopsmodule'){
return $ret;
}
$gperm_handler =& xoops_gethandler('groupperm');
$groups = is_object($xoopsUser)? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;
if($gperm_handler->checkRight('module_read', $blog_module->getVar('mid'), $groups)) {
$ret =& $blog_module;
}
return $ret;
}
function getGrantedGroupsForIds($item_ids_array, $gperm_name = false)
{
static $groups;
if ($gperm_name) {
if (isset($groups[$gperm_name])) {
return $groups[$gperm_name];
}
} else {
// if !$gperm_name then we will fetch all permissions in the module so we don't need them again
return $groups;
}
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('gperm_modid', $this->mid));
if ($gperm_name) {
$criteria->add(new Criteria('gperm_name', $gperm_name));
}
$objs = $this->getObjects($criteria);
foreach ($objs as $obj) {
$groups[$obj->getVar('gperm_name')][$obj->getVar('gperm_itemid')][] = $obj->getVar('gperm_groupid');
}
//Return the permission array
if ($gperm_name) {
return isset($groups[$gperm_name]) ? $groups[$gperm_name] : array();
} else {
return isset($groups) ? $groups : array();
}
}
function publisher_date_to_date_show($options)
{
$myts = MyTextSanitizer::getInstance();
$publisher = PublisherPublisher::getInstance();
$block = array();
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('datesub', strtotime($options[0]), '>'));
$criteria->add(new Criteria('datesub', strtotime($options[1]), '<'));
$criteria->setSort('datesub');
$criteria->setOrder('DESC');
// creating the ITEM objects that belong to the selected category
$itemsObj = $publisher->getHandler('item')->getObjects($criteria);
$totalItems = count($itemsObj);
if ($itemsObj) {
for ($i = 0; $i < $totalItems; $i++) {
$newItems['itemid'] = $itemsObj[$i]->itemid();
$newItems['title'] = $itemsObj[$i]->title();
$newItems['categoryname'] = $itemsObj[$i]->getCategoryName();
$newItems['categoryid'] = $itemsObj[$i]->categoryid();
$newItems['date'] = $itemsObj[$i]->datesub();
$newItems['poster'] = $itemsObj[$i]->linkedPosterName();
$newItems['itemlink'] = $itemsObj[$i]->getItemLink(false, isset($options[3]) ? $options[3] : 65);
$newItems['categorylink'] = $itemsObj[$i]->getCategoryLink();
$block['items'][] = $newItems;
}
$block['lang_title'] = _MB_PUBLISHER_ITEMS;
$block['lang_category'] = _MB_PUBLISHER_CATEGORY;
$block['lang_poster'] = _MB_PUBLISHER_POSTEDBY;
$block['lang_date'] = _MB_PUBLISHER_DATE;
$modulename = $myts->displayTarea($publisher->getModule()->getVar('name'));
$block['lang_visitItem'] = _MB_PUBLISHER_VISITITEM . " " . $modulename;
$block['lang_articles_from_to'] = sprintf(_MB_PUBLISHER_ARTICLES_FROM_TO, $options[0], $options[1]);
}
return $block;
}
/**
* xoopsfaq_search()
*
* @param mixed $queryarray
* @param mixed $andor
* @param mixed $limit
* @param mixed $offset
* @param mixed $userid
* @return
*/
function xoopsfaq_search($queryarray, $andor, $limit, $offset, $userid)
{
global $xoopsDB;
$ret = array();
if ($userid != 0) {
return $ret;
}
$xfDir = basename(dirname(dirname(__FILE__)));
$xfContentsHandler =& xoops_getmodulehandler('contents', $xfDir);
$contentFields = array('contents_id', 'contents_cid', 'contents_title', 'contents_contents', 'contents_publish');
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('contents_active', 1, '='));
$criteria->setSort('contents_id');
$criteria->setOrder('DESC');
$criteria->setLimit(intval($limit));
$criteria->setStart(intval($offset));
if (is_array($queryarray) && !empty($queryarray)) {
$criteria->add(new Criteria('contents_title', "%{$queryarray[0]}%", 'LIKE'));
$criteria->add(new Criteria('contents_contents', "%{$queryarray[0]}%", 'LIKE'), 'OR');
array_shift($queryarray);
//get rid of first element
foreach ($queryarray as $query) {
$criteria->add(new Criteria('contents_title', "%{$query}%", 'LIKE'), $andor);
$criteria->add(new Criteria('contents_contents', "%{$query}%", 'LIKE'), 'OR');
}
}
$contentArray = $xfContentsHandler->getAll($criteria, $contentFields, false);
foreach ($contentArray as $content) {
$ret[] = array('image' => 'images/question2.gif', 'link' => "index.php?cat_id=" . $content['contents_cid'] . "#" . $content['contents_id'], 'title' => $content['contents_title'], 'time' => $content['contents_publish']);
}
unset($contentArray);
return $ret;
}
function update_block_permissions($old_gid, $new_gid)
{
// get handlers
$gperm_handler =& xoops_gethandler('groupperm');
$module_handler =& xoops_gethandler('module');
$module =& $module_handler->getByDirname('xoonips');
$mid = $module->getVar('mid');
$block_objs =& XoopsBlock::getByModule($mid);
foreach ($block_objs as $block_obj) {
// find moderator menu block
if ($block_obj->getVar('show_func') == 'b_xoonips_moderator_show') {
$bid = $block_obj->getVar('bid');
// if old_gid don't have module admin right,
// delete the right to access from old_gid.
if (!$gperm_handler->checkRight('module_admin', $mid, $old_gid)) {
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('gperm_groupid', $old_gid));
$criteria->add(new Criteria('gperm_itemid', $bid));
$criteria->add(new Criteria('gperm_name', 'block_read'));
$gperm_handler->deleteAll($criteria);
}
// if there is no right to access moderator block in new_gid,
// the right gives new_gid.
if (!$gperm_handler->checkRight('block_read', $bid, $new_gid)) {
$gperm_handler->addRight('block_read', $bid, $new_gid);
}
break;
}
}
}
public static function makeKeywordCriteria(CriteriaCompo $cri, $dirname, $keywords, $andor = 'AND')
{
$handler = Legacy_Utils::getModuleHandler('definition', $dirname);
//keywords
$keywordArr = self::splitKeywords($keywords);
//definition
$cri->add(new Criteria('search_flag', 1));
$cri->add(new Criteria('field_type', array(Xcck_FieldType::STRING, Xcck_FieldType::TEXT, Xcck_FieldType::URI), 'IN'));
$defObjs = $handler->getObjects($cri);
foreach ($defObjs as $obj) {
$fieldList['field_name'][] = $obj->get('field_name');
$fieldList['field_type'][] = $obj->get('field_type');
}
//page
$cri = new CriteriaCompo();
foreach ($defObjs as $def) {
foreach ($keywordArr as $keyword) {
if (strtoupper($andor) === 'OR') {
$cri->add(new Criteria($def->get('field_name'), self::makeKeyword($keyword), 'LIKE'), 'OR');
} else {
$cri->add(new Criteria($def->get('field_name'), self::makeKeyword($keyword), 'LIKE'));
}
}
}
return $cri;
}
function getGrantedGroupsForIds($item_ids_array, $gperm_name = false)
{
static $groups;
static $smartsection_all_permissions_fetched;
if ($gperm_name) {
if (isset($groups[$gperm_name])) {
return $groups[$gperm_name];
}
} else {
// if !$gperm_name then we will fetch all permissions in the module so we don't need them again
if ($smartsection_all_permissions_fetched) {
return $groups;
} else {
$smartsection_all_permissions_fetched = true;
}
}
$smartModule =& smartsection_getModuleInfo();
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('gperm_modid', $smartModule->getVar('mid')));
if ($gperm_name) {
$criteria->add(new Criteria('gperm_name', $gperm_name));
}
//Get group permissions handler
$gperm_handler =& xoops_gethandler('groupperm');
$permissionsObj = $gperm_handler->getObjects($criteria);
foreach ($permissionsObj as $permissionObj) {
$groups[$permissionObj->getVar('gperm_name')][$permissionObj->getVar('gperm_itemid')][] = $permissionObj->getVar('gperm_groupid');
}
//Return the permission array
if ($gperm_name) {
return isset($groups[$gperm_name]) ? $groups[$gperm_name] : array();
} else {
return isset($groups) ? $groups : array();
}
}
/**
* XXX
*
* @copyright XOOPS Project (http://xoops.org)
* @license GNU GPL 2 or later (http://www.gnu.org/licenses/gpl-2.0.html)
* @since 2.6.0
* @author Mage Grégory (AKA Mage)
* @version $Id: $
*/
function xoops_module_update_search(XoopsModule &$module)
{
$xoops = Xoops::getInstance();
// Copy old configs in new configs and delete old configs
$config_handler = $xoops->getHandlerConfig();
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('conf_modid', 0));
$criteria->add(new Criteria('conf_catid', 5));
$configs = $config_handler->getConfigs($criteria);
$confcount = count($configs);
if ($confcount > 0) {
for ($i = 0; $i < $confcount; ++$i) {
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('conf_modid', $module->getVar('mid')));
$criteria->add(new Criteria('conf_name', $configs[$i]->getvar('conf_name')));
$new_configs = $config_handler->getConfigs($criteria);
$new_confcount = count($new_configs);
if ($new_confcount > 0) {
for ($j = 0; $j < $new_confcount; ++$j) {
$obj = $config_handler->getConfig($new_configs[$j]->getvar('conf_id'));
}
$obj->setVar("conf_value", $configs[$i]->getvar('conf_value'));
$config_handler->insertConfig($obj);
$config_handler->deleteConfig($configs[$i]);
}
}
}
return true;
}
/**
* _setupObject
*
* @param void
*
* @return void
**/
protected function _setupObject()
{
$dirname = $this->mRoot->mContext->mRequest->getRequest('dirname');
$dataname = $this->mRoot->mContext->mRequest->getRequest('dataname');
$groupId = $this->mRoot->mContext->mRequest->getRequest('group_id');
XCube_DelegateUtils::call('Legacy_GroupClient.GetActionList', new XCube_Ref($this->mActionList), $dirname, $dataname);
$this->mObjectHandler =& $this->_getHandler();
$cri = new CriteriaCompo();
$cri->add(new Criteria('dirname', $dirname));
$cri->add(new Criteria('dataname', $dataname));
$cri->add(new Criteria('group_id', $groupId));
$cri->add(new Criteria('action', $this->mActionList['action'], 'IN'));
$this->mObject = $this->mObjectHandler->getObjects($cri);
if (count($this->mObject) < count($this->mActionList['action'])) {
foreach (array_keys($this->mActionList['action']) as $key) {
if (!$this->_checkObject($this->mActionList['action'][$key])) {
$obj = $this->mObjectHandler->create();
$obj->set('group_id', $groupId);
$obj->set('dirname', $dirname);
$obj->set('dataname', $dataname);
$obj->set('action', $this->mActionList['action'][$key]);
$obj->set('rank', $this->mActionList['rank'][$key]);
$this->mObject[] = $obj;
unset($obj);
}
}
}
$this->mPolicyArr = array('groupId' => $groupId, 'dirname' => $dirname, 'dataname' => $dataname);
}
/**
* @param $options
* @return array
*/
function alumni_show($options)
{
$block = array();
$myts = MyTextSanitizer::getInstance();
$xoops = Xoops::getInstance();
$helper = $xoops->getModuleHelper('alumni');
$module_id = $helper->getModule()->getVar('mid');
$listingHandler = $helper->getHandler('listing');
$groups = $xoops->getUserGroups();
$alumni_ids = $xoops->getHandlerGroupPermission()->getItemIds('alumni_view', $groups, $module_id);
$all_ids = implode(', ', $alumni_ids);
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('valid', 1, '='));
$criteria->add(new Criteria('cid', '(' . $all_ids . ')', 'IN'));
$criteria->setLimit($options[1]);
$criteria->setSort('date');
$criteria->setOrder('DESC');
$block_listings = $listingHandler->getall($criteria);
foreach (array_keys($block_listings) as $i) {
$name = $block_listings[$i]->getVar('name');
$mname = $block_listings[$i]->getVar('mname');
$lname = $block_listings[$i]->getVar('lname');
$school = $block_listings[$i]->getVar('school');
$year = $block_listings[$i]->getVar('year');
$view = $block_listings[$i]->getVar('view');
$a_item = array();
$a_item['school'] = $school;
$a_item['link'] = '<a href="' . XOOPS_URL . "/modules/alumni/listing.php?lid=" . addslashes($block_listings[$i]->getVar('lid')) . "\"><b>{$year} - {$name} {$mname} {$lname}</b><br /></a>";
$block['items'][] = $a_item;
}
$block['lang_title'] = AlumniLocale::BLOCKS_ITEM;
$block['lang_date'] = AlumniLocale::BLOCKS_DATE;
$block['link'] = "<a href=\"" . XOOPS_URL . "/modules/alumni/index.php\"><b>" . AlumniLocale::BLOCKS_ALL_LISTINGS . "</b></a></div>";
return $block;
}
function checkLogin(&$xoopsUser)
{
$root =& XCube_Root::getSingleton();
if ($root->mContext->mUser->isInRole('Site.RegisteredUser')) {
return;
}
$root->mLanguageManager->loadModuleMessageCatalog('user');
$userHandler =& xoops_getmodulehandler('users', 'user');
$criteria = new CriteriaCompo();
if (xoops_getrequest('uname') != "" && strpos(xoops_getrequest('uname'), '@') !== false) {
$criteria->add(new Criteria('email', xoops_getrequest('uname')));
} else {
$criteria->add(new Criteria('uname', xoops_getrequest('uname')));
// use for both e-mail or uname logiin
// $criteria->add(new Criteria('uname','')); // use for only e-mail logiin
}
$criteria->add(new Criteria('pass', md5(xoops_getrequest('pass'))));
$userArr =& $userHandler->getObjects($criteria);
if (count($userArr) != 1) {
return;
}
if ($userArr[0]->get('level') == 0) {
return;
}
$handler =& xoops_gethandler('user');
$user =& $handler->get($userArr[0]->get('uid'));
$xoopsUser = $user;
require_once XOOPS_ROOT_PATH . '/include/session.php';
xoops_session_regenerate();
$_SESSION = array();
$_SESSION['xoopsUserId'] = $xoopsUser->get('uid');
$_SESSION['xoopsUserGroups'] = $xoopsUser->getGroups();
}
function dispatch()
{
global $xoopsUser, $xoopsUserIsAdmin;
if($this->isGuest() || !$this->validateToken('MEMBER_EDIT')){
redirect_header(XOOPS_URL, 2, _NOPERM);
}
$own_uid = $xoopsUser->getVar('uid');
$cid = $this->getIntRequest('cid');
$uid = $this->getIntRequest('uid');
if(!$cid || !$uid || $uid == $own_uid){
redirect_header(XOOPS_URL, 2, _NOPERM);
}
// コミュニティの取得
$perm = XSNS_AUTH_XOOPS_ADMIN | XSNS_AUTH_ADMIN;
$commu_handler =& XsnsCommunityHandler::getInstance();
$community =& $commu_handler->get($cid);
if(!is_object($community) || !$community->checkAuthority($perm)){
redirect_header(XOOPS_URL, 2, _NOPERM);
}
// 対象コミュニティメンバーの取得
$c_member_handler =& XsnsMemberHandler::getInstance();
$c_member =& $c_member_handler->getOne($cid, $uid);
if(!is_object($c_member)){
redirect_header(XOOPS_URL, 2, _NOPERM);
}
$c_member_info =& $c_member->getInfo();
// コミュニティメンバーの強制退会
if($c_member_handler->delete($c_member)){
// 既存の依頼を削除
$confirm_handler =& XsnsConfirmHandler::getInstance();
$criteria = new CriteriaCompo(new Criteria('c_commu_id', $cid));
$criteria->add(new Criteria('uid_from', $own_uid));
$criteria->add(new Criteria('uid_to', $uid));
$criteria->add(new Criteria('mode', '(1,2)', 'IN')); // 管理者交代 or 副管理者就任
$confirm_handler->deleteObjects($criteria);
// XOOPS管理者による特別な処理
if($xoopsUserIsAdmin){
// 対象が管理者の場合、自分が管理者に代わる
if($uid == $community->getVar('uid_admin')){
$community->setVar('uid_admin', $own_uid);
}
// 対象が副管理者の場合、副管理者は無しにする
elseif($uid == $community->getVar('uid_sub_admin')){
$community->setVar('uid_sub_admin', 0);
}
$commu_handler->insert($community);
}
redirect_header(XSNS_URL_COMMU.'?cid='.$cid, 2, sprintf(_MD_XSNS_MEMBER_LEAVE_OK, $c_member_info['name']));
}
redirect_header(XSNS_URL_COMMU, 2, _MD_XSNS_MEMBER_LEAVE_NG);
}
/**
* Export data
* @return boolean
*/
function export()
{
$def = array(array('o_id', 'N', 10, 0), array('o_uid', 'N', 10, 0), array('o_date', 'D'), array('o_state', 'N', 1, 0), array('o_ip', 'C', 32), array('o_lastname', 'C', 155), array('o_firstnam', 'C', 155), array('o_adress', 'C', 155), array('o_zip', 'C', 30), array('o_town', 'C', 155), array('o_country', 'C', 3), array('o_telephon', 'C', 30), array('o_email', 'C', 155), array('o_articles', 'N', 10, 0), array('o_total', 'N', 10, 2), array('o_shipping', 'N', 10, 2), array('o_bill', 'L'), array('o_password', 'C', 155), array('o_text', 'C', 155), array('o_cancel', 'C', 155), array('c_id', 'N', 10, 0), array('c_prod_id', 'N', 10, 0), array('c_qte', 'N', 10, 0), array('c_price', 'N', 10, 2), array('c_o_id', 'N', 10, 0), array('c_shipping', 'N', 10, 2), array('c_pass', 'C', 155));
/*
* Correspondances
* cmd_id o_id
* cmd_uid o_uid
* cmd_date o_date
* cmd_state o_state
* cmd_ip o_ip
* cmd_lastname o_lastname
* cmd_firstname o_firstnam
* cmd_adress o_adress
* cmd_zip o_zip
* cmd_town o_town
* cmd_country o_country
* cmd_telephone o_telephon
* cmd_email o_email
* cmd_articles_count o_articles
* cmd_total o_total
* cmd_shipping o_shipping
* cmd_bill o_bill
* cmd_password o_password
* cmd_text o_text
* cmd_cancel o_cancel
* caddy_id c_id
* caddy_product_id c_prod_id
* caddy_qte c_qte
* caddy_price c_price
* caddy_cmd_id c_o_id
* caddy_shipping c_shipping
* caddy_pass c_pass
*/
if (!dbase_create($this->folder . DIRECTORY_SEPARATOR . $this->filename, $def)) {
$this->success = false;
return false;
}
$dbf = dbase_open($this->folder . DIRECTORY_SEPARATOR . $this->filename, 2);
if ($dbf === false) {
$this->success = false;
return false;
}
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('cmd_id', 0, '<>'));
$criteria->add(new Criteria('cmd_state', $this->orderType, '='));
$criteria->setSort('cmd_date');
$criteria->setOrder('DESC');
$orders = $this->handlers->h_myshop_commands->getObjects($criteria);
foreach ($orders as $order) {
$carts = array();
$carts = $this->handlers->h_myshop_caddy->getObjects(new Criteria('caddy_cmd_id', $order->getVar('cmd_id'), '='));
foreach ($carts as $cart) {
dbase_add_record($dbf, array($order->getVar('cmd_id'), $order->getVar('cmd_uid'), date('Ymd', strtotime($order->getVar('cmd_date'))), $order->getVar('cmd_state'), $order->getVar('cmd_ip'), $order->getVar('cmd_lastname'), $order->getVar('cmd_firstname'), $order->getVar('cmd_adress'), $order->getVar('cmd_zip'), $order->getVar('cmd_town'), $order->getVar('cmd_country'), $order->getVar('cmd_telephone'), $order->getVar('cmd_email'), $order->getVar('cmd_articles_count'), $order->getVar('cmd_total'), $order->getVar('cmd_shipping'), $order->getVar('cmd_bill'), $order->getVar('cmd_password'), $order->getVar('cmd_text'), $order->getVar('cmd_cancel'), $cart->getVar('caddy_id'), $cart->getVar('caddy_product_id'), $cart->getVar('caddy_qte'), $cart->getVar('caddy_price'), $cart->getVar('caddy_cmd_id'), $cart->getVar('caddy_shipping'), $cart->getVar('caddy_pass')));
}
}
dbase_close($dbf);
$this->success = true;
return true;
}
function isUserOfGroup($uid, $groupid)
{
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('groupid', $groupid));
$criteria->add(new Criteria('uid', $uid));
$objs =& $this->getObjects($criteria);
return count($objs) > 0 && is_object($objs[0]);
}
function fetch()
{
parent::fetch();
$root =& XCube_Root::getSingleton();
$image_display = $root->mContext->mRequest->getRequest('image_display');
$imgcat_id = $root->mContext->mRequest->getRequest('imgcat_id');
$option_field = $root->mContext->mRequest->getRequest('option_field');
$option_field2 = $root->mContext->mRequest->getRequest('option_field2');
$search = $root->mContext->mRequest->getRequest('search');
if (isset($_REQUEST['image_display'])) {
$this->mNavi->addExtra('image_display', xoops_getrequest('image_display'));
$this->_mCriteria->add(new Criteria('image_display', xoops_getrequest('image_display')));
}
if (isset($_REQUEST['imgcat_id'])) {
$this->mNavi->addExtra('imgcat_id', xoops_getrequest('imgcat_id'));
$this->_mCriteria->add(new Criteria('imgcat_id', xoops_getrequest('imgcat_id')));
}
if (isset($_REQUEST['option_field'])) {
$this->mNavi->addExtra('option_field', $option_field);
$this->mOptionField = $option_field;
if ($this->mOptionField == "visible") {
$this->_mCriteria->add(new Criteria('image_display', '1'));
} elseif ($this->mOptionField == "invisible") {
$this->_mCriteria->add(new Criteria('image_display', '0'));
} else {
//all
}
}
if (isset($_REQUEST['option_field2'])) {
$this->mNavi->addExtra('option_field2', $option_field2);
$this->mOptionField2 = $option_field2;
if ($this->mOptionField2 == "gif") {
$this->_mCriteria->add(new Criteria('image_mimetype', 'image/gif'));
} elseif ($this->mOptionField2 == "png") {
$this->_mCriteria->add(new Criteria('image_mimetype', 'image/png'));
} elseif ($this->mOptionField2 == "jpeg") {
$cri = new CriteriaCompo();
$cri->add(new Criteria('image_mimetype', 'image/jpeg'));
$cri->add(new Criteria('image_mimetype', 'image/pjpeg'), 'OR');
$this->_mCriteria->add($cri);
} else {
//all
}
}
//
if (!empty($search)) {
$this->mKeyword = $search;
$this->mNavi->addExtra('search', $this->mKeyword);
$this->_mCriteria->add(new Criteria('image_nicename', '%' . $this->mKeyword . '%', 'LIKE'));
}
$this->_mCriteria->addSort($this->getSort(), $this->getOrder());
/*
if (abs($this->mSort) != IMAGE_SORT_KEY_IMAGE_WEIGHT) {
$this->_mCriteria->addSort($this->mSortKeys[IMAGE_SORT_KEY_IMAGE_WEIGHT], $this->getOrder());
}
*/
}
/**
* @param int $uid
*
* @return int
*/
public function userPosts($uid)
{
$comments = \Xoops::getModuleHelper('comments');
//need this here to init constants
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('status', Comments::STATUS_ACTIVE));
$criteria->add(new Criteria('uid', $uid));
return $comments->getHandlerComment()->getCount($criteria);
}
/**
* @param int $uid
*
* @return int
*/
public function userPosts($uid)
{
$comments = Comments::getInstance();
//need this here to init constants
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('status', COMMENTS_ACTIVE));
$criteria->add(new Criteria('uid', $uid));
return Comments::getInstance()->getHandlerComment()->getCount($criteria);
}
public function getLatestRevision($pageId, $status = Lenum_Status::PROGRESS)
{
$cri = new CriteriaCompo();
$cri->add(new Criteria('page_id', $pageId));
$cri->add(new Criteria('status', $status, '>='));
$cri->setSort('revision_id', 'DESC');
$objs = $this->getObjects($cri);
return count($objs) > 0 ? array_shift($objs) : null;
}
/**
* Gets users who this mailjob will send mail to, with $retry number.
* @param int $retry
*/
function &getUsers($retry)
{
$handler =& xoops_getmodulehandler('mailjob_link', 'user');
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('mailjob_id', $this->get('mailjob_id')));
$criteria->add(new Criteria('retry', $retry));
$arr =& $handler->getObjects($criteria);
return $arr;
}
function setContent($isreturn = false)
{
global $jieqiTpl;
global $jieqiConfigs;
jieqi_getconfigs('article', 'configs');
$article_static_url = empty($jieqiConfigs['article']['staticurl']) ? $GLOBALS['jieqiModules']['article']['url'] : $jieqiConfigs['article']['staticurl'];
$article_dynamic_url = empty($jieqiConfigs['article']['dynamicurl']) ? $GLOBALS['jieqiModules']['article']['url'] : $jieqiConfigs['article']['dynamicurl'];
$jieqiTpl->assign('article_static_url', $article_static_url);
$jieqiTpl->assign('article_dynamic_url', $article_dynamic_url);
jieqi_includedb();
$query = JieqiQueryHandler::getInstance('JieqiQueryHandler');
$criteria = new CriteriaCompo();
$criteria->setFields("r.*,a.articlename");
$criteria->setTables(jieqi_dbprefix('article_reviews') . " AS r LEFT JOIN " . jieqi_dbprefix('article_article') . " AS a ON r.ownerid=a.articleid");
if ($this->exevars['istop'] == 1) {
$criteria->add(new Criteria('r.istop', '1'));
} elseif ($this->exevars['istop'] == 2) {
$criteria->add(new Criteria('r.istop', '0'));
}
if ($this->exevars['isgood'] == 1) {
$criteria->add(new Criteria('r.isgood', '1'));
} elseif ($this->exevars['isgood'] == 2) {
$criteria->add(new Criteria('r.isgood', '0'));
}
$criteria->setSort('r.topicid');
$criteria->setOrder('DESC');
$criteria->setLimit($this->exevars['listnum']);
$criteria->setStart(0);
$query->queryObjects($criteria);
$reviewrows = array();
$i = 0;
while ($v = $query->getObject()) {
$reviewrows[$i]['reviewtitle'] = jieqi_htmlstr(str_replace(array("\r", "\n"), array('', ' '), $v->getVar('title', 'n')));
$reviewrows[$i]['ownerid'] = $v->getVar('ownerid');
$reviewrows[$i]['articlename'] = $v->getVar('articlename');
$reviewrows[$i]['topicid'] = $v->getVar('topicid');
$reviewrows[$i]['url_review'] = $article_dynamic_url . '/reviews.php?aid=' . $v->getVar('ownerid');
$reviewrows[$i]['poster'] = $v->getVar('poster');
$reviewrows[$i]['posterid'] = $v->getVar('posterid');
$reviewrows[$i]['postdate'] = date('m-d H:i', $v->getVar('posttime'));
$reviewrows[$i]['posttime'] = $v->getVar('posttime');
$reviewrows[$i]['replytime'] = $v->getVar('replytime');
$reviewrows[$i]['views'] = $v->getVar('views');
$reviewrows[$i]['replies'] = $v->getVar('replies');
$reviewrows[$i]['islock'] = $v->getVar('islock');
$reviewrows[$i]['istop'] = $v->getVar('istop');
$reviewrows[$i]['isgood'] = $v->getVar('isgood');
$reviewrows[$i]['topictype'] = $v->getVar('topictype');
$reviewrows[$i]['url_articleinfo'] = jieqi_geturl('article', 'article', $v->getVar('ownerid'), 'info');
$reviewrows[$i]['url_articleindex'] = jieqi_geturl('article', 'article', $v->getVar('ownerid'), 'index');
$reviewrows[$i]['url_articleread'] = $reviewrows[$i]['url_articleindex'];
$i++;
}
$jieqiTpl->assign_by_ref('reviewrows', $reviewrows);
$jieqiTpl->assign('url_more', $article_dynamic_url . '/reviewslist.php');
}
/**
* _getPermit
*
* @param int $groupId
*
* @return Lecat_PermitObject[]
**/
protected function _getPermit($groupid = 0)
{
$handler = Legacy_Utils::getModuleHandler('permit', $this->mAsset->mDirname);
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('cat_id', 0));
if (intval($groupid) > 0) {
$criteria->add(new Criteria('groupid', $groupid));
}
return $handler->getObjects($criteria);
}
function setContent($isreturn = false)
{
global $jieqiTpl;
include_once JIEQI_ROOT_PATH . '/class/ptopics.php';
$ptopics_handler =& JieqiPtopicsHandler::getInstance('JieqiPtopicsHandler');
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('ownerid', $this->blockvars['cacheid']));
if ($this->exevars['istop'] == 1) {
$criteria->add(new Criteria('istop', 1));
} elseif ($this->exevars['istop'] == 2) {
$criteria->add(new Criteria('istop', 0));
}
if ($this->exevars['isgood'] == 1) {
$criteria->add(new Criteria('isgood', 1));
} elseif ($this->exevars['isgood'] == 2) {
$criteria->add(new Criteria('isgood', 0));
}
if ($this->exevars['islock'] == 1) {
$criteria->add(new Criteria('islock', 1));
} elseif ($this->exevars['islock'] == 2) {
$criteria->add(new Criteria('islock', 0));
}
$criteria->setSort($this->exevars['field']);
if ($this->exevars['asc'] == 1) {
$criteria->setOrder('ASC');
} else {
$criteria->setOrder('DESC');
}
$criteria->setLimit($this->exevars['listnum']);
$criteria->setStart(0);
$ptopics_handler->queryObjects($criteria);
$ptopicrows = array();
$k = 0;
while ($v = $ptopics_handler->getObject()) {
$ptopicrows[$k]['istop'] = $v->getVar('istop');
$ptopicrows[$k]['isgood'] = $v->getVar('isgood');
$ptopicrows[$k]['islock'] = $v->getVar('islock');
$ptopicrows[$k]['topicid'] = $v->getVar('topicid');
$ptopicrows[$k]['posttime'] = $v->getVar('posttime');
$ptopicrows[$k]['replytime'] = $v->getVar('replytime');
$ptopicrows[$k]['posterid'] = $v->getVar('posterid');
$ptopicrows[$k]['poster'] = $v->getVar('poster');
$ptopicrows[$k]['title'] = $v->getVar('title');
$ptopicrows[$k]['views'] = $v->getVar('views');
$ptopicrows[$k]['replies'] = $v->getVar('replies');
$ptopicrows[$k]['size'] = $v->getVar('size');
$ptopicrows[$k]['size_c'] = ceil($v->getVar('size') / 2);
$ptopicrows[$k]['ownerid'] = $v->getVar('ownerid');
$k++;
}
$jieqiTpl->assign_by_ref('ptopicrows', $ptopicrows);
$jieqiTpl->assign('ownerid', $this->blockvars['cacheid']);
$jieqiTpl->assign('url_more', JIEQI_URL . '/ptopics?oid=' . $this->blockvars['cacheid']);
}
function validateLogin()
{
if (strlen($this->get('login')) > 0) {
$handler =& xoops_getmodulehandler('bannerclient', 'legacyRender');
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('login', $this->get('login')));
$criteria->add(new Criteria('cid', $this->get('cid'), '<>'));
if ($handler->getCount($criteria) > 0) {
$this->addErrorMessage(_AD_LEGACYRENDER_ERROR_LOGIN_REPETITION);
}
}
}
