-- 
-- Table structure for table `phpbb_ranks`
-- 

CREATE TABLE `phpbb_ranks` (
  `rank_id` smallint(5) unsigned NOT NULL auto_increment,
  `rank_title` varchar(50) NOT NULL default '',
  `rank_min` mediumint(8) NOT NULL default '0',
  `rank_special` tinyint(1) default '0',
  `rank_image` varchar(255) default NULL,
  PRIMARY KEY  (`rank_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

-- 
-- Dumping data for table `phpbb_ranks`
-- 

INSERT INTO `phpbb_ranks` VALUES (1, 'Administrator', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (2, 'Moderator', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (3, 'Co-Administrator', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (4, 'Volunteer', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (5, 'Village Idiot', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (6, 'Angel in Devil''s Clothing', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (7, 'Legal Defense', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (8, 'Sensei Ninja Master', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (9, 'Cluebie', 0, 0, '');
INSERT INTO `phpbb_ranks` VALUES (10, 'Poser', 50, 0, '');
INSERT INTO `phpbb_ranks` VALUES (11, 'Member', 100, 0, '');
INSERT INTO `phpbb_ranks` VALUES (12, 'Super Poster', 500, 0, '');
INSERT INTO `phpbb_ranks` VALUES (13, 'Elite Poster', 1000, 0, '');
INSERT INTO `phpbb_ranks` VALUES (14, 'Elite', 2000, 0, '');
INSERT INTO `phpbb_ranks` VALUES (15, 'Call-Center Junkie', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (16, 'Gigolo', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (17, 'I can''t follow the rules', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (18, '<b>Banned</b>', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (20, '<b><font color="#FF0000">Warned</font></b>', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (21, '<b><font color="#FF8000">Spammer</font></b>', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (22, 'Former Portland Traffic', -1, 1, '');

header("Location: {URL}/ubbthreads.php{$var_start}ubb{$var_eq}cfrm");

$topic = $_GET['t'];
$post = $_GET['p'];

if ($topic || $post) {
	
	if (!$topic) $topic = 0;
	if (!$post) $post = 0;
	
	if ($redirect == 301) {
		header("HTTP/1.1 301 Moved Permanently");
	} else {
		header("HTTP/1.1 302 Moved Temporarily");
	}
	header("Location: {$URL}/ubbthreads.php{$var_start}ubb{$var_eq}showflat{$var_sep}topic{$var_eq}$topic{$var_sep}Number{$var_eq}$post{$var_sep}site_id{$var_eq}$site_id#import");
	exit;
} else {
	if ($redirect == 301) {
		header("HTTP/1.1 301 Moved Permanently");
	} else {
		header("HTTP/1.1 302 Moved Temporarily");
	}
	header("Location: {$URL}/ubbthreads.php{$var_start}ubb{$var_eq}cfrm");
	exit;
}	
?>

[quote][/quote]

&amp

	$query = "show tables like '{$dbprefix}users%'";
	$sth = mysql_query($query,$dbhimport);
	list($check) = mysql_fetch_array($sth);
	if (!$check) {
		echo "Unable to query from the {$dbprefix}Users table, it doesn't appear your import database settings are correct.";
		exit;
	}