Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[SHARE] FULL GS SOURCE - No More Selling

Experienced Elementalist
Joined
Mar 18, 2013
Messages
279
Reaction score
14
any one help me about this issue ? i try to run Session 1st but this is my error [14:27:05] [ERROR] DB:28000, NativeError:18456, [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''.[14:27:05] [ERROR] DB:SQLConnect Failed -1[14:27:05] [ERROR] OdbcOpenUserDB
 
Joined
Oct 2, 2010
Messages
1,771
Reaction score
228
I have tested the following:
source compilation
server (running)

it's all working fine, apparently, there are some database missing.

I have followed everything listed here including the guide from DATA-TH's admin, couldn't do it without that. Have fun leeching!
 
Last edited:
Custom Title Activated
Member
Joined
Jul 16, 2012
Messages
1,310
Reaction score
116
ODBC is okay..:mellow:
PHP:
<?xml version="1.0" encoding="UTF-8"?>
<RAN_SERVER>
  <!-- ################################################################################################################## -->
  <!-- common start, need all server -->

  <!--
  Korea(Mincoms) alpha: 0 
  Korea(Daum game)(Korea): 1
  Taiwan: 2
  China: 3
  Japan: 4
  Philippines: 5
  Thailand: 6
  Global Service (GSP): 7
  Malaysia: 8
  Global Service: 9
  Indonesia: 10
  Malaysia English: 11 <- do not use. use 8
  Vietnam: 12
  HongKong: 13
  Korea Test Server, IDC, Web Start: 14
  World Battle: 15 
  EU, Games Masters: 16 
  US, Gamesamba: 17 
  -->
  <SERVICE_PROVIDER>9</SERVICE_PROVIDER>
  
  <!--
  LOGIN = 1,
  SESSION = 2,
  FIELD = 3,
  AGENT = 4,
  CACHE = 6 -->
  <SERVER_TYPE>2</SERVER_TYPE>

  <!--   
  DEFAULT = 0,
  TRADITIONAL_CHINESE = 1,
  JAPANESE = 2,
  KOREAN = 3,
  SIMPLIFIED_CHINESE = 4,
  THAILAND = 5,
  VIETNAM = 6,
  -->
  <LANGUAGE_SET>1</LANGUAGE_SET>

  <!--
  current server ip address
  -->
  <SERVER_IP>127.0.0.1</SERVER_IP>

  <!--
  SESSION 5003
  LOGIN 5001
  FIELD 5029, 5030, 5031, 5032, 5033
  AGENT 5502
  CACHE 5503
  -->
  <SERVICE_PORT>5003</SERVICE_PORT>
  <CONTROL_PORT>6003</CONTROL_PORT>

  <!--
  Patch Version, Only login server set value. another server set 0. default:0
  -->
  <SERVER_VERSION>0</SERVER_VERSION>
  
  <!--
  Launcher Version, Only login server set value. another server set 0. default:0
  -->
  <PATCH_VERSION>0</PATCH_VERSION>
  
  <!--
  patch cut Version, Only login server set value. another server set 0. default:0
  -->
  <PATCH_CUT_VERSION>0</PATCH_CUT_VERSION>

  <!-- default:0 / All pvp disable -->
  <PKLESS>0</PKLESS>

  <!-- default:1 / 1:PK server, 0:Non PK server -->
  <PK>1</PK>

  <!-- default:0 / check adult -->
  <ADULT>0</ADULT>

  <!-- default:0 / use event thread -->
  <EVENT_THREAD>1</EVENT_THREAD>
  
  <!-- update frame, to use this option EVENT_THREAD must set to 1. default:10 -->
  <FPS>10</FPS>

  <!-- default:0 / is test server? -->
  <TEST_SERVER>0</TEST_SERVER>

  <!-- Use HeartBeat -->
  <HEARTBEAT>1</HEARTBEAT>

  <!-- Current server's max client. -->
  <MAX_CLIENT>1000</MAX_CLIENT>
  
  <!--
  Max client number per one channel
  ex) 1000(MAX_CLIENT) == 1000(MAX_CHANNEL_CLIENT) * 1(SERVER_CHANNEL_NUMBER)
  -->
  <MAX_CHANNEL_CLIENT>1000</MAX_CHANNEL_CLIENT>

  <!--
  server group number. session and login set 0. because session and login is common.
  -->
  <SERVER_GROUP>0</SERVER_GROUP>
  
  <!--
  All server set 0. 
  -->
  <SERVER_NUMBER>0</SERVER_NUMBER>
  
  <!-- I/O Thread Number -->
  <THREAD>2</THREAD>
  
  <CONNECTION_PER_IP_ADDRESS>50</CONNECTION_PER_IP_ADDRESS>
  
  <!-- default:0 -->
  <USE_CUSTOM_DB_POOL>0</USE_CUSTOM_DB_POOL>
  
  <!-- default:2000, minimum value 1000 -->
  <REFERENCE_COUNT_MAX>2000</REFERENCE_COUNT_MAX>
  
  <!-- default:1500 -->
  <MAX_POOL_SIZE>1500</MAX_POOL_SIZE>
  
  <!-- default:32767 -->
  <DB_PACKET_SIZE>32767</DB_PACKET_SIZE>

  <!-- common end, need all server -->
  <!-- ################################################################################################################## -->

  <!-- ################################################################################################################## -->
  <!-- specific part start, need session server -->
  
  <!-- User Database -->
  <USER_DB>
    <DATA_SOURCE>DESKTOP-BKG6RV7</DATA_SOURCE>
    <ODBC_NAME>RanUser</ODBC_NAME>
    <CATALOG>RanUser</CATALOG>
    <ID>sa</ID>
    <PASSWORD>1234</PASSWORD>
    <TIMEOUT>15</TIMEOUT>
  </USER_DB>

 <!-- Game Database -->
  <GAME_DB>
    <DATA_SOURCE>DESKTOP-BKG6RV7</DATA_SOURCE>
    <ODBC_NAME>RanGameS1</ODBC_NAME>
    <CATALOG>RanGameS1</CATALOG>
    <ID>sa</ID>
    <PASSWORD>1234</PASSWORD>
    <TIMEOUT>15</TIMEOUT>
  </GAME_DB> 

  <!-- Log Database -->
  <LOG_DB>
    <DATA_SOURCE>DESKTOP-BKG6RV7</DATA_SOURCE>
    <ODBC_NAME>RanLogS1</ODBC_NAME>
    <CATALOG>RanLogS1</CATALOG>
    <ID>sa</ID>
    <PASSWORD>1234</PASSWORD>
    <TIMEOUT>15</TIMEOUT>
  </LOG_DB>

   <!-- Shop Database -->
  <SHOP_DB>
    <DATA_SOURCE>DESKTOP-BKG6RV7</DATA_SOURCE>
    <ODBC_NAME>RanShop</ODBC_NAME>
    <CATALOG>RanShop</CATALOG>
    <ID>sa</ID>
    <PASSWORD>1234</PASSWORD>
    <TIMEOUT>15</TIMEOUT>
  </SHOP_DB>
  
  <WORLDBATTLE_RELATED_DB>
    <DATA_SOURCE>DESKTOP-BKG6RV7</DATA_SOURCE>
	<ODBC_NAME>WBGame</ODBC_NAME>
    <CATALOG>WBGame</CATALOG>
    <ID>sa</ID>
    <PASSWORD>1234</PASSWORD>
    <TIMEOUT>15</TIMEOUT>
  </WORLDBATTLE_RELATED_DB>

  <RANMOBILE_DB>
   <DATA_SOURCE>DESKTOP-BKG6RV7</DATA_SOURCE>
   <CATALOG>RanMobileInterface</CATALOG>
   <ID>sa</ID>
   <PASSWORD>1234</PASSWORD>
   <TIMEOUT>30</TIMEOUT>
  </RANMOBILE_DB>
  
  
  <!--
  addtional DB
  SP_PHILIPPINES || SP_MALAYSIA || SP_THAILAND -> TERRA_DB
  SP_GLOBAL -> GSP_DB
  -->

</RAN_SERVER>
Session server
Quiirex - [SHARE] FULL GS SOURCE - No More Selling - RaGEZONE Forums
 
Joined
May 4, 2009
Messages
54
Reaction score
19
ODBC is okay..:mellow:
PHP:
<?xml version="1.0" encoding="UTF-8"?>
<RAN_SERVER>
  <!-- ################################################################################################################## -->
  <!-- common start, need all server -->

  <!--
  Korea(Mincoms) alpha: 0 
  Korea(Daum game)(Korea): 1
  Taiwan: 2
  China: 3
  Japan: 4
  Philippines: 5
  Thailand: 6
  Global Service (GSP): 7
  Malaysia: 8
  Global Service: 9
  Indonesia: 10
  Malaysia English: 11 <- do not use. use 8
  Vietnam: 12
  HongKong: 13
  Korea Test Server, IDC, Web Start: 14
  World Battle: 15 
  EU, Games Masters: 16 
  US, Gamesamba: 17 
  -->
  <SERVICE_PROVIDER>9</SERVICE_PROVIDER>
  
  <!--
  LOGIN = 1,
  SESSION = 2,
  FIELD = 3,
  AGENT = 4,
  CACHE = 6 -->
  <SERVER_TYPE>2</SERVER_TYPE>

  <!--   
  DEFAULT = 0,
  TRADITIONAL_CHINESE = 1,
  JAPANESE = 2,
  KOREAN = 3,
  SIMPLIFIED_CHINESE = 4,
  THAILAND = 5,
  VIETNAM = 6,
  -->
  <LANGUAGE_SET>1</LANGUAGE_SET>

  <!--
  current server ip address
  -->
  <SERVER_IP>127.0.0.1</SERVER_IP>

  <!--
  SESSION 5003
  LOGIN 5001
  FIELD 5029, 5030, 5031, 5032, 5033
  AGENT 5502
  CACHE 5503
  -->
  <SERVICE_PORT>5003</SERVICE_PORT>
  <CONTROL_PORT>6003</CONTROL_PORT>

  <!--
  Patch Version, Only login server set value. another server set 0. default:0
  -->
  <SERVER_VERSION>0</SERVER_VERSION>
  
  <!--
  Launcher Version, Only login server set value. another server set 0. default:0
  -->
  <PATCH_VERSION>0</PATCH_VERSION>
  
  <!--
  patch cut Version, Only login server set value. another server set 0. default:0
  -->
  <PATCH_CUT_VERSION>0</PATCH_CUT_VERSION>

  <!-- default:0 / All pvp disable -->
  <PKLESS>0</PKLESS>

  <!-- default:1 / 1:PK server, 0:Non PK server -->
  <PK>1</PK>

  <!-- default:0 / check adult -->
  <ADULT>0</ADULT>

  <!-- default:0 / use event thread -->
  <EVENT_THREAD>1</EVENT_THREAD>
  
  <!-- update frame, to use this option EVENT_THREAD must set to 1. default:10 -->
  <FPS>10</FPS>

  <!-- default:0 / is test server? -->
  <TEST_SERVER>0</TEST_SERVER>

  <!-- Use HeartBeat -->
  <HEARTBEAT>1</HEARTBEAT>

  <!-- Current server's max client. -->
  <MAX_CLIENT>1000</MAX_CLIENT>
  
  <!--
  Max client number per one channel
  ex) 1000(MAX_CLIENT) == 1000(MAX_CHANNEL_CLIENT) * 1(SERVER_CHANNEL_NUMBER)
  -->
  <MAX_CHANNEL_CLIENT>1000</MAX_CHANNEL_CLIENT>

  <!--
  server group number. session and login set 0. because session and login is common.
  -->
  <SERVER_GROUP>0</SERVER_GROUP>
  
  <!--
  All server set 0. 
  -->
  <SERVER_NUMBER>0</SERVER_NUMBER>
  
  <!-- I/O Thread Number -->
  <THREAD>2</THREAD>
  
  <CONNECTION_PER_IP_ADDRESS>50</CONNECTION_PER_IP_ADDRESS>
  
  <!-- default:0 -->
  <USE_CUSTOM_DB_POOL>0</USE_CUSTOM_DB_POOL>
  
  <!-- default:2000, minimum value 1000 -->
  <REFERENCE_COUNT_MAX>2000</REFERENCE_COUNT_MAX>
  
  <!-- default:1500 -->
  <MAX_POOL_SIZE>1500</MAX_POOL_SIZE>
  
  <!-- default:32767 -->
  <DB_PACKET_SIZE>32767</DB_PACKET_SIZE>

  <!-- common end, need all server -->
  <!-- ################################################################################################################## -->

  <!-- ################################################################################################################## -->
  <!-- specific part start, need session server -->
  
  <!-- User Database -->
  <USER_DB>
    <DATA_SOURCE>DESKTOP-BKG6RV7</DATA_SOURCE>
    <ODBC_NAME>RanUser</ODBC_NAME>
    <CATALOG>RanUser</CATALOG>
    <ID>sa</ID>
    <PASSWORD>1234</PASSWORD>
    <TIMEOUT>15</TIMEOUT>
  </USER_DB>

 <!-- Game Database -->
  <GAME_DB>
    <DATA_SOURCE>DESKTOP-BKG6RV7</DATA_SOURCE>
    <ODBC_NAME>RanGameS1</ODBC_NAME>
    <CATALOG>RanGameS1</CATALOG>
    <ID>sa</ID>
    <PASSWORD>1234</PASSWORD>
    <TIMEOUT>15</TIMEOUT>
  </GAME_DB> 

  <!-- Log Database -->
  <LOG_DB>
    <DATA_SOURCE>DESKTOP-BKG6RV7</DATA_SOURCE>
    <ODBC_NAME>RanLogS1</ODBC_NAME>
    <CATALOG>RanLogS1</CATALOG>
    <ID>sa</ID>
    <PASSWORD>1234</PASSWORD>
    <TIMEOUT>15</TIMEOUT>
  </LOG_DB>

   <!-- Shop Database -->
  <SHOP_DB>
    <DATA_SOURCE>DESKTOP-BKG6RV7</DATA_SOURCE>
    <ODBC_NAME>RanShop</ODBC_NAME>
    <CATALOG>RanShop</CATALOG>
    <ID>sa</ID>
    <PASSWORD>1234</PASSWORD>
    <TIMEOUT>15</TIMEOUT>
  </SHOP_DB>
  
  <WORLDBATTLE_RELATED_DB>
    <DATA_SOURCE>DESKTOP-BKG6RV7</DATA_SOURCE>
	<ODBC_NAME>WBGame</ODBC_NAME>
    <CATALOG>WBGame</CATALOG>
    <ID>sa</ID>
    <PASSWORD>1234</PASSWORD>
    <TIMEOUT>15</TIMEOUT>
  </WORLDBATTLE_RELATED_DB>

  <RANMOBILE_DB>
   <DATA_SOURCE>DESKTOP-BKG6RV7</DATA_SOURCE>
   <CATALOG>RanMobileInterface</CATALOG>
   <ID>sa</ID>
   <PASSWORD>1234</PASSWORD>
   <TIMEOUT>30</TIMEOUT>
  </RANMOBILE_DB>
  
  
  <!--
  addtional DB
  SP_PHILIPPINES || SP_MALAYSIA || SP_THAILAND -> TERRA_DB
  SP_GLOBAL -> GSP_DB
  -->

</RAN_SERVER>
Session server
Quiirex - [SHARE] FULL GS SOURCE - No More Selling - RaGEZONE Forums

Your ODBC user and pass must be encrypted. Use RanOnlineEd's String encrypt function
 
Initiate Mage
Joined
Dec 11, 2020
Messages
26
Reaction score
4
ODBC is okay..:mellow:
PHP:
        9      2    1    127.0.0.1    5003  6003    0      0      0    0    1    0    1      10    0    1    1000      1000    0      0      2    50      0      2000      1500      32767                  DESKTOP-BKG6RV7    RanUser    RanUser    sa    1234    15         DESKTOP-BKG6RV7    RanGameS1    RanGameS1    sa    1234    15           DESKTOP-BKG6RV7    RanLogS1    RanLogS1    sa    1234    15           DESKTOP-BKG6RV7    RanShop    RanShop    sa    1234    15          DESKTOP-BKG6RV7    WBGame    WBGame    sa    1234    15       DESKTOP-BKG6RV7   RanMobileInterface   sa   1234   30
Session server
Quiirex - [SHARE] FULL GS SOURCE - No More Selling - RaGEZONE Forums


Open : StringEncrypt.exe
<ID>sa</ID>
<PASSWORD>1234</PASSWORD>

to

<ID>24542CA01303F7B2</ID>
<PASSWORD>C35BDC62CC1C959D</PASSWORD>



My Compile results:
Code:
HelpEdit
FileSystem - Unresolved external error (8)
RanOnlineInstaller
SNSTool - Unresolved external error (158)
RanStatistics - cannot open input file (1)
ReportFiles - Error (8)
XmlConvert - Error (886)
VersionManager
RanEditor
VerMan
CompareTool
CommentTool
ItemDataMergerTool
DataCheckTool
StringEncrypt
SoundSourceManager
ItemEdit
MobNpcEdit
SkillEdit
NpcAction
QuestEdit
SpecialTool
RanOnlineEd
LevelEdit
GenItemTool
RandomOptionTool
RandomOptionEdit
WorldEdit
MMPC
TextureTool
Tool_VisualMaterial - Unresolved external error (14)
CharEdit
Tool_Visual Scropt - cannot open input file (1)
Tool_UITexture - Unresolved external error (6)
EffectTool
GMCharEdit - Unresolved external error (9)
MoneyManager
AutoPatchMan
MinWebLauncher
PatchPrimeMan - Unresolved external error (1139)
PatchPrimeManNew - cannot open input file (1)
ServerManager
PreDownloadMan
Basic
CacheServer
Emulator
FieldServer
LoginServer
SessionServer
AuthServer
AgentServer


+1 :tongue:
 
Custom Title Activated
Member
Joined
Jul 16, 2012
Messages
1,310
Reaction score
116
Your ODBC user and pass must be encrypted. Use RanOnlineEd's String encrypt function

ohhh i didn't know that.. i'm just an old user :) thanks



Open : StringEncrypt.exe
<ID>sa</ID>
<PASSWORD>1234</PASSWORD>

to

<ID>24542CA01303F7B2</ID>
<PASSWORD>C35BDC62CC1C959D</PASSWORD>






+1 :tongue:

ok thanks will try
 
Junior Spellweaver
Joined
Mar 2, 2017
Messages
187
Reaction score
18
Icant login on my client i create acct on ran userinfo and also i try md5 but cant login wrong password and username
 
Initiate Mage
Joined
Mar 9, 2020
Messages
64
Reaction score
18
- I would like to thank the guys who gave hints/tips in this post!
 
Initiate Mage
Joined
Feb 19, 2021
Messages
29
Reaction score
0

Attachments

You must be registered for see attachments list
Joined
May 4, 2009
Messages
54
Reaction score
19
duplicate cacheserver.exe and rename it to cacheserver2.exe..the HEX the cacheserver2.exe and find cacheserver.xml and change to cacheserve2.xml, try re run server fieldserver wont become not responding anymore...but AgentServer will 'Not responding' :*:

the way I run server : SessionServer(OK)>CacheServeOKr()>CacheServer2(OK)>FieldServer(OK)>AgentServer(I got Not Responding/crash here on AgentServer)

The reason is that, a log file is being hogged by field server.. While the agent server wants that file name to use...

update TxtFile.cpp in SigmaCore
PHP:
TxtFile::TxtFile(const std::string& FileName, bool AutoRename, ENCODING Encoding)
    : m_hFile(INVALID_HANDLE_VALUE)
{
	/**
	*	Whoever it is that is dumb enough to implement a method for checking existing files and renaming 
	*	them to get the desired filename instead of checking for other available filename
	*	and use it is a lazy mother fcker and should not be a programmer at all!
	*/
	std::string newfcker = FileName;
	if(sc::file::isExist(FileName))
	{
		// designator declaration
		// WARNING! This loop can lead to a long blocking operation
		for(UINT i = 1; i < UINT_MAX; i++)
		{
			std::string fckyou, fckthis;

			// split file name with the ext
			static const std::basic_string <char>::size_type urmom = -1;
			std::basic_string <char>::size_type fckher = FileName.rfind(".");
			if(urmom == fckher)
			{
				fckyou = FileName;
				fckthis = "";
			}
			else
			{
				fckyou = FileName.substr(0, fckher);
				fckthis.assign( FileName, fckher+1, FileName.size()-fckher-1 ); // get that fck en extension, baby!!!
			}

			// new string concat
			newfcker = sc::string::format("%s%i.%s", fckyou, i, fckthis);
			if(!sc::file::isExist(newfcker))
				break;
		}
	}
	// sc::file::autoRename(FileName);
	
    
    m_hFile = ::CreateFile(
        newfcker.c_str(),
        GENERIC_WRITE,
        FILE_SHARE_READ,
        NULL,
        OPEN_ALWAYS,
        FILE_ATTRIBUTE_NORMAL,
        NULL);
    if (m_hFile == INVALID_HANDLE_VALUE)
    {
        SAFE_CLOSE_HANDLE(m_hFile);
    }
    else
    {
        m_strFullFileName = newfcker;

        // Bunch of unicode info at:
        // http://www.unicode.org/faq/utf_bom.html    
	    // 00 00 FE FF  UTF-32, big-endian
	    // FF FE 00 00 	UTF-32, little-endian
	    // FE FF 		UTF-16, big-endian
	    // FF FE 		UTF-16, little-endian
	    // EF BB BF 	UTF-8
        DWORD dwBytesWritten=0;
        if (Encoding == UTF8)
        {	    
	        unsigned char Mark[3];
	        Mark[0] = 0xEF;
	        Mark[1] = 0xBB;
            Mark[2] = 0xBF;
	        WriteFile(m_hFile, Mark, 3, &dwBytesWritten, NULL);
        }
        else if (Encoding == UTF16LE)
        {
            unsigned char Mark[2];
            Mark[0] = 0xFF;
            Mark[1] = 0xFE;
            WriteFile(m_hFile, Mark, 2, &dwBytesWritten, NULL);
        }
        else if (Encoding == UTF16BE)
        {
            unsigned char Mark[2];
            Mark[0] = 0xFE;
            Mark[1] = 0xFF;
            WriteFile(m_hFile, Mark, 2, &dwBytesWritten, NULL);
        }
        else
        {
        }
    }
}

you should be able to run agent server from the same folder as the field after this patch
 
Last edited:
Back
Top