Preech
04-17-2012, 05:53 PM
So this is my php script.
<?php
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
// #################### DEFINE IMPORTANT CONSTANTS #######################
define('THIS_SCRIPT', 'vbmusic_album');
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('vbmusic_album',
);
// pre-cache templates used by specific actions
$actiontemplates = array('vbmusic_album');
// ######################### 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('' => 'Album'));
$navbar = render_navbar_template($navbits);
// ###### YOUR CUSTOM CODE GOES HERE #####
$vbulletin->input->clean_gpc('r', 'id', TYPE_UINT);
$id = $vbulletin->GPC['id'];
$track = $db->query_read("SELECT tr.trname, tr.playtime AS tracktime, tr.tracknr, tr.trid, al.*,
ar.arname, co.cdecname, cd.cdid, cd.playtime AS cdtime, cd.cdname, ge.genname,
cn.cntyname, fe.ext AS filext
FROM " . TABLE_PREFIX. " track tr
LEFT JOIN cdlist cd ON cd.cdid=tr.cdid
LEFT JOIN album al ON al.alid=cd.alid
LEFT JOIN artist ar ON ar.arid=al.arid
LEFT JOIN codec co ON co.cdecid=al.codec
LEFT JOIN genre ge ON ge.genid=al.genre
LEFT JOIN country cn ON cn.id=al.country
LEFT JOIN filext fe ON fe.id=tr.extid
WHERE cd.alid=$id ORDER BY cd.cdname,tr.tracknr, tr.trname");
$cdcnt=1;
$cdid='0';
$cdname='';
$mart = array();
if ($db->num_rows($track))
{
while ($musical = $db->fetch_array($track))
{
$mart[] = $musical;
}
}
$db->free_result($track);
// ###### NOW YOUR TEMPLATE IS BEING RENDERED ######
$templater = vB_Template::create('vbmusic_album');
$templater->register_page_templates();
$templater->register('navbar', $navbar);
$templater->register('mart', $mart);
print_output($templater->render());
?>
// ###### NOW YOUR TEMPLATE IS BEING RENDERED ######
So it seems to me, everything is correct, no errors. When I go to try to get my data to show up through the template, nothing. Could anyone explain to me what I'm doing wrong.
Before I forget. I am getting to this page by clicking a link from another page.
The link is something like this. something.php?id={vb:raw something}
I got the id..but I can't get any of the info that may go with that id.
<?php
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
// #################### DEFINE IMPORTANT CONSTANTS #######################
define('THIS_SCRIPT', 'vbmusic_album');
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('vbmusic_album',
);
// pre-cache templates used by specific actions
$actiontemplates = array('vbmusic_album');
// ######################### 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('' => 'Album'));
$navbar = render_navbar_template($navbits);
// ###### YOUR CUSTOM CODE GOES HERE #####
$vbulletin->input->clean_gpc('r', 'id', TYPE_UINT);
$id = $vbulletin->GPC['id'];
$track = $db->query_read("SELECT tr.trname, tr.playtime AS tracktime, tr.tracknr, tr.trid, al.*,
ar.arname, co.cdecname, cd.cdid, cd.playtime AS cdtime, cd.cdname, ge.genname,
cn.cntyname, fe.ext AS filext
FROM " . TABLE_PREFIX. " track tr
LEFT JOIN cdlist cd ON cd.cdid=tr.cdid
LEFT JOIN album al ON al.alid=cd.alid
LEFT JOIN artist ar ON ar.arid=al.arid
LEFT JOIN codec co ON co.cdecid=al.codec
LEFT JOIN genre ge ON ge.genid=al.genre
LEFT JOIN country cn ON cn.id=al.country
LEFT JOIN filext fe ON fe.id=tr.extid
WHERE cd.alid=$id ORDER BY cd.cdname,tr.tracknr, tr.trname");
$cdcnt=1;
$cdid='0';
$cdname='';
$mart = array();
if ($db->num_rows($track))
{
while ($musical = $db->fetch_array($track))
{
$mart[] = $musical;
}
}
$db->free_result($track);
// ###### NOW YOUR TEMPLATE IS BEING RENDERED ######
$templater = vB_Template::create('vbmusic_album');
$templater->register_page_templates();
$templater->register('navbar', $navbar);
$templater->register('mart', $mart);
print_output($templater->render());
?>
// ###### NOW YOUR TEMPLATE IS BEING RENDERED ######
So it seems to me, everything is correct, no errors. When I go to try to get my data to show up through the template, nothing. Could anyone explain to me what I'm doing wrong.
Before I forget. I am getting to this page by clicking a link from another page.
The link is something like this. something.php?id={vb:raw something}
I got the id..but I can't get any of the info that may go with that id.