SQLize | PHPize | SQLtest

DELIMITER $ CREATE FUNCTION textDecrypt (input TEXT) RETURNS TEXT DETERMINISTIC BEGIN DECLARE crypt_str BLOB; DECLARE key_str BINARY(32); DECLARE init_vector BINARY(16); SET crypt_str = FROM_BASE64(input); SET key_str = UNHEX(SHA2('marks', 256)); SET init_vector = REPEAT('\0', 16); SET block_encryption_mode = 'aes-256-cbc'; RETURN AES_DECRYPT(crypt_str, key_str, init_vector); END $ DELIMITER ; SELECT textDecrypt('AatPsEv2OsG8Lz+osgEF1DEOy4IWNzp2VBOt6hg2i1TIUJbLMBTnG/VXcbGo+tlXitKKZZGTPqpVfPjJxKkKeeQ+UPMMwAEcfptV++fOReM/o/6FZozDw8ybPgHLiC5Bpv4UQOxCdgx1J3TL7I+mIm4KEUdW5g5aT1Vy5b89EznbcyeXdD2F3fwqGusUVVOwGXtEVb/h4RX5knHuOWZkduifCvgagvYRGztWiFlOWAMdG6VJjFmvRAhgRpBa6NYTYz1jPUyo20qMeZvdvMWPc+tzjIjaXF0UKgVG3zMB8QU4Og0jmTb2qjvYhE//8X5hPZumnZyw1Gi16ugWeVyH3BRiisoLPEEAiczRtFnxAD5SHnMZeOvoDSzUywainvtek9uuzU2QN8zFc1EVbEGwt/U9UCqrwhc5S4hWSUimjbdRVmN1JSmJzehZ0OOBj3WeU/wPhnVrZ+jG/TRjyIdHjUPqF9YDIfrvJlpBpCPqvtlTq1oQm3gR2CA3x+COR++Tg56uLtKggLE2Us7Gthoe6jcxJfCiB0vu/mNDjjMDIY5Sfa6W+J+y3aQyghF3fOIuInpn9nRJh2dpMqSUwuNbKdpvAY7lI/sxfgnX8SAYWsYceE6Qnat5ld532AVkJamHbGTNmWSt2CLnA8w/ejpck+sACpSbyzWe1bZ0qDxJowIGGgZC9GtwgbRY/S41WsKL');