vb.org Archive - View Single Post - Newspro + VBulletin Question (or any other good program)

#4 01-23-2001, 11:38 PM

im working on a new version of the newspro+vb integration thang that does most of what you want. i dont have the # of comments thing down just yet, but im working on it =D

in the meantime you can make a script like this, and plop it in your vb dir:

Code:

<? 
//Newspro link to vB forum thread finder
//vbGenGetThread.php
<? 
require("global.php"); 

$title="News: ".$subject;
//echo "$title";
$threads = $DB_site->query("SELECT threadid FROM thread WHERE title='".addslashes($title)."'"); 
while ($thread = $DB_site->fetch_array($threads)) { 
//echo "$thread[0]";
$url="http://www.tribalwar.com/forums/showthread.php?threadid=".$thread[0];
//echo "<a href=$url>test</a>";
if(!$thread[0]){header("Location: http://www.tribalwar.com/");}
header("Location: $url");
} 
?>

obviously if you use a prefix other then News: you'll have to change that part, and adjust the links to showthread.php and nocomment.shtml (or whatever you want to take them back to if theres no comment thread)

theres some problems with it (like it selects the last thread to be posted w/ that name, so if you have 2 identically titled news posts that you want active comment threads for you're SOL for now) but it works nicely for me

see it in action @ http://www.tribalwar.com/

also, so far as only doing it for each category, in newspro set your category in question to use a different doHTML subroutine, and then copy your current doHTML, name it what you told the category to use, and add something like

Code:

<a href="http://www.tribalwar.com/forums/vbgenGetThread.php?subject=$newssubject">Comments&gt;&gt;</a>

wherever you want for a Comments link. again, use your link to your script, but that should work (except for the number of comments, but as i said i havent really figured how to go about that yet)

[Edited by Ratorasniki on 01-23-2001 at 08:50 PM]

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02158 seconds Memory Usage 1,764KB 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 (2)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: