Changeset 3311

Timestamp:

05/23/07 16:26:32 (20 months ago)

Author:

inureyes

Message:

#408

• 팀블로그들 이름 쿼리하는 부분 개선
  
• 이후 쿼리수 자체를 줄여야한다.
  

Files:

• sandbox/components/Textcube.Core.php (modified) (2 diffs)

sandbox/components/Textcube.Core.php

@@ -138 +138 @@
             }
             </script>');
-        $blogn .= '<select id="teamblog" onChange="teamblog();"><optgroup label="'._t('내가 가입한 팀블로그').'">';
+        $blogn .= '<select id="teamblog" onChange="teamblog();"><optgroup label="'._t('참여중인 블로그').'">';
     
         $isEnd = $_SESSION['admin']+1;
@@ -147 +147 @@
         }
     
-        $result = DBQuery::query("SELECT * FROM ".$database['prefix']."Teamblog WHERE userid='".$_SESSION['admin']."'");
-        while($res = mysql_fetch_array($result)){
+        $teamblogInfo = DBQuery::queryAll("SELECT * FROM ".$database['prefix']."Teamblog WHERE userid='".$_SESSION['admin']."'");
+        foreach($teamblogInfo as $res){
             if($res['teams'] == $res['userid'] && $res['enduser'] > '0'){
                 continue;
             } else {
-                $itmp = DBQuery::queryCell("SELECT title FROM ".$database['prefix']."BlogSettings WHERE owner='".$res['teams']."'");
-                if(empty($itmp['title'])){
-                    $itmp = DBQuery::queryCell("SELECT name FROM ".$database['prefix']."Users WHERE userid='".$res['teams']."'");
-                    $title = $itmp['name'] .'님의 블로그';
-                } else { 
-                    $title = $itmp['title'];
+                $title = DBQuery::queryCell("SELECT title FROM ".$database['prefix']."BlogSettings WHERE owner='".$res['teams']."'");
+                if(empty($title)){
+                    $title = _f('%1 님의 블로그',DBQuery::queryCell("SELECT name FROM ".$database['prefix']."Users WHERE userid='".$res['teams']."'"));
                 }
                 $blogn .= '<option value="' . $res['teams'] . '"';
                 if($res['teams'] == $owner) $blogn .= ' selected';
-                $blogn .= ' />' . $title . '</option>';
+                $blogn .= '>' . $title . '</option>';
             }
         }