MS Access editing Thread

[Hakeem]

.

Originally posted by Ethereal
Hakeem Rules!!!

Thanx for the help man !!!

np

 

[butcher]

Which column is that?

I think (not sure though) I tried changing colours to GenKitColour and Customkitcolor and none of that worked...I think it works when you don't add a kit through CC but when you do it doesn't...

are you certain for that Hakeem? and if yes which EXACT column?

 

[Treebeard]

Has anyone figured out what the x-rank or x-bodytype fields are for?

Could one of them be captaincy?

All of the defaults are 0

 

[Treebeard]

The kit raptor works great but after editing the dev_all_data file with ms access and installing the changes through the cc all the 3rd/GK kitchanges made by KR are lost and have to be put in again.

Is there any way around this

 

[Hans]

Re: .

Originally posted by Hakeem
boot type is not changeable.
Its in the exe file that says that only a few players like becks a others (like 15 or so) have specific boots, and the boots go with the face: if you put becks face to another player, then he will use becks boots too.

ARGH !!!!!!!!!!!!!!!!!!!!!!!! But can anyone create a patch that edits the exe file like GK Patcher for FIFA 2002 ?

 

[Hakeem]

.

Originally posted by Treebeard
The kit raptor works great but after editing the dev_all_data file with ms access and installing the changes through the cc all the 3rd/GK kitchanges made by KR are lost and have to be put in again.

Is there any way around this

you have to manually enable the third and GK kits in access database. thats what KR 2 does

 

[Treebeard]

can you explain how to do that?

 

[Hakeem]

.

go to the kits table and the last value is "isgeneric", just unselect that and the team will use the fsh file you install for it.

the IDs in that table are not the ones of teams but the ones of the teams kits:
example:

arsenal:
home kit 1
away kit 2
third kit 3
fourth kit (GK home) 4
fifth kit (GK away) 5

 

[Treebeard]

Hakeem, many thanks for your help!

 

[3m1n3m]

Well... the strangest thing happened to my dev_all_data.mdb

All the tables except Players (Teams, Link_PT, Link_TF, etc etc) got empty!!!! From one moment to another!!! And now, I have to restart my patch all over again! Can someone tell me what has happened? Is there anyway to recover all the work?!


PLEEEEEEEEEEEASE HELP!!!

 

[Mark Jo]

Please I need help-
I create a Championsleague Patch with all 32 Original Teams and the Original Roster, but I want the Original Groups in the Game, but i don´t know how I can make this. Is a Way to edit a File to do this?

 

[Hamdan]

I like to look back at this post by breamster on Nov 14, 2002

"i have done this and the commentary for 2 is DIXON, who used to be in the previous games, i cant seem to change this other than un tick the fifapro box, which then removes the playes first name in the game!!!

I just guess that we can put back all the previous players in the game but not in the new game FIFA2003.

I give an example for AC Milan, Valerio Fiori, Fernando Redondo and Leonardo who are back with the team... If we can examine their previous ID number, then we can have them back in the game as well as their commentaries...

Any comments................

 

[breamster]

finally a reply...!!

it is true that all players previously in 2002 and now deleted in 2003, can be put back with ease. if we no there 2002 id's then they can be placed straight back into the 2003 database, keeping their old id's

it seems EA have jus deleted them and not used the old id's for any other player.

when i put Kolo Toure into the arsenal squad, i set his id to 2, in the game the commentary was DIXON, an old retired arsenal player, who was in 2002 but now removed within 2003. i tried to put his speech id to that of another toure within the game, but still, motty says Dixon, the only way i have found is to remove the commentary by unselecting the fifapro option for the player. this in turn replaces the players first name with jus an inital!!!

this option is good news for putting old player back into their original id's but bad for adding players to these id's due to the commentary

has anyone bin able to overcome this??

comments...???

 

[Alex]

Originally posted by breamster
finally a reply...!!

it is true that all players previously in 2002 and now deleted in 2003, can be put back with ease. if we no there 2002 id's then they can be placed straight back into the 2003 database, keeping their old id's

it seems EA have jus deleted them and not used the old id's for any other player.

when i put Kolo Toure into the arsenal squad, i set his id to 2, in the game the commentary was DIXON, an old retired arsenal player, who was in 2002 but now removed within 2003. i tried to put his speech id to that of another toure within the game, but still, motty says Dixon, the only way i have found is to remove the commentary by unselecting the fifapro option for the player. this in turn replaces the players first name with jus an inital!!!

this option is good news for putting old player back into their original id's but bad for adding players to these id's due to the commentary

has anyone bin able to overcome this??

comments...???

Overcome it just by using ID's that are lower than the auto assigned, but havent been used before. There is plenty of them around. The database seems to have a few values that it doesnt use, such as Voice ID. It has them in the DB, but identifies the player using his ID number anyway.

Cheers
sKIp_E

 

[Alex]

Originally posted by DreamTim

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)

Yes u can, if u add a team, u can add a kit for that team. Than using Kit Raptor (just change the team.ini to ur new teams ID) and add a kit for that team, after deselecting isgeneric in the kit table.

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

You really shouldnt edit ANYTHING that has LUT or UI at the front. These are values used by the CC, to go in the combo boxes, etc. They arent put their to change, but to refer to (by the program and you if u need to).

 

[breamster]

Originally posted by sKIp_E
Overcome it just by using ID's that are lower than the auto assigned, but havent been used before. There is plenty of them around. The database seems to have a few values that it doesnt use, such as Voice ID. It has them in the DB, but identifies the player using his ID number anyway.

how do i give my new player a commentary then? for example, Kolo Toure, as there is already a toure in the game, how do i go about using his commentary?

 

[Alex]

Originally posted by DreamTim
btw when the tool by maniac will be released?

The tool by Maniac isnt a stand alone tool, but simply forms in MS Access.

Anyone can make these to make editing for themselves easier. Ive doen it myself, and now have a form where I can change all a teams main data (with a list of its players their prefered positions, their numbers, and their team positions below, and a button to take u to the ->) AND a Player form, which includes all info on a player.

Cheers
sKIp_E

 

[Alex]

Originally posted by breamster
how do i give my new player a commentary then? for example, Kolo Toure, as there is already a toure in the game, how do i go about using his commentary?

As far as I know u cant.

I had the same problem. Ive added a few players, often with last names already used, and given them the speechID of a player with the same last name, but I dont get any commentary for that player. As far as I can see the game does its player Iding for commentary by the player ID, not the commentary ID.

Cheers
sKIp_E

 

[Hakeem]

.

so Alex: this forms wont work without access installed right? coz I dont have access at work (only at home) and I'm using another program that edits mdbs but it sucks. so I need something that works without access. this forms wont do it right?
I'm not sure but I think Im gonna make an editor myself in VB. I just have to check if I'll be able to code some things.

 

[breamster]

what player id did you start creating players with to prevent the old commentary being used?