Changeset 1449

Timestamp:

08/05/07 13:49:33 (1 year ago)

Author:

jm3

Message:

clean delete user functionality

Files:

• feedmelinks/modules/utils.inc.php (modified) (3 diffs)
• feedmelinks/testing/delete_user.php (added)

feedmelinks/modules/utils.inc.php

@@ -11 +11 @@
-define( "IDLENESS", 1 );
-define( "SPAMMING", 2 );
+
+
+/* functions */
+
+/* deleting */
+
+function delete_links_for_user( $u, $confirm_true ) {
+        if( !$u )
+                return;
+        $q = run_query( getQuery( "links_for_user", $u ));
+        $c = mysql_num_rows($q);
+        $count = 0;
+        echo "for-each link:\n";
+        while( $row = mysql_fetch_assoc( $q ) ) {
+                $ID = urldecode( $row["ID"] );
+                deleteCategorizationForLink( $ID );
+                deleteLink( $ID, $u );
+                $count++;
+        }
+        return $count;
+}
+
+function delete_tags_for_user( $u, $confirm_true ) {
+        if( !$u )
+                return;
+        echo "for-each tag\n";
+
+        $q = run_query( getQuery( "tags_for_user", $u ));
+        $c = mysql_num_rows($q);
+        $count = 0;
+        echo "for-each tag:\n";
+        while( $row = mysql_fetch_assoc( $q ) ) {
+                $ID = urldecode( $row["ID"] );
+                delete_tag( $u, $ID );
+                $count++;
+        }
+        return $count;
+}
+
+function delete_tag( $u, $t ) {
+        if( !$u || !$t )
+                return;
+        echo "  FIXME: delete the tag\n";
+        $qs = getQuery( "delete_tag", $u, $t );
+        $q = run_query( $qs );
+        echo $q;
+}
+
+function delete_user( $u, $confirm_true ) {
+        if( !$u )
+                return;
+        echo "deleted " . delete_links_for_user( $u, $confirm_true ) . " links.\n";
+        echo "deleted " . delete_tags_for_user(  $u, $confirm_true ) . " tags.\n";
+        echo "FIXME: delete the comments\n"; # FIXME: not implemented
+}
-
-function is_whitelisted( $user ) {
@@ -2477 +2532 @@
-                        SELECT * FROM tags WHERE name = 'private' AND userid = '" . urlencode( $args[1] ) . "';";
-
+        } else if( $argWhichQuery  == "tags_for_user" ) {
+                $user = urlencode( $args[1] );
+    return "
+                SELECT * FROM tags WHERE userid = '$user';";
+        
+        } else if( $argWhichQuery  == "links_for_user" ) {
+                $user = urlencode( $args[1] );
+                return "
+                SELECT * FROM links WHERE userid = '$user'";
+
-        } else if( $argWhichQuery  == "links_tagged_for_me" ) {
-                $me = urlencode( $args[1] );
@@ -2662 +2727 @@
-  } else if( $argWhichQuery  == "delete_tag" ) {
-    return "
-ID = " . $args[1
+userid = '" . urlencode( $args[1] ) . "' AND ID = " . $args[2
-
-  } else if( $argWhichQuery  == "add_new_category_xref" ) {