Php Code
PHP Code:
<?php
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
// #################### DEFINE IMPORTANT CONSTANTS #######################
define('THIS_SCRIPT', 'vbmusic');
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','vbmusic_latest'
);
// 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('' => 'Music'));
$navbar = render_navbar_template($navbits);
// ###### YOUR CUSTOM CODE GOES HERE #####
$musicalbum = $db->query_read("
SELECT al.alid, al.alname, al.arid, al.added, al.cvrsaved, ar.arname FROM " . TABLE_PREFIX. " album al
LEFT JOIN artist ar ON ar.arid=al.arid
ORDER BY al.alid DESC LIMIT 5
");
$musicals = array();
if ($db->num_rows($musicalbum))
{
while ($musical = $db->fetch_array($musicalbum))
{
$musicals[] = $musical;
}
}
$db->free_result($musicalbum);
$templater = vB_Template::create('vbmusic_latest');
$templater->register('musicals', $musicals);
// $templater->register('malbumid', $malbumid);
// $templater->register('malbumname', $malbumname);
//$templater->register('malbumarname', $malbumarname);
// $templater->register('malbumarid', $malbumarid);
$vbmusic_latest = $templater->render();
//$malbumid = $musical['alid'];
//$malbumname = $musical['alname'];
//$malbumarname = $musical['arname'];
//$malbumarid = $musical['arid'];
//$mcvrsaved = $musical['cvrsaved'];
$musicstat = $db->query_read("SELECT nr_artists, nr_albums,nr_tracks FROM " . TABLE_PREFIX ." stats");
while ($music_stat = $db->fetch_array($musicstat))
{
$statar = $music_stat['nr_artists'];
$statal = $music_stat['nr_albums'];
$statt = $music_stat['nr_tracks'];
}
// ###### NOW YOUR TEMPLATE IS BEING RENDERED ######
$templater = vB_Template::create('vbmusic');
$templater->register_page_templates();
$templater->register('navbar', $navbar);
$templater->register('vbmusic_latest', $vbmusic_latest);
$templater->register('cvrsaved', $cvrsaved);
$templater->register('statar', $statar);
$templater->register('statal', $statal);
$templater->register('statt', $statt);
print_output($templater->render());
?>
PHP 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}
<br /><br /><br />
<div class="colmask leftmenu">
<div class="colleft">
<div class="col1">
<!-- Column 1 start -->
<div class="audio_head">Newest Mixtapes</div>
<div class="audio_body">
<vb:each from="musicals" value="musical">
{vb:raw musical.alid}
{vb:raw musical.alname}
</vb:each>
<!--{vb:raw vbmusic_latest}-->
</div>
<!-- Column 1 end -->
</div>
<div class="col2">
<!-- Column 2 start -->
<div class="audio_head">Menu</div>
<div class="audio_body">
<table align="center" cellspacing="0" cellpadding="0" width="100%" >
<tr>
<td valign="top" align="center">
<table align="center" cellspacing="5" cellpadding="0" width="100%">
<tr>
<td align="left"><a href="vbmusic.php" title="" alt="">- Music Home</a></td>
</tr>
<tr>
<td align=\"left\"><a href=\"browse.php?typ=artist\" title=\"\" alt=\"\">- Browse Artist</a></td>
</tr>
<tr>
<td align=\"left\"><a href=\"browse.php?typ=album\" title=\"\" alt=\"\">- Browse Albums</a></td>
</tr>
<tr>
<td align=\"left\"><a href=\"browse.php?typ=genre\" title=\"\" alt=\"\">- Browse Genre</a></td>
</tr>
<tr>
<td align=\"left\"><a href=\"import.php\" title=\"\" alt=\"\">- Import Albums</a></td>
</tr>
<tr>
<td align=\"left\"><a href=\"config.php\" title=\"\" alt=\"\">- Config Settings</a></td>
</tr>
<tr>
<td align=\"left\"><a href=\"usr_list.php\" title=\"\" alt=\"\">- Userlist</a></td>
</tr>
<tr>
<td align=\"left\"><a href=\"showlog.php\" title=\"\" alt=\"\">- Show Log</a></td>
</tr>
<tr>
<td align=\"left\"><a href=\"stats.php\" title=\"\" alt=\"\">- Statistics</a></td>
</tr>
<tr>
<td align=\"left\"><a href=\"create_artist.php\" title=\"\" alt=\"\">- Create artist</a></td>
</tr>
<tr>
<td align=\"left\"><a href=\"del_artist.php\" title=\"\" alt=\"\">- Delete artist</a></td>
</tr>
</table>
</td>
</tr>
</table>
</div><br />
<div class="audio_head">Statistics</div>
<div class="audio_body">
<table align="center" cellspacing="0" cellpadding="0" width="100%">
<tr>
<td valign="top" align="center">
<table align="center" cellspacing="0" cellpadding="0" width="90%">
<tr>
<td class="data3" align="left"><b>Albums </b> </td>
<td class="data1" align="left">{vb:raw statal}</td></tr>
<tr><td class="data3" align="left"><b>Artists </b> </td>
<td class="data1" align="left">{vb:raw statar}</td></tr>
<tr><td class="data3" align="left"><b>Songs </b> </td>
<td class="data1" align="left">{vb:raw stats}</td></tr>
</table>
</td>
</tr>
</table>
</div>
<!-- Column 2 end -->
</div>
</div>
</div>
{vb:raw footer}
</body>
</html>
More Information