• 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!

Career Youthplayer Name Groups & Tables

BlackEmperor

Youth Team
Hey guys,

I wanted to ask if anyone has any experience with editing the career_firstnames, career_lastnames and career_commonnames tables in the DB?
They seem to be used to generate names for youth players from specific countries, which is why we get these Pablo Escobar or Fernando Alonso players from hispanic countries for example. Each name is assigned to a groupid, which again are assigned to different nations in the career_namegroups table.

How do they work in the game? Is there some kind of precedence? Most of the countries using these names don't have a league in the game. Usually the game seems to take the names of existing players from the same country to generate youth players, but without having a national league, the amount of players from that nation is drastically reduced most of the time.
On the other hand, the fact that countries that have a league like Spain or Portugal use these names as well makes me thing that it could be used for other nations as well, despite having a league themselves.

Do you think (or even know) if hybrids could be built with that method? So that youth players would draw their names from both the existing player pool and the ones defined in these tables? I'm inclined to say no when I look at most Spanish youth players for example (since they don't seem to use those weird long names some players like Cristiano Ronaldo have), but I don't quite get why the names for Spanish or Portuguese youth players are defined in career_commonnames instead of just firstnames and lastnames (which would allow more variety if I understand it correctly, as commonnames uses set firstname and lastname combinations instead of randomization). Is it even possible to add new groupids properly and assign nations to them?

I thought I'd ask before I start messing around with it. Would be quite a lot of work, but it might be worth it to get more "natural" names instead of reusing names of existing players all the time and get names like Weidenfeller or ter Stegen all the time...
 

bromireal

Youth Team
BlackEmperor;3873606 said:
Hey guys,

I wanted to ask if anyone has any experience with editing the career_firstnames, career_lastnames and career_commonnames tables in the DB?
They seem to be used to generate names for youth players from specific countries, which is why we get these Pablo Escobar or Fernando Alonso players from hispanic countries for example. Each name is assigned to a groupid, which again are assigned to different nations in the career_namegroups table.

How do they work in the game? Is there some kind of precedence? Most of the countries using these names don't have a league in the game. Usually the game seems to take the names of existing players from the same country to generate youth players, but without having a national league, the amount of players from that nation is drastically reduced most of the time.
On the other hand, the fact that countries that have a league like Spain or Portugal use these names as well makes me thing that it could be used for other nations as well, despite having a league themselves.

Do you think (or even know) if hybrids could be built with that method? So that youth players would draw their names from both the existing player pool and the ones defined in these tables? I'm inclined to say no when I look at most Spanish youth players for example (since they don't seem to use those weird long names some players like Cristiano Ronaldo have), but I don't quite get why the names for Spanish or Portuguese youth players are defined in career_commonnames instead of just firstnames and lastnames (which would allow more variety if I understand it correctly, as commonnames uses set firstname and lastname combinations instead of randomization). Is it even possible to add new groupids properly and assign nations to them?

I thought I'd ask before I start messing around with it. Would be quite a lot of work, but it might be worth it to get more "natural" names instead of reusing names of existing players all the time and get names like Weidenfeller or ter Stegen all the time...

That's what I was trying to figure out as well, but for now I couldn't. maybe if we find a way we could also give them real surnames of the real youth players?
 

bangus

Starting XI
New names and name IDs can be added to the playernames table. You can use current names/name ids, and also create names/name ids and add them to the playernames table, and then control which names get used in with league by assigning the requisite groupid value.
 

BlackEmperor

Youth Team
Cool, so it works? And what's with the question about what method the game actually chooses ingame? So if I added something like Thomas to career_firstnames and Müller to career_lastnames, gave both names the groupid 11 and assigned groupid 11 to Germany, would all German youthplayers have the name Thomas Müller? So the game wouldn't use names of existing German players anymore to generate new German youthplayer names?
 

bromireal

Youth Team
I still don't understand in career_firstnames, career_lastnames and career_commonnames tables there are numeric values. Do you mean they can be replaced by names?
 


Top