Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

MuEMU s6.ep3 Reset wcoin reward

Newbie Spellweaver
Joined
Sep 23, 2015
Messages
17
Reaction score
0
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.
 
Newbie Spellweaver
Joined
Sep 23, 2015
Messages
17
Reaction score
0
/reset command

I wrote sql trigger for this, but i think it will be need many db resourses
 
Upvote 0
Master Summoner
Joined
Feb 17, 2017
Messages
580
Reaction score
72
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
 
Upvote 0
Newbie Spellweaver
Joined
Nov 5, 2017
Messages
32
Reaction score
2
i'm using season 9 ep 2 igcn files, and can't find "WZ_SetResetInfo" . Maybe they use another table name
 
Upvote 0
Initiate Mage
Joined
May 21, 2022
Messages
2
Reaction score
0
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.
 
Upvote 0
Initiate Mage
Joined
Mar 2, 2023
Messages
1
Reaction score
0
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
 
Upvote 0
Newbie Spellweaver
Joined
Apr 9, 2023
Messages
21
Reaction score
8
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
 
Upvote 0
Back
Top