MySQL help - 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: MySQL help (
/showthread.php?tid=635080)
MySQL help -
MrFantasy - 01.06.2017
Код:
SetupPlayerTable()
{
mysql_tquery(g_SQL, "CREATE TABLE IF NOT EXISTS `players` (`id` int(11) NOT NULL AUTO_INCREMENT,`username` varchar(24) NOT NULL,`password` char(64) NOT NULL,`salt` char(16) NOT NULL,`kills` mediumint(8) NOT NULL DEFAULT '0',`deaths` mediumint(8) NOT NULL DEFAULT '0',`x` float NOT NULL DEFAULT '0',`y` float NOT NULL DEFAULT '0',`z` float NOT NULL DEFAULT '0',`angle` float NOT NULL DEFAULT '0',`interior` tinyint(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`))");
return 1;
}
This code, how can I put AdminLevel inside there?
Код:
enum pInfo
{
ID,
AdminLevel,
Name[MAX_PLAYER_NAME],
Password[65], // the output of SHA256_PassHash function (which was added in 0.3.7 R1 version) is always 256 bytes in length, or the equivalent of 64 Pawn cells
Salt[17],
Kills,
Deaths,
Float: X_Pos,
Float: Y_Pos,
Float: Z_Pos,
Float: A_Pos,
Interior,
Cache: Cache_ID,
bool: IsLoggedIn,
LoginAttempts,
LoginTimer
};
new PlayerInfo[MAX_PLAYERS][pInfo];
Re: MySQL help -
JasonRiggs - 01.06.2017
Код:
SetupPlayerTable()
{
mysql_tquery(g_SQL, "CREATE TABLE IF NOT EXISTS `players` (`id` int(11) NOT NULL AUTO_INCREMENT,`Admin Rank` mediumint(8) NOT NULL DEFAULT '0',`username` varchar(24) NOT NULL,`password` char(64) NOT NULL,`salt` char(16) NOT NULL,`kills` mediumint(8) NOT NULL DEFAULT '0',`deaths` mediumint(8) NOT NULL DEFAULT '0',`x` float NOT NULL DEFAULT '0',`y` float NOT NULL DEFAULT '0',`z` float NOT NULL DEFAULT '0',`angle` float NOT NULL DEFAULT '0',`interior` tinyint(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`))");
return 1;
}
Replace your code with this one.