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

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

diff --git a/cron/register.php b/cron/register.php
new file mode 100755 (executable)
index 0000000..8238168
--- /dev/null
+++ b/cron/register.php
@@ -0,0 +1,42 @@
+#!/usr/local/bin/php
+<?php
+require('../config/config.inc');
+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(SYSTEM_ROOT.'/inc/senate.inc');
+
+//REGISTRATION_VOTES CONSTANT DEFINED IN INC/SENATE.INC
+define('REGISTER_TEXT','request for access');
+define('REGISTRATION_REQUEST_NODE',2091448);
+
+$_SESSION['user_id']=UBIK_ID;
+
+$db=new CLASS_DATABASE();
+
+$q="select users.login as persona,users.email as email,
+k,node_id,node_creator,login from nodes
+left join users on nodes.node_creator=users.user_id
+where node_name like '".REGISTER_TEXT."%'
+and node_parent=".REGISTRATION_REQUEST_NODE."
+and k >=".REGISTRATION_VOTES;
+
+$set=$db->query($q);
+
+while ($set->next()) {
+      $q="update users set header_id=0 where user_id=".$set->getString('node_id');
+      $db->update($q);
+      $login=$set->getString('login');
+      echo $login." registered\n";
+      $db->update("update nodes set template_id=7,external_link='db://users',node_name='$login' where node_id=".$set->getString('node_id'));
+      $mail=$set->getString('email');
+      mail($mail,"kyberia gate is opened","Vitaj v kyberii");
+
+      //VHODNE POSLAT ZACIATOCNIKOVI POSTU
+//      ubik::ubikMail($params);
+
+}
+
+?>
\ No newline at end of file