- Joined
- Apr 5, 2007
- Messages
- 5
- Reaction score
- 0
Re: [Guide] AutoReset Script[SQL] + Full Details
wow
wow
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];
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?
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...