10.02.2013, 19:49
pawn Код:
mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
mysql_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), \
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), \
PosX float, \
PosY float, \
PosZ float, \
PosA float, \
Registered INT(20) )");
mysql_query("ALTER TABLE playerdata ADD FishName1 INT(20)");
mysql_query("ALTER TABLE playerdata ADD FishName2 INT(20)");
mysql_query("ALTER TABLE playerdata ADD FishName3 INT(20)");
mysql_query("ALTER TABLE playerdata ADD FishName4 INT(20)");
mysql_query("ALTER TABLE playerdata ADD FishName5 INT(20)");
mysql_query("ALTER TABLE playerdata ADD FishNames INT(20)");
mysql_query("ALTER TABLE playerdata ADD FishingRod INT(20)");
mysql_query("ALTER TABLE playerdata ADD RodDurab INT(20)");
mysql_query("ALTER TABLE playerdata ADD Bait INT(20)");
mysql_debug(1);
I recompile - rerun the server - refresh phpmyadmin and "No tables found in database". Wtf? Seems like it just does what it wants.