Beiträge von ShadowSura

Closed habe einen Ts3 bekommen mit 1250 slots wieso man auch soviel hat ka jedenfalls danke an die leute die mir geholfen haben

nicht wirklich

Hallo ich suche einen Teamspeak3 server mit 5 slots wäre nett wenn ich es kostenlos sponsord bekomme möchten halt nur mit freunden drauf
#

edit/ falls falscher bereich bitte verschieben nicht verwarnen dankeee<3

och man das weiß ich ja nicht -.-"

Ja also
Schritt
1.Wenn ich account erstelle
2.Danach wenn ich server neustarte
3.Wird das passwort einfach so geändert
4.Das passwort wird zur NULL in mysql
5.Wenn ich in game ein loggen will steht da falsches passwort wo ich mein account erstellt habe danach hab ich es mit NULL versucht dann hat es geklappt aber wenn jetzt jeder user sowas macht hat ja jeder das passwort NULL aber das will ich ja ebend nicht ich will das es zb shadow123 wird und nicht so ein gehashdes oder NULL

stock CreateAccount(playerid, pass[])
{
new Name[MAX_PLAYER_NAME];
GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
mysql_real_escape_string(Name,Name);
mysql_real_escape_string(pass,pass);
format(query, sizeof(query), "INSERT INTO accounts (Name, Passwort) VALUES ('%s', '%s')", Name, pass);
mysql_query(query);
//mysql_query(query,-1,0,connection); mysql_query(query,-1,0,connection1);
//print("account in der funktion erstellt");
return true;
}

stock mysql_CheckAccount(playerid)
{
new Name[MAX_PLAYER_NAME];
GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
mysql_real_escape_string(Name, Name);
format(query, sizeof(query), "SELECT * FROM accounts WHERE Name = '%s' ORDER BY `id` DESC LIMIT 1", Name);
mysql_query(query);
//mysql_query(query,-1,0,connection); mysql_query(query,-1,0,connection1);
mysql_store_result();
return mysql_num_rows();
}

stock mysql_ReturnPasswort(Name[])
{
new Get[130];
mysql_real_escape_string(Name, Name);
format(query, 128, "SELECT Passwort FROM accounts WHERE Name = '%s'", Name);
//mysql_query(query,-1,0,connection); mysql_query(query,-1,0,connection1);
mysql_query(query);
mysql_store_result();
mysql_fetch_row(Get,"|");
mysql_free_result();
return Get;
}

ocmd:changepass(playerid, params[])
{
if(PlayerInfo[playerid][pAdjustable] == 1)
{
ShowPlayerDialog(playerid, DIALOG_CHANGEPASS, DIALOG_STYLE_PASSWORD, "Passwort ändern","Hier kannst du dein Passwort ändern.\n\n{FF8C00}Tipps für ein sicheres Passwort:\n1. Länger als 8 Zeichen lang sollte es ein!\n2. Es sollte groß und kleinbuchstaben enthalten!\n3. Es sollte Sonderzeichen und Zahlen enthalten!", "Ausführen", "Abbruch");
}
else
{
SendClientMessage(playerid,COLOR_RED,"Du kannst dein Passwort nicht ändern, da du nicht eingeloggt bist.");
}
return 1;
}

}
if(dialogid == DIALOG_REG)
{
if(response)
{
new MeinName[MAX_PLAYER_NAME];
GetPlayerName(playerid,MeinName,sizeof MeinName);
ShowPlayerDialog(playerid,DIALOG_REG2,DIALOG_STYLE_PASSWORD,"Account erstellen","Gib das Passwort für deinen Account ein:","OK","Abbrechen");
}
else
{
ShowPlayerDialog(playerid,DIALOG_REG,DIALOG_STYLE_MSGBOX,"Account","Du benötigst einen Account, um auf diesem Server zu spielen!","Erstellen","Abbrechen");
}
}
if(dialogid == DIALOG_REG2)
{
if(response && strlen(inputtext) > 3)
{
OnPlayerRegister(playerid, inputtext);
}
else
{
ShowPlayerDialog(playerid,DIALOG_REG2,DIALOG_STYLE_PASSWORD,"Account erstellen","[FEHLER] Das Passwort muss min. 4 Zeichen haben.\nGib das Passwort für deinen Account ein:","OK","Abbrechen");
}
}

if(dialogid == DIALOG_CHANGEPASS)
{
if(response)
{
if(PlayerInfo[playerid][pAdjustable] == 1)
{
if(strlen(inputtext) > 3)
{
new string22[128];
format(string22, 128, "Du hast dein Passwort zu {FF1E00} %s {FFFFFF} geändert", inputtext);
SendClientMessage(playerid, 0xFFFFFFFF, string22);
mysql_SetString("accounts", "Passwort", inputtext, "Name", PlayerInfo[playerid][pIngameName]);
mysql_SetInt("accounts", "PasswordHashed", 0, "Name", PlayerInfo[playerid][pIngameName]);
return 1;
}
else SendClientMessage(playerid, 0xFFFFFFFF, "Dein Passwort muss mindestens 4 Zeichen lang sein.");
}
else
{
SendClientMessage(playerid,COLOR_RED,"Du kannst dein Passwort nicht ändern, da du nicht eingeloggt bist.");
}
}
}

public OnPlayerLogin(playerid,password[])
{
new string2[500];
if(IsPlayerConnected(playerid))
{
GetPlayerName(playerid, PlayerInfo[playerid][pIngameName], 24);
mysql_real_escape_string(PlayerInfo[playerid][pIngameName],PlayerInfo[playerid][pIngameName]);
if(PlayerInfo[playerid][pPasswordHashed])
{
WP_Hash(string2,129,password);
if(!strcmp(string2, mysql_ReturnPasswort(PlayerInfo[playerid][pIngameName]), true))
{
// Wird weiter ausgeführt
}
else
{
ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Gebe dein Passwort bitte erneut ein:","Login","Abbrechen");
gPlayerLogTries[playerid] += 1;
if(gPlayerLogTries[playerid] == 4) { SetTimerEx("KickPublic", 500, 0, "d", playerid); }
mysql_free_result();
return 1;
}
}
else if(!PlayerInfo[playerid][pPasswordHashed])
{
if(!strcmp(password, mysql_ReturnPasswort(PlayerInfo[playerid][pIngameName]), true))
{
// Wird weiter ausgeführt
WP_Hash(PlayerInfo[playerid][pKey],129,password);
mysql_SetString("accounts", "Passwort", PlayerInfo[playerid][pKey], "Name", PlayerInfo[playerid][pIngameName]);
mysql_SetInt("accounts", "PasswordHashed", 1 , "Name", PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPasswordHashed] = 1;
}
else
{
ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Gebe dein Passwort bitte erneut ein:","Login","Abbrechen");
gPlayerLogTries[playerid] += 1;
if(gPlayerLogTries[playerid] == 4) { SetTimerEx("KickPublic", 500, 0, "d", playerid); }
mysql_free_result();
return 1;
}
}
else
{
return 1;
}
StopAudioStreamForPlayer(playerid);
TextDrawHideForPlayer(playerid, newlogin0);
TextDrawHideForPlayer(playerid, newlogin1);
TextDrawHideForPlayer(playerid, newlogin2);
TextDrawHideForPlayer(playerid, newlogin3);
TextDrawHideForPlayer(playerid, newlogin4);
TextDrawHideForPlayer(playerid, newlogin5);
TextDrawHideForPlayer(playerid, newlogin6);
TextDrawHideForPlayer(playerid, newlogin7);
TextDrawHideForPlayer(playerid, newlogin8);
TextDrawHideForPlayer(playerid, newlogin9);
TextDrawHideForPlayer(playerid, newlogin10);
format(query, sizeof(query),"SELECT * FROM `accounts` WHERE `Name` = '%s'", PlayerInfo[playerid][pIngameName]);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pMySQLID] = mysql_GetIntByString("accounts", "id", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pLevel] = mysql_GetIntByString("accounts", "Level", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pLastMyCar] = mysql_GetIntByString("accounts", "LastMyCar", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pAdmin] = mysql_GetIntByString("accounts", "AdminLevel", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pMapper] = mysql_GetIntByString("accounts", "Mapper", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pSupporter] = mysql_GetIntByString("accounts", "Supporter", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pDonateRank] = mysql_GetIntByString("accounts", "DonatorRank", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pDonateZeit] = mysql_GetIntByString("accounts", "Donatorzeit", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][gPupgrade] = mysql_GetIntByString("accounts", "UpgradePunkte", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pReg] = mysql_GetIntByString("accounts", "Registriert", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pSex] = mysql_GetIntByString("accounts", "Geschlecht", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pOrigin] = mysql_GetIntByString("accounts", "Herkunft", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pMuted] = mysql_GetIntByString("accounts", "Gemuted", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pExp] = mysql_GetIntByString("accounts", "Respekt", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pCash] = mysql_GetIntByString("accounts", "Geld", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pAccount] = mysql_GetIntByString("accounts", "BankGeld", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pCrimes] = mysql_GetIntByString("accounts", "Verbrechen", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pKills] = mysql_GetIntByString("accounts", "Kills", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pDeaths] = mysql_GetIntByString("accounts", "Tode", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pArrested] = mysql_GetIntByString("accounts", "Eingesperrt", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pWantedDeaths] = mysql_GetIntByString("accounts", "WantedTode", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPhoneBook] = mysql_GetIntByString("accounts", "Telefonbuch", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pNavi] = mysql_GetIntByString("accounts", "Navi", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pBonusZeit] = mysql_GetIntByString("accounts", "BonusZeit", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pWerkzeugkasten] = mysql_GetIntByString("accounts", "Werkzeugkasten", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pBrille] = mysql_GetIntByString("accounts", "Brille", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pLottoNr] = mysql_GetIntByString("accounts", "LottoNr", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pFishes] = mysql_GetIntByString("accounts", "Fische", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pBiggestFish] = mysql_GetIntByString("accounts", "GroeßterFisch", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pJob] = mysql_GetIntByString("accounts", "Job", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPayCheck] = mysql_GetIntByString("accounts", "PaydayCheck", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pJailed] = mysql_GetIntByString("accounts", "Jailed", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pJailTime] = mysql_GetIntByString("accounts", "Jailtime", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pATime] = mysql_GetIntByString("accounts", "Anwalttime", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pAR] = mysql_GetIntByString("accounts", "AnwaltReady", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pLeader] = mysql_GetIntByString("accounts", "Leader", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pMember] = mysql_GetIntByString("accounts", "Member", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pFMember] = mysql_GetIntByString("accounts", "FMember", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pRank] = mysql_GetIntByString("accounts", "Rang", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pChar] = mysql_GetIntByString("accounts", "Skin", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pContractTime] = mysql_GetIntByString("accounts", "ContractZeit", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pDetSkill] = mysql_GetIntByString("accounts", "DetSkill", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pSexSkill] = mysql_GetIntByString("accounts", "SexSkill", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pBoxSkill] = mysql_GetIntByString("accounts", "BoxSkill", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pLawSkill] = mysql_GetIntByString("accounts", "AnwSkill", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pMechSkill] = mysql_GetIntByString("accounts", "MechSkill", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pJackSkill] = mysql_GetIntByString("accounts", "JackSkill", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pCarSkill] = mysql_GetIntByString("accounts", "CarSkill", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pDrugsSkill] = mysql_GetIntByString("accounts", "DrogenSkill", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pCookSkill] = mysql_GetIntByString("accounts", "KochSkill", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pFishSkill] = mysql_GetIntByString("accounts", "FischSkill", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pFarmerSkill] = mysql_GetIntByString("accounts", "FarmerSkill", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pTaschendiebSkill] = mysql_GetIntByString("accounts", "TaschendiebSkill", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][TDCooldown] = mysql_GetIntByString("accounts", "TDCooldown", "Name", PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pSHealth] = mysql_GetFloatByString("accounts", "pSHealth", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pHealth] = mysql_GetFloatByString("accounts", "pHealth", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pInt] = mysql_GetIntByString("accounts", "Interior", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pLocal] = mysql_GetIntByString("accounts", "Local", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pTeam] = mysql_GetIntByString("accounts", "Team", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pModel] = mysql_GetIntByString("accounts", "Model", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPnumber] = mysql_GetIntByString("accounts", "TelefonNr", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPhousekey] = mysql_GetIntByString("accounts", "Haus", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPbiskey] = mysql_GetIntByString("accounts", "Biz", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pHandyGeld] = mysql_GetIntByString("accounts", "HandyGeld", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pHandyVer] = mysql_GetIntByString("accounts", "HandyVer", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pHartzIV] = mysql_GetIntByString("accounts", "ArbeitsGeld", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPos_x] = mysql_GetFloatByString("accounts", "Pos_x", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPos_y] = mysql_GetFloatByString("accounts", "Pos_y", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPos_z] = mysql_GetFloatByString("accounts", "Pos_z", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pCarLic] = mysql_GetIntByString("accounts", "AutoLizenz", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pFlyLic] = mysql_GetIntByString("accounts", "FlugLizenz", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pBoatLic] = mysql_GetIntByString("accounts", "BootLizenz", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pFishLic] = mysql_GetIntByString("accounts", "FischLizenz", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pGunLic] = mysql_GetIntByString("accounts", "WaffenLizenz", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pLKWLic] = mysql_GetIntByString("accounts", "LKWLizenz", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pMotoLic] = mysql_GetIntByString("accounts", "MotorradLizenz", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pZig] = mysql_GetIntByString("accounts", "Zig", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPayDay] = mysql_GetIntByString("accounts", "PayDay", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPayDayHad] = mysql_GetIntByString("accounts", "PayDayHad", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pWins] = mysql_GetIntByString("accounts", "Wins", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pLoses] = mysql_GetIntByString("accounts", "Loses", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pAlcoholPerk] = mysql_GetIntByString("accounts", "AlcoholPerk", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pDrugPerk] = mysql_GetIntByString("accounts", "DrugPerk", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pMiserPerk] = mysql_GetIntByString("accounts", "MiserPerk", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPainPerk] = mysql_GetIntByString("accounts", "PainPerk", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pTraderPerk] = mysql_GetIntByString("accounts", "TraderPerk", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pTut] = mysql_GetIntByString("accounts", "Tutorial", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pWarns] = mysql_GetIntByString("accounts", "Warnings", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pAdjustable] = mysql_GetIntByString("accounts", "Adjustable", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pFuel] = mysql_GetIntByString("accounts", "Fuel", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pMarried] = mysql_GetIntByString("accounts", "Verheiratet", "Name",PlayerInfo[playerid][pIngameName]);
strmid(PlayerInfo[playerid][pMarriedTo], mysql_GetStringByString("accounts","MarriedTo","Name",PlayerInfo[playerid][pIngameName]), 0, 32, 255);
SpawnChange[playerid] = mysql_GetIntByString("accounts", "SpawnChange", "Name",PlayerInfo[playerid][pIngameName]);
WantedLevel[playerid] = mysql_GetIntByString("accounts", "WantedLevel", "Name",PlayerInfo[playerid][pIngameName]);
WantedPoints[playerid] = mysql_GetIntByString("accounts", "WantedPoints", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPlayMinutes] = mysql_GetIntByString("accounts", "PlayMinutes", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pGesamtMinutes] = mysql_GetIntByString("accounts", "GesamtMinutes", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pSFPASS] = mysql_GetIntByString("accounts", "SFPASS", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pLVPASS] = mysql_GetIntByString("accounts", "LVPASS", "Name",PlayerInfo[playerid][pIngameName]);
OfflineFlucht[playerid] = mysql_GetIntByString("accounts", "Offflucht", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pLPRunden] = mysql_GetIntByString("accounts", "LaufPrisonRunden", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pHandyID] = mysql_GetIntByString("accounts", "Handy", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pUhrID] = mysql_GetIntByString("accounts", "Uhr", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pOwnPerso] = mysql_GetIntByString("accounts", "Perso", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pFrakSperre] = mysql_GetIntByString("accounts", "FrakSperre", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pEventSperre] = mysql_GetIntByString("accounts", "EventSperre", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pHausWaffe] = mysql_GetIntByString("accounts", "HausWaffe", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pHausAmmu] = mysql_GetIntByString("accounts", "HausAmmu", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pLaptop] = mysql_GetIntByString("accounts", "Laptop", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pBankkarte] = mysql_GetIntByString("accounts", "Bankkarte", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pBlacklist] = mysql_GetIntByString("accounts", "BlackFrak", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pMuteTime] = mysql_GetIntByString("accounts", "MuteTime", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pTimeBan] = mysql_GetIntByString("accounts", "TimeBan", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pStyle] = mysql_GetIntByString("accounts", "FightStyle", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pDutymarke] = mysql_GetIntByString("accounts", "Dutymarke", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pCoins] = mysql_GetIntByString("accounts", "Coins", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pGebannt] = mysql_GetIntByString("accounts", "Gebannt", "Name",PlayerInfo[playerid][pIngameName]);
strmid(PlayerInfo[playerid][pBangrund], mysql_GetStringByString("accounts","Bangrund","Name",PlayerInfo[playerid][pIngameName]), 0, 128, 255);
strmid(PlayerInfo[playerid][pPrisongrund], mysql_GetStringByString("accounts","Prisongrund","Name",PlayerInfo[playerid][pIngameName]), 0, 128, 255);
strmid(PlayerInfo[playerid][pPrisonvon], mysql_GetStringByString("accounts","Prisonvon","Name",PlayerInfo[playerid][pIngameName]), 0, 32, 255);
strmid(PlayerInfo[playerid][pGebanntvon], mysql_GetStringByString("accounts","Gebanntvon","Name",PlayerInfo[playerid][pIngameName]), 0, 32, 255);
strmid(PlayerInfo[playerid][pKontack], mysql_GetStringByString("accounts","Kontackt","Name",PlayerInfo[playerid][pIngameName]), 0, 128, 255);
PlayerInfo[playerid][pSavedDrugs] = mysql_GetIntByString("accounts", "SavedDrugs", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pSavedMats] = mysql_GetIntByString("accounts", "SavedMats", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPunkteLKW] = mysql_GetIntByString("accounts", "LKWPunkte", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPunkteAuto] = mysql_GetIntByString("accounts", "AutoPunkte", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPunkteBike] = mysql_GetIntByString("accounts", "BikePunkte", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPunkteSegel] = mysql_GetIntByString("accounts", "SegelPunkte", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPunkteFlug] = mysql_GetIntByString("accounts", "FlugPunkte", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPunkteGun] = mysql_GetIntByString("accounts", "GunPunkte", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPunktePBike] = mysql_GetIntByString("accounts", "PPaydayBike", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPunktePLKW] = mysql_GetIntByString("accounts", "PPaydayLKW", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPunktePAuto] = mysql_GetIntByString("accounts", "PPaydayAuto", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPunktePFlug] = mysql_GetIntByString("accounts", "PPaydayFlug", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPunktePSegel] = mysql_GetIntByString("accounts", "PPaydaySegel", "Name",PlayerInfo[playerid][pIngameName]);
//PlayerInfo[playerid][pBomb] = mysql_GetIntByString("accounts", "Bomben", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pCodes] = mysql_GetIntByString("accounts", "HackerCodes", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pHelm] = mysql_GetIntByString("accounts", "Helm", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pPIN] = mysql_GetIntByString("accounts", "PINCode", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pNamechange] = mysql_GetIntByString("accounts", "Namechange", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pVersicherung] = mysql_GetIntByString("accounts", "Versicherung", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pKlingelTon] = mysql_GetIntByString("accounts", "KlingelTon", "Name",PlayerInfo[playerid][pIngameName]);

PlayerInfo[playerid][pCarBuy] = mysql_GetIntByString("accounts", "CarBuy", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pFlyBuy] = mysql_GetIntByString("accounts", "FlyBuy", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pBoatBuy] = mysql_GetIntByString("accounts", "BoatBuy", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pFishBuy] = mysql_GetIntByString("accounts", "FishBuy", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pGunBuy] = mysql_GetIntByString("accounts", "GunBuy", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pLKWBuy] = mysql_GetIntByString("accounts", "LKWBuy", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pMotoBuy] = mysql_GetIntByString("accounts", "MotoBuy", "Name",PlayerInfo[playerid][pIngameName]);

PlayerInfo[playerid][pHandyTalk] = mysql_GetIntByString("accounts", "HandyTalk", "Name",PlayerInfo[playerid][pIngameName]);
PlayerInfo[playerid][pAdminAufgabe] = mysql_GetIntByString("accounts", "pAdminAufgabe", "Name",PlayerInfo[playerid][pIngameName]);
//Hut System
HutGekauft[playerid] = mysql_GetIntByString("accounts", "HutGekauft", "Name",PlayerInfo[playerid][pIngameName]);
if(HutGekauft[playerid] == 1)
{
HutPos[playerid][3][hut] = mysql_GetIntByString("accounts", "Hut", "Name",PlayerInfo[playerid][pIngameName]);
HutPos[playerid][3][hutX] = mysql_GetFloatByString("accounts","HutPosX", "Name",PlayerInfo[playerid][pIngameName]);
HutPos[playerid][3][hutY] = mysql_GetFloatByString("accounts","HutPosY", "Name",PlayerInfo[playerid][pIngameName]);
HutPos[playerid][3][hutZ] = mysql_GetFloatByString("accounts","HutPosZ", "Name",PlayerInfo[playerid][pIngameName]);
HutPos[playerid][3][hutRotX] = mysql_GetFloatByString("accounts","HutRotX", "Name",PlayerInfo[playerid][pIngameName]);
HutPos[playerid][3][hutRotY] = mysql_GetFloatByString("accounts","HutRotY", "Name",PlayerInfo[playerid][pIngameName]);
HutPos[playerid][3][hutRotZ] = mysql_GetFloatByString("accounts","HutRotZ", "Name",PlayerInfo[playerid][pIngameName]);
}

// LoadUser(playerid);
PlayerInfo[playerid][pAfk] = 0;
warrived[playerid] = 0;
mask[playerid] = 0;
if(PlayerInfo[playerid][pSpeedoAktiv] == 0||PlayerInfo[playerid][pSpeedoAktiv] == 1){PlayerInfo[playerid][pSpeedoAktiv] = mysql_GetIntByString("accounts", "SpeedoAktiv", "Name",PlayerInfo[playerid][pIngameName]);}
mysql_free_result();

SetPlayerFightingStyle(playerid, PlayerInfo[playerid][pStyle]);

{
GetPlayerName(playerid, PlayerInfo[playerid][pIngameName],MAX_PLAYER_NAME);
mysql_real_escape_string(PlayerInfo[playerid][pIngameName],PlayerInfo[playerid][pIngameName]);

format(query, sizeof(query),"SELECT * FROM `accounts` WHERE `Name` = '%s'", PlayerInfo[playerid][pIngameName]);
mysql_query(query);
mysql_store_result();

strmid(PlayerInfo[playerid][pKontack], mysql_GetStringByString("accounts","Kontackt","Name",PlayerInfo[playerid][pIngameName]), 0, 128, 255);
PlayerInfo[playerid][pPasswordHashed] = mysql_GetIntByString("accounts", "PasswordHashed", "Name",PlayerInfo[playerid][pIngameName]);
mysql_free_result();
}

Also die dazu gehörigen script stelle von dem register stelle?

Also ich habe es mal getestet habe nochmal das selbe vorgang gemacht und danach bin ich in die account.sql und habe das hash password kopiert und das hash password hat danach funktioniert D27A22EBBCD7129BA2A4790ADB47CCB6E2812C840FB0FDC61588FFB69DBC262D7244CDE2A4638377B6849AE41F86297915E29EB1EF889E19E6B547C2BAE363FA das alles oO? aber wenn ich change pass mache und normal einlogge geht das nach restart wird das wieder zur hash passwort und das hash passwort funktioniert dann als normales passwort normal gemeint so
D27A22EBBCD7129BA2A4790ADB47CCB6E2812C840FB0FDC61588FFB69DBC262D7244CDE2A4638377B6849AE41F86297915E29EB1EF889E19E6B547C2BAE363FA

ja und ich möchte das iwi nicht wie kann ich das hier weg machen bitte kann mir jemand per Team wiver helfen mein skype adde
shadowchaos9

Also ich habe da so ein Problem wenn man sich ein account erstellt funktioniert alles password usw
Aber nachdem Restart wenn ich mich versuche einzuloggen steht da password falsch und wenn ich account.sql Öffne und dort pw anschaue hat sich das password irgendwie geändert in dem logs seh ich keine errors woran kann das Liegen?

Ja also wenn ich mein game mode hoch lade alles drum und drann plugins so wie ich es auf dem pc habe also auf pc funktioniert das nur beim Linux nicht ich hoste bei SAMP4you ich weiß net woran das liegt hier sind die logs

[23:43:55] --- Server Shutting Down.
[23:43:55] [debug] Run time error 19: "File or function is not found"
[23:43:55] [debug] mysql_real_escape_string
[23:43:55] [debug] mysql_store_result
[23:43:55] [debug] mysql_num_rows
[23:43:55] [debug] mysql_fetch_row
[23:43:55] [debug] mysql_free_result
[23:43:55] [debug] mysql_fetch_field
[23:43:55] [debug] mysql_init
[23:43:55] [debug] mysql_ping
[23:43:55] [junkbuster] Resetting player classes.
[23:43:55]

*** Streamer Plugin v2.7.2 by Incognito unloaded ***

[23:43:55]

[23:43:55] ===============================

[23:43:55] sscanf plugin unloaded.

[23:43:55] ===============================

[23:43:55]
[23:43:55] ====================
[23:43:55]
[23:43:55] Whirlpool unloaded
[23:43:55]
[23:43:55] ====================
[23:43:55]
[23:43:55]

[23:43:55] ______________________________________

[23:43:55] Encrypt Plugin v0.1 unloaded
[23:43:55] ______________________________________

[23:43:55] plugin.mysql: Unloading plugin...
[23:43:55] plugin.mysql: Plugin unloaded.

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z, (C)2005-2014 SA-MP Team

[23:44:03] mapname = "San Andreas" (string)
[23:44:03]
[23:44:03] Server Plugins
[23:44:03] --------------
[23:44:03] Loading plugin: streamer.so
[23:44:03]

*** Streamer Plugin v2.7.2 by Incognito loaded ***

[23:44:03] Loaded.
[23:44:03] Loading plugin: sscanf.so
[23:44:03]

[23:44:03] ===============================

[23:44:03] sscanf plugin loaded.

[23:44:03] (c) 2009 Alex "Y_Less" Cole

[23:44:03] 0.3d-R2 500 Players "dnee"

[23:44:03] ===============================

[23:44:03] Loaded.
[23:44:03] Loading plugin: Whirlpool.so
[23:44:03]
[23:44:03] ==================
[23:44:03]
[23:44:03] Whirlpool loaded
[23:44:03]
[23:44:03] ==================
[23:44:03]
[23:44:03] Loaded.
[23:44:03] Loading plugin: nativechecker.so
[23:44:03] Loaded.
[23:44:03] Loading plugin: Encrypt.so
[23:44:03]

[23:44:03] ______________________________________

[23:44:03] Encrypt Plugin v0.1 loaded
[23:44:03] ______________________________________

[23:44:03] By: Fro (c) Copyright <TBG> 2009-2010
[23:44:03] ______________________________________

[23:44:03] Loaded.
[23:44:03] Loading plugin: crashdetect.so
[23:44:03] crashdetect v4.8.3 is OK.
[23:44:03] Loaded.
[23:44:03] Loading plugin: mysql.so
[23:44:03] Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference)
[23:44:03] Loading plugin: filemanager.so
[23:44:03] ******************
[23:44:03] ** FILE MANAGER **
[23:44:03] ** Loaded **
[23:44:03] ** Version 1.1 **
[23:44:03] ******************
[23:44:03] Loaded.
[23:44:03] Loaded 7 plugins.

[23:44:03]
[23:44:03] Filterscripts
[23:44:03] ---------------
[23:44:03] Loading filterscript 'DT_DynamicCar.amx'...
[23:44:04]

[23:44:04] -------- www.dark-trigardon.de --------
[23:44:04] [FS]DT_DynamicCar by [DT]Sniper
[23:44:04] ---------------------------------------

[23:44:04] 4
[23:44:04] Loading filterscript 'JunkBuster.amx'...
[23:44:04]
[23:44:04] [junkbuster] Current JunkBuster configuration:
[23:44:04] [junkbuster] - WeaponHack = 1
[23:44:04] [junkbuster] - MoneyHack = 1
[23:44:04] [junkbuster] - Jetpack = 1
[23:44:04] [junkbuster] - HealthHack = 0
[23:44:04] [junkbuster] - ArmourHack = 1
[23:44:04] [junkbuster] - DriveBy = 2
[23:44:04] [junkbuster] - Spam = 0
[23:44:04] [junkbuster] - CommandSpam = 0
[23:44:04] [junkbuster] - BadWords = 1
[23:44:04] [junkbuster] - CarJackHack = 1
[23:44:04] [junkbuster] - TeleportHack = 1
[23:44:04] [junkbuster] - MaxPing = 600
[23:44:04] [junkbuster] - SpectateHack = 0
[23:44:04] [junkbuster] - Blacklist = 1
[23:44:04] [junkbuster] - IpBans = 1
[23:44:04] [junkbuster] - TempBans = 0
[23:44:04] [junkbuster] - SpawnKill = 0
[23:44:04] [junkbuster] - CapsLock = 1
[23:44:04] [junkbuster] - 3DSpeed = 1
[23:44:04] [junkbuster] - MaxSpeed = 250
[23:44:04] [junkbuster] - AdminImmunity = 1
[23:44:04] [junkbuster] - Advertisement = 0
[23:44:04] [junkbuster] - FreezeUpdate = 0
[23:44:04] [junkbuster] - SpawnTime = 10
[23:44:04] [junkbuster] - CheckpointTeleport = 1
[23:44:04] [junkbuster] - Airbrake = 150
[23:44:04] [junkbuster] - TankMode = 0
[23:44:04] [junkbuster] - WarnPlayers = 0
[23:44:04] [junkbuster] - SingleplayerCheats = 1
[23:44:04] [junkbuster] - MinFPS = 0
[23:44:04] [junkbuster] - DisableBadWeapons = 1
[23:44:04] [junkbuster] - CBug = 16
[23:44:04] [junkbuster] - AntiBugKill = 1
[23:44:04] [junkbuster] - NoReload = 0
[23:44:04] [junkbuster] - NoReloadForSawnOff = 0
[23:44:04] [junkbuster] - ActiveGMC = 1
[23:44:04] [junkbuster] - GMCBan = 0
[23:44:04] [junkbuster] - ServerSideHealth = 0
[23:44:04] [junkbuster] - CheckVMPos = 0
[23:44:04] [junkbuster] - QuickTurn = 0
[23:44:04] [junkbuster] - VehicleTeleport = 1
[23:44:04] [junkbuster] - Wallride = 170
[23:44:04] [junkbuster] - DisplayTextDraw = 1
[23:44:04] [junkbuster] - AFK = 5
[23:44:04] [junkbuster] - PickupTeleport = 1
[23:44:04] [junkbuster] - FlyHack = 40
[23:44:04] [junkbuster] - JunkBusterChrome = 1
[23:44:04] [junkbuster] - CheckWalkAnims = 1
[23:44:04] [junkbuster] - ReportMoneyHack = 1
[23:44:04] [junkbuster] - SpeedhackAdvanced = 20
[23:44:04] [junkbuster] - Joypad = 0
[23:44:04] [junkbuster] - ArmedVehicles = 0
[23:44:04] [junkbuster] - VehicleRepair = 2
[23:44:04] [junkbuster] - TuningHack = 1
[23:44:04] [junkbuster] - PayForGuns = 3
[23:44:04] [junkbuster] - SpawnVehicles = 0
[23:44:04] [junkbuster] - MaxTotalWarnings = 15
[23:44:04] [junkbuster] - TooManyWarningsAction = 1
[23:44:04]
[23:44:04] [junkbuster] 0 IP-bans have been loaded.
[23:44:04] [junkbuster] 0 temporary bans have been loaded.
[23:44:04] [junkbuster] 5 whitelist entries have been loaded.
[23:44:04] [junkbuster] 10 blacklist entries have been loaded.
[23:44:04] [junkbuster] 0 bad words have been loaded.
[23:44:04] [junkbuster] 7 forbidden weapons have been loaded.
[23:44:04] [junkbuster] JunkBuster has been configurated.
[23:44:04] [junkbuster] JunkBuster (v10.0) has successfully been loaded.
[23:44:04] Loaded 2 filterscripts.

[23:44:04] Error: Function not registered: 'mysql_real_escape_string'
[23:44:04] Error: Function not registered: 'mysql_query'
[23:44:04] Error: Function not registered: 'mysql_store_result'
[23:44:04] Error: Function not registered: 'mysql_num_rows'
[23:44:04] Error: Function not registered: 'mysql_fetch_row'
[23:44:04] Error: Function not registered: 'mysql_free_result'
[23:44:04] Error: Function not registered: 'mysql_fetch_field'
[23:44:04] Error: Function not registered: 'mysql_init'
[23:44:04] Error: Function not registered: 'mysql_connect'
[23:44:04] Error: Function not registered: 'mysql_ping'
[23:44:04] Error: Function not registered: 'mysql_close'
[23:44:04] [debug] Run time error 19: "File or function is not found"
[23:44:04] [debug] mysql_real_escape_string
[23:44:04] [debug] mysql_query
[23:44:04] [debug] mysql_store_result
[23:44:04] [debug] mysql_num_rows
[23:44:04] [debug] mysql_fetch_row
[23:44:04] [debug] mysql_free_result
[23:44:04] [debug] mysql_fetch_field
[23:44:04] [debug] mysql_init
[23:44:04] [debug] mysql_connect
[23:44:04] [debug] mysql_ping
[23:44:04] [debug] mysql_close
[23:44:04] Script[gamemodes/BetaV1.0.amx]: Run time error 19: "File or function is not found"
[23:44:04] Number of vehicle models: 0

schade ich bräuchte einen Gameserver mit 5 slots

nope ist nicht verbuggt ;D volle system ist ja drin aber 0 ahnung mit den zonen mache ich da was falsch mit den coords oder

Hay leute also ich habe mir einen "Script" gekauft und ja alles schön und etc aber ich habe einen Problem mit dem Gangfight system ich kann die zonen einfach nicht erstellen checke das nicht das Gangfight system besitzt das "Capture The Flag" hier mal die zonen was mache ich hier falsch -.-

und das hier ist ein sccren vom Gangwar

ja und wenn ich hir ein bann bekomme bzw ip bann habe ich ip changer ändert sich auf beliebiger weiße

ja toll nur weil er ts3 server sponsiert mir ist das late habe selber ts3 server >_>

ja aber wo soll ich den gucken unter howtos nach dieser datei -.-

problem ist wie mache ich das so damit ich drauf spielen kann mysql 0 problem aber ich weis nicht was ich mit dieser 1 datei machen soll

hillfe-.-

wie tu ich das auf meinem pc abspielen ohne linux oder sowas -.- das ist nur 1 datei und kein pwn oder sowas xD hillfe

wie tu ich das auf meinem pc abspielen ohne linux oder sowas -.- das ist nur 1 datei und kein pwn oder sowas xD hillfe