cron/register.php

   1 #!/usr/local/bin/php
   2 <?php
   3 /*
   4  * Script that register new users who gaind enough K (votes)
   5  * Called XXX
   6  */
   7
   8
   9 // Use relative address of config file
  10 // Change this, if you move you cron directory.
  11 $dir=substr(__FILE__, 0, strrpos(__FILE__, '/'));
  12 require($dir.'/../wwwroot/config/config.inc');
  13
  14 require(INCLUDE_DIR.'/log.inc');
  15 require(INCLUDE_DIR.'/database.inc');
  16 require(INCLUDE_DIR.'/nodes.inc');
  17 require(INCLUDE_DIR.'/permissions.inc');
  18 require(INCLUDE_DIR.'/ubik.inc');
  19 require(INCLUDE_DIR.'/senate.inc');
  20
  21 //REGISTRATION_VOTES CONSTANT DEFINED IN INC/SENATE.INC
  22 define('REGISTER_TEXT','request for access');
  23 define('REGISTRATION_REQUEST_NODE',2091448);
  24
  25 $_SESSION['user_id']=UBIK_ID;
  26
  27 $db=new CLASS_DATABASE();
  28
  29 $q="select users.login as persona,users.email as email,
  30         k,node_id,node_creator,login from nodes
  31         left join users on nodes.node_creator=users.user_id
  32         where node_name like '".REGISTER_TEXT."%'
  33         and node_parent=".REGISTRATION_REQUEST_NODE."
  34         and k >=".REGISTRATION_VOTES;
  35
  36 $set=$db->query($q);
  37
  38 while ($set->next()) {
  39       $q="update users set header_id=0 where user_id=".$set->getString('node_id');
  40       $db->update($q);
  41       $login=$set->getString('login');
  42       echo $login." registered\n";
  43       $db->update("update nodes set
  44                         template_id=7,
  45                         external_link='db://users',
  46                         node_name='$login'
  47                         where node_id=".$set->getString('node_id'));
  48       $mail=$set->getString('email');
  49       mail($mail,"kyberia gate is opened","Vitaj v kyberii");
  50
  51       //VHODNE POSLAT ZACIATOCNIKOVI POSTU
  52 //      ubik::ubikMail($params);
  53 }
  54
  55 ?>