[ajhalls]

Understand, I just keep getting errors with a page like this:

<?php

error_reporting(E_ALL & ~E_NOTICE);
define('THIS_SCRIPT', 'flashcard');

$specialtemplates = array('flashcard_catcache');
$globaltemplates = array('shell_blank');
$template_hook = array();


require_once('./global.php');

define('IS_ADMIN', is_member_of($vbulletin->userinfo, 6));

$catcache =& $vbulletin->flashcard_catcache;

if (!$_REQUEST['do'])
{
	$_REQUEST['do'] = 'home';
}

require_once(DIR . '/includes/flashcard_functions.php');

$navbits['flashcard.php'] = 'Flashcards';



// ##### Homepage #############################################################
if ($_REQUEST['do'] == 'home')
{
	$html = '<h2 class="blockhead">Browse Categories</h2> 
	<div class="blockbody">';

	foreach ($catcache AS $catid => $cats)
	{
		if ($cats['level'] > 3)
		{
			continue;
		}
		
		if ($cats['toplevel'])
		{
			$html .= '<div class="blocksubhead" style="font-weight: bold">' . str_repeat('--', ($cats['level'] - 1)) . '<a href="flashcard.php?do=browse&amp;catid=' . $cats['catid'] . '">' . $cats['title'] . '</a></div>';
		}
		else
		{
			$html .= '<div class="blockrow">[<a href="flashcard.php?do=start&amp;catid=' . $cats['catid'] . '">Take Quiz</a>] ' . str_repeat('--', ($cats['level'] - 1)) .  $cats['title'] . ' (' . $cats['questioncount'] . ' Questions)</div>';
		}
	}

	$html .= '</div>';
}
if ($html)
{
	$pagetitle = ($navbits['']) ? $navbits[''] : 'Flashcards';

	$navbits = construct_navbits($navbits);
	$navbar = render_navbar_template($navbits);

	$templater = vB_Template::create('shell_blank');
	$templater->register_page_templates();
	$templater->register('html', $html);
	$templater->register('navbar', $navbar);
	$templater->register('pagetitle', $pagetitle);

	print_output($templater->render());
}

In particular define('IS_ADMIN', is_member_of($vbulletin->userinfo, 6)); and also require_once(DIR . '/includes/flashcard_functions.php');. I assume I don't need tables like tag, reminder, reputation, but do I need settings, phrase, all the user tables, style, what about stylevar... You can't need every table for a simple page.

As our software got bigger, working with version control became more important, but with 1/2 the code in the database under plugins and templates it made it miserable and we gave up doing more than regular full backups. We need to step back from using eval() and ob_start() so much and need to find which tables are required till I can replace things like the $templater and stuff.