[Release]Get DP with Level up

[..Zeus..]

USE [PS_GameData]
GO

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

SET QUOTED_IDENTIFIER ON
GO




create trigger [dbo].[PointsForLevel]
on [PS_GameData].[dbo].[Chars]
after update
as
IF (UPDATE (Level))
begin
declare @oldLevel int
declare @newLevel int
set @oldLevel = (select Level from deleted)
set @newLevel = (select Level from inserted)
if @oldLevel<@newLevel
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),@newLevel) 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 Level value that is "like" 1000 or 2000 or 3000 etc, not just 1000 kills
*/
end

You can change the DP Amount if u want

It´s from the DP Via pvp kill by Svinseladden


Regards

[Sh1nra]

Very Nice Zeus,

I'll try it definitely!

[JohnHeatz]

A good release, yet I don't quite get the purpose of giving points for leveling, unless a grinding server arrives (long time without seeing a good one of these kind)

[_-Phoenix-_]

Well john there are a few of us still around . that does not belive in the instant leveling.

and i might have to add the pvp aspect of this. might be intresting .

[Ethar1]

Very good script.I´ve tested we can change AP per EXP per namechange and many many more good script