X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;f=cron%2Fcitizen.php;h=caa71fe32b9d201048e742aecdeed99aca8909a1;hb=8ab966c2cc9c22aa38bfd8f88d29d64b2e2a0b47;hp=68ffd76ae2212e9adf577013196f4cfdd71ea344;hpb=b42b2bf946332ad8544d53f610be9cb05e80bf56;p=mirrors%2FKyberia-bloodline.git

diff --git a/cron/citizen.php b/cron/citizen.php
index 68ffd76..caa71fe 100755
--- a/cron/citizen.php
+++ b/cron/citizen.php
@@ -1,21 +1,35 @@
 #!/usr/bin/php
 <?php
-require('../config/config.inc');
+/*
+ * Script that XXX
+ * Called XXX
+ */
+
+
+// Use relative address of config file
+// Change this, if you move you cron directory.
+$dir=substr(__FILE__, 0, strrpos(__FILE__, '/'));
+require_once($dir.'/../wwwroot/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');
+require_once(INCLUDE_DIR.'/log.inc');
+require_once(INCLUDE_DIR.'/database.inc');
+require_once(INCLUDE_DIR.'/nodes.inc');
+require_once(INCLUDE_DIR.'/permissions.inc');
+require_once(INCLUDE_DIR.'/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'");
+$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'");
+$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";
 
@@ -25,8 +39,10 @@ while ($set2->next()) {
   $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";
@@ -34,24 +50,43 @@ while ($set2->next()) {
       //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'");
+      $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);
-
   }
 }
 
-
-
-
 ?>