psql db schema test

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

diff --git a/cron/register.php b/cron/register.php
index 50aa6e4b8c0e731486f69d3eb00c505c4b202c4b..70316247ef0d7fc6584f16f4bb9fc4d74c22d764 100755 (executable)
--- a/cron/register.php
+++ b/cron/register.php
@@ -6,6 +6,8 @@
  * Called once a day at 0:42
  * 
  * TODO: ? call only function from eventz ? 
+ *        remove sql code
+ *        update texts & send mail
  */
 
 
@@ -17,7 +19,7 @@ require($dir.'/../wwwroot/config/config.inc');
 require(INCLUDE_DIR.'/log.inc');
 require(INCLUDE_DIR.'/database.inc');
 require(INCLUDE_DIR.'/nodes.inc');
-require(INCLUDE_DIR.'/permissions.inc');
+include_once(BACKEND_DIR.'/'.DB_TYPE.'/permissions.inc');
 require(INCLUDE_DIR.'/ubik.inc');
 //require(INCLUDE_DIR.'/senate.inc');
 
@@ -38,13 +40,13 @@ $q="select users.login as persona,users.email as email,
 $set=$db->query($q);
 
 while ($set->next()) {
-      $q="update users set header_id=0 where user_id=".$set->getString('node_id');
+      $q="update users set header_id=0,hash='' 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',
+                       external_link='db://user',
                        node_name='$login' 
                        where node_id=".$set->getString('node_id'));
       $mail=$set->getString('email');