Author |
Topic |
 Akov Stohs Windowlickers Inc |
Posted - 2011.01.13 08:48:00 - [ 151]
Edited by: Akov Stohs on 13/01/2011 09:10:55tracked down my problem to the field "ID_MEMBER" apparently as part of some upgrade this was either added or removed as it is currently not part of the table structure...still disecting the code but I found this in tables.php from the svn repository: Quote:
$info[1]['old'] = 'eve_api'; $info[1]['name'] = 'tea_api'; $info[1]['primary'] = 'ID_MEMBER, userid'; $tables[1]["ID_MEMBER"] = "INT"; $tables[1]["userid"] = "INT DEFAULT NULL"; $tables[1]["api"] = "VARCHAR(64) DEFAULT NULL"; //$tables[1]["characters"] = "VARCHAR(150) DEFAULT NULL"; //$tables[1]["charid"] = "INT DEFAULT NULL"; $tables[1]["status"] = "VARCHAR(20) DEFAULT NULL"; $tables[1]["matched"] = "VARCHAR(20) DEFAULT NULL"; $tables[1]["errorid"] = "INT(5) DEFAULT NULL"; $tables[1]["error"] = "VARCHAR(254) DEFAULT NULL"; $tables[1]["status_change"] = "INT DEFAULT NULL"; //$tables[1]["auto"] = "INT(1) DEFAULT 1";
Edit: Was able to force some error messages from it... Access denied for user 'Apache'sUsername'@'localhost' (using password: NO) |
 Akov Stohs Windowlickers Inc |
Posted - 2011.01.20 03:49:00 - [ 152]
Pulling the latest from code.google has resulted in some pretty broken things...Also think Temar is afk so any new adopters may wish to wait until the next update to use this. |
 Blue Sassley Caldari The Ankou Raiden. |
Posted - 2011.02.04 01:27:00 - [ 153]
So I'm guessing this has grinded to a halt? |
 Floydd Heywood |
Posted - 2011.02.07 11:23:00 - [ 154]
This seems to work ok and does what is needed until ESAM is developed for SMF 2.
One thing that does not work anymore is the option to use your EVE avatar, because the new avatars came after the last update to this mod.
Even if it still worked, it would leave it up to the user whether he wanted to use his EVE avatar or another picture.
To enforce the use of the correct character portrait you can use this simple php script:
--- <?php
$avatar_url_head = 'http://image.eveonline.com/Character/'; $avatar_url_tail = '_128.jpg';
$con = mysql_connect('localhost', 'usernameforyourdatabase', 'passwordfordatabase'); if (!$con) { die('connection to db failed: ' . mysql_error()); } mysql_select_db ('nameofyourdatabase') or die ('could not select database');
$query = 'SELECT m.id_member FROM smf_members AS m JOIN smf_tea_api AS a ON m.id_member=a.id_member';
$result = mysql_query($query, $con);
while ($row = mysql_fetch_row($result)) { $member_id = $row[0]; $query= "select c.charid from smf_tea_characters as c join smf_tea_api as a on c.userid=a.userid join smf_members as m on a.id_member=m.id_member where m.id_member = " . $member_id . " and m.real_name like concat('%', c.name, '%')"; $result2 = mysql_query($query, $con); $row2 = mysql_fetch_row($result2); $char_id = $row2[0]; if ($char_id != '') { $query = "UPDATE smf_members SET avatar= '" . $avatar_url_head . $char_id . $avatar_url_tail . "' WHERE id_member = " . $member_id; mysql_query($query, $con); } };
$con.close();
?> ---
Replace the bold words with your database credentials, then upload the script somewhere on your server. Upon execution it pulls the avatar URL for all forum users that have a valid API key and writes them to the database. SMF 2 conveniently uses the "external avatar" whenever it finds one set in the members table, so setting the field enforces its use.
User accounts that have no api key or whose key is invalid (e.g. expired accounts) are not modified.
Using a cron job to execute this every hour or day would be a good idea. |
 Blue Sassley Caldari The Ankou Raiden. |
Posted - 2011.02.08 20:08:00 - [ 155]
Well I tested your script out, and it seems to not be grabbing the charid correctly from the database as all the images are showing just http://image.eveonline.com/Character/1_128.jpg
Thanks, Blue |
 Temar Radeik Intergalactic Syndicate Nulli Secunda |
Posted - 2011.02.21 15:03:00 - [ 156]
1.1.2 Beta Release
---------------------- Version 1.1.1 -> 1.1.2 Beta ---------------------- New Features - Now Supports Sockets to get data from eveonline if curl not installed
Bug Fixes - Run Table Check on Upgrade - Removed use of split() function as its deprecated - Fixed Avatar to new address - Fixed check for esam upgrade - Added a check for open_basedir and safe_mode when using CURLOPT_FOLLOWLOCATION
|
 Blue Sassley Caldari The Ankou Raiden. |
Posted - 2011.02.21 19:22:00 - [ 157]
Thanks for the update! So far working great! One thing, how do I clean up the: Quote: 8: Undefined index: tea File: /var/www/vhosts/domian/httpdocs/Sources/TEA.php Line: 2548
In the SMF logs? Thanks, Blue |
 Akov Stohs Windowlickers Inc |
Posted - 2011.02.28 21:16:00 - [ 158]
Glad to have you back Temar :] |
 Count'Dus LIGHTS 0UT Gypsy Band |
Posted - 2011.03.07 13:33:00 - [ 159]
Edited by: Count''Dus on 07/03/2011 13:33:26Good day, Temar! I've installed TEA 1.1.2 Beta version on my SMF 2.0 RC5 and can't see any menus of mod in "Features and Options". There were no errors during installation process. In "Features and Options" i have only: General - Layout - Signatures - Profile Fields  Packages browser shows me that I've installed 1.1.1 version, and everything is OK, but  Please, can you help me fix a problem? Thanks! P.S. BFF  |
 Temar Radeik Intergalactic Syndicate Nulli Secunda |
Posted - 2011.03.07 15:41:00 - [ 160]
it not under features and options its got its own area look thurther down the list (usually bottom) |
 Count'Dus LIGHTS 0UT Gypsy Band |
Posted - 2011.03.09 21:47:00 - [ 161]
Oh, thanks! My bad  |
 Count'Dus LIGHTS 0UT Gypsy Band |
Posted - 2011.03.10 22:33:00 - [ 162]
Hello, Temar! Me again I found an issue: using Main Group rule doesn't assign the Main Group to user. Only additional group. API checker sais: "%username% Not Monitored 1". Rule #2 (for main group) exists, but "not monitored". Hes checking only rule #1 (for additional group). I don't know why  |
 Seymore Graves The New Era C0NVICTED |
Posted - 2011.03.17 03:13:00 - [ 163]
For those of you having issues with the "Get characters" button, chmodding the TEA_xmlhttp.php file located in your forums root directory to 644 seems to resolve the issue for most people. |
 Bos Haus |
Posted - 2011.03.18 02:20:00 - [ 164]
any plans on updating this to support RC5? |
 Monty Raynolds |
Posted - 2011.03.18 16:26:00 - [ 165]
If there's anyone still working on this I've noticed a couple of problems.
For some reason the cache doesn't work and nothing is downloaded. Runing the cron script outputs a load of errors and no rules get processed.
Also standings is coming from standings.xml.aspx but I believe it should be ContactList.xml.aspx.
I'm willing to pay good ISK to the person that fixes these two problems. |
 Temar Radeik Intergalactic Syndicate Nulli Secunda |
Posted - 2011.03.20 06:12:00 - [ 166]
Fixed standings will do some more work tomorrow
Will do another Beta Release in a few days or you can use SVN to get now |
 Duke Rottingham |
Posted - 2011.03.20 07:32:00 - [ 167]
Originally by: Temar Radeik Fixed standings will do some more work tomorrow
Will do another Beta Release in a few days or you can use SVN to get now
Good to know. Thanks. |
 Temar Radeik Intergalactic Syndicate Nulli Secunda |
Posted - 2011.03.20 16:49:00 - [ 168]
Tested on RC5 with no Problems so unless you get errors during install/upgrade of TEA u can asume it will work with RC5 |
 Temar Radeik Intergalactic Syndicate Nulli Secunda |
Posted - 2011.03.21 05:14:00 - [ 169]
Cache has already been fixed in SVN and will be in next release as for Cron, Yes i see alot of errors too, but they are just undefined Errors do u have a Proper Error in that stop that stops it running? most likly bottom 1 |
 Count'Dus LIGHTS 0UT Gypsy Band |
Posted - 2011.03.21 15:39:00 - [ 170]
What about with assigning Main Groups by Rule? |
 BearUkraine Gallente Light Style
|
Posted - 2011.03.24 14:15:00 - [ 171]
Edited by: BearUkraine on 24/03/2011 14:15:15 Hi I have installed this mod on clear forum RC5, but button "settings" doesnt work. I got blank page. "Rules" and "Checks" work ok.
I downloaded the latest version from SVN. Any idea? |
 Iaeenu Minmatar Sin Factory Anarchy Unlimited |
Posted - 2011.03.31 03:54:00 - [ 172]
I just did a fresh install of SMF 2.0 RC5. Then installed the api mod. I made a few forums and a couple usergroups and made 2 rules. I went to Checks and a ran a member check it took away my admin rights. Is there a guide for setup or can I contact you for help? I am willing to pay isk. Been going nuts with this for 2 days now.
Thank you. |
 Temar Radeik Intergalactic Syndicate Nulli Secunda |
Posted - 2011.04.01 00:29:00 - [ 173]
Edited by: Temar Radeik on 01/04/2011 00:29:17 You prob have Admin ticked at top of rules page this basicly means it will check users in that group and change to the group is matched altho the option is provided, most cases the Administrator Group is not ticked for monitoring |
 Iaeenu Minmatar Sin Factory Anarchy Unlimited |
Posted - 2011.04.01 03:43:00 - [ 174]
Thank you Temar for the prompt reply. I really appreciate it. |
 Temar Radeik Intergalactic Syndicate Nulli Secunda |
Posted - 2011.04.12 15:16:00 - [ 175]
Coming Soon: TeamSpeak 3 Support
Closed Beta: Most Stuff are now Complete for the next Version of TEA which includes TeamSpeak 3 Support im after a Few users to join the Beta and help make sure everything is working will ofc require that you have a TeamSpeak 3 Server Contact me ingame or on MSN chris_smith96 hotmail com |
 Avok Epsilon Lyr BPLAN |
Posted - 2011.04.15 22:23:00 - [ 176]
Edited by: Avok on 15/04/2011 22:37:14 Edited by: Avok on 15/04/2011 22:23:48 Seems registration with rule based on API for account with 3 neutrals character on it works great (they cant acces the reserved content to corp member).
But, after registering with another api with 3 another characters (2 neutrals and one corp mate) selecting the neutral character during registering, i can acces the reserved content that is nomally not accessible for neutrals...
Can you check ? Do i miss a specific rule ?
EDIT : find the solution... following this : * Rules for Main Group are checked in Order of ID Create a rule for ISNT corp member (no access private content) then a second IS corp member (access private content)
|
 Temar Radeik Intergalactic Syndicate Nulli Secunda |
Posted - 2011.04.16 00:52:00 - [ 177]
The Character Selection during Registration is used for Setting the Name and Avatar and nothing todo with rules
he would of got access because 1 character was in corp, regardless of which char he selected
the way you set-up after that, basicly has it check the account and if ANY of the characters arnt in the corp it matches to that group because its a main group it then uses that and doesn't check any below |
 Count'Dus LIGHTS 0UT Gypsy Band |
Posted - 2011.04.17 15:16:00 - [ 178]
Originally by: Count'Dus Hello, Temar!
Me again
I found an issue: using Main Group rule doesn't assign the Main Group to user. Only additional group.
API checker sais: "%username% Not Monitored 1". Rule #2 (for main group) exists, but "not monitored". Hes checking only rule #1 (for additional group).
I don't know why
 |
 Temar Radeik Intergalactic Syndicate Nulli Secunda |
Posted - 2011.04.18 02:04:00 - [ 179]
Sorry for not replying to that
my guess is the users main group is set to not be monitored these are set at the top of the rules page usually used for stuff like Admin group so it doesnt remove it basicly if unticked the group will not be removed in case of main group it wont be changed |
 Temar Radeik Intergalactic Syndicate Nulli Secunda |
Posted - 2011.04.18 03:29:00 - [ 180]
1.2.0 Released
The Main Feature of this Release is the Support for Registering and Managing TeamSpeak 3
---------------------- Version 1.1.2 -> 1.2.0 ---------------------- New Features - TeamSpeak 3 Support, This includes Registering via User uniqueKey or being on the server and having it find you Also Maintains users Access, will smf and Ts group linking, and can enforce nicknames - Added Setting of a Main Character and Improved the Realname and Avatar Setting Options - Added TEA to profile dropdown menu
Bug Fixes - Fixed bug that showed full forum page instead of character list when registering |