The Every League Project

[mrliioadin]

The issue with EA's rating system is players are too grouped in higher rated attribute values.

Messi and Ronaldo are one thing but Van Persie as high as he is plays nowhere near the level Messi and Ronaldo do and therefore his rating is
unjust.

My opinion Messi, Ronaldo and Robben and the next highest low 80's at best and downhill from there.

The ratings are GOD like and no player is that good or even close to the above 3 mentioned.

I don't disagree. I think players have flashes of looking super human. There have been games when Gareth Bale or even Wilfred Bony just looked like world beaters. But, there's something to the consistency of these big guns that is just unprecedented.

Let me mull some of this over. Maybe there is a way to incorporate it. If we develop an equation, it would take SQL 1 second to apply the changes to every player in the database.

 

[mrliioadin]

I'm sharing some of the files I use to quickly build leagues. I hope to upload some instructional videos to help with this. These only apply to data gleaned from the soccerway site. Hopefully I can provide some more later.

https://drive.google.com/file/d/0B7r70DklaZ0fME91SlY0YmlDYms/view?usp=sharing

This includes two Web Content Extractor Projects and three SQL scripts. The SQL Scripts won't work right out of the box. I need to get you one more script before it will work.

As a quick primer, the SQL scripts won't work because it builds the next table for the next league using the model provided by another league I did. It looks at the Jamaican tables I put together, copies the formatting to the new table then inputs all the new data. What I need to get you is a quick table that just creates the first table.

The command for creating a table is just Create Table

The command for copying the data from an existing table into a new table is just Select * into newtable from existingtable.
To delete the data from the new table, just type truncate table newtable.


I'll be picking away at all of this as I have time.

 

[pesfifa76]

can you make georgian prtemier league(umaglesi liga) with cmp file?????

 

[mrliioadin]

can you make georgian prtemier league(umaglesi liga) with cmp file?????

I'm not really focusing on Europe at this time. Sorry.

 

[regularcat]

I'm not really focusing on Europe at this time. Sorry.

This made my day, leave UEFA to EA.

 

[mrliioadin]

This made my day, leave UEFA to EA.

Yeah. I'll go back to UEFA when we have 25 working leagues in all of the other considerations.

My only exception might be making an English 5th division. Promoting a team from deep in the pyramid all the way to champions league is fun. But, I like to pull players from all over the world to do it.

 

[paul2008me123]

mrliioadin, I have a question, when it is time to play asian cup or afrian cup in career mode,even though I can see the results in news, I cannot see african cup or asian cup in tables, do you know how to make.these intercups visible in tables? thx

 

[mrliioadin]

mrliioadin, I have a question, when it is time to play asian cup or afrian cup in career mode,even though I can see the results in news, I cannot see african cup or asian cup in tables, do you know how to make.these intercups visible in tables? thx

You have to make those tournaments. Right now, they aren't actually playable tournaments. I'm working on leagues first, then cups.

 

[paul2008me123]

You have to make those tournaments. Right now, they aren't actually playable tournaments. I'm working on leagues first, then cups.

I have already made those tournaments and playable, but the only problem is I can't see those tornaments in table, I can see the tournaments results in News

 

[mrliioadin]

To the first post, I added six help videos and several files to help you learn to build leagues quickly. It includes the web content extractor files and SQL scripts necessary to build quickly from soccerway.com data.

The examples I use in the videos were from the Egyptian league. I discovered during the course of production that the data for the Egyptian league is rather messed up. So, use the videos as a guide for pulling data for other leagues knowing that Egypt was an especially poor example of its usefulness.

Happy modding.

 

[mrliioadin]

I have already made those tournaments and playable, but the only problem is I can't see those tornaments in table, I can see the tournaments results in News

If you modified the tournaments in any way, the best way for me to be able to help is to see screenshots of what you did.

 

[regularcat]

Watching your videos, pretty slick sh*t.

 

[mrliioadin]

Watching your videos, pretty slick sh*t.

Thanks!

 

[regularcat]

Thanks!

I noticed you delete a lot of unnecessary data at the end, why compile it
if you're just going to delete it.

 

[mrliioadin]

I noticed you delete a lot of unnecessary data at the end, why compile it
if you're just going to delete it.

In some cases, it's used for the initial sort function in Excel to determine which players might be better than others.

In other cases, I built the Web Content Extractor scripts to pull more data than less so that I can come back and use it later if I want to. Right now, RM15 is only built to accept certain data. Later versions might take more. Footedness, for example, might be easy to add. But, the current of RM15 just doesn't deal with it for right now.

Because we collected it in the first place and stored it in our database, if we want to use it in the future, we just have to reference those databases rather than recollecting data.

My thoughts anyway.

 

[regularcat]

There has to be a faster way of renaming in the scripts than what you
were doing for example Jamaican to Egypt premier league.

 

[mrliioadin]

There has to be a faster way of renaming in the scripts than what you
were doing for example Jamaican to Egypt premier league.

In SQL? Yes there is. I just didn't code it that way. The thing with coding is that there is always a way to do it better, cleaner, tighter and faster. I strongly encourage people to experiment with ways to speed this up. I'm constantly improving old code.

Apologize if you know some of what I'm explaining already. I'll spell it out for you or others. What you're wanting to do is called making it "dynamic."

In SQL, if you want to make something dynamic you declare a variable, set the variable then reference the variable.

declare @countryName nvarchar(max)
set @countryName = 'Jamaica'

(pseudocode) bulk insert 'c://PATHPATHPATH/'+@countryName+' premier league 2014-2015.csv'

something like that.

In some rare situations with dynamic processes in SQL, you have to use a command that is something like SQLEXEC. W3 schools has all sorts of stuff on doing this.

 

[Sebo]

Hey!
Awesome work man. If you're interested you can make the Slovenian league. Last year our champion Maribor was in the champions league.
Keep up the good work

 

[mrliioadin]

Thanks Sebo. But, we're gonna focus outside of Europe for right now.

 

[Snk]

How about doing Indian Super League?