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
Madame Harpy
Wizard's Den
#221 - 2012-04-24 02:15:57 UTC
First off I'd like to say, AWESOME JOB on this! hat's off to you

secondly, as awesome as this is, I'm having an issue sync-ing my logins. I'm working with phpBB3 as the Master with Joomla as slave and bridging with jfusion. All the names are migrating over from phpBB3 to Joomla, but not the groups. It only takes the default groups as defined in phpBB3.

I suspect it's related to the issue of the cron jobs but not figured out how to resolve it. I've tried using both the Simple and Advanced permissions in the plug-in, but it doesn't seem to fix it.

Anything you have on this would be appreciated.
Alex Kent
Pandemic Leagion of Test
#222 - 2012-04-26 08:53:26 UTC  |  Edited by: Alex Kent
Dumgard wrote:
Hey guys,

Has anyone else received an error when registering that gives an error saying:

SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4 [1064]

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

===========================================================================
It still successfully registers the person upon giving the error, and they can log in the forum successfully, but I am trying to hunt it down to see what I did wrong.

Any help or ideas would be greatly appreciated, thanks!



That's because you didn't assigned a group to your members.
Maybe it's scripting error , but all you have to do is:
1. Create another Group, ex: Members
2. Go to EVE API Module -> Corporation -> Assign forum group -> Choose Member Group.

I had the same problem, and it's working now .


Cyerus wrote:


KongGal wrote:
Im just getting this error when i try to use the Teamspeak 3 mod

Fatal error: Uncaught exception 'TeamSpeak3_Helper_Exception' with message 'invalid URI supplied' in /home/konggal/public_html/forum/includes/eveapi/TeamSpeak3/Helper/Uri.php:133 Stack trace: #0 /home/konggal/public_html/forum/includes/eveapi/TeamSpeak3/TeamSpeak3.php(303): TeamSpeak3_Helper_Uri->__construct('serverquery://s...') #1 /home/konggal/public_html/forum/eveapi_cron.php(205): TeamSpeak3::factory('serverquery://s...') #2 {main} thrown in /home/konggal/public_html/forum/includes/eveapi/TeamSpeak3/Helper/Uri.php on line 133

any idea for a fix?


Change the TeamSpeak 3 server nickname to something simple (1 word with only alphabetical characters) and try again.


.


Confirm that it's not working . However .. If you leave the Serverquery Nickname empty, it will work.

eraberaca wrote:
I'm having trouble with the [evefit] feature.

I copy the EFT fitting and paste it into the post, then click on the 'evefit' which surrounds the fitting text with the [evefit] and ends with the [/evefit] tags however.....the eve fitting panel is empty and the mods icons are listed on individual lines below the panel.

Any ideas how I fix this? Is there some sort of BBCode that I need to enable? I'm quite lost and really want this feature on our boards.

Thanks for all your hard work on this mod. Excellent job.


I have the same Problem . It'w ill be nice if we can find a fix for this.


Apart from this , it will be nice if you can:
1. Add a Link to a predefined API , on the registration page.
2. Same, on the registration page, mentiont that the Forum Account name should be the same as the Character name.
3. In the Profile -> Edit Account Settings, to add some info in how can you get the TeamSpeak ID.


Everyhting else works just fine . Great Job.
Thank you.
Madame Harpy
Wizard's Den
#223 - 2012-04-26 13:33:53 UTC
Alex Kent wrote:
eraberaca wrote:
I'm having trouble with the [evefit] feature.

I copy the EFT fitting and paste it into the post, then click on the 'evefit' which surrounds the fitting text with the [evefit] and ends with the [/evefit] tags however.....the eve fitting panel is empty and the mods icons are listed on individual lines below the panel.

Any ideas how I fix this? Is there some sort of BBCode that I need to enable? I'm quite lost and really want this feature on our boards.

Thanks for all your hard work on this mod. Excellent job.


I have the same Problem . It'w ill be nice if we can find a fix for this.


See Cyerus' post #187: "Be sure to add all the style files to the style you are using, as well as adding the fitting css file into the overall_header.html."

It fixed if for me. ;)
salia Shiar
The Scope
Gallente Federation
#224 - 2012-05-01 00:48:49 UTC
Felsaa wrote:
Decaedron wrote:



Hi ! I'm also experiencing this issue : some random user accounts get disabled, even if the API keys are correct. I have to manually reactivate the accounts from the ACP. If I hit the cron page just after that, everything just goes fine !
I'm glad I'm not the only one having this problem at least :)


I've disabled the auto cronjob and will manually run until I see the issue happen, I don't know if it's relating to how long the job takes to run and this is causing a problem when scheduled job.


anyone got a fix for this yet? been trying to get help with this for months lol
Suleiman Shouaa
The Tuskers
The Tuskers Co.
#225 - 2012-05-03 15:29:20 UTC
Excellent mod. A++

The only suggestions I can make off the top of my head is to make Avatars upload for pre-registered users once they're API verified and that an mail icon is added below each user's name which if you click it, will open up an evemail to them.
Dumgard
State War Academy
Caldari State
#226 - 2012-05-03 19:46:26 UTC
Confirming that I also have all the SQL entries in as directed, and still have this bug:

SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4 [1064]

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

=======================================

That error comes up I have found at two specific things that can be replicated:

1. On a new forum account creation when you hit Submit (the account is still created though)
2. When you try to add in a Teamspeak 3 UID into your profile manually and hit submit (the UID box remains empty upon submitting)

I am not a coder, but I suspect that means this has something to do with the Teamspeak 3 module.

I'm available whenever you like for a Teamviewer session.

Thanks!
Dumgard
State War Academy
Caldari State
#227 - 2012-05-03 19:58:24 UTC
Alex Kent wrote:



That's because you didn't assigned a group to your members.
Maybe it's scripting error , but all you have to do is:
1. Create another Group, ex: Members
2. Go to EVE API Module -> Corporation -> Assign forum group -> Choose Member Group.

I had the same problem, and it's working now .


Tried that, good idea... didn't fix my problem though. My problems still remain.
cynobirduk
Call For IT
#228 - 2012-05-04 11:48:00 UTC
Hey,

Im getting a few issues that i really need some help on.

If using TS3 bit i get error on top of cron page

Quote:
xception 'TeamSpeak3_Adapter_ServerQuery_Exception' with message 'invalid parameter size' in /home3/evetest/public_html/includes/eveapi/TeamSpeak3/Adapter/ServerQuery/Reply.php:305 Stack trace: #0 /home3/evetest/public_html/includes/eveapi/TeamSpeak3/Adapter/ServerQuery/Reply.php(82): TeamSpeak3_Adapter_ServerQuery_Reply->fetchError(Object(TeamSpeak3_Helper_String)) #1 /home3/evetest/public_html/includes/eveapi/TeamSpeak3/Adapter/ServerQuery.php(140): TeamSpeak3_Adapter_ServerQuery_Reply->__construct(Array, 'clientupdate cl...', Object(TeamSpeak3_Node_Host)) #2 /home3/evetest/public_html/includes/eveapi/TeamSpeak3/Node/Abstract.php(72): TeamSpeak3_Adapter_ServerQuery->request('clientupdate cl...') #3 /home3/evetest/public_html/includes/eveapi/TeamSpeak3/Node/Abstract.php(96): TeamSpeak3_Node_Abstract->request('clientupdate cl...') #4 /home3/evetest/public_html/includes/eveapi/TeamSpeak3/Node/Host.php(179): TeamSpeak3_Node_Abstract->execute('clientupdate', Array) #5 /home3/evetest/public_html/includes/eveapi/TeamSpeak3/Node/Host.php(261): TeamSpeak3_Node_Host->serverSelectByPort(9988) #6 /home3/evetest/public_html/includes/eveapi/TeamSpeak3/TeamSpeak3.php(352): TeamSpeak3_Node_Host->serverGetByPort(9988) #7 /home3/evetest/public_html/includes/eveapi/functions_eveapi.php(81): TeamSpeak3::factory('serverquery://a...') #8 /home3/evetest/public_html/eveapi_cron.php(219): eveapi_setTeamSpeakGroups('*************...', Array, '**********') #9 {main}


I would really like to get this working so if the correct fix is posted and it works, there is isk in it for the poster!!

Many thanks
FlyingLotus 1201
Einherjer Waffenschmiede
#229 - 2012-05-07 12:28:37 UTC  |  Edited by: FlyingLotus 1201
gnarf ... obsolete post please delete!
Cyerus
University of Caille
Gallente Federation
#230 - 2012-05-22 18:38:24 UTC
Will release update as soon as I have the new Inferno database dump.
Derp Teknick
AirHogs
Hogs Collective
#231 - 2012-05-24 14:46:56 UTC
Love the mod so far Cyerus, looking forward to the update for Inferno.

I'm having an issue with users having their account disabled, sometimes weeks after having a functional account.

Checking back through the cron output, I've come across the following error whenever a user's account is deactivated:

05-22-2012 15:00:05 *username* EVE API error: 221 -> Illegal page
request! Please verify the access granted by the key you are using!
05-22-2012 15:00:05 *username* User is a Non-Member
05-22-2012 15:00:05 *username* Removing user from Forum group ->
Crimson Cell
05-22-2012 15:00:05 *username* Removing user sessions and disabling
account

At first I thought the user had just forgotten to check the No Expiry check box, so had them re-enable their account with the eveapi_update.php form, but on the next cronjob, the user had their account deactivated again.

Then I came across the next problem. After this had happened a few times, I had the user create a new API key, and run the update script using the new key. Again, the user was reactivated without an issue, but on the next cron the following error appeared:

05-23-2012 19:00:10 *username* EVE API error: 203 -> Authentication
failure.
05-23-2012 19:00:10 *username* Character and API settings do not match
05-23-2012 19:00:10 *username* Removing user from Forum group -> Crimson
Cell
05-23-2012 19:00:10 *username* Removing user sessions and disabling account

Upon checking the user's information through the PHPBB admin panel, I found that while the script had run successfully and allowed the user to log in, it had not updated the user's API information in their profile to the new key.

This has happened to 3 users so far out of 14, all of them popping up in the last day or two, so I'm just wondering if this has happened to anyone else, or if anyone knows a way to fix it.

Thanks for your time :)

- Derp

.

Cyerus
University of Caille
Gallente Federation
#232 - 2012-05-26 01:40:00 UTC
I'm thinking about removing the "Ship presented" and "Fitting Name" texts from the fitting window, because I can't seem to make it look exactly right, if you know what I mean.

Is anybody opposed to removing those 2 lines? Or perhaps any of you might have an idea on how to make it look better?

Please let me know.
Derp Teknick
AirHogs
Hogs Collective
#233 - 2012-05-27 04:03:39 UTC
I would just make the format {Ship Type} - {Fitting Name} on a single line.
ie: Oneiros - Lvl5 Cap Stable

.

delakut
Das zweite Konglomerat
Northern Coalition.
#234 - 2012-05-28 09:29:32 UTC
Derp Teknick wrote:
I would just make the format {Ship Type} - {Fitting Name} on a single line.
ie: Oneiros - Lvl5 Cap Stable

I think that's the best solution.
ISuper
State War Academy
Caldari State
#235 - 2012-06-01 10:05:28 UTC
Hello!

I have full list of corporations (10/10), how can i add more fields(corps) ? Thank you in advance.
Eric Deloitte
The Flowing Penguins
#236 - 2012-06-01 15:49:09 UTC
Just a quick one.

Is there anyway of having more than the 5 special groups immune to the Cronjob?

Regards
Derp Teknick
AirHogs
Hogs Collective
#237 - 2012-06-02 00:58:15 UTC
ISuper wrote:
Hello!

I have full list of corporations (10/10), how can i add more fields(corps) ? Thank you in advance.


Eric Deloitte wrote:
Just a quick one.

Is there anyway of having more than the 5 special groups immune to the Cronjob?

Regards


I believe both of these can be changed as in this post:

https://forums.eveonline.com/default.aspx?g=posts&m=767445#post767445

.

Eric Deloitte
The Flowing Penguins
#238 - 2012-06-03 06:38:34 UTC
Thatnk you, you are a genius and I clearly fail at reading o7
Mrs Doubtfire
The Northerners
Pandemic Horde
#239 - 2012-06-03 11:23:57 UTC
I'm having problem registering a user manually.

I've created a VIP group for adding people, who does not have an active EVE account to the forums. Using a mod to create the users from the ACP works fine.

Problem is that even with this VIP group set to ignore, the users are still being forced to enter correct API details, when changing their password for example.

Any way to get around this? I just want to be able to create users who are excluded from using API information.

Thanks
ISuper
State War Academy
Caldari State
#240 - 2012-06-04 10:40:50 UTC
Derp Teknick wrote:
ISuper wrote:
Hello!

I have full list of corporations (10/10), how can i add more fields(corps) ? Thank you in advance.


Eric Deloitte wrote:
Just a quick one.

Is there anyway of having more than the 5 special groups immune to the Cronjob?

Regards


I believe both of these can be changed as in this post:

https://forums.eveonline.com/default.aspx?g=posts&m=767445#post767445



Thank you very much!