function get_event()
{
global $xoopsDB, $xoopsUser;
$andWebID = empty($_REQUEST['WebID']) ? "" : "and `WebID`='{$_REQUEST['WebID']}'";
$start = date("Y-m-d", $_REQUEST['start'] / 1000);
$andEnd = "";
if ($_REQUEST['end']) {
$end = date("Y-m-d", $_REQUEST['end'] / 1000);
$andEnd = "and toCal <= '{$end}'";
}
$andNewsKind = empty($_REQUEST['NewsKind']) ? "" : "and NewsKind='{$_REQUEST['NewsKind']}'";
$sql = "select * from " . $xoopsDB->prefix("tad_web_news") . " where toCal >= '{$start}' {$andEnd} {$andWebID} {$andNewsKind} order by toCal";
//$sql = "select * from ".$xoopsDB->prefix("tad_web_news")." where 1 $andWebID $andNewsKind order by toCal";
//die($sql);
$result = $xoopsDB->queryF($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error());
$i = 0;
while ($all = $xoopsDB->fetchArray($result)) {
//以下會產生這些變數： $out_sn , $inspector_name , $out_date , $location , $job , $job_content
foreach ($all as $k => $v) {
${$k} = $v;
}
$toCal = userTimeToServerTime(strtotime($toCal));
$myEvents[$i]['id'] = $NewsID;
$myEvents[$i]['title'] = $NewsTitle;
$myEvents[$i]['rel'] = XOOPS_URL . "/modules/tad_web/{$NewsKind}.php?WebID={$WebID}&NewsID={$NewsID}";
$myEvents[$i]['start'] = $toCal;
$myEvents[$i]['allDay'] = true;
$myEvents[$i]['className'] = "fc-event";
$i++;
}
return json_encode($myEvents);
}
function list_tad_gallery_cate_tree($def_csn = "")
{
global $xoopsDB, $xoopsTpl;
$tadgallery = new tadgallery();
$cate_count = $tadgallery->get_tad_gallery_cate_count();
$path = get_tadgallery_cate_path($def_csn);
$path_arr = array_keys($path);
$sql = "select csn,of_csn,title from " . $xoopsDB->prefix("tad_gallery_cate") . " order by sort";
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error());
while (list($csn, $of_csn, $title) = $xoopsDB->fetchRow($result)) {
$font_style = $def_csn == $csn ? ", font:{'background-color':'yellow', 'color':'black'}" : '';
$open = in_array($csn, $path_arr) ? 'true' : 'false';
$display_counter = empty($cate_count[$csn]['file']) ? "" : " ({$cate_count[$csn]['file']})";
$data[] = "{ id:{$csn}, pId:{$of_csn}, name:'{$title}{$display_counter}', url:'cooliris.php?csn={$csn}', open: {$open} ,target:'_self' {$font_style}}";
}
$json = implode(",\n", $data);
if (!file_exists(XOOPS_ROOT_PATH . "/modules/tadtools/ztree.php")) {
redirect_header("index.php", 3, _MA_NEED_TADTOOLS);
}
include_once XOOPS_ROOT_PATH . "/modules/tadtools/ztree.php";
$ztree = new ztree("album_tree", $json, '', '', "of_csn", "csn");
$ztree_code = $ztree->render();
$xoopsTpl->assign('ztree_code', $ztree_code);
return $data;
}
function processPreview($request)
{
// Ticket Check
if (!$GLOBALS['xoopsGTicket']->check(true, 'pico')) {
redirect_header(XOOPS_URL . '/', 3, $GLOBALS['xoopsGTicket']->getErrors());
}
// initialize
$cat_data = $this->currentCategoryObj->getData();
$myts =& PicoTextSanitizer::getInstance();
// assigning other than preview/request
// parent::execute( $request ) ;
// permission check (can_edit) done
// request
$request = pico_get_requests4content($this->mydirname, $errors = array(), $cat_data['post_auto_approved'], $cat_data['isadminormod'], $this->assign['content']['id']);
$request['body_raw'] = $request['body'];
$request['subject_raw'] = $request['subject'];
$request4assign = array_map('htmlspecialchars_ent', $request);
$this->assign['request'] = $request4assign;
// override content data for edit
$this->assign['content'] = $request4assign + $this->assign['content'];
$this->assign['content']['filter_infos'] = pico_main_get_filter_infos($request['filters'], $cat_data['isadminormod']);
$this->assign['content']['body_raw'] = $request['body'];
$this->assign['content']['extra_fields'] = $request['extra_fields'];
$this->assign['content']['ef'] = pico_common_unserialize($request['extra_fields']);
// temporary $contentObj
$tmpContentObj = new PicoContent($this->mydirname, 0, $this->currentCategoryObj, true);
// preview
$this->assign['preview'] = array('errors' => $errors, 'htmlheader' => $request['htmlheader'], 'subject' => $myts->makeTboxData4Show($request['subject'], 1, 1), 'body' => $tmpContentObj->filterBody($this->assign['content']));
}
protected function _registerAction()
{
$this->form->fetchInput()->validate();
if ($this->form->hasError() === true) {
return;
}
$memberHandler =& xoops_gethandler('member');
$newUser =& $memberHandler->createUser();
$this->_update($newUser);
try {
$this->root->cms->database()->queryF('BEGIN');
if ($memberHandler->insertUser($newUser) == false) {
throw new Exception(t('Database error 111'));
}
if ($memberHandler->addUserToGroup(XOOPS_GROUP_USERS, $newUser->get('uid')) == false) {
throw new Exception(t('Database error 222'));
}
$providerUserLinkHandler = $this->root->getModelHandler('ProviderUserLink', 'social_media');
$result = $providerUserLinkHandler->addProviderUserLink($_SESSION['socialMediaType'], $_SESSION['socialMediaId'], $newUser->get('uid'));
if ($result == false) {
throw new Exception(t('Database error 333'));
}
$this->root->cms->database()->queryF('COMMIT');
unset($_SESSION['socialMediaType'], $_SESSION['socialMediaId']);
$this->_registerSession($newUser);
redirect_header(XOOPS_URL, 1, t('Thank you for your registeration. You now logged in.'));
} catch (Exception $e) {
$this->form->addError($e->getMessage());
$this->root->cms->database()->queryF('ROLLBACK');
}
}
function show_rss_content()
{
global $xoopsConfig;
include_once $GLOBALS['xoops']->path('class/template.php');
$tpl = new XoopsTpl();
$module = rmc_server_var($_GET, 'mod', '');
if ($module == '') {
redirect_header('backend.php', 1, __('Choose an option to see its feed', 'rmcommon'));
die;
}
if (!file_exists(XOOPS_ROOT_PATH . '/modules/' . $module . '/rss.php')) {
redirect_header('backend.php', 1, __('This module does not support rss feeds', 'rmcommon'));
die;
}
$GLOBALS['xoopsLogger']->activated = false;
if (function_exists('mb_http_output')) {
mb_http_output('pass');
}
header('Content-Type:text/xml; charset=utf-8');
include XOOPS_ROOT_PATH . '/modules/' . $module . '/rss.php';
if (!isset($rss_channel['image'])) {
$rmc_config = RMFunctions::configs();
$rss_channel['image']['url'] = $rmc_config['rssimage'];
$dimention = getimagesize(XOOPS_ROOT_PATH . '/images/logo.png');
$rss_channel['image']['width'] = $dimention[0] > 144 ? 144 : $dimention[0];
$rss_channel['image']['height'] = $dimention[1] > 400 ? 400 : $dimention[1];
}
include RMTemplate::get()->get_template('rmc_rss.php', 'module', 'rmcommon');
}
/**
* show error
*
* @param string $reason 'select', 'insert', 'delete',
* 'lock_edit', 'lock_delete'
*/
function xoonips_group_error($url, $reason)
{
$messages = array('select' => _MD_XOONIPS_ERROR_GROUP_SELECT, 'insert' => _MD_XOONIPS_ERROR_GROUP_INSERT, 'update' => _MD_XOONIPS_ERROR_GROUP_UPDATE, 'delete' => _MD_XOONIPS_ERROR_GROUP_DELETE, 'lock_edit' => sprintf(_MD_XOONIPS_ERROR_CANNOT_EDIT_LOCKED_GROUP, _MD_XOONIPS_LOCK_TYPE_STRING_CERTIFY_REQUEST), 'lock_delete' => sprintf(_MD_XOONIPS_ERROR_CANNOT_DELETE_LOCKED_GROUP, _MD_XOONIPS_LOCK_TYPE_STRING_CERTIFY_REQUEST));
$msg = isset($messages[$reason]) ? $messages[$reason] : 'fatal error';
redirect_header($url, 3, $msg);
exit;
}
function redirect($message, $toFrompage = false)
{
if ($toFrompage) {
$url = XOOPS_URL . '/';
/* @var $cookie Openid_Context */
$cookie =& OpenID_Utils::load('context');
$cookie->accept('openid_frompage', 'string', 'cookie');
if ($frompage = $cookie->get('openid_frompage')) {
$parsed = parse_url(XOOPS_URL);
$url = isset($parsed['scheme']) ? $parsed['scheme'] . '://' : 'http://';
if (isset($parsed['host'])) {
$url .= $parsed['host'];
if (isset($parsed['port'])) {
$url .= ':' . $parsed['port'];
}
} else {
$url .= xoops_getenv('HTTP_HOST');
}
$url .= trim($frompage);
}
} else {
$url = XOOPS_URL . '/';
}
unset($_SESSION['openid_response']);
setcookie('openid_frompage', '', time() - 3600);
redirect_header($url, 2, $message);
}
function editcat($catid = '')
{
$name = '';
$description = '';
global $xoopsUser, $xoopsUser, $xoopsConfig, $xoopsDB, $modify;
include_once XOOPS_ROOT_PATH . '/class/xoopsformloader.php';
if ($modify) {
$result = $xoopsDB->query("SELECT name, description FROM " . $xoopsDB->prefix("faqcategories") . " WHERE catID = '{$catid}'");
list($name, $description) = mysql_fetch_row($result);
if (mysql_num_rows($result) == 0) {
redirect_header("index.php", 1, _AM_NOCATTOEDIT);
exit;
}
$sform = new XoopsThemeForm(_AM_MODIFYCAT, "op", xoops_getenv('PHP_SELF'));
} else {
$sform = new XoopsThemeForm(_AM_ADDCAT, "op", xoops_getenv('PHP_SELF'));
}
$sform->addElement(new XoopsFormText(_AM_CATNAME, 'name', 50, 80, $name), true);
$sform->addElement(new XoopsFormDhtmlTextArea(_AM_CATDESCRIPT, 'description', $description, 15, 60));
$sform->addElement(new XoopsFormHidden('catid', $catid));
$sform->addElement(new XoopsFormHidden('modify', $modify));
$button_tray = new XoopsFormElementTray('', '');
$hidden = new XoopsFormHidden('op', 'addcat');
$button_tray->addElement($hidden);
if ($modify == '0') {
$button_tray->addElement(new XoopsFormButton('', 'update', _AM_CREATE, 'submit'));
} else {
$button_tray->addElement(new XoopsFormButton('', 'update', _AM_MODIFY, 'submit'));
}
$sform->addElement($button_tray);
$sform->display();
unset($hidden);
}
function view_pic_exif($sn = "")
{
global $xoopsDB, $xoopsModule, $xoopsModuleConfig;
$sql = "select exif from " . $xoopsDB->prefix("tad_gallery") . " where sn='{$sn}'";
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error());
list($exif) = $xoopsDB->fetchRow($result);
$info = explode("||", $exif);
foreach ($info as $v) {
$exif_arr = explode("=", $v);
$exif_arr[1] = str_replace("�", "", $exif_arr[1]);
$bb = "\$aa{$exif_arr[0]}=\"{$exif_arr[1]}\";";
if (empty($exif_arr[0])) {
continue;
}
@eval($bb);
}
$exif_all = $exif_data = "";
foreach ($aa as $k => $v) {
$exif_data = "";
foreach ($v as $kk => $vv) {
$exif_data .= get_exif_info($kk, $vv);
}
if (!empty($exif_data)) {
$exif_all .= $exif_data;
}
}
return "<table style='width:auto;' class='line'>{$exif_all}</table>";
}
function &execute(&$controller, &$request, &$user)
{
redirect_header("index.php", 1, $request->getAttribute('success_message'));
$renderer = new mojaLE_NoneRenderer($controller, $request, $user);
$renderer->setTemplate('');
return $renderer;
}
function dispatch()
{
global $xoopsUser;
if($this->isGuest()){
redirect_header(XOOPS_URL, 2, _NOPERM);
}
$own_uid = $xoopsUser->getVar('uid');
$limit = 30;
$start = $this->getIntRequest('s', XSNS_REQUEST_GET);
if(!isset($start) || $start<0){
$start = 0;
}
$user_handler =& XsnsUserHandler::getInstance();
$user =& $user_handler->get($own_uid);
if(!is_object($user) || $user->getVar('level') < 1){
redirect_header(XOOPS_URL, 2, _NOPERM);
}
$blog_list =& $user->getFriendBlogList($limit, $start, &$blog_count);
$pager = $this->getPageSelector(XSNS_URL_MYPAGE.'&'.XSNS_ACTION_ARG.'=blog_list',
$start, $limit, count($blog_list), $blog_count);
$this->context->setAttribute('user_menu', $user->getMypageMenu());
$this->context->setAttribute('blog_list', $blog_list);
$this->context->setAttribute('pager', $pager);
}
function go_update2()
{
global $xoopsDB;
$sql = "ALTER TABLE " . $xoopsDB->prefix("jill_booking_item") . " CHANGE `jbi_approval` `jbi_approval` varchar(255) COLLATE 'utf8_general_ci' NOT NULL COMMENT '審核人員' AFTER `jbi_enable` ";
$xoopsDB->queryF($sql) or redirect_header(XOOPS_URL, 3, mysql_error());
return true;
}
/**
* constructor
*/
function OpenID_Library()
{
if (!@$GLOBALS['xoopsModuleConfig']['openid_rand_souce']) {
define('Auth_OpenID_RAND_SOURCE', null);
} else {
if (!@is_readable($GLOBALS['xoopsModuleConfig']['openid_rand_souce'])) {
redirect_header(XOOPS_URL, 2, 'Please set rand_source on admin panel');
} else {
define('Auth_OpenID_RAND_SOURCE', $GLOBALS['xoopsModuleConfig']['openid_rand_souce']);
}
}
if (@$GLOBALS['xoopsModuleConfig']['curl_cainfo_file']) {
$cainfo = str_replace('XOOPS_ROOT_PATH', XOOPS_ROOT_PATH, $GLOBALS['xoopsModuleConfig']['curl_cainfo_file']);
define('Auth_OpenID_CURLOPT_CAINFO_FILE', $cainfo);
}
if (version_compare(PHP_VERSION, '5.0.0', '>=')) {
$path_extra = XOOPS_ROOT_PATH . '/modules/openid/class/php5-openid';
} else {
$path_extra = XOOPS_ROOT_PATH . '/modules/openid/class/php-openid';
}
$path = ini_get('include_path');
$path = $path_extra . PATH_SEPARATOR . $path;
ini_set('include_path', $path);
$this->doIncludes();
// @todo Set on module config
$this->sregFields = array('nickname', 'fullname', 'email', 'timezone');
$this->pape_policy_uris = array(PAPE_AUTH_MULTI_FACTOR_PHYSICAL, PAPE_AUTH_MULTI_FACTOR, PAPE_AUTH_PHISHING_RESISTANT);
}
function dispatch()
{
global $xoopsUser;
if($this->isGuest() || !$this->validateToken('CONFIG_EDIT')){
redirect_header(XOOPS_URL, 2, _NOPERM);
}
$own_uid = $xoopsUser->getVar('uid');
$config_arr = $this->getConfigArray();
if(!is_array($config_arr)){
redirect_header(XSNS_URL_MYPAGE, 2, _MD_XSNS_CONFIG_CHANGE_NG);
}
$module_config_handler =& XsnsModuleConfigHandler::getInstance();
$module_config =& $module_config_handler->getOne($own_uid);
if(!is_object($module_config)){
$module_config =& $module_config_handler->create();
$module_config->setVar('uid', $own_uid);
}
$module_config->setVar('config_values', $config_arr);
if($module_config_handler->insert($module_config)){
redirect_header(XSNS_URL_MYPAGE_NEWS.'&uid='.$own_uid, 2, _MD_XSNS_CONFIG_CHANGE_OK);
}
redirect_header(XSNS_URL_MYPAGE, 2, _MD_XSNS_CONFIG_CHANGE_NG);
}
function sendComment()
{
global $xoopsUser, $xoopsModule, $xoopsModuleConfig, $mc, $xoopsConfig;
$util =& RMUtils::getInstance();
if (!$util->validateToken()) {
redirect_header('comment.php', 2, _MS_TC_ERRID);
die;
}
foreach ($_POST as $k => $v) {
${$k} = $v;
}
if ($name == '' || $email == '' || $comment == '') {
redirect_header('comment.php', 2, _MS_TC_ERRFIELDS);
die;
}
$xoopsMailer =& getMailer();
$xoopsMailer->useMail();
$xoopsMailer->setTemplate('mail.tpl');
$xoopsMailer->assign('SITENAME', $xoopsConfig['sitename']);
$xoopsMailer->assign('ADMINMAIL', $xoopsConfig['adminmail']);
$xoopsMailer->assign('SITEURL', XOOPS_URL . "/");
$xoopsMailer->assign('NAME', $name);
$xoopsMailer->assign('EMAIL', $email);
$xoopsMailer->assign('COMMENTS', $comment);
$xoopsMailer->setTemplateDir(XOOPS_ROOT_PATH . "/modules/team/language/" . $xoopsConfig['language'] . "/");
$xoopsMailer->setFromEmail($email);
$xoopsMailer->setFromName($name);
$xoopsMailer->setSubject(sprintf(_MS_TC_COMFROM, $xoopsConfig['sitename'] . ": " . $xoopsModule->name()));
$xoopsMailer->setToEmails($xoopsModuleConfig['email']);
if (!$xoopsMailer->send(true)) {
redirect_header('comment.php', 2, $xoopsMailer->getErrors());
} else {
redirect_header('./', 1, _MS_TC_COMTHX);
}
}
function getRSSItems(&$items) {
$mydirname = $this->mydirname;
$module_handler =& xoops_gethandler('module');
$xoopsModule =& $module_handler->getByDirname($mydirname);
$mid = $xoopsModule->getVar('mid');
$config_handler =& xoops_gethandler('config');
$xoopsModuleConfig =& $config_handler->getConfigsByCat(0, $mid);
$pipe_id = isset($xoopsModuleConfig['backend_pipe_id'])? (int)$xoopsModuleConfig['backend_pipe_id'] : 0;
if (! $pipe_id) return;
require_once dirname(dirname(__FILE__)) . '/include/common_prepend.inc.php';
// single pipe
$pipe4assign = d3pipes_common_get_pipe4assign( $mydirname , $pipe_id ) ;
if( empty( $pipe4assign['main_rss'] ) ) {
redirect_header( XOOPS_URL.'/modules/'.$mydirname.'/' , 3 , _MD_D3PIPES_ERR_INVALIDPIPEID ) ;
exit ;
}
// fetch entries
$entries = d3pipes_common_fetch_entries( $mydirname , $pipe4assign , $xoopsModuleConfig['entries_per_rss'] , $errors , $xoopsModuleConfig ) ;
foreach ($entries as $entry) {
$items[] = array (
'title' => $entry['headline'],
'link' => $entry['link'],
'guid' => $entry['fingerprint'],
'pubdate' => $entry['pubtime'],
'description' => $entry['description'],
'category' => $entry['pipe']['name4xml'],
);
}
}
function &execute(&$controller, &$request, &$user)
{
redirect_header('index.php', 3, _MD_A_PLZXOO_MESSAGE_DBUPDATE_FAIL);
$renderer = new mojaLE_NoneRenderer($controller, $request, $user);
$renderer->setTemplate('');
return $renderer;
}
function postAction()
{
global $xoopsUser;
if (!$this->_response->getResult()) {
foreach ($this->_collection->getItems() as $item) {
foreach ($item->getErrorCodes() as $code) {
if ($code != E_XOONIPS_UPDATE_CERTIFY_REQUEST_LOCKED) {
continue;
}
$titles =& $item->getVar('titles');
$item_lock_handler =& xoonips_getormhandler('xoonips', 'item_lock');
redirect_header(XOOPS_URL . '/modules/xoonips/import.php?action=default', 5, sprintf(_MD_XOONIPS_ERROR_CANNOT_OVERWRITE_LOCKED_ITEM, $titles[0]->get('title'), xoonips_get_lock_type_string($item_lock_handler->getLockType($item->getUpdateItemId()))));
}
}
}
$this->_finish_time = time();
$success =& $this->_response->getSuccess();
$this->_view_params['result'] = $this->_response->getResult();
$this->_view_params['import_items'] = $success['import_items'];
$this->_view_params['begin_time'] = $this->_begin_time;
$this->_view_params['finish_time'] = $this->_finish_time;
$this->_view_params['filename'] = $this->_collection->getImportFileName();
$this->_view_params['uname'] = $xoopsUser->getVar('uname');
$this->_view_params['errors'] = array();
foreach ($success['import_items'] as $item) {
foreach (array_unique($item->getErrorCodes()) as $code) {
$this->_view_params['errors'][] = array('code' => $code, 'extra' => $item->getPseudoId());
}
}
}
/**
* Edit a Picture
*
* @param object $picturesObj ProfilePicture object to be edited
* @param bool $hideForm
* @global mod_profile_PicturesHandler $profile_pictures_handler picture handler
* @global object $icmsTpl template
*
*/
function editpictures($picturesObj, $hideForm = false)
{
global $profile_pictures_handler, $icmsTpl;
$icmsTpl->assign('hideForm', $hideForm);
if (!$picturesObj->isNew()) {
if (!$picturesObj->userCanEditAndDelete()) {
redirect_header($picturesObj->getItemLink(true), 3, _NOPERM);
}
$picturesObj->hideFieldFromForm(array('url', 'creation_time', 'uid_owner'));
$sform = $picturesObj->getSecureForm($hideForm ? '' : _MD_PROFILE_PICTURES_EDIT, 'addpictures');
$sform->assign($icmsTpl, 'profile_picturesform');
$icmsTpl->assign('lang_picturesform_title', _MD_PROFILE_PICTURES_EDIT);
} else {
if (!$profile_pictures_handler->userCanSubmit()) {
redirect_header(PROFILE_URL, 3, _NOPERM);
}
if (!$profile_pictures_handler->checkUploadLimit()) {
return;
}
$picturesObj->setVar('uid_owner', icms::$user->getVar('uid'));
$picturesObj->setVar('creation_time', date(_DATESTRING));
$picturesObj->hideFieldFromForm(array('creation_time', 'uid_owner'));
$sform = $picturesObj->getSecureForm($hideForm ? '' : _MD_PROFILE_PICTURES_SUBMIT, 'addpictures');
$sform->assign($icmsTpl, 'profile_picturesform');
$icmsTpl->assign('lang_picturesform_title', _MD_PROFILE_PICTURES_SUBMIT);
}
}
/**
* Loads the invite code
*
* @param string $code Invitation code
**/
function load_invite_code($code)
{
// validate if code is of valid length.
if (empty($code) || strlen($code) != 8) {
header('Location: invite.php');
// redirect_header('invite.php', 0, _US_INVITENONE);
exit;
}
$sql = sprintf('SELECT invite_to, invite_date, register_id, extra_info FROM %s WHERE invite_code = %s AND register_id = 0', icms::$xoopsDB->prefix('invites'), icms::$xoopsDB->quoteString(addslashes($code)));
$result = icms::$xoopsDB->query($sql);
list($invite_to, $invite_date, $register_id, $extra_info) = icms::$xoopsDB->fetchRow($result);
if (empty($invite_to)) {
redirect_header('invite.php', 3, _US_INVITEINVALID);
exit;
}
// discard if already registered or invite is more than 3 days old
if (!empty($register_id) || (int) $invite_date < time() - 3 * 86400) {
redirect_header('invite.php', 3, _US_INVITEEXPIRED);
exit;
}
// load default email and actkey
global $email, $actkey;
$email = $invite_to;
$actkey = $code;
// load extra_info
$extra_array = unserialize($extra_info);
foreach ($extra_array as $ex_key => $ex_value) {
$GLOBALS[$ex_key] = $ex_value;
}
// update view time
$sql = sprintf('UPDATE ' . icms::$xoopsDB->prefix('invites') . ' SET view_date = %d WHERE invite_code = %s AND register_id = 0', time(), icms::$xoopsDB->quoteString(addslashes($code)));
$result = icms::$xoopsDB->queryF($sql);
}
protected function _updateAction()
{
$criteria = new Pengin_Criteria();
// 入力値チェック
$this->_formValidate();
if ($this->_hasError() == true) {
return;
}
$this->providerHandler = $this->root->getModelHandler('Provider');
$providerUserLinkHandler = $this->root->getModelHandler('ProviderUserLink');
try {
// トランザクション開始
$this->root->cms->database()->queryF('BEGIN');
// Provider全件更新
if ($this->providerHandler->updateProviders($_GET) == false) {
throw new Exception(t('Database error'));
}
// すべての入力値が空だったとき、ユーザーとのリンク情報を削除する
foreach ($this->providerList as $list) {
if ($list['key'] == "" and $list['secret'] == "") {
$provider_name = $this->providerHandler->getNameById($list['id']);
$criteria->add('social_media_type', $provider_name);
$providerUserLinkHandler->deleteAll($criteria);
}
}
// コミット
$this->root->cms->database()->queryF('COMMIT');
// 画面遷移
redirect_header(XOOPS_URL . '/modules/social_media/admin/index.php?controller=provider_list', 1, t('provider information is updated'));
} catch (Exception $e) {
$this->errors[] = $e->getMessage();
$this->root->cms->database()->queryF('ROLLBACK');
}
}
function fetchSummary($external_link_id)
{
global $xoopsDB, $xoopsConfig, $xoopsUser;
$myts =& MyTextSanitizer::getInstance();
$module_handler =& xoops_gethandler('module');
$module =& $module_handler->getByDirname($this->mydirname);
$eventcomment_id = intval($external_link_id);
$mydirname = $this->mydirname;
if (!preg_match('/^(\\D+)(\\d*)$/', $mydirname, $regs)) {
die('Invalid mydirname');
}
$mydirnumber = $regs[2] === '' ? '' : intval($regs[2]);
$table_event = $xoopsDB->prefix("pical{$mydirnumber}_event");
$MOD_PATH = XOOPS_ROOT_PATH . '/modules/' . $mydirname;
if (!class_exists('piCal_xoops')) {
require_once $MOD_PATH . '/class/piCal.php';
require_once $MOD_PATH . '/class/piCal_xoops.php';
}
$cal = new piCal_xoops('', $xoopsConfig['language'], true);
include $MOD_PATH . '/include/read_configs.php';
$whr_categories = $cal->get_where_about_categories();
$whr_class = $cal->get_where_about_class();
$content_row = $xoopsDB->fetchArray($xoopsDB->query("SELECT id, summary, description FROM {$table_event} WHERE id={$eventcomment_id} AND ({$whr_categories}) AND ({$whr_class})"));
if (empty($content_row)) {
redirect_header(XOOPS_URL . '/user.php', 3, _NOPERM);
exit;
}
$subject = $myts->makeTboxData4Show($content_row['summary']);
//HACK by domifara
// $uri = XOOPS_URL.'/modules/'.$mydirname.'/index.php?action=View&event_id='.$eventcomment_id;
$uri = XOOPS_URL . '/modules/' . $mydirname . '/index.php?action=View&event_id=' . $eventcomment_id;
$str = strip_tags($myts->displayTarea(strip_tags($content_row['description'])));
$summary = xoops_substr($str, 0, 255);
return array('dirname' => $mydirname, 'module_name' => $module->getVar('name'), 'subject' => $subject, 'uri' => $uri, 'summary' => $summary);
}
function dispatch()
{
global $xoopsUser, $xoopsUserIsAdmin;
if(!$this->checkPermissionForGuest()){
redirect_header(XOOPS_URL, 2, _NOPERM);
}
$limit = 10;
$start = $this->getIntRequest('s', XSNS_REQUEST_GET);
if(!$start){
$start = 0;
}
$uid_to = $this->getIntRequest('uid', XSNS_REQUEST_GET);
$uid_from = is_object($xoopsUser) ? $xoopsUser->getVar('uid') : -1;
$user_handler =& XsnsUserHandler::getInstance();
$user_to =& $user_handler->get($uid_to);
if(!is_object($user_to) || $user_to->getVar('level') < 1){
redirect_header(XOOPS_URL, 2, _NOPERM);
}
$intro_list =& $user_to->getIntroList($limit, $start);
$intro_count = $user_to->getIntroCount();
$pager = $this->getPageSelector(XSNS_URL_MYPAGE_INTRO.'&uid='.$uid_to,
$start, $limit, count($intro_list), $intro_count);
$this->context->setAttribute('intro_list', $intro_list);
$this->context->setAttribute('intro_count', $intro_count);
$this->context->setAttribute('pager', $pager);
$this->context->setAttribute('user_menu', $user_to->getMypageMenu());
$this->context->setAttribute('uid_to', $uid_to);
$this->context->setAttribute('uid_from', $uid_from);
$this->context->setAttribute('is_xoops_admin', $xoopsUserIsAdmin);
}
function dispatch()
{
if($this->isGuest()){
redirect_header(XOOPS_URL, 2, _NOPERM);
}
$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) || $community->getTopicCount() > 0){
redirect_header(XOOPS_URL, 2, _NOPERM);
}
$commu_data = array(
'id' => $cid,
'name' => $community->getVar('name'),
'info' => $community->getVar('info'),
);
$this->context->setAttribute('commu', $commu_data);
}
function &execute(&$controller, &$request, &$user)
{
$answer =& $request->getAttribute('answer');
redirect_header('index.php?action=detail&qid=' . $answer->getVar('qid'), 1, _MD_PLZXOO_MESSAGE_SUCCESS);
$renderer = new mojaLE_NoneRenderer($controller, $request, $user);
return $renderer;
}
function dispatch()
{
global $xoopsUser;
if($this->isGuest()){
redirect_header(XOOPS_URL, 2, _NOPERM);
}
$own_uid = $xoopsUser->getVar('uid');
$cid = $this->getIntRequest('cid', XSNS_REQUEST_GET);
if(!isset($cid)){
redirect_header(XOOPS_URL, 2, _NOPERM);
}
// コミュニティの取得
$perm = XSNS_AUTH_MEMBER | XSNS_AUTH_SUB_ADMIN;
$commu_handler =& XsnsCommunityHandler::getInstance();
$community =& $commu_handler->get($cid);
if(!is_object($community) || !$community->checkAuthority($perm)
|| $community->getVar('uid_admin') == $own_uid){
redirect_header(XOOPS_URL, 2, _NOPERM);
}
$commu = array(
'id' => $cid,
'name' => $community->getVar('name'),
);
$this->context->setAttribute('commu', $commu);
}
public function eventCoreHeaderStart($args)
{
global $xoopsDB;
$sql = "select `tt_bootstrap_color` from `" . $xoopsDB->prefix("tadtools_setup") . "` where `tt_theme`='{$GLOBALS['xoopsConfig']['theme_set']}'";
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error());
list($tt_bootstrap_color) = $xoopsDB->fetchRow($result);
if ($_GET['WebID']) {
$_SESSION['bootstrap'] = 3;
$_SESSION['web_bootstrap'] = 3;
} else {
$_SESSION['bootstrap'] = 2;
$_SESSION['web_bootstrap'] = 2;
if ($tt_bootstrap_color == "bootstrap3") {
$_SESSION['bootstrap'] = 3;
$_SESSION['web_bootstrap'] = 3;
} else {
$c = explode('/', $tt_bootstrap_color);
if ($c[0] == "bootstrap3") {
$_SESSION['bootstrap'] = 3;
$_SESSION['web_bootstrap'] = 3;
}
}
}
if ($_REQUEST['WebID'] and strpos($_SERVER['PHP_SELF'], "modules/tad_web") !== false and strpos($_SERVER['REQUEST_URI'], "?WebID=") !== false) {
$GLOBALS['xoopsConfig']['theme_set_allowed'][] = "for_tad_web_theme";
$_REQUEST['xoops_theme_select'] = "for_tad_web_theme";
} else {
$_REQUEST['xoops_theme_select'] = $GLOBALS['xoopsConfig']['theme_set'];
}
}
function fetchSummary($external_link_id)
{
global $xoopsDB;
$db =& $this->d3dConf->db;
$myts =& $this->d3dConf->myts;
$entryID = intval($external_link_id);
$mydirname = $this->mydirname;
if (preg_match('/[^0-9a-zA-Z_-]/', $mydirname)) {
die('Invalid mydirname');
}
$uid = $this->d3dConf->uid;
$sql = "SELECT d.bid AS bid, d.uid AS uid, d.cid AS cid, d.title AS title, d.vgids AS vgids, d.vpids AS vpids, \n\t\td.diary AS diary, d.create_time AS create_time, d.openarea AS openarea_entry, d.create_time, \n\t\td.dohtml AS dohtml, cfg.openarea AS openarea, \n\t\tc.openarea AS openarea_cat, c.vgids AS vgids_cat, c.vpids AS vpids_cat \n\t\tFROM " . $db->prefix($mydirname . '_diary') . " d LEFT JOIN " . $db->prefix($mydirname . '_config') . " cfg ON d.uid=cfg.uid LEFT JOIN " . $db->prefix($mydirname . '_category') . " c ON (d.cid=c.cid AND (d.uid=c.uid OR c.uid='0')) WHERE d.bid ='" . $entryID . "'";
$content_row = $db->fetchArray($db->query($sql));
//var_dump($sql); var_dump($content_row);
$diary_uid = (int) $content_row['uid'];
$dohtml = (int) $content_row['dohtml'];
$_tmp_isfriend = $this->mPerm->check_is_friend($diary_uid);
$_tmp_isfriend2 = $this->mPerm->check_is_friend2($diary_uid);
$_tmp_op = (int) $content_row['openarea'];
list($_got_op, $_slctd_op, $_tmp_gperms, $_tmp_pperms) = $this->d3dConf->mPerm->override_openarea($_tmp_op, $content_row['openarea_entry'], $content_row['openarea_cat'], $content_row['vgids'], $content_row['vpids'], $content_row['vgids_cat'], $content_row['vpids_cat']);
// var_dump($_tmp_gperms); var_dump($_tmp_pperms);
$permission = $this->d3dConf->mPerm->can_display($diary_uid, $_got_op, $content_row['create_time'], $_tmp_isfriend, $_tmp_isfriend2, $_tmp_gperms, $_tmp_pperms);
//var_dump($diary_uid); var_dump($_got_op); var_dump($_slctd_op); var_dump($content_row['create_time']); var_dump($_tmp_isfriend); var_dump($_tmp_isfriend2); var_dump($_tmp_gperms); var_dump($_tmp_pperms); var_dump($content_row['openarea_entry']); var_dump($content_row['openarea_cat']); echo"<br />";
//checking permission : if false, redirect
//if( $permission != true ) {
if ($permission != true && ($this->mPerm->exerpt_ok_bymod !== true || $this->mod_config['can_disp_com'] !== 1)) {
redirect_header(XOOPS_URL . '/user.php', 3, _NOPERM);
exit;
}
$categoryID = $content_row['cid'];
$uri = XOOPS_URL . '/modules/' . $mydirname . '/index.php?page=detail&bid=' . $entryID . '&req_uid=' . $diary_uid;
$summary = $this->func->substrTarea($content_row['diary'], $dohtml, 255, true);
return array('dirname' => $mydirname, 'module_name' => $this->d3dConf->module_name, 'subject' => $myts->makeTboxData4Show($content_row['title']), 'uri' => $uri, 'summary' => $summary);
}
function execute($request)
{
parent::execute($request);
$this->assign['content'] = $this->readWrappedFile($request);
// check existence
if (empty($this->assign['content'])) {
redirect_header(XOOPS_URL . "/modules/{$this->mydirname}/index.php", 2, _MD_PICO_ERR_READCONTENT);
exit;
}
$cat_data = $this->currentCategoryObj->getData();
$this->assign['category'] = $this->currentCategoryObj->getData4html();
// permission check
if (empty($this->assign['content']['can_read']) || empty($this->assign['content']['can_readfull'])) {
if ($this->uid > 0) {
redirect_header(XOOPS_URL . '/', 2, _MD_PICO_ERR_PERMREADFULL);
} else {
redirect_header(XOOPS_URL . '/user.php', 2, _MD_PICO_ERR_LOGINTOREADFULL);
}
exit;
}
// auto-register
if (!empty($this->mod_config['wraps_auto_register']) && @$cat_data['cat_vpath'][0] == '/') {
$register_class = empty($this->mod_config['auto_register_class']) ? 'PicoAutoRegisterWraps' : $this->mod_config['auto_register_class'];
require_once dirname(__FILE__) . '/' . $register_class . '.class.php';
$register_obj = new $register_class($this->mydirname, $this->mod_config);
$affected_rows = $register_obj->registerByCatvpath($cat_data);
if ($affected_rows > 0) {
// reload if the content is updated
header('Location: ' . pico_common_unhtmlspecialchars($this->assign['mod_url']) . '/' . pico_common_unhtmlspecialchars($this->assign['content']['link']));
exit;
}
}
// link for "tell to friends"
// (TODO?)
if ($this->mod_config['use_taf_module']) {
$this->assign['content']['tellafriend_uri'] = XOOPS_URL . '/modules/tellafriend/index.php?target_uri=' . rawurlencode(pico_common_unhtmlspecialchars($this->assign['mod_url'] . '/' . $this->assign['content']['link'])) . '&subject=' . rawurlencode(sprintf(_MD_PICO_FMT_TELLAFRIENDSUBJECT, @$GLOBALS['xoopsConfig']['sitename']));
} else {
$this->assign['content']['tellafriend_uri'] = 'mailto:?subject=' . pico_main_escape4mailto(sprintf(_MD_PICO_FMT_TELLAFRIENDSUBJECT, @$GLOBALS['xoopsConfig']['sitename'])) . '&body=' . pico_main_escape4mailto(sprintf(_MD_PICO_FMT_TELLAFRIENDBODY, $this->assign['content']['subject'])) . '%0A' . rawurlencode(pico_common_unhtmlspecialchars($this->assign['mod_url'] . '/' . $this->assign['content']['link']));
}
// breadcrumbs
$breadcrumbsObj =& AltsysBreadcrumbs::getInstance();
$breadcrumbsObj->appendPath('', $this->assign['content']['subject']);
$this->assign['xoops_breadcrumbs'] = $breadcrumbsObj->getXoopsbreadcrumbs();
$this->assign['xoops_pagetitle'] = $this->assign['content']['subject'];
// views
switch ($request['view']) {
case 'singlecontent':
$this->template_name = 'db:' . $this->mydirname . '_independent_singlecontent.html';
$this->is_need_header_footer = false;
break;
case 'print':
$this->template_name = 'db:' . $this->mydirname . '_independent_print.html';
$this->is_need_header_footer = false;
break;
default:
$this->template_name = $this->mydirname . '_main_viewcontent.html';
$this->is_need_header_footer = true;
break;
}
}
function get_option($of_csn = '', $def_csn = '', $chk_view = 1, $chk_up = 1)
{
global $xoopsDB, $xoopsUser, $xoopsModule, $isAdmin;
$tadgallery = new tadgallery();
$ok_cat = $ok_up_cat = "";
if ($chk_view) {
$ok_cat = $tadgallery->chk_cate_power();
}
if ($chk_up) {
$ok_up_cat = $tadgallery->chk_cate_power("upload");
}
$option = "";
$sql = "select csn,title from " . $xoopsDB->prefix("tad_gallery_cate") . "\n where of_csn='{$of_csn}' order by sort";
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error());
while (list($csn, $title) = $xoopsDB->fetchRow($result)) {
if ($chk_view and is_array($ok_cat)) {
if (!in_array($csn, $ok_cat)) {
continue;
}
}
if ($chk_up and is_array($ok_up_cat)) {
if (!in_array($csn, $ok_up_cat)) {
continue;
}
}
$selected = $csn == $def_csn ? "selected" : "";
$option .= "<option value='{$csn}' {$selected}>{$title}</option>\n";
}
return $option;
}
