[Query] Enable - Disable Safezone

[geomangy]

Hello Epvp 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.

[KingDollar]

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)

If @issafezone = 'No'
set @zonedes ='Battle Field'
begin
set @legendknight1 = 1
end
btw you have to get @zonedes under the begin
begin
set @legendknight1 = 1
set @zonedes ='Battle Field'
end