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

Database

bangus

Starting XI
gartxi;3874608 said:
but in player table not have names
Player names are coded as number IDs, the playernames table lists which number IDs go with which names. You can add new names to that table, just add a name and create a new number ID for it.
 

gartxi

Club Supporter
I know that, but i dont see it well. I mean, in players table have example playerid, firstnameid and lastnameid. In playernames have only nameid, name and comentaryid.

Not see firstname and lastname in tables, and not see nameid in players table. Im so confused with that
 

bangus

Starting XI
gartxi;3874625 said:
Not see firstname and lastname in tables, and not see nameid in players table.
Are you trying to find the number IDs of specific players? The playernames table lists which names go with which number IDs. That is the only way you can figure out the number IDs, it is a lot of work. Example:

Wayne ID# 23401
Rooney ID# 19423

Or do you want to create new names for players? Example:

Last player on playernames table: ID# 24859
Create new player first and last name ID:
Bilbo ID# 24860
Baggins ID# 24861
 

bangus

Starting XI
gartxi;3874649 said:
I want to know the firstname and lastname in players table. Only that.
Open the playernames table with Excel, the names will be in alphabetical order. Scroll down the list to find the name, and that's how you find the name ID.
 

bangus

Starting XI
gartxi;3874654 said:
ooh, i think i got it. Many of thanks mate.

And for the positions? I mean, st, gk, etc ...
Those are in the players table, preferposition1-4.

0 gk
1 sw
2 rwb
3 rb
4 rcb
5 cb
6 lcb
7 lb
8 lwb
9 rdm
10 cdm
11 ldm
12 rm
13 rcm
14 cm
15 lcm
16 lm
17 ram
18 cam
19 lam
20 rf
21 cf
22 lf
23 rw
24 rs
25 st
26 ls
27 lw
 

gartxi

Club Supporter
bangus;3874663 said:
Those are in the players table, preferposition1-4.

0 gk
1 sw
2 rwb
3 rb
4 rcb
5 cb
6 lcb
7 lb
8 lwb
9 rdm
10 cdm
11 ldm
12 rm
13 rcm
14 cm
15 lcm
16 lm
17 ram
18 cam
19 lam
20 rf
21 cf
22 lf
23 rw
24 rs
25 st
26 ls
27 lw

Thank you so much.
 

Mick-S

Youth Team
in game : team sheets / squad, you can click on a player and see his details, end button gives specialities and traits, I can find the traits in the DB but not the specialities, anyone know where those values are ? or did Rinaldo just miss it out.
also what version of DBMaster are you using.
 

bangus

Starting XI
Mick-S;3879339 said:
I can find the traits in the DB but not the specialities, anyone know where those values are ?
Specialties are not listed because they are auto-assigned depending upon a player's ratings.
 


Top