EVE Technology Lab

1

https://github.com/shibdib/phpBB-3.x-API-Registration-Mod-Revisited

I put a fix in for it, 99% sure the cause is it was disabling keys if they threw any kind of connection error and not just if they went bad (expired/mask issue/etc..)

Saw your other post, looking into it. Everyone hold off for a moment

Almost, it fixed the issue of the AutoMod tab not working, but it doesn't see the mod in the folder.
You have the zip file (phpBB-3.x-API-Registration-Mod-Revisited-7.0.0.zip) with a folder inside (phpBB-3.x-API-Registration-Mod-Revisited-7.0.0) and then the files. It needs to be the zip file, and the files.

I removed the inner folder and it sees it. Installing now.

Installed without issue. Thanks.

About to mass reactivate accounts, then intentionally run cron, and see what happens.

Let me know, it fixed it on my corps forum. Brought us from 5 pages of inactive to 2 which are actual bum api keys

It does, something with curl. Lemme dig.

Perfect example of why I made the github tho, the base release was getting long in the tooth with a bunch of custom fixes needed to keep it running.

So, the good and the bad of things. The API and your fixes work great.

I also see that "something" has greatly expanded on the error message received when an account is bad, for example:
11-04-2015 15:27:24 username EVE API Key error: 222 -> Key has expired. Contact key owner for access renewal.

Here is where the issue is, and maybe its how I did the board, so I'm open to that statement.

The board requires you to be a member of the alliance AND a member of an alliance corp. I guess the second isn't so important, but regardless.

We allow non-alliance members to make an account, and post to the public area.

We also have manual (not API checked) groups. For example "Fleet Commanders", "Logistics" and such. If these were API checked, the cron job would remove them daily. I learned this the hard way when I implemented the cron job.

In the past (right or wrong) when the cron job ran, and your API failed, it disabled the account 100%
Now when it runs it simply removes you from alliance and corp groups, putting you back into "registered user".

Good, expect those darn manual groups. It (as expected) leaves you in them. So, right now, I have 0 disabled accounts, but I have 7 that are only registered users.

Sloppy admin on my part, I admit, 3 of them had manual permissions and were instantly granted access to private areas of the forum as a result.

Apart from, "you need to check every member daily" which may be the answer, any ideas from anyone?

When a user is set to inactive (and I think when he leaves corp too), he still has permissions on TS3. Any idea how I can have the TS3 groups automatically revoked?

I updated the mod to the newest version for phpbb 3.0.14, but couldn't get the eve fitting to display correctly, just posted as text.

So I uninstalled the mod, purged cache, then reinstalled, purged cache, then went to /install url;

It showed that API Registration Mod Revisited 7.0.6 is currently installed, with the only option being uninstall, so I select it and get this error;
General Error

SQL ERROR [ mysqli ]

Unknown column 'group_eveapi_special' in 'field list' [1054]

SQL

INSERT INTO eveapi_grouptmp (group_id, group_eveapi_special, group_eveapi_ts3, group_eveapi_jabber, group_eveapi_openfire) SELECT group_id, group_eveapi_special, group_eveapi_ts3, group_eveapi_jabber, group_eveapi_openfire FROM bb_groups

BACKTRACE


FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 189
CALL: dbal->sql_error()

FILE: [ROOT]/install/index.php
LINE: 161
CALL: dbal_mysqli->sql_query()

FILE: (not given by php)
LINE: (not given by php)
CALL: umil_eveapi_7_0_6()

FILE: [ROOT]/umil/umil.php
LINE: 493
CALL: call_user_func()

FILE: [ROOT]/umil/umil.php
LINE: 432
CALL: umil->_call_custom_function()

FILE: [ROOT]/umil/umil_auto.php
LINE: 178
CALL: umil->run_actions()

FILE: [ROOT]/install/index.php
LINE: 126
CALL: include('[ROOT]/umil/umil_auto.php')


I delete the install folder and navigate back to admin control panel, refresh styles, purge cache.

But the forum now displays "Powered by EVE API v6.3.1 for phpBB 3.0.x - Cyerus"
[EDIT] I didn't apply the style to my current style. Fixed


I go to /eveapi_cron.php and get this error;
General Error

SQL ERROR [ mysqli ]

Unknown column 'group_eveapi_special' in 'field list' [1054]

SQL

SELECT group_id, group_name, group_eveapi_special, group_eveapi_ts3, group_eveapi_jabber, group_eveapi_openfire FROM bb_groups

BACKTRACE


FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 189
CALL: dbal->sql_error()

FILE: [ROOT]/includes/eveapi/functions_eveapi.php
LINE: 340
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/eveapi_cron.php
LINE: 313
CALL: eveapi_setForumGroups()


Everything seems to be back to normal, although 2 instances of API KEY registration appeared, I just deleted the dead link version from the style.php

But the fitting bbcode is still not working.

What the hell have I done? Please help!