Changeset 3407

Timestamp:

06/05/07 22:17:53 (18 months ago)

Author:

inureyes

Message:

#408

• deleteUser function 구현 변경 및 해당 함수 추가
  
• invitation cancel 구현 변경
  

Location:

trunk

Files:

• blog/owner/setting/teamblog/cancelInvite/index.php (modified) (1 diff)
• blog/owner/setting/teamblog/deleteUser/index.php (modified) (1 diff)
• lib/model/blog.blogSetting.php (modified) (1 diff)
• lib/model/blog.teamblog.php (modified) (1 diff)

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

@@ -11 +11 @@
 require ROOT . '/lib/includeForBlogOwner.php';
 requireStrictRoute();
-function TeamcancelInvite($userid){
-    global $owner,$database;
-    if(DBQuery::queryCell("SELECT count(*) FROM `{$database['prefix']}Users` WHERE `userid` = $userid AND `lastLogin` = 0")==0)
-        return false;
-    if(DBQuery::queryCell("SELECT count(*) FROM `{$database['prefix']}Users` WHERE `userid` = $userid AND `host` = $owner")===0)
-        return false;
-    if(DBQuery::execute("DELETE FROM `{$database['prefix']}Users` WHERE `userid` = $userid")){
-        if(DBQuery::execute("DELETE FROM `{$database['prefix']}BlogSettings` WHERE `owner` = $userid")){
-            if(DBQuery::execute("DELETE FROM `{$database['prefix']}SkinSettings` WHERE `owner` = $userid")){
-                if(DBQuery::execute("DELETE FROM `{$database['prefix']}FeedSettings` WHERE `owner` = $userid")){
-                    DBQuery::execute("DELETE FROM `{$database['prefix']}Teamblog` WHERE teams='$owner' and userid='$userid'");
-                    return true;
-                }else{
-                    return false;
-                }
-            }else{
-                return false;
-            }
-        }else{
-            return false;
-        }
-    }else{
-        return false;
-    }
-}
-if (TeamcancelInvite($_POST['userid'])) {
+
+if (cancelInviteAsTeam($_POST['userid'])) {
     respondResultPage(0);
 }
-respondResultPage( - 1);
+respondResultPage(-1);
 ?>

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

@@ -11 +11 @@
 require ROOT . '/lib/includeForBlogOwner.php';
 requireStrictRoute();
-function deleteUser($userid){
-    global $owner, $database;
 
-    $result = DBQuery::query("SELECT Id FROM `{$database['prefix']}TeamEntryRelations` WHERE Owner='$owner' AND Team='$userid'");
-    while($res = mysql_fetch_array($result)){
-        DBQuery::execute("UPDATE `{$database['prefix']}TeamEntryRelations` SET Team='$owner' WHERE Owner='$owner' AND Id='$res[Id]'");
-    }
-    $En=mysql_fetch_array(DBQuery::query("SELECT enduser FROM `{$database['prefix']}Teamblog` WHERE teams='$owner' AND userid='$userid'"));
-    $isp = intval($En['enduser']-$userid);
-    if($isp == 0 || $isp == 1){
-        DBQuery::execute("DELETE FROM `{$database['prefix']}Teamblog` WHERE teams='$userid' and userid='$userid'");
-    }
-    if(DBQuery::execute("DELETE FROM `{$database['prefix']}Teamblog` WHERE teams='$owner' and userid='$userid'")){
-        $En=DBQuery::queryCell("SELECT userid FROM `{$database['prefix']}Teamblog` WHERE userid='$userid'");
-        if(empty($En)){
-            @DBQuery::execute("DELETE FROM `{$database['prefix']}Users` WHERE `userid` = $userid");
-            @DBQuery::execute("DELETE FROM `{$database['prefix']}BlogSettings` WHERE `owner` = $userid");
-            @DBQuery::execute("DELETE FROM `{$database['prefix']}SkinSettings` WHERE `owner` = $userid");
-            @DBQuery::execute("DELETE FROM `{$database['prefix']}FeedSettings` WHERE `owner` = $userid");
-        }
-        return true;
-    }else{
-        return false;
-    }
-}
 if (deleteUser($_POST['userid'])) {
     respondResultPage(0);
 }
-respondResultPage( - 1);
+respondResultPage(-1);
 ?>

trunk/lib/model/blog.blogSetting.php

@@ -377 +377 @@
     return DBQuery::execute($sql);
 }
+
+function deleteUser($userid){
+    global $owner, $database;
+
+    $result = DBQuery::queryColumn("SELECT id 
+        FROM `{$database['prefix']}TeamEntryRelations` 
+        WHERE owner='$owner' 
+            AND team='$userid'");
+    foreach($result as $id){    // Make all posts belong to owner.
+        DBQuery::execute("UPDATE `{$database['prefix']}TeamEntryRelations` 
+            SET team='$owner' 
+            WHERE owner=".$owner." AND id=".$id);
+    }
+
+    $enduser = DBQuery::queryCell("SELECT enduser FROM `{$database['prefix']}Teamblog` WHERE teams='$owner' AND userid='$userid'"));
+    $isp = intval($enduser - $userid);
+    if($isp == 0 || $isp == 1){
+        DBQuery::execute("DELETE FROM `{$database['prefix']}Teamblog` WHERE teams='$userid' and userid='$userid'");
+    }
+    if(DBQuery::execute("DELETE FROM `{$database['prefix']}Teamblog` WHERE teams='$owner' and userid='$userid'")){
+        $En=DBQuery::queryCell("SELECT userid FROM `{$database['prefix']}Teamblog` WHERE userid='$userid'");
+        if(empty($En)){
+            @DBQuery::execute("DELETE FROM `{$database['prefix']}Users` WHERE `userid` = $userid");
+            @DBQuery::execute("DELETE FROM `{$database['prefix']}BlogSettings` WHERE `owner` = $userid");
+            @DBQuery::execute("DELETE FROM `{$database['prefix']}SkinSettings` WHERE `owner` = $userid");
+            @DBQuery::execute("DELETE FROM `{$database['prefix']}FeedSettings` WHERE `owner` = $userid");
+        }
+        return true;
+    } else {
+        return false;
+    }
+}
 ?>

trunk/lib/model/blog.teamblog.php

@@ -148 +148 @@
 }
 
+function cancelInviteAsTeam($userid){
+    global $owner,$database;
+    if(DBQuery::queryCell("SELECT count(*) FROM `{$database['prefix']}Users` WHERE `userid` = $userid AND `lastLogin` = 0")==0)
+        return false;
+    if(DBQuery::queryCell("SELECT count(*) FROM `{$database['prefix']}Users` WHERE `userid` = $userid AND `host` = $owner")===0)
+        return false;
+    if(DBQuery::execute("DELETE FROM `{$database['prefix']}Users` WHERE `userid` = $userid")){
+        if(DBQuery::execute("DELETE FROM `{$database['prefix']}BlogSettings` WHERE `owner` = $userid")){
+            if(DBQuery::execute("DELETE FROM `{$database['prefix']}SkinSettings` WHERE `owner` = $userid")){
+                if(DBQuery::execute("DELETE FROM `{$database['prefix']}FeedSettings` WHERE `owner` = $userid")){
+                    DBQuery::execute("DELETE FROM `{$database['prefix']}Teamblog` WHERE teams='$owner' and userid='$userid'");
+                    return true;
+                } else {
+                    return false;
+                }
+            } else {
+                return false;
+            }
+        } else {
+            return false;
+        }
+    } else {
+        return false;
+    }
+}
+
 ?>