Changeset 3408

Timestamp:

06/05/07 22:37:19 (18 months ago)

Author:

inureyes

Message:

#408

• teamblog permission 조정 부분 수정
  

Location:

trunk

Files:

• blog/owner/setting/teamblog/index.php (modified) (1 diff)
• blog/owner/setting/teamblog/isAdmin/index.php (modified) (2 diffs)
• lib/model/blog.teamblog.php (modified) (1 diff)

trunk/blog/owner/setting/teamblog/index.php

@@ -248 +248 @@
                                 function teamblog_admin(stype, userid) {
                                     
-                                    var request = new HTTPRequest("POST", "<?php    echo $blogURL;?>/owner/setting/teamblog/isAdmin/");
+                                    var request = new HTTPRequest("POST", "<?php echo $blogURL;?>/owner/setting/teamblog/isAdmin/");
                                     request.onSuccess = function() {
                                         PM.showMessage("<?php   echo _t('설정을 변경했습니다.');?>", "center", "bottom");

trunk/blog/owner/setting/teamblog/isAdmin/index.php

@@ -1 @@
-<?php
+<?php
 /// Copyright (c) 2004-2007, Needlworks / Tatter Network Foundation
 /// All rights reserved. Licensed under the GPL.
@@ -12 +12 @@
 require ROOT . '/lib/includeForBlogOwner.php';
 requireStrictRoute();
-function CHgetIdentify($userid){
-    global $database;
-
-    $email = DBQuery::queryCell("SELECT loginid FROM {$database['prefix']}Users WHERE userid=$userid");
-    
-    $Itmp = explode("@", $email);
-    $Id = $Itmp[0];
-
-    while(1){
-        $check = DBQuery::queryCell("SELECT name FROM {$database['prefix']}BlogSettings WHERE name=$Id");
-        if(!empty($check)){
-            $Id = $Itmp . rand(10,999);     
-        }
-        else{
-            break;
-        }
-    }
-    
-    return $Id; 
-}
-function changeAdmin($owner,$stype,$userid){
-    global $database;
-    if(empty($stype)||empty($userid))
-        return false;
-
-    $res = DBQuery::queryRow("SELECT admin, posting, enduser 
-            FROM {$database['prefix']}Teamblog 
-            WHERE teams='$owner' and userid='$userid'");
-
-    if($stype == 1){
-        if(empty($res['Admin'])) $admin = 1;
-        else $admin = 0;
-        $sql = "UPDATE `{$database['prefix']}Teamblog` 
-            SET admin = '$admin' 
-            WHERE teams = '$owner' and userid = '$userid'";
-    }
-    else if($stype == 2){
-        if(empty($res['Posting'])) $post = 1;
-        else $post = 0;
-        $sql = "UPDATE `{$database['prefix']}Teamblog` SET 
-            posting = '$post' 
-            WHERE teams = '$owner' and userid = '$userid'";
-    }
-    else{
-        $result = DBQuery::query("SELECT * 
-                FROM `{$database['prefix']}Teamblog` 
-                WHERE teams = '$userid' and userid = '$userid'");
-        if(!$result||(mysql_affected_rows()==0)){
-            $name = DBQuery::queryCell("SELECT name 
-                    FROM {$database['prefix']}Users 
-                    WHERE userid = '$userid'");
-            $profile = _f('%1 님의 글입니다.',$name);
-            DBQuery::query("INSERT INTO `{$database['prefix']}Teamblog`  
-                    VALUES('$userid', '$userid', '1', '1', '1', '$profile', '', '0', '#000000', '10', '0', UNIX_TIMESTAMP(), '0')");
-        }
-        
-        $enduser = $res['enduser'] - $userid;
-        if(empty($enduser)){
-            $enduser = $userid + 1;
-            $new_name = CHgetIdentify($userid);
-        }
-        else{
-            $enduser = $userid;
-            $new_name = substr(md5(time()),4,9);
-        }
-        $Psql = "UPDATE `{$database['prefix']}BlogSettings` 
-            SET name='$new_name' 
-            WHERE owner='$userid'";
-        DBQuery::execute($Psql);
-        $sql="UPDATE `{$database['prefix']}Teamblog` 
-            SET enduser = '$enduser' 
-            WHERE teams='$owner' and userid = '$userid'";
-    }
-    
-    
-    return DBQuery::execute($sql);
-}
-if (changeAdmin($owner,$_POST['stype'],$_POST['userid'])) {
+if (changeACLonTeamblog($owner,$_POST['stype'],$_POST['userid'])) {
     respondResultPage(0);
 }
-respondResultPage( - 1);
+respondResultPage(-1);
 ?>

trunk/lib/model/blog.teamblog.php

@@ -174 +174 @@
 }
 
+function changeACLonTeamblog($owner,$stype,$userid){  // Change user priviledge on the blog.
+    global $database;
+    if(empty($stype) || empty($userid))
+        return false;
+
+    $res = DBQuery::queryRow("SELECT admin, posting, enduser 
+            FROM {$database['prefix']}Teamblog 
+            WHERE teams='$owner' and userid='$userid'");
+
+    if($stype == 1){    // When changing permission,
+        if(empty($res['admin'])) $admin = 1;
+        else $admin = 0;
+        $sql = "UPDATE `{$database['prefix']}Teamblog` 
+            SET admin = ".$admin." 
+            WHERE teams = ".$owner." and userid = ".$userid;
+    } else if($stype == 2){
+        if(empty($res['posting'])) $post = 1;
+        else $post = 0;
+        $sql = "UPDATE `{$database['prefix']}Teamblog` 
+            SET posting = ".$post."
+            WHERE teams = ".$owner." and userid = ".$userid;
+    } else {    // When changing identity,
+        $result = DBQuery::query("SELECT * 
+                FROM `{$database['prefix']}Teamblog` 
+                WHERE teams = '$userid' and userid = '$userid'");
+        if(!$result||(mysql_affected_rows()==0)){
+            $name = DBQuery::queryCell("SELECT name 
+                    FROM {$database['prefix']}Users 
+                    WHERE userid = '$userid'");
+            $profile = _f('%1 님의 글입니다.',$name);
+            DBQuery::query("INSERT INTO `{$database['prefix']}Teamblog`  
+                    VALUES('$userid', '$userid', '1', '1', '1', '$profile', '', '0', '#000000', '10', '0', UNIX_TIMESTAMP(), '0')");
+        }
+        
+        $enduser = $res['enduser'] - $userid;
+        if(empty($enduser)){
+            $enduser = $userid + 1;
+            $new_name = CHgetIdentify($userid);
+        } else {
+            $enduser = $userid;
+            $new_name = substr(md5(time()),4,9);
+        }
+        DBQuery::execute("UPDATE `{$database['prefix']}BlogSettings` 
+            SET name='$new_name' 
+            WHERE owner='$userid'");
+        $sql = "UPDATE `{$database['prefix']}Teamblog` 
+            SET enduser = '$enduser' 
+            WHERE teams='$owner' and userid = '$userid'";
+    }
+    
+    return DBQuery::execute($sql);
+}
+
+function CHgetIdentify($userid){
+    global $database;
+
+    $email = DBQuery::queryCell("SELECT loginid FROM {$database['prefix']}Users WHERE userid=$userid");
+    
+    $Itmp = explode("@", $email);
+    $Id = $Itmp[0];
+
+    while(1){
+        $check = DBQuery::queryCell("SELECT name FROM {$database['prefix']}BlogSettings WHERE name=$Id");
+        if(!empty($check)){
+            $Id = $Itmp . rand(10,999);     
+        } else {
+            break;
+        }
+    }
+    
+    return $Id; 
+}
+
 ?>