hpgalvao 9 Posted November 6, 2022 Share Posted November 6, 2022 Hi guys! use a mysql editor (HeidSQL or NavCat) and select your ACCOUNT.ACCOUNT table to crate a trigger script. Run this query: CREATE TRIGGER `account_before_update` BEFORE UPDATE ON `account` FOR EACH ROW BEGIN /* TRIGGER WRITED BY [ADM]Arkatuz (Meleb.Net) */ if (LEFT(NEW.password,1)<>'*') then SET NEW.password = PASSWORD(NEW.password); END if; END Now, your can update PASSWORD column directly of the Mysql Editor. Eg.: your put 'mypasswd123' and the trigger crated go crypt to '*DD33176027C486CECB9B6F770756A1C115A1F659'. This is good to help administer your server without external applications to generate passwords. good lock! ^^ 1 2 1 Link to comment Share on other sites More sharing options...
Management AZICKO 7351 Posted November 6, 2022 Management Share Posted November 6, 2022 Nice, that's useful! No need to encrypt the password yourself. Scamming ? Reselling ? metin2.download | metin2.dev | fr.metin2.dev | metin2dev.org | metin2.top | top-metin2.org Link to comment Share on other sites More sharing options...
Nitro Booster Luigina 18 Posted November 6, 2022 Nitro Booster Share Posted November 6, 2022 You can use to know encrypted password; open console from navicat or etc. select password("password"); 1 1 Link to comment Share on other sites More sharing options...
JamieWonder 0 Posted November 8, 2022 Share Posted November 8, 2022 Using this "encrypt" (hash) is extremely negligent, use sha256 or at least add some salt. It's painful to read stuff like this in 2022. Link to comment Share on other sites More sharing options...
Recommended Posts