The same number of kills to characters

[bruno9280]

How to get all characters on the account has the same amount of kill?

[nubness]

So you release a... I don't even know what to call it... a that has some malicious, yet dumb, code in it, and then come asking for help ?

[bruno9280]

eu não disse kill_count e sim a quantidade de kills para os chars de uma só conta

[SnickQ]

I try something like that to update all k1:

Declare @CharID varchar(30) = (Select top 1 CharID from PS_GameData.dbo.chars where CharName='123')
Declare @UserID varchar(12) =(select top 1 UserID from PS_GameData.dbo.chars where CharID =@CharID)

Declare @Slot1 int =(Select top 1 k1 From PS_GameData.dbo.chars where UserID =@UserID and slot ='0' and del ='0')
Declare @Slot2 int =(Select top 1 k1 From PS_GameData.dbo.chars where UserID =@UserID and slot ='1' and del ='0')
Declare @Slot3 int =(Select top 1 k1 From PS_GameData.dbo.chars where UserID =@UserID and slot ='2' and del ='0')
Declare @Slot4 int =(Select top 1 k1 From PS_GameData.dbo.chars where UserID =@UserID and slot ='3' and del ='0')
Declare @Slot5 int =(Select top 1 k1 From PS_GameData.dbo.chars where UserID =@UserID and slot ='4' and del ='0')

Declare @S1 int =(Select top 1 k2 From PS_GameData.dbo.chars where UserID =@UserID and slot ='0' and del ='0')
Declare @S2 int =(Select top 1 k2 From PS_GameData.dbo.chars where UserID =@UserID and slot ='1' and del ='0')
Declare @S3 int =(Select top 1 k2 From PS_GameData.dbo.chars where UserID =@UserID and slot ='2' and del ='0')
Declare @S4 int =(Select top 1 k2 From PS_GameData.dbo.chars where UserID =@UserID and slot ='3' and del ='0')
Declare @S5 int =(Select top 1 k2 From PS_GameData.dbo.chars where UserID =@UserID and slot ='4' and del ='0' )

Declare @Toon1 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserID =@UserID and slot ='0' and del ='0')
Declare @Toon2 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserID =@UserID and slot ='1' and del ='0')
Declare @Toon3 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserID =@UserID and slot ='2' and del ='0')
Declare @Toon4 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserID =@UserID and slot ='3' and del ='0')
Declare @Toon5 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserID =@UserID and slot ='4' and del ='0')

update PS_GameData.dbo.chars
Set K1 = @Slot1+@Slot2+@Slot3+@Slot4+@Slot5
Where CharID=@CharID
PRINT 'Update 1'

update PS_GameData.dbo.chars
Set K2 = @S1+@S2+@S3+@S4+@S5 
Where CharID=@CharID
PRINT 'Update 2'

update PS_GameData.dbo.chars
Set K1 = '0'
Where CharID=@Toon1
PRINT 'Update 3'
update PS_GameData.dbo.chars
Set K1 = '0'
Where CharID=@Toon2
PRINT 'Update 4'
update PS_GameData.dbo.chars
Set K1 = '0'
Where CharID=@Toon3
PRINT 'Update 5'
update PS_GameData.dbo.chars
Set K1 = '0'
Where CharID=@Toon4
PRINT 'Update 6'
update PS_GameData.dbo.chars
Set K1 = '0'
Where CharID=@Toon5
PRINT 'Update 7'
update PS_GameData.dbo.chars
Set K2 = '0'
Where CharID=@Toon1
PRINT 'Update 8'
update PS_GameData.dbo.chars
Set K2 = '0'
Where CharID=@Toon2
PRINT 'Update 9'
update PS_GameData.dbo.chars
Set K2 = '0'
Where CharID=@Toon3
PRINT 'Update 10'
update PS_GameData.dbo.chars
Set K2 = '0'
Where CharID=@Toon4
PRINT 'Update 11'
update PS_GameData.dbo.chars
Set K2 = '0'
Where CharID=@Toon5
PRINT 'Update 12'
update PS_GameData.dbo.chars
Set K1 = @Slot1+@Slot2+@Slot3+@Slot4+@Slot5
Where CharID=@CharID
PRINT 'Update 1a'
update PS_GameData.dbo.chars
Set K2 = @S1+@S2+@S3+@S4+@S5
Where CharID=@CharID
PRINT 'Update 2a'

But have a problem with empty slot in account ;/

Msg 515, Level 16, State 2, Line 22
Cannot insert the value NULL into column 'K1', table 'PS_GameData.dbo.Chars'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
Update 1
Msg 515, Level 16, State 2, Line 27
Cannot insert the value NULL into column 'K2', table 'PS_GameData.dbo.Chars'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
Update 2

[sominus]

It should be something like Get the kills from the toon with most kills in the account, add the 'current kill', put the result to all active toons. Also check if slot is not empty (has a toon and that toon is not dead/deleted).

I still think this is some form of 'legal padding'.
Example: You have a 80 toon with 50.000 kills, you make a new toon for pvp 30, it will have 50.000 kills already, you go to the vet manager and get more stats without killing a single enemy.

[[ADM]SpyRow]

Any news about this "project" how to make it work ?

[wallerus]

Good luck with this .

I'd also say, be aware of what sominus mentions with Vet Manager, although it is possible to disable the Vet Manager for lower levels so you don't run into the problem of huge rank level 30s with a lot of PvP stats.