vb.org Archive - News Out - posts from forum(s) on any page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)

- - News Out - posts from forum(s) on any page (https://vborg.vbsupport.ru/showthread.php?t=65114)

Well, it probably is the forumspath that has not been defined correctly.

Look for $forumspath

Smilies works fine on my site. It took me awhile to figure it out, lol ... *sigh* I'm happy I'm done with figuring it out. *laughs*

Hmmm. the smilies are there if you view the newsout.php output, but disappear once the file is included into the .shtml page :confused:

having problems...i really want this to work properly...

here goes:

http://dfmafia.net/forums/newsout.php <-- works fine

http://dfmafia.net/network1.php <--- inop (its after the text "Need to fix the News script that when it grabs the articles out of the forums we don't loose right content ")

heres the code im using to include the newsout.php:

PHP Code:


		
			
<?php
include('/THE/DIRECTORY/TO/forums/newsout.php');
?>

(its after the text "Need to fix the News script that when it grabs the articles out of the forums we don't loose right content ")

that first NEWS block works fine but all it did was grab the titles...i want part of the text as well...

http://dfmafia.net/network.php

im using the below script and it gets what i want but i loose the right table and footer on the page...

PHP Code:


		
			
<?php
error_reporting(E_ALL & ~E_NOTICE);
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'news');
require_once('global.php');
require_once('./forums/includes/functions_bbcodeparse.php');
$news = mysql_query("select thread.threadid,thread.title,thread.replycount,thread.postusername,thread.dateline,post.postid,post.pagetext from thread,post where thread.forumid=3 and post.postid=thread.firstpostid group by thread.firstpostid order by threadid desc limit 10;");
$n = 0;
while($newsitem = mysql_fetch_row($news)){
$n++;
$newstitle[$n]=$newsitem["1"];
$newsreply[$n]=$newsitem["2"];
$newsuser[$n]=$newsitem["3"];
$newsdate[$n]=vbdate("D j M Y, g:i A",$newsitem["4"]);
$newsthread[$n]=$newsitem["5"];
$limittext[$n] = substr($newsitem["6"], 0, 200) . "...";
$newstext[$n]=parse_bbcode($limittext[$n]);
$newsavatar[$n]=$newsitem["7"];
}
eval('$newstables = "' . fetch_template('news_table_s') . '";');
eval('$newstablem = "' . fetch_template('news_table_m') . '";');
eval('$newstablee = "' . fetch_template('news_table_e') . '";');
eval('print_output("' . fetch_template('news') . '");');
?>

heres how the page is suspose to look: http://dfmafia.net/network_A.php

minus the news...it has the right and footer content

Thank you for this hack, but could you explain why I get this error by any chance?

Code:

Warning: mysql_query(): 6 is not a valid MySQL-Link resource in /home/static/public_html/forums/includes/db_mysql.php on line 212



Warning: mysql_error(): 6 is not a valid MySQL-Link resource in /home/static/public_html/forums/includes/db_mysql.php on line 357



Warning: mysql_errno(): 6 is not a valid MySQL-Link resource in /home/static/public_html/forums/includes/db_mysql.php on line 358



Warning: mysql_query(): 6 is not a valid MySQL-Link resource in /home/static/public_html/forums/includes/db_mysql.php on line 212



Warning: mysql_error(): 6 is not a valid MySQL-Link resource in /home/static/public_html/forums/includes/db_mysql.php on line 357



Warning: mysql_errno(): 6 is not a valid MySQL-Link resource in /home/static/public_html/forums/includes/db_mysql.php on line 358

everything else works fine, but at the bottom I get these errors.

Put a @ in front of the mysql queries.

eLITeGuRu,

I experienced the same as above. All working fine but I received these errors in the bottom of the page:

Code:

Warning: mysql_query(): 6 is not a valid MySQL-Link resource in usrlocalpsahomevhostsi-symbian.comhttpdocsforumincludesdb_mysql.php on line 212



Warning: mysql_error(): 6 is not a valid MySQL-Link resource in usrlocalpsahomevhostsi-symbian.comhttpdocsforumincludesdb_mysql.php on line 357



Warning: mysql_errno(): 6 is not a valid MySQL-Link resource in usrlocalpsahomevhostsi-symbian.comhttpdocsforumincludesdb_mysql.php on line 358



Warning: mysql_query(): 6 is not a valid MySQL-Link resource in usrlocalpsahomevhostsi-symbian.comhttpdocsforumincludesdb_mysql.php on line 212



Warning: mysql_error(): 6 is not a valid MySQL-Link resource in usrlocalpsahomevhostsi-symbian.comhttpdocsforumincludesdb_mysql.php on line 357



Warning: mysql_errno(): 6 is not a valid MySQL-Link resource in usrlocalpsahomevhostsi-symbian.comhttpdocsforumincludesdb_mysql.php on line 358

I have tried to put @ in front of mysql_query (there are 3 of them) like you suggested but still the same errors. It looks like this :

Code:

@mysql_query

Please advice. All appreciated.

Thanks and best regards

Can anyone help me with this 1? I get the common 3 errors at the bottom of the page, and everything is setup as it should be.

Thanks

anyone getting the three lines of text at the bottom, remove:

//disconnect
mysql_free_result($sql_result);
mysql_close($connection);

From your newsout.php file and it should resolve it. ^^

thaks dude it fixed it!

Looks to be nice when it's finished. Thanks.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01230 seconds Memory Usage 1,758KB 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 (3)bbcode_code_printable (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: