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;

---

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;

---

Originally by: Cyerus

---

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

---

Originally by: Lompen

---

any updates on the release of the mod only?

---

Originally by: FreakOfNature666

---

I set my forum to allow non-alliance members to register but when I try to register a toon that is not in the alliance I get "The API information you entered was invalid." Also when a toon name is spelled wrong I get the same message instead of a toon not found message.

---

Originally by: Cyerus

---

Yet why don't you set the API check to "None"?

---

Originally by: Thorin Wren

---

Hi, thx for the work you are doing on this mod. The mod is working fine for me but I am unable to get the cron script to work. I get the following error.....

/api_cron.php: line 1: ?php: No such file or directory
/api_cron.php: line 3: //: is a directory
/api_cron.php: line 27: syntax error near unexpected token `('
/api_cron.php: line 27: `$clean_userid_array = eveapi_array_userid($all_users);'

Any ideas?

Thanks again

-TW-

---

Originally by: Faridi Dem

---

first of all, very nice you contiuned this mod for phpbb3. so far i havnt found any bugs, but i got a feature request.

atm if the api check fails, the account will be deactivated. it would be nice to have an option that does the following

api check (corpmember) -> fail -> swicht user from group corpmember to nonmember

---

Originally by: MEXXDOR

---

hi

bbcodes not work for all items --> PICTURE HERE

thx

---

Originally by: leath4xr

---

a few things:
first of all, this is cool, i have been playing around with this for a while with no luck yet, but it looks promising and i have been looking at the code, looks like it should be working

second, i noticed there were a few problems with the inability to download the packages, have you ever tried google code? the will host all the files for you, check it out!

and third, when you edit the registration permissions, is the entity the ID or the literal name of the corp/alliance?

---

Originally by: DaReaper

---

does this mod include a way to have people placed in a certin group based off the corp they are in? So i can set a forum for corp x only and all users of corp x can see said forum?

---

Originally by: leath4xr

---

nah, i have a test forum of my own thats setup atm, and its working, however when i test user registration it just gives me a blank screen when i submit the form

also part of my previous question when i fill out the group settings, so i select the type of ID to look for, i select alliance and in the id space do i put the alliance ID or the literal alliance name (10475348 vs Blah Alliance)?

---

Quote:

---

Entity:
The name of the corporation or alliance in which membership is required.

---

Originally by: Zagdul

---

How hard would it be for you to port this to SMF?

---

Quote:

---

582function bbcode_second_pass_eveitem($itemname)
583{
584global $db, $phpbb_root_path;
585
586$sql = 'SELECT *
587FROM eve_items
588WHERE itemName = "' . $db->sql_escape($itemname) . '"';
589$result = $db->sql_query($sql);
590$row = $db->sql_fetchrow($result);
591$db->sql_freeresult($result);
592
593$preview_array = array(2,6,18,23,40);
594$return_string = $itemname;
...

---

• prosilver based templates
• posting_buttons.html
• ucp_avatar_options.html
• ucp_profile_reg_details.html
• ucp_register.html
• subsilver2 based templates
• posting_buttons.html
• ucp_profile_avatar.html
• ucp_profile_reg_details.html
• ucp_register.html

Quote:

---

Step1: You must log into your server's SSH portal. Typically that information is made available on request if your able to do so. ssh [email protected] It then asks for password... and may require a signature approval or encryption key addition.

---

Quote:

---

type this
crontab -e

You'll be dumped into a VI Text editor...

type
i
Use the arrow keys to type the following:
00 00 * * * /usr/bin/php5 -q web/forums/directory/api_mod.php
00 12 * * * /usr/bin/php5 -q web/forums/directory/api_mod.php

hit the ESC Key then SHIFT : (colon).
Then type
x
Hit Enter
Your done.

---

Quote:

---

#!/bin/sh
cd path/to/phpbb
/usr/bin/php5 api_cron.php

---

Quote:

---

0 */12 * * * path/to/api_cron

---

Originally by: Carl Rannseier

---

Edited by: Carl Rannseier on 17/07/2010 03:13:30
Edited by: Carl Rannseier on 17/07/2010 03:02:08
@ Gerin Tell: I can't help ya here, i think for this you have to ask Cyerus. I actually think that you have to do all the work again cos he has rewritten pretty much all of the code so it might be easier setting it up from scratch again.

@DiLantius: You have to update your board template if you want those functions to work properly. The mod ships with the prosilver template only so this is the only one that actually works when you initially install it. The files that need to be modified are:

• prosilver based templates
• posting_buttons.html
• ucp_avatar_options.html
• ucp_profile_reg_details.html
• ucp_register.html
• subsilver2 based templates
• posting_buttons.html
• ucp_profile_avatar.html
• ucp_profile_reg_details.html
• ucp_register.html

You can tell what style was used to create the one you are using by looking up those files in the "phpbb/styles/<your_style>/template" folder. check if there is either ucp_avatar_options.html (prosilver) or ucp_profile_avatar.html (subsilver2). To check this you can simply use the acp, go to the styles tab -> templates -> edit the style you are using. there you get a dropdown box that offers you all files within that template. you can also modify it there althouh a proper editor would perform better.

If it is prosilver based then simply follow the steps that can be found in the install_api_registration_4.0.xml file. it's well structured and easy to read. For a subsilver based style i don't have any instructions ready but you can contact me ingame and we can figure out how to get your board running correctly with this mod.

---

Originally by: Carl Rannseier

---

Nice work u did there, although u might want to change the lines 588 and 628 of "includes/bbcode.php" to this:

Quote:

---

582function bbcode_second_pass_eveitem($itemname)
583{
584global $db, $phpbb_root_path;
585
586$sql = 'SELECT *
587FROM eve_items
588WHERE itemName = "' . $db->sql_escape($itemname) . '"';
589$result = $db->sql_query($sql);
590$row = $db->sql_fetchrow($result);
591$db->sql_freeresult($result);
592
593$preview_array = array(2,6,18,23,40);
594$return_string = $itemname;
...

---

line 628 is the same for the system name. that way it is using phpbb's built in database methods and u don't have to bother what db driver actually is used. i came across this since i'm using mysqli.

keep up the great work m8, really appreciate it.

---

Originally by: Drake Draconis

---

Edited by: Drake Draconis on 11/07/2010 08:43:51
Excellent job... I love this package.

Comments:
1: Instructions would be deathly/dangerous to any noob who didn't know enough about PHPBB systems to be dangerous... strongly urged to find a way to automate the SQL insertion commands via PHP or some such.

2: Might want to set a trap/error code for when you tell the API checker to use "Pre-set" User Groups... triggered an SQL Error... managed to find out that you have to use a pre-set group to make it happy again. Minor but a little annoying if your not the tinker'er type.

3: I got a suggestion for your "why allow more than one corporation/alliance" bit...

Standings... some alliances may want guests or some such... or there may be some corporations with +10 standings... would be nice to have extra sets of permissions set aside for them. Push them to different groups perhaps?


Conclusion - Fantastic addition to any EVE Online PHPBB... I love it. Hope it works when I throw a a crapload of users at it. :)

Question - If you leave API fields blank... does it "assume" your just a guest and not error out? Havn't tried this yet as no one that doesn't play eve will be seeing this board but I'd like to put it on a couple others for just corporations.

---

Originally by: Agent Unknown

---

Link is broken. Please host it again...I need it.

---

Originally by: Gerin Tell

---

Edited by: Gerin Tell on 15/07/2010 18:33:41
Edited by: Gerin Tell on 15/07/2010 18:32:22
I apologize if this question has already been answered, but as I have not seen an adequate response so far i'll ask away:

I have the old API mod running on my forum (version 2.1.1) and I am looking to update to this version. Can I simply update the files, and if so how would I go about doing this? I, of course, know how to do it as it's working and installed on my board currently, but I was wondering if there was an alternative to manually installing everything again, or if that is even possible without creating errors.

The current mod version I'm running has a lot of issues and limitations, so I'd love to update!

---

Originally by: DiLantius

---

I'm sorry if this has been answered before, but I can't seem to find out how to do this. I've installed this mod on my test phpbb server, but from what I can tell I can only use it for bbcode stuff, like entering a system name and linking it in game.

Is there more to it than that? How can I take advantage of more functionality without knowing php/js and the api system intimately?

1.) I've seen on a few phpbb powered alliance boards where the profile has a dedicated Eve Online section of the profile settings. Under that, there are spaces to enter the User ID/limited-api, along with the TS3 uniq Id for teamspeak registration. Then under that are lines that list which characters are associated with the userid/api. In addition, you can have those link back to the alliance/corp killboard.

Not only that, but it gives you the option to pull the avatar from eve and replace your uploaded avatar in phpbb. Under your avatar it also shows your total kills/losses and k/d ratio. Also your kills per month.

So what I'm curious about is if the info to do that is out there already, or if that's a custom job. Also, how difficult would that be to do?

Thanks very much to anyone who can answer that. I hope it stems from the use of this API mod.

---

Originally by: Carl Rannseier

---

Edited by: Carl Rannseier on 17/07/2010 03:13:30
Edited by: Carl Rannseier on 17/07/2010 03:02:08
@ Gerin Tell: I can't help ya here, i think for this you have to ask Cyerus. I actually think that you have to do all the work again cos he has rewritten pretty much all of the code so it might be easier setting it up from scratch again.

---

Quote:

---

General Error
SQL ERROR [ mysqli ]

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

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

---

Originally by: Tevoda

---

Edited by: Tevoda on 21/09/2010 23:11:17
Doh never mind. Too tired, forget to reload apache.

---

Originally by: FreakOfNature666

---

Originally by: Tevoda

---

Edited by: Tevoda on 21/09/2010 23:11:17
Doh never mind. Too tired, forget to reload apache.

---

lol, been there done that. On the bright side, at least you didn't restart sshd on a remote system over 1k miles away only to have sshd crash and never load back up. Second time that happened, I decided sshd was set up just fine the way it was.

Anyway, is there an ETA on the next version of this lovely mod?

---

Originally by: mazin mubinmiraj

---

I've done a significant amount of modification in order to get your mod working with PostgreSQL. Unfortunately, I have one minor problem: I can't seem to get avatars to display. The avatar file itself seems intact when downloaded, but phpBB doesn't seem to want to display the file correctly and the file itself seems odd though it has some semblance of JFIF header:


djpeg -verbose 2.jpeg
Independent JPEG Group's DJPEG, version 8b 16-May-2010
Copyright (C) 2010, Thomas G. Lane, Guido Vollbeding
Not a JPEG file: starts with 0x20 0x20

Any ideas?

---

Originally by: Greyfish

---

Greetings,
I sent this to Cyerus, but I know sometimes we get busy and dont log into the game so I thought posting here might help. I would like to thank anyone in advance for their help.

---

Originally by: Onyc Chick

---

Edited by: Onyc Chick on 08/10/2010 09:08:26
Just hoping someone can help with the problem I am having. Hopefully its just a box I havent ticked somewhere...

Basically the problem is with the avatars. Although I have enabled them in the ACP the UCP doesnt show the download your avatar option. The only place the option actually shows is in the ACP when I manually look at a member and then his avatar settings.

This basicaly means that users do not seem able to have the option to download their avatars but admins can do it for them...

Thanks for any pointers you guys can give me

---

Originally by: Motoko Oshii

---

Hi there.

I just installed this on my board, and I am having problems with the fact that SOME users' API keys aren't recognized as valid, while others are.

Can anyone provide some clarity here? Thanks! :)

---

Originally by: Donna Vecchi

---

Edited by: Donna Vecchi on 24/10/2010 02:24:21
I have installed this on a New board &
For the life of me I cant get the API fields to appear on the registration page.
I have activated the API Reg in 'User Registration Settings'
I have refreshed of everything in the Styles page, etc etc.....

Can you give me pointers to why its not work???

---

Originally by: Cyerus

---

Originally by: Donna Vecchi

---

Edited by: Donna Vecchi on 24/10/2010 02:24:21
I have installed this on a New board &
For the life of me I cant get the API fields to appear on the registration page.
I have activated the API Reg in 'User Registration Settings'
I have refreshed of everything in the Styles page, etc etc.....

Can you give me pointers to why its not work???

---

It should work with the ProSilver default style. If you are using another template, you need to edit that yourself using the included .xml file.

---

Originally by: LoegPose

---

Edited by: LoegPose on 25/10/2010 17:01:10
Ok so im in the process of moving forums from one server to another and are having big problems getting this mod to work.

First of i tried getting the mod going on the exsisting forum, when a new user hits submit the page goes blank and user is not add'd. i figured it might have been some **** gone wrong in the move from the old server to the new one, so i went a head and set up a new site, installed a freish copy of phpbb, uploaded the files from /pre-edit/ and /new files/ folder to my forum, then add'd the sql scripts the the db, and still, im getting the blank page when hitting submit.

i have no other issues with the server what, and when i disable the api mod i am able to register users just fine.

anyone have any clue as to whats going on? im having a hard time working out wtf to do about this one.

---

Originally by: Onyc Chick

---

Edited by: Onyc Chick on 07/11/2010 09:27:44
Ok things are getting real messy atm. Ever since the last patch i have had 2 instances where the 1st time a handful of members lost registration with a reason: Invalid API credentials. Today Sunday 1:00am all members have lost access with the same reason. I have the cron run every 2 hours (the reports are successful) and my users arent changing their APIs.

Does anyone know why this is happening ?

---

Originally by: Krusty McNugget

---

Originally by: LoegPose

---

Edited by: LoegPose on 25/10/2010 17:01:10
Ok so im in the process of moving forums from one server to another and are having big problems getting this mod to work.

First of i tried getting the mod going on the exsisting forum, when a new user hits submit the page goes blank and user is not add'd. i figured it might have been some **** gone wrong in the move from the old server to the new one, so i went a head and set up a new site, installed a freish copy of phpbb, uploaded the files from /pre-edit/ and /new files/ folder to my forum, then add'd the sql scripts the the db, and still, im getting the blank page when hitting submit.

i have no other issues with the server what, and when i disable the api mod i am able to register users just fine.

anyone have any clue as to whats going on? im having a hard time working out wtf to do about this one.

---

Got in touch with cyrous ingame, he jumped in ts3 with me and help me with my problem, its all fixed and good now, turns out you need curl to run this, and i was missing it. :) install now and all is working beutifully.

Thanks again!

---

Originally by: Krusty McNugget

---

Edited by: Krusty McNugget on 07/11/2010 14:15:36

Originally by: Onyc Chick

---

Edited by: Onyc Chick on 07/11/2010 09:27:44
Ok things are getting real messy atm. Ever since the last patch i have had 2 instances where the 1st time a handful of members lost registration with a reason: Invalid API credentials. Today Sunday 1:00am all members have lost access with the same reason. I have the cron run every 2 hours (the reports are successful) and my users arent changing their APIs.

Does anyone know why this is happening ?

---

Same happend here.

Acording to the dev. this happens when the script does the check during server dt.

---

Originally by: BeanBagKing

---

Download link (http://87.253.139.8/phpBB%20API%20Mod%204.0.zip) is giving me a "The page cannot be found" error.

---

Originally by: Migo Gemcrusher

---

i have instaled this in my phpbb3 forum 3.0.7-PL1 but when i try to update it for 3.0.8 i receive this errors when i try to update mysql database:

Notice: Undefined index: api_userid in /home/..../public_html/includes/functions_user.php on line 300

Notice: Undefined index: api_limitedkey in /home/..../public_html/includes/functions_user.php on line 301

Fatal error: in /home/..../public_html/includes/db/dbal.php on line 694

can anyone help me resolve this?

---

Originally by: Dvorak Telemnar

---

Edited by: Dvorak Telemnar on 21/12/2010 19:49:12
Thank you greatly for updating the MOD.

This is the first time I am using it and phpBB (clean install) so please excuse any ignorant questions.

I have 3 issues that I can't seem to solve :
1) When adding API credentials via User Administration; it always fails even if the credentials are correct and working (tested on EveMon and manual test using http://api.eve-online.com/account/AccountStatus.xml.aspx?userID=<user_id>&apiKey=<api_key>
Error message : "Warning: The API information you entered was invalid."

2) api_update.php regularly (most times) does not activate accounts and when it redirects to http://forum/ucp.php?mode=login&sid=very_long_number it is just a blank page.

3) For accounts that have managed to activate using their API's, their Eve Character Portrait is not coming up as their avatar and I can't seem to find where to fix that.

Is there any documentation for the MOD as to what it does and does not do and how to configure it?

I would appreciate any help I can get.

Running on Apache 2 with PhP5 and MySQL standard install on Ubuntu 10.10 and register_globals turned off (default)

Tested with IE, firefox (windows & linux) and IGB.

---

Originally by: Cyerus

---

1.) Recheck the settings for the API check. Usually (95% of the cases) it's either a typo or lowercase/uppercase problem in the name of the corporation / alliance.
Be sure it is written EXACTLY the same as ingame.

2.) Blank page is not good, but if you recheck step 1, it could be fixed. Try and please reply back.

3.) Under Avatar settings, enable Avatars in general, enable EVE avatars and, because of a small bug, enable the ability to upload avatars. This should bring up the Avatar options in the User CP.~Cy

---

Quote:

---

switch($config['api_validation'])
{
case 1:
$corp = (string) $xml->result->corporationName;
if($corp == $config['api_entity'])
{
cronlog("Succesful", $row['username']);
eveapi_accountmgt($row, true, 0);
return true;
}
else
{
if(!$config['api_nm_register'])
{
cronlog("User not part of correct corporation", $row['username']);
eveapi_accountmgt($row, false, 6);
return false;
}
else
{
cronlog("Succesful -> Non-Member override", $row['username']);
eveapi_accountmgt($row, false, 0);
return true;
// original line eveapi_accountmgt($row, true, 0);

}
}

---

Quote:

---

if($nr == 5)
{
//disabling account
//cronlog("Disabling account", $row['username']);
//$sql = "UPDATE " . USERS_TABLE . "
//SET user_type = '1', user_inactive_reason = '" . $nr . "', user_inactive_time = '" . time() . "'
//WHERE user_id = '" . $row['user_id'] . "'";
//$db->sql_query($sql);
//cronlog("Account disabled", $row['username']);
}

---

Originally by: Demitrios

---

Edited by: Demitrios on 25/12/2010 01:50:59
Fixed my problem, needed to disable "Allow non-member registration", this then puts non corpies into the non corp group.

Going to check how this affects people that join the fourm to post in the recruitment section.

EDIT:

Character is not a member of the corporation "Di-Tron Heavy Industries"

So i'd say this is a bug, as it overrides putting the person in the non member group, and the only fix is to disable non corp registerations.

Thanks for the mod :).

Demi

---

Originally by: Dvorak Telemnar

---

Originally by: Cyerus

---

1.) Recheck the settings for the API check. Usually (95% of the cases) it's either a typo or lowercase/uppercase problem in the name of the corporation / alliance.
Be sure it is written EXACTLY the same as ingame.

2.) Blank page is not good, but if you recheck step 1, it could be fixed. Try and please reply back.

3.) Under Avatar settings, enable Avatars in general, enable EVE avatars and, because of a small bug, enable the ability to upload avatars. This should bring up the Avatar options in the User CP.~Cy

---

I have confirmed that the corp name is spelt correctly and exactly as in game.
I have enabled everything to do with avatars I could find

Still no luck. Anything else I could check?

---

Originally by: Paris vonTroja

---

Is there any possibility to move a char in corp/alli in several usergroups automatically?
Next question, is it planned to identify directors and CEO to move them in special groups? perhaps in a next step dependent on given title?

---

Originally by: Cyerus

---

Originally by: Demitrios

---

Edited by: Demitrios on 25/12/2010 01:50:59
Fixed my problem, needed to disable "Allow non-member registration", this then puts non corpies into the non corp group.

Going to check how this affects people that join the fourm to post in the recruitment section.

EDIT:

Character is not a member of the corporation "Di-Tron Heavy Industries"

So i'd say this is a bug, as it overrides putting the person in the non member group, and the only fix is to disable non corp registerations.

Thanks for the mod :).

Demi

---

I don't understand what you mean exactly.
The whole concept of the non-members registration is to allow everybody who has working API information to register on the forums. People without an EVE account, basicly without valid API information, will still not be able to create an account if the API mod is enabled. On the other hand, who of that group would ever use this mod.

So that brings us back. I've scatched different situations and on what the current outcome should be. Please tell me which situation you use(d) and if the outcome you got matches the one on my list.

Situations scatch -> http://eve-it.org/situations.png

---

Originally by: Cyerus

---

Originally by: Dvorak Telemnar

---

Originally by: Cyerus

---

1.) Recheck the settings for the API check. Usually (95% of the cases) it's either a typo or lowercase/uppercase problem in the name of the corporation / alliance.
Be sure it is written EXACTLY the same as ingame.

2.) Blank page is not good, but if you recheck step 1, it could be fixed. Try and please reply back.

3.) Under Avatar settings, enable Avatars in general, enable EVE avatars and, because of a small bug, enable the ability to upload avatars. This should bring up the Avatar options in the User CP.~Cy

---

I have confirmed that the corp name is spelt correctly and exactly as in game.
I have enabled everything to do with avatars I could find

Still no luck. Anything else I could check?

---

Contact me ingame, seems this is one of those bugs I need far more detailed information about :)
Oh, before I forget, are you using my premodded files?

---

Originally by: Steph Wing

---

So uh...after installing, registration fails and returns "The value you entered is too short."

Did I do something wrong? Anybody got a fix?

---

Originally by: Labrena

---

I think I found a bug.

When updating an API (api_update.php)

It does not check and make sure the user is in the appropriate groups and add them if not.

Example:
Old member returns to corp, re-activates their account with new API info via api_update.php.

Their acct is enabled, but not added to the group. Running the cron job after that, does not add user to correct group either.

---

Originally by: Drake Draconis

---

Still cannot update my forums DB or files or the Mod due to a paradox with the update itself.

I would appreciate help because this patch closes some security holes.

Reinstalling the DB would be unacceptable.

I got 170 Members + who would not like having to re-do the whole damn account business.

---

Originally by: Norjia Blacksteel

---

Edited by: Norjia Blacksteel on 11/01/2011 03:14:15
My cron job doesn't seem to run at all. One of our members created his account, which worked, then invalidated his limited API to test the cron. Nothing has happened in 72 hours. He can still log in and see all the private boards.

ETA: Ok, I get it. I have to run the cron by hitting the page. Sorry about that!

---

Originally by: Drake Draconis

---

Edited by: Drake Draconis on 11/01/2011 06:40:48
Edited by: Drake Draconis on 11/01/2011 06:40:17

Check earlier posts *in this thread*... I think I posted a way to run the script automatically.

Requires SSH access however. Others have since improved it...

---

Originally by: Drake Draconis

---

Still cannot update my forums DB or files or the Mod due to a paradox with the update itself.
I would appreciate help because this patch closes some security holes.
Reinstalling the DB would be unacceptable.
I got 170 Members + who would not like having to re-do the whole damn account business.

---

Originally by: Steph Wing

---

Is this mod not compatible with some themes? I can't get it to work with any except the default Prosilver.

---

Originally by: Demitrios

---

Edited by: Demitrios on 12/01/2011 19:27:55

Originally by: Drake Draconis

---

Still cannot update my forums DB or files or the Mod due to a paradox with the update itself.
I would appreciate help because this patch closes some security holes.
Reinstalling the DB would be unacceptable.
I got 170 Members + who would not like having to re-do the whole damn account business.

---

Go through with the update, telling it to trash all the modifications, then re-add them after its installed.

Was the only way i could make sure i was getting the new version of phpbb.

You can thank the lazy guys at phpbb for not making a propper modding system like EDK for this. (editing core core = pants on head ******ed)

Plus i spoke to him on Sunday, and he was busy at looking at the code to fix the bugs, so he hasnt gone mia, just afk :).

---

Originally by: Cyerus

---

Version 4.3 released with the following fixes:

- Fixed all the group settings for the api_cron script.
- Added a file to (hopefully) make it possible for users to have a "simple" mean of updating their board.

---

Originally by: Labrena

---

Originally by: Cyerus

---

Version 4.3 released with the following fixes:

- Fixed all the group settings for the api_cron script.
- Added a file to (hopefully) make it possible for users to have a "simple" mean of updating their board.

---

I believe this is a bug:

User has account got deactivated due to bad API.
api_update.php corrected
User acct still disabled, api_cron.php does not correct it either, since it skips disabled accounts.

---

Originally by: Cyerus

---

Are you sure that the character you've tested is suppose to be active by the settings you've set?

---

Originally by: Labrena

---

Originally by: Cyerus

---

Are you sure that the character you've tested is suppose to be active by the settings you've set?

---

Yes, this is what I did.

User with correct API / correct groups.
- Changed the API
- Ran api_cron.php
- Removed user from groups, and disabled account
- Ran api_update.php with correct API
- Account was left disabled, but had correct API

---

Originally by: Cyerus

---

Originally by: Labrena

---

Originally by: Cyerus

---

Are you sure that the character you've tested is suppose to be active by the settings you've set?

---

Yes, this is what I did.

User with correct API / correct groups.
- Changed the API
- Ran api_cron.php
- Removed user from groups, and disabled account
- Ran api_update.php with correct API
- Account was left disabled, but had correct API

---

You didn't understand my question correctly.
Is the character, according to the settings you have set, allowed to have an active account on the forum?
If he/she has, I need to know every single API setting you've set and also the name of the character you are trying to add.

---

Originally by: Labrena

---

Sorry.

I have it set to allow non-members to register.

I've tried with both an in corp and out of corp characters, both with the same result.

The API does get updated, but the 1 is not changed to a 0 in user_type enabling the account.

Everything else is working fine. Same issue with 4.2/4.3/4.4.

I just noticed, that after putting in the correct API, it says "You have been successfully logged in." then goes back to the api_update.php page.

Also, if I try to send the re-activation email, I get this message:
"Your account has been manually deactivated and is only able to be reactivated by an administrator."

---

Originally by: Shoot2kilI

---

Did anything change as far as the API system with the recent patch? My board is now failing to retrieve player avatars, or really do anything that requires the API. Cyerus, appreciate all the work you've done.

---

Originally by: Cyerus

---

Open "include/auth.php", go to line 946.
Should say; $eve_api_row['user_type'] = 0;

Change that to; $eve_api_row['user_type'] = 5;

Let me know if that does the trick.

---

Originally by: Swanny231

---

Warning

It was not possible to determine the dimensions of the image.
The submitted avatar is 0 pixels wide and 0 pixels high. Avatars must be at least 64 pixels wide and 64 pixels high, but no larger than 256 pixels wide and 256 pixels high.

Any help would rock.

---

Quote:

---

function getAvatar($id, $user_id = false)
{
global $config, $user, $phpbb_root_path;
$user_id = ($user_id) ? $user_id : $user->data['user_id'];
$input = 'http://img.eve.is/serv.asp?s=256&c=' . $id;

---

Quote:

---

$input = 'http://image.eveonline.com/Character/'.$id.'_128.jpg';

---

Originally by: WereWolfik

---

Edited by: WereWolfik on 21/01/2011 21:01:44
Edited by: WereWolfik on 21/01/2011 20:29:18
So if you enabled uploaded avatars + eve its working good? And only eve avatars don't work?

I have only problem if disable all options and only enable eve avatars

---

Quote:

---

General Error
SQL ERROR [ mysqli ]

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

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

---

Originally by: Demitrios

---

Did you import the SQL file into the database?

---

Quote:

---

SQL query:

# EVE API start
ALTER TABLE phpbb_users ADD COLUMN api_userid VARCHAR( 10 ) NOT NULL DEFAULT '' AFTER user_form_salt;

MySQL said: Documentation
#1060 - Duplicate column name 'api_userid'

---

Originally by: Lord Frost

---

Edited by: Lord Frost on 23/01/2011 00:25:51

EDIT:::: okay, I got another step further, but now it's not showing the avatars. I get this message when I try and download character portrait...

Quote:

---

It was not possible to determine the dimensions of the image.
The submitted avatar is 0 pixels wide and 0 pixels high. Avatars must be at least 20 pixels wide and 20 pixels high, but no larger than 128 pixels wide and 128 pixels high.

---

I played with the admin settings on that, and still all the same error message.

---

Originally by: WereWolfik

---

look for this post

---

Quote:

---

General Error SQL ERROR [ mysqli ] Unknown column 'api_userid' in 'field list' [1054] An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

---

Originally by: Flirvutus

---

Hi I'm getting

Quote:

---

General Error SQL ERROR [ mysqli ] Unknown column 'api_userid' in 'field list' [1054] An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

---

I know that this means I need to update the database with the files in the SQL directory of the phpBB API MOD 4.4 folder, however, I am unsure as to the method of doing this. I have found a "Database" section on my phpBB ACP control panel, but my only options are: Backup, Restore, and Search Index. I've tried to search around on to find out how exactly to "update your database with additional queries" with no luck. A detailed explanation on how to do this would be great.

So far I've used a fresh install of phpBB3, the phpBB API MOD 4.4 pre_edit files, and I'm just stuck at this part about adding the SQL to the database. Thanks.

---

Originally by: Carl Rannseier

---

Edited by: Carl Rannseier on 17/07/2010 03:13:30
Edited by: Carl Rannseier on 17/07/2010 03:02:08
@ Gerin Tell: I can't help ya here, i think for this you have to ask Cyerus. I actually think that you have to do all the work again cos he has rewritten pretty much all of the code so it might be easier setting it up from scratch again.

@DiLantius: You have to update your board template if you want those functions to work properly. The mod ships with the prosilver template only so this is the only one that actually works when you initially install it. The files that need to be modified are:

• prosilver based templates
• posting_buttons.html
• ucp_avatar_options.html
• ucp_profile_reg_details.html
• ucp_register.html
• subsilver2 based templates
• posting_buttons.html
• ucp_profile_avatar.html
• ucp_profile_reg_details.html
• ucp_register.html

You can tell what style was used to create the one you are using by looking up those files in the "phpbb/styles/<your_style>/template" folder. check if there is either ucp_avatar_options.html (prosilver) or ucp_profile_avatar.html (subsilver2). To check this you can simply use the acp, go to the styles tab -> templates -> edit the style you are using. there you get a dropdown box that offers you all files within that template. you can also modify it there althouh a proper editor would perform better.

If it is prosilver based then simply follow the steps that can be found in the install_api_registration_4.0.xml file. it's well structured and easy to read. For a subsilver based style i don't have any instructions ready but you can contact me ingame and we can figure out how to get your board running correctly with this mod.

---

Originally by: Macaya

---

Edited by: Macaya on 07/02/2011 17:43:53
Getting this error when trying to import the default.sql :

Error

SQL query:

# EVE API start
ALTER TABLE phpbb_users ADD COLUMN api_userid VARCHAR( 10 ) NOT NULL DEFAULT '' AFTER user_form_salt;

MySQL said: Documentation
#1146 - Table 'forum.phpbb_users' doesn't exist

---

Originally by: Drake Draconis

---

The new API changes that CCP announced... are you going to factor those in in a future update?

---

Originally by: Mewzz

---

Ok i've uploaded everything from a clean install. The php sql wouldnt let me load it so i had to input the info manually in php admin the problem i have is that when i put an API in my profile i get:

The API information you entered was invalid.

Idk why i get that cause i copy and pasted my info exactly.

---

Originally by: PryMary

---

Hi there,

I am trying to get the BB codes to work with the Advanced BBCode MOD for PHPbb3 but I can't for the life of me work out how to go about adding them. Would I have to do this in the ACP in the custom bbcode area, or would I have to modify the Advanced BB Code Box files directly? As I would really like to be able to still link in EVE System's & Items.

Apart from this everything works fine and dandy TY :)

Link to MOD: Click Here

TY ♥

---

Originally by: Ikki Phoenix

---

Anyone has an idea why the software tells me that the API I entered is invalid. I checked my corp and it is the correct one.

Thanks

---

Originally by: Drake Draconis

---

Edited by: Drake Draconis on 07/03/2011 04:32:36
Your requested link - API Updates forthcoming

Cyerus - The Update script fails/crashes when I try to use it... your instructions don't say where to put it let alone what it expects... so clarification would help....

Warning: include(./common.php) [function.include]: failed to open stream: No such file or directory in ****removed****/install/new_files/update307pl1to308.php on line 6

Warning: include() [function.include]: Failed opening './common.php' for inclusion (include_path='.:/usr/lib/php5') in ****removed****/install/new_files/update307pl1to308.php on line 6

Fatal error: Call to a member function session_begin() on a non-object in ****removed****/install/new_files/update307pl1to308.php on line 9

---

Originally by: Cyerus

---

Edited by: Cyerus on 08/03/2011 01:49:25

Originally by: Drake Draconis

---

Edited by: Drake Draconis on 07/03/2011 04:32:36
Your requested link - API Updates forthcoming

Cyerus - The Update script fails/crashes when I try to use it... your instructions don't say where to put it let alone what it expects... so clarification would help....

Warning: include(./common.php) [function.include]: failed to open stream: No such file or directory in ****removed****/install/new_files/update307pl1to308.php on line 6

Warning: include() [function.include]: Failed opening './common.php' for inclusion (include_path='.:/usr/lib/php5') in ****removed****/install/new_files/update307pl1to308.php on line 6

Fatal error: Call to a member function session_begin() on a non-object in ****removed****/install/new_files/update307pl1to308.php on line 9

---

The script has to be placed in the root directory of your forum.
Instructions on how to use it can be found here.

---

Quote:

---

$ch = curl_init();

---

Originally by: Drake Draconis

---

OK...update took.

But I suspect something is funny funny with the API checking script.
The system is booting accounts known to be valid and OK.

Any way to verify that everything is ok?

Some sort of test or manual start to see if the system is successfully working?

---

Originally by: FASTTRACKS0

---

Getting a blank page after api info entered and submitted at either initial registration or an update to the user profile in the ACP.

Fresh install of phpbb3 3.0.8 mod ver 4.4 downloaded yesterday. Followed all instructions.

Steps taken
*installed phpbb3 board.
*created test user (non-admin)
*verified users can create accounts and login
*no errors on the forum at all.
-
*Copied all from the pre_edit folder and merged with phpbb3 files.
*Copied all from new_files to phpbb3 directory.
*Logged into phpmyadmin and imported each sql file successfully; all (3).
*cleared phpbb3 cache files.

Issue: When a new user registers (entering api info) and submitting a blank page is displayed. The user also isn't registered nor are errors generated.

This is also the case for existing accounts when the api info is added to the user info in the acp.

Any ideas? Thanks.

---

Originally by: Kerark

---

Edited by: Kerark on 14/03/2011 20:20:02
Was there ever found a solution for subsilver2 based themes?

Or do I have to go get a prosilver based one? (Damn, I just tweaked this one to look nice)

---

Originally by: Cyerus

---

Subsilver2 based themes work correctly, altho they need a bit more work compared to the prosilver ones. By that I mean that the Subsilver2 uses different html tags than Prosilver and hence need to be changed to match that.
Other then that, any subsilver2 / prosilver based template should work correctly.

---

1. How often I should program cron run on: api_cron.php file?
2. I experience follwoing error while trying to get Character avatar via ticking "Use Character Portrait:"