The Arcive of vBulletin Modifications Site.

MrBeastlymfe · #1 04-27-2014, 01:51 PM

I am trying to get all the results from a table but the while loop is only outputting one thing?

home.php:

PHP Code:


			
<?php



// ####################### SET PHP ENVIRONMENT ###########################

error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################



define('THIS_SCRIPT', 'home');

define('CSRF_PROTECTION', true);  

// change this depending on your filename



// ################### PRE-CACHE TEMPLATES AND DATA ######################

// get special phrase groups

$phrasegroups = array();



// get special data templates from the datastore

$specialtemplates = array();



// pre-cache templates used by all actions

$globaltemplates = array('home_page',

);



// pre-cache templates used by specific actions

$actiontemplates = array();



// ######################### REQUIRE BACK-END ############################

// if your page is outside of your normal vb forums directory, you should change directories by uncommenting the next line

// chdir ('/path/to/your/forums');

require_once('./global.php');



// #######################################################################

// ######################## START MAIN SCRIPT ############################

// #######################################################################



$navbits = construct_navbits(array('' => 'Home Page'));

$navbar = render_navbar_template($navbits);



// ###### YOUR CUSTOM CODE GOES HERE #####

$pagetitle = 'TGS News';

$News = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "homepage_news WHERE category != 'PlayStation' ORDER BY title,description DESC");



while($row = $vbulletin->db->fetch_array($News))

{

    $pageID = $row['id'];

    $ouput = '<a href="read.php?id='.$pageID.'"><span style="font-size:22px !important;margin-top:5px !important;">'.$row['title'].'</span></a><br><span style="padding-left:9px;">'.$row['description'].'</span><br>'.$row['username'].'';

}



if($_REQUEST['id'] == true)

{

    include 'hp_read.php';

}



// ###### NOW YOUR TEMPLATE IS BEING RENDERED ######



$templater = vB_Template::create('home_page');

$templater->register_page_templates();

$templater->register('navbar', $navbar);

$templater->register('pagetitle', $pagetitle);

$templater->register('news', $ouput);

print_output($templater->render());



?>

Template:

Code:

{vb:stylevar htmldoctype}
<html xmlns="http://www.w3.org/1999/xhtml" dir="{vb:stylevar textdirection}" lang="{vb:stylevar languagecode}" id="vbulletin_html">
  <head>
    <title>{vb:raw vboptions.bbtitle} - {vb:raw pagetitle}</title>
    {vb:raw headinclude}
    {vb:raw headinclude_bottom}
  </head>
  <body>
    
    {vb:raw header}
    
    {vb:raw navbar}

<div style="float: left; width: 650px">
    <h2 class="blockhead">Site News</h2>
    <div class="blockbody">
      <div class="blockrow">
       <div style="padding:10px 10px 10px 10px;">
         <img src='holder.js/150x85' alt='Thumbnail' class="img-thumbnail img-responsive"/>
            {vb:raw news}
            {vb:raw description}
       </div>
      </div>
    </div></br>
</div>
    
<div style="float: right; width: 315px">
    <h2 class="blockhead">{vb:raw vboptions.bbtitle} Feed</h2>
    <div class="blockbody">
      <div class="blockrow">
       <a class="twitter-timeline"  href="https://twitter.com/TxShadowz"  data-widget-id="301882168601354240">Tweets by @TxShadowz</a>
    <script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],p=/^http:/.test(d.location)?'http':'https';if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=p+"://platform.twitter.com/widgets.js";fjs.parentNode.insertBefore(js,fjs);}}(document,"script","twitter-wjs");</script>
      </div>
    </div></br>
</div>

<div style="float: left; width: 650px">
    <h2 class="blockhead">Playstation News</h2>
    <div class="blockbody">
      <div class="blockrow">
        {vb:raw ps_news}<br>
        {vb:raw ps_desc}
      </div>
    </div></br>
</div>
    
    {vb:raw footer}
    <script src="http://imsky.github.com/holder/holder.js"></script>
  </body>
</html>

kh99 · #2 04-27-2014, 02:06 PM

You want to change the assignment inside the loop to "$ouput .= " (add the '.'), so that you add to the string on each iteration instead of overwriting it.

MrBeastlymfe · #3 04-27-2014, 02:26 PM

That worked! Thanks a lot!

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06768 seconds Memory Usage 4,677KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_code (1)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (3)post_thanks_box (1)post_thanks_box_bit (3)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (3)post_thanks_postbit_info (3)postbit (3)postbit_onlinestatus (3)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

Благодарность от:
Lynne