Wipe Discussion Relief Thread

[dragonistrypsis]

I like this thread because I also wipe after being reliefed

oh yeah, I took a Talad   and wiped my Laanx,   and felt much lighter.


yeah, I know, I was one of the most outspoken against it at first, but I've had some breathing time with the paper bag.

[derula]

Does that mean they wipe my logs??? Is there a way to back them up?? I don't want to lose my logs... *cries*

* derula lies down on a nearby Ulber fur and coils up, occasionally sobbing "no, not my logs..."

[steuben]

aren't logs just dead trees... for that matter where did you get logs ingame. i didn't think they were implemented yet.

[Rigwyn]

A Wipe ? Oh noooos... Guess I'll have to start mining plat so I can buy some new Q300's   
Oh !     Wait a minute ... 
You mean its back to killing rats with a lame q50 that I can no longer buy from NPC's  ? 
   

[gaelfx]

The only thing I want is a garauntee that after the wipe, our Yliakum won't be crawling with Klingons and such, that would make things faaaar too complicated.

(I couldn't help it, I had to perform at least a little lameness  )

[Syenna]

Does that mean they wipe my logs??? Is there a way to back them up?? I don't want to lose my logs... *cries*

* derula lies down on a nearby Ulber fur and coils up, occasionally sobbing "no, not my logs..."

Just save a copy outside where they usually go on your computer.

[gaelfx]

We need a new forum emoticon for "over your head" jokes, apparently

[derula]

We need a new forum emoticon for "over your head" jokes, apparently

Agreed.

[weltall]

DELETE FROM characters;


Edit: ops wrong window.

[neko kyouran]

begin tran
DELETE FROM characters;
--rollback
--commit

f'xd

[derula]

DELETE FROM characters;

Can't you start a poll for which query to use?

My vote goes for DELETE FROM characters WHERE user_id != (SELECT id FROM users WHERE email = '[email id removed]')

(okay this probably won't do what I want it to do; whatever you know what I mean)

[weltall]

DELETE FROM characters;

Can't you start a poll for which query to use?

My vote goes for DELETE FROM characters WHERE user_id != (SELECT id FROM users WHERE email = '')

(okay this probably won't do what I want it to do; whatever you know what I mean)

yeah that will show many errors

this works better DELETE FROM characters where account_id != (SELECT id from accounts where username = "...."); btw i'd suggest you to remove your email from your message

[neko kyouran]

/sigh

Code: [Select]

BEGIN TRAN
DELETE
FROM tCharacters
join tAccounts ON tCharacters.account_id = tAccounts.account_id
WHERE
tAccounts.username = 'Nekos Account Name'

--rollback
--commit

more efficient DB handling to use join statement than nested select statements! 

[weltall]

it seems neko wants to optimize wipes so we can wipe faster

[neko kyouran]

Well, as we all are aware, making sure wiping is done properly makes sure there isn't any leftover bits still hanging around to cause issues later on.  ;-)