[Guide] Script for Auto Fix stats

View previous topic View next topic Go down

[Guide] Script for Auto Fix stats

Post by Asgard on Thu Dec 11, 2014 2:45 pm

I m whant present my sript for fix 32767 max stats, when someone try more 32767 stats he backup to 32767, and when character takes all str,vit,ene,agi stats max delete freee points, include dl max too.

Code:
UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Dexterity, Dexterity = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Dexterity < 0) AND (ConnectStat = 0)

UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Vitality, Vitality = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Vitality < 0) AND (ConnectStat = 0)

UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Strength, Strength = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Strength < 0) AND (ConnectStat = 0)

UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Energy, Energy = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Energy < 0) AND (ConnectStat = 0)

UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Leadership, Leadership = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Leadership < 0) AND (ConnectStat = 0)

UPDATE Character
SET LevelUpPoint='0
WHERE Strength+Dexterity+Vitality+Energy='131068' OR Strength+Dexterity+Vitality+Energy+Leadership='163835'
avatar
Asgard
Admin
Admin

Брой мнения : 37
Points : 119
Reputation : 14
Join date : 2014-12-10
Age : 29
Местожителство : Germany

View user profile http://WARTUNEMU.COM

Back to top Go down

Re: [Guide] Script for Auto Fix stats

Post by bugme on Mon Dec 15, 2014 11:41 pm

work for all version ? scratch
avatar
bugme
V.I.P
V.I.P

Брой мнения : 21
Points : 70
Reputation : 13
Join date : 2014-12-11
Age : 27
Местожителство : Bulgaria - Burgas

View user profile http://wartune.bulgarianforum.net

Back to top Go down

Re: [Guide] Script for Auto Fix stats

Post by Asgard on Mon Dec 15, 2014 11:43 pm

Yes.

!!! Download links are open only to registered users !!!


!!! Линковете за сваляне са отворени единствено за регистрирани потребители !!!

[You must be registered and logged in to see this image.] You don't make the rules! [You must be registered and logged in to see this image.]
avatar
Asgard
Admin
Admin

Брой мнения : 37
Points : 119
Reputation : 14
Join date : 2014-12-10
Age : 29
Местожителство : Germany

View user profile http://WARTUNEMU.COM

Back to top Go down

Re: [Guide] Script for Auto Fix stats

Post by nstoqnova on Tue Dec 16, 2014 12:08 am

Open query analyzer and select MuOnline and post script code and click F5 and close program and click NO
avatar
nstoqnova
Member
Member

Брой мнения : 8
Points : 27
Reputation : 9
Join date : 2014-12-12

View user profile

Back to top Go down

Re: [Guide] Script for Auto Fix stats

Post by Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum