How to add a new National Championship
|
Nicholas |
Posted on 31-07-2007 14:59
|
Under 23
Posts: 91
Joined: 02-12-2006
PCM$: 200.00
|
Hi
Im makin a db for PCMNorge.com, and atr trying to add the norwegian national championship. I have made the race, but i cant get it to the right place on the calendar, or to get the stage together with the race. I'm using Hannes v.2. Any solutions? |
|
|
|
Addy291 |
Posted on 31-07-2007 15:07
|
Grand Tour Champion
Posts: 8915
Joined: 29-11-2006
PCM$: 200.00
|
i will just write down how i think it could work
YORKSHIRE BORN, YORKSHIRE BRED...
|
|
|
|
Addy291 |
Posted on 31-07-2007 15:57
|
Grand Tour Champion
Posts: 8915
Joined: 29-11-2006
PCM$: 200.00
|
1. go into STA_race
2. click on the blank row at the bottom
3. it will have an automatically generated number in the IDrace column, leave that
4. type 'Norwegian Championships' in the two columns next to the ID (or in whatever language)
5. fkIDcountry, put the code for Norway, '35'
6. fkIDnewUCI_class put the code '14' (national champs RR)
7. put '81' in the column fkIDclassification_time
8. put '0' in the next 2 columns (mountain and points)
9. put 127 in the next column (fkIDclassification_team)
10. put '0' in the next 3 columns (specific 1, 2 + 3)
NOW OPEN UP ANOTHER HANNES CONVERTOR (open the another program keeping the other still open as we will come back to it)
11. go into STA_stage
12. click on the blank row at the bottom
13. automatically generated stage ID, leave it
14. fkIDrace, put in the automatically generated ID number from step 3
15. gene_i_day, gene_i_month put when you want it
16. now the gene_i_computed_date
go to this website https://www.onlineconversion.com/unix_...x_time.htm and in the bit that says Convert a Date/Time to a Unix timestamp, put the month, day and year in and click submit
the number that comes up is the number you put in the column i named above
17. gene_sz_stage_name put int Norwegian Championships or whatever you want
18. fkIDstage_type put '1'
19. fkIDrelief, put a number between 1 and 4
20. feat_f_rain put in 5, 15, 25, 30 or 50
21. feat_f_direction_wind put 999
22. gene_i_stage_number, put 1
23. gene_f_distance, however long it is
24. gene_i_sprints_number put 0 unless it has intermidiate sprint, which i doubt
25. gene_i_num_ravito put 3 or 4
26. gene_f_time_gap put 20
27, gene_b_selected put 1
28. gene_f_start put 0
29. gene_f_altitude put 0
30. gene_f_spline_length haven't got a clue what a spline is, so unless you know copy one of the other national champs
31. weather put 0
32. temperature put 0
33. addtemperature put 0
34. gene_f_mountain if it's flat put 0 if it's not put something (don't know what)
35. gene_f_uphillsprint put 0 unless there is an uphill sprint
36. gene_b_hascobble put as 0 unless has cobbles
37. gene_b_demo put as 0
38. gene_b_ladder_stage put as 0
39. CONSTANT leave blank
40. fkIDday put as 0
41. gene_sz_stage_xml put in the xml file name
42. gene_sz_stage_ladder_xml leave blank
43. gene_sz_stage_md5 wtf is that
44. gene_sz_stage_ladder_md5 leave blank
45. gene_b_played put as 0
BACK TO THE OTHER ONE (STA_race)
46. fkIDfirst_stage, fkIDlast_stage put inthe automatically generated stageID in step 13 (man that was a long time ago)
47. all 4 jersey ones put as 0
48. gene_b_inscription put as 0
49. gene_b_importantrace put as 0
50. gene_i_number_stages put as 1
51. number flat, number hill, number high mountain, put all as 0 apart from the stage type it is where you put a 1
52. gene_b_isactive put as 0
53. gene_i_min_cyclist put as 1
54. gene_i_max_cyclist put 9
55. leave the email column blank
56. leave the gene_ilist_fkIDteam blank
57. fkIDLastRaceLead put as 0
58 CONSTANT put as champ_norway (or whatever but it has to be champ_)
59. local_temp_count put as 0
60. gene_sz_classification_xml put 'default.xml'
61. gene_b_classification_mountain, classification_points, classification_young, gene_b_customrace and gene_f_organisatuer_coeff put as 0
62. gene_sz_variant_xml put Norwegian championships
63. fkIDtype_tour put as '9' (national champ)
64. gene_b_aso put as 0
65. make sure you save both open tables via the small button at the bottom, then the big button at the top and make sure you click on the table name before clicking ok
FINISHED!!!!!!!!!!!!!!!!!!!
my god that took ages
hope it helps and hope that answers you're question, if it doesn't, i will kill you
please report back if it works or not
Edited by Addy291 on 31-07-2007 18:10
YORKSHIRE BORN, YORKSHIRE BRED...
|
|
|
|
Smoothie |
Posted on 31-07-2007 16:04
|
Team Leader
Posts: 6622
Joined: 04-02-2007
PCM$: 300.00
|
So can you add a british RR championship?? |
|
|
|
Addy291 |
Posted on 31-07-2007 16:07
|
Grand Tour Champion
Posts: 8915
Joined: 29-11-2006
PCM$: 200.00
|
yes if you can be botherd
YORKSHIRE BORN, YORKSHIRE BRED...
|
|
|
|
CrueTrue |
Posted on 31-07-2007 16:07
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
Very good job, Addy. |
|
|
|
Addy291 |
Posted on 31-07-2007 16:08
|
Grand Tour Champion
Posts: 8915
Joined: 29-11-2006
PCM$: 200.00
|
thanks, it took a while but i got there
i was working on writing that down for like 20/30 mins
Edited by Addy291 on 31-07-2007 16:09
YORKSHIRE BORN, YORKSHIRE BRED...
|
|
|
|
Smoothie |
Posted on 31-07-2007 16:09
|
Team Leader
Posts: 6622
Joined: 04-02-2007
PCM$: 300.00
|
Hmm i cant make stages so ill request someone to do it for me! It would be great to race the Brit Champ it would add a whole new dimenson to my story! |
|
|
|
Addy291 |
Posted on 31-07-2007 16:10
|
Grand Tour Champion
Posts: 8915
Joined: 29-11-2006
PCM$: 200.00
|
yes it would be great, unfortunatley i can't make stages either, well i haven't tried
YORKSHIRE BORN, YORKSHIRE BRED...
|
|
|
|
Ad Bot |
Posted on 25-12-2024 02:59
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
IP: None |
|
|
Smoothie |
Posted on 31-07-2007 16:13
|
Team Leader
Posts: 6622
Joined: 04-02-2007
PCM$: 300.00
|
"This is a call to all stage creators, can you make a British national championship race." I hope to find a profile of the race... |
|
|
|
Addy291 |
Posted on 31-07-2007 16:14
|
Grand Tour Champion
Posts: 8915
Joined: 29-11-2006
PCM$: 200.00
|
why don't you put a request in the Stages section, maybe Roadie will help
i hear Jape is very good at making stages as well
Edited by Addy291 on 31-07-2007 16:14
YORKSHIRE BORN, YORKSHIRE BRED...
|
|
|
|
Smoothie |
Posted on 31-07-2007 16:15
|
Team Leader
Posts: 6622
Joined: 04-02-2007
PCM$: 300.00
|
We could always use a national championship stage that exists already |
|
|
|
Addy291 |
Posted on 31-07-2007 16:17
|
Grand Tour Champion
Posts: 8915
Joined: 29-11-2006
PCM$: 200.00
|
then why did you suggest making one
YORKSHIRE BORN, YORKSHIRE BRED...
|
|
|
|
Smoothie |
Posted on 31-07-2007 16:23
|
Team Leader
Posts: 6622
Joined: 04-02-2007
PCM$: 300.00
|
Hehe that was my 1st idea and this my second |
|
|
|
SportingNonsense |
Posted on 31-07-2007 16:57
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
Maybe a profile for Sundays race will be released? You could alaways use the profile from PPDB and just add roads.
|
|
|
|
Addy291 |
Posted on 31-07-2007 16:58
|
Grand Tour Champion
Posts: 8915
Joined: 29-11-2006
PCM$: 200.00
|
well not me and Smoothie we don't know how to
YORKSHIRE BORN, YORKSHIRE BRED...
|
|
|
|
SportingNonsense |
Posted on 31-07-2007 16:59
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
I'll do it then
|
|
|
|
Smoothie |
Posted on 31-07-2007 17:06
|
Team Leader
Posts: 6622
Joined: 04-02-2007
PCM$: 300.00
|
Im stuck in a bad place now ive know how to do it i would love to do them in my story but, i cant edit the offical release with my save game. I dont know weather to restart my story or just leave it... |
|
|
|
murder |
Posted on 31-07-2007 17:32
|
Junior Rider
Posts: 28
Joined: 19-07-2007
PCM$: 200.00
|
@ addy ,
you got a great knowledge , im wondering that you dont know how to give a rider the Leader Jersey for the cya top tour, dont you? |
|
|
|
SportingNonsense |
Posted on 31-07-2007 17:33
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
Murder, you cant just give it to a rider - they have to actually be leading the toptour for them to wear it. I suppose there might be a setting somewhere in Hannes, hidden away.
Edited by SportingNonsense on 31-07-2007 17:34
|
|
|