I'm not sure if I did wrong some where in the code. But here is what I did.
in the php code:
PHP Code:
<?php
// ####################### SET PHP ENVIRONMENT ########################### error_reporting(E_ALL & ~E_NOTICE);
// #################### DEFINE IMPORTANT CONSTANTS ####################### define('THIS_SCRIPT', 'instructor'); 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('ese_instructor');
// pre-cache templates used by specific actions $actiontemplates = array();
if (!(in_array($ese_instructor['do'], $pages))) { $ese_instructor['do'] = 'this'; }
// custom code here if ($ese_instructor['do'] == 'this'){
$result = $vbulletin->db->query_read("SELECT id, name, gender, class, time, userid, status FROM " . TABLE_PREFIX . "ese_instructor WHERE status = 'Active' ORDER BY gender, name"); while($r = $vbulletin->db->fetch_array($result)){
$result = $vbulletin->db->query_read("SELECT id, name, gender, class, time, userid, status FROM " . TABLE_PREFIX . "ese_instructor WHERE status = 'inactive' ORDER BY gender, name"); while($r = $vbulletin->db->fetch_array($result)){