Pages: 1 2 3 4 5 6 :: [one page] |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.23 03:32:00 -
[1]
Version: 1.0
Intro: So there I was, using a Teamspeak registration system that once worked well but is now outdated and falling to pieces :( (♥ u really Agent Unknown :) ). I saw that people had made their own but wanted outrageous amounts of ISK in order to share it. So, meh. I'll make my own simple, fast, easy to mod and adaptable system. Only one problem, I know jack about PHP. I only knew what little I learnt from building my alliance a nice new website.
So I learnt PHP :) Then built my baby piece by piece. Now you can have it. Call it my little gesture to share a little love in Eve. I plan to add more features such as red alt scanning etc. while keeping it fast in the future along with keeping up to date with the ever changing Teamspeak development. Also as I am/was/ish a sort of PHP noob, you should find my heavily commented code easy to understand.
Features: Cron job for quickly scanning if characters registered have left their corp/alliance and removes them Alliance whitelist Corporation whitelist Assign your own boys/girls into a separate group than your blues Shoo's away doorstep salesmen API interface powered by Pheal Teamspeak interface powered by TS3 PHP Framework
Down to business: Here it is: Mirror 1 - Sev3rance Alliance (MJ Maverick)
Baring in mind how much ISK people want for a system like this feel free to donate if you use it :) (me poor *sadface*). If you run into any problems then either use this thread or mail me in game and I'll be happy to help.
Any donations should be sent to "MJ Maverick".
Special Thanks To: Peter Powers from Pheal Wollari from DOTLAN ScP from Teamspeak
------------------ CCP are not perfect. :)
|
Peter Powers
FinFleet Raiden.
|
Posted - 2011.03.23 08:55:00 -
[2]
hey mj m.,
nice to see you are getting further with your effords to learn php, however, i have to put out a warning for people to install your script.
please do not take this personal, but the current version of the script is a security risk to everyone who installs it. you are not sanitizing any userinput and therefor this script is quite vulnerable to sql injections. more on SQL Injection
also, you dont verify the user who puts in the API key is actually the owner of the key, assuming that someone who knows the key is actually the guy that should be allowed to access your teamspeak. That Idea is wrong, apikeys are 'public' keys; so if someone puts his api key to a random website, and that website owner then decides to register on your teamspeak with the users key, he could do that. To verify a user is the owner of a character you wont get arround letting him send an isk or an evemail from one of the characters on his account to one of yours (you can pull that from your own API then).
Vote Peter Powers for CSM6!
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.23 16:42:00 -
[3]
Hey Peter,
I know a bit about injections but was unable to give myself access with them. I see it as someone's API key is their responsibility but in light of what you said would you recommend using their FULL API? A lot of people wouldn't like to use this.
I'll hit you up in game next time I see you pop up but I really can't see a security problem.
------------------ CCP are not perfect. :)
|
Peter Powers
FinFleet Raiden.
|
Posted - 2011.03.23 17:25:00 -
[4]
about the sql injection: its possible to insert characters that mysql interpretes as mysql commands, therefor it will execute 'em
about the key: it does not matter what key you use, the key is meant to be 'distributed', since it is meant to allow others to access your accounts data. therefor its not safe to use it for authentication. for example, if i want myself to appear on a killboard through api, i have to give away my key, the owner of the killboard can read it and do shenannigans with it, like registering on your tool, thats why using keys, no matter if full or limited is no way of authentication.
Vote Peter Powers for CSM6!
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.23 19:23:00 -
[5]
Next time I see you we should have a discussion about alternative methods, I do have a few in mind. But as it is all Teamspeaks I have ever needed to register on use the API key method. True there are more secure methods, but keeping things simple is also key. I shall probably change the verification methods later on to a more secure way if I can find one that is also reliable.
------------------ CCP are not perfect. :)
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.25 17:19:00 -
[6]
Update v1.1
Added some spy and general imposter stuff. Also added an instructions page when people need to verify they are the account holder via making a new API. You should no longer be able to get a person in your database twice, but it checks anyway, that goes for TS also.
------------------ CCP are not perfect. :)
|
Catari Taga
Centre Of Attention Middle of Nowhere
|
Posted - 2011.03.25 17:37:00 -
[7]
Originally by: MJ Maverick After a detailed going over of my code I have found it not susceptible to SQL injections. Any SQL injection would stop the script with an error before it got anywhere near the database. "str_replace" removes key ingredients of SQL injections even if one did some how get through.
If you are talking about the code that is posted in the OP that is not correct, you write form input directly to your database and thus are widely open to SQL injection. The thought alone makes me shudder. You really should do some research on this, it is not a trivial matter. --
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.25 17:47:00 -
[8]
If you can make it work then please let me know straight away as yes, that would be serious, but I cannot. Raw data is taken yes. However an SQL injection still has to go through the API verification, as it will not be a valid API/user/char information it will of course fail. Thus never reaching the SQL stage it was intended to inject.
------------------ CCP are not perfect. :)
|
Catari Taga
Centre Of Attention Middle of Nowhere
|
Posted - 2011.03.25 18:02:00 -
[9]
Originally by: MJ Maverick If you can make it work then please let me know straight away as yes, that would be serious, but I cannot. Raw data is taken yes. However an SQL injection still has to go through the API verification, as it will not be a valid API/user/char information it will of course fail. Thus never reaching the SQL stage it was intended to inject.
I would have to check pheal source code to be sure but assuming pheal does some input sanitizing it might simply strip offending characters from the input without giving you an error message. Or CCP might allow tomorrow to allow e.g. a semi-colon in their character names or API keys. The thing is that it is simply unnecessary and bad practice to even take the risk. Sanitize what goes into your database and thus decouple it from whatever else may go on in your code. mysql_real_escape_string() will take care of the names, e.g. intval() will take care of the IDs. --
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.25 18:19:00 -
[10]
Edited by: MJ Maverick on 25/03/2011 18:29:30
inputID is just used when using the persons API prior to storage.
I'll take a look at those functions you linked and see if I can put them in just for good measure. I have to make sure that nothing filters ' or ! however as they have special meaning in my code. Because you have ' in character names, ! = ' as ' will crash an SQL statement so must be subsidised with ! in the database and switched back to ' whenever being displayed. But as it goes today, right now, I honestly don't see it susceptible to injections.
I will however add safeguards incase CCP do something daft.
Edit: In hind sight, a if I remove all ", ' and ; from all fields prior to storage then I should be immune anyway right? The problem is API Keys contain certain characters such as = so cannot be filtered. Do you know of a list of characters all API Keys are made up of?
------------------ CCP are not perfect. :)
|
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.25 19:18:00 -
[11]
Update v1.15
Made security future proof for SQL shenanigans.
------------------ CCP are not perfect. :)
|
Catari Taga
Centre Of Attention Middle of Nowhere
|
Posted - 2011.03.25 19:38:00 -
[12]
Originally by: MJ Maverick Because you have ' in character names, ! = ' as ' will crash an SQL statement so must be subsidised with ! in the database and switched back to ' whenever being displayed.
Lol no, what you do is escape special characters, not replace them. The function I linked will do this for you (hence the name). Welcome to programming. --
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.25 22:18:00 -
[13]
Haha, I see what you mean. So by using that it would insert the ' into the database but not break the query :P right? To be honest how it is now will die() on SQL injection attempts, and as I don't want them in with my database even if they have no effect I just barred them completely. But in future when boxing with names with ' in and SQL I will use the escape function so definitely a thanks there. :D Thanks for the lesson.
------------------ CCP are not perfect. :)
|
Catari Taga
Centre Of Attention Middle of Nowhere
|
Posted - 2011.03.25 22:38:00 -
[14]
You are welcome. :)
Your change does not really catch all injection vectors but I'll leave you alone with this now.
PS: Parting presents: in_array() and trim(). :) --
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.25 22:57:00 -
[15]
Yeah I found that out reading up on your links.
$query = "INSERT INTO users (api_user,api_key,characterID,blue,tsDatabaseID,tsUniqueID,tsName) VALUES ('$inputID','$inputAPI','$characterID','$blue','$tsDatabaseID','$tsUniqueID','$tsName')"; $sqlquery = mysql_real_escape_string($query); mysql_query($sqlquery);
Is that good?
------------------ CCP are not perfect. :)
|
Peter Powers
FinFleet Raiden.
|
Posted - 2011.03.26 01:15:00 -
[16]
simply checking for a small list of characters that might hurt your sql does not cut it.
php offers several methods to escape mysql queries (mysql_real_escape_string), but even those can be tricked by characterset shenannigans, if you want to be safe for heavens sake use prepared queries.
Link for the lazy people:
http://de.php.net/manual/en/pdo.prepare.php
Originally by: "PHP Manual"
"The purpose of prepared statements is to not include data in your SQL statements. Including them in your SQL statements is NOT safe. Always use prepared statements. They are cleaner to use (code easier to read) and not prone to SQL injections."
your check for duplicates does not ensure that the registered user is the right user,
case: user a is not registered, but put his api key to website x owned by user b user b goes to the app and enters key of user a user b now looks like user a.
the only way you can be sure that the owner of the key is the one registering is when you ingame auth the user aswell (and by that i do not mean using the IGB which can be forged),
howto:
stuff needed: an account which is trusted by the website (the one running it) a cronjob
Step 1: User Registeres at the website, his characterID is saved.
Step 2: two methods possible: a) User sends 1 (or random amount) of ISK to trusted character (your character) (this can be with a specific reason so you can filter by that) b) User sends a evemail to trusted character (this can be with a specific subject so you can filter by that)
Step 3: Cronjob runs, checks for new transfers/evemail (matching filter) for all new items (transfers or evemails), it will check the user accounts created in step 1, and set them to verified.
Step 4: User is able to login
Problems: user cannot login directly (doh). cronjob has to respect cache timers, so it can take a while
Thing is, there is no other way to be sure that whoever registers is who he claims to be. This Subject has been discussed on #eve-dev a few times, and its up to CSM6 (still hoping i got elected ;) to talk to the right people at CCP, to get them to prioritize a way of verification that has a bit more usability to the end user. Until that happens, there is no way arround it.
Vote Peter Powers for CSM6!
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.26 02:36:00 -
[17]
Edited by: MJ Maverick on 26/03/2011 02:44:34 A lot of what you say is my point. There is no practical way to be certain all members are who they say they are. All ways that prove this are plagued by cache timers like you said. For the sake of speed and getting people on comms every alliance/corporation I know uses the API Key. It's not perfect but in my opinion it is the best we have for practicality at the moment. If the cache timers didn't last so long then the wallet would be the first thing I'd leap for. But as it is, pretty much everyone uses API with one dodgy system or the other.
So I am simply trying to offer the best way to do it if you must use API. Which, as I said, most people are forced to. Perhaps I will make a way to merge the two, or make a just wallet verification system at some point. But as it stands, I'm just filling the void Agent Unknowns system left. I hope for all our sakes you get into CSM6 and are able to change CCPs opinion on verification. But at the end of the day, nothing is ever 100% secure.
Edit: I am using mysql_real_escape_string :P
------------------ CCP are not perfect. :)
|
Varitina
|
Posted - 2011.03.27 19:36:00 -
[18]
Edited by: Varitina on 27/03/2011 19:46:34 I am paying for website host from a source other than Teamspeak 3, and I'm also paying for teamspeak 3 host, by Gameservers.com
They claim default serverquery is 9100, so i used it. This is what i get.
Quote: API Connection was established.
Checking... Character: Varitina
You are on our alliance whitelist Attempting to grant access to: STCZ Varitina...
Removing your old registrations... 0 old registrations removed.
An error occured: Connection timed out [F10]
Any ideas? *Edit* I entered debug, and it gave no extra info, still says connection time out, and 0 old registrations removed. So its has to be a serverquery problem. and im all out of my knowledge.
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.27 23:00:00 -
[19]
That error is a complete failure to connect to your Teamspeak.
GameServers are wrong, the default port is in fact as stated in my readme "10011". Have you tried using that port? The only way it would not be 10011 is if GameServers have changed it from the default for some silly reason. :-/
http://forum.teamspeak.com/showthread.php/46486-Teamspeak-3-Server-Ports?p=200519#post200519
------------------ CCP are not perfect. :)
|
Varitina
|
Posted - 2011.03.27 23:11:00 -
[20]
Edited by: Varitina on 27/03/2011 23:17:35 Thats what i mean, they stated, that they have changed all ports, and they have a confusing answer.
FAQ Post on their members section for TS3:
Quote: What is the query port for my server? Why won't the ts viewer work?
The query port for your server is 9100. No existing TS query scripts or websites will work, they will all need to be updated for the new version of TS.
I'll try 10011 anyways, and get back to ya. But i also made a TS server on my PC, enabled default ports on my router, just to test, and it still failed. But that could be my fault. *Edit* With 10011, still same error. Any ideas? Could it maybe not be port?
|
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.28 00:09:00 -
[21]
Any quote like that from a service provider deeply worries me. It shows incredible arrogance. I assure you my script works with the latest Teamspeak :)
If the server wasn't interpreting the commands correctly it would throw errors, not time out or not connect at all. I would suggest contacting GameServers on the basis their TS servers do not accept Queries... Which is both a failure of adiquette service and providing of the full service you pay for.
------------------ CCP are not perfect. :)
|
Varitina
|
Posted - 2011.03.28 01:32:00 -
[22]
I really like this authenticator. I hope to get it working.
But i still cant get it working, like i said, i made my own server on my local pc to test out the program, and it doesn't work on mine either, and all ports are correctly forwarded, and proper ip's in place.
Could it be permissions?
|
Moogless
|
Posted - 2011.03.28 02:23:00 -
[23]
Originally by: Varitina I really like this authenticator. I hope to get it working.
But i still cant get it working, like i said, i made my own server on my local pc to test out the program, and it doesn't work on mine either, and all ports are correctly forwarded, and proper ip's in place.
Could it be permissions?
Unless your actuelly running your php script from the computer you are probably going to have problems with your router. (I need to DMZ to my local IP as port forwarding doesnt help me much on my router).
Are your
public $tsport = "10011"; //ServerQuery Port public $tscport = "9987"; //TeamSpeak client port
Set correctly according to gameservers details?
Are you using domain for the: public $tshost = "ts3.lala.com";
Try with the ip only, public $tshost = "11.22.333.44";
If there hasnt been thought of it in the programming (cba to look through code)
|
PsyKzz
Minmatar Bat Country Goonswarm Federation
|
Posted - 2011.03.28 02:25:00 -
[24]
MJ Maverick, do you know of R3tro? he's a dude in your alliance. PsyK
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.28 18:00:00 -
[25]
Originally by: PsyKzz MJ Maverick, do you know of R3tro? he's a dude in your alliance.
lol off-topic but yes.
------------------ CCP are not perfect. :)
|
Varitina
|
Posted - 2011.03.28 22:12:00 -
[26]
Edited by: Varitina on 28/03/2011 22:14:27 @Moogless, appreciate the help on those, but nope, i have all info filled correctly, contacted the company, and they confirmed that the query is 9100, and the connection port is 9186.
i also used the ip instead of subdomain. Still nothing, it gets connection times out. I'm so lost, what on earth could it be, if all the possibilities are 100% correct, whats left?
Host 8.9.36.132 Query: 9100 client: 9186 name: *Custom* pass: *Randomly generated from my name*
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.29 15:37:00 -
[27]
Try this:
1) In Teamspeak go to Tools > ServerQuery. 2) Press the tick in the top right and select login command. 3) Enter this into the top box on the left:
login $tsname $tspass use 1 clientkick clid=YOUR_CLIENT_ID reasonid=5 reasonmsg=Test
Check your config.php and put in place of $tsname and $tspass what ever you have entered for them. For YOUR_CLIENT_ID click on your name in TS and on the right there is a number in brackets next to your name. So for example.
login username password use 1 clientkick clid=29 reasonid=5 reasonmsg=Test
If you get an invalid clientID error then try "use 2" then 3 then 4 until you run out of servers. (error id=1033 msg=server\sis\snot\srunning).
If it doesn't work then your provider has ServerQuery turned off and needs to be shot.
------------------ CCP are not perfect. :)
|
Varitina
|
Posted - 2011.03.29 16:10:00 -
[28]
Good and bad news, since i followed your last directions, its not the same message. Bad news, still doesn't work. I get a different error, and I'm not in an alliance.
Quote: Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta
API Connection was established.
Checking... Character: Varitina Debug: User ID: **lol** Debug: API Key: *NO bodys business*
Character ID: **********
Debug: Character List: Debug: PLAYER1 Debug: Varitina Debug: PLAYER2 Debug: API verified. You are on our alliance whitelist Debug: Getting your corp ticker... STCZ Debug: Getting your alliance ticker... An error occured: API Date could not be read / parsed, orginial exception: Operation timed out after 10 seconds with 465007 bytes received [239]
Any ideas now?
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.29 19:22:00 -
[29]
Keep the clientID as your client ID on the server (in brackets) but keep changing "use" up one number until you hit server not running again. Eventually you should be kicked from TS.
------------------ CCP are not perfect. :)
|
Varitina
|
Posted - 2011.03.30 21:37:00 -
[30]
Edited by: Varitina on 30/03/2011 21:37:02 Okay, i have received a reply to my service petition, and he told me to use the following phrase "use port=" rather than "use". like this:
login *User* *Pass* use port=9186 clientkick clid=66 reasonid=5 reasonmsg=Test
This kicked me. So, the serverquery is working, whats my next approach to solving this problem, and i am 100% positive that the config file is filled TS info correctly.
|
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.31 17:30:00 -
[31]
Try setting $tsport to 9186...
------------------ CCP are not perfect. :)
|
Jorr Meditir
Gallente Deathwatch Gaming
|
Posted - 2011.03.31 21:07:00 -
[32]
Hello MJ Maverick.
Really nice thing you have going here!
Just a sugestion on this debate on validating the API key/user: What about using the in game browser to validate the charid aganist what is found on the api key? |
Varitina
|
Posted - 2011.03.31 21:21:00 -
[33]
... Thats what I have been using.
|
Aaeolian
the united Negative Ten.
|
Posted - 2011.03.31 21:28:00 -
[34]
Evelopedia
Originally by: "Evelopedia" Implementation Tips
Bear in mind that these headers are easily spoofed, and you should not rely on them for security or authentication.
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.31 21:57:00 -
[35]
Indeed they are. Never rely on headers.
So Varitina you have tried setting $tsport (NOT $tscport) to 9100, 10011 and 9186? Does the Teamspeak account you created the ServerQuery user with have server admin? I mean full server admin (all your permissions should be 75).
------------------ CCP are not perfect. :)
|
Varitina
|
Posted - 2011.03.31 22:16:00 -
[36]
Sorry, well just tried anyway, and no success.
And yes, it has full admin, except for global commands, the company can't let me touch other peoples servers.
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.03.31 23:58:00 -
[37]
Edited by: MJ Maverick on 31/03/2011 23:59:47 Is your web server on your Teamspeak servers whitelist?
If not you need to contact your host, 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 adress open CMD and "ping www.mywebsite.com". Obviously make sure you send your web servers IP to your TS provider.
------------------ CCP are not perfect. :)
|
Varitina
|
Posted - 2011.04.01 10:45:00 -
[38]
They have added it, and I've tried since, no success. I will give it a couple more hours, they said give it some time, that was 6 hours ago.
|
Sasha KittyPuss
|
Posted - 2011.04.01 10:45:00 -
[39]
Ok I get to this stage and get this error.
Removing your old registrations... 0 old registrations removed.
An error occured: invalid URI supplied [F10]
any enlightenment would be welcome
cheers
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.01 13:21:00 -
[40]
Varitina if it wasn't set then your Teamspeak will need restarting.
Sasha, [F10] = Failed to connect to your Teamspeak 3 server, ensure your details are correct.
------------------ CCP are not perfect. :)
|
|
Sasha KittyPuss
|
Posted - 2011.04.01 14:49:00 -
[41]
Originally by: MJ Maverick Edited by: MJ Maverick on 01/04/2011 13:42:51 Varitina if it wasn't set then your Teamspeak will need restarting.
Sasha, [F10] = Failed to connect to your Teamspeak 3 server, ensure your details are correct.
Also: Update v1.17 cron.php will now know if it's being run via CPanel and format e-mails correctly. Made readme.html into your EVEOTS bible for when I'm not around.
Ok TS3 ip is correct serverquery admin name and pass correct, ports correct, database correct TS3 ip whitelist is also correct still same error.
API Connection was established.
Checking... Character: Thickonumbnuts
You are on our alliance whitelist Attempting to grant access to: BIG-I A-N-D Thickonumbnuts...
Removing your old registrations... 0 old registrations removed.
An error occured: invalid URI supplied [F10]
|
Peter Powers
FinFleet Raiden.
|
Posted - 2011.04.01 16:12:00 -
[42]
Originally by: Jorr Meditir Hello MJ Maverick.
Really nice thing you have going here!
Just a sugestion on this debate on validating the API key/user: What about using the in game browser to validate the charid aganist what is found on the api key?
thats so ****ing easy to fake its not even funny to suggest this. Vote Peter Powers for CSM6!
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.04.02 00:10:00 -
[43]
Edited by: Cyerus on 02/04/2011 00:14:41 Hi,
First I should thank you for trying to create something like this. As you said, your PHP skills aren't that good, and can easily be seen by checking out your code. Here are some things you need to pay more attention to;
* Stop using die() There is no need whatsoever to use die(). Everything can be caught by some if...else statements.
Instead of;
if(statement) { die("Error"); } do_something();
Try;
if(!statement) { do_something(); } else { echo "error"; }
Or the bigger version;
if(!statement) { if(!other_statement) { do_something(); } else { echo "other error"; } } else { echo "error"; }
* Variable outside the quotes
Wrong;
format("Checking... $fetchCharacterName\n", "Checking... $fetchCharacterName<br />");
Good;
format("Checking... " . $fetchCharacterName . "\n", "Checking... $" . $fetchCharacterName . "<br />");
* PHP 'echo' is slow, and should be avoided for big texts
duplicates.php
echo "<html> .... ";
Instead, just close the PHP tag ( !> ), and let the HTML just be passed along. Variables always need to be outside the quotes, and can be echo'd by using using;
<!php echo $c->banner; !>
* Only 1 database connection is enough
Instead of every function calling the database on it's own (and hence repeating the same piece of code over and over), just make a seperate function and do the database connection there. All the tables are loaded in the same database, meaning that select_db() function can be set in that function aswell. For example;
function do_DB($host, $user, $pass, $db) { $connect = mysql_connect($host, $user, $pass); if($connect) { $link = mysql_select_db($db, $db); if($link) { return $link; } else { return false; } } else { return false; } }
$link = do_DB($c->db_host, $c->db_user, $c->db_pass, $c->db_name); if($link) { echo "Connection succesful";
do_stuff();
mysql_close($link); } else { echo "Connection failed; " . mysql_error($link); }
After you get this under control, you want to remove PHP from the template. Meaning that no PHP will be used inside the template, instead tags like {$variable} will pe parsed by a template engine. RainTPL is a very fast one, having all the functions you need. Also things like CSS and JavaScript should be made seperate files, for caching purposes.
I hope this helps.
~Cyerus
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.02 00:32:00 -
[44]
Thanks Cyerus.
However a few things are intentional so I'll just point them out.
die() is used all the time because if a single stage of the registration fails then you need everything to stop. Otherwise you could end up with anything like people registered on TS but not in the database or visa versa. It can just cause a total mess.
I see your point about the variables :P I just didn't think it was such a biggy as the PHP manual says if you use " then the variable value will be printed, ' will just print the variable.
The reason the database is opened and closed continuously is to prevent time-outs on long runs. I had a distinct problem on some web servers of the connection timing out if held open for too long. So it's like that for compatibility purposes with other servers.
I don't really want to add stuff I'm not going to totally utilise. I'm trying to keep it as "lite" as possible. Think Windows 95 not Vista.
------------------ CCP are not perfect. :)
|
Varitina
|
Posted - 2011.04.03 14:46:00 -
[45]
I'm just going to give up on this, I don't know why in hell it keeps timing out, but its hopeless at this point.
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.03 16:00:00 -
[46]
Edited by: MJ Maverick on 03/04/2011 16:01:00 I'm sorry to hear that. But it genuinely sounds like a real problem with your host. They have clearly messed with settings and screwed up the Teamspeaks ability to communicate. After they added your websites IP to their whitelist did they reboot the Teamspeak? Also have you tried the different query ports we tried before since?
------------------ CCP are not perfect. :)
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.04 08:46:00 -
[47]
Originally by: Varitina I'm just going to give up on this, I don't know why in hell it keeps timing out, but its hopeless at this point.
Ok I have been watching this problem, try this, set up a TS3 server on a local machine using the mysql tables on your host, once you have it set up make sure to add your hosts ip and your actual ip not local machine to the whitelist, once you have done that install this application on your host and add the sql table to your TS3 sql on your host. when you first start TS3 it will generate the serverquery admin for you with a password. use this on the config >> serveradmin and what ever the password is. this does work and works well. if this works then you will know there is a issue with the TS3 server you are having hosted.
Very Nice application well done
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Varitina
|
Posted - 2011.04.04 22:14:00 -
[48]
Okay Mediek, I'll try this. Give me a day or two, really busy this week, and I'm not the best at local sql. I've done it a few times, but ill need to refresh.
I'll post when i have tried. I like this idea though.
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.06 17:34:00 -
[49]
Originally by: Varitina Okay Mediek, I'll try this. Give me a day or two, really busy this week, and I'm not the best at local sql. I've done it a few times, but ill need to refresh.
I'll post when i have tried. I like this idea though.
If you have a problem look for me in game ill help you set it up :-) if i can co's ime rusty as well now lol but i can assure you this really does work and it works well http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Jetro Grissom
Amarr Massive Dynamic Defense Massive Dynamic Alliance
|
Posted - 2011.04.10 13:03:00 -
[50]
Heya Nice scripting but i have problems with using it.
Maybe i'm stupid, solution alway simple as we know. I'm enterring whole data to config file as putted in readme.
Then i'm connecting to TS server as -MDD- Jetro Grissom (as showed in readme) and going to registration page.
Enterring limited api data and character name without corp ticker and press reigter. I'm getting this message in reply:
Quote: API Connection was established.
Checking... Character: Jetro Grissom Debug: User ID: 6XXXXX Debug: API Key: XXXXXXXXXXXXXX Character ID: XXXXXXXX
Debug: Character List: Debug: Jetro Grissom Debug: API verified. You are not allowed to register on this server.
So how to fix it? With best regards MacOSX player |
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.10 17:15:00 -
[51]
Edited by: Mediek Ordos on 10/04/2011 17:27:58 Edited by: Mediek Ordos on 10/04/2011 17:18:32
Originally by: Jetro Grissom Heya Nice scripting but i have problems with using it.
Maybe i'm stupid, solution alway simple as we know. I'm enterring whole data to config file as putted in readme.
Then i'm connecting to TS server as -MDD- Jetro Grissom (as showed in readme) and going to registration page.
Enterring limited api data and character name without corp ticker and press reigter. I'm getting this message in reply:
Quote: API Connection was established.
Checking... Character: Jetro Grissom Debug: User ID: 6XXXXX Debug: API Key: XXXXXXXXXXXXXX Character ID: XXXXXXXX
Debug: Character List: Debug: Jetro Grissom Debug: API verified. You are not allowed to register on this server.
So how to fix it?
Ok How to fix, make sure you have your Corp and alliance names added to the whitelist that should rectify the problem in your case as you are in an alliance just add your alliance name in both.
// API Connection Testing Information (REQUIRED) - TESTID and TESTname MUST be the characterID and characterName of the SAME character respectively public $TESTID = 00000000; <<<<<<<<<<<<<replace with your char id no public $TESTname = "Jetro Grissom"; // Your alliance/corp name public $ourname = "Massive Dynamic Alliance"; // Alliance Whitelist Information (REQUIRED) - Example: ("Alliance1","Alliance 2"); public $allyList = array("Massive Dynamic Alliance"); // Corporation Whitelist Information (REQUIRED) - Example: ("Corporation1","Corporation 2"); public $corpList = array(""); ok once config set up like this when you register do not use your Alliance tikker only your corp tikker on teamspeak server, no brackets example A-C-E Mediek Ordos
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Jetro Grissom
Amarr Massive Dynamic Defense Massive Dynamic Alliance
|
Posted - 2011.04.10 18:01:00 -
[52]
well now it looks better, but now i'm getting same error as few posts above and don't know how to fix it.
Removing your old registrations... 0 old registrations removed.
An error occured: invalid URI supplied [F10] I've restarted my TS server and it didn't helped. With best regards MacOSX player |
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.10 18:21:00 -
[53]
Edited by: Mediek Ordos on 10/04/2011 18:26:56
Originally by: Jetro Grissom well now it looks better, but now i'm getting same error as few posts above and don't know how to fix it.
Removing your old registrations... 0 old registrations removed.
An error occured: invalid URI supplied [F10] I've restarted my TS server and it didn't helped.
[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").
add your host ip where you are running the app from into your whitelist on your teamspeak server, if you are running your TS3 server on local machine add the actual ip not your local machine ip to whitelist as well, that done make sure if you are running on local machine to set the ports on your router and firewall. also on the config, did you add the correct serveradmin query name and password that was created and you saved when you first started your server.
class Config { // Administrators character public $admin = "Mediek Ordos"; // Teamspeak 3 Server Query Information (REQUIRED) public $tshost = "put ts3 host ip here"; public $tsname = "serveradmin"; public $tspass = "put serveradmin pass here"; public $tsport = "10011"; //ServerQuery Port public $tscport = "9987"; //TeamSpeak client port
if not convo me in game
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Agent Unknown
Caldari
|
Posted - 2011.04.10 20:26:00 -
[54]
Very nice work MJ Maverick. I stopped playing a while ago because I've been busy with school and other life things. Good to see someone taking over the project. :) I forgot to mention that you are in fact reading something that is called a signature. |
Jetro Grissom
Amarr Massive Dynamic Defense Massive Dynamic Alliance
|
Posted - 2011.04.11 11:04:00 -
[55]
hmm i did everything like you said, but still getting this error
Quote: Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta
API Connection was established.
Checking... Character: Jetro Grissom Debug: User ID: XXXXX Debug: API Key: XXXXX Character ID: XXXXX Debug: Character List: Debug: Jetro Grissom Debug: API verified. You are on our alliance whitelist Debug: Getting your corp ticker... -MDD- Debug: Getting your alliance ticker... M D Attempting to grant access to: -MDD- Jetro Grissom...
Removing your old registrations... 0 old registrations removed.
An error occured: invalid URI supplied [F10]
With best regards MacOSX player |
Jetro Grissom
Amarr Massive Dynamic Defense Massive Dynamic Alliance
|
Posted - 2011.04.11 11:24:00 -
[56]
wow now it works the error was in tsname
now its perfect ;-) With best regards MacOSX player |
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.11 16:50:00 -
[57]
Originally by: Jetro Grissom wow now it works the error was in tsname
now its perfect ;-)
that is why i posted an example for you to look at it, glad you got it working ok. http://www.a-c-e.eu/images/A-C-E-signature.jpg |
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.11 17:27:00 -
[58]
Thanks for assisting Mediek :)
------------------ CCP are not perfect. :)
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.11 18:07:00 -
[59]
Update: v1.2
Security bot now optional to make sure people have the correct name. If you changed register.php to have "TICKER | NAME" then don't worry. The bot will know about you putting the | in and shouldn't go on a kicking spree if you did it properly. General code tweaks made. Readme updated.
------------------ CCP are not perfect. :)
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.12 11:43:00 -
[60]
Originally by: MJ Maverick Update: v1.2
Security bot now optional to make sure people have the correct name. If you changed register.php to have "TICKER | NAME" then don't worry. The bot will know about you putting the | in and shouldn't go on a kicking spree if you did it properly. General code tweaks made. Readme updated.
If you changed register.php to have "TICKER | NAME" <<< would this be here line 192// SET NICKNAME $nickname = $corpTicker." ".$character; // TRY TO CONNECT - GATHER DETAILS - GRANT PERMISSIONS - STORE DETAILS
and like this ? $nickname = $corpTicker."| A-C-E | ".$character; ? co's i am thick when it comes to php :-) ps only to glad to help peeps http://www.a-c-e.eu/images/A-C-E-signature.jpg |
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.12 18:57:00 -
[61]
Originally by: Mediek Ordos
If you changed register.php to have "TICKER | NAME" <<< would this be here line 192// SET NICKNAME $nickname = $corpTicker." ".$character; // TRY TO CONNECT - GATHER DETAILS - GRANT PERMISSIONS - STORE DETAILS
and like this ? $nickname = $corpTicker."| A-C-E | ".$character; ? co's i am thick when it comes to php :-) ps only to glad to help peeps
Hehe, no worries.
If you want "ACE | Mediek Ordos" then edit $nickname to:
[Line 193]
$nickname = $corpTicker." | ".$character; [Line 247]
if ($alliancemate == true) { $nickname = $corpTicker." | ".$character; } else { $nickname = $allianceTicker." | ".$corpTicker." | ".$character; }
------------------ CCP are not perfect. :)
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.12 21:20:00 -
[62]
Originally by: MJ Maverick
Originally by: Mediek Ordos
If you changed register.php to have "TICKER | NAME" <<< would this be here line 192// SET NICKNAME $nickname = $corpTicker." ".$character; // TRY TO CONNECT - GATHER DETAILS - GRANT PERMISSIONS - STORE DETAILS
and like this ? $nickname = $corpTicker."| A-C-E | ".$character; ? co's i am thick when it comes to php :-) ps only to glad to help peeps
Hehe, no worries.
If you want "ACE | Mediek Ordos" then edit $nickname to:
[Line 193]
$nickname = $corpTicker." | ".$character; [Line 247]
if ($alliancemate == true) { $nickname = $corpTicker." | ".$character; } else { $nickname = $allianceTicker." | ".$corpTicker." | ".$character; }
ok nearly :-) If you want "ACE | Mediek Ordos" then edit $nickname to: I want to do this "| ACE | Mediek Ordos" then edit $nickname to: or " RAGE | ACE | Mediek Ordos" then edit $nickname to: http://www.a-c-e.eu/images/A-C-E-signature.jpg |
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.12 21:34:00 -
[63]
Originally by: Mediek Ordos
ok nearly :-) If you want "ACE | Mediek Ordos" then edit $nickname to: I want to do this "| ACE | Mediek Ordos" then edit $nickname to: or " RAGE | ACE | Mediek Ordos" then edit $nickname to:
[Line 193]
$nickname = "| ".$corpTicker." | ".$character; [Line 247]
if ($alliancemate == true) { $nickname = "| ".$corpTicker." | ".$character; } else { $nickname = $allianceTicker." | ".$corpTicker." | ".$character; }
Will produce: | ACE | Mediek Ordos and RAGE | ACE | Mediek Ordos
------------------ CCP are not perfect. :)
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.12 22:32:00 -
[64]
Originally by: MJ Maverick
Originally by: Mediek Ordos
ok nearly :-) If you want "ACE | Mediek Ordos" then edit $nickname to: I want to do this "| ACE | Mediek Ordos" then edit $nickname to: or " RAGE | ACE | Mediek Ordos" then edit $nickname to:
[Line 193]
$nickname = "| ".$corpTicker." | ".$character; [Line 247]
if ($alliancemate == true) { $nickname = "| ".$corpTicker." | ".$character; } else { $nickname = $allianceTicker." | ".$corpTicker." | ".$character; }
Will produce: | ACE | Mediek Ordos and RAGE | ACE | Mediek Ordos
Already experimenting :-), ill try not to break it to much cheers MJ http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Dutch Psycho00
|
Posted - 2011.04.14 20:43:00 -
[65]
i installed it on my server but when i enter my info i keep getting the following error :
API does not match the character you entered's account, make sure you have pasted your API details without any spaces either side and entered your characters name properly
here is the list of the debug mode for security reasons fragile info has been cleared
Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta
API Connection was established.
Checking... Character: ----- Debug: User ID: ---------- Debug: API Key: -----------------------
Character ID: 0
Debug: Character List: Debug: Dutch Psycho00 Debug: ------------ Debug: --------------- Error: API does not match the character you entered's account, make sure you have pasted your API details without any spaces either side and entered your characters name properly. (Denied.)
anybody has any idea what this could be?
please let me know.
|
Moogless
|
Posted - 2011.04.14 21:08:00 -
[66]
Edited by: Moogless on 14/04/2011 21:11:26
Originally by: Dutch Psycho00 i installed it on my server but when i enter my info i keep getting the following error :
API does not match the character you entered's account, make sure you have pasted your API details without any spaces either side and entered your characters name properly
here is the list of the debug mode for security reasons fragile info has been cleared
Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta
API Connection was established.
Checking... Character: ----- Debug: User ID: ---------- Debug: API Key: -----------------------
Character ID: 0
Debug: Character List: Debug: Dutch Psycho00 Debug: ------------ Debug: --------------- Error: API does not match the character you entered's account, make sure you have pasted your API details without any spaces either side and entered your characters name properly. (Denied.)
anybody has any idea what this could be?
please let me know.
That is normally an error from you user typing in script Name: TICKER NAME, and their name on server being TICKER NAME.
However the name during registration needs to just be Name: NAME.
Basicly its not seing the user your trying to register being on the server.
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.15 00:33:00 -
[67]
Indeed, if your character ID is 0 then it's because the character you entered doesn't exist.
Example: Character "Dutch Psycho00" DOES exist. Character "CP Dutch Psycho00" DOES NOT exist.
Please see the readme for how to register.
------------------ CCP are not perfect. :)
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.15 03:39:00 -
[68]
Edited by: Mediek Ordos on 15/04/2011 03:41:16 Edited by: Mediek Ordos on 15/04/2011 03:40:10
Originally by: Dutch Psycho00 i installed it on my server but when i enter my info i keep getting the following error :
API does not match the character you entered's account, make sure you have pasted your API details without any spaces either side and entered your characters name properly
here is the list of the debug mode for security reasons fragile info has been cleared
Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta
API Connection was established.
Checking... Character: ----- Debug: User ID: ---------- Debug: API Key: -----------------------
Character ID: 0
Debug: Character List: Debug: Dutch Psycho00 Debug: ------------ Debug: --------------- Error: API does not match the character you entered's account, make sure you have pasted your API details without any spaces either side and entered your characters name properly. (Denied.)
anybody has any idea what this could be?
please let me know.
on the web registration do not use your corp/alliance tikker. on the TS3 server make sure you DO USE corp/alliance tikker works just fine http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Ashkrall
Lucifer's Hammer
|
Posted - 2011.04.15 06:28:00 -
[69]
Edited by: Ashkrall on 15/04/2011 06:29:00 Okay, I'm not exactly sure what's wrong here...
I attempt to register and I get
Checking... Character: Ashkrall Debug: User ID: ****** Debug: API Key: ***************
Character ID: ******
Debug: Character List: Debug: Ashkrall Debug: ****** Debug: API verified. You are not allowed to register on this server.
I've got it set up for the corporation Lucifer's Hammer. I'm not sure if the apostrophe is throwing it off or what, but it won't verify me. Character is a member of the corp and has been for a long while, so it's certainly not a problem with the API.
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.15 14:06:00 -
[70]
Ok in your config you should have this:
public $corpList = array("Lucifer's Hammer");
NOTE the "" either side of Lucifer's Hammer.
If you DO have it like that and it's not working then try changing register.php line 164 to:
if (!in_array("$fetchCorporation",$c->corpList)) {
Please let me know if this works, if you have set the config properly then I need to know if my app is not using ' properly.
------------------ CCP are not perfect. :)
|
|
Dutch Psycho00
|
Posted - 2011.04.15 16:06:00 -
[71]
okay followed your guide and now im getting this
Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta
API Connection was established.
Checking... Character: Dutch Psycho00 Debug: User ID: ************* Debug: API Key: ****************
Character ID: 1860253443
Debug: Character List: Debug: Dutch Psycho00 Debug: ********** Debug: ********** Debug: API verified. You are on our corp whitelist Debug: Getting your corp ticker... **** Attempting to grant access to: **** Dutch Psycho00 Removing your old registrations... 0 old registrations removed.
An error occured: Connection timed out [F10]
|
Moogless
|
Posted - 2011.04.15 16:26:00 -
[72]
Edited by: Moogless on 15/04/2011 16:26:46
Originally by: Dutch Psycho00 Edited by: Dutch Psycho00 on 15/04/2011 16:23:24 followed your guide now i get this :S
Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta
API Connection was established.
Checking... Character: Dutch Psycho00 Debug: User ID: ********* Debug: API Key: *********
Character ID: 1860253443
Debug: Character List: Debug: Dutch Psycho00 Debug: ********* Debug: ************** Debug: API verified. You are not allowed to register on this server.
Query aint being allowed to communicate with server.
Add Teamspeak 3 server to the firewall on the hostee, and on the webserver you have add the ip of the ts3 server to whitelist.
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.15 18:24:00 -
[73]
Originally by: Moogless Edited by: Moogless on 15/04/2011 16:26:46
Originally by: Dutch Psycho00 Edited by: Dutch Psycho00 on 15/04/2011 16:23:24 followed your guide now i get this :S
Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta
API Connection was established.
Checking... Character: Dutch Psycho00 Debug: User ID: ********* Debug: API Key: *********
Character ID: 1860253443
Debug: Character List: Debug: Dutch Psycho00 Debug: ********* Debug: ************** Debug: API verified. You are not allowed to register on this server.
Query aint being allowed to communicate with server.
Add Teamspeak 3 server to the firewall on the hostee, and on the webserver you have add the ip of the ts3 server to whitelist.
do you have the correct server query admin name and password for serverquery admin correct ??
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Dutch Psycho00
|
Posted - 2011.04.15 19:53:00 -
[74]
okay problem found was too high security levels on my server lowered it a bit for the script and now it works. thanks for all the help guys :)
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.16 05:17:00 -
[75]
Hi MJ, Have noticed the version.php on 1.2 is still 0.17 http://www.a-c-e.eu/images/A-C-E-signature.jpg |
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.16 17:44:00 -
[76]
Hmm, try again. I just checked the files I uploaded and it's saying 1.2 :/ Perhaps it didn't upload properly the first time.
------------------ CCP are not perfect. :)
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.17 06:36:00 -
[77]
Originally by: MJ Maverick Hmm, try again. I just checked the files I uploaded and it's saying 1.2 :/ Perhaps it didn't upload properly the first time.
Hi MJ, downloaded from link again and recievied a 1kb zip of nothing this time lol,checked the other zips and they are 0.17 versions.php.
cheers Mediek http://www.a-c-e.eu/images/A-C-E-signature.jpg |
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.17 16:35:00 -
[78]
Hmmmm, apparently it helps if you actually put the files in the zip before uploading.
...Doing too many things at once again... lol
------------------ CCP are not perfect. :)
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.17 18:07:00 -
[79]
Cheers MJ, have new zip and installed I would like to see this progess to having a staged registration proccess as we discussed on TS a few weeks back, that being said did the alterations to register.php to include correct tikker tags in correct place for alliance & corp A-C-E TS3REG by Maverick with viewer by Psychokiller
So you can see it working as an example other than MJ's fine work. http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Kari Trace
Caldari Nox Imperium
|
Posted - 2011.04.22 02:11:00 -
[80]
I've run a bit of a problem. Got everything installed , database is in, get my character data together and submit it...and then I get the following error:
Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta
API Connection was established.
Checking... Character: -XMP- Kari Trace Debug: User ID: *****REMOVED***** Debug: API Key: *****REMOVED*****
Character ID: 0
An error occured: API server couldn't retrieve your account or the API wasn't correct, check for spaces after your entered API. (Error: Invalid username and/or password passed to UserData.LoginWebUser().) [126]
Using the same API data to call the API server directly gets me all the data I could ask for. But when coming from EVEOTS my account shows authentication failed (obviously).
Ideas?
|
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.22 10:17:00 -
[81]
Originally by: Kari Trace I've run a bit of a problem. Got everything installed , database is in, get my character data together and submit it...and then I get the following error:
Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta
API Connection was established.
Checking... Character: -XMP- Kari Trace Debug: User ID: *****REMOVED***** Debug: API Key: *****REMOVED*****
Character ID: 0
An error occured: API server couldn't retrieve your account or the API wasn't correct, check for spaces after your entered API. (Error: Invalid username and/or password passed to UserData.LoginWebUser().) [126]
Using the same API data to call the API server directly gets me all the data I could ask for. But when coming from EVEOTS my account shows authentication failed (obviously).
Ideas?
ok firstly is your config set up correctly for TS3 server admin ? example >> class Config { // Administrators character public $admin = "Mediek Ordos"; // Teamspeak 3 Server Query Information (REQUIRED) public $tshost = "put ts3 host ip here"; public $tsname = "serveradmin"; public $tspass = "put serveradmin pass here"; public $tsport = "10011"; //ServerQuery Port public $tscport = "9987"; //TeamSpeak client port
lets try this first, then in the config have you got the whitelist set up correctly ? then when registering on the web interface use just use your char name no corp/ally tikker. on temaspeak use your corp tikker and char name for me it is like this | A-C-E | Mediek Ordos.
hope this helps http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Kari Trace
Caldari Nox Imperium
|
Posted - 2011.04.22 11:56:00 -
[82]
Originally by: Mediek Ordos
Originally by: Kari Trace I've run a bit of a problem. Got everything installed , database is in, get my character data together and submit it...and then I get the following error:
Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta
API Connection was established.
Checking... Character: -XMP- Kari Trace Debug: User ID: *****REMOVED***** Debug: API Key: *****REMOVED*****
Character ID: 0
An error occured: API server couldn't retrieve your account or the API wasn't correct, check for spaces after your entered API. (Error: Invalid username and/or password passed to UserData.LoginWebUser().) [126]
Using the same API data to call the API server directly gets me all the data I could ask for. But when coming from EVEOTS my account shows authentication failed (obviously).
Ideas?
ok firstly is your config set up correctly for TS3 server admin ? example >> class Config { // Administrators character public $admin = "Mediek Ordos"; // Teamspeak 3 Server Query Information (REQUIRED) public $tshost = "put ts3 host ip here"; public $tsname = "serveradmin"; public $tspass = "put serveradmin pass here"; public $tsport = "10011"; //ServerQuery Port public $tscport = "9987"; //TeamSpeak client port
Yep, got all that correctly, re-double checked it.
Originally by: Mediek Ordos
lets try this first, then in the config have you got the whitelist set up correctly ?
By correctly you mean the IP provided from the TS3 server, yep got it. are these addresses comma separated (for future reference).
Originally by: Mediek Ordos
then when registering on the web interface use just use your char name no corp/ally tikker. on temaspeak use your corp tikker and char name for me it is like this | A-C-E | Mediek Ordos.
hope this helps
Ok, we've one step closer. Now on the debug print out it does show the correct characterID rather than 0...
Though, still no luck :S. Still getting Error 126. Error on the api log: /account/Characters.xml.aspx Authentication Failure Code 521
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.22 19:09:00 -
[83]
Kari, make sure you are registering correctly. Take a look at the readme on how to register.
Your name in Teamspeak should be exactly: "-XMP- Kari Trace" Your Character Name on the registration page should be exactly: "Kari Trace"
API Error: 512 = Invalid charID passed to CharData.GetCharacter().
This is likely due to not entering your name into the "Character Name" box correctly.
Hope this helps bud.
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.22 21:08:00 -
[84]
Originally by: MJ Maverick Kari, make sure you are registering correctly. Take a look at the readme on how to register.
Your name in Teamspeak should be exactly: "-XMP- Kari Trace" Your Character Name on the registration page should be exactly: "Kari Trace"
API Error: 512 = Invalid charID passed to CharData.GetCharacter().
This is likely due to not entering your name into the "Character Name" box correctly.
Hope this helps bud.
Hm thought that was what I said but in the long routed way, :-) http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Kari Trace
Caldari Nox Imperium
|
Posted - 2011.04.23 01:00:00 -
[85]
Originally by: Mediek Ordos
Originally by: MJ Maverick Kari, make sure you are registering correctly. Take a look at the readme on how to register.
Your name in Teamspeak should be exactly: "-XMP- Kari Trace" Your Character Name on the registration page should be exactly: "Kari Trace"
API Error: 512 = Invalid charID passed to CharData.GetCharacter().
This is likely due to not entering your name into the "Character Name" box correctly.
Hope this helps bud.
Hm thought that was what I said but in the long routed way, :-)
Checked an double checked: TS: Identity: -XMP- Kari Trace Registration page: Kari Trace
Debug: User ID: *****REMOVED***** Debug: API Key: *****REMOVED*****
Character ID: *****REMOVED*****
An error occured: API server couldn't retrieve your account or the API wasn't correct, check for spaces after your entered API. (Error: Invalid username and/or password passed to UserData.LoginWebUser().) [126]
Sorry to be a pain on this. I know it `should` work without much issue...
Mediek Ordos: you have EVEmail. KT
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.23 03:12:00 -
[86]
Edited by: MJ Maverick on 23/04/2011 03:14:21
Does this link work after you fill in your details?
http://api.eveonline.com/account/Characters.xml.aspx?&userID=YOUR_USERID&apiKey=YOUR_APIKEY
If it loads, view source and you should have something like:
<?xml version='1.0' encoding='UTF-8'?> <eveapi version="2"> <currentTime>2011-04-23 03:12:21</currentTime> <result> <rowset name="characters" key="characterID" columns="name,characterID,corporationName,corporationID"> <row name="Character 1" characterID="NUMBERS" corporationName="STUFF" corporationID="NUMBERS" /> <row name="Character 2" characterID="NUMBERS" corporationName="STUFF" corporationID="NUMBERS" /> <row name="Character 3" characterID="NUMBERS" corporationName="STUFF" corporationID="NUMBERS" /> </rowset> </result> <cachedUntil>2011-04-23 04:08:00</cachedUntil> </eveapi>
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.23 07:57:00 -
[87]
Originally by: Kari Trace
Originally by: Mediek Ordos
Originally by: MJ Maverick Kari, make sure you are registering correctly. Take a look at the readme on how to register.
Your name in Teamspeak should be exactly: "-XMP- Kari Trace" Your Character Name on the registration page should be exactly: "Kari Trace"
API Error: 512 = Invalid charID passed to CharData.GetCharacter().
This is likely due to not entering your name into the "Character Name" box correctly.
Hope this helps bud.
Hm thought that was what I said but in the long routed way, :-)
Checked an double checked: TS: Identity: -XMP- Kari Trace Registration page: Kari Trace
Debug: User ID: *****REMOVED***** Debug: API Key: *****REMOVED*****
Character ID: *****REMOVED*****
An error occured: API server couldn't retrieve your account or the API wasn't correct, check for spaces after your entered API. (Error: Invalid username and/or password passed to UserData.LoginWebUser().) [126]
Sorry to be a pain on this. I know it `should` work without much issue...
Mediek Ordos: you have EVEmail. KT
Read and replied to Eve Mail, Convo me in game when you are online so i can set up access for you on our TS and we can run a few experiments on the registration from there if you are up for it, looking so far it just seems you are having a API issue, but we will try to iron out the issue for you on comms, look forward to speaking to you. http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Kari Trace
Caldari Nox Imperium
|
Posted - 2011.04.23 12:41:00 -
[88]
@MJ Maverick: Yep, worked like a charm the way it should. Character name, IDs, corps, corpID all returned nicely...
@Mediek Ordos: Will do, thank you for the help.
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.23 21:32:00 -
[89]
That's certainly some anomaly you have their KAri. I've done a bit of research and it seems to be something some users get and its definitely the API server not EVEOTS.
Have you tried creating a new Limited API Key? Perhaps that might snap the server out of it.
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.23 22:31:00 -
[90]
Originally by: MJ Maverick That's certainly some anomaly you have their KAri. I've done a bit of research and it seems to be something some users get and its definitely the API server not EVEOTS.
Have you tried creating a new Limited API Key? Perhaps that might snap the server out of it.
Hi MJ, I have been helping set this up today and have nearly got there, what i have done is set this up on my server with the correct blue group set to a created group on the TS3 server, on A-C-E's current set up Kari Trace is now able to register with the correct corp tikker and the blue group in config set to one I have created. Soooo, I have now set it up on our server pointing to Kari's TS3 server >> api working fine but Kari now has to set the query ip_whirelist correctly in TS3 server config, allow that IP to have remote access to his MySql server and open up the ports on his router for the server query admin, once he has done this I am sure it will work ok. Once we have it working I will the transfer it to Kari's server and see if it works ok on his server, will update progress as we go along, the issue is not script side it is server side :-) http://www.a-c-e.eu/images/A-C-E-signature.jpg |
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.24 14:20:00 -
[91]
Great, thanks again Mediak. Have you checked if Kari had the groups set right on his server?
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
Sue Hareka
|
Posted - 2011.04.24 16:59:00 -
[92]
i know this must sound like a noob question how do i make it so the program can read the config.php and not the public
|
Father O'Malley
|
Posted - 2011.04.24 18:24:00 -
[93]
i am not sure but when i set it up it says Attempting to grant access to: and dosent do a thing after that i have tryd giveing it full server query 100 that dident work any iders
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.24 22:30:00 -
[94]
@ Sue Hareka: I'm not sure what you mean. The program of course reads config.php otherwise the file would be pointless and the program wouldn't work.
@ Father O'Malley: In config.php set $verbose to "true" to turn on debug mode. Then please paste what the page produces.
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
Father O'Malley
|
Posted - 2011.04.25 13:08:00 -
[95]
Edited by: Father O''Malley on 25/04/2011 13:08:45 Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta
API Connection was established.
Checking... Character: sue cyno Debug: User ID: 2695652 Debug: API Key: Blanked
Character ID: 1791492930
Debug: Character List: Debug: Father O'Malley Debug: Sam O'riley Debug: sue cyno Debug: API verified. You are on our corp whitelist Debug: Getting your corp ticker... LSDD Attempting to grant access to: LSDD sue cyno
dosent do any thing after
|
Father O'Malley
|
Posted - 2011.04.25 13:43:00 -
[96]
i have dubbel check the sql tabel is added i am going to try another char
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.25 17:43:00 -
[97]
Edited by: Mediek Ordos on 25/04/2011 17:44:56
Originally by: MJ Maverick Great, thanks again Mediak. Have you checked if Kari had the groups set right on his server?
ok :-) here is what i did, initialy caused some head scratching as on first set and trial it refused to register Kari due to the char already having permissions on TS3 server,so I went to the config of eveots and sure enough the config was set to server group guest "8" so i changed it to one I created on TS3 server called registerd and adjusted the eveots config for blue corps group to match the new TS3 group number. IE.// Teamspeak 3 group for alliance/corp members public $group = 9; // Teamspeak 3 group for people on the whitelist but not in your alliance/corp public $bluegroup = 10; <<<<<<<<<<<<<<<< CHANGED THIS FROM GUEST GROUP 8 // Banner Image public $banner = "images/banner.jpg";
Script then ran through fine on my server just waiting for Kari to alter his server now to run test n his setup, :-) http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.25 17:46:00 -
[98]
Originally by: Father O'Malley i have dubbel check the sql tabel is added i am going to try another char
Father do you require some Divine intervention as well, lol, :-)
A-C-E http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Father O'Malley
|
Posted - 2011.04.25 17:58:00 -
[99]
yes lol
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises R.A.G.E
|
Posted - 2011.04.25 18:04:00 -
[100]
Originally by: Father O'Malley yes lol
oK ill find you in game m8ty http://www.a-c-e.eu/images/A-C-E-signature.jpg |
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.26 03:46:00 -
[101]
Update v1.3: MkII (first post lost due to crappy forum asking me to lo in again. FFS) General code clean up. Handles even more errors properly. Added staged registration as requested (Yay). Added compatibility for option ticker separators as requested. _______________________________________________________________
Something in there for you Mediek, thanks for helping the peeps. Very much appreciated
@ Father O'Malley Looks like a total failure of the functions.php kicking in. Make sure it's uploaded and the file structure is as it should be. If all else fails, convo me in game.
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
Father O'Malley
|
Posted - 2011.04.28 00:14:00 -
[102]
great app great support lernt alot
|
Father O'Malley
|
Posted - 2011.04.28 15:32:00 -
[103]
Edited by: Father O''Malley on 28/04/2011 15:32:26 to get a corp line if just in a corp add to line 242
// SET NICKNAME $nickname = $corpTicker." ".$c->spacer." ".$character;
centos 5 tips if you are having trouble centos testsing repo needed /etc/yum.repos.d/CentOS-Testing.repo
[c5-testing] name=CentOS-5 Testing baseurl=http://dev.centos.org/centos/$releasever/testing/$basearch/ enabled=1 gpgcheck=1 gpgkey=http://dev.centos.org/centos/RPM-GPG-KEY-CentOS-testing
centos lamp needed yum install httpd php php-mysql mysql-server php-gd postgres ImageMagick ImageMagick-devel
|
Father O'Malley
|
Posted - 2011.04.28 16:26:00 -
[104]
Centos 5 Step by step install of lamp û Ts3 û eveots mod This is using a remote vps server Ok download eveots mod and extract it
Ok first you are going to have to put in the testing repo I like nano but if you have a better text editor just use it Nano /etc/yum.repos.d/CentOS-Testing.repo
Copy and paste this in
[c5-testing] name=CentOS-5 Testing baseurl=http://dev.centos.org/centos/$releasever/testing/$basearch/ enabled=1 gpgcheck=1 gpgkey=http://dev.centos.org/centos/RPM-GPG-KEY-CentOS-testing Ok
Next command installing lamp
yum install httpd php php-mysql mysql-server php-gd postgres ImageMagick ImageMagick-devel service httpd restart service mysql restart mysql_secure_insallation follow the steps on their if you are using a offsite ts server allow remote database access mysql ûp that will open mysql command line up create database tsreg; ok database created now to populate it copy in to the window the table ok the mysql data base is set up
getting and downloading ts3 wget http://teamspeak.gameserver.gamed.de/ts3/releases/beta-30/teamspeak3-server_linux-x86-3.0.0-beta30.tar.gz or get the latest version tar xzf teamspeak3-server_linux_3.0.0-beta30.tar.gz mv teamspeak3-server_linux_3.0.0-beta30.tar.gz /opt/ts3 ok you have it unzipped cd /opt/ts3 ./ts3server_minimal_startscript.sh Take note of the server query username and password aswell as the ts token you now have a working ts server login your host:9987 permissions>use token and use the token that you got from start-up goto server groups anc copy normal in to its own server group and call it registered and note down the numper at the end
yum install vsftpd /etc/init.d/vsftpd restart remove root nano /etc/vsftpd/ftpusers nano/etc/vsftpd/user_list ok now you can log on to ftp use a simpal program like filezila or another ftp application log on with root and your password head to dir /var/www/http Ok fill out the the config file inside upload/eveots Ok you know you created a group called registered take the group id the number at the end and put that in to the config file With all the detail the readme will help in the root directory of the mod Upload the entire eveots folder /var/www/http though the ftp application Test and your done
i hope this has helped i know it is a bit jumbled up
|
Kari Trace
Caldari Nox Imperium
|
Posted - 2011.04.29 13:57:00 -
[105]
Just checking in guys, Ive not had a chance to circle around to finish debugging my EVEOTS install yet.
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.29 17:56:00 -
[106]
No idea what Centos 5 is but thanks for pointing out I left out the option for corps... I've put it in now and uploaded a new copy.
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
robo tim
Caldari
|
Posted - 2011.05.16 22:33:00 -
[107]
loving the mod. but i get stuck on registration.
its says "TESTAn error occured: Connection refused [F11]"
I checked ur readme file and u dont sat what F11 is and how to correct it.
i checked the config.php file everything is correct, web host IP is in the whitelist for ts. im just now stuck for ideas.
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.05.17 02:21:00 -
[108]
Have you changed the code at all? There isn't an F11 by default and the "TEST" bit in the message makes me feel you may have changed something.
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
robo tim
Caldari
|
Posted - 2011.05.17 11:37:00 -
[109]
i had someone look at the code to see if we could change the code, so we could say what group each corp would go into. As long as they were in the alliance.
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.05.17 13:31:00 -
[110]
I have no idea what they have changed so I couldn't support you on it too much. But the nearest error is an F11.
Basically your Teamspeak is refusing your connection. Make sure you have restarted your Teamspeak after adding your web server to the whitelist.
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
|
robo tim
Caldari
|
Posted - 2011.05.17 13:44:00 -
[111]
i think the only thing that was changed was part of the config file. im waiting on the guy to get back to me. i have restart the TS server after the IP was added to the whitelist.
the config file looks like this
class Config { // Administrators character public $admin = "robo tim"; // Teamspeak 3 Server Query Information (REQUIRED) public $tshost = "193.104.35.41"; public $tsname = "TSAuth"; public $tspass = "kFCReThi"; public $tsport = "11001"; //ServerQuery Port public $tscport = "9987"; //TeamSpeak client port // Database Information (REQUIRED) public $db_host = "localhost"; public $db_user = "********"; public $db_pass = "********"; public $db_name = "********"; // API Connection Testing Information (REQUIRED) - TESTID and TESTname MUST be the characterID and characterName of the SAME character respectively public $TESTID = 935338328; public $TESTname = "MJ Maverick"; // Your alliance name public $ourAlliance = "KRYSIS."; // Your alliance corps, and the Teamspeak 3 group for that corp. - Example: ("Corp1" => 123, "Corp2" => 124); will set Corp1 members to group 123, and Corp2 members to group 124. public $ourCorps = array("GLOBAL DISSENSION" => 19); // Alliance Allys. Similar to Alliance Corps, include the TS3 group for each alliance. - Example: ("Alliance1" => 125, "Alliance 2" => 126); public $allyList = array(); // Corporation Allys. Similar to Alliance Corps and Alliance Allies. - Example: ("Corporation1" => 127, "Corporation 2" => 128); public $corpList = array(); // Debug Mode? (true/false) public $verbose = true; // Banner Image public $banner = "images/banner.jpg"; // Optional ticker spacers. - Example: For "IRNP | MJ Maverick" use "|". public $spacer = " - "; }
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.05.17 17:14:00 -
[112]
Did you have it working before you changed the code?
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
robo tim
Caldari
|
Posted - 2011.05.17 17:25:00 -
[113]
I just replace my config with your config and added the details, and i get this
"An error occured: Connection refused [F10]"
I know the details are correct and the TS server has been restarted, and i know the IP is in the whitelist.
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.05.27 18:04:00 -
[114]
:) Need to be very careful copy/pasting sensitive details.
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
Zyper
Crimson Nation En Garde
|
Posted - 2011.06.17 09:28:00 -
[115]
Has anyone else experienced a the error that the script timed out?
I have tried several servers with this script as well as webhosts, and I have had NO luck at all, and sat with MJ on ts3. -- |
Nuramori
Amarr Drama Llamas
|
Posted - 2011.06.17 20:56:00 -
[116]
I keep getting the following error, even when I cut and paste the exact way it's supposed to look in the nickname on the client sign in. I could use some help :(
Error: Could not find you on the server, your nickname should be exactly " | ELKA | Nuramori" (Error: invalid clientID [F20])
In fact everyone in the corp is getting this. Running debug, everything looks fine up to this point. Running the bot.php or the cron php returns no errors, but when I manually look in the database, there are no entries.
|
PsyKzz
Minmatar Bat Country Goonswarm Federation
|
Posted - 2011.06.18 11:18:00 -
[117]
Can this handle users logging in from multiply computers? As my own script worked except you couldnt have users log in from multiply computers,
Also if your looking for someone to help you out let me know. I doubt you need it, but i dont mind getting involved. PsyK
|
Nuramori
Amarr Drama Llamas
|
Posted - 2011.06.18 12:54:00 -
[118]
Apparently you can. If you run the ./duplicates.php file via a browser it gives you the instructions how to do what you are asking.
|
muhuh Aihaken
|
Posted - 2011.06.21 18:13:00 -
[119]
A feature request: An option to remove inactive accounts access.
|
Kiyra Chi'Amo
|
Posted - 2011.06.21 19:32:00 -
[120]
MJ, any thoughts on this one?
I used your api reg and found that on my character name the array does not like the return from the api. It comes back to tell me that my name is Kiyra Chi\'Amo and not Kiyra Chi'Amo. When it compares that to the return from api it sees the difference and does not allow access. Any ideas... also when processing the registration I have had both test users get stuck at step 3 and cannot continue from there.
THx
|
|
Pedrosito85
|
Posted - 2011.06.24 05:23:00 -
[121]
Directing this question to Mr. MJ Maverick,
I am currently working to set up and install the EVEOTS app on my web host. I have a paid service web host and I run my own teamspeak server off a virtual windows server I lease as well (and have full access to the server OS).
I was able to set up, configure, and run the web interface. However, during TS registration I am hitting the F10 - Connection refused error. Using the verbose=true method, I see that this is the only error I am receiving during the registration attempt. I have tried a number of things but I am uncertain on how best to proceed. I have tried all of the following:
1. Resetting the ServerQuery login to a new user/pass combo 2. Ensured the web server IP address was included in the whitelist.txt file. 3. Shutdown TS3 and restarted after added the entry in the whitelist file. 4. Made sure serverquery port was passing properly over the firewall to the correct TS server IP 5. Logged in locally with the serveradmin locally on the TS server, manually ran the ServerQuery and kicked my standard user account out of the server. 6. Used the same ServerQuery login info in the config.php file and still got connection refused error. 7. Got frustrated (), planted C4 on the server (), blew it up (), felt bad, rebuilt it from scratch, used default serverquery logins, same issue. 8. Gave up and wrote this post.
Any help you can offer would be greatly appreciated. There may even be ISK involved with the person that can help me get this up and running.
Let me know if you have any ideas.
Thanks,
- Pedro |
Morgenholt Blue
RED.Legion
|
Posted - 2011.06.25 06:49:00 -
[122]
Edited by: Morgenholt Blue on 25/06/2011 06:50:00
Originally by: Kiyra Chi'Amo MJ, any thoughts on this one?
I used your api reg and found that on my character name the array does not like the return from the api. It comes back to tell me that my name is Kiyra Chi\'Amo and not Kiyra Chi'Amo. When it compares that to the return from api it sees the difference and does not allow access. Any ideas... also when processing the registration I have had both test users get stuck at step 3 and cannot continue from there.
THx
I haven't really had a chance to test this fix due to having no characters with ' in there name but I changed $inputName = trim($_POST["inputName"]); in index.php to: $inputName = trim(stripslashes($_POST["inputName"])); and it gets it past the first stage. Again completely untested all I know is that it gets it past the first error.
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.06.25 18:02:00 -
[123]
Hey Pedro, there are a few possibilities.
Have you made sure that your VPS host hasn't got the query port (default 10011) blocked by a firewall? Check with them and make sure it's forwarded correctly. If that's not the problem send me a mail with some TS information and I'll have a rummage around.
As a connection is being sucessfully made it doesn't look like it's your web server. The VPS is actively blocking the connection.
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
Pedrosito85
|
Posted - 2011.06.25 22:38:00 -
[124]
MJ,
Thanks for the reply.
I double checked the firewall settings and I am in fact passing port traffic to the local IP of the TS server:
Rule Name,Listen Link,Host,Listen IP,Application,Listen Port,Protocol,Forward IP,Forward Port,Enable,Enable Logging,Description TeamSpeak_Server_API,wan2,<<REMOVED>>,WAN IP,ANY,10011,ANY,10.10.10.206,10011,Yes,0,
Here is what I have in my config file: ---------------------------------------------------- class Config { // Administrators character public $admin = "Pedrosito85"; // Teamspeak 3 Server Query Information (REQUIRED) public $tshost = "used FQDN (domain name) and IP - same result"; public $tsname = "REMOVED"; public $tspass = "REMOVED"; public $tsport = "10011"; //ServerQuery Port public $tscport = "9987"; //TeamSpeak client port // Database Information (REQUIRED) public $db_host = "REMOVED"; public $db_user = "REMOVED"; public $db_pass = "REMOVED"; public $db_name = "REMOVED"; // API Connection Testing Information (REQUIRED) - TESTID and TESTname MUST be the characterID and characterName of the SAME character respectively public $TESTID = 935338328; public $TESTname = "MJ Maverick"; // Your alliance/corp name public $ourname = "Alliance"; // Alliance Whitelist Information (REQUIRED) - Example: ("Alliance1","Alliance 2"); public $allyList = array("Alliance"); // Corporation Whitelist Information (REQUIRED) - Example: ("Corporation1","Corporation 2"); public $corpList = array("Corporation"); // Debug Mode? (true/false) public $verbose = true; // Teamspeak 3 group for alliance/corp members public $group = 9; // Teamspeak 3 group for people on the whitelist but not in your alliance/corp public $bluegroup = 8; // Banner Image public $banner = "images/banner.jpg"; // Optional ticker spacers. - Example: For "IRNP | MJ Maverick" use "|". public $spacer = "|"; } ----------------------------------------------------
Here is the debug info from stage 1 (prior to clicking register) ---------------------------------------------------- Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta
API Connection was established.
Checking... Character: Pedrosito85 Debug: User ID: <<REMOVED>> Debug: API Key: <<REMOVED>>
Debug: Character ID: 90202605
Debug: Character List: Debug: Pedrosito85
Debug: API verified.
You are on our alliance whitelist
Debug: Getting your corp ticker... WOLS Debug: Getting your alliance ticker... RB Please connect to Teamspeak 3 using the following details: Address: <<REMOVED>>:9987 Nickname: "WOLS | Pedrosito85"
Once connected, click register. ----------------------------------------------------
Here is the error after I click register: ---------------------------------------------------- Attempting to grant access to: WOLS | Pedrosito85...
An error occured: Connection refused [F10] ----------------------------------------------------
I can never get past that point.
Thanks for any help in advance.
- Pedro
|
d3athmane
Caldari Federation Security
|
Posted - 2011.06.26 05:25:00 -
[125]
Edited by: d3athmane on 26/06/2011 05:25:41 Is there a way to NOT make use of the alliance whitelist Requirement? I have 2 corps that share one TS3, but are not in an alliance.
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.06.27 18:33:00 -
[126]
Yeah, just don't use the alliance list. Leave it empty. Just put the two corp names in the Corp List.
@Pedrosito85 I'm talking with the Teamspeak chaps about this one... Seems very odd.
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
Pedrosito85
|
Posted - 2011.06.27 19:22:00 -
[127]
Thanks MJ.
I shall await news of your discoveries.
|
Kiyra Chi'Amo
|
Posted - 2011.07.08 15:06:00 -
[128]
Originally by: Morgenholt Blue Edited by: Morgenholt Blue on 25/06/2011 06:50:00
Originally by: Kiyra Chi'Amo MJ, any thoughts on this one?
I used your api reg and found that on my character name the array does not like the return from the api. It comes back to tell me that my name is Kiyra Chi\'Amo and not Kiyra Chi'Amo. When it compares that to the return from api it sees the difference and does not allow access. Any ideas... also when processing the registration I have had both test users get stuck at step 3 and cannot continue from there.
THx
I haven't really had a chance to test this fix due to having no characters with ' in there name but I changed $inputName = trim($_POST["inputName"]); in index.php to: $inputName = trim(stripslashes($_POST["inputName"])); and it gets it past the first stage. Again completely untested all I know is that it gets it past the first error.
I actually got inspired to write my own API registration system thanks to MJ. I had the same issue with mine and figured out that it was a string in the php config file that was causing that to happen. After correcting the setting I was able to get the proper return. |
Kiyra Chi'Amo
|
Posted - 2011.07.08 15:18:00 -
[129]
@Pedro
What are you using as a database server? MySQL Server?
Sounds like the script cannot establish another open connection to the database to input data to the users table. Maybe open up more allowed connections to see if that corrects the issue. Just a thought.
GL |
trader4040404
|
Posted - 2011.07.11 21:18:00 -
[130]
Is there anyway to make the "alliance" or "corp" array list read from a database rather than having to alter the config file every time you want to allow/deny registrations? ie directors of a given corp/alliance can alter who gains access via a simple web interface?
|
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.07.15 16:48:00 -
[131]
Edited by: MJ Maverick on 15/07/2011 16:48:30 No, but I have taken your idea on-board... I like it.
v1.31 Teamspeak 3 only supports character names up to 30 characters. Any nicknames that come to more than that will no longer cause registration problems.
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
T0m Cruise
|
Posted - 2011.07.19 17:45:00 -
[132]
Hello MJ Maverick,
I don't see a whole lot of other replies for a while, so I hope I'm not missing something. I downloaded the zip you provided and went through the whole setup pretty well, but ran into the following after I log in to my TS server with the user-name I am given and try to use the register button on the web page:
Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /var/www/localhost/htdocs/eveots/functions.php on line 59 Could not connect: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [F61]
Before this error happened, I had to edit my php.ini file to allow more max_execution_time and the memory_limit well over 128M. It seems like the registration is taking up a lot of resources. Has anyone else encountered this problem? Maybe I'm missing something.
Best regards, T0m Cruise
|
T0m Cruise
|
Posted - 2011.07.19 23:43:00 -
[133]
Originally by: T0m Cruise
Before this error happened, I had to edit my php.ini file to allow more max_execution_time and the memory_limit well over 128M. It seems like the registration is taking up a lot of resources. Has anyone else encountered this problem? Maybe I'm missing something.
I modified php.ini again to see what the error was before:
Fatal error: Allowed memory size of 1342177280 bytes exhausted (tried to allocate 523800 bytes) in /var/www/localhost/htdocs/eveots/TeamSpeak3/Transport/TCP.php on line 148
Why is it trying to allocate 523800 bytes and then hits the limit 1280MB? That is quite a bit of data. Not sure what I messed up here.
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.07.23 18:14:00 -
[134]
Hi, sorry about the delay T0m.
I have no idea why so much memory is being *****d. What PHP and MySQL versions are you running? Have you tried running PHP in strict mode? Personally I'd contact your host... This seems like a pretty drastic server mess.
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
T0m Cruise
|
Posted - 2011.07.23 20:30:00 -
[135]
Originally by: MJ Maverick Hi, sorry about the delay T0m.
I have no idea why so much memory is being *****d. What PHP and MySQL versions are you running? Have you tried running PHP in strict mode? Personally I'd contact your host... This seems like a pretty drastic server mess.
Thanks for getting back to me MJ, no problem man. I'm sure you're busy doing other stuff. I figured out what the problem was just moments ago. I made my own queryserver login instead of using the admin that was created when I started up my TS3 server the first time. Seems like the error I was experiencing was caused by not having enough permissions. Maybe a memory leak or something looping in the background(not sure)? Anyways, thanks again for getting back to me. Hope this helps you with your project here. Awesome job buddy!
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.07.24 16:37:00 -
[136]
Thanks T0m, I'll make a note of that error and see if anything can be done to notify you of such problems.
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
Keil Sonter
|
Posted - 2011.08.11 01:28:00 -
[137]
Edited by: Keil Sonter on 11/08/2011 01:29:02 Hi,
Nice script and thank you for your work on this.
I have setup a server and am having some issues when trying to register - getting the dreaded F10 error with connection timeout.
The problem seems to be with the server query and I will be checking with my hosting company to ensure it is enabled and has a default setup. However I wondered if you could advise on any checks I can perform to diagnose the problem and ensure it is at the server end or at my website?
Can you confirm that users are added to the database after a successful connection to the server as at the moment no users are being logged to the dbase at registration.
Any assistance is much appreciated.
regards, Keil Sonter Website Hosting Services - EVE Corporation SubDomain Hosting Services - EVE Domain |
Jack Lagoon
|
Posted - 2011.08.15 09:01:00 -
[138]
Any word yet on the F10 error? Still getting that error as well when trying to register with this script.
|
king curt
Caldari The Maverick Navy Against ALL Authorities
|
Posted - 2011.08.17 17:08:00 -
[139]
I was having the F10 issue, but fixed it by using the "serveradmin"/"password" combination when you first set up your TS.
If you don't have it or don't remember it go to server query login and create a new one to a "name" and it will give you a new "password". ***Note*** it does not seem to like a space in the name, so if you have a two word name like "joe blow" use "joeblow" when generating a new password for the server query login.
Put that in your config.
$tsname="serveradmin" or "joeblow" $tspass="PW when you first set up TS" or "PW issued for server query login when creating one using a new name"
At least this is what worked for me.
Also do not forget the port number when making your connection to TS when it asks you to connect during the registration process. I found that by not using the port number it was giving an F25 error.
|
Dutch Psycho00
|
Posted - 2011.08.20 16:11:00 -
[140]
i aswell still have the issue with the time out (f10) error.
not matter what i try it keeps popping up. or when i try a localhost db it keeps giving me the error(f61) cant connect to mysql.
what am i doing wrong?
- dutch
|
|
Duc Lebowski
|
Posted - 2011.08.21 10:50:00 -
[141]
I am trying to work this script out and its working like a charm with 1 fault i cant seem to beat here is the verbose i hope somone can help fix this as its awsome and the coding looks fine.
----------------------------- Step 2
Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta
API Connection was established.
Checking... Character: Duc Lebowski
Debug: API Key: *****
Debug: Character ID: *****
Debug: Character List: Debug: Duc Lebowski
Debug: API verified.
You are on our corp whitelist Debug: Getting your corp ticker... XOHX Please connect to Teamspeak 3 using the following details: Address: *****:7715 Nickname: XOHX - Duc Lebowski
----------------- Then this
Attempting to grant access to: XOHX - Duc Lebowski...
An error occured: invalid URI supplied [F10]
Ive checked with the host the domain IP has been added to the white list and the details are fine exact to the TS server how on earth can i fix this
|
Jabberwockeee
|
Posted - 2011.08.21 11:07:00 -
[142]
Quote: I was having the F10 issue, but fixed it by using the "serveradmin"/"password" combination when you first set up your TS.
If you don't have it or don't remember it go to server query login and create a new one to a "name" and it will give you a new "password". ***Note*** it does not seem to like a space in the name, so if you have a two word name like "joe blow" use "joeblow" when generating a new password for the server query login.
Put that in your config.
Now thats fixed and now getting Attempting to grant access to: XOHX - Duc Lebowski...
An error occured: Connection timed out [F10]
|
Keil Sonter
|
Posted - 2011.08.21 15:11:00 -
[143]
Hi,
Made some progress and figuring out how this app works :)
Discovered the outgoing ports were blocked from my shared hosting. Anyone else getting [F10] - Connection Timeout - its probably the same reason - check with your host.
Once I setup the app on a VPS with ports enabled and had no problems other than a glitch which occurred due to having set the groupID's set incorrectly but once setup right the app worked a treat.
One 'issue' I now see is having multiple accounts and trying to add alts from these. I get - [F25] duplicate entry - which I guess is because the unique id for the connection via the client is the same value.
I'd like to add multiple accounts and have a different alt connect via the client so need a way to add these.
Good work you've done here and I'd like to see this app being a bit more sophisticated with web enabled admin to modify the corps/alliances to an additional table in the d'base rather than editing the config via FTP.
regards, Keil Sonter Website Hosting Services - EVE Corporation SubDomain Hosting Services - EVE Domain |
Dutch Psycho00
|
Posted - 2011.08.21 19:48:00 -
[144]
Originally by: Keil Sonter Hi,
Made some progress and figuring out how this app works :)
Discovered the outgoing ports were blocked from my shared hosting. Anyone else getting [F10] - Connection Timeout - its probably the same reason - check with your host.
Once I setup the app on a VPS with ports enabled and had no problems other than a glitch which occurred due to having set the groupID's set incorrectly but once setup right the app worked a treat.
this solved my f10 connection timed out error thnx for this reason for timeout was cause of fact some ports that were used by the script were indeed closed One 'issue' I now see is having multiple accounts and trying to add alts from these. I get - [F25] duplicate entry - which I guess is because the unique id for the connection via the client is the same value.
I'd like to add multiple accounts and have a different alt connect via the client so need a way to add these.
Good work you've done here and I'd like to see this app being a bit more sophisticated with web enabled admin to modify the corps/alliances to an additional table in the d'base rather than editing the config via FTP.
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.08.23 23:39:00 -
[145]
Hi chaps, best thing to do if you are having problems is read the previous pages. All these errors have been had before. Failing that mailing me in game is the quickest way to get a hold of me.
[F10] = The web server failed to connect to the TS. So things you need to check are, firewalls, blocked ports, if it's actively refused then you need to make sure you are using a SQAdmin that was created by a person with FULL SA on TS. Remember to check with your provider for blocked ports on both the web server and the TS. Also some TS providers like to disable ServerQuery because they are "special". The kind of special you put on a bus and send on it's merry way as far away from the rest of humanity as possible.
@Keil Sonter, users are only entered into the database once they have been successfully registered.
@Dutch Psycho00, I only advise using a local database, in these cases you need to double and triple check your database details. Try recreating a new one, remember spaces can be bad. Failing that make sure your host hasn't been "special" and disabled any modifications of the database that aren't done manually.
@Duc Lebowski, I'm looking into URI's but for now I believe it's invalid login credentials.
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.08.29 00:13:00 -
[146]
Update: v1.5 Admin panel added. All admin actions are logged. Security level allows you to have admins and just whitelist operators. Admin lists stream the admins current corp/alliance. Cron job updates whitelist member counts. Change password. Admins can edit admin accounts easily. Whitelist is now totally databased. Cron.php in /admin/ added to optionally update whitelist member counts.
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
Keil Sonter
|
Posted - 2011.08.29 03:46:00 -
[147]
Originally by: MJ Maverick Update: v1.5 Admin panel added. All admin actions are logged. Security level allows you to have admins and just whitelist operators. Admin lists stream the admins current corp/alliance. Cron job updates whitelist member counts. Change password. Admins can edit admin accounts easily. Whitelist is now totally databased. Cron.php in /admin/ added to optionally update whitelist member counts.
Excellent work MJ
This has added some much needed sophistication to your work - small donation heading your way...
regards, Keil Sonter Website Hosting Services - EVE Corporation SubDomain Hosting Services - EVE Domain |
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.08.29 04:09:00 -
[148]
You're more than welcome, and yay \o/ :D
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
MillerUk
Caldari Knights Of Divinity Unforgiving.
|
Posted - 2011.08.29 17:59:00 -
[149]
Edited by: MillerUk on 29/08/2011 18:02:44 Nice work MJ!
Altered the admin system to fit my needs and removed the need to login based on previous sessions made from website so i dont have to use mutiple logins
Also added option to list all registered members and their TS id, can also edit a member (usefull if they change corp so i can change the ticker without having to use database editing)
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises Imperial 0rder
|
Posted - 2011.08.30 05:11:00 -
[150]
Originally by: MillerUk Edited by: MillerUk on 29/08/2011 18:02:44 Nice work MJ!
Altered the admin system to fit my needs and removed the need to login based on previous sessions made from website so i dont have to use mutiple logins
Also added option to list all registered members and their TS id, can also edit a member (usefull if they change corp so i can change the ticker without having to use database editing)
Nice, and usefull, are you going to share your adjustments ? Ill drop you admin link later MJ, we alterd the templates again :-) worked sweet as a nut again nice one m8ty :-) http://www.a-c-e.eu/images/A-C-E-signature.jpg |
|
MillerUk
Caldari Knights Of Divinity Unforgiving.
|
Posted - 2011.08.30 08:53:00 -
[151]
Edited by: MillerUk on 30/08/2011 09:02:54
Originally by: Mediek Ordos
Nice, and usefull, are you going to share your adjustments ? Ill drop you admin link later MJ, we alterd the templates again :-) worked sweet as a nut again nice one m8ty :-)
Ill Show You how to add the members listing firstly... bear in mind this is not the final way i want it to look as it does not show pagination so if you have loads registered it will show one big list.
Look For the following line.
break; case "add_admin";
then add above
case "auditmembers": // Authorised to access this area? // Connect to server and select database. SQLconnect(open); $query = mysql_query("SELECT securityLevel FROM admins WHERE username = \"".$_SESSION['character']."\";"); while ($row = mysql_fetch_array($query)) { $securityLevel = "$row[securityLevel]"; } SQLconnect(close); // Audit Members List
?>
<?php // Connect to server and select database. SQLconnect(open); // Set query $query = mysql_query("SELECT * FROM users ORDER BY tsName;"); // Build admin table echo "<table width=\"100%\" border=\"0\">"; echo "<tr><td width=\"32px\"></td><td>Teamspeak Name</td><td align=\"center\">Corp</td><td width=\"100px\">Databse Id</td><td width=\"40px\"></td></tr>"; // Populate admin table while ($row = mysql_fetch_array($query)) { $id = "$row[entryID]"; $tsID = "$row[tsUniqueID]"; $characterID = "$row[characterID]"; $username = "$row[tsName]"; $databseid = "$row[tsDatabaseID]"; // Get the characters current corporation if ($characterID !== "") { try { $fetch = $pheal->eveScope->CharacterInfo(array('characterID' => $characterID)); $fetchCorporation = $fetch->corporation; $fetchAlliance = $fetch->alliance; } catch (PhealException $e) { die("An error occured: ".$e->getMessage()." [A".__LINE__."]"); } } if ($id == $c->adminID) { echo "<tr class=\"listRootAdmin\">"; } else { echo "<tr>"; } echo "<td width=\"32px\">"; if ($characterID !== "") { echo "<img src=\"http://image.eveonline.com/Character/".$characterID."_32.jpg\" border=\"0\">"; } else { echo "<img src=\"images/admin.png\" border=\"0\">"; } echo "</td><td>".$username."<br><font size=1>".$tsID."</font></td><td align=\"center\">".$fetchCorporation."<br /><font size=\"2\">".$fetchAlliance."</font></td><td align=\"center\">".$databaseid."</td>"; if ($id == $c->adminID && $id == $_SESSION["EVEOTSid"]) { echo "<td><a href=\"?menu=member_edit&id=".$id."\"><img src=\"images/edit.png\" border=\"0\" title=\"Edit\"></a></td></tr>"; } else if ($id == $c->adminID) { echo "<td></td></tr>"; } else { echo "<td><a href=\"?menu=member_edit&id=".$id."\"><img src=\"images/edit.png\" border=\"0\" title=\"Edit\"></a> <a href=\"?menu=delete_member&id=".$id."\" onclick=\"return confirm('Are you sure you want to delete ".$username."?')\"><img src=\"images/delete.png\" border=\"0\" title=\"Delete\"></a></td></tr>"; } } echo "</table>"; SQLconnect(close);
break;
Then you need to add the new page to the navagation links which should look something similar to below:
<a href="admin_panel.php?menu=main">Main</a><br /> <a href="admin_panel.php?menu=logs">Logs</a><br /> <a href="admin_panel.php?menu=audit">Audit</a><br /> <a href="admin_panel.php?menu=auditmembers">Audit Members</a><br /><br /> <a href="admin_panel.php?menu=whitelist">Edit Whitelist</a><br />
which in the end should loook somthing similar to http://img20.imageshack.us/img20/926/teamspeaklist.png
|
Balani
|
Posted - 2011.08.30 10:55:00 -
[152]
Edited by: Balani on 30/08/2011 11:08:15 I missing an option to disable Alliance /Corp ticker in the Usernick the reason is i use TS groups that add tag automaticly after registration.
The second thing i find nice was if i can add more then 1 corp that checked
add corp 1 in grp x add corp 2 in grp xx and so on
all other corps in grp xx
if possible same with alliance
I see that the funktion to edit the user is missing in the last post
|
C'Thul
|
Posted - 2011.08.30 16:51:00 -
[153]
what does this system even do? TS3 has no user-registration anymore, instead unique IDs are used ... so judging from your description this system doesnt do anything
|
MillerUk
Caldari Knights Of Divinity Unforgiving.
|
Posted - 2011.08.30 17:25:00 -
[154]
Originally by: C'Thul what does this system even do? TS3 has no user-registration anymore, instead unique IDs are used ... so judging from your description this system doesnt do anything
If you knew anything about the Teamspeak user groups and IDs you would t bother asking that question
|
C'Thul
|
Posted - 2011.08.30 18:19:00 -
[155]
Originally by: MillerUk
Originally by: C'Thul what does this system even do? TS3 has no user-registration anymore, instead unique IDs are used ... so judging from your description this system doesnt do anything
If you knew anything about the Teamspeak user groups and IDs you would t bother asking that question
in fact, as a professional software-developer and gamer who uses TS3 a lot i know a bit about TS3, i already wrote SQuery-software, kiddo ... now : shut and and let the adults talk, mkay? Troll elsewhere please.
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises Imperial 0rder
|
Posted - 2011.08.30 18:39:00 -
[156]
Originally by: C'Thul
Originally by: MillerUk
Originally by: C'Thul what does this system even do? TS3 has no user-registration anymore, instead unique IDs are used ... so judging from your description this system doesnt do anything
If you knew anything about the Teamspeak user groups and IDs you would t bother asking that question
in fact, as a professional software-developer and gamer who uses TS3 a lot i know a bit about TS3, i already wrote SQuery-software, kiddo ... now : shut and and let the adults talk, mkay? Troll elsewhere please.
It is nice that proffesional software developers get involved with these projects, C'Thul take a look at the scripting MJ has written in its entirety then you will see what it is actually doing by assigning server groups with id keys http://www.a-c-e.eu/images/A-C-E-signature.jpg |
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.08.30 18:40:00 -
[157]
Edited by: MJ Maverick on 30/08/2011 18:45:25
Alright C'Thul calm down dude, no one asked for your CV. I don't really want any rioting in my thread.
What it does is: Registrations are based on your UniqueID right? Permissions are tied to that right? Well, presuming you have your TS setup so only certain groups can access/view your channels with the exception of the default channel. EVEOTS will automatically assign people those permissions if they meet the white list criteria.
I do have plans to make it more friendly for those with large numbers of groups like Balani and many others have asked. But it's a fair chunk of work so I'm leaving it until after the new API system comes out... If I can ever work that mystery out. I'm also going to be adding a member edit list in there, but more really wanted to get it out before the new API system came along to strap C4 to all my work.
@MillerUK, your chunk of code doesn't check if they are authorised that I can see :/ it only seems to prepare to check, log into a SL2 account and check that out. Also remember to mention you changed ".$_SESSION['character']" or people using it could break their panel.
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
Mediek Ordos
Caldari Association of Commonwealth Enterprises Imperial 0rder
|
Posted - 2011.08.30 20:15:00 -
[158]
nice one MillierUK i couldnt get the database id working so i changed it a bit from line 377 to line 439 admin_panel.php break; case "auditmembers": // Authorised to access this area? // Connect to server and select database. SQLconnect(open); $query = mysql_query("SELECT securityLevel FROM admins WHERE username = \"".$_SESSION['character']."\";"); while ($row = mysql_fetch_array($query)) { $securityLevel = "$row[securityLevel]"; } SQLconnect(close); // Audit Members List
?>
<?php // Connect to server and select database. SQLconnect(open); // Set query $query = mysql_query("SELECT * FROM users ORDER BY tsName;"); // Build admin table echo "<table width=\"100%\" border=\"0\">"; echo "<tr><td width=\"32px\"></td><td>Teamspeak Name</td><td align=\"center\">Corp</td><td width=\"100px\">Database Id</td><td width=\"40px\"></td></tr>"; // Populate admin table while ($row = mysql_fetch_array($query)) { $id = "$row[entryID]"; $tsID = "$row[tsUniqueID]"; $characterID = "$row[characterID]"; $username = "$row[tsName]"; $tsDatabaseID = "$row[tsDatabaseID]"; // Get the characters current corporation if ($characterID !== "") { try { $fetch = $pheal->eveScope->CharacterInfo(array('characterID' => $characterID)); $fetchCorporation = $fetch->corporation; $fetchAlliance = $fetch->alliance; } catch (PhealException $e) { die("An error occured: ".$e->getMessage()." [A".__LINE__."]"); } } if ($id == $c->adminID) { echo "<tr class=\"listRootAdmin\">"; } else { echo "<tr>"; } echo "<td width=\"32px\">"; if ($characterID !== "") { echo "<img src=\"http://image.eveonline.com/Character/".$characterID."_32.jpg\" border=\"0\">"; } else { echo "<img src=\"images/admin.png\" border=\"0\">"; } echo "</td><td>".$username."<br><font size=1>".$tsID."</font></td><td align=\"center\">".$fetchCorporation."<br /><font size=\"2\">".$fetchAlliance."</font></td><td align=\"center\">".$tsDatabaseID."</td>"; if ($id == $c->adminID && $id == $_SESSION["EVEOTSid"]) { echo "<td><a href=\"?menu=member_edit&id=".$id."\"><img src=\"images/edit.png\" border=\"0\" title=\"Edit\"></a></td></tr>"; } else if ($id == $c->adminID) { echo "<td></td></tr>"; } else { echo "<td><a href=\"?menu=member_edit&id=".$id."\"><img src=\"images/edit.png\" border=\"0\" title=\"Edit\"></a> <a href=\"?menu=delete_member&id=".$id."\" onclick=\"return confirm('Are you sure you want to delete ".$username."?')\"><img src=\"images/delete.png\" border=\"0\" title=\"Delete\"></a></td></tr>"; } } echo "</table>"; SQLconnect(close); break; case "add_admin"; now it works, edit and delete function need some attention nice one m8ty http://www.a-c-e.eu/images/A-C-E-signature.jpg |
king curt
Caldari The Maverick Navy Against ALL Authorities
|
Posted - 2011.09.01 23:46:00 -
[159]
MJ,
Got a question for you. I got everything working well, but I think there is a problem with the cron job for the admin portion and am getting the following error on the cron output:
<br /> <b>Warning</b>: require_once(functions.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in <b>/home5/rattiusm/public_html/eveots/admin/cron.php</b> on line <b>9</b><br /> <br /> <b>Fatal error</b>: require_once() [<a href='function.require'>function.require</a>]: Failed opening required 'functions.php' (include_path='.:/usr/lib64/php:/usr/lib/php') in <b>/home5/rattiusm/public_html/eveots/admin/cron.php</b> on line <b>9</b><br />
This is from your cron php:
require_once("../pheal/Pheal.php"); require_once("../config.php"); require_once("../functions.php"); require_once("functions.php");
Is the last require_once('functions.php") correct? Should it be there?
|
Cpt Sc4rlet
|
Posted - 2011.09.04 12:52:00 -
[160]
This may be a stupid question but how is the Cron managed?
|
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.09.04 22:21:00 -
[161]
Originally by: king curt Edited by: king curt on 02/09/2011 17:40:45 MJ,
Got a question for you. I got everything working well, but I think there is a problem with the cron job for the admin portion and am getting the following error on the cron output:
<br /> <b>Warning</b>: require_once(functions.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in <b>/home5/xxxxxxx/public_html/eveots/admin/cron.php</b> on line <b>9</b><br /> <br /> <b>Fatal error</b>: require_once() [<a href='function.require'>function.require</a>]: Failed opening required 'functions.php' (include_path='.:/usr/lib64/php:/usr/lib/php') in <b>/home5/xxxxxxx/public_html/eveots/admin/cron.php</b> on line <b>9</b><br />
This is from your cron php:
require_once("../pheal/Pheal.php"); require_once("../config.php"); require_once("../functions.php"); require_once("functions.php");
Is the last require_once('functions.php") correct? Should it be there?
Ahhh, sorry about that, last minute change. Fixed now. Redownload and just replace that file.
@Cpt Sc4rlet Run eveots/cron.php, done.
------------------ CCP are not perfect. :) [EVEOTS] Eve Online Teamspeak 3 API Registration
|
sniperhawk1
|
Posted - 2011.09.07 02:55:00 -
[162]
Error message:
Attempting to grant access to: NUKKA sniperhawk1...
An error occured: Connection refused [F10]
I have my login info entered in the config.php file, and can log in to the TS server using PuTTY & the same info. Advice?
|
|
|
|
Pages: 1 2 3 4 5 6 :: [one page] |