Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE FUNCTION GenerateGUID( pid VARCHAR(50) ) RETURNS VARCHAR(32)
- BEGIN
- DECLARE temp VARCHAR(32);
- SET temp = CONCAT(temp, CHAR(pid & 0xFF));
- SET pid = pid >> 8;
- SET temp = CONCAT(temp, CHAR(pid & 0xFF));
- SET pid = pid >> 8;
- SET temp = CONCAT(temp, CHAR(pid & 0xFF));
- SET pid = pid >> 8;
- SET temp = CONCAT(temp, CHAR(pid & 0xFF));
- SET pid = pid >> 8;
- SET temp = CONCAT(temp, CHAR(pid & 0xFF));
- SET pid = pid >> 8;
- SET temp = CONCAT(temp, CHAR(pid & 0xFF));
- SET pid = pid >> 8;
- SET temp = CONCAT(temp, CHAR(pid & 0xFF));
- SET pid = pid >> 8;
- SET temp = CONCAT(temp, CHAR(pid & 0xFF));
- SET pid = pid >> 8;
- SET temp = MD5(CONCAT('BE',temp));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement