[Release] The Right divided OF Any SRO Server Files databases .!

12/10/2011 21:18 Dr.Abdelfattah#1
- Well Our release Today is very simple and so it will seem to some people it's non important or something else ,,
but for those people whose looks to secure there server and know how to apply the maximum security to his server , those release will help him ..
Well My Work i will apply on drew cert So it will seems it's something wrong but it works 1000% .
anyway what is The right divided of any sro server files database
look for this example
Account DB
Global DB
Silk DB
Shard DB
Shard Log DB
Those are the right divided of the databases , well let me me tell you , that you don't need to change your shard db (sro_vt_shard) or the shard log db , cuz those are same ,
Well our work will be on the database which named Account DB or (SRO_VT_ACCOUNT) which was with vsro files ..
well my example for that will be on a database of a sro server files (not vsro) so you will just backup it and look for the way of divided (the tables) and made the same of what i make (in those dbs) .
Well you can download the databases which got the example of the real divided in attachment or [Only registered and activated users can see links. Click Here To Register...] .
Well That Step Now How to Use that or them
Now if you use drew cert{the normal cert all use} (not another modules) you will just need to post the database (Account_DB) in
srGlobalService.ini
and about (Global_DB) and (Silk_DB)
You need to post those dbs info in server.cfg
How?
Well look over here ,,
PHP Code:
GlobalManager {
// Certification "192.168.0.73", 32000
Certification "192.168.0.73"32000
AccountDBConfig 
"DRIVER={SQL Server};SERVER=CODE-PC\SQLEXPRESS;DSN=Global_DB;UID=sa;PWD=123;DATABAS E=Global_DB"
SilkDBConfig "DRIVER={SQL Server};SERVER=CODE-PC\SQLEXPRESS;DSN=Silk_DB;UID=sa;PWD=123;DATABASE= Silk_DB"

LoginFailureTolerance 3 
IBUVFailureTolerance 3 
//
LoginFailureBlockTimeMin 10 //
IBUVFailureBlockTimeMin 10 // 
AutomatedPunisher "AutomatedPunisher" //
LoginPunishmentGuide "Blocked for 10 minutes due to incorrect password entered 3 times" // 
LoginPunishmentDescription "Blocked for 10 minutes due to incorrect password entered 3 times" // 
IBUVPunishmentGuide "Blocked for 10 minutes due to incorrect code entered 3 times" // 
IBUVPunishmentDescription "Blocked for 10 minutes due to incorrect code entered 3 times" //


you will replace you server.cfg (only the part of global manager with this) ..
and u need to edit

PHP Code:
 AccountDBConfig "DRIVER={SQL Server};SERVER=CODE-PC\SQLEXPRESS;DSN=Global_DB;UID=sa;PWD=123;DATABAS E=Global_DB"
SilkDBConfig "DRIVER={SQL Server};SERVER=CODE-PC\SQLEXPRESS;DSN=Silk_DB;UID=sa;PWD=123;DATABASE= Silk_DB" 
those with your new dbs info (of global and silk dbs) ,,
Well i have got that from long time but i release now cuz it's just a small start to make the new thread (Which is full) for how to protect or make your server security ..
Well For Those people Which Don't know how to change the Account DB name in Shard DB i Will make a small guide in my new thread for how to protect your server , with how to do that ..
(will if you don't change the account db name in shard db name u will get dc or the silk won't read anymore)..

Now Have fun and if u need anymore information just post here :)
12/10/2011 21:25 LastThief#2
Sorry i didn't understand single word of what you've just said ...
12/10/2011 21:30 Getzabelz#3
I donīt understand either anything #1 said xD..
12/10/2011 21:30 mertcoskun#4
thanks my brouther!
12/10/2011 21:33 Dr.Abdelfattah#5
Quote:
Originally Posted by LastThief View Post
Sorry i didn't understand single word of what you've just said ...
Well i fix my write mistakes .
Edit
The thread edited again .
Edit 2
The thread edited again and all mistakes got fixed ^^
12/10/2011 22:13 xavi#6
What the point of this?

Any SRO server? We don't have it, only you have. We have only vSRO and BR for now.
12/10/2011 22:17 Dr.Abdelfattah#7
Quote:
Originally Posted by xavi View Post
What the point of this?

Any SRO server? We don't have it, only you have. We have only vSRO and BR for now.
read that guide again ,,
for any sro server files means cuz of all global manager (old or new or any sro kind) are the same in reading this kind of databases divided ..
The point of this , if u have some skills in dev. or hacking so that those will help you to make more security (special if you use php to read the data from your server database{like register or change password or silk or or or}) ..
12/10/2011 22:35 LastThief#8
even after editing i still understand nothing ...
12/10/2011 22:40 Dr.Abdelfattah#9
Quote:
Originally Posted by LastThief View Post
even after editing i still understand nothing ...
Now it's not my English problem ,
Give me the mistake or the part which u couldn't understand ;)
12/10/2011 22:51 18andLife#10
Quote:
Originally Posted by LastThief View Post
even after editing i still understand nothing ...
Seperated databases, for example account db seperated to account db and silk db
shard db -> global db(i haven't seen it yet, but i guess mostly ref tables), shard db (server related stuff like characters, etc)
12/10/2011 22:56 Dr.Abdelfattah#11
Quote:
Originally Posted by 18andLife View Post
Seperated databases, for example account db seperated to account db and silk db
shard db -> global db(i haven't seen it yet, but i guess mostly ref tables), shard db (server related stuff like characters, etc)
oh oh shard db not separated ,
sro_vt_account will separated to account db and global db and silk db
about shard db and shard log , we don't make anywork on them ..
12/10/2011 22:59 18andLife#12
Quote:
Originally Posted by Dr.Abdelfattah View Post
oh oh shard db not separated ,
sro_vt_account will separated to account db and global db and silk db
about shard db and shard log , we don't make anywork on them ..
ok ^.^
12/10/2011 23:55 !x_~!#13
if it will be installed in any server
what will gonna happen into the server?
converting to isro? :P
12/11/2011 02:18 ✗EpicSoul✗#14
more dumps ??
12/11/2011 08:27 MeGaMaX#15
i really dont understand anything O.o but thx anyway xD