Changeset 3299 for sandbox/blog/checkup/index.php

Timestamp:

05/21/07 01:56:13 (20 months ago)

Author:

inureyes

Message:

#408

• 팀블로그 소스 이식
  
• 차칸아이님 소스 기반으로 태터툴즈 코드 일관성 유지를 위하여 전체적으로 수정하였음.
  
  • 아직 멀었다.
    

Files:

• sandbox/blog/checkup/index.php (modified) (1 diff)

sandbox/blog/checkup/index.php

@@ -492 +492 @@
 }
 
+if (!doesExistTable($database['prefix'] . 'Teamblog')) {
+    $changed = true;
+    echo '<li>', _text('팀블로그 기능을 위한 테이블을 추가합니다.'), ': ';
+    $query = "
+        CREATE TABLE {$database['prefix']}Teamblog (
+            teams int(11) NOT NULL default 0,
+            userid int(11) NOT NULL default 1,
+            enduser int(11) NOT NULL default 0,
+            admin int(11) NOT NULL default 0,
+            posting int(11) NOT NULL default 0,
+            profile text NULL default '',
+            logo varchar(15) default '',
+            font_style int(11) NOT NULL default 0,
+            font_color varchar(10) NOT NULL default '#000000',
+            font_size int(11) NOT NULL default 10,
+            font_bold int(11) NOT NULL default 0,
+            created int(11) NOT NULL default 0,
+            lastLogin int(11) NOT NULL default 0,
+            PRIMARY KEY (teams,userid,admin)
+        ) TYPE=MyISAM
+    ";
+    if (DBQuery::execute($query . ' DEFAULT CHARSET=utf8') || DBQuery::execute($query)) {
+        while($row = DBQuery::queryRow("SELECT * FROM `{$database['prefix']}Users` ORDER BY userid")){
+            DBQuery::execute("INSERT INTO `{$database['prefix']}Teamblog` VALUES('".$row['userid']."', '".$row['userid']."','0','1','1', '".$row['name']."', '', '0', '#000000', '10', '0', '".$row['created']."', '0')");
+        }
+        echo '<span style="color:#33CC33;">', _text('성공'), '</span></li>';
+    } else
+        echo '<span style="color:#FF0066;">', _text('실패'), '</span></li>';
+}
+
+if (!doesExistTable($database['prefix'] . 'TeamEntryRelations')) {
+    $changed = true;
+    echo '<li>', _text('팀블로그 연관글 기능을 위한 테이블을 추가합니다.'), ': ';
+    $query = "
+        CREATE TABLE {$database['prefix']}TeamEntryRelations (
+            owner int(11) NOT NULL default 1,
+            id int(11) NOT NULL default 1,
+            team int(11) NOT NULL default 1,
+            PRIMARY KEY (owner,id,team)
+        ) TYPE=MyISAM
+    ";
+    if (DBQuery::execute($query . ' DEFAULT CHARSET=utf8') || DBQuery::execute($query)) {
+        while($row = DBQuery::queryRow("SELECT * FROM `{$database['prefix']}Entries` ORDER BY owner")){
+            DBQuery::execute("INSERT INTO   `{$database['prefix']}TeamEntryRelations`  VALUES('".$row['owner']."', '".$row['id']."','".$row['owner']."')");
+        }
+        echo '<span style="color:#33CC33;">', _text('성공'), '</span></li>';
+    } else
+        echo '<span style="color:#FF0066;">', _text('실패'), '</span></li>';
+}
+
 $filename = ROOT . '/.htaccess';
 $fp = fopen($filename, "r");