$url,'value'=>'');
$owner=null;
$depth=substr_count($service['path'],'/');
if($depth>0){
if(ereg("^((/+[^/]+){{$depth}})(.*)$",$url,$matches))
$url=$matches[3];
else
respondNotFoundPage();
}
if($service['type']=='single'){
$owner=1;
}else{
if($service['type']=='domain'){
if($_SERVER['HTTP_HOST']==$service['domain']){
$owner=1;
}else{
$domain=explode('.',$_SERVER['HTTP_HOST'],2);
if($domain[1]==$service['domain']){
$owner=getOwner($domain[0]);
if($owner===null)
$owner=getOwnerBySecondaryDomain($_SERVER['HTTP_HOST']);
}else{
$owner=getOwnerBySecondaryDomain($_SERVER['HTTP_HOST']);
}
}
}else{
if($url=='/'){
$owner=1;
}elseif(ereg('^/+([^/]+)(.*)$',$url,$matches)){
$owner=getOwner($matches[1]);
$url=$matches[2];
}else{
respondNotFoundPage();
}
}
if($owner===null)
respondNotFoundPage();
}
$blog=getBlogSetting($owner);
$skinSetting=getSkinSetting($owner);
$depth=substr_count(ROOT,'/');
if($depth>0){
if(ereg("^((/+[^/]+){{$depth}})/*(.*)$",$url,$matches)){
$suri['directive']=$matches[1];
if($matches[3]!==false)
$suri['value']=$matches[3];
}else
respondNotFoundPage();
}else{
$suri['directive']='/';
$suri['value']=ltrim($url,'/');
}
if(is_numeric($suri['value']))
$suri['id']=$suri['value'];
$suri['page']=empty($_POST['page'])?(empty($_GET['page'])?true:$_GET['page']):$_POST['page'];
$hostURL="http://{$_SERVER['HTTP_HOST']}".(isset($service['port'])?":{$service['port']}":'');
$blogURL=$service['type']=='path'?"{$service['path']}/{$blog['name']}":$service['path'];
$folderURL=rtrim($blogURL.$suri['directive'],'/');
unset($url,$domain);
if(!file_exists('../../config.php')){
header("Location: $blogURL/setup.php");
exit;
}
function respondNotFoundPage(){
header('HTTP/1.1 404 Not Found');
header("Connection: close");
exit;
}
function getMicrotimeAsFloat(){
list($usec,$sec)=explode(" ",microtime());
return ($usec+$sec);
}
$sessionMicrotime=getMicrotimeAsFloat();
function openSession($savePath,$sessionName){
return true;
}
function closeSession(){
return true;
}
function readSession($id){
global $database,$service;
if($result=mysql_query("SELECT data FROM {$database['prefix']}Sessions WHERE id = '$id' AND address = '{$_SERVER['REMOTE_ADDR']}' AND updated >= (UNIX_TIMESTAMP() - {$service['timeout']})")){
if($session=mysql_fetch_array($result))
return $session['data'];
}
return '';
}
function writeSession($id,$data){
global $database;
global $sessionMicrotime;
if(strlen($id)<32)
return false;
$userid=isset($_SESSION['userid'])?$_SESSION['userid']:'null';
$data=mysql_escape_string($data);
$server=mysql_escape_string($_SERVER['HTTP_HOST']);
$request=mysql_escape_string($_SERVER['REQUEST_URI']);
$referer=isset($_SERVER['HTTP_REFERER'])?mysql_escape_string($_SERVER['HTTP_REFERER']):'';
$timer=getMicrotimeAsFloat()-$sessionMicrotime;
$result=mysql_query("UPDATE {$database['prefix']}Sessions SET userid = $userid, data = '$data', server = '$server', request = '$request', referer = '$referer', timer = $timer, updated = UNIX_TIMESTAMP() WHERE id = '$id' AND address = '{$_SERVER['REMOTE_ADDR']}'");
if($result&&(mysql_affected_rows()==1))
return true;
return false;
}
function destroySession($id,$setCookie=false){
global $database;
if(!isset($_SESSION['userid']))
return ;
@mysql_query("DELETE FROM {$database['prefix']}Sessions WHERE id = '$id' AND address = '{$_SERVER['REMOTE_ADDR']}'");
gcSession();
}
function gcSession($maxLifeTime=false){
global $database,$service;
@mysql_query("DELETE FROM {$database['prefix']}Sessions WHERE updated < (UNIX_TIMESTAMP() - {$service['timeout']})");
$result=@mysql_query("SELECT DISTINCT v.id, v.address FROM {$database['prefix']}SessionVisits v LEFT JOIN {$database['prefix']}Sessions s ON v.id = s.id AND v.address = s.address WHERE s.id IS NULL AND s.address IS NULL");
if($result){
$gc=array();
while($g=mysql_fetch_row($result))
array_push($gc,$g);
foreach($gc as $g)
@mysql_query("DELETE FROM {$database['prefix']}SessionVisits WHERE id = '{$g[0]}' AND address = '{$g[1]}'");
}
return true;
}
function getAnonymousSession(){
global $database;
$result=mysql_query("SELECT id FROM {$database['prefix']}Sessions WHERE address = '{$_SERVER['REMOTE_ADDR']}' AND userid IS NULL AND preexistence IS NULL");
if($result&&(list($id)=mysql_fetch_array($result)))
return $id;
return false;
}
function newAnonymousSession(){
global $database;
for($i=0;$i<100;$i++){
if(($id=getAnonymousSession())!==false)
return $id;
$id=dechex(rand(0x10000000,0x7FFFFFFF)).dechex(rand(0x10000000,0x7FFFFFFF)).dechex(rand(0x10000000,0x7FFFFFFF)).dechex(rand(0x10000000,0x7FFFFFFF));
mysql_query("INSERT INTO {$database['prefix']}Sessions(id, address, created, updated) VALUES('$id', '{$_SERVER['REMOTE_ADDR']}', UNIX_TIMESTAMP(), UNIX_TIMESTAMP())");
if(mysql_affected_rows()>0)
return $id;
}
return false;
}
function setSessionAnonymous($currentId){
$id=getAnonymousSession();
if($id!==false){
if($id!=$currentId)
session_id($id);
return true;
}
$id=newAnonymousSession();
if($id!==false){
session_id($id);
return true;
}
return false;
}
function isSessionAuthorized($id){
global $database;
$result=mysql_query("select id from {$database['prefix']}Sessions where id = '$id' and address = '{$_SERVER['REMOTE_ADDR']}' and (userid is not null or preexistence is not null)");
if($result&&(mysql_num_rows($result)==1))
return true;
return false;
}
function setSession(){
$id=empty($_COOKIE[session_name()])?'':$_COOKIE[session_name()];
if((strlen($id)<32)||!isSessionAuthorized($id))
setSessionAnonymous($id);
}
session_name('TSSESSION');
setSession();
session_set_save_handler('openSession','closeSession','readSession','writeSession','destroySession','gcSession');
session_cache_expire(1);
session_set_cookie_params(0,'/',$service['domain']);
if(session_start()!==true){
header('HTTP/1.1 503 Service Unavailable');
}
function doesHaveMembership(){
return empty($_SESSION['userid'])?false:true;
}
function getUserId(){
return empty($_SESSION['userid'])?false:$_SESSION['userid'];
}
if(doesHaveMembership()){
$user=array('id'=>getUserId());
list($user['loginid'],$user['name'])=fetchQueryRow("select loginid, name from {$database['prefix']}Users where userid = {$user['id']}");
list($user['blog'],$user['timezone'])=fetchQueryRow("select name, timezone from {$database['prefix']}BlogSettings where owner = {$user['id']}");
$user['homepage']=getBlogURL($user['blog']);
}else
$user=null;
Timezone::set(isset($blog['timezone'])?$blog['timezone']:$service['timezone']);
mysql_query('SET time_zone = \''.Timezone::getCanonical().'\'');
Locale::setDirectory('../../language');
Locale::set(isset($blog['language'])?$blog['language']:$service['language']);
$activePlugins=array();
$eventMappings=array();
$tagMappings=array();
if(!empty($owner)){
$activePlugins=fetchQueryColumn("SELECT name FROM {$database['prefix']}Plugins WHERE owner = $owner");
$xmls=new XMLStruct();
foreach($activePlugins as $plugin){
$manifest=@file_get_contents("../../plugins/$plugin/index.xml");
if($manifest&&$xmls->open($manifest)){
if($xmls->doesExist('/plugin/binding/listener')){
foreach($xmls->selectNodes('/plugin/binding/listener') as $listener){
if(!empty($listener['.attributes']['event'])&&!empty($listener['.value'])){
if(!isset($eventMappings[$listener['.attributes']['event']]))
$eventMappings[$listener['.attributes']['event']]=array();
array_push($eventMappings[$listener['.attributes']['event']],array('plugin'=>$plugin,'listener'=>$listener['.value']));
}
}
unset($listener);
}
if($xmls->doesExist('/plugin/binding/tag')){
foreach($xmls->selectNodes('/plugin/binding/tag') as $tag){
if(!empty($tag['.attributes']['name'])&&!empty($tag['.attributes']['handler'])){
if(!isset($tagMappings[$tag['.attributes']['name']]))
$tagMappings[$tag['.attributes']['name']]=array();
array_push($tagMappings[$tag['.attributes']['name']],array('plugin'=>$plugin,'handler'=>$tag['.attributes']['handler']));
}
}
unset($tag);
}
}else{
$plugin=mysql_escape_string($plugin);
mysql_query("DELETE FROM {$database['prefix']}Plugins WHERE owner = $owner AND name = '$plugin'");
}
}
unset($xmls);
unset($plugin);
}
header('Content-Type: text/html; charset=utf-8');
if(!file_exists('../../cache/CHECKUP')||(file_get_contents('../../cache/CHECKUP')!=TATTERTOOLS_VERSION)){
if($fp=fopen('../../cache/CHECKUP','w')){
fwrite($fp,TATTERTOOLS_VERSION);
fclose($fp);
@chmod('../../cache/CHECKUP',0666);
}
}?>
<?=_t('태터툴즈를 점검합니다')?>...
...
',_t('스킨 설정 테이블에 공지 길이 제한 필드를 추가합니다'),': ';
if(DBQuery::execute("ALTER TABLE {$database['prefix']}SkinSettings ADD recentNoticeLength INT DEFAULT 30 NOT NULL AFTER expandTrackback"))
echo '',_t('성공'),'';
else
echo '',_t('실패'),'';
}
if(DBQuery::queryExistence("DESC {$database['prefix']}Categories `order`")){
$changed=true;
echo '- ',_t('분류 테이블의 우선순위 필드명을 변경합니다'),': ';
if(DBQuery::execute("ALTER TABLE {$database['prefix']}Categories CHANGE `order` priority INT NOT NULL DEFAULT 0"))
echo '',_t('성공'),'
';
else
echo '',_t('실패'),'';
}
if(DBQuery::queryExistence("DESC {$database['prefix']}Users `database`")){
$changed=true;
echo '- ',_t('사용자 테이블의 미사용 필드를 삭제합니다'),': ';
if(DBQuery::execute("ALTER TABLE {$database['prefix']}Users DROP server, DROP `database`"))
echo '',_t('성공'),'
';
else
echo '',_t('실패'),'';
}
if(!DBQuery::queryExistence("DESC {$database['prefix']}RefererLogs url")){
$changed=true;
echo '- ',_t('레퍼러 로그 테이블의 구조를 변경합니다'),': ';
if(DBQuery::execute("UPDATE {$database['prefix']}RefererLogs SET path = CONCAT('http://', host, path)")&&DBQuery::execute("ALTER TABLE {$database['prefix']}RefererLogs CHANGE path url VARCHAR(255) NOT NULL")&&DBQuery::execute("ALTER TABLE {$database['prefix']}RefererLogs CHANGE written referred INT NOT NULL"))
echo '',_t('성공'),'
';
else
echo '',_t('실패'),'';
}
if(!DBQuery::queryExistence("SELECT count(*) FROM {$database['prefix']}Filters WHERE owner = 0")){
$changed=true;
echo '- ',_t('필터와 관련된 구조를 변경합니다'),': ';
$query="
CREATE TABLE {$database['prefix']}Filters (
id int(11) NOT NULL auto_increment,
owner int(11) NOT NULL default '0',
type enum('content','ip','name','url') NOT NULL default 'content',
pattern varchar(255) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY owner (owner, type, pattern)
) TYPE=MyISAM
";
if(DBQuery::execute($query.' DEFAULT CHARSET=utf8')||DBQuery::execute($query)){
if(DBQuery::execute("INSERT INTO {$database['prefix']}Filters(owner, type, pattern) SELECT owner, 'content', word FROM {$database['prefix']}ContentFilters"))
DBQuery::execute("DROP TABLE {$database['prefix']}ContentFilters");
if(DBQuery::execute("INSERT INTO {$database['prefix']}Filters(owner, type, pattern) SELECT owner, 'name', name FROM {$database['prefix']}GuestFilters"))
DBQuery::execute("DROP TABLE {$database['prefix']}GuestFilters");
if(DBQuery::execute("INSERT INTO {$database['prefix']}Filters(owner, type, pattern) SELECT owner, 'ip', address FROM {$database['prefix']}HostFilters"))
DBQuery::execute("DROP TABLE {$database['prefix']}HostFilters");
if(DBQuery::execute("INSERT INTO {$database['prefix']}Filters(owner, type, pattern) SELECT owner, 'url', url FROM {$database['prefix']}URLFilters"))
DBQuery::execute("DROP TABLE {$database['prefix']}URLFilters");
echo '',_t('성공'),'
';
}else{
echo '',_t('실패'),'';
}
}
if(DBQuery::queryExistence("SELECT count(*) FROM {$database['prefix']}FeedOwners WHERE owner = 0")){
$changed=true;
echo '- ',_t('리더와 관련된 구조를 변경합니다'),': ';
if(DBQuery::execute("DROP TABLE {$database['prefix']}FeedOwners"))
echo '',_t('성공'),'
';
else
echo '',_t('실패'),'';
}
if(DBQuery::queryExistence("SELECT count(*) FROM {$database['prefix']}MonthlyStatistics WHERE owner = 0")){
$changed=true;
echo '- ',_t('통계와 관련된 구조를 변경합니다'),': ';
if(DBQuery::execute("DROP TABLE {$database['prefix']}MonthlyStatistics"))
echo '',_t('성공'),'
';
else
echo '',_t('실패'),'';
}
if(DBQuery::queryExistence("SELECT * FROM {$database['prefix']}Users WHERE name = ''")){
$changed=true;
echo '- ',_t('사용자 이름 누락 정보를 보완합니다'),': ';
if(DBQuery::execute("UPDATE {$database['prefix']}Users SET name = IF(LEFT(loginid, POSITION('@' IN loginid) - 1) = '', loginid, LEFT(loginid, POSITION('@' IN loginid) - 1)) WHERE name = ''"))
echo '',_t('성공'),'
';
else
echo '',_t('실패'),'';
}
if(DBQuery::queryCell("DESC {$database['prefix']}Entries owner",'Key')!='PRI'){
$changed=true;
echo '- ',_t('엔트리 테이블의 인덱스를 수정합니다'),': ';
if(DBQuery::execute("ALTER TABLE {$database['prefix']}Entries DROP PRIMARY KEY, ADD PRIMARY KEY(owner, id, draft)"))
echo '',_t('성공'),'
';
else
echo '',_t('실패'),'';
}
if(DBQuery::queryCell("DESC {$database['prefix']}TagRelations owner",'Key')!='PRI'){
$changed=true;
echo '- ',_t('태그관계 테이블의 인덱스를 수정합니다'),': ';
if(DBQuery::execute("ALTER TABLE {$database['prefix']}TagRelations DROP PRIMARY KEY, ADD PRIMARY KEY(owner, tag, entry)"))
echo '',_t('성공'),'
';
else
echo '',_t('실패'),'';
}
if(DBQuery::queryCell("DESC {$database['prefix']}Trackbacks owner",'Key')!='MUL'){
$changed=true;
echo '- ',_t('트랙백 테이블의 인덱스를 수정합니다'),': ';
if(DBQuery::execute("ALTER TABLE {$database['prefix']}Trackbacks DROP INDEX entry, ADD UNIQUE owner (owner, entry, url)"))
echo '',_t('성공'),'
';
else
echo '',_t('실패'),'';
}
if(DBQuery::queryCell("DESC {$database['prefix']}Comments parent",'Key')!='MUL'){
$changed=true;
echo '- ',_t('댓글 테이블에 인덱스를 추가합니다'),': ';
if(DBQuery::execute("ALTER TABLE {$database['prefix']}Comments ADD INDEX parent (parent)"))
echo '',_t('성공'),'
';
else
echo '',_t('실패'),'';
}
if(!Validator::getBool(DBQuery::queryCell("DESC {$database['prefix']}Sessions data",'Null'))){
$changed=true;
echo '- ',_t('세션 테이블의 필드 속성을 변경합니다'),': ';
if(DBQuery::execute("ALTER TABLE {$database['prefix']}Sessions CHANGE data data TEXT DEFAULT NULL"))
echo '',_t('성공'),'
';
else
echo '',_t('실패'),'';
}
if(DBQuery::queryCell("DESC {$database['prefix']}Categories name",'Type')=='varchar(32)'){
$changed=true;
echo '- ',_t('분류 테이블의 이름 필드 속성을 변경합니다'),': ';
if(DBQuery::execute("ALTER TABLE {$database['prefix']}Categories CHANGE name name VARCHAR(127) NOT NULL"))
echo '',_t('성공'),'
';
else
echo '',_t('실패'),'';
}
if(DBQuery::queryCell("DESC {$database['prefix']}Categories label",'Type')=='varchar(80)'){
$changed=true;
echo '- ',_t('분류 테이블의 라벨 필드 속성을 변경합니다'),': ';
if(DBQuery::execute("ALTER TABLE {$database['prefix']}Categories CHANGE label label VARCHAR(255) NOT NULL"))
echo '',_t('성공'),'
';
else
echo '',_t('실패'),'';
}
if(DBQuery::queryCell("DESC {$database['prefix']}BlogSettings timezone",'Type')!='varchar(32)'){
$changed=true;
echo '- ',_t('블로그 설정 테이블의 시간대 필드 속성을 변경합니다'),': ';
if(DBQuery::execute("ALTER TABLE {$database['prefix']}BlogSettings CHANGE timezone timezone VARCHAR(32) NOT NULL DEFAULT 'GMT'")){
DBQuery::execute("UPDATE {$database['prefix']}BlogSettings SET timezone = 'GMT' WHERE timezone <> '32400' AND timezone <> '-18000'");
DBQuery::execute("UPDATE {$database['prefix']}BlogSettings SET timezone = 'Asia/Seoul' WHERE timezone = '32400'");
DBQuery::execute("UPDATE {$database['prefix']}BlogSettings SET timezone = 'America/New_York' WHERE timezone = '-18000'");
echo '',_t('성공'),'
';
}else{
echo '',_t('실패'),'';
}
}
if(DBQuery::queryCell("DESC {$database['prefix']}BlogSettings language",'Type')!='varchar(5)'){
$changed=true;
echo '- ',_t('블로그 설정 테이블의 언어 필드 속성을 변경합니다'),': ';
if(DBQuery::execute("ALTER TABLE {$database['prefix']}BlogSettings CHANGE language language VARCHAR(5) NOT NULL DEFAULT 'en'"))
echo '',_t('성공'),'
';
else
echo '',_t('실패'),'';
}?>