[SHARE] FULL GS SOURCE - No More Selling

Experienced Elementalist
Joined
Mar 18, 2013
Messages
280
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
Loyal 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
 
Newbie Spellweaver
Joined
May 4, 2009
Messages
54
Reaction score
19

Your ODBC user and pass must be encrypted. Use RanOnlineEd's String encrypt function
 
Newbie Spellweaver
Joined
Dec 11, 2020
Messages
26
Reaction score
4


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

to

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





+1 :tongue:
 
Custom Title Activated
Loyal 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
 
Newbie Spellweaver
Joined
Mar 9, 2020
Messages
64
Reaction score
18
- I would like to thank the guys who gave hints/tips in this post!
 
Newbie Spellweaver
Joined
Feb 19, 2021
Messages
29
Reaction score
0

Attachments

You must be registered for see attachments list
Newbie Spellweaver
Joined
Feb 19, 2021
Messages
29
Reaction score
0

Attachments

You must be registered for see attachments list
Newbie Spellweaver
Joined
May 4, 2009
Messages
54
Reaction score
19

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: