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']) : 'description'; if (preg_match('/^[_[:lower:]]{1,11}$/', $order_by)); else $order_by='description'; $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 game_event WHERE start_time <> end_time'),0); // main data that we need for this page, game events $result = $sqlw->query('SELECT description, start_time, occurence, length FROM game_event WHERE start_time <> end_time 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_events['total'].' : '.$all_record.'

'. generate_pagination('events.php?order_by='.$order_by.'&dir='.(($dir) ? 0 : 1), $all_record, $itemperpage, $start); // column headers, with links for sorting $output .= '
'; while ($events = $sqlw->fetch_assoc($result)) { $days = floor(round($events['occurence'] / 60) / 24); $hours = round($events['occurence'] / 60) - ($days * 24); $event_occurance = ''; if ($days) $event_occurance .= $days.' days '; if ($hours) $event_occurance .= $hours.' hours'; $days = floor(round($events['length'] / 60) / 24); $hours = round($events['length'] / 60) - ($days * 24); $event_duration = ''; if ($days) $event_duration .= $days.' days '; if ($hours) $event_duration .= $hours.' hours'; $output .= ' '; } unset($event_duration); unset($event_occurance); unset($hours); unset($days); unset($events); unset($result); $output .= '
'.$lang_events['descr'].' '.$lang_events['start'].' '.$lang_events['occur'].' '.$lang_events['length'].'
'.$events['description'].' '.$events['start_time'].' '.$event_occurance.' '.$event_duration.'
'; } //############################################################################# // MAIN //############################################################################# // error variable reserved for future use //$err = (isset($_GET['error'])) ? $_GET['error'] : NULL; //unset($err); $lang_events = lang_events(); $output .= '

'.$lang_events['events'].'

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