Query check user or char online

[sontran.dev]

Hello all,
I want to check online or offline by user or char!

Help me! Query. Sr i 'm not good english

[B1Q]

event id 4 Login and 6 Logout in _LogCharEvent (idk the name but it's in the Log database)

also, wrong section. ask here

[White Ros3]

U Can Use Guard To Save Characters Log in Table , Or U Can Add This Function To _AddLogChar
At Frist Make This Table

USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_IPLogs]    Script Date: 5/10/2018 12:21:28 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_IPLogs](
	[CharID] [int] NOT NULL,
	[Charname] [varchar](64) NOT NULL,
	[IP] [varchar](20) NOT NULL,
	[DATE] [datetime] NOT NULL,
 CONSTRAINT [PK__IPLogs] PRIMARY KEY CLUSTERED 
(
	[CharID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Then Add This Function in _addLogChar

if (@EventID=4)
    begin
    declare [MENTION=1414528]Dyn[/MENTION]IP varchar(20)
declare [MENTION=300634]peto[/MENTION]ption tinyint
exec [MENTION=1414528]Dyn[/MENTION]IP = SRO_VT_ACCOUNT.dbo.split_ip [MENTION=336745]DaTa[/MENTION]2
if (exists(SELECT * From _IPLogs where CharID [MENTION=395373]Chari[/MENTION]D))
begin
UPDATE _IPLogs SET IP [MENTION=1414528]Dyn[/MENTION]IP where CharID [MENTION=395373]Chari[/MENTION]D
end
if(not exists(SELECT * FROM _IPLogs where CharID [MENTION=395373]Chari[/MENTION]D))
begin
Insert into _IPLogs (CharID,Charname,IP,DATE) Values  [MENTION=395373]Chari[/MENTION]D [MENTION=3898309]charname[/MENTION] [MENTION=1414528]Dyn[/MENTION]IP,Getdate())
END
END
IF (@EventID=6)
 begin
 Delete From _IPLogs Where CharID = [MENTION=395373]Chari[/MENTION]D
 END

If U Want To Search For Online Player use That Query

USE SRO_VT_SHARDLOG
Go
Select * From _IPLogs Where Charname = 'CharName'

[hunter2051]

exec @DynIP = SRO_VT_ACCOUNT.dbo.split_ip @Data2

this code only return ip of server, no foreign ip of users. can you help me ?

[InZiDeR]

Originally Posted by hunter2051

this code only return ip of server, no foreign ip of users. can you help me ?

because you are using a filter, it's catching FILTER's IP^^

[irockalone]

a simple addon like this maybe will help you !
_AddLogChar

 Spoiler

declare @ varchar(max)
set @ = (select charname16 from SRO_VT_SHARD.dbo._char where charID @ID)
if @d = 4 and not exists (Select charname16 from _onlineplayers where charid @id)
begin
insert into _onlineplayers (charid,charname16,isonline) values @id @,1)
end

 Spoiler

if eventid = 6
begin
delete from _onlineplayers where charid @id
end

Create table

 Spoiler

USE [LOG_ARTEMIS]
GO

/****** Object: Table [dbo].[_Trivia_Losers] Script Date: 10/25/2020 1:12:52 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_OnlinePlayers](
[CharID] [int] NULL,
[Charname16] [varchar](max) NULL,
[isonline] [varchar](max) NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

this will record everysingle online player and will be deleted once they exit the game.