[Question] MySQL
#1

Код:
    mysql_query("CREATE TABLE IF NOT EXISTS Factions(FactionID INT(1) NOT NULL, Leader INT(1) NOT NULL, Members INT(15) NOT NULL)");
	mysql_query("CREATE TABLE IF NOT EXISTS PlayerInfo(Name VARCHAR(25), Password VARCHAR(25), Level INT(3), VIP INT(1), AdminLevel INT(1)");
i made these querys but Factions table is the only table to create, soo what should i do to create the playerinfo?
obs: both are on onfilterscriptinit
Reply
#2

You're missing the closing ')' on the playerdata create table but there may be more issues. Use mysql_debug(1); before those lines then post your MySQL log that is in your server directory if problems persist.
Reply
#3

Sorry, my bad, it was only the ґ)ґ thank you for your quick answer.
Reply
#4

i got a new error :

[01:31:10] CMySQLHandler::Query(INSERT PlayerInfo(Name, Password, Level, VIP, AdminLevel, Faction) VALUES (Player, senha, 0, 0, 0, 'none')) - An error has occured. (Error ID: 1054, Unknown column 'Player' in 'field list')

any ideas?
Reply
#5

All string values must be in-cased with ' and ' like you did with the value 'none'.
Reply
#6

thank you again
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)