Kyberia v2.3 - 1st revision from SVN (Without patches of kyberia.sk team)

[mirrors/Kyberia-bloodline.git] / cron / citizen.php

diff --git a/cron/citizen.php b/cron/citizen.php
new file mode 100755 (executable)
index 0000000..68ffd76
--- /dev/null
+++ b/cron/citizen.php
@@ -0,0 +1,57 @@
+#!/usr/bin/php
+<?php
+require('../config/config.inc');
+//connecting to database and creating universal $db object
+require(SYSTEM_ROOT.'/inc/log.inc');
+require(SYSTEM_ROOT.'/inc/database.inc');
+require(SYSTEM_ROOT.'/inc/nodes.inc');
+require(SYSTEM_ROOT.'/inc/permissions.inc');
+require(SYSTEM_ROOT.'/inc/ubik.inc');
+
+$_SESSION['user_id']=UBIK_ID;
+
+$db=new CLASS_DATABASE();
+
+$set=$db->query("select * from node_access where node_id='1961061' and node_permission='execute'");
+$citizens=$set->getNumRows();
+
+$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'");
+
+ echo "TOTAL $citizens citizens \n";
+
+while ($set2->next()) {
+  $request_id=$set2->getString('node_id');
+  $votes=$set2->getString('k');
+  $login=$set2->getString('login');
+  $citizen=$set2->getString('node_creator');
+  echo "citizen $citizen - $login has $votes needs ".floor(log($citizens,"1.42"))." \n";
+  if (($citizens<66 && $votes>=floor($citizens/6)) ||
+    ($citizens>=66 && $votes>floor(log($citizens,"1.42")))) {
+      $params['node_parent']=$request_id;
+      $params['node_creator']=UBIK_ID;
+      $params['node_content']="request of user $login approved by $votes citizens";
+      $params['node_name']="citizen $citizen approved";
+      //print_r($params);
+      echo $votes.$citizen."\n";
+      nodes::addNode($params);
+      $t1=$db->query("select * from node_access where node_id='1961061' and user_id='$citizen' and node_permission='execute'");
+      if (!$t1->getNumRows()) $db->query("insert into node_access set node_id='1961061',user_id='$citizen',node_permission='execute'");
+      $t1=$db->query("select * from node_access where node_id='1061495' and user_id='$citizen' and node_permission='execute'");
+      if (!$t1->getNumRows())
+      $db->query("insert into node_access set node_id='1061495',user_id='$citizen',node_permission='execute'");
+      $t1=$db->query("select * from node_access where node_id='1961070' and user_id='$citizen' and node_permission='execute'");
+      if (!$t1->getNumRows())
+      $db->query("insert into node_access set node_id='1961070',user_id='$citizen',node_permission='execute'");
+      $db->query("update nodes set node_name='approved citizenship request' where node_id='$request_id'");
+      $params['mail_to']=$citizen;
+      $params['mail_text']="you have become a citizen";
+
+      ubik::ubikMail($params);
+
+  }
+}
+
+
+
+
+?>