
Any kind ISK donations should be sent to "MJ Maverick" in-game.
Database Setup:
Go into the database you want the table in and import "table.sql". The table should be imported and constructed. Job done. :) Just make sure the database user you use in the "config.php" has ALL privileges to the databse you build the table 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.
>> 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.
>> Alliance Whitelist Information
$allyList = Alliance whitelist, only alliances on this list have access to your Teamspeak 3 server. Example: ("Alliance1","Alliance 2").
>> Corporation Whitelist Information
$corpList = Corporation whitelist, only corps on this list have access to your Teamspeak 3 server. Example: ("Corporation1","Corporation 2").
>> 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 "|".
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:
- Enter JUST your character name for example: "MJ Maverick".
- Enter your user ID for example: 123456.
- Enter you LIMITED API key, this is the yellow one on the Eve Online website.
- Hit Submit.
- Join Teamspeak using the nickname provided.
- 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 format your database, here is how you fix it for them:
1) Go into your database structure and find them using their "Unique ID" or "Database ID" from Teamspeak.
2) Once you find them change their "tsName" to have their new corp ticker.
3) They will no longer be kicked.
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.
[115] = 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. :)
[125] = There is a space in your API Key, there shouldn't be.
[130] = There is a space in your user ID, there shouldn't be.
[166] = 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".
[172] = Something went totally tits up, check your API details very carefully. Failed to get any account details with that API Key/User ID combination.
[193] = Failed to retrieve any characters on that account. A very unlikely error but could possibly occur on brand new accounts.
[209] = CCP didn't like that, for some reason we can't access this characters CharacterInfo.xml.
[237] = Couldn't fetch any details from the CorporationSheet.xml API. If your corp is brand new, leave it a few days.
[279] = Couldn't fetch any details from the CorporationSheet.xml API. If your corp is brand new, leave it a few days.
[299] = Couldn't fetch any details from the AllianceList.xml API. If your alliance is brand new, leave it a few days.
[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_).
[F50] = 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_).
[F85] = 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_).
[F89] = 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_).
[F103] = 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").
[F112] = Failed to remove the old registration of someone, you need to do it manually. The details you need will be included in the warning.
[F115] = Failed to remove a users old persona from Teamspeak, you need to do it manually. The details you need will be included in the warning.
[F129] = User has entered illegal characters, we don't allow this for security purposes.
[F140] = User has entered illegal characters, we don't allow this for security purposes.