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.

 

[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.

[COLOR=#666666][FONT=noto_italic]UPDATE CashShopData Set WCoinC = WCoinC + 100 WHERE AccountID = [/FONT][/COLOR][COLOR=#666666][FONT=noto_italic]@Account[/FONT][/COLOR][COLOR=#666666][FONT=noto_italic]
[/FONT][/COLOR]

[FONT=noto_italic]

[/FONT]

 

[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

 

[DraconMG]

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

Please add, vip type?

My vip MuOnline/dbo.T_VipList. accountid /date / Type


Types 0 1 2 3 4