Basic PHP code for setting up a session and database entry for users.
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.gitignore
LICENSE
README.md
auth_functions.php
db.inc.php
devauthcallback.php
devlogin.php
logout.php
whoami.php

README.md

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