added get_synapse_weight function

[mirrors/Kyberia-bloodline.git] / wwwroot / backend / mysql / backend.inc

diff --git a/wwwroot/backend/mysql/backend.inc b/wwwroot/backend/mysql/backend.inc
index bea0e50cba6eaa46afeb9aaea646b4fcd21c6915..3c6da90495ac84ad5161203abd618af515b62319 100644 (file)
--- a/wwwroot/backend/mysql/backend.inc
+++ b/wwwroot/backend/mysql/backend.inc
@@ -341,22 +341,77 @@ function getKNeurons($user_id,$interval) {
        return $k_array;
 }
 
-// Set synapse weight,
+// setSynapse
 
-// XXX TODO
+// Set synapse weight. 
+// If synapse does not exists, create a new one.
+// Secure.
+// Returns true on sucess, otherwise false.
 
-function setSynapseWeight($synapse_weightl) {
+function setSynapse($params){
        global $db,$node,$error,$error_messages;
 
-       // XXX security fix
-//     $q="update neurons set synapse_weight='$synapse_weight' where dst = '$dst' and src = '$src'";
-//     $q="insert into neurons values('$synapse_weight','$dst','$src',NULL,'synapse',XXX,now(),XXX,$src)";
+       // security check
+       if ((!is_numeric($params['src'])) 
+               or (!is_numeric($params['dst']))
+               or (!is_numeric($params['weight']))) {
 
-//     $set=$db->query($q);
+               return false;
+       }
+
+       $src=$params['src'];
+       $dst=$params['dst'];
+       $weight=$params['weight'];
+
+       // weight could be only positive
+       if ( $weight < 0) {
+               return false;
+       }
+
+       // if already exists
+       $q="select count(src) from neurons where dst ='$dst' and src = '$src'";
+       $set=$db->query($q);
+       $set->next();
+       $isrc=$set->getString('count(src)');
+
+       if ( $isrc > 0 ) {
+               $q="update neurons set synapse_weight='$weight' 
+                       where dst = '$dst' and src = '$src'";
+       } else { 
+               // FIXME no vector set
+               $q="insert into neurons values('$weight','$dst','$src',0,'synapse',
+                                               CURRENT_TIMESTAMP(),now(),NULL,$src)";
+       }
+       $set=$db->query($q);
 
        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();
+       $synapes_weight=$set->getString('synapse_weight');
+
+       if (! ($synapse_weight) ) { $synapse_weight = 1;}       
+
+       return $synapse_weight;
 
 }
+}
+
+?>