[Guide] Setting up a server based on VSRO server files

10/12/2011 18:49 xFlyer#541
Quote:
Originally Posted by jack99888 View Post
What is GM's way of creating an account
Read this damn guide!

If you need GM account do as I showed bellow, if you need normal account then fill only StrUserID and password.

Open MSSQL ––> TB_User

and it's how fill tables

StrUserId: accname
password: md5 hash password, example: 1a1dc91c907325c69271ddf0c944bc72 it mean: pass
GMrank: 1
Sec_Primary: 1
Sec_Content: 1

leave other.

Quote:
Originally Posted by bloody94
...
You configured your certificate wrongly.
10/12/2011 18:55 bloody94#542
Well, tell me wat's wrong on my certificate?
10/12/2011 19:07 jack99888#543
GM accounts could be created but can not login
10/12/2011 19:28 xFlyer#544
@bloody94 first of all ODBC names.

@jack99888 did you put ip's in PrivilegedIP?
10/12/2011 19:49 jack99888#545
Local IP? hamachi IP?
10/12/2011 20:04 bloody94#546
All my DSN have been set with ODBC, the probleme is same as before, and i am pretty shure there is no problem about my ODBC. I thinking about the port, i cant only set port 32000, not 32001 or 32004 ect..
10/12/2011 21:29 jack99888#547
The image does not come out the code when you try to log in the GM account
10/12/2011 21:54 xFlyer#548
Quote:
Originally Posted by jack99888 View Post
Local IP? hamachi IP?
Depends which are you using to launch server.

Quote:
Originally Posted by bloody94 View Post
All my DSN have been set with ODBC, the probleme is same as before, and i am pretty shure there is no problem about my ODBC. I thinking about the port, i cant only set port 32000, not 32001 or 32004 ect..
So u added your databases to ODBC with the name of ODBC if so then okay but I don't think so. Try certification which uses ports around 15882~, for certification connection it's 32000 as u said and I can't use higher too, lol. :mofo:

And show me your MSSQL database and ODBC. I'm pretty sure you fucked up on ODBC DSN. :)

Quote:
Originally Posted by jack99888 View Post
The image does not come out the code when you try to log in the GM account
Again - Privilege IP.
10/12/2011 23:57 [IL]#549
may you help me please?
[Only registered and activated users can see links. Click Here To Register...]

i can't run the service..
10/13/2011 01:38 bloody94#550
here's my odbc setup,

I also used the SRO_ODBC_REG reg's files from miki maus:

[Only registered and activated users can see links. Click Here To Register...]


[Only registered and activated users can see links. Click Here To Register...]
10/13/2011 05:38 jack99888#551
I come with the image code and set the GM account Privilege IP
10/13/2011 12:37 xFlyer#552
Quote:
Originally Posted by bloody94 View Post
here's my odbc setup,

I also used the SRO_ODBC_REG reg's files from miki maus:

[Only registered and activated users can see links. Click Here To Register...]


[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=22
name=ServerName
query=DRIVER={SQL Server};SERVER=USER-PC\SQLEXPRESS;DSN=ODBC;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=USER-PC\SQLEXPRESS;DSN=ODBC;DATABASE=SRO_VT_SHARDLOG
I marked RED your problems.

First DSN=SRO_VT_SHARD
Second DSN=Log_DB
DATABASE=Log_DB

@jack99888,
so it's working?
10/13/2011 14:53 bloody94#553
Probleme is same as before. still "request server certification" :s
10/13/2011 19:24 [IL]#554
any one can help me build the server i tryed few time and i didn't seccsed, who can contact with me at
skype: shahar-bos
msn: [Only registered and activated users can see links. Click Here To Register...]
please i need it for my project.
10/13/2011 20:00 playboll#555
[Only registered and activated users can see links. Click Here To Register...]
Http, FTP on but i got billing server

Code:
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 "cert.joymax.com", 32000
	Certification "ip", 32000
	
	LoginFailureTolerance		3				// ÃÖ´ë ·Î±×ÀÎ ÆÐ½º¿öµå ¿À·ù Çã¿ëÄ¡
	IBUVFailureTolerance		3				// ÃÖ´ë À̹ÌÁö ÀÎÁõ ¿À·ù Çã¿ëÄ¡
	LoginFailureBlockTimeMin	10				// ºí·° ½Ã°£(ºÐ) - ·Î±×ÀÎ ÆÐ½º¿öµå ¿À·ù 
	IBUVFailureBlockTimeMin		10				// ºí·° ½Ã°£(ºÐ) - À̹ÌÁö ÀÎÁõ ¿À·ù 
	AutomatedPunisher		"AutomatedPunisher"		// ºí·° ÁÖü À̸§ (±âÁ¸ ºí·°Àº gm ¸í)
	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"		// À̹ÌÁö ÀÎÁõ ¿À·ù¿¡ ´ëÇÑ ºí·° ¼³¸í

}

GatewayServer {
	LastFullVersion_SR_Client 130
	Certification "ip", 15880
	IBUVQueueReserveCount		20000	// IBUV¸¦ À§ÇØ ¹Ì¸® »ý¼ºÇØ ³õÀ» À̹ÌÁö °¹¼ö	
	IBUVQueuePrepareRatio		0.05	// ¾ÆÀ̵é ŸÀÓ¿¡ À̹ÌÁö »ý¼ºÇÒ ºñÀ²
	IBUVFailureIPTolerance		0	// ÇÑ IP´ç IBUV ½ÇÆÐ¸¦ Çã¿ëÇÒ ÃÖ´ë ¿À·ù Çã¿ëÄ¡, 0ÀÌ¸é ºí·° ¾ÈÇϰڴٴ °ÅÁö.

	// Ãß°¡µÈ ³ÑÀÌ´Ù!!!!!
	//////////////////////////////////////////////////////////
	IBUVStringSize			6 	// ÇÑ±Û Ä³¸¯Åͼ »ç¿ë ½Ã 3, ¾ËÆÄºª ij¸¯ÅÍ ¼Â¸¸ »ç¿ëÇÏ´Â °æ¿ì 6 À¸·Î ¼¼ÆÃÇÑ´Ù.
	IBUVCharacterSet		"ABCDEFGHLMNQRTabdehimn2345678"
	//////////////////////////////////////////////////////////
}

DownloadServer {
        Certification "ip", 15880
}
FarmManager {
	Certification "ip", 15880
}

AgentServer {
	Certification "ip", 15882
}

MachineManager {
	Certification "ip", 15880
}

SR_GameServer {
	Certification "ip", 15882

	ExpRatio             100
        ExpRatioParty        100
      
	DropItemRatio       0,1
        DropGoldAmountCoef   0,1	
        //WINTER_EVENT_2009		EVENT_ON	// 2009³â °Ü¿ï À̺¥Æ®
	//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 "ip", 15882
    BILLING_SERVER_URL "http://ip:8080/test.asp"
    CREST_FTP_URL "ftp://id:pw@ip/SRO_CREST"  
	   ChristmasEvent2007 1
	   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
}
PHP Code:
2011-10-13    20:44:25    [SR_ShardManager]    Not found RefServerEvent[30001]. Check service and date valueprogress next data
2011
-10-13    20:44:25    [SR_ShardManager]    Not found RefServerEvent[30002]. Check service and date valueprogress next data
2011
-10-13    20:44:25    [SR_ShardManager]    Not found RefServerEvent[30003]. Check service and date valueprogress next data
2011
-10-13    20:44:25    [SR_ShardManager]    Not found RefServerEvent[30004]. Check service and date valueprogress next data
2011
-10-13    20:44:25    [SR_ShardManager]    SR_ShardManager is initialized successfully
2011
-10-13    20:44:25    [SR_ShardManager]    BillingServer is Dead!!