Shaiya AP per x50 kill

[ShaiyaIwanttolearn]

Hello would like to know if it is possible to set for players to receive AP, after a certain amount of kills, for example every 50 Kills during PvP, the player automatically receives 500 AP without cheating. I tried to do something using an example of Ap per kills, but to no avail.

[[GameAdvisor]Finn]

Originally Posted by ShaiyaIwanttolearn

Hello would like to know if it is possible to set for players to receive AP, after a certain amount of kills, for example every 50 Kills during PvP, the player automatically receives 500 AP without cheating. I tried to do something using an example of Ap per kills, but to no avail.

USE [PS_GameData]
GO

/****** Object: Trigger [dbo].[PointsForKills] Script Date: 09/27/2012 11:57:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




create trigger [dbo].[PointsForKills]
on [PS_GameData].[dbo].[Chars]
after update
as
IF (UPDATE (k1))
begin
declare @1 int
declare @1 int
set @1 = (select k1 from deleted)
set @1 = (select k1 from inserted)
if @1 @1
begin
update PS_userdata.dbo.users_master
set point=point+5
from PS_userdata.dbo.users_master m,inserted i where m.userUID=i.useruid
end
/*if I wanted to do 500 points per x000 kills I would do something like this

if (convert ( varchar (5) @1) like '%000')
begin
update PS_userdata.dbo.users_master
set point=point+500
from PS_userdata.dbo.users_master m,inserted i where m.userUID=i.useruid
end
This would give 500 points to every k1 value that is "like" 1000 or 2000 or 3000 etc, not just 1000 kills
*/
end

GO

[ShaiyaIwanttolearn]

Originally Posted by [GameAdvisor]Finn

USE [PS_GameData]
GO

/****** Object: Trigger [dbo].[PointsForKills] Script Date: 09/27/2012 11:57:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




create trigger [dbo].[PointsForKills]
on [PS_GameData].[dbo].[Chars]
after update
as
IF (UPDATE (k1))
begin
declare @1 int
declare @1 int
set @1 = (select k1 from deleted)
set @1 = (select k1 from inserted)
if @1 @1
begin
update PS_userdata.dbo.users_master
set point=point+5
from PS_userdata.dbo.users_master m,inserted i where m.userUID=i.useruid
end
/*if I wanted to do 500 points per x000 kills I would do something like this

if (convert ( varchar (5) @1) like '%000')
begin
update PS_userdata.dbo.users_master
set point=point+500
from PS_userdata.dbo.users_master m,inserted i where m.userUID=i.useruid
end
This would give 500 points to every k1 value that is "like" 1000 or 2000 or 3000 etc, not just 1000 kills
*/
end

GO

that's not what i'm trying to do, let's suppose every 50 kills in pvp the player gets 500 AP, when he completes 50 kills the amount is left and the player would have to kill 50 kills to get more points

[[GameAdvisor]Finn]

Originally Posted by ShaiyaIwanttolearn

that's not what i'm trying to do, let's suppose every 50 kills in pvp the player gets 500 AP, when he completes 50 kills the amount is left and the player would have to kill 50 kills to get more points

try to read this part

 Spoiler

/*if I wanted to do 500 points per x000 kills I would do something like this

if (convert ( varchar (5) @1) like '%000')
begin
update PS_userdata.dbo.users_master
set point=point+500
from PS_userdata.dbo.users_master m,inserted i where m.userUID=i.useruid
end
This would give 500 points to every k1 value that is "like" 1000 or 2000 or 3000 etc, not just 1000 kills
*/

[ShaiyaIwanttolearn]

Originally Posted by failpvper

if you were doing this by rank...

put this in your usp.Insert_Action_Log_E

IF (@ActionType = 103)
BEGIN
IF (@Text2) LIKE 'kill=49%'
BEGIN
UPDATE PS_UserData.dbo.Users_Master SET Point = Point + 500 WHERE UserUID = (@UserUID)
END

IF (@Text2) LIKE 'kill=299%'
BEGIN
UPDATE PS_UserData.dbo.Users_Master SET Point = Point + 500 WHERE UserUID = (@UserUID)
END
END

you'll need to set the kill count to to one point below, because the kills you have when a pvp kill is logged, is what it inserts; not what you have after the kill. i know it's not exactly what you want, but it works.

the Text2 column has this string; kill=49, death=0, win=0, lose=0

this is why we use the LIKE operator, and use the % to trim off the rest of the string, otherwise the other values will make the IF statement impossible. to add more IF checks, just paste them, and change the kills.

my idea would be basically, you killed or received 50 kills in PvP you would get automatic points, it would look like a quest where you kill 50 enemies from the opposing faction, then you collect Item AP at npc, but I think that way It would be tiring for the players, so I tried to create a procedure that does the same thing as the quest, except that it delivers the aps automatically, without the player going to a npc redeeming the reward.

[[GameAdvisor]Finn]

Originally Posted by ShaiyaIwanttolearn

my idea would be basically, you killed or received 50 kills in PvP you would get automatic points, it would look like a quest where you kill 50 enemies from the opposing faction, then you collect Item AP at npc, but I think that way It would be tiring for the players, so I tried to create a procedure that does the same thing as the quest, except that it delivers the aps automatically, without the player going to a npc redeeming the reward.

sorry but i think you didnt even know this sql procedure.. did you even try his said? of course we know your point but i think you didnt even try this procedure....
this procedure can give to players points every kill that you change to % but the points show ingame (itemmall) if the players got relog..

[ShaiyaIwanttolearn]

Originally Posted by [GameAdvisor]Finn

sorry but i think you didnt even know this sql procedure.. did you even try his said? of course we know your point but i think you didnt even try this procedure....
this procedure can give to players points every kill that you change to % but the points show ingame (itemmall) if the players got relog..

I do not know if you read, or did not understand what I said, your procedure, which is not really yours, has been published here before, and as I said, I'm not looking for it, what I'm looking for and do something similar, when you create a quest to kill 100 players from the opposing faction, then you go to the quest's NPC and redeem a reward, which in my case would be AP, but I would like to have an idea of ​​a SQL procedure that performs the same function as quest, and sends AP automatically each time the player kills 50 people in PvP. You're saying what you don't know, not wanting to be rude.

[[GameAdvisor]Finn]

Originally Posted by ShaiyaIwanttolearn

I do not know if you read, or did not understand what I said, your procedure, which is not really yours, has been published here before, and as I said, I'm not looking for it, what I'm looking for and do something similar, when you create a quest to kill 100 players from the opposing faction, then you go to the quest's NPC and redeem a reward, which in my case would be AP, but I would like to have an idea of ​​a SQL procedure that performs the same function as quest, and sends AP automatically each time the player kills 50 people in PvP. You're saying what you don't know, not wanting to be rude.

Read again what im saying i didnt tell that you try my procedure i said try his procedure and i already tell sorry before telling you that..

[ShaiyaIwanttolearn]

Originally Posted by failpvper

the action type for ending a quest is 133. Value1 column records the QuestID, and Value2 = 1 if they succeeded. so this would work if you made a repeatable quest...

IF (@ActionType) = 133 AND (@Value1) = 1222 -- change to your QuestID
BEGIN
IF (@Value2) = 1
BEGIN
UPDATE PS_UserData.dbo.Users_Master
SET Point = Point + 500
WHERE UserUID = (@UserUID)
END
END

i used the 'Chavi's Gate' QuestID of 1222 as an example. you would obviously change that to your custom QuestID. this will do what you're asking for.

thank you, that was exactly it, but in this role after the quest is completed it automatically activates to collect, or does it always need to relog the character to take effect?