29.03.2019, 14:31
PHP код:
new query[1000];
strcat(query, "CREATE TABLE IF NOT EXISTS `"TABELA_FACCOES"` (`FactionID` int AUTO_INCREMENT PRIMARY KEY,");
strcat(query, "`Facзгo Nome` varchar("#MAX_NOME_FACCAO"), `Lнder da Facзгo` varchar(24), `Local Facзгo X` float NOT NULL,");
strcat(query, "`Local Facзгo Y` float NOT NULL, `Local Facзгo Z` float NOT NULL, `Local Facзгo A` float NOT NULL,");
strcat(query, "`Cofre da Facзгo` int NOT NULL");
new string[66];
for(new m; m < MAX_MEMBERS; ++m){
format(string, 256, "`Membro %d` varchar(24) NOT NULL, `Aviso Membro %d` int NOT NULL%s", m+1, m+1, m == MAX_MEMBERS-1 ? (")") : (","));
strcat(query, string);
}
mysql_query(g_SQL, query);