inc/smarty/node_methodz/function.get_waiting_users.php

   1 <?php
   2
   3         function smarty_function_get_waiting_users($params,&$smarty) {
   4                 global $db, $error, $node;
   5                 $node_id=$node['node_id'];
   6                 $q="select node_content,users.* from users left join node_content on node_content.node_id=users.user_id where user_status='waiting'";
   7                 if ($_SESSION['cube_vector']) $q.=" and cube_vector='".$_SESSION['cube_vector']."'";
   8                 else $q.=" and cube_vector IS NULL";
   9                 $result=$db->query($q);
  10                 while ($result->next()) {
  11                         $get_waiting_users[]=$result->getRecord();
  12                 }
  13                 $smarty->assign('get_waiting_users',$get_waiting_users);
  14
  15         }
  16 ?>