Changeset 3309

Timestamp:

05/21/07 18:17:45 (20 months ago)

Author:

inureyes

Message:

#408

• DB 쿼리 시 대소문자 부분 처리.
  
• 이제 비효율 쿼리 제거 갑니다.
  

Files:

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

sandbox/components/Textcube.Core.php

@@ -41 +41 @@
     function name(){
         requireComponent('Eolin.PHP.Core');
-        global $database, $owner, $entry, $_SESSION;
+        global $database, $owner, $entry;
 
         $res = DBQuery::queryRow("SELECT * FROM ".$database['prefix']."Teamblog WHERE teams='$owner' and userid='$owner' " );
@@ -58 +58 @@
         $styleS = '';
         $styleE = '';
-    
-        $ttmp = DBQuery::queryRow("SELECT * FROM ".$database['prefix']."Teamblog WHERE teams='".$owner."' and userid='".$_SESSION['admin']."' " );
-        $stmp = DBQuery::queryRow("SELECT * FROM ".$database['prefix']."TeamEntryRelations WHERE owner='".$owner."' and id='".$entry['id']."'");
-        $itmp = DBQuery::queryRow("SELECT a.*, b.name FROM {$database['prefix']}Teamblog a, {$database['prefix']}Users b WHERE a.teams='".$owner."' and a.userid='".$stmp['team']."' AND a.userid=b.userid");
+
+        $ttmp = DBQuery::queryRow("SELECT * 
+                FROM ".$database['prefix']."Teamblog 
+                WHERE teams='".$owner."' 
+                    and userid='".$_SESSION['admin']."'");
+        $stmp = DBQuery::queryRow("SELECT * 
+                FROM ".$database['prefix']."TeamEntryRelations 
+                WHERE owner='".$owner."' 
+                    and id='".$entry['id']."'");
+        $itmp = DBQuery::queryRow("SELECT a.*, b.name 
+                FROM {$database['prefix']}Teamblog a, 
+                    {$database['prefix']}Users b 
+                WHERE a.teams='".$owner."' 
+                    AND a.userid='".$stmp['team']."' 
+                    AND a.userid=b.userid");
  
         if(empty($font_style)){
@@ -88 +99 @@
         }
     
-        if(($ttmp['Posting'] == 1) || ($stmp['Team'] == $_SESSION['admin'])) $name[2] = 1;
+        if(($ttmp['posting'] == 1) || ($stmp['team'] == $_SESSION['admin'])) $name[2] = 1;
  
         return $name;
@@ -94 +105 @@
 
     function PC(){
-        global $database, $owner, $_SESSION;
+        global $database, $owner;
         $itmp = DBQuery::queryRow("SELECT * FROM ".$database['prefix']."Teamblog WHERE teams='".$owner."' and userid='".$_SESSION['admin']."'");
         $access = 0;
-        if(!empty($itmp['Posting'])) $access = 1;
+        if(!empty($itmp['posting'])) $access = 1;
         return $access;
      }
       
      function AC(){
-        global $database, $owner, $_SESSION;
+        global $database, $owner;
         $itmp = DBQuery::queryRow("SELECT * FROM ".$database['prefix']."Teamblog WHERE teams='".$owner."' and userid='".$_SESSION['admin']."'");
         $access = 0;
@@ -111 +122 @@
      
      function myBlog(){
-        global $database, $owner, $_SESSION, $blogURL, $_SERVER, $blog, $service;
+        global $database, $owner, $blogURL, $_SERVER, $blog, $service;
         
         if($service['type'] == "path")