wwwroot/inc/smarty/node_methodz/function.get_moods.php

   1 <?php
   2 function smarty_function_get_moods($params,&$smarty) {
   3         global $db;
   4 error_reporting(1);
   5         $user_id = $params['user_id'];
   6         $set = $db->query(sprintf('select moods from users where user_id = %d', $user_id));
   7         $set->next();
   8         $moods_db = $set->getString('moods');
   9         $moods_expl = explode(";",$moods_db);
  10
  11         // moodlist [array]
  12         for ($i = 0;$i < count($moods_expl)-1;$i++) {
  13                 $set = $db->query(sprintf('select node_id,node_name from nodes where node_id = %d', $moods_expl[$i]));
  14                 $set->next();
  15                 $moods[$i]['node_id'] = $set->getString('node_id');
  16                 $moods_str[$i] = $set->getString('node_id');
  17                 $moods[$i]['node_name'] = $set->getString('node_name');
  18         }
  19
  20         // moodlist [string]
  21         $moods_string = implode(";",$moods_str);
  22
  23         // momentalne nastaveny mood
  24         if (is_numeric($moods_expl[count($moods_expl)-1])) {
  25                 $set = $db->query(sprintf('select node_id, node_name, node_content from nodes where node_id = %d', $moods_expl[count($moods_expl)-1]));
  26                 $set->next();
  27                 $mood['node_id'] = $set->getString('node_id');
  28                 $mood['node_name'] = strip_tags($set->getString('node_name'));
  29                 $mood['node_content'] = addslashes(substr(strip_tags($set->getString('node_content')),0,223));
  30         }
  31         else {
  32                 $mood['node_id'] = '';
  33                 $mood['node_name'] = '';
  34                 $mood['node_content'] = '';
  35         }
  36
  37         $smarty->assign('get_moods',$moods);
  38         $smarty->assign('get_moods_string',$moods_string);
  39         $smarty->assign('get_moods_mood',$mood);
  40 }
  41 ?>