[HELP]Auto Stats Repair

Dragon124 · Nov 17, 2007

As far i didnt see anyting about that ... but i can suggest to someone to do it like:
1) when ur stats become to 32767 + then they must be repaired
2)repair after an hour or less ...
3) if u do it, send a sipmle installation guide with it ,
-Thanks

commandcom · Nov 17, 2007

you can use simple sql query

Code:

use MuOnline
UPDATE Character 
SET Strength = '32000' 
WHERE Strength < '1' 
 
UPDATE Character 
SET Dexterity = '32000' 
WHERE Dexterity < '1' 
 
UPDATE Character 
SET Vitality = '32000' 
WHERE Vitality < '1' 
 
UPDATE Character 
SET Energy = '32000' 
WHERE Energy < '1'

or make it as sql agent job

Code:

1.open enterprize manager
2.go to SQL Server Group-[local]-Management-SQL Server Agent-Jobs
3.right click on Jobs and pick New Job and name: Statsfix
4.go to Steps tab add New step 
5.name Statsfix select Database MuOnline
6.now Command window write:

use MuOnline
UPDATE Character 
SET Strength = '32000' 
WHERE Strength < '1' 
 
UPDATE Character 
SET Dexterity = '32000' 
WHERE Dexterity < '1' 
 
UPDATE Character 
SET Vitality = '32000' 
WHERE Vitality < '1' 
 
UPDATE Character 
SET Energy = '32000' 
WHERE Energy < '1' 

7.press Parse, if no errors press Apply and Ok
8.go Schedules tab and add New Schedule, name Statsfix
9.select Recurring and press Change... button
10.select following settings:
Occurs: Daily
Daily: Every 1 day
Daily frequency: occurs every 10 Minutes
Duration: No end date
11.press Ok-Ok-Ok and close Enterprize Manager
12.go to Microsoft SQL Server>SQL Server Service Manager
13.in services drop-down menu select SQL Server Agent and press Start/Continue and select Auto-start service when OS starts

i wrote that as easy as possible

hope it help you

Dragon124 · Nov 17, 2007

This guide with SQL AGENT was GREAT , now only test left .. i hope works thanks for ur help.
The first is for SQL query but how can i set time , and all that ? or only agent does that?