* remove sql code
* update texts & send mail
*/
// 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';
require INCLUDE_DIR . '/log.inc';
require INCLUDE_DIR . '/database.inc';
require INCLUDE_DIR . '/nodes.inc';
include_once BACKEND_DIR . '/' . DB_TYPE . '/permissions.inc';
require INCLUDE_DIR . '/ubik.inc';
//require(INCLUDE_DIR.'/senate.inc');
//REGISTRATION_VOTES CONSTANT DEFINED IN INC/SENATE.INC
define('REGISTER_TEXT', 'request for access');
$_SESSION['user_id'] = UBIK_ID;
$db = new CLASS_DATABASE();
$q = "select users.login as persona,users.email as email,\n\tk,node_id,node_creator,login from nodes\n\tleft join users on nodes.node_creator=users.user_id\n\twhere node_name like '" . REGISTER_TEXT . "%'\n\tand node_parent=" . REGISTRATION_REQUEST_NODE . "\n\tand k >=" . REGISTRATION_VOTES;
$set = $db->query($q);
while ($set->next()) {
$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 \n\t\t\ttemplate_id=7,\n\t\t\texternal_link='db://user',\n\t\t\tnode_name='{$login}' \n\t\t\twhere node_id=" . $set->getString('node_id'));
$mail = $set->getString('email');
mail($mail, "kyberia gate is opened", "Vitaj v kyberii");
//VHODNE POSLAT ZACIATOCNIKOVI POSTU
// XXX undefined params FIX
// ubik::ubikMail($params);
}
#!/usr/local/bin/php
<?php
require '../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';
$db = new CLASS_DATABASE();
$q = "select user_id,login from users";
$set = $db->query($q);
$i = 0;
while ($set->next()) {
$user_id = $set->getString('user_id');
$user_name = $set->getString('login');
$us = $db->query("select node_id from nodes where node_id='{$user_id}'");
if (!$us->getNumRows()) {
++$i;
$q = "insert into nodes set node_id='{$user_id}',node_creator='{$user_id}',node_system_access='public',\n node_external_access='yes',template_id='7',node_name='{$user_name}',external_link='session://user',node_vector='{$vector}'";
echo "\n {$i} {$q} <br>";
$db->update($q);
}
}
if ($permissions['r'] || $event != 'register') {
//performing node_events (based on update/insert/delete db queries)
if ($event) {
require SYSTEM_ROOT . 'inc/eventz.inc';
} elseif ($transaction) {
require SYSTEM_ROOT . 'inc/transaction.inc';
}
//end of performing node events
//sventest
}
if ($permissions['r']) {
log::log('enter', $node['node_id'], 'ok', $node['node_user_subchild_count']);
if (!empty($_SESSION['user_id']) && is_numeric($node['node_id'])) {
$q = "update node_access set visits=visits+1,node_user_subchild_count='0',last_visit=NOW() where node_id='" . $node['node_id'] . "' and user_id='" . $_SESSION['user_id'] . "'";
// echo $q;
$result = $db->update($q);
if (!$result) {
$q = "insert into node_access set user_id='" . $_SESSION['user_id'] . "',node_id='" . $node['node_id'] . "',last_visit=NOW()";
$db->query($q);
}
}
//creating neural network
$db->update("update nodes set node_views=node_views+1 where node_id='" . $node['node_id'] . "'");
if (is_numeric($referer_id)) {
$q = "update neurons set synapse=synapse+1 where dst='" . $node['node_id'] . "' and src='{$referer_id}'";
$result = $db->update($q);
if (!$result) {
$q = "insert into neurons set synapse_creator='" . $_SESSION['user_id'] . "',dst='" . $node['node_id'] . "',src='{$referer_id}',synapse=1";
$db->query($q);
}
}
