| 1 | <?php |
| 2 | function F() { |
| 3 | global $db,$node,$error,$error_messages; |
| 4 | $user_id=$_SESSION['user_id']; |
| 5 | $user_name=$_SESSION['user_name']; |
| 6 | $kset=$db->query("select user_k from users where user_id='$user_id'"); |
| 7 | $kset->next(); |
| 8 | $user_k=$kset->getString('user_k'); |
| 9 | |
| 10 | $senat_id = 876611; |
| 11 | $K_id = 1961061; |
| 12 | $comms = getCommanders($K_id); |
| 13 | $isComm = isCommander($comms,$user_id); |
| 14 | $isSOwner = isSenatOwner($senat_id, $user_id); |
| 15 | |
| 16 | if (is_array($_POST['node_chosen'])) { |
| 17 | $k=$_POST['node_chosen']; |
| 18 | } |
| 19 | else $k[]=$node['node_id']; |
| 20 | $db->query("set autocommit=0"); |
| 21 | |
| 22 | foreach ($k as $id) { |
| 23 | |
| 24 | if ($user_k) { |
| 25 | $isSenat = hasAncestor(getAncestors($id), $senat_id); |
| 26 | if ($isSenat && !($isComm || $isSOwner)){ |
| 27 | $error.="Sorry, ale v senate mozu Kckovat len obcania."; |
| 28 | }else{ |
| 29 | $userset=$db->query("select node_creator from nodes where node_id='$id'"); |
| 30 | $userset->next(); |
| 31 | $acceptor_id=$userset->getString('node_creator'); |
| 32 | |
| 33 | $set=$db->query("select * from node_access where node_id='$id' and user_id='$user_id' and given_k='yes'"); |
| 34 | if ($set->getNumRows()) { |
| 35 | $error.=$error_messages['K_GIVEN']; |
| 36 | }else{ |
| 37 | --$user_k; |
| 38 | $db->query("update nodes set k=k-1 where node_id='$id'"); |
| 39 | $db->query("insert into I set node_id='$id'"); |
| 40 | $result=$db->update("update node_access set given_k='yes' where node_id='$id' and user_id='$user_id'"); |
| 41 | if (!$result) { |
| 42 | $db->query("insert into node_access set given_k='yes',node_id='$id',user_id='$user_id',last_visit=NOW()"); |
| 43 | } |
| 44 | } |
| 45 | } |
| 46 | } |
| 47 | |
| 48 | else { |
| 49 | $error.=$error_messages['K_SPENT']; |
| 50 | } |
| 51 | } |
| 52 | |
| 53 | $db->query("update users set user_k='$user_k' where user_id='$user_id'"); |
| 54 | $db->query("commit"); |
| 55 | |
| 56 | if (!$error) return true; |
| 57 | else return false; |
| 58 | } |
| 59 | |
| 60 | ?> |