1. We have just migrated to Xenforo forum platform. Few things to remember:
    - You will need to reset your password in order to login. Reset your pass here: Click here. Be sure to check SPAM folder!
    - Avatars were not migrated. You will need to upload your new avatar

    Regards,
    Soccer Gaming Admin

The Every League Project

Discussion in 'FIFA 15 Mods, Patches and Total Conversions' started by mrliioadin, Jul 20, 2015.

  1. mrliioadin

    mrliioadin Senior Squad

    Joined:
    Apr 3, 2006
    Messages:
    2,347
    Likes Received:
    1
    Location:
    Wilmington
    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.
     
  2. mrliioadin

    mrliioadin Senior Squad

    Joined:
    Apr 3, 2006
    Messages:
    2,347
    Likes Received:
    1
    Location:
    Wilmington
    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.
     
  3. pesfifa76

    pesfifa76 Youth Team

    Joined:
    May 23, 2014
    Messages:
    185
    Likes Received:
    0
    can you make georgian prtemier league(umaglesi liga) with cmp file?????
     
  4. mrliioadin

    mrliioadin Senior Squad

    Joined:
    Apr 3, 2006
    Messages:
    2,347
    Likes Received:
    1
    Location:
    Wilmington
    I'm not really focusing on Europe at this time. Sorry.
     
  5. regularcat

    regularcat Manager Moderator

    Joined:
    Jun 11, 2008
    Messages:
    12,894
    Likes Received:
    143
    This made my day, leave UEFA to EA.
     
  6. mrliioadin

    mrliioadin Senior Squad

    Joined:
    Apr 3, 2006
    Messages:
    2,347
    Likes Received:
    1
    Location:
    Wilmington
    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.
     
  7. paul2008me123

    paul2008me123 Club Supporter

    Joined:
    Oct 20, 2014
    Messages:
    18
    Likes Received:
    3
    Location:
    Chengdu,China
    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
     
  8. mrliioadin

    mrliioadin Senior Squad

    Joined:
    Apr 3, 2006
    Messages:
    2,347
    Likes Received:
    1
    Location:
    Wilmington
    You have to make those tournaments. Right now, they aren't actually playable tournaments. I'm working on leagues first, then cups.
     
  9. paul2008me123

    paul2008me123 Club Supporter

    Joined:
    Oct 20, 2014
    Messages:
    18
    Likes Received:
    3
    Location:
    Chengdu,China
    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
     
  10. mrliioadin

    mrliioadin Senior Squad

    Joined:
    Apr 3, 2006
    Messages:
    2,347
    Likes Received:
    1
    Location:
    Wilmington
    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.
     
  11. mrliioadin

    mrliioadin Senior Squad

    Joined:
    Apr 3, 2006
    Messages:
    2,347
    Likes Received:
    1
    Location:
    Wilmington
    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.
     
  12. regularcat

    regularcat Manager Moderator

    Joined:
    Jun 11, 2008
    Messages:
    12,894
    Likes Received:
    143
    Watching your videos, pretty slick shit.
     
  13. mrliioadin

    mrliioadin Senior Squad

    Joined:
    Apr 3, 2006
    Messages:
    2,347
    Likes Received:
    1
    Location:
    Wilmington
    Thanks!
     
  14. regularcat

    regularcat Manager Moderator

    Joined:
    Jun 11, 2008
    Messages:
    12,894
    Likes Received:
    143
    I noticed you delete a lot of unnecessary data at the end, why compile it
    if you're just going to delete it.
     
  15. mrliioadin

    mrliioadin Senior Squad

    Joined:
    Apr 3, 2006
    Messages:
    2,347
    Likes Received:
    1
    Location:
    Wilmington
    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.
     
  16. regularcat

    regularcat Manager Moderator

    Joined:
    Jun 11, 2008
    Messages:
    12,894
    Likes Received:
    143
    There has to be a faster way of renaming in the scripts than what you
    were doing for example Jamaican to Egypt premier league.
     
  17. mrliioadin

    mrliioadin Senior Squad

    Joined:
    Apr 3, 2006
    Messages:
    2,347
    Likes Received:
    1
    Location:
    Wilmington
    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/'[email protected]+' 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.
     
  18. Sebo

    Sebo Club Supporter

    Joined:
    Aug 8, 2013
    Messages:
    10
    Likes Received:
    0
    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
     
  19. mrliioadin

    mrliioadin Senior Squad

    Joined:
    Apr 3, 2006
    Messages:
    2,347
    Likes Received:
    1
    Location:
    Wilmington
    Thanks Sebo. But, we're gonna focus outside of Europe for right now.
     
  20. Snk

    Snk Club Supporter

    Joined:
    Aug 12, 2015
    Messages:
    7
    Likes Received:
    0
    How about doing Indian Super League?
     
      

Share This Page