Load the DB you want toe dit the sponsor goal with the latest hannes convertor. Load these tables: - STA_objektif_type - STA_objectif_sponsor_info - STA_objectif_sponsor - STA_race - DYN_team
Go to objectif_type. There you see 4 columns. Forget the 2nd and 3rd. First look what your sort of goal it needs to be in the 4th column. In my example you want your team goal to be: Top 3 in Tour de France. Then you look in the 4th column in STA_objectif_info where you see top 3. Then you look in the First Column in the row of top 3 what number it is. You’ll see that it is numer 2. Keep that in mind.
Then go to STA_race We want top 3 in the tour the France. We know the number of top 3 so now th number of the tour de France. Look in the 2 nd column where you see Tour de France. Then look in the 1 column of that row. You’ll find number 25.
So now we have numer 2 and 25
Then go to objectif_sponsor. You’ll see 4 columns again but this time a lot more rows. You need to find the row that has number 2 in the 2 nd column and number 25 in the 3 rd column. Because the 2 nd indicates the sort of goal and the 3 rd indicates the race. When you found that row you’ll find number 1077 in the first column. That is your sponsor goal code. Now we need to set it as sponsor goal.
First you need to know the number of your team So go to DYN_team Find your team name in the 2 nd column. Then look what number is in the first column. Let’s say our team is astana. You’ll find number 12
then go to STA_objectif_sponsor_info Find you team. Which is number 12(astana) in column 3. Then make the 2 nd comlum some bigger so you can see all number that are in there. There`s 11 numbers. These numbers are: first 5 are the goals last 6 are the importance of the races/objectifs (the stars) Then remove one of the first 5 numbers(the goals) and replace it with number 1077(top 3 in tour de france).
Repeat this untill you have your new goals and you’re happy. If you want to remove one certain goal you’ll have to look up that number as well so you can replace it.
If you have any questions, feel free to PM me.
mrlol
· Posted by mrlol
on October 25 2007 ·
0 Comments ·
10815 Reads ·
