Hint :
_RefRegion-> set samarkand isbattlefield = 1
this thread will help you.
[Only registered and activated users can see links. Click Here To Register...]
1st query ->
Quote:
|
update _RefRegion set IsBattleField = 1 where ContinentName in ('CA','AM')
|
Add this to _AddLogChar
Quote:
Declare @RegionID int = (select latestregion from sro_vt_shard.._char where charid = @charid)
if @eventid = 20 and @regionid in (select wregionid from sro_vt_shard.._refregion where ContinentName in ('CA','AM'))
begin
EXEC exo_killfetch @CharID,@Desc,@strPos
end
|
Exo_killfetch procedure should be like this
Quote:
CREATE PROCEDURE Exo_KillFetch
-- =============================================
-- Author: <Exo>
-- Create date: <13.5.2014>
-- Description: <KillFetch>
-- =============================================
@CharID INT,
@Desc VARCHAR(512),
@strPos VARCHAR(64)
AS
BEGIN SET NOCOUNT ON;
--//---------------------------------------------------------------
DECLARE
@KillerName VARCHAR(max),
@KillerID INT,
@JobType VARCHAR(max),
@StartPos TINYINT,
@killedName varchar(max)
--//---------------------------------------------------------------
SELECT @StartPos = (SELECT CHARINDEX('(',@desc)) + 1
SELECT @KillerName = (SELECT SUBSTRING(@Desc, @StartPos, CHARINDEX(')', @Desc, @StartPos) - @StartPos))
SELECT @KillerID = (SELECT CharID FROM Fayox_Shard.._Char WHERE CharName16 = @KillerName)
SELECT @KILLEDNAME = (SELECT CHARNAME16 FROM SRO_VT_SHARD.._CHAR WHERE CHARID = @CHARID)
--//---------------------------------------------------------------
SELECT @JobType = CASE
WHEN (@desc LIKE '%My: Trader%')
OR (@desc LIKE '%My: Robber%')
OR (@desc LIKE '%My: Hunter%')
THEN 'Job'
WHEN (@desc LIKE '%Murderer%')
THEN 'Murder'
ELSE 'Free'
END
--//---------------------------------------------------------------
BEGIN TRANSACTION
insert plusnotice (sent,message) values (0,''+@KillerName+' has just killed '+@KilledName+' in Samarkand Extreme PVP')
INSERT Fayox_Log.._KillLogs VALUES (@KillerID,@CharID,@strPos,@JobType)
COMMIT TRANSACTION
END
|