[XeroX]

After many people lately attempted to create their own databases I decided to step up and write a tutorial, how to make databases.

First thing you need to know is how to operate in the FM editor himself and not to get lost when I'll mention names later, in the next parts.

The following picture shows the parts of the editor window.



File menu

Load Editor Data - allows you to load your saved XML file to the editor.

Merge Editor Data - using that option you may merge changes from 2 XMLs to one XML.

Save Editor Data - you can save your DB here.

Save Editor Data As... - allows to save your DB under a new name.

Load Database - the thing that you need to do before doing anything in the editor; loads the default game database with all players, clubs and other details.


Settings menu

Currency - allows you to select currency in which you will edit.

Compress Editor Data Files - selecting this option will make the game to compress the database you make; it's useful when there's a lot of data to store.


Menu - You can navigate between the currently edited item and the database (searching items etc.)


Recent Database Records - a list of the items you've recently seen or edited, allows you to switch through edited items.


Add Nation Rules - allows you to add league rules for a country.


Item menu - lists possible sections you can go to.


Filter button - allows you to filter the search results.


Search box - you can search for an item by its name.


Editing buttons

Add - allows you to add an item.

Edit - allows to edit an item.

Duplicate - allows to duplicate an item.

Remove - allows to remove an item.


Next time I will write how to add a club and a player.

My blog | Request a logo | Twitter

[alilane4]

Sweet, good job mate. I am liking this.

[XeroX]

Adding a club

To add a club, load the database, click the "Clubs" item from the item menu (as showed in the last update) and click the "Add" button in the bottom right of the screen.

Details

Name: The full name of your club.
Short Name: Shorter name of the club.
Six Letter Name: Abbreviation of the name (max. 6 characters)
Nickname, Second Nickname: nickname of your club.
Nation: nation that your club is located in.
Year Founded: year that your club was founded in.
Status: status of your club, can be either professional, semi professional or amateur.
Maximum Age: maximum age your players can be at.
Morale: morale of the team; this is out of 20.
Reputation: reputation of the team; out of 10000.
Reserve Teams: to add a team, click Add in the reserve team panel.

Stadium

Stadium tab

Stadium: stadium your club plays on.
Reserve Stadium: stadium your reserve team(s) use.

WARNING! If you select a stadium, the newgens will be from the country the stadium is located at.

Attendance: average attendance on your club's matches.
Minimum Attendance: minimum attendance on your club's matches.
Maximum Attendance: maximum attendance on your club's matches.
Training: state of club's training facilities; out of 20.
Youth Setup: state of club's youth facilities; out of 20.
Youth Academy: determines if the club has a youth academy (ticked) or not (unticked)

Alternative Stadiums

If the club will play on a different stadium in specific competition, click Add button in the bottom and set the alternative stadium up.

Stadium Move

New Stadium: the stadium your club will move to in the future.
Alternative Stadium: alternative stadium your club will move to in the future.
Leave Date: the date your club will leave the old stadium.
Move In Date: the date your club will move into the old stadium.

Finances

General

Balance: current debts or money in the bank. Can be either positive or negative.
Transfer Budget: available transfer budget for the club.
Remaining Wage Budget: wage budget available for the club.
Public Limited Company: determines if club is a public limited company or not.
Sugar Daddy: determines the type of the man pushing injections into the club; if you don't want such person leave it as "None"
Stadium Rental Per Year: money your club has to pay to rent the stadium for a year.
Average Match Ticket Price and Average Season Ticket Price: determines the match ticket's or season ticket's average price.
Number of Season Ticket Holders: amount of people buying the season tickets.

Other Income

To add an income source, click Add button on the bottom.

Amount: amount of money earned from the source of income.
Income Type: type of income.
Start Date and End Date: dates determining when does the income start and end.
Renew Income: determines if the income will be renewed next season.
Fixed Value: determines if the value will be the same every season.

Debts

To add debts, click Add button on the bottom.

Amount: amount of money to return.
Source: type of debt.
Start Date and End Date: dates determining when does the debt start and end.
Interest: determines the importance of the debt to the sides the money was taken from.

Player Buy Back Clauses

Determines if the club can buy back a player for a certain amount of money.

Sell On Clauses

Determines who the club will give back a certain part of the transfer fee in case of a transfer.

Appearance Clauses

Money other clubs will have to play if a player makes a certain number of appearances.

Competitions

Competitions

Division: the division the team plays in.
Last Division: the division the team played in last season.
Last Position: the position the team taken last season.
Next Division: the division the team will play next season.
Other Division: the division the team will play alongside the current division.
Has No Reserve Fixtures: determines if the team will get reserve fixture or not.
Has No Youth Fixtures: determines if the team will get youth fixture or not.
Euro Coefficients: the amount of points that the team earned in the European competitions in last seasons.

Regional Divisions

Determines if the team plays in a regional division.

Tactical Attributes

Determines the team's favoured formation and the team's style of play. Attributes are out of 20.

Kits and Colours

Determines the crests the team will play in and the team's colours.

Staff and Players

Allows you to add players and staff; to add players or staff click the Add buttons.

Relationships

Allows to select the club's fierce rivals, favoured personnel, disliked people and club legends.

The relationships levels are out of 100 (100 = max)

Current Affilliations

Allows you to add affilliates. To add one, click the "Add" button.

Affilliated Club: the club you're affilliated with.
Is Main Club: determines if the club is the main club (ticked) or the feeder club (unticked)
Start Date: the date that the affilliation starts on.
Affilliation Type: type of affilliation.
Yearly Fee: the amount of money your club will pay yearly to the affilliate.

Records and History

Allows you to add your team's records of the team's history in the league system.

My blog | Request a logo | Twitter

[тевез94]

Fantastic man, this guide is very useful for those who want to make a database...

[XeroX]

Creating A Player

To add a player, load the database, click the "People" item from the item menu (as showed in the first update) and click the "Add" button in the bottom right of the screen. A drop down menu will appear; from available items select "Player" by clicking at it.

Details

First Name: player's first name.
Second Name: player's second name.
Common Name: player's name that he will be addressed under. (e.g. Ronaldinho)
Full Name: full player's name with second and other names.
Person Type: Player (do not touch)
Ethnicity: player's ethnic origin.
Hair Colour: player's hair colour.
Skin Tone: player's skin tone.
Date Of Birth: player's date of birth.
City Of Birth: player's place of birth.
Nation: primary country that the player can play in,
Declared For Nation: determines whether the player is declared for the primary nation or not.
International Retirement: determines whether the player has retired from the international football (national team)
International Retirement Date: date of the player's retirement from the national team.
Retiring After Spell At Current club: determines if the player will retire in the club he's playing in.
Second Nations: secondary nations the player is eligible to play for (if not declared for one nation)
International/U21 Apps/Goals: record of the player's appearances and goals in his national team(s).

Contract

Club Contract

Club: club the player will be playing for.
Job: Player (leave)
Date Joined: the date the player joined the club.
Contract Started: date of the contract's start.
Contract Expires: date of the contract's expiry.
Contract Type: type of the player's contract.
Weekly Wage: player's wages (per week)
Squad Number: player's number in the squad.
Preferred Squad Number: player's preferred squad number.
Co-owned By: determines which club the player is co-owned by.
Co-own Wage: determines wages paid by the co-owning club.

Contract Clauses

Clauses that the contract includes.

Nation Contract

Nation: the nation the player's on contract with.
Job: the player's job in the nation's FA.
Date Joined: the date the player joined the nation.

Loan

Club: the club the player is loaned to.
Start Date: loan's start date.
End Date: loan's end date.
Can Be Recalled: determines whether the player can be called back by his parent club or not.
Fee To Buy: amount of money the loaning club will have to pay for permanent transfer.
% Wages Paid By Loaning Club: determines the percentage of wages paid by the loaning club.

Future Transfer

Club: the club the player will go to.
Transfer Date: transfer's date.
Contract End Date: the date the new contract will end in.
Wage: the wages the player will get.
New Job: the role the player will play.

Person Data

Attributes

Player's personality attributes; all out of 20.

Languages

Languages the player can speak in; proficiency is out of 20.

Player Data

General

Current Ability: the level that player is on now.
Potential Ability: the level the player can play in the future.
Current Reputation: player's reputation.
Home Reputation: player's reputation at his home country.
World Reputation: player's reputation in the world.

All above are out of 200.

Height and Weight: player's height and weight (in cm and kg)
Left Foot: player's ability to play with his left foot.
Right Foot: player's ability to play with his right foot.
Retirement Date: the date the player will retire in.

Positions

Determines the ability to play of the player on specific positions - out of 20.

Mental, Physical, Technical and Goalkeeping Attributes

Determines the player's attributes (out of 20). 0 = randomly assigned stat.

Preferred Moves

Moves the player prefers to make while playing.

Relationships

The people and clubs the player likes and dislikes.

Playing History & Non Playing History

Player's history in the past seasons/roles.

Achievements

The list of achievements that the player has made in the past.

My blog | Request a logo | Twitter