vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Last XXX post on a non vb page but with first post instead of last post (https://vborg.vbsupport.ru/showthread.php?t=52483)

Sharg 05-02-2003 06:49 PM

Last XXX post on a non vb page but with first post instead of last post
 
Hi,
I would like a hack similar to the old and popular "Last XXX post on a non vb page" from tubedog ( https://vborg.vbsupport.ru/showthrea...hlight=tubedog ) but instead of looking for the last post of a thread, it should look only for the first post.

This way, when user comment a news ( thread) it doesn't care about the users reply and won't bumb up the title back up.

N!ck 05-02-2003 09:51 PM

You run an XXX board? ;)

Anyway, just take change ORDER BY lastpost DESC in the SQL query to ORDER BY dateline DESC

Sharg 05-03-2003 01:15 AM

I edited the config file and the sorting is correct. Problem now is that it stills pulls the date and text from last post instead of first thread post :/..

N!ck 05-03-2003 03:35 AM

change all instances of lastpost to dateline

Sharg 05-03-2003 10:21 AM

Thanks for your help . Now everything is good except the message text it still extract from last posts !?

Sharg

Sharg 05-03-2003 10:54 AM

I think I got it :)

I changed ORDER BY dateline DESC LIMIT to
1 ORDER BY dateline ASC LIMIT 1 and it did it :) .

Thanks for your help.
Sharg

N!ck 05-03-2003 04:22 PM

Ah, I didn't understand that you wanted to show the very first threads in the forum. But heck, if you're gonna do that, why not just hardcode the links?

If you do decide to stick with that query, you can just remove ASC, as it doesn't do anything really.

Sharg 05-04-2003 03:38 AM

Hello,
what do you need when you suggest to "hardcode" the links ?

Cordially,
Sharg

N!ck 05-05-2003 12:40 AM

I mean, just put the HTML right in the template. :) It will remove a query and thereby reduce your server load--slightly.


All times are GMT. The time now is 08:24 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01008 seconds
  • Memory Usage 1,719KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete