Skip to content
The Trongate PHP framework
PHP CSS Hack
Branch: master
Clone or download
davidjconnelly Added 404 http status code to the default error page. Also made corre…
…ction to admin template so that it's now pointing at w3css folder for admin.css.
Latest commit bfacbd2 Aug 16, 2019
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
config removed test files and code Aug 13, 2019
engine changed version number Aug 15, 2019
modules Added 404 http status code to the default error page. Also made corre… Aug 16, 2019
public *** Rerouted admin.css etc --- admin.css is now being served from adm… Aug 16, 2019
templates
.gitignore improved api_auth and removed console.log from comments block Aug 13, 2019
.htaccess here goes nothing Aug 13, 2019
README.md Correction to readme file - added SQL for comments table. Aug 13, 2019
license.txt changed version number Aug 15, 2019

README.md

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 -- https://www.phpmyadmin.net/

-- Host: localhost -- Generation Time: Aug 13, 2019 at 08:25 PM -- Server version: 10.1.31-MariaDB -- PHP Version: 7.0.28

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00";

-- -- Database: a3


-- -- Table structure for table comments

CREATE TABLE IF NOT EXISTS comments ( id int(11) NOT NULL AUTO_INCREMENT, comment text NOT NULL, date_created int(11) NOT NULL DEFAULT '0', user_id int(11) NOT NULL, target_table varchar(125) NOT NULL, update_id int(11) NOT NULL, code varchar(6) NOT NULL DEFAULT '', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;


-- -- Table structure for table trongate_tokens

CREATE TABLE IF NOT EXISTS trongate_tokens ( id int(11) NOT NULL AUTO_INCREMENT, token varchar(125) NOT NULL, user_id int(11) NOT NULL DEFAULT '0', expiry_date int(11) NOT NULL, code varchar(3) NOT NULL DEFAULT '0', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=2240 DEFAULT CHARSET=utf8;


-- -- Table structure for table trongate_users

CREATE TABLE IF NOT EXISTS trongate_users ( id int(11) NOT NULL AUTO_INCREMENT, code varchar(32) DEFAULT NULL, user_level_id int(11) NOT NULL DEFAULT '0', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- -- Dumping data for table trongate_users

INSERT INTO trongate_users (id, code, user_level_id) VALUES (1, 'UVsY8ASG5evncc4U6trru2XH5Tbq7MU5', 1);


-- -- Table structure for table trongate_user_levels

CREATE TABLE IF NOT EXISTS trongate_user_levels ( id int(11) NOT NULL AUTO_INCREMENT, level_title varchar(125) NOT NULL DEFAULT '', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- -- Dumping data for table trongate_user_levels

INSERT INTO trongate_user_levels (id, level_title) VALUES (1, 'admin'); COMMIT;

END

You can’t perform that action at this time.