SQL Query To Delete Empty Accounts

[metallica]

i need any like ass but..need delete X pjs of X level whit restriction..example

delete (all char(dk) and lvl =1) in acc whit char lvl max = 400

u understern?...tks..

[themad]

i need any like ass but..need delete X pjs of X level whit restriction..example

delete (all char(dk) and lvl =1) in acc whit char lvl max = 400

u understern?...tks..

lol im not sure what u just said but...i gues u want this

delete from character where class=('16') and clevel=('1')
delete from character where class=('0') and clevel=('1')
delete from character where class=('32') and clevel=('1')

this will delete all characters who have not completed the quest and are level 1

[metallica]

lol im not sure what u just said but...i gues u want this

delete from character where class=('16') and clevel=('1')
delete from character where class=('0') and clevel=('1')
delete from character where class=('32') and clevel=('1')

this will delete all characters who have not completed the quest and are level 1

very tks..but need :


delete from character where [class=('16') and clevel=('1')] AND [the char lvl max of ACC <= 100]


I wan DELETE ALL CHAR (class=('16') and clevel=('1')) IN ACC WHIT CHARs <= 100

u understen my script?...

[HackingSkills]

try this one too. this deletes empty accounts

truncate table nullaccounts;
insert into nullaccounts SELECT a.memb___id, b.AccountID FROM MEMB_INFO a
LEFT JOIN (SELECT DISTINCT AccountID FROM [Character]) b
ON a.memb___id = b.AccountID
WHERE b.AccountID IS NULL;

declare @neym nvarchar(10)

DECLARE my_pointer CURSOR FOR Select username from nullaccounts
open my_pointer
FETCH NEXT FROM my_pointer INTO @neym WHILE
@@FETCH_STATUS=0

BEGIN
delete from memb_info where @neym=memb___id
delete from vi_curr_info where @neym=memb___id
FETCH NEXT FROM my_pointer INTO @neym
END

close my_pointer
deallocate my_pointer

you need to create a table named "nullaccounts" with fields username and status. both of nvarchar with 10 width

[Josh]

ROFL, just deleted 96 acc! And reg was closed! Thanks!!

[FragFrog]

try this one too. this deletes empty accounts



you need to create a table named "nullaccounts" with fields username and status. both of nvarchar with 10 width

Um.. That does EXACTLEY the same as my script, but its more difficult to use... So why the hell would anybody want it? :icon6:

[~~Cash~~]

Need script for delete DarkLord create not 300 Level whis AccountCharacter
(Sorry My English)from Russia whis love)))