<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>
<?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;
<?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;
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>