phpbb screwing me!

[Spike]

When I put in my webhost via FTP

I want to put a mysql code into my mysql database by install/schemas way.... so I can insert this into my phpbb2 forums. But, I don't know what files I would need. I know I need (something).php put into my install folder, then (something).sql file put into my schemas folder. Then I would type in

www.mydomain.com/forums/install/(something).php

then it would install it all, then I delete the install folder and everything in it, then poof it works.

What would I need for the (something).php code to be, and the (something).sql file....


Here's the code...

#
#-----[ SQL ]-------------------------------------------------
#
CREATE TABLE `phpbb_xdata_fields` (
	field_id smallint(5) UNSIGNED NOT NULL,
	field_name varchar(255) NOT NULL default '',
	field_desc text NOT NULL default '',
	field_type varchar(255) NOT NULL default '',
	field_order smallint(5) UNSIGNED NOT NULL default '0',
	code_name varchar(255) NOT NULL default '',
	field_length mediumint(8) UNSIGNED NOT NULL default '0',
	field_values text NOT NULL default '',
	field_regexp text NOT NULL default '',
	default_auth tinyint(1) NOT NULL default '1',
	display_register tinyint(1) NOT NULL default '1',
	display_viewprofile tinyint(1) NOT NULL default '0',
	display_posting tinyint(1) NOT NULL default '0',
	handle_input tinyint(1) NOT NULL default '0',
	allow_html tinyint(1) NOT NULL default '0',
	allow_bbcode tinyint(1) NOT NULL default '0',
	allow_smilies tinyint(1) NOT NULL default '0',
	
	PRIMARY KEY  (field_id),
	UNIQUE KEY code_name (code_name)
);

CREATE TABLE `phpbb_xdata_data` (
  field_id smallint(5) UNSIGNED NOT NULL,
  user_id mediumint(8) UNSIGNED NOT NULL,
  xdata_value text NOT NULL
);

CREATE TABLE `phpbb_xdata_auth` (
  field_id smallint(5) UNSIGNED NOT NULL,
  group_id mediumint(8) UNSIGNED NOT NULL,
  auth_value tinyint(1) NOT NULL
);

INSERT INTO `phpbb_xdata_fields`
	(field_id, field_name, field_type, field_order, code_name, display_register)
	VALUES
	(1, 'ICQ Number', 'special', '1', 'icq', 2);
	
INSERT INTO `phpbb_xdata_fields`
	(field_id, field_name, field_type, field_order, code_name, display_register)
	VALUES
	(2, 'AIM Address', 'special', '2', 'aim', 2);

INSERT INTO `phpbb_xdata_fields`
	(field_id, field_name, field_type, field_order, code_name, display_register)
	VALUES
	(3, 'MSN Messenger', 'special', '3', 'msn', 2);

INSERT INTO `phpbb_xdata_fields`
	(field_id, field_name, field_type, field_order, code_name, display_register)
	VALUES
	(4, 'Yahoo Messenger', 'special', '4', 'yim', 2);

INSERT INTO `phpbb_xdata_fields`
	(field_id, field_name, field_type, field_order, code_name, display_register)
	VALUES
	(5, 'Website', 'special', '5', 'website', 2);

INSERT INTO `phpbb_xdata_fields`
	(field_id, field_name, field_type, field_order, code_name, display_register)
	VALUES
	(6, 'Location', 'special', '6', 'location', 2);

INSERT INTO `phpbb_xdata_fields`
	(field_id, field_name, field_type, field_order, code_name, display_register)
	VALUES
	(7, 'Occupation', 'special', '7', 'occupation', 2);

INSERT INTO `phpbb_xdata_fields`
	(field_id, field_name, field_type, field_order, code_name, display_register)
	VALUES
	(8, 'Interests', 'special', '8', 'interests', 2);

INSERT INTO `phpbb_xdata_fields`
	(field_id, field_name, field_type, field_order, code_name, display_register)
	VALUES
	(9, 'Signature', 'special', '9', 'signature', 2);

NOTE: This is for a phpbb2 forum mod/hack for my forums... it's an addon thing.

CLICK HERE http://placida.fu8.com/forum/xdata.txt CLICK HERE

[Spike]

I think I found it....


http://www.phpbbhacks.com/forums/db_generator.php


Go there, insert the code, it makes it into a .php file, put into ur root file, poof all uploaded. Thank you no one