- Joined
- Dec 7, 2006
- Messages
- 250
- Reaction score
- 2
Topic title says all
add this below in LOAD_USER_DATA procedure:
Table query:
u gotta edit the
part though it easy, for example a char is named; GM_RageZone.
then this character will be inserted into GM_LOGIN_LOG.
the same will count for GM_e7823odi27tgdi
but if u make it:
it would add charnames like:
canibegmplz
and:
GMRageZone
you can also add an OR statement to the code like:
now it would log both
canibegmplz
GMRageZone
and
GM_RageZone
add this below in LOAD_USER_DATA procedure:
Code:
if @id like 'GM_%'
BEGIN
INSERT INTO GM_LOGIN_LOG (strAccountID,strUserID, LoginDate) VALUES (@AccountID,@id, getdate() )
END
Table query:
Code:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[GM_LOGIN_LOG](
[strAccountID] [char](50) NULL,
[strUserID] [char](50) NULL,
[LoginDate] [smalldatetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
u gotta edit the
Code:
if @id like 'GM_%'
then this character will be inserted into GM_LOGIN_LOG.
the same will count for GM_e7823odi27tgdi
but if u make it:
Code:
if @id like 'GM%'
it would add charnames like:
canibegmplz
and:
GMRageZone
you can also add an OR statement to the code like:
Code:
if @id like 'GM_%' OR @id like 'GM%'
BEGIN
INSERT INTO GM_LOGIN_LOG (strAccountID,strUserID, LoginDate) VALUES (@AccountID,@id, getdate() )
END
now it would log both
canibegmplz
GMRageZone
and
GM_RageZone
Woot another epic release, lol.
:laugh:
:laugh: