"Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWriter!

hm..... cant get trough it.

i have this problem can anyone help???
http://im73.gulfup.com/Qaomg2.png

How to level restrictions? Example Lvl 95 + Killed

How could buffer instead of goods?

To everyone who get many sql errors and his brain has allot of blue screens :D

this is one is working just change eroticuskingz0r to SRO_VT_SHARD or your database name

CRTL +H > SEARCH "eroticuskingz0r"

Change to "MYDATABASENAME" (SRO_VT_SHARD)


add this script after last END .

Code:

---

IF (@EventID = 20) -- PVP
BEGIN
IF  @desc LIKE '%Trader, Neutral, no freebattle team%' -- Trader
OR  @desc LIKE '%Hunter, Neutral, no freebattle team%' -- Hunter
OR  @desc LIKE '%Robber, Neutral, no freebattle team%' -- Thief
OR  @desc like '%no job, Neutral, %no job, Neutral%' -- Free PVP
)
BEGIN
-- Get killer name
DECLARE  @killername VARCHAR(512) =  @desc
DECLARE  @killeriD INT = 0
SELECT  @killername = REPLACE  @killername, LEFT  @killername, CHARINDEX('(',  @killername)), '')
SELECT  @killername = REPLACE  @killername, RIGHT  @killername, CHARINDEX(')', REVERSE  @killername))), '')
SELECT  @killeriD = CharID FROM [eroticuskingz0rDB].[dbo].[_Char] WHERE CharName16 =  @killername
-- Get job type
DECLARE  @jobString VARCHAR(10) = LTRIM(RTRIM(SUBSTRING  @desc, 5, 7)))
DECLARE  @jobType INT = CASE
WHEN  @jobString LIKE 'Trader' THEN 1
WHEN  @jobString LIKE 'Robber' THEN 2
WHEN  @jobString LIKE 'Hunter' THEN 3
ELSE 0 END
-- Delete original log
DELETE FROM _LogEventChar WHERE CharID =  @CharID AND EventID = 20
AND (strDesc LIKE '%Trader, Neutral, no freebattle team%'
OR strDesc LIKE '%Hunter, Neutral, no freebattle team%'
OR strDesc LIKE '%Robber, Neutral, no freebattle team%'
OR  @desc like '%no job, Neutral, %no job, Neutral%')
-- Get additional info for notice message
DECLARE  @CharName VARCHAR(64) = (SELECT CharName16 FROM [eroticuskingz0rDB].[dbo].[_Char] WHERE CharID =  @CharID)
DECLARE  @jobDesc VARCHAR(32) = CASE WHEN  @jobType BETWEEN 1 AND 3 THEN 'Job Conflict' ELSE 'Free PVP' END
DECLARE @strDesc VARCHAR(512)
IF  @jobString LIKE 'Trader' OR  @jobString LIKE 'Robber' OR  @jobString LIKE 'Hunter')
BEGIN
-- If it's a Job Kill, then write character nicknames
DECLARE  @killerNickName VARCHAR(64) = (SELECT NickName16 FROM [eroticuskingz0rDB].[dbo].[_CharNickNameList] WHERE CharID =  @killeriD)
DECLARE  @CharnickName VARCHAR(64) = (SELECT NickName16 FROM [eroticuskingz0rDB].[dbo].[_CharNickNameList] WHERE CharID =  @CharID)
SET @strDesc = '[' +  @killerNickName + '] has just killed [' +  @CharnickName + '] in [' +  @jobDesc + '] mode on [' + CONVERT(NVARCHAR(30), GETDATE(), 0) + ']'
END
ELSE BEGIN
-- If it's normal PVP Kill, write real character names
SET @strDesc = '[' +  @killername + '] has just killed [' +  @CharName + '] in [' +  @jobDesc + '] mode on [' + CONVERT(NVARCHAR(30), GETDATE(), 0) + ']'
END
-- Update the log
INSERT INTO _LogEventPVP VALUES (0,  @killeriD,  @CharID,  @jobType, GETDATE(), @strPos, @strDesc)
-- Flag notice if it's not sent more than 5 minutes
UPDATE _LogEventPVP SET isSent = 1 WHERE CharID =  @CharID AND EventTime < DATEADD(MINUTE, -5, GETDATE())
END
END

---

http://i.imgur.com/D9LoDcn.png

help me to activate it on my server

them'm honest I'm a little rough with this part of Add_Charlog that more should I add and where in the DB
someone can take their time and explain well .. everything fits my DB but kill 10 times in the game is not active and not recorded in logeventchar

help please error ejecute code sro_vt_log

- - - Updated - - -

Quote:

---

Originally Posted by Eroticus

To everyone who get many sql errors and his brain has allot of blue screens :D

this is one is working just change eroticuskingz0r to SRO_VT_SHARD or your database name

CRTL +H > SEARCH "eroticuskingz0r"

Change to "MYDATABASENAME" (SRO_VT_SHARD)


add this script after last END .

Code:

---

IF (@EventID = 20) -- PVP
BEGIN
IF  @desc LIKE '%Trader, Neutral, no freebattle team%' -- Trader
OR  @desc LIKE '%Hunter, Neutral, no freebattle team%' -- Hunter
OR  @desc LIKE '%Robber, Neutral, no freebattle team%' -- Thief
OR  @desc like '%no job, Neutral, %no job, Neutral%' -- Free PVP
)
BEGIN
-- Get killer name
DECLARE  @killername VARCHAR(512) =  @desc
DECLARE  @killeriD INT = 0
SELECT  @killername = REPLACE  @killername, LEFT  @killername, CHARINDEX('(',  @killername)), '')
SELECT  @killername = REPLACE  @killername, RIGHT  @killername, CHARINDEX(')', REVERSE  @killername))), '')
SELECT  @killeriD = CharID FROM [eroticuskingz0rDB].[dbo].[_Char] WHERE CharName16 =  @killername
-- Get job type
DECLARE  @jobString VARCHAR(10) = LTRIM(RTRIM(SUBSTRING  @desc, 5, 7)))
DECLARE  @jobType INT = CASE
WHEN  @jobString LIKE 'Trader' THEN 1
WHEN  @jobString LIKE 'Robber' THEN 2
WHEN  @jobString LIKE 'Hunter' THEN 3
ELSE 0 END
-- Delete original log
DELETE FROM _LogEventChar WHERE CharID =  @CharID AND EventID = 20
AND (strDesc LIKE '%Trader, Neutral, no freebattle team%'
OR strDesc LIKE '%Hunter, Neutral, no freebattle team%'
OR strDesc LIKE '%Robber, Neutral, no freebattle team%'
OR  @desc like '%no job, Neutral, %no job, Neutral%')
-- Get additional info for notice message
DECLARE  @CharName VARCHAR(64) = (SELECT CharName16 FROM [eroticuskingz0rDB].[dbo].[_Char] WHERE CharID =  @CharID)
DECLARE  @jobDesc VARCHAR(32) = CASE WHEN  @jobType BETWEEN 1 AND 3 THEN 'Job Conflict' ELSE 'Free PVP' END
DECLARE @strDesc VARCHAR(512)
IF  @jobString LIKE 'Trader' OR  @jobString LIKE 'Robber' OR  @jobString LIKE 'Hunter')
BEGIN
-- If it's a Job Kill, then write character nicknames
DECLARE  @killerNickName VARCHAR(64) = (SELECT NickName16 FROM [eroticuskingz0rDB].[dbo].[_CharNickNameList] WHERE CharID =  @killeriD)
DECLARE  @CharnickName VARCHAR(64) = (SELECT NickName16 FROM [eroticuskingz0rDB].[dbo].[_CharNickNameList] WHERE CharID =  @CharID)
SET @strDesc = '[' +  @killerNickName + '] has just killed [' +  @CharnickName + '] in [' +  @jobDesc + '] mode on [' + CONVERT(NVARCHAR(30), GETDATE(), 0) + ']'
END
ELSE BEGIN
-- If it's normal PVP Kill, write real character names
SET @strDesc = '[' +  @killername + '] has just killed [' +  @CharName + '] in [' +  @jobDesc + '] mode on [' + CONVERT(NVARCHAR(30), GETDATE(), 0) + ']'
END
-- Update the log
INSERT INTO _LogEventPVP VALUES (0,  @killeriD,  @CharID,  @jobType, GETDATE(), @strPos, @strDesc)
-- Flag notice if it's not sent more than 5 minutes
UPDATE _LogEventPVP SET isSent = 1 WHERE CharID =  @CharID AND EventTime < DATEADD(MINUTE, -5, GETDATE())
END
END

---

http://i.imgur.com/D9LoDcn.png

---

help please error ejecute code sro_vt_log

https://www.youtube.com/watch?v=QItGsW8KBCM

sql code

https://onedrive.live.com/?cid=f77bb...FEC5D16%212934

Hi, i want to send the notice for only specific player, for example who are in job mode. How can i do that

Thank You . Based on your Topic Iam make a PVP Rank .. Now my DB can count Kills, Killed and Killer in PVP MODE .. ALOT TY ..

now going to work and make a php code to count it in Rank to Web .

http://s2.postimg.org/quctw2je1/rank.png

In case you need the working code (to add after the last end)

Attachment 163470