Blocking Characters with illegal stats

nightx · Admin Data inscrierii: 17/Aug/2007 Mesaje: 159

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