wwwroot/backend/mysql/backend.inc

   1 <?php
   2
   3 global $node,$db,$error;
   4 // All mysql code should go here
   5 // Split into multiple files if needed
   6
   7
   8 // Called for every node view. Updates node views, neurons,
   9 function update_nodes(user_id,node_id,referer_id) {
  10
  11         $db->update("update nodes set node_views=node_views+1 where".
  12                      "node_id='".$node_id."'");
  13         if (is_numeric($referer_id) && ($referer_id)) {
  14                 $q="update neurons set synapse=synapse+1 where ".
  15                     "dst='".$node_id."' and src='$referer_id'";
  16                 $result=$db->update($q);
  17                 if (!$result) {
  18                         $q="insert into neurons set synapse_creator='".
  19                            $user_id."',dst='".$node_id.
  20                            "',src='$referer_id',synapse=1";
  21                         $db->query($q);
  22                 }
  23         }
  24
  25         // LEVENSHTEIN
  26
  27         // these 4 lines are not the source of kyberia lagging problems.
  28         // leave them. started on the 10.4.
  29         // data gained will be used for scientific purposes
  30         if ($user_id) {
  31                 $q="insert delayed into levenshtein set user_id='".
  32                     $user_id."',node_id='".$node_id."'";
  33                 $db->update($q);
  34         }
  35 }
  36
  37 ?>