View Single Post
  #3  
Old 08-03-2002, 10:06 AM
ULTIMATESSJ's Avatar
ULTIMATESSJ ULTIMATESSJ is offline
 
Join Date: Nov 2001
Location: Bristol, England
Posts: 315
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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???
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01255 seconds
  • Memory Usage 1,778KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete