Change Team with an editor
|
CrueTrue |
Posted on 04-03-2008 19:38
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
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 |
|
|
|
Ad Bot |
Posted on 24-11-2024 16:34
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
IP: None |
|
|
Dankan |
Posted on 04-03-2008 19:42
|
Protected Rider
Posts: 1065
Joined: 29-10-2006
PCM$: 200.00
|
That's way too easy.
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. |
|
|
|
Halvor |
Posted on 04-03-2008 19:42
|
Sprinter
Posts: 1951
Joined: 18-09-2007
PCM$: 200.00
|
What kind of editing? |
|
|
|
Halvor |
Posted on 04-03-2008 19:42
|
Sprinter
Posts: 1951
Joined: 18-09-2007
PCM$: 200.00
|
What kind of editing? |
|
|
|
Takitdown |
Posted on 04-03-2008 19:43
|
Stagiare
Posts: 234
Joined: 26-09-2007
PCM$: 200.00
|
someone is bragging they can do it and they didn't helped me?:cry: |
|
|
|
Takitdown |
Posted on 04-03-2008 19:50
|
Stagiare
Posts: 234
Joined: 26-09-2007
PCM$: 200.00
|
Dankan wrote:
That's way too easy.
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 comunities
Edited by Takitdown on 04-03-2008 19:52
|
|
|
|
Jape |
Posted on 04-03-2008 21:02
|
Neo-Pro
Posts: 277
Joined: 12-06-2007
PCM$: 200.00
|
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. |
|
|
|
Dankan |
Posted on 04-03-2008 21:19
|
Protected Rider
Posts: 1065
Joined: 29-10-2006
PCM$: 200.00
|
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 |
|
|
|
niconico |
Posted on 06-05-2008 23:02
|
Grand Tour Specialist
Posts: 4102
Joined: 09-07-2007
PCM$: 200.00
|
Dankan wrote:
That's way too easy.
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?
|
|
|
|
Jakub_MSP |
Posted on 19-09-2008 16:04
|
Amateur
Posts: 18
Joined: 08-08-2007
PCM$: 200.00
|
Dankan wrote:
That's way too easy.
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! |
|
|