コード例 #1
0
ファイル: write.skin.php プロジェクト: J2paper/narinwiki
	  <th>보안이미지</th>
	  <td>
	  <input class='ed' type=input size=10 name=wr_key itemname="자동등록방지" required><img id='kcaptcha_image' /><span style="margin-left:85px">왼쪽의 글자를 입력하세요.</span>
	  </td>
	</tr>
	<? } ?>
	
	<tr>
		<td colspan="2" style="text-align:center">
			<? if($member['mb_id']) { ?>
			<span class="button green"><a href="#tmpsave" id="btn_tmpsave">임시저장</a></span>&nbsp;
			<? } ?>
			<span class="button red"><input type=submit id="btn_submit" value="완료" border=0 accesskey='s'></span>&nbsp;
	    <span class="button"><a href="javascript:history.go(-1);" id="btn_back">뒤로</a></span>&nbsp;
	    <span class="button"><a href="<?php 
echo wiki_url();
?>
" id="btn_list">시작페이지</a></span></td>
	  </td>
	 </tr>
	</table>

</form>

<script type="text/javascript" src="<?php 
echo $wiki['g4_url'];
?>
/js/jquery.kcaptcha.js"></script>
<script type="text/javascript">
<?
// 관리자라면 분류 선택에 '공지' 옵션을 추가함
コード例 #2
0
ファイル: narin.syntax.php プロジェクト: J2paper/narinwiki
	/**
	 *
	 * 위키 문서 링크
	 *
	 * @param array $matches 매칭 결과
	 * @param array $params {@link NarinParser} 에서 전달하는 파라미터
	 * @return string 문서 링크
	 */
	public function wiki_internal_link($matches, $params)
	{
		$doc = $matches[2].$matches[4];
		$title = $matches[6];
		$path = explode("/", $matches[4]);

		// 문서내 링크
		if(preg_match("/^#/", $matches[4])) {
			if(!$title) $title = preg_replace("/^#/", "", $matches[4]);
			return sprintf(
	      '<a href="%s" class="%s">%s</a>',
			$matches[4],
	      "wiki_active_link",
			$title
			);
		}

		if(!$title) $title = array_pop($path);

		// 문서 존재 여부 확인
		list($ns, $docname, $full) = wiki_page_name($doc);

		$article =& wiki_class_load("Article");
		$is_exists = $article->exists($ns, $docname);
		if($is_exists) $class = "wiki_active_link";
		else $class = "wiki_inactive_link";

		// [[/narin/나린위키 문법#HML 직접 작성]] 과 같이
		// 문단 링크 허용 (FROM 2011-12-01)
		/*
		$hash = '';
		if(strpos($full, '#')) {
			list($doc, $hash) = explode('#', $full);
			$hash = '#' . $hash;
		}
		*/
		return sprintf(
      '<a href="%s" class="%s">%s</a>',
		wiki_url('read', array('doc'=>$doc)),
		$class,
		$title
		);
	}
コード例 #3
0
ファイル: doc_update.php プロジェクト: J2paper/narinwiki
	exit;	
}

if($wiki_folder_switch == "wiki_folder_select") {
	$wiki_folder = $wiki_folder_select;
} else {
	$wiki_folder = $wiki_folder_input;
}

$wiki_doc = stripcslashes($wiki_doc);
$wiki_folder = stripcslashes($wiki_folder);

// 문자열 끝에 '/' 가 있다면 '/' 삭제
$wiki_folder = preg_replace("/\/$/", "", $wiki_folder);

// target folder 가 없다면 '/' 로 셋팅
$toDoc = ($wiki_folder == "" ? "/" : $wiki_folder."/") . $wiki_doc;

// target folder 유효성 체크
wiki_validate_doc($toDoc);

if($write[ns] != $wiki_folder || $write[doc] != $wiki_doc) {
	$wikiArticle->moveDoc($fulldoc, $toDoc, $write['wr_id']);
}

$wikiArticle->updateLevel($toDoc, $wiki_access_level, $wiki_edit_level);

wiki_goto_url(wiki_url('read', array('doc'=>$toDoc)));

?>
コード例 #4
0
ファイル: move_doc_all.php プロジェクト: J2paper/narinwiki
 * @license GPL2 (http://narinwiki.org/license)
 * @author	byfun (http://byfun.com)
 * @filesource
 */

include_once "./_common.php";

if( !$is_wiki_admin )
{	
	alert("권한이 없습니다");
	exit;
}

$folder = stripcslashes($folder);
$move_to_folder = stripcslashes($move_to_folder);

if($folder != $move_to_folder) {
	$wikiArticle =& wiki_class_load("Article");
	for($i=0; $i<count($chk_wr_id); $i++) {
		$wr = &$wikiArticle->getArticleById($chk_wr_id[$i]);
		if(!$wr) continue;
		$fromDoc = wiki_doc($folder, $wr['wr_subject']);
		$toDoc = wiki_doc($move_to_folder, $wr['wr_subject']);
		$wikiArticle->moveDoc($fromDoc, $toDoc, $wr['wr_id']);
	}
}

header("location:".wiki_url('folder', array('loc'=>stripcslashes($move_to_folder))));

?>
コード例 #5
0
 * @subpackage event
 * @license GPL2 (http://narinwiki.org/license)
 * @author	byfun (http://byfun.com)
 * @filesource
 */
 
if (!defined('_GNUBOARD_')) exit;

// 위키문서 링크 수정 (/ 로 시작하지 않는 문서에 대해서)
$util =& wiki_class_load("Util");
$content = $util->wiki_fix_internal_link($wr_content);

if($content != $wr_content) {
	$content = mysql_real_escape_string($content);
	sql_query("UPDATE ".$this->wiki['write_table']." SET wr_content = '$content' WHERE wr_id = $comment_id");
}		

	
// 최근 변경 내역 업데이트
if($w == 'c' || $w == 'cu') {
	list($ns, $docname, $doc) = wiki_page_name($wr_doc);
	$wikiChanges =& wiki_class_load("Changes");
	if($w == 'c') $status = "댓글 작성";
	else $status = "댓글 편집";
	$wikiChanges->update("DOC", $doc, $status, ($member['mb_id'] ? $member['mb_id'] : $wr_name));		
}

wiki_goto_url(wiki_url('read', array('doc'=>$doc.'#c_'.$comment_id)));
exit;
?>
コード例 #6
0
ファイル: diff.php プロジェクト: J2paper/narinwiki
echo $diffData;
?>

<div class="clear" style="margin-top:10px">
	<div style="float:left">
		<span class="button"><a href="<?php 
echo wiki_url();
?>
">시작페이지</a></span>
		<span class="button"><a href="<?php 
echo wiki_url('history', array('doc' => $doc));
?>
">문서이력  목록</a></span>
		<span class="button red"><a href="<?php 
echo wiki_url('read', array('doc' => $doc));
?>
">문서보기</a></span>
		<? if($is_wiki_admin || $is_doc_owner) { ?>
		<span class="button green"><a href="javascript:recover_history(<?php 
echo $article['wr_id'];
?>
, <?php 
echo $hid;
?>
);">이 문서로 복원</a></span>
		<? } ?>
	</div>
	<div style="float:right">
		<span class="button"><a href="javascript:history.go(-1);">뒤로</a></span>
	</div>
コード例 #7
0
for ($i=count($wr_id_array)-1; $i>=0; $i--) 
{
	$write = sql_fetch(" select wr_id from ".$this->wiki['write_table']." where wr_id = '".$wr_id_array[$i]."' ");
	
	if(!$write) {
	
		$wikiArticle->deleteArticleById($wr_id_array[$i]);				
		$wikiCache->delete($wr_id_array[$i]);
		
		$d_doc = $delete_all_docs[$wr_id_array[$i]];
		
		$wikiHistory->setUnlinked($wr_id_array[$i], $d_doc);
		
		$backlinks = $wikiArticle->getBackLinks($d_doc, $includeSelf = false);
		$wikiChanges->update("DOC", $d_doc, "삭제", $member['mb_id']);				
		for($k=0; $k<count($backlinks); $k++) {
			$wikiArticle->shouldUpdateCache($backlinks[$k]['wr_id'], 1);
		}
	}			
}		

if($folder) {
	$bo_table = $wiki['bo_table'];
	$ns = $wikiNS->get($folder);
	if(!$ns) wiki_goto_url(wiki_url());
	else wiki_goto_url(wiki_url('folder', array('loc'=>$folder)));
	exit;
}		

?>
コード例 #8
0
	/**
	 *
	 * 트리 배열로 트리 HTML 생성
	 *
	 * @param array $tree _build_tree 에서 만들어지 트리 배열
	 * @param string $prefix prefix 로 사용할 부모 폴더 경로
	 * @param string $current 현재 폴더 경로
	 * @return string 트리 HTML
	 */
	function _build_list($tree, $prefix = '', $current = '') {
		$url = $this->wiki['url'].'/folder.php?bo_table='.$this->wiki['bo_table'].'&loc=';
		$ul = '';
		foreach ($tree as $key => $value) {
			$li = '';
			$folder = $prefix.$key;
			if(preg_match("/^".preg_quote($folder, "/")."/", $current)) $class = ' class="open"';
			else $class = '';
			$link = wiki_url('folder', array('loc'=>$folder));
			if (is_array($value)) {
				$li .= '<li'.$class.'><span class="folder"><a href="'.$link.'" code="'.wiki_input_value($folder).'">'.$key.'</a></span>';
				$sub = $this->_build_list($value, "$prefix$key/", $current);
				if($sub) $li .= $sub;
				$ul .= $li.'</li>';
			} else {
				if($class != '') $closed = " leaf";
				else $closed = " leaf leaf_folder";
				$ul .= '<li'.$class.'><span class="folder '.$closed.'"><a href="'.$link.'" code="'.wiki_input_value($folder).'">'.$key.'</a></span></li>';
			}
		}
		return strlen($ul) ? sprintf('<ul>%s</ul>', $ul) : '';
	}
コード例 #9
0
ファイル: narin.wiki.lib.php プロジェクト: J2paper/narinwiki
/**
 *
 * 네비게이션 문자열 반환
 *
 * @uses $navi = wiki_navigation("/narin/plugins/locing", false);
 *
 * @param string $doc 문서 또는 폴더 경로
 * @param boolean $isNS $doc가 폴더 경로인지 아닌지
 * @return string 네비게이션문자열 (e.g. Home > 폴더 > 문서)
 */
function wiki_navigation($doc, $isNS=false) {
	global $wiki;

	if(!$isNS) list($ns, $docname, $fullpath) = wiki_page_name($doc);
	else $ns = $doc;

	$path = explode("/", $ns);

	$wiki_navigation = "<a href='".wiki_url('folder')."'>Home</a> > ";
	$hrefPath = "";
	for($i=0; $i<count($path); $i++) {
		if($path[$i]) {
			$hrefPath .= "/".$path[$i];
			$wiki_navigation .= " <a href='".wiki_url('folder', array('loc'=>$hrefPath))."'>".$path[$i]."</a> > ";
		}
	}
	return $wiki_navigation . " <a href='".wiki_url('read', array('doc'=>$doc))."'>$docname</a>";
}
コード例 #10
0
ファイル: syntax.php プロジェクト: J2paper/narinwiki-plugins
 /**
  *
  * include 처리 without js (currently no js version though)
  *
  * @param array $args 파라미터
  * @param array $params {@link NarinParser} 에서 전달하는 파라미터/ can be null
  * @return string include되고 파싱된 결과
  */
 public function wiki_include_nojs($args, $params)
 {
     // default parser, if params is not null
     if ($params) {
         $wikiParser = new NarinParser();
         $plugins =& $params['plugins'];
         $default =& $plugins[array_search('wiki_default_parser', $plugins)];
     } else {
         $wikiParser = wiki_class_load("Parser");
     }
     // if partial nocache used, should use container
     if (isset($args['partialnocache'])) {
         $args['nocontainer'] = false;
     }
     // folder access level check
     $wikiNS = wiki_class_load("Namespace");
     $n = $wikiNS->get($args['loc']);
     if ($this->member['mb_level'] < $n['ns_access_level']) {
         return "";
     }
     // container pre/post-fix vars
     if ($args['nocontainer']) {
         // flag box=no OR nocontainer
         $prefix = "";
         $postfix = "";
     } else {
         $prefix = "<div style='border:1px gray dotted; padding:5px; overflow:auto;'>" . "<div style='padding:5px 10px;background-color:#f8f8f8;'>";
         if (isset($args['partialnocache']) || isset($args['pnc'])) {
             $prefix .= "(partial nocache를 이용한) ";
         }
         $prefix .= "Include된 문서: " . "<a href='" . wiki_url('read', array('doc' => $args['path'])) . "'>" . $args['path'] . "</a></div>";
         $postfix = "</div>";
     }
     // get include article
     $wikiArticle = wiki_class_load("Article");
     if (!$wikiArticle->exists($args['loc'], $args['docname'])) {
         return $this->error_msg($args, "nonexist", $prefix, $postfix);
     }
     // cannot include itself
     $thisDoc = $this->doc . $this->board[bo_subject];
     //TODO: should be better way..
     if ($this->doc == $args['path'] || $thisDoc == $args['path']) {
         return $this->error_msg($args, "self", $prefix, $postfix);
     }
     $d = $wikiArticle->getArticle($args['loc'], $args['docname']);
     // page access level check
     if ($this->member['mb_level'] < $d['access_level']) {
         return "";
     }
     // include loop check
     if ($this->check_loop($d)) {
         return $this->error_msg($args, "loop", $prefix, $postfix);
     }
     // random=element 처리
     if (isset($args['random'])) {
         // element can be section_# for section, wiki_table, wiki_code, wiki_box
         if ($args['random'] == "wiki_box") {
             $matches = array();
             $lines = explode("\n", $d['wr_content']);
             $pattern = '/^\\s{2,}(.*?)$/';
             foreach ($lines as $k => $line) {
                 if (preg_match($pattern, $line, $match) && strlen($match[1]) > 0) {
                     array_push($matches, $match);
                 }
             }
             $n = count($matches);
             if ($n == 0) {
                 return $prefix . "해당 element가 없습니다." . $postfix;
             }
             $rndKey = array_rand($matches);
             $d['wr_content'] = $matches[$rndKey][0];
             $content = $wikiParser->parse($d);
             $content = $this->treat_footnotes(&$default, $content);
             $pattern = '/^<div class=\'narin_contents\'>|<div id="wiki_footnotes">.*<\\/div>$|<\\/div>$/s';
             $content = preg_replace($pattern, "", $content);
             return $prefix . $content . $postfix;
         }
     }
     // find the first secname and its level
     $pattern = '/[^=](=+)\\s*(.*?)\\s*\\1[^=]/s';
     if (preg_match($pattern, $d['wr_content'], $matches)) {
         $args['includeTopSectionLevel'] = strlen($matches[1]);
         // update the secmane based on param firstseconly
         if ($args['firstseconly']) {
             $args['secname'] = $matches[2];
         }
     }
     // extract specific section with given secname
     if ($args['secname']) {
         $pattern = '/[^=](=+)\\s*' . $args['secname'] . '\\s*\\1[^=]/s';
         if (preg_match($pattern, $d['wr_content'], $match)) {
             if (preg_match('/[^=](=+)\\s*' . $args['secname'] . '\\s*\\1(.*?)[^=]\\1[^=]/s', $d['wr_content'], $matches)) {
                 $section = $matches[1] . $args['secname'] . $matches[1] . $matches[2];
             } else {
                 preg_match('/[^=](=+)\\s*' . $args['secname'] . '.*/s', $d['wr_content'], $matches);
                 $section = $matches[0];
             }
             $d['wr_content'] = $section;
         } else {
             return $this->error_msg($args, "nosec", $prefix, $postfix);
         }
     }
     // for now ignore any 'include' in $d
     $loop_include_msg = "";
     if (!$args['nocontainer']) {
         $loop_include_msg = "<html><div style='border:1px gray dotted; padding:5px; overflow:auto;'><div style='padding:5px 10px;background-color:#f8f8f8;'>Include 대상 문서: \${1}</div><div style='color:red;padding:5px;'>다단계 include 대상이나, include 하지 않았습니다.</div></div></html>";
     }
     $d['wr_content'] = preg_replace("/{{page=([^?]*)[^}]*}}/s", $loop_include_msg, $d['wr_content']);
     // parse the included page
     $content = $wikiParser->parse($d);
     // if nocontainer, prepare seamless including, like closing tags, section & prepare afterwards
     if ($args['nocontainer']) {
         //			$params['parser']->stop = true;
         $this->save_section(&$default, &$args);
         $closeTags = $this->get_before(&$default, &$args);
         $openTags = $this->get_after(&$default, &$args);
     }
     // get rid of wiki_content, wiki_toc and wiki_footnote
     if ($args['nocontainer']) {
         // update footnotes
         $content = $this->treat_footnotes(&$default, $content);
         $pattern = '/^<div class=\'narin_contents\'>|<div id=\'wiki_toc\'>.*<!--\\/\\/ wiki_toc -->|<div id="wiki_footnotes">.*<\\/div>$|<\\/div>$/s';
     } else {
         $pattern = '/^<div class=\'narin_contents\'>|<div id=\'wiki_toc\'>.*<!--\\/\\/ wiki_toc -->|<a name[^<]*><\\/a>|<a href="#footnote_(\\d)" name="footnote_top_(\\d)" id="footnote_top_(\\d)">(\\d)\\)|<div id="wiki_footnotes">.*<\\/div>$|<\\/div>$/s';
     }
     $content = preg_replace($pattern, "", $content);
     if ($args['nocontainer']) {
         // add secname to TOC
         $pattern = '/<h(\\d)>([^<\\/h\\1]*)<\\/h\\1>/';
         preg_match_all($pattern, $content, $matches, PREG_SET_ORDER);
         foreach ($matches as $v) {
             array_push($default->toc, array("level" => $v[1], "title" => $v[2]));
         }
         $this->recover_section(&$default, &$args);
         return $closeTags . $content . "<!--// wiki_include -->" . $openTags;
     } else {
         return $prefix . $content . $postfix . "<!--// wiki_include -->";
     }
 }
コード例 #11
0
	/**
	 * 
	 * 그누보드 extend 처리
	 * 
	 * <g4>/extends/narin.wiki.extend.php 에서 호출하며,
	 * 요청되는 스크립트 파일에 따라 위키에서 필요한 처리를 수행
	 * 
	 * @param string $scriptFile 스크립트 파일 (write.php, board.php, write_update.php ...)
	 */
	function board($scriptFile) {
		
		global $wiki, $bo_table,  $wr_id, $board, $doc;
					
		// view
		if($scriptFile == "board.php" && $wr_id) {
			$wikiArticle =& wiki_class_load("Article");
			$view = & $wikiArticle->getArticleById($wr_id);
			$doc = ($view[ns] == "/" ? "" : $view[ns]."/") . $view[doc];
			wiki_goto_url(wiki_url('read', array('doc'=>$doc)));
			exit;			
		}
		
		// list
		if($scriptFile == "board.php" && !$wr_id) {
			header("location:".wiki_url());
			exit;
		}	
						
		// 에디터에게 글 작성 권한을 주기 위해...
		if($wr_id && $this->member['mb_id'] && $this->member['mb_id'] != $this->write['mb_id']) {
			
			$wikiArticle =& wiki_class_load("Article");			
			$wikiConfig =& wiki_class_load("Config");

			$default_edit_level = $wikiConfig->setting['edit_level'];
			$article = & $wikiArticle->getArticleById($wr_id);
			$edit_level = ( $article['edit_level'] ? $article['edit_level'] : $default_edit_level);				
			
			$is_doc_editor = ($this->member['mb_level'] >= $edit_level );
			if($scriptFile == "write.php" || $scriptFile == "write_update.php") {
				if($is_doc_editor) {					
					$this->write['mb_id'] = $this->member['mb_id'];			
					$this->write['is_editor'] = true;		
				}
			}
		} else if($wr_id && $this->member['mb_id'] && $this->member['mb_id'] == $this->write['mb_id']) {
			$this->write['is_owner'] = true;
		}
				
		// write
		if($scriptFile == "write.php" && !$doc && !$wr_id ) {
			header("location:".wiki_url());
			exit;			
		}						
	}
コード例 #12
0
	/**
	 * 
	 * 백링크 반환
	 * (백링크 : 문서를 링크하고 있는 다른 문서들)
	 * 
	 * @param string $doc 문서경로를 포함한 문서명
	 * @param boolean $includeSelf $doc 자신도 백링크에 포함할지 안할지
	 * @return array 문서목록 배열
	 */
	public function getBackLinks($doc, $includeSelf = false)
	{
		$escapedDoc = mysql_real_escape_string($doc);
		$list = array();
		// 2011-12-11 : 문서명뒤의 hash 태그사용할 수 있도록 수정
		$sql = "SELECT *, wb.wr_subject AS doc FROM ".$this->wiki['write_table']." AS wb 
				LEFT JOIN ".$this->wiki['nsboard_table']." AS nt ON wb.wr_id = nt.wr_id 
				WHERE nt.bo_table= '".$this->wiki['bo_table']."' 
							AND ( 
							      wb.wr_content LIKE '%[[".$escapedDoc."]]%' 
							      OR wb.wr_content LIKE '%[[".$escapedDoc."#%]]%'
							      OR wb.wr_content LIKE '%[[".$escapedDoc."|%'
							      OR wb.wr_content LIKE '%[[".$escapedDoc."#%|%'
							    ) 
							AND wb.wr_content NOT LIKE '%[[".$escapedDoc."/%'";
		$result = sql_query($sql);
		while($row = sql_fetch_array($result))
		{
			if(!$this->hasInternalLink($row['wr_content'], $doc)) {
				continue;
			}
			$bdoc = ($row['ns'] == "/" ? "/" : $row['ns'] . "/") . $row['doc'];
			if(!$includeSelf && $bdoc == $doc) continue;
				
			$row['href'] = wiki_url('read', array('doc'=>$bdoc));
			array_push($list, $row);
		}
		
		if(count($list)) $list = wiki_subval_asort($list, "doc");
		return $list;
	}
コード例 #13
0
ファイル: narin.php プロジェクト: J2paper/narinwiki
	$wiki_admin_href = $wiki['url']."/adm/";
	// 관리 패스
	$admin_href = $wiki['g4_url']."/adm/board_form.php?w=u&bo_table=".$bo_table;	
}

// 최근 변경내역 보기 링크
$recent_href = wiki_url('recent');

// 백링크
$back_links = $wikiArticle->getBackLinks($doc);


// 문서이력 URL
if( $is_doc_owner || $is_wiki_admin || $member['mb_level'] >= $history_access_level)
{
	$history_href = wiki_url('history', array('doc'=>$doc));
} else $history_href = "";

// 네비게이션
$navigation = wiki_navigation($doc);

// 공헌자
$contributors = $write['contributors'];


// 문서이력 보기라면 버튼 감춤
if($is_history) {
	$update_href = "";
	$delete_href = "";
	$comment_delete_href = "";
	$doc_admin_href = "";
コード例 #14
0
ファイル: folder_update.php プロジェクト: J2paper/narinwiki
// 폴더 정보 로드
$ns = $wikiNS->get($loc);

// 권한 검사
if($w != 'u' || !$loc || !$wiki_loc || !$ns || !$wiki_access_level || !$is_wiki_admin)
{
	alert("권한이 없습니다");
	exit;
}

// 문자열 끝에 '/' 가 있다면 '/' 삭제
$loc = preg_replace("/\/$/", "", $loc);
$wiki_loc = preg_replace("/\/$/", "", $wiki_loc);
if(!$wiki_loc) $wiki_loc = "/";

// 폴더 업데이트 (이동)
if($ns['ns'] != "/" && $wiki_loc != "/" && $ns['ns'] != $wiki_loc) {
	$wikiNS->updateNamespace($loc, $wiki_loc);
}

// 템플릿 설정
$wikiNS->setTemplate($wiki_loc, $wiki_template);

// 권한 설정
$wikiNS->updateAccessLevel($wiki_loc, $wiki_access_level);

// 리다이렉트
wiki_goto_url(wiki_url('folder', array('loc'=>stripcslashes($wiki_loc))));
?>
コード例 #15
0
ファイル: syntax.php プロジェクト: J2paper/narinwiki-plugins
	/**
	 *
	 * dataout inline 처리 without js (currently no js version though)
	 *
	 * @param array $args 파라미터
	 * @param array $params {@link NarinParser} 에서 전달하는 파라미터/ can be null
	 * @return string output
	 */
	public function wiki_dataout_inline_nojs($args, $params) {
		if($args['having']>0) {
			$having = "HAVING COUNT(1)=".$args['having'];
		}
	
		if($args['method'] == "rank") {
			if($args['having_target']>0) {
				$having_target = "HAVING COUNT(1)=".$args['having_target'];
			}
		
			$sql_wr_id = "SELECT wr_id FROM ".$args['db_table']."
							WHERE bo_table='".$this->bo_table."' AND ".$args['filter_keyword']." AND (".$args['filter_target'].") 
							GROUP BY wr_id ".$having_target;
			$res_wr_id = sql_query($sql_wr_id);
			$row_wr_id = mysql_fetch_assoc($res_wr_id);
			$sort_wr_id = $row_wr_id['wr_id'];
			if(!$sort_wr_id) return " <span style='color:red;'>등록정보없음</span> ";
				
			// make all wr_id list without filter_target
			mysql_query("SET @rank=0");
			$sql_rank = "SELECT rank FROM (
							SELECT @rank:=@rank+1 AS rank, wr_id, val FROM (
								SELECT d.wr_id, val FROM (
									SELECT wr_id FROM ".$args['db_table']."
									WHERE bo_table='".$this->bo_table."' AND ".$args['filter_keyword']." AND (".$args['filter_where'].")
									GROUP BY wr_id ".$having."
								) c, ".$args['db_table']." d
								WHERE d.bo_table='".$this->bo_table."' AND ".$args['filter_keyword']." AND d.wr_id=c.wr_id AND col = '".$args['field']."'
								ORDER BY CAST(val AS DECIMAL) ".$args['sort']."
							) r
						) g	
						WHERE g.wr_id = ".$sort_wr_id;
						//TODO: order should be done by proper casting.. maybe need to specify the data type 
						//		e.g. _int  --> CAST(val AS UNSIGNED), _dt --> CAST(val AS DATETIME), _num  --> CAST(val AS DECIMAL)
			$res_rank = sql_query($sql_rank);
			$row_rank = mysql_fetch_assoc($res_rank);
			return " ".$row_rank['rank']." ";
		}
			
		$sql_wr_id = "SELECT wr_id FROM ".$args['db_table']."
						WHERE bo_table='".$this->bo_table."' AND ".$args['filter_keyword']." AND (".$args['filter_where'].") 
						GROUP BY wr_id ".$having;
		$res_wr_id = sql_query($sql_wr_id);
		if($args['method'] == "count") {
			$nb_count = mysql_num_rows($res_wr_id);
			return " ".$nb_count." ";
		}else {
			$data_array = array();
			while($row_wr_id = mysql_fetch_assoc($res_wr_id)) {
				$wr_id = $row_wr_id['wr_id'];
			
				// fullpath is reserved for %pageid%, docname is reserved for %title%
				if($args['field']=='fullpath' || $args['field']=='%pageid%' || $args['field']=='%title%') {
					$wikiArticle =& wiki_class_load("Article");
					$write = $wikiArticle->getArticleById($wr_id);
					$fullpath = wiki_doc($write['ns'], $write['doc']);
					$href = wiki_url('read', array('doc'=>$fullpath));
					if($args['field']=='fullpath' || $args['field']=='%pageid%') {
						array_push($data_array, "<a href='".$href."' class='wiki_active_link'>".$fullpath."</a>");
					}else {
						array_push($data_array, "<a href='".$href."' class='wiki_active_link'>".$write['doc']."</a>");
					}
				}else {
					$sql = "SELECT val FROM ".$args['db_table']."
								WHERE bo_table='".$this->bo_table."' AND ".$args['filter_keyword']." AND col='".$args['field']."' AND wr_id=".$wr_id."
								GROUP BY wr_id";
					$row = sql_fetch($sql);
					array_push($data_array, $row['val']);
				}
				if($args['method'] == "item") {
					return " ".array_shift($data_array)." ";
				}
			}
			if(count($data_array) == 0) return " <span style='color:red;'>등록정보없음</span> ";
			sort($data_array);
				return " ".implode(", ", $data_array)." ";
		}
	}
コード例 #16
0
ファイル: recent.php プロジェクト: J2paper/narinwiki
$sql = "SELECT * FROM ".$wiki['changes_table']." WHERE bo_table = '".$wiki['bo_table']."' ORDER BY id DESC LIMIT $from_record, $page_rows";

$page_base_url = wiki_url('recent', array('page'=>''));
if($wiki['fancy_url']) $page_base_url .= '/';
$paging = get_paging(10, $page, $total_page, $page_base_url);


if($is_wiki_admin) {
	$clear_href = "javascript:clear_changes();";
	$delete_selected_href = "javascript:delete_selected_changes();";
} else {
	$clear_href = "";
	$delete_selected_href = "";
}

$list = array();
$res = sql_query($sql);
while($row = sql_fetch_array($res)) {
	if($row['target_type'] == "DOC") {
		$row['view_href'] = wiki_url('read', array('doc'=>$row[target]));
	} else if($row['target_type'] == "FOLDER") {
		$row['view_href'] = wiki_url('folder', array('loc'=>$row[target]));		
	}
	array_push($list, $row);
}


$wikiControl->includePage($wiki['inc_skin_path'] . "/recent.skin.php", $layout=true);	

?>
コード例 #17
0
ファイル: on_delete_tail.php プロジェクト: J2paper/narinwiki
$wikiArticle =& wiki_class_load("Article");
$article = $delete_article;

$doc = wiki_doc($article['ns'], $article['doc']);

$backlinks = $wikiArticle->getBackLinks($doc, $includeSelf = false);
for($i=0; $i<count($backlinks); $i++) {
	$wikiArticle->shouldUpdateCache($backlinks[$i]['wr_id'], 1);
}

$wikiArticle->deleteArticleById($wr_id);

// 문서 이력 삭제
$wikiHistory =& wiki_class_load("History");
$wikiHistory->setUnlinked($wr_id, $doc);
//$wikiHistory->clear($wr_id, $delete_all = true);

// 캐시 삭제				
$wikiCache =& wiki_class_load("Cache");
$wikiCache->delete($wr_id);

// 최근 변경 내역 업데이트
$wikiChanges =& wiki_class_load("Changes");
$wikiChanges->update("DOC", $doc, "삭제", ($member['mb_id'] ? $member['mb_id'] : $write[wr_name]));

wiki_goto_url(wiki_url());
exit;

?>
コード例 #18
0
	/**
	 *
	 * 문서이력 목록 반환
	 *
	 * @param int $wr_id 문서 id
	 * @param string $doc 문서명(경로포함)
	 * @param int $page 페이지
	 * @param int $page_rows 한 페이지당 보여줄 목록 수
	 * @return array 문서이력 목록
	 */
	function getHistory($wr_id, $doc, $page = 1, $page_rows = 20)
	{
		$bo_table = $this->wiki[bo_table];
		$wr_id = mysql_real_escape_string($wr_id);

		$sql_all = "SELECT id FROM ".$this->wiki['history_table']." AS ht
								LEFT JOIN ".$this->wiki['write_table']." AS wt ON ht.wr_id = wt.wr_id 
								WHERE ht.bo_table = '".$this->wiki['bo_table']."' AND ht.wr_id = '$wr_id' 
								ORDER BY ht.id DESC";	
		$result = sql_query($sql_all);
		$total_count = mysql_num_rows($result);

		$total_page  = ceil($total_count / $page_rows);
		$from_record = ($page - 1) * $page_rows; // 시작 열을 구함

		$sql = "SELECT ht.*, wt.wr_option, wt.mb_id, mt.mb_name, mt.mb_nick FROM ".$this->wiki['history_table']." AS ht
						LEFT JOIN ".$this->wiki['write_table']." AS wt ON ht.wr_id = wt.wr_id 
						JOIN ".$this->g4['member_table']." AS mt ON wt.mb_id = mt.mb_id
						WHERE ht.bo_table = '".$this->wiki['bo_table']."' AND ht.wr_id = '$wr_id' 
						ORDER BY ht.id DESC LIMIT $from_record, $page_rows";			
		$list = wiki_sql_list($sql);
		for($i=0; $i<count($list); $i++)
		{
			// 로그인 안한 상태로 작성했다면...
			if(!$list[$i]['mb_name']) {
				$list[$i]['mb_name'] = $list['editor_mb_id'];
				$list[$i]['mb_nick'] = $list['editor_mb_id'];
			}
			$list[$i]['content'] = nl2br(wiki_text($list[$i]['content']));
			$list[$i]['date'] = date("Y-m-d h:i", strtotime($list[$i]['reg_date']));
			if($list[$i][mb_id] == $this->member[mb_id] || $this->is_admin) {
				if($page != 1 || $i > 0) {
					$list[$i]['recover_href'] = "javascript:recover_history($wr_id, ".$list[$i]['id'].");";
					if($this->is_admin) {
						$list[$i]['delete_href'] = "javascript:delete_history(".$list[$i]['id'].");";
					}
				}
			}
		}
		
		$page_base_url = wiki_url('history', array('doc'=>$doc, 'page'=>''));
		$paging = get_paging(10, $page, $total_page, $page_base_url);

		$ret = array($list, $paging);

		return $ret;
	}