Arkadaşlar iyi günler, Forumdan almış olduğum kod satırlarını düzenleyerek kendi guardım ile çalışan unique honor sistemi yapmak istiyorum. Şu anda herşey güzelce çalışıyor ancak Oyuncu academy sistemine kayıtlı değilse farklı mesaj döndürmek istiyorum. Yani @CharID .. TrainingMember de bulunan CharID ile eşleşmiyorsa farklı bir mesaj gönderteceğim. Bu konuda yardımcı olur musunuz.
IF (@ObjectID in (1954,5871,14936,1982,2002 )) -- Tiger Girl, Cerberus, Captain Ivy, Uruchi, Isyutaru, Lord Yarkan, Deamon Shaitan
BEGIN
DECLARE @CampID int = isnull((SELECT CampID FROM SRO_VT_SHARD.._TrainingCampMember WITH(NOLOCK) WHERE CharID=@CharID),0)
UPDATE SRO_VT_SHARD.dbo._TrainingCamp SET EvaluationPoint +=1,GraduateCount +=1 where ID=@CampID
UPDATE SRO_VT_SHARD.dbo._TrainingCampMember set HonorPoint = HonorPoint + 1 where CharID = @CharID
EXEC _Char_SendTextNotification @CharID, 'Congratulations, you have earned 1 honor point.', 1, 0, 1;
end
IF (@ObjectID in (3810,3875,36326,38211,38212,38213,38214)) -- Lord,Demon,Selketh,Neith,Anubis,Isis,ToguiElder
BEGIN
DECLARE @CampID1 int = isnull((SELECT CampID FROM SRO_VT_SHARD.._TrainingCampMember WITH(NOLOCK) WHERE CharID=@CharID),0)
UPDATE SRO_VT_SHARD.dbo._TrainingCamp SET EvaluationPoint +=2,GraduateCount +=2 where ID=@CampID
UPDATE SRO_VT_SHARD.dbo._TrainingCampMember set HonorPoint = HonorPoint + 2 where CharID = @CharID
EXEC _Char_SendTextNotification @CharID, 'Congratulations, you have earned 2 honor point.', 1, 0, 1;
end
IF (@ObjectID in (14997,3877)) -- Beakyung and Roc
BEGIN
DECLARE @CampID2 int = isnull((SELECT CampID FROM SRO_VT_SHARD.._TrainingCampMember WITH(NOLOCK) WHERE CharID=@CharID),0)
UPDATE SRO_VT_SHARD.dbo._TrainingCamp SET EvaluationPoint +=3,GraduateCount +=3 where ID=@CampID
UPDATE SRO_VT_SHARD.dbo._TrainingCampMember set HonorPoint = HonorPoint + 3 where CharID = @CharID
EXEC _Char_SendTextNotification @CharID, 'Congratulations, you have earned 3 honor point.', 1, 0, 1;
end
@CharID TrainingMember..CharID ile eşleşmiyorsa gönderilmesi istenen mesaj 'In order to earn Honor points, you must register to the Academy system from the Bank.'
IF (@ObjectID in (1954,5871,14936,1982,2002 )) -- Tiger Girl, Cerberus, Captain Ivy, Uruchi, Isyutaru, Lord Yarkan, Deamon Shaitan
BEGIN
DECLARE @CampID int = isnull((SELECT CampID FROM SRO_VT_SHARD.._TrainingCampMember WITH(NOLOCK) WHERE CharID=@CharID),0)
UPDATE SRO_VT_SHARD.dbo._TrainingCamp SET EvaluationPoint +=1,GraduateCount +=1 where ID=@CampID
UPDATE SRO_VT_SHARD.dbo._TrainingCampMember set HonorPoint = HonorPoint + 1 where CharID = @CharID
EXEC _Char_SendTextNotification @CharID, 'Congratulations, you have earned 1 honor point.', 1, 0, 1;
end
IF (@ObjectID in (3810,3875,36326,38211,38212,38213,38214)) -- Lord,Demon,Selketh,Neith,Anubis,Isis,ToguiElder
BEGIN
DECLARE @CampID1 int = isnull((SELECT CampID FROM SRO_VT_SHARD.._TrainingCampMember WITH(NOLOCK) WHERE CharID=@CharID),0)
UPDATE SRO_VT_SHARD.dbo._TrainingCamp SET EvaluationPoint +=2,GraduateCount +=2 where ID=@CampID
UPDATE SRO_VT_SHARD.dbo._TrainingCampMember set HonorPoint = HonorPoint + 2 where CharID = @CharID
EXEC _Char_SendTextNotification @CharID, 'Congratulations, you have earned 2 honor point.', 1, 0, 1;
end
IF (@ObjectID in (14997,3877)) -- Beakyung and Roc
BEGIN
DECLARE @CampID2 int = isnull((SELECT CampID FROM SRO_VT_SHARD.._TrainingCampMember WITH(NOLOCK) WHERE CharID=@CharID),0)
UPDATE SRO_VT_SHARD.dbo._TrainingCamp SET EvaluationPoint +=3,GraduateCount +=3 where ID=@CampID
UPDATE SRO_VT_SHARD.dbo._TrainingCampMember set HonorPoint = HonorPoint + 3 where CharID = @CharID
EXEC _Char_SendTextNotification @CharID, 'Congratulations, you have earned 3 honor point.', 1, 0, 1;
end
@CharID TrainingMember..CharID ile eşleşmiyorsa gönderilmesi istenen mesaj 'In order to earn Honor points, you must register to the Academy system from the Bank.'
