function facebookSocialPlugins($target, $mother) { global $database, $suri, $blog, $configVal; $data = Misc::fetchConfigVal($configVal); $output = ''; $directive = array('archive', 'category', 'guestbook', 'imageResizer', 'link', 'login', 'logout', 'pannels', 'protected', 'search', 'tag', 'trackback', 'rss', 'atom', 'ientry', 'sync', 'm', 'commentcomment'); if (in_array(str_replace('/', '', $suri['directive']), $directive)) { return $target; } $permalink = $blog['useSloganOnPost'] ? 'entry/' . POD::queryCell("SELECT `slogan` FROM {$database['prefix']}Entries WHERE `id`={$mother} LIMIT 1") : $mother; $permalink = urlencode(getBlogURL() . '/' . $permalink); $title = urlencode(POD::queryCell("SELECT `title` FROM {$database['prefix']}Entries WHERE `id`={$mother} LIMIT 1")); $output = '<div style="margin-top:1em;width:auto;height:auto;clear:both;">'; $__width = !isset($data['content_width']) || (int) $data['content_width'] <= 0 ? 520 : $data['content_width']; if ($data['like_button']) { $output .= '<div class="fb-like" data-href="' . $permalink . '" data-send="true" data-width="' . $__width . '" data-show-faces="true"></div>'; } if ($data['comments']) { $output .= '<div class="fb-comments" data-href="' . $permalink . '" data-num-posts="2" data-width="' . $__width . '"></div>'; } if ($data['share']) { $output .= '<div class="fb-send" data-href="' . $permalink . '"></div>'; } $output .= '</div><br />'; return $target . $output; }
function __getPluginConfig() { global $database; if (defined("__TISTORY__") == true) { global $__globalCache_data; if (isset($__globalCache_data['pluginSettings']) && array_key_exists($this->pluginName, $__globalCache_data['pluginSettings'])) { return $__globalCache_data['pluginSettings'][$this->pluginName]; } } $configXml = POD::queryCell("SELECT settings FROM {$database['prefix']}Plugins WHERE blogid = {$this->blogid} AND name = '{$this->pluginName}'"); $t = Setting::fetchConfigVal($configXml); return false == is_array($t) ? array() : $t; }
function getEntryFormatterInfo($id) { global $database; static $info; if (!Validator::id($id)) { return NULL; } else { if (!isset($info[$id])) { $query = sprintf('SELECT contentformatter FROM %sEntries WHERE id = %d', $database['prefix'], $id); $info[$id] = POD::queryCell($query); } } return $info[$id]; }
function CountAndShow($target, $mother) { global $database, $service, $suri, $blogid; $now_timestamp = time(); $output = ''; if ($suri['directive'] != "/rss" && $suri['directive'] != "/m" && $suri['directive'] != "/i/entry" && $suri['directive'] != "/atom" && $suri['directive'] != "/sync") { if (SaveReadToCookie($blogid, $mother)) { if (!POD::queryCount("UPDATE {$database['prefix']}EntryReadCount SET readcounts = readcounts + 1, lastaccess = {$now_timestamp} WHERE blogid={$blogid} AND id={$mother}")) { POD::query("INSERT INTO {$database['prefix']}EntryReadCount (blogid, id, readcounts, lastaccess) VALUES ({$blogid}, {$mother}, 1, {$now_timestamp})"); } } $readcount = POD::queryCell("SELECT readcounts FROM {$database['prefix']}EntryReadCount WHERE blogid={$blogid} AND id={$mother}"); $output .= "<span class=\"c_cnt\">views: {$readcount} times </span><br />"; } return $output . $target; }
function flushEntry($entryId = null) { global $database; if (empty($entryId)) { $entryId = ''; } else { $entryId = $entryId . '\\_'; } $cache = pageCache::getInstance(); $Entries = POD::queryColumn("SELECT name\n\t\t\tFROM {$database['prefix']}PageCacheLog\n\t\t\tWHERE blogid = " . getBlogId() . "\n\t\t\tAND (name like 'entry\\_" . $entryId . "%' OR name = 'commentRSS_" . $entryId . "')"); CacheControl::purgeItems($Entries); if (!empty($entryId)) { $entry = POD::queryCell("SELECT userid, category FROM {$database['prefix']}Entries\n\t\t\t\tWHERE blogid = " . getBlogId() . " AND id = {$entryId}"); if (!empty($entry)) { CacheControl::flushAuthor($entry['userid']); CacheControl::flushCategory($entry['category']); CacheControl::flushDBCache(); } } else { CacheControl::flushAuthor(); CacheControl::flushCategory(); CacheControl::flushDBCache(); } unset($cache); return true; }
} if (!empty($diff)) { ?> <script type="text/javascript"> //<![CDATA[ <?php echo $diff; ?> //]]> </script> <?php flush(); } } setProgress(0, _t('교정 대상을 확인하고 있습니다.')); $items = 4 + POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}Comments WHERE blogid = {$blogid}") + POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}RemoteResponses WHERE blogid = {$blogid}"); set_time_limit(0); $item = 0; $corrected = 0; $post = new Post(); setProgress($item++ / $items * 100, _t('글의 댓글 정보를 다시 계산해서 저장합니다.')); $post->updateComments(); setProgress($item++ / $items * 100, _t('글의 걸린글 정보를 다시 계산해서 저장합니다.')); $post->updateRemoteResponses(); setProgress($item++ / $items * 100, _t('분류의 글 정보를 다시 계산해서 저장합니다.')); updateEntriesOfCategory($blogid); setProgress($item++ / $items * 100, _t('태그와 태그 관계 정보를 다시 계산해서 저장합니다.')); $post->correctTagsAll(); if ($result = POD::query("SELECT id, name, parent, homepage, comment, entry, isfiltered FROM {$database['prefix']}Comments WHERE blogid = {$blogid} and isfiltered = 0")) { while ($comment = POD::fetch($result)) { setProgress($item++ / $items * 100, _t('댓글과 방명록 데이터를 교정하고 있습니다.'));
function checkStep($step, $check = true) { global $root, $path; $error = 0; if ($step == 1) { if ($check) { return true; } } else { if ($step == 2) { if ($check) { if (!empty($_POST['mode'])) { switch ($_POST['mode']) { case 'install': case 'setup': case 'uninstall': return true; } } } ?> <input type="hidden" name="step" value="2" /> <input id="setupMode" type="hidden" name="mode" value="" /> <div id="inner"> <h2><span class="step"><?php echo _f('%1단계', 2); ?> </span> : <?php echo _t('작업 유형을 선택해 주십시오.'); ?> </h2> <div style="text-align:center"> <div style="width:100%; padding:40px 0px 40px 0px"> <div style="margin:20px;"><input type="button" value="<?php echo _t('새로운 텍스트큐브를 설정합니다'); ?> " style="width:100%; height:40px; font-size:14px" onclick="next('install');return false;" /></div> <div style="margin:20px;"><input type="button" value="<?php echo _t('텍스트큐브를 다시 설정합니다'); ?> " style="width:100%; height:40px; font-size:14px" onclick="next('setup');return false;" /></div> <div style="margin:20px;"><input type="button" value="<?php echo _t('텍스트큐브 테이블을 삭제합니다'); ?> " style="width:100%; height:40px; font-size:14px" onclick="next('uninstall');return false;" /></div> </div> </div> </div> <?php } else { if ($step == 3) { if ($check) { switch ($_POST['mode']) { case 'install': case 'setup': if (!empty($_POST['dbServer']) && !empty($_POST['dbName']) && !empty($_POST['dbUser']) && isset($_POST['dbPassword']) && isset($_POST['dbPrefix'])) { $dbTemp = array('server' => $_POST['dbServer'], 'username' => $_POST['dbUser'], 'password' => $_POST['dbPassword'], 'port' => $_POST['dbPort']); if (!empty($_POST['dbName'])) { $dbTemp['database'] = $_POST['dbName']; } global $dbms; $dbms = $_POST['dbms']; if (!POD::bind($dbTemp)) { $error = 1; } else { if (!empty($_POST['dbPrefix']) && !preg_match('/^[a-zA-Z0-9_]+$/', $_POST['dbPrefix'])) { $error = 3; } else { return true; } } } break; case 'uninstall': if (!empty($_POST['dbServer']) && !empty($_POST['dbName']) && !empty($_POST['dbUser']) && isset($_POST['dbPassword']) && !empty($_POST['dbPort'])) { $dbTemp = array('server' => $_POST['dbServer'], 'username' => $_POST['dbUser'], 'password' => $_POST['dbPassword'], 'port' => $_POST['dbPort']); if (!empty($_POST['dbName'])) { $dbTemp['database'] = $_POST['dbName']; } global $dbms; $dbms = $_POST['dbms']; if (!POD::bind($dbTemp)) { $error = 1; } else { return true; } } break; } } ?> <input type="hidden" name="step" value="3" /> <input type="hidden" name="mode" value="<?php echo $_POST['mode']; ?> " /> <script type="text/javascript"> //<![CDATA[ function suggestDefaultPort(db) { switch(db) { case 'MySQLi': default: port = 3306; break; case 'Cubrid': port = 30000; break; case 'PostgreSQL': port = 5432; break; default: port = ''; break; } document.getElementById('dbPort').value = port; document.getElementById('dbms'+db).checked = checked; return true; } //]]> </script> <div id="inner"> <h2><span class="step"><?php echo _f('%1단계', 3); ?> </span> : <?php echo _t('작업 정보를 입력해 주십시오.'); ?> </h2> <div id="userinput"> <table class="inputs"> <tr> <th><?php echo _t('데이터베이스 관리 시스템'); ?> :</th> <td> <?php $dbmsSupport = array(); if (function_exists('mysqli_connect')) { array_push($dbmsSupport, 'MySQLi'); } if (function_exists('pg_connect')) { array_push($dbmsSupport, 'PostgreSQL'); } if (class_exists('SQLite3')) { array_push($dbmsSupport, 'SQLite3'); } if (function_exists('cubrid_connect')) { array_push($dbmsSupport, 'Cubrid'); } foreach ($dbmsSupport as $dbms) { ?> <input type="radio" id="dbms<?php echo $dbms; ?> " name="dbms" value="<?php echo $dbms; ?> " <?php echo isset($_POST['dbms']) && $_POST['dbms'] == $dbms || !isset($_POST['dbms']) && $dbms == $dbmsSupport[0] ? 'checked' : ''; ?> onclick="suggestDefaultPort('<?php echo $dbms; ?> ');return false;" /> <?php echo $dbms; } ?> </td> </tr> <tr> <th><?php echo _t('데이터베이스 서버'); ?> :</th> <td> <input type="text" name="dbServer" value="<?php echo isset($_POST['dbServer']) ? $_POST['dbServer'] : 'localhost'; ?> " class="input<?php echo $check && (empty($_POST['dbServer']) || $error == 1) ? ' input_error' : ''; ?> " /> </td> </tr> <tr> <th><?php echo _t('데이터베이스 포트'); ?> :</th> <td> <input type="text" id="dbPort" name="dbPort" value="<?php echo isset($_POST['dbPort']) ? $_POST['dbPort'] : '3306'; ?> " class="input<?php echo $check && (empty($_POST['dbPort']) || $error == 1) ? ' input_error' : ''; ?> " /> </td> </tr> <tr> <th><?php echo _t('데이터베이스 이름'); ?> :</th> <td> <input type="text" name="dbName" value="<?php echo isset($_POST['dbName']) ? $_POST['dbName'] : NULL; ?> " class="input<?php echo $check && (empty($_POST['dbName']) || $error == 2) ? ' input_error' : ''; ?> " /> </td> </tr> <tr> <th><?php echo _t('데이터베이스 사용자명'); ?> :</th> <td> <input type="text" name="dbUser" value="<?php echo isset($_POST['dbUser']) ? $_POST['dbUser'] : ''; ?> " class="input<?php echo $check && (empty($_POST['dbUser']) || $error) ? ' input_error' : ''; ?> " /> </td> </tr> <tr> <th><?php echo _t('데이터베이스 암호'); ?> :</th> <td> <input type="password" name="dbPassword" value="<?php echo isset($_POST['dbPassword']) ? htmlspecialchars($_POST['dbPassword']) : ''; ?> " class="input<?php echo $check && $error == 1 ? ' input_error' : ''; ?> " /> </td> </tr> <?php switch ($_POST['mode']) { case 'install': case 'setup': ?> <tr> <th><?php echo _t('테이블 식별자'); ?> :</th> <td> <input type="text" name="dbPrefix" value="<?php echo isset($_POST['dbPrefix']) ? $_POST['dbPrefix'] : 'tc_'; ?> " class="input <?php echo $check && $error == 3 ? ' input_error' : ''; ?> " /> </td> </tr> <?php break; case 'uninstall': break; } ?> </table> </div> <div id="content"> <ol> <li><?php echo _t('데이터베이스가 해당 호스트에 먼저 생성되어 있어야 합니다.'); ?> </li> <li><?php echo _t('테이블식별자는 텍스트큐브가 사용하는 테이블이름 앞에 붙는 문자열입니다. 데이터 베이스내에 다른 어플리케이션이 사용하는 테이블이 있을 경우 구별하기 위해 사용합니다'); ?> <?php echo _t('테이블식별자를 입력하지 않을 경우 자동으로 tc_ 를 사용합니다.'); ?> </li> </ol> </div> <div id="warning"><?php if ($error == 1) { echo _t('데이터베이스 서버에 연결할 수 없습니다. 정보를 다시 입력해 주십시오.'); } else { if ($error == 2) { echo _t('데이터베이스를 사용할 수가 없습니다. 정보를 다시 입력해 주십시오.'); } else { if ($error == 3) { echo _t('테이블 식별자가 올바르지 않습니다. 다시 입력해 주십시오.'); } else { if ($error == 6) { echo _t('데이터베이스에 연결할 수 없습니다.'); } else { if ($error == 7) { echo _t('데이터베이스에 접근할 수 없습니다.'); } else { if ($error == 8) { echo _t('새로운 테이블 식별자가 올바르지 않습니다. 다시 입력해 주십시오.'); } else { if ($check) { echo _t('표시된 정보가 부족합니다.'); } else { echo ' '; } } } } } } } ?> </div> <div id="navigation"> <a href="#" onclick="window.history.back()" title="<?php echo _t('이전'); ?> "><img src="./resources/style/setup/image/icon_prev.gif" width="74" height="24" alt="<?php echo _t('이전'); ?> " /></a> <a href="#" onclick="next(); return false;" title="<?php echo _t('다음'); ?> "><img src="./resources/style/setup/image/icon_next.gif" width="74" height="24" alt="<?php echo _t('다음'); ?> " /></a> </div> </div> <?php } else { if ($step == 4 || $step == 33) { if ($check) { if ($_POST['mode'] == 'uninstall') { if (empty($_POST['target'])) { checkStep(2, false); return false; } else { checkStep(205, false); return false; } } if (!empty($_POST['checked']) && $_POST['checked'] == 'yes') { return true; } } if ($_POST['mode'] == 'uninstall') { return checkStep(204, false); } ?> <input type="hidden" name="step" value="4" /> <input type="hidden" name="mode" value="<?php echo $_POST['mode']; ?> " /> <input type="hidden" name="dbms" value="<?php echo isset($_POST['dbms']) ? $_POST['dbms'] : ''; ?> " /> <input type="hidden" name="dbServer" value="<?php echo isset($_POST['dbServer']) ? $_POST['dbServer'] : ''; ?> " /> <input type="hidden" name="dbName" value="<?php echo isset($_POST['dbName']) ? $_POST['dbName'] : ''; ?> " /> <input type="hidden" name="dbPort" value="<?php echo isset($_POST['dbPort']) ? $_POST['dbPort'] : ''; ?> " /> <input type="hidden" name="dbUser" value="<?php echo isset($_POST['dbUser']) ? $_POST['dbUser'] : ''; ?> " /> <input type="hidden" name="dbPassword" value="<?php echo isset($_POST['dbPassword']) ? htmlspecialchars($_POST['dbPassword']) : ''; ?> " /> <input type="hidden" name="dbPrefix" value="<?php echo isset($_POST['dbPrefix']) ? $_POST['dbPrefix'] : ''; ?> " /> <input type="hidden" name="disableRewrite" value="<?php echo isset($_POST['disableRewrite']) ? $_POST['disableRewrite'] : ''; ?> " /> <div id="inner"> <h2><span class="step"><?php echo _f('%1단계', 4); ?> </span> : <?php echo _t('설치 요구 사항을 확인하고 있습니다.'); ?> </h2> <div id="content-box"> <h3><?php echo _t('환경'); ?> </h3> <ul> <li><?php echo _t('하드웨어'); ?> : <?php echo @exec('uname -mp'); ?> </li> <li><?php echo _t('운영체제'); ?> : <?php echo @exec('uname -sir'); ?> </li> <li><?php echo _t('웹서버'); ?> : <?php echo $_SERVER['SERVER_SOFTWARE']; ?> <?php echo isset($_SERVER['SERVER_SIGNATURE']) ? $_SERVER['SERVER_SIGNATURE'] : '(no signature)'; ?> </li> <li><?php echo _t('PHP 버전'); ?> : <?php echo phpversion(); ?> </li> <li><?php echo _t('데이터베이스 종류'); ?> : <?php echo POD::dbms(); ?> </li> <li><?php echo _f('%1 버전', POD::dbms()); ?> : <?php echo POD::version(); ?> </li> </ul> <h3>PHP</h3> <ul> <?php $functions = "\naddslashes\narray_flip\narray_key_exists\narray_pop\narray_push\narray_shift\narray_slice\nbase64_encode\nceil\ncheckdate\nclosedir\ncopy\ncount\ndechex\ndir\nexplode\nfclose\nfeof\nfgets\nfile_exists\nfile_get_contents\nfilesize\nfopen\nfputs\nfread\nfsockopen\nfunction_exists\nfwrite\nget_magic_quotes_gpc\ngetimagesize\ngmdate\ngmmktime\ngmstrftime\nheader\nhtml_entity_decode\nhtmlspecialchars\nimplode\nini_set\nintval\nis_dir\nis_file\nis_null\nis_numeric\nis_writable\nksort\nltrim\nmax\nmd5\nmicrotime\nmin\nmkdir\nmktime\nmove_uploaded_file\nnl2br\nnumber_format\nob_end_clean\nob_get_contents\nob_start\nopendir\nord\nparse_url\npreg_match\npreg_replace\nrand\nrawurlencode\nreaddir\nrmdir\nrtrim\nsession_cache_expire\nsession_destroy\nsession_id\nsession_name\nsession_set_cookie_params\nsession_set_save_handler\nsession_start\nsetcookie\nsizeof\nsprintf\nstr_replace\nstrftime\nstripslashes\nstrlen\nstrncasecmp\nstrncmp\nstrpos\nstrrev\nstrtolower\nstrval\nsubstr\nsubstr_count\nsubstr_replace\ntime\ntrim\nunlink\nurlencode\nxml_get_error_code\nxml_parse\nxml_parser_create\nxml_parser_free\nxml_parser_set_option\nxml_set_character_data_handler\nxml_set_default_handler\nxml_set_element_handler\nxml_set_object\n"; $required = array(); foreach (explode("\n", str_replace("\r", '', trim($functions))) as $function) { if (!function_exists($function)) { array_push($required, $function); } } if (version_compare(PHP_VERSION, '5.4.0') === -1 && (!isset($service['forceinstall']) || $service['forceinstall'] == false)) { $error = 4; ?> <span style="color:red"><?php echo _f('PHP 버전이 낮습니다. 설치를 위해서는 최소한 %1 이상의 버전이 필요합니다.', '5.4.0'); ?> </span> <?php } else { if (count($required) == 0) { ?> <li>OK</li> <?php } else { $error = 4; ?> <span style="color:red"><?php echo _t('함수가 설치되어야 합니다.'); ?> </span> <?php foreach ($required as $function) { ?> <li style="color:red"><?php echo $function; ?> </li> <?php } } } ?> </ul> <h3><?php echo POD::dbms(); ?> </h3> <ul> <?php if (POD::charset() == 'utf8') { echo '<li>Character Set: OK</li>'; } else { echo '<li style="color:navy">Character Set: ', _t('UTF8 미지원 (경고: 한글 지원이 불완전할 수 있습니다.)'), '</li>'; } if (POD::query("CREATE TABLE {$_POST['dbPrefix']}Setup (a INT NOT NULL)")) { POD::query("DROP TABLE {$_POST['dbPrefix']}Setup"); echo '<li>', _t('테이블 생성 권한'), ': OK</li>'; } else { $error = 6; echo '<li style="color:red">', _t('테이블 생성 권한'), ': ', _t('없음'), '</li>'; } ?> </ul> <?php $tables = array(); if ($result = POD::tableList()) { foreach ($result as $table) { if (strncmp($table, $_POST['dbPrefix'], strlen($_POST['dbPrefix']))) { continue; } switch (strtolower(substr($table, strlen($_POST['dbPrefix'])))) { case 'attachments': case 'blogsettings': case 'blogstatistics': case 'categories': case 'comments': case 'commentsnotified': case 'commentsnotifiedqueue': case 'commentsnotifiedsiteinfo': case 'dailystatistics': case 'entries': case 'entriesarchive': case 'feedgrouprelations': case 'feedgroups': case 'feeditems': case 'feedreads': case 'feedsettings': case 'feedstarred': case 'feeds': case 'filters': case 'linkcategories': case 'links': case 'openidusers': case 'pagecachelog': case 'plugins': case 'refererlogs': case 'refererstatistics': case 'reservedwords': case 'servicesetting': case 'sessionvisits': case 'sessions': case 'skinsettings': case 'tagrelations': case 'tags': case 'teamblog': case 'trackbacklogs': case 'trackbacks': case 'usersettings': case 'users': case 'xmlrpcpingsettings': $tables[count($tables)] = $table; break; } } } switch ($_POST['mode']) { case 'install': echo '<h3>', _t('새 데이터베이스 테이블'), '</h3>'; if (count($tables) == 0) { echo '<ul><li>OK</li></ul>'; } else { $error = 7; echo '<ul style="color:red">', _t('테이블이 이미 존재합니다.'); foreach ($tables as $table) { echo '<li>', $table, '</li>'; } echo '</ul>'; } break; case 'setup': echo '<h3>', _t('데이터베이스 테이블 확인'), '</h3>'; if (count($tables) < 40 && count($tables) > 35 || count($tables) == 35 && !in_array('Filters', $tables)) { echo '<ul><li>OK</li></ul>'; } else { $error = 7; echo '<ul style="color:red">', _t('테이블이 존재하지 않습니다.'); foreach ($tables as $table) { echo '<li>', $table, '</li>'; } echo '</ul>'; } } ?> <h3><?php echo _t('파일 시스템 권한'); ?> </h3> <ul> <?php $commands = array(); $filename = $root . '/.htaccess'; if (file_exists($filename)) { if (is_writable($filename)) { if (filesize($filename)) { echo '<li style="color:navy">', _f('설정 파일: OK (경고: "%1" 파일을 덮어 쓰게 됩니다.)', $filename), '</li>'; } else { echo '<li>', _t('웹 설정 파일'), ': OK</li>'; } } else { $error = 8; echo '<li style="color:red">', _t('웹 설정 파일'), ': ', _f('"%1"에 접근할 수 없습니다. 퍼미션을 %2(으)로 수정해 주십시오.', $filename, '0666'), '</li>'; array_push($commands, 'chmod 0666 ' . $filename); } } else { if (is_writable($root)) { echo '<li>', _t('웹 설정 파일'), ': OK</li>'; } else { $error = 9; echo '<li style="color:red">', _t('웹 설정 파일'), ': ', _f('"%1"에 %2 파일을 생성할 수 없습니다. "%1"의 퍼미션을 %3(으)로 수정해 주십시오.', $root, '.htaccess', '0777'), '</li>'; array_push($commands, 'chmod 0777 ' . $root); } } $filename = $root . '/config.php'; if (file_exists($filename)) { if (is_writable($filename)) { if (filesize($filename)) { echo '<li style="color:navy">', _f('설정 파일: OK (경고: "%1" 파일을 덮어 쓰게 됩니다.)', $filename), '</li>'; } else { echo '<li>', _t('설정 파일'), ': OK</li>'; } } else { $error = 10; echo '<li style="color:red">', _t('설정 파일'), ': ', _f('"%1"에 접근할 수 없습니다. 퍼미션을 %2(으)로 수정해 주십시오.', $filename, '0666'), '</li>'; array_push($commands, 'chmod 0666 ' . $filename); } } else { if (is_writable($root)) { echo '<li>', _t('설정 파일'), ': OK</li>'; } else { $error = 11; echo '<li style="color:red">', _t('설정 파일'), ': ', _f('"%1"에 %2 파일을 생성할 수 없습니다. "%1"의 퍼미션을 %3(으)로 수정해 주십시오.', $root, 'config.php', '0777'), '</li>'; array_push($commands, 'chmod 0777 ' . $root); } } $filename = $root . '/user'; if (file_exists($filename)) { if (is_dir($filename) && is_writable($filename)) { echo '<li>', _t('사용자 데이터 디렉토리'), ': OK</li>'; } else { $error = 12; echo '<li style="color:red">', _t('사용자 데이터 디렉토리'), ': ', _f('"%1"에 접근할 수 없습니다. 퍼미션을 %2(으)로 수정해 주십시오.', $filename, '0777'), '</li>'; array_push($commands, 'chmod 0777 ' . $filename); } } else { if (mkdir($filename)) { @chmod($filename, 0777); echo '<li>', _t('사용자 데이터 디렉토리'), ': OK</li>'; } else { $error = 13; echo '<li style="color:red">', _t('사용자 데이터 디렉토리'), ': ', _f('"%1"에 %2 디렉토리를 생성할 수 없습니다. "%1"의 퍼미션을 %3(으)로 수정해 주십시오.', $root, 'user', '0777'), '</li>'; array_push($commands, 'chmod 0777 ' . $root); } } $filename = $root . '/user/attach'; if (file_exists($filename)) { if (is_dir($filename) && is_writable($filename)) { echo '<li>', _t('첨부 디렉토리'), ': OK</li>'; } else { $error = 12; echo '<li style="color:red">', _t('첨부 디렉토리'), ': ', _f('"%1"에 접근할 수 없습니다. 퍼미션을 %2(으)로 수정해 주십시오.', $filename, '0777'), '</li>'; array_push($commands, 'chmod 0777 ' . $filename); } } else { if (mkdir($filename)) { @chmod($filename, 0777); echo '<li>', _t('첨부 디렉토리'), ': OK</li>'; } else { $error = 13; echo '<li style="color:red">', _t('첨부 디렉토리'), ': ', _f('"%1"에 %2 디렉토리를 생성할 수 없습니다. "%1"의 퍼미션을 %3(으)로 수정해 주십시오.', $root, 'attach', '0777'), '</li>'; array_push($commands, 'chmod 0777 ' . $root); } } $filename = $root . '/user/cache'; if (is_dir($filename)) { if (is_writable($filename)) { echo '<li>', _t('캐시 디렉토리'), ': OK</li>'; } else { $error = 12; echo '<li style="color:red">', _t('캐시 디렉토리'), ': ', _f('"%1"에 접근할 수 없습니다. 퍼미션을 %2(으)로 수정해 주십시오.', $filename, '0777'), '</li>'; array_push($commands, 'chmod 0777 ' . $filename); } } else { if (mkdir($filename)) { @chmod($filename, 0777); echo '<li>', _t('캐시 디렉토리'), ': OK</li>'; } else { $error = 13; echo '<li style="color:red">', _t('캐시 디렉토리'), ': ', _f('"%1"에 %2 디렉토리를 생성할 수 없습니다. "%1"의 퍼미션을 %3(으)로 수정해 주십시오.', $root, 'cache', '0777'), '</li>'; array_push($commands, 'chmod 0777 ' . $root); } } /* $filename = $root . '/remote'; if (is_dir($filename)) { if (is_writable($filename)) echo '<li>', _t('원격 설치 디렉토리'), ': OK</li>'; else { $error = 12; echo '<li style="color:red">', _t('원격 설치 디렉토리'), ': ', _f('"%1"에 접근할 수 없습니다. 퍼미션을 %2(으)로 수정해 주십시오.', $filename, '0777'), '</li>'; } } else if (mkdir($filename)) { @chmod($filename, 0777); echo '<li>', _t('원격 설치 디렉토리'), ': OK</li>'; } else { $error = 13; echo '<li style="color:red">', _t('원격 설치 디렉토리'), ': ', _f('"%1"에 %2 디렉토리를 생성할 수 없습니다. "%1"의 퍼미션을 %3(으)로 수정해 주십시오.', $root, 'cache', '0777'), '</li>'; }*/ $filename = $root . '/user/skin/blog/customize'; if (is_dir($filename)) { if (is_writable($filename)) { echo '<li>', _t('스킨 디렉토리'), ': OK</li>'; } else { $error = 14; echo '<li style="color:red">', _t('스킨 디렉토리'), ': ', _f('"%1"에 접근할 수 없습니다. 퍼미션을 %2(으)로 수정해 주십시오.', $filename, '0777'), '</li>'; array_push($commands, 'chmod 0777 ' . $filename); } } else { if (mkdir($filename)) { @chmod($filename, 0777); echo '<li>', _t('스킨 디렉토리'), ': OK</li>'; } else { $error = 15; echo '<li style="color:red">', _t('스킨 디렉토리'), ': ', _f('"%1"에 %2 디렉토리를 생성할 수 없습니다. "%1"의 퍼미션을 %3(으)로 수정해 주십시오.', "{$root}/user/skin/blog", 'customize', '0777'), '</li>'; array_push($commands, 'chmod 0777 ' . "{$root}/user/skin/blog"); } } ?> </ul> <?php if (!empty($commands)) { echo '<span class="instruction">' . _t("퍼미션 수정은 FTP 프로그램을 사용하시거나 다음의 명령을 터미널에 붙여 넣으시면 됩니다.") . "</span>"; echo '<ul class="instruction">'; $commands = array_unique($commands); foreach ($commands as $command) { echo "<li>" . $command . "</li>"; } echo '</ul>'; } if ($step == 33) { $error = 16; if (checkIIS()) { ?> <h3><?php echo _t('IIS Rewrite Module'); ?> </h3> <ul style="color:red"> <li><?php echo _t('현재 IIS에서의 설치는 실험적으로만 지원하고 있으며 별도의 Rewrite 모듈을 사용해야 합니다.') . ' ' . _t('만약 이 페이지를 보고 계시다면 Apache mod_rewrite와 호환되지 않는 Rewrite 모듈을 사용 중이거나 아예 모듈이 없는 경우입니다.'); ?> </li> <li><?php echo _t('IIS 7.0을 사용하시는 경우 공식 URL Rewrite Module을 사용하려면 <a href="http://www.iis.net/extensions/URLRewrite">이곳에서 다운로드</a>받아 설치하시고, 계속 진행·설치 후 생성되는 <b>.htaccess</b> 파일 내용을 그대로 import해주시면 됩니다.'); ?> </li> <li><?php echo _t('IIS 6.0 이전 버전을 사용하시는 경우 Rewrite 모듈을 설치하려면, 오픈스소 무료 모듈을 제공하고 있는 <a href="http://www.codeplex.com/IIRF" target="_blank">Ionics Isapi Rewrite Filter 홈페이지</a>를 방문하여 설치하신 후, 계속 진행·설치 후 생성되는 <b>.htaccess</b> 파일의 내용을 위 모듈의 설정파일(<b>IsapiRewrite4.ini</b>)에 복사하시기 바랍니다.'); ?> </li> </ul> <p> <input type="radio" name="rewriteIIS" value="IISRewrite" id="rewriteIIS_Option1"><label for="rewriteIIS_Option1"><?php echo _t('IIS 7.0용 공식 URL Rewrite 모듈을 사용합니다.'); ?> </label><br /> <input type="radio" name="rewriteIIS" value="ISAPI" id="rewriteIIS_Option2"><label for="rewriteIIS_Option2"><?php echo _t('IIS 6.0 및 그 이전 버전을 위한 오픈소스 Rewrite 모듈을 사용합니다.'); ?> </label> </p> <?php $error = 0; } else { ?> <h3><?php echo _t('Apache Rewrite Engine'); ?> </h3> <ul style="color:red"> <li><?php echo _t('Rewrite를 사용할 수 없습니다.'); ?> <br /><span style="color:black"><?php echo _t('다음 항목을 확인하십시오.'); ?> </span></li> <input type="checkbox" id="disableRewrite" name="disableRewrite" /> <label for="disableRewrite"><?php echo _t('rewrite 모듈을 사용하지 않습니다.') . ' ' . _t('만약 rewrite 모듈 설정을 올바르게 했는데도 모듈 사용 여부의 검사에 문제가 있는 경우 rewrite 모듈을 사용하지 않음을 선택하시고 이 부분을 건너 뛰시기 바랍니다.') . ' ' . _t('지금 설정하지 않아도 설치 이후에 관리 패널의 서비스설정-서버 에서 rewrite 관련 설정을 할 수 있습니다.'); ?> </label> <ol style="color:blue"> <li><?php echo _t('웹서버 설정에 <b>mod_rewrite</b>의 로딩이 포함되어야 합니다.'); ?> <br /> <samp><?php echo _t('예: LoadModule <b>rewrite_module</b> modules/<b>mod_rewrite</b>.so'); ?> </samp> </li> <li><?php echo _t('웹서버 설정의 이 디렉토리에 대한 <em>Options</em> 항목에 <b>FollowSymLinks</b>가 포함되거나 <b>All</b>이어야 합니다.'); ?> <samp><br /><?php echo _t('예: Options <b>FollowSymLinks</b>'); ?> </samp> <samp><br /><?php echo _t('예: Options <b>All</b>'); ?> </samp> </li> <li><?php echo _t('웹서버 설정의 이 디렉토리에 대한 <em>AllowOverride</em> 항목에 <b>FileInfo</b>가 포함되거나 <b>All</b>이어야 합니다.'); ?> <samp><br /><?php echo _t('예: AllowOverride <b>FileInfo</b>'); ?> </samp> <samp><br /><?php echo _t('예: AllowOverride <b>All</b>'); ?> </samp> </li> <li><b><?php echo _t('위 2와 3의 문제는 아래 내용을 웹서버 설정에 포함시켜 해결할 수 있습니다.'); ?> </b> <samp style="color:black"><br /> <Directory "<?php echo $root; ?> "><br /> Options FollowSymLinks<br /> AllowOverride FileInfo<br /> </Directory> </samp> </li> </ul> </ul> <?php } } ?> </div> <div id="navigation"> <a href="#" onclick="window.history.back()" title="<?php echo _t('이전'); ?> "><img src="./resources/style/setup/image/icon_prev.gif" width="74" height="24" alt="<?php echo _t('이전'); ?> " /></a> <a href="#" onclick="next(); return false;" title="<?php echo _t('다음'); ?> "><img src="./resources/style/setup/image/icon_next.gif" width="74" height="24" alt="<?php echo _t('다음'); ?> " /></a> </div> </div> <input type="hidden" name="checked" value="<?php echo $error > 0 ? 'no' : 'yes'; ?> " /> <?php } else { if ($step == 5) { if ($check) { if (!empty($_POST['domain']) && !empty($_POST['type'])) { return true; } } // mod_rewrite routine. if (empty($_POST['disableRewrite']) && empty($_POST['rewriteIIS'])) { $filename = $root . '/.htaccess'; $fp = fopen($filename, 'w+'); if (!$fp) { checkStep($step - 1, false); return false; } fwrite($fp, "RewriteEngine On\nRewriteBase {$path}/\nRewriteRule ^testrewrite\$ setup.php [L]"); fclose($fp); @chmod($filename, 0666); if (testMyself('blog' . substr($_SERVER['HTTP_HOST'], strpos($_SERVER['HTTP_HOST'], '.')), $path . '/testrewrite?test=now', $_SERVER['SERVER_PORT'])) { $rewrite = 3; } else { if (testMyself('blog.' . $_SERVER['HTTP_HOST'], $path . '/testrewrite?test=now', $_SERVER['SERVER_PORT'])) { $rewrite = 2; } else { if (testMyself($_SERVER['HTTP_HOST'], $path . '/testrewrite?test=now', $_SERVER['SERVER_PORT'])) { $rewrite = 1; } else { $rewrite = 0; @unlink($filename); checkStep(33, false); return false; } } } @unlink($filename); } else { if (!empty($_POST['rewriteIIS'])) { switch ($_POST['rewriteIIS']) { case 'ISAPI': $rewrite = -1; break; case 'IISRewrite': default: $rewrite = -2; } } else { $rewrite = 0; } } $domain = $rewrite == 3 ? substr($_SERVER['HTTP_HOST'], strpos($_SERVER['HTTP_HOST'], '.') + 1) : $_SERVER['HTTP_HOST']; $blogProtocol = isset($_SERVER['HTTPS']) ? 'https' : 'http'; $blogDefaultPort = isset($_SERVER['HTTPS']) ? 443 : 80; ?> <input type="hidden" name="step" value="<?php echo $step; ?> " /> <input type="hidden" name="mode" value="<?php echo $_POST['mode']; ?> " /> <input type="hidden" name="dbms" value="<?php echo isset($_POST['dbms']) ? $_POST['dbms'] : ''; ?> " /> <input type="hidden" name="dbServer" value="<?php echo isset($_POST['dbServer']) ? $_POST['dbServer'] : ''; ?> " /> <input type="hidden" name="dbPort" value="<?php echo isset($_POST['dbPort']) ? $_POST['dbPort'] : ''; ?> " /> <input type="hidden" name="dbName" value="<?php echo isset($_POST['dbName']) ? $_POST['dbName'] : ''; ?> " /> <input type="hidden" name="dbUser" value="<?php echo isset($_POST['dbUser']) ? $_POST['dbUser'] : ''; ?> " /> <input type="hidden" name="dbPassword" value="<?php echo isset($_POST['dbPassword']) ? htmlspecialchars($_POST['dbPassword']) : ''; ?> " /> <input type="hidden" name="dbPrefix" value="<?php echo isset($_POST['dbPrefix']) ? $_POST['dbPrefix'] : ''; ?> " /> <input type="hidden" name="checked" value="<?php echo isset($_POST['checked']) ? $_POST['checked'] : ''; ?> " /> <input type="hidden" name="domain" value="<?php echo $domain; ?> " /> <input type="hidden" name="disableRewrite" value="<?php echo isset($_POST['disableRewrite']) ? $_POST['disableRewrite'] : ''; ?> " /> <input type="hidden" name="rewriteMode" value="<?php echo $rewrite <= -1 ? $_POST['rewriteIIS'] : 'mod_rewrite'; ?> " /> <div id="inner"> <h2><span class="step"><?php echo _f('%1단계', $step); ?> </span> : <?php echo _t('사용 가능한 운영 방법은 다음과 같습니다. 선택하여 주십시오.'); ?> </h2> <div id="userinput"> <table class="inputs"> <?php if ($rewrite != 0) { ?> <tr> <th width="120"><strong><?php echo _t('다중 사용자'); ?> : </strong></th> <td> <?php if ($rewrite >= 2) { ?> <label for="type1"><input type="radio" id="type1" name="type" value="domain" checked="checked" onclick="show('typeDomain');" /> <?php echo _t('도메인네임(DNS)으로 블로그 식별'); ?> </label> <br /> <?php } ?> <label for="type2"><input type="radio" id="type2" name="type" value="path"<?php echo $rewrite == 1 || $rewrite == -1 ? ' checked="checked"' : ''; ?> onclick="show('typePath');" /> <?php echo _t('하위 경로(Path)로 블로그 식별'); ?> </label></td> </tr> <?php } ?> <tr> <th style="padding-top:10px"><strong><?php echo _t('단일 사용자'); ?> : </strong></th> <td style="padding-top:10px"> <label for="type3"><input type="radio" id="type3" name="type" value="single" onclick="show('typeSingle');" <?php echo empty($_POST['disableRewrite']) ? '' : 'checked="checked"'; ?> /><?php echo _t('단일 블로그'); ?> </label></td> </tr> <tr> <th style="padding-top:20px"><?php echo _t('블로그 주소 예시'); ?> </th> <td style="padding-top:20px; height:100px"> <ul id="typeDomain"<?php echo $rewrite >= 2 ? '' : ' style="display:none"'; ?> > <li><?php echo $blogProtocol; ?> ://<b>blog1</b>.<?php echo $domain; echo $_SERVER['SERVER_PORT'] == $blogDefaultPort ? '' : ":{$_SERVER['SERVER_PORT']}"; echo $path; ?> /</li> <li><?php echo $blogProtocol; ?> ://<b>blog2</b>.<?php echo $domain; echo $_SERVER['SERVER_PORT'] == $blogDefaultPort ? '' : ":{$_SERVER['SERVER_PORT']}"; echo $path; ?> /</li> </ul> <ul id="typePath"<?php echo $rewrite == 1 ? '' : ' style="display:none"'; ?> > <li><?php echo $blogProtocol; ?> ://<?php echo $domain; echo $_SERVER['SERVER_PORT'] == $blogDefaultPort ? '' : ":{$_SERVER['SERVER_PORT']}"; echo $path; ?> /<b>blog1</b></li> <li><?php echo $blogProtocol; ?> ://<?php echo $domain; echo $_SERVER['SERVER_PORT'] == $blogDefaultPort ? '' : ":{$_SERVER['SERVER_PORT']}"; echo $path; ?> /<b>blog2</b></li> </ul> <ul id="typeSingle" <?php echo empty($_POST['disableRewrite']) ? 'style="display:none"' : ''; ?> > <li><?php echo $blogProtocol; ?> ://<?php echo $domain; echo $_SERVER['SERVER_PORT'] == $blogDefaultPort ? '' : ":{$_SERVER['SERVER_PORT']}"; echo $path; ?> /<?php echo empty($_POST['disableRewrite']) ? '' : 'blog/'; ?> </li> </ul> </td> </tr> </table> </div> <div id="navigation"> <a href="#" onclick="window.history.back()" title="<?php echo _t('이전'); ?> "><img src="./resources/style/setup/image/icon_prev.gif" width="74" height="24" alt="<?php echo _t('이전'); ?> " /></a> <a href="#" onclick="next(); return false;" title="<?php echo _t('다음'); ?> "><img src="./resources/style/setup/image/icon_next.gif" width="74" height="24" alt="<?php echo _t('다음'); ?> " /></a> </div> </div> <?php } else { if ($step == 6) { if ($check) { if (!empty($_POST['email']) && !empty($_POST['password']) && !empty($_POST['password2']) && ($_POST['type'] == 'single' || !empty($_POST['blog'])) && isset($_POST['name'])) { if (!preg_match('/^[^@]+@([-a-zA-Z0-9]+\\.)+[-a-zA-Z0-9]+$/', $_POST['email'])) { $error = 51; } else { if ($_POST['password'] != $_POST['password2']) { $error = 52; } else { if ($_POST['type'] != 'single' && !preg_match('/^[a-zA-Z0-9]+$/', $_POST['blog'])) { $error = 53; } else { if (strlen($_POST['password']) < 6 || strlen($_POST['password2']) < 6) { $error = 54; } else { return true; } } } } } } else { @POD::query('SET CHARACTER SET utf8'); if ($result = @POD::query("SELECT loginid, password, name FROM {$_POST['dbPrefix']}Users WHERE userid = 1")) { @(list($_POST['email'], $_POST['password'], $_POST['name']) = POD::fetch($result, 'row')); $_POST['password2'] = $_POST['password']; POD::free($result); } if ($result = @POD::queryCell("SELECT value FROM {$_POST['dbPrefix']}BlogSettings\n\t\t\t\t\t\tWHERE blogid = 1\n\t\t\t\t\t\t\tAND name = 'name'")) { $_POST['blog'] = $result; } } ?> <input type="hidden" name="step" value="<?php echo $step; ?> " /> <input type="hidden" name="mode" value="<?php echo $_POST['mode']; ?> " /> <input type="hidden" name="dbms" value="<?php echo isset($_POST['dbms']) ? $_POST['dbms'] : ''; ?> " /> <input type="hidden" name="dbServer" value="<?php echo isset($_POST['dbServer']) ? $_POST['dbServer'] : ''; ?> " /> <input type="hidden" name="dbPort" value="<?php echo isset($_POST['dbPort']) ? $_POST['dbPort'] : ''; ?> " /> <input type="hidden" name="dbName" value="<?php echo isset($_POST['dbName']) ? $_POST['dbName'] : ''; ?> " /> <input type="hidden" name="dbUser" value="<?php echo isset($_POST['dbUser']) ? $_POST['dbUser'] : ''; ?> " /> <input type="hidden" name="dbPassword" value="<?php echo isset($_POST['dbPassword']) ? htmlspecialchars($_POST['dbPassword']) : ''; ?> " /> <input type="hidden" name="dbPrefix" value="<?php echo isset($_POST['dbPrefix']) ? $_POST['dbPrefix'] : ''; ?> " /> <input type="hidden" name="checked" value="<?php echo isset($_POST['checked']) ? $_POST['checked'] : ''; ?> " /> <input type="hidden" name="domain" value="<?php echo isset($_POST['domain']) ? $_POST['domain'] : ''; ?> " /> <input type="hidden" name="disableRewrite" value="<?php echo isset($_POST['disableRewrite']) ? $_POST['disableRewrite'] : ''; ?> " /> <input type="hidden" name="rewriteMode" value="<?php echo isset($_POST['rewriteMode']) ? $_POST['rewriteMode'] : ''; ?> " /> <input type="hidden" name="type" value="<?php echo isset($_POST['type']) ? $_POST['type'] : ''; ?> " /> <div id="inner"> <h2><span class="step"><?php echo _f('%1단계', $step); ?> </span> : <?php echo _t('관리자 정보 입력'); ?> </h2> <div id="userinput"> <table class="inputs"> <tr> <th style="width:100px"><?php echo _t('이메일'); ?> : </th> <td> <input type="text" id="email" name="email" value="<?php echo isset($_POST['email']) ? htmlspecialchars($_POST['email']) : ''; ?> " class="input_email"<?php echo $check && (empty($_POST['email']) || $error == 51) ? ' style="border-color:red"' : ''; ?> /> </td> </tr> <tr> <th><?php echo _t('비밀번호'); ?> : </th> <td> <input type="password" name="password" value="<?php echo isset($_POST['password']) ? htmlspecialchars($_POST['password']) : ''; ?> " class="input_password"<?php echo $check && empty($_POST['password']) ? ' style="border-color:red"' : ''; ?> /><br /> <em class="password"><?php echo _t('비밀번호는 최소 6자 이상이어야 합니다.'); ?> </em> </td> </tr> <tr> <th><?php echo _t('비밀번호 확인'); ?> : </th> <td> <input type="password" name="password2" value="<?php echo isset($_POST['password2']) ? htmlspecialchars($_POST['password2']) : ''; ?> " class="input_password"<?php echo $check && empty($_POST['password2']) ? ' style="border-color:red"' : ''; ?> /> </td> </tr> <tr> <th><?php echo _t('블로그 식별자'); ?> : </th> <td> <input type="text" name="blog" value="<?php echo isset($_POST['blog']) ? htmlspecialchars($_POST['blog']) : ''; ?> " class="input_password"<?php echo $check && (empty($_POST['blog']) || $error == 53) ? ' style="border-color:red"' : ''; ?> /> </td> </tr> <tr> <th><?php echo _t('필명'); ?> : </th> <td> <input type="text" name="name" value="<?php echo isset($_POST['name']) ? htmlspecialchars($_POST['name']) : ''; ?> " class="input_password" /> </td> </tr> </table> <div id="warning"><?php if ($error == 51) { echo _t('이메일이 올바르지 않습니다.'); } else { if ($error == 52) { echo _t('비밀번호가 일치하지 않습니다.'); } else { if ($error == 53) { echo _t('블로그 식별자가 올바르지 않습니다.'); } else { if ($error == 54) { echo _t('비밀번호는 최소 6자 이상이어야 합니다.'); } else { if ($check) { echo _t('표시된 정보가 부족합니다.'); } else { echo ' '; } } } } } ?> </div> </div> <div id="navigation"> <a href="#" onclick="window.history.back()" title="<?php echo _t('이전'); ?> "><img src="./resources/style/setup/image/icon_prev.gif" width="74" height="24" alt="<?php echo _t('이전'); ?> " /></a> <a href="#" onclick="next(); return false;" title="<?php echo _t('다음'); ?> "><img src="./resources/style/setup/image/icon_next.gif" width="74" height="24" alt="<?php echo _t('다음'); ?> " /></a> </div> </div> <script type="text/javascript"> //<![CDATA[ document.getElementById('email').focus(); //]]> </script> <?php } else { if ($step == 7) { if ($check) { return true; } ?> <input type="hidden" name="step" value="<?php echo $step; ?> " /> <input type="hidden" name="mode" value="<?php echo $_POST['mode']; ?> " /> <input type="hidden" name="dbms" value="<?php echo isset($_POST['dbms']) ? $_POST['dbms'] : ''; ?> " /> <input type="hidden" name="dbServer" value="<?php echo isset($_POST['dbServer']) ? $_POST['dbServer'] : ''; ?> " /> <input type="hidden" name="dbPort" value="<?php echo isset($_POST['dbPort']) ? $_POST['dbPort'] : ''; ?> " /> <input type="hidden" name="dbName" value="<?php echo isset($_POST['dbName']) ? $_POST['dbName'] : ''; ?> " /> <input type="hidden" name="dbUser" value="<?php echo isset($_POST['dbUser']) ? $_POST['dbUser'] : ''; ?> " /> <input type="hidden" name="dbPassword" value="<?php echo isset($_POST['dbPassword']) ? htmlspecialchars($_POST['dbPassword']) : ''; ?> " /> <input type="hidden" name="dbPrefix" value="<?php echo isset($_POST['dbPrefix']) ? $_POST['dbPrefix'] : ''; ?> " /> <input type="hidden" name="checked" value="<?php echo isset($_POST['checked']) ? $_POST['checked'] : ''; ?> " /> <input type="hidden" name="domain" value="<?php echo isset($_POST['domain']) ? $_POST['domain'] : ''; ?> " /> <input type="hidden" name="disableRewrite" value="<?php echo isset($_POST['disableRewrite']) ? $_POST['disableRewrite'] : false; ?> " /> <input type="hidden" name="rewriteMode" value="<?php echo isset($_POST['rewriteMode']) ? $_POST['rewriteMode'] : ''; ?> " /> <input type="hidden" name="type" value="<?php echo isset($_POST['type']) ? $_POST['type'] : ''; ?> " /> <input type="hidden" name="blog" value="<?php echo isset($_POST['blog']) ? $_POST['blog'] : ''; ?> " /> <div id="inner"> <h2><span class="step"><?php echo _f('%1단계', $step); ?> </span> : <?php echo _t('데이터베이스를 준비하고 있습니다. 잠시만 기다려 주십시오.'); ?> </h2> <div id="content-box" style="text-align:center"> <p></p> </div> </div><!-- inner --> </form> </div><!-- container --> <?php function fail($msg) { flush(); if ($_POST['mode'] == 'install') { } exit; } $loginid = POD::escapeString($_POST['email']); $password = md5($_POST['password']); $name = POD::escapeString($_POST['name']); $blog = POD::escapeString($_POST['blog']); $baseLanguage = POD::escapeString($_POST['Lang']); $baseTimezone = POD::escapeString(substr(_t('default:Asia/Seoul'), 8)); if (POD::dbms() == 'MySQLi') { $charset = 'DEFAULT CHARSET=utf8'; // if (!@POD::query('SET CHARACTER SET utf8')) // $charset = 'TYPE=MyISAM'; // @POD::query('SET SESSION collation_connection = \'utf8_general_ci\''); } else { $charset = ''; } if ($_POST['mode'] == 'install') { $schema = ''; // Compatibility layer load if (file_exists(ROOT . '/resources/setup/compatibility.' . POD::dbms() . '.sql')) { $schema = file_get_contents(ROOT . '/resources/setup/compatibility.' . POD::dbms() . '.sql'); $query = explode(';', trim($schema)); foreach ($query as $sub) { @POD::query($sub); } $schema = ''; $query = array(); } // Loading create schema from sql file. (DBMS specific) if (POD::dbms() == 'MySQLi') { $dbSelector = 'MySQL'; } else { $dbSelector = POD::dbms(); } $schema .= file_get_contents(ROOT . '/resources/setup/initialize.' . $dbSelector . '.sql'); $schema = str_replace('[##_dbPrefix_##]', $_POST['dbPrefix'], $schema); $schema = str_replace('[##_charset_##]', $charset, $schema); $schema .= "\nINSERT INTO {$_POST['dbPrefix']}Users VALUES (1, '{$loginid}', '{$password}', '{$name}', " . Timestamp::getUNIXtime() . ", 0, 0);\nINSERT INTO {$_POST['dbPrefix']}Privileges VALUES (1, 1, 16, " . Timestamp::getUNIXtime() . ", 0);\nINSERT INTO {$_POST['dbPrefix']}ServiceSettings VALUES ('newlineStyle', '1.1');\nINSERT INTO {$_POST['dbPrefix']}ServiceSettings VALUES ('useNewPluginSetting', 1);\nINSERT INTO {$_POST['dbPrefix']}BlogSettings VALUES (1, 'name', '{$blog}');\nINSERT INTO {$_POST['dbPrefix']}BlogSettings VALUES (1, 'language', '{$baseLanguage}');\nINSERT INTO {$_POST['dbPrefix']}BlogSettings VALUES (1, 'blogLanguage', '{$baseLanguage}');\nINSERT INTO {$_POST['dbPrefix']}BlogSettings VALUES (1, 'timezone', '{$baseTimezone}');\nINSERT INTO {$_POST['dbPrefix']}BlogSettings VALUES (1, 'defaultEditor', 'tinyMCE');\nINSERT INTO {$_POST['dbPrefix']}BlogSettings VALUES (1, 'defaultFormatter', 'ttml');\nINSERT INTO {$_POST['dbPrefix']}BlogSettings VALUES (1, 'acceptTrackbacks', 1);\nINSERT INTO {$_POST['dbPrefix']}BlogSettings VALUES (1, 'acceptComments', 1);\nINSERT INTO {$_POST['dbPrefix']}Plugins VALUES (1, 'CL_OpenID', null);\nINSERT INTO {$_POST['dbPrefix']}SkinSettings VALUES (1,'skin','periwinkle');\nINSERT INTO {$_POST['dbPrefix']}FeedSettings (blogid) values(1);\nINSERT INTO {$_POST['dbPrefix']}FeedGroups (blogid) values(1);\nINSERT INTO {$_POST['dbPrefix']}Entries (blogid, userid, id, category, visibility, location, title, slogan, contentformatter, contenteditor, starred, acceptcomment, accepttrackback, created, published, modified, content) VALUES (1, 1, 1, 0, 2, '/', '" . POD::escapeString(_t('환영합니다')) . "', 'welcome', 'ttml', 'tinyMCE', 0, 1, 1, " . Timestamp::getUNIXtime() . ", " . Timestamp::getUNIXtime() . "," . Timestamp::getUNIXtime() . ",'" . POD::escapeString(getDefaultPostContent()) . "')"; $query = explode(';', trim($schema)); foreach ($query as $sub) { if (!empty($sub) && !POD::query($sub, false)) { $tables = getTables('2.0', $_POST['dbPrefix']); foreach ($tables as $table) { if (POD::dbms() == 'Cubrid') { @POD::query("DROP " . $table); } else { @POD::query("DROP TABLE " . $table); } } /* @POD::query( "DROP TABLE {$_POST['dbPrefix']}Attachments, {$_POST['dbPrefix']}BlogSettings, {$_POST['dbPrefix']}BlogStatistics, {$_POST['dbPrefix']}Categories, {$_POST['dbPrefix']}Comments, {$_POST['dbPrefix']}CommentsNotified, {$_POST['dbPrefix']}CommentsNotifiedQueue, {$_POST['dbPrefix']}CommentsNotifiedSiteInfo, {$_POST['dbPrefix']}ContentFilters, {$_POST['dbPrefix']}DailyStatistics, {$_POST['dbPrefix']}Entries, {$_POST['dbPrefix']}EntriesArchive, {$_POST['dbPrefix']}FeedGroupRelations, {$_POST['dbPrefix']}FeedGroups, {$_POST['dbPrefix']}FeedItems, {$_POST['dbPrefix']}FeedReads, {$_POST['dbPrefix']}FeedSettings, {$_POST['dbPrefix']}FeedStarred, {$_POST['dbPrefix']}Feeds, {$_POST['dbPrefix']}Filters, {$_POST['dbPrefix']}Links, {$_POST['dbPrefix']}LinkCategories, {$_POST['dbPrefix']}OpenIDUsers, {$_POST['dbPrefix']}PageCacheLog, {$_POST['dbPrefix']}Plugins, {$_POST['dbPrefix']}Privileges, {$_POST['dbPrefix']}RefererLogs, {$_POST['dbPrefix']}RefererStatistics, {$_POST['dbPrefix']}RemoteResponseLogs, {$_POST['dbPrefix']}RemoteResponses, {$_POST['dbPrefix']}ReservedWords, {$_POST['dbPrefix']}ServiceSettings, {$_POST['dbPrefix']}SessionVisits, {$_POST['dbPrefix']}Sessions, {$_POST['dbPrefix']}SkinSettings, {$_POST['dbPrefix']}TagRelations, {$_POST['dbPrefix']}Tags, {$_POST['dbPrefix']}UserSettings, {$_POST['dbPrefix']}Users, {$_POST['dbPrefix']}XMLRPCPingSettings" );*/ echo '<script type="text/javascript">//<![CDATA[' . CRLF . 'alert("', _t('테이블을 생성하지 못했습니다.'), '")//]]></script>'; $error = 1; break; } } } else { $ctx = Model_Context::getInstance(); $ctx->setProperty('database.prefix', $_POST['dbPrefix']); $pool = DBModel::getInstance(); $pool->reset('Users'); $pool->setAttribute('loginid', $loginid, true); $pool->setAttribute('name', $name, true); $pool->setQualifier('userid', 'equals', 1); $pool->update(); $pool->reset('Users'); $pool->setAttribute('password', $password, true); $pool->setQualifier('userid', 'equals', 1); $pool->setQualifier('password', 'not', $password2, true); $pool->update(); $pool->reset('BlogSettings'); $pool->setAttribute('value', $_POST['blog'], true); $pool->setQualifier('blogid', 'equals', 1); $pool->setQualifier('name', 'equals', 'name', true); $pool->update(); $pool->reset('BlogSettings'); $pool->setAttribute('value', $baseLanguage, true); $pool->setQualifier('blogid', 'equals', 1); $pool->setQualifier('name', 'equals', 'language', true); $pool->update(); $pool->reset('BlogSettings'); $pool->setAttribute('value', $baseTimezone, true); $pool->setQualifier('blogid', 'equals', 1); $pool->setQualifier('name', 'equals', 'timezone', true); $pool->update(); $pool->reset('BlogSettings'); $pool->setAttribute('value', Timestamp::getUNIXtime()); $pool->setQualifier('blogid', 'equals', 1); $pool->setQualifier('name', 'equals', 'created', true); $pool->update(); } if (!$error) { POD::unbind(); echo '<script type="text/javascript">//<![CDATA[' . CRLF . 'next() //]]></script>'; } ?> </body> </html> <?php } else { if ($step == 8) { if ($check) { return true; } $useSSL = Utils_Misc::isSecureProtocol() ? 'true' : 'false'; $filename = $root . '/config.php'; $fp = fopen($filename, 'w+'); // For first entry addition $database = array('server' => $_POST['dbServer'], 'database' => $_POST['dbName'], 'username' => $_POST['dbUser'], 'port' => $_POST['dbPort'], 'password' => $_POST['dbPassword'], 'prefix' => $_POST['dbPrefix']); if ($fp) { fwrite($fp, "<?php\nini_set('display_errors', 'off');\n\$database['server'] = '{$_POST['dbServer']}';\n\$database['dbms'] = '{$_POST['dbms']}';\n\$database['database'] = '{$_POST['dbName']}';\n\$database['port'] = '{$_POST['dbPort']}';\n\$database['username'] = '******'dbUser']}';\n\$database['password'] = '******'dbPassword']}';\n\$database['prefix'] = '{$_POST['dbPrefix']}';\n\$service['type'] = '{$_POST['type']}';\n\$service['domain'] = '{$_POST['domain']}';\n\$service['path'] = '{$path}';\n\$service['skin'] = 'periwinkle';\n\$service['favicon_daily_traffic'] = 10; // 10MB\n\$service['useSSL'] = {$useSSL}; // Force SSL protocol (via https)\n//\$serviceURL = 'http://{$_POST['domain']}{$path}' ; // for path of Skin, plugin and etc.\n//\$service['reader'] = true; // Use Textcube reader. You can set it to false if you do not use Textcube reader, and want to decrease DB load.\n//\$service['debugmode'] = true; // uncomment for debugging, e.g. displaying DB Query or Session info\n//\$service['pagecache'] = false; // uncomment if you want to disable page cache feature.\n//\$service['codecache'] = true; // uncomment if you want to enable code cache feature.\n//\$service['debug_session_dump'] = true; // session info debuging.\n//\$service['debug_rewrite_module'] = true; // rewrite handling module debuging.\n//\$service['session_cookie_path'] = \$service['path']; // for avoiding spoiling other textcube's session id sharing root.\n//\$service['allowBlogVisibilitySetting'] = true; // Allow service users to change blog visibility.\n//\$service['externalresources'] = false; // Loads resources from external storage.\n//\$service['resourcepath'] = 'http://example.com/resource';\t// Specify the full URI of external resource.\n//\$service['autologinTimeout'] = 1209600;\t// Automatic login timeout (sec.)\n//\$service['favicon_daily_traffic'] = 10; // Set favicon traffic limitation. default is 10MB.\n//\$service['skincache'] = true; // Use skin pre-fetching. Textcube will parse static elements (blog name, title…) only when you change skin. Reduces CPU loads.\n//\$service['cookie_prefix'] = ''; // Service cookie prefix. Default cookie prefix is Textcube_[VERSION_NUMBER].\n//\$database['port'] = 3639; // Database port number\n//\$database['dbms'] = 'MySQLi'; // DBMS. (MySQL, MySQLi, PostgreSQL, Cubrid.)\n//\$service['memcached'] = true; // Using memcache to handle session and cache\n//\$memcached['server'] = 'localhost'; // Where memcache server is.\n//\$service['requirelogin'] = false; // Force log-in process to every blogs. (for private blog service)\n//\$service['jqueryURL'] = '';\t\t// Add URL if you want to use external jquery via CDN. e.g.) Microsoft's CDN: http://ajax.aspnetcdn.com/ajax/jQuery/\n//\$service['lodashURL'] = '';\t\t// Add URL if you want to use external lo-dash via CDN. e.g.) CDNJS' CDN: https://cdnjs.cloudflare.com/ajax/libs/lodash.js/2.4.1/\n?>"); fclose($fp); @chmod($filename, 0666); } if (!isset($_POST['disableRewrite']) || !$_POST['disableRewrite']) { $filename = $root . '/.htaccess'; $fp = fopen($filename, 'w+'); switch ($_POST['rewriteMode']) { case 'ISAPI': // Users must copy these rules to IsapiRewrite4.ini $htaccessContent = <<<EOF RewriteRule ^{$path}/(thumbnail)/([0-9]+/.+)\$ {$path}/cache/\$1/\$2 [L,U] RewriteRule ^{$path}/attach/([0-9]+/.+)\$ {$path}/user/attach/\$1 [L,U] RewriteCond %{REQUEST_FILENAME} -f RewriteRule ^{$path}/user+/+(cache)+/+(.+[^/]).(cache|xml|txt|log)\$ - [NC,F,L,U] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^{$path}/([^?]+[^/])\$ {$path}/\$1/ [L,U] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{QUERY_STRING} ^\$ RewriteRule ^{$path}/(.*)\$ {$path}/rewrite.php [L,U] RewriteRule ^{$path}/(.*)\$ {$path}/rewrite.php?%{QUERY_STRING} [L,U] EOF; break; case 'IISRewrite': // Users must import these rules into URL Rewrite module. $htaccessContent = <<<EOF RewriteRule ^{$path}/(thumbnail)/([0-9]+/.+)\$ {$path}/cache/\$1/\$2 [L] RewriteRule ^{$path}/attach/([0-9]+/.+)\$ {$path}/user/attach/\$1 [L] RewriteCond %{REQUEST_FILENAME} -f RewriteRule ^{$path}/user+/+(cache)+/+(.+[^/]).(cache|xml|txt|log)\$ - [NC,F,L] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^{$path}/([^?]+[^/])\$ {$path}/\$1/ [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteRule ^{$path}/(.*)\$ {$path}/rewrite.php [L,QSA] EOF; break; case 'mod_rewrite': default: $htaccessContent = <<<EOF #<IfModule mod_url.c> #CheckURL Off #</IfModule> #SetEnv PRELOAD_CONFIG 1 RewriteEngine On RewriteBase {$path}/ RewriteRule ^(thumbnail)/([0-9]+/.+)\$ cache/\$1/\$2 [L] RewriteRule ^attach/([0-9]+/.+)\$ user/attach/\$1 [L] RewriteCond %{REQUEST_FILENAME} -f RewriteRule ^user+/+(cache)+/+(.+[^/]).(cache|xml|txt|log)\$ - [NC,F,L] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+[^/])\$ \$1/ [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteRule ^(.*)\$ rewrite.php [L,QSA] EOF; } if ($fp) { fwrite($fp, $htaccessContent); fclose($fp); @chmod($filename, 0666); } } $blogProtocol = isset($_SERVER['HTTPS']) ? 'https' : 'http'; $blogDefaultPort = isset($_SERVER['HTTPS']) ? 443 : 80; switch ($_POST['type']) { case 'domain': $blogURL = "{$blogProtocol}://{$_POST['blog']}.{$_POST['domain']}" . ($_SERVER['SERVER_PORT'] != $blogDefaultPort ? ":{$_SERVER['SERVER_PORT']}" : '') . "{$path}" . (empty($_POST['disableRewrite']) ? '' : '/index.php?'); break; case 'path': $blogURL = "{$blogProtocol}://{$_POST['domain']}" . ($_SERVER['SERVER_PORT'] != $blogDefaultPort ? ":{$_SERVER['SERVER_PORT']}" : '') . "{$path}" . (empty($_POST['disableRewrite']) ? '' : '/index.php?') . "/{$_POST['blog']}"; break; case 'single': $blogURL = "{$blogProtocol}://{$_POST['domain']}" . ($_SERVER['SERVER_PORT'] != $blogDefaultPort ? ":{$_SERVER['SERVER_PORT']}" : '') . "{$path}" . (empty($_POST['disableRewrite']) ? '' : '/index.php?'); break; } ?> <div id="inner"> <h2><span class="step"><?php echo _t('설치완료'); ?> </span> : <?php echo _t('텍스트큐브가 성공적으로 설치되었습니다.'); ?> </h2> <div id="content-box"> <p> </p> <ul> <li><?php echo _t('텍스트큐브 주소'); ?> <br /> <a href="<?php echo $blogURL . '/'; ?> "><?php echo $blogURL . '/'; ?> </a><br /> <br /> </li> <li><?php echo _t('텍스트큐브 관리 툴 주소'); ?> <br /> <a href="<?php echo $blogURL . '/'; ?> owner"><?php echo $blogURL . '/'; ?> owner</a></li> </ul> <p> <?php if (checkIIS()) { echo _t('새로 IIS용 Rewrite 모듈을 설치하셨다면 <b>.htaccess 내용을 모듈 설정에 적용</b>해주십시오.<br />'); } ?> <?php echo '<li style="color:red">', _t('보안 관련 안내'), ': ', '<br /><span class="instruction">', _t('보안을 위하여 설치때 필요했던 권한 중 일부를 제거해주세요. FTP 프로그램으로 권한을 수정하시거나 다음의 명령을 터미널에 붙여 넣으시면 됩니다'), '<br />', 'chmod 0755 ' . $root, '</span></li>'; ?> <?php echo _t('텍스트큐브 관리 툴로 로그인 하신 후 필요사항을 수정해 주십시오.'); ?> <br /> <?php echo _t('텍스트큐브를 이용해 주셔서 감사합니다.'); ?> </p> </div> </div> <?php } else { if ($step == 204) { ?> <input type="hidden" name="step" value="4" /> <input type="hidden" name="mode" value="<?php echo $_POST['mode']; ?> " /> <input type="hidden" name="dbms" value="<?php echo isset($_POST['dbms']) ? $_POST['dbms'] : ''; ?> " /> <input type="hidden" name="dbServer" value="<?php echo isset($_POST['dbServer']) ? $_POST['dbServer'] : ''; ?> " /> <input type="hidden" name="dbPort" value="<?php echo isset($_POST['dbPort']) ? $_POST['dbPort'] : ''; ?> " /> <input type="hidden" name="dbName" value="<?php echo isset($_POST['dbName']) ? $_POST['dbName'] : ''; ?> " /> <input type="hidden" name="dbUser" value="<?php echo isset($_POST['dbUser']) ? $_POST['dbUser'] : ''; ?> " /> <input type="hidden" name="dbPassword" value="<?php echo isset($_POST['dbPassword']) ? htmlspecialchars($_POST['dbPassword']) : ''; ?> " /> <div id="inner"> <h2><span class="step"><?php echo _f('%1단계', 4); ?> </span> : <?php echo _t('삭제하고자 하는 테이블을 선택하여 주십시오.'); ?> </h2> <div id="userinput"> <table id="info"> <tr> <th><?php echo _t('식별자'); ?> </th> <th><?php echo _t('버전'); ?> </th> <th><?php echo _t('테이블'); ?> </th> <th></th> </tr> <?php $tables = array(); $ckeckedString = 'checked '; if ($result = POD::tableList()) { foreach ($result as $table) { //$table = $table[0]; $entriesMatched = preg_match('/Entries$/', $table); if ($entriesMatched && checkTables('2.0', $prefix = substr($table, 0, strlen($table) - 7))) { ?> <tr> <th><?php echo $prefix; ?> </th> <th>2.0</th> <td><?php echo implode(', ', getTables('2.0', $prefix)); ?> </td> <th><input type="radio" name="target" value="2.0_<?php echo $prefix; ?> " <?php echo $ckeckedString; ?> /></th> </tr> <?php $ckeckedString = ''; } else { if ($entriesMatched && checkTables('1.9', $prefix = substr($table, 0, strlen($table) - 7))) { ?> <tr> <th><?php echo $prefix; ?> </th> <th>1.9</th> <td><?php echo implode(', ', getTables('1.9', $prefix)); ?> </td> <th><input type="radio" name="target" value="1.9_<?php echo $prefix; ?> " <?php echo $ckeckedString; ?> /></th> </tr> <?php $ckeckedString = ''; } else { if ($entriesMatched && checkTables('1.8', $prefix = substr($table, 0, strlen($table) - 7))) { ?> <tr> <th><?php echo $prefix; ?> </th> <th>1.8</th> <td><?php echo implode(', ', getTables('1.8', $prefix)); ?> </td> <th><input type="radio" name="target" value="1.8_<?php echo $prefix; ?> " <?php echo $ckeckedString; ?> /></th> </tr> <?php $ckeckedString = ''; } else { if ($entriesMatched && checkTables('1.7', $prefix = substr($table, 0, strlen($table) - 7))) { ?> <tr> <th><?php echo $prefix; ?> </th> <th>1.7</th> <td><?php echo implode(', ', getTables('1.7', $prefix)); ?> </td> <th><input type="radio" name="target" value="1.7_<?php echo $prefix; ?> " <?php echo $ckeckedString; ?> /></th> </tr> <?php $ckeckedString = ''; } else { if ($entriesMatched && checkTables('1.6', $prefix = substr($table, 0, strlen($table) - 7))) { ?> <tr> <th><?php echo $prefix; ?> </th> <th>1.6</th> <td><?php echo implode(', ', getTables('1.6', $prefix)); ?> </td> <th><input type="radio" name="target" value="1.6_<?php echo $prefix; ?> " <?php echo $ckeckedString; ?> /></th> </tr> <?php $ckeckedString = ''; } else { if ($entriesMatched && checkTables('1.5', $prefix = substr($table, 0, strlen($table) - 7))) { ?> <tr> <th><?php echo $prefix; ?> </th> <th>1.5</th> <td><?php echo implode(', ', getTables('1.5', $prefix)); ?> </td> <th><input type="radio" name="target" value="1.5_<?php echo $prefix; ?> " <?php echo $ckeckedString; ?> /></th> </tr> <?php $ckeckedString = ''; } else { if ($entriesMatched && checkTables('1.1', $prefix = substr($table, 0, strlen($table) - 7))) { ?> <tr> <th><?php echo $prefix; ?> </th> <th>1.1</th> <td><?php echo implode(', ', getTables('1.1', $prefix)); ?> </td> <th><input type="radio" name="target" value="1.1_<?php echo $prefix; ?> " <?php echo $ckeckedString; ?> /></th> </tr> <?php $ckeckedString = ''; } else { if ($entriesMatched && checkTables('1.0.2', $prefix = substr($table, 0, strlen($table) - 7))) { ?> <tr> <th><?php echo $prefix; ?> </th> <th>1.0.2</th> <td><?php echo implode(', ', getTables('1.0.2', $prefix)); ?> </td> <th><input type="radio" name="target" value="1.0.2_<?php echo $prefix; ?> " <?php echo $ckeckedString; ?> /></th> </tr> <?php $ckeckedString = ''; } else { if ($entriesMatched && checkTables('1.0.0', $prefix = substr($table, 0, strlen($table) - 7))) { ?> <tr> <th><?php echo $prefix; ?> </th> <th>1.0.0</th> <td><?php echo implode(', ', getTables('1.0.0', $prefix)); ?> </td> <th><input type="radio" name="target" value="1.0.0_<?php echo $prefix; ?> " <?php echo $ckeckedString; ?> /></th> </tr> <?php $ckeckedString = ''; } else { if ($entriesMatched && checkTables('1.0.b2', $prefix = substr($table, 0, strlen($table) - 7))) { ?> <tr> <th><?php echo $prefix; ?> </th> <th>1.0 Beta 2</th> <td><?php echo implode(', ', getTables('1.0.b2', $prefix)); ?> </td> <th><input type="radio" name="target" value="1.0.b2_<?php echo $prefix; ?> " <?php echo $ckeckedString; ?> /></th> </tr> <?php $ckeckedString = ''; } else { if (preg_match('/^t3_(.*)_10ofmg$/', $table) && checkTables('0.97', $prefix = substr($table, 3, strlen($table) - 10))) { ?> <tr> <th><?php echo $prefix; ?> </th> <th>0.97 (Classic)</th> <td><?php echo implode(', ', getTables('0.97', $prefix)); ?> </td> <th><input type="radio" name="target" value="0.97_<?php echo $prefix; ?> " <?php echo $ckeckedString; ?> /></th> </tr> <?php $ckeckedString = ''; } else { if (preg_match('/^t3_(.*)_ct1$/', $table) && checkTables('0.96', $prefix = substr($table, 3, strlen($table) - 7))) { ?> <tr> <th><?php echo $prefix; ?> </th> <th>0.96x</th> <td><?php echo implode(', ', getTables('0.96', $prefix)); ?> </td> <th><input type="radio" name="target" value="0.96_<?php echo $prefix; ?> " <?php echo $ckeckedString; ?> /></th> </tr> <?php $ckeckedString = ''; } } } } } } } } } } } } } } ?> </table> </div> <div id="navigation"> <a href="#" onclick="window.history.back()" title="<?php echo _t('이전'); ?> "><img src="./resources/style/setup/image/icon_prev.gif" width="74" height="24" alt="<?php echo _t('이전'); ?> " /></a> <a href="#" onclick="if (confirm('<?php echo _t('삭제하시겠습니까?'); ?> ') && confirm('<?php echo _t('정말 삭제하시겠습니까?'); ?> ')) next(); return false;" title="<?php echo _t('다음'); ?> "><img src="./resources/style/setup/image/icon_next.gif" width="74" height="24" alt="<?php echo _t('다음'); ?> " /></a> </div> </div> <?php } else { if ($step == 205) { ?> <input type="hidden" name="step" value="1" /> <div id="inner"> <h2><span class="step"><?php echo _f('%1단계', 5); ?> </span> : <?php echo _t('선택된 테이블을 삭제하고 있습니다.'); ?> </h2> <div id="userinput"> <table id="info"> <tr> <th><?php echo _t('식별자'); ?> </th> <th><?php echo _t('버전'); ?> </th> <th><?php echo _t('테이블'); ?> </th> </tr> <?php list($version, $prefix) = explode('_', $_POST['target'], 2); $result = false; if (checkTables($version, $prefix)) { ?> <tr> <th><?php echo $prefix; ?> </th> <th><?php echo $version; ?> </th> <td><?php echo implode(', ', getTables($version, $prefix)); ?> </td> </tr> <?php $result = @POD::query('DROP TABLE ' . implode(', ', getTables($version, $prefix))); } ?> </table> <p><?php echo $result ? _t('삭제하였습니다.') : '<span style="color:red">' . _t('삭제하지 못했습니다.') . '</span>'; ?> </p> </div> <div id="navigation"> <a href="#" onclick="window.history.back()" title="<?php echo _t('이전'); ?> "><img src="./resources/style/setup/image/icon_prev.gif" width="74" height="24" alt="<?php echo _t('이전'); ?> " /></a> <a href="#" onclick="next(); return false;" title="<?php echo _t('다음'); ?> "><img src="./resources/style/setup/image/icon_next.gif" width="74" height="24" alt="<?php echo _t('다음'); ?> " /></a> </div> </div> <?php } } } } } } } } } } }
<?php $row = 25; $bloglist = POD::queryColumn("SELECT blogid,name FROM `{$database['prefix']}BlogSettings` WHERE name = 'name' ORDER BY blogid ASC LIMIT " . ($page - 1) * $row . " ,{$row}"); $blogcount = POD::queryCount("SELECT blogid FROM `{$database['prefix']}BlogSettings` WHERE name = 'name'"); $pages = (int) (($blogcount - 0.5) / $row) + 1; if ($pages < $page) { printRespond(array('error' => -2, 'result' => $pages)); } if ($bloglist) { $tempString = ""; foreach ($bloglist as $itemBlogId) { $result = POD::queryAll("SELECT * FROM `{$database['prefix']}BlogSettings` WHERE blogid = {$itemBlogId}"); foreach ($result as $row) { $bsetting[$row['name']] = $row['value']; } $bsetting['owner'] = POD::queryCell("SELECT userid FROM `{$database['prefix']}Privileges` WHERE acl & " . BITWISE_OWNER . " != 0 AND blogid = " . $itemBlogId); ?> <tr id="table-blog-list_<?php echo $itemBlogId; ?> "> <td> <?php echo $itemBlogId; ?> </td> <td> <a href="<?php echo $context->getProperty('uri.blog'); ?> /control/blog/detail/<?php
function changeACLofUser($blogid, $userid, $ACLtype, $switch) { // Change user priviledge on the blog. global $database; if (empty($ACLtype) || empty($userid)) { return false; } $acl = POD::queryCell("SELECT acl\n\t\t\t\tFROM {$database['prefix']}Privileges\n\t\t\t\tWHERE blogid={$blogid} and userid={$userid}"); if ($acl === null) { // If there is no ACL, add user into the blog. $name = User::getName($userid); POD::query("INSERT INTO {$database['prefix']}Privileges\n\t\t\t\t\tVALUES({$blogid}, {$userid}, 0, UNIX_TIMESTAMP(), 0)"); $acl = 0; } $bitwise = null; switch ($ACLtype) { case 'admin': $bitwise = BITWISE_ADMINISTRATOR; break; case 'editor': $bitwise = BITWISE_EDITOR; break; default: return false; } if ($switch) { $acl |= $bitwise; } else { $acl &= ~$bitwise; } return POD::execute("UPDATE {$database['prefix']}Privileges\n\t\t\tSET acl = " . $acl . "\n\t\t\tWHERE blogid = " . $blogid . " and userid = " . $userid); }
function changePassword($userid, $pwd, $prevPwd, $forceChange = false) { $pool = DBModel::getInstance(); $pool->reset('UserSettings'); $ctx = Model_Context::getInstance(); if (!strlen($pwd) || !strlen($prevPwd) && !$forceChange) { return false; } if ($forceChange === true) { $pwd = md5($pwd); $pool->reset('UserSettings'); $pool->setQualifier('userid', 'eq', $userid); $pool->setQualifier('name', 'eq', 'AuthToken', true); @$pool->delete(1); $pool->reset('Users'); $pool->setAttribute('password', $pwd, true); $pool->setQualifier('userid', 'eq', $userid); return $pool->update(); } if (strlen($prevPwd) == 32 && preg_match('/[0-9a-f]/i', $prevPwd)) { $secret = '(password = \'' . md5($prevPwd) . "' OR password = '******')"; } else { $secret = 'password = \'' . md5($prevPwd) . '\''; } $count = POD::queryCell("SELECT count(*) FROM " . $ctx->getProperty('database.prefix') . "Users WHERE userid = {$userid} AND {$secret}"); if ($count == 0) { return false; } $pwd = md5($pwd); $pool->reset('UserSettings'); $pool->setQualifier('userid', 'eq', $userid); $pool->setQualifier('name', 'eq', 'AuthToken', true); @$pool->delete(1); $pool->reset('Users'); $pool->setQualifier('userid', 'eq', $userid); $pool->setAttribute('password', $pwd, true); return $pool->update(); }
function getTrackBacksNextId() { global $database; $maxId = POD::queryCell("SELECT max(id) FROM {$database['prefix']}Trackbacks WHERE blogid = " . getBlogId()); return empty($maxId) ? 1 : $maxId + 1; }
function updateRandomFeed() { global $database; $updatecycle = POD::queryCell("SELECT updatecycle FROM {$database['prefix']}FeedSettings LIMIT 1"); if ($updatecycle != 0) { if ($feed = POD::queryRow("SELECT * FROM {$database['prefix']}Feeds WHERE modified < " . (gmmktime() - $updatecycle * 60) . " ORDER BY RAND() LIMIT 1")) { Setting::setServiceSetting('lastFeedUpdate', gmmktime(), true); return array(updateFeed($feed), $feed['xmlurl']); } } return array(1, 'No feeds to update'); }
static function setTotalStatistics($blogid) { global $database; POD::execute("DELETE FROM {$database['prefix']}DailyStatistics WHERE blogid = {$blogid}"); $prevCount = POD::queryCell("SELECT visits FROM {$database['prefix']}BlogStatistics WHERE blogid = {$blogid}"); if (!is_null($prevCount) && $prevCount == 0) { return true; } if (POD::execute("UPDATE {$database['prefix']}BlogStatistics SET visits = 0 WHERE blogid = {$blogid}")) { return true; } else { $result = POD::execute("INSERT INTO {$database['prefix']}BlogStatistics values({$blogid}, 0)"); return $result; } }
function getCommentsNotifiedSiteInfoMaxId() { global $database; $maxId = POD::queryCell("SELECT max(id)\n\t\tFROM {$database['prefix']}CommentsNotifiedSiteInfo"); return empty($maxId) ? 0 : $maxId; }
function deleteTagById($blogid, $id) { global $database; /// delete relation $result = POD::execute('DELETE FROM ' . $database['prefix'] . 'TagRelations WHERE blogid = ' . $blogid . ' AND tag = ' . $id); if (!$result) { return false; } $count = POD::queryCell('SELECT COUNT(*) FROM ' . $database['prefix'] . 'TagRelations WHERE tag = ' . $id); if (intval($count) == 0) { POD::execute('DELETE FROM ' . $database['prefix'] . 'Tags WHERE id = ' . $id); } return true; }
function getNextLinkCategoryPid($id = 0) { global $database; $maxId = POD::queryCell("SELECT MAX(pid) FROM {$database['prefix']}LinkCategories"); if ($id == 0) { return $maxId + 1; } else { return $maxId > $id ? $maxId + 1 : $id; } }
function load() { global $database; $result = POD::queryCell("SELECT value FROM {$database['prefix']}PageCacheLog WHERE blogid = " . $this->_gBlogId . " AND name = 'globalCacheStorage'"); if (isset($result)) { $this->_gCacheStorage[$this->_gBlogId] = unserialize($result); } }
$errorMessage = _t('슬래시가 들어간 카테고리 이름은 사용할 수 없습니다'); /*} elseif ((!empty($_POST['newCategory']) && strpos($_POST['newCategory'], '&') !== false) || (!empty($_POST['modifyCategoryName']) && strpos($_POST['modifyCategoryName'], '&') !== false)) { $history = ''; $errorMessage = _t('앰퍼샌드(&)가 들어간 카테고리 이름은 사용할 수 없습니다');*/ } elseif (!empty($_POST['newCategory']) && strpos($_POST['newCategory'], '?') !== false || !empty($_POST['modifyCategoryName']) && strpos($_POST['modifyCategoryName'], '?') !== false) { $history = ''; $errorMessage = _t('물음표가 들어간 카테고리 이름은 사용할 수 없습니다'); } elseif (!empty($_POST['newCategory'])) { $history = addCategory($blogid, $selected == 0 ? null : $_POST['id'], trim($_POST['newCategory'])) ? 'document.getElementById("newCategory").select();' : ''; if (empty($history)) { $errorMessage = _t('같은 이름의 카테고리가 이미 존재합니다'); } } else { if (!empty($_POST['modifyCategoryName']) || !empty($_POST['modifyCategoryBodyId'])) { $history = modifyCategory($blogid, $_POST['id'], trim($_POST['modifyCategoryName']), trim($_POST['modifyCategoryBodyId'])) ? 'document.getElementById("modifyCategoryName").select();' : ''; $tempParentId = POD::queryCell("SELECT `parent` FROM `{$database['prefix']}Categories` WHERE `id` = {$_POST['id']} AND `blogid` = " . getBlogId()); if (preg_match('/^[0-9]+$/', $tempParentId, $temp)) { $depth = 2; } else { $depth = 1; } } else { $history = ''; } } $categories = getCategories($blogid); $name = getCategoryNameById($blogid, $selected) ? getCategoryNameById($blogid, $selected) : _t('전체'); $bodyid = getCategoryBodyIdById($blogid, $selected); if (empty($_POST['search']) || $searchColumn === true) { $searchParam = true; } else {
function PN_Blog_Statistics_Default() { global $database, $blogid, $defaultURL, $blogURL, $pluginURL, $pluginMenuURL, $configVal; requireComponent('Textcube.Model.Statistics'); requireComponent('Textcube.Function.misc'); $data = misc::fetchConfigVal($configVal); if (is_null($data)) { $data['privateChk'] = 2; } $getVisibility = $data['privateChk'] == 2 ? " AND visibility > 0 " : ""; $stats = Statistics::getStatistics($blogid); $getDate = isset($_GET['date']) ? $_GET['date'] : date('Y', strtotime("now")); $getMenu = isset($_GET['menu']) ? $_GET['menu'] : "entry"; $getYear = substr($getDate, 0, 4); $getMonth = substr($getDate, 4); $yearRow = POD::queryAll("SELECT EXTRACT(YEAR FROM FROM_UNIXTIME(published)) period, COUNT(*) count FROM {$database['prefix']}Entries WHERE blogid = {$blogid} AND draft = 0 {$getVisibility} AND category >= 0 GROUP BY period ORDER BY period DESC"); $yearCell = POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}Entries WHERE blogid = {$blogid} AND draft = 0 {$getVisibility} AND category >= 0 AND EXTRACT(YEAR FROM FROM_UNIXTIME(published)) = '" . date('Y', strtotime("now")) . "'"); $yearAll = POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}Entries WHERE blogid = {$blogid} AND draft = 0 {$getVisibility} AND category >= 0"); $yearSelect = "<select id=\"yearSelect\" onchange=\"execDate(this);\">\n"; $yearSelect .= "<option value=\"\">" . _t(' - 년 도 -') . "</option>\n"; $selected = $getYear == 9999 ? " selected" : ""; $yearSelect .= "<option value=\"9999\" style=\"font-weight:bold;\" {$selected}>" . _t('#전체') . "({$yearAll})</option>\n"; if (!$yearCell) { $selected = $getYear == date('Y', strtotime("now")) ? " selected" : ""; $yearSelect .= "<option value=\"" . date('Y', strtotime("now")) . "\" {$selected}>" . date('Y', strtotime("now")) . _t('년') . "(0)</option>\n"; } foreach ($yearRow as $items) { $selected = $getYear == $items['period'] ? " selected" : ""; $yearSelect .= "<option value=\"{$items['period']}\" {$selected}>{$items['period']}" . _t('년') . "({$items['count']})</option>\n"; } $yearSelect .= "</select>\n"; $monthSelect = "<select id=\"monthSelect\" onchange=\"execDate(this);\">\n"; $monthSelect .= "<option value=\"\">- " . _t('월') . " -</option>\n"; $monthSelect .= "<option value=\"{$getYear}\" " . (strlen($getDate) == 4 ? " selected" : "") . ">" . _t('#전체') . "</option>\n"; for ($i = 1; $i <= 12; $i++) { $gMonth = strlen($i) == 1 ? "0" . $i : $i; $gValue = $getYear . $gMonth; $selected = $getMonth == $gMonth ? " selected" : ""; $monthSelect .= "<option value=\"{$gValue}\" {$selected}>" . $gMonth . _t('월') . "</option>\n"; } $monthSelect .= "</select>\n"; $noticeRow = POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}Entries WHERE blogid = {$blogid} AND draft = 0 {$getVisibility} AND category = -2"); //공지 $keywordRow = POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}Entries WHERE blogid = {$blogid} AND draft = 0 {$getVisibility} AND category = -1"); //키워드 ?> <script type="text/javascript"> //<![CDATA[ function execLoadFunction() { tempDiv = document.createElement("DIV"); tempDiv.style.clear = "both"; document.getElementById("part-statistics-blog").appendChild(tempDiv); } function execDate(selectObject){ if(selectObject.options[selectObject.selectedIndex].value){ location.href="<?php echo $pluginMenuURL; ?> &date="+selectObject.options[selectObject.selectedIndex].value+"&menu=<?php echo $getMenu; ?> "; } } window.addEventListener("load", execLoadFunction, false); //]]> </script> <div id="part-statistics-blog" class="part"> <h2 class="caption"><span class="main-text"><?php echo _t('블로그 통계정보를 보여줍니다'); ?> </span></h2> <div id="statistics-main"> <div id="statistics-counter-inbox"> <div class="title"><h3><?php echo _t('종 합 정 보'); ?> </h3></div> <table width="100%"> <tbody> <tr class="tr"> <td colspan="2"><?php echo _t('년/월별 선택'); ?> <br /> <?php echo $yearSelect; ?> <?php echo $monthSelect; ?> </td> </tr> <tr height="5"><td colspan="2"></td></tr> <tr height="1" bgcolor="#dddddd"><td colspan="2"></td></tr> <tr class="tr"> <td><?php echo _t('오늘 방문자'); ?> </td> <th><?php echo number_format($stats['today']); ?> </th> </tr> <tr class="tr"> <td><?php echo _t('어제 방문자'); ?> </td> <th><?php echo number_format($stats['yesterday']); ?> </th> </tr> <tr class="tr"> <td><?php echo _t('총 방문자'); ?> </td> <th><?php echo number_format($stats['total']); ?> </th> </tr> <tr height="1" bgcolor="#dddddd"><td colspan="2"></td></tr> <tr class="tr"> <td><?php echo _t('글 개수'); ?> </td> <th><?php echo number_format(getEntriesTotalCountDB($blogid)); ?> </th> </tr> <tr class="tr"> <td><?php echo _t('공지 개수'); ?> </td> <th><?php echo number_format($noticeRow); ?> </th> </tr> <tr class="tr"> <td><?php echo _t('키워드 개수'); ?> </td> <th><?php echo number_format($keywordRow); ?> </th> </tr> <tr class="tr"> <td><?php echo _t('댓글 개수'); ?> </td> <th><?php echo number_format(getCommentCountDB($blogid)); ?> </th> </tr> <tr class="tr"> <td><?php echo _t('방명록 개수'); ?> </td> <th><?php echo number_format(getGuestbookCountDB($blogid)); ?> </th> </tr> <tr class="tr"> <td><?php echo _t('트랙백 개수'); ?> </td> <th><?php echo number_format(getTrackbackCountDB($blogid)); ?> </th> </tr> <tr height="10"><td colspan="2"></td></tr> </tbody> </table> <div class="title"><h3><?php echo _t('세 부 메 뉴'); ?> </h3></div> <table width="100%"> <tbody> <tr class="tr"> <td> » <a href="<?php echo $pluginMenuURL; ?> &date=<?php echo $getDate; ?> &menu=entry"><?php echo _get_t(_t('글(포스트) 통계'), 'entry'); ?> </a></td> </tr> <tr class="tr"> <td> » <a href="<?php echo $pluginMenuURL; ?> &date=<?php echo $getDate; ?> &menu=comment"><?php echo _get_t(_t('댓글 통계'), 'comment'); ?> </a></td> </tr> <tr class="tr"> <td> - <a href="<?php echo $pluginMenuURL; ?> &date=<?php echo $getDate; ?> &menu=commenter"><?php echo _get_t(_t('작성자 목록'), 'commenter'); ?> </a></td> </tr> <tr class="tr"> <td> » <a href="<?php echo $pluginMenuURL; ?> &date=<?php echo $getDate; ?> &menu=trackback"><?php echo _get_t(_t('트랙백 통계'), 'trackback'); ?> </a></td> </tr> <tr class="tr"> <td> » <a href="<?php echo $pluginMenuURL; ?> &date=<?php echo $getDate; ?> &menu=guestbook"><?php echo _get_t(_t('방명록 통계'), 'guestbook'); ?> </a></td> </tr> <tr class="tr"> <td> - <a href="<?php echo $pluginMenuURL; ?> &date=<?php echo $getDate; ?> &menu=guestbookcommenter"><?php echo _get_t(_t('작성자 목록'), 'guestbookcommenter'); ?> </a></td> </tr> <tr class="tr"> <td> » <a href="<?php echo $pluginMenuURL; ?> &date=<?php echo $getDate; ?> &menu=tag"><?php echo _get_t(_t('태그 통계'), 'tag'); ?> </a></td> </tr> <tr class="tr"> <td> » <a href="<?php echo $pluginMenuURL; ?> &date=<?php echo $getDate; ?> &menu=visit"><?php echo _get_t(_t('방문자 통계'), 'visit'); ?> </a></td> </tr> <tr class="tr"> <td> » <a href="<?php echo $pluginMenuURL; ?> &date=<?php echo $getDate; ?> &menu=referer"><?php echo _get_t(_t('리퍼러 통계'), 'referer'); ?> </a></td> </tr> </tbody> </table> </div> <div id="statistics-inbox"> <?php //############################## // 글(포스트) 통계 ######### //############################## if ($getMenu == "entry") { if ($getYear == 9999 && !$getMonth) { $getData = array(); $getTags = array(); $getDateTitle = _t('전체 년도별'); $tempData = getStatisticsDB('years', '', $getMenu); foreach ($tempData as $item) { array_push($getData, $item['count']); array_push($getTags, rawurlencode($item['period'] . _t('년'))); } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 1); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('글(포스트) 통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> YearStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> YearPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=archiveYear&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php } $getData = array(); $getTags = array(); if ($getYear == 9999) { $getDateTitle = !$getMonth ? _t('전체') : _t('전체') . ' ' . $getMonth . _t('월'); } else { $getDateTitle = !$getMonth ? $getYear . _t('년도') : $getYear . _t('년도') . $getMonth . _t('월'); } if (!$getMonth) { $lastCount = 12; $textValue = _t('월'); } else { $lastCount = $getYear == 9999 ? 31 : date('t', mktime(0, 0, 0, $getMonth, 1, $getYear)); $textValue = ""; } for ($i = 1; $i <= $lastCount; $i++) { $tempData = getStatisticsDB($getDate, $i, $getMenu); if ($tempData) { array_push($getData, $tempData['count']); array_push($getTags, rawurlencode($i . $textValue)); } } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 1); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('글(포스트) 통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> Stic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td align="right"> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> Pizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=archiveMonth&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php if (!$getMonth) { $getData = array(); $getTags = array(); for ($i = 1; $i <= 4; $i++) { $tempData = getQuartersStatistics($getDate, $i, $getMenu); if ($tempData) { array_push($getData, $tempData); array_push($getTags, rawurlencode($i . "/4 " . _t('분기'))); } } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('분기별') . _t('글(포스트) 통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> QuartersStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> QuartersPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php } $getData = array(); $getTags = array(); $tempData = getCategoryStatistics(); $itemCnt = getCategoryStatisticsTotal(0, $getDate); if ($itemCnt) { array_push($getData, $itemCnt); array_push($getTags, $item['id']); } foreach ($tempData as $item) { $itemCnt = getCategoryStatisticsTotal($item['id'], $getDate); if ($itemCnt) { array_push($getData, $itemCnt); array_push($getTags, $item['id']); } } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('카테고리별') . _t('글(포스트) 통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> CategoryStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=category&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> CategoryPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=category&grpYear=" . $getYear . "&grpTypeName=category&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php $query = "SELECT * FROM {$database['prefix']}Entries_hits"; if (POD::queryRow($query)) { $getData = array(); $getTags = array(); $tempData = getEntryHitsStatistics($getDate); foreach ($tempData as $item) { array_push($getData, $item['hits']); array_push($getTags, $item['id']); } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('조회수 TOP 10') . _t('글(포스트) 통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> HitsStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=hits&grpXLabelType=2&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> HitsPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=entry&grpYear=" . $getYear . "&grpTypeName=hits&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php } $getData = array(); $getTags = array(); for ($i = 0; $i <= 23; $i++) { $tempData = getTimeStatistics($getDate, $i, $getMenu); if ($tempData) { if ($tempData['period'] == "00") { $tempData['period'] = str_replace("00", "0", $tempData['period']); } else { if (substr($tempData['period'], 0, 1) == "0") { $tempData['period'] = str_replace("0", "", $tempData['period']); } } array_push($getData, $tempData['count']); array_push($getTags, $tempData['period']); } } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('시간대별') . _t('글(포스트) 통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> TimeStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=time&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> TimePizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=time&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <hr class="hidden" /> <?php } else { if ($getMenu == "comment") { //############################## // 댓글 통계 ################### //############################## if ($getYear == 9999 && !$getMonth) { $getData = array(); $getTags = array(); $getDateTitle = _t('전체 년도별'); $tempData = getStatisticsDB('years', '', $getMenu); foreach ($tempData as $item) { array_push($getData, $item['count']); array_push($getTags, rawurlencode($item['period'] . _t('년'))); } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('댓글 통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> YearStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> YearPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php } $getData = array(); $getTags = array(); if ($getYear == 9999) { $getDateTitle = !$getMonth ? _t('전체') : _t('전체') . ' ' . $getMonth . _t('월'); } else { $getDateTitle = !$getMonth ? $getYear . _t('년도') : $getYear . _t('년도') . $getMonth . _t('월'); } if (!$getMonth) { $lastCount = 12; $textValue = _t('월'); } else { $lastCount = $getYear == 9999 ? 31 : date('t', mktime(0, 0, 0, $getMonth, 1, $getYear)); $textValue = ""; } for ($i = 1; $i <= $lastCount; $i++) { $tempData = getStatisticsDB($getDate, $i, $getMenu); if ($tempData) { array_push($getData, $tempData['count']); array_push($getTags, rawurlencode($i . $textValue)); } } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('댓글 통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> Stic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> Pizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php if (!$getMonth) { $getData = array(); $getTags = array(); for ($i = 1; $i <= 4; $i++) { $tempData = getQuartersStatistics($getYear, $i, $getMenu); if ($tempData) { array_push($getData, $tempData); array_push($getTags, rawurlencode($i . "/4 " . _t('분기'))); } } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('분기별') . _t('댓글 통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> QuartersStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> QuartersPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php } $getData = array(); $getTags = array(); $tempData = getCommentEntryMaxCount($getDate); foreach ($tempData as $item) { array_push($getData, $item['comments']); array_push($getTags, $item['id']); } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('댓글 TOP 10') . _t('글 통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> EntryMaxStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=cmmax&grpXLabelType=2&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> EntryMaxPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=entry&grpYear=" . $getYear . "&grpTypeName=cmmax&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php $getData = array(); $getTags = array(); $tempData = getCommenterMaxCount($getDate, $getMenu); foreach ($tempData as $item) { array_push($getData, $item['namecnt']); array_push($getTags, rawurlencode($item['name'])); } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('댓글자 TOP 10') . _t('통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> erMaxStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=commenter&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> erMaxPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php $getData = array(); $getTags = array(); for ($i = 0; $i <= 23; $i++) { $tempData = getTimeStatistics($getDate, $i, $getMenu); if ($tempData) { if ($tempData['period'] == "00") { $tempData['period'] = str_replace("00", "0", $tempData['period']); } else { if (substr($tempData['period'], 0, 1) == "0") { $tempData['period'] = str_replace("0", "", $tempData['period']); } } array_push($getData, $tempData['count']); array_push($getTags, $tempData['period']); } } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('시간대별') . _t('댓글 통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> TimeStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=time&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> TimePizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=time&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <hr class="hidden" /> <?php } else { if ($getMenu == "commenter") { //############################## // 댓글 작성자 목록 ############ //############################## if ($getYear == 9999) { $getDateTitle = !$getMonth ? _t('전체') : _t('전체') . ' ' . $getMonth . _t('월'); } else { $getDateTitle = !$getMonth ? $getYear . _t('년도') : $getYear . _t('년도') . $getMonth . _t('월'); } $tempData = getCommenterMaxCount($getDate, $getMenu); $tempAllCount = getCommenterMaxCount(9999, $getMenu); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('댓글') . _t('작성자') . _t('목록'); ?> (<?php echo number_format(count($tempData)) . "/" . number_format(count($tempAllCount)); echo _t('명'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div id="commenterList"> <?php $i = 0; foreach ($tempData as $item) { $guestname = htmlspecialchars(UTF8::lessenAsEm($item['name'], 20)); if (!empty($item['home'])) { $homepage = ereg('^[[:alnum:]]+:', $item['home']) ? htmlspecialchars($item['home']) : "http://" . htmlspecialchars($item['home']); $guestname = "<a href=\"{$homepage}\" onclick=\"window.open(this.href); return false;\">{$guestname}</a>"; } $count = "<span class=\"count\">(" . $item['namecnt'] . ")</span>"; ?> <div class="userlist"><?php echo $guestname; ?> <?php echo $count; ?> </div><?php if ($i % 4 == 3) { echo "<div class=\"clear\"></div>\n"; } $i++; } ?> </div> </td> </tr> </tbody> </table> <hr class="hidden" /> <?php } else { if ($getMenu == "trackback") { //############################## // 역인글 통계 ################# //############################## if ($getYear == 9999 && !$getMonth) { $getData = array(); $getTags = array(); $getDateTitle = _t('전체 년도별'); $tempData = getStatisticsDB('years', '', $getMenu); foreach ($tempData as $item) { array_push($getData, $item['count']); array_push($getTags, rawurlencode($item['period'] . _t('년'))); } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> 트랙백 통계(<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> YearStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> YearPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php } $getData = array(); $getTags = array(); if ($getYear == 9999) { $getDateTitle = !$getMonth ? _t('전체') : _t('전체') . ' ' . $getMonth . _t('월'); } else { $getDateTitle = !$getMonth ? $getYear . _t('년도') : $getYear . _t('년도') . $getMonth . _t('월'); } if (!$getMonth) { $lastCount = 12; $textValue = _t('월'); } else { $lastCount = $getYear == 9999 ? 31 : date('t', mktime(0, 0, 0, $getMonth, 1, $getYear)); $textValue = ""; } for ($i = 1; $i <= $lastCount; $i++) { $tempData = getStatisticsDB($getDate, $i, $getMenu); if ($tempData) { array_push($getData, $tempData['count']); array_push($getTags, rawurlencode($i . $textValue)); } } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('트랙백') . _t('통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> Stic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> Pizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php if (!$getMonth) { $getData = array(); $getTags = array(); for ($i = 1; $i <= 4; $i++) { $tempData = getQuartersStatistics($getYear, $i, $getMenu); if ($tempData) { array_push($getData, $tempData); array_push($getTags, rawurlencode($i . "/4 " . _t('분기'))); } } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('분기별') . _t('트랙백') . _t('통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> QuartersStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> QuartersPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php } $getData = array(); $getTags = array(); $getLink = array(); $tempData = getTrackbackEntryMaxCount($getDate); foreach ($tempData as $item) { array_push($getData, $item['trackbacks']); array_push($getTags, $item['id']); } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('트랙백') . _t('받은 TOP 10') . _t('글 통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> EntryMaxStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=tbmax&grpXLabelType=2&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> EntryMaxPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=entry&grpYear=" . $getYear . "&grpTypeName=tbmax&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php $getData = array(); $getTags = array(); $tempData = getTrackbackCallEntryMaxCount($getDate); foreach ($tempData as $item) { array_push($getData, $item['trackbacklogs']); array_push($getTags, $item['id']); } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('트랙백') . _t('보낸 TOP 10') . _t('글 통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> CallEntryMaxStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=cmmax&grpXLabelType=2&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> CallEntryMaxPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=entry&grpYear=" . $getYear . "&grpTypeName=cmmax&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php $getData = array(); $getTags = array(); for ($i = 0; $i <= 23; $i++) { $tempData = getTimeStatistics($getDate, $i, $getMenu); if ($tempData) { if ($tempData['period'] == "00") { $tempData['period'] = str_replace("00", "0", $tempData['period']); } else { if (substr($tempData['period'], 0, 1) == "0") { $tempData['period'] = str_replace("0", "", $tempData['period']); } } array_push($getData, $tempData['count']); array_push($getTags, $tempData['period']); } } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('시간대별') . _t('트랙백') . _t('통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> TimeStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=time&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> TimePizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=time&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <hr class="hidden" /> <?php } else { if ($getMenu == "guestbook") { //############################## // 방명록 통계 ################# //############################## if ($getYear == 9999 && !$getMonth) { $getData = array(); $getTags = array(); $getDateTitle = _t('전체 년도별'); $tempData = getStatisticsDB('years', '', $getMenu); foreach ($tempData as $item) { array_push($getData, $item['count']); array_push($getTags, rawurlencode($item['period'] . _t('년'))); } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('방명록') . _t('통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> YearStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> YearPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php } $getData = array(); $getTags = array(); if ($getYear == 9999) { $getDateTitle = !$getMonth ? _t('전체') : _t('전체') . ' ' . $getMonth . _t('월'); } else { $getDateTitle = !$getMonth ? $getYear . _t('년도') : $getYear . _t('년도') . $getMonth . _t('월'); } if (!$getMonth) { $lastCount = 12; $textValue = _t('월'); } else { $lastCount = $getYear == 9999 ? 31 : date('t', mktime(0, 0, 0, $getMonth, 1, $getYear)); $textValue = ""; } for ($i = 1; $i <= $lastCount; $i++) { $tempData = getStatisticsDB($getDate, $i, $getMenu); if ($tempData) { array_push($getData, $tempData['count']); array_push($getTags, rawurlencode($i . $textValue)); } } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('방명록') . _t('통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> Stic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> Pizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php if (!$getMonth) { $getData = array(); $getTags = array(); for ($i = 1; $i <= 4; $i++) { $tempData = getQuartersStatistics($getYear, $i, $getMenu); if ($tempData) { array_push($getData, $tempData); array_push($getTags, rawurlencode($i . "/4 " . _t('분기'))); } } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('분기별') . _t('방명록') . _t('통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> QuartersStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> QuartersPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php } $getData = array(); $getTags = array(); $tempData = getCommenterMaxCount($getDate, $getMenu); foreach ($tempData as $item) { array_push($getData, $item['namecnt']); array_push($getTags, rawurlencode($item['name'])); } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('방명록') . _t('댓글자 TOP 10') . _t('통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> CommenterMaxStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=commenter&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> CommenterMaxPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php $getData = array(); $getTags = array(); for ($i = 0; $i <= 23; $i++) { $tempData = getTimeStatistics($getDate, $i, $getMenu); if ($tempData) { if ($tempData['period'] == "00") { $tempData['period'] = str_replace("00", "0", $tempData['period']); } else { if (substr($tempData['period'], 0, 1) == "0") { $tempData['period'] = str_replace("0", "", $tempData['period']); } } array_push($getData, $tempData['count']); array_push($getTags, $tempData['period']); } } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('시간대별') . _t('방명록') . _t('통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> TimeStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=time&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> TimePizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=time&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <hr class="hidden" /> <?php } else { if ($getMenu == "guestbookcommenter") { //############################## // 방명록 작성자 목록 ############ //############################## if ($getYear == 9999) { $getDateTitle = !$getMonth ? _t('전체') : _t('전체') . ' ' . $getMonth . _t('월'); } else { $getDateTitle = !$getMonth ? $getYear . _t('년도') : $getYear . _t('년도') . $getMonth . _t('월'); } $tempData = getCommenterMaxCount($getDate, $getMenu); $tempAllCount = getCommenterMaxCount(9999, $getMenu); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('방명록') . _t('작성자') . _t('목록'); ?> (<?php echo number_format(count($tempData)) . "/" . number_format(count($tempAllCount)); ?> 명)</h3></th> </tr> </thead> <tbody> <tr> <td> <div id="commenterList"> <?php $i = 0; foreach ($tempData as $item) { $guestname = htmlspecialchars(UTF8::lessenAsEm($item['name'], 20)); if (!empty($item['home'])) { $homepage = ereg('^[[:alnum:]]+:', $item['home']) ? htmlspecialchars($item['home']) : "http://" . htmlspecialchars($item['home']); $guestname = "<a href=\"{$homepage}\" onclick=\"window.open(this.href); return false;\">{$guestname}</a>"; } $count = "<span class=\"count\">(" . $item['namecnt'] . ")</span>"; ?> <div class="userlist"><?php echo $guestname; ?> <?php echo $count; ?> </div><?php if ($i % 4 == 3) { echo "<div class=\"clear\"></div>\n"; } $i++; } ?> </div> </td> </tr> </tbody> </table> <hr class="hidden" /> <?php } else { if ($getMenu == "tag") { //############################## // 태그 통계 ################### //############################## $getDateTitle = !$getMonth ? $getYear . _t('년도') : $getYear . _t('년도') . $getMonth . _t('월'); $getData = array(); $getTags = array(); $tempData = getTagMaxCount(); foreach ($tempData as $item) { array_push($getData, $item['count']); array_push($getTags, rawurlencode($item['name'])); } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 1); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo _t('인기') . _t('태그 TOP 10') . _t('통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> MaxStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=tag&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> MaxPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=tag&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php $getData = array(); $getTags = array(); if ($getYear == 9999) { $getDateTitle = !$getMonth ? _t('전체') : _t('전체') . ' ' . $getMonth . _t('월'); } else { $getDateTitle = !$getMonth ? $getYear . _t('년도') : $getYear . _t('년도') . $getMonth . _t('월'); } $tempData = getTagEntryMaxCount($getDate, 1); foreach ($tempData as $item) { array_push($getData, $item['count']); array_push($getTags, $item['id']); } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('태그') . _t('걸린 TOP 10') . _t('글 통계'); ?> (<?php echo number_format(getTagEntryMaxCount($getDate, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> EntryMaxStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=tagmax&grpXLabelType=2&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> EntryMaxPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=entry&grpYear=" . $getYear . "&grpTypeName=tagmax&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <hr class="hidden" /> <?php } else { if ($getMenu == "visit") { //############################## // 방문자 통계 ################# //############################## if ($getYear == 9999 && !$getMonth) { $getData = array(); $getTags = array(); $getDateTitle = _t('전체 년도별'); $tempData = getStatisticsDB('years', '', $getMenu); foreach ($tempData as $item) { array_push($getData, $item['count']); array_push($getTags, rawurlencode($item['period'] . _t('년'))); } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('방문자') . _t('통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> YearStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> YearPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php } $getData = array(); $getTags = array(); if ($getYear == 9999) { $getDateTitle = !$getMonth ? _t('전체') : _t('전체') . ' ' . $getMonth . _t('월'); } else { $getDateTitle = !$getMonth ? $getYear . _t('년도') : $getYear . _t('년도') . $getMonth . _t('월'); } if (!$getMonth) { $lastCount = 12; $textValue = _t('월'); } else { $lastCount = $getYear == 9999 ? 31 : date('t', mktime(0, 0, 0, $getMonth, 1, $getYear)); $textValue = ""; } for ($i = 1; $i <= $lastCount; $i++) { $tempData = getStatisticsDB($getDate, $i, $getMenu); if ($tempData) { array_push($getData, $tempData['count']); array_push($getTags, rawurlencode($i . $textValue)); } } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('방문자') . _t('통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> Stic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> Pizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php if (!$getMonth) { $getData = array(); $getTags = array(); for ($i = 1; $i <= 4; $i++) { $tempData = getQuartersStatistics($getYear, $i, $getMenu); if ($tempData) { array_push($getData, $tempData); array_push($getTags, rawurlencode($i . "/4 " . _t('분기'))); } } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 0); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo $getDateTitle; ?> <?php echo _t('분기별') . _t('방문자') . _t('통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 0)) . "/" . number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> QuartersStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> QuartersPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <hr class="hidden" /> <hr class="hidden" /> <?php } } else { if ($getMenu == "referer") { //############################## // 리퍼러 통계 ################# //############################## $getData = array(); $getTags = array(); $tempData = getRefererMaxCount(); foreach ($tempData as $item) { array_push($getData, $item['count']); array_push($getTags, rawurlencode($item['host'])); } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = getStatisticsTotalDB($getDate, $getMenu, 1); ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo _t('리퍼러') . _t('TOP 10') . _t('통계'); ?> (<?php echo number_format(getStatisticsTotalDB($getDate, $getMenu, 1)); echo _t('개'); ?> )</h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> MaxStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=refer&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> MaxPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php $getData = array(); $getTags = array(); $getDuplicate = array(); $beforCount = ""; $tempData = getRefererKeywordStatistics(); foreach ($tempData as $item) { if ($item['count'] != $beforCount) { $beforCount = $item['count']; } else { array_push($getDuplicate, $item['count']); } } $getDuplicate = array_count_values($getDuplicate); $beforCount = ""; foreach ($tempData as $item) { if ($item['count'] != $beforCount && $item['rank'] < 11) { array_push($getData, $item['count']); $duplicateCount = $getDuplicate[$item['count']] ? _f("(외 %1 개)", $getDuplicate[$item['count']]) : _f("(외 %1 개)", 0); array_push($getTags, rawurlencode(htmlspecialchars(UTF8::lessenAsEm($item['keyword'], 15)) . $duplicateCount)); $beforCount = $item['count']; } } $getData = implode("|", $getData); $getTags = implode("|", $getTags); $getTotal = $tempData[0]['total']; ?> <table class="data-inbox" cellspacing="0" cellpadding="0"> <thead> <tr> <th colspan="2"><h3><?php echo _t('리퍼러') . _t('키워드 TOP 10') . _t('통계'); ?> (<?php echo number_format($tempData[0]['total']); echo _t('개'); ?> ) : <?php echo $tempData[0]['dateStart']; ?> ~ <?php echo $tempData[0]['dateEnd']; ?> </h3></th> </tr> </thead> <tbody> <tr> <td> <div class="flash-stic"> <div id="get<?php echo $getMenu; ?> KeywordMaxStic"> <?php echo open_flash_chart_object(470, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=bar&grpTypeName=referkey&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_bar" : "")); ?> </div> </div> </td> <td> <div class="flash-pizza"> <div id="get<?php echo $getMenu; ?> KeywordMaxPizza"> <?php echo open_flash_chart_object(265, 250, $blogURL . "/plugin/BlogStatisticsProcess/?grpStyle=pie&grpLinkType=&grpYear=" . $getYear . "&grpTypeName=&grpData=" . $getData . "&grpTotal=" . $getTotal . "&grpLabel=" . $getTags . (empty($getData) ? "&grpNoData_pie" : "")); ?> </div> </div> </td> </tr> </tbody> </table> <?php } } } } } } } } } ?> </div> </div> </div> <?php }
function getEntryIdBySlogan($blogid, $slogan) { global $database; $result = POD::queryCell("SELECT id\n\t\tFROM {$database['prefix']}Entries \n\t\tWHERE blogid = {$blogid} \n\t\t\tAND slogan = '" . POD::escapeString($slogan) . "'"); if (!$result) { return false; } else { return $result; } }
function _getMaxId() { global $database; $maxId = POD::queryCell("SELECT max(id) FROM {$database['prefix']}Tags"); if ($maxId) { return $maxId; } else { return 0; } }
static function fetch($sqlmodel, $page, $count, $url = null, $prefix = '?page=', $countItem = null, $onclick = null) { $context = Model_Context::getInstance(); if ($url === null) { $url = $context->getProperty('uri.folder'); } $paging = array('url' => $url, 'prefix' => $prefix, 'postfix' => '', 'onclick' => $onclick); if (empty($sqlmodel)) { return array(array(), $paging); } if (gettype($sqlmodel) == "object" && get_class($sqlmodel) == "DBModel") { // It's DBModel. $isDBModel = true; } else { // It's SQL $isDBModel = false; } if ($isDBModel) { $order = $sqlmodel->getOrder(); $sqlmodel->unsetOrder(); $paging['total'] = $sqlmodel->getSize(); // get record size $sqlmodel->setOrder($order['attribute'], $order['order']); } else { // It's SQL if (preg_match('/\\s(FROM.*)(ORDER BY.*)$/si', $sqlmodel, $matches)) { $from = $matches[1]; $paging['total'] = POD::queryCell("SELECT COUNT(*) {$from}"); } else { return array(array(), $paging); } } if ($paging['total'] === null) { return array(array(), $paging); } if (empty($count)) { $count = 1; } $paging['pages'] = intval(ceil($paging['total'] / $count)); $paging['page'] = is_numeric($page) ? $page : 1; if ($paging['page'] > $paging['pages']) { $paging['page'] = $paging['pages']; if ($paging['pages'] > 0) { $paging['prev'] = $paging['pages'] - 1; } } if ($paging['page'] > 1) { $paging['prev'] = $paging['page'] - 1; } if ($paging['page'] < $paging['pages']) { $paging['next'] = $paging['page'] + 1; } $offset = ($paging['page'] - 1) * $count; if ($offset < 0) { $offset = 0; } if ($countItem !== null) { $count = $countItem; } if ($isDBModel) { $sqlmodel->setLimit($count, $offset); $result = $sqlmodel->getAll(); // Prevent Object poisoning by lazy evaluation of DBModel recycling. return array($result, $paging); } else { return array(POD::queryAll("{$sqlmodel} LIMIT {$count} OFFSET {$offset}"), $paging); } }
function nextId($id = 0) { global $database; $maxId = POD::queryCell("SELECT max(id) FROM {$database['prefix']}Comments WHERE blogid = " . getBlogId()); if ($id == 0) { return $maxId + 1; } else { return $maxId > $id ? $maxId + 1 : $id; } }
function printIphoneEntryContent($blogid, $userid, $id) { global $database; $result = POD::queryCell("SELECT content \n\t\tFROM {$database['prefix']}Entries\n\t\tWHERE \n\t\t\tblogid = {$blogid} AND userid = {$userid} AND id = {$id}"); return $result; }
function getBlogidBySecondaryDomain($domain) { global $database; return POD::queryCell("SELECT blogid FROM {$database['prefix']}BlogSettings WHERE name = 'secondaryDomain' AND (value = '{$domain}' OR value = '" . (substr($domain, 0, 4) == 'www.' ? substr($domain, 4) : 'www.' . $domain) . "')"); }
function getTrackbackCount($blogid, $entryId = null) { global $database; if (is_null($entryId)) { return POD::queryCell("SELECT SUM(trackbacks) \n\t\t\t\tFROM {$database['prefix']}Entries \n\t\t\t\tWHERE blogid = {$blogid} \n\t\t\t\t\tAND draft= 0"); } return POD::queryCell("SELECT trackbacks \n\t\t\tFROM {$database['prefix']}Entries \n\t\t\tWHERE blogid = {$blogid} \n\t\t\t\tAND id = {$entryId} \n\t\t\t\tAND draft= 0"); }
public function getCount($field = '*') { /// Returns the 'selection count' $field = $this->_treatReservedFields($field); return POD::queryCell('SELECT COUNT(' . $field . ') FROM ' . $this->table . $this->_makeWhereClause()); // return POD::queryCount('SELECT ' . $field . ' FROM ' . $this->table . $this->_makeWhereClause() . ' LIMIT 1'); }
function nextEntryId($id = 0) { global $database; $maxId = POD::queryCell("SELECT MAX(id) FROM {$database['prefix']}Entries WHERE blogid = " . getBlogId()); if ($id == 0) { return $maxId + 1; } else { return $maxId > $id ? $maxId : $id; } }
function myPlurk_AddPlurkIcon($target, $mother) { global $blogid, $service, $database, $suri, $blogURL, $pluginURL, $configVal; requireComponent('Textcube.Function.misc'); $data = misc::fetchConfigVal($configVal); $attachResponses = isset($data['attachResponses']) && $data['attachResponses'] == 1 ? true : false; $plurklang = Setting::getBlogSettingGlobal('blogLanguage', ''); $plurkIcon = ""; $responsePlurks = ""; if ($suri['directive'] != "/rss" && $suri['directive'] != "/m" && $suri['directive'] != "/i/entry" && $suri['directive'] != "/atom" && $suri['directive'] != "/sync" && POD::queryCount("SELECT id FROM {$database['prefix']}PlurkEntries WHERE blogid={$blogid} AND id={$mother}") > 0) { $plurk_id = intval(POD::queryCell("SELECT plurkid FROM {$database['prefix']}PlurkEntries WHERE blogid={$blogid} AND id={$mother}")); $plurkLink = "http://www.plurk.com/p/" . base_convert($plurk_id, 10, 36); if (!empty($plurkLink)) { $plurkIcon = '<div id="plurkthis"><img src="' . $pluginURL . '/images/plurkicon.png" border="0" width="16" height="16" alt="Plurk This!" /> PLURK: <a href="' . $plurkLink . '" target="_blank">' . $plurkLink . '</a></div><br />'; } if (!$attachResponses) { return $plurkIcon . $target; } $cache = new PageCache(); $cache->name = 'HC_TCPlurkCache'; if ($cache->load()) { $cache->contents = unserialize($cache->contents); if (array_key_exists($mother, $cache->contents) && Timestamp::getUNIXtime() - $cache->dbContents < 600) { return $plurkIcon . $target . $cache->contents[$mother]; } } require_once "libs/plurk_api.php"; $plurk = new plurk_api(); $plurkNickname = isset($data['plurknickname']) ? $data['plurknickname'] : ""; $plurkPassword = isset($data['plurkpassword']) ? $data['plurkpassword'] : ""; $plurk_api = 'iMCH3JDDda7c4bs0qiOchZcxAx7t8PA7'; if (!$plurk->login($plurk_api, $plurkNickname, $plurkPassword)) { return $plurkIcon . $target; } $responsePlurks = ""; $response = $plurk->get_responses($plurk_id); if ($response->responses_seen > 0) { $qualifiers = array("loves", "likes", "shares", "gives", "hates", "wants", "wishes", "needs", "will", "hopes", "asks", "has", "was", "wonders", "feels", "thinks", "says", "is"); $qualifiers_locale = array('en' => $qualifiers, 'zh-TW' => array("愛", "喜歡", "推", "給", "討厭", "想要", "希望", "需要", "打算", "希望", "問", "已經", "曾經", "好奇", "覺得", "想", "說", "正在"), 'zh-CN' => array("爱", "喜欢", "推", "给", "讨厌", "想要", "希望", "需要", "打算", "希望", "问", "已经", "曾经", "好奇", "觉得", "想", "说", "正在")); $lang = "en"; switch ($plurklang) { case "zh-TW": case "zh-CN": $lang = $plurklang; break; default: $lang = "en"; } $friends = array(); $nick2displayname = array('nickname' => array(), 'displayname' => array()); foreach ($response->friends as $friend) { $friends[$friend->uid]['display_name'] = $friend->display_name; $friends[$friend->uid]['nick_name'] = $friend->nick_name; $friends[$friend->uid]['has_profile_image'] = $friend->has_profile_image == 1 ? true : false; $friends[$friend->uid]['avatar'] = $friend->avatar == null ? "" : $friend->avatar; if (!in_array($friend->nick_name, $nick2displayname['nickname'])) { array_push($nick2displayname['nickname'], $friend->nick_name); array_push($nick2displayname['displayname'], $friend->display_name); } } ob_start(); echo "<div class=\"plurkResponse\" id=\"plurkResponse_{$mother}\">\n"; echo "<h3>" . _f("%1 Responses to this Plurk", $response->responses_seen) . "</h3>\n"; echo "<div class=\"plurkResponseLists\">\n<table cellpadding=\"2\" cellspacing=\"2\" border=\"0\">\n"; foreach ($response->responses as $commentObj) { $comment = (array) $commentObj; $userIcon = $friends[$comment['user_id']]['has_profile_image'] ? "http://avatars.plurk.com/{$comment['user_id']}-medium{$friends[$comment['user_id']]['avatar']}.gif" : ""; $display_name = $friends[$comment['user_id']]['display_name']; $nick_name = $friends[$comment['user_id']]['nick_name']; $qualifier = in_array($comment['qualifier'], $qualifiers) ? $comment['qualifier'] : ""; $qualifierKey = array_keys($qualifiers, $comment['qualifier']); $qualifier_trans = isset($qualifiers_locale[$lang][$qualifierKey[0]]) ? $qualifiers_locale[$lang][$qualifierKey[0]] : ''; if (preg_match_all('/<a href="http:\\/\\/www.plurk.com\\/(.*?)" class="ex_link">(.*?)<\\/a>/ms', $comment['content'], $matches)) { $mlen = count($matches[1]); for ($i = $mlen - 1; $i >= 0; $i--) { if (in_array($matches[1][$i], $nick2displayname['nickname'])) { $replydisplayname = $nick2displayname['displayname'][array_search($matches[1][$i], $nick2displayname['nickname'])]; $comment['content'] = str_replace('<a href="http://www.plurk.com/' . $matches[1][$i] . '" class="ex_link">' . $matches[2][$i] . '</a>', '<a href="http://www.plurk.com/' . $matches[1][$i] . '" class="ex_link">' . $replydisplayname . '</a>', $comment['content']); } } } echo "<tr><td class=\"user_icon\"><a href=\"http://www.plurk.com/{$nick_name}\" target=\"_blank\"><img src=\"{$userIcon}\" border=\"0\" width=\"45\" height=\"45\" alt=\"{$display_name}\" title=\"{$display_name}\" onerror=\"this.src='{$pluginURL}/images/nonusericon.gif'\" /></a></td>\n"; echo "<td class=\"plurkcontent\"><a href=\"http://www.plurk.com/{$nick_name}\" target=\"_blank\">{$display_name}</a> \n"; echo "<span class=\"qualifier_{$qualifier}\">{$qualifier_trans}</span> <span class=\"plurkcomment\">{$comment['content']}</span></td></tr>\n"; } echo "</table>\n</div>\n<p style=\"text-align:right;line-height:1em;\" class=\"plurkResponseMoreButton\">" . _t('MorePlurk...') . "</p>\n"; echo "</div>\n\n"; $responsePlurks = ob_get_contents(); ob_end_clean(); } else { // no response } $cache->contents[$mother] = $responsePlurks; $cache->contents = serialize($cache->contents); $cache->dbContents = Timestamp::getUNIXtime(); $cache->update(); unset($cache); } return $plurkIcon . $target . $responsePlurks; }
<?php /// Copyright (c) 2004-2016, Needlworks / Tatter Network Foundation /// All rights reserved. Licensed under the GPL. /// See the GNU General Public License for more details. (/documents/LICENSE, /documents/COPYRIGHT) require ROOT . '/library/preprocessor.php'; $password = POD::queryCell("SELECT password\n\t\tFROM {$database['prefix']}Entries\n\t\tWHERE blogid = " . getBlogId() . " AND id = {$suri['id']} AND draft = 0"); if (is_null($password)) { $password = ''; } Respond::PrintResult(array('error' => 0, 'password' => $password));