08.08.2011, 21:58
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:
![Wink](images/smilies/wink.png)
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);
}