i get some information and im working in the produces thx!Quote:
SQL Require ..
Quote:
declare @WarMap int = (select B.IsBattleField from SRO_VT_SHARD.._Char as A
inner join SRO_VT_SHARD.._RefRegion as B on A.LatestRegion = B.wRegionID where CharID = @CharID)
IF (@EventID = 20 and @WarMap = 0)
begin
exec _SystemHonor @charid, @desc
end
good luckQuote:
CREATE PROCEDURE [dbo].[_SystemHonor]
@CharID INT,
@Desc varchar(max)
AS
DECLARE @KillerName varchar(64),
@KillerID INT,
@KilledName varchar(64),
@StartPos TINYINT
Select TOP 1 @KilledName = Charname16 from SRO_VT_SHARD.._Char WITH (NOLOCK) where CharID = @CharID
SELECT @StartPos = (SELECT CHARINDEX('(',@desc)) + 1
SELECT @KillerName = (SELECT SUBSTRING(@Desc, @StartPos, CHARINDEX(')', @Desc, @StartPos) - @StartPos))
set @KillerID = (select CharID from SRO_VT_SHARD.._Char where CharName16 = @KillerName)
DECLARE @CampID int = (select COUNT(CampID) from SRO_VT_SHARD.._TrainingCampMember where CharID = @KillerID)
DECLARE @GraduateCount int = (select GraduateCount from SRO_VT_SHARD.._TrainingCamp where ID =
(select CampID from SRO_VT_SHARD.._TrainingCampMember where CharID = @CharID))
DECLARE @IpKiller varchar(64) = ('127.0.0.1')--@KillerName you create select from you guard
DECLARE @IpKilled varchar(64) = ('127.0.0.2')--@KilledName you create select from you guard
if (@IpKilled != @IpKiller)
Begin
if(@CampID = 1)
begin
update SRO_VT_SHARD.._TrainingCamp set EvaluationPoint = EvaluationPoint+10,GraduateCount = GraduateCount+1,LatestEvaluationDate = GETDATE()
where ID = (select CampID from SRO_VT_SHARD.._TrainingCampMember where CharID = @CharID)
print 'You have received (1) Honor Points';
end else
if (@CampID = 0)
begin
print 'In order to receive your Honor Points you have to create Academy first.';
end
end
wow thx! do u know how to make the frist part? disable join academy and thatQuote:
first
you need
AcademyCreate enable
Academy Join disable
Academy Invite disable
Academy Accept disable
2nd
good luck
from hereQuote:
Hello,Quote:
question how can i know warMap is = 1 and when is 0 witch parts are 1 and witch are 0 ?Quote:
first
you need
AcademyCreate enable
Academy Join disable
Academy Invite disable
Academy Accept disable
2nd
good luck
Hello,Quote:
other question , how works GraduateCount and EvaluationPoint with Honor Point because i test the Academy With Graduate players i join one player at lv 1 and i lvl up to lv 40 then i graduate and i check table and i got GraduateCount 1, EvaluationPoint 5, and in _TrainingCampMember i got 39 honor points.?Quote:
0 = in town
1 = out town
you can check from [LatestRegion] before and after ctf & arena.
You can use this query in another system.
good luck