aboutsummaryrefslogtreecommitdiffstats
path: root/php/database.php
diff options
context:
space:
mode:
Diffstat (limited to 'php/database.php')
-rw-r--r--php/database.php31
1 files changed, 21 insertions, 10 deletions
diff --git a/php/database.php b/php/database.php
index ba02fc7..4b701a2 100644
--- a/php/database.php
+++ b/php/database.php
@@ -378,6 +378,8 @@ require_once "node.php";
function unlink_nodes(int $dir_id, string $filename)
{
+ /*TODO delet this*/
+ error_log("in unlink nodes");
$prep=$this->pdo->prepare("delete from node_links
where directory_id=:dir_id and name=:name
");
@@ -388,21 +390,29 @@ require_once "node.php";
error_log("there was an error with the first statement in unlink_nodes");
return;
}
+ error_log("in pre stuff in unlink nodes");
+ $prep=$this->pdo->prepare("select count(1) as count from trash");
+ $prep->execute() or die(1);
do{
- $prep=$this->pdo->prepare("select count(1) as count from trash");
+
+
+ $prep=$this->pdo->prepare("select count(1) as count from super_trash");
$prep->execute() or die(1);
- $res=$prep->fetch(PDO::FETCH_ASSOC);
- $prep=$this->pdo->prepare("insert into super_trash select node_id from trash");
+ $super_trash_count=$prep->fetch(PDO::FETCH_ASSOC);
+ $prep=$this->pdo->prepare("delete from super_trash");
$prep->execute() or die(1);
- $prep=$this->pdo->prepare("delete from trash");
+
+
+
+ $prep=$this->pdo->prepare("select count(1) as count from trash");
$prep->execute() or die(1);
- $prep=$this->pdo->prepare("delete from links
- where directory_id in
- (select node_id from super_trash)
- ");
+ $trash_count=$prep->fetch(PDO::FETCH_ASSOC);
+ $prep=$this->pdo->prepare("delete from trash");
$prep->execute() or die(1);
- }while($res["count"]!=0);
+ error_log("asdf: ".$trash_count["count"]." ".$super_trash_count["count"]);
+ }while($trash_count["count"]!=$super_trash_count["count"]);
+
$prep=$this->pdo->prepare("select code from nodes where node_id in
(select node_id from super_trash)");
$prep->execute() or die(1);
@@ -412,9 +422,10 @@ require_once "node.php";
unlink($storage_root,"/".$node["code"]);
}
$prep=$this->pdo->prepare("delete from nodes where node_id in
- (select node_id from super_trash");
+ (select node_id from super_trash)");
$prep->execute() or die(1);
$prep=$this->pdo->prepare("delete from super_trash");
+ $prep->execute() or die(1);
}