|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Cyerus
|
Posted - 2010.04.18 20:56:00 -
[1]
Current Version - 3.0 Released April 18, 2010
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: Only follow the Copy instructions if you don't have mods already installed. Otherwise, follow the manual edit directions.
Also, be sure to open the installation XML file in Firefox. IE incorrectly assumes there's a problem with the XML. NOTE: Currently I'm not yet finished with the
Link #1: phpBB 3.0.7-PL1 + API Mod v3.0 Link #2: API Mod v3.0 only [soon]
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
|
Posted - 2010.04.18 21:04:00 -
[2]
Placeholder for changelog, etc.
|
Cyerus
|
Posted - 2010.04.19 02:19:00 -
[3]
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.
OR use this link to download a pre-modified schema_data.sql
|
Cyerus
|
Posted - 2010.04.19 18:23:00 -
[4]
Fixed the link :)
|
Cyerus
|
Posted - 2010.04.22 12:14:00 -
[5]
Originally by: Lompen any updates on the release of the mod only?
I'm sorry, what do you mean exactly?
|
Cyerus
|
Posted - 2010.05.05 02:24:00 -
[6]
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?
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.05.12 03:51:00 -
[7]
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.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.05.22 01:30:00 -
[8]
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.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.05.22 17:50:00 -
[9]
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.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.05.26 16:45:00 -
[10]
I have no clue. The package should work if set up correctly.
Have you had any problems with PHPBB 3.x itself running on your webhost?
|
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.05.28 07:55:00 -
[11]
Beani Kliadi:
Thank you for the tests. I'm about to release an update to the mod, both full version and ModX. This will address issues in the overalls tability and rewritten major part of the old code, including api_cron.php
I would like you to contact me as soon as you read this post, to check why the mod is not working for you while it is for me.
Alliance/corp information is updated once every hour on the EVE-API server. However the test to check if the API key is valid should work within the second.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.05.28 15:08:00 -
[12]
Edited by: Cyerus on 28/05/2010 15:15:15 API-MOD updated to version 4. Included are 2 BBcodes designed for the IGB. Lots of bug small fixes aswell.
Oh, and ModX :)
See topicstart post for updated links. And yes, the link works, altho at this moment the Eve Forum VIRUS LINK WARNING screen doesn't... ps. Read the readme.txt file!
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.06.01 15:39:00 -
[13]
Just a bump and question if any might have found a bug.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.06.14 21:50:00 -
[14]
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.
I can't just check on character, it's the full package. If you supplied the correct information the API should pop up. If not, the page doesn't show. -> Nothing for me to change on that.
If I have the time, I will check on the issue with the "allow non-alliance members". Yet why don't you set the API check to "None"?
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.06.16 08:14:00 -
[15]
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-
You seem to be getting some weird PHP error, and I don't think it has anything to do with the api_cron.php script. The first lines states that the PHP opening tag isn't viewed correctly, are you sure you didn't change anything to the file?
To fix it you can try to redownload the package and replace the api_cron.php script with the one from the downloadfile.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.06.16 22:10:00 -
[16]
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
Thanks for the idea, will include that in a future release.
Originally by: MEXXDOR hi
bbcodes not work for all items --> PICTURE HERE
thx
Will be fixed in the next release -> 4.1
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?
The mod should work corerctly, I use the exact same code and haven't had any install / mod problem so far. I can set up some kind of test forum so you can see it in action if you like? Ofcourse no admin-panel access, but normal functions should be visible...
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?
If you set the non-alliance (or non-corp) group to guests, and the alliance / corp members group to registered users and delete the guest group from every private forum -> should work. Then just open 1 small forum pure and only for guests to see, having like a welcomepage explaining that a user needs to create an account to see the full forum, which will disappear after the user logged in ;)
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.06.18 00:33:00 -
[17]
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)?
Would you mind emailing the character/API information of the user giving a blank screen?
Answer to your second question is already answered in the MOD itself:
Quote: Entity: The name of the corporation or alliance in which membership is required.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.07.18 01:43:00 -
[18]
Let me take some time and answer some of your questions.
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.
Thanks for that bit of info, will be change din the future. Do note that currently it is relatively safe, considering 'regex' weeds out most of the damage.
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.
1. Some kind of database change/update PHP script will be created and released in the next update. (will take some time, to do proper testing).
2. I'm not sure what you are asking here?
3. I will add standings support to the forum in a later version (not scheduled for v5). A simple list of corps/alliance to get access will however not be created, I'm thinking more of an on/off function with a numeric value of the standings a corp/alliance should at least have.
..and thanks for the kind words.
Originally by: Agent Unknown Link is broken. Please host it again...I need it.
Link works, hasn't changed since I uploaded it a while ago. You are probably trying to use an outdated version of the mod. Be sure to check the topic startpost to get updated information, including links.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.07.18 02:13:00 -
[19]
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!
Hhhmm, where to start. I suggest you download a 'clean' phpBB 3.0.7-PL1 pack from phpbb.com and read the instructions I've posted to mod the files.
The database on the other hand doesn't need much work. You should compare my DB-edits witht he ones from 2.1.1, and remove what is already done. I'm pretty sure I didn't change anything in the way 2.1.1 was editing the phpbb_users table, so you can ignore those. Besides that just add the ones that weren't in 2.1.1, and you should be fine.
This is a very very very short 'guide', can provide live-help if needed.
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.
This mod is intended to add API verification to phpBB forums. Besides that, I added extra features specially made for either the ingame browser, or automated adminitration processes. Besides that, I'm aiming for a stable, easy-installable mod that is carefully tested before released.
I'm sure the other items you named are a custom job. Some of those features will be integrated in the mod, and others won't. Can't release more information on this subject at this point.
I would rather not spend development/testing time on custom jobs while releasing it to the public a month later. However, if you feel/need it ASAP, feel free to contact me.
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.
Wrong, no need to rewrite it again. The way 2.1.1 and older were setup wasn't supporting major use. I just converted (read: rewritten) the functions to support phpBB internal functions and/or high usage. It's setup to relativly easy add new features.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.09.06 00:33:00 -
[20]
Vacation is over, school started. Next weeks I'll release a new version.
If you have any issue that is still unresolved (or unanswered), please let me know and I'll get back to you as soon as I can. Ingame mail preferred.
~Cyerus
|
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.09.21 22:39:00 -
[21]
It appears cURL is not installed properly, or not configured properly in the php.ini file. Either way, PHP doesn't recognize the function curl_init(), which suggest you need to doublecheck your settings.
Would you mind, just to be sure, to give me a link to a page showing phpinfo()?
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.10.14 20:12:00 -
[22]
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?
No clue, you might want to contact CCP about what them, I just copy/paste basicly.
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.
I think I have answered you ingame, if not, hereby. I would like you to email me the charactername of the person (or multiple people) getting this error. I think I know what's wrong, just want to doublecheck.
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
2 options you need to set: - Enable Avatars - Enable EVE Avatars
Work for me with both enabled.
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! :)
Please contact me by ingame chat. Demitrios; you to if possible.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.10.24 03:17:00 -
[23]
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.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.11.14 02:42:00 -
[24]
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!
Only "major" difference in the use of functions between my mod and a "clean" forum is the use of cURL. YOu can simply check whether you have it on your webhost by searching for cURL in the phpinfo() page.
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.
Indeed, the cronjob doesn't take into account the downtime of the server. New version does, and will be released soon. Easy fix is to set the API check 12 hours different from the scheduled downtime (for instance 1am servertime), since EVE haven't been offline for nearly as long as that. Detailed information of the process during downtime; CheckAPI ---api.eveonline.com--> 404 --search for alliance/corp tag--> not found, being empty "" --compare with presetup one--> no match, meaning not in corp/alliance --disable account--> account disabled :)
Fix is in next release.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.11.24 14:22:00 -
[25]
I took the file temp. offline for the following reasons:
* phpBB 3.0.8 release was near, hence has been released few days back * Going to release 4.2 of the mod for phpBB 3.0.8 as one big package again
If you really really really want 4.0 for phpBB 3.0.7-PL1, sent me an ingame mail, altho expect to update it to 4.2 soon enough.
~Cy
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.12.21 00:33:00 -
[26]
4.2 for phpBB 3.0.8 released into the wild :D
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.12.21 22:28:00 -
[27]
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.
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.
Hope it helps.
~Cy
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.12.25 02:53:00 -
[28]
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
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.12.25 03:06:00 -
[29]
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: 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?
Multiple groups? No. Frankly no need for, every person can be set with the 1 member group. Identifying directors / CEOs is hard, since atm. the API information from CCP doesn't correctly include titles. So when set by a title, there's just no way to check it at this point.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2010.12.30 03:40:00 -
[30]
Demi,
If possible I would like to have a voicechat session with you about the problems you currently have, and also about the features you might like to have added in the future.
Contact me by ingame mail to work out a place and time.
~Cy
|
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.01.12 22:01:00 -
[31]
Just to clarify;
I'm not MIA nor afk. I'm working on this mod in my spare time, basicly dividing time between school, work and EVE.
The problem with phpBB, as Demitrios has already pointed out, is that's it's not having any modding engine at all. You may ask, what's the difference? Let me try to explain.
Normally when you are talking about a moddable application, it's consists of 1 Core and 0 to infinite Modules. The Core is basicly the inner workings of the program, like where/how the data is saved, connections, etc, basicly all the most important stuff that you shouldn't mess with. On the other hand we have modules (MODs). These mods are made to add additional funtionality to the program (Core). Some people would like to have a most clean version and have enough functionality using the Core only, other people would like tons of more functionality and thus rely on a ton of MODs.
This explained, you should now know that phpBB is setup as a Core package without any engine to allow mods. This means that to add functionality, we need to change key parts in the Core with the possiblity of destroying the whole script. While you may think that this isn't bad yet, imagine the person who wants 2+ mods on his phpBB, meaning he has to change the Core for each mod.When you've reached mod nr. 5, you wouldn't even know what you changed when you did nr. 2.
For instance, take the BBcodes in phpBB. You can easily add a simple replacement piece of BBcode into phpBB, like adding a certain smilie or the simple code to make text underlined. What it can't do however, is do things more advanced then that. So let's say I want to check the database and return some text, it falls under scripting and you'll need to change about 8 different sections of code in the Core.
Basicly, the best outcome would be if phpBB would make an MOD engine where instead of having to change the Core files, I would only have to supply you with a certain mod package that automaticly installs in a seperate directory, that once enabled is being used to double check everything.
Would gives us; - No more problems into updating our forums - No more different versions for different updates of phpBB - Far easier to manage
which will hopefully result into far more happy ppl.
~Cy
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.01.15 18:09:00 -
[32]
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. *NOTE!: Should be said the script is untested, but with good backups nothing can go unrepaired.
So, if you are still using 3.0.7-PL1 with the EVE API MOD, and want to update to 3.0.8; read on. Else, stop reading!
1. Backup your forum before even attempting to upload the "update307pl1to308.php" script. 2. Disable the board so no users are able to do anything while you are busy with the script. 3. Run the script (should only take seconds). Once it's finished, you'll read something like: "Step 1 completed". 4. Now update the forum using the normal phpBB update package. 5. Once your board is fully updated, install my 3.0.8 mod files by uploading the files in 'new_files' and 'pre_edit'. SQL is NOT NEEDED! 6. Now run the 'update307pl1to308.php' script again, after a few seconds it should say "Step 2 completed". 7. Delete 'update307pl1to308.php' from your forum and on you go.
If you have used this script, or are willing to risk using it, contact me by ingame evemail. I'll provide you with help with the script untill I'm statisfied it's working correctly. Nonetheless, be sure by triplechecking that you do have a functioning backup before attempting anything.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.01.16 15:32:00 -
[33]
Version 4.4 released.
-Updated and tested the 3.0.7-PL1 to 3.0.8 update script on my own forum, and now works like a charms. Follow the instructions I've posted few messages back, and you should be fine. If not, evemail me.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.01.16 17:12:00 -
[34]
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.
I've tested this myself, seems to work correctly.
I've changed the API settings in the DB, basicly making them invalid. api_cron.php disabled the account. Used api_update.php, and filled in the correct (working) API information, along with the charactername and the correct password. Account was made active again. Ran api_cron.php again, account was in the list as being (and staying) active, like it should.
Are you sure that the character you've tested is suppose to be active by the settings you've set?
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.01.16 19:34:00 -
[35]
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.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.01.20 21:46:00 -
[36]
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."
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: 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.
Seems to work for me tho. Just tested the api_cron script, seems to correctly grab all the info from the EVE API.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.01.26 01:02:00 -
[37]
Has anybody used my update script yet?
Update to fix avatars will be released in a few days.
~Cy
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.01.27 19:52:00 -
[38]
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.
You have to use an application like phpMyAdmin to update your database using the provided .sql files. Your webhost should either already have this installed, or you can do it yourself.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.02.17 00:47:00 -
[39]
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
You are using different (non-default) table names for your phpBB installation. In order for the SQL scripts to work, you need to manually change the 3 .sql files to match the table names youa re using.
Originally by: Drake Draconis The new API changes that CCP announced... are you going to factor those in in a future update?
Could you link me to the changes announcement, haven't seen that page yet. In any case I will update the script to match the API changes for the API MOD to continue working normally.
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.
It's the default error message you get, when; 1. The API details are wrong. 2. You are not part of the corp/alliance you have set up. 3. The EVE servers are down (eg. crash or daily downtime).
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 ♥
No, I will not make my mod compatible with that mod. Simple reason is that in my opinion my mod needs to stay clear, focussed and lightweight. However, if you really absolutely want it, I can take a look at it, altho it comes with a price.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.02.26 12:50:00 -
[40]
Try to contact me ingame, will be online most of the day tomorrow.
|
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.03.08 01:49:00 -
[41]
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.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.03.08 12:07:00 -
[42]
Ok, weird error indeed.
Unpack and upload all the files of THIS archieve into your phpBB forum. Then run the phpBB install script again to see if this time it updates correctly.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.03.15 18:18:00 -
[43]
Edited by: Cyerus on 15/03/2011 18:18:26
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?
There is no manual testing. The only thing to do is to wait for user's input and have the cronjob output logged. You could on the other hand set up a test alt and add / remove him from corp to check if that works correctly, although that requires much patience.
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.
Have you set all the settings yet (user registration settings, avatar settings and server settings)? Did you delete all cache? Are you using the default prosilver theme?
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)
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.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.03.22 23:23:00 -
[44]
Originally by: Tobe Confirmed
Originally by: Alucard Strat First of all good job. Package is almost perfect, tho it takes some level skill's to understand how it works and where what should be. (Thank god to good ERROR reporting)
I adapted this mod to our site g0ons.info/forum , it took me some time to get work but I still experience some problems. As I use custom theme I had to manually do the 4 file programming and move 2 new files via manual upload/copy to custom theme to get cron run perfectly. How ever I have few questions and maybe you can help me out.
- How often I should program cron run on: api_cron.php file?
- I experience follwoing error while trying to get Character avatar via ticking "Use Character Portrait:"
Thank you for your time and reply at advance.
Oddly enough, I get the same error. It seems that when the script is downloading jpg files for the avatars, it isn't properly forming them. Too tired to look into it so I will muck with it tomorrow.
Hopefully the creator has a fix :)
Avatars are fixed in version 4.5. Thought I already uploaded it, seems I was mistaken **sorry!!**.
Originally by: Tobe Confirmed Edited by: Tobe Confirmed on 22/03/2011 10:20:42 btw Cyerus, do you have your source code sitting in a repo somewhere for people who want to test the bleeding edge? And possibly even submit patches?
I haven't got any SVN up, I'm working from a local directory. After the changes are stable and working, I tag the differences using ExamDiff Pro (compare directories, newly bought license) and add them to the XML. I'm planning to work on options for standings- / faction warfare checking aswell, although put on a hold because of upcoming API changes.
Version 4.5 just released. Changed files compared to 4.4; includes\auth.php includes\function_user.php
* Avatars are working correctly now * api_update.php now correctly enables disabled accounts.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.03.22 23:46:00 -
[45]
Never used GIT before, don't seem to be any Windows clients for it. SVN is central based, so no local version control and hard to understand for the less-technical people.
So that brings us back to the current system we are using; pre-editted files and an XML for people with custom mods installed.
With this information, why change?
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.03.27 03:44:00 -
[46]
Originally by: Dvorak Telemnar Request/Suggestion
Have you considered making a "lite" version? Essentially only does the portrait and changes group membership depending on the characters corp/alliance with the option to disable accounts based on API calls that do not require a valid API such as https://api.eve-online.com/eve/CharacterInfo.xml.aspx?characterID=<CHAR_ID> ?
Also using "custom profile fields" and not changing any of the forum code or database? (I have a bastardised version of this on my forum for registration using the IGB which works well).
The 3 custom profile fields I use are "char_id", "char_corp" & "char_alliance" and the registration script adds a link to the character portrait from https://image.eveonline.com/Character/<char_id>_128.jpg which means any user portrait changes (CCP feature coming soon) are automagic :)
As I said, just an idea for a "lite" version for those who don't want/need all the bells & whistles :)
All the information we need is hidden behind the API keys. With the upcoming changes you mind be able to select which things fall under a key, removing the somewhat security issue of sharing more information then you want. The IGB is very unsafe and cannot be trusted whatsoever. The extra information fields that the IGB has can easily be duplicated by a few lines of code.
I'm against hotlinking of images, and so is CCP. The image needs to be cached on your webserver for an X amount of days, so you might as well save the image and let the user update the character picture whenever changes are made to his/her character.
The fields I use in the database are pretty much the same as those you mention as being custom profile fields. Problem with phpBB's update script is that it doesn't like database mods, although I'm already working on a solution to that..
The current featureset of the MOD I already call "lite".
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.03.27 03:56:00 -
[47]
*** SECURITY RELEASE ***
Fixed a few security flaws consisting in the api_update.php process. I urge you to update to v4.6 as soon as possible.
Changed files: * includes/auth.php
Due to the nature of this bug, the "Anonymous" user *can* have API information attached to it, which can only be removed manually from the database. Also, update the groups of the "Anonymous" account, which should consist *only* of a group named "guests".
If you have any questions about this, send me an ingame mail.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.03.29 22:16:00 -
[48]
Originally by: Varrun Excellent mod it work perfectly.
Any plans on allowing more than one corp (not in allaince) to be able to register to different groups?
Yes, I plan to, but that's the only information I can currently give you. With the upcoming changes to the API, I'll have to rethink whether or not using a framework to deal with the API details. On the other hand we have phpBB, I'm still waiting for some feedback on how to make certain features work. When I have more information I'll let you know.
On another note; I can set up some kind of hard-coded multi-corp setup for a small fee. This will work just the same way, except for having to change the source code to change the corps rather than changing it in the control panel. Ofcourse you'll have to manually do this mod everytime I release a change to the files used.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.03.30 23:44:00 -
[49]
Originally by: Squizz Caphinator Edited by: Squizz Caphinator on 30/03/2011 13:43:20 wow.. the pain you guys are going through...
save yourself the hassle and use http://evechatter.com or just download SMF and use ESAM
It is always fun to see troll replies like these.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.04.12 00:18:00 -
[50]
Originally by: P3k1 Hello,
Just finished moving phpBB forum to new hosting and I'm having problems with avatars. I only got the DB dump, so avatars were not moved from old forum.
Is there some php script or function that I can call to get all the users avatars?
Each user can go to their respective User Control Panels and update their own avatars. There is no way to do that from the Admin Control Panel.
|
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.04.15 17:10:00 -
[51]
Originally by: Cronabus I have just installed the mod and it is wonderful, thank you for you dedication to this project. When I add an item or system with the tags, they show up like they are a link and have the information button. When I mouse over or click on either, nothing happens, is this working as intended? If it is, could it be made to link the item/system on the Wiki(http://wiki.eveonline.com/en/)?
Use the ingame browser
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.04.15 18:14:00 -
[52]
Originally by: Kyle Cook Edited by: Kyle Cook on 15/04/2011 12:38:39 Hi,
Have to say amazing work, love it! I am having trouble putting the api_cron.php script into good use via the crontab though.
I installed a blank phpbb 3.0.8 forum, the latest mod and it all works, api validation etc and avatar linking ... the only thing is the cron script, which works just fine via a web browser but in cron I get this:
Quote: Warning: include(./common.php): failed to open stream: No such file or directory in /home/vtec/domains/vt-ec.co/public_html/forum/api_cron.php on line 7
Warning: include(./common.php): failed to open stream: No such file or directory in /home/vtec/domains/vt-ec.co/public_html/forum/api_cron.php on line 7
Warning: include(): Failed opening './common.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/vtec/domains/vt-ec.co/public_html/forum/api_cron.php on line 7
Warning: include(.//includes/functions_messenger.php): failed to open stream: No such file or directory in /home/vtec/domains/vt-ec.co/public_html/forum/api_cron.php on line 8
Warning: include(.//includes/functions_messenger.php): failed to open stream: No such file or directory in /home/vtec/domains/vt-ec.co/public_html/forum/api_cron.php on line 8
Warning: include(): Failed opening './/includes/functions_messenger.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/vtec/domains/vt-ec.co/public_html/forum/api_cron.php on line 8
Warning: include(.//includes/functions_user.php): failed to open stream: No such file or directory in /home/vtec/domains/vt-ec.co/public_html/forum/api_cron.php on line 9
Warning: include(.//includes/functions_user.php): failed to open stream: No such file or directory in /home/vtec/domains/vt-ec.co/public_html/forum/api_cron.php on line 9
Warning: include(): Failed opening './/includes/functions_user.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/vtec/domains/vt-ec.co/public_html/forum/api_cron.php on line 9
Fatal error: Call to a member function session_begin() on a non-object in /home/vtec/domains/vt-ec.co/public_html/forum/api_cron.php on line 12
Any ideas/pointers? my webhost is clueless.
The script is not meant to be a cronscript itself, it's meant to be run from browser. You can circumvent this by making the cronjob run the script by using php binary. In other words, to run the script every 12 hours by cronjob, use this;
00 00 * * * /usr/bin/php5 -q webdirectory/forum/api_cron.php 00 12 * * * /usr/bin/php5 -q webdirectory/forum/api_cron.php
Paths need to be changed to your situation ofc.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.04.28 16:50:00 -
[53]
Originally by: InSaNe ViRuS I am having a problem with this mod. I have it downloaded but I have no clue how to upload the files into the forum.
The same way you uploaded the phpBB files -> via ftp.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.05.27 23:42:00 -
[54]
Originally by: MJ Maverick Just curious, is there a demo of this anywhere? Or can someone provide some screenies or a link so I can see what it looks like? I don't surrently use PHPBB3
At this point no. I can make some screenshots of what it lookes like if you want -> send me an ingame mail.
Originally by: Faridi Dem Edited by: Faridi Dem on 23/05/2011 19:12:50 Edited by: Faridi Dem on 23/05/2011 19:10:16 iŠve updated to the newest version and i am getting the following error when i try to open the api_cron.php
Quote: Fatal error: Call to a member function attributes() on a non-object in /www/htdocs/w006cac8/testing2/forum/includes/functions_user.php on line 3505
any ideas? rest is working
I tried to contact you ingame, but for some reason it keeps saying "You are not allowed to contact this person.". Look at the previous post, perhaps this applies to you aswell.
Originally by: Awarga The download link isn't working?
I have no problems with the link.
Originally by: Ayumikata ...
Nice plugin!
Is it possible to have a run-down of what happens in case the users either has not supplied a key (registered before validation) and what happens when a user has left the corporation/alliance.
It depends on what your settings are. I can give you a rundown if you can tell me what settings your are using (either here or per evemail).
I'm planning on updating my blog to include changes and fixes on this mod. Hopefully, I will be able to create a simple grid (like Excel) to compare settings with outcome. It's on the to-do list, but can't give an estimate.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.06.04 02:05:00 -
[55]
Originally by: Nathan WAKE ...
Can you tell me if line 3525 in file 'includes/function_user.php' equals
$input = 'http://image.eveonline.com/Character/' . $id . '_256.jpg';
Also, can you doublecheck that the character you are trying to get the portrait on has filled in correct and working API settings?
Originally by: Faridi Dem nope, i couldnt fix the problem...it still shows the same error...i had the "blocked all unkwon contancts" on a few days ago. i will also try to get you ingame
I'm not sure what problem you have on the forum, to figure it out I would have to see it for myself. Perhaps we can schedule a TeamViewer session?
Originally by: Kisame Hirashi Hi there,
installed a fresh version of PHPBB 3.08 and installed your mod as per the instructions. All seemed to install fine, activated the mod and set it to alliance, but when a new user tries to register or I try and add my own api key, all we're getting is 'API key is invalid'.
Any suggestions?
There are two possible outcomes; 1 - The API are indeed invalid 2 - The user is not authorised to create an account using the settings you have set. Be sure to have entered the exact corporation / alliance name (capitals, punctuations).
Originally by: StyphonUK Hi, I've just done a fresh install of this, copied all the files over in the new files and pre edit folders and imported the three sql files but when importing the first 1 I get the following 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 #1060 - Duplicate column name 'api_userid'
What's up?
It appears you have either executed the SQL file twice, or you used a database which was already filled with data.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.06.23 00:45:00 -
[56]
Originally by: StyphonUK The problem was the name didn't match any of the account names, so the mod is working, however it needs to throw an error instead of just returning to the page with no instructions as to why the account isn't being created.
Will be fixed in the next verison, thanks for the TeamViewer session.
Originally by: Nathan WAKE To Cyerus
Forgot to mention publicly that your intervention helped me solve all my problems. It works like a charm !!
Thanks again.
Chears
Nathan
No problem Nathan. Both of his problems were fixed, had to do with his hybrid Joomla / phpBB setup.
Originally by: Nuramori Perhaps a bit tangential, but I was wondering if you could assist/add some functionality. What you have now works superbly and I thank and applaud you for your efforts.
I was wondering if you knew of, or could/would add to this validator the ability to also modify rights to teamspeak. While I know it's not directly relevant to phbb3, many of us that play eve use either TS2/3 or vent, and want to also manage access there.
Your validator is excellent and well done - and forums tend to be the FIRST step in gaining membership to a corp and alliance, so having one check point makes not only sense but eases the burden of managing things. So what would be great is if once your validator authenticates a member it not only sets rights on the forum, but also runs thru the client ID on the teamspeak DB and registers them there. Basically an addition of the teamspeak API thing that MJ Maverick has put out.
Just a thought since forums and comms go hand in hand with Eve gaming.
I can't say anything more then that it will be implemented in the soon future. However, this will be limited to TS 3 and Mumble, since TS 2 and Ventrilo don't support API scripted calls. Version 5 of the MOD will be the best one yet!
Originally by: Vevalius Kion bit of a problem...
would be good if you could edit your API info somewhere... or add it if the account doesn't have it already!
Important: The mod blocks admins from changing their username (even though they don't have their API on their account... and that is because there is nowhere to add it to a current account). Users also inform me they are unable to create an account at all due to "invalid api information".
Also a feature request:
Having pepole sign up from the corp would be put in one usergroup and if people sign up from the alliance they get put in another usergroup.
The ability to change (or add) API details on accounts is build it. "User Control Panel" -> "Profile" -> "Edit account settings". Adminwise, you can find it at the users profile using the Admin Control Panel.
Users should be able to change their usernames, if you have that option enabled in phpBB.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.06.28 17:40:00 -
[57]
Originally by: TheBooky Might I suggest that you change the comparisons to ID's rather than names since differences in spelling could take a few days of pain for new users. The only reason I realized that it was wrong is I had it echo the 2 values and it saw Of != of.
I will not be using the IDs (don't feel like implementing unnecessary steps), but I will change the checks to be lower case. In other words; Both the API gathered Corp/Alliance Name and the one filled in on the AdminCP will be transformed to lowercase, then checked against eachother.
Hope that will suffice.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.08.17 17:15:00 -
[58]
Edited by: Cyerus on 17/08/2011 17:16:11 Working on it.
*shame* I missed the whole 3.0.9 release due to vacation, now I'm trying to catch up. Working as fast as I can guys ;) Just hold with 3.0.8 for now, not many changes in 3.0.9 security wise.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.08.18 18:04:00 -
[59]
Originally by: EVEVERIFY Cashier
Originally by: Cyerus Edited by: Cyerus on 17/08/2011 17:16:11 Working on it.
*shame* I missed the whole 3.0.9 release due to vacation, now I'm trying to catch up. Working as fast as I can guys ;) Just hold with 3.0.8 for now, not many changes in 3.0.9 security wise.
I'm wondering about the coming changes to api keys and how it relates to this mod?
In theory nothing big would change. You still need an UserID / APIkey pare, although named slightly different.
Only difference is that the user will have the chance to select what information to share per UserID / APIkey pair. In other words, he will need to set Username, Corporation and Alliance information in there, else the mod will deny him/her access. When the changes are made final, I'll check out what permissions to set on the UserID / APIkey pair to have a fully functional check.
TL-DR: Nothing to worry about.
|
Cyerus
Galactic Dominion Eternal Strife
|
Posted - 2011.09.01 16:59:00 -
[60]
Originally by: Pattux Doesn't work with the new API (Incarna 1.1) system. The old API system does still work, but is deprecated.
Working on it, release will be tomorrow.
|
|
|
|
|