PCM.daily banner
25-04-2024 16:44
PCM.daily
Users Online
· Guests Online: 34

· Members Online: 0

· Total Members: 159,136
· Newest Member: zupagrzybowa123
Articles Hierarchy
Articles Home » PCM 07: General Articles » Editing Tips: Race Inscriptions
Editing Tips: Race Inscriptions
For this guide i will use the Hannes Convertor 2.0, available for download from this site, by going to the downloads section or clicking HERE!!

All you need to do, is download that pack and open it up. Once open you need to click the button on the top left (it looks a bit like a plug). This is where you will select your database, that you wish to edit.

You will need to open up 3 tables for this process. They are STA_race, DYN_team and DYN_team_race (to open them both use Ctrl+click)

1. Firstly we will need to find the race you wish to edit your team's inscription status in. To do this we need to open STA_race.

2. Locate the name of the race you want to edit your subscription to, and note the number in the column "IDrace", by writing it down or memory.

3. Now open up DYN_team, search for your team an note down the number in the column "IDteam".

4. You can now close that table and open up DYN_team_race.

5. Search for the race, using the number you noted, by looking under the column "fkIDrace", and then locate your team's row using the team ID you noted down in step 3.

6. "fkIDinvitation_state" is the important column and depending on what status you wish to choose out of:

1InvitedINVITED
2Asking wildcardASKING_WILDCARD
3SubscribedSUBSCRIBED
4RejectedREJECTED
5Not interestedNOT_INTERESTED
6Given upGIVEN_UP
7Asking invitation (for human only)ASKING_INVITATION
8Will subscribe (for human only)WILL_SUBSCRIBE
9Not invitedNOT_INVITED
10ForcedFORCED


- the ones in bold are the options you would choose if you wanted to participate.
- the ones underlined are the options you would choose if you didn't want to participate.
- the ones in italics are the options you would choose if you weren't fully sure yet.

Whichever option you would like to use, put the corresponding number (on the left of option) into the box, in your teams row, under the column "fkIDinvitation_state".

7. Save using the button at the bottom of the screen, then the button at the top (looks like a floppy disc), select which savegame to overwrite then when the window appears showing the tables you opened, make sure you click on the ones you have edited before click OK, otherwise no effects will be noticed.
Comments
#1 | SportingNonsense on 20. October 2007 15:01
Very useful guide!
#2 | casprdko on 20. January 2008 18:28
What can we do if there is no entry in the DYN_team_race table for the Team id and race id?
#3 | Darthvador on 29. April 2008 19:06
where do you open STA_race DYN_team DYN_team_race from???
#4 | CrueTrue on 29. April 2008 20:36
Hannes Converter...
#5 | Dennuz on 02. May 2008 15:29
Will a patch be released that will correct this bug (milan-San Remo)? Because I can't seem to get it fixed with the Hannes Convertor.

When I open DYN_team_race I get a blanc sheet. I only have to fill in the numbers of the race and my team and the fkIDinvitation_state? Then save?
Post Comment
Please Login to Post a Comment.
Ratings
Rating is available to Members only.

Please login or register to vote.

No Ratings have been Posted.
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
Ready... Set... Go!
Ready... Set... Go!
PCM 08: Funny Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 15,476 PCM$
bullet df_Trek 14,574 PCM$
bullet Marcovdw 12,345 PCM$
bullet jseadog1 10,852 PCM$
bullet baseba... 9,139 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 20,090 PCM$
bullet df_Trek 12,620 PCM$
bullet Marcovdw 11,800 PCM$
bullet jseadog1 10,800 PCM$
bullet baseball... 6,232 PCM$

bullet Main MG Betting page
bullet Get weekly MG PCM$
bullet Rankings: Top 100
Render time: 0.45 seconds