Топ дня: VeteR

Вот запросы.
mysql_query("CREATE TABLE IF NOT EXISTS `ban` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`why` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");
mysql_query("CREATE TABLE IF NOT EXISTS `chat` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
`room` int(12) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");
mysql_query("CREATE TABLE IF NOT EXISTS `forum` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`open` int(1) NOT NULL DEFAULT '1',
`up` int(1) NOT NULL,
`razdel` int(255) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");
mysql_query("CREATE TABLE IF NOT EXISTS `forum_komm` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`theme` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");
mysql_query("CREATE TABLE IF NOT EXISTS `forum_t` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`opis` text COLLATE utf8_unicode_ci NOT NULL,
`razdel` int(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");
mysql_query("CREATE TABLE IF NOT EXISTS `guestbook` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`msg` varchar(512) COLLATE utf8_unicode_ci DEFAULT '-',
`time` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");
mysql_query("CREATE TABLE IF NOT EXISTS `guests` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`tel` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
`click` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");
mysql_query("CREATE TABLE IF NOT EXISTS `jurnal` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`time` int(255) NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`read` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");
mysql_query("CREATE TABLE IF NOT EXISTS `mail` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`from` int(255) NOT NULL,
`to` int(255) NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
`read` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");
mysql_query("CREATE TABLE IF NOT EXISTS `mnen` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");
mysql_query("CREATE TABLE IF NOT EXISTS `news` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");
mysql_query("CREATE TABLE IF NOT EXISTS `news_komm` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`msg` text CHARACTER SET utf8 NOT NULL,
`time` int(255) NOT NULL,
`nid` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");
mysql_query("CREATE TABLE IF NOT EXISTS `obmen` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`ras` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
`razdel` int(255) NOT NULL DEFAULT '0',
`type` text COLLATE utf8_unicode_ci NOT NULL,
`nameras` text COLLATE utf8_unicode_ci NOT NULL,
`ds` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");
mysql_query("CREATE TABLE IF NOT EXISTS `obmen_komm` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`file` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");
mysql_query("CREATE TABLE IF NOT EXISTS `obmen_t` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`opis` text COLLATE utf8_unicode_ci NOT NULL,
`razdel` int(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");
mysql_query("CREATE TABLE IF NOT EXISTS `rekl` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`href` text COLLATE utf8_unicode_ci NOT NULL,
`img` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
`where` int(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");
mysql_query("CREATE TABLE IF NOT EXISTS `room` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");
mysql_query("CREATE TABLE IF NOT EXISTS `user` (
`id` int(255) NOT NULL AUTO_INCREME

что не так?

я же говорю вроде почистил таблы от пых кода mysql_query("") а оно всеравно не фыр-фыр

ArIzOn,
________
посл. ред. 20.02.2015 в 18:44; всего 1 раз(а); by [FTP]Angel

йеб# я попросил очисить базу от пых кода
mysql_query("")

какая ошибка?

AlexTracks, mysql_query(" вот этот код пых его просто надо убрать я просто с тела и не могу :(

ArIzOn, Сейчас сделаем епта)

сапс бро

CREATE TABLE IF NOT EXISTS `ban` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`why` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE IF NOT EXISTS `chat` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
`room` int(12) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE IF NOT EXISTS `forum` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`open` int(1) NOT NULL DEFAULT '1',
`up` int(1) NOT NULL,
`razdel` int(255) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE IF NOT EXISTS `forum_komm` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`theme` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE IF NOT EXISTS `forum_t` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`opis` text COLLATE utf8_unicode_ci NOT NULL,
`razdel` int(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE IF NOT EXISTS `guestbook` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`msg` varchar(512) COLLATE utf8_unicode_ci DEFAULT '-',
`time` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE IF NOT EXISTS `guests` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`tel` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
`click` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE IF NOT EXISTS `jurnal` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`time` int(255) NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`read` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE IF NOT EXISTS `mail` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`from` int(255) NOT NULL,
`to` int(255) NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
`read` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE IF NOT EXISTS `mnen` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
CREATE TABLE IF NOT EXISTS `news` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE IF NOT EXISTS `news_komm` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`msg` text CHARACTER SET utf8 NOT NULL,
`time` int(255) NOT NULL,
`nid` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE IF NOT EXISTS `obmen` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`ras` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
`razdel` int(255) NOT NULL DEFAULT '0',
`type` text COLLATE utf8_unicode_ci NOT NULL,
`nameras` text COLLATE utf8_unicode_ci NOT NULL,
`ds` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE IF NOT EXISTS `obmen_komm` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`file` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE IF NOT EXISTS `obmen_t` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`opis` text COLLATE utf8_unicode_ci NOT NULL,
`razdel` int(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE IF NOT EXISTS `rekl` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`href` text COLLATE utf8_unicode_ci NOT NULL,
`img` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
`where` int(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci


CREATE TABLE IF NOT EXISTS `room` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE IF NOT EXISTS `user` (
`id` int(255) NOT NULL AUTO_INCREME