Any kind ISK donations should be sent to "MJ Maverick" in-game. :)

Database Setup:

Go into the database you want the tables in and import "database.sql". The tables should be imported and constructed. Job done. :) Just make sure the database user you use in the "config.php" has ALL privileges to the database you build the tables in.

Config Guide:

>> Administrators character
$admin = This is your character name. Or if you are not the Corporation/Alliances Administrator, then it should be their character name.
>> Root administrators account ID
$adminID = This is the database ID of your root admin. See "How To Setup A New Root Admin".
>> Teamspeak 3 Server Query Information
$tshost = This is the IP address of your Teamspeak 3 server ONLY.
$tsname = This is your ServerQuery username. Don't have one? In Teamspeak 3 go to "Tools -> ServerQuery Login" and enter a username for example "EVEOTS". You will then be given a password for $tspass. This MUST be done by a full server admin (all permissions and at 75).
$tspass = This is your ServerQuery password provided to you by the server when creating a ServerQuery user. Don't have one? See $tsname above to create a new one.
$tsport = This is the ServerQuery port NOT the normal client connection port. Default is "10011".
$tscport = This is the port clients use to connect on. Default is 9987.
>> Database Information
$db_host = Your database host. Default and is most commonly "localhost".
$db_user = This is the database user that has access to the database. Include your domain prefix if it has one for example "sever_eveots".
$db_pass = The password for the databse user you entered for $db_user.
$db_name = The name of the database you created the EVEOTS table in. $db_user must have ALL privileges to this database.
>> API Connection Testing Information
$TESTID = This is your Character ID, used for testing the API connection. You can just use mine though if you want.
$TESTname = This is your Character Name, used for testing the API connection. You can just use mine though if you want.
>> Your alliance/corp name
$ourname = If you are just in a corp, this is your Corporations name. If you are in an alliance, this is your alliances name.
>> Debug Mode
$verbose = If you are experiancing problems set this to true (without speech marks) and EVEOTS will tell you everything it is doing to help you find the problem.
>> Teamspeak 3 group for alliance/corp members
$group = This is the Teamspeak group for your corp members and alliance mates. To find a groups ID, in Teamspeak go to "Permissions -> Server Groups". The group ID is the number in brackets next to the group name.
>> Teamspeak 3 group for people on the whitelist but not in your alliance/corp
$bluegroup = This is the Teamspeak group for people that are blue to you. To find a groups ID, in Teamspeak go to "Permissions -> Server Groups". The group ID is the number in brackets next to the group name.
>> Banner Image
$banner = This is the directory your banner is in. I recommend keeping all your images in the image folder.
>> Spacer
$spacer = Some people like to have spacers between tickers on their Teamspeak, this is totally optional and if you want "-7- IRNP MJ Maverick" then leave it blank. However for "-7- | IRNP | MJ Maverick" set it to "|".

How To Setup A New Root Admin:

As of v1.5 you will need to know how to setup a root admin for the admin panel. This might seem complicated but it's actually very easy.
  1. Go to the admin panel (eveots_uploaded_here/admin) and login, the default username/password is "admin"
  2. Create yourself an account in the Audit Administrators menu.
  3. Open your database and go to the admins table.
  4. Find your account entry or the otherwise "root admin to-be" and get their "id" number.
  5. Open config.php and set "$adminID" to this "id" number and reupload.
  6. Go back into the admin panel and logout.
  7. If the original "admin" admin still exists log back in to the admin panel with your account and delete the original "admin" account in the Audit Administrators menu.
  8. If "admin" is no longer listed in the Administrator lists and the desired root admin is highlighted, you did it right.

Teamspeak Whitelist:

Your Teamspeak server MUST have your web servers IP on a whitelist or it will not accept it's commands and registration will not be able to connect. To do this contact your Teamspeak provider.
There is a file in the Teamspeak folder on the server called "query_ip_whitelist.txt". Your web servers IP must be in this. To find your websites IP address open Command Prompt and "ping www.mywebsite.com". Obviously make sure you send your web servers IP to your TS provider.

How To Register:

  1. Enter JUST your character name for example: "MJ Maverick".
  2. Use the link on the page to create a new customizable key here if you haven't already.
  3. Enter your key's ID and verification code from here.
  4. Hit Submit.
  5. Join Teamspeak using the nickname provided or just use the link.
  6. Click Register.

Security Bot:

bot.php is a script that will scan your TS and make sure people have the correct nickname, if they don't it will kick them with reason "SecurityBot: Your nickname should be exactly PROPER_NICKNAME".
It is recommended you run this file on a cron job every 10 minutes or 15 on extremely trafficed servers, depending on how much load your web server can take (the script is pretty lightweight). To prevent e-mail spam (if you have that enabled in CPanel) you can add ">/dev/null 2>&1" to the end of the cron command to prevent e-mails.

It is also worth noting that if a user switches corp in your alliance then they will be kicked for having the wrong name if they change their ticker in Teamspeak respectively. Until I implement a function (possibly long winded) to fix this for you without you having to do anything, here is how you fix it for them:
1) Log into the admin panel.
2) Find them in "Audit Members" and edit them.
3) You can now change their permitted name. Remember to include tickers.

Error Codes:

If anything fails through registration after their permisions are granted, they will be removed before the page stops. No need to worry about stray accounts getting through.

[93] = CCP server down or the character ID you entered into $TESTID is fubar. Make sure you are using your character ID and NOT your API user ID. If in doubt, use mine. :)
[114] = There is a space in your verification code, there shouldn't be.
[120] = There is a space in your key ID, there shouldn't be.
[145] = CCP rejected the ID and Verification Code combination.
[148] = Couldn't retrieve APIKeyInfo.xml from the API server, it's probably down. Try again later.
[181] = Couldn't find a character ID for the character name you entered. Make sure you entered it correctly with NO ticker. See "How To Register".
[188] = Something went totally tits up, check your API details very carefully. Failed to get any account details with that ID/VCode combination.
[215] = Not sure how this happened, apparently I can't count. Nothing to worry about.
[228] = Failed to retrieve any characters on that account. A very unlikely error but could possibly occur on brand new accounts.
[245] = CCP didn't like that, for some reason we can't access this characters CharacterInfo.xml.
[280] = Couldn't fetch any details from the CorporationSheet.xml API. If your corp is brand new, leave it a few days.
[331] = Couldn't fetch any details from the CorporationSheet.xml API. If your corp is brand new, leave it a few days.
[352] = Couldn't fetch any details from the AllianceList.xml API. If your alliance is brand new, leave it a few days.

[A103] = Failed to get the character corporation for the admin list, make sure the API server is alive.
[A281] = Failed to get the character ID from the API server, the API server may be down.
[A293] = Failed to get the character name from the API server, the API server may be down.
[A365] = Failed to get the character corporation and alliance for the admin list, make sure the API server is alive.
[A807] = Failed to connect to Teamspeak.
[A818] = Failed to kick a person from Teamspeak, this is concerning.
[A844] = Query sent to the database failed.
[A864] = Query sent to the database failed..
[A867] = Failed to delete the clients Teamspeak registration.
[A914] = Failed to connect to Teamspeak.
[A951] = Failsafe, didn't see this coming. Failed to query the Teamspeak regarding someones name during a discrepancy check.
[A1212] = Failed to retrieve Corp ID.
[A1225] = Failed to retieve Corp details.

[F10] = Failed to connect to your Teamspeak 3 server, ensure your details are correct (see $tsname in "Config Guide" to set up a ServerQuery user). If your details are certainly right, check with your host that they have ServerQuery enabled and haven't arsed about with the settings. If everything is in order make sure your webserver is on the Teamspeaks whitelist (see "Teamspeak Whitelist").
[F20] = It looks like you put your ticker in your name or something daft. The system should actually detect this before now but it's here in case something wacky happens.
[F25] = You probably already have permissions. Check in Teamspeak.
[F32] = Couldn't connect to your SQL server, double check all your details and there are no connection problems with your host, $db_user and $db_name should contain your domain prefix (webhostaccount_).
[F37] = Couldn't connect the table in your SQL database, double check all your details and there are no connection problems with your host, your table is $db_name and should contain your website account prefix (webhostaccount_).
[F49] = Failed to insert the new user into the database. Check your table structure is correct. If all else fails, recreate the table and transfer your data across fromt he old table.
[F59] = Couldn't connect to your SQL server, double check all your details and there are no connection problems with your host, $db_user and $db_name should contain your domain prefix (webhostaccount_).
[F63] = Couldn't connect to your SQL database, double check all your details and there are no connection problems with your host, your table is $db_name and should contain your website account prefix (webhostaccount_).
[F89] = Couldn't connect to your SQL server, double check all your details and there are no connection problems with your host, $db_user and $db_name should contain your domain prefix (webhostaccount_).
[F93] = Couldn't connect to your SQL database, double check all your details and there are no connection problems with your host, your table is $db_name and should contain your website account prefix (webhostaccount_).
[F108] = Failed to connect to your Teamspeak 3 server, ensure your details are correct (see $tsname in "Config Guide" to set up a ServerQuery user). If your details are certainly right, check with your host that they have ServerQuery enabled and haven't arsed about with the settings. If everything is in order make sure your webserver is on the Teamspeaks whitelist (see "Teamspeak Whitelist").
[F119] = Failed to remove the old registration of someone, you need to do it manually. The details you need will be included in the warning.
[F130] = Failed to remove a users old persona from the SQL database, you need to do it manually. The details you need will be included in the warning.
[F134] = You are online with an account I'm trying to delete. :(
[F136] = Failed to delete a user from Teamspeak.
[F151] = User has entered illegal characters, we don't allow this for security purposes.
[F162] = User has entered illegal characters, we don't allow this for security purposes.
[F181] = Couldn't connect to your SQL server, double check all your details and there are no connection problems with your host, $db_user and $db_name should contain your domain prefix (webhostaccount_).
[F185] = Couldn't connect the table in your SQL database, double check all your details and there are no connection problems with your host, your table is $db_name and should contain your website account prefix (webhostaccount_).