2 files changed, 122 insertions, 0 deletions
diff --git a/public_html/browser/get.php b/public_html/browser/get.php
new file mode 100644
index 0000000..fa346c3
--- /dev/null
+++ b/public_html/browser/get.php
@@ -0,0 +1,35 @@
+<?php
+
+require_once('/home/grizzly/store/browser/db.php');
+
+$member = $_GET['member'];
+
+if (isset($_GET["random"]) || !isset($member)) {
+    $stmt = $db->prepare("SELECT * FROM `websites` ORDER BY RANDOM() LIMIT 1;");
+    $stmt->execute();
+    $row = $stmt->fetch();
+
+    die(header("Location: https://tilde.team/~grizzly/browser/?member=" . $row['login_name']));
+} else {
+    $stmt = $db->prepare("SELECT * FROM `websites` WHERE login_name = :login_name;");
+    $stmt->execute(array(':login_name' => $member));
+    $row = $stmt->fetch(); // works
+
+    $stmt = $db->prepare("SELECT login_name FROM `websites` WHERE id > :id;");
+    $stmt->execute(array(':id' => $row['id']));
+    $next = $stmt->fetch(); // works
+
+    $stmt = $db->prepare("SELECT login_name FROM `websites` WHERE id < :id;");
+    $stmt->execute(array(':id' => $row['id']));
+    $prev = $stmt->fetch(); // always return first record from database, why?
+}
+
+$current = $row["login_name"];
+$next = $next["login_name"] ? $next["login_name"] : null;
+$prev = $prev["login_name"] ? $prev["login_name"] : null;
+
+// echo "current: " . $current . "\n";
+// echo "next: " . $next . "\n";
+// echo "prev: " . $prev . "\n";
+
+?>
\ No newline at end of file
diff --git a/public_html/browser/index.php b/public_html/browser/index.php
new file mode 100644
index 0000000..08aecd6
--- /dev/null
+++ b/public_html/browser/index.php
@@ -0,0 +1,87 @@
+<?php require_once ('get.php');
+?><!DOCTYPE html>
+<html lang="en">
+  <head>
+    <meta charset="UTF-8" />
+    <meta http-equiv="X-UA-Compatible" content="IE=edge" />
+    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
+    <title>Members websites on tilde.team</title>
+  </head>
+  <body>
+    <div class="app">
+      <div class="view">
+        <iframe
+          src="https://tilde.team/~<?=$current?>"
+          frameborder="0"
+        ></iframe>
+      </div>
+      <div class="control">
+        <div>
+          you are viewing
+          <a href="https://tilde.team/~<?=$current?>" target="_blank"
+            ><?=$current?></a
+          >
+          site
+        </div>
+        <div>
+          <?php if (isset($prev)) { ?>
+          <a href="https://tilde.team/~grizzly/browser/?member=<?=$prev?>"
+            >[previous]</a
+          >
+          <?php } ?>
+          <a href="https://tilde.team/~grizzly/browser/?random">[random]</a>
+          <?php if (isset($next)) { ?>
+          <a href="https://tilde.team/~grizzly/browser/?member=<?=$next?>"
+            >[next]</a
+          >
+          <?php } ?>
+        </div>
+        <div class="cache">user list cache is updated once a day</div>
+      </div>
+    </div>
+
+    <style>
+      * {
+        padding: 0;
+        margin: 0;
+        box-sizing: border-box;
+      }
+      body {
+        font-family: "lucida sans unicode", "lucida grande", sans-serif;
+        line-height: 1.7;
+        font-size: 14px;
+        background-color: #0e0e0e;
+      }
+      .app {
+        display: flex;
+        flex-direction: column;
+        min-height: 100vh;
+      }
+      .view {
+        display: flex;
+        flex-direction: column;
+        flex-grow: 1;
+        border: 5px dotted #3ee77b;
+      }
+      iframe {
+        flex-grow: 1;
+        background-color: #cecece;
+      }
+      .control {
+        display: flex;
+        flex-direction: column;
+        border-top: 5px dotted #3ee77b;
+        padding: 10px;
+        color: #3ee77b;
+        align-items: center;
+      }
+      .control a {
+        color: #99f2b9;
+      }
+      .cache {
+        font-size: 10px;
+        margin-top: 5px;
+      }
+    </style>
+  </body>
+</html>
\ No newline at end of file