cron/register.php

   1 #!/usr/local/bin/php
   2 <?php
   3 require('../config/config.inc');
   4 require(SYSTEM_ROOT.'/inc/log.inc');
   5 require(SYSTEM_ROOT.'/inc/database.inc');
   6 require(SYSTEM_ROOT.'/inc/nodes.inc');
   7 require(SYSTEM_ROOT.'/inc/permissions.inc');
   8 require(SYSTEM_ROOT.'/inc/ubik.inc');
   9 require(SYSTEM_ROOT.'/inc/senate.inc');
  10
  11 //REGISTRATION_VOTES CONSTANT DEFINED IN INC/SENATE.INC
  12 define('REGISTER_TEXT','request for access');
  13 define('REGISTRATION_REQUEST_NODE',2091448);
  14
  15 $_SESSION['user_id']=UBIK_ID;
  16
  17 $db=new CLASS_DATABASE();
  18
  19 $q="select users.login as persona,users.email as email,
  20 k,node_id,node_creator,login from nodes
  21 left join users on nodes.node_creator=users.user_id
  22 where node_name like '".REGISTER_TEXT."%'
  23 and node_parent=".REGISTRATION_REQUEST_NODE."
  24 and k >=".REGISTRATION_VOTES;
  25
  26 $set=$db->query($q);
  27
  28 while ($set->next()) {
  29       $q="update users set header_id=0 where user_id=".$set->getString('node_id');
  30       $db->update($q);
  31       $login=$set->getString('login');
  32       echo $login." registered\n";
  33       $db->update("update nodes set template_id=7,external_link='db://users',node_name='$login' where node_id=".$set->getString('node_id'));
  34       $mail=$set->getString('email');
  35       mail($mail,"kyberia gate is opened","Vitaj v kyberii");
  36
  37       //VHODNE POSLAT ZACIATOCNIKOVI POSTU
  38 //      ubik::ubikMail($params);
  39
  40 }
  41
  42 ?>