# ======================================================== # # Database saved : nuke76 # On 05-16-2005 at 18:14 by ! # # ======================================================== # -------------------------------------------------------- # # Table structure for table 'nuke_authors' # CREATE TABLE nuke_authors ( aid varchar(25) NOT NULL, name varchar(50), url varchar(255) NOT NULL, email varchar(255) NOT NULL, pwd varchar(40), counter int(11) DEFAULT '0' NOT NULL, radminsuper tinyint(1) DEFAULT '1' NOT NULL, admlanguage varchar(30) NOT NULL, PRIMARY KEY (aid), KEY aid (aid) ); # # Dumping data for table 'nuke_authors' # INSERT INTO nuke_authors VALUES ( 'smile', 'God', 'test', 'kashirin@etc.kna.ru', '1bd07ba5568b5297c840105683bcccbd', '0', '1', ''); # -------------------------------------------------------- # # Table structure for table 'nuke_autonews' # CREATE TABLE nuke_autonews ( anid int(11) NOT NULL auto_increment, catid int(11) DEFAULT '0' NOT NULL, aid varchar(30) NOT NULL, title varchar(80) NOT NULL, time varchar(19) NOT NULL, hometext text NOT NULL, bodytext text NOT NULL, topic int(3) DEFAULT '1' NOT NULL, informant varchar(20) NOT NULL, notes text NOT NULL, ihome int(1) DEFAULT '0' NOT NULL, alanguage varchar(30) NOT NULL, acomm int(1) DEFAULT '0' NOT NULL, associated text NOT NULL, PRIMARY KEY (anid), KEY anid (anid) ); # # Dumping data for table 'nuke_autonews' # # -------------------------------------------------------- # # Table structure for table 'nuke_banned_ip' # CREATE TABLE nuke_banned_ip ( id int(11) NOT NULL auto_increment, ip_address varchar(15) NOT NULL, reason varchar(255) NOT NULL, date date DEFAULT '0000-00-00' NOT NULL, PRIMARY KEY (id), KEY id (id) ); # # Dumping data for table 'nuke_banned_ip' # # -------------------------------------------------------- # # Table structure for table 'nuke_banner' # CREATE TABLE nuke_banner ( bid int(11) NOT NULL auto_increment, cid int(11) DEFAULT '0' NOT NULL, imptotal int(11) DEFAULT '0' NOT NULL, impmade int(11) DEFAULT '0' NOT NULL, clicks int(11) DEFAULT '0' NOT NULL, imageurl varchar(100) NOT NULL, clickurl varchar(200) NOT NULL, alttext varchar(255) NOT NULL, date datetime, dateend datetime, type tinyint(1) DEFAULT '0' NOT NULL, active tinyint(1) DEFAULT '1' NOT NULL, PRIMARY KEY (bid), KEY bid (bid), KEY cid (cid) ); # # Dumping data for table 'nuke_banner' # # -------------------------------------------------------- # # Table structure for table 'nuke_bannerclient' # CREATE TABLE nuke_bannerclient ( cid int(11) NOT NULL auto_increment, name varchar(60) NOT NULL, contact varchar(60) NOT NULL, email varchar(60) NOT NULL, login varchar(10) NOT NULL, passwd varchar(10) NOT NULL, extrainfo text NOT NULL, PRIMARY KEY (cid), KEY cid (cid) ); # # Dumping data for table 'nuke_bannerclient' # # -------------------------------------------------------- # # Table structure for table 'nuke_bbauth_access' # CREATE TABLE nuke_bbauth_access ( group_id mediumint(8) DEFAULT '0' NOT NULL, forum_id smallint(5) unsigned DEFAULT '0' NOT NULL, auth_view tinyint(1) DEFAULT '0' NOT NULL, auth_read tinyint(1) DEFAULT '0' NOT NULL, auth_post tinyint(1) DEFAULT '0' NOT NULL, auth_reply tinyint(1) DEFAULT '0' NOT NULL, auth_edit tinyint(1) DEFAULT '0' NOT NULL, auth_delete tinyint(1) DEFAULT '0' NOT NULL, auth_sticky tinyint(1) DEFAULT '0' NOT NULL, auth_announce tinyint(1) DEFAULT '0' NOT NULL, auth_vote tinyint(1) DEFAULT '0' NOT NULL, auth_pollcreate tinyint(1) DEFAULT '0' NOT NULL, auth_attachments tinyint(1) DEFAULT '0' NOT NULL,
auth_mod tinyint(1) DEFAULT '0' NOT NULL, KEY group_id (group_id), KEY forum_id (forum_id) ); # # Dumping data for table 'nuke_bbauth_access' # # -------------------------------------------------------- # # Table structure for table 'nuke_bbbanlist' # CREATE TABLE nuke_bbbanlist ( ban_id mediumint(8) unsigned NOT NULL auto_increment, ban_userid mediumint(8) DEFAULT '0' NOT NULL, ban_ip varchar(8) NOT NULL, ban_email varchar(255), ban_time int(11), ban_expire_time int(11), ban_by_userid mediumint(8), ban_priv_reason text, ban_pub_reason_mode tinyint(1), ban_pub_reason text, PRIMARY KEY (ban_id), KEY ban_ip_user_id (ban_ip, ban_userid) ); # # Dumping data for table 'nuke_bbbanlist' # # -------------------------------------------------------- # # Table structure for table 'nuke_bbcategories' # CREATE TABLE nuke_bbcategories ( cat_id mediumint(8) unsigned NOT NULL auto_increment, cat_title varchar(100), cat_order mediumint(8) unsigned DEFAULT '0' NOT NULL, PRIMARY KEY (cat_id), KEY cat_order (cat_order) ); # # Dumping data for table 'nuke_bbcategories' # # -------------------------------------------------------- # # Table structure for table 'nuke_bbconfig' # CREATE TABLE nuke_bbconfig ( config_name varchar(255) NOT NULL, config_value varchar(255) NOT NULL, PRIMARY KEY (config_name) ); # # Dumping data for table 'nuke_bbconfig' # INSERT INTO nuke_bbconfig VALUES ( 'config_id', '1'); INSERT INTO nuke_bbconfig VALUES ( 'board_disable', '0'); INSERT INTO nuke_bbconfig VALUES ( 'sitename', 'MySite.com'); INSERT INTO nuke_bbconfig VALUES ( 'site_desc', ''); INSERT INTO nuke_bbconfig VALUES ( 'cookie_name', 'phpbb2mysql'); INSERT INTO nuke_bbconfig VALUES ( 'cookie_path', '/'); INSERT INTO nuke_bbconfig VALUES ( 'cookie_domain', 'MySite.com'); INSERT INTO nuke_bbconfig VALUES ( 'cookie_secure', '0'); INSERT INTO nuke_bbconfig VALUES ( 'session_length', '3600'); INSERT INTO nuke_bbconfig VALUES ( 'allow_html', '1'); INSERT INTO nuke_bbconfig VALUES ( 'allow_html_tags', 'b,i,u,pre'); INSERT INTO nuke_bbconfig VALUES ( 'allow_bbcode', '1'); INSERT INTO nuke_bbconfig VALUES ( 'allow_smilies', '1'); INSERT INTO nuke_bbconfig VALUES ( 'allow_sig', '1'); INSERT INTO nuke_bbconfig VALUES ( 'allow_namechange', '0'); INSERT INTO nuke_bbconfig VALUES ( 'allow_theme_create', '0'); INSERT INTO nuke_bbconfig VALUES ( 'allow_avatar_local', '1'); INSERT INTO nuke_bbconfig VALUES ( 'allow_avatar_remote', '0'); INSERT INTO nuke_bbconfig VALUES ( 'allow_avatar_upload', '0'); INSERT INTO nuke_bbconfig VALUES ( 'override_user_style', '1'); INSERT INTO nuke_bbconfig VALUES ( 'posts_per_page', '15'); INSERT INTO nuke_bbconfig VALUES ( 'topics_per_page', '50'); INSERT INTO nuke_bbconfig VALUES ( 'hot_threshold', '25'); INSERT INTO nuke_bbconfig VALUES ( 'max_poll_options', '10'); INSERT INTO nuke_bbconfig VALUES ( 'max_sig_chars', '255'); INSERT INTO nuke_bbconfig VALUES ( 'max_inbox_privmsgs', '100'); INSERT INTO nuke_bbconfig VALUES ( 'max_sentbox_privmsgs', '100'); INSERT INTO nuke_bbconfig VALUES ( 'max_savebox_privmsgs', '100'); INSERT INTO nuke_bbconfig VALUES ( 'board_email_sig', 'Thanks, Webmaster@MySite.com'); INSERT INTO nuke_bbconfig VALUES ( 'board_email', 'Webmaster@MySite.com'); INSERT INTO nuke_bbconfig VALUES ( 'smtp_delivery', '0'); INSERT INTO nuke_bbconfig VALUES ( 'smtp_host', ''); INSERT INTO nuke_bbconfig VALUES ( 'require_activation', '0'); INSERT INTO nuke_bbconfig VALUES ( 'flood_interval', '15'); INSERT INTO nuke_bbconfig VALUES ( 'board_email_form', '0'); INSERT INTO nuke_bbconfig VALUES ( 'avatar_filesize', '6144'); INSERT INTO nuke_bbconfig VALUES ( 'avatar_max_width', '80'); INSERT INTO nuke_bbconfig VALUES ( 'avatar_max_height', '80'); INSERT INTO nuke_bbconfig VALUES ( 'avatar_path', 'modules/Forums/images/avatars'); INSERT INTO nuke_bbconfig VALUES ( 'avatar_gallery_path', 'modules/Forums/images/avatars'); INSERT INTO nuke_bbconfig VALUES ( 'smilies_path', 'modules/Forums/images/smiles'); INSERT INTO nuke_bbconfig VALUES ( 'default_style', '1'); INSERT INTO nuke_bbconfig VALUES ( 'default_dateformat', 'D M d, Y g:i a'); INSERT INTO nuke_bbconfig VALUES ( 'board_timezone', '10'); INSERT INTO nuke_bbconfig VALUES ( 'prune_enable', '0'); INSERT INTO nuke_bbconfig VALUES ( 'privmsg_disable', '0'); INSERT INTO nuke_bbconfig VALUES ( 'gzip_compress', '0'); INSERT INTO nuke_bbconfig VALUES ( 'coppa_fax', ''); INSERT INTO nuke_bbconfig VALUES ( 'coppa_mail', ''); INSERT INTO nuke_bbconfig VALUES ( 'board_startdate', '1013908210'); INSERT INTO nuke_bbconfig VALUES ( 'default_lang', 'english'); INSERT INTO nuke_bbconfig VALUES ( 'smtp_username', ''); INSERT INTO nuke_bbconfig VALUES ( 'smtp_password', ''); INSERT INTO nuke_bbconfig VALUES ( 'record_online_users', '2'); INSERT INTO nuke_bbconfig VALUES ( 'record_online_date', '1034668530'); INSERT INTO nuke_bbconfig VALUES ( 'server_name', 'MySite.com'); INSERT INTO nuke_bbconfig VALUES ( 'server_port', '80'); INSERT INTO nuke_bbconfig VALUES ( 'script_path', '/modules/Forums/'); INSERT INTO nuke_bbconfig VALUES ( 'version', '.0.14'); INSERT INTO nuke_bbconfig VALUES ( 'enable_confirm', '0'); INSERT INTO nuke_bbconfig VALUES ( 'sendmail_fix', '0'); # -------------------------------------------------------- # # Table structure for table 'nuke_bbdisallow' # CREATE TABLE nuke_bbdisallow ( disallow_id mediumint(8) unsigned NOT NULL auto_increment, disallow_username varchar(25), PRIMARY KEY (disallow_id) ); # # Dumping data for table 'nuke_bbdisallow' # # -------------------------------------------------------- # # Table structure for table 'nuke_bbforum_prune' # CREATE TABLE nuke_bbforum_prune ( prune_id mediumint(8) unsigned NOT NULL auto_increment, forum_id smallint(5) unsigned DEFAULT '0' NOT NULL, prune_days tinyint(4) unsigned DEFAULT '0' NOT NULL, prune_freq tinyint(4) unsigned DEFAULT '0' NOT NULL, PRIMARY KEY (prune_id), KEY forum_id (forum_id) ); # # Dumping data for table 'nuke_bbforum_prune' # # -------------------------------------------------------- # # Table structure for table 'nuke_bbforums' # CREATE TABLE nuke_bbforums ( forum_id smallint(5) unsigned NOT NULL auto_increment, cat_id mediumint(8) unsigned DEFAULT '0' NOT NULL, forum_name varchar(150), forum_desc text, forum_status tinyint(4) DEFAULT '0' NOT NULL, forum_order mediumint(8) unsigned DEFAULT '1' NOT NULL, forum_posts mediumint(8) unsigned DEFAULT '0' NOT NULL, forum_topics mediumint(8) unsigned DEFAULT '0' NOT NULL, forum_last_post_id mediumint(8) unsigned DEFAULT '0' NOT NULL, prune_next int(11), prune_enable tinyint(1) DEFAULT '1' NOT NULL, auth_view tinyint(2) DEFAULT '0' NOT NULL, auth_read tinyint(2) DEFAULT '0' NOT NULL, auth_post tinyint(2) DEFAULT '0' NOT NULL, auth_reply tinyint(2) DEFAULT '0' NOT NULL, auth_edit tinyint(2) DEFAULT '0' NOT NULL, auth_delete tinyint(2) DEFAULT '0' NOT NULL, auth_sticky tinyint(2) DEFAULT '0' NOT NULL, auth_announce tinyint(2) DEFAULT '0' NOT NULL, auth_vote tinyint(2) DEFAULT '0' NOT NULL, auth_pollcreate tinyint(2) DEFAULT '0' NOT NULL, auth_attachments tinyint(2) DEFAULT '0' NOT NULL, PRIMARY KEY (forum_id), KEY forums_order (forum_order), KEY cat_id (cat_id), KEY forum_last_post_id (forum_last_post_id) ); # # Dumping data for table 'nuke_bbforums' # # -------------------------------------------------------- # # Table structure for table 'nuke_bbgroups' # CREATE TABLE nuke_bbgroups ( group_id mediumint(8) NOT NULL auto_increment, group_type tinyint(4) DEFAULT '1' NOT NULL, group_name varchar(40) NOT NULL, group_description varchar(255) NOT NULL, group_moderator mediumint(8) DEFAULT '0' NOT NULL, group_single_user tinyint(1) DEFAULT '1' NOT NULL, PRIMARY KEY (group_id), KEY group_single_user (group_single_user) ); # # Dumping data for table 'nuke_bbgroups' # INSERT INTO nuke_bbgroups VALUES ( '1', '1', 'Anonymous', 'Personal User', '0', '1'); INSERT INTO nuke_bbgroups VALUES ( '3', '2', 'Moderators', 'Moderators of this Forum', '5', '0'); # -------------------------------------------------------- # # Table structure for table 'nuke_bbposts' # CREATE TABLE nuke_bbposts ( post_id mediumint(8) unsigned NOT NULL auto_increment, topic_id mediumint(8) unsigned DEFAULT '0' NOT NULL, forum_id smallint(5) unsigned DEFAULT '0' NOT NULL, poster_id mediumint(8) DEFAULT '0' NOT NULL, post_time int(11) DEFAULT '0' NOT NULL, poster_ip varchar(8) NOT NULL, post_username varchar(25), enable_bbcode tinyint(1) DEFAULT '1' NOT NULL, enable_html tinyint(1) DEFAULT '0' NOT NULL, enable_smilies tinyint(1) DEFAULT '1' NOT NULL, enable_sig tinyint(1) DEFAULT '1' NOT NULL, post_edit_time int(11), post_edit_count smallint(5) unsigned DEFAULT '0' NOT NULL, PRIMARY KEY (post_id), KEY forum_id (forum_id), KEY topic_id (topic_id), KEY poster_id (poster_id), KEY post_time (post_time) ); # # Dumping data for table 'nuke_bbposts' # # -------------------------------------------------------- # # Table structure for table 'nuke_bbposts_text' # CREATE TABLE nuke_bbposts_text ( post_id mediumint(8) unsigned DEFAULT '0' NOT NULL, bbcode_uid varchar(10) NOT NULL,
блин Soniks я тебя чо обманывать что ли буду, всё делал нормально по мануалу и по твоим советам. код выше.......(весь не стал копировать)
...........ну да ладно спасибо и на этом
CODE_666
20.01.2006, 21:14
нажимаю обзор, выбераю, и ок, начинается загрузка, и внизу полоска загрузки страницы идёт потихоньку, и когда доходит до конца, как будто зависает, и так и стоит, сразу пропадает поток интернета, ну типо вообще не идёт загрузка, а затем либо база данных выдает какието надписи, типо ерор и т.д, либо просто пишет страница не найдена
а вот ещё........етот же sql кинул на другой хост jino-net.ru, там короче у них встроенный phpMyAdmin, ну а базу данных зделал через блакнот в кодировке UTF-8, и кинул туда и вот что выбело!!!!!
SQL-запрос:
-- phpMyAdmin SQL Dump
-- version 2.7.0-pl1
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Янв 18 2006 г., 14:51
-- Версия сервера: 4.0.18
-- Версия PHP: 4.3.9
--
-- БД: `nuke`
--
-- --------------------------------------------------------
--
-- Структура таблицы `nuke_authors`
--
CREATE TABLE `nuke_authors` (
`aid` varchar( 25 ) NOT NULL default '',
`name` varchar( 50 ) default NULL ,
`url` varchar( 255 ) NOT NULL default '',
`email` varchar( 255 ) NOT NULL default '',
`pwd` varchar( 40 ) default NULL ,
`counter` int( 11 ) NOT NULL default '0',
`radminsuper` tinyint( 1 ) NOT NULL default '1',
`admlanguage` varchar( 30 ) NOT NULL default '',
PRIMARY KEY ( `aid` ) ,
KEY `aid` ( `aid` )
) TYPE = MYISAM
Ответ MySQL:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-- phpMyAdmin SQL Dump
-- version 2.7.0-pl1
-- http://www.phpmyadmin.net
-' at line 1