kein register

Hey also das register system geht nicht
(es läuft über mysql)
also ein neuer kommt drauf dan kommt stat Register, Login er gibt pw an aber dan kommt die abfrage männlich oder weiblich und dan das tutorial und die sachen werde auch nicht gepseichert

könntest du mal bitte TV gucken schicke dir gleich daten geht glaube ich dan besser.

forward OnPlayerRegister(playerid, password[]);

self_mysql_query(TextString);
mysql_store_result(MySQLConnection);
if(mysql_num_rows(MySQLConnection) != 0)
{
mysql_fetch_row_format(TextString);
new val[256];
self_mysql_get_field("Reason", val); strmid(BanReason, val, 0, strlen(val), 255);
self_mysql_get_field("Hammer", val); strmid(BanHammer, val, 0, strlen(val), 255);
self_mysql_get_field("Time", val); BPZeit = strval( val );
if(BPZeit != -1)
{
if(BPZeit > Time())
{
VAR = 1;
}
else
{
format(TextString, sizeof(TextString), "DELETE FROM `bannedplayers` WHERE `Name`='%s'", playername);
self_mysql_query(TextString);
VAR = 0;
}
}
else
{
VAR = 1;
}
if(VAR == 1)
{
SendClientMessage(playerid, COLOR_LIGHTBLUE, "..::Exklusiv Reallife Baninformation ::..");
SendClientMessage(playerid, COLOR_LIGHTRED, "Dieser Account wurde von einem Admin gebannt, für einen Entbann wende dich bitte an einen Admin !");
if(BPZeit == -1)
{
SendClientMessage(playerid, COLOR_LIGHTRED, "Dauer: unbegrenzt");
}
else
{
new _converts[4], Zeit = BPZeit-Time();
ConvertSecEx( Zeit , _converts[0] , _converts[1] , _converts[2] , _converts[3]);
format(TextString, sizeof(TextString), "Dauer: %d Tage, %d Stunden, %d Minuten und %d Sekunden", _converts[3],_converts[2],_converts[1],_converts[0]);
SendClientMessage(playerid, COLOR_LIGHTRED, TextString);
}
format(TextString, sizeof(TextString), "Grund: %s", BanReason);
SendClientMessage(playerid, COLOR_LIGHTRED, TextString);
format(TextString, sizeof(TextString), "Gebannt von: %s", BanHammer);
SendClientMessage(playerid, COLOR_LIGHTRED, TextString);
SetTimerEx("ConnectKick", 4000,0,"i",playerid);
//Kick(playerid);
return 1;
}
}
mysql_free_result(MySQLConnection);
if(VAR == 0)
{
new TextStringMySQL[128];
format(TextStringMySQL, sizeof(TextStringMySQL), "SELECT * FROM `users` WHERE `Name`='%s'", playername);
self_mysql_query(TextStringMySQL);
mysql_store_result(MySQLConnection);
if(mysql_num_rows(MySQLConnection) != 0)
{
gPlayerAccount[playerid] = 1;
PlayerPlaySound(playerid, 1097, 0.0, 0.0, 0.0);
//SendClientMessage(playerid, COLOR_YELLOW, "Bitte logge dich ein {FF6400}'/login [Passwort]'");
ShowPlayerDialog(playerid, Login, DIALOG_STYLE_PASSWORD, "Login", "Bitte logge dich ein indem du dein Passwort unten eingibst.","Login","Abbruch");
return 1;
}
else
{
if(strfind(playername, "[", true) != -1 || strfind(playername, "]", true) != -1)
{
SendClientMessage(playerid, COLOR_LIGHTRED, "Clan-Tag's sind Nicht erlaubt. Du musst ein Namen Ohne '[' und ']' Nehmen.");
TogglePlayerControllable(playerid, 0);
//Kick(playerid);
SetTimerEx("ConnectKick", 2000,0,"i",playerid);
}
else
{
gPlayerAccount[playerid] = 0;
ShowPlayerDialog(playerid, Register, DIALOG_STYLE_PASSWORD, "Registrieren", "{FFFFFF}Willkommen auf {88AA88}E{FFFFFF}klu {88AA88}s{FFFFFF}iv {88AA88}R{FFFFFF}eallife,\nbitte registriere dich indem du dein gewünschtes Passwort unten eingibst.","Registrieren","Abbruch");
}
return 1;
}
}
return 1;
}

mysql_free_result(MySQLConnection);
if(VAR == 0)
{
new TextStringMySQL[128];
format(TextStringMySQL, sizeof(TextStringMySQL), "SELECT * FROM `users` WHERE `Name`='%s'", playername);
self_mysql_query(TextStringMySQL);
mysql_store_result(MySQLConnection);
if(mysql_num_rows(MySQLConnection) != 0)
{
gPlayerAccount[playerid] = 1;
PlayerPlaySound(playerid, 1097, 0.0, 0.0, 0.0);
//SendClientMessage(playerid, COLOR_YELLOW, "Bitte logge dich ein {FF6400}'/login [Passwort]'");
ShowPlayerDialog(playerid, Login, DIALOG_STYLE_PASSWORD, "Login", "Bitte logge dich ein indem du dein Passwort unten eingibst.","Login","Abbruch");
return 1;
}
else
{
if(strfind(playername, "[", true) != -1 || strfind(playername, "]", true) != -1)
{
SendClientMessage(playerid, COLOR_LIGHTRED, "Clan-Tag's sind Nicht erlaubt. Du musst ein Namen Ohne '[' und ']' Nehmen.");
TogglePlayerControllable(playerid, 0);
//Kick(playerid);
SetTimerEx("ConnectKick", 2000,0,"i",playerid);
}
else
{
gPlayerAccount[playerid] = 0;
ShowPlayerDialog(playerid, Register, DIALOG_STYLE_PASSWORD, "Registrieren", "{FFFFFF}Willkommen auf {88AA88}E{FFFFFF}klu {88AA88}s{FFFFFF}iv {88AA88}R{FFFFFF}eallife,\nbitte registriere dich indem du dein gewünschtes Passwort unten eingibst.","Registrieren","Abbruch");
}
return 1;
}
}
return 1;
}

public OnPlayerLogin(playerid)
{
RemoveBuildings(playerid);
new tmp[256],
string[450],
sendername[MAX_PLAYER_NAME];
new 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("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("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("bankfach1", val); PlayerInfo[playerid][pBankFach1] = strval( val );
self_mysql_get_field("bankfach2", val); PlayerInfo[playerid][pBankFach2] = strval( val );
self_mysql_get_field("bankfach3", val); PlayerInfo[playerid][pBankFach3] = strval( val );
self_mysql_get_field("bankfach4", val); PlayerInfo[playerid][pBankFach4] = strval( val );
self_mysql_get_field("wgs", val); PlayerInfo[playerid][pwgs] = strval( val );
self_mysql_get_field("facherlaubis", val); PlayerInfo[playerid][pfacherlaubis] = 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("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("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();
}

}

else if(dialogid == Register)
{
if(response == 0)
{
SendClientMessage(playerid, COLOR_ERRORTEXT, " Du hast den Vorgang abgebrochen und wurdest automatisch gekickt.");
TogglePlayerControllable(playerid, 0);
Kick(playerid);
}
if(response == 1)
{
if(!strlen(inputtext) || strlen(inputtext) < -1 || strlen(inputtext) > 15 || strlen(inputtext) < 6)
{
ShowPlayerDialog(playerid, Register, DIALOG_STYLE_PASSWORD, "Registrieren", "Dein Passwort muss mindestens 6 und maximal 15 Bustaben haben\nUnd darf nur auch Bustaben von A-Z und Zahlen von 0-9 Bestehen.", "Registrieren", "Abbruch");
return 1;
}
new ForbiddenCharactersExist = 0;
for(new ac = 0; ac < sizeof(ForbiddenCharacters); ac++)
{
if(strfind(inputtext, ForbiddenCharacters[ac], true) != -1)
{
ForbiddenCharactersExist = 1;
break;
}
}
if(strlen(inputtext) > 15 || ForbiddenCharactersExist == 1)
{
ShowPlayerDialog(playerid, Register, DIALOG_STYLE_PASSWORD, "Registrieren", "Dein Passwort muss mindestens 6 und maximal 15 Bustaben haben\nUnd darf nur auch Bustaben von A-Z und Zahlen von 0-9 Bestehen.", "Registrieren", "Abbruch");
return SendClientMessage(playerid, COLOR_ERRORTEXT, " Dein Passwort darf maximal 10 Zeichen haben und darf nur aus A-Z bzw. a-z und 1-9 inkl. 0 bestehen !");
}
new tmppass[64];
strmid(tmppass, inputtext, 0, strlen(inputtext), 255);
//Encrypt(tmppass);
OnPlayerRegister(playerid, tmppass);
//SendClientMessage(playerid, COLOR_YELLOW, "Du hast dich erfolgreich registriert, Bitte logge dich ein '/login [Passwort]'!");
ShowPlayerDialog(playerid, Login, DIALOG_STYLE_PASSWORD, "Login", "Bitte logge dich ein indem du dein Passwort unten eingibst.", "Login", "Abbruch");
}
return 1;
}
else if(dialogid == Login)
{
if(response == 0)
{
SendClientMessage(playerid, COLOR_ERRORTEXT, " Du hast den Vorgang abgebrochen und wurdest automatisch gekickt.");
TogglePlayerControllable(playerid, 0);
Kick(playerid);
}
if(response == 1)
{
if(strlen(inputtext) == 0 || strlen(inputtext) < -1 || strlen(inputtext) > 15) // Wenn kein Passwort angegebene wurde
{
ShowPlayerDialog(playerid, Login, DIALOG_STYLE_PASSWORD, "Login", "Bitte logge dich ein indem du dein Passwort unten eingibst.","Login","Abbruch");
return 1;
}
else
{
new NotJoin = 0;
new StepID = -1;
new sendername[MAX_PLAYER_NAME];
for(new i = 0; i < sizeof(OffPickup); i++)
{
if(OffPickup[i][OffErstellt] == 1)
{
if(OffPickup[i][OffZeit] > 0)
{
GetPlayerName(playerid, sendername, sizeof(sendername));
if(strcmp(sendername,OffPickup[i][OfflineName], true) == 0)
{
NotJoin = 1;
StepID = i;
break;
}
}
}
}
if(CheckPasswort(playerid, inputtext) == 1) // Wir holen uns das Passwort aus der MySQL Datenbank und überprüfen es mit dem angegebenen passwort.
{
if(NotJoin == 1)
{
format(string, sizeof(string), "Du musst warten bis dein Logout Pickup weg ist. {0087FF}(%d Sekunden)", OffPickup[StepID][OffZeit]);
ShowPlayerDialog(playerid, Login, DIALOG_STYLE_PASSWORD, "Login", string,"Login","Abbruch");
return 1;
}
strmid(PlayerInfo[playerid][pKey], inputtext, 0, strlen(inputtext), 255);
OnPlayerLogin(playerid); //Der Spieler wird "geladen", speich es werden seine Daten aus der Datenbank geholt und in variablen gespeichert um diese im Skript zu verwenden.
return 1;
}
else
{
//Wenn das Passwort falsch war, lassen wir erneut das Login fenster erscheinen damit der Spieler das Richtige Passwort eingibt.
ShowPlayerDialog(playerid, Login, DIALOG_STYLE_PASSWORD, "Login", "Das eingegebene Passwort ist Falsch, bitte versuche es erneut.","Login","Abbruch");
return 1;
}
}
}
return 1;
}