16.08.2015, 13:54
Try to use two formats:
Код:
new query[1000]; format(query, sizeof(query), "CREATE TABLE IF NOT EXISTS `players`(\ `ID` int(10) NOT NULL AUTO_INCREMENT, \ `Username` varchar(24) NOT NULL, \ `Password` varchar(129) NOT NULL, \ `IP` varchar(16) NOT NULL, \ `Admin` int(10) NOT NULL, \ `VIP` int(10) NOT NULL, \ `Ban` int(10) NOT NULL, \ `Kills` int(10) NOT NULL, \ `Deaths` int(10) NOT NULL, \ `Score` int(10) NOT NULL, \ `Cash` int(10) NOT NULL, \ `Skin` int(10) NOT NULL, \ `Jail` int(10) NOT NULL, \ `Headshots` int(10) NOT NULL, \ `Bombs` int(10) NOT NULL, \ `Veh1` int(10) NOT NULL, \ `Veh2` int(10) NOT NULL, \ `Veh3` int(10) NOT NULL, \ `Veh4` int(10) NOT NULL, \ `Veh5` int(10) NOT NULL, "); //second format format(query, sizeof(query), "%s`Veh6` int(10) NOT NULL, \ `Veh7` int(10) NOT NULL, \ `Veh8` int(10) NOT NULL, \ `Veh9` int(10) NOT NULL, \ `Veh10` int(10) NOT NULL, \ `Lock` int(10) NOT NULL, \ `Cloths` int(10) NOT NULL, \ `Helper` int(10) NOT NULL, \ `AK47` int(10) NOT NULL, \ `M4` int(10) NOT NULL, \ `SP` int(10) NOT NULL, \ `Balance` int(10) NOT NULL, \ `Duelwon` int(10) NOT NULL, \ `Duellose` int(10) NOT NULL, \ `Kick` int(10) NOT NULL, \ `Warns` int(10) NOT NULL, \ `Mathwin` int(10) NOT NULL, \ `Moneybag` int(10) NOT NULL, \ `BanAdmin` varchar(24) NOT NULL, \ `BanReason` varchar(32) NOT NULL, \ PRIMARY KEY (`ID`))", query); mysql_tquery(mysql, query, "", "");