eve-sso-auth

Basic PHP code for setting up a session and database entry for users

requires a database and the CURL extension.

Right now, it makes the assumption that people don't change which alliance/corporation they're in. Long term I'll change that, so it checks every time. Kind of requires a fix-this cronjob for the moment

You'll need to have a file called secret.php, for the $clientid and $secret.

Please change the $useragent in the authcallback.

CREATE TABLE `alliance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `allianceid` int(11) DEFAULT NULL,
  `alliancename` varchar(255) DEFAULT NULL,
  `allianceticker` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8

 CREATE TABLE `corporation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `corporationid` int(11) DEFAULT NULL,
  `corporationname` varchar(255) DEFAULT NULL,
  `corporationticker` varchar(10) DEFAULT NULL,
  `allianceid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8

 CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `characterid` int(11) DEFAULT NULL,
  `characterownerhash` varchar(255) DEFAULT NULL,
  `character_name` varchar(255) DEFAULT NULL,
  `corporationid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8