MuEMU s6.ep3 Reset wcoin reward

[muonlinenoob]

Hi all.
I have a problem.
I want to give players wcoin c for reset count.

for example 30 wcoinC for each reset.

When player make reset: wcoinC = wcoinC + 30

But i cant find any configs and stored procedures in db.
Found only goblin point for online config. But i need wcoinC for reset.

[MentaL]

[KarLi]

how do players make reset? with website or files?

[muonlinenoob]

/reset command

I wrote sql trigger for this, but i think it will be need many db resourses

[Andriusha]

Need that query , too , can somebody help ?

[seedmaker]

Like this ?

Go on Stored Procedures Find "WZ_SetResetInfo" then add this bellow


UPDATE Character SET ResetCount=@Reset WHERE AccountID=@Account AND Name=@Name


UPDATE CashShopData Set WCoinC = WCoinC + 100

This one if you type /reset its automatic gives your acc. with 100WCoinC

[Andriusha]

i'm using season 9 ep 2 igcn files, and can't find "WZ_SetResetInfo" . Maybe they use another table name

[ReaperKID]

Like this ?

Go on Stored Procedures Find "WZ_SetResetInfo" then add this bellow


UPDATE Character SET ResetCount=@Reset WHERE AccountID=@Account AND Name=@Name


UPDATE CashShopData Set WCoinC = WCoinC + 100

This one if you type /reset its automatic gives your acc. with 100WCoinC

Hi, I tried this SQL Script but the problem is, when someone use /reset then all the players will receive the amount you put on the Stored Procedure, how to make it individual? for accounts only of a player who use /reset not for all.

[zipper20032]

This one is the correct one.

UPDATE CashShopData Set WCoinC = WCoinC + 100 WHERE AccountID = @Account

[layzen1985]

USE MuOnline
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'ResetPorCash')
DROP TRIGGER ResetPorCash
GO

CREATE TRIGGER dbo.ResetPorCash
ON dbo.Character
AFTER UPDATE
AS
BEGIN
DECLARE
@Char varchar(10)
SELECT @Char = AccountID from inserted
IF UPDATE(ResetCount)
BEGIN
UPDATE CashShopData
SET
WCoinC = WCoinC + 1000
WHERE AccountID = @Char
END
END
GO