AutoReset Script[SQL] + Full Details

Quote:

---

Originally Posted by jduval

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.

tnx for the info man..

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

SET clevel = 1, and SET clevel=('1'), are the same ??

How make auto reset script for 5DB? Me_Muonline And Muonline... Now I Have Memb_Info Bug :(

Do you have AutoReset script for S3 ???

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:

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

Quote:

---

Originally Posted by lhootak

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;

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