• 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

Alex

sKIp_E
Staff member
Administrator
Super Moderator
Re: Re: Re: .

Originally posted by Hakeem
I mean the position in Arsenal.
I change the position in the team for bergkamp (put him as a susbtitute = 32) and I put my player in the position of bergkamp and then in the game bergkamp was in the bench and my player in the field and the other players were ok, not messed up.




I didnt checked about this but I put my created team in the rest of the World Section AND in my new league and the team appeared in the Rest of the World Section in the game but the new league didnt.

Hakeem, i take it ur using the unlinking and relinking trick to make lower player ID's?

If so, than this is why it is working for u, and not for others ;)

Cheers
sKIp_E
 

Maniac

Reserve Team
Woho!! I've solved it!!

Take a look at the player numbers!!!!
When you add a player ti goes from 1999 and up !!! :D
 

The Hedgehog

Reserve Team
wow!

Originally posted by Maniac
Woho!! I've solved it!!

Take a look at the player numbers!!!!
When you add a player ti goes from 1999 and up !!! :D

Great!!!! When are you going to release the tool...?
 

rid

Club Supporter
that's good. then, i don't need to complete my tool. but what about the people hasn't ms access??
 

butcher

Youth Team
About faces and hairstyles:

why don't you try what I did?

after making my files complete in access (I didn't even bother with hairstyles and faces) I went and edited the appearances on the CC...simple?

well...I'd still like some help from anyone who can tell me what the formations and playing styles and strategies are in the team table...and of course how to make MY logo appear on the menus...
 

lukas_svoboda

Senior Squad
the most commonly used formation today is 4-4-2. For this setting, choose formation=24, tactics=3, style=1

if you finalize the player appereance in the CC, then you have some info stored in the MDB and some info strored in the PKG. It is better to have everything in one file. It is easier to distribute the rosters then.
 

gigiuzzo

Youth Team
Originally posted by Maniac
Woho!! I've solved it!!

Take a look at the player numbers!!!!
When you add a player ti goes from 1999 and up !!! :D

Where is the player's jersey number option ???....
 

Alex

sKIp_E
Staff member
Administrator
Super Moderator
Originally posted by lukas_svoboda
the most commonly used formation today is 4-4-2. For this setting, choose formation=24, tactics=3, style=1

if you finalize the player appereance in the CC, then you have some info stored in the MDB and some info strored in the PKG. It is better to have everything in one file. It is easier to distribute the rosters then.

Yeah, formation is the only one that actually decides the formation though. Tactis are whether its attacking etc, and style im not sure about.
I also know that 13 for formation is 4-1-2-1-2 ;)
Cheers
sKIp_E
 

Alex

sKIp_E
Staff member
Administrator
Super Moderator
Hakeem or Lukas u might be able to help me here:

Now using the relationship tihng, i can create brand new players, and teams, and they work great: Creating a new player with this method (and a lower ID number) means that his settings are kept in the game, and Creating a new team with this method means that players added to that team also keep their settings in the game.

HOWEVER, because an added team has no logo file, and the game doesnt use the default CC one because it doesnt realise its a new team, just after the actual match is loading, it crashes back to windows. If there is a way to import logos, flags etc, than it will fix this problem. I am pretty sure this is the problem, its the only thing i could narrow it down to.

Any ideas?

Cheers
sKIp_E
 

Alex

sKIp_E
Staff member
Administrator
Super Moderator
Originally posted by Maniac
Woho!! I've solved it!!

Take a look at the player numbers!!!!
When you add a player ti goes from 1999 and up !!! :D

Make sure that it doesnt have the same number as any current players though ;)

Also, reserves arent 33/34 they are 33/35 ;)
 

Alex

sKIp_E
Staff member
Administrator
Super Moderator
Originally posted by Maniac
And here is the Team Add/Edit window:


That Sim Rank thing, that u have in unknown represents how well the team plays in matches that are simulated (ie. when u click simulate during a league/tourney, or matches between two CPU teams in a tourney)

Also i was thinking maybe the GFX thing in that unknown area is what i was looking for in my earlier post..lets hope

Cheers
sKIp_E
 

butcher

Youth Team
well...

Ok...formation numbers are formations AND strategies within the game ...RG. formation 4 is 3-5-2 attacking

some formations I've found are
13: 4 -1-2-1-2
24: 4-4-2 as pointed out
25: 4-5-1
4: 3-5-2 attacking
18: 4-3-3
19: 4-4-2 attacking
I still haven't found 2-5-3 or 3-6-1...I don't know any teams that play like that...oh! and I don't know what playing style is at all!

So if Strategies are about attacking or defending what's the difference? I suppose 3 is attacking while 1 is defending since Brazil play 3 and Italy 1 but then again can't be sure...maybe playing style is about attacking and defending...

worst thing is I don't know how to find out what is what for sure...

any ideas?
 

Alex

sKIp_E
Staff member
Administrator
Super Moderator
I think that playing style is maybe an AI thing. How aggresive the team plays etc. Im really not sure about this though.

Strategy is still the team management thing, and is the bit underneath the formation selector (where u can choose what form of that formation u want-not all formations have choices, many only have one type ;))

Cheers
sKIp_E
 

Treebeard

Youth Team
The util looks great. Thanks for your hard work. Is there any way of starting the new player ID numbers lower down than 1999 as this would allow more players to be added in?

Tb
 

Hakeem

Superman
,

Skip:

I think we have to know how does the game knows, if change the flags, logos, etc for a team, where are the files of those. coz in the teams table theres a grafix field and a chants field but everybody has it in 0 so I guess that if we can create the grafix and sounds in the "Custom_Suport_Sounds" and "Custom_Suport_grafics" and grab the IDs.
Then go back to the teams table and set those grafics and chants values to the IDs we created.
then when we go to the CC I think somethign is gonna show up cos the CC will need to find those graphics we setted for the teams right?

this same thing could be done for the kits (in the custom_kits table) but its easier to add new kits and IDs in the kits table and then add the FSHs to the big kits file.

and Treebeard:

your start in 1999??? how did you do that?
 

The Hedgehog

Reserve Team
...

I've started to create such forms too to make the editing with Access more easy.

I have still some problems beacuse that was ages ago when I last used Access. I created a form for the KITS first, now I'm working on to add/edit players.

BUT!!! I don't wanna challenge with Hercules and Maniac. I know they will do a better "tool"...

I just want to edit my hungarian patch more easily. Thats all :D
 


Top