Example #1
0
function RecentRP_getRecentComments($blogid)
{
    $context = Model_Context::getInstance();
    $data = $context->getProperty('plugin.config');
    $comments = array();
    $limitLine = $data['repliesList'] ? $data['repliesList'] : $context->getProperty('skin.commentsOnRecent');
    $pool = DBModel::getInstance();
    $pool->reset('Comments');
    $pool->setQualifier('blogid', 'equals', intval($context->getProperty('blog.id')));
    $pool->setQualifier('isfiltered', 'equals', 0);
    $pool->setQualifier('entry', 'neq', 0);
    if ($data['repliesChk'] != 1) {
        $pool->setQualifier('replier', null);
    }
    $pool->setOrder('written', 'DESC');
    $pool->setLimit($limitLine);
    $result = $pool->getAll();
    foreach ($result as $comment) {
        if ($data['repliesChk'] == 2) {
            $pool->reset('Comments');
            $pool->setQualifier('blogid', 'equals', $context->getProperty('blog.id'));
            $pool->setQualifier('parent', 'equals', $comment['id']);
            $row = $pool->getCount();
            $comment['replier'] = $row ? "<img src=\"" . $context->getProperty("plugin.uri") . "/replier.gif\" width=\"11\" height=\"9\" align=\"top\" style=\"margin-left:2px;\" alt=\"\" />" : "";
        } else {
            $comment['replier'] = "";
        }
        $comment['secret'] = $comment['secret'] == 1 ? "<img src=\"" . $context->getProperty("plugin.uri") . "/secret.gif\" width=\"9\" height=\"11\" style=\"margin-left:2px;\" alt=\"\" />" : "";
        array_push($comments, $comment);
    }
    return $comments;
}
Example #2
0
function getBlogidBySecondaryDomain($domain)
{
    $pool = DBModel::getInstance();
    $pool->init("BlogSettings");
    $pool->setQualifier('name', 'eq', 'secondaryDomain', true);
    $pool->setQualifierSet(array("value", "eq", $domain, true), "OR", array("value", "eq", substr($domain, 0, 4) == 'www.' ? substr($domain, 4) : 'www.' . $domain, true));
    return $pool->getCell("blogid");
}
Example #3
0
function getBlogidByName($name)
{
    $query = DBModel::getInstance();
    $query->reset('BlogSettings');
    $query->setQualifier('name', 'equals', 'name', true);
    $query->setQualifier('value', 'equals', $name, true);
    return $query->getCell('blogid');
    return false;
}
Example #4
0
function printMobileEntryContent($blogid, $userid, $id)
{
    $pool = DBModel::getInstance();
    $pool->reset('Entries');
    $pool->setQualifier('blogid', 'eq', $blogid);
    $pool->setQualifier('userid', 'eq', $userid);
    $pool->setQualifier('id', 'eq', $id);
    return $pool->getCell('content');
}
Example #5
0
function getSkinSettingForMigration($blogid, $name, $default = null)
{
    $pool = DBModel::getInstance();
    $pool->reset("SkinSettingsMig");
    $pool->setQualifier("blogid", "eq", $blogid);
    $pool->setQualifier("name", "eq", $name, true);
    $value = $pool->getCell("value");
    return $value === null ? $default : $value;
}
 private static function initialize()
 {
     global $memcache;
     /** After PHP 5.0.5, session write performs after object destruction. */
     self::$mc = $memcache;
     /** To Avoid this, just copy memcache handle into Session object.     */
     self::$context = Model_Context::getInstance();
     self::$pool = DBModel::getInstance();
 }
 function _buildQuery()
 {
     $query = DBModel::getInstance();
     $query->reset('ServiceSettings');
     $query->setQualifier('name', 'equals', Utils_Unicode::lessenAsEncoding($this->name, 32), false);
     if (isset($this->value)) {
         $query->setAttribute('value', Utils_Unicode::lessenAsEncoding($this->value, 255), true);
     }
     return $query;
 }
Example #8
0
 static function getUserNamesOfBlog($blogid)
 {
     // TODO : Caching with global cache component. (Usually it is not changing easily.)
     $pool = DBModel::getInstance();
     $pool->reset('Privileges');
     $pool->setQualifier('blogid', 'eq', $blogid);
     $authorIds = $pool->getColumn('userid');
     $pool->reset('Users');
     $pool->setQualifier('userid', 'hasOneOf', $authorIds);
     return $pool->getAll('userid,name');
 }
 function _buildQuery()
 {
     $query = DBModel::getInstance();
     $query->reset('UserSettings');
     $query->setQualifier('userid', 'equals', getUserId());
     $query->setQualifier('name', 'equals', $this->name, false);
     if (isset($this->value)) {
         $query->setAttribute('value', $this->value, true);
     }
     return $query;
 }
Example #10
0
function FAS_Call($type, $name, $title, $url, $content)
{
    $context = Model_Context::getInstance();
    $pool = DBModel::getInstance();
    $blogstr = $context->getProperty('uri.host') . $context->getProperty('uri.blog');
    $DDosTimeWindowSize = 300;
    $rpc = new XMLRPC();
    $rpc->url = 'http://antispam.textcube.org/RPC/';
    if ($rpc->call('checkSpam', $blogstr, $type, $name, $title, $url, $content, $_SERVER['REMOTE_ADDR']) == false) {
        // call fail
        // Do Local spam check with "Thief-cat algorithm"
        $count = 0;
        if ($type == 2) {
            $storage = "RemoteResponses";
            $pool->reset($storage);
            $pool->setQualifier("url", "eq", $url, true);
            $pool->setQualifier("isfiltered", ">", 0);
            if ($cnt = $pool->getCount("id")) {
                $count += $cnt;
            }
        } else {
            // Comment Case
            $storage = "Comments";
            $pool->reset($storage);
            $pool->setQualifier("comment", "eq", ${$content}, true);
            $pool->setQualifier("name", "eq", $name, true);
            $pool->setQualifier("homepage", "eq", $url, true);
            $pool->setQualifier("isfiltered", ">", 0);
            if ($cnt = $pool->getCount("id")) {
                $count += $cnt;
            }
        }
        // Check IP
        $pool->reset($storage);
        $pool->setQualifier("ip", "eq", $_SERVER['REMOTE_ADDR'], true);
        $pool->setQualifier("written", ">", Timestamp::getUNIXtime() - $DDosTimeWindowSize);
        if ($cnt = $pool->getCount("id")) {
            $count += $cnt;
        }
        if ($count >= 10) {
            return false;
        }
        return true;
    }
    if (!is_null($rpc->fault)) {
        // FAS has some problem
        return true;
    }
    if ($rpc->result['result'] == true) {
        return false;
        // it's spam
    }
    return true;
}
 function load($fields = '*')
 {
     global $database;
     $blogid = getBlogId();
     $this->reset();
     $query = DBModel::getInstance();
     $query->reset('BlogSettings');
     if ($query->doesExist()) {
         $query->setQualifier('blogid', 'equals', $blogid);
         $blogSettings = $query->getAll('name,value');
         if (isset($blogSettings)) {
             foreach ($blogSettings as $blogSetting) {
                 $name = $blogSetting['name'];
                 $value = $blogSetting['value'];
                 switch ($name) {
                     case 'logo':
                         $name = 'banner';
                         break;
                     case 'entriesOnPage':
                         $name = 'postsOnPage';
                         break;
                     case 'entriesOnList':
                         $name = 'postsOnList';
                         break;
                     case 'entriesOnRSS':
                         $name = 'postsOnFeed';
                         break;
                     case 'publishWholeOnRSS':
                         $name = 'publishWholeOnFeed';
                         break;
                     case 'allowWriteOnGuestbook':
                         $name = 'acceptGuestComment';
                         break;
                     case 'allowWriteDblCommentOnGuestbook':
                         $name = 'acceptcommentOnGuestComment';
                         break;
                     case 'defaultDomain':
                     case 'useSloganOnPost':
                     case 'useSloganOnCategory':
                     case 'useSloganOnTag':
                     case 'acceptGuestComment':
                     case 'acceptcommentOnGuestComment':
                         $value = $value ? true : false;
                         break;
                 }
                 $this->{$name} = $value;
             }
         }
         return true;
     }
     return false;
 }
 function _buildQuery()
 {
     $query = DBModel::getInstance();
     $query->reset('BlogStatistics');
     $query->setQualifier('blogid', 'equals', getBlogId());
     if (isset($this->visits)) {
         if (!Validator::number($this->visits, 0)) {
             return $this->_error('visits');
         }
         $query->setAttribute('visits', $this->visits);
     }
     return $query;
 }
Example #13
0
function getDefaultDBModelOnNotice($blogid)
{
    $query = DBModel::getInstance();
    $query->reset('Entries');
    $query->setQualifier('blogid', 'equals', $blogid);
    $query->setQualifier('draft', 'equals', 0);
    if (!doesHaveOwnership()) {
        $query->setQualifier('visibility', 'bigger', 1);
    }
    $query->setQualifier('category', 'equals', -2);
    $query->setOrder('published', 'DESC');
    return $query;
}
 function _buildQuery()
 {
     if (!Validator::directory($this->name)) {
         return $this->_error('name');
     }
     $query = DBModel::getInstance();
     $query->reset('Plugins');
     $query->setQualifier('blogid', 'equals', getBlogId());
     $query->setQualifier('name', 'equals', Utils_Unicode::lessenAsEncoding($this->name, 255), true);
     if (isset($this->setting)) {
         $query->setAttribute('settings', $this->setting, true);
     }
     return $query;
 }
Example #15
0
function getEntriesByKeyword($blogid, $keyword)
{
    $pool = DBModel::getInstance();
    $pool->reset('Entries');
    $pool->setQualifier('blogid', 'eq', $blogid);
    $pool->setQualifier('draft', 'eq', 0);
    if (doesHaveOwnership()) {
        $pool->setQualifier('visibility', 'b', 1);
    }
    $pool->setQualifier('category', 'beq', 0);
    $pool->setQualifierSet(array('title', 'like', $keyword, true), 'OR', array('content', 'like', $keyword, true));
    $pool->setOrder('published', 'DESC');
    return $pool->getRow('id,userid,title,category,comments,published');
}
Example #16
0
function suggestLocatives($blogid, $filter)
{
    $pool = DBModel::getInstance();
    $pool->reset("Entries");
    $pool->setQualifier("blogid", "eq", $blogid);
    $pool->setQualifier("location", "like", $filter . '%', true);
    $pool->setGroup("location");
    $pool->setOrder("cnt", "desc");
    $pool->setLimit(10);
    $result = $pool->getAll("location, COUNT(*) cnt", array("filter" => "distinct"));
    $locatives = array();
    if ($result) {
        foreach ($result as $locative) {
            $locatives[] = $locative[0];
        }
    }
    return $locatives;
}
Example #17
0
function getEntryFormatterInfo($id)
{
    static $info;
    $context = Model_Context::getInstance();
    $blogid = intval($context->getProperty('blog.id'));
    if (!Validator::id($id)) {
        return NULL;
    } else {
        if (!isset($info[$blogid][$id])) {
            $context = Model_Context::getInstance();
            $pool = DBModel::getInstance();
            $pool->reset('Entries');
            $pool->setQualifier('blogid', 'equals', $blogid);
            $pool->setQualifier('id', 'equals', $id);
            $info[$blogid][$id] = $pool->getCell('contentformatter');
        }
    }
    return $info[$blogid][$id];
}
Example #18
0
function _getRecentEntries($blogid)
{
    $query = DBModel::getInstance();
    $query->reset('Entries');
    $query->setQualifier('blogid', 'equals', $blogid);
    $query->setQualifier('draft', 'equals', 0);
    if (doesHaveOwnership()) {
        $query->setQualifier('visibility', 'bigger', 0);
    }
    $query->setQualifier('category', 'bigger or same', 0);
    $query->setLimit(8);
    $query->setOrder('published', 'desc');
    $result = $query->getAll('id,title,comments');
    if (!empty($result)) {
        return $result;
    } else {
        return array();
    }
}
Example #19
0
function CT_Start_Default_getEntry($blogid, $id)
{
    if ($id == 0) {
        return null;
    }
    $visibility = doesHaveOwnership() ? '' : 'AND visibility > 0';
    $pool = DBModel::getInstance();
    $pool->reset("Entries");
    $pool->setQualifier("blogid", "eq", $blogid);
    $pool->setQualifier("id", "eq", $id);
    $pool->setQualifier("draft", "eq", 0);
    if (!doesHaveOwnership()) {
        $pool->setQualifier("visibility", ">", 0);
    }
    $entry = $pool->getRow("id,title,visibility");
    if (!$entry) {
        return false;
    }
    return $entry;
}
 public function load($fields = '*')
 {
     $this->reset();
     $pool = DBModel::getInstance();
     $pool->reset('SkinSettings');
     $pool->setQualifier('blogid', 'equals', getBlogId());
     $result = $pool->getAll('name, value');
     if (!empty($result)) {
         foreach ($result as $data) {
             if (!empty($date['name'])) {
                 if ($data['name'] == 'tagboxAlign') {
                     $data['name'] = 'alignOnTagbox';
                 }
                 $this->{$data}['name'] = $data['value'];
             }
         }
         return true;
     }
     return false;
 }
Example #21
0
 function authenticate($blogid, $loginid, $password, $blogapi = false)
 {
     $session = array();
     Acl::clearAcl();
     $pool = DBModel::getInstance();
     $blogApiPassword = Setting::getBlogSettingGlobal("blogApiPassword", "");
     $pool->reset("Users");
     if (strlen($password) == 32 && preg_match('/[0-9a-f]{32}/i', $password)) {
         // Traditional md5 Raw login. ( with/without auth token)
         $userid = User::getUserIdByEmail($loginid);
         if (!empty($userid) && !is_null($userid)) {
             $pool->reset('UserSettings');
             $pool->setQualifier('userid', 'equals', intval($userid));
             $pool->setQualifier('name', 'equals', 'AuthToken', true);
             $authtoken = $query->getCell('value');
             $pool->reset("Users");
             if (!empty($authtoken) && $authtoken === $password) {
                 // If user requested auth token, use it to confirm.
                 $session['userid'] = $userid;
             } else {
                 // login with md5 hash
                 $pool->setQualifier("password", "eq", md5($password), true);
             }
         } else {
             return false;
         }
     } else {
         if ($blogapi && !empty($blogApiPassword)) {
             // BlogAPI login
             $pool->setQualifierSet(array("password", "eq", md5($password), true), "OR", array($password, "eq", $blogApiPassword, true));
         } else {
             // Normal login
             $pool->setQualifier("password", "eq", md5($password), true);
         }
     }
     if (empty($session)) {
         $pool->setQualifier("loginid", "eq", $loginid, true);
         $session = $pool->getRow("userid, loginid");
     }
     if (empty($session)) {
         /* You should compare return value with '=== false' which checks with variable types*/
         return false;
     }
     $userid = $session['userid'];
     Acl::authorize('textcube', $userid);
     $pool->reset("Users");
     $pool->setAttribute("lastlogin", Timestamp::getUNIXtime());
     $pool->setQualifier("loginid", "eq", $loginid, true);
     $pool->update();
     //		POD::execute("DELETE FROM {$database['prefix']}UserSettings WHERE userid = '$userid' AND name = 'AuthToken' LIMIT 1");
     return $userid;
 }
Example #22
0
function api_update_attaches_with_replace($entryId)
{
    $pool = DBModel::getInstance();
    $pool->reset('Attachments');
    $pool->setQualifier('blogid', 'eq', getBlogId());
    $pool->setQualifier('parent', 'eq', 0);
    $newFiles = $pool->getAll('name,label');
    if ($newFiles) {
        foreach ($newFiles as $newfile) {
            $newfile['label'] = Utils_Unicode::lessenAsEncoding($newfile['label'], 64);
            $pool->reset('Attachments');
            $pool->setQualifier('blogid', 'eq', getBlogId());
            $pool->setQualifier('parent', 'eq', $entryId);
            $pool->setQualifier('label', 'eq', $newfile['label'], true);
            $oldFile = $pool->getCell('name');
            if (!is_null($oldFile)) {
                deleteAttachment(getBlogId(), $entryId, $oldFile);
            }
        }
    }
    api_update_attaches($entryId);
}
Example #23
0
 if ($dbCaseInsensitive == true) {
     $tempTables = $definedTables;
     $definedTables = array();
     foreach ($tempTables as $table) {
         $table = strtolower($table);
         array_push($definedTables, $table);
     }
     $tempTables = $dbtables;
     $dbtables = array();
     foreach ($tempTables as $table) {
         $table = strtolower($table);
         array_push($dbtables, $table);
     }
     $dbtables = array_values(array_diff($dbtables, $definedTables));
 }
 $query = DBModel::getInstance();
 $query->reset('ServiceSettings');
 $query->setQualifier('name', 'like', 'Database%', true);
 $plugintablesraw = $query->getAll('name,value');
 $plugintables = array();
 foreach ($plugintablesraw as $table) {
     $dbname = $database['prefix'] . substr($table['name'], 9);
     $values = explode('/', $table['value'], 2);
     $plugin = $values[0];
     $version = $values[1];
     if (!array_key_exists($plugin . '/' . $version, $plugintables)) {
         $plugintables[$plugin . '/' . $version] = array('plugin' => $plugin, 'version' => $version, 'tables' => array());
     }
     array_push($plugintables[$plugin . '/' . $version]['tables'], $dbname);
     if ($dbCaseInsensitive == true) {
         $dbname = strtolower($dbname);
Example #24
0
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 '&nbsp;';
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
                ?>
</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 />
          &lt;Directory &quot;<?php 
                            echo $root;
                            ?>
&quot;&gt;<br />
          &nbsp;&nbsp;Options FollowSymLinks<br />
          &nbsp;&nbsp;AllowOverride FileInfo<br />
          &lt;/Directory&gt;
          </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 '&nbsp;';
                                            }
                                        }
                                    }
                                }
                            }
                            ?>
</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 
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}
 function _buildQuery()
 {
     global $database;
     $query = DBModel::getInstance();
     $query->reset('Comments');
     $query->setQualifier('blogid', 'equals', getBlogId());
     $query->setQualifier('entry', 'equals', 0);
     if (isset($this->id)) {
         if (!Validator::number($this->id, 1)) {
             return $this->_error('id');
         }
         $query->setQualifier('id', 'equals', $this->id);
     }
     if (isset($this->parent)) {
         if (!Validator::number($this->parent, 1)) {
             return $this->_error('parent');
         }
     }
     $query->setAttribute('parent', $this->parent);
     if (isset($this->commenter)) {
         if (!Validator::number($this->commenter, 1)) {
             return $this->_error('commenter');
         }
         if (!($this->name = User::getName($this->commenter))) {
             return $this->_error('commenter');
         }
         $query->setAttribute('replier', $this->commenter);
     }
     if (isset($this->name)) {
         $this->name = Utils_Unicode::lessenAsEncoding(trim($this->name), 80);
         if (empty($this->name)) {
             return $this->_error('name');
         }
         $query->setAttribute('name', $this->name, true);
     }
     if (isset($this->openid)) {
         $this->openid = Utils_Unicode::lessenAsEncoding(trim($this->openid), 128);
         if (empty($this->openid)) {
             return $this->_error('openid');
         }
         $query->setAttribute('openid', $this->openid, true);
     }
     if (isset($this->homepage)) {
         $this->homepage = Utils_Unicode::lessenAsEncoding(trim($this->homepage), 80);
         if (empty($this->homepage)) {
             return $this->_error('homepage');
         }
         $query->setAttribute('homepage', $this->homepage, true);
     }
     if (isset($this->ip)) {
         if (!Validator::ip($this->ip)) {
             return $this->_error('ip');
         }
         $query->setAttribute('ip', $this->ip, true);
     }
     if (isset($this->secret)) {
         $query->setAttribute('secret', Validator::getBit($this->secret));
     }
     if (isset($this->content)) {
         $this->content = trim($this->content);
         if (empty($this->content)) {
             return $this->_error('content');
         }
         $query->setAttribute('comment', $this->content, true);
     }
     if (isset($this->written)) {
         if (!Validator::timestamp($this->written)) {
             return $this->_error('written');
         }
         $query->setAttribute('written', $this->written);
     }
     if (isset($this->isfiltered)) {
         $query->setAttribute('isfiltered', Validator::getBit($this->isfiltered));
     }
     if (isset($this->password)) {
         $this->password = Utils_Unicode::lessenAsEncoding($this->password, 32);
         $query->setAttribute('password', $this->password, true);
         $this->password = null;
     }
     return $query;
 }
Example #26
0
<?php

/// Copyright (c) 2004-2015, Needlworks  / Tatter Network Foundation
/// All rights reserved. Licensed under the GPL.
/// See the GNU General Public License for more details. (/documents/LICENSE, /documents/COPYRIGHT)
$IV = array('GET' => array('page' => array('number', 'min' => 1, 'default' => 1)));
require ROOT . '/library/preprocessor.php';
$pool = DBModel::getInstance();
$context = Model_Context::getInstance();
$context->setProperty('service.admin_script', 'control.js');
require ROOT . '/interface/common/control/header.php';
requirePrivilege('group.creators');
$page = $_GET['page'];
?>
	<div id="part-create-newblog" class="part">
		<h2 class="caption"><span class="main-text"><?php 
echo _t('새 블로그 만들기');
?>
</span></h2>
		
		<form onsubmit="return false;">
			<fieldset>
				<dl>
					<dt><label for="bi-owner-loginid"><?php 
echo _t('소유자');
?>
</label>
					<dd id="suggestContainer"><input id="bi-owner-loginid" class="input-text" name="location" value="<?php 
echo User::getEmail(1);
?>
" /></dd>
Example #27
0
function removeBlog($blogid)
{
    $pool = DBModel::getInstance();
    $ctx = Model_Context::getInstance();
    if (Setting::getServiceSetting("defaultBlogId", 1, true) == $blogid) {
        return false;
    }
    $targets = array('Attachments', 'BlogSettings', 'BlogStatistics', 'Categories', 'Comments', 'CommentsNotified', 'CommentsNotifiedQueue', 'DailyStatistics', 'Entries', 'EntriesArchive', 'FeedGroups', 'FeedReads', 'FeedStarred', 'FeedSettings', 'Filters', 'Links', 'LinkCategories', 'PageCacheLog', 'Plugins', 'RefererLogs', 'RefererStatistics', 'RemoteResponses', 'RemoteResponseLogs', 'SkinSettings', 'TagRelations', 'Privileges', 'XMLRPCPingSettings');
    //Clear Tables
    foreach ($targets as $t) {
        $pool->reset($t);
        $pool->setQualifier('blogid', 'eq', $blogid);
        $pool->delete();
    }
    //Delete Tags
    $tags = POD::queryColumn("SELECT DISTINCT tag FROM " . $ctx->getProperty('database.prefix') . "TagRelations WHERE blogid = {$blogid}");
    if (count($tags) > 0) {
        $tagliststr = implode(', ', $tags);
        // Tag id used at deleted blog.
        $nottargets = POD::queryColumn("SELECT DISTINCT tag FROM " . $ctx->getProperty('database.prefix') . "TagRelations WHERE tag in ( {$tagliststr} )");
        // Tag id used at other blogs.
        if (count($nottargets) > 0) {
            $nottargetstr = implode(', ', $nottargets);
            POD::execute("DELETE FROM " . $ctx->getProperty('database.prefix') . "Tags WHERE id IN ( {$tagliststr} ) AND id NOT IN ( {$nottargetstr} )");
        } else {
            POD::execute("DELETE FROM " . $ctx->getProperty('database.prefix') . "Tags WHERE id IN ( {$tagliststr} ) ");
        }
    }
    //Delete Feeds
    $feeds = POD::queryColumn("SELECT DISTINCT feeds FROM " . $ctx->getProperty('database.prefix') . "FeedGroupRelations WHERE blogid = {$blogid}");
    if (count($feeds) > 0) {
        foreach ($feeds as $feedId) {
            deleteFeed($blogid, $feedId);
        }
    }
    //Clear Plugin Database
    // TODO : encapsulate with 'value'
    $query = "SELECT name, value FROM " . $ctx->getProperty('database.prefix') . "ServiceSettings WHERE name like 'Database\\_%'";
    $plugintablesraw = POD::queryAll($query);
    foreach ($plugintablesraw as $table) {
        $dbname = $ctx->getProperty('database.prefix') . substr($table['name'], 9);
        POD::execute("DELETE FROM " . $ctx->getProperty('database.prefix') . "{$dbname} WHERE blogid = {$blogid}");
    }
    //Clear RSS Cache
    if (file_exists(__TEXTCUBE_CACHE_DIR__ . "/rss/{$blogid}.xml")) {
        unlink(__TEXTCUBE_CACHE_DIR__ . "/rss/{$blogid}.xml");
    }
    //Delete Attachments
    Path::removeFiles(Path::combine(ROOT, 'attach', $blogid));
    return true;
}
 function _buildQuery()
 {
     $query = DBModel::getInstance();
     $query->reset('RemoteResponses');
     $query->setQualifier('blogid', getBlogId());
     $query->setQualifier('responsetype', 'pingback');
     if (isset($this->id)) {
         if (!Validator::number($this->id, 1)) {
             return $this->_error('id');
         }
         $query->setQualifier('id', $this->id);
     }
     if (isset($this->entry)) {
         if (!Validator::number($this->entry, 1)) {
             return $this->_error('entry');
         }
         $query->setQualifier('entry', $this->entry);
     }
     if (isset($this->url)) {
         $this->url = Utils_Unicode::lessenAsEncoding(trim($this->url), 255);
         if (empty($this->url)) {
             return $this->_error('url');
         }
         $query->setQualifier('url', $this->url, true);
     }
     if (isset($this->ip)) {
         if (!Validator::ip($this->ip)) {
             return $this->_error('ip');
         }
         $query->setAttribute('ip', $this->ip, true);
     }
     if (isset($this->received)) {
         if (!Validator::timestamp($this->received)) {
             return $this->_error('received');
         }
         $query->setAttribute('written', $this->received);
     }
     if (isset($this->isFiltered)) {
         if ($this->isFiltered) {
             $query->setAttribute('isFiltered', 'UNIX_TIMESTAMP()');
         } else {
             $query->setAttribute('isFiltered', Validator::getBit($this->isFiltered));
         }
     }
     return $query;
 }
 function _buildQuery()
 {
     global $database;
     $this->host = Utils_Unicode::lessenAsEncoding(trim($this->host), 64);
     if (empty($this->host)) {
         return $this->_error('host');
     }
     $query = DBModel::getInstance();
     $query->reset('RefererStatistics');
     $query->setQualifier('blogid', 'equals', getBlogId());
     $query->setQualifier('host', 'equals', $this->host, true);
     if (isset($this->count)) {
         if (!Validator::number($this->count, 1)) {
             return $this->_error('count');
         }
         $query->setAttribute('count', $this->count);
     }
     return $query;
 }
Example #30
0
 function _getMaxId()
 {
     $pool = DBModel::getInstance();
     $pool->reset('FeedItems');
     $maxId = $pool->getCell('max(id)');
     if (!empty($maxId)) {
         return $maxId;
     } else {
         return 0;
     }
 }