修复龙珠不能创建代理问题
删除THAgentDB-可编程性-存储过程-user_createUser
执行sql语句
USE [THAgentDB]
GO
/****** Object: StoredProcedure [dbo].[user_createUser] Script Date: 2018/7/29 19:48:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[user_createUser]
(
@UserName varchar(50),
@PassWord varchar(50),
@AgentNo varchar(8),
@UserType int,
@IsurePassword varchar(50),
@IsureScore bigint
)
as
begin
declare @errors int = 0
begin tran
declare @uid int
begin try
--新增代理用户
insert into Users(UserName,PassWord,status,createtime,AgentNo,UserType)
values(
@UserName
,@PassWord
,1
,GETDATE()
,@AgentNo
,@UserType
)
select @uid=ISNULL(SCOPE_IDENTITY(),0)
update agentno
set status=0
where agentno=@AgentNo
end try
begin catch
set @errors=@errors+1
end catch
if @uid>0
begin
-- GSP_GP_RegisterAccounts
--@strAccounts NVARCHAR(31), -- 用户帐号
--@strNickName NVARCHAR(31), -- 用户昵称
--@strSpreader NVARCHAR(31), -- 推荐帐号
--@strLogonPass NCHAR(32), -- 登录密码
--@wFaceID SMALLINT, -- 头像标识
--@cbGender TINYINT, -- 用户性别
--@strPassPortID NVARCHAR(18), -- 身份证号
--@strCompellation NVARCHAR(16), -- 真实名字
--@strClientIP NVARCHAR(15), -- 连接地址
--@strMachineID NCHAR(32), -- 机器标识
--@strErrorDescribe NVARCHAR(127) OUTPUT -- 输出信息
begin try
declare @error nvarchar(127)
declare @id int
declare @gameUid int
declare @uname NVARCHAR(31)='AGENTUSER'+CONVERT(varchar(8) , getdate(), 112 )+CAST(CEILING(rand()*1000000)as VARCHAR(8) )
--新增游戏用户
insert into gameUser
exec THAccountsDB.dbo.GSP_GP_RegisterAccountsV2 @uname
,@uname
,''
,@Password
,1
,1
,''
,'代理用户'
,'127.0.0.1'
,''
,@isureScore
,N''
select @id=ISNULL(SCOPE_IDENTITY(),0)
if(@id>0)
begin
select @gameUid=UserId from gameUser where id=@id
--建立用户关系
INSERT INTO UserRelation(AgentUId,GameUId)
values(@uid,@gameUid)
--更新游戏账户的交易密码
UPDATE THAccountsDB.[dbo].AccountsInfo
set InsurePass=@IsurePassword
where UserId=@gameUid
print 2
--初始化用户银行账户
--if not exists (select 1 from [THTreasureDB].[dbo].[GameScoreInfo] where userid=@gameUid)
--begin
print @gameUid
--INSERT INTO [THTreasureDB].[dbo].[GameScoreInfo]([UserID],InsureScore)
--values(@gameUid,@IsureScore)
--INSERT INTO [THTreasureDB].[dbo].[GameScoreInfo]([UserID]
-- ,[Score]
-- ,[Revenue]
-- ,[InsureScore]
-- ,[WinCount]
-- ,[LostCount]
-- ,[DrawCount]
-- ,[FleeCount]
-- ,[UserRight]
-- ,[MasterRight]
-- ,[MasterOrder]
-- ,[AllLogonTimes]
-- ,[PlayTimeCount]
-- ,[OnLineTimeCount]
-- ,[LastLogonIP]
-- ,[LastLogonDate]
-- ,[LastLogonMachine]
-- ,[RegisterIP]
-- ,[RegisterDate]
-- ,[RegisterMachine])
--VALUES(@gameUid,0,0,@IsureScore,0,0,0,0,0,0,0,0,0,0,'0.0.0.0',GETDATE(),'','0.0.0.0',GETDATE(),'')
----end
--升级为VIP会员
EXEC THRecordDB.dbo.WSP_PM_GrantMemberV2 1,'127.0.0.1',@gameUid,5,'',2000
end
end try
begin catch
print ERROR_MESSAGE()
set @errors=@errors+1
end catch
end
if @errors>0
begin
rollback tran
select 0
end
else
begin
commit tran
select 1
end
end
GO