5 odpowiedzi w tym temacie

[Evolt]

Proszę o podanie zapytania do tego :)Bez wzorów czy czegoś tam bo chce tylko zapytanie

Użytkownik Evolt edytował ten post 21.01.2013 14:57

[Kawon]

CREATE TABLE `amx_flagged`(

`fid` int(11) NOT NULL auto_increment,

`player_ip` varchar(32) default NULL,

`player_id` varchar(35) default NULL,

`player_nick` varchar(100) default 'Unknown',

`admin_ip` varchar(32) default NULL,

`admin_id` varchar(35) default NULL,

`admin_nick` varchar(100) default 'Unknown',

`reason` varchar(100) default NULL,

`created` int(11) default NULL,

`length` int(11) default NULL,

`server_ip` varchar(100) default NULL,

PRIMARY KEY  (`fid`),

KEY `player_id` (`player_id`)

);

[Evolt]

Mógłbyś podać jeszcze serverinfo, reasons i resons set ?

[Kawon]

Wklejka 16mtt0hena2so(tabele amxbans) dodana przez Kawon, 21.01.2013 16:31

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.

CREATE TABLE `amx_serverinfo`(
	`id` INT(11) NULL AUTO_INCREMENT,
	`timestamp` INT(11) NULL,
	`hostname` VARCHAR(100) NULL DEFAULT 'Unknown',
	`address` VARCHAR(100) NULL,
	`gametype` VARCHAR(32) NULL,
	`rcon` VARCHAR(32) NULL,
	`amxban_version` VARCHAR(32) NULL,
	`amxban_motd` VARCHAR(250) NULL,
	`motd_delay` INT(10) NULL DEFAULT '10',
	`amxban_menu` INT(10) NOT NULL DEFAULT '1',
	`reasons` INT(10) NULL,
	`timezone_fixx` INT(11) NOT NULL DEFAULT '0',
	PRIMARY KEY (id)
);
 
CREATE TALBE `amx_reasons`(
	`id int`(11) NULL AUTO_INCREMENT,
	`reason` VARCHAR(100) NULL,
	`static_bantime` INT(11) NOT NULL DEFAULT '0',
	PRIMARY KEY (id)
);
 
 
CREATE TALBE `amx_reasons_set`(
	`id` INT(11) NULL AUTO_INCREMENT,
	`setname` VARCHAR(32) NULL,
	PRIMARY KEY (id)
);

[Evolt]

Przy reasons i reasons set wyskakuję błąd

#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
'TALBE `amx_reasons`( `id int`(11) NULL AUTO_INCREMENT, `reason` VARCHAR(100) N' at line 1

[Evolt]

Odświeżam.