[Query] Enable - Disable Safezone

[geomangy011]

Hello Rz Members

I Just Come To Make Disable And Enable The Safezone Easier For the newibes

This Is A Simple Query Coded By Me

Use [SRO_VT_SHARD]
Go

Declare @Charname Varchar(max), @Issafezone varchar(max), @Legendknight1 int, @regionid int, @regionname varchar(max), @zonedes varchar(max), @OwNeR1 varchar(max), @OwNeR2 varchar(max), @OwNeR3 varchar(max), @OwNeR4 varchar(max), @OwNeR5 varchar(max)

set @Charname = 'LegendKnight'    ----- Write here charname which at the region
set @Issafezone = 'no'   ----- Write 'Yes' If You Want It A Safezone 'No' If You Want

If @Issafezone = 'Yes'
begin
set @Legendknight1 = 0
set @zonedes ='Safe Zone'
end
If @Issafezone = 'No'
set @zonedes ='Battle Field'
begin
set @Legendknight1 = 1
end
If @Issafezone not in ('Yes','No')
begin
Print 'Error Set No Or Yes At @Issafezone'
end
If Not Exists (select * From _char where charname16 = @Charname)
begin
Print 'Error There is no charname with this name'
end
If Exists (select * From _char where charname16 = @Charname) and @Issafezone in ('Yes','No')
begin
set @regionid = ( select LatestRegion from _char where charname16 = @Charname ) set @regionname = ( select ContinentName from _RefRegion where wRegionID @regionid) set @OwNeR1 = 'Le'set @OwNeR2 = 'ge' set @OwNeR4 = 'Knig' set @OwNeR3 = 'nd' set @OwNeR5 = 'ht'
update _RefRegion set IsBattleField @Legendknight1 where wRegionID @regionid
print 'Region [' @regionname+ '] Is Now ' @zonedes+' .' print 'Just Restart Your Sr_Gameserver ... Credit Goes To ' @OwNeR1 @OwNeR2 @OwNeR3 @OwNeR4 @OwNeR5+' .'
end

Just Edit The Charname And
Type Yes To Make The Region Which the Char In =Safezone
Or No To Make It BattleZone

Thx.

[MentaL]

[ongamanext]

Mens. 102, Level 15, State 1, Line 27
Incorrect syntax near 'regionid'.
Mens. 102, Level 15, State 1, Line 28
Incorrect syntax near '@ Legendknight1'.

[DrugDealers]

why to
set @Legendknight1 = 0

you can use case system example
set @Issafezone = (select 'numberic' = case when @Issafezone = 'yes' then '0' when @Issafezone = ' no' then '1' end)

and btw it's released before you just edit the query
and you have patched edit with a noob edit (facepalm)

[abdo1020]

disable

Update _RefRegionSet IsBattleField = 1Where ContinentName = CHINA 

ENABLE SAFEZONE

Update _RefRegionSet IsBattleField = 0Where ContinentName = Ur Region Name 

[Blackdiana]

hi, you can make safezone to coordinate, not region?
i want make some coordinate (x,y,z) safezone, not all region.. Can you make this?

[RenePunik]

USE [SRO_VT_SHARD]
Update _RefRegion
Set IsBattleField = 0 >>> 0 For Active Safe Zone | 1 For Disable Safe Zone
Where ContinentName LIKE 'ARENA_OCCUPY'

This query works fine.

[Blackdiana]

yes, i know this, then i need only some cooridantes make safezone, not all region... can you help me this?