let us know if you would like beta testers!

Got a hold of Cyerus in game. He was nice enough to let me know the project's about 90% done.

factionID="500001" factionName="Caldari State"
factionID="500002" factionName="Minmatar Republic"
factionID="500003" factionName="Amarr Empire"
factionID="500004" factionName="Gallente Federation"

Will it be possible to add users to a CHANNELgroup? I will create Corp only Channels on my Server in which the other Corps of my Allianz are not able to join. With the Right System of Teamspeak, this is only able with Channelgroups, not with Servergroups.

It looks promising!

I await you have made it compilant with the new, CAK (Customizable API Key) system.....

BTW, are you still in need of the factional warfare API data?
You might want to look at this link

If you pull the public XML data for a corp in factional warfare, ingame it is member of a NPC alliance, but API shows allianceID=0, and no way to easily 'know' it is in factional warfare unless you get a cross result for a player in that corp with the top list, so you need access to the player API details whenever you want to know it he is enlisted for factional warfare.

BTW, you can know a player is in a determined FW faction by the 'factionID' given when looking at the private FW stats API resultset.

From http://api.eveonline.com/eve/FacWarStats.xml.aspx



Those are the association between the factionID(s) and the factions themselves, I await you find this handy....

PS: if not in FW, you will get a 124 error, 'Character not enlisted in Factional Warfare.'

This function will be for ServerGroups only.
Problem with channelgroups is that they apply to each individual channels. In other words, to implement that, I will need to implement your whole TeamSpeak server setup.

Whats with Teamspeak on MySQL Database? Or is it impossible too?

Whats with Teamspeak on MySQL Database? Or is it impossible too?

My guess is that this script is on a TS server with MySQL backend, so it does not need to interact with serverquery for everything.... but not required.

And, BTW, TBH, I belive that the thing about channel groups in the server would not solve your problem, as the TS permissions system works like a hierarchy, a single one, with groups of users or individual users being 'tagged' higher in that hierarchy, but in no way there are different ladders, so you cannot allow something like:

Channel A for reserved issues
Channel B for corp 1
Channel C for corp 2
.....

And allow corp 1 to only join channel B only for example. But if you need it, you can make that corp 2 members cannot join corp 1 channel.

That can be done even without a SQL backend.

Other solution is to have each corp join a different virutalserver, and run some kind of 'echo' daemon, so if someone calls people from other corps they would hear them without invading their channel, however this is a intensive task and needs many resources (specially when communications are triggered). Also, the number of processes is exponential.....

This evening, EVE time.

You would also then need full api keys from the ceo or a director (with the director role)

that would be the smallest problem. most CEO's would like to use a corp key instead of a account key to get the extra function

and btw we talked about a option to get directors in a corps a special group where you said its was impossible to get roles from titles where i have been reading about it and learned you can get both titles and roles giving from tiles from the membertracking.xml

This evening, EVE time.

This still going to happen?

Yup yup, think I got about 45 minutes left

Found an issue where 'systems' using BBcodes were not correctly linked.

*EDIT:
Fixed!, and mod is released.

Have phun

I don't have much experience with the module system but I don't see any of the modules in the dropdown menu as shown on the 3rd screenshot.

Which version of phpBB are you using? Did you upload the files in both pre_edit and new_files directories?

Redownload the package, should be fixed

I have everything setup, but users aren't getting registered. They're getting a blank page when hitting submit on the registration page. I'm very tired so maybe I'm missing something small? I have the API's running through a corporation check and that's all. I'm going to sleep on it. Any help is appreciated.

Simon Victor wrote:
I have everything setup, but users aren't getting registered. They're getting a blank page when hitting submit on the registration page. I'm very tired so maybe I'm missing something small? I have the API's running through a corporation check and that's all. I'm going to sleep on it. Any help is appreciated.

Is the PHP module cURL enabled on your webhost? You can easily check by opening the phpinfo() page, and checking if cURL is in that list.

cURL is indeed enabled. Error log entry included:

Great job, Cyerus.
I have two small troubles:
1) all avatars resizing to eve portrait size: 128x128 for example.
2) what is the minimum access mask to register?

if ($config['eveapi_validation'] && $config['eveapi_portrait'])
{
$avatar_width = $config['eveapi_portrait_size'];
$avatar_height = $config['eveapi_portrait_size'];
}

It's not a bug, it's a feature. Let's assume you have the EVE Portrait Size selected to Medium (128x128), it will resize all Avatar pictures to 128x128. This is to ensure unity. The EVE Portraits are downloaded in 256x256 format, then resize to whatever you size you have set; this is to allow easy switching between sizes without having to redownload all the Portraits.

Manually deactivation works fine, thx. May make this option configurable?

Guys, where can I find instructions for installing this mod on PHPbb 3.0.9? I tried to find it in older version archives (mystical "readme.txt" as I think), but I can't even find alive link.

Pls direct me to guide or briefly tell what to do, If possible. Step-by-step instructions are welcome too :)

phpbb 3.0.9
API mod will be installed for the first time.




I found that I need just copy files from both folders into the "root" of my forum. Before I must create tables. After that I need to reload an avatar-mod and install an api-mod via mod-engine. Is this true way?

First of all Great job Cyerus !



Yeah thats indeed a pretty annoying feature. I have a transition period from apiv1 to apiv2 on our forums atm . As soon ppls update their api details they get removed from other groups .. even the special ones leaving them behind in the standard group.

I got the files and all put in the right places, and things from that end are working fine. However, i cannot figure out what to do with the sql files in that folder.

Where do they go?

Or do i have to upload those to mysql database?

That's a bug. A special group is supposed to be like that; You have to manually join it, and it should not disappear when running the cronjob. I think this peace of code got lost somewhere in the transition, and I have to admit that I didn't check that.

Will deploy fix in v5.1

Also, I will make an install guide whenever I have the chance; probably this weekend, busy week =/

Cyrerus, is it possible to relize next version in MODX format for easy update and installation?

IMO, it is better having the mod this way than in MODX, as as long as you do not want to install toons of mods to your board, you should be fine.....

Perhaps we could have this mod in the two variants or something like that?

Mods in MODX format automatically installed by AutoMod, imho it's simplest way. Why are any more variants?
Now impossible to install this mod if you already install any another mod, because installed mods would be broken. This distribution way only for fresh phpBB.

1) Avatar resizing
It's not a bug, it's a feature. Let's assume you have the EVE Portrait Size selected to Medium (128x128), it will resize all Avatar pictures to 128x128. This is to ensure unity. The EVE Portraits are downloaded in 256x256 format, then resize to whatever you size you have set; this is to allow easy switching between sizes without having to redownload all the Portraits.

However, this feature can be disabled, but it requires some manual work.

• Open pre_edit/includes/functions_display.php in notepad (I suggest Notepad++ if you don't mind installing it)
• Scroll to the bottom, where you should see the following 5 lines:

• Remove those 5 lines and save the file.
• Upload the file and clear you forums cache.

if ($config['eveapi_validation'] && $config['eveapi_portrait'])
{
$avatar_ratio = $avatar_width / $avatar_height;
$avatar_width = $config['eveapi_portrait_size'];
$avatar_height = round($config['eveapi_portrait_size'] / $avatar_ratio);
}

Well... some success

I am not sure which change helped but...

I downloaded the latest 5.1 files and reloaded them but also cleared the styles cache as well...

I am now getting the additional two api fields - however i now get this error when registering...




General Error

SQL ERROR [ mysqli ]

Unknown column 'eveapi_keyId' in 'field list' [1054]

An SQL error occurred while fetching this page.

exception 'TeamSpeak3_Helper_Exception' with message 'invalid URI supplied' in /var/www/bb/web/forum/includes/eveapi/TeamSpeak3/Helper/Uri.php:133 Stack trace: #0 /var/www/bb/web/forum/includes/eveapi/TeamSpeak3/TeamSpeak3.php(287): TeamSpeak3_Helper_Uri->__construct('serverquery://b...') #1 /var/www/bb/web/forum/includes/eveapi/functions_eveapi.php(81): TeamSpeak3::factory('serverquery://b...') #2 /var/www/bb/web/forum/includes/acp/acp_users.php(973): eveapi_setTeamSpeakGroups('MKGNGTYVx0fD3wR...', Array, 'Khroam') #3 /var/www/bb/web/forum/includes/functions_module.php(507): acp_users->main('users', 'overview') #4 /var/www/bb/web/forum/adm/index.php(74): p_master->load_active() #5 {main}

$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);

$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"]);

Any idea why I'm getting this when I try to enter my TeamSpeak server UID and hit submit?



Also, the TS reg doesn't seem to work. To clarify a few points:

1. TS server is on a different machine (does this matter?)
2. IP of the connecting server (where the forum is) is whitelisted
3. The MOD was installed on a fresh instance of phpBB3 3.0.9 with no other mods, however, data was imported from another phpBB3 forum (same version) with the old EVE API mod.
4. I'm also seeing this in my config panel (is this normal?) screenshotscreenshot
5. The drop-downs where I must select a group in any part of the MOD does not contain any pre-determined forum groups, only those that have been created manually.

I appreciate your attention! Thanks in advance!

• TeamSpeak on another server doesn't matter.
• Screenshots are normal behavior; mod supports up to 5 special groups for both forum and TeamSpeak. Reason they look the same, is that they use the same language file.
• Dropdown menu doesn't show defaultgroups on purpose, you should always make your own groups for each EVE Entity. Within phpBB you can easily add the permissions of those default groups to any other group you like.

Even though you have fixed it, let me explain what the error is about.
'invalid URI supplied' means that something is wrong with the URI used to connect to the TeamSpeak server.
Settings for that URI can be changed in the AdminCP, as well as the 'nickname' flag.
If you keep that 'nickname' flag empty, you don't need to manually edit the code and remove it there.

11-13-2011 19:04:00 Username User is part of corporation -> Corp
11-13-2011 19:04:00 Username Removing user from Forum group -> Group A
11-13-2011 19:04:00 Username Removing user from Forum group -> Group B

Hello,
was the cron meant to be fixed removing ppls from other user groups with version 5.1?
Cause on our forum they are still getting remoed :(
Did I miss to replace a file?




Thx in advance


Desas

I'd try to install your awesome mod on my corporation phpBB forum. I checked the folder tree on the package and I saw a folder named 'pre_edit'. My phpBB is already modded and I think I've edited also a couple of files on the 'pre_edit' folder.

Have you got some sort of 'search for:' and 'replace with:' instructions to edit those files? I'm a little bit preoccupied to upload the 'pre_edit' folder because I'm scared to mess with previous installed mod.

Thanks in advance for your support.

Bst rgds,
Attoy.

Will be added in the v5.2 package once released.

Hello,
was the cron meant to be fixed removing ppls from other user groups with version 5.1?
Cause on our forum they are still getting remoed :(
Did I miss to replace a file?




Thx in advance


Desas

Experiencing the same issue... all users get removed from all other usergroups except the one they register into. Also, I am experiencing the following error for some users when they try to register (I even did this with my own alt on another account and still got the error):

Character and API settings do not match -> CharName

I triple-verified the key, tried to create a new one, and even ticked all boxes when creating the key meaning all info is shared - still no luck. Thoughts?

This mod is awesome.

I do have 2 issues though.

1. The names of the options are not showing completely. Check out the screenshot below:

[IMG]http://www.image-share.com/upload/1079/263m.jpg

2. I cannot register. It's giving me the message "This character is not permitted to have an account on this forum.". Check the screenshot below:

[IMG]http://www.image-share.com/upload/1079/264m.jpg


How do I fix this? Thanks..

exception 'TeamSpeak3_Transport_Exception' with message 'Connection timed out' in

/****/*******/public_html/forums/includes/eveapi/TeamSpeak3/Transport/TCP.php:54 Stack trace: #0

/****/*******/public_html/forums/includes/eveapi/TeamSpeak3/Transport/TCP.php(108):

TeamSpeak3_Transport_TCP->connect() #1

/****/*******/public_html/forums/includes/eveapi/TeamSpeak3/Adapter/ServerQuery.php(76):

TeamSpeak3_Transport_TCP->readLine() #2

/****/*******/public_html/forums/includes/eveapi/TeamSpeak3/Adapter/Abstract.php(60):

TeamSpeak3_Adapter_ServerQuery->syn() #3

/****/*******/public_html/forums/includes/eveapi/TeamSpeak3/TeamSpeak3.php(294):

TeamSpeak3_Adapter_Abstract->__construct(Array) #4

/****/*******/public_html/forums/includes/eveapi/functions_eveapi.php(81): TeamSpeak3::factory

('serverquery://s...') #5 /****/*******/public_html/forums/includes/ucp/ucp_profile.php(207):

eveapi_setTeamSpeakGroups() #6 /****/*******/public_html/forums/includes/functions_module.php(507)

You need to change the language of the admin account to British English, check my previous posts. I had the same issue.

It is in British English, its actually the only language available on my board :(

Clear new install Version: phpBB 3.0.10

I copyed all the files form the zip in the first post:
"new_files"
"pre_edit"

and ran the SQL on the phpbb DB from "sql"

I was able to add all the mods but now when I try to go to the Administration Control Panel I get this error:

Fatal error: Call to undefined function phpbb_version_compare() in /home/eveamp/public_html/forum/includes/acp/acp_main.php on line 419

Line 419 of forum/includes/acp/acp_main.php is: 'S_VERSION_UP_TO_DATE'=> phpbb_version_compare(trim($latest_version_info[0]), $config['version'], '<='),

Please help

Clear new install Version: phpBB 3.0.10

I copyed all the files form the zip in the first post:
"new_files"
"pre_edit"

and ran the SQL on the phpbb DB from "sql"

I was able to add all the mods but now when I try to go to the Administration Control Panel I get this error:

Fatal error: Call to undefined function phpbb_version_compare() in /home/eveamp/public_html/forum/includes/acp/acp_main.php on line 419

Line 419 of forum/includes/acp/acp_main.php is: 'S_VERSION_UP_TO_DATE'=> phpbb_version_compare(trim($latest_version_info[0]), $config['version'], '<='),

Please help

Great mod gratz to you Cyerus



Problem doesn't come from the mod but from the bz2 package of phpBB. Download the 3.0.10 full package on zip format. Get the 2 files from that package and replace the old files from your server and it should work

Warning: require(./includes/startup.php) [function.require]: failed to open stream: No such file or directory in /home/dominant/public_html/mindstar-technology.net/forums/common.php on line 19

Warning: require(./includes/startup.php) [function.require]: failed to open stream: No such file or directory in /home/dominant/public_html/mindstar-technology.net/forums/common.php on line 19

Fatal error: require() [function.require]: Failed opening required './includes/startup.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/dominant/public_html/mindstar-technology.net/forums/common.php on line 19

Is it possible to add more than 5 groups to the auto purge immune list?

Been looking at the code, but I don't know a lot about php and the few tweaks I did myself didn't seem to do anything.

Call me a ****** but, What folder do I place these files in.......

How can i increase the amount of corps that are on the corp list?!?

Any help on this would be amazing!!

Hello Awesome MOD, I have managed to get it installed and ready but every time i upload the common.php file i get this error:



any help would be great and i know there isnt a file called startup.php ?

Found a bug that was causing the bbcode to not work correctly.


bbcode.php

find
if(!is_null($row['marketID']))

replace with
if(!is_null($row['itemID']))

Have you uploaded all the files from pre_edit as well as new_files to the root of your forum?
In other words, did you use the XML with AutoMOD or did you manually install the mod instead?

I manually installed the mod using the files from new_files and pre_edit, and haven't come across any issues yet.

Can't do much about the PHEAL error, you'll have to report that in the PHEAL thread.

reproduced the error still the same on the main domain.
on a home installation of xampp it works fine
so it is probably the webserver itself being blocked from the api server

The recent CCP changes and changes to the app's themselves require an upgrade of the core software of our servers.

Specifically Curl and Simple XMl

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?

if you not are using the Teamspeak 3 mod then delete Line 45 "cronlog("TeamSpeak 3 Framework -> version " . TeamSpeak3::LIB_VERSION);" and try and run it by your self with Domain/eveapi_cron.php and it should run fine "delete or comment it out with // in front of the line

SQL ERROR [ mysqli ]

Table '[insertdomain]_bb.eveapi_systems' doesn't exist [1146]

SQL

SELECT * FROM eveapi_systems WHERE systemName = "Erenta"

BACKTRACE

FILE: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/includes/bbcode.php
LINE: 637
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/bbcode.php(112) : regexp code
LINE: 1
CALL: bbcode->bbcode_second_pass_evesystem()

FILE: [ROOT]/includes/bbcode.php
LINE: 112
CALL: preg_replace()

FILE: [ROOT]/viewtopic.php
LINE: 1407
CALL: bbcode->bbcode_second_pass()

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

Thats something that pissed me off also.

like if it was possible then make it so it move them to a group you make with no perrmissions other that edit profile so they have a chance to update the key, since i have a lot memberst hat forget to click no expiry so i have to update the key my self

No, I will not change that when an user has invalid API details, the account will be disabled.
Simple reason: Why would an user be part of an EVE-based forum without API details?

there is 1 simple reason for that.

stupid members who is clueless about the API and cant find the no expiry box. each day i have to reactivate like 2-4 accounts

it would be alot better if the cron would move them to a non permission / guest permission group where they can login and update the API data if the data is correct then it would put them into Member group again

Those users can use link-to-forum.com/eveapi_update.php to re-enable their own account with new API settings.

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

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.

# 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

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...

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

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

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?

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

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?

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

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

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.

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!

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 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

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

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"

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

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?

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...)

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.

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"

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

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

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

[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]

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.

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.

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

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?

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

**snip**

Now with wget i get:



And there are nothing in httpd error.log

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 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!

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..

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