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 » TEA (v1.2.1) - Member Management Mod for SMF 2, TeamSpe...

Topic is locked indefinitely.

First pagePrevious page2728293031Next page

TEA (v1.2.1) - Member Management Mod for SMF 2, TeamSpeak 3 and Jabber First post
Author

Previous Topic Next Topic

Nisroc Angels The Obsidian Front - Reborn 445
Ynot Eyob Nisroc Angels The Obsidian Front - Reborn Likes received: 445	#561 - 2013-08-27 11:39:34 UTC Shin Chogan If we can posible solve this together, at some point once im home from Work, ill trow two plex your way for your work. Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".

Shin Chogan

Federal Navy Academy

Gallente Federation

Likes received: 60

#562 - 2013-08-27 12:06:24 UTC | Edited by: Shin Chogan

Ynot Eyob wrote:

Ty,

Iv walked trough the database, and no Realnames was empty

Im still getting the same errors.

I think if i could fix this:

Check Full Member Now

With the error:
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
File: C:\XXXXXXX\TEA.php
Line: 2408

It might solve the rest.

Line 2408:
$users1 = $this -> smcFunc['db_query']('', "SELECT id_member, member_name, ID_GROUP FROM {db_prefix}members WHERE id_member <= ".$this -> lastid);

What i dont understant, but yet again im a .NET programmer not a php programmer, if i make an Echo on $this i get this:
API System Screwed : bool(false)

Now how would that fit in with "Where id_member <="

Would this mean, that im not getting an ID from the API, and it cannot compare and string with an integer?

This would then make sence with the error 500.

And then my last question would be, 169 worked, so if it cant pull an API now, whats changes from 169 that could make this happen.

OK lets work on this bit ... 169 was the last build by the original author ... LOTS has changed since then mostly around error checking though CCP have also changed to https from http and changed the way they do errors - I don't know when you upgraded to my latest release.

You are running on Windows does that version of PHP have the curl functions ? Since CCP switched to https everything will fail if you don't have them.

I've uploaded a new test version :

https://docs.google.com/file/d/0BwWRlORSHGGeVFdZaE1rRV9pcUE/edit?usp=sharing

All it should do is die in a slightly different way if you don't have the CURL stuff available. if you echo $this again you should get something like

API System Screwed : NO CURL

I hope :)

Ynot Eyob

Nisroc Angels

The Obsidian Front - Reborn

Likes received: 445

#563 - 2013-08-27 12:29:10 UTC | Edited by: Ynot Eyob

Iv changed directly from 169 to yours 179

The old 169 i changed the TEAP to use https and that worked without issues.

PHP Version 5.2.17

cURL is installed

curl
cURL support enabled
cURL Information libcurl/7.21.0 OpenSSL/0.9.8q zlib/1.2.3

Your new version made no different

$Echo .$this
API System Screwed : bool(false)

With the new version. I deleted all old TEA files before installing this.

I know dont fix what aint broken :p

Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".

Shin Chogan

Federal Navy Academy

Gallente Federation

Likes received: 60

#564 - 2013-08-27 12:46:37 UTC | Edited by: Shin Chogan

Ynot Eyob wrote:

There is a Lot broke in 169 :)

ok in TEA.php find :

echo "API System Screwed : \n";

it should be on line 187 or there abouts. ... the next line reads :

var_dump ($accnt);

change that to:
var_dump ($accnt);die;

then run the TEA_cron.php from the command line so you can see the output.

edit ... another thought ...
in the function single in TEA.php ... line 234 ish ... uncomment the first line so that is does echo $user . " - ";


Ynot Eyob Nisroc Angels The Obsidian Front - Reborn Likes received: 445	#565 - 2013-08-27 12:55:45 UTC \| Edited by: Ynot Eyob bool(false) This forum might not be the best to finish this Ill try your edit, iv just updated the cURL libary to see if that will make a different Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".


Ynot Eyob Nisroc Angels The Obsidian Front - Reborn Likes received: 445	#566 - 2013-08-27 15:54:12 UTC None of abov helpped same issue Biggest problem now is that people cant registre on the forum anymore. They can put in their Id and vCode cut cant choose a character. Im woundering what version of php you have used for version 179 Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".

Ynot Eyob

Nisroc Angels

The Obsidian Front - Reborn

Likes received: 445

#567 - 2013-08-28 08:54:43 UTC

Well iv updated to the latest version of PHP allowed on Windows 2003.

This is what i get now:
API System Screwed - Can't fetch Toons : bool(false)

curl is running the new version also:

curl

Quote:

cURL support enabled
cURL Information 7.30.0
Age 3
Features
AsynchDNS Yes
Debug No
GSS-Negotiate Yes
IDN No
IPv6 Yes
Largefile Yes
NTLM Yes
SPNEGO Yes
SSL Yes
SSPI Yes
krb4 No
libz Yes
CharConv No
Protocols dict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, pop3, pop3s, rtsp, scp, sftp, smtp, smtps, telnet, tftp
Host i386-pc-win32
SSL Version OpenSSL/0.9.8y
ZLib Version 1.2.7
libSSH Version libssh2/1.4.2

I got you eve-mail last night, and this will be posible.
Im tempted to return to 169 for now, so at least people can register on our forum. Im our of idears

Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".

Shin Chogan

Federal Navy Academy

Gallente Federation

Likes received: 60

#568 - 2013-08-28 09:10:38 UTC

Ynot Eyob wrote:

Well iv updated to the latest version of PHP allowed on Windows 2003.

This is what i get now:
API System Screwed - Can't fetch Toons : bool(false)

This is progress Big smile

it is no longer failing at the first step but there obviously there are still problems.

I'm doing a big rewrite again ... old api key support is being removed due to CCP removing the vaguely helpful xml error codes. I'm removing the support for the raw socket fetch which is broken for https so to speed up the next release I'm just going to give an error message if you don't have CURL support in your PHP until I can work out the fun that is https over raw sockets.

As you suggest go back to 169 for now and I'll post back here when I'm done.

Ynot Eyob

Nisroc Angels

The Obsidian Front - Reborn

Likes received: 445

#569 - 2013-08-28 09:23:34 UTC | Edited by: Ynot Eyob

Worse past is i hade to make a role back on the PHP version also, as about 10 other sites crashed on the strtotime compared with date.timestamp. Fx 5 killboards....

Trying to find 169 Again

Apparently PHP 5.4.17 abov is no longer support Windows 2003 server.... Joy

php5.dll cant be registreret has an entry point issue so Windows 2003 and XP cant registre it on the new versions.

Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".

Shin Chogan

Federal Navy Academy

Gallente Federation

Likes received: 60

#570 - 2013-08-28 09:37:07 UTC

Ynot Eyob wrote:

v 169 I hope Big smile


Ynot Eyob Nisroc Angels The Obsidian Front - Reborn Likes received: 445	#571 - 2013-08-28 09:40:25 UTC Dude, you should make a new topic called TEA And state that donation is accepted, i will deffently donate something for your effort Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".

Ynot Eyob

Nisroc Angels

The Obsidian Front - Reborn

Likes received: 445

#572 - 2013-08-29 14:17:17 UTC

So reinstalled 169 Again, and made the changes as before.

Now i just get an API error.

Iv made a test SMF install blank to play around with. Here is the funny part. Iv installed the newest cURL and i made a test script, first on Google news RSS and then directly on

https://api.eveonline.com/account/APIKeyInfo.xml.aspx?keyID=XXXXX&vCode=XXXXX

Googles RSS print out fine but the account API shows nothing, not even an error just blank. This is the script i used as test:

http://stackoverflow.com/questions/181082/how-do-i-install-curl-on-windows part 2

Unless CCP have blocked my server for API calls, im out of idears, it only runs one killboard and one SMF forum so nothing API heavy calling, oh and an ingame .NET application, which actually works well. Now i should be right, by saying that cURL should print out the XML from the API

Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".

Shin Chogan

Federal Navy Academy

Gallente Federation

Likes received: 60

#573 - 2013-08-29 14:27:53 UTC

Ynot Eyob wrote:

Are you "running" the script from a browser ? If so you may find the browser is struggling to interpret the xml ... try using the view source option.


Ynot Eyob Nisroc Angels The Obsidian Front - Reborn Likes received: 445	#574 - 2013-08-29 14:28:35 UTC \| Edited by: Ynot Eyob nm, finally got it to Work Again with 169 \o/ I serious get anoind when people hardcode adresses into the code, i missed 3 Places in TEAP with https changes, only changed the one constant at the very top exspecting that to Work trough out the code. Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".

Shin Chogan

Federal Navy Academy

Gallente Federation

Likes received: 60

#575 - 2013-08-29 15:09:04 UTC

Ynot Eyob wrote:

nm, finally got it to Work Again with 169 \o/

I serious get anoind when people hardcode adresses into the code, i missed 3 Places in TEAP with https changes, only changed the one constant at the very top exspecting that to Work trough out the code.

Heh ... not me ... I'm innocent ... it caught me out when I had to update it.

That said ... I've not changed that aspect yet Oops

LionGate Enterprises 38
Zenith Gravit LionGate Enterprises Likes received: 38	#576 - 2013-08-30 13:58:21 UTC Is there a version of TEA floating around that would work at say, an alliance level? So it would group people by corps as well instead of just corp/alliance/blue?


Shin Chogan Federal Navy Academy Gallente Federation Likes received: 60	#577 - 2013-08-30 15:20:42 UTC Zenith Gravit wrote: Is there a version of TEA floating around that would work at say, an alliance level? So it would group people by corps as well instead of just corp/alliance/blue? Just set your rules up "Right" and it will be fine. Main group = if you are in the alliance secondary group = your corp group.

Zenith Gravit

LionGate Enterprises

Likes received: 38

#578 - 2013-08-30 17:51:21 UTC

Shin Chogan wrote:

Zenith Gravit wrote:

Is there a version of TEA floating around that would work at say, an alliance level? So it would group people by corps as well instead of just corp/alliance/blue?

Just set your rules up "Right" and it will be fine.
Main group = if you are in the alliance
secondary group = your corp group.

Yeah. we have it setup and working fine. I was thinking of an instance like alliance forums with sub forums for corporations, but I don't want to have to micromanage group assignment.


Shin Chogan Federal Navy Academy Gallente Federation Likes received: 60	#579 - 2013-08-30 18:12:47 UTC Zenith Gravit wrote: micromanage group assignment. Yeah ... that is your problem ... You can do corp sections on your boards but you would have to create at least on group and tea rule per corp.


Zenith Gravit LionGate Enterprises Likes received: 38	#580 - 2013-08-30 21:27:35 UTC Am I correct in thinking that a rule per corp isn't possible?

First pagePrevious page2728293031Next page