Increase eucoins automatically by kills

Removed

maybe this will go to LAMBDA bcuz DN used to work on someon else work and then he says "all credits goes to me"

What is it?
Msg 208, Level 16, State 6, Procedure spUpdateCharInfoData, Line 26
Name of object 'dbo.spUpdateCharInfoData' invalid.

nice release dn only have lambda web =D no DB

Quote:

---

Originally Posted by X-Weaver

nice release dn only have lambda web =D no DB

---

only? hmmm finally someone said "dn have the lambda web" cuz he never wanted to say that

This is 1 kill = 2 euCoins ?

Removed

How can I Increase eucoins automatically by winning a CW?

dbo.spWinTheClanGame.

am i wanna make 5 kill = 2 eucoin how can i do that?

Quote:

---

Originally Posted by diosz

am i wanna make 5 kill = 2 eucoin how can i do that?

---

Try this

SELECT @euCoins = @KillInc * 0.4


I wanna to add 10 euCoins on winning a clan war, '-'

Woooo, Thanks! :D

Can you also make a script that it will update the coins every hour if they are online ;O ?

Thx in advance <3

YAY COOl nice release ^^

i dont know how to use it sry pls anyone can help me?

Quote:

---

Originally Posted by Trilest

Can you also make a script that it will update the coins every hour if they are online ;O ?

Thx in advance <3

---

Try this:

PHP Code:

---

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO





/* 캐릭터 플레이 시간 업데이트 */
ALTER PROC [dbo].[spUpdateCharPlayTime]
  @PlayTimeInc    int,
  @CID            int
AS
SET NOCOUNT ON
DECLARE @euCoins int
DECLARE @AID int
SELECT @AID=AID FROM Character(nolock) WHERE CID = @CID

BEGIN

SELECT @euCoins = @PlayTimeInc

UPDATE Character 
SET PlayTime=PlayTime+(@PlayTimeInc), LastTime=GETDATE() 
WHERE CID=@CID

UPDATE Login SET euCoins = euCoins+(@PlayTimeInc) WHERE AID = @AID
END 


---

Able to do it on DarKGunZ ?

i need to know what i must do i am noob at this thinks

Quote:

---

Originally Posted by HighZard

i need to know what i must do i am noob at this thinks

---

Open Microsoft SQL Server Mnagement Studio, Connect to your database, click on New Querry, put the code posted and execute.

this is sick
/requeest delete

eucoins?
like bounty.. never heard of it can someone explain to me what it is?


-Chanel

Quote:

---

Originally Posted by Chanel

eucoins?
like bounty.. never heard of it can someone explain to me what it is?


-Chanel

---

it was the website currency used in Lambda's very old website ("MPOG")

Quote:

---

Originally Posted by alfredao

Try this:

PHP Code:

---

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO





/* 캐릭터 플레이 시간 업데이트 */
ALTER PROC [dbo].[spUpdateCharPlayTime]
  @PlayTimeInc    int,
  @CID            int
AS
SET NOCOUNT ON
DECLARE @euCoins int
DECLARE @AID int
SELECT @AID=AID FROM Character(nolock) WHERE CID = @CID

BEGIN

SELECT @euCoins = @PlayTimeInc

UPDATE Character 
SET PlayTime=PlayTime+(@PlayTimeInc), LastTime=GETDATE() 
WHERE CID=@CID

UPDATE Login SET euCoins = euCoins+(@PlayTimeInc) WHERE AID = @AID
END 


---

---

Thx, you sure it works this gives every hour some coins ?
Doesn't looks like that =[

If i'm right this gives eucoins the time they play =S

lol it looks like the script is putting the coins as the same ammout of time you have played (PlayTimeInc) :P play everyday and get alot of ecoins xD

Quote:

---

Originally Posted by wesman2232

lol it looks like the script is putting the coins as the same ammout of time you have played (PlayTimeInc) :P play everyday and get alot of ecoins xD

---

yep just told that >.<
I only want a script giving every hour some eucoins.

This original autor this Script is Lambda

Can anyone help me with making this script updating 1 coin each hour the person is playing??

wow! thanx! nice release :love:

[QUOTE=_System32_;5037581]This original autor this Script is Lambda