Hi Guys! any one have a system Academy Via Job Kills - BA or CTF, i read the we can change Honor Point for Gift Silk and that make it more easy. any help or hints?
i can make produces, or change in modules Via OllyDBG
the only that i cant make is a DLL via C++
AcademyCreate enable
Academy Join disable
Academy Invite disable
Academy Accept disable
2nd
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
Quote:
CREATE PROCEDURE [dbo].[_SystemHonor]
@CharID INT,
@Desc varchar(max)
AS
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
you can check from [LatestRegion] before and after ctf & arena.
You can use this query in another system.
good luck
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.?
do you have discord cuz i follow the steps but i didnt work , there is something missing
