9b80aa4a |
1 | <?php |
5b9c0808 |
2 | |
3 | global $node,$db,$error; |
2bda541f |
4 | // All mysql code should go here |
5b9c0808 |
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 | |
2bda541f |
37 | ?> |