cron/citizen.php

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