• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

MuEMU s6.ep3 Reset wcoin reward

M

muonlinenoob

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.
 
Sort by date Sort by votes
M

muonlinenoob

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

seedmaker

Master Summoner
500 Posts
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
A

Andriusha

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
R

ReaperKID

Initiate Mage
Joined
May 21, 2022
Messages
2
Reaction score
0

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
L

layzen1985

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
D

DraconMG

Newbie Spellweaver
Joined
Apr 9, 2023
Messages
21
Reaction score
8
Please add, vip type?

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


Types 0 1 2 3 4
 
Upvote 0
You must log in or register to reply here.