function getMenu()
{
$queryresult = getDbArray("SELECT * FROM `meal`");
$newresult = array();
//gruppieren des Arrays nach caterer
foreach ($queryresult as $result) {
$caterer_id = $result["caterer_id"];
$index_caterer = FALSE;
for ($i = 0; $i < count($newresult); $i++) {
if ($newresult[$i][0] == $caterer_id) {
$index_caterer = $i;
break;
}
}
if ($index_caterer === FALSE) {
$newresult[] = array($caterer_id);
$index_caterer = count($newresult) - 1;
}
$newresult[$index_caterer][] = array($result["meal_name"], $result["meal_price"], $result["idmeal"]);
}
//kodieren in UTF8
$newresult = utf8($newresult);
return $newresult;
}
<?php
$_sort = array(array('hit', 'desc'), array('comment', 'desc'));
?>
[RESULT:
<ul>
<?php
$_date = date('YmdHis', mktime(0, 0, 0, substr($date['today'], 4, 2), substr($date['today'], 6, 2) - 30, $date['year']));
$_RCD = getDbArray($table['bbsdata'], 'site=' . $s . ' and display=1 and d_regis > ' . $_date, '*', $_sort[$type - 1][0], $_sort[$type - 1][1], $num, 1);
$_i = 0;
while ($_R = db_fetch_array($_RCD)) {
$_i++;
?>
<li><i<?php
if ($_i < 4) {
?>
class="emp"<?php
}
?>
><?php
echo $_i;
?>
</i><a href="<?php
echo getPostLink($_R);
?>
"><?php
echo $_R['subject'];
?>
while (false !== ($files = readdir($dirh))) {
if (substr($files, -4) != '.php') {
continue;
}
$incs[] = str_replace('.php', '', $files);
}
closedir($dirh);
return $incs;
}
include $g['path_module'] . $module . '/var/var.search.php';
include $g['path_module'] . $module . '/var/var.order.php';
$MODULE_LIST = getDbArray($table['s_module'], '', '*', 'gid', 'asc', 0, $p);
$_names = array();
$PAGESET = array();
$TMPST = array();
$SITES = getDbArray($table['s_site'], '', '*', 'gid', 'asc', 0, $p);
$SITEN = db_num_rows($SITES);
?>
<div class="row" id="search-body">
<div class="col-sm-4 col-lg-3 rb-aside">
<div class="panel-group" id="accordion">
<div class="panel panel-default">
<div class="panel-heading rb-icon">
<div class="icon">
<i class="fa fa-search fa-2x"></i>
</div>
<h4 class="panel-title">
<a class="accordion-toggle collapsed" data-parent="#accordion" data-toggle="collapse" href="#collapseOne">
<?php
echo _LANG('a1001', 'search');
if ($_HH['usemobile'] == 1) {
$_HS = getUidData($table['s_site'], $_HH['startsite']);
} else {
if ($_HH['usemobile'] == 2) {
if ($g['url_root'] . '/' != $_HH['startdomain']) {
getLink($_HH['startdomain'], '', '', '');
}
}
}
}
if (!$_HS['uid']) {
$_HD = getDbData($table['s_domain'], "name='" . str_replace('www.', '', $_SERVER['HTTP_HOST']) . "'", '*');
if ($_HD['site']) {
$_HS = getUidData($table['s_site'], $_HD['site']);
} else {
$_HS = db_fetch_array(getDbArray($table['s_site'], '', '*', 'gid', 'asc', 1, 1));
}
}
$s = $_HS['uid'];
$r = $_HS['id'];
} else {
$_HS = getUidData($table['s_site'], $s);
}
if (!$_HS['lang']) {
$_HS['lang'] = $g['sys_lang'];
}
require $g['path_var'] . 'language/' . $_HS['lang'] . '/_sys.lang.php';
$_CA = array();
$date = getVDate($_HS['timecal']);
$g['s'] = str_replace('/index.php', '', $_SERVER['SCRIPT_NAME']);
$g['r'] = $_HS['rewrite'] ? $g['s'] . ($_HS['usescode'] ? '/' . $r : '') : '.';
" onclick="return cmentDel('<?php
echo $R['id'];
?>
',event);"><img src="<?php
echo $g['img_module_skin'];
?>
/btn_delete.gif" alt="삭제" title="삭제" /></a> <a href="javascript:;" onclick="doReply('<?php
echo $R['uid'];
?>
')"><img src="<?php
echo $g['img_module_skin'];
?>
/btn_modify.gif" alt="답변" title="답변" /></a></td>
</tr>
<?php
$TCD = getDbArray($table['s_oneline'], 'parent=' . $R['uid'], '*', 'uid', $d['comment']['orderby2'], 0, 0);
?>
<?php
while ($O = db_fetch_array($TCD)) {
?>
<?php
// echo $TPG . " = " . $p;// echo "<pre>"; print_r( $O ); echo "</pre>";
?>
<tr class="reply">
<td>┗ <div class="icon inline"><?php
echo $O['nic'];
?>
</div></td>
<td class="sbj"><?php
echo $O['content'];
?>
}
?>
<?php
if (!db_num_rows($SITES)) {
?>
<option value="">등록된 사이트가 없습니다.</option>
<?php
}
?>
</select>
<select name="bid" onchange="this.form.submit();">
<option value=""> + 전체게시판</option>
<option value="">---------------------------</option>
<?php
$_BBSLIST = getDbArray($table[$module . 'list'], '', '*', 'gid', 'asc', 0, 1);
?>
<?php
while ($_B = db_fetch_array($_BBSLIST)) {
?>
<option value="<?php
echo $_B['uid'];
?>
"<?php
if ($_B['uid'] == $bid) {
?>
selected="selected"<?php
}
?>
>ㆍ<?php
echo $_B['name'];
}
include_once $g['path_module'] . $m . '/var/var.php';
if ($cync) {
$_SESSION[$m . 'cync'] = $cync;
}
if (!$_SESSION[$m . 'cync']) {
getLink(RW(0), '', '동기화코드가 지정되지 않았습니다.', '');
}
$cyncArr = getArrayString($_SESSION[$m . 'cync']);
$mod = 'main';
$sort = $sort ? $sort : 'uid';
$orderby = $orderby ? $orderby : 'asc';
$recnum = $recnum && $recnum < 200 ? $recnum : $d['trackback']['recnum'];
$cmentque = "parent='" . $cyncArr['data'][0] . $cyncArr['data'][1] . "' and type=1";
$RCD = array();
$TCD = getDbArray($table['s_trackback'], $cmentque, '*', $sort, $orderby, $recnum, $p);
$NUM = getDbRows($table['s_trackback'], $cmentque);
$TPG = getTotalPage($NUM, $recnum);
while ($_R = db_fetch_array($TCD)) {
$RCD[] = $_R;
}
if ($g['mobile'] && $_SESSION['pcmode'] != 'Y') {
$B['skin'] = $d['trackback']['skin_mobile'];
} else {
$B['skin'] = $skin ? $skin : $d['trackback']['skin_main'];
}
$g['track_reset'] = $c ? $g['s'] . '/?r=' . $r . '&c=' . $c : getLinkFilter($g['s'] . '/?r=' . $r . '&m=' . $m, array('skin', 'iframe'));
$g['track_list'] = $g['track_reset'] . getLinkFilter('', array('p', 'sort', 'orderby', 'recnum', 'where', 'keyword'));
$g['track_action'] = $g['track_list'] . '&a=';
$g['track_delete'] = $g['track_action'] . 'delete&uid=';
$g['dir_module_skin'] = $g['dir_module'] . 'theme/' . $B['skin'] . '/';
echo $g['s'];
?>
/" method="post" class="rb-form">
<input type="hidden" name="r" value="<?php
echo $r;
?>
">
<input type="hidden" name="m" value="<?php
echo $module;
?>
">
<input type="hidden" name="a" value="">
<div class="dd" id="nestable-menu">
<ol class="dd-list">
<?php
$ADMPAGE = getDbArray($table['s_admpage'], 'memberuid=' . $my['uid'], '*', 'gid', 'asc', 0, 1);
?>
<?php
$_i = 1;
while ($R = db_fetch_array($ADMPAGE)) {
?>
<li class="dd-item dd3-item" data-id="<?php
echo $_i;
?>
">
<div class="dd-handle dd3-handle"></div>
<div class="dd3-content"><a href="<?php
echo $R['url'];
?>
"><?php
echo $R['name'];
function getCommentList($theme, $parent, $_where, $recnum, $sort, $orderby1, $orderby2, $cp)
{
global $g, $table, $_HS, $m, $my;
include $theme . '_var.php';
// 설정파일 인클루드
$g['img_module_skin'] = $theme . 'image/';
$NCD = array();
$RCD = array();
$cp = $cp ? $cp : 1;
$sort = $sort ? $sort : 'uid';
$orderby1 = $orderby1 ? $orderby1 : $d['comment']['orderby1'];
$orderby2 = $orderby2 ? $orderby2 : $d['comment']['orderby2'];
$recnum = $recnum ? $recnum : $d['comment']['recnum'];
$cmentque = " and parent='" . str_replace('-', '', $parent) . "'";
if ($_where) {
$cmentque .= " and " . $_where;
}
$PCD = getDbArray($table['s_comment'], 'notice=1' . $cmentque, '*', $sort, $orderby1, 0, 0);
$TCD = getDbArray($table['s_comment'], 'notice=0' . $cmentque, '*', $sort, $orderby2, $recnum, $cp);
$NUM = getDbRows($table['s_comment'], 'notice=0' . $cmentque);
$TPG = getTotalPage($NUM, $recnum);
while ($_R = db_fetch_array($PCD)) {
$NCD[] = $_R;
}
while ($_R = db_fetch_array($TCD)) {
$RCD[] = $_R;
}
//echo $cmentque;
$RCD = $NCD + $RCD;
$i = 1;
$namegi = $NUM - $cp * $recnum;
if ($namegi > 0) {
$namegi_ment = '총 <span class="text-danger namegi">' . $namegi . '</span> 개의 댓글이 더 있습니다.';
$btn_more = 'btn-more';
$is_namegi = 1;
} else {
$namegi_ment = '더이상 댓글이 없습니다.';
$btn_more = 'disabled';
$is_namegi = 0;
}
// 한줄의견 쓰는(현재 로그인한) 사용자 아바타 사진 url 세팅
if ($my['photo']) {
$avatar_img = $g['url_root'] . '/_var/avatar/' . $my['photo'];
} else {
$avatar_img = $g['url_root'] . '/_var/avatar/0.gif';
}
foreach ($RCD as $C) {
$C['mobile'] = isMobileConnect($C['agent']);
if ($C['mbruid']) {
$M = getDbData($table['s_mbrdata'], 'memberuid=' . $C['mbruid'], '*');
} else {
$M = array();
}
$isSECRETCHECK = true;
$JN_time = getJNTime($C['d_regis']);
// 지난시간 얻기 함수 호출
// 댓글 작성자 아바타 사진 url 세팅
if ($M['photo']) {
$avatar_img = $g['url_root'] . '/_var/avatar/' . $M['photo'];
} else {
$avatar_img = $g['url_root'] . '/_var/avatar/0.gif';
}
echo '
<section id="pinBoot" class="rb-pinterest-grid">
<article class="panel panel-default panel-google-plus comment-list" id="' . $C['uid'] . '-' . $C['score1'] . '-' . $C['oneline'] . '">
<div id="cuid-' . $C['uid'] . '">
<input type="hidden" name="is_namegi" value="' . $is_namegi . '"/>
<input type="hidden" name="TPG" value="' . $TPG . '"/>
<input type="hidden" name="theme" class="theme" value="' . $theme . '" />
<input type="hidden" name="parent" class="parent" value="' . $parent . '" />
<input type="hidden" name="c_content" class="c_content" value="' . htmlspecialchars(getContents($C['content'], $C['html'], $keyword)) . '" />
<div class="dropdown">
<span class="dropdown-toggle" type="button" data-toggle="dropdown">
<span class="[ glyphicon glyphicon-chevron-down ]"></span>
</span>
<ul class="dropdown-menu" role="menu">
<li role="presentation"><a role="menuitem" tabindex="-1" href="#">Action</a></li>
<li role="presentation"><a role="menuitem" tabindex="-1" href="#">Another action</a></li>
<li role="presentation"><a role="menuitem" tabindex="-1" href="#">Something else here</a></li>
<li role="presentation" class="divider"></li>
<li role="presentation"><a role="menuitem" tabindex="-1" href="#">Separated link</a></li>
</ul>
</div>
<div class="panel-google-plus-tags">
<ul>
<li>#자동차</li>
<li>#귀성길</li>
</ul>
</div>
<div class="panel-heading">
<img class="img-circle pull-left" src="/_core/opensrc/thumb/image.php?width=46&height:46&cropratio=1:1&image=' . $avatar_img . '" alt="' . $M[$_HS['nametype']] . ' 아바타 " />
<h3>소비자와 함께</h3>
<h5><span>제한적으로 공유함</span> - <span>' . getDateFormat($C['d_regis'], 'Y. m. d') . '</span> </h5>
</div>
<div class="panel-body">
<p>' . getContents($C['content'], $C['html'], $keyword) . '</p>
</div>
<div class="panel-footer">
<button type="button" class="btn btn-default">+1</button>
<button type="button" class="btn btn-default">
<span class="glyphicon glyphicon-share-alt"></span>
</button>
<div class="input-placeholder">댓글 추가...</div>
</div>
<div class="panel-google-plus-comment" id="comments-' . $C['uid'] . '-reply">
<input type="hidden" name="parent" value="' . $C['uid'] . '" />
<input type="hidden" name="theme" value="' . $theme . '" />
<input type="hidden" name="ouid" value="" />
<img class="img-circle pull-left" src="/_core/opensrc/thumb/image.php?width=46&height:46&cropratio=1:1&image=' . $avatar_img . '" alt="' . $my[$_HS['nametype']] . ' 아바타 " />
<div class="panel-google-plus-textarea">
<textarea rows="4"></textarea>
<button type="button" class="btn btn-success disabled" id="one-regis-' . $C['uid'] . '">댓글 올리기</button>
<button type="reset" class="btn btn-default">취소</button>
</div>
<div class="clearfix"></div>
</div>';
echo '<div id="oneline-box-' . $C['uid'] . '" class="one-list-wrap">';
// 한줄 의견 리스트 출력함수 호출
getOnelineList($theme, $C['uid']);
echo '</div>';
// 한 줄 의견 출력 박스
echo '</div>
</article>
</section>';
$i++;
}
//endforeach
$R = array();
// 더보기 버튼 설정시
if ($d['comment']['show_more']) {
echo '<button class="text-center btn btn-default btn-block ' . $btn_more . '"><i class="fa fa-sort-desc fa-lg"></i><span class="text-muted small"> 더 보기 ( ' . $namegi_ment . ' ) </span></button>';
}
}
<?php
$sort = $sort ? $sort : 'gid';
$orderby = $orderby ? $orderby : 'asc';
$recnum = $recnum && $recnum < 91 ? $recnum : 30;
$RCD = getDbArray($table['s_module'], '', '*', $sort, $orderby, $recnum, $p);
$NUM = getDbRows($table['s_module'], '');
$TPG = getTotalPage($NUM, $recnum);
if (!$id) {
$id = 'home';
}
$R = getDbData($table['s_module'], "id='" . $id . "'", '*');
?>
<div id="catebody">
<div id="category">
<form name="mform1" action="<?php
echo $g['s'];
?>
/" method="post" target="_action_frame_<?php
echo $m;
?>
">
<input type="hidden" name="r" value="<?php
echo $r;
?>
" />
<input type="hidden" name="m" value="<?php
echo $module;
?>
" />
}
?>
/>이 레이아웃에서 제공하는 메인화면(게시판 생성 필요)</label><br />
<label><input type="checkbox" name="mainType_rb" value="1"<?php
if ($d['layout']['mainType_rb']) {
?>
checked="checked"<?php
}
?>
/>킴스큐 자체에서 꾸미는 메인화면(직접꾸미기,위젯꾸미기,모듈콘텐츠 연결)</label><br />
</div>
</td>
</tr>
<?php
if ($d['layout']['mainType_layout']) {
$BBSLIST = getDbArray($table['bbslist'], '', '*', 'gid', 'asc', 0, 1);
$_RCD = array();
while ($_B = db_fetch_array($BBSLIST)) {
$_RCD[] = $_B;
}
?>
<tr>
<td class="t1">상단출력 대상물</td>
<td class="t2">:</td>
<td class="t3">
<select name="bbs1" class="select1">
<option value="0"<?php
if ($d['layout']['bbs1'] == '0') {
?>
selected="selected"<?php
}
}
if ($d['upload']['ftp_pasv']) {
ftp_pasv($FTP_CONNECT, true);
}
$FILES = getDbArray($table['s_upload'], "tmpcode='" . $sescode . "'", '*', 'uid', 'asc', 0, 0);
while ($R = db_fetch_array($FILES)) {
getDbDelete($table['s_upload'], 'uid=' . $R['uid']);
getDbUpdate($table['s_numinfo'], 'upload=upload-1', "date='" . substr($R['d_regis'], 0, 8) . "' and site=" . $R['site']);
ftp_delete($FTP_CONNECT, $d['upload']['ftp_folder'] . $R['folder'] . '/' . $R['tmpname']);
if ($R['type'] == 2) {
ftp_delete($FTP_CONNECT, $d['upload']['ftp_folder'] . $R['folder'] . '/' . $R['thumbname']);
}
}
ftp_close($FTP_CONNECT);
} else {
$FILES = getDbArray($table['s_upload'], "tmpcode='" . $sescode . "'", '*', 'uid', 'asc', 0, 0);
while ($R = db_fetch_array($FILES)) {
getDbDelete($table['s_upload'], 'uid=' . $R['uid']);
getDbUpdate($table['s_numinfo'], 'upload=upload-1', "date='" . substr($R['d_regis'], 0, 8) . "' and site=" . $R['site']);
unlink($g['path_file'] . $R['folder'] . '/' . $R['tmpname']);
if ($R['type'] == 2) {
unlink($g['path_file'] . $R['folder'] . '/' . $R['thumbname']);
}
}
}
}
if ($close == 'Y') {
$_SESSION['upsescode'] = '';
getLink('', '', '', 'close');
} else {
getLink('reload', 'parent.', '', '');
$_QUE = 'site=' . $s . ' and hidden=0';
if ($mbruid) {
$_QUE .= ' and mbruid=' . $mbruid;
}
if ($B['uid']) {
$_QUE .= ' and bbs=' . $B['uid'];
}
$RCD = array();
if ($mbruid) {
$M = getDbData($table['s_mbrdata'], 'memberuid=' . $mbruid, '*');
$TCD = getDbArray($table[$m . 'data'], $_QUE, '*', $sort, $orderby, $recnum, $p);
while ($_R = db_fetch_array($TCD)) {
$RCD[] = $_R;
}
} else {
$TCD = getDbArray($table[$m . 'data'], $_QUE, 'gid', $sort, $orderby, $recnum, $p);
while ($_R = db_fetch_array($TCD)) {
$RCD[] = getDbData($table[$m . 'data'], 'gid=' . $_R['gid'], '*');
}
}
Header("Content-type: text/xml");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
echo "<?xml version='1.0' encoding='utf-8'?>\r\n\r\n";
if ($type == 'rss1') {
?>
<rss version='2.0' xmlns:dc='http://purl.org/dc/elements/1.1/'>
<channel>
<title><?php
echo $mbruid ? $M[$_HS['nametype']] . '님의 포스트' : htmlspecialchars($B['name'] ? $B['name'] : $_HS['name']);
echo $infoNotice_element[uid];
?>
"><?php
echo $infoNotice_element[subject];
?>
</a></li>
<?php
}
?>
</ul>
</li>
<li class="noMargin">
<h1><a href="http://www.trevia.co.kr/?r=mexico&m=bbs&bid=epilogue"><img src="/pages/image/trevia_main_travelstory.gif" alt="여행후기 안내" /></a></h1>
<ul class="latestArticle">
<?php
$infoNotice = getDbArray($table['bbsdata'], "site = 7 AND bbs = 6 AND (bbsid='epilogue' OR bbsid='epilogue') AND notice = 0", "uid, subject,site", "gid", "asc", "5", "1");
?>
<?php
for ($i = 0; $infoNotice_element = db_fetch_array($infoNotice); $i++) {
?>
<li><a href="./?r=dubai&m=bbs&uid=<?php
echo $infoNotice_element[uid];
?>
"><?php
echo $infoNotice_element[subject];
?>
</a></li>
<?php
}
?>
</ul>
echo $wdgvar['title'];
?>
</a></h6>
<?php
} else {
?>
<h6><?php
echo $wdgvar['title'];
?>
</h6>
<?php
}
?>
<ul>
<?php
$_RCD = getDbArray($table['bbsdata'], ($wdgvar['bid'] ? 'bbs=' . $wdgvar['bid'] . ' and ' : '') . 'display=1 and site=' . $_HS['uid'], '*', 'gid', 'asc', $wdgvar['limit'], 1);
?>
<?php
$k = 0;
while ($_R = db_fetch_array($_RCD)) {
$k++;
?>
<?php
$_thumbimg = getUploadImage($_R['upload'], $_R['d_regis'], $_R['content'], 'jpg|jpeg');
?>
<?php
$_thumbimg = $_thumbimg ? $_thumbimg : $g['img_core'] . '/blank.gif';
?>
<?php
$_link = getPostLink($_R);
?>
<?php
$R = array();
$mtype = $mtype ? $mtype : 'admin';
$recnum = $recnum ? $recnum : 10;
$sendsql = 'admin=' . ($mtype == 'admin' ? 1 : 0);
$RCD = getDbArray($table['s_mbrdata'], $sendsql, '*', 'memberuid', 'asc', $recnum, $p);
$NUM = getDbRows($table['s_mbrdata'], $sendsql);
$TPG = getTotalPage($NUM, $recnum);
$_authset = array('', _LANG('aa001', 'admin'), _LANG('aa002', 'admin'), _LANG('aa003', 'admin'), _LANG('aa004', 'admin'));
?>
<div id="admin-users">
<div class="page-header">
<h4><?php
echo _LANG('aa005', 'admin');
?>
</h4>
</div>
<form name="listForm" action="<?php
echo $g['s'];
?>
/" method="post" onsubmit="return false;">
<input type="hidden" name="r" value="<?php
echo $r;
?>
">
<input type="hidden" name="m" value="<?php
echo $module;
?>
<?php
}
?>
<?php
if ($d['layout']['bbs3'] != 'n') {
?>
<?php
$_sort = explode(',', $d['layout']['sort3']);
?>
<?php
$_date = $d['layout']['bbs3_day'] != '' ? date('YmdHis', mktime(0, 0, 0, substr($date['today'], 4, 2), substr($date['today'], 6, 2) - $d['layout']['bbs3_day'], $date['year'])) : 0;
?>
<?php
$_RCD = getDbArray($table['bbsdata'], ($d['layout']['bbs3'] ? 'bbs=' . $d['layout']['bbs3'] : 'site=' . $s) . ' and display=1 and d_regis > ' . $_date, '*', $_sort[0], $_sort[1], $d['layout']['bbs3_num'], 1);
?>
<?php
$_NUM = db_num_rows($_RCD);
?>
<div class="fboard">
<?php
if (!$d['layout']['bbs3_namehide']) {
?>
<div class="title"><?php
echo $d['layout']['bbs3_name'];
?>
</div><?php
}
?>
$sort = $sort ? $sort : 'uid';
$orderby = $orderby ? $orderby : 'asc';
$recnum = $recnum && $recnum < 200 ? $recnum : 20;
$bbsque = 'mbruid=' . $my['uid'] . ' and site=' . $s;
if ($where && $keyword) {
if (strstr('[name][nic][id][ip]', $where)) {
$bbsque .= " and " . $where . "='" . $keyword . "'";
} else {
if ($where == 'term') {
$bbsque .= " and d_regis like '" . $keyword . "%'";
} else {
$bbsque .= getSearchSql($where, $keyword, $ikeyword, 'or');
}
}
}
$RCD = getDbArray($table['s_oneline'], $bbsque, '*', $sort, $orderby, $recnum, $p);
$NUM = getDbRows($table['s_oneline'], $bbsque);
$TPG = getTotalPage($NUM, $recnum);
?>
<div id="bbslist">
<div class="info">
<div class="article">
<?php
echo number_format($NUM);
?>
개(<?php
echo $p;
include_once $g['dir_module_skin'] . '_menu.php';
$type = $type ? $type : 'point';
$sort = $sort ? $sort : 'uid';
$orderby = $orderby ? $orderby : 'desc';
$recnum = $recnum && $recnum < 200 ? $recnum : 20;
$sqlque = 'my_mbruid=' . $my['uid'];
if ($price == '1') {
$sqlque .= ' and price > 0';
}
if ($price == '2') {
$sqlque .= ' and price < 0';
}
if ($where && $keyword) {
$sqlque .= getSearchSql($where, $keyword, $ikeyword, 'or');
}
$RCD = getDbArray($table['s_' . $type], $sqlque, '*', $sort, $orderby, $recnum, $p);
$NUM = getDbRows($table['s_' . $type], $sqlque);
$TPG = getTotalPage($NUM, $recnum);
?>
<div id="pointlist">
<div class="info">
<div class="article">
<span class="tx">
<a class="<?php
if ($type == 'point') {
?>
if ($_L['gid']) {
break;
}
}
?>
</select>
</td>
</tr>
<tr>
<td class="td1">파일첨부권한</td>
<td class="td2">
<select name="perm_upfile" class="select1">
<option value="0"> + 전체허용</option>
<option value="0">--------------------------------</option>
<?php
$_LEVEL = getDbArray($table['s_mbrlevel'], '', '*', 'uid', 'asc', 0, 1);
?>
<?php
while ($_L = db_fetch_array($_LEVEL)) {
?>
<option value="<?php
echo $_L['uid'];
?>
"<?php
if ($_L['uid'] == $d['comment']['perm_upfile']) {
?>
selected="selected"<?php
}
?>
>ㆍ<?php
echo $_L['name'];
$recnum = $recnum && $recnum < 200 ? $recnum : 20;
$type = $type ? $type : 'follower';
if ($type == 'follower') {
$sqlque = 'by_mbruid=' . $my['uid'];
if ($category) {
$sqlque .= " and category='" . $category . "'";
}
} elseif ($type == 'following') {
$sqlque = 'my_mbruid=' . $my['uid'];
} else {
$sqlque = 'my_mbruid=' . $my['uid'] . ' and rel=1';
}
if ($where && $keyword) {
$sqlque .= getSearchSql($where, $keyword, $ikeyword, 'or');
}
$RCD = getDbArray($table['s_friend'], $sqlque, '*', $sort, $orderby, $recnum, $p);
$NUM = getDbRows($table['s_friend'], $sqlque);
$TPG = getTotalPage($NUM, $recnum);
$_NUM = array();
$_NUM['follower'] = getDbRows($table['s_friend'], 'by_mbruid=' . $my['uid']);
$_NUM['following'] = getDbRows($table['s_friend'], 'my_mbruid=' . $my['uid']);
$_NUM['friend'] = getDbRows($table['s_friend'], 'my_mbruid=' . $my['uid'] . ' and rel=1');
?>
<div id="friendlist">
<div class="info">
<div class="article">
exit;
}
checkAdmin(0);
$fdset = array();
$fdset['config'] = array('version', 'themepc', 'pannellink', 'cache_flag', 'smtp_use', 'smtp_host', 'smtp_port', 'smtp_auth', 'smtp_ssl', 'smtp_user', 'smtp_pass', 'ftp_use', 'ftp_type', 'ftp_host', 'ftp_port', 'ftp_pasv', 'ftp_user', 'ftp_pass', 'ftp_rb', 'email', 'smtp', 'ftp', 'uninstall', 'dblclick', 'codeeidt', 'editor', 'syslang', 'sysmail', 'sysmodule');
$fdset['ssl'] = array('http_port', 'ssl_type', 'ssl_port', 'ssl_module', 'ssl_menu', 'ssl_page');
$fdset['security'] = array('secu_tags', 'secu_domain', 'secu_param');
//제거탭 출력 주의 알림
if (!$d['admin']['uninstall'] && $uninstall) {
$_message = _LANG('a5001', 'admin');
$_referer = $g['s'] . '/?r=' . $r . '&m=admin&module=admin';
putNotice($my['uid'], $m, 0, $_message, $_referer, '');
}
if ($act == 'config') {
if ($d['admin']['syslang'] != $syslang) {
$RCD = getDbArray($table['s_module'], '', '*', 'gid', 'asc', 0, 1);
while ($_R = db_fetch_array($RCD)) {
$new_modulename = $g['path_module'] . $_R['id'] . '/language/' . $syslang . '/name.module.txt';
getDbUpdate($table['s_module'], "name='" . ($syslang && is_file($new_modulename) ? implode('', file($new_modulename)) : getFolderName($g['path_module'] . $_R['id'])) . "'", "id='" . $_R['id'] . "'");
}
$panel_reload = true;
}
}
foreach ($fdset[$act] as $val) {
$d['admin'][$val] = str_replace("\n", '<br>', trim(${$val}));
}
$_tmpdfile = $g['dir_module'] . 'var/var.system.php';
$fp = fopen($_tmpdfile, 'w');
fwrite($fp, "<?php\n");
foreach ($d['admin'] as $key => $val) {
fwrite($fp, "\$d['admin']['" . $key . "'] = \"" . addslashes(stripslashes($val)) . "\";\n");
$d['mediaset'] = getArrayString($files);
foreach ($d['mediaset']['data'] as $_val) {
$U = getUidData($table['s_upload'], $_val);
if ($U['uid']) {
$S += $U['size'];
$N++;
}
}
}
$P = array();
if (!$_SESSION['upsescode']) {
$_SESSION['upsescode'] = str_replace('.', '', $g['time_start']);
}
$sescode = $_SESSION['upsescode'];
if ($sescode) {
$PHOTOS = getDbArray($table['s_upload'], "tmpcode='" . $sescode . "' and fileonly=1", '*', 'pid', 'asc', 0, 0);
while ($R = db_fetch_array($PHOTOS)) {
$P[] = $R;
$S += $R['size'];
$N++;
}
}
$d['mediaset']['limitnum'] = $d['mediaset']['maxnum_img'];
$d['mediaset']['limitsize'] = $d['mediaset']['maxsize_img'];
$d['mediaset']['limitsize'] = $d['mediaset']['limitsize'] * 1024 * 1024;
$LimitNum = $d['mediaset']['limitnum'] - $N;
$LimitSize = $d['mediaset']['limitsize'] - $S;
$gparamExp = explode('|', $gparam);
if ($tab == 'file_info') {
if (!$file_uid) {
$file_uid = $P[0]['uid'];
</div>
<div class="tr">
<?php
if ($d['layout']['bbs4']) {
?>
<?php
$_B = getUidData($table['bbslist'], $d['layout']['bbs4']);
?>
<?php
$_sort = explode(',', $d['layout']['sort4']);
?>
<?php
$_date = $d['layout']['bbs4_day'] != '' ? date('YmdHis', mktime(0, 0, 0, substr($date['today'], 4, 2), substr($date['today'], 6, 2) - $d['layout']['bbs4_day'], $date['year'])) : 0;
?>
<?php
$_RCD = getDbArray($table['bbsdata'], 'bbs=' . $d['layout']['bbs4'] . ' and display=1 and d_regis > ' . $_date, '*', $_sort[0], $_sort[1], $d['layout']['bbs4_num'], 1);
?>
<?php
$_R = db_fetch_array($_RCD);
?>
<div class="tt">
<div class="ts"><?php
echo $_B['name'];
?>
</div>
<div class="tmore"><a href="<?php
echo RW('m=bbs&bid=' . $_B['id']);
?>
">더보기</a></div>
<div class="clear"></div>
<img src="<?php
echo $g['img_core'];
?>
/_public/ico_q.gif" alt="도움말" title="도움말" class="hand" onclick="__layerShowHide('guide_permg','block','none');" />
</td>
<td class="td2">
<select name="_perm_g" class="select1" multiple="multiple" size="5">
<option value=""<?php
if (!$CINFO['perm_g']) {
?>
selected="selected"<?php
}
?>
>ㆍ차단안함</option>
<?php
$_SOSOK = getDbArray($table['s_mbrgroup'], '', '*', 'gid', 'asc', 0, 1);
?>
<?php
while ($_S = db_fetch_array($_SOSOK)) {
?>
<option value="<?php
echo $_S['uid'];
?>
"<?php
if (strstr($CINFO['perm_g'], '[' . $_S['uid'] . ']')) {
?>
selected="selected"<?php
}
?>
>ㆍ<?php
echo $_S['name'];
$resResort = getDbArray($table['bbsdata'], "bbsid='resort' AND (category = '수상비행기' OR category = '국내선지역')", "uid, subject, upload", "uid", "desc", "", "");
} else {
if ($R['category'] == "프랄린" || $R['category'] == "마헤" || $R['category'] == "라디그") {
$resResort = getDbArray($table['bbsdata'], "bbsid='resort' AND (category = '프랄린' OR category = '마헤' OR category = '라디그')", "uid, subject, upload", "uid", "desc", "", "");
} else {
if ($_GET[mod] == "login") {
$resResort = getDbArray($table['bbsdata'], "bbsid='resort' AND category = '칸쿤'", "uid, subject, upload", "uid", "desc", "", "");
} else {
if (!$uid && $uidX) {
$uid = $uidX;
$R = getUidData($table[$m . 'data'], $uid);
}
if ($bid == "resort") {
$resResort = getDbArray($table['bbsdata'], "bbsid='resort' AND category = '" . ($cat ? $cat : $R['category']) . "'", "uid, subject, upload", "uid", "desc", "", "");
} else {
$resResort = getDbArray($table['bbsdata'], "bbsid='resort'", "uid, subject, upload", "uid", "desc", "", "");
}
}
}
}
$rcdCount = mysql_num_rows($resResort);
$perCol = ceil($rcdCount / 4);
?>
<div class="list">
<ul class="resort">
<?php
for ($i = 1; $infoResort = db_fetch_array($resResort); $i++) {
?>
<?php
$uploadUid = substr($infoResort['upload'], 1, strpos($infoResort['upload'], "]") - 1);
$infoUpload = getDbData($table['s_upload'], "uid = " . $uploadUid, "url, folder, thumbname ");
$year1 = $year1 ? $year1 : substr($date['today'], 0, 4);
$month1 = $month1 ? $month1 : substr($date['today'], 4, 2);
$day1 = $day1 ? $day1 : 1;
//substr($date['today'],6,2);
$year2 = $year2 ? $year2 : substr($date['today'], 0, 4);
$month2 = $month2 ? $month2 : substr($date['today'], 4, 2);
$day2 = $day2 ? $day2 : substr($date['today'], 6, 2);
$sort = $sort ? $sort : 'uid';
$orderby = $orderby ? $orderby : 'desc';
$recnum = $recnum && $recnum < 200 ? $recnum : 20;
$sqlque = 'mbruid=' . $my['uid'] . ' and site=' . $s;
$sqlque = $sqlque . ' and d_regis > ' . $year1 . sprintf('%02d', $month1) . sprintf('%02d', $day1) . '000000 and d_regis < ' . $year2 . sprintf('%02d', $month2) . sprintf('%02d', $day2) . '240000';
if ($where && $keyword) {
$sqlque .= getSearchSql($where, $keyword, $ikeyword, 'or');
}
$RCD = getDbArray($table['s_referer'], $sqlque, '*', $sort, $orderby, $recnum, $p);
$NUM = getDbRows($table['s_referer'], $sqlque);
$TPG = getTotalPage($NUM, $recnum);
?>
<div id="loglist">
<form name="bbssearchf" action="<?php
echo $g['s'];
?>
/">
<input type="hidden" name="r" value="<?php
echo $r;
?>
}
include_once $g['dir_module'] . 'var/var.php';
include_once $g['path_module'] . 'upload/var/var.php';
if ($d['bbs']['commentdel']) {
if ($R['comment']) {
getLink('', '', '댓글이 있는 게시물은 삭제할 수 없습니다.', '');
}
}
if ($d['bbs']['replydel']) {
if (getDbRows($table[$m . 'data'], 'parent=' . $R['uid'])) {
getLink('', '', '답변글이 있는 게시물은 삭제할 수 없습니다.', '');
}
}
//댓글삭제
if ($R['comment']) {
$CCD = getDbArray($table['s_comment'], "parent='" . $m . $R['uid'] . "'", '*', 'uid', 'asc', 0, 0);
while ($_C = db_fetch_array($CCD)) {
if ($_C['upload']) {
$UPFILES = getArrayString($_C['upload']);
foreach ($UPFILES['data'] as $_val) {
$U = getUidData($table['s_upload'], $_val);
if ($U['uid']) {
getDbUpdate($table['s_numinfo'], 'upload=upload-1', "date='" . substr($U['d_regis'], 0, 8) . "' and site=" . $U['site']);
getDbDelete($table['s_upload'], 'uid=' . $U['uid']);
if ($U['url'] == $d['upload']['ftp_urlpath']) {
$FTP_CONNECT = ftp_connect($d['upload']['ftp_host'], $d['upload']['ftp_port']);
$FTP_CRESULT = ftp_login($FTP_CONNECT, $d['upload']['ftp_user'], $d['upload']['ftp_pass']);
if (!$FTP_CONNECT) {
getLink('', '', 'FTP서버 연결에 문제가 발생했습니다.', '');
}
if (!$FTP_CRESULT) {
?>
>저작자표시-동일조건변경허락 Creative Commons</option>
<option value="6"<?php
if ($_R['license'] == 6) {
?>
selected<?php
}
?>
>저작자표시-변경금지 Creative Commons</option>
</select>
</div>
<div class="form-group">
<label>Category</label>
<select name="category" class="selectpicker show-tick show-menu-arrow scrollMe" data-width="100%" data-style="btn btn-default" data-size="auto">
<?php
$_CT_RCD = getDbArray($table['s_uploadcat'], 'mbruid=' . $my['uid'] . " and type=2 and name<>'none' and name<>'trash'", '*', 'gid', 'asc', 0, 1);
?>
<option value="0"<?php
if ($_R['category'] == 0) {
?>
selected<?php
}
?>
>미분류</option>
<?php
while ($_CT = db_fetch_array($_CT_RCD)) {
?>
<option value="<?php
echo $_CT['uid'];
?>
"<?php
<?php
include_once $g['dir_module_skin'] . '_menu.php';
$sort = $sort ? $sort : 'gid';
$orderby = $orderby ? $orderby : 'asc';
$recnum = $recnum && $recnum < 200 ? $recnum : $d['search']['s_num2'];
$bbsque = 'site=' . $s . " and type=2 and ext='jpg' and d_regis > " . $d['search']['date'];
$bbsque .= getSearchSql('name|caption', $keyword, $ikeyword, 'or');
$RCD = getDbArray($table['s_upload'], $bbsque, '*', $sort, $orderby, $recnum, $p);
$NUM = getDbRows($table['s_upload'], $bbsque);
$TPG = getTotalPage($NUM, $recnum);
?>
<?php
if ($NUM) {
?>
<div id="s_image">
<div class="subtitle">
<div class="xleft">이미지(검색결과 <?php
echo number_format($NUM);
?>
개)</div>
<div class="xright"><a href="<?php
echo $g['url_reset'];
?>
">통합검색</a></div>
<div class="clear"></div>
</div>