cron/citizen.php

   1 #!/usr/bin/php
   2 <?php
   3 /*
   4  * Script that XXX
   5  * Called XXX
   6  */
   7
   8
   9 // Use relative address of config file
  10 // Change this, if you move you cron directory.
  11 $dir=substr(__FILE__, 0, strrpos(__FILE__, '/'));
  12 require_once($dir.'/../wwwroot/config/config.inc');
  13
  14
  15 //connecting to database and creating universal $db object
  16 require_once(INCLUDE_DIR.'/log.inc');
  17 require_once(INCLUDE_DIR.'/database.inc');
  18 require_once(INCLUDE_DIR.'/nodes.inc');
  19 require_once(INCLUDE_DIR.'/permissions.inc');
  20 require_once(INCLUDE_DIR.'/ubik.inc');
  21
  22 $_SESSION['user_id']=UBIK_ID;
  23
  24 $db=new CLASS_DATABASE();
  25
  26 $set=$db->query("select * from node_access where
  27                 node_id='1961061' and node_permission='execute'");
  28 $citizens=$set->getNumRows();
  29
  30 $set2=$db->query("select k,node_id,node_creator,login from nodes
  31                 left join users on nodes.node_creator=users.user_id where
  32                 node_name='request for citizenship'");
  33
  34  echo "TOTAL $citizens citizens \n";
  35
  36 while ($set2->next()) {
  37   $request_id=$set2->getString('node_id');
  38   $votes=$set2->getString('k');
  39   $login=$set2->getString('login');
  40   $citizen=$set2->getString('node_creator');
  41   echo "citizen $citizen - $login has $votes needs ".floor(log($citizens,"1.42"))." \n";
  42
  43   if (($citizens<66 && $votes>=floor($citizens/6)) ||
  44     ($citizens>=66 && $votes>floor(log($citizens,"1.42")))) {
  45
  46       $params['node_parent']=$request_id;
  47       $params['node_creator']=UBIK_ID;
  48       $params['node_content']="request of user $login approved by $votes citizens";
  49       $params['node_name']="citizen $citizen approved";
  50       //print_r($params);
  51       echo $votes.$citizen."\n";
  52       nodes::addNode($params);
  53       $t1=$db->query("select * from node_access where
  54                 node_id='1961061' and
  55                 user_id='$citizen'
  56                 and node_permission='execute'");
  57       if (!$t1->getNumRows()) {
  58         $db->query("insert into node_access set
  59                                 node_id='1961061',
  60                                 user_id='$citizen',
  61                                 node_permission='execute'");
  62         }
  63       $t1=$db->query("select * from node_access where
  64                 node_id='1061495' and
  65                 user_id='$citizen' and
  66                 node_permission='execute'");
  67       if (!$t1->getNumRows()) {
  68       $db->query("insert into node_access set
  69                                         node_id='1061495',
  70                                         user_id='$citizen',
  71                                         node_permission='execute'");
  72         }
  73       $t1=$db->query("select * from node_access where
  74                 node_id='1961070' and
  75                 user_id='$citizen' and
  76                 node_permission='execute'");
  77       if (!$t1->getNumRows()) {
  78       $db->query("insert into node_access set
  79                 node_id='1961070',
  80                 user_id='$citizen',
  81                 node_permission='execute'");
  82         }
  83       $db->query("update nodes set node_name='approved citizenship request'
  84                 where node_id='$request_id'");
  85       $params['mail_to']=$citizen;
  86       $params['mail_text']="you have become a citizen";
  87
  88       ubik::ubikMail($params);
  89   }
  90 }
  91
  92 ?>