[Guide] Most of vsro files problem solved here

[ByMnkn]

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_ExistsServiceOffRentItem](
[nID] [smallint] NOT NULL,
[ip] [int] NOT NULL,
[capacity] [smallint] NOT NULL
) ON [PRIMARY]

GO

nID - ip - capatpy

what ?

[Dr.Abdelfattah]

Originally Posted by DaD2

abdelftah From Where i get My id - pw FTP ??

lool !
setup ftp server and iis manager will make u control ftp server (makeing account on domains and pass) etc

Originally Posted by ByMnkn

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_ExistsServiceOffRentItem](
[nID] [smallint] NOT NULL,
[ip] [int] NOT NULL,
[capacity] [smallint] NOT NULL
) ON [PRIMARY]

GO

nID - ip - capatpy

what ?

PHP Code:

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_ExistsServiceOffRentItem](
[nID] [smallint] NOT NULL,
[ip] [int] NOT NULL,
[capacity] [smallint] NOT NULL
) ON [PRIMARY]

GO 


right one

[Gol.D.Roger]

i have write my ip in the srNodeType i replace all ip to my ip but customcertificationserver.bin doesnt works anyway hm ..

[angelZeus]

[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=17
name=Shade
query=DRIVER={SQL Server};SERVER=MICROSOF-118807\SQLEXPRESS;DSN=SQLEXPRESS;UID=sa;PWD=123456 ;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=MICROSOF-118807\SQLEXPRESS;DSN=SQLEXPRESS;UID=sa;PWD=123456 ;DATABASE=Log_DB
capacity=2300
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0

[global]
count=1
[entry0]
operation_type=17
name=SRO_GameOn_Official
query=DRIVER={SQL Server};SERVER=MICROSOF-118807\SQLEXPRESS;DSN=SQLEXPRESS;UID=sa;PWD=123456 ;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697

Common {
debug_option_debugger_present {
DEBUG_OPTION_ASSERT_SHOW_MESSAGEBOX_OKCANCEL,
DEBUG_OPTION_ASSERT_ADVANCE_BREAK,
DEBUG_OPTION_ASSERT_CANCEL_EXIT
}

debug_option_stand_alone {
DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX ,
DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
}

netengine_debug_option_debugger_present {
DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX ,
DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
}

netengine_debug_option_stand_alone {
DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX ,
DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
}

}

////////////////////////////////////////////////////////////////////////////////////////////
GlobalManager {
// Certification "56.155.145.95", 32001
Certification "56.155.145.95", 32001

LoginFailureTolerance 3 // AO?e ·I+?AI ?????oчa ?A·u Ca?eA?
IBUVFailureTolerance 3 // AO?e AI?IAo AIAo ?A·u Ca?eA?
LoginFailureBlockTimeMin 10 // ?i·° ?A°?(??) - ·I+?AI ?????oчa ?A·u
IBUVFailureBlockTimeMin 10 // ?i·° ?A°?(??) - AI?IAo AIAo ?A·u
AutomatedPunisher "AutomatedPunisher" // ?i·° AOA? AI? (+aA? ?i·°A? gm ?i)
LoginPunishmentGuide "Blocked for 10 minutes due to incorrect password entered 3 times" // ?????oчa ?A·u?? ?eCN ?i·° °?AIчa
LoginPunishmentDescription "Blocked for 10 minutes due to incorrect password entered 3 times" // ?????oчa ?A·u?? ?eCN ?i·° ???i
IBUVPunishmentGuide "Blocked for 10 minutes due to incorrect code entered 3 times" // AI?IAo AIAo ?A·u?? ?eCN ?i·° °?AIчa
IBUVPunishmentDescription "Blocked for 10 minutes due to incorrect code entered 3 times" // AI?IAo AIAo ?A·u?? ?eCN ?i·° ???i

}

GatewayServer {
LastFullVersion_SR_Client 130
Certification "56.155.145.95", 32000
IBUVQueueReserveCount 20000 // IBUV?│ ACO ?I?R >y??CO ?oA> AI?IAo °??o
IBUVQueuePrepareRatio 0.05 // ??AIчe A?AO?? AI?IAo >y??CO ?nA?
IBUVFailureIPTolerance 0 // CN IP?c IBUV ?C???│ Ca?eCO AO?e ?A·u Ca?eA?, 0AI?e ?i·° ?ECI°U?U?A °AAo.

// A?°?чE ?NAI?U!!!!!
//////////////////////////////////////////////////////////
IBUVStringSize 6 // CN+U A???AI?A >c?e ?A 3, ?E?A?? A???AI ?A?? >c?eCI?A °??i 6 A?·I ???ACN?U.
IBUVCharacterSet "ABCDEFGHLMNQRTabdehimn2345678"
//////////////////////////////////////////////////////////
}

DownloadServer {
Certification "56.155.145.95", 32000
}
FarmManager {
Certification "56.155.145.95", 32000
}

AgentServer {
Certification "56.155.145.95", 32004
}

MachineManager {
Certification "56.155.145.95", 32000
}

SR_GameServer {
Certification "56.155.145.95", 32004

ExpRatio 100
ExpRatioParty 100

DropItemRatio 0,1
DropGoldAmountCoef 0,1
//WINTER_EVENT_2009 EVENT_ON // 2009?a °U?i AI???R
//EUBUSINESS_EVENT EVENT_ON
//GOLDEN_PIG_FEBRUARY_EVENT EVENT_ON
//THANKS_GIVING_EVENT EVENT_ON
//LIBERATION_EVENT EVENT_ON
LOCALE LOCALE_VIETNAM // for Helper mark

//#ifdef OPEN_MARKET_SYSTEM
SET_FEE_RATE "0,5,5,5"
SELL_FEE_RATE "0,10,10,10"
//#endif OPEN_MARKET_SYSTEM
}

SR_ShardManager {
Certification "56.155.145.95", 32004
BILLING_SERVER_URL "http://46.160.127.95:8080/"
CREST_FTP_URL "ftp://admin:[email protected]/"
ExtraExpRatio 0.1
ChristmasEvent2007 0
//SERVER_EVENT_SYSTEM ON
LOCALE LOCALE_VIETNAM
FlagEvent 0
FlagEvent 1
HourForMeterRateLevelFirst 22
HourForMeterRateLevelSecond 23

BattleArenaRandom 1
BattleArenaParty 1
BattleArenaGuild 1
BattleArenaJob 1
ArenaMatchOccupy 1
ArenaMatchFlag 1
ArenaMatchPoint 1

???

[DaD2]

Check Your Profile Pls

[Gol.D.Roger]

it says unhandled exception: System.net.Sockets.SocketException: The Requested adress ip is not valid in its context

anyone can say me too how i can connect the database from vsro files to navicat ? i dont like mysql and i want to use navicat but idk if he wants my ip adress + the pw of router or if he wants the DB id and pw xD

[Dr.Abdelfattah]

Guys give me rest for 5 mints

[rushcrush]

i got bored from this iis -.-
cant get it setup till now

[flozz]

abdelfattah

maybe you have some time to make english guide with setup server?

[paradise1992]

[megaman963]

Originally Posted by HaGsTeR

Well creating that table didnt help

It is for GlobalManager -.-

[ByMnkn]

setup video where ?

[raiden90]

i have filezilla ftp server and work.

server.cfg is configured:

SR_ShardManager {
Certification "5.104.120.172", 32004
BILLING_SERVER_URL "http://5.104.120.172:8080/"
CREST_FTP_URL "ftp://admin:[email protected]/"
ExtraExpRatio 0.1
ChristmasEvent2007 0
//SERVER_EVENT_SYSTEM ON
LOCALE LOCALE_VIETNAM
FlagEvent 0
FlagEvent 1
HourForMeterRateLevelFirst 22
HourForMeterRateLevelSecond 23

BattleArenaRandom 1
BattleArenaParty 1
BattleArenaGuild 1
BattleArenaJob 1
ArenaMatchOccupy 1
ArenaMatchFlag 1
ArenaMatchPoint 1
}


but dosen't work <.<



EDIT:

i have this tablet

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_ExistsServiceOffRentItem](
[nID] [smallint] NOT NULL,
[ip] [int] NOT NULL,
[capacity] [smallint] NOT NULL
) ON [PRIMARY]

GO

[Gol.D.Roger]

can anyone tell me how i can connect the DB with microsoft SQL ServerManagement ? whats the pw and id from DB to connect with it ?

[login_2020]

i think good for video tutorial.. please make video tutorial...