Development Project Of Silkroad Server Files !

Hello ,
Those are my last days in SRO Community Here , after 1 week i will leave to start work in new project out of SRO which will take all My time ,
So i decided before i Leave To make full explain project and guide how to edit all parts in databases/applications~Client\Modules/pk2 (take a look at the project script to got more understand)
We will start to learn out that with each other, tell we can made new game So the life will be more better ^_ ^
And after we will finish that project I will release from time to time some of leaked server files !

Oky let's discussion about what script we are going to work on

1 - Explain of all stored procedures .
2 - Explain of all databases/tables and it's data content and how it works .
3 - Client side Pk2/applications/protection .
4 - dev. of agent .
5 - Explain of modules and how they work in real .
6 - After we finish all of that we will start to make full edit to make new game (System) , I mean for example ..

This project will depends on VSRO/BR/SWSRO/CSRO< Server Files

How this thread will going on?
At first we need only people who will join us, so we could help each other , as I can't finish all those parts in only 1 week so i will do as fast as i can but maybe i forgot or lose a thing so just mind me , also if you got experiences or skills with something we are going to explain it in our Development project So we will be thanks if you share with us,
Ideas is sure accepted .

I will start my First part of this project tomorrow as it's too late here ,
This Thread Will be updated every new part is done also we will move step by step .

Hope at last we done this Project as it will take a big effect and also change in all MMO games not with SRO community only and also it will help u at last .

-------------------------------------
We are going today to Start Our First Steps about Stored Procedures , When we were making emulators we were develop it to read all the system from it's packets , I mean for example like add remove item and so
But with server files they extract those packets to add them into the stored procedures, as 85% of GameServer System is add in Stored Procedures So we could edit on them easy and they are the main discussion as i see for this Project .

Let's Start :

So let's Start out first step with stored procedures With BR Files :
From Time to time i will add group of stored procedures, Also we will begain with Shard db then Shard log then Account db
Let's go .


Named : __GoldTracePerMin
-----------------------------------------------

Named : _ActiveteCharCOS
-----------------------------------------
Named : _ADD_ITEM_EXTERN
----------------------------------------

Named : _ADD_ITEM_EXTERN_CHEST
---------------------------------------

Named : _ADD_ITEM_EXTERN_CHEST_FAST

----------------------------------------

Named : _ADD_ITEM_EXTERN_CHEST_FAST_FULL_DATA
[spoiler]
[php]/****** Object: StoredProcedure [dbo].[_ADD_ITEM_EXTERN_CHEST_FAST_FULL_DATA] Script Date: 02/08/2012 15:28:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER procedure [dbo].[_ADD_ITEM_EXTERN_CHEST_FAST_FULL_DATA]
@JID int,
@ItemToAdd int,
@data int,
@opt_level int,
@MagParamNum tinyint,
@MagParam1 bigint,
@MagParam2 bigint,
@MagParam3 bigint,
@MagParam4 bigint,
@MagParam5 bigint,
@MagParam6 bigint,
@MagParam7 bigint,
@MagParam8 bigint,
@MagParam9 bigint,
@MagParam10 bigint,
@MagParam11 bigint,
@MagParam12 bigint, @[Only registered and activated users can see links. Click Here To Register...]64 bigint

as

if (not exists(select * from sysobjects where name = '_TEMP_ADDITEMEXTERN_CHEST_LOG'))
begin
create table _TEMP_ADDITEMEXTERN_CHEST_LOG
(
ID int identity(0, 1) not null,
LogString varchar(256),
LogDate datetime default getdate() not null
)
end

declare @LogString varchar(256)
declare @link_to_item int

if (not exists (select UserJID from _User with (nolock) where UserJID = @JID))
begin
set @LogString = 'not existing account ID: ' + cast(@JID as char(15))
insert into _TEMP_ADDITEMEXTERN_CHEST_LOG(LogString) values(@LogString)
raiserror('%s', 1, 16, @LogString)
return -2
end

if (not exists (select * from _chest with (nolock) where UserJID = @JID and (itemid = 0 or itemid is null)))
begin
set @LogString = 'chest Full! JID is ' + cast(@JID as char(15)) + ', item: ' + cast(@ItemToAdd as char(15))
insert into _TEMP_ADDITEMEXTERN_CHEST_LOG(LogString) values(@LogString)
raiserror('%s', 1, 16, @LogString)
return -3
end

declare @empty_slot int
select top 1 @empty_slot = slot from _chest with (nolock) where UserJID = @JID and (itemid = 0 or itemid is null) order by slot

set @link_to_item = 0

select @link_to_item = link from _RefObjCommon where ID = @ItemToAdd

if (@link_to_item = 0 or @link_to_item is null)
begin
set @LogString = 'RefItem Link == NULL JID is ' + cast(@JID as char(15))
insert into _TEMP_ADDITEMEXTERN_CHEST_LOG(LogString) values(@LogString)
raiserror('%s', 1, 16, @LogString)
return -5
end

declare @[Only registered and activated users can see links. Click Here To Register...]1 int
declare @[Only registered and activated users can see links. Click Here To Register...]2 int
declare @[Only registered and activated users can see links. Click Here To Register...]3 int
declare @[Only registered and activated users can see links. Click Here To Register...]4 int

select @[Only registered and activated users can see links. Click Here To Register...]1 = TypeID1, @[Only registered and activated users can see links. Click Here To Register...]2 = TypeID2, @[Only registered and activated users can see links. Click Here To Register...]3 = TypeID3, @[Only registered and activated users can see links. Click Here To Register...]4 = TypeID4 from _RefObjCommon where ID = @ItemToAdd

declare @IS_EQUIP int
declare @IS_PET int

set @IS_EQUIP = 0
set @IS_PET = 0

if @[Only registered and activated users can see links. Click Here To Register...]1 <> 3)
begin
set @LogString = 'not item! JID is ' + cast(@JID as char(15)) + 'item is: ' + cast(@ItemToAdd as char(15))
insert into _TEMP_ADDITEMEXTERN_CHEST_LOG(LogString) values(@LogString)
raiserror('%s', 1, 16, @LogString)
return -6 -- ฟภภื! พฦภฬลภฬ พฦดฯพ฿?
end

if @[Only registered and activated users can see links. Click Here To Register...]1 = 3 and @[Only registered and activated users can see links. Click Here To Register...]2 = 1)
set @IS_EQUIP = 1
else if @[Only registered and activated users can see links. Click Here To Register...]1 = 3 and @[Only registered and activated users can see links. Click Here To Register...]2 = 2 and @[Only registered and activated users can see links. Click Here To Register...]3 = 1 and @[Only registered and activated users can see links. Click Here To Register...]4 = 1 or @[Only registered and activated users can see links. Click Here To Register...]4 = 2))
set @IS_PET = 1

if (@IS_EQUIP = 1)
begin
select @data = Dur_L from _RefObjItem where ID = @link_to_item

if (@opt_level < 0)
set @opt_level = 0
else if (@opt_level > 12)
set @opt_level = 12
end
else
begin

if( @IS_PET = 1 )
set @data = 0
else
begin
declare @max_count int
select @max_count = MaxStack from _RefObjItem where ID = @link_to_item

if (@data <= 0 or @data > @max_count)
set @data = @max_count
end

set @opt_level = 0
end

-------------------------------------------------------------------------------- let's generate item !!!
set xact_abort on

begin transaction

declare @dummy_serial_number bigint
set @dummy_serial_number = 0

declare @NewItemID bigint
set @NewItemID = 0

EXEC @NewItemID = _STRG_ALLOC_ITEM_NoTX @dummy_serial_number OUTPUT

IF (@NewItemID = 0)
BEGIN
rollback transaction
set @LogString = 'failed to allocate new item id! JID is ' + cast(@JID as char(15)) + ', Item Is: ' + cast(@ItemToAdd as char(15))

insert into _TEMP_ADDITEMEXTERN_CHEST_LOG(LogString) values(@LogString)
raiserror('%s', 1, 16, @LogString)
return -7
END

if( @IS_PET = 1 )
UPDATE _Items SET
RefItemID = @ItemToAdd,
OptLevel = @Opt_Level,
Data = @Data,
Variance = 0 ,
MagParamNum = @MagParamNum,
MagParam1 = @MagParam1 ,
MagParam2 = @MagParam2 ,
MagParam3 = @MagParam3 ,
MagParam4 = @MagParam4 ,
MagParam5 = @MagParam5 ,
MagParam6 = @MagParam6 ,
MagParam7 = @MagParam7 ,
MagParam8 = @MagParam8 ,
MagParam9 = @MagParam9 ,
MagParam10 = @MagParam10 ,
MagParam11 = @MagParam11 ,
MagParam12 = @MagParam12 ,
Serial64 = @[Only registered and activated users can see links. Click Here To Register...]64
WHERE ID64 = @NewItemID
else
UPDATE _Items SET
RefItemID = @ItemToAdd,
OptLevel = @Opt_Level,
Data = @Data ,
MagParamNum = @MagParamNum,
MagParam1 = @MagParam1 ,
MagParam2 = @MagParam2 ,
MagParam3 = @MagParam3 ,
MagParam4 = @MagParam4 ,
MagParam5 = @MagParam5 ,
MagParam6 = @MagParam6 ,
MagParam7 = @MagParam7 ,
MagParam8 = @MagParam8 ,
MagParam9 = @MagParam9 ,
MagParam10 = @MagParam10 ,
MagParam11 = @MagParam11 ,
MagParam12 = @MagParam12 ,
Serial64 = @[Only registered and activated users can see links. Click Here To Register...]64
WHERE ID64 = @NewItemID

IF (@@ERROR <> 0)
BEGIN
rollback transaction
set @LogString = 'failed to create new item! JID is ' + cast(@JID as char(15)) + ', Item Is: ' + cast(@ItemToAdd as char(15))

insert into _TEMP_ADDITEMEXTERN_CHEST_LOG(LogString) values(@LogString)
raiserror('%s', 1, 16, @LogString)
return -8
END

UPDATE _chest SET ItemID = @NewItemID WHERE UserJID = @JID AND Slot = @empty_slot
IF (@@ROWCOUNT = 0 OR @@ERROR <> 0)
BEGIN
rollback transaction
set @LogString = 'failed to insert item to chest! JID is ' + cast(@JID as char(15)) + ', Item Is: ' + cast(@ItemToAdd as char(15))

insert into _TEMP_ADDITEMEXTERN_CHEST_LOG(LogString) values(@LogString)
raiserror('%s', 1, 16, @LogString)
return -9
END

--------------------------------------------------------------------------------
if (@NewItemID <= 0)
begin
rollback transaction
set @LogString = 'item generation failed for unknown reason! JID is ' + cast(@JID as char(15)) + ', Item Is: ' + cast(@ItemToAdd as char(15))

insert into _TEMP_ADDITEMEXTERN_CHEST_LOG(LogString) values(@LogString)
raiserror('%s', 1, 16, @LogString)
return -10
end

commit transaction

Great

Great bro! :D, Explanations are more important than a setup guide imo. Because you'll get a wider view of everything and when you know how things works out. You can fix the problems on your own :)

Great

wow This's Good ^^

G.L bro
thats will be Awesome

i think i can help with my exp in this
send me private mesg with your email
going sleep as well

Cool , since no1 want to help this section ! and G.L with ur own project <3

Great

so nice bro and im sorry i didn't finish your order yet cuz i have something wrong with my PC but while i make your order i gonna explain it and how you can make one like it

Hello again ,
Nice to see great guys like u will join us :)

So let's Start out first step with stored procedures With BR Files :
From Time to time i will add group of stored procedures, Also we will begain with Shard db then Shard log then Account db
Let's go .


Named : __GoldTracePerMin

As This seems to you it's the packet which summon the gold in game and also reload when the item used or we can say increase or decrease by amount of gold , Without this Gold in game won't load or reload .

Let's make small Discussion about this
Those are the tables which recall the gold amount and add from them
We Could say this packet is the gold system in game , But maybe not the full system as there's another parts in stored pro. related to gold load and reload .

and so , those are the columns in tables which contain the gold data .

Those explain them selves here
With this part
This Part to collect the data which is needed to load in game to insert in a table
Here is the part which Insert those values in __GoldTrace Table .

Any Part i forgot Hope you mind me plz
Every 1 Stored Pro. will explained same as this one .
Hope It's appear as easy to be understand :)

-----------------------------------------------
Named : _ActiveteCharCOS

As the prevue Packet explain it self, It's the packet which accept the summon of any COS in game by a player char , without this packet u can't summon any COS/Pet In game,
When u summon ur COS it Insert aka update at _CharCos table the State of this COS to 1 as it's summoned and also when u load for first time in game it's read that the Statue and if it's 1 so u will find ur COS is already summoned ,
This part to remove any error could happen in reading values(State) as he made the State Start with -1 and end with 1 , so any another value in Statue column will be changed to 0 to prevent any error or You GameServer may take overflaw when this player who's have This COS which got wrong Statue Load in game .
Also it remove any other errors so if error occur , it set the value to 0 in any column in COS table (_CharCos) .

Named : _ADD_ITEM_EXTERN

This Packet is something Hard ,
Let's Start a few Explain about it ,
This Packet is for summon or load the data of items in game of a char,
It's check all item data like blues and states and opt level (+) and so
also it's check after that, that the item is active and already found in _RefObjCommon table ,
It's also check where's the item in inventory (Slot number) to load the item in the right place ,
Also it contain the error module so any unknown error occurs The GameServer will DC this Char .

That part for data reader and also gives the max inventory size in game as in BR files the max ever inventory size is 45 ,
Here is the module packet of error (If not exists)
So if GameServer don't find the current item at RefObjCommon table at Codename128 (Gameserver is searching by item name for example ITEM_CH_...)
This unkown error at %=item id @Codename , will appear at GameServer
and also will set that item to -1 , so GameServer won't show it in game and might the Char DC in First load (Login) time .
This is a part same related to the error packet
But that's if item found for non existing char , return -2 so the gameserver won't see that item again .
This is part of packet which load the data in game , It's make connection between every data like at this example
and
To load out the char name in game ,
This is an part also from error packet , so if it found item is out of slots or 2 items in same slots or in wrong slot
So it return to -3 item deleted , and if u were in game and need to add item while ur inventory is full it , GameServer gives packet of inventory is full
This if there's an empty slot in ur inventory in game and need to take item by exchange or buy it from small or collect it from mobs drop or any drop and so it search for the top empty slot to add this item in and it's already check if the item already in _RefObjCommon and it's imformation cuz some items u can't pick up it and so ..
This error module is something for the un-avilable errors in game !
what i mean ! , if the item current insert in game but after that by some way the service of this item change to 0 or delete from RefObjCommon so GameServer fives error with Item id and return -4 = no action done ,
if there isn't link for this item or the link column is null (u will understand more when we explain the tables side) gameserver will gives u error and return -5 = no action also
This is the part where this packet read from _RefObjCommon
This is common errors and known and also this packet fix it
This error if there's no item in current data -6 = DC

This is a calculation or not calculation but it's IF the packet find out the values of tid and it's parents as the current the item id will change to 0 disabled .

It's a part of the prevue part , This common error or not really error , but it's read just the data of opt_level >12
as it seems so the last damage of the weapon for example if more than +12 the damage will reset as the same like +12 , You Could test ur self that part in game in BR files make +200 and u will find damage same like +12 .

Part of Packet which load the gold in game .
This part of packet is call data from another stored pro. , when we explain _STRG_ADD_EQUIP_NORMAL Packet , we will understand this part more as i won't explain it with this packet .
Same as _STRG_ADD_EQUIP_NORMAL


Also Error module so if item id = 0 so return 1 = gameserver won't read it
Else
So gameserver will write the unknown error with char name and item code and return -7 = Char DC

Finished

Named : _ADD_ITEM_EXTERN_CHEST

This don't need more explain as it's same as _ADD_ITEM_EXTERN
It's not a same it's a part of it , Just this Part for add items , and also got the common error module .

For me it's a wrong section...
[Only registered and activated users can see links. Click Here To Register...]

Named : _ADD_ITEM_EXTERN_CHEST_FAST

Few Fast explain about this one
it's just same like _ADD_ITEM_EXTERN
But it's work is different
Columns will be read data from
Part of if not exist
_TEMP_ADDITEMEXTERN_CHEST_LOG
Is a Stored Pro. which gives out the item logs like exchange or move and so to Log DB
Same but this if the account JID/Name not exist
Check the item in RefObjCommon and it's link and if link = 0 or NULL or not found so error will show ('%s', 1, 16, @LogString)
and
return -5 = won't read or gives log .

Same as all of those parts for writing Logs
and same error system if item id wrong or or or will gives error .. and return .
This part of checking out the item Opt Level (+)
This part if it found item over the max opt level will be reset to @max_count where the value of it in another stored Procedure
Also the opt level reset to 0 .

Explain !
All of that part for adding item , add log for this item , error module (I think u could read the error module now)
any Question about that just ask :)

If Success of checking item / adding and insert data to Item Log (@Log DB)
return 1 = success