help with the protection of databases

05/07/2015 16:27 luxor155#1

Description of my problem ...
On my server, create a character with a status of 16, while in the table accounts status on your account is not displayed 0_o
I should ps_login from nubnes.
And there were third party requests in the procedures, this is one of them

UPDATE Users_Master SET UserIP =UserIP WHERE UserUID =UserUID
IF HashBytes ('SHA1',InPassword) = 0xECC8A0F1A30F5F7CEECE3B200C0D205B429131B0
SET @ Status = 16

help me please

05/08/2015 00:20 Big_#2

you dont only set ther status to 16 u need need adminlvl of 255 and A and to say True

05/09/2015 11:20 luxor155#3

No, I want to know how to protect the database against hacking

05/22/2015 12:51 Jinx Me#4

Keeping your database secure is easy. Close the ports for SQL in Windows firewall, unless you have a reason for them to be open. Next, change your SQL username and password. You will need to change these in your config files as well, and the passwords will have to be hashed. Changing passwords frequently is good practice as well. You can also have the remote desktop port limited to only your IP so your the only one that can connect.