AutoReset Script[SQL] + Full Details

Re: [Guide] AutoReset Script[SQL] + Full Details

Help me create script who need cleare all inventory - then reset

Code:
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 350 * (Reset + 1), Money = Money - (50000000), Inventory = NULL, MagicList = NULL, 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 >= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) [b]AND (Inventory = NULL)[/b];

where is error?
 
Re: [Guide] AutoReset Script[SQL] + Full Details

guys, i have a question about this

ConnectStat = 0

this means that the user will be resetted when he's not online, right

my question is if it is possible that the character will be resetted whether he is online or not by removing this ConnectStat = 0
so that the last part of the script will be

WHERE ((class = 0) OR (class = 1)) AND (clevel >= 350) AND (Money >= (50000000)) AND (Inventory = NULL)


is this possible?
 
Re: [Guide] AutoReset Script[SQL] + Full Details

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...
 
Re: [Guide] AutoReset Script[SQL] + Full Details

guys, i have a question about this

ConnectStat = 0

this means that the user will be resetted when he's not online, right

my question is if it is possible that the character will be resetted whether he is online or not by removing this ConnectStat = 0
so that the last part of the script will be

WHERE ((class = 0) OR (class = 1)) AND (clevel >= 350) AND (Money >= (50000000)) AND (Inventory = NULL)


is this possible?

Impossible.
 
Re: [Guide] AutoReset Script[SQL] + Full Details

Hmm, can someone please give me script for this one -> After reset stats goes back normal, 300 points 1st reset, 600 2nd and so on, Reset cost 200kk. ThanQ ;)

Edit: 1st res - 350 lvl, 2nd - 352, 3rd - 353, 4th - 354 and so on :P
 
Re: [Guide] AutoReset Script[SQL] + Full Details

How make auto reset script for 5DB? Me_Muonline And Muonline... Now I Have Memb_Info Bug :(
 
Re: [Guide] AutoReset Script[SQL] + Full Details

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 :grr:
 
Re: [Guide] AutoReset Script[SQL] + Full Details

As if I want to reset it for each request 50kk the first and second 50kk + 20kk additional
 
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;
 
Last edited:
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
 
Back