Added minor comments, started movil SQL into backed, register update

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

diff --git a/wwwroot/backend/mysql/backend.inc b/wwwroot/backend/mysql/backend.inc
index b3f17dc3e2904e23b91a9beeb465972c6752a5be..cca3d709f5212addeb1904cb3980c98fce234318 100644 (file)
--- a/wwwroot/backend/mysql/backend.inc
+++ b/wwwroot/backend/mysql/backend.inc
@@ -1,3 +1,37 @@
 <?
+
+global $node,$db,$error;
 // All mysql code should go here
+// Split into multiple files if needed
+
+
+// Called for every node view. Updates node views, neurons, 
+function update_nodes(user_id,node_id,referer_id) {
+
+       $db->update("update nodes set node_views=node_views+1 where".
+                    "node_id='".$node_id."'");
+       if (is_numeric($referer_id) && ($referer_id)) {
+               $q="update neurons set synapse=synapse+1 where ".
+                   "dst='".$node_id."' and src='$referer_id'";
+               $result=$db->update($q);
+               if (!$result) {
+                       $q="insert into neurons set synapse_creator='".
+                          $user_id."',dst='".$node_id.
+                          "',src='$referer_id',synapse=1";
+                       $db->query($q);
+               }
+       }
+
+       // LEVENSHTEIN
+
+       // these 4 lines are not the source of kyberia lagging problems.
+       // leave them. started on the 10.4. 
+       // data gained will be used for scientific purposes
+       if ($user_id) {
+               $q="insert delayed into levenshtein set user_id='".
+                   $user_id."',node_id='".$node_id."'";
+               $db->update($q);
+       }
+}
+
 ?>