• This is a reminder of 3 IMPORTANT RULES:

    1- External self-promotion websites or apps are NOT allowed here, like Discord/Twitter/Patreon/etc.

    2- Do NOT post in other languages. English-only.

    3- Crack/Warez/Piracy talk is NOT allowed.

    Breaking any of the above rules will result in your messages being deleted and you will be banned upon repetition.

    Please, stop by this thread SoccerGaming Forum Rules And Guidelines and make sure you read and understand our policies.

    Thank you!

MS Access editing Thread

H

Hakeem

Superman
d

the logos are in the data\feart\flags folder in the files xxxxx.fsh and xxxxx1.fsh being xxxxx the name of the league.
use the files of the league where you added your team and add the logo of your team in there.
check the socceraccess' argentinean league episode 1 patch to see how ariel did it.
 
S

shokz

The Red Devil
In Access is there a way to turn the night and day options on/off due to the fact FIFA 2003 lags so bad during night time games :(

But is so smooth during afternoon matches. :o
 
B

Bredrin

Youth Team
I see that it is possible to add different players to different teams but I am not familiar with ms access so could someone tell me how its done step by step? for example i would like to add ronaldo to the brazilian squad but have no idea how.
 
B

Bredrin

Youth Team
Re: Re: Gracias

Originally posted by Hakeem
de nada:)

and Bredrin go back to the thread where you'll find an explanation on each table
Click to expand...

which thread do you mean? this one? if so i have looked through this one and havent found any explanations like that....can you tell me which thread specifically or give me the link?
 
H

Hakeem

Superman
.

Open in the CC directory the following file dev_all_data.mdb (Hint, before you start editting it is wise to make a backup from this file).

survey

Competitions = don't edit this
Custom_Kits = don't edit this
Custom_Support_Graphics = don't edit this
Custom_Support_Sounds = don't edit this
Federations = don't add a federation, but you can rename one
Kits = don't add one but here you can change the base settings for kits (ID is not the team ID, but you need to check the Teams_table for the right ID)
Link_PT = here you can start editting the players (use the players table for the correct players list (ID))
Link_TC = don't edit this
Link_TF = here you can change in which league a team is playing
LUT_AssetTypes = translation for in CC
LUT_Comp_Type = translation for CC
LUT_DisplayGroups = survey for the league's in CC
LUT_Face_Styles = survey for the faces in CC
LUT_Facial_Hair_Styles = survey for the hair styles in CC
LUT_Foot_Type = translation for CC
LUT_Hair_Colours = survey for the different colors of hair in CC
LUT_Hair_Styles = survey for the different styles of hair in CC
LUT_Kit_Colours = translation for in CC
LUT_Kit_Style = survey for the kit styles in CC
LUT_Legs_Final = here you can change the option of the number of returns you want to play in the final
LUT_Legs_KO = same as above but now for the knockout
LUT_Matches_vs_Each_Group_Team = same as above but now for the league (if you play a league + cup cometition
LUT_Matches_vs_Each_Team = how many times you wants to play against a team in a league
LUT_Months = translation of the months for in CC
LUT_Nationality = here you can change the nationality
LUT_Number_Of_Groups = change the amount of groups at cup's
LUT_Number_Of_KO_Teams = here you can change the amount of teams who are playing in a cup
LUT_Number_Of_League_Teams = same as above but now for the league
LUT_Positions = translation of the postions for in CC
LUT_Sleeve_Lengths = translations for the sleeve lengths for inCC
LUT_Teams_Adv = i really don't know
Players = here you can change the stats/names etc. for players
Teams = here you can change the info etc. for teams
UI_Kit_Items = translation for the shirt (kit) in CC
UI_Kit_Source = translation for the different type sof shirt(kit's) in CC
UI_Kit_Type = translation for the types of shirts (kit's)
UI_Yes_No = translation of yes/no in CC


And now the following, how do you get it in the game.
If you are finished with adapt/modify then start Creation Centre DON'T CHANGE A THING save it to a PKG file and install it.
When you now start Fifa you'll see the changes.
 
B

Buffon

Youth Team
filtering

hi guys...
can someone please explain how to filter players by team in the players table... i can only sort them by id but how can i sort them by team number so that i can see all players in each team...
thanks
 
P

Paul

Fan Favourite
Originally posted by zul-aid
That Microsoft Office 2000 costs $1,200 IMO thats a ****ing rip-off
Click to expand...

Office XP is more ... and i have it :o

anything where you have to pay that is microsofts is a rip off :p
 
Z

zul-aid

Starting XI
Re: filtering

Originally posted by Buffon
hi guys...
can someone please explain how to filter players by team in the players table... i can only sort them by id but how can i sort them by team number so that i can see all players in each team...
thanks
Click to expand...

go to Team type file

See when you access (not the program) players it gives you players Id - Now look up your team Id for one (like Brazil) already exist look for Team ID in either Kit tutorial at socceraccess.

Now you scroll down in teams the Team ID and with that should list (only in player ID not name :( ) and there position in numbers and there playing number - I hope this makes sense as sKIp_E showd me this last night Team file should be below Player file

Also have trouble finding it - go to find in File at the top of the screen hope this helps
 
Alex

Alex

sKIp_E
Staff member
Administrator
Super Moderator
Re: filtering

Originally posted by Buffon
hi guys...
can someone please explain how to filter players by team in the players table... i can only sort them by id but how can i sort them by team number so that i can see all players in each team...
thanks
Click to expand...

U cant actually filter the players form by team, without using forms, which isnt filtering at all (but just displaying different info together).
However, u can filter players in LINK_PT by team, which would mean that they would display all of their team information (eg. Number, Position etc in that team).

To do this go:
Record->Filter->Advanced Filter

Choose the filed "Team", and below it put "Not sorted"
Than in the next box below it, put in the team ID u want.

Really forms are the easiest way, but the trouble is that people cant upload their forms for downloading very easily, because it is part of the database.

Im considering uploading my Forms, with a blank database, but to get these forms working, it would require a fair bit of setting up so I havent decided If I will or not yet ;)

Cheers
sKIp_E
 
B

Buffon

Youth Team
thanks

thanks skip for ur help... i just created my own form with access with all the info i need on a player... is it possible to sort the forms by team id so that let's say all arsenal team members appear one after another and so on??
thanks again
 
J

Jerrydon

Club Supporter
Originally posted by starhannes
has it been discovered how to set captains?
Click to expand...

Yep, the player of a team with the lowest ID will become the captain (he need to be in the starting eleven)
 
9

9th Korner

Youth Team
So is it possible to change Champions League groups, like the real ones, so dynamo Kiev would be playing agains Newcstle , Juve and Feyonord????
 
E

ErwinF

Club Supporter
Yep, the player of a team with the lowest ID will become the captain (he need to be in the starting eleven)
Click to expand...

I don't think it is that easy.

Take for example Lyn Oslo (team.id 1464): The player with the lowest id is Tommy Nilsen (player.id 730) who is in my starting eleven, but the captain is Ole Bjørn Sundgot (45292) (or Johan Gudmundsson (14585) when Sundgot was out of the starting eleven).

I thought the captain was the player with the highest score, but that is not always true. For FC St. Pauli the captain in my starting eleven is the player with the lowest id, Oliver Held, who has definitely not the highest score. When I put the real life captain, Stanislawski, in the starting eleven, Held remains the captain.

So, for me, who becames captain is still a mystery.
 
You must log in or register to reply here.


Top