Биллинговая система Nodeny

`passwd` tinytext NOT NULL,

ALTER TABLE `users` MODIFY COLUMN passwd VARCHAR(64) NOT NULL;

UPDATE users SET passwd=AES_DECRYPT(passwd, 'hardpass');

UPDATE users SET passwd=AES_ENCRYPT(passwd, 'hardpass');

SELECT AES_DECRYPT(passwd, 'hardpass') FROM users;

UPDATE users SET passwd=IFNULL(AES_DECRYPT(passwd, 'hardpass'), '');

Warning: #1366 Incorrect string value: '\x9Cj|\xA7\xAE\x0B...' for column 'passwd' at row 1
Warning: #1366 Incorrect string value: '\xA8\xED\x9C\xC9\xB7\x0F...' for column 'passwd' at row 2
Warning: #1366 Incorrect string value: '\xAFX\xFA 8\x85...' for column 'passwd' at row 3
Warning: #1366 Incorrect string value: '\xC0-\xA7\x89%\xDA...' for column 'passwd' at row 4
Warning: #1366 Incorrect string value: '\xFEw\x89\xE0\x83...' for column 'passwd' at row 5
Warning: #1366 Incorrect string value: '\xFA\xD5d\xAB\xB7\xE1...' for column 'passwd' at row 6
Warning: #1366 Incorrect string value: '\xBDG\x1D\x09n\xF9...' for column 'passwd' at row 7
Warning: #1366 Incorrect string value: '\xFF\x1A\xEC`\x94\x9D...' for column 'passwd' at row 8
Warning: #1366 Incorrect string value: '\xFB\xF5\xEF\xB6T\x1B...' for column 'passwd' at row 9

SELECT id, name FROM users WHERE AES_DECRYPT(passwd, 'hardpass') IS NULL;

DROP FUNCTION IF EXISTS strSplit;
CREATE FUNCTION strSplit(x MEDIUMTEXT, delim MEDIUMTEXT, pos int) RETURNS MEDIUMTEXT
RETURN 
    TRIM(BOTH '\r' FROM TRIM(
    REPLACE(SUBSTRING(SUBSTRING_INDEX(x, delim, pos), LENGTH(SUBSTRING_INDEX(x, delim, pos - 1)) + 1), delim, '')
));

ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

DELIMITER $$

$$
DELIMITER ;

root@localhost [db]> DROP FUNCTION IF EXISTS strSplit;
Query OK, 0 rows affected (0.02 sec)

root@localhost [db]> DELIMITER $$
root@localhost [db]> CREATE FUNCTION strSplit(x MEDIUMTEXT, delim MEDIUMTEXT, pos int) RETURNS MEDIUMTEXT
    -> RETURN
    ->     TRIM(BOTH '\r' FROM TRIM(
    ->     REPLACE(SUBSTRING(SUBSTRING_INDEX(x, delim, pos), LENGTH(SUBSTRING_INDEX(x, delim, pos - 1)) + 1), delim, '')
    -> ));
    ->
    -> $$
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
root@localhost [db]> DELIMITER ;

DROP FUNCTION IF EXISTS strSplit;
CREATE FUNCTION strSplit(x MEDIUMTEXT, delim MEDIUMTEXT, pos int) RETURNS MEDIUMTEXT
DETERMINISTIC
RETURN 
    TRIM(BOTH '\r' FROM TRIM(
    REPLACE(SUBSTRING(SUBSTRING_INDEX(x, delim, pos), LENGTH(SUBSTRING_INDEX(x, delim, pos - 1)) + 1), delim, '')
));