Having just created a new team I would like to try and create appropriate goals for it using Hannes Converter 2007. I've been looking and think I know the tables to use but have very little idea of just how to use them and I haven't yet found any advice on this in the forums or articles.
Any help or a point in the right direction would be appreciated.
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 in column 3.
Then make the 2 nd comlum so bigger so you can see all number that are in there.
Then remove one of the numbers 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.
I hope it’s all clear to you now. I know it’s a lot of number searching but…
thanks very much guys it's just what i was looking for, i'm off to try it out now.
and cladestino that's a very impressive first post and your english is fine!
