View topic - Got Something You Want To Say?

FAQ

Memberlist

Dramas:	a b c d e f g h i j k l m n o p r s t u v w y z 0-9	Top 100
Artistes:	a b c d e f g h i j k l m n o p r s t u v w y z	Top 100
Seasons:	Spring 2019 Summer 2019 Fall 2019 Winter 2020

Got Something You Want To Say?
Goto page Previous 1, 2, 3 ... 422, 423, 424 ... 1751, 1752, 1753 Next

jdorama.com Forum Index -> General Discussions

View previous topic :: View next topic

krim

Joined: 24 Jun 2005
Posts: 12316
Location: burunto o suimasu ka?
Country: Spain

Posted: Wed Nov 30, 2005 11:31 pm Post subject:

tabana wrote:

Genma can do it. It has been done a few days ago. http://jdorama.com/viewtopic.6165.20.htm

I'm no database expert, but it could be done very easily. Something like:

Code:

DELETE FROM members WHERE postcount = 0 AND joined_date < '2005-06-01';

or if you want to do a major cleanup Wink

Code:

DELETE FROM members WHERE postcount < 28000;

Code:

Delete * from members where name <> "krim"

tabana

Joined: 07 Oct 2005
Posts: 9573
Location: �o�J�i�_
Country: Canada

Posted: Wed Nov 30, 2005 11:36 pm Post subject:

That's good too.

dochira

Joined: 13 Oct 2004
Posts: 8550
Location: California
Country: United States

Posted: Thu Dec 01, 2005 2:57 am Post subject:

bmwracer wrote:

Sleeping in tomorrow. Let those other suckers get up early and get trampled for an early morning sale... Beaten

I was out there that morning. My sister really wanted a cheap laptop. Despite my pleas that the queue would be insane, we still went. The laptop was gone in 10 minutes, but I got a $10 Bluetooth headset instead. Now if I only had a Bluetooth phone... Beaten

dochira

Joined: 13 Oct 2004
Posts: 8550
Location: California
Country: United States

Posted: Thu Dec 01, 2005 2:59 am Post subject:

tabana wrote:

or if you want to do a major cleanup Wink

Code:

DELETE FROM members WHERE postcount < 28000;

Crap, that'll reduce the site to only one user. hehe

K.T.Tran

Joined: 17 Sep 2004
Posts: 14056
Location: San Ho Se, Ka-Ri-Por-Nya
Country: Vietnam

Posted: Thu Dec 01, 2005 3:05 am Post subject:

dochira wrote:

Crap, that'll reduce the site to only one user. hehe

HAHAHAHA

How ya been Doc?
Haven't seen you post in a while
_________________

Tu_triky

Joined: 15 Jun 2004
Posts: 46182
Location: Los Skandolous, California
Country: United States

Posted: Thu Dec 01, 2005 3:08 am Post subject:

dochira wrote:

Crap, that'll reduce the site to only one user. hehe

no sh8t....hey man i thought you fell in a bowl of curry or sumptin.....what did you fall into an extended food coma from eating too many lumpia Beaten

i kept yelling "dochira-sama doko desu ka?" Bleah

dochira

Joined: 13 Oct 2004
Posts: 8550
Location: California
Country: United States

Posted: Thu Dec 01, 2005 3:11 am Post subject:

K.T.Tran wrote:

HAHAHAHA

How ya been Doc?
Haven't seen you post in a while

Yup, I was in San Diego for over Thanksgiving and then stayed with my wife at her teacher's conference. Just got back last night, and now I'm at work trying to catch up here and, of course, here as well.

@Tu: If I fell into curry, I'd stick to high heaven, but I'll still be in heaven. hehe

Tu_triky

Joined: 15 Jun 2004
Posts: 46182
Location: Los Skandolous, California
Country: United States

Posted: Thu Dec 01, 2005 3:19 am Post subject:

dochira wrote:

Yup, I was in San Diego for over Thanksgiving and then stayed with my wife at her teacher's conference. Just got back last night, and now I'm at work trying to catch up here and, of course, here as well.

@Tu: If I fell into curry, I'd stink to high heaven, but I'll still be in heaven. hehe

glad to hear you are alive and well....you should have passed by l.a. and had a meal at one of the dozen japanese restaurants that we've been yapping about...so what part of san diego did you go to...mira mesa? otherwise known as manila mesa Bleah

rumor was you left the states and went to japan on a rina uchiyama stalking hunt... Beaten

dochira

Joined: 13 Oct 2004
Posts: 8550
Location: California
Country: United States

Posted: Thu Dec 01, 2005 3:22 am Post subject:

Tu_triky wrote:

Close enough. I was near Chula Vista.

Tu_triky wrote:

rumor was you left the states and went to japan on a rina uchiyama stalking hunt... Beaten

That only happens when I close my eyes for the evening. Sweat

bmwracer

Joined: 07 Jul 2003
Posts: 125547
Location: Juri-chan's speed dial
Country: United States

Posted: Thu Dec 01, 2005 3:24 am Post subject:

dochira wrote:

Aww, too bad you couldn't have stopped by. .. Puppy Dog Eyes

Tu_triky

Joined: 15 Jun 2004
Posts: 46182
Location: Los Skandolous, California
Country: United States

Posted: Thu Dec 01, 2005 3:27 am Post subject:

dochira wrote:

That only happens when I close my eyes for the evening. Sweat

you sound fine....

anata wa heiki desu... Mr Green

z123_us

Joined: 06 Feb 2005
Posts: 2572

Posted: Thu Dec 01, 2005 3:30 am Post subject:

bmwracer wrote:

I wouldn't even send out a mass mail: they'll just make one post or two then disappear again...

Just wack the zero posters and be done with it. Smack!

what the heck .. this way they cant say we did'nt tell them .... and u i wont be surprized if hardly any post still

dochira

Joined: 13 Oct 2004
Posts: 8550
Location: California
Country: United States

Posted: Thu Dec 01, 2005 3:31 am Post subject:

bmwracer wrote:

Aww, too bad you couldn't have stopped by. .. Puppy Dog Eyes

It's just 2 hours away, right?

bmwracer

Joined: 07 Jul 2003
Posts: 125547
Location: Juri-chan's speed dial
Country: United States

Posted: Thu Dec 01, 2005 3:38 am Post subject:

dochira wrote:

It's just 2 hours away, right?

From San Diego, yeah.

1-1/2 hours if I'm driving. Wink

qilver

Joined: 28 Sep 2004
Posts: 25363

Posted: Thu Dec 01, 2005 3:58 am Post subject:

bmwracer wrote:

Aww, too bad you couldn't have stopped by. .. Puppy Dog Eyes

you drove all the way down from SJ area?, traffic must've been quite bad on the 5fwy. yeah, about 2 hrs from SD to OC/LA area.

dochira

Joined: 13 Oct 2004
Posts: 8550
Location: California
Country: United States

Posted: Thu Dec 01, 2005 4:00 am Post subject:

qilver wrote:

you drove all the way down from SJ area?, traffic must've been quite bad on the 5fwy. yeah, about 2 hrs from SD to OC/LA area.

I don't dare drive during the Thanksgiving time. Flew of course. Big Grin

Tu_triky

Joined: 15 Jun 2004
Posts: 46182
Location: Los Skandolous, California
Country: United States

Posted: Thu Dec 01, 2005 4:02 am Post subject:

dochira wrote:

I don't dare drive during the Thanksgiving time. Flew of course. Big Grin

it just proves ur not suicidal

dochira

Joined: 13 Oct 2004
Posts: 8550
Location: California
Country: United States

Posted: Thu Dec 01, 2005 4:04 am Post subject:

Tu_triky wrote:

it just proves ur not suicidal

I did one year. It took us a long time to get from LAX to the 405-5 junction. After time experience, never again. I only need to be zapped once to know it's probably a good idea to stay away.

Tu_triky

Joined: 15 Jun 2004
Posts: 46182
Location: Los Skandolous, California
Country: United States

Posted: Thu Dec 01, 2005 4:07 am Post subject:

dochira wrote:

I did one year. It took us a long time to get from LAX to the 405-5 junction. After time experience, never again. I only need to be zapped once to know it's probably a good idea to stay away.

when i was living on the east coast one year i was flying out of newark new jersey on american airlines and those f*ckers decide to go on strike on THANKSGIVING...my direct flight from newark to l.a. turned into a 10 hour mult-leg affair.....talk about a BAD fuggin' trip... bleh

bmwracer

Joined: 07 Jul 2003
Posts: 125547
Location: Juri-chan's speed dial
Country: United States

Posted: Thu Dec 01, 2005 4:18 am Post subject:

Tu_triky wrote:

i say they e-mail them all with a virus. hehe

j/k

No you're not. Wink

Did you guys notice that more than half of the people with b-days today have zero posts?? Shake Head

Time to unsheathe the admin katana and start whacking away...

Display posts from previous:

	jdorama.com Forum Index -> General Discussions	All times are GMT + 8 Hours Goto page Previous 1, 2, 3 ... 422, 423, 424 ... 1751, 1752, 1753 Next
Page 423 of 1753

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum