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.
 

TEA (v1.3.1) - Member Management Mod for SMF 2, TeamSpeak 3 and Jabber

Author
Fisnar Jejrhald
Ailes Grises
#321 - 2014-07-12 13:08:13 UTC
cheack

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 1
Файл: /var/www/fisnar/data/www/ailes-grises.ru/Sources/TEA.php
Строка: 2757
Shin Chogan
Federal Navy Academy
Gallente Federation
#322 - 2014-07-13 07:56:23 UTC
Minibren wrote:
Is there a way to force an update of the alliance corp list? When corps leave the alliance it does not automatically remove them from groups as it says their corp is still in the alliance, its been 2 days and its still not updated.

Edit:
Seems to update every 2 days.



A lot of that problem is actually down to CCP ... we found this issue with our new and old corps ... the API data doesn't actually seem to update very frequently.
Shin Chogan
Federal Navy Academy
Gallente Federation
#323 - 2014-07-13 07:58:38 UTC
Fisnar Jejrhald wrote:
whether it is possible to use mumble instead of team speak?


Look further back in this thread ... short answer ... no.
Shin Chogan
Federal Navy Academy
Gallente Federation
#324 - 2014-07-13 08:00:07 UTC
Fisnar Jejrhald wrote:
[ERROR] API is returning invalid XML



Yes that is a nice error message isn't it ... thanks for sharing :)

CCP are not sending you valid XML
Shin Chogan
Federal Navy Academy
Gallente Federation
#325 - 2014-07-13 08:03:41 UTC
Fisnar Jejrhald wrote:
cheack

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 1
Файл: /var/www/fisnar/data/www/ailes-grises.ru/Sources/TEA.php
Строка: 2757



At a guess you have no valid api keys in your database ... and have never had any and are trying to run the check all api's job.
MN8
No Fixed Address Inc.
EVICTION NOTICE LTD
#326 - 2014-08-02 23:21:35 UTC  |  Edited by: MN8
Hey Guys.

Firstly I would just want to say that this is truly a great mod. Hat's off to you for working so hard on it!

Secondly, I have some questions which have already been raised before but the answers may need updating due to changes in the code...

I am looking to obtain and full API key, disable sign up if one is not produced and get the Full Member Check to flag an issue if it's not a full key.

I've seen some suggestions such as;

Quote:
Bit of a hack at present but if you find

$accessMask = (int)$xml;

Should be about line 156 in *path to forum*/Sources/TEA.php

then add just under it

if ($accessMask == 268435455)
return True;
else
return False;

that should cause people to see an error if they haven't entered a Full API key.


This code now appears to be different as follows...

Quote:
$accessMask = (int)$xml->result[0]->key[0]['accessMask'];
$result['access'] = array(
'Wallet Transactions' => ($accessMask & 4194304) > 0,
'Wallet Journal' => ($accessMask & 2097152) > 0,
'Market Orders' => ($accessMask & 4096) > 0,
'Account Balance' => ($accessMask & 1) > 0,
'Notification Texts' => ($accessMask & 32768) > 0,
'Notifications' => ($accessMask & 16384) > 0,
'Mail Messages' => ($accessMask & 2048) > 0,
'Mailing Lists' => ($accessMask & 1024) > 0,
'Mail Bodies' => ($accessMask & 512) > 0,
'Contact Notifications' => ($accessMask & 32) > 0,
'Contact List' => ($accessMask & 16) > 0,
'Contracts' => ($accessMask & 67108864) > 0,
'Account Status' => ($accessMask & 33554432) > 0,
'Character Info Priv' => ($accessMask & 16777216) > 0,
'Upcoming Calendar Events' => ($accessMask & 1048576) > 0,
'Skill Queue' => ($accessMask & 262144) > 0,
'Skill In Training' => ($accessMask & 131072) > 0,
'Character Sheet' => ($accessMask & 8) > 0,
'Calendar Event Attendees' => ($accessMask & 4) > 0,
'Asset List' => ($accessMask & 2) > 0,
'Character Info' => ($accessMask & 8388608) > 0,
'Standings' => ($accessMask & 524288) > 0,
'Medals' => ($accessMask & 8192) > 0,
'KillLog' => ($accessMask & 256) > 0,
'Fac War Stats' => ($accessMask & 64) > 0,
'Research' => ($accessMask & 65536) > 0,
'Industry Jobs' => ($accessMask & 128) > 0


I've also seen the following pertaining to the not allowing members to sign up if the mask is wrong...

Quote:
I added access mask checking in the last (or possibly the one before that) release.
find function checkmask($xml) in TEA.php and modify to suit your needs ... if you don't care if they've put in a key that will break some of the rule checking then the quick way is to change the line :

return False;

to

return True;


if you don't want them to have to put in an account key then find the if statement in TEA.php :

if ($accnt->result[0]->key[0]['type']!="Account")

and comment out the whole block. There are 3 of them


Is this still valid?

Any help would be appreciated. Smile
MN8
No Fixed Address Inc.
EVICTION NOTICE LTD
#327 - 2014-08-03 18:54:08 UTC
Ok, so I think I have nailed part of it...

Quote:
if ( ( ($result['access']['Character Info']) || ($result['access']['Character Info Priv']) ) && ($result['access']['Wallet Transactions']) && ($result['access']['Wallet Journal']) && ($result['access']['Market Orders']) && ($result['access']['Account Balance']) && ($result['access']['Notification Texts']) && ($result['access']['Notifications']) && ($result['access']['Mail Messages']) && ($result['access']['Mailing Lists']) && ($result['access']['Mail Bodies']) && ($result['access']['Contact Notifications']) && ($result['access']['Contact List']) && ($result['access']['Contracts']) && ($result['access']['Account Status']) && ($result['access']['Upcoming Calendar Events']) && ($result['access']['Skill Queue']) && ($result['access']['Skill In Training']) && ($result['access']['Character Sheet']) && ($result['access']['Calendar Event Attendees']) && ($result['access']['Asset List']) && ($result['access']['Standings']) && ($result['access']['Medals']) && ($result['access']['KillLog']) && ($result['access']['Fac War Stats']) && ($result['access']['Research']) && ($result['access']['Industry Jobs']) )
{
return True;
}
else
{
return False;
}
}
Cailith Akhragen
Science and Trade Institute
Caldari State
#328 - 2014-08-09 01:18:58 UTC  |  Edited by: Cailith Akhragen
Hello,

I'm sorry if this has been asked and solved before, but I've run into a few problems trying to set-up TEA. I keep getting the error

Quote:
API System Screwed - Can't fetch Toons : API System Screwed - Can't Fetch Standings : API call error while fetching standings: Error Code =


when I enter an API Key into the TEA > Configuration > Settings. The error just sits there at the top of the page. I've verified the API key details are correctly copied from the EVE API website. I'm using a full key (all characters everything ticked on, no expiry date) and have tried limiting the API access to specific fields, but still get the same error. I've performed the SMF installation myself and believe it to be configured properly. Is this a known issue, what have I done wrong, and is there any other information I can provide to diagnose the problem?
lasterax
Republic Military School
Minmatar Republic
#329 - 2014-08-10 19:34:38 UTC
Getting pressed for Jabber integration again so I'm trying to slay the beast.

Openfire and SMF are on the same server. SMF can see the Openfire groups fine and I'm able to set all the rules so clearly it has read access to the database.

However, it's not doing any writes for new users, they never get added to the group selected. I don't get that as I've set up the service with a user with ample permissions.

Does anyone have this all up and working well that could give me some pointers? I'm not seeing anything in the error log, all I see from SMF is:

Quote:
http://SMF Server/index.php?action=admin;area=tea;sa=jabber
8192: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead
File: /var/www/html/Sources/TEA_Jabber_OF.php
Line: 30


Thanks.
lasterax
Republic Military School
Minmatar Republic
#330 - 2014-08-10 22:38:07 UTC
Actually looks like I figured this out, I think I borked the User Service allowed IPs. Once I threw spaghetti at it (localhost, 127.0.0.1, and the server's IP) it looks like it's working.

--Rax
Gem Hadah
Imperial Academy
Amarr Empire
#331 - 2014-09-02 03:56:40 UTC  |  Edited by: Gem Hadah
Hello, I'm having an issue with the standings being updated under "settings"

Standings Last Updated: NeverStandings List Contains: 0 Blue Contacts, 0 Red ContactsAlliance Corp List Last Updated: 14:12 Mon 01 Sep 14 (GMT)Alliance Corp List Contains: 14301

Here are my cronjobs

*/6 * * * * xxxx/TEA_Cron.php
*/5 * * * * xxxx/TEA_Jabber_Cron_Access.php
*/4 * * * * xxxx/TEA_TS_Cron_Access.php
*/1 * * * * xxxx/TEA_TS_Cron_Names.php
*/2 * * * * xxxx/TEA/eve_corplist.php
*/3 * * * * xxxx/TEA/db_clean_up.php


Have I messed something up?

edit - i might have fixed with using a full corp director level API, is that required vs a personal full api?
MN8
No Fixed Address Inc.
EVICTION NOTICE LTD
#332 - 2014-09-27 00:21:52 UTC
Cailith Akhragen wrote:
Hello,

I'm sorry if this has been asked and solved before, but I've run into a few problems trying to set-up TEA. I keep getting the error

Quote:
API System Screwed - Can't fetch Toons : API System Screwed - Can't Fetch Standings : API call error while fetching standings: Error Code =


when I enter an API Key into the TEA > Configuration > Settings. The error just sits there at the top of the page. I've verified the API key details are correctly copied from the EVE API website. I'm using a full key (all characters everything ticked on, no expiry date) and have tried limiting the API access to specific fields, but still get the same error. I've performed the SMF installation myself and believe it to be configured properly. Is this a known issue, what have I done wrong, and is there any other information I can provide to diagnose the problem?


I am now getting the exact same problem. Did you find an answer to this issue?
Rouque Vanderbuilt
Balanced Unity
Goonswarm Federation
#333 - 2014-10-07 11:08:09 UTC  |  Edited by: Rouque Vanderbuilt
I am using
Openfire 3.9.3
SMF 2.0.9
TEA 1.3.1 r7
Java 7 (maby the problem) Question
User Service 2.0.0 (maby the problem)Question

No User' want build on Openfire Server over the Forum if you fill the form.

I have test it on Debian 6 and 7 ( Java 7 on both Systems)
Java 6 dont work with Openfire 3.9.3 Plugins
Rouque Vanderbuilt
Balanced Unity
Goonswarm Federation
#334 - 2014-10-07 11:18:18 UTC
lasterax wrote:
Getting pressed for Jabber integration again so I'm trying to slay the beast.

Openfire and SMF are on the same server. SMF can see the Openfire groups fine and I'm able to set all the rules so clearly it has read access to the database.

However, it's not doing any writes for new users, they never get added to the group selected. I don't get that as I've set up the service with a user with ample permissions.

Does anyone have this all up and working well that could give me some pointers? I'm not seeing anything in the error log, all I see from SMF is:

Quote:
http://SMF Server/index.php?action=admin;area=tea;sa=jabber
8192: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead
File: /var/www/html/Sources/TEA_Jabber_OF.php
Line: 30


Thanks.


maby we have the same problem.
8192: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

we need also...

8192: mysqli_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

also this is code fail Question
Tahnil
Gunboat Commando
#335 - 2014-10-07 11:48:05 UTC
Sorry, can‘t help you.

But is Shin Chogan still around? His last postings are several months old :-(
Rouque Vanderbuilt
Balanced Unity
Goonswarm Federation
#336 - 2014-10-07 14:32:27 UTC
The next i find out:

Openfire dont like names are "marvin mueller" or "marvin_mueller" ..... "marvinmueller" are acceptet Shocked
Nutbolt
University of Caille
Gallente Federation
#337 - 2014-10-07 19:57:29 UTC  |  Edited by: Nutbolt
Rouque Vanderbuilt wrote:
I am using
Openfire 3.9.3
SMF 2.0.9
TEA 1.3.1 r7
Java 7 (maby the problem) Question
User Service 2.0.0 (maby the problem)Question

No User' want build on Openfire Server over the Forum if you fill the form.

I have test it on Debian 6 and 7 ( Java 7 on both Systems)
Java 6 dont work with Openfire 3.9.3 Plugins


I believe I am also experiencing the same issue. It worked fine before upgrading User Service to 2.0.0 I think. My connection to the openfire DB seems fine, it just won't create a user for it.

Can anyone find a download link for UserService 1.4.4 so we can test if this is the case?
Rouque Vanderbuilt
Balanced Unity
Goonswarm Federation
#338 - 2014-10-07 21:40:30 UTC
New Version of User Service Plugin

2.0.1 -- October 7th, 2014
  • Fixed the problem that authentication type was not saved

  • .... same Problem .. not Fix it Cry
    Nutbolt
    University of Caille
    Gallente Federation
    #339 - 2014-10-08 13:09:46 UTC  |  Edited by: Nutbolt
    Right, it was a mission but I have tracked down a link for the UserService 1.4.4 plugin. This has fixed the issue.
    http://bamboo.igniterealtime.org/browse/OPENFIRE-NIGHTLYPLUGINS-1355/artifact/shared/Project-Plugins/

    I will do my best to look into the problem but I am a crap coder so no promises at all.

    Edit: The issue lies in that the UserService plugin has moved onto a RESTful API. Although the changelog states its backwards compatible, it clearly isn't. Hopefully this is an issue which will be fixed with the plugin. However TEA is now using a deprecated API to create and edit jabber users and should really be updated by someone who actually understands how to code it.

    Edit2: Version 2.0.2 of the UserService plugin has just been released which has fixed the problem. So simply update to the most recent version to get it working again. But it should be noted that we are now using a deprecated API and it should still be fixed.
    Rouque Vanderbuilt
    Balanced Unity
    Goonswarm Federation
    #340 - 2014-10-08 22:15:08 UTC
    I have test it with User Service 2.0.2 ...don't work Sad
    The older Version are not running with JVM: 1.7.0_67 Oracle Corporation -- Java HotSpot(TM) 64-Bit
    and Openfire 3.9.3