Commit | Line | Data |
---|---|---|
b42b2bf9 H |
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 | ?> |