#!/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($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(INCLUDE_DIR.'/log.inc');
+require(INCLUDE_DIR.'/database.inc');
+require(INCLUDE_DIR.'/nodes.inc');
+require(INCLUDE_DIR.'/permissions.inc');
+require(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";
$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";
//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);
-
}
}
-
-
-
?>