Welcome, Guest. Please login or register.

Author Topic: How to search the Archive?  (Read 1996 times)

Description:

0 Members and 1 Guest are viewing this topic.

Offline bloodlineTopic starter

  • Master Sock Abuser
  • Hero Member
  • *****
  • Join Date: Mar 2002
  • Posts: 12113
    • Show only replies by bloodline
    • 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

  • Full Member
  • ***
  • Join Date: May 2004
  • Posts: 153
    • Show only replies by MickJT
    • http://members.iinet.net.au/~trebs/AmiMSN
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

  • Hero Member
  • *****
  • Join Date: Feb 2002
  • Posts: 606
    • Show only replies by 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 bloodlineTopic starter

  • Master Sock Abuser
  • Hero Member
  • *****
  • Join Date: Mar 2002
  • Posts: 12113
    • Show only replies by bloodline
    • 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

  • Full Member
  • ***
  • Join Date: May 2004
  • Posts: 153
    • Show only replies by MickJT
    • http://members.iinet.net.au/~trebs/AmiMSN
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 bloodlineTopic starter

  • Master Sock Abuser
  • Hero Member
  • *****
  • Join Date: Mar 2002
  • Posts: 12113
    • Show only replies by bloodline
    • 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

  • Sockologist
  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Nov 2002
  • Posts: 16867
  • Country: gb
  • Thanked: 4 times
    • Show only replies by 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

  • Full Member
  • ***
  • Join Date: Feb 2009
  • Posts: 240
    • Show only replies by crawff
Re: How to search the Archive?
« Reply #8 on: April 06, 2011, 08:54:01 PM »
great work
 

Offline bloodlineTopic starter

  • Master Sock Abuser
  • Hero Member
  • *****
  • Join Date: Mar 2002
  • Posts: 12113
    • Show only replies by bloodline
    • 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?