USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_Scroll_Name] Script Date: 2/23/2020 1:43:29 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[_Scroll_Name]
@
d int
as
begin
Declare @
varchar(20), @
ttle int
set @
ttle = (select IsBattleField from SRO_VT_SHARD.dbo._RefRegion where wRegionID =
(Select LatestRegion from SRO_VT_SHARD.dbo._Char where CharID = @
d ))
-- Check if char ouside town dont tp him for non job cheating and other stuff ... !
if( @
ttle ='1')
begin
Insert Into iLegendBot..iLegend_Tool (Service,Type,Target,Message,Date) values
(1,'Private' @
,'sorry but you are not in town ',Getdate())
END
-- End of anti-cheating
else
begin
print 'ITEM_MALL_STATUS'
end
end