Exemple #1
0
function dispatch()
{
	if($this->isGuest()){
		redirect_header(XOOPS_URL, 2, _NOPERM);
	}
	
	$sess_handler =& XsnsSessionHandler::getInstance();
	$commu_temp = $sess_handler->getVar('community');
	$sess_handler->clearVars();
	$ts =& XsnsTextSanitizer::getInstance();
	
	$default = array(
		'name' => isset($commu_temp['name']) ? $ts->makeTboxData4PreviewInForm($commu_temp['name']) : '',
		'info' => isset($commu_temp['info']) ? $ts->makeTareaData4PreviewInForm($commu_temp['info']) : '',
		'cat_id' => isset($commu_temp['cat_id']) ? intval($commu_temp['cat_id']) : 0,
		'public_id' => isset($commu_temp['public_id']) ? intval($commu_temp['public_id']) : 1,
	);
	
	$image_handler =& XsnsImageHandler::getInstance();
	$image_handler->deleteImageTemp();
	
	$category_handler =& XsnsCategoryHandler::getInstance();
	$category_selector = $category_handler->getSelectorHtml('category', $default['cat_id'], _MD_XSNS_SELBOX_DEFAULT);
	
	$public_id = $default['public_id'];
	$default['public'.$public_id] = ' checked';
	
	$this->context->setAttribute('category_selector', $category_selector);
	$this->context->setAttribute('default', $default);
}
Exemple #2
0
function dispatch()
{
	if($this->isGuest() || !$this->validateToken('COMMUNITY_EDIT')){
		redirect_header(XOOPS_URL, 2, _NOPERM);
	}
	
	$cid = $this->getIntRequest('cid');
	if(!isset($cid)){
		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);
	}
	
	// 入力データのチェック
	$name = $this->getTextRequest('name');
	$info = $this->getTextRequest('info');
	$cat_id = $this->getIntRequest('category');
	$public_id = $this->getIntRequest('public');
	
	if(!$commu_handler->checkParams($cid, $name, $info, $cat_id, $public_id)){
		$errors = $commu_handler->getErrors();
		if(count($errors) > 0){
			$msg = "";
			foreach($errors as $err){
				$msg .= $err."<br>";
			}
			redirect_header(XSNS_URL_COMMU.'?'.XSNS_ACTION_ARG.'=edit&cid='.$cid, 3, $msg);
		}
	}
	
	$old_name = $community->getVar('name');
	
	// コミュニティ情報の更新
	$community->setVar('name', $name);
	$community->setVar('info', $info);
	$community->setVar('c_commu_category_id', $cat_id);
	$community->setVar('public_flag', $public_id);
	
	$category_handler =& XsnsCategoryHandler::getInstance();
	
	if(($cid = $commu_handler->insert($community)) && $category_handler->updateSelector()){
		
		// 画像のアップロード
		$image_handler =& XsnsImageHandler::getInstance();
		$image_handler->setFormLimit(1);
		if($image_handler->uploadImageTemp('image')){
			$image_handler->uploadImage('c', 1, $cid);
		}
		
		redirect_header(XSNS_URL_COMMU.'?cid='.$cid, 2, sprintf(_MD_XSNS_INDEX_EDIT_OK, $old_name));
	}
	redirect_header(XSNS_URL_COMMU.'?cid='.$cid, 2, _MD_XSNS_INDEX_EDIT_NG);
}
Exemple #3
0
function dispatch()
{
	global $xoopsUser;
	
	if($this->isGuest() || !$this->validateToken('COMMUNITY_ADD')){
		redirect_header(XOOPS_URL, 2, _NOPERM);
	}
	$own_uid = $xoopsUser->getVar('uid');
	
	$sess_handler =& XsnsSessionHandler::getInstance();
	$commu = $sess_handler->getVar('community');
	
	$commu_handler =& XsnsCommunityHandler::getInstance();
	if(!$commu_handler->checkParams(0, $commu['name'], $commu['info'], $commu['cat_id'], $commu['public_id'])){
		redirect_header(XOOPS_URL, 2, _NOPERM);
	}
	
	$new_community =& $commu_handler->create();
	$new_community->setVars(array(
		'name' => $commu['name'],
		'uid_admin' => $own_uid,
		'uid_sub_admin' => 0,
		'info' => $commu['info'],
		'c_commu_category_id' => $commu['cat_id'],
		'r_datetime' => date('Y-m-d H:i:s'),
		'r_date' => date('Y-m-d'),
		'public_flag' => $commu['public_id'],
	));
	
	$category_handler =& XsnsCategoryHandler::getInstance();
	
	if(($cid = $commu_handler->insert($new_community)) && $category_handler->updateSelector()){
		
		// 作成したコミュニティに対して画像を追加
		$image_handler =& XsnsImageHandler::getInstance();
		$image_handler->setFormLimit(1);
		$image_handler->uploadImage('c', 1, $cid);
		
		// コミュニティの作成者をメンバーに追加
		$c_member_handler =& XsnsMemberHandler::getInstance();
		$new_member =& $c_member_handler->create();
		$new_member->setVars(array(
			'uid' => $own_uid,
			'c_commu_id' => $cid,
			'r_datetime' => date('Y-m-d H:i:s'),
		));
		
		if($c_member_handler->insert($new_member)){
			$sess_handler->clearVars();
			redirect_header(XSNS_URL_COMMU.'?cid='.$cid, 2, _MD_XSNS_INDEX_ADD_OK);
		}
	}
	redirect_header(XSNS_URL_COMMU.'?'.XSNS_ACTION_ARG.'=add', 2, _MD_XSNS_INDEX_ADD_NG);
}
function dispatch()
{
	$cat_handler =& XsnsCategoryHandler::getInstance();
	$cat_parent_handler =& XsnsCategoryParentHandler::getInstance();
	
	$msg_ok = _AM_XSNS_CATEGORY_DEL_OK;
	$msg_ng = _AM_XSNS_CATEGORY_DEL_NG;
	
	$mode = $this->getTextRequest('mode');
	
	$id = ($mode=='parent') ? $this->getIntRequest('pid') : $this->getIntRequest('id');
	
	$title = $this->getTextRequest('title'.$id);
	if(empty($title)){
		redirect_header(XSNS_URL_ADMIN.'?'.XSNS_ACTION_ARG.'=category', 2, _AM_XSNS_CATEGORY_NAME_NG);
	}
	
	$order = $this->getIntRequest('order'.$id);
	if($order < 0){
		redirect_header(XSNS_URL_ADMIN.'?'.XSNS_ACTION_ARG.'=category', 2, _AM_XSNS_CATEGORY_ORDER_NG);
	}
	
	if($mode=='parent'){
		$cat_parent =& $cat_parent_handler->get($id);
		if(!is_object($cat_parent)){
			redirect_header(XSNS_URL_ADMIN, 2, _NOPERM);
		}
		
		// 中カテゴリの削除
		$criteria = new Criteria('c_commu_category_parent_id', $id);
		$cat_obj_list =& $cat_handler->getObjects($criteria);
		foreach($cat_obj_list as $cat_obj){
			// 小カテゴリの削除
			$cat_handler->delete($cat_obj);
		}
		$ret = $cat_parent_handler->delete($cat_parent);
	}
	else{
		$cat =& $cat_handler->get($id);
		if(!is_object($cat)){
			redirect_header(XSNS_URL_ADMIN, 2, _NOPERM);
		}
		
		// 小カテゴリの削除
		$ret = $cat_handler->delete($cat);
	}
	
	if($ret && $cat_handler->updateSelector()){
		redirect_header(XSNS_URL_ADMIN.'?'.XSNS_ACTION_ARG.'=category', 2, $msg_ok);
	}
	redirect_header(XSNS_URL_ADMIN.'?'.XSNS_ACTION_ARG.'=category', 2, $msg_ng);
}
Exemple #5
0
function dispatch()
{
	if($this->isGuest() || !$this->validateToken('COMMUNITY_DELETE')){
		redirect_header(XOOPS_URL, 2, _NOPERM);
	}
	
	$cid = $this->getIntRequest('cid');
	if(!isset($cid)){
		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) || $community->getTopicCount() > 0){
		redirect_header(XOOPS_URL, 2, _NOPERM);
	}
	
	$old_name = $community->getVar('name');
	
	if($commu_handler->delete($community)){
		
		$category_handler =& XsnsCategoryHandler::getInstance();
		if($category_handler->updateSelector()){
			
			$criteria = new Criteria('c_commu_id', $cid);
			
			// 所属メンバーデータの削除
			$c_member_handler =& XsnsMemberHandler::getInstance();
			$c_member_handler->deleteObjects($criteria);
			
			// 依頼データの削除
			$confirm_handler =& XsnsConfirmHandler::getInstance();
			$confirm_handler->deleteObjects($criteria);
			
			// アクセスログの削除
			$access_log_handler =& XsnsAccessLogHandler::getInstance();
			$access_log_handler->deleteObjects($criteria);
			
			// 画像の削除
			$image_criteria = new CriteriaCompo(new Criteria('target', 1));
			$image_criteria->add(new Criteria('target_id', $cid));
			$image_handler =& XsnsImageHandler::getInstance();
			$image_handler->deleteObjects($image_criteria);
			
			redirect_header(XSNS_URL_COMMU, 2, sprintf(_MD_XSNS_INDEX_DEL_OK, $old_name));
		}
	}
	redirect_header(XSNS_URL_COMMU, 2, _MD_XSNS_INDEX_DEL_NG);
}
function dispatch()
{
	$cat_handler =& XsnsCategoryHandler::getInstance();
	$cat_parent_handler =& XsnsCategoryParentHandler::getInstance();
	
	$title = $this->getTextRequest('title');
	if(empty($title)){
		redirect_header(XSNS_URL_ADMIN.'?'.XSNS_ACTION_ARG.'=category', 2, _AM_XSNS_CATEGORY_NAME_NG);
	}
	
	$order = $this->getIntRequest('order');
	if($order < 0){
		redirect_header(XSNS_URL_ADMIN.'?'.XSNS_ACTION_ARG.'=category', 2, _AM_XSNS_CATEGORY_ORDER_NG);
	}
	
	$mode = $this->getTextRequest('mode');
	
	if($mode=='parent'){
		// 中カテゴリの作成
		$cat_parent =& $cat_parent_handler->create();
		$cat_parent->setVars(array(
			'name' => $title,
			'sort_order' => $order,
			'selector' => '<span></span>'	// NOT NULL
		));
		$ret = $cat_parent_handler->insert($cat_parent);
	}
	else{
		$pid = $this->getIntRequest('pid');
		if($pid < 0){
			redirect_header(XSNS_URL_ADMIN, 2, _AM_XSNS_CATEGORY_ADD_NG);
		}
		// 小カテゴリの作成
		$cat =& $cat_handler->create();
		$cat->setVars(array(
			'name' => $title,
			'sort_order' => $order,
			'c_commu_category_parent_id' => $pid,
		));
		$ret = $cat_handler->insert($cat);
	}
	
	if($ret && $cat_handler->updateSelector()){
		redirect_header(XSNS_URL_ADMIN.'?'.XSNS_ACTION_ARG.'=category', 2, _AM_XSNS_CATEGORY_ADD_OK);
	}
	redirect_header(XSNS_URL_ADMIN.'?'.XSNS_ACTION_ARG.'=category', 2, _AM_XSNS_CATEGORY_ADD_NG);
}
Exemple #7
0
function dispatch()
{
	if($this->isGuest()){
		redirect_header(XOOPS_URL, 2, _NOPERM);
	}
	
	require_once XOOPS_ROOT_PATH.'/class/xoopsformloader.php'; 
	$token_handler = new XoopsMultiTokenHandler();
	$token = new XoopsFormToken($token_handler->create('COMMUNITY_EDIT')); 
	// Hidden 
	$token_tag = '<input type="hidden" name="'.$token->_name.'" value="'.$token->_value.'">';
	$this->context->setAttribute('token_tag', $token_tag); 

	$cid = $this->getIntRequest('cid', XSNS_REQUEST_GET);
	if(!isset($cid)){
		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);
	}
	
	$commu_data = array(
		'id' => $cid,
		'name' => $community->getVar('name', 'e'),
		'info' => $community->getVar('info', 'e'),
		'del_enabled' => ($community->getTopicCount()==0)? true : false,
		'image' => $community->getImage(XSNS_IMAGE_SIZE_S),
	);
	
	$category_handler =& XsnsCategoryHandler::getInstance();
	$category_selector = $category_handler->getSelectorHtml('category', $community->getVar('c_commu_category_id'));
	
	$this->context->setAttribute('commu', $commu_data);
	$this->context->setAttribute('public_flag', $community->getVar('public_flag'));
	$this->context->setAttribute('category_selector', $category_selector);
}
Exemple #8
0
function dispatch()
{
	$err = $this->checkPermission();
	if(!is_array($err) || count($err) > 0){
		$this->context->setAttribute('perm_error', $err);
		return "default";
	}
	
	$category_p = $category = array();
	
	$criteria = new CriteriaCompo();
	$criteria->setSort('sort_order');
	
	$category_p_handler =& XsnsCategoryParentHandler::getInstance();
	$category_p_obj_list =& $category_p_handler->getObjects($criteria);
	
	foreach($category_p_obj_list as $category_p_obj){
		if(is_object($category_p_obj)){
			$category_p[] = $category_p_obj->getVarsArray();
		}
	}
	unset($criteria);
	
	$criteria = new CriteriaCompo();
	$criteria->setSort('c_commu_category_parent_id,sort_order');
	
	$category_handler =& XsnsCategoryHandler::getInstance();
	$category_obj_list =& $category_handler->getObjects($criteria);
	
	foreach($category_obj_list as $category_obj){
		if(is_object($category_obj)){
			$pid = $category_obj->getVar('c_commu_category_parent_id');
			$category[$pid][] = $category_obj->getVarsArray();
		}
	}
	
	$this->context->setAttribute('category_p', $category_p);
	$this->context->setAttribute('category', $category);
}
Exemple #9
0
	function &getList($criteria = NULL)
	{
		$limit = $start = 0;
		$ret = array();
		
		$sql = "SELECT cc.*,COUNT(ccm.uid) AS member_count FROM ".
				$this->prefix($this->table_name)." cc".
				" LEFT JOIN ".$this->prefix('c_commu_member')." ccm".
				" ON cc.c_commu_id=ccm.c_commu_id";
		$sql_order = "";
		
		if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
			$sql_where = $criteria->render();
			if(!empty($sql_where)){
				$sql .= " WHERE ".$sql_where;
			}
			$limit = $criteria->getLimit();
			$start = $criteria->getStart();
			
			if ($criteria->getSort() != '') {
				$sql_order .= " ORDER BY ".$criteria->getSort()." ".$criteria->getOrder();
			}
		}
		$sql .= " GROUP BY ccm.c_commu_id". $sql_order;
		
		$result = $this->db->query($sql, $limit, $start);
		if (!$result) {
			return $ret;
		}
		
		$obj_list = array();
		$cids = array();
		$cat_ids = array();
		$image_handler =& XsnsImageHandler::getInstance();
		$image_handler->setFormLimit(1);
		$category_handler =& XsnsCategoryHandler::getInstance();
		
		while ($row = $this->db->fetchArray($result)) {
			$obj = new $this->obj_class();
			$obj->assignVars($row);
			$cid = $obj->getVar('c_commu_id');
			$obj_list[$cid] = $obj;
			$cids[] = $cid;
		}
		$image_list =& $image_handler->getListByIds(1, $cids, XSNS_IMAGE_SIZE_S);
		$category_list =& $category_handler->getNameList();
		
		foreach($obj_list as $cid => $obj){
			if(!is_object($obj)){
				continue;
			}
			$cat_id = $obj->getVar('c_commu_category_id');
			$ret[] = array(
				'c_commu_id' => $cid,
				'name' => $obj->getVar('name'),
			//	'info' => $obj->getVar('info', 'x'),		// stripXoopsCode
				'info' => strip_tags($obj->getVar('info')),	// naao
				'category_name' => isset($category_list[$cat_id]) ? $category_list[$cat_id] : "",
				'member_count' => $obj->getMemberCount(),	// != $row['member_count']
				'page_url' => XSNS_BASE_URL.'/?cid='.$cid,
				'image' => isset($image_list[$cid][0]) ? $image_list[$cid][0] : array(),
			);
		}
		return $ret;
	}
function dispatch()
{
	if($this->isGuest()){
		redirect_header(XOOPS_URL, 2, _NOPERM);
	}
	
	require_once XOOPS_ROOT_PATH.'/class/xoopsformloader.php';
	$token_handler = new XoopsMultiTokenHandler();
	$token = new XoopsFormToken($token_handler->create('COMMUNITY_ADD'));
	// Hidden
	$token_tag = '<input type="hidden" name="'.$token->_name.'" value="'.$token->_value.'">';
	$this->context->setAttribute('token_tag', $token_tag);

	$name = $this->getTextRequest('name');
	$cat_id = $this->getIntRequest('category');
	$public_id = $this->getIntRequest('public');
	$info = $this->getTextRequest('info');
	
	$errors = array();
	$commu_handler =& XsnsCommunityHandler::getInstance();
	if(!$commu_handler->checkParams(0, $name, $info, $cat_id, $public_id)){
		$errors = $commu_handler->getErrors();
	}
	
	if($public_id < 1 || $public_id > 3){
		$public_id = 1;
	}
	
	$new_community =& $commu_handler->create();
	$new_community->setVars(array(
		'name' => $name,
		'info' => $info,
	));
	
	$sess_handler =& XsnsSessionHandler::getInstance();
	$commu_vars_temp = array(
		'name' => $name,
		'cat_id' => $cat_id,
		'public_id' => $public_id,
		'info' => $info,
	);
	$sess_handler->setVar('community', $commu_vars_temp);
	
	$category_handler =& XsnsCategoryHandler::getInstance();
	
	// check input : NG
	if(count($errors) > 0){
		$default = array(
			'name' => $new_community->getVar('name', 'f'),
			'info' => $new_community->getVar('info', 'f'),
			'public'.$public_id => ' checked',
		);
		$category_selector = $category_handler->getSelectorHtml('category', $cat_id, _MD_XSNS_SELBOX_DEFAULT);
		$this->context->setAttribute('category_selector', $category_selector);
		$this->context->setAttribute('default', $default);
		$this->context->setAttribute('errors', $errors);
		return "add";	// �� index/addView.php
	}
	
	// check input : OK
	$image_handler =& XsnsImageHandler::getInstance();
	$image_handler->setFormLimit(1);
	
	$public_desc = array(
		'1' => _MD_XSNS_INDEX_PUBLIC_L1,
		'2' => _MD_XSNS_INDEX_PUBLIC_L2,
		'3' => _MD_XSNS_INDEX_PUBLIC_L3,
	);
	
	$category =& $category_handler->get($cat_id);
	
	$commu_vars = array(
		'name' => $new_community->getVar('name', 'p'),
		'category_id' => $cat_id,
		'category' => $category->getVar('name', 'p'),
		'public_id' => $public_id,
		'public' => $public_desc[$public_id],
		'info' => $new_community->getVar('info', 'p'),
		'image' => $image_handler->uploadImageTemp('image'),
	);
	
	$this->context->setAttribute('commu', $commu_vars);
}
Exemple #11
0
function dispatch()
{
	$limit = 10;
	
	$sess_handler =& XsnsSessionHandler::getInstance();
	$sess_handler->clearVars();
	
	$cid = $this->getIntRequest('cid', XSNS_REQUEST_GET);
	
	if($cid > 0){
		$commu_detail = $this->getCommunityDetail($cid);
		$this->context->setAttribute('commu', $commu_detail);
		
		return "detail";
	}
	
	$start = $this->getIntRequest('s', XSNS_REQUEST_GET);
	if(!isset($start) || $start<0){
		$start = 0;
	}
	
	$cat_id = $this->getIntRequest('cat_id', XSNS_REQUEST_GET);
	$keyword = $this->getTextRequest('keyword', XSNS_REQUEST_GET);
	$sort_method = $this->getTextRequest('sort', XSNS_REQUEST_GET);
	
	$commu_handler =& XsnsCommunityHandler::getInstance();
	
	$criteria = new CriteriaCompo();
	$criteria->setLimit($limit);
	$criteria->setStart($start);
	
	if($cat_id > 0){
		$criteria->add(new Criteria('c_commu_category_id', $cat_id));
	}
	if($keyword != ''){
		$kw_criteria = new CriteriaCompo(new Criteria('name', '%'.$keyword.'%', 'LIKE'));
		$kw_criteria->add(new Criteria('info', '%'.$keyword.'%', 'LIKE'), 'OR');
		$criteria->add($kw_criteria);
	}
	
	switch($sort_method){
		case 'date':
		default:
			$criteria->setSort('cc.r_datetime');
			$criteria->setOrder('DESC');
			break;
		
		case 'member':
			$criteria->setSort('member_count');
			$criteria->setOrder('DESC');
			break;
		
		case 'pop':
			$criteria->setSort('cc.popularity');
			$criteria->setOrder('DESC');
			break;
		
		case 'up':
			$criteria->setSort('cc.update_freq');
			$criteria->setOrder('DESC');
			break;
	}
	$commu_list =& $commu_handler->getList($criteria);
	$commu_total = $commu_handler->getCount($criteria);
	
	$base_url = XSNS_URL_COMMU.'?';
	if($cat_id > 0){
		$base_url .= "&cat_id=".$cat_id;
	}
	if($keyword != ''){
		$base_url .= "&keyword=".rawurlencode($keyword);
	}
	
	if($sort_method=='member' || $sort_method=='date' || $sort_method=='pop' || $sort_method=='up'){
		$base_url .= '&sort='.$sort_method;
	}
	
	$category_handler =& XsnsCategoryHandler::getInstance();
	$category_parent_handler =& XsnsCategoryParentHandler::getInstance();
	$category_selector = $category_handler->getSelectorHtml('cat_id', 0, _MD_XSNS_INDEX_CATEGORY_NO);
	$category_list =& $category_parent_handler->getList();
	
	$pager = $this->getPageSelector($base_url, 
				$start, $limit, count($commu_list), $commu_total);
	
	if(count($commu_list)==0){
		$pager['description'] = _MD_XSNS_INDEX_COMMU_COUNT0;
	}
	
	$keyword_option = empty($keyword)? '' : '&keyword='.rawurlencode($keyword);
	$cat_id_option = empty($cat_id)? '' : '&cat_id='.$cat_id;
	
	$url = array(
		'sort_member' => XSNS_URL_COMMU.'?sort=member'. $keyword_option. $cat_id_option,
		'sort_date' => XSNS_URL_COMMU.'?sort=date'. $keyword_option. $cat_id_option,
		'sort_pop' => XSNS_URL_COMMU.'?sort=pop'. $keyword_option. $cat_id_option,
		'sort_up' => XSNS_URL_COMMU.'?sort=up'. $keyword_option. $cat_id_option,
	);
	
	$this->context->setAttribute('is_guest', $this->isGuest());
	$this->context->setAttribute('keyword', $keyword);
	$this->context->setAttribute('url', $url);
	$this->context->setAttribute('category_selector', $category_selector);
	$this->context->setAttribute('category_list', $category_list);
	$this->context->setAttribute('pager', $pager);
	$this->context->setAttribute('commu_list', $commu_list);
}