Automatically adding tables/fields in MySQL database.
#9

I figured as much! I'll do it that way instead, it's more efficient anyways. Plus, with threaded queries it won't cause any lag!

Final code:

pawn Код:
stock CreateSQLTables()
{
    mysql_query("CREATE TABLE IF NOT EXISTS `Accounts` ( \
    `Username` varchar(25) NOT NULL, \
    `Password` varchar(129) NOT NULL, \
    `aLevel` int(11) NOT NULL, \
    `aPassword` varchar(129) NOT NULL, \
    `Money` int(11) NOT NULL, \
    `Score` int(11) NOT NULL, \
    UNIQUE KEY `Username` (`Username`) \
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;"
, qNormal);

    mysql_query("CREATE TABLE IF NOT EXISTS `Ban Logs` ( \
    `Log ID` int(11) NOT NULL auto_increment, \
    `Administrator` varchar(25) NOT NULL, \
    `Player` varchar(25) NOT NULL, \
    `Reason` varchar(150) NOT NULL, \
    `Length` varchar(128) NOT NULL, \
    PRIMARY KEY  (`Log ID`) \
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;"
, qNormal);

    mysql_query("CREATE TABLE IF NOT EXISTS `CMD Logs` ( \
    `Log ID` int(11) NOT NULL auto_increment, \
    `Player` varchar(25) NOT NULL, \
    `cmdtext` varchar(300) NOT NULL, \
    PRIMARY KEY  (`Log ID`) \
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;"
, qNormal);

    mysql_query("CREATE TABLE IF NOT EXISTS `Kick Logs` ( \
    `Log ID` int(11) NOT NULL auto_increment, \
    `Administrator` varchar(25) NOT NULL, \
    `Player` varchar(25) NOT NULL, \
    `Reason` varchar(150) NOT NULL, \
    PRIMARY KEY  (`Log ID`) \
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;"
, qNormal);
}
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 2 Guest(s)