X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;f=wwwroot%2Fbackend%2Fmysql%2Fbackend.inc;h=f8cd6a3fec998f83318162a8ee967ecc58dc1e51;hb=57029afafb263ab5f16ced291748f9cca0860dd8;hp=18b0d98c73debbdc474dd5c460c80ac313dac44a;hpb=3676f24250be4b7db303567eee89cd33247cf674;p=mirrors%2FKyberia-bloodline.git

diff --git a/wwwroot/backend/mysql/backend.inc b/wwwroot/backend/mysql/backend.inc
index 18b0d98..f8cd6a3 100644
--- a/wwwroot/backend/mysql/backend.inc
+++ b/wwwroot/backend/mysql/backend.inc
@@ -35,6 +35,35 @@ function update_nodes($user_id,$node_id,$referer_id) {
 }
 
 
+function putNode($what,$where,$checkpermissions=true) {
+	global $db,$error,$error_messages;
+	$user_id = $_SESSION['user_id'];
+	if (!$user_id) {
+		$user_id=UBIK_ID;
+	}
+	if (!is_numeric($what) || !is_numeric($where)) {
+		$error=$error_messages['NUMERIC_NOT_NUMERIC'];
+	}
+
+	$nodeshell = nodes::getNodeById($where,$user_id);
+	$nodeshell_vector = $nodeshell['node_vector'];
+	
+	if ($checkpermissions) {
+		$nodeshell_permissions = permissions::checkPermissions($nodeshell);
+		if (!$nodeshell_permissions['w']) {
+			$error = $error_messages['WRITE_PERMISSION_ERROR'];
+			return false;
+    		}
+	}
+
+	$dst_vector = $nodeshell_vector.str_pad($chosen,VECTOR_CHARS,0,STR_PAD_LEFT);
+	$q = "update neurons set synapse_created=NOW(),link='hard',synapse=synapse+1, dst_vector='$dst_vector' where src='$what' and dst='$where'";
+	$result=$db->update($q);
+
+	if (!$result) $db->query("insert into neurons set synapse_creator='$user_id',synapse_created=NOW(), src='$what',dst='$where',dst_vector='$dst_vector',link='hard',synapse=1");
+	$db->query("update nodes set lastdescendant_created=NOW(),node_children_count=node_children_count+1 where node_id='$where'");
+}
+
 function addNode($params) {
         global $db,$node,$error,$error_messages;
         $parent_id=$params['node_parent'];
@@ -149,15 +178,17 @@ node_vector='".$params['node_vector']."'";
                 }
         }
 
+	function getNodeIdByName($name, $external_link=false) {
+	    global $db;
 
-        function getNodeIdByName($name,$external_link=false) {
-                global $db;
-                $q="select node_id from nodes where node_name='$name'";
-                if ($external_link) $q.=" and external_link='$external_link'";
-                $set=$db->query($q);
-                $set->next();
-                return $set->getString('node_id');
-        }
+	    $qh = sprintf('select node_id from nodes where node_name = "%s"', mysql_real_escape_string($name));
+    		if ($external_link)
+      			$qh .= sprintf(' and external_link="%s"', mysql_real_escape_string($external_link));
+
+	    $set = $db->query($qh);
+	    $set->next();
+	    return $set->getString('node_id');
+  	}
 
         function getNodeById($node_handle,$user_id, $table_name="nodes") {
                 global $db, $error;