Beiträge von ShadowSura

ShadowSura · 12. Juli 2014

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

ShadowSura · 12. Juli 2014

nicht wirklich

ShadowSura · 12. Juli 2014

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

ShadowSura · 3. Juli 2014

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

ShadowSura · 3. Juli 2014

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

ShadowSura · 3. Juli 2014

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();
}

ShadowSura · 2. Juli 2014

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

ShadowSura · 2. Juli 2014

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

ShadowSura · 2. Juli 2014

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?

ShadowSura · 1. Juli 2014

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] 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

ShadowSura · 29. Juni 2014

schade ich bräuchte einen Gameserver mit 5 slots

ShadowSura · 29. Juni 2014

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

ShadowSura · 29. Juni 2014

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

ShadowSura · 13. April 2012

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 -.-

ShadowSura · 13. April 2012

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

ShadowSura · 13. April 2012

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

ShadowSura · 13. April 2012

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

Beiträge von ShadowSura

Suche einen Teampeak3 Server

Suche einen Teampeak3 Server

Suche einen Teampeak3 Server

Server Registrierungs problem

Server Registrierungs problem

Server Registrierungs problem

Server Registrierungs problem

Server Registrierungs problem

Server Registrierungs problem

Hilfe Mysql spackt rum

noLimit Hosting | Kostenfreie Teamspeak Bots

Hey leute Gangfight-Mysql Frage

Hey leute Gangfight-Mysql Frage

GTA PowerPlay Full Version

GTA PowerPlay Full Version

GTA PowerPlay Full Version

GTA PowerPlay Full Version