how can i make to stop adding points after i have 32767
Printable View
how can i make to stop adding points after i have 32767
what files u have?
Posted via Mobile Device
season 3 ep 1 of dsw_pool
just use the SQL query
i tested one yesterday .... but no luck :|
the point is i wanna disable "+" button for points when i have 32767 stats
ur files have extra data folder for config files? maybe on gs folder?
or make full search in ur files for the number '3276' and see . .
Posted via Mobile Device
yeah i searched no such option in files like titantech .... becouse max stat of files is 32767... so i need a sql job something like that to auto fix stats .... maybeQuote:
Originally Posted by karLi
idk search on google for 'sql query codes muonline'
Posted via Mobile Device
i found this maybe will work
i will test and report becouse maybe will need too
but missing for DLCode: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
no its not missing go on that page u found the script and scroll more down to get dl code to.
Posted via Mobile Device
is it applicable in any server version?
what applicable just use the script
Posted via Mobile Device