I'm working on a 2013 Database (DB) for PCM 2011 based on PCM.daily's 2012 DB V2.
It's the first time i'm doing things like this, so don't blame me if I make mistakes...
Started: Jan 4, 2013 Last update: Jan 6, 2013
Done:
- Changed the Team Names (based on this list)
- Added new / deleted old riders from AG2R
- Added new / deleted old riders from Argos Shimano
- Added new / deleted old riders from Astana
- Added new / deleted old riders from Blanco Pro Cycling
- Added new / deleted old riders from BMC
- Added new / deleted old riders from Cannondale
- Added new / deleted old riders from Euskaltel
-
To Do:
- Adding & deleting riders from all other teams
- Jerseys ( please help me with this )
- Tell me what I should do... (reply)
-
Status:
altehacke will convert his DB for PCM 2012 to PCM 2011 (& 2010), Thanks!
Well, you could do some stats maybe... Do you mean based on PCMdaily's db for PCM 2012 or PCM 2011? Cause I think that the stats will be fine if you use the PCM Daily's expension pack for PCM 2012, although you could of course change them a bit into your opinion.
I guess(depends if you want to make it a big DB, or just smaller) you can also use 2013 routes in the DB, but I don't think you can use the PCM 2012 stages, so it would require some stage-makers...
It's great to know that there are people interested in a 2013 DB for PCM11, but this is the hardest way to get it You'd be re-doing the work on the DB, which takes weeks to do. The easiest is to wait for the PCM12 DB to be released, and then convert it to PCM11. The PCM12 stages are not compatible with PCM11, but other than that, pretty much everything else will already be on fine and on its place (regarding the files, since directories for shirts, logos, minishirts, etc, hasn't changed). The only real work then will be converting the DB really
Jesleyh wrote:
Do you mean based on PCMdaily's db for PCM 2012 or PCM 2011? Cause I think that the stats will be fine if you use the PCM Daily's expension pack for PCM 2012, although you could of course change them a bit into your opinion.
I'm using the PCMdaily's db for PCM 2011 (this one)
Miguel98 wrote:
If you want any help, specially with stats from some Portuguese riders, say here, cause I will give you help.
Changing the stats is something for when all the Teams are correct
PCM rulezz wrote:
Nice , can I help you with something maybe?
lluuiiggii wrote:
It's great to know that there are people interested in a 2013 DB for PCM11, but this is the hardest way to get it You'd be re-doing the work on the DB, which takes weeks to do. The easiest is to wait for the PCM12 DB to be released, and then convert it to PCM11. The PCM12 stages are not compatible with PCM11, but other than that, pretty much everything else will already be on fine and on its place (regarding the files, since directories for shirts, logos, minishirts, etc, hasn't changed). The only real work then will be converting the DB really
Any idea when the 2013 DB for PCM 2012 is released? And how to convert? I found this one...
I can make a jersey myself, never don that before. But maybe I can look on the forum if there are jersey's for 2013 and give you the download link?
But most of the jersey's of WT -teams are already in the shirt DB
Edited by PCM rulezz on 04-01-2013 17:21
Winners never quit, quitters never win.
It's difficult not to be happy when you're surrounded by Belgians. - Mark Cavendish
You could also try converting altehacke's DB, of course. That's your choice In fact, you could even try contacting altehacke to see if he wouldn't be interested in releasing a PCM11 version of it. He decided to convert his PCM11-2012 DB to PCM10 after a request: https://pcmdaily.com/forum/viewthread....rowstart=0
As for converting a DB, basically you need to compare the main tables (DYN_cyclist, team, sponsors, etc) and check which columns have changed and which have stayed the same, and the copying/pasting information under the same columns. But between the PCM11-12 DB there's not much difference in most tables, except for STA_race and STA_stage really. F.e., the only changes in DYN_team from PCM11 to 12 is that the jersey_sz_abbreviation column is gone (now only appears in DYN_sponsor), gene_ilist_young_area is gone and there's a 3rd column for calendar of races (fkIDcalendar3).
)
, can I help you with something maybe?
