Subject: Dream Team Web II

does it also now take into count if the team is in 2-nd or 1-st position?
as earlier it only managed to check points of each team in leagues and then list them accordingly.


edit:seems like its okey now.
(edited)

It should be ok.
Script is quite big and complicated now.
Just inform me if you think its not correct.

promotion script seems to be faulty. at least for Denmark

Details please.
Danmark has 85 leagues, so should not have a problem there...
(edited)

When i try to update it says

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/.sites/78/site1670/web/dreamteam/curlfunctions.php on line 494

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/.sites/78/site1670/web/dreamteam/curlfunctions.php on line 494

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/.sites/78/site1670/web/dreamteam/curlfunctions.php on line 495

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/.sites/78/site1670/web/dreamteam/curlfunctions.php on line 495

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/.sites/78/site1670/web/dreamteam/curlfunctions.php on line 496

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/.sites/78/site1670/web/dreamteam/curlfunctions.php on line 496

preventMySQLTimeout() ATTEMPT

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/.sites/78/site1670/web/dreamteam/curlfunctions.php on line 494

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/.sites/78/site1670/web/dreamteam/curlfunctions.php on line 494

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/.sites/78/site1670/web/dreamteam/curlfunctions.php on line 495

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/.sites/78/site1670/web/dreamteam/curlfunctions.php on line 495

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/.sites/78/site1670/web/dreamteam/curlfunctions.php on line 496

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/.sites/78/site1670/web/dreamteam/curlfunctions.php on line 496

preventMySQLTimeout() ATTEMPT

Array
(
[1616] => Array
(
[0] => 7690
[1] => 14162
[2] => 7616
[3] => 7715
[4] => 7640
[5] => 7667
[6] => 7695
[7] => 7645
)



and so on...

Don't worry, thats normal.
Don't know why the errors started, but they are from the anti mysql timeout script.
The arrays you see it the actual updating it does.
Let it running (it will take some time to sort all arrays) and wait for the script to be finished.

.doublepost?
(edited)

It seems to be working pretty well now. Well done loop and rtg. Respect!

Updating the promo/reg doesn't seem to work straight away. Wait a couple of days after the league update and then it seems to work.

Thanks.
Should work directly after the update, if you ignore the mysql errors.
Rtg is on holiday and I have just really started with mysql and php because of dreamteam, so I don't want to mess around too much.
I have only changed the script that orders the teams data, now according to number of leagues for correctness. Wasn't hard to do.

There are still a couple of other errors I don't know how to fix.
Here a list:
1. Selecting ALL will result in mysql error (could not find an error in the code, maybe the query is too big)
2. Selecting ALL (non polish) same result as 1
3. SQL error in promotion.php when no data is in the table (does not effect the users but is not nice)
4. Updating player values almost always times out when running. Restarting it will result in it being started right from the beginning, so you will never be done with it.
Will ask rtg if it is possible to add a new index to the table that shows if a player was already updated.
5. Not all new country flags are on the server. Will fix this later on.

BTW:
For the people interested:

damian:
Yes, his IP is blocked automatically.
There is a limit of unsuccessful authentications after which IP is blocked for 12 hours.

So, some of you have found it funny to send wrong login data to the update scripts and therefore Sokker banned my IP.
Thanks for the troubles ;)

rofl let me try that again...

So, some of you have found it funny to send wrong login data to the update scripts and therefore Sokker banned my IP.


Doesn't make sense. Sokker only bans IP from where the failed logins came from....

The login comes from Dreamteam, which is the IP I use at work, which is therefore my IP ;)

However, I already thought that it was an automatic anti hacker script when we had the troubles for 2 days. So no login prompt is going to come anymore.
Kinda stupid, but no workaround for this....cannot check if login data is right without connecting.
Don't know how other sides do this, but they must suffer the same problems if users use wrong data for fun.
(edited)

The login comes from Dreamteam, which is the IP I use at work, which is therefore my IP ;)

Hahhaaa....should have kept my mouth shut....

Yep, was a lot of fun for me.
Not only that dreamteam did not work and I had to reset all round 13 data 3 times, was I no longer able to connect to sokker.
lol

I think not but i hope yes.....is it possible to know today rpomotion matches using dream team???


And, about the work with this feature, big Thanks to Loop and rtg

you can mate yes. Just update your fixtures as soon as they are finished