You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
38 lines
1.4 KiB
38 lines
1.4 KiB
# BBS.ピケ.コム
|
|
|
|
this is a silly little BBS page I've thrown together out of a desite to have something I can use to get images from *practically anything* to a modern computer. it's designed as an imageboard in the style of [ふたは☆チャンネル](https://2chan.net)/[4chan](https://4channel.org), since I find that structure is remakably practical while being so minimalist you don't even need names to follow a conversation.
|
|
|
|
## hosting
|
|
1. install:
|
|
- PHP (I use 7.3.31)
|
|
- PostgreSQL (I use 11.14)
|
|
- ffmpeg (I use 4.1.8)
|
|
- exiftool (I use 11.16)
|
|
2. clone this repo, `git clone https://git.xn--rck9c.xn--tckwe/pk11/bbs.git`
|
|
2. copy `vars.php.example` to `vars.php`
|
|
3. edit `vars.php` as explained in the file
|
|
- ensure that your `image` and `thumb` folders exist
|
|
4. create the following tables in the configured database:
|
|
```sql
|
|
CREATE TABLE posts (
|
|
post_id INT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
|
|
post_time TIMESTAMPTZ NOT NULL DEFAULT NOW(),
|
|
user_id VARCHAR(40),
|
|
name VARCHAR(256),
|
|
trip VARCHAR(10),
|
|
email VARCHAR(256),
|
|
comment VARCHAR(2048),
|
|
img VARCHAR(256),
|
|
thumb_width INT,
|
|
thumb_height INT,
|
|
spoiler BOOL
|
|
);
|
|
```
|
|
```sql
|
|
CREATE TABLE access (
|
|
count INT,
|
|
lock BOOL PRIMARY KEY DEFAULT TRUE,
|
|
CONSTRAINT lock_unique CHECK(lock)
|
|
);
|
|
```
|