CREATE procedure [dbo].[up_save_ip]
	@auth_id uniqueidentifier,
	@real_ip varchar(16),
	@server_ip varchar(16),
	@host_id int,
	@DBCIndex smallint
as 
set nocount on

	update AuthTable set [online]='1',[IP] = @real_ip, [ServerIP] = @server_ip, [ServerType]='G', [HostID]=@host_id, [DBCIndex]=@DBCIndex from AuthTable where AuthID = @auth_id

return @@error