* 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); } }