connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']); //-------------------SQL Injection Prevention-------------------------------- // this page has multipage support and field ordering, so we need these $start = (isset($_GET['start'])) ? $sqlw->quote_smart($_GET['start']) : 0; if (is_numeric($start)); else $start=0; $order_by = (isset($_GET['order_by'])) ? $sqlw->quote_smart($_GET['order_by']) : 'level_min'; if (preg_match('/^[_[:lower:]]{1,11}$/', $order_by)); else $order_by='level_min'; $dir = (isset($_GET['dir'])) ? $sqlw->quote_smart($_GET['dir']) : 1; if (preg_match('/^[01]{1}$/', $dir)); else $dir=1; $order_dir = ($dir) ? 'ASC' : 'DESC'; $dir = ($dir) ? 0 : 1; // for multipage support $all_record = $sqlw->result($sqlw->query('SELECT count(*) FROM instance_template'), 0); // main data that we need for this page, instances if ($server_type) $result = $sqlw->query('SELECT map, level_min, level_max, maxPlayers as maxplayers, reset_delay FROM instance_template JOIN access_requirement ON access_requirement.id = instance_template.access_id ORDER BY '.$order_by.' '.$order_dir.' LIMIT '.$start.', '.$itemperpage.';'); else $result = $sqlw->query('SELECT map, levelMin as level_min, levelMax as level_max, maxPlayers as maxplayers, reset_delay FROM instance_template ORDER BY '.$order_by.' '.$order_dir.' LIMIT '.$start.', '.$itemperpage.';'); //---------------Page Specific Data Starts Here-------------------------- // we start with a lead of 10 spaces, // because last line of header is an opening tag with 8 spaces // keep html indent in sync, so debuging from browser source would be easy to read $output .= '
'; // multi page links $output .= $lang_instances['total'].' : '.$all_record.'

'. generate_pagination('instances.php?order_by='.$order_by.'&dir='.(($dir) ? 0 : 1), $all_record, $itemperpage, $start); // column headers, with links for sorting $output .= '
'; $sqlm = new SQL; $sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']); while ($instances = $sqlw->fetch_assoc($result)) { $days = floor(round($instances['reset_delay'] / 3600) / 24); $hours = round($instances['reset_delay'] / 3600) - ($days * 24); $reset = ""; if ($days) $reset .= $days.' days'; if ($hours) $reset .= $hours.' hours'; $output .= ' '; } unset($reset); unset($hours); unset($days); unset($instances); unset($result); $output .= '
'.$lang_instances['map'].' '.$lang_instances['level_min'].' '.$lang_instances['level_max'].' '.$lang_instances['max_players'].' '.$lang_instances['reset_delay'].'
'.get_map_name($instances['map'], $sqlm).' ('.$instances['map'].') '.$instances['level_min'].' '.$instances['level_max'].' '.$instances['maxplayers'].' '.$reset.'
'; } //############################################################################# // MAIN //############################################################################# // error variable reserved for future use //$err = (isset($_GET['error'])) ? $_GET['error'] : NULL; //unset($err); $lang_instances = lang_instances(); $output .= '

'.$lang_instances['instances'].'

'; // action variable reserved for future use //$action = (isset($_GET['action'])) ? $_GET['action'] : NULL; instances(); //unset($action); unset($action_permission); unset($lang_instances); require_once 'footer.php'; ?>