logo
Author: brinza
Description:
Language: PHP
<?php

require_once ('./header.php');

$search = set_get_string_var ('search');
if ($search != '') {
	$search_mode = true;
}
else {
	$search_mode = false;
}



if ($_SESSION['logged_in']) {
        $user = set_get_string_var ('user', $username);
}
else {
        $user = set_get_string_var ('user');
}
$display_shared = false;

if (isset ($_GET['user']) && check_username ($user)) {
	$title = $user . "'s Online Bookmarks";
}
else {
	$title = "Shared Online-Bookmarks";
}

$order = set_get_order ();

?>

<h1 id="caption"><?php echo $title; ?></h1>

<!-- Wrapper starts here. -->
<div style="min-width: <?php echo 230 + $settings['column_width_folder']; ?>px;"> </div>
	<!-- Menu starts here. -->
	<div id="menu">
//
<h2 class="nav">Search</h2>
		<ul class="nav">
		  <li>
		  	<form action="<?php echo $_SERVER['SCRIPT_NAME']; ?>" method="GET" class="nav">
					<input type="text" name="search" size="8" value="<?php echo $search; ?>">
					<input type="submit" value="Go" name="submit">
		  	</form>
</li>
		<h2 class="nav">Bookmarks</h2>
		<ul class="nav">
<?php if ($search_mode) { ?>
			<li><a href="./shared.php"><?php echo $settings['root_folder_name']; ?></a></li>
			<?php } ?>
			
			
		  <li><a href="./index.php">My Bookmarks</a></li>
		  <li><a href="./shared.php">Shared Bookmarks</a></li>
		</ul>
	
		<h2 class="nav">Tools</h2>
		<ul class="nav">
			<?php if (isset ($_SESSION['logged_in']) && $_SESSION['logged_in']) { ?>
			<?php if (admin_only ()) { ?>

			<li><a href="./admin.php">Admin</a></li>
			<?php } ?>
			<li><a href="./import.php">Import</a></li>
			<li><a href="./export.php">Export</a></li>
			<li><a href="./sidebar.php">View as Sidebar</a></li>
			<li><a href="./settings.php">Settings</a></li>
			<li><a href="./index.php?logout=1">Logout</a></li>
			<?php } else { ?>
			<li><a href="./index.php">Login</a></li>
			<?php } ?>
		</ul>
	<!-- Menu ends here. -->
	</div>

	<!-- Main content starts here. -->
	<div id="main">


<?php
if (isset ($_GET['user']) && check_username ($user)) {
?>
<?php

	          require_once ('./lib/BooleanSearch.php');
	          $searchfields = array ('url', 'title', 'description');
	
	          $query = assemble_query ($search, $searchfields);
	
	          if ($mysql->query ($query)) {
	                  $bookmarks = array ();
	                  while ($row = mysql_fetch_assoc ($mysql->result)) {
	                          array_push ($bookmarks, $row);

	                  }
	                  if (count ($bookmarks) > 0) {
	                          require_once (ABSOLUTE_PATH . "bookmarks.php");
	                          list_bookmarks ($bookmarks,
	                                  true,
	                                  true,
	                                  $settings['show_bookmark_icon'],
	                                  true,
	                                  $settings['show_bookmark_description'],
	                                  $settings['show_column_date'],
	                                  $settings['show_column_edit'],
	                                  $settings['show_column_move'],
	                                  $settings['show_column_delete'],
	                                  $settings['show_public'],
	                                  false);
	                  }
	                  else {
	                          echo '<div id="content"> No Bookmarks found matching <b>' . $search . '</b>.</div>';
	                  }
	          }
	          else {
	                  message ($mysql->error);
	          }

					?>

	<!-- Folders starts here. -->
	<div class="folders" style="width: <?php echo $column_width_folder; ?>; height: <?php echo $table_height; ?>;">

	<?php
	require_once (ABSOLUTE_PATH . "folders.php");
	$tree = & new folder ($user);
	$tree->make_tree (0);
	$tree->print_tree ();
	?>

	<!-- Folders ends here. -->
	</div>

	<!-- Bookmarks starts here. -->
	<div class="bookmarks" style="height: <?php echo $table_height; ?>;">

    <?php

    require_once (ABSOLUTE_PATH . "shared.php");
    $query = sprintf ("SELECT title, url, description, UNIX_TIMESTAMP(date) AS timestamp, id, favicon
            FROM bookmark
            WHERE user='%s'
            AND childof='%d'
            AND deleted!='1'
            AND public='1'
            ORDER BY $order[1]",
            $mysql->escape ($user),
            $mysql->escape ($folderid));

    if ($mysql->query ($query)) {
            $bookmarks = array ();
            while ($row = mysql_fetch_assoc ($mysql->result)) {
                    array_push ($bookmarks, $row);
            }
            list_bookmarks ($bookmarks,
                    false,
                    false,
                    $settings['show_bookmark_icon'],
                    true,
                    $settings['show_bookmark_description'],
                    $settings['show_column_date'],
                    false,
                    false,
                    false,
                    false,
                    true,
                    $user);
    }
    else {
            message ($mysql->error);
    }

    ?>
	
	<!-- Bookmarks ends here. -->
	</div>

<?php
}
else {
		echo '<div id="content" style="height:' .  $table_height . ';">' . "\n";
        $query = "SELECT user, SUM(bookmarks) AS bookmarks, SUM(folders) AS folders FROM (
                SELECT user, 1 AS bookmarks, 0 AS folders FROM bookmark WHERE public='1' AND deleted!='1'
                UNION ALL
                SELECT user, 0 AS bookmarks , 1 AS folders FROM folder WHERE public='1' AND deleted!='1'
                ) AS tmp GROUP BY user";

        if ($mysql->query ($query)) {
                while ($row = mysql_fetch_object ($mysql->result)) {
                        echo '<p class="shared"><a href="' . $_SERVER['SCRIPT_NAME'] . '?user=' . $row->user . '&folderid=0"><b>' . $row->user . "</b><br>\n";
                        echo "Shares $row->folders Folders and $row->bookmarks Bookmarks</a></p>\n";
                }
        }
        else {
                message ($mysql->error);
        }
				echo "</div>";
}
?>

	<!-- Main content ends here. -->
	</div>
<!-- Wrapper ends here. -->
</div>

<?php
print_footer ();
require_once (ABSOLUTE_PATH . "footer.php");
?>
Recent pastes:
biophreak (Plain Text)
Raik (PHP)
MUSbKA (Plain Text)
MUSbKA (Plain Text)
nekitozzz (C++)
nekitozzz (Plain Text)
nekitozzz (C++)
ksurent (Perl)
MUSbKA (C++)
stalin_alex (C++)
dzantiev (Plain Text)
unreal (C++)
eug2b (Plain Text)
netsago.paste.β © 2009 Neunica