Как удалить неактивные аккаунты на MU online SQL Server?

[Dzib]

Как удалить акаунты на которие не заходили неделю?

и ещё подскажите как удалить всех персонажей где уровень меньше чем 100

[GrInYa]

delete from character where clevel < 100

[Dzib]

спосиба за ответ на творой вопрос, а кто мог бы на первый ответить:?)

и ещё пожалуйста подскажите скрипт на удаления акаунтов на которих нет персонажей

[ketanof]

спосиба за ответ на творой вопрос, а кто мог бы на первый ответить:?)

и ещё пожалуйста подскажите скрипт на удаления акаунтов на которих нет персонажей

Спойлер

Well the scripts for clear accounts need a extra column or a table, well i have find a nice code made by HackingSkills in this topic https://forum.ragezone.com/old-releases/rel...unts-75721.html and i have changed some things to work without the table he says

Code:

--Original by HackingSkills
--Modified by navossoc

declare @neym nvarchar(10)

DECLARE my_pointer CURSOR FOR SELECT a.memb___id FROM MEMB_INFO a
LEFT JOIN (SELECT DISTINCT AccountID FROM [Character]) b
ON a.memb___id = b.AccountID
WHERE b.AccountID IS NULL

open my_pointer
FETCH NEXT FROM my_pointer INTO @neym WHILE
@@FETCH_STATUS=0

BEGIN
delete from accountcharacter where @neym=id
--delete from extwarehouse where @neym=accountid
delete from memb_info where @neym=memb___id
delete from memb_stat where @neym=memb___id
delete from vi_curr_info where @neym=memb___id
delete from warehouse where @neym=accountid
FETCH NEXT FROM my_pointer INTO @neym
END

close my_pointer
deallocate my_pointer

I think is better add some tables in for delete, because if u delete the account by a editor or what the hell happens with he... he clean everything, if u use the 1.1e u can remove the -- from extwarehouse, or if u wanna see the names of the peoples u are deleting try run just this code:

Code:

SELECT a.memb___id FROM MEMB_INFO a
LEFT JOIN (SELECT DISTINCT AccountID FROM [Character]) b
ON a.memb___id = b.AccountID
WHERE b.AccountID IS NULL

Made a backup before running i have tested and works fine
I am thankful for sugestions

CAREFULL WITH THE COLLATION IN 1.0 OR 1.1
[]'s

[свернуть]

[lisenok]

Здраствуйте! не могу создать тему поэтому пишу тут! Помогите! как убрать с сервера /reset?? и как убрать баг с сумкой! при нажать кнопки открыть магии (образно)! нечего не открывается!

[Ronny]

В Mu Maker есть такая опция, выбираешь время и удаляешь.

[WakeUp]

Как удалить акаунты на которие не заходили неделю?

ну вот как-то так можно..

Код Выделить Развернуть

declare @deldate datetime
set @deldate = '2011-04-01'

DECLARE tnames CURSOR
FOR select memb___id from memb_stat where connecttm < @deldate  or disconnecttm < @deldate
open tnames
DECLARE @tablename sysname
FETCH NEXT FROM tnames INTO @tablename
WHILE @@FETCH_STATUS = 0
BEGIN
delete accountcharacter where id = @tablename
delete character where accountid = @tablename
delete memb_info where memb___id = @tablename
delete vi_curr_info where memb___id = @tablename
delete warehouse where accountid = @tablename
delete extwarehouse where accountid = @tablename
print 'delete account: ' + @tablename
FETCH NEXT FROM tnames INTO @tablename
END
close tnames
DEALLOCATE tnames

delete character where accountid not in (select memb___id from memb_info)
delete accountcharacter where id not in (select memb___id from memb_info)
delete warehouse where accountid not in (select memb___id from memb_info)
delete extwarehouse where accountid not in (select memb___id from memb_info)