Changing season goals with the Hannes Convertor/Kicker NG:
-----------------------------------------------------------------------
This is done in MS Access !!
1 Open table 'DYN_team'
2 Browse the field 'gene_sz_name' for your team
3 Get the corresponding number in the column 'IDteam'
4 Get the objectif numbers for your team ... SELECT gene_ilist_fkIDobjectif FROM STA_objectif_sponsor_info WHERE fkIDteam = [the number you got in point 3]
5 ... and their corresponding goals SELECT * from STA_objectif_sponsor WHERE fkIDobjectif_type IN (SELECT gene_ilist_fkIDobjectif FROM STA_objectif_sponsor_info WHERE fkIDteam = [the number you got in point 3])
6 Now you can start modifying :
|-> GOALS : Only 5 numbers can be present. Search for the objectives you want in the 'STA_objectif_sponsor' table, and replace the numbers you got in point 5.
|-> IMPORTANT RACES : 6 races to select for this list, 2 per level where :
* Level3_[RaceName] stands for a *** race
* Level2_[RaceName] stands for a ** race
* Level1_[RaceName] stands for a * race
You should end up having a list of 11 lines, comma-separated, which needs to be pasted over the existing list in STA_objectif_sponsor_info.gene_ilist_fkIDobjectif
7 Copy STA_objectif_sponsor_info.gene_ilist_fkIDobjectif to relational field STA_objectif_sponsor_info_future.gene_ilist_fkIDobjectif
This sounds logical to me - haven't tested this ...
If anyone has things to change / add for this procedure, please feel free ...
Edited by Djoe on 10-07-2007 10:11
+++ DIVIDE BY CUCUMBER ERROR. PLEASE REINSTALL UNIVERSE AND REBOOT +++
4 Get the objectif numbers for your team ... SELECT gene_ilist_fkIDobjectif FROM STA_objectif_sponsor_info WHERE fkIDteam = [the number you got in point 3]
4 Get the objectif numbers for your team ... SELECT gene_ilist_fkIDobjectif FROM STA_objectif_sponsor_info WHERE fkIDteam = 1
I get one line for team "1" (Caisse d'Epargne) with value = 11
5 ... and their corresponding goals SELECT * from STA_objectif_sponsor WHERE fkIDobjectif_type IN (SELECT gene_ilist_fkIDobjectif FROM STA_objectif_sponsor_info WHERE fkIDteam = 1)
I get 1350 line.
How I know witch line is for Caisse d'Epargne ?
Edited by duxy on 11-07-2007 11:03
