[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1412] Delete user from relationships-related tables.
From: |
Toby Inkster |
Subject: |
[Librefm-commits] [1412] Delete user from relationships-related tables. |
Date: |
Fri, 08 May 2009 11:51:11 +0000 |
Revision: 1412
http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1412
Author: tobyink
Date: 2009-05-08 11:51:10 +0000 (Fri, 08 May 2009)
Log Message:
-----------
Delete user from relationships-related tables.
Modified Paths:
--------------
trunk/nixtape/delete-profile.php
Modified: trunk/nixtape/delete-profile.php
===================================================================
--- trunk/nixtape/delete-profile.php 2009-05-08 11:42:49 UTC (rev 1411)
+++ trunk/nixtape/delete-profile.php 2009-05-08 11:51:10 UTC (rev 1412)
@@ -38,7 +38,6 @@
$smarty->display('error.tpl');
die ();
} else {
- $mdb2->exec("DELETE FROM Users WHERE lower(username) =
".$mdb2->quote(strtolower($username), 'text'));
$mdb2->exec("DELETE FROM Scrobble_Sessions WHERE username =
".$mdb2->quote($username, 'text'));
$mdb2->exec("DELETE FROM Delete_Request WHERE username =
".$mdb2->quote($username, 'text'));
$mdb2->exec("DELETE FROM Auth WHERE username =
".$mdb2->quote($username, 'text'));
@@ -46,6 +45,11 @@
$mdb2->exec("DELETE FROM Radio_Sessions WHERE username =
".$mdb2->quote($username, 'text'));
$mdb2->exec("DELETE FROM Recovery_Request WHERE username =
".$mdb2->quote($username, 'text'));
$mdb2->exec("DELETE FROM Scrobbles WHERE username =
".$mdb2->quote($username, 'text'));
+ $mdb2->exec("DELETE FROM User_Relationship_Flags WHERE uid1 =
".$mdb2->quote($this_user->uniqueid, 'integer'));
+ $mdb2->exec("DELETE FROM User_Relationship_Flags WHERE uid2 =
".$mdb2->quote($this_user->uniqueid, 'integer'));
+ $mdb2->exec("DELETE FROM User_Relationships WHERE uid1 =
".$mdb2->quote($this_user->uniqueid, 'integer'));
+ $mdb2->exec("DELETE FROM User_Relationships WHERE uid2 =
".$mdb2->quote($this_user->uniqueid, 'integer'));
+ $mdb2->exec("DELETE FROM Users WHERE lower(username) =
".$mdb2->quote(strtolower($username), 'text'));
session_destroy();
header("Location: index.php");
}
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1412] Delete user from relationships-related tables.,
Toby Inkster <=