I'm working on a template for a custom page for my site but the rows from the database are not showing up right. I'm going to post the vbulletin code and then the non-vbulletin code. Can anyone help me get it to display right?
new page
PHP Code:
<?php
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'hall_of_fame'); // 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(
'hall-of-fame',
);
// pre-cache templates used by specific actions
$actiontemplates = array(
);
// ######################### REQUIRE BACK-END ############################
require_once('./global.php');
// #######################################################################
// ######################## START MAIN SCRIPT ############################
// #######################################################################
$navbits = array();
$navbits[$parent] = 'Hall of Fame';
$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('hall-of-fame') . '");');
?>
template
PHP Code:
$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<title>$vboptions[bbtitle]</title>
$headinclude
</head>
<body>
$header
$navbar
$entries = $vbulletin->db->query_read("SELECT sotw.category, sotw.week, sotw.link, sotw.username, user.userid, user.username FROM sotw, user WHERE user.username=sotw.username");
$hallOfFameEntries = $vbulletin->db->fetch_array($entries);
do
{
$hall_o_fame_tmp = "<div class=\"hallOfamContainer\"><!-- for avatar shown with hall of famers <img src=\"image.php?u=$hallOfFameEntries[userid]\" /> --> <img src=\"$hallOfFameEntries[link]\" /><a href=\"http://www.narutosoul.com/forum/members/$hallOfFameEntries[username].html\">$hallOfFameEntries[username]</a> <span class=\"hallOfame\">$hallOfFameEntries[category]</span><span class=\"weeklys\">Winner of week # $hallOfFameEntries[week]</span></div>";
echo $hall_o_fame_tmp;
}
while($hallOfFameEntries = $vbulletin->db->fetch_array($entries));
$footer
</body>
</html>
I based it off of this script I wrote as a tester
PHP Code:
<?php
$DBCONN = mysql_connect("localhost","root", "");
$DB = mysql_select_db("sotw", $DBCONN);
$QUERY = "SELECT * FROM entries";
$SQL = mysql_query($QUERY);
$entries = mysql_fetch_assoc($SQL);
do
{
$hall_o_fame_tmp = "<div class=\"hallOfamContainer\"><img src=\"$entries[url]\" /> <a href=\"http://www.narutosoul.com/forum/members/$entries[username].html>$entries[username]</a> <span class=\"hallOfame\">$entries[theme]</span></div>";
echo $hall_o_fame_tmp;
}
while($entries = mysql_fetch_assoc($SQL))
?>
it will show the image with a link that has the code inside it for some reason it wont show as a div with the images inside with the username as a link and the theme as a span.
Changed query so I can also match userids so I can show there avatars as well.
04-21-2010, 06:47 PM
Template Help
Linear Mode
