SQL Query for Reset Skill Tree

[daezugun]

Howdy RZ,

Im asking for help about query thingy in MUEMU Database and change it all to 220 MasterlLevel and MasterPoint or something?

I can only do is to reset all characters with this code below

Reset All Char Skill Tree

Update MasterSkillTree
set [MasterPoint] = MasterLevel, 
MasterSkill = 0

However i need the query to change for the character who has max master level to be change like 220.

Pls share yours if you know it thanks.

 

[myheart]

Howdy RZ,

Im asking for help about query thingy in MUEMU Database and change it all to 220 MasterlLevel and MasterPoint or something?

I can only do is to reset all characters with this code below

Reset All Char Skill Tree

Update MasterSkillTree
set [MasterPoint] = MasterLevel, 
MasterSkill = 0

However i need the query to change for the character who has max master level to be change like 220.

Pls share yours if you know it thanks.

set MasterLevel = 220 where MasterLevel > 220
set MasterPoint = MasterLevel
set MasterSkill = CAST('0' AS VARBINARY)

 

[seedmaker]

Guys did you fixed your JoinServer can log in random passwods ? pls can you share it ?

 

[daezugun]

set MasterLevel = 220 where MasterLevel > 220
set MasterPoint = MasterLevel
set MasterSkill = CAST('0' AS VARBINARY)

Thanks myheart, that'll help

Guys did you fixed your JoinServer can log in random passwods ? pls can you share it ?

What do you mean by can log im random passwords on joinserver bro?

 

[seedmaker]

Thanks myheart, that'll help





What do you mean by can log im random passwords on joinserver bro?

Yeah bro Sorry if i Comment on your Post with other problem because i Create i new thread but im still waiting for reply Problem is can Log in any password ex. my old password is 123456789 and i put 12345679adfshdfasd can log in in game i hope you can help me

 

[daezugun]

Have you tried using other JoinServer? or try to check other webfiles php if the problem still same.

 

[seedmaker]

yep idid itry a lot of JoinServer but still can log in i dont know what is the error Can you share your JoinServer ?

 

[daezugun]

yep idid itry a lot of JoinServer but still can log in i dont know what is the error Can you share your JoinServer ?

Here bro

You must be registered to see links

BTW do you know the sql query and config on how to earn wcoinc for Kundun when you kill it?

 

[seedmaker]

Query depends on you if WCoinC of Goblin Points

USE [MuOnline]GO/****** Object: StoredProcedure [dbo].[WZ_CustomMonsterReward] Script Date: 08/07/2017 15:25:18 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER Procedure [dbo].[WZ_CustomMonsterReward] @Account varchar(10),@Name varchar(10),@MonsterClass int,@MapNumber int,@RewardValue1 int,@RewardValue2 intASBEGINSET NOCOUNT ONSET XACT_ABORT ONUPDATE CashShopData SET GoblinPoint=GoblinPoint+@RewardValue1 WHERE AccountID=@AccountSET NOCOUNT OFFSET XACT_ABORT OFFEND

Here Custom monster depends on you what map you will put your Kundun this is for Arena

//Index MapNumber MaxLife DamageMin DamageMax Defense AttackRate DefenseRate ExperienceRate KillMessage InfoMessage RewardValue1275 06 999999 50 50 0 50 0 1000 526 527 3000

Message.txt

526 "Player %s killed Kundun in Arena"527 "You have Gain% d WCoin"

 

[daezugun]

Query depends on you if WCoinC of Goblin Points




Here Custom monster depends on you what map you will put your Kundun this is for Arena



Message.txt

How bout for other monster? do i need to put again that query or just add an additional monster?

 

[seedmaker]

Still can Log in

How bout for other monster? do i need to put again that query or just add an additional monster?

additional monster and message