Guten Tag habe ein problem Accounts werden nicht gespeichert
SChon weren die gepeichert aber Das geld,level,adminleven und soh weiter
Könnt ihr mir vileicht helfen ?????
Guten Tag habe ein problem Accounts werden nicht gespeichert
SChon weren die gepeichert aber Das geld,level,adminleven und soh weiter
Könnt ihr mir vileicht helfen ?????
Könnt ihr mir vileicht helfen
So. Jetzt nochmal ganz langsam und ganz von vorne.
Zeig uns doch mal ein wenig von dem Code. Am besten den, wo du alles speichern lässt.
MEinst du das
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `users_backup`
--
CREATE TABLE IF NOT EXISTS `users_backup` (
`SQLid` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(24) NOT NULL,
`Password` varchar(32) NOT NULL,
`keyConfirmKey` varchar(10) NOT NULL DEFAULT '0',
`Level` int(11) NOT NULL DEFAULT '0',
`AdminLevel` int(11) NOT NULL DEFAULT '0',
`krankenkasse` int(11) NOT NULL DEFAULT '0',
`krankenzeit` int(11) NOT NULL DEFAULT '0',
`DonateRank` int(11) NOT NULL DEFAULT '0',
`UpgradePoints` int(11) NOT NULL DEFAULT '0',
`ConnectedTime` int(11) NOT NULL DEFAULT '0',
`Registered` int(11) NOT NULL DEFAULT '0',
`Sex` int(11) NOT NULL DEFAULT '0',
`Age` int(11) NOT NULL DEFAULT '0',
`Origin` int(11) NOT NULL DEFAULT '0',
`Muted` int(11) NOT NULL DEFAULT '0',
`Respect` int(11) NOT NULL DEFAULT '0',
`Money` int(11) NOT NULL DEFAULT '0',
`Bank` int(11) NOT NULL DEFAULT '0',
`Crimes` int(11) NOT NULL DEFAULT '0',
`Kills` int(11) NOT NULL DEFAULT '0',
`sKills` int(11) NOT NULL DEFAULT '0',
`Deaths` int(11) NOT NULL DEFAULT '0',
`Arrested` int(11) NOT NULL DEFAULT '0',
`ArrestTime` int(11) NOT NULL DEFAULT '0',
`PhoneBook` int(11) NOT NULL DEFAULT '0',
`LottoNr` int(11) NOT NULL DEFAULT '0',
`Fishes` int(11) NOT NULL DEFAULT '0',
`BiggestFish` int(11) NOT NULL DEFAULT '0',
`Job` int(11) NOT NULL DEFAULT '0',
`Paycheck` int(11) NOT NULL DEFAULT '0',
`HeadValue` int(11) NOT NULL DEFAULT '0',
`Jailed` int(11) NOT NULL DEFAULT '0',
`JailTime` int(11) NOT NULL DEFAULT '0',
`Materials` int(11) NOT NULL DEFAULT '0',
`Drugs` int(11) NOT NULL DEFAULT '0',
`Leader` int(11) NOT NULL DEFAULT '0',
`Member` int(11) NOT NULL DEFAULT '0',
`Rank` int(11) NOT NULL DEFAULT '0',
`Char` int(11) NOT NULL DEFAULT '0',
`Vertragszeit` int(11) NOT NULL DEFAULT '0',
`DetSkill` int(11) NOT NULL DEFAULT '0',
`SexSkill` int(11) NOT NULL DEFAULT '0',
`LawSkill` int(11) NOT NULL DEFAULT '0',
`MechSkill` int(11) NOT NULL DEFAULT '0',
`JackSkill` int(11) NOT NULL DEFAULT '0',
`CarSkill` int(11) NOT NULL DEFAULT '0',
`NewsSkill` int(11) NOT NULL DEFAULT '0',
`DrugsSkill` int(11) NOT NULL DEFAULT '0',
`CookSkill` int(11) NOT NULL DEFAULT '0',
`FishSkill` int(11) NOT NULL DEFAULT '0',
`pSHealth` float NOT NULL DEFAULT '0',
`pHealth` float NOT NULL DEFAULT '0',
`PhoneNr` int(11) NOT NULL DEFAULT '0',
`House` int(11) NOT NULL DEFAULT '0',
`Biz` int(11) NOT NULL DEFAULT '0',
`CarLic` int(11) NOT NULL DEFAULT '0',
`FlyLic` int(11) NOT NULL DEFAULT '0',
`BoatLic` int(11) NOT NULL DEFAULT '0',
`FishLic` int(11) NOT NULL DEFAULT '0',
`GunLic` int(11) NOT NULL DEFAULT '0',
`Zollpass` int(11) NOT NULL DEFAULT '0',
`Gun1` int(11) NOT NULL DEFAULT '0',
`Gun2` int(11) NOT NULL DEFAULT '0',
`Gun3` int(11) NOT NULL DEFAULT '0',
`Gun4` int(11) NOT NULL DEFAULT '0',
`Ammo1` int(11) NOT NULL DEFAULT '0',
`Ammo2` int(11) NOT NULL DEFAULT '0',
`Ammo3` int(11) NOT NULL DEFAULT '0',
`Ammo4` int(11) NOT NULL DEFAULT '0',
`CarTime` int(11) NOT NULL DEFAULT '0',
`PayDay` int(11) NOT NULL DEFAULT '0',
`PayDayHad` int(11) NOT NULL DEFAULT '0',
`CDPlayer` int(11) NOT NULL DEFAULT '0',
`AlcoholPerk` int(11) NOT NULL DEFAULT '0',
`DrugPerk` int(11) NOT NULL DEFAULT '0',
`MiserPerk` int(11) NOT NULL DEFAULT '0',
`TraderPerk` int(11) NOT NULL DEFAULT '0',
`Tutorial` int(11) NOT NULL DEFAULT '0',
`Mission` int(11) NOT NULL DEFAULT '0',
`Warnings` int(11) NOT NULL DEFAULT '0',
`Fuel` int(11) NOT NULL DEFAULT '0',
`Married` int(11) NOT NULL DEFAULT '0',
`MarriedTo` text NOT NULL,
`WantedLevel` int(11) NOT NULL DEFAULT '0',
`FamilySpawn` int(11) NOT NULL DEFAULT '0',
`Spawn` int(11) NOT NULL DEFAULT '0',
`SavedMaterials` int(11) NOT NULL DEFAULT '0',
`SavedDrugs` int(11) NOT NULL DEFAULT '0',
`BikeLic` int(11) NOT NULL DEFAULT '0',
`LKWLic` int(11) NOT NULL DEFAULT '0',
`DonatorTime` int(11) NOT NULL DEFAULT '0',
`WerberName` text NOT NULL,
`FightingStyle` int(11) NOT NULL DEFAULT '0',
`Handy` int(11) NOT NULL DEFAULT '0',
`OnDutySkin` int(11) NOT NULL DEFAULT '0',
`CarLicPoints` int(11) NOT NULL DEFAULT '0',
`BikeLicPoints` int(11) NOT NULL DEFAULT '0',
`InviteSperre` int(11) NOT NULL DEFAULT '0',
`warntime1` int(11) NOT NULL DEFAULT '0',
`warntime2` int(11) NOT NULL DEFAULT '0',
`Ticketsopen` int(11) NOT NULL DEFAULT '0',
`Banned` int(11) NOT NULL DEFAULT '0',
`Skin` int(11) NOT NULL DEFAULT '0',
`OldName` text,
`StudioLeiter` int(11) NOT NULL DEFAULT '0',
`PainKillerPerk` int(11) NOT NULL DEFAULT '0',
`ClientIP` varchar(32) NOT NULL DEFAULT '0.0.0.0',
`OrgLeader` int(11) NOT NULL DEFAULT '-1',
`OrgMember` int(11) NOT NULL DEFAULT '-1',
`OrgName` varchar(156) NOT NULL DEFAULT 'Keine',
`SaveCodes` int(11) NOT NULL,
`DeleteDatum` int(11) NOT NULL DEFAULT '0',
`LastLoginDatum` int(11) NOT NULL DEFAULT '0',
`RegisterDatum` int(11) NOT NULL DEFAULT '0',
`InviteDatum` int(11) NOT NULL DEFAULT '0',
`eMail` varchar(100) NOT NULL DEFAULT '0',
`eMailConfirmKey` varchar(10) NOT NULL DEFAULT '0',
`TeamspeakRegistered` int(1) NOT NULL DEFAULT '0',
`TeamspeakDBID` int(5) NOT NULL DEFAULT '0',
`TeamspeakUID` varchar(100) NOT NULL DEFAULT '0',
`TeamspeakSupporter` int(1) NOT NULL DEFAULT '0',
`TeamspeakChannelAdmin` int(5) NOT NULL DEFAULT '0',
`TeamspeakBanned` int(1) NOT NULL DEFAULT '0',
`ComplainModerator` int(1) NOT NULL DEFAULT '0',
`ForumRegistered` int(5) NOT NULL DEFAULT '0',
`ForumModerator` int(5) NOT NULL DEFAULT '0',
`ForumGroupLeader` int(4) NOT NULL DEFAULT '0',
`ForumDonator` int(1) NOT NULL DEFAULT '0',
`ControlPanelBanned` int(1) NOT NULL DEFAULT '0',
`OPBeschwerden` int(2) NOT NULL DEFAULT '0',
`Timestamp` bigint(20) DEFAULT '0',
`Allowed` int(11) DEFAULT '0',
PRIMARY KEY (`SQLid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Jetz wissen wir wie deine Tabelle aussieht,
Wie wäre es mit dem Code wo du das ganze speicherst?
kleines problem ich weis nicht genau was das ist das ist von mein bruder das script sollte von den fragen schike einfach mal alles aus User : http://pastebin.com/DEBnDP8T
Willkommen auf Breadfish!
Das was du uns hier gegeben hast ist deine Datenbankstruktur und deine Daten.
Du musst aber die Scriptdatei öffnen (.pwn-Datei) und den Code, der die Spieler speichert uns geben.
Außerdem wäre es sehr hilfreich, wenn du uns den Log deines MySQL Plugins gibst. Wie du an den kommst ist hier beschrieben: Tipps: Scripting-Probleme richtig erklären (Kapitel 1.4).
was soll ich suchen habe schon accounts probirt aber xDzu viel verstehe nix muss ich vileich mysql_??
Du hast doch einen Ordner in dem die samp-server.exe liegt. Öffne diesen Ordner, dann gehe in den gamemodes Order und öffne die .pwn Datei die da drin ist. Dann suche in dem Code den Teil, der den Spieler speichert.
Wenn du allerdings überhaupt nicht weißt was du wo machen musst, dann rate ich dir auf deinen Bruder zu warten, der soll dir dann helfen.
//---------------------Save's------------------------//
public LoadStuff()
{
if(SaveServerMySQL == 1)
{
StuffInfo[sSteuern] = mysql_GetInttoo("stuff", "Steuern", "DatensatzID");
StuffInfo[sSteuerkasse] = mysql_GetInttoo("stuff", "Steuerkasse", "DatensatzID");
StuffInfo[sJackpot] = mysql_GetInttoo("stuff", "Jackpot", "DatensatzID");
StuffInfo[sVerfuegbareDrogen] = mysql_GetInttoo("stuff", "VerfuegbareDrogen", "DatensatzID");
StuffInfo[sDrogenBank] = mysql_GetInttoo("stuff", "DrogenBank", "DatensatzID");
StuffInfo[sAktuellesWetter] = mysql_GetInttoo("stuff", "AktuellesWetter", "DatensatzID");
StuffInfo[sWetterVorhersage] = mysql_GetInttoo("stuff", "WetterVorhersage", "DatensatzID");
StuffInfo[sUserRekord] = mysql_GetInttoo("stuff", "UserRekord", "DatensatzID");
StuffInfo[sLastNumber] = mysql_GetInttoo("stuff", "LastNumber", "DatensatzID");
StuffInfo[sToteUser] = mysql_GetInttoo("stuff", "Tode", "DatensatzID");
StuffInfo[sSendSMS] = mysql_GetInttoo("stuff", "SMS", "DatensatzID");
StuffInfo[sSchrotCars] = mysql_GetInttoo("stuff", "CarsDead", "DatensatzID");
StuffInfo[sCommands] = mysql_GetInttoo("stuff", "Commands", "DatensatzID");
StuffInfo[sNeuUser] = mysql_GetInttoo("stuff", "NeueUser", "DatensatzID");
StuffInfo[sVerbrechen] = mysql_GetInttoo("stuff", "Verbrechen", "DatensatzID");
StuffInfo[sLoggins] = mysql_GetInttoo("stuff", "Loggins", "DatensatzID");
StuffInfo[sWeaponPreis] = mysql_GetInttoo("stuff", "Waffen", "DatensatzID");
StuffInfo[sEinnahmen] = mysql_GetInttoo("stuff", "Einnahmen", "DatensatzID");
StuffInfo[sAusgaben] = mysql_GetInttoo("stuff", "Ausgaben", "DatensatzID");
StuffInfo[sEventKasse] = mysql_GetInttoo("stuff", "EventKasse", "DatensatzID");
StuffInfo[slogzeile] = mysql_GetInttoo("stuff", "logzeile", "DatensatzID");
StuffInfo[sCasinoMoney] = mysql_GetInttoo("stuff", "CasinoMoney", "DatensatzID");
StuffInfo[LastOrgaID] = mysql_GetInttoo("stuff", "LastOrgaID", "DatensatzID");
StuffInfo[Produkte] = mysql_GetInttoo("stuff", "Produkte", "DatensatzID");
StuffInfo[sFahrschulpreise] = mysql_GetInttoo("stuff", "Fahrschulpreise", "DatensatzID");
StuffInfo[sKreditkartenpreise] = mysql_GetInttoo("stuff","Kreditkartenpreise","DatensatzID");
}
return 1;
}
Das ist nicht der richtige Code. Dieser Code lädt Server Einstellungen beim starten des Servers.
Du musst den Code posten, der die Spielerstatistiken speichert.
public SavePlayers()
{
ForAllPlayers(i){
if(IsPlayerConnected(i) && gPlayerLogged[i] && !IsPlayerNPC(i)){
if(strcmp(PlayerInfo[i][pForceName], "Niemand", true) != 0)
{
SetPlayerName(i,PlayerInfo[i][pForceName]);
SetPlayerScore(i, PlayerInfo[i][pLevel]);
}
PlayerUpdate(i);
PlayerCarUpdate(i);
}
}
return 1;
Den habe ich jetzt nur noch gefunden
Ja zeig uns doch den Query...
Zeig mal "PlayerUpdate"
mfg
public PlayerUpdate(playerid)
{
if(IsPlayerConnected(playerid))
{
if(IsPlayerNPC(playerid))
{
return 1;
}
new playername[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername, sizeof(playername));
new endstring[1600];
new var[129];
new Float: p[4];
GetPlayerPos(playerid, p[0], p[1], p[2]);
GetPlayerFacingAngle(playerid, p[3]);
format(endstring, sizeof(endstring), "UPDATE `users` SET ");
format(var, sizeof(var), "`Password`='%s', ", PlayerInfo[playerid][pKey]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Level`='%d', ", PlayerInfo[playerid][pLevel]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`AdminLevel`='%d', ", PlayerInfo[playerid][pAdmin]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Checkpoint`='%d', ", CCP[playerid]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`CPrison`='%d', ", xPrison[playerid]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`RunningCP`='%d', ", RunningCP[playerid]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`TeamRadar`='%d', ", TeamRadar[playerid]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`BNDRadar`='%d', ", BNDRadar[playerid]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Rolex`='%d', ", PlayerInfo[playerid][pRolex]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Swissonic`='%d', ", PlayerInfo[playerid][pSwissonic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Casio`='%d', ", PlayerInfo[playerid][pCasio]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Breitling`='%d', ", PlayerInfo[playerid][pBreitling]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Nixon`='%d', ", PlayerInfo[playerid][pNixon]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`IceWatch`='%d', ", PlayerInfo[playerid][pIceWatch]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`StartCoints`='%d', ", PlayerInfo[playerid][pStartCoints]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Coints`='%d', ", PlayerInfo[playerid][pCoints]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Spawnheal`='%d', ", PlayerInfo[playerid][pSpawnheal]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Deaglespawn`='%d', ", PlayerInfo[playerid][pDeaglespawn]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`M4Spawn`='%d', ", PlayerInfo[playerid][pM4Spawn]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`MP5Spawn`='%d', ", PlayerInfo[playerid][pMP5Spawn]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`MehrZinsen`='%d', ", PlayerInfo[playerid][pMehrZinsen]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`SpawnhealZeit`='%d', ", PlayerInfo[playerid][pSpawnhealZeit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`DeaglespawnZeit`='%d', ", PlayerInfo[playerid][pDeaglespawnZeit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`M4SpawnZeit`='%d', ", PlayerInfo[playerid][pM4SpawnZeit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`MP5SpawnZeit`='%d', ", PlayerInfo[playerid][pMP5SpawnZeit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`MehrZinsenZeit`='%d', ", PlayerInfo[playerid][pMehrZinsenZeit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Medickit`='%d', ", PlayerInfo[playerid][pMedickit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Startbonus`='%d', ", PlayerInfo[playerid][pStartbonus]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Kreditkarte`='%d', ", PlayerInfo[playerid][pKreditkarte]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`KreditkarteBenutzung`='%d', ", PlayerInfo[playerid][pKreditkartebenutzen]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Personalausweis`='%d', ", PlayerInfo[playerid][pPersonalausweis]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Namechange`='%d', ", PlayerInfo[playerid][pSchongeandert]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`krankenkasse`='%d', ", PlayerInfo[playerid][pKrankenkasse]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`krankenzeit`='%d', ", PlayerInfo[playerid][pKrankenkasseTime]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`DonateRank`='%d', ", PlayerInfo[playerid][pDonatorRank]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`UpgradePoints`='%d', ", PlayerInfo[playerid][gPupgrade]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`ConnectedTime`='%d', ", PlayerInfo[playerid][pConnectTime]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Registered`='%d', ", PlayerInfo[playerid][pReg]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Sex`='%d', ", PlayerInfo[playerid][pSex]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Age`='%d', ", PlayerInfo[playerid][pAlter]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Origin`='%d', ", PlayerInfo[playerid][pOrigin]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Muted`='%d', ", PlayerInfo[playerid][pMuted]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Respect`='%d', ", PlayerInfo[playerid][pRespekt]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Gehalt`='%d', ", PlayerInfo[playerid][pGehalt]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Money`='%d', ", PlayerInfo[playerid][pCash]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Bank`='%d', ", PlayerInfo[playerid][pBank]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Allowed`='%d', ", PlayerInfo[playerid][pAllowed]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Crimes`='%d', ", PlayerInfo[playerid][pCrimes]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Kills`='%d', ", PlayerInfo[playerid][pKills]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`sKills`='%d', ", PlayerInfo[playerid][psKills]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Deaths`='%d', ", PlayerInfo[playerid][pDeaths]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Arrested`='%d', ", PlayerInfo[playerid][pArrested]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`ArrestTime`='%d', ", PlayerInfo[playerid][pArrestTime]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`PhoneBook`='%d', ", PlayerInfo[playerid][pPhoneBook]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`LottoNr`='%d', ", PlayerInfo[playerid][pLottoNr]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Fishes`='%d', ", PlayerInfo[playerid][pFishes]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`BiggestFish`='%d', ", PlayerInfo[playerid][pBiggestFish]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Job`='%d', ", PlayerInfo[playerid][pJob]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Paycheck`='%d'", PlayerInfo[playerid][pPayCheck]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), " WHERE `Name`='%s'", playername);
strcat(endstring, var, sizeof(endstring));
self_mysql_queryEx(endstring);
format(endstring, sizeof(endstring), "UPDATE `users` SET ");
format(var, sizeof(var), "`HeadValue`='%d', ", PlayerInfo[playerid][pHeadValue]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Jailed`='%d', ", PlayerInfo[playerid][pJailed]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`JailTime`='%d', ", PlayerInfo[playerid][pJailTime]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Leader`='%d', ", PlayerInfo[playerid][pLeader]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Member`='%d', ", PlayerInfo[playerid][pMember]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Rank`='%d', ", PlayerInfo[playerid][pRank]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Skin`='%d', ", PlayerInfo[playerid][pChar]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Vertragszeit`='%d', ", PlayerInfo[playerid][pVertragszeit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`DetSkill`='%d', ", PlayerInfo[playerid][pDetSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`SexSkill`='%d', ", PlayerInfo[playerid][pSexSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`LawSkill`='%d', ", PlayerInfo[playerid][pAnwaltSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`MechSkill`='%d', ", PlayerInfo[playerid][pMechSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`JackSkill`='%d'", PlayerInfo[playerid][pJackSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), " WHERE `Name`='%s'", playername);
strcat(endstring, var, sizeof(endstring));
self_mysql_queryEx(endstring);
format(endstring, sizeof(endstring), "UPDATE `users` SET ");
format(var, sizeof(var), "`CarSkill`='%d', ", PlayerInfo[playerid][pCarSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`NewsSkill`='%d', ", PlayerInfo[playerid][pNewsSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`DrugsSkill`='%d', ", PlayerInfo[playerid][pDrugsSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`CookSkill`='%d', ", PlayerInfo[playerid][pCookSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`FishSkill`='%d', ", PlayerInfo[playerid][pFishSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`pSHealth`='%.1f', ", PlayerInfo[playerid][pSHealth]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`PhoneNr`='%d', ", PlayerInfo[playerid][pNummer]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`House`='%d', ", PlayerInfo[playerid][pPhousekey]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Hotel`='%d', ", PlayerInfo[playerid][pPhotelkey]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Biz`='%d', ", PlayerInfo[playerid][pBizKey]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`CarLic`='%d', ", PlayerInfo[playerid][pCarLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`FlyLic`='%d', ", PlayerInfo[playerid][pFlyLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`BoatLic`='%d', ", PlayerInfo[playerid][pBoatLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`FishLic`='%d', ", PlayerInfo[playerid][pFishLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`GunLic`='%d', ", PlayerInfo[playerid][pGunLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Zollpass`='%d'", PlayerInfo[playerid][pZollpass]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), " WHERE `Name`='%s'", playername);
strcat(endstring, var, sizeof(endstring));
self_mysql_queryEx(endstring);
format(endstring, sizeof(endstring), "UPDATE `users` SET ");
format(var, sizeof(var), "`Gun1`='%d', ", PlayerInfo[playerid][pGun1]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Gun2`='%d', ", PlayerInfo[playerid][pGun2]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Gun3`='%d', ", PlayerInfo[playerid][pGun3]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Gun4`='%d', ", PlayerInfo[playerid][pGun4]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Ammo1`='%d', ", PlayerInfo[playerid][pAmmo1]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Ammo2`='%d', ", PlayerInfo[playerid][pAmmo2]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Ammo3`='%d', ", PlayerInfo[playerid][pAmmo3]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Ammo4`='%d', ", PlayerInfo[playerid][pAmmo4]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`CarTime`='%d', ", PlayerInfo[playerid][pCarTime]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`PayDay`='%d', ", PlayerInfo[playerid][pPayDay]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`PayDayHad`='%d', ", PlayerInfo[playerid][pPayDayHad]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`CDPlayer`='%d', ", PlayerInfo[playerid][pCDPlayer]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`AlcoholPerk`='%d', ", PlayerInfo[playerid][pAlcoholPerk]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`PainKillerPerk`='%d', ", PlayerInfo[playerid][pPainKillerPerk]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`PistolSkill`='%d', ", PlayerInfo[playerid][pPistolSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`MaschinePistolSkill`='%d', ", PlayerInfo[playerid][pMaschinePistolSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`SturmgewehrPistolSkill`='%d', ", PlayerInfo[playerid][pSturmgewehrPistolSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`ShotGunSkill`='%d', ", PlayerInfo[playerid][pShotGunSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`DrugPerk`='%d', ", PlayerInfo[playerid][pDrugPerk]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`MiserPerk`='%d', ", PlayerInfo[playerid][pMiserPerk]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`TraderPerk`='%d', ", PlayerInfo[playerid][pTraderPerk]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Tutorial`='%d', ", PlayerInfo[playerid][pTut]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Warnings`='%d'", PlayerInfo[playerid][pWarns]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), " WHERE `Name`='%s'", playername);
strcat(endstring, var, sizeof(endstring));
self_mysql_queryEx(endstring);
format(endstring, sizeof(endstring), "UPDATE `users` SET ");
format(var, sizeof(var), "`Fuel`='%d', ", PlayerInfo[playerid][pFuel]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Married`='%d', ", PlayerInfo[playerid][pMarried]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`MarriedTo`='%s', ", PlayerInfo[playerid][pMarriedTo]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`WantedLevel`='%d', ", PlayerInfo[playerid][pWantedLevel]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Spawn`='%d', ", PlayerInfo[playerid][pSpawn]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`SavedMaterials`='%d', ", PlayerInfo[playerid][pSaveMats]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`SavedDrugs`='%d', ", PlayerInfo[playerid][pSaveDrugs]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`SaveCodes`='%d', ", PlayerInfo[playerid][pSaveCodes]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`BikeLic`='%d', ", PlayerInfo[playerid][pBikeLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`LKWLic`='%d', ", PlayerInfo[playerid][pLKWLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`DonatorTime`='%d', ", PlayerInfo[playerid][pDonatorZeit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`WerberName`='%s', ", PlayerInfo[playerid][pWerberName]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`FightingStyle`='%d', ", PlayerInfo[playerid][pFightingStyle]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Handy`='%d'", PlayerInfo[playerid][pHandy]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), " WHERE `Name`='%s'", playername);
strcat(endstring, var, sizeof(endstring));
self_mysql_queryEx(endstring);
format(endstring, sizeof(endstring), "UPDATE `users` SET ");
format(var, sizeof(var), "`OnDutySkin`='%d', ", PlayerInfo[playerid][pOnDutySkin]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`CarLicPoints`='%d', ", PlayerInfo[playerid][pCarLicPoints]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`BikeLicPoints`='%d', ", PlayerInfo[playerid][pBikeLicPoints]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`InviteSperre`='%d', ", PlayerInfo[playerid][pInviteSperre]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`warntime1`='%d', ", PlayerInfo[playerid][pWarnTime1]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`warntime2`='%d', ", PlayerInfo[playerid][pWarnTime2]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Ticketsopen`='%d', ", PlayerInfo[playerid][pTicketsopen]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`DonatorTime`='%d', ", PlayerInfo[playerid][pDonatorZeit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`OldName`='%s', ", PlayerInfo[playerid][pOldName]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`ClientIP`='%s', ", PlayerInfo[playerid][pUserIP]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`OrgMember`='%d', ", PlayerInfo[playerid][pOrgaID]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`OrgLeader`='%d', ", PlayerInfo[playerid][pOrgaLeader]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`OrgManager`='%d', ", PlayerInfo[playerid][pOrgaManager]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`OrgName`='%s'", PlayerInfo[playerid][pOrgaName]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), " WHERE `Name`='%s'", playername);
strcat(endstring, var, sizeof(endstring));
self_mysql_queryEx(endstring);
}
return 1;
}
So, einen Teil hätten wir mal. Und jetzt wäre es sehr hilfreich, wenn du uns den Log deines MySQL Plugins gibst. Wie du an den kommst ist hier beschrieben: Tipps: Scripting-Probleme richtig erklären (Kapitel 1.4).
Die accounts werden nicht auf der mysql gespeichert der name schon aber das geld usw. nicht das ist mein problem
Dann mach doch bitte das was ich dir gesagt habe. Der MySQL Log ist hier sehr wichtig, da man in diesen hunderten Zeilen den Fehler so gut wie nicht finden kann, außer durch Zufall, oder ewiges Suchen.
Also schalte bitte den MySQL Log an und poste was darin steht, wenn du den Spieler speicherst.
er klers mir bitte finde auf den link nix
Ich habe es auf dem Link bereits ausführlich erklärt, in Kapitel 1.4 (4. Bei MySQL-Problemen → Debug Modus nutzen).
Link öffnen => STRG+F => "Debug Modus nutzen" eingeben => Und schon bist du da wo du lesen sollst. Das wirst du doch sicher hinbekommen.
Dort steht es für alle gängigen MySQL Plugins, was du machen sollst.
wie schalte ich den debugmodus ein ?? WOH ?? woh vinde ich den mysql-log. ??
Also wenn es jetzt nicht klar ist weiß ich auch nicht.