x-MU.net форум

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