The Trongate PHP framework
For best results, it's HIGHLY recommended to use the Trongate Desktop App, which is available at https://trongate.io.
If - for some reason - you'd like to use the Trongate framework without the desktop app AND you'd like to use the API manager then you'll need to set up a mySQL database. Here's a dump of some SQL code that will get you started with API authentication:
START
-- phpMyAdmin SQL Dump -- version 4.7.9
-- Host: localhost -- Generation Time: Aug 13, 2019 at 08:25 PM -- Server version: 10.1.31-MariaDB -- PHP Version: 7.0.28
SET SQLMODE = "NOAUTOVALUEON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION;
CREATE TABLE IF NOT EXISTS
comments(
idint(11) NOT NULL AUTOINCREMENT,
commenttext NOT NULL, `datecreated
int(11) NOT NULL DEFAULT '0',userid
int(11) NOT NULL,targettable
varchar(125) NOT NULL,updateid
int(11) NOT NULL,code
varchar(6) NOT NULL DEFAULT '', PRIMARY KEY (id`) ) ENGINE=InnoDB AUTOINCREMENT=1 DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS
trongate_tokens(
idint(11) NOT NULL AUTOINCREMENT,
tokenvarchar(125) NOT NULL, `userid
int(11) NOT NULL DEFAULT '0',expirydate
int(11) NOT NULL,code
varchar(3) NOT NULL DEFAULT '0', PRIMARY KEY (id`) ) ENGINE=InnoDB AUTOINCREMENT=1 DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS
trongate_users(
idint(11) NOT NULL AUTOINCREMENT,
codevarchar(32) DEFAULT NULL, `userlevelid
int(11) NOT NULL DEFAULT '0', PRIMARY KEY (id`) ) ENGINE=InnoDB AUTOINCREMENT=1 DEFAULT CHARSET=utf8;
INSERT INTO
trongate_users(
id,
code,
user_level_id) VALUES (1, 'UVsY8ASG5evncc4U6trru2XH5Tbq7MU5', 1);
CREATE TABLE IF NOT EXISTS
trongate_user_levels(
idint(11) NOT NULL AUTOINCREMENT, `leveltitle
varchar(125) NOT NULL DEFAULT '', PRIMARY KEY (id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
INSERT INTO
trongate_user_levels(
id,
level_title) VALUES (1, 'admin');
CREATE TABLE IF NOT EXISTS
trongate_administrators(
idint(11) NOT NULL,
usernamevarchar(65) NOT NULL,
passwordvarchar(60) NOT NULL,
trongate_user_idint(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO
trongate_administrators(
id,
username,
password,
trongate_user_id) VALUES (11, 'admin', '$2y$11$SoHZDvbfLSRHAi3WiKIBiu.tAoi/GCBBO4HRxVX1I3qQkq3wCWfXi', 1);
ALTER TABLE
trongate_administratorsADD PRIMARY KEY (
id);
ALTER TABLE
trongate_administratorsMODIFY
idint(11) NOT NULL AUTOINCREMENT, AUTOINCREMENT=1; COMMIT;
COMMIT;
END