These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

Forum Index

EVE Forums » EVE Technology and Research Center » EVE Technology Lab » phpBB 3.x API Registration Mod v6+

Topic is locked indefinitely.

First pagePrevious page1819202122Next pageLast page

phpBB 3.x API Registration Mod v6+
Author

Previous Topic Next Topic

AzAkiR NaLDa

Council of Exiles

Brave Collective

Likes received: 51

#381 - 2012-09-06 17:53:11 UTC

all of a sudden whenever people try to update their avatar to reflect the ingame image this shows up every time.

Quote:

SQL ERROR [ mysqli ]

Column 'user_avatar_width' cannot be null [1048]

SQL

UPDATE phpbb_users SET user_avatar = '2_1346953900.jpg', user_avatar_type = 1, user_avatar_width = NULL, user_avatar_height = NULL WHERE user_id = 2

BACKTRACE

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

FILE: [ROOT]/includes/functions_user.php
LINE: 2457
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/ucp/ucp_profile.php
LINE: 652
CALL: avatar_process_user()

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

FILE: [ROOT]/ucp.php
LINE: 333
CALL: p_master->load_active()

The avatar image gets pulled and saved but it doesnt work how to fix this?

Lone Star Warrior

Cyerus

University of Caille

Gallente Federation

Likes received: 265

#382 - 2012-09-06 23:24:00 UTC | Edited by: Cyerus

Khi3l wrote:

I will try to explain my point of view with my poor english :)

Let's imagine i'm in a 300 members corp with many many alts.

As a director, i can't remember all alts and accounts of a main char, right ? Now let the forum user enter all his API Keys.

On his main account, in his profile, i can view all characters he have. So, i can identify an alt just by looking at the forum and search for his name.

Example :

I have a forum account with Khi3l.

On my profile, there are two more alt on this account : alt01, member of Babylon Knights and alt 02, member of NPC corp.

On a profile field, i can enter second API key for my other account (account2 with 3 chars in NPC corp).

Now, on my profile, admin or members with the right permissions can view :

Khi3l (Babylon Knights, Test Alliance Please Ignore)
alt01 (Babylon Knights, Test Alliance Please Ignore)
alt02 (Random NPC Corp)
SecondAccount01 (Random NPC Corp)
SecondAccount02 (Random NPC Corp)
SecondAccount03 (Random NPC Corp)

Now, in admin panel, admin can search for alt01. When he search for him, infos about forum account are shown (Khi3l, Babylon Knights, Test Alliance Please Ignore). Now admin knows alt01 is an alt of Khi3l.

For permissions, they are still given by the forum main account so that's not really a problem, except for those who have two or more forum accounts....

This feature isn't for most forum user but for directors and CEO to know who is who.

AzAkiR NaLDa wrote:

This is a registration and forum tool. Not a management application.

Khi3l wrote:

That's probably why a fitting mod is included in this tool...

My feature use :

- PhpBB
- EVE API
- Registration

So i think it can be part of this mod imo. Cyerus will say yes or no, it's his decision.

First of all, stop with the bashing.

Second, this is a modification for a forum package (phpBB) which allows API key integration.
What I mean by that is quite simple.

This tool allows you to grand and/or deny access to your forum using a set of user-defined options, with the capability of also managing your teamspeak server without the need of an external library.
On top of that I've included some handy stuff like avatars, fitting display and in the future perhaps a way to show off which skills you have trained. Everything to give the user a meeting place and in a way an extension of the game they like to play.

Even though forum admins can see user's API details, doesn't mean it should be considered an in-depth management tool for entities. If you want to use this mod purely as a penetration test for new users, you should move along.

AzAkiR NaLDa wrote:

all of a sudden whenever people try to update their avatar to reflect the ingame image this shows up every time.

Quote:

The avatar image gets pulled and saved but it doesnt work how to fix this?

It doesn't happen "all of a sudden", it happens when you either changed / removed a setting (avatar width / height) or haven't set them in the first place.
General Settings -> Avatar dimensions.

Also, this is posted in the guide and it has a reason to be there;
Go through each of the modules and click on the Save button at the bottom. By doing this, the module will save their default values to the database, making it less likely for the mod to show weird behaviour.


AzAkiR NaLDa Council of Exiles Brave Collective Likes received: 51	#383 - 2012-09-08 17:25:26 UTC Found the problem and its fixed now. Can't wait for the next version. Keep up the great work Lone Star Warrior

MYALT6

Doomheim

Likes received: 0

#384 - 2012-09-09 19:04:39 UTC | Edited by: MYALT6

Heey there, first of all, no problems with installing it.. great MOD, but now i am running on some problems

I can't assign a group to specified Corp (see image below)
http://img51.imageshack.us/img51/5186/cantassign.jpg

After login i got this error (see image below)
http://img13.imageshack.us/img13/9339/loginerrorc.jpg

I have cleared my cache and it doens't seems to work, my forum is compleetly new so there is nothing i can mess up.
Please help

btw using phpMyAdmin 3.3.5

Cyerus

University of Caille

Gallente Federation

Likes received: 265

#385 - 2012-09-09 21:13:01 UTC

MYALT6 wrote:

You have to create forum groups in order to be able to assign them to the entities.
Doing that, will probably fix that SQL error too.

Faldal Dartan

Sebiestor Tribe

Minmatar Republic

Likes received: 8

#386 - 2012-09-10 11:03:30 UTC | Edited by: Faldal Dartan

Seems like I have new problems. :)
I had to update my root-server to a new OS. Used Debian 4 all the time and now I updated to Debian 5 and switched to x86_64. Also I had to move to another domain, so I had to re-install the forum of course.

I am using
PHP Version 5.3.3-7+squeeze14
cURL 7.21.0 is enabled
MySQL(i) 5.1.63-0+squeeze1

I read about the problems with the version 3.0.11.
No API key fields under registration page or user control panel. Of course I am using the default prosilver style and I also purged the cache etc. ANd I also changed AutoMod to the Compressed File Download configuration and uploaded the edited files manually.

Then I tried it again with a fresh new install and database. The same. Then I tried it with 3.0.10 again also on a fresh new install but now it is the same problem.

Also I noticed when opening the "eveapi_cron.php" that there is a "HTTP-Error 500 (Internal Server Error)"...it's like the file doesn't exist.

CHMOD is set everywhere right.
The API mod itself is fully configured.

I have no idea what to do. :)

Cyerus

University of Caille

Gallente Federation

Likes received: 265

#387 - 2012-09-10 12:05:08 UTC

Faldal Dartan wrote:

See if you can start over one more time, while writing down (in detail) exactly what you have done.
Because it's hard to determine which install step you have missed.

Also, please use phpBB 3.0.10 since the mod is made for that version.

Faldal Dartan

Sebiestor Tribe

Minmatar Republic

Likes received: 8

#388 - 2012-09-10 12:07:49 UTC | Edited by: Faldal Dartan

1. Installing phpBB 3.0.10
1.1 Uploading content via FTP
1.2 Setting CHMOD 777 for cache/files/images/store and config.php
1.3 Installing the board (new created MySQL database)
...following the install process...no errors, all green.
1.4 removing install folder, setting config.php to 644

2. Board Settings
2.1 Setting up categories,forums, groups, ranks, board settings, etc.

3. AutoMOD
3.1 Uploading and replacing the automod files (7 folders - adm, develop, includes, install, language, store, umil)
3.2 using "boardurl.com/install"
AutoMOD - Success
3.3 removing install folder
3.4 Configuring AutoMOD to "Compressed File Download"

4. EVE_API_6.0.3_for_phpBB_3.x.rar
4.1 uploading and replacing all files from the "upload" directory
4.2 re-setting CHMOD 777 as in step 1.2 mentioned folders
4.3 using "boardurl.com/install"
EVE API for phpBB 3.x - Success
4.4 removing install folder
4.5 Board ACP - AutoMOD - uploading "EVE API 6.0.3 for phpBB [AutoMOD].zip"
4.6 Installing "EVE API MOD"
MOD installed
-> browser download window appears after a few seconds with "EVE_API_MOD.zip"
(saved the file on my local machine, doing nothing with it.)
4.7 Purging forums cache
4.8 using the Module Manager in the ACP, doing exactly this on the pictures:
http://eve-it.org/screenshot/module_1.png
http://eve-it.org/screenshot/module_2.png
http://eve-it.org/screenshot/module_3.png
http://eve-it.org/screenshot/module_4.png
4.9 enabling all modules
4.10 deleting and reimporting "User Control Panel -> Profile -> Edit Avatar"
4.11 enabling "Edit Avatar" module

5. EVE API Settings
5.1 General settings
Enable API validation: YES
Allow non-member registration: NO
Enable avatars: YES
EVE Portraits: YES
EVE Portrait size: Medium
Minimum avatar dimensions: 64x64
Maximum avatar dimensions: 128x128
Force avatar resize: No

Special forumgroups: 5
Admins immune?: Yes
"Special"-group immune?: No
"Special"-group: "Alliance Member" (i created after phpbb installation)
for the rest of the 4 groups i choosed the same.
SUBMIT

5.2 Corporations
Enable corporation management: YES
Amount of Corporations: 10

Enable: YES
Name: "Corp Name"
Assign forum group: "Alliance Member"
Default group: NO
Assign TeamSpeak group: 69 (is the alliance member group on my ts3)

Same settings for following corps

5.3 Alliances
Enable alliance management: NO (for now)

5.4 Standings
Enable standings management: NO (for now)

5.5 Faction Warfare
Enable faction warfare management: NO

5.6 TeamSpeak 3
Enable TeamSpeak 3 management: NO (for now)

SAME PROBLEM - no api in user control panel
purged cache again
purged prosilver template cache
deleted board cookies also in my browser -> same problem

Also the Avatars/Portraits are not replaced in the forums.
Normal registration is still possible...there is also no API possibility.

Cyerus

University of Caille

Gallente Federation

Likes received: 265

#389 - 2012-09-10 13:44:26 UTC | Edited by: Cyerus

Faldal Dartan wrote:

...
3.4 Configuring AutoMOD to "Compressed File Download"
...
4.6 Installing "EVE API MOD"
MOD installed
-> browser download window appears after a few seconds with "EVE_API_MOD.zip"
(saved the file on my local machine, doing nothing with it.)
...

When using the "Compress File Download" feature (step 3.4), you'll receive an ZIP file (step 4.6) with the modified phpBB files.
You then have to manually upload the files contained inside that ZIP package. Overwrite existing files -> Yes.
After this step 4.7 is important, so that the forum cache is cleared and the new files (the ones you have just uploaded) are loaded.

This should be mentioned on the screen just before you receive the ZIP file download popup;

AutoMOD is sending a compressed file to your computer. Because of the AutoMOD configuration, files cannot be written to your site automatically. You will need to extract the file and upload the files to your server manually, using an FTP client or similar method. If you did not receive this file automatically, click here.

Also, with the right CHMOD on the whole forum (777 while installing) should allow AutoMOD to make the changes itself, without having to enable "Compressed File Download". But you'll have to google what the default phpBB CHMOD permissions are when you are done installing with AutoMOD.


Faldal Dartan Sebiestor Tribe Minmatar Republic Likes received: 8	#390 - 2012-09-10 13:51:05 UTC \| Edited by: Faldal Dartan omg..it's working..i'm so stupid :) ok, but now u have a new installation guide ... almost :D ty for the help.

The Scope Gallente Federation 0
Carmen Wilson The Scope Gallente Federation Likes received: 0	#391 - 2012-09-14 13:21:43 UTC soon will be a version for phpBB 3.0.11?

Faldal Dartan

Sebiestor Tribe

Minmatar Republic

Likes received: 8

#392 - 2012-09-17 00:02:28 UTC | Edited by: Faldal Dartan

is it possible to add a feature that the forum pulls the ingame charcater name automatically when registering with api (people should not be able to choose a username at registration)? [should be admins choice to turn that on or off would be best I think.]

can you combine the "Special forumgroups" in the "General Settings" with TS3 Server Groups?
so when I say one special user group in the forums is for example "Directors" I can choose a TS3 servergroup next to it which will be assigned? (and implementated in the cronjob)

I can imagine that this is a **** load of work...but it would be really handy. :)

Soul Takers Nourv Gate Security Commission 6
Dism0 Soul Takers Nourv Gate Security Commission Likes received: 6	#393 - 2012-09-18 01:43:36 UTC damn, i just upgraded our forums to 3.0.11. waiting for new release.

State War Academy Caldari State 2
graves warship State War Academy Caldari State Likes received: 2	#394 - 2012-09-20 11:25:38 UTC just reinstalled it on a new domian as i got an error while instaling about alloacatd bytes i installed it on my home pc works fine now :) anyhow i exported the populated db eveapi_items, eveapi_ships etc to a file if anyone needs it: http://studdmuffins.net/stuff/forum.sql.gz that should sort any mising ites if the db installer doesnt complete correctly

Caldari Provisions Caldari State 0
RazzTak Caldari Provisions Caldari State Likes received: 0	#395 - 2012-09-24 20:43:01 UTC My problem is that the accounts are disabled alone with message "Invalid EVE API key", but when I check the API KEY this work fine. The first few days were disabled until 1 or 2 accounts up to last nigth with more than 10 accounts. I run the Cron Job 1 time per day. I change max_execution_time to 1800. Let's see if it works well.

Azam Azara

Phoenix Legion Ltd

Likes received: 5

#396 - 2012-09-25 01:41:57 UTC

Slight bug in

Function wrote:

function eveapi_checkThisCharacter($keyID, $vCode, $characterName)

When a user enters an incorrect API key, they will always get the error from

Line 470 wrote:

$charArray["error"][999] = "Character and API settings do not match -> " . $characterName;

stating "Character and API settings do not match...", overwriting the previous, more useful, errors. Changing the line to

Line 470 wrote:

if (is_null($charArray["error"][999])) $charArray["error"][999] = "Character and API settings do not match -> " . $characterName;

appears to fix this.

Azam

Andy Tibs

Ministry of War

Likes received: 2

#397 - 2012-09-25 12:59:01 UTC

I have run into a confusing issue it seems when people are trying to update their API information.

After putting correct/updated API information into the eveapi_update.php page, their accounts are re-activated and they are able to access the forums normally, but once the cron job is run it disables their accounts again. I looked at their profiles in the admin section and it appears that the API information is not being saved into their profile.

So when the cron job runs it checks their profile for the API information but it isn't there so it disables their account again. I did notice that I am able to manually add an API key in the admin section and it will stay there and work as it should but I am not sure what would cause this other issue.

Any help or ideas with this would be great! (sorry if this has been solved already)

-Andy

The Wonkster

SkREW CREW

Likes received: 0

#398 - 2012-09-26 10:39:39 UTC | Edited by: The Wonkster

Carmen Wilson wrote:

soon will be a version for phpBB 3.0.11?

Devious Decorum wrote:

damn, i just upgraded our forums to 3.0.11. waiting for new release.

I just installed eve api v.603 on phpbb3 v.3.0.11 had no trouble at all here try it out @ http://www.skrew-crew.com/bb311/

just follow all the instructions and you will be good to go Cool

Great work Cyerus thanks

Tranquillian Imperial Navy 36
Aron Fox Tranquillian Imperial Navy Likes received: 36	#399 - 2012-09-26 21:18:50 UTC is there any yourube turtorials on how to install this? Because i aint getting it right


Aron Fox Tranquillian Imperial Navy Likes received: 36	#400 - 2012-09-27 13:01:25 UTC The user defined BBCodes arent working

First pagePrevious page1819202122Next pageLast page

EVE Technology Lab

Council of Exiles

Brave Collective

University of Caille

Gallente Federation

Doomheim

Sebiestor Tribe

Minmatar Republic

The Scope

Gallente Federation

Soul Takers

Nourv Gate Security Commission

State War Academy

Caldari State

Caldari Provisions

Caldari State

Phoenix Legion Ltd

Ministry of War

SkREW CREW

Tranquillian Imperial Navy