[REQUEST]Shared Kills

04/07/2015 21:14 AuronCrow#1
Hello guys, i'm making this post after i looked around all epvp for it and nothing, i'm just searching a script or smth for make Shared kills in the same account, for exapmle if i got 5 toons in 1 account, when i'll kill a dark/light with one of them, all the toons will get the kill, do you know how can i do it?
04/07/2015 21:51 SnickQ#2
[Only registered and activated users can see links. Click Here To Register...]
04/11/2015 06:12 AroraBleu#3
USE [PS_GameData]
GO
/ Object: Trigger [dbo].[PvPSharedRank] Script Date: 1/9/2015 12:12:32 AM /
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




CREATE trigger [dbo].[PvPSharedRank]
on [PS_GameData].[dbo].[Chars]
after update
as
IF (UPDATE (k1))
begin
declare @oldk1 int
declare @newk1 int
declare @MaxK1 int
declare @NewUserUID INT
DECLARE @CharID INT
Declare @addkill int

set @oldk1 = (select k1 from deleted)
set @newk1 = (select k1 from inserted)
SET @CharID = (select CHARID from inserted) -- gets char id from new inserted row
set @newUserUID = (SELECT USERUID FROM PS_gameData.dbo.chars WHERE charID =@charID) -- sets newuserid as the id to look for
set @Maxk1 = (select MAX(k1) FROM dbo.chars where UserUID = @newUserUID) -- gets max kills from a account
set @Addkill = @newk1 - @oldk1

if @oldk1<@newk1
begin
update PS_userdata.dbo.users_master
set point=point+0
from PS_userdata.dbo.users_master m,inserted i where m.userUID=i.useruid
update PS_GAMEDATA.dbo.CHARS
set K1 = @MAXK1
from PS_GAMEDATA.dbo.CHARS M,inserted i where M.userUID=i.useruid
END
end
04/11/2015 17:11 italo.sanchez#4
:confused:
Quote:
Originally Posted by AroraBleu View Post
USE [PS_GameData]
GO
/ Object: Trigger [dbo].[PvPSharedRank] Script Date: 1/9/2015 12:12:32 AM /
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE trigger [dbo].[PvPSharedRank]
on [PS_GameData].[dbo].[Chars]
after update
as
IF (UPDATE (k1))
begin
declare @oldk1 int
declare @newk1 int
declare @MaxK1 int
declare @NewUserUID INT
DECLARE @CharID INT
Declare @addkill int

set @oldk1 = (select k1 from deleted)
set @newk1 = (select k1 from inserted)
SET @CharID = (select CHARID from inserted) -- gets char id from new inserted row
set @newUserUID = (SELECT USERUID FROM PS_gameData.dbo.chars WHERE charID =@charID) -- sets newuserid as the id to look for
set @Maxk1 = (select MAX(k1) FROM dbo.chars where UserUID = @newUserUID) -- gets max kills from a account
set @Addkill = @newk1 - @oldk1

if @oldk1<@newk1
begin
update PS_userdata.dbo.users_master
set point=point+0
from PS_userdata.dbo.users_master m,inserted i where m.userUID=i.useruid
update PS_GAMEDATA.dbo.CHARS
set K1 = @MAXK1
from PS_GAMEDATA.dbo.CHARS M,inserted i where M.userUID=i.useruid
END
end
Error for me, i use sql 2008 r2
PRINT:
05/10/2015 02:07 Mark.Teal1982#5
that's because the trigger was created by me and it was builtin sql 2014 version of mssql but thanks for sharing it I compared it to mine and the only difference this one has create and my has alter for the trigger but every word and letter in it is the same so I know its mine there is 2 parts to it also not just one you need the createchar part which is part 2 of 2 otherwise your new chars will start with 0 kills next time please don't share other peoples work with out asking also I posted both parts in the Shaiya release section for everyone to use


even the set @Addkill = @newk1 - @oldk1 is still there from when I use to have 3 parts to it so I know its my coding

here is the link with both parts 1 and 2

[Only registered and activated users can see links. Click Here To Register...]
07/21/2016 18:03 GMCronus#6
i there any way to change this to effect same lvl only? becouse in lvl 30 with a lvl 70-80 or 90 kills that run for a vile make lvl 30 in a way stupid to have. 30 is for lvl linked/farming ppl. if some wthen have a shitloads of kills on top of that with low stats it will kill it..

why i ask..
07/28/2016 17:49 R00G3R#7
Please, at least make an attempt to find it yourself. It's just as simple as typing in, "Shared Kills" in the search box.