Penny Arcade Forums› Tube's Circus Of Bug Reports and User Issues

Testing?

ÄlphämönkëyÄlphämönkëy Registered User regular
edited April 2004 in Tube's Circus Of Bug Reports and User Issues
testing.

Älphämönkëy on

Posts

  • KoukenKouken Registered User regular
    edited April 2004
    test

    Kouken on
    some sig.
  • Johnny SmashJohnny Smash Tucson, AZRegistered User regular
    edited April 2004
    it didn't WORK

    edit: POST TIMER

    Johnny Smash on
    cFhq9lX.jpg
  • KoukenKouken Registered User regular
    edited April 2004
    more testing

    Kouken on
    some sig.
  • KoukenKouken Registered User regular
    edited April 2004
    shut up. Im working on it.

    Kouken on
    some sig.
  • Munkus BeaverMunkus Beaver You don't have to attend every argument you are invited to. Philosophy: Stoicism. Politics: Democratic SocialistRegistered User, ClubPA regular
    edited April 2004
    Post timer works for me

    Munkus Beaver on
    Humor can be dissected as a frog can, but dies in the process.
  • HadjiQuestHadjiQuest Registered User regular
    edited April 2004
    Can I be freed now that the Ayatollah is in power, and Reagan has taken office?

    I didn't even break a rule.....

    AND LOOK WHAT THOSE FUCKS DID!

    HadjiQuest on
  • ObbiObbi Registered User, ClubPA regular
    edited April 2004
    Shut up. he's working on it.

    Ah, the post timer works for me too, hooray!

    Obbi on
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited April 2004
    K its back. This was a spped hack that went horribly wrong.

    Älphämönkëy on
  • RamiusRamius Joined: July 19, 2000 Administrator, ClubPA admin
    edited April 2004
    speed indeed.

    ;)

    Ramius on
    1zxt8dhasaon.png
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited April 2004
    Ramius wrote:
    speed indeed.

    ;)
    // This one is the built in phpBB one
		$sql = "SELECT MAX(post_time) AS last_post_time
			FROM " . POSTS_TABLE . "
			WHERE $where_sql";

/* This is the one that is faster, but doesnt work */
		//$sql = "SELECT post_id AS last_post_id 
		//	FROM " . POSTS_TABLE . "  use INDEX(topic_n_id) 
		//	WHERE topic_id = $topic_id ORDER BY post_id LIMIT 1";
    I should never do coding when Im sick.

    Älphämönkëy on
  • RansRans Registered User regular
    edited April 2004
    heh. interesting

    Rans on
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited April 2004
    Yeah, I just forgot a significant part of the query.

    Älphämönkëy on
  • RamiusRamius Joined: July 19, 2000 Administrator, ClubPA admin
    edited April 2004
    I'm not clear why it isn't "order by post_id DESC" and I'm also not clear where $topic_id is coming from...

    Ramius on
    1zxt8dhasaon.png
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited April 2004
    bingo you got it. I forgot the DESC and the topic id is irrelevant, it was supposed to call $where_sql

    Älphämönkëy on
  • Johnny SmashJohnny Smash Tucson, AZRegistered User regular
    edited April 2004
    i can't believe you forgot to call $where_sql

    man

    Johnny Smash on
    cFhq9lX.jpg
  • incognitoincognito Registered User regular
    edited April 2004
    no me gusto what you are saying.

    incognito on
    My art thread.
    Janson: Listen bitches, just shut up and get back to licking my floor clean.
    I'm not dealing with your kind of crap today.
  • LegacyLegacy Stuck Somewhere In Cyberspace The Grid(Seattle)Registered User, ClubPA regular
    edited April 2004
    I missed all the fun...

    Legacy on
    Can we get the chemicals in. 'Cause anything's better than this.
Sign In or Register to comment.
Penny Arcade Forums› Tube's Circus Of Bug Reports and User Issues