open All Channels
seplocked EVE Technology Lab
blankseplocked phpBB3 API Registration Mod v3+
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: [1] 2 3 4 5 6 7 8 9 ... : last (10)

Author Topic

Cyerus
Galactic Dominion
Eternal Strife
Posted - 2010.04.18 20:56:00 - [1]
 

Edited by: Cyerus on 11/06/2011 01:56:52
Edited by: Cyerus on 27/03/2011 03:44:26
Current Version - 4.6
Released March 27, 2011

This is a modification written to allow support for membership validation within corporations or alliances in EVE Online via its API. This functionality can also be disabled via the Administration Control Panel, under "User registration settings".
You can either manually install this mod (if you have mods already installed and in use), or you can copy the supplied files in the 'root' folder if you're installing this mod on a fresh installation (see below for version support).

Ignore references to phpBB.com's MODs section. This one will not be posted there, as it's got a specific purpose many phpBB users won't have use for.

NOTE: Read the enclosed "readme.txt" file for updated instructions!

Also, be sure to open the installation XML file in Firefox. IE incorrectly assumes there's a problem with the XML.

Link: phpBB API MOD 4.6.zip

If you find any bugs, please reply back to this topic.

Please check my next post for the changelog.

I would like to thank Valek Rennesist for his past work on creating and maintaining this mod.

Cyerus
Galactic Dominion
Eternal Strife
Posted - 2010.04.18 21:04:00 - [2]
 

Edited by: Cyerus on 27/03/2011 03:47:29
Changes:

[v4.6]
*** SECURITY RELEASE ***
* Fixed a few security flaws

[v4.5]
* Avatars are working correctly
* api_update.php now correctly enables disabled accounts

[v4.4]
* Tested and updated the 3.0.7-PL1 to 3.0.8 update script. Works correctly now.

[v4.3]
* Fixed setting groups for the api_cron script.
* Fixed updating from 3.0.7-PL1 to 3.0.8
Please read: http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1304222&page=6#162

[v4.2]
* Everything updated for phpBB 3.0.8, so update your forum and use these shiny new files.
* Added a page so that users can change their own API information if their account has been disabled. Link to that is "forum/api_update.php".
* Rewritten parts of the Item / System linking for the IGB, so that it recognizes almost anything
* "api_cron.php" has been completely rewritten, now uses the board's style (or as much of it as it can), and now checks if the server is available before doing anything.
NOTE: You don't see any screenupdates while the script is at work, but instead once it finishes it shows everything.

To update from 4.0 to 4.2, you first need to update your forum to 3.0.8 using the new phpBB files. After that, upload my package's "new_files" and "pre_edit" to your webserver, as well as including "eve_items.sql" and "eve_systems.sql" to the database.

[v4.0]
* Completely rewritten api_cron.php
It now includes the characterid script, and automaticly enables a user as long as the API key works and the user is in the alliance/corp.
* BBcode for IGB.
[eveitem]Cap Recharger II[/eveitem]
[evesystem]Jita[/evesystem]
* Crushed lot's of small bugs.

[v3.0.1]
* Fixed typo in language\en\acp\board.php
* Added default values to API queries

[v3.0]
* Allow 128x128px EVE avatars. Avatar dimensions need to be set for 256x256px to use this option.
* 'Enable EVE Avatars' option doesn't need 'Enable avatar uploading' enabled anymore. This means that if you run your forum with only EVE avatars, you don't have that annoying "upload your own avatar" box in usercp anymore.
* Added default settings to installation files.
* Switched to cURL to grab API information. Cronjob + CharacterID script included.

Keil Sonter
Posted - 2010.04.19 00:06:00 - [3]
 

Hi,

Firstly let me thank you for taking the time to work on this as I know the effort involved and the work you will put in...

Now for the bad bit :)

I'm getting and error on the installtion at the 'create database tables' stage.

---------------------------------------------------------------------------
A fatal and unrecoverable database error has occurred. This may be because the specified user does not have appropriate permissions to CREATE TABLES or INSERT data, etc. Further information may be given below. Please contact your hosting provider in the first instance or the support forums of phpBB for further assistance.

install_install.php [ 1230 ]

SQL : INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_from, user_icq, user_aim, user_yim, user_msnm, user_jabber, user_website, user_occ, user_interests, user_actkey, user_newpasswd, user_allow_massemail) VALUES (2, 1, 'Anonymous', 'anonymous', 0, '', '', 'en', 1, 0, '', 0, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0)

Field 'api_userid' doesn't have a default value
-----------------------------------------------------------------------------

Now I have an existing phBB3 installaton but I have setup a new directory on the server and a new database so I know its not a configuration issue or compatibility as I already have a running phpBB3.

Looking at the above the last statement 'Field 'api_userid' doesn't have a default value' seems to be the sticking point. Also the SQL INSERT doesn't include the api_userid in the field list.

When I look at the database the tables are configured but no data has been installed in the user table. This table should include the users such as Google_bot etc by default.

Please advise..



Cyerus
Galactic Dominion
Eternal Strife
Posted - 2010.04.19 02:19:00 - [4]
 

Edited by: Cyerus on 19/04/2010 11:21:22
Edited by: Cyerus on 19/04/2010 02:22:32
Which SQL-type are you using? I'm using MySQL (without MySQLi!) and I have no problems with setting it up.

Open install\schemas\schema_data.sql
Change line 8 to 10 to this (the old ALTER TABLE lines):
Quote:

ALTER TABLE phpbb_users ADD COLUMN api_userid VARCHAR(10) NOT NULL AFTER user_form_salt DEFAULT '';
ALTER TABLE phpbb_users ADD COLUMN api_limitedkey VARCHAR(64) NOT NULL AFTER api_userid DEFAULT '';
ALTER TABLE phpbb_users ADD COLUMN character_id INTEGER UNSIGNED NOT NULL AFTER api_limitedkey DEFAULT 0;



Rerun setup and let me know if it works.

Keil Sonter
Posted - 2010.04.19 05:49:00 - [5]
 

Hi,

That was a fix but with a slight change in the ALTER in install\schemas\schema_data.sql

Quote:

ALTER TABLE phpbb_users ADD COLUMN api_userid VARCHAR(10) NOT NULL AFTER user_form_salt DEFAULT '';
ALTER TABLE phpbb_users ADD COLUMN api_limitedkey VARCHAR(64) NOT NULL AFTER api_userid DEFAULT '';
ALTER TABLE phpbb_users ADD COLUMN character_id INTEGER UNSIGNED NOT NULL AFTER api_limitedkey DEFAULT 0;



This should be

ALTER TABLE phpbb_users ADD COLUMN api_userid VARCHAR(10) NOT NULL DEFAULT '' AFTER user_form_salt;
ALTER TABLE phpbb_users ADD COLUMN api_limitedkey VARCHAR(64) NOT NULL DEFAULT '' AFTER api_userid;
ALTER TABLE phpbb_users ADD COLUMN character_id INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER api_limitedkey;

good work and thanks for your prompt response..

Lompen
Posted - 2010.04.19 10:56:00 - [6]
 

Edited by: Lompen on 19/04/2010 10:56:03
Well,, the download is the complete forum and mod.

Do you perhaps have the mod itself? or maybe specify where the edit directions are?

Edit: Sorry, i saw the second download is coming. My bad

Dan O'Connor
Cerberus Network
Dignitas.
Posted - 2010.04.19 13:39:00 - [7]
 

Is there a mod like this for PunBB also? My Forum is PunBB

He dares
Caldari
KINGS OF EDEN
Sev3rance
Posted - 2010.04.19 14:52:00 - [8]
 

Originally by: Cyerus

Link #1: phpBB 3.0.7-PL1 + API Mod v3.0.1



This link doese not work

Cyerus
Galactic Dominion
Eternal Strife
Posted - 2010.04.19 18:23:00 - [9]
 

Fixed the link :)

Ecliptic Illusion
Caldari
Executive Intervention
Controlled Chaos
Posted - 2010.04.20 02:37:00 - [10]
 

Edited by: Ecliptic Illusion on 20/04/2010 02:37:57
Is there another location to download this from? Would like to test this out so I can update our forums :) That link is downloading at like 10b/s lol.

nvm it speeded up :)

Tidachidd
Posted - 2010.04.21 21:35:00 - [11]
 

Edited by: Tidachidd on 21/04/2010 21:36:26
Thanks for stepping up as the new dev. Cool

Lompen
Posted - 2010.04.22 05:49:00 - [12]
 

any updates on the release of the mod only?

Cyerus
Galactic Dominion
Eternal Strife
Posted - 2010.04.22 12:14:00 - [13]
 

Originally by: Lompen
any updates on the release of the mod only?


I'm sorry, what do you mean exactly?

Lompen
Posted - 2010.04.24 08:40:00 - [14]
 

well,, i have a forum with a couple of mods in it.. So i would love if you could release the mod only.

with modification info

Lompen
Posted - 2010.04.29 08:43:00 - [15]
 

Any updates`?

Head Noob
Noobswarm.
Posted - 2010.04.30 13:52:00 - [16]
 

Edited by: Head Noob on 30/04/2010 22:08:42
Edited by: Head Noob on 30/04/2010 17:22:39
I just installed a fresh copy of the 3.0.7-PL1+API Mod v3.0.1 file referenced in the OP (Thanks for your efforts), and everything is working up to the point when I try to register a the first user.

The API fields are not showing up for entry on the register page, and when I submit, it complains the "entry is too short".

The registration completes normally when I turn off the API mod in the admin control panel.

edit - I also see that this problem is just with using the API verification in Corporation mode - Alliance mode seems fine.

edit again - Apparently, it let me do one verification for alliance after switching modes, and then that stopped working also.


Geallen
Gallente
Rapid Ore Extraction
Looney Toons.
Posted - 2010.05.02 03:01:00 - [17]
 

Any ETA on the MOD only? I did a diff on your phpbb+mod and might have some issues trying to merge/modify with the number of mods and customization already on our board.

Also, if it helps, let me know if you need a mirror, I would be glad to set up a sync for you. Contact me in-game evemail.

...G.

Lompen
Posted - 2010.05.03 12:30:00 - [18]
 

Please update this with the mod only.

Would be really appreciated

Cyerus
Galactic Dominion
Eternal Strife
Posted - 2010.05.05 02:24:00 - [19]
 

Sorry I haven't been in touch.

I have been working on more eve related mods for the forum ^^, which will be released very soon.
After that I the mod-only file will be released, but be aware that file will probably take an hour to mod into your existing forum.

The issue about the API fields not showing up on the registration page I haven't had yet. I use the alliance feature, haven't tested the corp one. Can you reinstall the whole forum (basicly start over) and test it again, if possible write down the steps you did (changes you did) comparing it to the default settings?

Alex Stokes
Erben der Nacht
WE FORM VOLTRON
Posted - 2010.05.10 07:32:00 - [20]
 

Where can I find the installation instruction?
I have some mods already installed and need the installation xml file.

xXShadowWarriorXx
Posted - 2010.05.11 08:13:00 - [21]
 

I installed the forum, all good, no errors, everything but the API works. I installed a style. (maybe that was the problem?)

I then enabled the API thing. I then went to register a new user, and the fields don't show up, i enter the info anyway, and hit submit. then i get the value too short thing and can't proceed any further.

Also another problem - it doesn't seem as though there is any way for me to set my API key once already registered. Would I have to get people to re-register in order for them to be able set the API key?

Cyerus
Galactic Dominion
Eternal Strife
Posted - 2010.05.12 03:51:00 - [22]
 

You need to edit certain style files to add the API fields.

If you are using the default skin, users can change their API under User Control -> Profile -> Edit account settings.

xXShadowWarriorXx
Posted - 2010.05.12 11:36:00 - [23]
 

could you please tell me how to edit my style? if that's even possible.

It's the one thing stopping this mod from being completely awesome right now.

Jules Asner
Van Diemen's Demise
Merciless.
Posted - 2010.05.14 05:11:00 - [24]
 

Hey guys i have found the files that need to be modified. If you do NOT know what you are looking at it will be hard to change. Eve mail me in game and i can ether do it for you (isk fee) or tell you the files to edit (higher isk fee if i have to fix it)

Amon Rhar
Samsara Dynamics
Posted - 2010.05.19 07:51:00 - [25]
 

I'm trying to install the mod and get the following error:

Parse error: parse error, unexpected T_OBJECT_OPERATOR in C: \ Inetpub \ vhosts \ meudominio.com \ httpdocs \ forums \ includes \ functions_user.php on line 156

I glanced at the code and you put it:

152 - function getId (& $ username, $ updatename = false) (
153 - $ url = "http://api.eve-online.com/eve/CharacterID.xml.aspx?names =". Urlencode (stripslashes ($ username));
154 - $ xml = simplexml_load_string (file_get_contents ($ url));
155 - $ id = (string) $ xml-> result-> rowset-> row [0] -> attributes () -> characterID;


I thought the error was on line 152 showing the variable username with the character '&' but even removing the error continues, someone would have some solution?

xXShadowWarriorXx
Posted - 2010.05.19 08:12:00 - [26]
 

Here's a solution that worked for me AND allowed eve API's to work with custom themes:

Delete PHPBB and install SimpleMachines Forum. Much better. And more modern. And the EVE API mod WORKS.

Lompen
Posted - 2010.05.20 09:35:00 - [27]
 

i'm afraid that is not a solution. Thats just avoiding problems. We want it on phpbb, hence the topic name

Cyerus
Galactic Dominion
Eternal Strife
Posted - 2010.05.22 01:30:00 - [28]
 

Amon Rhar:
I don't see any bugs on that line, nor line 156 itself.
The zipfile works for me, as it sohuld for you without any problems.
Nonetheless, would you mind posting a bigger snippet of the code? (between quote brackets if possible).

All:
First version of ModX file will be released this weekend, expect it on somewhere on the sunday evening UTC.

Amon Rhar
Samsara Dynamics
Posted - 2010.05.22 04:24:00 - [29]
 

So I've been thinking about the error and possible causes.

Realized it could be PHP then updated my forum to a server with PHP 5.0 and it worked perfectly, perhaps because the mod is not compatible with PHP 4 is a tip for those who experience this problem in the future.

I would take and take two doubts:

1 - How do I allow users to be registered in two different corps, but these corps are not in the same alliance?

2 - Registered users are not showing tab of Users and Groups> Manage Users
they appear only in the Inactive Users, but once you activate them they do not appear anywhere, is this normal?

Cyerus
Galactic Dominion
Eternal Strife
Posted - 2010.05.22 17:50:00 - [30]
 

Edited by: Cyerus on 22/05/2010 17:52:10
Answer to the previous post questions:

1. No, impossible for now. At this point I don't see why this would be needed? If you can convince me, I'll try to work something out.

2. I'm not sure what you mean exactly by this.
Are you sure you have setup the API-settings correctly?
AdminCP: General -> User registration settings -> (scroll down to the bottom) API validation settings -> Member Group.
Default should be Registered Users.


Pages: [1] 2 3 4 5 6 7 8 9 ... : last (10)

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only