From fc779bb49a74da78689776391f5ea999c0a03f37 Mon Sep 17 00:00:00 2001
From: adam <adam@>
Date: Sat, 13 Feb 2021 22:12:39 +0200
Subject: share is share

---
 php/database.php | 55 +++++++++++++++++++++++++++++++++++++++++++++----------
 1 file changed, 45 insertions(+), 10 deletions(-)

(limited to 'php/database.php')

diff --git a/php/database.php b/php/database.php
index c7851c5..b95b2a6 100644
--- a/php/database.php
+++ b/php/database.php
@@ -84,15 +84,15 @@ require_once "node.php";
 					 where name=:name"
 					);
 			$statement->bindParam(':name',$name);
-			if($statement->execute()==NULL)
+			if($statement->execute()==false)
 			{
 				error_log("there was a problem with the sql statement at get_nodes_with_name");
-				return [];
+				return NULL;
 			}
 			return $statement->fetchAll(PDO::FETCH_ASSOC);
 		}
 
-		/*returns assoc array*/
+		/*returns id*/
 		function get_node_with_code($code)
 		{
 			$statement=$this->pdo->prepare(
@@ -101,12 +101,13 @@ require_once "node.php";
 					 where code=:code"
 					);
 			$statement->bindParam(':code',$code);
-			if($statement->execute()==NULL)
+			if($statement->execute()==false)
 			{
 				error_log("there was a problem with the sql statement at get_nodes_with_code");
-				return [];
+				return NULL;
 			}
-			return $statement->fetch(PDO::FETCH_ASSOC);
+			$ret= $statement->fetch(PDO::FETCH_ASSOC);
+			return $ret["id"];
 		}
 		/* I think this only makes sense if node is a dir*/
 		/* returns assoc array of nodes*/
@@ -347,7 +348,7 @@ require_once "node.php";
 			/*give premissions*/
 
 			$id=$this->get_node_with_code($code_name);
-			if(count($id)!=1)
+			if($id!=NULL)
 			{
 				error_log("created a dangling directory but couldn't find it afterward. Fatal error!");
 				exit(1);
@@ -450,6 +451,40 @@ require_once "node.php";
 				return false;
 			}
 
+		}
+		function create_shared_node(string $password,int $node_id):bool
+		{
+			$prep=$this->pdo->prepare("insert into shared_nodes(node_id,passcode)
+							values (:id,:pass)
+						");
+			$prep->bindParam(':id',$node_id);
+			$prep->bindParam(':pass',$password);
+			if($prep->execute()==false)
+			{
+				error_log("could not create shared node in create_shared_node");
+				return false;
+			}
+			return true;
+		}
+		function get_node(int $node_id)
+		{
+			$prep=$this->pdo->prepare("select * from nodes where node_id=:id");
+			$prep->bindParam(':id',$node_id);
+			if($prep->execute()==false)
+			{
+				error_log("sql statement at get_node failed");
+				return NULL;
+			}
+			$nod=$prep->fetch(PDO::FETCH_ASSOC);
+			$ret=new Node();
+			$ret->node_id=$nod["node_id"];
+			$ret->is_directory=$nod["is_directory"];
+			$ret->relative_path=$nod["relative_path"];
+			$ret->type=$nod["type"];
+			$ret->code=$nod["code"];
+
+			return $ret;
+
 		}
 		/*returns the file name as it must be in the filesystem relative to the storage root*/
 		function create_file_node(string $filename,string $note,int $dir_id,string $mimetype,User $user): string
@@ -470,9 +505,9 @@ require_once "node.php";
 			{
 				error_log("could not exedude dir sql statement in create_file_node");
 				return "error";
-            }
+		        }
 
-            $dir=$dir_prep->fetch(PDO::FETCH_ASSOC);
+			$dir=$dir_prep->fetch(PDO::FETCH_ASSOC);
 			if($dir == false)
 			{
 				error_log("create_file_node dir isnt a directory");
@@ -514,7 +549,7 @@ require_once "node.php";
 				/*not so quiet error*/
 				return "error";
 			}
-			$new_id=$this->get_node_with_code($code)["id"];
+			$new_id=$this->get_node_with_code($code);
 			/*link the node to the directory*/
 			$this->link_nodes($dir_id,$new_id,$filename,$note);
 			/*give premissions to the creator*/
-- 
cgit v1.2.3