stock CreateAccountTabelle()
{
new query[2048], query2[256];
format(query, sizeof(query), "CREATE TABLE IF NOT EXISTS `"SQL_DTAG"accounts` (");
format(query, sizeof(query), "%s `ID` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `Spielername` varchar(32) NOT NULL,", query);
format(query, sizeof(query), "%s `Passwort` varchar(65) NOT NULL,", query);
format(query, sizeof(query), "%s `Geschlecht` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `Geburtsdatum` varchar(11) NOT NULL,", query);
format(query, sizeof(query), "%s `Tutorial` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `Level` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `Geld` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `SpawnChange` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `Skin` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `Admin` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `Perso` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `Fraktion` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `FraktionRang` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `LastIP` varchar(16) NOT NULL", query);
format(query, sizeof(query), "%s) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;", query);
mysql_pquery(handle, query);
format(query2, sizeof(query2), "ALTER TABLE `"SQL_DTAG"accounts`");
format(query2, sizeof(query2), "%s ADD PRIMARY KEY (`ID`);", query2);
mysql_pquery(handle, query2);
return 1;
}
Alles anzeigen