Welcome, Guest. Please login or register.
Amiga Kit Amiga Store Iridium Banner AMIStore App Store A1200/A600 4xIDE Interface

AuthorTopic: How to search the Archive?  (Read 1497 times)

0 Members and 1 Guest are viewing this topic.

Offline bloodline

  • Master Sock Abuser
  • Hero Member
  • *****
  • Join Date: Mar 2002
  • Posts: 12113
  • Total likes: 0
    • http://www.troubled-mind.com
How to search the Archive?
« 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?

Offline MickJT

Re: How to search the Archive?
« Reply #1 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.
 

Offline Khephren

Re: How to search the Archive?
« Reply #2 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.
 

Offline bloodline

  • Master Sock Abuser
  • Hero Member
  • *****
  • Join Date: Mar 2002
  • Posts: 12113
  • Total likes: 0
    • http://www.troubled-mind.com
Re: How to search the Archive?
« Reply #3 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...

Offline zipper

Re: How to search the Archive?
« Reply #4 on: April 06, 2011, 02:07:35 PM »
I found mine first 11.2008
 

Offline MickJT

Re: How to search the Archive?
« Reply #5 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.
« Last Edit: April 06, 2011, 02:14:24 PM by MickJT »
 

Offline bloodline

  • Master Sock Abuser
  • Hero Member
  • *****
  • Join Date: Mar 2002
  • Posts: 12113
  • Total likes: 0
    • http://www.troubled-mind.com
Re: How to search the Archive?
« Reply #6 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 :)

Offline Karlos

Re: How to search the Archive?
« Reply #7 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
« Last Edit: April 06, 2011, 07:39:01 PM by Karlos »
int p; // A
 

Offline crawff

Re: How to search the Archive?
« Reply #8 on: April 06, 2011, 08:54:01 PM »
great work
 

Offline bloodline

  • Master Sock Abuser
  • Hero Member
  • *****
  • Join Date: Mar 2002
  • Posts: 12113
  • Total likes: 0
    • http://www.troubled-mind.com
Re: How to search the Archive?
« Reply #9 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
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?