wispr beta

Open source social network for blogging and meeting friends using bootstrap Materialize css... for now.

For first time setup, copy all files to your server via your prefered method and create the database and tables as below

ESSENTIAL

create a .htaccess file in the root of the site with the following contents:

RewriteEngine On
RewriteRule ^([a-zA-Z0-9_-]+)$ profile.php?id=$1
RewriteRule ^([a-zA-Z0-9_-]+)/$ profile.php?id=$1
RewriteCond %{HTTP_HOST} ^www\.(.*)$ [NC]
RewriteRule ^(.*)$ http://%1%{REQUEST_URI} [R=301,QSA,NC,L]
DirectoryIndex index.php
ErrorDocument 404 /404.php

• Database

  • Table: friends
    Columns:
    friend_a varchar(45)
    friend_b varchar(45)
    approved int(11)
    blocked int(11)
  • Table: img_usr
    Columns:
    pic_id int(11) AI PK
    username varchar(45)
    imgname text
    caption text
    
  • Table: users
    Columns:
    id int(11) AI PK
    username varchar(255)
    password char(64)
    salt char(16)
    title text
    about longtext
    email varchar(255)
    profilepic text
    disp_name text
    opt_promode int(11)
  }