bangus;3945869 said:
Not sure Creation Master will work for that. You will probably have to use Database Master and add the commentary ID # to each player. I've done this many times and know it works. There are two commentary tables in the DB, sorry I can't help further but my PC crashed and I lost my files. Now I have no Database Master tool and rinaldo's site is dead. If you have a working copy of Database Master, could you upload the file here? I can then install it and help you further.
I got my copy from
this Thread, which has
this link. I can also upload it if the link for some reason doesn't work.
Anyway i've seen the tables,
first is "commentarynames" with some columns that i don't really understand ("commentarypreview","commentarystarting" --> Are their several audios for some players or what is it supposed to mean?) and
second is "playernames", where player names are matched to an commentaryid.
It seems like there is audio for first and last names in the playernames table, now the problem is just how to match an player to an audio. My player is named "Keller" and his lastnameid is 12031. In the playernames table the nameid 12031 is linked to the name "Keller" and the commentaryid 900910.
In the commentarynames table the commentaryid 900910 is also linked to the name Keller, in the column commentarystring and then there is also an column "commentarypreview" witht the value 1 for every entry except one guy, and an column "commentarystarting" with different values for the players, for Keller it's 11. I don't really understand this either. Commentarypreview seems to indicate whether it's possible to hear the preview ingame, which seems to be true for nearly everyone (1 = true), but it ISN'T possible to hear an preview for "Keller" ingame or to even just select it as commentaryname. Also i have no idea what "commentarystarting" means, maybe when its actually wortwhile to say the name in relation to the probable time until something important happens ingame (16 --> takes a lot of time to say the name, 2 --> takes very short), but that doesnÄt make much sense. There seems to be little correlation between name length and commentarystarting value and too many players have one as value.
From just looking at the tables it seems that the player "Keller" is already linked to an commentaryname, but i didn't hear his name ingame in a few short test sessions and ingame it says that no commentaryname is assigned to him (although ingame there is also no commentaryname "Keller").
The bigger mystery is Zidane. Even though there is no commentarystring in commentarynames and no commentaryid in playernames for Zidane, Zidan, Zinédine, Zinedine etc. i could clearly hear the commentators say several time "Zinédine Zidane xy" or "Zinédine Zidan to take the corner" etc., that seems to be similar to the experience of
this guy. But they seem to say the name rather seldom and only ever say Zinédine Zidane, never just Zidane or sth. similar, and there probably is just one recording for the name.
Thanks for the hint in the previous post and i would appreciate any futher help, but i don't know how to link Zidane to an commentary ID that is apparently somewhere as the commentators use it, but now in the database or selectable ingame. Very strange.
Regards