EVE Technology Lab

Look Here... https://neweden-dev.com/Char/CharacterSheet

row roleID="1" roleName="roleDirector" /

Getting SQL errors when a user tries to register using an API:

Any idea how I should get this fixed?

General Error
SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4 [1064]

SQL

SELECT user_id, group_leader FROM phpbb_user_group WHERE user_id = 48 AND group_id = 

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/functions_user.php
LINE: 2767
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/eveapi/functions_eveapi.php
LINE: 434
CALL: group_user_add()

FILE: [ROOT]/includes/acp/acp_users.php
LINE: 844
CALL: eveapi_setForumGroups()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: acp_users->main()

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()

Wow, that is awesome, thank you MillerUK!

Don't do it every 2 hours. I have 1000 users on my board and had to cut it back to once daily and that eliminated the false positives.

Out of curiousity, since I couldn't seem to find an answer in the threadnaut....do we have any word about 3.1 support?

AutoMod, which is required for installation of this mod, does not work on phpBB 3.1.X, and never will.

https://www.phpbb.com/customise/db/official_tool/automod/support/topic/130321

3.1 changed a lot of how the functionality of phpBB works, including how mods are installed. Basically this will require a rather large update to support it, so I would recommend staying on 3.0.X for now, for more reasons than just the API Registration mod but all the other mods available supporting it as well.

Is something wrong with the API server? As of yesterday the eveapi_cron.php script runs, but abruptly stops spitting out no errors, deactivating members accounts. I noticed I was getting API errors in EVEMON as well. Can someone confirm if you are experiencing similar issues or not? Thanks.

Yes, it's really me, I'm still alive..

Support for phpBB 3.1 is going slower than expected.
It seems that every time I set a date and time to have it finished, something pops up making me overshoot the deadline.

Few months ago I've started uploading semi-finished code to Github (was a populair request) for the seperated phpBB 3.1 extensions.

Unlike the mod, the extensions will be seperated to simplify updates and promote faster development;

1. EVE Online BBcodes
2. EVE Online SSO
3. EVE Online SSO-Buttons
4. EVE Online Entity-Authentication
5. TeamSpeak and OpenFire integration

1,2 Working but beta version
3,4 Coded but not uploaded to github yet (requires some formatting )
5 Requires phpBB to add more 'hooks', process to solve this has been started

EVE Online BBcodes
This will add the BBcodes to your forum just like the mod did. The codebase has been updated to avoid weird behaviour, and should now show the correct slot layout for the tech 3 ships based on their subsystems.
At the time of writing it uses EVE's last expansions database information, so it's only outdated by a few weeks.

EVE Online SSO
EVE Online SSO integration is its more basic form. This extension extends the SSO integration phpBB uses by adding EVE SSO functionality to it. This extension only adds the ability to link your EVE account (character + account combination really) to your forum account, allowing you to log in to the forum using your EVE account. That's it, nothing more.

EVE Online SSOButtons
Changes the weird text-based "Sign in with whatever" options with proper images. Downside is that the text for all non-EVE SSO buttons is also removed (as I override some css), it provides suitable buttons to the other 4 default options aswell.

EVE Online Entity-Authentication
This holds the basic functionality as the mod. It checks the users corporation / alliances and does some magic to make grant / revoke his rights on the forum, teamspeak and/or openfire. This is at the time of writing still a private project, as I'm not confident enough in its abilities to release it to the public just yet.

TeamSpeak and OpenFire integration
This extensions holds the basic functionality of connecting to teamspeak and/or openfire. The EVE Online Entity-Authentication-extension will require this extension to work properly. This is at the time of writing still a private project, as I'm not confident enough in its abilities to release it to the public just yet.

Hope this answers some of your questions.
And ofcourse a big thank-you to all those that were able to answer other users questions while I wasn't around.

~Cyerus

You have no idea how happy I am to see that you're updating for 3.1

Seriously please don't ever leave us! lol

For the teamspeak etc is there a way to make an optional extra page used for admin only that communicates with the main forum?

The idea being if someone is on virtual dedicated hosting and has limited ports the admin page generates commands then accesses the remote page stored on another dedicated (likely slower) server.

for example:

Main site: mysite.com
extra host: 25.577.234.44/mysite

You want most people going to mysite.com since it is fast, high bandwidth and easy to remember url.

then when a teamspeak command neads to be given

mysite.com/tsadmin.php authenticated with 25.577.234.44/mysite/tsrelay.php

login verified, access rights confirmed

mysite.com asks tsrelay.php to issue X commands and asks for X information

tsrelay passes on commands and returns information to mysite.com/tsadmin.php

assuming both pages can share an sql server it should be easy enough and should all be done on port 80 which needs to be allowed.