1 files changed, 0 insertions, 224 deletions
diff --git a/includes/temp_functions.php b/includes/temp_functions.php
deleted file mode 100644
index 3a75263..0000000
--- a/includes/temp_functions.php
+++ /dev/null
@@ -1,224 +0,0 @@
-<?php
-//just temoprary file to find all function needed for account delete
-
-function account_email_delete($mailid){
-//deletes an email entry from an acount
-//revolkes all certifcates for that email address
-//called from www/account.php if($process != "" && $oldid == 2)
-//called from www/diputes.php if($type == "reallyemail") / if($action == "accept")
-//called from account_delete
-	$mailid = intval($mailid);
-	$query = "select `emailcerts`.`id`
-		from `emaillink`,`emailcerts` where
-		`emailid`='$mailid' and `emaillink`.`emailcertsid`=`emailcerts`.`id` and
-		`revoked`=0 and UNIX_TIMESTAMP(`expire`)-UNIX_TIMESTAMP() > 0
-			group by `emailcerts`.`id`";
-	$dres = mysql_query($query);
-	while($drow = mysql_fetch_assoc($dres)){
-		mysql_query("update `emailcerts` set `revoked`='1970-01-01 10:00:01', `disablelogin`=1 where `id`='".$drow['id']."'");
-	}
-	$query = "update `email` set `deleted`=NOW() where `id`='$mailid'";
-	mysql_query($query);
-}
-
-function account_domain_delete($domainid){
-//deletes an domain entry from an acount
-//revolkes all certifcates for that domain address
-//called from www/account.php if($process != "" && $oldid == 9)
-//called from www/diputes.php if($type == "reallydomain") / if($action == "accept")
-//called from account_delete
-	$domainid = intval($domainid);
-	$query = "select distinct `domaincerts`.`id`
-		from `domaincerts`, `domlink`
-		where `domaincerts`.`domid` = '$domainid'
-		or (
-		`domaincerts`.`id` = `domlink`.`certid`
-		and `domlink`.`domid` = '$domainid')";
-	$dres = mysql_query($query);
-	while($drow = mysql_fetch_assoc($dres))
-	{
-		mysql_query(
-			"update `domaincerts`
-			set `revoked`='1970-01-01 10:00:01'
-			where `id` = '".$drow['id']."'
-			and `revoked` = 0
-			and UNIX_TIMESTAMP(`expire`) -
-			UNIX_TIMESTAMP() > 0");
-	}
-	mysql_query(
-		"update `domains`
-		set `deleted`=NOW()
-		where `id` = '$domainid'");
-}
-
-function account_delete($id, $arbno, $adminid){
-//deletes an account following the deleted account routnie V3
-// called from www/account.php if($oldid == 50 && $process != "")
-//change password
-	$id = intval($id);
-	$arbno = mysql_real_escape_string($arbno);
-	$adminid = intval($adminid);
-	$pool = 'abcdefghijklmnopqrstuvwxyz';
-	$pool .= '0123456789!()§';
-	$pool .= 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
-	srand ((double)microtime()*1000000);
-	$password="";
-	for($index = 0; $index < 30; $index++)
-	{
-		$password .= substr($pool,(rand()%(strlen ($pool))), 1);
-	}
-	mysql_query("update `users` set `password`=sha1('".$password."') where `id`='".$id."'");
-
-//create new mail for arbitration number
-	$query = "insert into `email` set `email`='".$arbno."@cacert.org',`memid`='".$id."',`created`=NOW(),`modified`=NOW(), `attempts`=-1";
-	mysql_query($query);
-	$emailid = mysql_insert_id();
-
-//set new mail as default
-	$query = "update `users` set `email`='".$arbno."@cacert.org' where `id`='".$id."'";
-	mysql_query($query);
-
-//delete all other email address
-	$query = "select * from `email` where `memid`='".$id."' and `id`!='".$emailid."'" ;
-	$res=mysql_query($query);
-	while($row = mysql_fetch_assoc($res)){
-		account_email_delete($row['id']);
-	}
-
-//delete all domains
-	$query = "select * from `domains` where `memid`='".$id."'";
-	$res=mysql_query($query);
-	while($row = mysql_fetch_assoc($res)){
-		account_domain_delete($row['id']);
-	}
-
-//clear alert settings
-	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."'";
-	mysql_query($query);
-
-//clear listings
-	$query = "update `users` set `listme`=' ',`contactinfo`=' ' where `id`='".$id."'";
-	mysql_query($query);
-
-//set lanuage to default
-	//set default language
-	mysql_query("update `users` set `language`='en_AU' where `id`='".$id."'");
-	//delete secondary langugaes
-	mysql_query("delete from `addlang` where `userid`='".$id."'");
-
-//change secret questions
-	for($i=1;$i<=5;$i++){
-		$q="";
-		$a="";
-		for($index = 0; $index < 30; $index++)
-		{
-			$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."'";
-		mysql_query($query);
-	}
-
-//change personal information to arbitration number and DOB=1900-01-01
-	$query = "select `fname`,`mname`,`lname`,`suffix`,`dob` from `users` where `id`='$userid'";
-	$details = mysql_fetch_assoc(mysql_query($query));
-	$query = "insert into `adminlog` set `when`=NOW(),`old-lname`='${details['lname']}',`old-dob`='${details['dob']}',
-		`new-lname`='$arbno',`new-dob`='1900-01-01',`uid`='$id',`adminid`='".$adminid."'";
-	mysql_query($query);
-	$query = "update `users` set `fname`='".$arbno."',
-		`mname`='".$arbno."',
-		`lname`='".$arbno."',
-		`suffix`='".$arbno."',
-		`dob`='1900-01-01'
-		where `id`='".$id."'";
-	mysql_query($query);
-
-//clear all admin and board flags
-	mysql_query("update `users` set `assurer`='0' where `id`='$id'");
-	mysql_query("update `users` set `assurer_blocked`='0' where `id`='$id'");
-	mysql_query("update `users` set `codesign`='0' where `id`='$id'");
-	mysql_query("update `users` set `orgadmin`='0' where `id`='$id'");
-	mysql_query("update `users` set `ttpadmin`='0' where `id`='$id'");
-	mysql_query("update `users` set `locadmin`='0' where `id`='$id'");
-	mysql_query("update `users` set `admin`='0' where `id`='$id'");
-	mysql_query("update `users` set `adadmin`='0' where `id`='$id'");
-	mysql_query("update `users` set `tverify`='0' where `id`='$id'");
-	mysql_query("update `users` set `board`='0' where `id`='$id'");
-
-//block account
-	mysql_query("update `users` set `locked`='1' where `id`='$id'");  //, `deleted`=Now()
-}
-
-
-function check_email_exists($email){
-// called from includes/account.php if($process != "" && $oldid == 1)
-// called from includes/account.php	if($oldid == 50 && $process != "")
-	$email = mysql_real_escape_string($email);
-	$query = "select 1 from `email` where `email`='$email' and `deleted`=0";
-	$res = mysql_query($query);
-	return mysql_num_rows($res) > 0;
-}
-
-function check_gpg_cert_running($uid,$cca=0){
-	//if $cca =0 if just expired, =1 if CCA retention +3 month should be obeyed
-	// called from includes/account.php	if($oldid == 50 && $process != "")
-	$uid = intval($uid);
-	if (0==$cca) {
-		$query = "select 1 from `gpg` where `memid`='$uid' and `expire`>NOW()";
-	}else{
-		$query = "select 1 from `gpg` where `memid`='$uid' and `expire`>(NOW()-90*86400)";
-	}
-	$res = mysql_query($query);
-	return mysql_num_rows($res) > 0;
-}
-
-function check_client_cert_running($uid,$cca=0){
-	//if $cca =0 if just expired, =1 if CCA retention +3 month should be obeyed
-	// called from includes/account.php	if($oldid == 50 && $process != "")
-	$uid = intval($uid);
-	if (0==$cca) {
-		$query1 = "select 1 from `emailcerts` where `memid`='$uid' and `expire`>NOW()";
-		$query2 = "select 1 from `emailcerts` where `memid`='$uid' and `revoked`>NOW()";
-	}else{
-		$query1 = "select 1 from `emailcerts` where `memid`='$uid' and `expire`>(NOW()-90*86400)  and `revoked`<`created`";
-		$query2 = "select 1 from `emailcerts` where `memid`='$uid' and `revoked`>(NOW()-90*86400)";
-	}
-	$res = mysql_query($query1);
-	$r1 = mysql_num_rows($res)>0;
-	$res = mysql_query($query2);
-	$r2 = mysql_num_rows($res)>0;
-	return !!($r1 || $r2);
-}
-
-function check_server_cert_running($uid,$cca=0){
-	//if $cca =0 if just expired, =1 if CCA retention +3 month should be obeyed
-	// called from includes/account.php	if($oldid == 50 && $process != "")
-	$uid = intval($uid);
-	if (0==$cca) {
-		$query1 = "select 1 from `domaincerts` where `memid`='$uid' and `expire`>NOW()";
-		$query2 = "select 1 from `domaincerts` where `memid`='$uid' and `revoked`>NOW()";
-	}else{
-		$query1 = "select 1 from `domaincerts` where `memid`='$uid' and `expire`>(NOW()-90*86400)  and `revoked`<`created`";
-		$query2 = "select 1 from `domaincerts` where `memid`='$uid' and `revoked`>(NOW()-90*86400)";
-	}
-	$res = mysql_query($query1);
-	$r1 = mysql_num_rows($res)>0;
-	$res = mysql_query($query2);
-	$r2 = mysql_num_rows($res)>0;
-	return !!($r1 || $r2);
-}
-function check_is_orgadmin($uid){
-	// called from includes/account.php	if($oldid == 50 && $process != "")
-	$uid = intval($uid);
-	$query = "select 1 from `org` where `memid`='$uid' and `deleted`=0";
-	$res = mysql_query($query);
-	return mysql_num_rows($res) > 0;
-}
-
-?>