[Guide] Most of vsro files problem solved here

09/13/2011 14:02 ByMnkn#151
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 ?
09/13/2011 14:03 Dr.Abdelfattah#152
Quote:
Originally Posted by DaD2 View Post
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

Quote:
Originally Posted by ByMnkn View Post
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] [smallintNOT NULL,
[
ip] [intNOT NULL,
[
capacity] [smallintNOT NULL
ON [PRIMARY]

GO 
right one
09/13/2011 14:07 Gol.D.Roger#153
i have write my ip in the srNodeType i replace all ip to my ip but customcertificationserver.bin doesnt works anyway hm ..
09/13/2011 14:08 angelZeus#154
[Only registered and activated users can see links. Click Here To Register...]
Quote:
[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
Quote:
[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
Quote:
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:123456@56.155.145.95/"
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
???
09/13/2011 14:08 DaD2#155
Check Your Profile Pls :)
09/13/2011 14:08 Gol.D.Roger#156
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
09/13/2011 14:10 Dr.Abdelfattah#157
Guys give me rest for 5 mints :)
09/13/2011 14:12 rushcrush#158
i got bored from this iis -.-
cant get it setup till now
09/13/2011 14:14 flozz#159
abdelfattah

maybe you have some time to make english guide with setup server?
09/13/2011 14:20 paradise1992#160
[Only registered and activated users can see links. Click Here To Register...]
09/13/2011 14:31 megaman963#161
Quote:
Originally Posted by HaGsTeR View Post
Well creating that table didnt help
It is for GlobalManager -.-
09/13/2011 14:33 ByMnkn#162
setup video where ?
09/13/2011 14:34 raiden90#163
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:123@5.104.120.172/"
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
09/13/2011 14:38 Gol.D.Roger#164
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 ?
09/13/2011 14:40 login_2020#165
i think good for video tutorial.. please make video tutorial...