[xbatista]

PHP Code:

new const szTables[][] =  
{ 
    "CREATE TABLE IF NOT EXISTS `d2_data` ( `player_steamid` varchar(25) NOT NULL default '', `player_ip` varchar(20) NOT NULL default '', `player_name` varchar(35) NOT NULL default '', `player_data` varchar(4096) NOT NULL default '', `player_data2` varchar(4096) NOT NULL default '', `player_data3` varchar(4096) NOT NULL default '', PRIMARY KEY  (`player_name`, `player_ip`, `player_steamid`), KEY `player_data` (`player_data`), KEY `player_data2` (`player_data2`), KEY `player_data3` (`player_data3`) ) TYPE=MyISAM;"; 
} 


I've try press 'enter' after ',' , no success "possibly non-terminated string"

[ConnorMcLeod]

Use \

PHP Code:

new const szTables[][] =  
{ 
    "CREATE TABLE IF NOT EXISTS `d2_data` ( `player_steamid` varchar(25) NOT NULL default '', \
    `player_ip` varchar(20) NOT NULL default '', `player_name` varchar(35) NOT NULL default '', \
    `player_data` varchar(4096) NOT NULL default '', `player_data2` varchar(4096) NOT NULL default '', \
    `player_data3` varchar(4096) NOT NULL default '', PRIMARY KEY  (`player_name`, `player_ip`, `player_steamid`), \
    KEY `player_data` (`player_data`), KEY `player_data2` (`player_data2`), KEY `player_data3` (`player_data3`) ) TYPE=MyISAM;"; 
} 


But [][] tells that a 2 dimensions array follow, and you only put a 1 dimension array, so be carefull.

[xbatista]

PHP Code:

new const szTables[][] =  
{ 
    "CREATE TABLE IF NOT EXISTS `d2_data` ( `player_steamid` varchar(25) NOT NULL default '', `player_ip` varchar(20) NOT NULL default '', `player_name` varchar(35) NOT NULL default '', `player_data` varchar(4096) NOT NULL default '', \
    `player_data2` varchar(4096) NOT NULL default '', `player_data3` varchar(4096) NOT NULL default '', PRIMARY KEY  (`player_name`, `player_ip`, `player_steamid`), KEY `player_data` (`player_data`), KEY `player_data2` (`player_data2`), \
    KEY `player_data3` (`player_data3`) ) TYPE=MyISAM;" 
} 


Error: "input line too long" wtf?

But [][] tells that a 2 dimensions array follow, and you only put a 1 dimension array, so be carefull.

It has worked, after I put more text to this array and at all it worked fine

[SnoW]

You must format the string.

[xbatista]

Ohh cmon I want to use it like is, new const szTables[][]

[Arkshine]

Don't know why you have to format. Anyway try this :

new const gTableCreateQuery[] =
"						\
    CREATE TABLE IF NOT EXISTS `d2_data`	\
    (						\
        `player_steamid` VARCHAR(25) NOT NULL,	\
        `player_ip` VARCHAR(20) NOT NULL,     	\
        `player_name` VARCHAR(35) NOT NULL,   	\
        `player_data` VARCHAR(4096) NOT NULL, 	\
        `player_data2` VARCHAR(4096) NOT NULL,	\
        `player_data3` VARCHAR(4096) NOT NULL,	\
        PRIMARY KEY(`player_name`,`player_ip`,`player_steamid`),\
        KEY `player_data` (`player_data`),    	\
        KEY `player_data2` (`player_data2`),  	\
        KEY `player_data3` (`player_data3`)   	\
    ) TYPE=MyISAM; 				\
";

[xbatista]

worked fine arky

EDIT : Something wrong in your string :

L 02/10/2010 - 16:29:03: [diablo2LOD.amxx] [MYSQLX] 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 'KEY `player_data` (`player_data`), KEY `player_data2` (`player_data2`), KE' at line 1

[stupok]

Read the error message. It's too long. Make it shorter, or do two separate queries.

[Arkshine]

Originally Posted by xbatista worked fine arky EDIT : Something wrong in your string :

Try again, I've forgot a ',' after `player_steamid`)

[xbatista]

now works, no errors and creates the table, thanks