AutoReset Script[SQL] + Full Details

[Kosik]

Do you have AutoReset script for S3 ???

[Stefata123]

can someon give me a cript for reset like:
reset points for bk 450
for mg 600
for elf 580
for sm 520
im version 97d+99i
PLS HELP

[moles]

As if I want to reset it for each request 50kk the first and second 50kk + 20kk additional

[polskiwoj]

dude I have problem with ODBC...
gives mi this error:

'Character' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'Reset', table 'MuOnline.dbo.Tmp_Character'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

PLSS help...

use query analiser
example:

ALTER TABLE [Character] ADD [granawww] [smallint] DEFAULT(0) NOT NULL;

[rottice]

I need auto reset code for season6.

AutoReset Lvl=400
Reset Cost=10millions*resets. (example 10m*1, 10*2, 10*3 etc.)
Reset Limit=50Resets
Stats=Goes Back To Normal
CharacterutoWarp to Lorencia/Noria
Character MagicSpellList=will not be cleared
Character Inventory=will not be cleared
+Additional Pk Clear (Each Chaacter)

Additional Points(Per Reset)
dk,bk,bm= 500 point
rage fighter,first master = 600