03.08.2016, 23:45
(
Последний раз редактировалось TheBigFive; 04.08.2016 в 10:41.
)
Hey.
I'm currently making a gamemode just for fun and try to learn pawn. I'm thinking about making a so-called master account system. I have an user control panel where you can register a master account, and you will also register your character through it. In other words; you just login once you connect to the server (with the character account of course).
The thing is that I want so if the master account is admin, all the characters assosciated with that master account will be admin as well. Is that a bad idea? Like, if you have one master account I trust that person - which means all his characters should be admin as well. I know that can be a security risk, however what's the best way of doing that? Do I have to make an inner join or something in MySQL and retrieve info whether the character account is associated with an admin master account?
I need help with finding the best way to deal with it. Like do I have to make a MySQL query every time I want to check if the person is admin or not? Or can I make a variable for that? Anything vulnerable if I do so?
Have a last question too. When a player disconnects people usually store all the player info of the person leaving. If I make everything update once changes are made, I don't have to do that I assume. But will this affect the server in a bad way? Imagine having like 200 players, and every changes are being updated to MySQL. E.g if 50 players change their skin at the same time - there will be 50 queries to the database at the same time, won't that make it load slow or? I have no clue, just thinking about things that could happen and whether it's a good idea or not. Because then there isn't any chance of rollbacks?
Thanks in advance!
I'm currently making a gamemode just for fun and try to learn pawn. I'm thinking about making a so-called master account system. I have an user control panel where you can register a master account, and you will also register your character through it. In other words; you just login once you connect to the server (with the character account of course).
The thing is that I want so if the master account is admin, all the characters assosciated with that master account will be admin as well. Is that a bad idea? Like, if you have one master account I trust that person - which means all his characters should be admin as well. I know that can be a security risk, however what's the best way of doing that? Do I have to make an inner join or something in MySQL and retrieve info whether the character account is associated with an admin master account?
I need help with finding the best way to deal with it. Like do I have to make a MySQL query every time I want to check if the person is admin or not? Or can I make a variable for that? Anything vulnerable if I do so?
Have a last question too. When a player disconnects people usually store all the player info of the person leaving. If I make everything update once changes are made, I don't have to do that I assume. But will this affect the server in a bad way? Imagine having like 200 players, and every changes are being updated to MySQL. E.g if 50 players change their skin at the same time - there will be 50 queries to the database at the same time, won't that make it load slow or? I have no clue, just thinking about things that could happen and whether it's a good idea or not. Because then there isn't any chance of rollbacks?
Thanks in advance!