| 1 | #!/usr/bin/php |
| 2 | <?php |
| 3 | require('../config/config.inc'); |
| 4 | //connecting to database and creating universal $db object |
| 5 | require(SYSTEM_ROOT.'/inc/log.inc'); |
| 6 | require(SYSTEM_ROOT.'/inc/database.inc'); |
| 7 | require(SYSTEM_ROOT.'/inc/nodes.inc'); |
| 8 | require(SYSTEM_ROOT.'/inc/permissions.inc'); |
| 9 | require(SYSTEM_ROOT.'/inc/ubik.inc'); |
| 10 | |
| 11 | $_SESSION['user_id']=UBIK_ID; |
| 12 | |
| 13 | $db=new CLASS_DATABASE(); |
| 14 | |
| 15 | $set=$db->query("select * from node_access where node_id='1961061' and node_permission='execute'"); |
| 16 | $citizens=$set->getNumRows(); |
| 17 | |
| 18 | $set2=$db->query("select k,node_id,node_creator,login from nodes left join users on nodes.node_creator=users.user_id where node_name='request for citizenship'"); |
| 19 | |
| 20 | echo "TOTAL $citizens citizens \n"; |
| 21 | |
| 22 | while ($set2->next()) { |
| 23 | $request_id=$set2->getString('node_id'); |
| 24 | $votes=$set2->getString('k'); |
| 25 | $login=$set2->getString('login'); |
| 26 | $citizen=$set2->getString('node_creator'); |
| 27 | echo "citizen $citizen - $login has $votes needs ".floor(log($citizens,"1.42"))." \n"; |
| 28 | if (($citizens<66 && $votes>=floor($citizens/6)) || |
| 29 | ($citizens>=66 && $votes>floor(log($citizens,"1.42")))) { |
| 30 | $params['node_parent']=$request_id; |
| 31 | $params['node_creator']=UBIK_ID; |
| 32 | $params['node_content']="request of user $login approved by $votes citizens"; |
| 33 | $params['node_name']="citizen $citizen approved"; |
| 34 | //print_r($params); |
| 35 | echo $votes.$citizen."\n"; |
| 36 | nodes::addNode($params); |
| 37 | $t1=$db->query("select * from node_access where node_id='1961061' and user_id='$citizen' and node_permission='execute'"); |
| 38 | if (!$t1->getNumRows()) $db->query("insert into node_access set node_id='1961061',user_id='$citizen',node_permission='execute'"); |
| 39 | $t1=$db->query("select * from node_access where node_id='1061495' and user_id='$citizen' and node_permission='execute'"); |
| 40 | if (!$t1->getNumRows()) |
| 41 | $db->query("insert into node_access set node_id='1061495',user_id='$citizen',node_permission='execute'"); |
| 42 | $t1=$db->query("select * from node_access where node_id='1961070' and user_id='$citizen' and node_permission='execute'"); |
| 43 | if (!$t1->getNumRows()) |
| 44 | $db->query("insert into node_access set node_id='1961070',user_id='$citizen',node_permission='execute'"); |
| 45 | $db->query("update nodes set node_name='approved citizenship request' where node_id='$request_id'"); |
| 46 | $params['mail_to']=$citizen; |
| 47 | $params['mail_text']="you have become a citizen"; |
| 48 | |
| 49 | ubik::ubikMail($params); |
| 50 | |
| 51 | } |
| 52 | } |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| 57 | ?> |