Sup guys I’m looking for script for Sql
When player make a reset he got immediately X credits to his account

Please anyone can create or publish script like that ?

Season 3 SSEMU

Uppppppp

I mean to Query for Sql can I running please UP

MuOnline Database -> Programmability -> Stored Procedures

Modify: dbo.WZ_SetResetInfo
Add the following:

UPDATE Character SET ResetCount=@reset WHERE AccountID=@account AND Name=@Name
UPDATE PcPointData Set PcPoint=PcPoint +<Reward_Value> WHERE AccountID=@account

Example: 1reset = 20 credits

UPDATE PcPointData Set PcPoint=PcPoint +20 WHERE AccountID=@account

To create a script that grants a player credits immediately upon making a reset, you can use SQL combined with triggers or procedural logic, depending on your database system.

You can run this query right after the reset function is triggered. Just make sure you replace `X` with the number of credits you want to award and `PlayerID` with the relevant player identifier.

If you're implementing this in a game server script, ensure that this SQL command executes every time a player performs a reset. It’s always good practice to back up your database before running any updates, just in case!



Thanks,

Miss Walker, Parramatta Carpet Cleaning