X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fsmarty%2Fnode_methodz%2Ffunction.get_moods.php;fp=inc%2Fsmarty%2Fnode_methodz%2Ffunction.get_moods.php;h=006f85f29e0cb14d6ddfeca77adee594799cb26a;hb=b42b2bf946332ad8544d53f610be9cb05e80bf56;hp=0000000000000000000000000000000000000000;hpb=e586807dafc64c3fe152ab518599e6cf3f0f84e1;p=mirrors%2FKyberia-bloodline.git

diff --git a/inc/smarty/node_methodz/function.get_moods.php b/inc/smarty/node_methodz/function.get_moods.php
new file mode 100644
index 0000000..006f85f
--- /dev/null
+++ b/inc/smarty/node_methodz/function.get_moods.php
@@ -0,0 +1,41 @@
+<?php
+function smarty_function_get_moods($params,&$smarty) {
+	global $db;
+error_reporting(1);
+	$user_id = $params['user_id'];
+	$set = $db->query(sprintf('select moods from users where user_id = %d', $user_id));
+	$set->next();
+	$moods_db = $set->getString('moods');
+	$moods_expl = explode(";",$moods_db);
+
+	// moodlist [array]
+	for ($i = 0;$i < count($moods_expl)-1;$i++) {
+		$set = $db->query(sprintf('select node_id,node_name from nodes where node_id = %d', $moods_expl[$i]));
+		$set->next();
+		$moods[$i]['node_id'] = $set->getString('node_id');
+		$moods_str[$i] = $set->getString('node_id');
+		$moods[$i]['node_name'] = $set->getString('node_name');
+	}
+
+	// moodlist [string]
+	$moods_string = implode(";",$moods_str);
+
+	// momentalne nastaveny mood
+	if (is_numeric($moods_expl[count($moods_expl)-1])) {
+		$set = $db->query(sprintf('select node_id, node_name, node_content from nodes where node_id = %d', $moods_expl[count($moods_expl)-1]));
+		$set->next();
+		$mood['node_id'] = $set->getString('node_id');
+		$mood['node_name'] = strip_tags($set->getString('node_name'));
+		$mood['node_content'] = addslashes(substr(strip_tags($set->getString('node_content')),0,223));
+	}
+	else {
+		$mood['node_id'] = '';
+		$mood['node_name'] = '';
+		$mood['node_content'] = '';
+	}
+
+	$smarty->assign('get_moods',$moods);
+	$smarty->assign('get_moods_string',$moods_string);
+	$smarty->assign('get_moods_mood',$mood);
+}
+?>
\ No newline at end of file