Die accounts werden nicht auf der mysql gespeichert der name schon aber das geld usw. nicht das ist mein problem
Beiträge von Killer_NatorTV
-
-
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;
} -
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
-
//---------------------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;
} -
was soll ich suchen habe schon accounts probirt aber xDzu viel verstehe nix muss ich vileich mysql_??
-
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
-
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 ; -
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 ?????