Disallow linking multiple Discords to same Steam account.

[39ma]

Is your feature request related to a problem? Please describe.
I have found bug or feature that players can link any Discord to same SteamID multiple times. Just "discord" in DB "players" table is updating each time. Is it possible to disallow it? For example I banned in Discord 1 annoying person, he just created new Discord account and linked his old SteamID to new account.

Describe the solution you'd like
If people try to link already linked steam account there will be error

[cameronshinn]

The instance you provided definitely seems like this is a "feature" that can be abused, so I'd call it a bug. I think we should fix this so what you experienced cannot happen again.

[B3none]

I know just the fix, we could make the steam id and discord id fields unique in the players table

[39ma]

I know just the fix, we could make the steam JD and discord id fields unique in the players table

I am not good at SQL, but it's not creating a new row. It's just updating existing raw. It's not changing "steam" field only "discord". If I'll make it unique will this restrict updating row?

[B3none]

Is it adding a steam ID multiple times?

[39ma]

Is it adding a steam ID multiple times?

No its not adding new rows, its just changing this field

[B3none]

I'll need to make a way to implement an is_banned column and check so that people who have a genuine reason to switch accounts still have the ability to do so.

[39ma]

I'll need to make a way to implement an is_banned column and check so that people who have a genuine reason to switch accounts still have the ability to do so.

Also it would be good to add to Discord bot some command like q!ban @user #time

[B3none]

I'll need to make a way to implement an is_banned column and check so that people who have a genuine reason to switch accounts still have the ability to do so.

Also it would be good to add to Discord bot some command like q!ban @user #time

Post this as a request on the discord bot

[cameronshinn]

I'm working on implementing bans in the bot. I ran into this issue again, I guess it's still not resolved?

[B3none]

I'm working on implementing bans in the bot. I ran into this issue again, I guess it's still not resolved?

We need somewhere more accessible where we can test the data

[cameronshinn]

Why do we need to know if the player is banned to prevent multiple accounts from being linked to their steam ID?