1234567891011121314151617181920212223242526272829303132333435363738394041424344 |
- SET NAMES utf8mb4;
- SET FOREIGN_KEY_CHECKS = 0;
- DROP PROCEDURE IF EXISTS `user_register`;
- delimiter ;;
- CREATE PROCEDURE `user_register`(IN inUid BIGINT, IN inPlayerId VARCHAR(50), IN inPlatformId INT, IN inChannelId INT, IN inSubChannelId INT, IN inGameId INT, IN inPhoneNumber VARCHAR(50), IN inEmailAddress VARCHAR(50), IN inWalletAddress VARCHAR(50), IN inWalletChain VARCHAR(50), IN inShareCode VARCHAR(50), IN inLastGameId INT, IN inLastLoginIp VARCHAR(50), IN inLastLoginTime VARCHAR(50), IN inToken VARCHAR(50))
- BEGIN
- IF NOT EXISTS (SELECT * FROM account_info WHERE uid = inUid) THEN
- INSERT INTO account_info(player_id, platform_id, channel_id, subchannel_id, game_id, phone_number, email_address, wallet_address, wallet_chain, share_code, last_game_id,last_login_ip, last_login_time, token)
- VALUES(inPlayerId, inPlatformId, inChannelId, inSubChannelId, inGameId, inPhoneNumber, inEmailAddress, inWalletAddress, inWalletChain, inShareCode, inLastGameId, inLastLoginIp, inLastLoginTime, inToken);
-
- IF ROW_COUNT() > 0 THEN
- SELECT uid AS resValue FROM account_info WHERE player_id = inPlayerId;
- ELSE
- SELECT -1 AS resValue;
- END IF;
- ELSE
- SELECT -2 AS resValue;
- END IF;
-
- END
- ;;
- delimiter ;
- SET FOREIGN_KEY_CHECKS = 1;
|