|
Messing with STA_Calender AND STA_UCI_class
|
| clamel |
Posted on 26-11-2014 10:00
|
Protected Rider
Posts: 1359
Joined: 13-07-2010
PCM$: 200.00
|
OK, who is sure about adding a new race calender.
This STA_calender seams to be connected to countries of course, and then more important to what calenders a ceratin teams prefer to race in.
Looking at most DBs, having about the same I do question the choice of Portugal as a single calender, with the fact Portugal having just a few races.
Some combination with Spain and Andorra looks more natural, but my addition (if not replacing Portugal) would be to add Australia/New Zealand as a calender of it´s own.
Plenty of great races have been created by stage-makers to add and these perhaps should not be added to the so known ASIAN calender.
Like UK the aussies and kiwis have their own great series and adding such, within the standard UCI calenders could be a nice touch. In fact the OCEANIC Tour is listed with UCI, but has only a few races to date.
Knowing that Cyanide put restrictions on many tables, this is why I ask more knowing folks in this forum.
SHOULD I REPLACE PORTUGAL, OR COULD I ADD A NEW CALENDER.
I do know that I then need some fixing in STA_country, but that´s it. OR ?
What I do think is not possible is adding a new UCI-class to match more regional races like Australias NRS or British series. The STA_UCI_class table feels limited as it is.
Dream had to be adding such a class as NationalSeries with it´s own points structure of course, but then it will perhaps turn out like the races within U23 classes. That¨s NOT raceable....
I know the STA_division should then be messed with too.
But I´m trying to find out how much this has been tried with before.
Edited by clamel on 30-11-2014 11:31
|
| |
|
|
| Bikex |
Posted on 26-11-2014 12:10
|
Team Leader
Posts: 7385
Joined: 25-08-2012
PCM$: 600.00
|
It is possible to add a new calendar. I did this before and it worked  |
| |
|
|
| clamel |
Posted on 28-11-2014 18:06
|
Protected Rider
Posts: 1359
Joined: 13-07-2010
PCM$: 200.00
|
Then I must add and ask
Is it possible to add a new divison in STA_division, for example National Road Series. I do believe not, but I have to ask.....
|
| |
|
|
| matt17br |
Posted on 28-11-2014 18:57
|
Directeur Sportif
Posts: 10519
Joined: 28-09-2013
PCM$: 200.00
|
clamel wrote:
Then I must add and ask
Is it possible to add a new divison in STA_division, for example National Road Series. I do believe not, but I have to ask.....
Don't think so, or at least I'm 100% sure that it won't be the only table that you'll have to edit (you'll probably have to edit the local.cdb as well as some other tables) or probably the game just doesn't allow that
|
| |
|
|
| sgdanny |
Posted on 28-11-2014 19:13
|
Classics Specialist
Posts: 3587
Joined: 18-03-2014
PCM$: 200.00
|
Yes you can't add a new division , but you can change the current ones , but then you have to replace the files with new images for the career mode and such 
|
| |
|
|
| clamel |
Posted on 29-11-2014 17:03
|
Protected Rider
Posts: 1359
Joined: 13-07-2010
PCM$: 200.00
|
OK,
but how about the STA_UCIclass table. At first look it looks ok to add anew class, most like those added like
FranceGrandTour
AutreGrandTour
AutresTours
ClassiqueMajeure
AutresClassiques
are all connected to GS1 division.
adding a new class then connect it to GS3 for example
My question then is what about the ciolumn
gene_strID_UCI_class ???
mostly numbers in the 800 range, but where is that connected ?
Since this STA_UCIclass table is very much linked with STA_Racerules it can be used I hope.
Several DB creators have missed this connection. A race that have ex.
AutresTours in the race table (STA_race) only need a line in STA_racerule IF it differs from the number in STA_UCIclass table for how many teams and riders that is max.
I have seen many doubles up in this. Sad since STA_Racerules are limited on hw many lines it can hold.
So anyone can 100% sure tell me about gene_strID_UCI_class ??? |
| |
|
|
| sgdanny |
Posted on 29-11-2014 17:20
|
Classics Specialist
Posts: 3587
Joined: 18-03-2014
PCM$: 200.00
|
I believe that you can't add a new one , only replace the current ones with the same method as in sta_division. But this just requires you to add a new logo for your new class
Edited by sgdanny on 29-11-2014 17:56
|
| |
|
|
| clamel |
Posted on 30-11-2014 11:29
|
Protected Rider
Posts: 1359
Joined: 13-07-2010
PCM$: 200.00
|
The STA_divison table seams more imprtant since it is the one setting up GS1,GS2,GS3 which ALL teams then are divided into.
Probably not to be messed with.
However the STA_UCI_class table are all connected to this STA_divisions and if not possible to add, one surely can change, like you say.
The two classes Olympics looks redundent, unless it´s a olympic year and that I guess is nothing Cyanide have automatic to pop up each 4th years in career mode I think. It has to be edited in by the gamer to work.
The logo as you mention is added work, but not necessary for it to work I think. Just eye-candy.
What this UCI_class table do is setting the groundwork for how many teams and riders that basically can start in a race.
First the STA_division (most important)
then the groupings of rules in STA_UCI_class
third and finer adjustment in STA_Race_rules
also STA_bonus_superpretige comes into play in getting the correct UCI points and money to correct . Very important table, and need to be brought in if setting up a new class.
Still my biggest concern is
gene_strID_UCI_class ???
THIS column has mostly numbers in the 800 range, but where is that connected ?
To what table....
|
| |
|
|
| matt17br |
Posted on 30-11-2014 12:37
|
Directeur Sportif
Posts: 10519
Joined: 28-09-2013
PCM$: 200.00
|
clamel wrote:
The STA_divison table seams more imprtant since it is the one setting up GS1,GS2,GS3 which ALL teams then are divided into.
Probably not to be messed with.
However the STA_UCI_class table are all connected to this STA_divisions and if not possible to add, one surely can change, like you say.
The two classes Olympics looks redundent, unless it´s a olympic year and that I guess is nothing Cyanide have automatic to pop up each 4th years in career mode I think. It has to be edited in by the gamer to work.
The logo as you mention is added work, but not necessary for it to work I think. Just eye-candy.
What this UCI_class table do is setting the groundwork for how many teams and riders that basically can start in a race.
First the STA_division (most important)
then the groupings of rules in STA_UCI_class
third and finer adjustment in STA_Race_rules
also STA_bonus_superpretige comes into play in getting the correct UCI points and money to correct . Very important table, and need to be brought in if setting up a new class.
Still my biggest concern is
gene_strID_UCI_class ???
THIS column has mostly numbers in the 800 range, but where is that connected ?
To what table....
Uciclass is actually connected to sta_race and some other stage race related tables.
|
| |
|
|
| sgdanny |
Posted on 30-11-2014 13:12
|
Classics Specialist
Posts: 3587
Joined: 18-03-2014
PCM$: 200.00
|
I'm not sure what you want to do / change ?
|
| |
|
|
| Ad Bot |
Posted on 16-12-2025 04:20
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| sgdanny |
Posted on 30-11-2014 13:36
|
Classics Specialist
Posts: 3587
Joined: 18-03-2014
PCM$: 200.00
|
Sorry for double posting
-----------
Let's go through the Sta_UCI_Class first :
IDUCI_class Is the ID of the Class, essentially this is connected to many variables
gene_strID_name : Is an unique ID only reserved by one column throughout the database
gene_tgaID_logo Refers to the ID in the local.cdb that sets the directory of the class logo
Constant Is the name of Class
gene_i_max_team The following 3 lines are the presets of the default rules for the class, in sta_race_rules you can customize each race specifically, this one is for the max allowed number of teams
gene_i_min_rider Minimum allowed riders to race for the participating teams
gene_i_max_rider Max ...
gene_i_sort_order Doesn't need explanation
gene_sz_calendar_color Hex number of the color representing each class
fkIDdivison The division mainly targeted for this class, several things can override this, but as default most teams from the specific divison will gain the highest number of participating teams
|
| |
|
|
| sgdanny |
Posted on 04-12-2014 18:45
|
Classics Specialist
Posts: 3587
Joined: 18-03-2014
PCM$: 200.00
|
sgdanny wrote:
Sorry for double posting
-----------
Let's go through the Sta_UCI_Class first :
IDUCI_class Is the ID of the Class, essentially this is connected to many variables
gene_strID_name : Is an unique ID only reserved by one column throughout the database
gene_tgaID_logo Refers to the ID in the local.cdb that sets the directory of the class logo
Constant Is the name of Class
gene_i_max_team The following 3 lines are the presets of the default rules for the class, in sta_race_rules you can customize each race specifically, this one is for the max allowed number of teams
gene_i_min_rider Minimum allowed riders to race for the participating teams
gene_i_max_rider Max ...
gene_i_sort_order Doesn't need explanation
gene_sz_calendar_color Hex number of the color representing each class
fkIDdivison The division mainly targeted for this class, several things can override this, but as default most teams from the specific divison will gain the highest number of participating teams
Did this answer all your questions ?
|
| |
|
|
| clamel |
Posted on 05-12-2014 09:55
|
Protected Rider
Posts: 1359
Joined: 13-07-2010
PCM$: 200.00
|
Well, lets see (I am kind of slow in thinking, sorry mates)
My general issue of trying is based on this idea.
Kind of two folded.
First I am in dire need on getting more race_rules into the game. I have combined the STA-RaceRules and this STA_UcI_class tables and that good.
Now to get more out I was thinking in the directions the upper classes World Tour and HC races are divided.
FranceGrandTour (only TDF)
AutreGrandTour (the other two)
ClassiqueMajeure (top classics)
AutresTours & AutresClassiques(the rest of in world tour)
These five are the world tour then
Cont2HC & Cont1HC(the remaining HC races NOT in world tour)
You get my drift.
In lower parts the 1.2 and 2.2 races have only ONE section (post) and that was my aim. I am trying to create 1 new line in the general idea as the World Tours are divided up. Still directing all it towards GS3 of course.
Getting National Series from ex (UK,Australia and US) in at the lowest level.
Still presenting them as 1.2 and 2.2 races basically BUT
involving the other table STA_bounusprestige with all the points handed out in overall competion. Also STA_bonus_UCI got some cool info of course that is directed towards UCI_classes (needs to be involved too)
THIS final table should have a much lower point system for these National series races, so they don´t attract to many teams from "abroad".
I have lowered their popularity already, so this points deduction could be another step.
However more important was to get an OVERALL rule for lesser teams, lets say 15 max for ONLY these National Series races. That will limit the abroad teams too.
It´s kind of wild and just an idea.
The basic QUESTION on this is if I can ADD a post in STA_Uci_class with this OR change ex. Olympics. My tries have failed so far.
The question on the fields that I think is the major issue
IDUCI_class
and
gene_strID_UCI_class (Guess is the one you call gene_strID_name, the one with 800 numbers)
And hey
thanks for your interrest and answers. I might have picked up something  |
| |
|
