Anybody care to help to remove player duplications?

[Guest]

Anybody out there willing to help to write a big query, or more likely a script, to rid the database of player duplications?

I have tried to look how to do it, but I can't find enough time to work through all the tables and fields. And I do not have the pgsql scripting knowledge to build a script that selects the player id's, put them in a cursor, walks through the cursor, updates the id_player of all tables and then deletes the redundant players from the player table.

Anybody care to help with this?

[Guest]

Is the lack of response because a) nobody else experiences duplicate player names or b) because nobody here has the knowledge to create such a script?

I'd really like to get started on this, the amount of duplications is staggering by now......

[WhiteRider]

Sorry - I don't remember seeing this post when you first made it. That said, I'm not able to help you directly. I'll let the developers know, as I said in the other thread..
You would have to be REALLY careful about doing this in your database.

[Guest]

Indeed I have to be really careful, that's why I was hoping that the development crew could lend a hand :)