?? doc.func.php
字號:
<?php
if (basename($_SERVER['PHP_SELF']) == "doc.func.php") {
exit("<h1>Access Denied</h1>");
}
function splitHtml($html,$preg='/(<div\s+class=\"hdwiki_tmml\">.+?<\/div>)/i')
{
$arrhtml=preg_split($preg,$html,-1,PREG_SPLIT_DELIM_CAPTURE);
$count=count($arrhtml);
for($i=0;$i<$count;$i++)
{
if(preg_match($preg,$arrhtml[$i])){
$resarr[$i]['value']=strip_tags($arrhtml[$i]);
$resarr[$i]['flag']=1;
continue;
}
$resarr[$i]['value']=$arrhtml[$i];
$resarr[$i]['flag']=0;
}
unset($arrhtml);
return $resarr;
}
function joinHtml($arrhtml)
{
$count=count($arrhtml);
$str='';
for($i=0;$i<$count;$i++)
{
if($arrhtml[$i]['flag']==1)
{
$str.="<div class=\"hdwiki_tmml\">".$arrhtml[$i]['value']."</div>";
}else {
$str.=$arrhtml[$i]['value'];
}
}
return $str;
}
function getSections($resarr)
{
$arrsection=array();
for($i=0;$i<count($resarr);$i++)
{
if($resarr[$i]['flag']==1)
{
$arrsection[]=array('key'=>$i,'value'=>$resarr[$i]['value']);
}
}
unset($resarr);
return $arrsection;
}
function getDocByTitle( $title )
{
$title=strtoupper($title);
global $g_table_prefix,$DB;
$sql=" select * from {$g_table_prefix}doc where doc_title_upper ='{$title}' and state=1 ";
$res = $DB->execQuery( $sql );
if($DB->getNumRows()>0){
$arr_doc_info = $DB->fetchArray0( $res );
}
return $arr_doc_info;
}
function spiltTags($doc_tags)
{
$tags=split(';',$doc_tags) ;
$arrTags=array();
foreach ($tags as $tag)
{
if(!empty($tag))
{
$arrTags[]=$tag;
}
}
return $arrTags;
}
function joinTags($arrTags)
{
$arrRes=array();
foreach ($arrTags as $tag)
{
if(!empty($tag))
{
$arrRes[]=trim($tag);
}
}
return implode(';',array_unique($arrRes));
}
function getDocUserList($docid)
{
global $g_table_prefix,$DB;
$sql= " SELECT a.* , b.*
FROM (
SELECT max( his_created_time ) AS edit_time, his_creator, count( his_id ) AS edit_count
FROM {$g_table_prefix}his AS h
WHERE h.doc_id = ".$docid."
GROUP BY his_creator
) AS a, {$g_table_prefix}user b
WHERE a.his_creator = b.user_id
ORDER BY a.edit_count DESC,a.edit_time DESC ";
$res = $DB->execQuery( $sql );
if($DB->getNumRows()>0){
$arr_doc_user_info = $DB->fetchArray( $res );
}
return $arr_doc_user_info;
}
function getDocHisList($docid)
{
global $g_table_prefix,$DB;
$sql= " SELECT h.*,u.user_nick
FROM (
SELECT his_created_time, his_creator, his_id, doc_edition_no, his_kind, his_reason
FROM {$g_table_prefix}his AS h
WHERE h.doc_id = ".$docid."
AND h.state=1
ORDER BY doc_edition_no DESC
) h, {$g_table_prefix}user u
WHERE h.his_creator=u.user_id ";
$res = $DB->execQuery( $sql );
if($DB->getNumRows()>0){
$arr_doc_user_info = $DB->fetchArray( $res );
}
return $arr_doc_user_info;
}
function getDocHisInfo($hisid)
{
global $g_table_prefix,$DB;
$sql= " SELECT h.*,u.user_nick
FROM {$g_table_prefix}his h, {$g_table_prefix}user u
WHERE h.his_id= ".$hisid."
AND h.state=1
AND u.user_id=h.his_creator ";
$res = $DB->execQuery( $sql );
if($DB->getNumRows()>0){
$arr_doc_user_info = $DB->fetchArray0( $res );
}
return $arr_doc_user_info;
}
function getDocHisCompare($hisnewid,$hisoldid)
{
global $g_table_prefix,$DB;
$sql= " SELECT h.*,u.user_nick
FROM {$g_table_prefix}his h, {$g_table_prefix}user u
WHERE h.his_id
IN (".$hisnewid.",".$hisoldid.")
AND h.state=1
AND u.user_id=h.his_creator ";
$res = $DB->execQuery( $sql );
if($DB->getNumRows()>0){
$arr_doc_user_info = $DB->fetchArray( $res );
}
return $arr_doc_user_info;
}
#鏈
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -