PDA

View Full Version : Question for Ben re: your HTML frontend


aston217
08-14-2013, 06:00 PM
Hey Ben (or anyone else who might know),

I've seen instructions before for removing duplicate names and things of this nature from draft classes, and I presume this is for the DB, as the game itself wouldn't have trouble with two players named the same thing.

As for what part of it, I always assumed it was for associating ratings with players. But it seems like there must be another reason too, because this doesn't seem necessary.

To combine extractor & the player_active/player_historical, you can match name, birthdate, and college, which should result in unique matches. If you're importing change tracker data, all of those fields exist in the *.db files that changetracker generates (although not in the CSVs).

Anything I am missing?

Ben E Lou
08-14-2013, 06:19 PM
The "card" (http://www.younglifenorthdekalb.com/ccfl/forum/showthread.php?t=5294) and "{leaguename}" tags that my leagues use will mess up, since the only input required is the name of the player. It completely defeats the purpose of league members have to look up a bunch of data to use the tags.

aston217
08-14-2013, 06:29 PM
Ohhh, it's only for those forum features. In that case, using ID instead of name would avoid the issue, right -- but you're going with name since it's much easier on the user end. I (think) I see.

aston217
08-14-2013, 06:32 PM
By the way, Nemesis needs you to fix the GEFL2 forums :P heh.

Dutch
08-14-2013, 06:44 PM
I join the player's extractor dumps on the db using the player's static attributes that never change. So a name can be the same. However, I don't have forum cards built so I'll have to cross that hurdle whenever I get that far.

FROM fof_playerdevelopment pd INNER JOIN fof_playeractive pa ON (pa.Loyalty, pa.PlaysToWin, pa.Personality, pa.Leadership, pa.Intelligence, pa.Volatility) = (pd.Loyalty, pd.Winner, pd.Personality, pd.Leader, pd.Intelligence, pd.Volatility)

Ben E Lou
08-14-2013, 06:48 PM
By the way, Nemesis needs you to fix the GEFL2 forums :P heh.afk..sent him a msg...yoda has access to fix...and wtf are you guys doing to cause this repeatedly?