|
You last visited: Today at 15:15
Advertisement
Academy System
Discussion on Academy System within the SRO Private Server forum part of the Silkroad Online category.
07/25/2020, 03:51
|
#1
|
elite*gold: 0
Join Date: Jul 2009
Posts: 285
Received Thanks: 47
|
Academy System
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++
|
|
|
07/28/2020, 20:51
|
#2
|
elite*gold: 100
Join Date: Apr 2015
Posts: 953
Received Thanks: 1,171
|
SQL Require ..
|
|
|
07/28/2020, 21:10
|
#3
|
elite*gold: 0
Join Date: Jul 2009
Posts: 285
Received Thanks: 47
|
Quote:
Originally Posted by Zerox*
SQL Require ..
|
i get some information and im working in the produces thx!
|
|
|
07/28/2020, 21:17
|
#4
|
elite*gold: 36
Join Date: Mar 2010
Posts: 558
Received Thanks: 224
|
Hello,
first
you need
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
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
|
good luck
|
|
|
07/28/2020, 22:18
|
#5
|
elite*gold: 0
Join Date: Jul 2009
Posts: 285
Received Thanks: 47
|
Quote:
Originally Posted by khaleed2010
Hello,
first
you need
AcademyCreate enable
Academy Join disable
Academy Invite disable
Academy Accept disable
2nd
good luck
|
wow thx! do u know how to make the frist part? disable join academy and that
|
|
|
07/28/2020, 22:25
|
#6
|
elite*gold: 36
Join Date: Mar 2010
Posts: 558
Received Thanks: 224
|
Quote:
Originally Posted by loader8
wow thx! do u know how to make the frist part? disable join academy and that
|
from here
[SQL]
_TRAINING_CAMP_CREATE
or
[Filter]
Packet 0x7470
|
|
|
08/01/2020, 18:28
|
#7
|
elite*gold: 480
Join Date: May 2020
Posts: 60
Received Thanks: 22
|
@ do you have discord cuz i follow the steps but i didnt work , there is something missing
|
|
|
08/01/2020, 23:02
|
#8
|
elite*gold: 36
Join Date: Mar 2010
Posts: 558
Received Thanks: 224
|
Quote:
Originally Posted by pherona
@ do you have discord cuz i follow the steps but i didnt work , there is something missing
|
Hello,
you can send here screenshot i fix to you error
Discord :Laag#8248
|
|
|
08/01/2020, 23:45
|
#9
|
elite*gold: 0
Join Date: Jul 2009
Posts: 285
Received Thanks: 47
|
Quote:
Originally Posted by khaleed2010
Hello,
first
you need
AcademyCreate enable
Academy Join disable
Academy Invite disable
Academy Accept disable
2nd
good luck
|
question how can i know warMap is = 1 and when is 0 witch parts are 1 and witch are 0 ?
|
|
|
08/02/2020, 16:57
|
#10
|
elite*gold: 36
Join Date: Mar 2010
Posts: 558
Received Thanks: 224
|
Quote:
Originally Posted by loader8
question how can i know warMap is = 1 and when is 0 witch parts are 1 and witch are 0 ?
|
Hello,
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
|
|
|
08/05/2020, 05:15
|
#11
|
elite*gold: 0
Join Date: Jul 2009
Posts: 285
Received Thanks: 47
|
Quote:
Originally Posted by khaleed2010
Hello,
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
|
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.?
|
|
|
All times are GMT +1. The time now is 15:15.
|
|