xml exort
same i follow this but login failed on gmc
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!xml exort
USE [RanUser]
GO
/****** Object: StoredProcedure [dbo].[gm_login] Script Date: 11/23/2020 10:30:02 AM ******/
/*** YeXiuPH Fix ***/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[gm_login]
[USER=1335]user[/USER]Id char(50),
[USER=1335]user[/USER]Pass char(50),
[USER=70865]authentic[/USER]ate char(50),
@nReturn int OUTPUT
AS
DECLARE [USER=77438]Nuser[/USER]Num int,
[USER=77438]Nuser[/USER]Type int
SET NOCOUNT ON
SET @nReturn = 0
SET [USER=77438]Nuser[/USER]Num = 0
SELECT [USER=77438]Nuser[/USER]Num = GSUserInfo.UserNum, [USER=77438]Nuser[/USER]Type= GSUserInfo.UserType
FROM GSUserInfo
WHERE UserID = [USER=1335]user[/USER]Id AND UserPass = [USER=1335]user[/USER]Pass AND UserAvailable = 1 AND UserType>=20
-- ID / PWD ??...
IF [USER=77438]Nuser[/USER]Num = 0
BEGIN
-- ID / PWD ??? ?? ???????
SET @nReturn = 0
END
ELSE
BEGIN
-- ID / PWD ??
SET @nReturn = [USER=77438]Nuser[/USER]Type
-- ???? ???
INSERT INTO LogGmCmd (UserNum, GmCmd)
VALUES [USER=77438]Nuser[/USER]Num, 'LOGIN GMTOOL UserID:' + [USER=1335]user[/USER]Id)
END
SET NOCOUNT OFF
RETURN @nReturn
For those who Failed to Login GMC
Try to Execute this:
After that create user password in gsuserinfo usertype 30PHP:USE [RanUser] GO /****** Object: StoredProcedure [dbo].[gm_login] Script Date: 11/23/2020 10:30:02 AM ******/ /*** YeXiuPH Fix ***/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[gm_login] [USER=1335]user[/USER]Id char(50), [USER=1335]user[/USER]Pass char(50), [USER=70865]authentic[/USER]ate char(50), @nReturn int OUTPUT AS DECLARE [USER=77438]Nuser[/USER]Num int, [USER=77438]Nuser[/USER]Type int SET NOCOUNT ON SET @nReturn = 0 SET [USER=77438]Nuser[/USER]Num = 0 SELECT [USER=77438]Nuser[/USER]Num = GSUserInfo.UserNum, [USER=77438]Nuser[/USER]Type= GSUserInfo.UserType FROM GSUserInfo WHERE UserID = [USER=1335]user[/USER]Id AND UserPass = [USER=1335]user[/USER]Pass AND UserAvailable = 1 AND UserType>=20 -- ID / PWD ??... IF [USER=77438]Nuser[/USER]Num = 0 BEGIN -- ID / PWD ??? ?? ??????? SET @nReturn = 0 END ELSE BEGIN -- ID / PWD ?? SET @nReturn = [USER=77438]Nuser[/USER]Type -- ???? ??? INSERT INTO LogGmCmd (UserNum, GmCmd) VALUES [USER=77438]Nuser[/USER]Num, 'LOGIN GMTOOL UserID:' + [USER=1335]user[/USER]Id) END SET NOCOUNT OFF RETURN @nReturn
also follow this:
And this:
i try this method but cant insert item and ado connection problem
use RanOnlineEd.exe for ado config for gmcharedit
anyone here manage to use the auto patch launcher?
is there any webpage or launcher for registration for new account for ran GS source? Or may be any modification in existing webpage or control panel?
you're staring right at the errorWhen tried to create Male Magician there is an error on fieldserver and it creates Brawler instead of Magician. But no problem in female creation magician.
How to fix?
here: mine is 16348 in database when createyou're staring right at the error
check your charset for magician, should be 16384
here: mine is 16348 in database when create
and in charset its 1348.. so I did change the 1348 to 1384 thanks
Have you already tried playing the magician pow class? Does the summon tiger follows you around?
It just stops wherever i last summoned it. I can't recall It unless im close to it like 8m or below. It also doesn't auto attack the enemy i have to consistently use the skill "animal attack order" if i want it to attack. Does it really work like that even on the official/ran-world gs? Or is it a bug?
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