Credits per Kill

Hey i found this with google ^^

Quote:

---

--v1.0
-- CashPoints for kills
DECLARE @AccUID INT
DECLARE @CashPoint INT

-- set AccountUniqueNumber
SET @AccUID = (SELECT AccountUniqueNumber FROM atum2_db_1.dbo.td_Character WHERE UniqueNumber = @UniqueNumber)

-- set the cashpoints
SET @CashPoint = (SELECT CashPoint FROM atum2_db_account.dbo.td_Account WHERE AccountUniqueNumber = @AccUID) + 10

-- update the cashpoints
UPDATE atum2_db_account.dbo.td_Account SET CashPoint = @CashPoint WHERE AccountUniqueNumber = @AccUID


--V2.0

-- update the cashpoints
UPDATE atum2_db_account.dbo.td_Account
SET CashPoint = ((SELECT CashPoint FROM atum2_db_account.dbo.td_Account WHERE AccountUniqueNumber = (SELECT AccountUniqueNumber FROM atum2_db_1.dbo.td_Character WHERE UniqueNumber = @UniqueNumber)) + 10)
WHERE AccountUniqueNumber = (SELECT AccountUniqueNumber FROM atum2_db_1.dbo.td_Character WHERE UniqueNumber = @UniqueNumber)

---

Can one tell me if this work? and where do i have to put this in?

If it not work do have any one help!?

I am not sure who wrote this nor do I want to check it, but I have another simple idea for you.

There is a function that inserts an item to a character. Make a table (I will call it @table here) with 2 columns, ItemNum and Credits. For each killmark ItemNum, you can give it some Credits value.

Assuming you have found the procedure that inserts the items, you will also have @itemnum and @accountuniquenumber.

Code:

---

declare @credits int = 0
select @credits = credits from @table where itemnum = @itemnum
-- You may make a more complicated algorithm depending on character's level.

-- Then increase the credits of the account.
update WhateverTableYouUseForCredits
set credits += @credits
where accountuniquenumber = @accountuniquenumber

---

This example is rather simple, but you should know exactly what to do if you know anything about SQL. If you are completely new to SQL, learn SQL and then you can ask questions about it.

Nice idea, I will try it for my server. Thanks Might & Pank!

procedure is no problem but problem is show message in 'system message window' like "You received X credits"" when server execute procedure.

SQL modding is easier than modding the binaries, but also of lower quality (this is why it is easier after all). If you want high quality mods, you have to learn how the server works at a really low level, you have to understand how your computer executes it. Like I said, either learn or pay, noone will work for you without a reward.