· 9 years ago · Nov 06, 2016, 12:44 AM
1main()
2{
3 new query[515];
4 strcat(query, "CREATE TABLE IF NOT EXISTS `players` (`id` int(11) NOT NULL AUTO_INCREMENT,`username` varchar(24) NOT NULL,");
5 strcat(query, "`password` char(64) NOT NULL,`salt` char(16) NOT NULL,`kills` mediumint(8) NOT NULL DEFAULT '0',");
6 strcat(query, "`deaths` mediumint(8) NOT NULL DEFAULT '0', `classe` int(20) NOT NULL DEFAULT '0',`x` float NOT NULL DEFAULT '0',");
7 strcat(query, "`y` float NOT NULL DEFAULT '0',`z` float NOT NULL DEFAULT '0',`angle` float NOT NULL DEFAULT '0',");
8 strcat(query, "`interior` tinyint(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`))");
9 //mysql_tquery(g_SQL, query);
10 print(query);
11}