06.02.2013, 21:18
pawn Код:
mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
new query[2048];
format(query, sizeof(query), "CREATE TABLE IF NOT EXISTS playerdata(Username VARCHAR(24), Password VARCHAR(40), Level INT(20), Gender INT(20), Cash INT(20), Bank INT(20), Job INT(20), BirthDate INT(20), BirthMonth INT(20), BirthYear INT(20), AdminLevel INT(20), AdminDuty INT(20),");
format(query, sizeof(query), "%s IP VARCHAR(15), Skin INT(20), FishPermit INT(20), Fish1 INT(20), Fish2 INT(20), Fish3 INT(20), Fish4 INT(20), Fish5 INT(20), Fishes INT(20), FishName1 VARCHAR(24), FishName2 VARCHAR(24), FishName3 VARCHAR(24), FishName4 VARCHAR(24),", query);
format(query, sizeof(query), "%s FishName5 VARCHAR(24), FishNames INT(20), PosX float, PosY float, PosZ float, PosA float, Registered INT(20)", query);
mysql_query(query);
mysql_debug(1);
Your input line in the code was simply too long.
