darknose123
Usuário XPZ
Olha Não Sei se esta correto Achei Algo Sobre resets Em 1 forum gringo vou postar aqui para quem quiser testar...
<-- How to install -->
1- Open Query Analyzer
1.1- Start > Programs > Microsoft SQL Server > Query Analyzer
1.2- Use you login method
1.3- Check header "Master", change for GameDB
1.4- Open 0_table.sql, select all and past inside query window
1.5- Press F5
1.6- Done and close Query Analyzer
2- Enterprise Manager
2.1- Open you server and choose Management > SQL Server Agent > Job
2.2- Click right mouse button in you right side, New Job
2.3- General Tab
Name = Reset System
Owner = sa
2.4- Steps Tab
Press NEW... button
2.5- New Job Step - General Tab
Step Name = Reset Warrior
Database = GameDB
Command = open 1_warrior.sql, select all, copy and past inside command box and press OK
2.6- Steps Tab
Press NEW... button
2.7- New Job Step - General Tab
Step Name = Reset Blader
Database = GameDB
Command = open 2_blader.sql, select all, copy and past inside command box and press OK
2.8- Steps Tab
Press NEW... button
2.9- New Job Step - General Tab
Step Name = Reset Wizard
Database = GameDB
Command = open 3_wizard.sql, select all, copy and past inside command box and press OK
2.10- Steps Tab
press NEW... button
2.11- New Job Step - General Tab
Step Name = Reset Force Archer
Database = GameDB
Command = open 4_force_archer.sql, select all, copy and past inside command box and press OK
2.12- Steps Tab
Press NEW... button
2.13- New Job Step - General Tab
Step Name = Reset Force Shielder
Database = GameDB
Command = open 5_force_shielder.sql, select all, copy and past inside command box and press OK
2.14- Steps Tab
Press NEW... button
2.15- New Job Step - General Tab
Step Name = Reset Force Blader
Database = GameDB
Command = open 6_force_blader.sql, select all, copy and past inside command box and press OK
2.16- Schedules Tab
Press New Schedule... button
2.17- New Job Schedule
Name = Reset System
Press Change... button
2.18- Edit Recurring Job Schedule
Occurs = Daily
Daily Frequecy = Occurs Every
1 = 10
Hour(s) = Minute(s)
23:59:59 = 23:49:59
Start Date = 1 day before today
Press OK
Press OK
Press OK
2.19- Done
you reset system work every 10 min, if you want less time change 10 and 23:49:59
<-- How to install -->
1- Open Query Analyzer
1.1- Start > Programs > Microsoft SQL Server > Query Analyzer
1.2- Use you login method
1.3- Check header "Master", change for GameDB
1.4- Open 0_table.sql, select all and past inside query window
1.5- Press F5
1.6- Done and close Query Analyzer
2- Enterprise Manager
2.1- Open you server and choose Management > SQL Server Agent > Job
2.2- Click right mouse button in you right side, New Job
2.3- General Tab
Name = Reset System
Owner = sa
2.4- Steps Tab
Press NEW... button
2.5- New Job Step - General Tab
Step Name = Reset Warrior
Database = GameDB
Command = open 1_warrior.sql, select all, copy and past inside command box and press OK
2.6- Steps Tab
Press NEW... button
2.7- New Job Step - General Tab
Step Name = Reset Blader
Database = GameDB
Command = open 2_blader.sql, select all, copy and past inside command box and press OK
2.8- Steps Tab
Press NEW... button
2.9- New Job Step - General Tab
Step Name = Reset Wizard
Database = GameDB
Command = open 3_wizard.sql, select all, copy and past inside command box and press OK
2.10- Steps Tab
press NEW... button
2.11- New Job Step - General Tab
Step Name = Reset Force Archer
Database = GameDB
Command = open 4_force_archer.sql, select all, copy and past inside command box and press OK
2.12- Steps Tab
Press NEW... button
2.13- New Job Step - General Tab
Step Name = Reset Force Shielder
Database = GameDB
Command = open 5_force_shielder.sql, select all, copy and past inside command box and press OK
2.14- Steps Tab
Press NEW... button
2.15- New Job Step - General Tab
Step Name = Reset Force Blader
Database = GameDB
Command = open 6_force_blader.sql, select all, copy and past inside command box and press OK
2.16- Schedules Tab
Press New Schedule... button
2.17- New Job Schedule
Name = Reset System
Press Change... button
2.18- Edit Recurring Job Schedule
Occurs = Daily
Daily Frequecy = Occurs Every
1 = 10
Hour(s) = Minute(s)
23:59:59 = 23:49:59
Start Date = 1 day before today
Press OK
Press OK
Press OK
2.19- Done
you reset system work every 10 min, if you want less time change 10 and 23:49:59