inc/smarty/node_methodz/function.get_poll.php

   1 <?php
   2
   3         function smarty_function_get_poll($params,&$smarty) {
   4                 global $db,$node;
   5                 $user_id=$_SESSION['user_id'];
   6                 if (!is_numeric($params['poll_id'])) $poll_id=$node['node_id'];
   7                 else $poll_id=$params['poll_id'];
   8
   9                 if (is_array($params['poll'])) {
  10                         $array=$params['poll'];
  11                         $voted='yes';
  12                 }
  13
  14                 else {
  15                         $set=$db->query("select nodes.*,node_content.node_content,node_access.node_permission from nodes left join node_content on node_content.node_id=nodes.node_id left join node_access on (nodes.node_id=node_access.node_id and node_access.user_id='$user_id') where node_parent='$poll_id' and node_type='11' order by node_id desc limit 1");
  16 //                      echo "select nodes.*,node_content.node_content,node_access.node_permission from nodes left join node_content on node_content.node_id=nodes.node_id left join node_access on (nodes.node_id=node_access.node_id and node_access.user_id='$user_id') where node_parent='$poll_id' and node_type='11' order by node_id desc limit 1";
  17                         $set->next();
  18                         $array=$set->getRecord();
  19                         if ($array['node_permission']=='ban') $voted='yes';
  20                         else $voted='no';
  21                 }
  22
  23                 $option_array=unserialize($array['node_content']);
  24                 $permission=$array['node_permission'];
  25
  26                 $poll=Array("voted"=>$voted,"node_id"=>$array['node_id'],"question"=>$array['node_name'],"total"=>$array['node_views'],"options"=>$option_array);
  27                 $smarty->assign('get_poll',$poll);
  28
  29 }
  30 ?>