summaryrefslogtreecommitdiff
path: root/includes/temp_functions.php
diff options
context:
space:
mode:
authorINOPIAE <inopiae@cacert.org>2013-01-07 19:51:44 +0100
committerINOPIAE <inopiae@cacert.org>2013-01-07 19:51:44 +0100
commita2f9b3f2f699f26fff8e7b816ef330d8c32bede4 (patch)
tree5661f8e08d793f7507289266092a8b711c838825 /includes/temp_functions.php
parent2afe862389e80078967ee029b1d8ea2010611f1e (diff)
downloadcacert-devel-a2f9b3f2f699f26fff8e7b816ef330d8c32bede4.tar.gz
cacert-devel-a2f9b3f2f699f26fff8e7b816ef330d8c32bede4.tar.xz
cacert-devel-a2f9b3f2f699f26fff8e7b816ef330d8c32bede4.zip
bug 893: fixed some sql statements
Diffstat (limited to 'includes/temp_functions.php')
-rw-r--r--includes/temp_functions.php14
1 files changed, 6 insertions, 8 deletions
diff --git a/includes/temp_functions.php b/includes/temp_functions.php
index 4373d46..cdf3a98 100644
--- a/includes/temp_functions.php
+++ b/includes/temp_functions.php
@@ -85,14 +85,14 @@ function account_delete($id, $arbno, $adminid){
$query = "select * from `domains` where `memid`='".$id."'";
$res=mysql_query($query);
while($row = mysql_fetch_assoc($res)){
- account_email_delete($row['id']);
+ account_domain_delete($row['id']);
}
//clear alert settings
- mysql_query("update `alerts` set `general`='1' where `memid`='$id'");
- mysql_query("update `alerts` set `country`='1' where `memid`='$id'");
- mysql_query("update `alerts` set `regional`='1' where `memid`='$id'");
- mysql_query("update `alerts` set `radius`='1' where `memid`='$id'");
+ mysql_query("update `alerts` set `general`='0' where `memid`='$id'");
+ mysql_query("update `alerts` set `country`='0' where `memid`='$id'");
+ mysql_query("update `alerts` set `regional`='0' where `memid`='$id'");
+ mysql_query("update `alerts` set `radius`='0' where `memid`='$id'");
//set default location
$query = "update `users` set `locid`='2256755', `regid`='243', `ccid`='12' where `id`='".$id."'";
@@ -117,9 +117,7 @@ function account_delete($id, $arbno, $adminid){
$q .= substr($pool,(rand()%(strlen ($pool))), 1);
$a .= substr($pool,(rand()%(strlen ($pool))), 1);
}
- $query = "update `users` set `Q".$i."`='".$q."',
- `A".$i."`='".$a."',
- where `id`='".$id."'";
+ $query = "update `users` set `Q$i`='$q', `A$i`='$a' where `id`='".$id."'";
mysql_query($query);
}