New Admin/Donator Setup

[NuclearWatermelon]

Previously we had a sort of hybrid system where the Blue admins and doantors were done from a database, and the Pink and Gold admins were done manually. However, with the influx of donators who come from our fun and trade servers (who would not get donator on the servers without bugging an admin to do it manually), we decided to fix this.

Benny and I went through and got this all set up, and now all admins are given their rights by the database on the appropriate servers, and donators now automatically get access to all servers, as advertised.

[Repoman]

I think it replaced my admin with donater, because I cant use admin commands now. o.o

Nevermind, it was fixed by Benny.

[Vivi Hill]

No worries, Repo was entered in the database twice, once as donator, once as admin. When I removed his Admin one and added it to the Donator one, everything works perfectly

[NuclearWatermelon]

And now we know that people can be added twice to the database, how odd.

[Vivi Hill]

Yeah, the "identity" field is not a primary key, there's a separate id field for it. I think the reason is you can specify multiple types of id, not just steamid. So if the ID field was a primary key I guess it could be problematic. Or something. Or the guy just didn't think about it.

Anyway the donator interface won't add multiple steamids with multiple donations as it does a REPLACE.

[Argent]

I think this may have turned my [a] into an [A] which doesn't seem right. Thought you ought to know.

[NuclearWatermelon]

I think this may have turned my [a] into an [A] which doesn't seem right. Thought you ought to know.

Which server?

[Argent]

I think this may have turned my [a] into an [A] which doesn't seem right. Thought you ought to know.

Which server?

SB2

[NuclearWatermelon]

Should be fixed.

[dieinafire]

Yeah, the "identity" field is not a primary key, there's a separate id field for it. I think the reason is you can specify multiple types of id, not just steamid. So if the ID field was a primary key I guess it could be problematic. Or something. Or the guy just didn't think about it.

Anyway the donator interface won't add multiple steamids with multiple donations as it does a REPLACE.

Add a unique index.

[Vivi Hill]

There is a unique index.

[NuclearWatermelon]

Make steamid unique is what we need. Either in the SQL, or when we add a user do a check.

[Argent]

I used to have access to the sm_removespray command, and now I do not, is that intentional, or a side-effect of this move?