DemonBK
Site Admin
Joined: 10 Jul 2007
Posts: 28
|
 Posted: Wed Jul 11, 2007 12:59 pm Post subject: SQL-Some guides |
 |
|
=== Auto PK Reset ===
Open
Start > Programs > Sql Server > Enterprise Manager
Open Microsoft SQL Servers > SQL Server Group > (local) (Windows NT) > Management >
Right click on SQL Server Agent > Start
Then open this category,click Jobs
Make Right Click > New Job
Name it AutoPkReset
change Owner to 'sa'
Now go to Steps tab,make New Job
Name it step1
database : muonline
command :
| Code: | UPDATE Character
SET PkLevel = ('0'), PkTime = ('0'), PkCount = ('0')
Where PkLevel>2 |
make parse,click apply then ok,now go to Schedules,click New Schedule
Name : AutoPkReset
Reccurting > Change
Occurs : Daily,every 1 days
Daily frequerency : occurs every : 1 minute
duration :
start date - make yesterday
then make NO End date,and ok 2 times
now click apply then ok,then right click on AutoPkReset job and Start job
=== Auto Reset ===
Open
Start > Programs > Sql Server > Enterprise Manager
Open Microsoft SQL Servers > SQL Server Group > (local) (Windows NT) > Management >
Right click on SQL Server Agent > Start
Then open this category,click Jobs
Make Right Click > New Job
Name it AutoReset
change Owner to 'sa'
Now go to Steps tab,make New Job
Name it step1
database : muonline
command :
| Code: | UPDATE Character
SET cLevel=('1') , experience=('0')
WHERE cLevel>349 |
make parse,click apply then ok,now go to Schedules,click New Schedule
Name : AutoReset
Reccurting > Change
Occurs : Daily,every 1 days
Daily frequerency : occurs every : 1 minute
duration :
start date - make yesterday
then make NO End date,and ok 2 times
now click apply then ok,then right click on AutoReset job and Start job
=== Auto Repair Stats ===
Open
Start > Programs > Sql Server > Enterprise Manager
Open Microsoft SQL Servers > SQL Server Group > (local) (Windows NT) > Management >
Right click on SQL Server Agent > Start
Then open this category,click Jobs
Make Right Click > New Job
Name it RepairStats
change Owner to 'sa'
Now go to Steps tab,make New Job
Name it step1
database : muonline
command :
| Code: | UPDATE Character
SET Strength = '32766'
WHERE Strength < '1'
UPDATE Character
SET Dexterity = '32766'
WHERE Dexterity < '1'
UPDATE Character
SET Vitality = '32766'
WHERE Vitality < '1'
UPDATE Character
SET Energy = '32766'
WHERE Energy < '1' |
make parse,click apply then ok,now go to Schedules,click New Schedule
Name : RepairStats
Reccurting > Change
Occurs : Daily,every 1 days
Daily frequerency : occurs every : 1 minute
duration :
start date - make yesterday
then make NO End date,and ok 2 times
now click apply then ok,then right click on RepairStats job and Start job
=== Auto add 2,000,000,000 money and fix if its bugged ===
Open
Start > Programs > Sql Server > Enterprise Manager
Open Microsoft SQL Servers > SQL Server Group > (local) (Windows NT) > Management >
Right click on SQL Server Agent > Start
Then open this category,click Jobs
Make Right Click > New Job
Name it Money
change Owner to 'sa'
Now go to Steps tab,make New Job
Name it step1
database : muonline
command :
| Code: | UPDATE Character
Set Money=('2000000000')
WHERE Money<1 |
make parse,click apply then ok,now go to Schedules,click New Schedule
Name : Money
Reccurting > Change
Occurs : Daily,every 1 days
Daily frequerency : occurs every : 1 minute
duration :
start date - make yesterday
then make NO End date,and ok 2 times
now click apply then ok,then right click on Money job and Start job
hope i help to some guys
works @ all versions (but 99.62 not tested)
..................................
By DemonBK |
|
