Online-Bookmarks bei linksilo.de

query($sql); $num=$db->num_rows(); if ($num!=0) { $db->next_record(); $auid=$db->f("id"); $siloexternadd=$db->f("siloexternadd"); if (!isset($folder_id)) { $folder_id=0; }; $tstamp=time(); $sql = "DELETE FROM extern_treeview WHERE auid='$auid' AND ip='$REMOTE_ADDR' AND tstamp < ". ($tstamp - 3600); $db->query($sql); if ($action=="open") { $sql = "INSERT INTO extern_treeview VALUES ('$auid','$REMOTE_ADDR','$tstamp','$node')"; $db->query($sql); $sql = "UPDATE extern_treeview SET tstamp='$tstamp' WHERE auid='$auid' AND ip='$REMOTE_ADDR'"; $db->query($sql); } elseif ($action=="close") { $sql = "DELETE FROM extern_treeview WHERE auid='$auid' AND ip='$REMOTE_ADDR' AND folder_id='$node'"; $db->query($sql); } ## Start function get_text($text,$folder2_id,$c,$invisible_folders) { global $auid,$DB_linksilo,$user,$REMOTE_ADDR,$style; $db2 = new DB_linksilo; $db3 = new DB_linksilo; $time = time(); $sql = "SELECT * FROM bookmarks WHERE folder_up_id='$folder2_id' AND auid='$auid' AND notextern='0' AND deleted='0' ORDER BY ISNULL(IF(folder_id='0',NULL,'Z')) ASC, name ASC"; $db2->query($sql); $num=$db2->num_rows(); if ($num!="0") { while ($db2->next_record()) { $temp=""; $folder2_id=$db2->f("folder_id"); $name=$db2->f("name"); $url=$db2->f("url"); $name=stripslashes($name); for ($x=0; $x<$c+1;$x++) { $temp .= "

"; } $sql3 = "SELECT auid FROM extern_treeview WHERE folder_id='$folder2_id' AND ip='$REMOTE_ADDR' AND auid='$auid'"; $db3->query($sql3); $num3=$db3->num_rows(); // Abfragen, ob Tree geöffnet werden soll if ($folder2_id!=0) { if ($num3!=0) { $temp.="

"; } else { $temp.="

"; } } else { $temp.="

"; } $c++; if ($folder2_id==0) { $text1 = $temp ." $name$rating_out
\n\r"; } else { $text1 = $temp ." $name$rating_out
\n\r"; } if ($folder2_id!=0) { if ($num3!=0) { $text .= get_text($text1,$folder2_id,$c,$invisible_folders); } else { $text .= $text1; } } else { $text .= $text1; } $c--; } } else { } return $text; } $output=""; $text=""; $invisible_folders=""; $output.= "

"; $output.= " Meine Links
\n\r"; $sql = "SELECT * FROM bookmarks WHERE folder_up_id='0' AND auid='$auid' AND notextern='0' AND deleted='0' ORDER BY ISNULL(IF(folder_id='0',NULL,'Z')) ASC, name ASC"; $db->query($sql); while ($db->next_record()) { $c=1; $folder_id=$db->f("folder_id"); $name=$db->f("name"); $name=stripslashes($name); $url=$db->f("url"); $temp2=""; // Abfragen, ob Tree geöffnet werden soll $sql2 = "SELECT auid FROM extern_treeview WHERE folder_id='$folder_id' AND auid='$auid' AND ip='$REMOTE_ADDR'"; $db2->query($sql2); $num2=$db2->num_rows(); if ($folder_id!=0) { if ($num2!=0) { $temp="

"; } else { $temp="

"; } } else { $temp="

"; } for ($x=0; $x<$c;$x++) { $temp2 .= "

"; } $temp=$temp2.$temp; if ($rating>0) { $rating_out="

"; } else { $rating_out=""; } if ($folder_id==0) { $output.=$temp . " $name$rating_out
\n\r"; } else { $output.=$temp . " $name$rating_out
\n\r"; } if ($folder_id!=0) { if ($num2!=0) { $output.=get_text($text,$folder_id,$c,$invisible_folders); } } else { $output.= $text; } } echo $output; ## Ende ?>