Free PVP kills fetching..

[PX2000]

Edit gs.exe on any hex editor
find this strings below

JuJak
HyeonMu
CheongRyong
BackHo
Kirin

replace all mentioned strings above to this "PVP" (no quote, carefull in bytes)

save and proceed to SHARD_DB editing

USE [SRO_VT_SHARD]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_CharFreePVP](
    [CharID] [int] NOT NULL,
    [Points] [int] NULL,
    [Kills] [int] NOT NULL,
    [Deaths] [int] NOT NULL,
    [LastKill] [varchar](12) NULL,
    [Date] [datetime] NULL,
    [CurChamp] [int] NULL,
 CONSTRAINT [PK__CharFreePVP] PRIMARY KEY CLUSTERED 
(
    [CharID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[_CharFreePVP] ADD  DEFAULT ((0)) FOR [Points]
GO

ALTER TABLE [dbo].[_CharFreePVP] ADD  DEFAULT ((0)) FOR [CurChamp]
GO

Now modify _AddNewChar

find

ROLLBACK TRANSACTION
RETURN -19
END

replace with

ROLLBACK TRANSACTION
RETURN -19
END

INSERT INTO _CharFreePVP VALUES (@NewCharID, 0, 0, 0, 'None', GETDATE(), 0)

next modify _AddLogChar and insert

--FREE PVP KILLS
if (@EventID=20 and @Desc like '%no job, Neutral, PVP%')
begin
declare @1strip varchar(120)
declare @1killername varchar(120)
declare @1killerid int
declare @1killcount int
declare @1target varchar(12)
declare @1targetkillcount int
declare @1targetkillpoint int
declare @1killercurchamp int
declare @1targetevent varchar(12)
declare @1targetcurscore varchar(12)

set @1strip = REPLACE(@Desc,'[My: no job, Neutral, PVP] [His(', '')
set @1killername = REPLACE(@1strip,'): no job, Neutral, PVP]', '')
set @1killerid = (select CharID from SRO_VT_SHARD.dbo._Char where CharName16=@1killername)
set @1killcount = (select Kills from SRO_VT_SHARD.dbo._CharFreePVP where CharID=@1killerid)
set @1target = (select CharName16 from SRO_VT_SHARD.dbo._Char where CharID=@CharID)
set @1targetkillcount = (select Kills from SRO_VT_SHARD.dbo._CharFreePVP where CharID=@CharID)
set @1targetkillpoint = (select Points from SRO_VT_SHARD.dbo._CharFreePVP where CharID=@CharID)
set @1killercurchamp = (select CurChamp from SRO_VT_SHARD.dbo._CharFreePVP where CharID=@1killerid)
set @1targetevent = (select CharName16 from SRO_VT_SHARD.dbo._Char where CharID=@CharID)
set @1targetcurscore = (select Points+Kills-Deaths from SRO_VT_SHARD.dbo._CharFreePVP where CharID=@CharID)

if(not exists(select * from SRO_VT_SHARD.dbo._CharFreePVP where CharID=@1killerid))
begin
insert SRO_VT_SHARD.dbo._CharFreePVP(CharID,Points,Kills,Deaths,LastKill,[Date])
values (@1killerid, 1, 1, 0, @1target, GETDATE())
end
else
begin
if (@1killercurchamp != 1)
begin
if (@1targetcurscore >= 1)
begin
update SRO_VT_SHARD.dbo._CharFreePVP set Kills=Kills+1, LastKill=@1target, [Date]=GETDATE() where CharID=@1killerid
end
else
begin
update SRO_VT_SHARD.dbo._CharFreePVP set Points=Points+1, Kills=Kills+1, LastKill=@1target, [Date]=GETDATE() where CharID=@1killerid
end
end
else
begin
update SRO_VT_SHARD.dbo._CharFreePVP set Kills=Kills+1, LastKill=@1target, [Date]=GETDATE() where CharID=@1killerid
end

--if (@1targetevent = '[GM]PX2000')
--begin
--update SRO_VT_SHARD.dbo._CharFreePVP set Points=Points+10, Kills=Kills+1, LastKill=@1targetevent, [Date]=GETDATE() where CharID=@1killerid
--insert into _AutoNotice (Sent, Message, Date, MsgType)
--values (0, '['+@1killername+'] killed [GM]PX2000', GETDATE(), 99)
--end
end

if(not exists(select * from SRO_VT_SHARD.dbo._CharFreePVP where CharID=@CharID))
begin
insert SRO_VT_SHARD.dbo._CharFreePVP(CharID,Points,Kills,Deaths,LastKill,[Date])
values (@CharID, 0, 0, 1, 'None', GETDATE())
end
else
begin
if (@1targetkillpoint != 0)
begin
update SRO_VT_SHARD.dbo._CharFreePVP set Points=Points-1, [Date]=GETDATE() where CharID=@CharID
end
update SRO_VT_SHARD.dbo._CharFreePVP set Deaths=Deaths+1, [Date]=GETDATE() where CharID=@CharID
end

--clean the logs
delete from _LogEventChar where CharID=@CharID and EventID=20 and strDesc like '%no job, Neutral, PVP%'
end
--You can modify this codes in you want!

Done!!

if you want to give prizes
make with your own!

[MentaL]

[loveme]

first :

ROLLBACK TRANSACTION
RETURN -19
END

INSERT INTO _CharFreePVP VALUES (@NewCharID, 0, 0, 0, 'None', GETDATE())

later querty

[Csarmy]

ROLLBACK TRANSACTION
RETURN -19
END
INSERT INTO _CharFreePVP VALUES (@NewCharID, 0, 0, 0, 'None', GETDATE())
----
Msg 213, Level 16, State 1, Procedure _AddNewChar, Line 267
Column name or number of supplied values does not match table definition.

[OutOfMemory]

can you release how to get global chat and record it in table?

[PX2000]

ROLLBACK TRANSACTION
RETURN -19
END
INSERT INTO _CharFreePVP VALUES (@NewCharID, 0, 0, 0, 'None', GETDATE())
----
Msg 213, Level 16, State 1, Procedure _AddNewChar, Line 267
Column name or number of supplied values does not match table definition.

INSERT INTO _CharFreePVP VALUES (@NewCharID, 0, 0, 0, 'None', GETDATE(), 0)

[CoderWaxy]

i can create reward with scroll :D but i cant do it auto matic only i can do in your query i have to edit :D

[Csarmy]

INSERT INTO _CharFreePVP VALUES (@NewCharID, 0, 0, 0, 'None', GETDATE(), 0)

Reward ? Silk, Gift silk or coin ?

[Madelyn]

Looking the procedure: i see a table that i think i have missing "_AutoNotice"
how work it or can share it with procedure?

[Caosfox]

_autonotice is commented, so is not need

[herolord46]

is it true ?ı am new hex :S

[Madelyn]

_autonotice is commented, so is not need

I know it but.. this table i haven on my DB.
So this exist really and work or what?
Share this if u have.

[Caosfox]

i bet is the "notice" table for noticewriter.exe

[ManagerPlay]

Thanx

[ZiCO]

PX2000 , get online on skype asap.

[fabien31]

Hello,

Can you tell me how i can't Prevent abuse of this script by adding time check between last kill and new kill ?

Thanks you for help