Example #1
0
        <div class="subject">
          <?php echo $v['check']?$v['check']:''?>
          <?php echo $v['category']?'<span class="category">'.$v['category'].'</span>':''; //분류출력?>
          <?php if($v['subject']['href']){?><a href="<?php echo $v['subject']['href']?>"><?php }?>
          <?php echo $v['subject']['text']?>
          <?php if($v['subject']['href']){?></a><?php }?>
        </div>
        <div class="datetime">
          <?php echo $v['datetime']?>
        </div>
      </li>
    <?php }?>
    <li class="last_line"></li>
  </ul>
</div>

<!-- 페이징 -->
<?php echo Paging::Inst(
	)->rows($rows*$cols
	)->tot($this->Sql('list_cnt')
	)->html(
)?>

<!-- 검색 및 버튼 -->
<div id="search_line">
  <div class="buttons"><?php include $this->path_view('buttons.php')?></div>
  <?php echo Search::Inst()->Html()?>
</div>


Example #2
0
<?php

if (!defined("__MAGIC__")) {
    exit;
}
$tbn = $this->TBN();
$sql = "\n\tSELECT count(mb_no) as cnt\n\tFROM {$tbn}\n\tWHERE mb_passwd<>''\n";
$sql .= Search::Inst()->Sql(array('mb_nick', 'mb_id'));
$cnt = DB::Get()->sql_fetch($sql);
$sql_result = $cnt['cnt'] ? $cnt['cnt'] : 0;
Example #3
0
<?php

if (!defined("__MAGIC__")) {
    exit;
}
$tbn = $this->TBN();
$bo_no = $this->bo_no;
$category = urldecode(GV::Category());
// 개수 카운트
$sql = "\n\tSELECT count(wr_no) as cnt \n\tFROM `{$tbn}` \n\tWHERE bo_no={$bo_no} AND wr_parent_no=0\n";
// 월별보기 저장소 쿼리
$archive = trim($_GET['archive']);
if ($archive) {
    $archive = explode(' ', $archive);
    $archive[0] = preg_replace('/[^0-9]/', '', $archive[0]);
    $archive[1] = preg_replace('/[^0-9]/', '', $archive[1]);
    $sql .= " AND DATE_FORMAT(wr_datetime,'%Y%m')=DATE_FORMAT('{$archive[0]}-{$archive[1]}-01','%Y%m') ";
}
$sql .= Search::Inst()->Sql(array('wr_subject', 'wr_content'));
$ca1 = trim($_GET['ca1']);
$ca2 = trim($_GET['ca2']);
if ($ca1) {
    $sql .= " AND wr_category LIKE '{$ca1}%' ";
}
if ($ca2) {
    $sql .= " AND wr_category LIKE '%{$ca2}' ";
}
$cnt = DB::Get()->sql_fetch($sql);
$sql_result = $cnt['cnt'] ? $cnt['cnt'] : 0;
Example #4
0
    echo Layout::Inst('admin')->path_img('btn_table_admin_modify_icon.gif');
    ?>
" alt="수정"/></a>
    <a href="<?php 
    echo $this->Link('unregist', $v['mb_no']);
    ?>
" onclick="return confirm('회원을 탈퇴 시키겠습니까?\n한번 탈퇴한 회원은 복구 할수 없습니다.\n신중히 생각해주세요.')"><img src="<?php 
    echo Layout::Inst('admin')->path_img('btn_table_admin_delete_icon.gif');
    ?>
" alt="탈퇴"/></a>
	</div></td>
</tr>
<?php 
}
?>
 
</tbody>
</table>
</form>

<!-- 검색 -->
<?php 
echo Search::Inst()->Html();
?>

<div class="center">
<?php 
echo Paging::Inst()->rows($this->Config('rows'))->tot($this->Sql('list_cnt'))->html();
?>
</div>