vb.org Archive - View Single Post - Slashdot.org-style news posting system

#29 09-06-2000, 04:33 AM

I had toyed w/ the idea of limiting the front page characters in but decided to wait on it until I had a more elegant solution than just gutting the story after 255 chars or whatever... Did ya'll solve this problem so that the script can cut it at an arbitrary point or just chops it @ 255? I didn't want to lose it in mid sentence...maybe I'll have it parse for \n\n or something, but that would limit pagination in the news script...that's no good either. I'll have to think about it.

Also, to the person who had asked about the additional hacks...

1) Yes it would be *possible* to have the script search through all the threads in all the forums for specially designated news threads but IMHO it would be a bad idea, because it would be a HUGE strain on the server as opposed to how it is now, where it just grabs the first X amount of threads from X forum. I could probably advise you on how to do it, but I don't really want to. sorry.

2) Logo like a picture or an avatar? Yes that would be a very simple and easy to add hack. If there is a "standard" avatar hack for vB could someone please point me to it and I'll add the code for the BFC, otherwise it would be a unique hack for every vB according to the mySQL field you added for your avatars...

3) I think so...I'll look into it.

4) Possible, and probable! In fact, here is the code:

Code:

<?php

require("bfc.php");

$footer_sql = "SELECT * FROM thread WHERE forumid=$newsforum ORDER BY dateline DESC LIMIT $bfcnewslimit,5";

$footer_result = mysql_query($footer_sql);

while($myrow = mysql_fetch_array($footer_result))
	{
	$threadid = $myrow["threadid"];
	$subsql = "SELECT * FROM post WHERE threadid=$threadid ORDER BY postid LIMIT 1;";
	$subresult = mysql_query($subsql);
	$posts = mysql_fetch_array($subresult);
	   	
	printf("<a href=\"%s/showthread.php?threadid=%s\">%s</a><br><br>",$forum_url,$threadid,$myrow["title"]);
	   }
   	
?>

Add that to your PHP file, I wrote it off the top of my head so if it doesn't work play w/ it or let me know...you'll obviously have to change your db settings.

Regards,
Paul

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01146 seconds Memory Usage 1,766KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: