Register for your free account! | Forgot your password?

You last visited: Today at 15:15

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Academy System

Discussion on Academy System within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #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++
loader8 is offline  
Old 07/28/2020, 20:51   #2


 
VORTEX*'s Avatar
 
elite*gold: 100
Join Date: Apr 2015
Posts: 953
Received Thanks: 1,171
SQL Require ..
VORTEX* is offline  
Old 07/28/2020, 21:10   #3
 
elite*gold: 0
Join Date: Jul 2009
Posts: 285
Received Thanks: 47
Quote:
Originally Posted by Zerox* View Post
SQL Require ..
i get some information and im working in the produces thx!
loader8 is offline  
Old 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
Laag#82 is offline  
Thanks
1 User
Old 07/28/2020, 22:18   #5
 
elite*gold: 0
Join Date: Jul 2009
Posts: 285
Received Thanks: 47
Quote:
Originally Posted by khaleed2010 View Post
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
loader8 is offline  
Old 07/28/2020, 22:25   #6
 
elite*gold: 36
Join Date: Mar 2010
Posts: 558
Received Thanks: 224
Quote:
Originally Posted by loader8 View Post
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


Laag#82 is offline  
Thanks
1 User
Old 08/01/2020, 18:28   #7
 
pherona's Avatar
 
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
pherona is offline  
Old 08/01/2020, 23:02   #8
 
elite*gold: 36
Join Date: Mar 2010
Posts: 558
Received Thanks: 224
Quote:
Originally Posted by pherona View Post
@ 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
Laag#82 is offline  
Old 08/01/2020, 23:45   #9
 
elite*gold: 0
Join Date: Jul 2009
Posts: 285
Received Thanks: 47
Quote:
Originally Posted by khaleed2010 View Post
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 ?
loader8 is offline  
Old 08/02/2020, 16:57   #10
 
elite*gold: 36
Join Date: Mar 2010
Posts: 558
Received Thanks: 224
Lightbulb

Quote:
Originally Posted by loader8 View Post
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
Laag#82 is offline  
Thanks
1 User
Old 08/05/2020, 05:15   #11
 
elite*gold: 0
Join Date: Jul 2009
Posts: 285
Received Thanks: 47
Quote:
Originally Posted by khaleed2010 View Post
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.?
loader8 is offline  
Reply


Similar Threads Similar Threads
Class Reborn Cap 110 - Dg 11- Pvp System- Uniques System -Job System- Coin System
04/09/2018 - SRO PServer Advertising - 17 Replies
http://i.epvpimg.com/HXIucab.jpg http://i.epvpimg.com/Ht37fab.png https://www.youtube.com/watch?v=1vJSSpEqTZw http://i.epvpimg.com/Ht37fab.png Site ClassReborn Online
Class Reborn Cap 110 - Dg 11- Pvp System- Uniques System -Job System- Coin System
02/18/2018 - SRO PServer Advertising - 2 Replies
http://i.epvpimg.com/HXIucab.jpg http://i.epvpimg.com/Ht37fab.png Site Download



All times are GMT +1. The time now is 15:15.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.