Log database Event ID

Hello Everyone,

Simply i want we include every event id in this topic.

Here is what i have:

EVENTID 1 = New character created
EVENTID 9 and 11 = Teleporting
EVENTID 90 =alchemy success
EVENTID 91 = Alchemy fail
EVENTID 4 = log in
EVENTID 6 = log out
EVENTID 19 = Job suit on
EVENTID 70 = Joined guild
EVENTID 71 = Left guild
EventID = 20 - PvP Kill -- by Tazdingo
EventID = 19 - PK/Guild War/Job Kill -- by Tazdingo
EventID = 75 - GuildWar Declare -- by Tazdingo
EventID = 77 - Guild War Win/Lose -- by Tazdingo
EventID =239, DATA1=1- registred to arena -- By Zenox
EventID =239, DATA1=2- Canceled arena-- By Zenox
EventID =98- Buying goods (trader)-- By Zenox
EventID =97- selling goods (trader)-- By Zenox
EventID =91, Data1=2- Goods selling (some kind of data, maybe exp) thief-- By Zenox
EventID =91, Data1=3- Goods selling (some kind of data, maybe exp) hunter-- By Zenox
EventID =94- leaving job-- By Zenox
EventID =93- joining job-- By Zenox
EventID =95- Making nickname-- By Zenox
EventID =101- Thief/Mob kills trader pet-- By Zenox
EventID = 22 -- Character Level Up --DrugDealers
EventID = 9 -- spawn to an Area--turkplaya

I will add more ids later

Share please what you got.

EventID = 20 - PvP Kill
EventID = 19 - PK/Guild War/Job Kill
EventID = 75 - GuildWar Declare
EventID = 77 - Guild War Win/Lose

Everyone who actually wants to find an eventid can do so with around 2.5 minutes of work, including starting a server and logging in.
Right now you are helping the shitheads you don't know how to find out eventids and operationids. Keep going and you''ll see the idiots catching up to you.

The "development" community died since the psro itemmall was invented.

Quote:

---

Originally Posted by Royalblade

Everyone who actually wants to find an eventid can do so with around 2.5 minutes of work, including starting a server and logging in.
Right now you are helping the shitheads you don't know how to find out eventids and operationids. Keep going and you''ll see the idiots catching up to you.

The "development" community died since the psro itemmall was invented.

---

I will help the "shitheads". Why? Because you blame at this guy who try to help a little bit.

Finding Event ID's: (Easy Method)

Step 1: Create this table at log db

/****** Object: Table [dbo].[_EventDetect] Script Date: 12/19/2013 04:39:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_EventDetect](
[CharID] [int] NULL,
[EventID] [int] NULL,
[Data1] [int] NULL,
[Data2] [int] NULL,
[strPos] [varchar](64) NULL,
[Desc] [varchar](128) NULL,
[Date] [datetime] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Step 2: Modify this procedure

/****** Object: StoredProcedure [dbo].[_AddLogChar] Script Date: 12/19/2013 04:40:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER procedure [dbo].[_AddLogChar] @CharID int, @eventID tinyint, @data1 int, @data2 int,
@strPos varchar(64), @desc varchar(128)
as

insert _EventDetect values @CharID, @eventID, @data1, @data2, @strPos, @desc, GetDate())

Step 3: Log in at one character and start doing things at the game

Step 4: Check every time the table _EventDetect and you will see the event ids and so on.

.-.-.-.-.-.--.

Find event id's and post here what you found :D

Good luck at finding what u are loking for.

BTW royal i remember the time when you and me where trying to solve c9 errors xD if you dont want to help dont post, that's all.

Quote:

---

Originally Posted by Royalblade

Everyone who actually wants to find an eventid can do so with around 2.5 minutes of work, including starting a server and logging in.
Right now you are helping the shitheads you don't know how to find out eventids and operationids. Keep going and you''ll see the idiots catching up to you.

The "development" community died since the psro itemmall was invented.

---

If you want to help us please stop write shit comments here.

- - - Updated - - -

Quote:

---

Originally Posted by Tazdingo

EventID = 20 - PvP Kill
EventID = 19 - PK/Guild War/Job Kill
EventID = 75 - GuildWar Declare
EventID = 77 - Guild War Win/Lose

---

Thanks buddy.
I will add more EventID today :)

Global log ?

Quote:

---

Originally Posted by loveme

Global log ?

---

If you use srzor then you don't have any problem.

You can use _LogEventItem for global
IF ( @ItemRefID = global id here)
Begin
Your sql query here
END

239, DATA1=1- registred to arena
239, DATA1=2- Canceled arena
98- Buying goods (trader)
97- selling goods (trader)
91, Data1=2- Goods selling (some kind of data, maybe exp) thief
91, Data1=3- Goods selling (some kind of data, maybe exp) hunter
94- leaving job
93- joining job
95- Making nickname
101- Thief/Mob kills trader pet

EventID = 22 -- Character Level Up

EventID = 9 -- spawn to an Area

global chat

Do you have full SQL code?

global chat

Do you have full SQL code?

Quote:

---

Originally Posted by loveme

global chat

Do you have full SQL code?

---

use sr_zor gs

Quote:

---

Originally Posted by Tazdingo

EventID = 20 - PvP Kill
EventID = 19 - PK/Guild War/Job Kill
EventID = 75 - GuildWar Declare
EventID = 77 - Guild War Win/Lose

---

EventID = 19 [Kill Event Winner]
EventID = 20 [Kill Event Loser ]

-- EventID = 23 [Skill Update]
-- EventID = 95 Update (NickName16)
-- EventID = 93 Join Thief Job
-- EventID = 1 and Data1 = 0 and Data2 = -450374574 || Char create?
-- EventID = 4 and Data1 = 0 and Data2 = -450374574 || LogIn
-- EventID = 6 and Data1 = 0 and Data2 = -450374574 || LogOut
-- EventID = 9 and Data1 = 0 and Data2 = 0 || Teleport
-- EventID = 211 and Data1 = 22865(Means RefCharID from _CharCos) and Data2 = 0 || Spawn Pet ( strDesc include PetName+RefCharID from _CharCos )
-- EventID = 212 and Data1 = 22865(Means RefCharID from _CharCos) and Data2 = 0 || DeSpawn Pet ( strDesc include PetName+RefCharID from _CharCos )
-- EventID = 217 and Data1 = 0 and Data2 = 0 || Pet wiederbeleben ( strDesc include COS_NAME "COS_P_WOLF_009" )

Code:

---

-- Item Log :
-- EventID : 0 || Operation 50 == Send Exchange Request [strDesc = CharName ]
-- EventID : 0 || Operation 52 == Exchange start [EventPos == Loc]
-- EventID : 0 || Operation 53 == Trade done or cancel !
-- EventID : 0 || Operation 54 == Add Item to Exchange Window !
-- EventID : 0 || Operation 55 == Remove Item from Exchange Window !
-- EventID : 0 || Operation 57 == Remove Trade Item from Inventory

---

i have much more but ya ...

Quote:

---

Originally Posted by Tazdingo

I will help the "shitheads". Why? Because you blame at this guy who try to help a little bit.

Finding Event ID's: (Easy Method)

Step 1: Create this table at log db

/****** Object: Table [dbo].[_EventDetect] Script Date: 12/19/2013 04:39:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_EventDetect](
[CharID] [int] NULL,
[EventID] [int] NULL,
[Data1] [int] NULL,
[Data2] [int] NULL,
[strPos] [varchar](64) NULL,
[Desc] [varchar](128) NULL,
[Date] [datetime] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Step 2: Modify this procedure

/****** Object: StoredProcedure [dbo].[_AddLogChar] Script Date: 12/19/2013 04:40:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER procedure [dbo].[_AddLogChar] @CharID int, @eventID tinyint, @data1 int, @data2 int,
@strPos varchar(64), @desc varchar(128)
as

insert _EventDetect values @CharID, @eventID, @data1, @data2, @strPos, @desc, GetDate())

Step 3: Log in at one character and start doing things at the game

Step 4: Check every time the table _EventDetect and you will see the event ids and so on.

.-.-.-.-.-.--.

Find event id's and post here what you found :D

Good luck at finding what u are loking for.

---

Testing