[Guide] Blocking Characters with illegal stats

View previous topic View next topic Go down

[Guide] Blocking Characters with illegal stats

Post by  on Mon Dec 24, 2007 6:33 am

To use this system fruit must not be used in your server. I suggest to
remove fruit from item(X).txt file of your server. then no problem
left. Game master characters are excluded from blocking system. If you
want to allow some of the characters increased stats, then set their Allowed field to 1. So they will be excluded from blocking system.
Follow the steps simply have it working;

Open Enterprise Manager of your SQL Server. Design Local>Databases>muonline>Tables>Character table as following:

Image-01:



Add allowed and total_pnts fields then exit the table but SAVE THE CHANGES certainly.

Image-02:



Choose New Job by right clicking to Local>Management>SQL Server Agent>Jobs just like following picture shows:

Image-03:



After that Properties screen of the job will be opened. Change the Name to illegal_stat_block or whatever you desire. And select sa from Owner.

Image-04:



After doing that, switch to Steps tab. Add a new step then follow the steps in Image-05. Put the following code into Command text field:
Quote:
UPDATE Character
SET
total_pnts=Strength
UPDATE Character
SET
total_pnts=total_pnts+Dexterity+Vitality+Energy-10
UPDATE Character
SET
total_pnts=total_pnts-10
WHERE Class=1 OR Class=33 OR Class=17
UPDATE Character
SET
CtlCode=1
WHERE total_pnts>(resets*350)+((clevel-1)*5)+100 AND Class<>48
AND Class<>64 AND Allowed<>1 AND CtlCode<>8
UPDATE Character
SET
CtlCode=1
WHERE total_pnts>(resets*350)+((clevel-1)*7)+104 AND Allowed<>1 AND
CtlCode<>8 AND (Class=48 OR Class=64)


Info: 350 is
bonus points after a character reseted. Your server may have different
bonus point amount per reset. So change it to whatever your reset
system bonus point is.

Image-05:



Switch to Schedules tab, add new schedule and follow Image-06

Image-06:




Here you go. good luck...


Favourite Game : MuOnline
Registration date : 1969-12-31

View user profile

Back to top Go down

Re: [Guide] Blocking Characters with illegal stats

Post by RedRox on Sun Mar 11, 2012 11:37 pm

good

RedRox
Beginner
Beginner

Number of posts : 4
Registration date : 2012-03-11

View user profile

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