Hey irgentwie wird mein Account nie gespeichert.....
ich bin der meinung, das etwas an der Tabelle nicht stimmt...
bitte help!
.sql:
new string[2900] = "CREATE TABLE IF NOT EXISTS `accounts` (";
strcat(string,"`id` int(11) NOT NULL AUTO_INCREMENT,");
strcat(string,"`Name` varchar(24) NOT NULL,");
strcat(string,"`Passwort` varchar(128) NOT NULL,");
strcat(string,"`Level` int(11) NOT NULL DEFAULT '1',");
strcat(string,"`Geld` int(11) NOT NULL DEFAULT '10000',");
strcat(string,"`Skin` int(11) NOT NULL DEFAULT '137',");
strcat(string,"`Member` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Job` int NOT NULL DEFAULT '0',");
strcat(string,"`Job Zeit` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Leader` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`FrakRank` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Adminlevel` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Supporter` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Ban` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Fuehrerschein` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Personalausweis` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Wantedlevel` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Krankenversicherung` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Verwarnungen` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Geschlecht` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Waffenschein` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Lunch` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Angelschein` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`iPod` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Fraktionsname` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Bank` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Geburtsjahr` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Jailtime` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Wanteds` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`Gestorben` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`PTX` float(11) NOT NULL DEFAULT '0',");
strcat(string,"`PTY` float(11) NOT NULL DEFAULT '0',");
strcat(string,"`PTZ` float(11) NOT NULL DEFAULT '0',");
strcat(string,"`NextPayday` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`ErsterLog` int(11) NOT NULL DEFAULT '0',");
strcat(string,"`LastX` float(11) NOT NULL DEFAULT '0',");
strcat(string,"`LastY` float(11) NOT NULL DEFAULT '0',");
strcat(string,"`LastZ` float(11) NOT NULL DEFAULT '0',");
strcat(string,"`LastA` float(11) NOT NULL DEFAULT '0',");
strcat(string,"PRIMARY KEY (`id`)");
strcat(string,") ENGINE=MyISAM AUTO_INCREMENT=220 DEFAULT CHARSET=latin1;");
mysql_query(string);
SavePlayer
stock SavePlayer(playerid)
{
mysql_SetInt("accounts", "Level", GetPlayerScore(playerid), "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Geld", GetPlayerMoney(playerid), "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Skin", GetPlayerSkin(playerid), "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Member", PlayerInfo[playerid][pMember], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Job", PlayerInfo[playerid][pJob], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Job Zeit", PlayerInfo[playerid][pJobTime], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Leader", PlayerInfo[playerid][pLeader], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "FrakRank", PlayerInfo[playerid][pFRank], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Member", PlayerInfo[playerid][pMember], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Adminlevel", PlayerInfo[playerid][pAdmin], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Supporter", PlayerInfo[playerid][pSupporter], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Ban", PlayerInfo[playerid][pBan], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Fuehrerschein", PlayerInfo[playerid][pDriverLic], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Personalausweis", PlayerInfo[playerid][pPerso], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Wantedlevel", GetPlayerWantedLevel(playerid), "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Krankenversicherung", PlayerInfo[playerid][pVersichert], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Verwarnungen", PlayerInfo[playerid][pWarn], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Geschlecht", PlayerInfo[playerid][pGeschlecht], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Waffenschein", PlayerInfo[playerid][pWaffenschein], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Lunch", PlayerInfo[playerid][pLunch], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Angelschein", PlayerInfo[playerid][pAngel], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "iPod", PlayerInfo[playerid][pIPod], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Fraktionsname", PlayerInfo[playerid][pFName], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Bank", PlayerInfo[playerid][Bank], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Geburtsjahr", PlayerInfo[playerid][pDate], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Jailtime", PlayerInfo[playerid][pJailtime], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Wanteds", PlayerInfo[playerid][pWanted], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "Gestorben", PlayerInfo[playerid][pTot], "Name", PlayerInfo[playerid][pName]);
mysql_SetFloat("accounts", "PTX", PlayerInfo[playerid][pTx], "Name", PlayerInfo[playerid][pName]);
mysql_SetFloat("accounts", "PTY", PlayerInfo[playerid][pTy], "Name", PlayerInfo[playerid][pName]);
mysql_SetFloat("accounts", "PTZ", PlayerInfo[playerid][pTz], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "NextPayday", Acc[playerid][NextPayday], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accounts", "ErsterLog", PlayerInfo[playerid][FirstLog], "Name", PlayerInfo[playerid][pName]);
mysql_SetFloat("accounts", "LastX", PlayerInfo[playerid][LogX], "Name", PlayerInfo[playerid][pName]);
mysql_SetFloat("accounts", "LastY", PlayerInfo[playerid][LogY], "Name", PlayerInfo[playerid][pName]);
mysql_SetFloat("accounts", "LastZ", PlayerInfo[playerid][LogZ], "Name", PlayerInfo[playerid][pName]);
mysql_SetFloat("accounts", "LastA", PlayerInfo[playerid][LogA], "Name", PlayerInfo[playerid][pName]);
return 1;
}
