RED RU - VPN продажа
KATSTAT.RU-ТОП РЕЙТИНГ САЙТОВ С ОТДАЧЕЙ
ADS LINK - Сервис интернет рекламы
METRO - ПОСТАПОКАЛИПТИЧЕСКАЯ ОНЛАЙН ИГРА
Мобильная 3D онлайн игра Lineage II
WorldByte - Наш хостинг - партнер
PHP/MySQL | MySQL запросы
Топ дня: 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
что не так?
David (20.02.2015 в 18:42)
что не так?

я же говорю вроде почистил таблы от пых кода mysql_query("") а оно всеравно не фыр-фыр
ArIzOn, Гг
________
посл. ред. 20.02.2015 в 18:44; всего 1 раз(а); by [FTP]Angel
[FTP]Angel (20.02.2015 в 18:43)
ArIzOn, ну и?мы тебе чё ванги?

йеб# я попросил очисить базу от пых кода
mysql_query("")
какая ошибка?
AlexTracks, mysql_query(" вот этот код пых его просто надо убрать я просто с тела и не могу :(
ArIzOn, Сейчас сделаем епта)
156709843 (20.02.2015 в 18:49)
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
Стр.: 1, 2
Форум На главную
Онлайн: 3
Время: 08:01:29
Gen. 0.1013
(c) ByMAS.RU 2010-2025