- Joined
- May 12, 2008
- Messages
- 2,547
- Reaction score
- 437
USE [RanUser]
GO
/****** Object: StoredProcedure [dbo].[gm_login] Script Date: 11/26/2008 21:15:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
-------------------------------------------------------------------------------
-- sp_gm_login.sql
-------------------------------------------------------------------------------
ALTER PROCEDURE [dbo].[gm_login]
@userId char(50),
@userPass char(50),
@authenticate char(50),
@nReturn int OUTPUT
AS
DECLARE @nUserNum int,
@nUserType int
SET NOCOUNT ON
SET @nReturn = 0
SET @nUserNum = 0
SELECT @nUserNum = UserInfo.UserNum, @nUserType=UserInfo.UserType
FROM UserInfo
WHERE UserID = @userId AND UserPass = @userPass AND UserAvailable = 1 AND UserType>=20
-- ID / PWD ??...
IF @nUserNum = 0
BEGIN
-- ID / PWD ??? ?? ???????
SET @nReturn = 0
END
ELSE
BEGIN
-- ID / PWD ??
SET @nReturn = @nUserType
-- ???? ???
INSERT INTO LogGmCmd (UserNum, GmCmd)
VALUES (@nUserNum, 'LOGIN GMTOOL UserID:' + @userId)
END
SET NOCOUNT OFF
RETURN @nReturn
DB Name : RanUser
SQL User : sa
Password : yourpass
Retype : yourpass
We will put the comment.ini in the glogic.rcc
client + server right
"just find working comment.ini"? You had the item add working on the screens you showed, so they weren't yours (the pics)? Or are you making fool of us
Same for Eifel, "I will share soon" were his words but of course there was nothing Eifel if you don't want to share then stop to show off and to make fake promises
sorry dude if I can't share all my stuff. the following reason is I'm so busy with my server and all other stuff outside world of RAN. and correy is right you should only find compatible comment.in for ep4 GMC.
the "comment.ini" that im using can't decrypt by any tools we have right now. I think this is a new method of encryption. and secondly upon working on this GMC the binary structure for ChaInven in our current files is different on what being fetch on database.
Thoughts about ep4 GMC:
- - When you add quest it is working!
- - When you add skill it is working!
- - UserInven and ChaInven totally wiped upon adding new item.
and stop this all misunderstandings, I'm a good sharer if you just know me well. and about what happen on the past days. me the one apologizing to you, magenik,bk etc. . . I don't want trouble anymore and that could just lead us all to failure.
@all
all tools have been share. I already share the new gm_login procedure which is now posted by abry and tbb.dll for emulator. all you have to do now is do your part which is search for that "comment.ini". try google.