Kyberia v2.3 - 1st revision from SVN (Without patches of kyberia.sk team)

[mirrors/Kyberia-bloodline.git] / inc / smarty / node_methodz / function.get_bookmarks.php

diff --git a/inc/smarty/node_methodz/function.get_bookmarks.php b/inc/smarty/node_methodz/function.get_bookmarks.php
index 901b4d1c467772c9a7622026d53d2f99eab35831..b413a36b633783d5e3f0753085ec1d318f8979b5 100644 (file)
--- a/inc/smarty/node_methodz/function.get_bookmarks.php
+++ b/inc/smarty/node_methodz/function.get_bookmarks.php
@@ -1,54 +1,55 @@
 <?php
+
 function smarty_function_get_bookmarks($brawco,&$smarty) {
 
-       if (is_numeric($brawco['node_id'])) $bookcat=$brawco['node_id'];
-       if (is_numeric($brawco['user_id'])) $user_id=$brawco['user_id'];
-        global $db;
-
-       //returning user specific bookmarks
-       if ($user_id) {
-               $q="select * from node_access left join nodes on node_access.node_id=nodes.node_id where user_id='$user_id' and node_bookmark='yes' and nodes.node_system_access='public'";
-               $set=$db->query($q);
-               while ($set->next()) {
-                       $array[]=$set->getRecord();
-               }
-               $smarty->assign('get_bookmarks',$array);
-               return false;
-       }
-
-       //returning my own bookmarks divided in categories
-       $q="select distinct bookmark_category,nodes.* from node_access left join nodes on node_access.bookmark_category=nodes.node_id where user_id='".$_SESSION['user_id']."' and node_bookmark='yes' order by node_name";
-        $result=$db->query($q);
-        while ($result->next()) {
-               $categories[$result->getString('node_id')]=$result->getRecord();
-        }
-
-        $q="select * from node_access left join nodes on node_access.node_id=nodes.node_id where user_id='".$_SESSION['user_id']."' and node_bookmark='yes'";
-       if ($bookcat) $q.=" and (bookmark_category='$bookcat' or bookmark_category=0 or bookmark_category IS NULL) order by node_name desc";
-       if ($bookcat && $_SESSION['user_id']==548) echo $q;
-
-       else $q.="order by node_name";
-        $result=$db->query($q);
-        if (!$bookcat) {
-       while ($result->next()) {
-               if (!$result->getString('bookmark_category')) {
-                       $categories['unsorted']['children'][]=$result->getRecord();
-                       $categories['unsorted']['sum']+=$result->getString('node_user_subchild_count');
-               }
-               else {
-                       $categories[$result->getString('bookmark_category')]['children'][]=$result->getRecord();
-                       $categories[$result->getString('bookmark_category')]['sum']+=$result->getString('node_user_subchild_count');
-                       }
-        }
-
-        $smarty->assign('get_bookmarks',$categories);
-       }
-
-       else {
-               while ($result->next()) {
-                       $bookmarks[]=$result->getRecord();
-               }
-               $smarty->assign('get_bookmarks',$bookmarks);
-       }
+if (is_numeric($brawco['node_id'])) $bookcat=$brawco['node_id'];
+if (is_numeric($brawco['user_id'])) $user_id=$brawco['user_id'];
+global $db;
+
+//returning user specific bookmarks
+if ($user_id) {
+$q="select * from node_access left join nodes on node_access.node_id=nodes.node_id where user_id='$user_id' and node_bookmark='yes' and nodes.node_system_access='public'";
+$set=$db->query($q);
+while ($set->next()) {
+$array[]=$set->getRecord();
+}
+$smarty->assign('get_bookmarks',$array);
+return false;
+}
+
+//returning my own bookmarks divided in categories
+$q="select distinct bookmark_category,nodes.* from node_access left join nodes on node_access.bookmark_category=nodes.node_id where user_id='".$_SESSION['user_id']."' and node_bookmark='yes' order by node_name";
+$result=$db->query($q);
+while ($result->next()) {
+$categories[$result->getString('node_id')]=$result->getRecord();
+}
+
+$q="select * from node_access left join nodes on node_access.node_id=nodes.node_id where user_id='".$_SESSION['user_id']."' and node_bookmark='yes' and node_name is not NULL ";
+if ($bookcat) $q.=" and (bookmark_category='$bookcat' or bookmark_category=0 or bookmark_category IS NULL) order by node_name desc";
+if ($bookcat && $_SESSION['user_id']==548) echo $q;
+
+else $q.="order by node_name";
+$result=$db->query($q);
+if (!$bookcat) {
+while ($result->next()) {
+if (!$result->getString('bookmark_category')) {
+$categories['unsorted']['children'][]=$result->getRecord();
+$categories['unsorted']['sum']+=$result->getString('node_user_subchild_count');
+}
+else {
+$categories[$result->getString('bookmark_category')]['children'][]=$result->getRecord();
+$categories[$result->getString('bookmark_category')]['sum']+=$result->getString('node_user_subchild_count');
+}
+}
+
+$smarty->assign('get_bookmarks',$categories);
+}
+
+else {
+while ($result->next()) {
+$bookmarks[]=$result->getRecord();
+}
+$smarty->assign('get_bookmarks',$bookmarks);
+}
 }
 ?>