Fuel PHP - Oauth Provider

Initial development of an Oauth provider package for Fuel PHP. Apologies for this not being just a single package as there are models and login / permissions pages also added. I couldn't think of an easy way to abstract the database calls from the package that anyone would benefit from, so for now this ships as a full app package.

If someone smarter than me (there should be a lot of you) wants to fork this and rework it into a single package by all means feel free. Also there is a basic users system in place for testing login and access, this is by no means thorough although should be "secure" enough and uses bcrypt for password hashing.

Prerequisites

• Requires Orm package.
• Database tables created.
• Create a table to hold your users if needed (see below).

To do's

• Create the block/'.$consumer->id method, to blacklist consumers against a particular users request token.
• Implement a RESTful controller and format output methods for easier API development.

Basic usage

Create your database tables for:

oauth_consumers

CREATE TABLE `oauth_consumers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `secret` varchar(255) NOT NULL,
  `active` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `description` text,
  `image` varchar(255) DEFAULT NULL,
  `homepage` varchar(255) DEFAULT NULL,
  `contact_email` varchar(255) DEFAULT NULL,
  `author` varchar(255) DEFAULT NULL,
  `platform` varchar(255) DEFAULT NULL,
  `callback_url` varchar(255) DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  `last_updated_by` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

oauth_consumer_nonces

CREATE TABLE `oauth_consumer_nonces` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `consumer_id` bigint(20) unsigned NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `nonce` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

oauth_tokens

CREATE TABLE `oauth_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('request','access') NOT NULL DEFAULT 'request',
  `consumer` bigint(20) unsigned NOT NULL,
  `token` varchar(255) NOT NULL,
  `token_secret` varchar(255) NOT NULL,
  `callback` varchar(255) DEFAULT NULL,
  `verifier` varchar(255) DEFAULT NULL,
  `user` bigint(20) unsigned DEFAULT NULL,
  `state` int(11) DEFAULT '0',
  `date_created` datetime DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  `last_updated_by` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `date_created` (`date_created`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

User table

CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `display_name` varchar(255) DEFAULT NULL,
  `full_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `state` int(11) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  `last_updated_by` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;