Hello ,
The Procedure below will restrict the using of any scroll to be used only inside towns , otherwise the scroll will give nothing ,also it's enhanced with Notice system to let players knows that such scroll should not be used Outside towns .
Here you go
Press Thanks if it Helps :)
The Procedure below will restrict the using of any scroll to be used only inside towns , otherwise the scroll will give nothing ,also it's enhanced with Notice system to let players knows that such scroll should not be used Outside towns .
Here you go
PHP Code:
use SRO_VT_HECKT0R
go
create proc _Scroll_Name
@ Charid int
as
begin
Declare @ charname varchar(20), @ isbattle int
set @ isbattle = (select IsBattleField from SRO_VT_SHARD.dbo._RefRegion where wRegionID =
(Select LatestRegion from SRO_VT_SHARD.dbo._Char where CharID =@ Charid ))
-- Check if char ouside town dont tp him for non job cheating and other stuff ... !
if( @ isbattle ='1')
begin
Insert into Notice (Service,Type,Target,Message,Date) values
(1,'Private',@ CharName,'sorry but you are not in town :) ',Getdate())
END
-- End of anti-cheating
else
begin
print 'Put here the stuff you want from the scroll'
end
end
Press Thanks if it Helps :)
