Quick Team Creator

[scouser09]

darkvajo: I have investigated what tables would need to be edited and found the following:

FIFA_NG_DB
leagueteamlinks
playernames
players
playervalues
teamkits
teamplayerlinks
teams
teamstadiumlinks
team_country

LANGUAGE
LanguageStrings

I have found the following to be problems:
-Player Names: first, last and shirt names are listed in the table playernames and linked to the players via an id for each in the players table. Without being able to interact with the database to check current values, this would mean names would be duplicated in this table, not sure if this would cause problems.
-Not sure of the significance of hashid in the table LanguageStrings. Is there an algorithm to calculate this or does it just have to be a unique value?



None of this affects the main project, only the side project to export data which can be imported in DBM11. The main project is making good progress, hoping to complete all parts of program that do not require knowledge of new cmp format before CM11 is released to speed up release time.

 

[Mahittoni]

I have created players .. and it doesn't have any hash problems as far as i know ... created like 10 national teams playing well ... players ... are just about IDs ... so don't worry because your database will understand them as different players ... as long as they have different Ids .. but if they have the same ID, your game will always read the first player in the table .. and may crash .. not sure about that

 

[scouser09]

I have created players .. and it doesn't have any hash problems as far as i know ... created like 10 national teams playing well ... players ... are just about IDs ... so don't worry because your database will understand them as different players ... as long as they have different Ids .. but if they have the same ID, your game will always read the first player in the table .. and may crash .. not sure about that

So the value in the field hashid only needs to be unique? I understand the need for general IDs to be unique, they are primary keys.


I have started work on the Excel team maker.

 

[darkvajo]

darkvajo: I have given things a bit more thought. Basically what is wanted is an interface which is more user friendly than DBM11 for creating the database of teams, which will be replaced by CM11. I do not want spend alot of time adapting my program for the alternate output, and for CM11 to be released very soon after, meaning alot of time was wasted (Rinaldo has not suggested a release date, I undertand his reasons). However, I think for this purpose it would be easier and quicker to create a new tool just using Excel. One worksheet would be a form similar to that of my program, and another would contain the database data with instructions of what database and table each would be copied into. It would not be as good as Quick Team Creator, but would be usefull in the short term. What do you think?.

sure man, it was exactly what i was thinking. I like ur idea so, as usual, let me know if there's any advance so I can beta test if u want

 

[darkvajo]

darkvajo: I have investigated what tables would need to be edited and found the following:

FIFA_NG_DB
leagueteamlinks
playernames
players
playervalues
teamkits
teamplayerlinks
teams
teamstadiumlinks
team_country

LANGUAGE
LanguageStrings

I have found the following to be problems:
-Player Names: first, last and shirt names are listed in the table playernames and linked to the players via an id for each in the players table. Without being able to interact with the database to check current values, this would mean names would be duplicated in this table, not sure if this would cause problems.
-Not sure of the significance of hashid in the table LanguageStrings. Is there an algorithm to calculate this or does it just have to be a unique value?



None of this affects the main project, only the side project to export data which can be imported in DBM11. The main project is making good progress, hoping to complete all parts of program that do not require knowledge of new cmp format before CM11 is released to speed up release time.

This is what I've been editing:
- formations: to add a formation to each team
- leagues: to create the league info (ID, name, etc)
- leagueteamlinks: Link the teams to a specific league
- playersnames: add 1st & last name to players. the limit (til db is expanded) is around 32000
- players: players info
- team_country: assign a team the specific country where it belongs
- teamplayerlinks: assing the players to a specific team. The "position" here and in "formation" tables need to be exactly equal; if not, the players wont appear in the pitch
- teams: teams info
- teamstadiumslinks: assign the team a specific stadium


I'll edit teamkits as well, that's to add new kits ?

PS: tell me if u have MSN so i can add u and we talk more bout this

 

[scouser09]

This is what I've been editing:
- formations: to add a formation to each team
- leagues: to create the league info (ID, name, etc)
- leagueteamlinks: Link the teams to a specific league
- playersnames: add 1st & last name to players. the limit (til db is expanded) is around 32000
- players: players info
- team_country: assign a team the specific country where it belongs
- teamplayerlinks: assing the players to a specific team. The "position" here and in "formation" tables need to be exactly equal; if not, the players wont appear in the pitch
- teams: teams info
- teamstadiumslinks: assign the team a specific stadium


I'll edit teamkits as well, that's to add new kits ?

PS: tell me if u have MSN so i can add u and we talk more bout this

Thanks, I missed formations. Yes, teamkits is for what kits are in use and data related to them, eg number colour. Sorry, I don't use MSN. If you PM me your email address I will send you the beta for testing, hopefully will be ready in a few days.



I need a little help to complete the Excel team creator. I need to know what ids of faces, hairstyles and boots are in use. I do not currently have the full game (only demo) and the demo's graphic archives seem to be incomplete. The list does not need to be complete, just need a reasonable number, ideally a range (eg ids 1-50) to pick random ids from.

 

[darkvajo]

Thanks, I missed formations. Yes, teamkits is for what kits are in use and data related to them, eg number colour. Sorry, I don't use MSN. If you PM me your email address I will send you the beta for testing, hopefully will be ready in a few days.



I need a little help to complete the Excel team creator. I need to know what ids of faces, hairstyles and boots are in use. I do not currently have the full game (only demo) and the demo's graphic archives seem to be incomplete. The list does not need to be complete, just need a reasonable number, ideally a range (eg ids 1-50) to pick random ids from.

ok man. here's something that MIGHT help u


- about faces id, just put "0" (that's for generic)
- about boots .. just randomize between 0-10 or sth that can be edited later (:
- about hairstyles, u can use from 0-127.
- facehaircolor: 0-11
- facialhairtype: 0-19
- skincolor: 0-11
- skintype: 0-2
- headclasscode: 1 (generic)
- haircolor: 0-11
- sideburns: 0-3
- lowmedhairtype: 0-31
- eyecolorcode: 1-8
- eyebrowcode: 0-2


my mail is on ur PM now =)

 

[scouser09]

ok man. here's something that MIGHT help u


- about faces id, just put "0" (that's for generic)
- about boots .. just randomize between 0-10 or sth that can be edited later (:
- about hairstyles, u can use from 0-127.
- facehaircolor: 0-11
- facialhairtype: 0-19
- skincolor: 0-11
- skintype: 0-2
- headclasscode: 1 (generic)
- haircolor: 0-11
- sideburns: 0-3
- lowmedhairtype: 0-31
- eyecolorcode: 1-8
- eyebrowcode: 0-2


my mail is on ur PM now =)

Thanks, that is very helpfull. What about headtypecode, seems to be the id of the generic face, not sure what values have textures? I will send you it when it is finished and tested. It is currently about 70% complete.

 

[scouser09]

Excel program is nearly finished (just need generic face ids). I created a team and imported to the demo. The game reconises the team, but crashes if I start a match or go into team management. Does the game crash if graphics are missing? Is data in the table formupdate needed?

 

[BrunolokoIF]

Excel program is nearly finished (just need generic face ids). I created a team and imported to the demo. The game reconises the team, but crashes if I start a match or go into team management. Does the game crash if graphics are missing? Is data in the table formupdate needed?

Duplicate id's in the table formations can cause this error.


Create a new formationid for the team created

 

[scouser09]

Duplicate id's in the table formations can cause this error.


Create a new formationid for the team created

formationid is unique, teamid matches the team. Not sure exactly is causing the crash, might be possible I have duplicated an ID in another table by mistake.

 

[darkvajo]

formationid is unique, teamid matches the team. Not sure exactly is causing the crash, might be possible I have duplicated an ID in another table by mistake.

make sure that the positions in the teamplayerlinks table are the same as the ones in the formation table.

 

[scouser09]

make sure that the positions in the teamplayerlinks table are the same as the ones in the formation table.

I have checked this and they match up. I assigned all the created players to an existing team using the same formation, removing the current players, and there was no problems with the players. Still testing to find the source of the problem.

Is it possible to actually add teams to the demo? Can someone confirm this just to rule out that possability.

 

[darkvajo]

I think not man, don't believe it's possible.

 

[scouser09]

I think not man, don't believe it's possible.

If it is not possible to add teams to the demo then I have been trying to solve a problem that does not exist. I have sent you a copy so you can test it.

 

[darkvajo]

e-mail answered man

 

[G2000]

I know this question has been kicked around a few times, has anyone figured out what the hashid needs to be?

 

[goke313]

scouser09 .....is it possible we can get a quick team editor{edit starting XI/bench + edit player attributes}

 

[darkvajo]

u might have it. I'm testing it to see if it works

 

[scouser09]

G2000: I have no idea, Rinaldo seems to have made some progress but has not solved the problem.

goke313: This will be possible with CM11.

darkvajo: Thanks, keep me updated!


Might post a new screenshot of the progress of the main project (Quick Team Creator) later.