Commit | Line | Data |
---|---|---|
b42b2bf9 H |
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 | ?> |