| 1 | <? |
| 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 | ?> |