Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DEFINER=`root`@`ns3015621.ip-151-80-109.eu` FUNCTION `ReferalEngine`(guid INTEGER, dp INTEGER) RETURNS int(11)
- BEGIN
- DECLARE refID INTEGER;
- DECLARE login VARCHAR(64);
- SELECT Login, Ref INTO login, refID FROM accounts WHERE ID = guid;
- IF(refID <> 0) THEN
- INSERT INTO Sync VALUES (0, 22, CONCAT(refID,';', ROUND(dp/10)), 1, 10, -1, -1);
- INSERT INTO Sync VALUES (0, 17, CONCAT(refID,';-65281;* Приглашенный Вами игрок (', IFNULL(login, 'Richard_Galliano'), ') купил ', dp, ' DP. Вы получаете подарок: ', ROUND(dp/10), ' DP.'), 1, 10, -1, -1);
- END IF;
- RETURN 1;
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement