Beiträge von staNleY.

Zitat von _Marvin

=> http://forum.sa-mp.com/showthread.php?t=102865

Website is offline

No cached version of this page is available.

Zitat von Jeffry

Lade dir den aktuellen Streamer und die dazugehörige aktuelle Include herunter.

Wo finde ich die?

Warum bekomm ich errors das ich SetDynamicObjectMaterialText nicht defined habe.. ich verstehe nicht wie ich das definen soll.

Zitat von Markuslobicher

Danke an @staNleY. es hat geklappt

Nix zu danken^^

Zitat von Jeffry

Poste dann bitte mal dein ganzes OnDialogResponse wie es momentan ist, mit den Errors, und markiere die Fehlerzeilen.

Ich habe es nun hinbekommen mit dem Dialog jedoch wenn ich annehmen drücke werde ich nicht zugewiesen.

if(dialogid == DIALOG_INVITE)
{
if(response) // If they clicked 'Yes' or pressed enter
{
SendClientMessage(playerid, COLOR_LIGHTBLUE, "* Du hast die Einladung angenommen.");
}
else // Pressed ESC or clicked cancel
{
SendClientMessage(playerid, COLOR_LIGHTBLUE, "* Du hast die Einladung abgelehnt!");
}
return 1; // We handled a dialog, so return 1. Just like OnPlayerCommandText.
}

//Bleibt stehen.
return 0;
}

Accept invite-system:

else if(strcmp(x_job,"invite",true) == 0)
{
if(InviteOffer[playerid] != -1)
{
if(IsPlayerConnected(InviteOffer[playerid]))
{
new ftext[20];
new Team = InviteTeam[playerid];
if(Team == 1) { ftext = "LV-PD"; }
else if(Team == 2) { ftext = "Drift Access"; }
else if(Team == 3) { ftext = "Feuerwehr"; }
else if(Team == 4) { ftext = "Medic"; }
else if(Team == 5) { ftext = "La Cosa Nostra"; }
else if(Team == 6) { ftext = "Yakuza"; }
else if(Team == 7) { ftext = "FBI"; }
else if(Team == 8) { ftext = "Hitman Agency"; }
else if(Team == 9) { ftext = "News Reporter"; }
else if(Team == 10) { ftext = "Wheelman Agency"; }
else if(Team == 11) { ftext = "Fahrschule"; }
else if(Team == 12) { ftext = "Regierung"; }
else if(Team == 13) { ftext = "Ordnungsamt"; }
else if(Team == 14) { ftext = "LS-PD"; }
else if(Team == 15) { ftext = "Biker Boys"; }
else if(Team == 16) { ftext = "SF-PD"; }
else if(Team == 17) { ftext = "Camorra"; }
else if(Team == 18) { ftext = "V.L.Atztecas"; }
else if(Team == 19) { ftext = "Grove Street"; }
else if(Team == 20) { ftext = "Ballas"; }
else if(Team == 21) { ftext = "West Coast Customs"; }
else if(Team == 22) { ftext = "Triaden"; }
else if(Team == 23) { ftext = "Red Soldiers"; }
else if(Team == 24) { ftext = "L.S.Vagos"; }
else if(Team == 25) { ftext = "Guerilla"; }
else if(Team == 26) { ftext = "Cali Kartell"; }
else { return 1; }
GetPlayerName(InviteOffer[playerid], giveplayer, sizeof(giveplayer));
GetPlayerName(playerid, sendername, sizeof(sendername));
PlayerInfo[playerid][pMember] = Team;
PlayerInfo[playerid][pTeam] = Team;
PlayerInfo[playerid][pRank] = 1;
PlayerInfo[playerid][pJob] = 0;
format(string, sizeof(string), "* %s hat deine Einladung angenommen.", sendername);
SendClientMessage(InviteOffer[playerid], COLOR_LIGHTBLUE, string);
format(string, sizeof(string), "* Du bist nun bei der Fraktion %s Beigetretten, du hast die Einladung von %s angenommen.", ftext, giveplayer);
SendClientMessage(playerid, COLOR_LIGHTBLUE, string);
format(string, sizeof(string), "UPDATE `users` SET `InviteDatum`='%d' WHERE `Name`='%s'", Time(), sendername);
self_mysql_query(string);
Kleidungsshop[playerid] = 1;
JoinSkinAuswahl(playerid);
SendClientMessage(playerid, COLOR_LIGHTRED, "* Wähle einen Skin aus mit den Pfeiltasten. Bestätigen mit Umschalt.");
InviteOffer[playerid] = -1;
InviteTeam[playerid] = -1;
new wielange = (InviteSperreTage*24*60*60);
new Zeit = wielange+Time();
PlayerInfo[playerid][pInviteSperre] += Zeit;
SetPVarInt(playerid, "PVTeam", Team);
return 1;
}
}
else
{
SendClientMessage(playerid, COLOR_ERRORTEXT, " Niemand hat dir einen Invite Angeboten !");
return 1;
}
}

Zitat von FeniX

Probier es mal ohne Port und Doppelpunkt.

Lösch das raus, hat bei mir geklappt^^ hatte auch den fehler

[list=1][*]f(!Connectstring[0] || strcmp(Connectstring,Verbindung,false))
[*]{
[*]printf("SERVER: Der Server ist nicht auf der IP '%s' gebinded!",Verbindung);
[*]print("SERVER: Server wird heruntergefahren Trage unter Verbindung Deine Serverip ein");
[*]SendRconCommand("exit");
[*]return 1;
[/list]

aus script löschen-

Gibt es noch ein DL?

Zitat von Jeffry

In deiner Users-Tabelle fehlen einige Spalten.
Gehe diesen Log mal durch und suche nach "An error has occured", dann findest du die ganzen Spalten (field) die fehlen, füge die jeweils hinzu.

Das Problem, dass du jedes mal das Tutorial neu machen musst liegt daran, dass pReg (Registered) auf 0 in der Datenbank ist, da es nicht gespeichert werden kann, da keine Spalte "Password" in der Tabelle users existiert.

Oke, dies mit Password hab ich jedoch jetzt gefixxt^^

https://paste.ee/p/xXwGW

@Jeffry

Zitat von Jeffry

Das sieht mir nicht nach dem Log vom Login aus, da im Login was von der HardwareID steht, die finde ich im Log zum Beispiel nicht.

Also muss ich mich erst einloggen oder wie?

e/

@Jeffry

Zitat von Jeffry

Ok, was sagt denn der MySQL Log, wenn du dich einloggst (vorher leeren)?

https://paste.ee/p/JuM4h

@Jeffry

Zitat von Jeffry

Zeigst du den Dialog vielleicht noch irgendwo anders dem Spieler an, suche mal im Code danach.
Wenn nicht, dann müssen wir das mal debuggen, poste dann bitte zuerst mal deinen MySQL Log der dir ausgegeben wird, wenn du dich einloggst (vorher leeren).

Oke moment!

[list=1][*]public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
[*]{
[*] new giveplayer[MAX_PLAYER_NAME];
[*] new playername[MAX_PLAYER_NAME];
[*] new string[256],buffer[32];
[*] if(dialogid == 1321) {
[*] if(RegistrationStep[playerid] > 0)
[*] {
[*] if(RegistrationStep[playerid] == 1)
[*] {
[*] new sendername[24];
[*] GetPlayerName(playerid, sendername, sizeof(sendername));
[*] if(strcmp(sendername, inputtext, true) == 0)
[*] {
[*] SendClientMessage(playerid, COLOR_YELLOW2, "Du kannst dich nicht selber als Werber eintragen !");
[*] // ShowPlayerDialog(playerid,1321,DIALOG_STYLE_INPUT,"User Werben User System","Von wem wurdest du geworben? (Wenn dich niemand geworben hat, gib 'Niemand' ein.\nDer Spieler der dich geworben hat kriegt, wenn du 48 Spielstunden hast eine belohnung!)","Bestätigen","");
[*] ShowPlayerDialog(playerid,1321,DIALOG_STYLE_INPUT,"User Werben User System","Von wem wurdest du geworben? Bitte gib den vollständigen Spielernamen ein.\n(Falls von niemanden, gib ""Niemand"" ein)","Weiter","Verlassen");
[*] return 1;
[*] }
[*] format(string, sizeof(string), "SELECT * FROM `users` WHERE `Name`='%s'", inputtext);
[*] self_mysql_queryEx(string);
[*] mysql_store_result(MySQLConnection);
[*] if(mysql_num_rows(MySQLConnection) == 0 && strcmp(inputtext, "Niemand", true) != 0)
[*] {
[*] SendClientMessage(playerid, COLOR_YELLOW2, "Dieser Spieler wurde nicht gefunden.Achte bitte auf die genaue Schreibweise.");
[*] ShowPlayerDialog(playerid,1321,DIALOG_STYLE_INPUT,"User Werben User System","Von wem wurdest du geworben? Bitte gib den vollständigen Spielernamen ein.\n(Falls von niemanden, gib ""Niemand"" ein)","Weiter","Verlassen");
[*] return 1;
[*] }
[*] strmid(PlayerInfo[playerid][pWerberName], inputtext, 0, strlen(inputtext), 255);
[*] format(string, sizeof(string), "Ok du wurdest von %s geworben.", PlayerInfo[playerid][pWerberName]);
[*] SendClientMessage(playerid, COLOR_YELLOW2, string);
[*] ShowPlayerDialog(playerid, Originauswahl, DIALOG_STYLE_LIST, "Herkunft", "Los Santos\nSan Fierro", "Auswählen", "Verlassen");
[*] RegistrationStep[playerid] = 0;
[*] return 1;
[*] }
[*] }
[*] return 1;
[*] }
[/list]

Also ich finde das nur bis hierher.

@Jeffry

Zitat von Jeffry

Du bekommst diese Nachricht hier wieder angezeigt?
SendClientMessage(playerid,COLOR_YELLOW,"Willkommen auf Los Santos Roleplay, bitte fülle die Fragen aus, um fortzufahren.");

Wenn ja, wo setzt du "pTut" auf 1 und wie speicherst du den Spieler?

Ich muss immer wenn ich Relogge, von wem ich geworben wurde ein geben.. nur dies ist er speichert es ab den ich geworben habe fragt dies aber nicht ab.

e/

In der datenbank zeigt er unter mein namen Tutorial= 1 an also muss ich da tut ja fertig haben.

e2/

if(PlayerInfo[playerid][pTut] == 1)
{
SpawnPlayer(playerid);
}
if(PlayerInfo[playerid][pTut] == 0 && PlayerInfo[playerid][pConnectTime] == 0)
{
gOoc[playerid] = 1; gNews[playerid] = 1; gFam[playerid] = 1;
TogglePlayerControllable(playerid, 0);
RegistrationStep[playerid] = 1;
PlayerInfo[playerid][pLocal] = -1;
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid,COLOR_YELLOW,"Willkommen auf Los Santos Roleplay, bitte fülle die Fragen aus, um fortzufahren.");
//ShowPlayerDialog(playerid, Geschlechtauswahl, DIALOG_STYLE_LIST, "Geschlecht", "Männlich\nWeiblich", "Auswählen", "Verlassen");
ShowPlayerDialog(playerid,1321,DIALOG_STYLE_INPUT,"User Werben User System","Von wem wurdest du geworben? Bitte gib den vollständigen Spielernamen ein.\n(Falls von niemanden, gib ""Niemand"" ein)","Weiter","Verlassen");
SetPlayerPos(playerid,440.8212,-20.1240,1001.1328);
SetPlayerInterior(playerid,1);
SetPlayerCameraPos(playerid,440.7491,-16.6782,1000.9297+1);
SetPlayerCameraLookAt(playerid,440.8212,-20.1240,1001.1328);
SetPlayerSkin(playerid,101);
StopAudioStreamForPlayer(playerid);
SetPlayerScore(playerid, PlayerInfo[playerid][pLevel]);
return 1;
}
return 1;
}

Dort steht ja, [pTut] == 1)

SpawnPlayer...
Ich verstehe nicht wieso es nicht geht.

Hey, Ich bin in der Tabelle user eingetragen, ich relogge muss tutorial wieder machen... alles saved sich aber muss Tut wieder neu machen..

OnPlayerLogin:

public OnPlayerLogin(playerid)
{
RemoveBuildings(playerid);
new tmp[256],
string[450],
sendername[MAX_PLAYER_NAME],
Beschwerden = 0;
//new LoginChecker;
getdate(Jahr, Monat, Tag);
gettime(Stunde, Minute, Sekunde);
GetPlayerName(playerid, sendername, sizeof(sendername)); //Wir Speichern den Namen des Spielers in der Variable [i]SpielerInfo[playerid][pName][/i]
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))//Wir fragen ab ob der angegebene Spieler auch Online ist, und kein NPC ist (nur zur sicherhheit)
{
format(string, sizeof(string),"SELECT * FROM `users` WHERE `Name` = '%s'", sendername);
mysql_query(string);//wir holen uns alles aus der tabelle "tabelle_mit_den_haeusern"
mysql_store_result();//speichern dann das ergebniss
new val[ 256 ];
while(mysql_fetch_row_format(string,"|"))
{
self_mysql_get_field("Level", val); PlayerInfo[playerid][pLevel] = strval( val );
self_mysql_get_field("AdminLevel", val); PlayerInfo[playerid][pAdmin] = strval( val );
self_mysql_get_field("Tutorial", val); PlayerInfo[playerid][pTut] = strval( val );
self_mysql_get_field("Rolex", val); PlayerInfo[playerid][pRolex] = strval( val );
self_mysql_get_field("Swissonic", val); PlayerInfo[playerid][pSwissonic] = strval( val );
self_mysql_get_field("Casio", val); PlayerInfo[playerid][pCasio] = strval( val );
self_mysql_get_field("Breitling", val); PlayerInfo[playerid][pBreitling] = strval( val );
self_mysql_get_field("Nixon", val); PlayerInfo[playerid][pNixon] = strval( val );
self_mysql_get_field("IceWatch", val); PlayerInfo[playerid][pIceWatch] = strval( val );
self_mysql_get_field("StartCoints", val); PlayerInfo[playerid][pStartCoints] = strval( val );
self_mysql_get_field("Coints", val); PlayerInfo[playerid][pCoints] = strval( val );
self_mysql_get_field("Spawnheal", val); PlayerInfo[playerid][pSpawnheal] = strval( val );
self_mysql_get_field("Deaglespawn", val); PlayerInfo[playerid][pDeaglespawn] = strval( val );
self_mysql_get_field("M4Spawn", val); PlayerInfo[playerid][pM4Spawn] = strval( val );
self_mysql_get_field("MP5Spawn", val); PlayerInfo[playerid][pMP5Spawn] = strval( val );
self_mysql_get_field("MehrZinsen", val); PlayerInfo[playerid][pMehrZinsen] = strval( val );
self_mysql_get_field("SpawnhealZeit", val); PlayerInfo[playerid][pSpawnhealZeit] = strval( val );
self_mysql_get_field("DeaglespawnZeit", val); PlayerInfo[playerid][pDeaglespawnZeit] = strval( val );
self_mysql_get_field("M4SpawnZeit", val); PlayerInfo[playerid][pM4SpawnZeit] = strval( val );
self_mysql_get_field("MP5SpawnZeit", val); PlayerInfo[playerid][pMP5SpawnZeit] = strval( val );
self_mysql_get_field("MehrZinsenZeit", val); PlayerInfo[playerid][pMehrZinsenZeit] = strval( val );
self_mysql_get_field("Medickit", val); PlayerInfo[playerid][pMedickit] = strval( val );
self_mysql_get_field("Startbonus", val); PlayerInfo[playerid][pStartbonus] = strval ( val );
self_mysql_get_field("Kreditkarte", val); PlayerInfo[playerid][pKreditkarte] = strval( val );
self_mysql_get_field("KreditkarteBenutzung", val); PlayerInfo[playerid][pKreditkartebenutzen] = strval( val );
self_mysql_get_field("Personalausweis",val); PlayerInfo[playerid][pPersonalausweis] = strval ( val );
self_mysql_get_field("Namechange", val); PlayerInfo[playerid][pSchongeandert] = strval( val );
self_mysql_get_field("krankenkasse", val); PlayerInfo[playerid][pKrankenkasse] = strval( val );
self_mysql_get_field("krankenzeit", val); PlayerInfo[playerid][pKrankenkasseTime] = strval( val );
self_mysql_get_field("DonateRank", val); PlayerInfo[playerid][pDonatorRank] = strval( val );
self_mysql_get_field("UpgradePoints", val); PlayerInfo[playerid][gPupgrade] = strval( val );
self_mysql_get_field("ConnectedTime", val); PlayerInfo[playerid][pConnectTime] = strval( val );
self_mysql_get_field("Registered", val); PlayerInfo[playerid][pReg] = strval( val );
self_mysql_get_field("Sex", val); PlayerInfo[playerid][pSex] = strval( val );
self_mysql_get_field("Age", val); PlayerInfo[playerid][pAlter] = strval( val );
self_mysql_get_field("Origin", val); PlayerInfo[playerid][pOrigin] = strval( val );
self_mysql_get_field("Muted", val); PlayerInfo[playerid][pMuted] = strval( val );
self_mysql_get_field("Respect", val); PlayerInfo[playerid][pRespekt] = strval( val );
self_mysql_get_field("Gehalt",val); PlayerInfo[playerid][pGehalt] = strval( val );
self_mysql_get_field("Money", val); PlayerInfo[playerid][pCash] = strval( val );
self_mysql_get_field("Bank", val); PlayerInfo[playerid][pBank] = strval( val );
self_mysql_get_field("Allowed", val); PlayerInfo[playerid][pAllowed] = strval( val );
self_mysql_get_field("Crimes", val); PlayerInfo[playerid][pCrimes] = strval( val );
self_mysql_get_field("Kills", val); PlayerInfo[playerid][pKills] = strval( val );
self_mysql_get_field("sKills", val); PlayerInfo[playerid][psKills] = strval( val );
self_mysql_get_field("Deaths", val); PlayerInfo[playerid][pDeaths] = strval( val );
self_mysql_get_field("Arrested", val); PlayerInfo[playerid][pArrested] = strval( val );
self_mysql_get_field("ArrestTime", val); PlayerInfo[playerid][pArrestTime] = strval( val );
self_mysql_get_field("PhoneBook", val); PlayerInfo[playerid][pPhoneBook] = strval( val );
self_mysql_get_field("LottoNr", val); PlayerInfo[playerid][pLottoNr] = strval( val );
self_mysql_get_field("Fishes", val); PlayerInfo[playerid][pFishes] = strval( val );
self_mysql_get_field("BiggestFish", val); PlayerInfo[playerid][pBiggestFish] = strval( val );
self_mysql_get_field("Job", val); PlayerInfo[playerid][pJob] = strval( val );
self_mysql_get_field("Paycheck", val); PlayerInfo[playerid][pPayCheck] = strval( val );
self_mysql_get_field("HeadValue", val); PlayerInfo[playerid][pHeadValue] = strval( val );
self_mysql_get_field("Jailed", val); PlayerInfo[playerid][pJailed] = strval( val );
self_mysql_get_field("JailTime", val); PlayerInfo[playerid][pJailTime] = strval( val );
self_mysql_get_field("Leader", val); PlayerInfo[playerid][pLeader] = strval( val );
self_mysql_get_field("Member", val); PlayerInfo[playerid][pMember] = strval( val );
self_mysql_get_field("Rank", val); PlayerInfo[playerid][pRank] = strval( val );
self_mysql_get_field("Skin", val); PlayerInfo[playerid][pChar] = strval( val );
self_mysql_get_field("Vertragszeit", val); PlayerInfo[playerid][pVertragszeit] = strval( val );
self_mysql_get_field("DetSkill", val); PlayerInfo[playerid][pDetSkill] = strval( val );
self_mysql_get_field("SexSkill", val); PlayerInfo[playerid][pSexSkill] = strval( val );
self_mysql_get_field("LawSkill", val); PlayerInfo[playerid][pAnwaltSkill] = strval( val );
self_mysql_get_field("MechSkill", val); PlayerInfo[playerid][pMechSkill] = strval( val );
self_mysql_get_field("JackSkill", val); PlayerInfo[playerid][pJackSkill] = strval( val );
self_mysql_get_field("CarSkill", val); PlayerInfo[playerid][pCarSkill] = strval( val );
self_mysql_get_field("NewsSkill", val); PlayerInfo[playerid][pNewsSkill] = strval( val );
self_mysql_get_field("DrugsSkill", val); PlayerInfo[playerid][pDrugsSkill] = strval( val );
self_mysql_get_field("CookSkill", val); PlayerInfo[playerid][pCookSkill] = strval( val );
self_mysql_get_field("FishSkill", val); PlayerInfo[playerid][pFishSkill] = strval( val );
self_mysql_get_field("pSHealth", val); PlayerInfo[playerid][pSHealth] = floatstr( val );
self_mysql_get_field("PhoneNr", val); PlayerInfo[playerid][pNummer] = strval( val );
self_mysql_get_field("House", val); PlayerInfo[playerid][pPhousekey] = strval( val );
self_mysql_get_field("Hotel",val); PlayerInfo[playerid][pPhotelkey] = strval( val );
self_mysql_get_field("Biz", val); PlayerInfo[playerid][pBizKey] = strval( val );
self_mysql_get_field("CarLic", val); PlayerInfo[playerid][pCarLic] = strval( val );
self_mysql_get_field("FlyLic", val); PlayerInfo[playerid][pFlyLic] = strval( val );
self_mysql_get_field("BoatLic", val); PlayerInfo[playerid][pBoatLic] = strval( val );
self_mysql_get_field("FishLic", val); PlayerInfo[playerid][pFishLic] = strval( val );
self_mysql_get_field("GunLic", val); PlayerInfo[playerid][pGunLic] = strval( val );
self_mysql_get_field("Zollpass", val); PlayerInfo[playerid][pZollpass] = strval( val );
self_mysql_get_field("Gun1", val); PlayerInfo[playerid][pGun1] = strval( val );
self_mysql_get_field("Gun2", val); PlayerInfo[playerid][pGun2] = strval( val );
self_mysql_get_field("Gun3", val); PlayerInfo[playerid][pGun3] = strval( val );
self_mysql_get_field("Gun4", val); PlayerInfo[playerid][pGun4] = strval( val );
self_mysql_get_field("Ammo1", val); PlayerInfo[playerid][pAmmo1] = strval( val );
self_mysql_get_field("Ammo2", val); PlayerInfo[playerid][pAmmo2] = strval( val );
self_mysql_get_field("Ammo3", val); PlayerInfo[playerid][pAmmo3] = strval( val );
self_mysql_get_field("Ammo4", val); PlayerInfo[playerid][pAmmo4] = strval( val );
self_mysql_get_field("CarTime", val); PlayerInfo[playerid][pCarTime] = strval( val );
self_mysql_get_field("PayDay", val); PlayerInfo[playerid][pPayDay] = strval( val );
self_mysql_get_field("PayDayHad", val); PlayerInfo[playerid][pPayDayHad] = strval( val );
self_mysql_get_field("CDPlayer", val); PlayerInfo[playerid][pCDPlayer] = strval( val );
self_mysql_get_field("AlcoholPerk", val); PlayerInfo[playerid][pAlcoholPerk] = strval( val );
self_mysql_get_field("DrugPerk", val); PlayerInfo[playerid][pDrugPerk] = strval( val );
self_mysql_get_field("MiserPerk", val); PlayerInfo[playerid][pMiserPerk] = strval( val );
self_mysql_get_field("TraderPerk", val); PlayerInfo[playerid][pTraderPerk] = strval( val );
self_mysql_get_field("PainKillerPerk", val); PlayerInfo[playerid][pPainKillerPerk] = strval( val );
self_mysql_get_field("Tutorial", val); PlayerInfo[playerid][pTut] = strval( val );
self_mysql_get_field("Warnings", val); PlayerInfo[playerid][pWarns] = strval( val );
self_mysql_get_field("Fuel", val); PlayerInfo[playerid][pFuel] = strval( val );
self_mysql_get_field("Married", val); PlayerInfo[playerid][pMarried] = strval( val );
self_mysql_get_field("MarriedTo", val); strmid(PlayerInfo[playerid][pMarriedTo], val, 0, strlen(val), 255);
self_mysql_get_field("WantedLevel", val); PlayerInfo[playerid][pWantedLevel] = strval( val );
self_mysql_get_field("Spawn", val); PlayerInfo[playerid][pSpawn] = strval( val );
self_mysql_get_field("SavedMaterials", val); PlayerInfo[playerid][pSaveMats] = strval( val );
self_mysql_get_field("SavedDrugs", val); PlayerInfo[playerid][pSaveDrugs] = strval( val );
self_mysql_get_field("SaveCodes", val); PlayerInfo[playerid][pSaveCodes] = strval( val );
self_mysql_get_field("BikeLic", val); PlayerInfo[playerid][pBikeLic] = strval( val );
self_mysql_get_field("LKWLic", val); PlayerInfo[playerid][pLKWLic] = strval( val );
self_mysql_get_field("DonatorTime", val); PlayerInfo[playerid][pDonatorZeit] = strval( val );
self_mysql_get_field("WerberName", val); strmid(PlayerInfo[playerid][pWerberName], val, 0, strlen(val), 255);
self_mysql_get_field("FightingStyle", val); PlayerInfo[playerid][pFightingStyle] = strval( val );
self_mysql_get_field("Handy", val); PlayerInfo[playerid][pHandy] = strval( val );
self_mysql_get_field("OnDutySkin", val); PlayerInfo[playerid][pOnDutySkin] = strval( val );
self_mysql_get_field("CarLicPoints", val); PlayerInfo[playerid][pCarLicPoints] = strval( val );
self_mysql_get_field("BikeLicPoints", val); PlayerInfo[playerid][pBikeLicPoints] = strval( val );
self_mysql_get_field("InviteSperre", val); PlayerInfo[playerid][pInviteSperre] = strval( val );
self_mysql_get_field("warntime1", val); PlayerInfo[playerid][pWarnTime1] = strval( val );
self_mysql_get_field("warntime2", val); PlayerInfo[playerid][pWarnTime2] = strval( val );
self_mysql_get_field("Ticketsopen", val); PlayerInfo[playerid][pTicketsopen] = strval( val );
self_mysql_get_field("OldName", val); strmid(PlayerInfo[playerid][pOldName], val, 0, strlen(val), 255);
self_mysql_get_field("OrgMember", val); PlayerInfo[playerid][pOrgaID] = strval( val );
self_mysql_get_field("OrgLeader", val); PlayerInfo[playerid][pOrgaLeader] = strval( val );
self_mysql_get_field("OrgManager", val); PlayerInfo[playerid][pOrgaManager] = strval ( val );
self_mysql_get_field("OrgName", val); strmid(PlayerInfo[playerid][pOrgaName], val, 0, strlen(val), 255);
self_mysql_get_field("SQLid", val); PlayerInfo[playerid][pSQLID] = strval( val );
self_mysql_get_field("OPBeschwerden", val); Beschwerden = strval( val );
mysql_free_result();
}

}
if(PlayerInfo[playerid][pAdmin] >= 2002)
{
SendClientMessage(playerid,COLOR_RED,"Du hast dich über Adminlevel 2001 eingelogt und wurdest aus sicherheitsgründen gekickt!");
SetTimerEx("ConnectKick", 2000,0,"i",playerid);
return 1;
}
new DeleteDate, Days;
DeleteDate = Days+Time();
format(string, sizeof(string), "UPDATE `users` SET `DeleteDatum`='%d', `LastLoginDatum`='%d' WHERE `Name`='%s'", DeleteDate, gettime(), sendername);
self_mysql_queryEx(string);
ResetPlayerWeapon(playerid);
if(PlayerInfo[playerid][pDonatorRank] == 2)
{
MaxVeh[playerid] = 3;
if(PlayerInfo[playerid][pDonatorZeit] < 10)
{
PlayerInfo[playerid][pDonatorRank] = 1;
}
}
else if(PlayerInfo[playerid][pDonatorRank] == 1)
{
MaxVeh[playerid] = 2;
}
else
{
MaxVeh[playerid] = 1;
}
ResetPlayerMoney(playerid);
GivePlayerMoney(playerid,PlayerInfo[playerid][pCash]);
if(PlayerInfo[playerid][pMarried] == 0)
{
ClearMarriage(playerid);
}
if(PlayerInfo[playerid][pOrigin] == 0) { PlayerInfo[playerid][pOrigin] = 1; }
if(PlayerInfo[playerid][pReg] == 0)
{
new Skin1 = random(11);
if(Skin1 == 1)
{
PlayerInfo[playerid][pChar] = 78;
}
if(Skin1 == 2)
{
PlayerInfo[playerid][pChar] = 79;
}
if(Skin1 == 3)
{
PlayerInfo[playerid][pChar] = 77;
}
if(Skin1 == 4)
{
PlayerInfo[playerid][pChar] = 134;
}
if(Skin1 == 5)
{
PlayerInfo[playerid][pChar] = 135;
}
if(Skin1 == 6)
{
PlayerInfo[playerid][pChar] = 159;
}
if(Skin1 == 7)
{
PlayerInfo[playerid][pChar] = 162;
}
if(Skin1 == 8)
{
PlayerInfo[playerid][pChar] = 168;
}
if(Skin1 == 9)
{
PlayerInfo[playerid][pChar] = 200;
}
if(Skin1 == 10)
{
PlayerInfo[playerid][pChar] = 212;
}
if(Skin1 == 11)
{
PlayerInfo[playerid][pChar] = 213;
}
PlayerInfo[playerid][pReg] = 1;
PlayerInfo[playerid][pAlter] = 0;
PlayerInfo[playerid][pTut] = 0;
PlayerInfo[playerid][pLevel] = 1;
PlayerInfo[playerid][pSHealth] = 50.0;
StuffInfo[sLastNumber] += 1;
PlayerInfo[playerid][pNummer] = StuffInfo[sLastNumber];
PlayerInfo[playerid][pPhousekey] = -1;
PlayerInfo[playerid][pBizKey] = -1;
PlayerInfo[playerid][pBank] = 0;
GivePlayerMoneys(playerid, 4000);
PlayerInfo[playerid][pCrimes] = 0;
PlayerInfo[playerid][pArrested] = 0;
PlayerInfo[playerid][pArrestTime] = 0;
PlayerInfo[playerid][pKills] = 0;
PlayerInfo[playerid][psKills] = 0;
PlayerInfo[playerid][pDeaths] = 0;
PlayerInfo[playerid][pMember] = -1;
PlayerInfo[playerid][pLeader] = -1;
PlayerInfo[playerid][pOnDutySkin] = 60;
/*Scheine*/
PlayerInfo[playerid][pGunLic] = 0;
PlayerInfo[playerid][pFlyLic] = 0;
PlayerInfo[playerid][pCarLic] = 0;
PlayerInfo[playerid][pBikeLic] = 0;
/*Scheine Ende*/
PlayerUpdate(playerid);
}
if(PlayerInfo[playerid][pLeader] != -1)
{
PlayerInfo[playerid][pTeam] = PlayerInfo[playerid][pLeader];
}
else if(PlayerInfo[playerid][pMember] != -1)
{
PlayerInfo[playerid][pTeam] = PlayerInfo[playerid][pMember];
}
SendClientMessage(playerid, COLOR_GREY," ");
SendClientMessage(playerid, COLOR_GREY," ");
SendClientMessage(playerid, COLOR_GREY," ");
SendClientMessage(playerid, COLOR_GREY," ");
SendClientMessage(playerid, COLOR_GREY," ");
SendClientMessage(playerid, COLOR_GREY," ");
SendClientMessage(playerid, COLOR_GREY," ");
SendClientMessage(playerid, COLOR_GREY," ");
SendClientMessage(playerid, COLOR_GREY," ");
SendClientMessage(playerid, COLOR_GREY," ");
SendClientMessage(playerid, COLOR_GREY," ");
format(string, sizeof(string), "SERVER: Willkommen %s",sendername);
SendClientMessage(playerid, COLOR_WHITE, string);
new playername[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername, sizeof(playername));
format(string, sizeof(string), "UPDATE `users` SET `Status`='1' WHERE `Name`='%s'", sendername);
self_mysql_queryEx(string);
format(string, sizeof(string), "UPDATE `users` SET `Legende`='1' WHERE SQLid = '%d'", PlayerInfo[playerid][pSQLID]);
self_mysql_queryEx(string);
new hwd[256];
gpci(playerid, hwd, sizeof hwd);
format(string, sizeof(string), "UPDATE `users` SET `HardwareID`='%s' WHERE `Name`='%s'", hwd,sendername);
self_mysql_queryEx(string);
SpawnPlayer(playerid);
SetPlayerScore(playerid, PlayerInfo[playerid][pLevel]);
PlayerCarConnect(playerid);
if(PlayerInfo[playerid][pTut] == 1)
{
for(new i=0; i<MAX_PLAYER_ATTACHED_OBJECTS; i++)
{
RemovePlayerAttachedObject(playerid, i);
}
}
TogglePlayerSpectating(playerid,false);
TextDrawHideForPlayer(playerid,LoginTextdraw);
TextDrawHideForPlayer(playerid,A);
TextDrawHideForPlayer(playerid,B);
TextDrawHideForPlayer(playerid,C);
KillTimer(LoginTimer[playerid]);
LoginTimer[playerid] = -1;
SetPlayerScore(playerid, PlayerInfo[playerid][pLevel]);
strmid(PlayerInfo[playerid][pForceName], "Niemand", 0, strlen("Niemand"), 255);
CheckTime(playerid);
PlayerPlaySound(playerid, 1098, 0.0, 0.0, 0.0);
SetPVarInt(playerid, "PVTeam", PlayerInfo[playerid][pTeam]);
SetPVarInt(playerid, "PVAdmin", PlayerInfo[playerid][pAdmin]);
SetPVarInt(playerid, "PVJob", PlayerInfo[playerid][pJob]);
LoadUberweisungen(playerid);
printf("%s hat sich eingeloggt. [ID: %d]",sendername,playerid);
format(string,sizeof(string),"AdmCmd: Spieler %s hat sich mit der IP: %s eingeloggt!",sendername,PlayerInfo[playerid][pUserIP]);
EnterToLog("Login",string);
if(PlayerInfo[playerid][pDonatorRank] == 1)
{
SendClientMessage(playerid, COLOR_WHITE,"SERVER: Du hast einen Premiumaccount. Vielen Dank, dass du unseren Server unterstützt.");
}
if(PlayerInfo[playerid][pDonatorRank] == 2)
{
SendClientMessage(playerid, COLOR_WHITE,"SERVER: Du hast einen Spendenaccount(Donator). Vielen Dank, dass du unseren Server unterstützt.");
format(string, sizeof(string), "UPDATE `users` SET `Legende`='2' WHERE SQLid = '%d'", PlayerInfo[playerid][pSQLID]);
self_mysql_queryEx(string);
}
if(PlayerInfo[playerid][pAdmin] >= 1)
{
format(string, sizeof(string), "SERVER: Du hast dich als Adminlevel %d eingeloggt.", PlayerInfo[playerid][pAdmin]);
SendClientMessage(playerid, COLOR_WHITE, string);
if(PlayerInfo[playerid][pAdmin] <= 9)
{
TextDrawShowForPlayer(playerid,TicketsTextdraw);
}
new Legende;
if(PlayerInfo[playerid][pAdmin] == -1)
{
Legende = 3;
}
if(PlayerInfo[playerid][pAdmin] >= 1 && PlayerInfo[playerid][pAdmin] <= 2)
{
Legende = 4;
}
if(PlayerInfo[playerid][pAdmin] >= 3 && PlayerInfo[playerid][pAdmin] <= 4)
{
Legende = 5;
}
if(PlayerInfo[playerid][pAdmin] >= 5 && PlayerInfo[playerid][pAdmin] <= 8)
{
Legende = 6;
}
if(PlayerInfo[playerid][pAdmin] >= 1338)
{
Legende = 7;
}
format(string, sizeof(string), "UPDATE `users` SET `Legende`='%d' WHERE `SQLid`='%d'", Legende, PlayerInfo[playerid][pSQLID]);
self_mysql_queryEx(string);
}
/*if(!NameValidator(playerid)){
SendClientMessage(playerid,COLOR_WHITE,"{A80000}SERVER{FFFFFF}: Wenn du möchtest kannst du deinen namen in ein Roleplaynamen ändern mit /Changename. Achtung dies geht nur einmal.");
}*/
format(string, sizeof(string), " %s [ID: %d] hat den Server betreten.",sendername, playerid);
ForAllPlayers(i){
if(IsPlayerConnected(i)){
if(TogLoginLogout[i] == 0){
SendClientMessage(i, COLOR_LIGHTGREEN, string); //Connect message
}}}
if(PlayerInfo[playerid][pChar] != -1)
{
new UseSkin = PlayerInfo[playerid][pChar];
SetSpawnInfo(playerid, 0, UseSkin,0.0,0.0,0.0,0,0,0,0,0,0,0);
}
TextDrawHideForPlayer(playerid, Text:NODMZoneTextdraw);
MedicBill[playerid] = 0;
FirstSpawnAfterLogin[playerid] = 1;
DateProp(playerid);
format(tmp, sizeof(tmp), "~w~Willkommen ~n~~y~%s", sendername);
GameTextForPlayer(playerid, tmp, 5000, 1);
Logintime[playerid] = 1;
gPlayerLogged[playerid] = 1;
StuffInfo[sLoggins] += 1;
start_screen{playerid} = false;
SetCameraBehindPlayer(playerid);
if(AdminIPClose == 0 || TogAdminMessage[playerid] == 0)
{
format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: %s eingeloggt!",sendername,PlayerInfo[playerid][pUserIP]);
SendAdminMessage(COLOR_LIGHTRED, 1, string);
}
if(PlayerInfo[playerid][pStartbonus] == 0)
{
SendClientMessage(playerid,COLOR_YELLOW,"Du hast deinen Startbonus noch nicht abgeholt. Du kannst ihn per /startbonus abholen.");
}
if(Beschwerden >= 1) {
format(string, sizeof(string), "Du hast %d ungelesene(n) Beschwerde(n) im Control Pannel.", Beschwerden);
SendClientMessage(playerid, COLOR_YELLOW, string);
}
if(PlayerInfo[playerid][pStartCoints] == 0)
{
SendClientMessage(playerid,COLOR_YELLOW,"Du hast dein einmaliges Start-Coint Paket erhalten, dir wurden (20) Coins auf deinem Account gutgeschrieben.");
SendClientMessage(playerid,COLOR_YELLOW,"Weitere Informationen über unser Coint-System findest du unter www.Sa-Mp.cc");
PlayerInfo[playerid][pStartCoints] = 1;
PlayerInfo[playerid][pCoints] += 20;
}
if(PlayerInfo[playerid][pWarns] > 0){
format(string, sizeof(string), "Achtung: Du hast schon %d von 3 Verwarnungen. Bei 3 Verwarnungen wirst du gebannt.", PlayerInfo[playerid][pWarns]);
SendClientMessage(playerid, COLOR_RED, string);
}
if(PlayerInfo[playerid][pTut] == 1)
{
SpawnPlayer(playerid);
}
if(PlayerInfo[playerid][pTut] == 0 && PlayerInfo[playerid][pConnectTime] == 0)
{
gOoc[playerid] = 1; gNews[playerid] = 1; gFam[playerid] = 1;
TogglePlayerControllable(playerid, 0);
RegistrationStep[playerid] = 1;
PlayerInfo[playerid][pLocal] = -1;
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid, COLOR_YELLOW, " ");
SendClientMessage(playerid,COLOR_YELLOW,"Willkommen auf Los Santos Roleplay, bitte fülle die Fragen aus, um fortzufahren.");
//ShowPlayerDialog(playerid, Geschlechtauswahl, DIALOG_STYLE_LIST, "Geschlecht", "Männlich\nWeiblich", "Auswählen", "Verlassen");
ShowPlayerDialog(playerid,1321,DIALOG_STYLE_INPUT,"User Werben User System","Von wem wurdest du geworben? Bitte gib den vollständigen Spielernamen ein.\n(Falls von niemanden, gib ""Niemand"" ein)","Weiter","Verlassen");
SetPlayerPos(playerid,440.8212,-20.1240,1001.1328);
SetPlayerInterior(playerid,1);
SetPlayerCameraPos(playerid,440.7491,-16.6782,1000.9297+1);
SetPlayerCameraLookAt(playerid,440.8212,-20.1240,1001.1328);
SetPlayerSkin(playerid,101);
StopAudioStreamForPlayer(playerid);
SetPlayerScore(playerid, PlayerInfo[playerid][pLevel]);
return 1;
}
return 1;
}

Bitte um hilfe..

@Jeffry

Brauche immernoch hilfe.

Zitat von SAMPScripter

Schau dir mal Tutorials zu einem MYSQL Login Register an und mach das nach.
Wirst du hinkriegen

Es speichert sich nix ab in der DB das ist es was ich meine -,-

Zitat von SAMPScripter

Nein liegt nicht an der Datenbank, sonder am Login Register System
Ich habe mir damals das Login Register System komplett neu gemacht.
Würde dir ya meins senden, aber dann hast du unser aktuelles ausgereiftes Script.. Sorry

schade wäre nähmlich hilfreich ...

Zitat von Slayer

Ich möchte mir nichts runterladen, schick uns hier einfach ein Auszug in schriftform.

Dann dauert ladet mein browser lange, liegt aufjeden fall an der datenbank vermute ich stark..

https://paste.ee/p/uAOXb @Slayer

Zitat von Slayer

Ja und dann die Mysql Log schicken.

http://www.file-upload.net/dow…203654/mysql_log.txt.html

@SAMPScripter

Ich habe einfach keine ahnung von Mysql..

Zitat von Slayer

Steht die Datenbank verbinung ?
Mach mal Mysql Debug an und sag und was für "Errors" dort kommen.

Die DB ist in verbindung vermute ich mal, Wie mach ich das an?

e/
Ist aktiviert muss ich jetzt starten?