[Guide] Blocking Characters with illegal stats

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...

good