I know it's possible, and I know some people have been bragging saying they can do it - but despite that, no one has ever been able to explain how to change the team of the manager through an editor. So, there you go. A challenge for all you DB-wizards
1) GAM_user. IDuser = 1. fkIDteam_duplicate = the team's ID you want to play.
2) DYN_team. fkIDuser_duplicate = 1 for the team you want to play, 0 for the team you're leaving.
1) GAM_user. IDuser = 1. fkIDteam_duplicate = the team's ID you want to play.
2) DYN_team. fkIDuser_duplicate = 1 for the team you want to play, 0 for the team you're leaving.
And that's it.
Easy when you are the people that most understand's about pcm 2007 in all the international comunitiesEdited by Takitdown on 04-03-2008 19:52
Shouldn't you change DYN_contract_manager too ? Don't know if there are any side effects if you leave that like it was. Also i noticed that fkIDuser_duplicate also has an 1 entry for the country in DYN_team, may be an easy way to edit the national team you play on WC instead of the teams country.
Jape wrote:
Shouldn't you change DYN_contract_manager too ? Don't know if there are any side effects if you leave that like it was. Also i noticed that fkIDuser_duplicate also has an 1 entry for the country in DYN_team, may be an easy way to edit the national team you play on WC instead of the teams country.
It's not necessary to edit the DYN_contract_manager, believe me. I used that before B)
About the WC-thingy: nice idea It's not hard to rememer how much time you've spent on DB's and programming by seeing these brainstromings
1) GAM_user. IDuser = 1. fkIDteam_duplicate = the team's ID you want to play.
2) DYN_team. fkIDuser_duplicate = 1 for the team you want to play, 0 for the team you're leaving.
And that's it.
Well it works and I've managed to change teams that way, only problem is that I get the pop-up window where I have to to choose between three teams because it says I haven't done well enough. Even when I choose another team and try to go to the next day I get the same message again so I can't move on.
I have no idea but could it have something to do with I changed teams on December 31?
1) GAM_user. IDuser = 1. fkIDteam_duplicate = the team's ID you want to play.
2) DYN_team. fkIDuser_duplicate = 1 for the team you want to play, 0 for the team you're leaving.
And that's it.
It works, I'm in another team, but season goals and Sponsor's confidence stay!
It's not hard to rememer how much time you've spent on DB's and programming by seeing these brainstromings 
