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
ISuper
State War Academy
Caldari State
#181 - 2012-03-29 20:12:16 UTC  |  Edited by: ISuper
Cyerus wrote:
ISuper wrote:
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


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



Now with wget i get:

Quote:
HTTP request sent, awaiting response... 500 Internal Server Error
2012-03-30 00:10:05 ERROR 500: Internal Server Error


And there are nothing in httpd error.log
eraberaca
The Scope
Gallente Federation
#182 - 2012-03-30 02:38:43 UTC
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.
Eric Deloitte
The Flowing Penguins
#183 - 2012-03-30 10:09:07 UTC
eraberaca wrote:
I'm having trouble with the [evefit] feature.


I had a few problems with this as well and found it needed some manual editing of the EFT text I needed to remove any white space from the top and add 2 lines of white space before the drones like below. Also some characters in the Fitting Name can cause you some problems, if it has a comma in it for example.


Quote:
[evefit][Talos, DPS]
Magnetic Field Stabilizer II
Magnetic Field Stabilizer II
Tracking Enhancer II
Tracking Enhancer II
Damage Control II

Large Shield Extender II
Large Shield Extender II
Invulnerability Field II
10MN MicroWarpdrive II

Neutron Blaster Cannon II, Void L
Neutron Blaster Cannon II, Void L
Neutron Blaster Cannon II, Void L
Neutron Blaster Cannon II, Void L
Neutron Blaster Cannon II, Void L
Neutron Blaster Cannon II, Void L
Neutron Blaster Cannon II, Void L
Neutron Blaster Cannon II, Void L

Medium Hybrid Collision Accelerator I
Medium Hybrid Metastasis Adjuster I
Medium Algid Hybrid Administrations Unit I


Warrior II x5
[/evefit]

eraberaca
The Scope
Gallente Federation
#184 - 2012-03-30 10:41:56 UTC
Eric Deloitte wrote:
eraberaca wrote:
I'm having trouble with the [evefit] feature.


I had a few problems with this as well and found it needed some manual editing of the EFT text I needed to remove any white space from the top and add 2 lines of white space before the drones like below. Also some characters in the Fitting Name can cause you some problems, if it has a comma in it for example.


Quote:
[evefit][Talos, DPS]
Magnetic Field Stabilizer II
Magnetic Field Stabilizer II
Tracking Enhancer II
Tracking Enhancer II
Damage Control II

Large Shield Extender II
Large Shield Extender II
Invulnerability Field II
10MN MicroWarpdrive II

Neutron Blaster Cannon II, Void L
Neutron Blaster Cannon II, Void L
Neutron Blaster Cannon II, Void L
Neutron Blaster Cannon II, Void L
Neutron Blaster Cannon II, Void L
Neutron Blaster Cannon II, Void L
Neutron Blaster Cannon II, Void L
Neutron Blaster Cannon II, Void L

Medium Hybrid Collision Accelerator I
Medium Hybrid Metastasis Adjuster I
Medium Algid Hybrid Administrations Unit I


Warrior II x5
[/evefit]



unfortunately that didn't work either. Same issue with fitting panel being empty yet all the ship and mod icons listed on individual lines below the panel.
Eupho4ic
NW Tech
#185 - 2012-03-30 21:02:26 UTC
I have having difficulty getting the Teamspeak function to register users on the Teamspeak server.

When a registered forum user enters their Teamspeak UID it disappears after submitting, is this working as intended?

What should I put in the Serverquery Nickname? I could not figure out what you meant by "This nickname will be used mask the webserver."

Also when I hit "ServerQuery Login" button on teamspeak and I enter the name of the serverquery username the password changes each time that I do this. Should I just enter the password that is given to me the first time, and not ask for the password again?

I'm not seeing any serverquery logs with the forum attempting to authenticate with the TS server, I think this is a problem correct?

I know its a bunch of questions and I appreciate your help!
Cyerus
University of Caille
Gallente Federation
#186 - 2012-03-31 02:21:26 UTC
Hatoshi Onohira wrote:
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.


I honestly have no idea where this bug comes from.
Will have to do some field testing using TeamViewer in order to crush it, if you are willing to at least..


swfblade wrote:
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 :)


Thanks! Shouldn't take long for the next release.


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.


Enik Gonz wrote:
Has this been updated to work with the new names of som modules. Or would you have to change this manually?


Not yet. However next release will hold the updated module names.
Cyerus
University of Caille
Gallente Federation
#187 - 2012-03-31 02:30:01 UTC
ISuper wrote:


**snip**

Now with wget i get:

Quote:
HTTP request sent, awaiting response... 500 Internal Server Error
2012-03-30 00:10:05 ERROR 500: Internal Server Error


And there are nothing in httpd error.log


Change the TeamSpeak 3 server nickname to something simple (1 word, alphabetical characters only) and test if that fixes the issue.


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.


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.


Eupho4ic wrote:
I have having difficulty getting the Teamspeak function to register users on the Teamspeak server.

When a registered forum user enters their Teamspeak UID it disappears after submitting, is this working as intended?

What should I put in the Serverquery Nickname? I could not figure out what you meant by "This nickname will be used mask the webserver."

Also when I hit "ServerQuery Login" button on teamspeak and I enter the name of the serverquery username the password changes each time that I do this. Should I just enter the password that is given to me the first time, and not ask for the password again?

I'm not seeing any serverquery logs with the forum attempting to authenticate with the TS server, I think this is a problem correct?

I know its a bunch of questions and I appreciate your help!


Questions exist in order to be answered.

If it disappears, then something went wrong;
1) The TeamSpeak UID was unknown to the server (like when the client has never connected to the server before).
2) The connection between the forum and the TeamSpeak server went wrong.

Serverquery nickname is a mask to hide your TeamSpeak server's IP address.
Normally it would be something like "* 192.125.352.122:432 has added Username to Servergroup"
Instead, it would name it like "* SERVERNICKNAME has added Username to Servergroup"
Personally I set it to Cookiemonster, but that's just my humour Big smile

You have to be serveradmin (or at least VirtualServer Admin) in order to have the correct permissions to use the serverquery window.
The ServerQuery password changes because you request a new one every time.
Request one on an UID with the correct permissions, the write down the username / password.
Fill that in on the TeamSpeak 3 settings on the forum, and then it should work.
Hatoshi Onohira
Doomheim
#188 - 2012-03-31 16:53:30 UTC
Cyerus wrote:
Hatoshi Onohira wrote:
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.


I honestly have no idea where this bug comes from.
Will have to do some field testing using TeamViewer in order to crush it, if you are willing to at least..



Just let me know what I need to do, anything to help with resolving this issue. Many thanks!

Recruiting – Happening Now!

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

ISuper
State War Academy
Caldari State
#189 - 2012-04-02 06:34:34 UTC
Quote:


Change the TeamSpeak 3 server nickname to something simple (1 word, alphabetical characters only) and test if that fixes the issue.




It didn't help
Felsaa
Imperial Shipment
Amarr Empire
#190 - 2012-04-03 22:06:05 UTC  |  Edited by: Felsaa
ISuper wrote:
Quote:


Change the TeamSpeak 3 server nickname to something simple (1 word, alphabetical characters only) and test if that fixes the issue.




It didn't help


I'm also have the same issues when trying to running the eveapi_cron.php

I get an Error 500.

Love the mod and would love if you can help to get it working correctly for me.

Regards

V

Edit - Resolved

After lots of messing around I have it working, I believe I know what the issues was (but cant be 100%).

I never enabled the standing section and didn't add a corp API, after adding the corp API and enabling the section the cron no longer gave me a 500 error and updated the groups and TS.

I have done some basic tests and it appears all in working order.

Love the mod Cyerus excellent work.
salia Shiar
The Scope
Gallente Federation
#191 - 2012-04-04 04:16:20 UTC
I am currently expereincing an error where the forums keep pulling peoples registrations, its not the same person and it seems to be random, but if the user uses the update feature of the program the same API works to re-instate their account.

Is this an issue with my server and the api server ? Some kinda hickup? Some tweek i havn't done to maybe slow the query of the api server down so it doesn't skip people maybe?
salia Shiar
The Scope
Gallente Federation
#192 - 2012-04-08 20:47:40 UTC
any thoughts? this is still an issue
ISuper
State War Academy
Caldari State
#193 - 2012-04-09 06:56:33 UTC
Felsaa wrote:
ISuper wrote:
Quote:


Change the TeamSpeak 3 server nickname to something simple (1 word, alphabetical characters only) and test if that fixes the issue.




It didn't help


I'm also have the same issues when trying to running the eveapi_cron.php

I get an Error 500.

Love the mod and would love if you can help to get it working correctly for me.

Regards

V

Edit - Resolved

After lots of messing around I have it working, I believe I know what the issues was (but cant be 100%).

I never enabled the standing section and didn't add a corp API, after adding the corp API and enabling the section the cron no longer gave me a 500 error and updated the groups and TS.

I have done some basic tests and it appears all in working order.

Love the mod Cyerus excellent work.


I have corp ID ON and standing OFF, Tried some combinations but it didn't help. I still have "ERROR 500: Internal Server Error."
Felsaa
Imperial Shipment
Amarr Empire
#194 - 2012-04-09 15:46:57 UTC
ISuper wrote:
Felsaa wrote:
ISuper wrote:
Quote:


Change the TeamSpeak 3 server nickname to something simple (1 word, alphabetical characters only) and test if that fixes the issue.




It didn't help


I'm also have the same issues when trying to running the eveapi_cron.php

I get an Error 500.

Love the mod and would love if you can help to get it working correctly for me.

Regards

V

Edit - Resolved

After lots of messing around I have it working, I believe I know what the issues was (but cant be 100%).

I never enabled the standing section and didn't add a corp API, after adding the corp API and enabling the section the cron no longer gave me a 500 error and updated the groups and TS.

I have done some basic tests and it appears all in working order.

Love the mod Cyerus excellent work.


I have corp ID ON and standing OFF, Tried some combinations but it didn't help. I still have "ERROR 500: Internal Server Error."


I also had standings disabled, after adding a corp API then enabling the feature it started to work, I would suggest trying to enable the feature even if you intend on disabling standing in the future.

Worth a try I say.
ISuper
State War Academy
Caldari State
#195 - 2012-04-10 05:56:43 UTC
Felsaa wrote:
ISuper wrote:
Felsaa wrote:
ISuper wrote:
Quote:


Change the TeamSpeak 3 server nickname to something simple (1 word, alphabetical characters only) and test if that fixes the issue.




It didn't help


I'm also have the same issues when trying to running the eveapi_cron.php

I get an Error 500.

Love the mod and would love if you can help to get it working correctly for me.

Regards

V

Edit - Resolved

After lots of messing around I have it working, I believe I know what the issues was (but cant be 100%).

I never enabled the standing section and didn't add a corp API, after adding the corp API and enabling the section the cron no longer gave me a 500 error and updated the groups and TS.

I have done some basic tests and it appears all in working order.

Love the mod Cyerus excellent work.


I have corp ID ON and standing OFF, Tried some combinations but it didn't help. I still have "ERROR 500: Internal Server Error."


I also had standings disabled, after adding a corp API then enabling the feature it started to work, I would suggest trying to enable the feature even if you intend on disabling standing in the future.

Worth a try I say.


With enabled `standings` i have the same error
Feanos
Brutor Tribe
Minmatar Republic
#196 - 2012-04-10 13:06:47 UTC
ISuper wrote:


With enabled `standings` i have the same error


Most likely, you've still got an invalid TS link in your config still. I personally went with really simple data:

| eveapi_ts_ip | 199.167.135.78 | 0 |
| eveapi_ts_masterswitch | 1 | 0 |
| eveapi_ts_nickname | some_bot | 0 |
| eveapi_ts_password | simplepassword | 0 |
| eveapi_ts_port_query | 10011 | 0 |
| eveapi_ts_port_server | 9987 | 0 |
| eveapi_ts_username | some_bot| 0 |

(No, that's not my real password.) Likely, you've got a : or something else in there. The IP should be just the IP, the port, just the port. If you want to go and debug it, open up functions_eveapi.php, find the line:
$ts3_VirtualServer = TeamSpeak3::factory("serverquery://" . $config["eveapi_ts_username"] . ":" . $config["eveapi_ts_password"] . "@" . $config["eveapi_ts_ip"] . ":" . $config["eveapi_ts_port_query"] . "/?server_port=" . $config["eveapi_ts_port_server"] . $nickname);

Add a line below that says: echo "serverquery://" . $config["eveapi_ts_username"] . ":" . $config["eveapi_ts_password"] . "@" . $config["eveapi_ts_ip"] . ":" . $config["eveapi_ts_port_query"] . "/?server_port=" . $config["eveapi_ts_port_server"] . $nickname;

Then do it again, that'll blurt out the serverquery line, and you can check for obvious/silly issues. Should be 1 @ and only 2 : in the entire thing. Ours looks something like: serverquery://some_bot:simplepassword@199.167.135.78:10011/?server_port=9987somebot It's a bit more complex, but if you know PHP, it's not too bad. Granted, you might have to look elsewhere for the factory, I was debugging mine when I was having issues with people getting added to ts (Forgot to whitelist the forum's IP!)

Side note, I love this mod, made my life really easy. I'd like to see some kind of external system that blues can use (Something for me to code and add perhaps) without forum regs, kinda like eveots, so it's easy for them to just drop in, drop the API, and their UID in without forum reg.
Bwuce Lee
Perkone
Caldari State
#197 - 2012-04-10 23:56:27 UTC
I've been trying to figure out an issue we've been having with BBCodes. Basically once I install the api everything seems to work fine, then I add a few custom youtube bbcodes and when I click on the bbcodes in a post nothing happens, if I highlight some post text and click the bbcode icon it says undefined?

I tested the bbcodes on several other boards without the api installed and they work fine, not sure what's up.
Miss Dominux
Stain Security Forces
#198 - 2012-04-12 13:45:51 UTC
Is there any way you can change what permission the Api key needs?
Felsaa
Imperial Shipment
Amarr Empire
#199 - 2012-04-12 18:36:07 UTC  |  Edited by: Felsaa
Website opened to the corp. with no hiccups (other than previously noted), excellent mod. +1

Not sure if it's possible but would love if there were some corp management features to identify who has not signed up to the forum, this would make my live so much easier Big smile
ISuper
State War Academy
Caldari State
#200 - 2012-04-13 12:30:31 UTC  |  Edited by: ISuper
Feanos wrote:
ISuper wrote:


With enabled `standings` i have the same error


Most likely, you've still got an invalid TS link in your config still. I personally went with really simple data:

| eveapi_ts_ip | 199.167.135.78 | 0 |
| eveapi_ts_masterswitch | 1 | 0 |
| eveapi_ts_nickname | some_bot | 0 |
| eveapi_ts_password | simplepassword | 0 |
| eveapi_ts_port_query | 10011 | 0 |
| eveapi_ts_port_server | 9987 | 0 |
| eveapi_ts_username | some_bot| 0 |

(No, that's not my real password.) Likely, you've got a : or something else in there. The IP should be just the IP, the port, just the port. If you want to go and debug it, open up functions_eveapi.php, find the line:
$ts3_VirtualServer = TeamSpeak3::factory("serverquery://" . $config["eveapi_ts_username"] . ":" . $config["eveapi_ts_password"] . "@" . $config["eveapi_ts_ip"] . ":" . $config["eveapi_ts_port_query"] . "/?server_port=" . $config["eveapi_ts_port_server"] . $nickname);

Add a line below that says: echo "serverquery://" . $config["eveapi_ts_username"] . ":" . $config["eveapi_ts_password"] . "@" . $config["eveapi_ts_ip"] . ":" . $config["eveapi_ts_port_query"] . "/?server_port=" . $config["eveapi_ts_port_server"] . $nickname;

Then do it again, that'll blurt out the serverquery line, and you can check for obvious/silly issues. Should be 1 @ and only 2 : in the entire thing. Ours looks something like: serverquery://some_bot:simplepassword@199.167.135.78:10011/?server_port=9987somebot It's a bit more complex, but if you know PHP, it's not too bad. Granted, you might have to look elsewhere for the factory, I was debugging mine when I was having issues with people getting added to ts (Forgot to whitelist the forum's IP!)

Side note, I love this mod, made my life really easy. I'd like to see some kind of external system that blues can use (Something for me to code and add perhaps) without forum regs, kinda like eveots, so it's easy for them to just drop in, drop the API, and their UID in without forum reg.


Where do i have to create this config? I didn't find any information on the 1st page. Thank you.