1
Scripts / querys / Re: Looking for script SQL Reset -> get credits
« Posteado: July 25, 2024, 04:11:55 AM »
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
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