Amiga.org

Amiga.org specific forums => Amiga.org Discussion and Site Feedback => Topic started by: bloodline on April 06, 2011, 12:42:26 PM

Title: How to search the Archive?
Post by: bloodline on April 06, 2011, 12:42:26 PM

I fancy looking at my first posts here after the reboot back in 2002... How can I see them?

Title: Re: How to search the Archive?
Post by: MickJT on April 06, 2011, 12:53:13 PM

Quote from: bloodline;628992

I fancy looking at my first posts here after the reboot back in 2002... How can I see them?

http://www.amiga.org/forums/search.php

Just type in your username.

Title: Re: How to search the Archive?
Post by: Khephren on April 06, 2011, 01:01:43 PM

I'd like ro read my posts before 2002 ;)  I bet I spout the same crap I do now.

Title: Re: How to search the Archive?
Post by: bloodline on April 06, 2011, 01:13:55 PM

Quote from: MickJT;628993

http://www.amiga.org/forums/search.php

Just type in your username.

I already tried that, but it only gies back to the cms switchover in 2009...

Title: Re: How to search the Archive?
Post by: zipper on April 06, 2011, 02:07:35 PM

I found mine first 11.2008

Title: Re: How to search the Archive?
Post by: MickJT on April 06, 2011, 02:08:41 PM

Quote from: bloodline;628999

I already tried that, but it only gies back to the cms switchover in 2009...

I can see my first post in 2004. Checking the page numbers at the bottom right?

Just checked your username, and yeah, 2009. Were you using a different username before then?

OK. Found your first thread from 2002, http://www.amiga.org/forums/showthread.php?t=42668

Basically, go to your own user profile page, click Statistics, then click "Find all threads started by bloodline".

You can't find all posts though. Seems to only search up to 500 results.

Title: Re: How to search the Archive?
Post by: bloodline on April 06, 2011, 02:51:22 PM

@MickJT ahhh, very clever yes, that is the oldest thread I started... Pleasingly it's AROS related, I was very zealotted back in the day :)

Still... I can't find my oldest post, since I've posted too many and the database won't search that far :)

I expect my first post was a rant against the PPC and very Pro x86 :)

Title: Re: How to search the Archive?
Post by: Karlos on April 06, 2011, 07:27:46 PM

@bloodline

Try:

SELECT FROM_UNIXTIME(dateline) AS date_posted, title, pagetext FROM post WHERE userid=298 ORDER BY dateline ASC LIMIT 100;

voila:

http://www.amiga.org/forums/showpost.php?p=459470&postcount=1 (http://www.amiga.org/forums/showpost.php?p=459470&postcount=1)

Title: Re: How to search the Archive?
Post by: crawff on April 06, 2011, 08:54:01 PM

great work

Title: Re: How to search the Archive?
Post by: bloodline on April 06, 2011, 09:04:38 PM

Quote from: Karlos;629195

@bloodline

Try:

SELECT FROM_UNIXTIME(dateline) AS date_posted, title, pagetext FROM post WHERE userid=298 ORDER BY dateline ASC LIMIT 100;

voila:

http://www.amiga.org/forums/showpost.php?p=459470&postcount=1 (http://www.amiga.org/forums/showpost.php?p=459470&postcount=1)

Holly Carp! So that was my first A.org post after the reboot... I feel all nostalgic :)

-Edit- at 3 in the morning!?!?! Is that right?