EVE Technology Lab

Rache: I'll try to help you with that tonight (in a few hours, after work).

You might check your Teamspeak logs though, to verify that it indeed has never connected to the server.

Cool, Rache. I'll have to look into that limit and put it in the config. documentation.

Here is another issue I found and have corrected. I have only found this issue to cause any problems but you may want to update the script.

in index.php Line 209

$corp = get_eve_corp ($_POST['Key_ID'], $_POST['Key_Ver_Code'], $_POST['Character_Name']) or die('Error getting corporation information with submitted API information.');
if ($corp == -1) { //connection error
die('Error connecting to EVE API server to verify corporation membership. Please try again later.');
}

Should be

$corp = get_eve_corp ($_POST['Key_ID'], $_POST['Key_Ver_Code'], stripslashes($_POST['Character_Name'])) or die('Error getting corporation information with submitted API information.');
if ($corp == -1) { //connection error
die('Error connecting to EVE API server to verify corporation membership. Please try again later.');
}

The reason for this change is for people that have names like mine with a ' in the name. This caused problems and could not verify the corp with the character because it had a slash in it. IE Rache Le\'Bonbon. The fix will remove the slash and allow the script to run properly.

Found one more issue that this causes. When it updates the forum, it adds the slash as well. Will have to figure out were in the code this is and update the fix.

TA5E: I don't know. It works for Drake, and he's on 1&1. EDIT: If you have shell access, play around in it until you can figure out the correct path to PHP. Clearly since you can do "echo", your account allows the exec command, as you established, and I know 1&1 uses suPHP (PHP runs as your username), so the same path you would use to run php from the shell should work in exec.

Rache: Although from looking it, you should be right, I do have a character in my corp. with a single-quote in his name, and he registered just fine after my 1.55 update. I'll probably correct that anyway, though, after doing some testing to see why it worked for me in the first place. It might be that you have Magic Quotes on in PHP, which would then be double-escaping things unnecessarily.

EDIT: I also verified that it didn't put a backslash on his name in the database.

EDIT 2: I figured it out. As per my 1.55 fix, the $_POST array is not escaped at all. On line 181, an escaped copy of $_POST is created solely for database query use ("$post_db"). You very likely have Magic Quotes on, and I'm going to add that to the documentation as a requirement (that magic_quotes_gpc be set to Off). Even according to the PHP manual, "This feature has been DEPRECATED as of PHP 5.3.0. Relying on this feature is highly discouraged."

Drake: I don't know why. Mine was filled with log lines of people being deleted, but I didn't lose everybody (since I caught it in time). The moral of the story is that backups are key, always. Sorry for the loss, though. Is it logging other things correctly?

Ok first off, excellent work being the first to actually attempt this with the new keys. From the posts here seems fairly solid.

However in my case we are hitting a wall with no real explanation. After Key entry when the user goes to click the character selection drop down the setup holds for second (It doesn't lock up) It seems to be attempting to contact the API server then returns with a message...

"Error Contacting API server"

Now I'm pretty sure of the culprit but before I proceed, is this the error that was displayed due to the 'EOL' vs. EOL and SQL version that was listed earlier in this thread? No real description of the that error was ever given only that the mod "Didn't work".

We aren't running 5.3 and I'm sure we need to upgrade, but before I go chasing that I wanted a little feedback here.

Thanks for the hard work BTW.

Yea, php.ini is the best way, but its not always a perfect world. I guess when I make scripts I try to think of it this way. Most people are dumb, and probably don't know how to modify there php.ini! Or their hosting service wont let them, or even they do use it for other scripts thus can not turn it off.

So as making a script I always put stuff in to take care of any problems that might rise to any situation, so I don't have to worry about it later. Making assumptions that people are smart will always get ya into trouble. LOL no matter what its about Life, scripts, Eve lol

I do understand from your prospective that Magic Quotes is deprecated and I believe in 6.0 is gone all together if I remember reading. So really no big deal! I guess I am the only one that ran into it seems anyhow. LoL. At minimum its in these forums, for anyone that might run into it, they can then search and find answers!

I am a novice to advanced in what I know about PHP, basically know enough to get into trouble lol.

However I did run into one more problem! I can not get it to interface with TS3.. It says everything is ok, but it is not adjusting groups like it should! Haven't started to dig yet into it. you have my TS info jump on if ya like, or just write back.

Also I would like to get your opinion on why I can not use the HTTPS as it tells me that the cert is bad.

Although I mentioned some fixes in index.php, I apparently forgot to include the updated index.php in my most recent release, so they actually weren't added, and I'll instead stick it in my next release. The good news is that they weren't critical changes.

Sorry about that.

Drake:
It should have logged, and it logged it all for me. That's what I'm trying to troubleshoot. Does it log errors normally otherwise?

Hello, i have a problem in TS3, im install you script, user EVE Registration Bot found in Admin server query group, but no one new user not enter any group. Forum registration work fine and no errors in txt file. Help me pls.

Quantum:
It could be a lot of things. Verify your group configuration and TS ignore list are set up correctly. Beyond that, it's hard to give you specific information when I have limited information. If Teamspeak is connecting at some point (probably when the registration form is submitted, but possibly not when check-users.php runs, that rules out a lot of things. If you need help, mail or email me with your comms. information, and I may be able to help figure out why it isn't connecting.

Drake:
I have no idea why it would log problems with only one user, it doesn't make sense that that one user would just be you (instead of some other random person), it's not happening for me, and I haven't seen it happen with anyone else.

Something you might try to test: On line 3 of check-users.php, paste the following:

With that, you should get an entry in errors.txt every time check-users.php runs via the cron job or via the registration form. My only guess I can think of is that it might be only logging when it runs via the registration form and not via the cron, but if you said it did show that your registration got deleted during the EVE API downtime, then that may not be it. Either way, that's a good troubleshooting step to make sure it at least can log at the appropriate times.

Running into RL stuff...gonna be a bit delayed on feedback results for the test.