37 lines
1.4 KiB
Transact-SQL
37 lines
1.4 KiB
Transact-SQL
CREATE procedure [dbo].[up_get_auth_id]
|
|
@bcust_id nvarchar(50),
|
|
@UUID uniqueidentifier,
|
|
@channelling int,
|
|
@mac_addr char(17),
|
|
@mac_addr02 char(17),
|
|
@mac_addr03 char(17)
|
|
as
|
|
set nocount on
|
|
|
|
declare @login_count bigint
|
|
set @login_count = -1
|
|
|
|
if exists (select AuthID from AuthTable with (nolock) where WindyCode = @bcust_id)
|
|
begin
|
|
|
|
select @login_count = [LCount] from AuthTable with (nolock) where WindyCode = @bcust_id
|
|
select AuthID, online, DBCIndex, InquiryCount, CashMileage, [pc_room_point] from AuthTable with (nolock) where WindyCode = @bcust_id
|
|
--Online Login Count
|
|
update AuthTable set [online] = '1', [LCount] = @login_count+1, ServerType = 'G', ServerIP=0, HostID=0, mac_addr=@mac_addr, mac_addr02=@mac_addr02, mac_addr03=@mac_addr03 from AuthTable where WindyCode = @bcust_id
|
|
return;
|
|
end
|
|
|
|
|
|
declare @LastAuthID bigint;
|
|
select @LastAuthID = [Value] from GlobalVariableTable with (nolock) where VarName = 'LastAuthID'
|
|
update GlobalVariableTable set [Value] = @LastAuthID+1 where VarName = 'LastAuthID'
|
|
|
|
insert into AuthTable
|
|
values( @bcust_id, 0, @UUID, @LastAuthID, '1', GetDate(), GetDate(), GetDate(), 0, 1, 0, 'G', 0, -1, 5, 0, 0, @channelling, 0, 0, @mac_addr, @mac_addr02, @mac_addr03, '' )
|
|
|
|
select AuthID, online, DBCIndex, InquiryCount, CashMileage, [pc_room_point] from AuthTable with (nolock) where WindyCode = @bcust_id
|
|
|
|
|
|
|
|
return @@error
|
|
|