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

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

EVE Technology Lab

Forum Index

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

Topic is locked indefinitely.

First pagePrevious page7891011Next pageLast page

phpBB 3.x API Registration Mod v6+
Author

Previous Topic Next Topic

Barrel Roll Squad 1
TEMAndroid Barrel Roll Squad Likes received: 1	#161 - 2012-03-08 15:51:46 UTC What version of phpbb u used and what are u doin - update or new install?

Hatoshi Onohira

Doomheim

Likes received: 3

#162 - 2012-03-08 18:02:58 UTC

Hatoshi Onohira wrote:

Have been working on this for several hours, everything installed okay and when I went to test.. received this error message.

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

Can you tell me what I doing wrong.

Sorry, for that..

brand new install, no mods or templates added. phpbb vers. 3.0.10

thanks..

Recruiting – Happening Now!

See our recruitment forum post for more details: - PvP, Industrial and Exploration Corp LF Pilots


TEMAndroid Barrel Roll Squad Likes received: 1	#163 - 2012-03-09 07:26:00 UTC \| Edited by: TEMAndroid U must execute all sql files from /sql... In default.sql ALTER TABLE phpbb_users ADD COLUMN eveapi_keyId INT UNSIGNED NOT NULL DEFAULT 0 AFTER user_reminded_time; will remove your error, but u need run all sql files...

Jone Sad

Doomheim

Likes received: 11

#164 - 2012-03-10 16:49:13 UTC | Edited by: Jone Sad

please help someone
i done all as was written in faq:
backup
rewrite (copy) files to root
add to module managment "module"
edit "avatar" module
saw the needed menus in general (for api) ACP
inputed data (id & vCode) to api settings

and now cant understand how does it works

where must user put in api and vcode? in registration there are not such fields, in profile too

how does it work and mb which settings (except) faq in 1st post, must i do and what where to look at this?

PS: Board version "3.0.10" and module "EVE_API_v5.3_for_phpBB_3.0.10"

ISuper

State War Academy

Caldari State

Likes received: 9

#165 - 2012-03-12 06:38:05 UTC

Do i need to add a cron job? If i am trying to run eveapi_cron.php manually i get error:

Quote:

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

Hatoshi Onohira

Doomheim

Likes received: 3

#166 - 2012-03-13 20:09:06 UTC

TEMAndroid wrote:

U must execute all sql files from /sql...
In default.sql

ALTER TABLE phpbb_users ADD COLUMN eveapi_keyId INT UNSIGNED NOT NULL DEFAULT 0 AFTER user_reminded_time;

will remove your error, but u need run all sql files...

After doing as instructed I received a different error message:

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.

The API module seems to be working - members are allowed to be registered as users.

Recruiting – Happening Now!

See our recruitment forum post for more details: - PvP, Industrial and Exploration Corp LF Pilots

Blacksteel Mining and Manufacturing Renaissance Federation 37
Norjia Blacksteel Blacksteel Mining and Manufacturing Renaissance Federation Likes received: 37	#167 - 2012-03-14 02:08:20 UTC So I have an old version, like 5.1 or something. It's installed on a 3.0.10 phpbb installation, and the mod is mostly working. There's one person who can't register for some reason. Anyway, I was going to upgrade to 5.3, and I'm not sure how to update the installation. Do I just upload all the files in the 5.3 package?

Black Omega Squadron 3
swfblade Black Omega Squadron Likes received: 3	#168 - 2012-03-14 10:31:42 UTC Just curious as to if there is quick easy way to update the data, so that it has all the new stupid names for items? Just so they show up correctly on the fitting. (ok some aren't that stupid, but some...fix, broken, not springs to mind...)

Oberon Incorporated 15
Gaurina Oberon Incorporated Likes received: 15	#169 - 2012-03-16 16:48:39 UTC I've got a possibly quite stupid question: Is it not possible to activate this module but still allow people to register without API key? I ask because I'd like my board to be able to do more then just serve more then just eve players.

Cyerus

University of Caille

Gallente Federation

Likes received: 265

#170 - 2012-03-17 12:04:30 UTC

graves warship wrote:

did that to our page ill upload a edited file for ya to use in a sec with the link in there

here it is:

http://united-kings.net/ucp_register.zip
after uploading the file to the apropriate folder
in your admin panel go to styles/templates and refresh ehm
otherwise it wont show up

I like this feature. WIll add it in v5.4.

salia Shiar wrote:

Greetings everyone,

i am currently having a problem where everything works fine.

the users are added to their corps groups. When they leave their corp though and login they are not moved to the neut group. Can anyone help me with this please.

i created the following cron job but it doesn't seem to work

0 * * * * php -q /public_html/forums/eveapi_cron.php

You should use "wget http://link-to-forums/eveapi_cron.php".

Eric Deloitte wrote:

Installed first time with no issues at all

will keep you posted of any issues

Many thanks

edit I notice the fitting display tool, what format is that expecting as it took a little juggling to get it to accept an eft export?

In EFT, click on the little arrow pointing downwards next to the ship icon. Choose option "Copy to Clipboard".
Then past on the forums, select the whole fitting (with CTRL-A) and click on the EVEFit button.

LordKeeps wrote:

there is some problems with the avatars (yes i removed the avatar thingy and readded it again) that pics dont show corretly
as soon avatar got updated on one account its showing same on all accounts.
For some reason its working corretly in IE for me but not in any other browsers.
Any1 with same problem?

5.3 mod on 3.0.10 phpbb3 version

Confirmed bug. Will be fixed in v5.4

salia Shiar wrote:

after several changes to that ine now i get

Fatal error: Class 'TeamSpeak3' not found in /home/<...>/public_html/forums/eveapi_cron.php on line 45

thats on the actual cron.php

the cronjob istelf sends my email this

Status: 404 Not Found
Content-type: text/html

No input file specified.

any ideas?

Confirmed bug. Will be fixed in v5.4

Cyerus

University of Caille

Gallente Federation

Likes received: 265

#171 - 2012-03-17 12:05:20 UTC

KongGal wrote:

also is there any way to update avatars. if a member edits hes avatar ingame then he could update it on the forum or put something in the cronjob that would update all the avatars

Each user can updated their forum avatar at the User Control Panel -> Profile -> Edit Avatar.

Balani wrote:

the cronjob disables accounts without api keys entered is it possible to move that member into other group instead of disabling account ?

That's not possible, and will not be included in future versions either.

Apocil Munar wrote:

Can someone tell me what i need to do to make this work with other pro-silver based templates? i have tried copying the files from the pro silver folder into the new template folder but the api fields do not show up on the registration page.

Take a look at the XML file for manual edits to be made. Skip to the styles/ section for styles changes.
Also, don't forget to upload new_files/styles files to your forum.

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!

Check if you have the extra fields in phpbb_users table. If not, rerun sql/default.sql

KongGal wrote:

i get the problem that the cron disable a lot of accounts when with active keys, "i can watch them by doing a API call my self"

Any reason on this?

The according to the settings you made in the AdminCP those accounts should be disabled.
Different corporation, removed standings, wrong corporation.. etc.

Cyerus

University of Caille

Gallente Federation

Likes received: 265

#172 - 2012-03-17 12:10:41 UTC

salia Shiar wrote:

the latest problem i get is that when i attempt to put my ID in for teamspeak it just deletes it when i hit submit, gives me no errors. Is there something that needs to be enabled somewhere?

it also says to me

Quote:

Fatal error: Uncaught exception 'TeamSpeak3_Adapter_ServerQuery_Exception' with message 'invalid loginname or password' in /home/domain/public_html/forums/includes/eveapi/TeamSpeak3/Adapter/ServerQuery/Reply.php:305 Stack trace: #0 /home/domain/public_html/forums/includes/eveapi/TeamSpeak3/Adapter/ServerQuery/Reply.php(82): TeamSpeak3_Adapter_ServerQuery_Reply->fetchError(Object(TeamSpeak3_Helper_String)) #1 /home/domain/public_html/forums/includes/eveapi/TeamSpeak3/Adapter/ServerQuery.php(140): TeamSpeak3_Adapter_ServerQuery_Reply->__construct(Array, 'login client_lo...', Object(TeamSpeak3_Node_Host)) #2 /home/domain/public_html/forums/includes/eveapi/TeamSpeak3/Node/Abstract.php(72): TeamSpeak3_Adapter_ServerQuery->request('login client_lo...') #3 /home/domain/public_html/forums/includes/eveapi/TeamSpeak3/Node/Abstract.php(96): TeamSpeak3_Node_Abstract->request('login client_lo...') #4 /home/domain/public_html/forums/includes/eveapi/TeamSpeak3/Node/Host.php(708): TeamSpeak3_Node_Abstract->execute('login', Array) #5 /home/karm in /home/domain/public_html/forums/includes/eveapi/TeamSpeak3/Adapter/ServerQuery/Reply.php on line 305

As the error clearly says; Wrong username / password for the TeamSpeak 3 connection.

TEMAndroid wrote:

Can u add option that can allow registration to members who have no standing to me|corp|alliance?

Enable the function called "Enable Non-member Registration".

Jone Sad wrote:

Doublecheck you set all the settings in all the module pages to your liking.
Test is with the default pro_silver template.
If that works, you can continue to edit your own template and see if that works too.
If it doesn't work, it means something went wrong in the installation and it might be easier to do it over again.

Cyerus

University of Caille

Gallente Federation

Likes received: 265

#173 - 2012-03-17 12:16:10 UTC

ISuper wrote:

Do i need to add a cron job? If i am trying to run eveapi_cron.php manually i get error:

Quote:

Use "wget http://path-to-forum.com/eveapI_cron.php".

Norjia Blacksteel wrote:

So I have an old version, like 5.1 or something. It's installed on a 3.0.10 phpbb installation, and the mod is mostly working. There's one person who can't register for some reason.

Anyway, I was going to upgrade to 5.3, and I'm not sure how to update the installation. Do I just upload all the files in the 5.3 package?

Yes, just overwrite the old files with the new ones.
Don't forget to update your sql aswell, since the new releases have updated items / systems table.
And clear cache in the AdminCP when you are done to avoid weird glitches.

swfblade wrote:

Just curious as to if there is quick easy way to update the data, so that it has all the new stupid names for items? Just so they show up correctly on the fitting. (ok some aren't that stupid, but some...fix, broken, not springs to mind...)

It's possible, but will take ages to do it manually.
I'm waiting for the Crucible 1.5 DB release, so I can update the items / systems table and add it to the v5.4 release.

Gaurina wrote:

I've got a possibly quite stupid question:

Is it not possible to activate this module but still allow people to register without API key?

I ask because I'd like my board to be able to do more then just serve more then just eve players.

That's not possible.


Norjia Blacksteel Blacksteel Mining and Manufacturing Renaissance Federation Likes received: 37	#174 - 2012-03-18 15:14:57 UTC \| Edited by: Norjia Blacksteel Ok, I just upgraded to V5.3, and now the cronjob says "Fatal error: Class 'TeamSpeak3' not found in #pathtofile#/eveapi_cron.php on line 45" ETA: Fixed. Just removed the cronlog for Teamspeak.

Hatoshi Onohira

Doomheim

Likes received: 3

#175 - 2012-03-18 19:54:24 UTC

I'm still having a bit of a problem with an error message users receive after they register on the forum. The regististration is successful and the user is allowed into the forums but if someone could assist me correcting this error.

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.

"brand new install, no mods or templates added. phpbb vers. 3.0.10"

Recruiting – Happening Now!

See our recruitment forum post for more details: - PvP, Industrial and Exploration Corp LF Pilots

Cyerus

University of Caille

Gallente Federation

Likes received: 265

#176 - 2012-03-18 20:26:11 UTC | Edited by: Cyerus

Hatoshi Onohira wrote:

Does it give a filename and/or linecode in a file where the error occurs?
Could you give me some more details on which page (which stage) of the registration this happens at?

Can you also check if both the eveapi_keyId and eveapi_vCode fields are in the phpbb_users table?

Hatoshi Onohira

Doomheim

Likes received: 3

#177 - 2012-03-19 05:02:48 UTC | Edited by: Hatoshi Onohira

I have confirmed that both eveapi_keyId and eveapi_vCode fields are in the phpbb_users table.

The error occurs after you have completed the registration form and select "submit" (.../forum/ucp.php?mode=register). The information below is all that is given.

"General Error
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."

Again, just to let you know that users are able to go from the error message - to the log in and enter the forums as normal. All the user's registration information was saved correctly.

Recruiting – Happening Now!

See our recruitment forum post for more details: - PvP, Industrial and Exploration Corp LF Pilots


swfblade Black Omega Squadron Likes received: 3	#178 - 2012-03-19 11:30:43 UTC Cyerus, many thanks for the updates. keep up the good work, this mod is fantastic and we use features of it a lot on our corp forums. I'll wait for the upgrade eagerly :)

KongGal

Circle-0f-Two

Circle-Of-Two

Likes received: 10

#179 - 2012-03-25 21:15:57 UTC

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?

Thorium. 13
Enik Gonz Thorium. Likes received: 13	#180 - 2012-03-28 10:27:15 UTC Has this been updated to work with the new names of som modules. Or would you have to change this manually?

First pagePrevious page7891011Next pageLast page

EVE Technology Lab

Barrel Roll Squad

Doomheim

Doomheim

State War Academy

Caldari State

Blacksteel Mining and Manufacturing

Renaissance Federation

Black Omega Squadron

Oberon Incorporated

University of Caille

Gallente Federation

Circle-0f-Two

Circle-Of-Two

Thorium.