|
How to edit sponsor goals?
|
| dawso |
Posted on 23-10-2007 12:40
|
Junior Rider
Posts: 35
Joined: 07-04-2007
PCM$: 200.00
|
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. |
| |
|
|
| rodda |
Posted on 23-10-2007 12:41
|
Small Tour Specialist
Posts: 2276
Joined: 17-08-2007
PCM$: 200.00
|
if you click on a team and go to "edit team" i think it is then a window pops up in which you are able to select sponsor goals
|
| |
|
|
| mrlol |
Posted on 23-10-2007 12:51
|
Grand Tour Specialist
Posts: 5005
Joined: 24-06-2007
PCM$: 200.00
|
maybe later today if I find time I'll take a look at it and tell you exactly how to do it cus I'm changing my goals as well soon  |
| |
|
|
| dawso |
Posted on 23-10-2007 12:55
|
Junior Rider
Posts: 35
Joined: 07-04-2007
PCM$: 200.00
|
thanks for the help guys, i look forward to it mrlol |
| |
|
|
| rodda |
Posted on 23-10-2007 13:06
|
Small Tour Specialist
Posts: 2276
Joined: 17-08-2007
PCM$: 200.00
|
nice to help another aussie 
|
| |
|
|
| mrlol |
Posted on 23-10-2007 13:34
|
Grand Tour Specialist
Posts: 5005
Joined: 24-06-2007
PCM$: 200.00
|
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… |
| |
|
|
| cladestino |
Posted on 23-10-2007 14:10
|
Amateur
Posts: 8
Joined: 26-02-2007
PCM$: 200.00
|
Hi:
Just an information:
In the STA_objectif_sponsor_info: in the gene_ilist_fkIDobjectif there`s 11 numbers.
These numbers are:
first 5 are the goals
last 6 are the importance of the races/objectifs (the stars)
For the stars:
Label3_xxxxx = 3 stars (big goals importance)
Label2_xxxxx = 2 stars (medium goals importance)
Label1_xxxxx = 1 star (low goals importance)
xxxx = name of the race
To see the goals and the labels/stars go to the STA_objectif_sponsor
Sorry for my bad english... |
| |
|
|
| CrueTrue |
Posted on 23-10-2007 16:31
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
Your English is fine, Cladestino. Welcome to the community -- another Portuguese member  |
| |
|
|
| Ad Bot |
Posted on 27-12-2024 03:39
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| dawso |
Posted on 24-10-2007 09:12
|
Junior Rider
Posts: 35
Joined: 07-04-2007
PCM$: 200.00
|
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! |
| |
|
