get_node_commanders goes to backend

[mirrors/Kyberia-bloodline.git] / wwwroot / backend / mysql / backend.inc

diff --git a/wwwroot/backend/mysql/backend.inc b/wwwroot/backend/mysql/backend.inc
index 7efab4280258b680e9d21ceb91cb58b5fe50b9d9..a9b4915417abd60e12e7265ce3bba71c90957fa4 100644 (file)
--- a/wwwroot/backend/mysql/backend.inc
+++ b/wwwroot/backend/mysql/backend.inc
@@ -370,9 +370,9 @@ public static function getLast($params) {
        else $offset=addslashes($params['offset']);
 
        global $db,$node;
-       if ($node['node_id']==23)  {
+       if ($node['node_id']==DEF_LAST_NODE)  {
                $interval=" nodes.node_created>NOW()-INTERVAL 65 HOUR and";
-               $params['vector']="00";
+               $vector="00";
        }       else {
 
                $vector=$node['node_vector'];
@@ -482,8 +482,48 @@ public static function getSynapseWeight($user_id,$node_id){
        if (! ($synapse_weight) ) { $synapse_weight = 1;}       
 
        return $synapse_weight;
-
 }
+
+// getNodeUserlist
+
+// Get list of users currently viewing specified node.
+// Secure.
+// Returns list of (login, user_id)
+
+public static function getNodeUserlist($node_id) {
+
+       global $db;
+       if (!is_numeric($node_id))
+                { return -1; }
+               
+
+       $set=$db->query("select login,user_id from users where user_action_id='$node_id'");
+       while ($set->next()) {
+               $userlist[]=$set->getRecord();
+       }
+
+       return $userlist;
 }
 
+// getNodeCommanders
+
+// Get logins of all node commanders (used in configure)
+// Secure.
+// Returns list of (node_permission, login)
+
+
+public static function getNodeCommanders($node_id) {
+       global $db;
+       $set=$db->query("select node_permission,users.login from node_access 
+                       left join users on node_access.user_id=users.user_id where 
+                       node_id='$node_id' and node_permission!='' order by node_permission");
+
+       while ($set->next()) {
+               $commanders[$set->getString('node_permission')].=$set->getString('login').";";
+       }
+
+       return $commanders;
+}
+       
+}
 ?>