// include include('lib/DB.html'); // DB °ü·Ã Ŭ·¡½º include include('lib/functions.html'); // ÇÁ·Î±×·¥ µ¶¸³ÀûÀÎ Basic ÇÔ¼ö include include('lib/bbs.html'); // ÇÁ·Î±×·¥ ÀÇÁ¸ÀûÀÎ ÇÔ¼ö include include('lib/email.html'); // ´äº¯ Email ¹ß¼ÛÀ» À§ÇÑ ÇÔ¼ö include // ¼Óµµ üũ $startProcessTime = getmicrotime(); // DB Table Set $document_table = 'square_document'; // °Ô½ÃÆÇÀÌ »ç¿ëÇÏ´Â DB Å×À̺í $file_table = 'square_file'; // ¾÷·ÎµåÈÀÏÀÇ Á¤º¸¸¦ °¡Áö°í ÀÖ´Â DB Å×À̺í $comment_table = 'square_comment'; // ¸àÆ®´Þ±â DB Å×À̺í // init $bid = ($bid) ? $bid : 1; // ±âº» °Ô½ÃÆÇ ¹øÈ£ if (file_exists("init/$bid.html")) include("init/$bid.html"); else goPrepage("$bid" . "¹ø °Ô½ÃÆÇÀÌ Á¸ÀçÇÏÁö ¾Ê½À´Ï´Ù. ÀÌÀü ÆäÀÌÁö·Î µ¹¾Æ°©´Ï´Ù."); // skin init if (file_exists("skin/$skin/init/init.html")) include("skin/$skin/init/init.html"); // SQL °ü·Ã ÄíŰ ¼³Á¤ if ($mode == 'order') { setcookie("cook_orderBy", $orderBy); // ¼ÒÆ® ¿À´õ Ç÷¡±× ¼³Á¤ $sortOrder = ($cook_sortOrder) ? '' : ' desc'; setcookie("cook_sortOrder", $sortOrder); $cook_orderBy = $orderBy; $cook_sortOrder = $sortOrder; } if ($mode == 'search') { // Äí۸¦ ±Á´Â´Ù. setcookie("cook_searchWhere", $searchWhere); setcookie("cook_searchWhat", $searchWhat); $cook_searchWhere = $searchWhere; $cook_searchWhat = $searchWhat; } if ($mode == 'list') { // Äí۸¦ »èÁ¦ÇÑ´Ù. setcookie("cook_searchWhere", '', time() - 3600); setcookie("cook_searchWhat", '', time() - 3600); setcookie("cook_orderBy", '', time() - 3600); setcookie("cook_sortOrder", '', time() - 3600); $cook_searchWhere = ''; $cook_searchWhat = ''; $cook_orderBy = ''; $cook_sortOrder = ''; } if ($mode != 'list') { // ÄíŰ·Î º¯¼ö¸¦ º¸Á¸ÇÑ´Ù. $searchWhere = $cook_searchWhere; $searchWhat = $cook_searchWhat; $orderBy = $cook_orderBy; $sortOrder = $cook_sortOrder; } // SQL Á¤ÀÇ $basicSql = "select uid, id, writer, category, email, subject, indent, wdate, count from $document_table"; $countSql = "select count(*) from $document_table"; $whereSql = " where bid = $bid"; if ($searchWhere == 'writer' || $searchWhere == 'all') { $searchSql .= ($searchSql) ? ' or ' : ''; $searchSql .= "writer like '%$searchWhat%'"; } if ($searchWhere == 'contents' || $searchWhere == 'all') { $searchSql .= ($searchSql) ? ' or ' : ''; $searchSql .= "contents like '%$searchWhat%'"; } if ($searchWhere == 'subject' || $searchWhere == 'all') { $searchSql .= ($searchSql) ? ' or ' : ''; $searchSql .= "subject like '%$searchWhat%'"; } $whereSql .= ($searchSql) ? " and ($searchSql)" : ''; $orderSql = ($orderBy) ? " order by $orderBy": " order by id desc"; $orderSql .= $sortOrder; // desc? asc? $basicSql = $basicSql . $whereSql . $orderSql; $countSql = $countSql . $whereSql; // DB ¹× ÄíŰ °ü·Ã ÇÁ·Î¼¼½º if ($mode == 'adminAuthen') { include('bin/adminAuthen.html'); } if ($mode == 'adminLogout') { include('bin/adminLogout.html'); } if ($mode == 'insert') { include('bin/insert.html'); } if ($mode == 'update') { include('bin/update.html'); } if ($mode == 'answer') { include('bin/answer.html'); } if ($mode == 'deleteFile') { include('bin/deleteFile.html'); } if ($mode == 'delete') { include('bin/delete.html'); } if ($mode == 'download') { include('bin/download.html'); exit(); } if ($mode == 'insertComment') { include('bin/insertComment.html'); } if ($mode == 'deleteComment') { include('bin/deleteComment.html'); } ?>