In e.g. PCM10 you could edit who was former national champion (gene_b_was_national_champion), former world champion (gene_b_was_world_champion) and all in the database in DYN_cyclist.
Is this string still there (and have I missed it) or is it gone, is there another table where it is in now? Because you can edit with PCM's editor so it still should be in the database.
The reason I'm asking is because I'm making a database from a couple years ago, so riders who were champion in the last couple years their championship win should be removed, and it would take ages to go over every rider one by one to check if champsthingy is checked...
Yes it is in DYN_cyclist, it is called gene_i_champion_bit. Set it to 0 to remove all champions.
This is a bit value, so it can hold much information. Example: 1 = national road champion, 2 = national tt champion. If a cyclist has won both championships he would have 3. (The numbers are only examples)
Lachi wrote:
Yes it is in DYN_cyclist, it is called gene_i_champion_bit. Set it to 0 to remove all champions.
This is a bit value, so it can hold much information. Example: 1 = national road champion, 2 = national tt champion. If a cyclist has won both championships he would have 3. (The numbers are only examples)
I have a similar question concerning the gene_i_champion_bit.
I am confused by the strange numbers it has;
71 Cancellara, -67 Hushovd, 49, 32, 33, 19, 1, 2
I assume it depends on whether you are current champion, former champion, tt or road. I wan't to edit the champions in my db based upon the pcmdaily v1.0, but I don't know which number to give the new champions.
Anyone?
TankNL wrote on ppdb forums:
For those who are using full editor v4 and you want to edit the the gene_i_champion_bit column but you're confused by the notation's; here's the guide.
title points
Current World Champion Road Race 128
Current World Champion Individual Time-trail 64
Current National Champion Road Race 32
Current National Champion Individual Time-trail 16
Former World Champion Road Race 8
Former World Champion Idividual Time-trail 4
Former National Champion Road Race 2
Former National Champion Individual Time-trail 1
But you can only enter 1 value, so add the values if a rider has more titles. so Cancellara as of 01.01.2011 had; WC ITT, former WC ITT, former RR and former ITT; 64 + 4 + 2+ 1 = 71
and now has; WC ITT, NC RR, former WC ITT, former RR and former ITT; 64 + 32 + 4 + 2+ 1 = 103
now for the catch (and no I won't explain you the basics in binary calculations), but if the total sum is above 128, then deduct 256 from the total.
So, for Thor Hushovd who is WC RR, NC RR, former RR and former ITT; so the total would 163, but its higher then 128 so it will be 163 - 256 = -93
and he now has; WC RR, former RR and former ITT; 131 - 256 = -125
hope it helps.
[url=www.pcmdaily.com/forum/viewthread.php?thread_id=33182]Team Santander Media Thread[/url]
