Create Table problem
#1

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);
This worked has been working for weeks, haven't even added anything new..
I recompile - rerun the server - refresh phpmyadmin and "No tables found in database". Wtf? Seems like it just does what it wants.
Reply
#2

Logs..?

(PUT mysql_debug(1) AT THE TOP OTHERWISE IT'S POINTLESS!)
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)