Create Table problem - Printable Version

Create Table problem - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Create Table problem (/showthread.php?tid=414867)

Create Table problem - AphexCCFC - 10.02.2013

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.

Re: Create Table problem - MP2 - 10.02.2013

Logs..?

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