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

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

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

phpBB 3.x API Registration Mod v6+
Author
Previous Topic Next Topic
Nongrat
MOON 437
#341 - 2012-08-24 10:24:54 UTC
Cyerus wrote:

Confirmed bug, was able to reproduce the same results. Will be fixed in next release.
As a workaround, set the Corporation (or Alliance) entity as Default.

Ok, thank you.
BinaryData
The Scope
Gallente Federation
#342 - 2012-08-25 21:19:27 UTC  |  Edited by: BinaryData
Heya Cyerus,


I checked this out back when it was first in its baby form, and now that I'm back into setting forums & ts3's up for people. I'm having a bit of trouble.

I have AutoMOD installed, everything looks like its working, but when i go to add the API Key & Information, and click Register, it returns an SQL Error. Your tutorial on how to install the mod is confusing as hell, and rather annoying. Most of the time I had to figure things out the hard way, or pay a friend to help me with it. I'm fairly good with web stuff, but this confuses me.


Here is the Error I've received.


Quote:
Unknown column 'eveapi_keyid' in 'field list' [1054]


I'm assuming I didn't modify the database, but the question is, how did I not do this? And HOW do I fix it?


Thanks in Advance :)


Edit:

helps to import the SQL files. DERP.
Orian NiKunni
Orian's EvE Communications
#343 - 2012-08-26 06:46:04 UTC
dude, you've made some vast improvements with this, good job at sticking with it and improving on it!! Big smile
Orian NiKunni
Orian's EvE Communications
#344 - 2012-08-26 06:47:44 UTC
BinaryData wrote:


helps to import the SQL files.


very important Smile
Cyerus
University of Caille
Gallente Federation
#345 - 2012-08-26 15:41:36 UTC  |  Edited by: Cyerus
BinaryData wrote:
Heya Cyerus,


I checked this out back when it was first in its baby form, and now that I'm back into setting forums & ts3's up for people. I'm having a bit of trouble.

I have AutoMOD installed, everything looks like its working, but when i go to add the API Key & Information, and click Register, it returns an SQL Error. Your tutorial on how to install the mod is confusing as hell, and rather annoying. Most of the time I had to figure things out the hard way, or pay a friend to help me with it. I'm fairly good with web stuff, but this confuses me.


Here is the Error I've received.


Quote:
Unknown column 'eveapi_keyid' in 'field list' [1054]


I'm assuming I didn't modify the database, but the question is, how did I not do this? And HOW do I fix it?


Thanks in Advance :)


Edit:

helps to import the SQL files. DERP.


Orian NiKunni wrote:
BinaryData wrote:


helps to import the SQL files.


very important Smile


No, you must not use the SQL files.
I've made an install script instead, as explained in my guide (steps 3, 4 and 5).

If you are using the SQL files, you'll be missing the actual data, since it only holds the database tables, not the data itself. To check this, simply try to link Jita using the EVE System BBcode.

In my opinion the guide is pretty self-explanatory. I've however not made the guide "newb-friendly", since there are enough resources available (on google and the phpBB forums) to help you with AutoMOD and the scripts involved.

However, any pointers on how and why the guide is "confusing as hell" are welcome.


I've just noticed phpBB updated their forum package to 3.0.11
So instead of releasing 6.0.4, I'll be working on 6.1.0 to support phpBB 3.0.11

This release will feature a fix for the groups not being assigned correctly bug, as well as updating the database values to Inferno 1.2

Stay tuned.
Faldal Dartan
Sebiestor Tribe
Minmatar Republic
#346 - 2012-08-27 15:21:40 UTC
when I fetch the "eveapi_cron.php" I get this error:

Quote:

Fatal error: Uncaught exception 'TeamSpeak3_Helper_Exception' with message 'invalid URI supplied' in /var/www/vhosts/sp-solutions.de/httpdocs/forum/includes/eveapi/TeamSpeak3/Helper/Uri.php:133 Stack trace: #0 /var/www/vhosts/sp-solutions.de/httpdocs/forum/includes/eveapi/TeamSpeak3/TeamSpeak3.php(303): TeamSpeak3_Helper_Uri->__construct('serverquery://s...') #1 /var/www/vhosts/sp-solutions.de/httpdocs/forum/eveapi_cron.php(209): TeamSpeak3::factory('serverquery://s...') #2 {main} thrown in /var/www/vhosts/sp-solutions.de/httpdocs/forum/includes/eveapi/TeamSpeak3/Helper/Uri.php on line 133
Cyerus
University of Caille
Gallente Federation
#347 - 2012-08-27 18:47:00 UTC
Faldal Dartan wrote:
when I fetch the "eveapi_cron.php" I get this error:

Quote:

Fatal error: Uncaught exception 'TeamSpeak3_Helper_Exception' with message 'invalid URI supplied' in /var/www/vhosts/sp-solutions.de/httpdocs/forum/includes/eveapi/TeamSpeak3/Helper/Uri.php:133 Stack trace: #0 /var/www/vhosts/sp-solutions.de/httpdocs/forum/includes/eveapi/TeamSpeak3/TeamSpeak3.php(303): TeamSpeak3_Helper_Uri->__construct('serverquery://s...') #1 /var/www/vhosts/sp-solutions.de/httpdocs/forum/eveapi_cron.php(209): TeamSpeak3::factory('serverquery://s...') #2 {main} thrown in /var/www/vhosts/sp-solutions.de/httpdocs/forum/includes/eveapi/TeamSpeak3/Helper/Uri.php on line 133


That means one (or multiple) settings on the TeamSpeak module are wrong.
Be sure to remove weird characters from the username and password, and sometimes removing (or changing) the server nickname works too.
Faldal Dartan
Sebiestor Tribe
Minmatar Republic
#348 - 2012-08-27 18:52:48 UTC
ah got it...the serverquery nick had a space.

ty :)
Andy Tibs
Ministry of War
#349 - 2012-08-29 17:02:49 UTC
Hi. Thanks for you work on this... I have started using it and so far it is great! Big smile

I was looking around and was wondering if there is a way to set access based on an account's skills or corp access? Best examples I can think of is like if members have any capital skillbooks trained it would grant them access to a section of the forums that can see a section dealing with capitals, or give directors access to a section that isn't available to the other members?

If not would there be any plans to add this in a future release?

Thanks!
Cyerus
University of Caille
Gallente Federation
#350 - 2012-08-29 23:03:22 UTC
Andy Tibs wrote:
Hi. Thanks for you work on this... I have started using it and so far it is great! Big smile

I was looking around and was wondering if there is a way to set access based on an account's skills or corp access? Best examples I can think of is like if members have any capital skillbooks trained it would grant them access to a section of the forums that can see a section dealing with capitals, or give directors access to a section that isn't available to the other members?

If not would there be any plans to add this in a future release?

Thanks!


I have a lot of people ask for such features, so I guess I should implement something like that.
Can't give you any ETA, since I'm first going to finish 6.1.0.
Norjia Blacksteel
Blacksteel Mining and Manufacturing
Renaissance Federation
#351 - 2012-08-30 01:57:38 UTC
I have a special group in the forum called "CEO and Director" for officers in the corps of my alliance. If I add someone to it, the cron job removes them.

I expected the mod to add people to Members if they're in my alliance, and remove them from the forum if they're not. I thought that would mean that they would stay in a group I set them to unless they left the alliance.

If there isn't a simple way for me to get it to do this, don't worry about it. I was just wondering if I was missing something.
Therese Ishihara
Council of Exiles
Brave Collective
#352 - 2012-08-31 11:11:01 UTC
I tried a lot of different settings to get this to work. But none of the scripts show up.
No API fields in the profile pages or registration pages. And even the fitting mods don't work.

I tried the default prosilver style as well as my custom style which I edited manually.

What am I doing wrong?
Brain Gehirn
Macabre Votum
Northern Coalition.
#353 - 2012-09-01 02:47:19 UTC  |  Edited by: Brain Gehirn
Im running on the same issue.
No API key fields under registration page or user control panel.

Im using the latest phpBB (3.0.11).

Just for a sidenote: I have adjusted some conflicts while installing the mod (1 to be exactly) but still didnt work.


Edit: the same with 3.0.10
Derp Teknick
AirHogs
Hogs Collective
#354 - 2012-09-03 08:48:08 UTC
I was having this issue, and it turns out (for me at least) that while Automod was saying that it was editing files successfully, it actually wasn't due to permission errors. I had to use the Compressed File Download configuration, then upload the edited files manually. Check that this is or isn't the case for you guys, it worked for me after this. I believe that Cyerus is still working on an update for the 3.0.11 version of PHPBB3, so for now I'd stick with 3.0.10. Hope this helps.

.
AzAkiR NaLDa
Council of Exiles
Brave Collective
#355 - 2012-09-03 13:14:39 UTC
Thnx for the tip I'll see if that will work.

Lone Star Warrior
Therese Ishihara
Council of Exiles
Brave Collective
#356 - 2012-09-03 15:43:21 UTC
Derp Teknick wrote:
I was having this issue, and it turns out (for me at least) that while Automod was saying that it was editing files successfully, it actually wasn't due to permission errors. I had to use the Compressed File Download configuration, then upload the edited files manually. Check that this is or isn't the case for you guys, it worked for me after this. I believe that Cyerus is still working on an update for the 3.0.11 version of PHPBB3, so for now I'd stick with 3.0.10. Hope this helps.


this fixxed my issues thnx for the tip
Brain Gehirn
Macabre Votum
Northern Coalition.
#357 - 2012-09-03 20:12:07 UTC
Fixed here too! Didn´t think about this!

Thanks!
AzAkiR NaLDa
Council of Exiles
Brave Collective
#358 - 2012-09-03 21:27:58 UTC
There is now only 1 issue left which is the fitting stuff. A fitting linked on the forum shows the fitting ring but no modules are shown. Trying to view it using ingame browser function doesn't work either. What could be the problem? I'm running 3.0.10 and using the prosilver template till we get it all fixed up

Lone Star Warrior
Brain Gehirn
Macabre Votum
Northern Coalition.
#359 - 2012-09-04 09:54:47 UTC
@AzAkiR NaLDa

Try to use the EFT format (latest version) or exporting from Pyfa (EFT style too).
The fitting may be missplaced if you have any extra linebreak.
AzAkiR NaLDa
Council of Exiles
Brave Collective
#360 - 2012-09-04 10:09:16 UTC
Can you give a example of how it should be like? The exported fitting

Lone Star Warrior