Add bios and signatures pages to enhance personal website content

- Created a new bios.html file featuring a collection of personal statements and interests, reflecting a nostalgic and creative approach to web design.
- Added a signatures.html file with various playful and engaging messages, encouraging visitors to explore the site and embrace the spirit of the indie web.

1 files changed, 253 insertions, 34 deletions

diff --git a/scripts/seed.sh b/scripts/seed.sh
index 59971dc..4cded48 100755
--- a/scripts/seed.sh
+++ b/scripts/seed.sh
@@ -2,60 +2,279 @@
 set -euo pipefail
 
 DB_PATH="shrine/pagoda.db"
+SEED_DIR="seed"
 
 if [ ! -f "$DB_PATH" ]; then
   echo "Database not found at $DB_PATH"
   exit 1
 fi
 
-HASH=$(npx -y bcryptjs-cli password 2>/dev/null)
-OWNER_DATE=$(date -v-4m +"%Y-%m-%dT%H:%M:%SZ" 2>/dev/null || date -d "4 months ago" +"%Y-%m-%dT%H:%M:%SZ")
-
-echo "Generating 99 unique citizens..."
-npx -y @faker-js/cli firstName >/dev/null 2>&1
-FAKER_MODULES=$(find ~/.npm/_npx -path "*/@faker-js/cli/bin/faker.js" -print -quit 2>/dev/null)
-FAKER_MODULES="${FAKER_MODULES%/@faker-js/cli/bin/faker.js}"
-
-NAMES=$(NODE_PATH="$FAKER_MODULES" node -e "
-var f = require('@faker-js/faker').faker;
-var now = Date.now();
-var threeMonthsAgo = new Date(now);
-threeMonthsAgo.setMonth(threeMonthsAgo.getMonth() - 3);
-var range = now - threeMonthsAgo.getTime();
-var seen = new Set();
-while (seen.size < 99) {
-  var first = f.person.firstName();
-  var username = first.toLowerCase().replace(/[^a-z]/g, '');
-  if (username.length >= 3 && username.length <= 32 && !seen.has(username)) {
-    seen.add(username);
-    var last = f.person.lastName();
-    var joinDate = new Date(threeMonthsAgo.getTime() + Math.random() * range).toISOString().replace(/\.\d{3}Z/, 'Z');
-    console.log(username + '|' + first + ' ' + last + '|' + joinDate);
-  }
+EXISTING=$(sqlite3 "$DB_PATH" "SELECT COUNT(*) FROM users;")
+if [ "$EXISTING" -gt 0 ]; then
+  echo "Database already has $EXISTING users, skipping seed"
+  exit 0
+fi
+
+HASH=$(htpasswd -nbBC 10 "" password | cut -d: -f2)
+
+FIRST_NAMES=(
+  Aiko Bram Cleo Dax Elara Fern Gideon Hana Idris Jade
+  Kael Luna Milo Nyx Orion Piper Quinn Rune Sage Thorn
+  Uma Vesper Wren Xara Yuki Zara Asher Blaze Cedar Dove
+  Echo Flint Haven Ivy Jet Kit Lark Moss Nova Onyx
+  Pearl Quill Rain Sky Terra Vale Wolf Yew Zen Aria
+  Bay Coral Drift Elm Fox Gale Hawk Iris Juniper Kai
+  Leaf Maple Nimbus Oak Pine River Storm Thistle Umber Violet
+  Willow Birch Cliff Dawn Eve Frost Glen Heath Kite Lotus
+  Meadow Night Olive Petal Reed Sol Tide Vine Wynn Briar
+  Cloud Dune Fable Grove Haze Isle Kelp Lyric Mars Nectar
+  Opal Plum Robin Star Twig Veil Wave Yarrow Zinnia Aster
+  Brook Cinder Delta Ember Fjord Garnet Holly Indigo Jasper Lichen
+  Mist Nettle Orbit Poppy Reef Sable Talon Vapor Wisp Aspen
+  Brine Cobalt Dew Eon Flame Glint Heather Ink Knoll Lumen
+  Moth Nile Pixel Quartz Ripple Shade Torrent Umbra Verge Zephyr
+)
+
+LAST_NAMES=(
+  Ashworth Blackwood Clearwater Duskfall Evergreen Foxglove Goldleaf Hawthorn
+  Ironbark Junewood Keelshore Larkspur Moonvale Nightbloom Oakshade Pinecrest
+  Quillstone Ravenhill Silverbrook Thornwick Underhill Verdant Westwind Zenith
+  Ashford Birchwood Copperfield Dawnstar Elderwood Fernside Greymist Holloway
+  Icemere Jadeheart Kestrel Lakeshore Mossglen Northlight Overbrook Peakwood
+  Quicksilver Rosewood Stonebridge Tidewater Umbervale Vineheart Wildmere Ashcroft
+  Brightwell Coldspring Deepwood Evenfall Frostmere Glendale Hartwood Ivybridge
+  Jasperfall Kirkwood Longmeadow Millbrook Newgrove Oldfield Ridgemont Sundale
+  Thistlewood Upland Valewood Wintermere Brookfield Creekside Dellwood Eastmore
+  Fairhaven Greenwood Highcliff Inkwell Lakewood Nightvale Pondcress Rustwood
+)
+
+PRONOUNS=(
+  "zir/zem" "voi/vol" "qui/quem" "sol/solis" "lux/luxis"
+  "nim/nir" "dra/drem" "pix/pixis" "nyx/nyxis" "vex/vir"
+  "kal/kis" "ryn/rynis" "zel/zem" "orb/orbis" "mox/moxis"
+  "jin/jinis" "tav/tavis" "wren/wrenis" "flux/fluxis" "ash/ashis"
+  "glyph/glyphir" "hex/haxis" "nil/nilis" "arc/arcis" "cyr/cyris"
+  "dex/dexis" "fen/fenis" "kez/kezis" "nym/nymis" "thri/threm"
+)
+
+LOCATIONS=(
+  "Portland, Oregon" "London, England" "Tokyo, Japan" "Berlin, Germany" "Melbourne, Australia"
+  "Toronto, Canada" "Brooklyn, New York" "Seattle, Washington" "Amsterdam, Netherlands" "Seoul, South Korea"
+  "Austin, Texas" "Glasgow, Scotland" "Lisbon, Portugal" "Chicago, Illinois" "Stockholm, Sweden"
+  "Vancouver, Canada" "Dublin, Ireland" "Paris, France" "Denver, Colorado" "Cape Town, South Africa"
+  "San Francisco, California" "Helsinki, Finland" "Singapore" "Oslo, Norway" "Montreal, Canada"
+  "Osaka, Japan" "Manchester, England" "Barcelona, Spain" "Wellington, New Zealand" "Reykjavik, Iceland"
+  "Buenos Aires, Argentina" "Prague, Czech Republic" "Bangkok, Thailand" "Taipei, Taiwan" "Nairobi, Kenya"
+  "Lima, Peru" "Kyoto, Japan" "Edinburgh, Scotland" "Bologna, Italy" "Zurich, Switzerland"
+  "Copenhagen, Denmark" "Marrakech, Morocco" "Hanoi, Vietnam" "Bogota, Colombia" "Tallinn, Estonia"
+  "Krakow, Poland" "Kuala Lumpur, Malaysia" "Mumbai, India" "Mexico City, Mexico" "Christchurch, New Zealand"
+)
+
+BIOS=()
+while IFS= read -r line; do
+  [ -n "$line" ] && BIOS+=("$line")
+done < "$SEED_DIR/bios.html"
+
+SIGS=()
+while IFS= read -r line; do
+  [ -n "$line" ] && SIGS+=("$line")
+done < "$SEED_DIR/signatures.html"
+
+BIO_COUNT=${#BIOS[@]}
+SIG_COUNT=${#SIGS[@]}
+
+TOTAL_USERS=$(( RANDOM % 31 + 120 ))
+CITIZEN_COUNT=$(( TOTAL_USERS - 1 ))
+
+ADMIN_COUNT=$(( CITIZEN_COUNT * 2 / 100 ))
+MOD_COUNT=$(( CITIZEN_COUNT * 3 / 100 ))
+BANNED_COUNT=$(( CITIZEN_COUNT * 4 / 100 ))
+DISABLED_COUNT=$(( CITIZEN_COUNT * 3 / 100 ))
+UNVERIFIED_COUNT=$(( CITIZEN_COUNT * 5 / 100 ))
+[ "$ADMIN_COUNT" -lt 1 ] && ADMIN_COUNT=1
+[ "$MOD_COUNT" -lt 1 ] && MOD_COUNT=1
+[ "$BANNED_COUNT" -lt 1 ] && BANNED_COUNT=1
+[ "$DISABLED_COUNT" -lt 1 ] && DISABLED_COUNT=1
+[ "$UNVERIFIED_COUNT" -lt 1 ] && UNVERIFIED_COUNT=1
+
+SLOTS=()
+for ((i=0; i<CITIZEN_COUNT; i++)); do SLOTS+=("$i"); done
+for ((i=${#SLOTS[@]}-1; i>0; i--)); do
+  j=$(( RANDOM % (i + 1) ))
+  tmp=${SLOTS[$i]}; SLOTS[$i]=${SLOTS[$j]}; SLOTS[$j]=$tmp
+done
+
+BIO_MAP=""
+for ((i=0; i<BIO_COUNT && i<${#SLOTS[@]}; i++)); do
+  BIO_MAP="${BIO_MAP},${SLOTS[$i]}:${i},"
+done
+
+SIG_POOL=()
+for ((i=0; i<BIO_COUNT && i<${#SLOTS[@]}; i++)); do SIG_POOL+=("${SLOTS[$i]}"); done
+for ((i=${#SIG_POOL[@]}-1; i>0; i--)); do
+  j=$(( RANDOM % (i + 1) ))
+  tmp=${SIG_POOL[$i]}; SIG_POOL[$i]=${SIG_POOL[$j]}; SIG_POOL[$j]=$tmp
+done
+
+SIG_MAP=""
+for ((i=0; i<SIG_COUNT && i<${#SIG_POOL[@]}; i++)); do
+  SIG_MAP="${SIG_MAP},${SIG_POOL[$i]}:${i},"
+done
+
+random_date_between() {
+  local start_epoch=$1
+  local end_epoch=$2
+  local range=$(( end_epoch - start_epoch ))
+  local offset=$(( RANDOM * RANDOM % range ))
+  echo $(( start_epoch + offset ))
 }
-")
+
+NOW_EPOCH=$(date +%s)
+THREE_MONTHS_AGO=$(date -v-3m +%s 2>/dev/null || date -d "3 months ago" +%s)
+ONE_MONTH_AGO=$(date -v-1m +%s 2>/dev/null || date -d "1 month ago" +%s)
+ONE_MONTH_AHEAD=$(date -v+1m +%s 2>/dev/null || date -d "1 month" +%s)
+FOUR_MONTHS_AGO=$(date -v-4m +%s 2>/dev/null || date -d "4 months ago" +%s)
+
+OWNER_DATE=$(date -r $FOUR_MONTHS_AGO +"%Y-%m-%dT%H:%M:%SZ" 2>/dev/null || date -d "@$FOUR_MONTHS_AGO" +"%Y-%m-%dT%H:%M:%SZ")
+OWNER_SEEN=$(date -u +"%Y-%m-%dT%H:%M:%SZ")
+OWNER_BIO='<p class="editor-paragraph"><i><em class="editor-italic" style="white-space: pre-wrap;">A really awesome cool slick ninja dinosaur thingy</em></i></p>'
+OWNER_SIG='<p class="editor-paragraph"><span style="white-space: pre-wrap;">Love and Ciao</span></p>'
 
 SQL_FILE=$(mktemp)
 trap "rm -f $SQL_FILE" EXIT
 
-printf '%s' "INSERT OR IGNORE INTO users (username, email, password_hash, display_name, role, email_verified, created_at, updated_at) VALUES " > "$SQL_FILE"
-printf '%s' "('cr', '[email protected]', '${HASH}', 'Bobby', 'owner', 1, '${OWNER_DATE}', '${OWNER_DATE}')" >> "$SQL_FILE"
+escape_sql() {
+  printf '%s' "$1" | sed "s/'/''/g"
+}
+
+echo "BEGIN TRANSACTION;" > "$SQL_FILE"
+
+OWNER_BIO_ESC=$(escape_sql "$OWNER_BIO")
+OWNER_SIG_ESC=$(escape_sql "$OWNER_SIG")
 
+cat >> "$SQL_FILE" << OWNERSQL
+INSERT OR IGNORE INTO users (
+  username, email, password_hash, display_name, role, email_verified,
+  jade, honor, pronouns, location, bio, signature, birthday, last_seen_at,
+  ip, created_at, updated_at
+) VALUES (
+  'master', '[email protected]', '${HASH}', 'Master', 'owner', 1,
+  1000, 500, 'sol/solis', 'The Cloud',
+  '${OWNER_BIO_ESC}', '${OWNER_SIG_ESC}',
+  '1904-03-15T00:00:00Z', '${OWNER_SEEN}',
+  '127.0.0.1', '${OWNER_DATE}', '${OWNER_DATE}'
+);
+OWNERSQL
+
+echo "Generating $CITIZEN_COUNT citizens..."
+
+USED_USERNAMES="|"
 COUNT=0
 
-while IFS='|' read -r USERNAME DISPLAY JOIN_DATE; do
-  DISPLAY=$(echo "$DISPLAY" | sed "s/'/''/g")
+for ((i=0; i<CITIZEN_COUNT; i++)); do
+  USERNAME=""
+  while true; do
+    FIRST=${FIRST_NAMES[$(( RANDOM % ${#FIRST_NAMES[@]} ))]}
+    USERNAME=$(echo "$FIRST" | tr '[:upper:]' '[:lower:]')
+    if [[ "$USED_USERNAMES" != *"|${USERNAME}|"* ]]; then
+      break
+    fi
+    LAST=${LAST_NAMES[$(( RANDOM % ${#LAST_NAMES[@]} ))]}
+    USERNAME=$(echo "${FIRST}${LAST}" | tr '[:upper:]' '[:lower:]')
+    if [[ "$USED_USERNAMES" != *"|${USERNAME}|"* ]]; then
+      break
+    fi
+  done
+  USED_USERNAMES="${USED_USERNAMES}${USERNAME}|"
+
+  DISPLAY_FIRST=${FIRST_NAMES[$(( RANDOM % ${#FIRST_NAMES[@]} ))]}
+  DISPLAY_LAST=${LAST_NAMES[$(( RANDOM % ${#LAST_NAMES[@]} ))]}
+  DISPLAY_NAME="$DISPLAY_FIRST $DISPLAY_LAST"
+
+  PRONOUN=${PRONOUNS[$(( RANDOM % ${#PRONOUNS[@]} ))]}
+  LOC=${LOCATIONS[$(( RANDOM % ${#LOCATIONS[@]} ))]}
+
+  JOIN_EPOCH=$(random_date_between $THREE_MONTHS_AGO $NOW_EPOCH)
+  JOIN_DATE=$(date -r $JOIN_EPOCH +"%Y-%m-%dT%H:%M:%SZ" 2>/dev/null || date -d "@$JOIN_EPOCH" +"%Y-%m-%dT%H:%M:%SZ")
+
+  SEEN_OFFSET=$(( RANDOM % (7 * 24 * 3600) ))
+  SEEN_EPOCH=$(( NOW_EPOCH - SEEN_OFFSET ))
+  LAST_SEEN=$(date -r $SEEN_EPOCH +"%Y-%m-%dT%H:%M:%SZ" 2>/dev/null || date -d "@$SEEN_EPOCH" +"%Y-%m-%dT%H:%M:%SZ")
+
+  BDAY_EPOCH=$(random_date_between $ONE_MONTH_AGO $ONE_MONTH_AHEAD)
+  BDAY_MONTH=$(date -r $BDAY_EPOCH +"%m" 2>/dev/null || date -d "@$BDAY_EPOCH" +"%m")
+  BDAY_DAY=$(date -r $BDAY_EPOCH +"%d" 2>/dev/null || date -d "@$BDAY_EPOCH" +"%d")
+  BIRTHDAY="1904-${BDAY_MONTH}-${BDAY_DAY}T00:00:00Z"
+
+  JADE=$(( RANDOM % 500 ))
+  HONOR=$(( RANDOM % 200 ))
+
+  BIO=""
+  SIG=""
+  if [[ "$BIO_MAP" == *",${i}:"* ]]; then
+    BIO_IDX=$(echo "$BIO_MAP" | sed "s/.*,${i}:\([0-9]*\),.*/\1/")
+    BIO=$(escape_sql "${BIOS[$BIO_IDX]}")
+  fi
+  if [[ "$SIG_MAP" == *",${i}:"* ]]; then
+    SIG_IDX=$(echo "$SIG_MAP" | sed "s/.*,${i}:\([0-9]*\),.*/\1/")
+    SIG=$(escape_sql "${SIGS[$SIG_IDX]}")
+  fi
+
+  ROLE="member"
+  EMAIL_VERIFIED=1
+  BANNED=0
+  BANNED_AT=""
+  BANNED_REASON=""
+  BANNED_BY=""
+  DISABLED=0
+  DISABLED_AT=""
+  DISABLED_REASON=""
+  DISABLED_BY=""
+  LINE_NUM=$(( i + 1 ))
+
+  if [ "$LINE_NUM" -le "$ADMIN_COUNT" ]; then
+    ROLE="admin"
+  elif [ "$LINE_NUM" -le "$((ADMIN_COUNT + MOD_COUNT))" ]; then
+    ROLE="moderator"
+  elif [ "$LINE_NUM" -le "$((ADMIN_COUNT + MOD_COUNT + BANNED_COUNT))" ]; then
+    BANNED=1
+    BANNED_AT="'${JOIN_DATE}'"
+    BANNED_REASON="'Violated community guidelines'"
+    BANNED_BY=1
+  elif [ "$LINE_NUM" -le "$((ADMIN_COUNT + MOD_COUNT + BANNED_COUNT + DISABLED_COUNT))" ]; then
+    DISABLED=1
+    DISABLED_AT="'${JOIN_DATE}'"
+    DISABLED_REASON="'Account temporarily suspended'"
+    DISABLED_BY=1
+  elif [ "$LINE_NUM" -le "$((ADMIN_COUNT + MOD_COUNT + BANNED_COUNT + DISABLED_COUNT + UNVERIFIED_COUNT))" ]; then
+    EMAIL_VERIFIED=0
+  fi
+
+  DISPLAY_ESC=$(escape_sql "$DISPLAY_NAME")
+  LOC_ESC=$(escape_sql "$LOC")
 
-  printf '%s' ", ('${USERNAME}', '${USERNAME}@pagoda.local', '${HASH}', '${DISPLAY}', 'member', 1, '${JOIN_DATE}', '${JOIN_DATE}')" >> "$SQL_FILE"
+  printf "INSERT OR IGNORE INTO users (username, email, password_hash, display_name, role, email_verified, jade, honor, pronouns, location, bio, signature, birthday, last_seen_at, account_banned, banned_at, banned_reason, banned_by, account_disabled, disabled_at, disabled_reason, disabled_by, ip, created_at, updated_at) VALUES ('%s', '%[email protected]', '%s', '%s', '%s', %s, %s, %s, '%s', '%s', '%s', '%s', '%s', '%s', %s, %s, %s, %s, %s, %s, %s, %s, '127.0.0.1', '%s', '%s');\n" \
+    "$USERNAME" "$USERNAME" "$HASH" "$DISPLAY_ESC" "$ROLE" "$EMAIL_VERIFIED" \
+    "$JADE" "$HONOR" "$PRONOUN" "$LOC_ESC" "$BIO" "$SIG" \
+    "$BIRTHDAY" "$LAST_SEEN" \
+    "$BANNED" "${BANNED_AT:-NULL}" "${BANNED_REASON:-NULL}" "${BANNED_BY:-NULL}" \
+    "$DISABLED" "${DISABLED_AT:-NULL}" "${DISABLED_REASON:-NULL}" "${DISABLED_BY:-NULL}" \
+    "$JOIN_DATE" "$JOIN_DATE" >> "$SQL_FILE"
 
   COUNT=$((COUNT + 1))
-  echo "  [$COUNT/99] $USERNAME ($DISPLAY)"
-done <<< "$NAMES"
+  STATUS=""
+  if [ "$BANNED" -eq 1 ]; then STATUS=" [banned]";
+  elif [ "$DISABLED" -eq 1 ]; then STATUS=" [disabled]";
+  elif [ "$EMAIL_VERIFIED" -eq 0 ]; then STATUS=" [unverified]";
+  elif [ "$ROLE" != "member" ]; then STATUS=" [$ROLE]";
+  fi
+  echo "  [$COUNT/$CITIZEN_COUNT] $USERNAME ($DISPLAY_NAME)$STATUS"
+done
 
-echo ";" >> "$SQL_FILE"
+echo "COMMIT;" >> "$SQL_FILE"
 
 echo "Inserting into database..."
 sqlite3 "$DB_PATH" < "$SQL_FILE"
 
 TOTAL=$(sqlite3 "$DB_PATH" "SELECT COUNT(*) FROM users;")
-echo "Done. Total users: $TOTAL"
\ No newline at end of file
+echo "Done. Total users: $TOTAL (admins: $ADMIN_COUNT, mods: $MOD_COUNT, banned: $BANNED_COUNT, disabled: $DISABLED_COUNT, unverified: $UNVERIFIED_COUNT)"
\ No newline at end of file