X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;f=wwwroot%2Fbackend%2Fmysql%2Fbackend.inc;h=515b344aa00d701f4b52671bb35029d220fdd738;hb=9b7c11be09e7a553b26667f673c6315209ddc210;hp=6bc454be76d4dc8ed31c903b54950ce7071b2596;hpb=ac063e07151a4a85e12c8e2ebe51c14b42fc3641;p=mirrors%2FKyberia-bloodline.git

diff --git a/wwwroot/backend/mysql/backend.inc b/wwwroot/backend/mysql/backend.inc
index 6bc454b..515b344 100644
--- a/wwwroot/backend/mysql/backend.inc
+++ b/wwwroot/backend/mysql/backend.inc
@@ -363,14 +363,19 @@ function setSynapse($params){
 	$dst=$params['dst'];
 	$weight=$params['weight'];
 
+	// weight could be only positive
+	if ( $weight < 0) {
+		return false;
+	}
+
 	// if already exists
-	$q="select src from neurons where dst ='$dst' and src = '$src'";
+	$q="select count(src) from neurons where dst ='$dst' and src = '$src'";
 	$set=$db->query($q);
 	$set->next();
-	$isrc=$set->getString('src');
+	$isrc=$set->getString('count(src)');
 
-	if ( $isrc ) {
-		$q="update neurons set synapse_weight='$synapse_weight' 
+	if ( $isrc > 0 ) {
+		$q="update neurons set synapse_weight='$weight' 
 			where dst = '$dst' and src = '$src'";
 	} else { 
 		// FIXME no vector set
@@ -382,6 +387,31 @@ function setSynapse($params){
 	return true;
 }
 
+// getSynapseWeight
+
+// If synapse does not exists, weight is 1
+// Secure.
+// Returns synapse weight (from user to node)
+
+function getSynapseWeight($user_id,$node_id){
+	global $db;
+
+	if (!is_numeric($user_id)) 
+		{ return -1; }
+	if (!is_numeric($node_id)) 
+		{ return -1; }
+
+	$set=$db->query("select synapse_weight from neurons where src =".
+		$user_id." and dst = ".$node_id." and link='synapse'");
+
+	$set->next();
+	$synapse_weight=$set->getString('synapse_weight');
 
+	if (! ($synapse_weight) ) { $synapse_weight = 1;}	
 
+	return $synapse_weight;
+
+}
 }
+
+?>