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

[RenePunik]

Re: "Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWrite

Error when executing query _AddLogChar Stored producer

 

[LethalSRO]

Re: "Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWrite

thanks

 

[asker7r]

Re: "Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWrite

thanksss

 

[Razor1337]

Re: "Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWrite

Epic release keep it up!

 

[Muhab Ashraf]

Re: "Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWrite

hey @Witchy Moo , i'm working on 2005 i edit the _AddLogChar but i still can't fix it ! i get many errors also edited declares as u said
can u take a look and try to fix it or just tell me how !
here is my error msgs
Msg 102, Level 15, State 1, Procedure _AddLogChar, Line 45
Incorrect syntax near '@killername'.
Msg 102, Level 15, State 1, Procedure _AddLogChar, Line 46
Incorrect syntax near '@killername'.
Msg 102, Level 15, State 1, Procedure _AddLogChar, Line 46
Incorrect syntax near 'REVERSE'.
Msg 102, Level 15, State 1, Procedure _AddLogChar, Line 50
Incorrect syntax near '@desc'.
Msg 156, Level 15, State 1, Procedure _AddLogChar, Line 52
Incorrect syntax near the keyword 'WHEN'.
Msg 137, Level 15, State 2, Procedure _AddLogChar, Line 66
Must declare the scalar variable "@jobType".
Msg 102, Level 15, State 1, Procedure _AddLogChar, Line 68
Incorrect syntax near ')'.
Msg 102, Level 15, State 1, Procedure _AddLogChar, Line 71
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Procedure _AddLogChar, Line 72
Incorrect syntax near '('.
Msg 137, Level 15, State 2, Procedure _AddLogChar, Line 73
Must declare the scalar variable "@killerNickName".
Msg 137, Level 15, State 2, Procedure _AddLogChar, Line 80
Must declare the scalar variable "@jobType".
Msg 156, Level 15, State 1, Procedure _AddLogChar, Line 84
Incorrect syntax near the keyword 'END'.


the full _AddLogChar in attachment

Fixed Thanks

 

[tschulian]

Re: "Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWrite

hm..... cant get trough it.

 

[hancook1st]

Re: "Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWrite

i have this problem can anyone help???

 

[ilowe]

Re: "Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWrite

How to level restrictions? Example Lvl 95 + Killed

 

[ilowe]

Re: "Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWrite

How could buffer instead of goods?

 

[Eroticus]

Re: "Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWrite

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

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 .

IF (@EventID = 20) -- PVP
BEGIN
IF   [USER=275999]des[/USER]c LIKE '%Trader, Neutral, no freebattle team%' -- Trader
OR  [USER=275999]des[/USER]c LIKE '%Hunter, Neutral, no freebattle team%' -- Hunter
OR  [USER=275999]des[/USER]c LIKE '%Robber, Neutral, no freebattle team%' -- Thief
OR  [USER=275999]des[/USER]c like '%no job, Neutral, %no job, Neutral%' -- Free PVP
)
BEGIN
-- Get killer name
DECLARE  [USER=434304]killername[/USER] VARCHAR(512) =  [USER=275999]des[/USER]c
DECLARE  [USER=803511]killeri[/USER]D INT = 0
SELECT  [USER=434304]killername[/USER] = REPLACE  [USER=434304]killername[/USER], LEFT  [USER=434304]killername[/USER], CHARINDEX('(',  [USER=434304]killername[/USER])), '')
SELECT  [USER=434304]killername[/USER] = REPLACE  [USER=434304]killername[/USER], RIGHT  [USER=434304]killername[/USER], CHARINDEX(')', REVERSE  [USER=434304]killername[/USER]))), '')
SELECT  [USER=803511]killeri[/USER]D = CharID FROM [eroticuskingz0rDB].[dbo].[_Char] WHERE CharName16 =  [USER=434304]killername[/USER]
-- Get job type
DECLARE  [USER=768752]job[/USER]String VARCHAR(10) = LTRIM(RTRIM(SUBSTRING  [USER=275999]des[/USER]c, 5, 7)))
DECLARE  [USER=768752]job[/USER]Type INT = CASE
WHEN  [USER=768752]job[/USER]String LIKE 'Trader' THEN 1
WHEN  [USER=768752]job[/USER]String LIKE 'Robber' THEN 2
WHEN  [USER=768752]job[/USER]String LIKE 'Hunter' THEN 3
ELSE 0 END
-- Delete original log
DELETE FROM _LogEventChar WHERE CharID =  [USER=551894]Char[/USER]ID 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  [USER=275999]des[/USER]c like '%no job, Neutral, %no job, Neutral%')
-- Get additional info for notice message
DECLARE  [USER=551894]Char[/USER]Name VARCHAR(64) = (SELECT CharName16 FROM [eroticuskingz0rDB].[dbo].[_Char] WHERE CharID =  [USER=551894]Char[/USER]ID)
DECLARE  [USER=768752]job[/USER]Desc VARCHAR(32) = CASE WHEN  [USER=768752]job[/USER]Type BETWEEN 1 AND 3 THEN 'Job Conflict' ELSE 'Free PVP' END
DECLARE @strDesc VARCHAR(512)
IF   [USER=768752]job[/USER]String LIKE 'Trader' OR  [USER=768752]job[/USER]String LIKE 'Robber' OR  [USER=768752]job[/USER]String LIKE 'Hunter')
BEGIN
-- If it's a Job Kill, then write character nicknames
DECLARE  [USER=770918]killer[/USER]NickName VARCHAR(64) = (SELECT NickName16 FROM [eroticuskingz0rDB].[dbo].[_CharNickNameList] WHERE CharID =  [USER=803511]killeri[/USER]D)
DECLARE  [USER=1333392005]Charnic[/USER]kName VARCHAR(64) = (SELECT NickName16 FROM [eroticuskingz0rDB].[dbo].[_CharNickNameList] WHERE CharID =  [USER=551894]Char[/USER]ID)
SET @strDesc = '[' +  [USER=770918]killer[/USER]NickName + '] has just killed [' +  [USER=1333392005]Charnic[/USER]kName + '] in [' +  [USER=768752]job[/USER]Desc + '] mode on [' + CONVERT(NVARCHAR(30), GETDATE(), 0) + ']'
END
ELSE BEGIN
-- If it's normal PVP Kill, write real character names
SET @strDesc = '[' +  [USER=434304]killername[/USER] + '] has just killed [' +  [USER=551894]Char[/USER]Name + '] in [' +  [USER=768752]job[/USER]Desc + '] mode on [' + CONVERT(NVARCHAR(30), GETDATE(), 0) + ']'
END
-- Update the log
INSERT INTO _LogEventPVP VALUES (0,  [USER=803511]killeri[/USER]D,  [USER=551894]Char[/USER]ID,  [USER=768752]job[/USER]Type, GETDATE(), @strPos, @strDesc)
-- Flag notice if it's not sent more than 5 minutes
UPDATE _LogEventPVP SET isSent = 1 WHERE CharID =  [USER=551894]Char[/USER]ID AND EventTime < DATEADD(MINUTE, -5, GETDATE())
END
END

 

[infor]

Re: "Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWrite

help me to activate it on my server

 

[DarSage]

Re: "Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWrite

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

 

[infor]

Re: "Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWrite

help please error ejecute code sro_vt_log

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

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 .

IF (@EventID = 20) -- PVP
BEGIN
IF   [USER=275999]des[/USER]c LIKE '%Trader, Neutral, no freebattle team%' -- Trader
OR  [USER=275999]des[/USER]c LIKE '%Hunter, Neutral, no freebattle team%' -- Hunter
OR  [USER=275999]des[/USER]c LIKE '%Robber, Neutral, no freebattle team%' -- Thief
OR  [USER=275999]des[/USER]c like '%no job, Neutral, %no job, Neutral%' -- Free PVP
)
BEGIN
-- Get killer name
DECLARE  [USER=434304]killername[/USER] VARCHAR(512) =  [USER=275999]des[/USER]c
DECLARE  [USER=803511]killeri[/USER]D INT = 0
SELECT  [USER=434304]killername[/USER] = REPLACE  [USER=434304]killername[/USER], LEFT  [USER=434304]killername[/USER], CHARINDEX('(',  [USER=434304]killername[/USER])), '')
SELECT  [USER=434304]killername[/USER] = REPLACE  [USER=434304]killername[/USER], RIGHT  [USER=434304]killername[/USER], CHARINDEX(')', REVERSE  [USER=434304]killername[/USER]))), '')
SELECT  [USER=803511]killeri[/USER]D = CharID FROM [eroticuskingz0rDB].[dbo].[_Char] WHERE CharName16 =  [USER=434304]killername[/USER]
-- Get job type
DECLARE  [USER=768752]job[/USER]String VARCHAR(10) = LTRIM(RTRIM(SUBSTRING  [USER=275999]des[/USER]c, 5, 7)))
DECLARE  [USER=768752]job[/USER]Type INT = CASE
WHEN  [USER=768752]job[/USER]String LIKE 'Trader' THEN 1
WHEN  [USER=768752]job[/USER]String LIKE 'Robber' THEN 2
WHEN  [USER=768752]job[/USER]String LIKE 'Hunter' THEN 3
ELSE 0 END
-- Delete original log
DELETE FROM _LogEventChar WHERE CharID =  [USER=551894]Char[/USER]ID 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  [USER=275999]des[/USER]c like '%no job, Neutral, %no job, Neutral%')
-- Get additional info for notice message
DECLARE  [USER=551894]Char[/USER]Name VARCHAR(64) = (SELECT CharName16 FROM [eroticuskingz0rDB].[dbo].[_Char] WHERE CharID =  [USER=551894]Char[/USER]ID)
DECLARE  [USER=768752]job[/USER]Desc VARCHAR(32) = CASE WHEN  [USER=768752]job[/USER]Type BETWEEN 1 AND 3 THEN 'Job Conflict' ELSE 'Free PVP' END
DECLARE @strDesc VARCHAR(512)
IF   [USER=768752]job[/USER]String LIKE 'Trader' OR  [USER=768752]job[/USER]String LIKE 'Robber' OR  [USER=768752]job[/USER]String LIKE 'Hunter')
BEGIN
-- If it's a Job Kill, then write character nicknames
DECLARE  [USER=770918]killer[/USER]NickName VARCHAR(64) = (SELECT NickName16 FROM [eroticuskingz0rDB].[dbo].[_CharNickNameList] WHERE CharID =  [USER=803511]killeri[/USER]D)
DECLARE  [USER=1333392005]Charnic[/USER]kName VARCHAR(64) = (SELECT NickName16 FROM [eroticuskingz0rDB].[dbo].[_CharNickNameList] WHERE CharID =  [USER=551894]Char[/USER]ID)
SET @strDesc = '[' +  [USER=770918]killer[/USER]NickName + '] has just killed [' +  [USER=1333392005]Charnic[/USER]kName + '] in [' +  [USER=768752]job[/USER]Desc + '] mode on [' + CONVERT(NVARCHAR(30), GETDATE(), 0) + ']'
END
ELSE BEGIN
-- If it's normal PVP Kill, write real character names
SET @strDesc = '[' +  [USER=434304]killername[/USER] + '] has just killed [' +  [USER=551894]Char[/USER]Name + '] in [' +  [USER=768752]job[/USER]Desc + '] mode on [' + CONVERT(NVARCHAR(30), GETDATE(), 0) + ']'
END
-- Update the log
INSERT INTO _LogEventPVP VALUES (0,  [USER=803511]killeri[/USER]D,  [USER=551894]Char[/USER]ID,  [USER=768752]job[/USER]Type, GETDATE(), @strPos, @strDesc)
-- Flag notice if it's not sent more than 5 minutes
UPDATE _LogEventPVP SET isSent = 1 WHERE CharID =  [USER=551894]Char[/USER]ID AND EventTime < DATEADD(MINUTE, -5, GETDATE())
END
END

help please error ejecute code sro_vt_log

 

[Eroticus]

[Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWrite



sql code

You must be registered to see links

 

[foremus95]

Re: "Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWrite

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

 

[hellangel2]

Re: "Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWrite

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 .

REMOVED

 

[TychusFindlay]

Re: "Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWrite

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

View attachment workingcode.txt