Auto Reset for 0.99.6XT

[HexaMaster]

Hi ppls,

There is SQL 2000 auto reset script, working on 0.99.62XT versions:

<code>
BEGIN TRANSACTION
DECLARE @JobID BINARY(16)
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[Uncategorized (Local)]') < 1
EXECUTE msdb.dbo.sp_add_category @name = N'[Uncategorized (Local)]'
SELECT @JobID = job_id
FROM msdb.dbo.sysjobs
WHERE (name = N'AutoReset')
IF (@JobID IS NOT NULL)
BEGIN
IF (EXISTS (SELECT *
FROM msdb.dbo.sysjobservers
WHERE (job_id = @JobID) AND (server_id <> 0)))
BEGIN
RAISERROR (N'Unable to import job ''AutoReset'' since there is already a multi-server job with this name.', 16, 1)
GOTO QuitWithRollback
END
ELSE
EXECUTE msdb.dbo.sp_delete_job @job_name = N'AutoReset'
SELECT @JobID = NULL
END

BEGIN

EXECUTE @ReturnCode = msdb.dbo.sp_add_job @job_id = @JobID OUTPUT , @job_name = N'AutoReset', @owner_login_name = N'sa', @description = N'AutoResetScript', @category_name = N'[Uncategorized (Local)]', @enabled = 1, @notify_level_email = 0, @notify_level_page = 0, @notify_level_netsend = 0, @notify_level_eventlog = 2, @delete_level= 0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID, @step_id = 1, @step_name = N'AutoReset', @command = N'UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 0) OR (class = 1)) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);


UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 16) OR (class = 17)) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 32) OR (class = 33)) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 48) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 64) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);
', @database_name = N'MuOnline', @server = N'', @database_user_name = N'', @subsystem = N'TSQL', @cmdexec_success_code = 0, @flags = 0, @retry_attempts = 0, @retry_interval = 1, @output_file_name = N'', @on_success_step_id = 0, @on_success_action = 1, @on_fail_step_id = 0, @on_fail_action = 2
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXECUTE @ReturnCode = msdb.dbo.sp_update_job @job_id = @JobID, @start_step_id = 1

IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID, @name = N'AutoReset', @enabled = 1, @freq_type = 4, @active_start_date = 20060831, @active_start_time = 0, @freq_interval = 1, @freq_subday_type = 4, @freq_subday_interval = 1, @freq_relative_interval = 0, @freq_recurrence_factor = 0, @active_end_date = 99991231, @active_end_time = 235959
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

EXECUTE @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @JobID, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

END
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:
</code>

Before you launch the query, be sure, that:

1st:

Exist column "Reset" in Database => MuOnline =>Character
If no, right click on table "character" and add column name: "Reset" , data type: "int" , lenght: "4", allow nulls: "NO", and setin table "Columns" default value to "(0)" .

2nd:
Column "Reset" must be set to default value "(0)". To do this, right click on character table, find reset column and disable nulls. Under the Reset column, in sction "columns", set default value to "(0)".

3rd:

Do not forget to run SQL Server agent, otherwise the script wont work.

Autoreset parameters:
Reset lvl: 380
Addpoints after reset: 1000
Stats stay: NO
Reset Cost: 50m

To autoreset: Log off for 1 minute
Done

ps: Do not write "" in tables!



Credits:

LifeStealer: Script core
HexaMaster: Rebuild to 0.99.6XT

[MentaL]

[heartagram]

meibi someone can make a reset script in web?

[HELL_IN_HEAVEN]

how about my table has the word Resets, if i will change it to Reset, it wont bug any char?

[HexaMaster]

how about my table has the word Resets, if i will change it to Reset, it wont bug any char?

Nope, it wont. You can change it to Reset. Dont forget set the default to 0, dont use nulls!

[avner]

i dont understand... what i have to do .... with this

<code>
BEGIN TRANSACTION
DECLARE @JobID BINARY(16)
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[Uncategorized (Local)]') < 1
EXECUTE msdb.dbo.sp_add_category @name = N'[Uncategorized (Local)]'
SELECT @JobID = job_id
FROM msdb.dbo.sysjobs
WHERE (name = N'AutoReset')
IF (@JobID IS NOT NULL)
BEGIN
IF (EXISTS (SELECT *
FROM msdb.dbo.sysjobservers
WHERE (job_id = @JobID) AND (server_id <> 0)))
BEGIN
RAISERROR (N'Unable to import job ''AutoReset'' since there is already a multi-server job with this name.', 16, 1)
GOTO QuitWithRollback
END
ELSE
EXECUTE msdb.dbo.sp_delete_job @job_name = N'AutoReset'
SELECT @JobID = NULL
END

BEGIN

EXECUTE @ReturnCode = msdb.dbo.sp_add_job @job_id = @JobID OUTPUT , @job_name = N'AutoReset', @owner_login_name = N'sa', @description = N'AutoResetScript', @category_name = N'[Uncategorized (Local)]', @enabled = 1, @notify_level_email = 0, @notify_level_page = 0, @notify_level_netsend = 0, @notify_level_eventlog = 2, @delete_level= 0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID, @step_id = 1, @step_name = N'AutoReset', @command = N'UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 0) OR (class = 1)) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);


UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 16) OR (class = 17)) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 32) OR (class = 33)) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 48) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 64) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);
', @database_name = N'MuOnline', @server = N'', @database_user_name = N'', @subsystem = N'TSQL', @cmdexec_success_code = 0, @flags = 0, @retry_attempts = 0, @retry_interval = 1, @output_file_name = N'', @on_success_step_id = 0, @on_success_action = 1, @on_fail_step_id = 0, @on_fail_action = 2
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXECUTE @ReturnCode = msdb.dbo.sp_update_job @job_id = @JobID, @start_step_id = 1

IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID, @name = N'AutoReset', @enabled = 1, @freq_type = 4, @active_start_date = 20060831, @active_start_time = 0, @freq_interval = 1, @freq_subday_type = 4, @freq_subday_interval = 1, @freq_relative_interval = 0, @freq_recurrence_factor = 0, @active_end_date = 99991231, @active_end_time = 235959
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

EXECUTE @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @JobID, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

END
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:
</code>

[Heraclia]

wonderfull is good job. thx

[HexaMaster]

i dont understand... what i have to do .... with this

BEGIN TRANSACTION
DECLARE @JobID BINARY(16)
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[Uncategorized (Local)]') < 1
EXECUTE msdb.dbo.sp_add_category @name = N'[Uncategorized (Local)]'
SELECT @JobID = job_id
FROM msdb.dbo.sysjobs
WHERE (name = N'AutoReset')
IF (@JobID IS NOT NULL)
BEGIN
IF (EXISTS (SELECT *
FROM msdb.dbo.sysjobservers
WHERE (job_id = @JobID) AND (server_id <> 0)))
BEGIN
RAISERROR (N'Unable to import job ''AutoReset'' since there is already a multi-server job with this name.', 16, 1)
GOTO QuitWithRollback
END
ELSE
EXECUTE msdb.dbo.sp_delete_job @job_name = N'AutoReset'
SELECT @JobID = NULL
END

BEGIN

EXECUTE @ReturnCode = msdb.dbo.sp_add_job @job_id = @JobID OUTPUT , @job_name = N'AutoReset', @owner_login_name = N'sa', @description = N'AutoResetScript', @category_name = N'[Uncategorized (Local)]', @enabled = 1, @notify_level_email = 0, @notify_level_page = 0, @notify_level_netsend = 0, @notify_level_eventlog = 2, @delete_level= 0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID, @step_id = 1, @step_name = N'AutoReset', @command = N'UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 0) OR (class = 1)) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);


UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 16) OR (class = 17)) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 32) OR (class = 33)) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 48) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 64) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);
', @database_name = N'MuOnline', @server = N'', @database_user_name = N'', @subsystem = N'TSQL', @cmdexec_success_code = 0, @flags = 0, @retry_attempts = 0, @retry_interval = 1, @output_file_name = N'', @on_success_step_id = 0, @on_success_action = 1, @on_fail_step_id = 0, @on_fail_action = 2
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXECUTE @ReturnCode = msdb.dbo.sp_update_job @job_id = @JobID, @start_step_id = 1

IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID, @name = N'AutoReset', @enabled = 1, @freq_type = 4, @active_start_date = 20060831, @active_start_time = 0, @freq_interval = 1, @freq_subday_type = 4, @freq_subday_interval = 1, @freq_relative_interval = 0, @freq_recurrence_factor = 0, @active_end_date = 99991231, @active_end_time = 235959
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

EXECUTE @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @JobID, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

END
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:

If you want to use this autoreset script, you must write it into "query analizer" (its part of MS SQL).

[HexaMaster]

wonderfull is good job. thx

thnx :)

[Fraps.]

hexamaster, copy the code to a TXT file and upload it. The forum is messing a bit the code.

[HexaMaster]

hexamaster, copy the code to a TXT file and upload it. The forum is messing a bit the code.

Here you go pal : HexaMU 0.99.62

[KillerHT]

HexaMaster, thx for this release!

[checkmate]

this autoreset clear vault?

[haros]

UPDATE Character SET clevel = 1, Experience = 0, LevelUpPoint = (2104 * (Resets )), Strength = 1825 , Dexterity = 1828 , Vitality = 50 , Energy = 2000 , Money = Money - (5000000), MapNumber = 0, MapPosX = 130,

MapPosY = 130, Resets = Resets + 1 FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI WHERE (clevel >=

350) AND (Money >= (5000000)) AND (ConnectStat = 0) AND (Resets <10) ;


UPDATE Character SET clevel = 1, Experience = 0, LevelUpPoint = (2104 * (Resets )),Strength = 1825 , Dexterity = 1828 , Vitality = 50 , Energy = 2000, Money = Money - (5000000), MapNumber = 0, MapPosX = 130,

MapPosY = 130, Resets = Resets + 1 FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI WHERE (clevel >=

400) AND (Money >= (5000000)) AND (ConnectStat = 0) AND (Resets >=10) ;

[djatrom]

I placed the JOB, but it is not reset! What it can be this?

Sorry my english!

[cubars]

in 1st it's script,run in query analyzer

[djatrom]

in 1st it's script,run in query analyzer

I placed in query, but this not reset. What he could be?

[DOMI]

Hi ppls,

There is SQL 2000 auto reset script, working on 0.99.62XT versions:

<code>
BEGIN TRANSACTION
DECLARE @JobID BINARY(16)
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[Uncategorized (Local)]') < 1
EXECUTE msdb.dbo.sp_add_category @name = N'[Uncategorized (Local)]'
SELECT @JobID = job_id
FROM msdb.dbo.sysjobs
WHERE (name = N'AutoReset')
IF (@JobID IS NOT NULL)
BEGIN
IF (EXISTS (SELECT *
FROM msdb.dbo.sysjobservers
WHERE (job_id = @JobID) AND (server_id <> 0)))
BEGIN
RAISERROR (N'Unable to import job ''AutoReset'' since there is already a multi-server job with this name.', 16, 1)
GOTO QuitWithRollback
END
ELSE
EXECUTE msdb.dbo.sp_delete_job @job_name = N'AutoReset'
SELECT @JobID = NULL
END

BEGIN

EXECUTE @ReturnCode = msdb.dbo.sp_add_job @job_id = @JobID OUTPUT , @job_name = N'AutoReset', @owner_login_name = N'sa', @description = N'AutoResetScript', @category_name = N'[Uncategorized (Local)]', @enabled = 1, @notify_level_email = 0, @notify_level_page = 0, @notify_level_netsend = 0, @notify_level_eventlog = 2, @delete_level= 0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID, @step_id = 1, @step_name = N'AutoReset', @command = N'UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 0) OR (class = 1)) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);


UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 16) OR (class = 17)) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 32) OR (class = 33)) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 48) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 64) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);
', @database_name = N'MuOnline', @server = N'', @database_user_name = N'', @subsystem = N'TSQL', @cmdexec_success_code = 0, @flags = 0, @retry_attempts = 0, @retry_interval = 1, @output_file_name = N'', @on_success_step_id = 0, @on_success_action = 1, @on_fail_step_id = 0, @on_fail_action = 2
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXECUTE @ReturnCode = msdb.dbo.sp_update_job @job_id = @JobID, @start_step_id = 1

IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID, @name = N'AutoReset', @enabled = 1, @freq_type = 4, @active_start_date = 20060831, @active_start_time = 0, @freq_interval = 1, @freq_subday_type = 4, @freq_subday_interval = 1, @freq_relative_interval = 0, @freq_recurrence_factor = 0, @active_end_date = 99991231, @active_end_time = 235959
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

EXECUTE @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @JobID, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

END
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:
</code>

Before you launch the query, be sure, that:

1st:

Exist column "Reset" in Database => MuOnline =>Character
If no, right click on table "character" and add column name: "Reset" , data type: "int" , lenght: "4", allow nulls: "NO", and setin table "Columns" default value to "(0)" .

2nd:
Column "Reset" must be set to default value "(0)". To do this, right click on character table, find reset column and disable nulls. Under the Reset column, in sction "columns", set default value to "(0)".

3rd:

Do not forget to run SQL Server agent, otherwise the script wont work.

Autoreset parameters:
Reset lvl: 380
Addpoints after reset: 1000
Stats stay: NO
Reset Cost: 50m

To autoreset: Log off for 1 minute
Done

ps: Do not write "" in tables!



Credits:

LifeStealer: Script core
HexaMaster: Rebuild to 0.99.6XT

Thank Man . But For Darklord(Class 64) the command still whit the same stats, not reset de comand stat. Any help for Reset the comand Stats??? Please Thanks

PD: Sorry for my bad English xD

[chevdox]

good very nice, i can run in 1.02j ... all it ok simple and good XD !
if it is possible to add the option to clean the inventory, or that single it allows to do reset without item put.
sorry me english XD
bb

[chevdox]

check this autoreset --> whit inventori and spell

--
-- Don`t delete this headline. It`s ingored by MSSQL
-- and will not cause any destructive effects ;]
--
--
-- SQL AutoReset script generated by &#187;Autoreset Generator&#171;
-- On day: 2006-11-13 at: 02:14
--
-- Autoreset Generator
--
--
-- AutoReset from level: 400 to level: 1
-- Increasing amount of additional points: 520 from reset
-- Increasing reset cost: 75KK from reset
--
-- Stats decrease to the basic value
-- Inventory will be cleared
-- Spells/skills will be cleared
--
-- Reset will affect only on non-connected characters
-- GMs won`t be reset
-- Characters will be warped to Lorencia
--
--
-- AutoReset is correct for column name: `Reset` in `Character` table
-- with default value: `0`
--
--

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (520 * (Reset + 1)), Money = Money - (75000000 * (Reset + 1)), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 0) OR (class = 1)) AND (clevel >= 400) AND (Money >= (75000000 * (Reset + 1))) AND (ConnectStat = 0) AND (ctlcode < 8);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (520 * (Reset + 1)), Money = Money - (75000000 * (Reset + 1)), Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 16) OR (class = 17)) AND (clevel >= 400) AND (Money >= (75000000 * (Reset + 1))) AND (ConnectStat = 0) AND (ctlcode < 8);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (520 * (Reset + 1)), Money = Money - (75000000 * (Reset + 1)), Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 32) OR (class = 33)) AND (clevel >= 400) AND (Money >= (75000000 * (Reset + 1))) AND (ConnectStat = 0) AND (ctlcode < 8);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (520 * (Reset + 1)), Money = Money - (75000000 * (Reset + 1)), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 48) OR (class = 64)) AND (clevel >= 400) AND (Money >= (75000000 * (Reset + 1))) AND (ConnectStat = 0) AND (ctlcode < 8);

Here is the web for create cryps fro quarys --> AUTORESET

[DOMI]

Thank Man . But For Darklord(Class 64) the command still whit the same stats, not reset de comand stat. Any help for Reset the comand Stats??? Please Thanks

PD: Sorry for my bad English xD

[LifeStealer]

Thank Man . But For Darklord(Class 64) the command still whit the same stats, not reset de comand stat. Any help for Reset the comand Stats??? Please Thanks

PD: Sorry for my bad English xD

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Leaderpoint = 26, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 64) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);

Good Luck. :winky:

[DOMI]

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 1000 * (Reset + 1), Money = Money - (50000000), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Leaderpoint = 26, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 64) AND (clevel >= 380) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 500);

Good Luck. :winky:

When i Put you script give me error. LeaderPoint dont exist in Character Table :S Please Help. I need Reset the comand of Darklord

[adonism]

replace the word Leaderpoint to Leadership

[DOMI]

replace the word Leaderpoint to Leadership

Thanks Man work Perfect nice nice : )