i looked in the scripts code and found this for how they make the users table
PHP Code:
$sql = mysql_query($query) or die(mysql_error());
echo '.';
$query = "
CREATE TABLE " . PHPRPG_DB_PREFIX . "_users (
user_id smallint(5) unsigned NOT NULL auto_increment,
user_name char(20) NOT NULL default '',
user_pass char(32) binary NOT NULL default '',
email char(60) NOT NULL default '',
name char(20) NOT NULL default '',
status char(20) NOT NULL default '',
HP mediumint(8) unsigned NOT NULL default '20',
HP_MAX mediumint(8) unsigned NOT NULL default '20',
MP mediumint(8) unsigned NOT NULL default '10',
MP_MAX mediumint(8) unsigned NOT NULL default '10',
STM mediumint(8) unsigned NOT NULL default '200',
STM_MAX mediumint(8) unsigned NOT NULL default '200',
EXP mediumint(8) unsigned NOT NULL default '0',
GP mediumint(8) unsigned NOT NULL default '0',
STR tinyint(3) unsigned NOT NULL default '4',
NTL tinyint(3) unsigned NOT NULL default '4',
PIE tinyint(3) unsigned NOT NULL default '4',
VIT tinyint(3) unsigned NOT NULL default '4',
DEX tinyint(3) unsigned NOT NULL default '4',
SPD tinyint(3) unsigned NOT NULL default '4',
CW mediumint(8) unsigned NOT NULL default '0',
CC mediumint(8) unsigned NOT NULL default '80',
map_name char(20) NOT NULL default '',
map_xpos tinyint(3) unsigned NOT NULL default '0',
map_ypos tinyint(3) unsigned NOT NULL default '0',
last_active char(255) NOT NULL default '',
delay char(255) NOT NULL default '',
delay_reason char(255) NOT NULL default '',
race char(10) NOT NULL default '',
avatar char(10) NOT NULL default '',
host char(255) NOT NULL default '',
PRIMARY KEY (user_id)
) TYPE=MyISAM
";
how could i bring that into the vBulletin users table???