Beiträge von Dr. Frauenarzt

Dr. Frauenarzt · 22. Mai 2018

Das ist gut obwohl ich kein Mieter bin werde ich aufgelistet das nicht nur einmal

Aber bin dir dankbar für deine hilfe ich hoffe wir finden eine lösung

Dr. Frauenarzt · 22. Mai 2018

Hallo,

Ich möchte gerne per MSGBOX wissen wie ich die Mieter die Online sind auflisten kann.
Und wie kann ich Besitzer rauswerfen die Online sind also ID angeben das der jenige rausgeworfen wird.

enum des Haussystem:

Code

enum e_Haus
{
	hCreated,
	Float:EnterX,
	Float:EnterY,
	Float:EnterZ,
	Float:ExitX,
	Float:ExitY,
	Float:ExitZ,
	hBesitzer[MAX_PLAYER_NAME],
	hOwned,
	hName[32],
	hPreis,
	hMieten,
	Text3D:hText,
	hPickup,
	hLock,
	hMietPreis,
	hInterior,
	hKasse,
	hdbID,
	hHealthUpgrade
}
new Haus[MAX_HOUSES][e_Haus];

Alles anzeigen

Befehl zum Einmieten:

Code

ocmd:renthouse(playerid)
{
	if(PlayerInfo[playerid][pHouseKey] != INVALID_HOUSE_KEY)return SendClientMessage(playerid, COLOR_GREY, "Du bist bereits in einem Haus eingemietet!");
	new count = CountPlayerHouses(playerid);
	if(count > 0)return SendClientMessage(playerid, COLOR_GREY, "Du besitzt bereits ein Haus.");
	if(IsPlayerHouse(playerid) != INVALID_HOUSE_KEY)return SendClientMessage(playerid, COLOR_GREY, "Du besitzt bereits ein Haus.");
	new i = GetNextHouseID(playerid);
	if(i == INVALID_HOUSE_KEY)return SendClientMessage(playerid, COLOR_GREY, "Es befindet sich kein Haus zum mieten in deiner Nähe!");
	if(Haus[i][hMieten] == 0)return SendClientMessage(playerid, COLOR_GREY, "Dieses Haus lässt das Mieten nicht zu.");
	if(GetPlayerMoneys(playerid) < Haus[i][hMietPreis])return SendClientMessage(playerid, COLOR_GREY, "Du hast nicht genügend Geld dabei.");
	PlayerInfo[playerid][pHouseKey] = i;
	GivePlayerMoneys(playerid, -Haus[i][hMietPreis]);
	Haus[i][hKasse] += Haus[i][hMietPreis];
	SendClientMessage(playerid, COLOR_GREEN, "Du hast dich erfolgreich in dieses Haus eingemietet.");
	return 1;
}

Alles anzeigen

Dr. Frauenarzt · 21. Mai 2018

Code

if(dialogid == DIALOG_HAUS_BESCHREIBUNG)
	{
	    new i = IsPlayerHouse(playerid);
		if(response)
		{
			if(!strlen(inputtext) || strlen(inputtext) > 32)
			{
			    //GivePlayerMoneys(playerid, 1000000);
				UpdateHouseLabel(i, Haus[i][hText]);
				SaveHouse(i);
				return 1;
			}
		}
	}

Alles anzeigen

Habe kurz eine frage,

Möchte gerne das man für 1kk die Beschreibung vom Haus ändern kann aber irgedwie funkioniert das nicht warum @Jeffry

Dr. Frauenarzt · 21. Mai 2018

C:\Users\ASUS\Desktop\Coming Soon\gamemodes\CS.pwn(47960) : warning 212: possibly unintended bitwise operation

Code

ocmd:cprison(playerid,params[])
{
    new pID, checks, string[250], grund[35];
    if(sscanf(params,"dds[35]",pID, checks, grund)) return SendClientMessage(playerid, COLOR_WHITE,"{247BA6}* Benutze: {00FF00}/cprison [SpielerID/Name] [Anzahl Checkpoints] [Grund]");
    if(strlen(grund) > 35) return SendClientMessage(playerid, COLOR_WHITE,"{247BA6}* Benutze: {00FF00}/cprison [SpielerID/Name] [Anzahl Checkpoints] [Grund max. 35 Zeichen]");
    if(!IsPlayerConnected(pID)) return SendClientMessage(playerid, COLOR_WHITE,"{AFAFAF}Der angegebene Spieler ist nicht connected!");
    if(IsPlayerNPC(pID)) return SendClientMessage(playerid, COLOR_WHITE,"{AFAFAF}Der angegebene Spieler ist ein NPC!");
    //if(pID == playerid) return SendClientMessage(playerid, COLOR_WHITE,"{AFAFAF}Du kannst dich nicht selbst bestrafen!");
    if(PlayerInfo[pID][pAdmin] > PlayerInfo[playerid][pAdmin]) return SendClientMessage(playerid, COLOR_WHITE,"{AFAFAF}Du kannst kein höher gestelltes Team Mitglied eine Strafe aussprechen!");
    if(checks> 5000 | checks< 10) return SendClientMessage(playerid, COLOR_WHITE,"{AFAFAF}Mindestens 10 Checkpoints & Maximal 5.0000 Checkpoints!"); //47960
    if(PlayerInfo[pID][pInStrafe] == 1) return SendClientMessage(playerid, COLOR_WHITE,"{AFAFAF}Der angegeben Spieler ist bereits bestraft wurden!");
   	format(string, sizeof(string), "%s wurde von %s für %d Checkpoints ins Prison teleportiert, Grund: %s", SpielerName(pID), SpielerName(playerid), checks, grund);
	SendClientMessageToAll(COLOR_RED, string);
    PlayerInfo[pID][pChecksGesamt] = checks;
    PlayerInfo[pID][pChecksGelaufen] = 0;
    PlayerInfo[pID][pInStrafe] = 1;
    SetPlayerSpawn(pID);
    return true;
}

Alles anzeigen

Weswegen schlägt der an?

Dr. Frauenarzt · 20. Mai 2018

Sehr schön verstanden.

cache_get_value_name(i, "Besitzer", Haus[houseID][hBesitzer]);
cache_get_value_name(i, "Name", Haus[houseID][hName]);

cache_get_value_name_int(i, "Besitzer", Haus[houseID][hBesitzer]);
cache_get_value_name_int(i, "Name", Haus[houseID][hName]);

Wie lasse ich am besten die 2 auslesen einmal den Besitzername
und einmal die Beschreibung des Hauses.

Beim Erstellen wird soweit alles richtig angezeigt nur das Problem ist wen ich den Server neu starte klappt es nicht.

//E:

Habe die Lösung gefunden.

cache_get_value_name(i, "Besitzer", Haus[houseID][hBesitzer], MAX_PLAYER_NAME);
cache_get_value_name(i, "Name", Haus[houseID][hName], 64);

Dr. Frauenarzt · 20. Mai 2018

Geht direkt wieder zu ?

Haustür -> AufHaustür -> Zu

Code

if(listitem == 2) // Tür
				{
					if(Haus[haus][hLock] == 1)
					{
						Haus[haus][hLock] = 0;
						printf("Haustür -> Auf", Haus[haus][hLock]);
						GameTextForPlayer(playerid, "~w~Haus ~g~aufgeschlossen", 3000, 6);
						UpdateHouseLabel(haus, Haus[haus][hOwned]);
					}
					if(Haus[haus][hLock] == 0)
					{
						Haus[haus][hLock] = 1;
						printf("Haustür -> Zu", Haus[haus][hLock]);
						GameTextForPlayer(playerid, "~w~Haus ~r~abgeschlossen", 3000, 6);
						UpdateHouseLabel(haus, Haus[haus][hOwned]);
					}
				}

Alles anzeigen

//E:

& Wie lasse ich Name und eine Beschreibung auslesen aus der DB?

Habe es so versucht:

cache_get_value_name(i, "Besitzer", Haus[houseID][hBesitzer]);
cache_get_value_name(i, "Name", Haus[houseID][hName]);

Und so versucht:

cache_get_value_name_int(i, "Besitzer", Haus[houseID][hBesitzer]);
cache_get_value_name_int(i, "Name", Haus[houseID][hName]);

Dr. Frauenarzt · 20. Mai 2018

Ich habe kurz eine Frage hab ein klein fehler warum auch immer.

Also wen ich das Haus zu schließe und auschließe steht immer bei beiden das es abgeschlossen ist warum?

Code

if(listitem == 2) // Tür
				{
					if(Haus[haus][hLock] == 1)
					{
						Haus[haus][hLock] = 0;
						GameTextForPlayer(playerid, "~w~Haus ~g~aufgeschlossen", 3000, 6);
						UpdateHouseLabel(haus, Haus[haus][hOwned]);
					}
					if(Haus[haus][hLock] == 0)
					{
						Haus[haus][hLock] = 1;
						GameTextForPlayer(playerid, "~w~Haus ~r~abgeschlossen", 3000, 6);
						UpdateHouseLabel(haus, Haus[haus][hOwned]);
					}
				}

Alles anzeigen

Dr. Frauenarzt · 20. Mai 2018

Gut habe ich mit.

was ich gerne noch wissen möchte was ist der Unterschied zwischen

mysql_tquery

und zwischen

mysql_pquery

Dr. Frauenarzt · 20. Mai 2018

Code

PUBLIC:OnPlayerRegister(playerid)
{
	StuffInfo[sNeuUser] += 1;
	if(IsPlayerConnected(playerid))
	{
		new string[128];
		PlayerInfo[playerid][pSQLID] = cache_insert_id();

		mysql_format(handle, string, sizeof(string), "UPDATE `server_accounts` SET `RegisterDatum`='%d' WHERE `Name`='%s'", Time(), SpielerName(playerid));
		mysql_pquery(handle, string);


  		PlayerInfo[playerid][pChar] = 26;
        gOoc[playerid] = 0;
        GotMD5[playerid] = 1;
		PlayerInfo[playerid][pReg] = 1;
		PlayerInfo[playerid][pAlter] = 0;
		PlayerInfo[playerid][pTut] = 0;
		PlayerInfo[playerid][pLevel] = 1;
		PlayerInfo[playerid][pSHealth] = 50.0;
		StuffInfo[sLastNumber] += 1;
		PlayerInfo[playerid][pNummer] = StuffInfo[sLastNumber];
		PlayerInfo[playerid][pBizKey] = -1;
		PlayerInfo[playerid][pBank] = 0;
		GivePlayerMoneys(playerid, 5000);
		PlayerInfo[playerid][pCrimes] = 0;
		PlayerInfo[playerid][pArrested] = 0;
		PlayerInfo[playerid][pArrestTime] = 0;
		PlayerInfo[playerid][pKills] = 0;
		PlayerInfo[playerid][psKills] = 0;
		PlayerInfo[playerid][pDeaths] = 0;
		PlayerInfo[playerid][pMember] = -1;
		PlayerInfo[playerid][pLeader] = -1;
		PlayerInfo[playerid][pOnDutySkin] = 60;
		PlayerInfo[playerid][pPistolSkill] = 2;
		PlayerInfo[playerid][pMaschinePistolSkill] = 2;
		PlayerInfo[playerid][pSturmgewehrPistolSkill] = 2;
		PlayerInfo[playerid][pShotGunSkill] = 1;
		/*Scheine*/
		PlayerInfo[playerid][pGunLicense] = 0;
		PlayerInfo[playerid][pFlyLicense] = 0;
		PlayerInfo[playerid][pCarLicense] = 0;
		PlayerInfo[playerid][pBikeLicense] = 0;
		PlayerInfo[playerid][pCPTUT] = 0;


		PlayerUpdate(playerid);
	}
	return 1;
}

Alles anzeigen

Dr. Frauenarzt · 20. Mai 2018

Wie ich schon gesgt habe.

Das Problem besteht wen sich der User "Registriert" sollte danach eigentlich das Login Fenster erscheinen.
Aber das Problem steht darin das er es nicht macht und somit könn die Spieler nicht geladen werden.
Somit muss der Spieler jedes mal reloggen um sich dann einzuloggen das es weiter geht.
Das wollte ich ja vermeiden das der Spieler jedes mal neu connecten muss.

Das ist der log dazu nachdem er sich Registriert hat.

Spoiler anzeigen

Code

[12:12:52] [DEBUG] mysql_format(1, 0x068D0090, 256, "INSERT INTO `server_accounts` (`Name`, `NewPassword`) VALUES ('%s', '%e')")
[12:12:52] [DEBUG] CHandle::EscapeString(this=0x6a68730, src='57B87A3FFAE0CF4E1C88DDF4FAD66F890AB379D222F6D2F4B8AC4D5099E5BEA8D9797A12039E0CD0079E4BE53C56940888B504274F60B32931188CE63F8739AB')
[12:12:52] [DEBUG] CConnection::EscapeString(src='57B87A3FFAE0CF4E1C88DDF4FAD66F890AB379D222F6D2F4B8AC4D5099E5BEA8D9797A12039E0CD0079E4BE53C56940888B504274F60B32931188CE63F8739AB', this=0x26bd438, connection=0x6aafe40)
[12:12:52] [DEBUG] CHandle::EscapeString - return value: true, escaped string: '57B87A3FFAE0CF4E1C88DDF4FAD66F890AB379D222F6D2F4B8AC4D5099E5BEA8D9797A12039E0CD0079E4BE53C56940888B504274F60B32931188CE63F8739AB'
[12:12:52] [DEBUG] mysql_format: return value: '202'
[12:12:52] [DEBUG] mysql_pquery(1, "INSERT INTO `server_accounts` (`Name`, `NewPassword`) VALUES ('James', '57B87A3FFAE0CF4E1C88DDF4FAD66F890AB379D222F6D2F4B8AC4D5099E5BEA8D9797A12039E0CD0079E4BE53C56940888B504274F60B32931188CE63F8739AB')", "", "")
[12:12:52] [DEBUG] CCallback::Create(amx=0x4ae30c8, name='', format='', params=0x68cfe78, param_offset=5)
[12:12:52] [DEBUG] CHandle::Execute(this=0x6a68730, type=2, query=0x6afb418)
[12:12:52] [DEBUG] CConnectionPool::Queue(query=0x6afb418, this=0x26bd9b8)
[12:12:52] [DEBUG] CHandle::Execute - return value: true
[12:12:52] [DEBUG] mysql_pquery: return value: '1'
[12:12:52] [DEBUG] CConnection::Execute(query=0x6afb418, this=0x70cc020, connection=0x6ace0e0)
[12:12:52] [DEBUG] CQuery::Execute(this=0x6afb418, connection=0x6ace0e0)
[12:12:52] [DEBUG] cache_insert_id()
[12:12:52] [ERROR] cache_insert_id: no active cache
[12:12:52] [DEBUG] mysql_format(1, 0x068CFC7C, 128, "UPDATE `server_accounts` SET `RegisterDatum`='%d' WHERE `Name`='%s'")
[12:12:52] [DEBUG] mysql_format: return value: '78'
[12:12:52] [DEBUG] mysql_pquery(1, "UPDATE `server_accounts` SET `RegisterDatum`='1525867972' WHERE `Name`='James'", "", "")
[12:12:52] [DEBUG] CCallback::Create(amx=0x4ae30c8, name='', format='', params=0x68cfc68, param_offset=5)
[12:12:52] [DEBUG] CHandle::Execute(this=0x6a68730, type=2, query=0x6afb840)
[12:12:52] [DEBUG] CConnectionPool::Queue(query=0x6afb840, this=0x26bd9b8)
[12:12:52] [DEBUG] CHandle::Execute - return value: true
[12:12:52] [DEBUG] mysql_pquery: return value: '1'
[12:12:52] [DEBUG] CConnection::Execute(query=0x6afb840, this=0x6ef0020, connection=0x6ac4cf8)
[12:12:52] [DEBUG] CQuery::Execute(this=0x6afb840, connection=0x6ac4cf8)
[12:12:52] [DEBUG] mysql_format(1, 0x068C9D3C, 3046, "UPDATE `server_accounts` SET `Level`='%d', `AdminLevel`='%d', `Checkpoint`='%d', `CPrison`='%d', `RunningCP`='%d', `TeamRadar`='%d', `BNDRadar`='%d', ")
[12:12:52] [DEBUG] mysql_format: return value: '143'
[12:12:52] [DEBUG] mysql_format(1, 0x068C9D3C, 3046, "%s`StartCoints`='%d', `Coints`='%d', `SpawnhealZeit`='%d', `DeaglespawnZeit`='%d', `M4SpawnZeit`='%d', `MP5SpawnZeit`='%d', `MehrZinsenZeit`='%d', `Tot`='%d', `TotUnix`='%d', `TotX`='%f', `TotY`='%f', `TotZ`='%f', `TotWorld`='%d', ")
[12:12:52] [DEBUG] mysql_format: return value: '380'
[12:12:52] [DEBUG] mysql_format(1, 0x068C9D3C, 3046, "%s`Medickit`='%d', `Startbonus`='%d', `Kreditkarte`='%d', `KreditkarteBenutzung`='%d', `Personalausweis`='%d', `DonateRank`='%d', `UpgradePoints`='%d', `ConnectedTime`='%d', `Registered`='%d', ")
[12:12:52] [DEBUG] mysql_format: return value: '562'
[12:12:52] [DEBUG] mysql_format(1, 0x068C9D3C, 3046, "%s`Geschlecht`='%d', `Age`='%d', `Origin`='%d', `Muted`='%d', `Respect`='%d', `Gehalt`='%d', `Money`='%d', `Bank`='%d', `Jobgeld`='%d', `Crimes`='%d', ")
[12:12:52] [DEBUG] mysql_format: return value: '704'
[12:12:52] [DEBUG] mysql_format(1, 0x068C9D3C, 3046, "%s`Kills`='%d', `sKills`='%d', `Deaths`='%d', `Arrested`='%d', `ArrestTime`='%d', `PhoneBook`='%d', `LottoNr`='%d', `Fishes`='%d', `BiggestFish`='%d', `Job`='%d', ")
[12:12:52] [DEBUG] mysql_format: return value: '855'
[12:12:52] [DEBUG] mysql_format(1, 0x068C9D3C, 3046, "%s`HeadValue`='%d', `Jailed`='%d', `JailTime`='%d', `Leader`='%d', `Member`='%d', `Rank`='%d', `Skin`='%d', `Vertragszeit`='%d', ")
[12:12:52] [DEBUG] mysql_format: return value: '977'
[12:12:52] [DEBUG] mysql_format(1, 0x068C9D3C, 3046, "%s`NewsSkill`='%d', `FishSkill`='%d', `MechSkill`='%d', `pSHealth`='%.1f', ")
[12:12:52] [DEBUG] mysql_format: return value: '1047'
[12:12:52] [DEBUG] mysql_format(1, 0x068C9D3C, 3046, "%s`PhoneNr`='%d', `Hotel`='%d', `Biz`='%d', `CarLicense`='%d', `FlyLicense`='%d', `BoatLicense`='%d', `FishLicense`='%d', `GunLicense`='%d', `Zollpass`='%d', `GotMD5`='%d' WHERE `Name`='%s' ")
[12:12:52] [DEBUG] mysql_format: return value: '1230'
[12:12:52] [DEBUG] mysql_pquery(1, "UPDATE `server_accounts` SET `Level`='1', `AdminLevel`='0', `Checkpoint`='0', `CPrison`='0', `RunningCP`='0', `TeamRadar`='0', `BNDRadar`='0', `StartCoints`='0', `Coints`='0', `SpawnhealZeit`='0', `DeaglespawnZeit`='0', `M4SpawnZeit`='0', `MP5SpawnZeit`='0', `MehrZinsenZeit`='0', `Tot`='0', `TotUnix`='0', `TotX`='0.000000', `TotY`='0.000000', `TotZ`='0.000000', `TotWorld`='0', `Medickit`='0', `Startbonus`='0', `Kreditkarte`='0', `KreditkarteBenutzung`='0', `Personalausweis`='0', `DonateRank`='0', `UpgradePoints`='0', `ConnectedTime`='0', `Registered`='1', `Geschlecht`='0', `Age`='0', `Origin`='0', `Muted`='0', `Respect`='0', `Gehalt`='0', `Money`='5000', `Bank`='0', `Jobgeld`='0', `Crimes`='0', `Kills`='0', `sKills`='0', `Deaths`='0', `Arrested`='0', `ArrestTime`='0', `PhoneBook`='0', `LottoNr`='0', `Fishes`='0', `BiggestFish`='0', `Job`='0', `HeadValue`='0', `Jailed`='0', `JailTime`='0', `Leader`='-1', `Member`='-1', `Rank`='0', `Skin`='26', `Vertragszeit`='5', `NewsSkill`='0', `FishSkill`='0', `MechSkill`='0', `pSHealth`='50.0', `PhoneNr`='1', `Hotel`='-1', `Biz`='-1', `CarLicense`='0', `FlyLicense`='0', `BoatLicense`='0', `FishLicense`='0', `GunLicense`='0', `Zollpass`='0', `GotMD5`='1' WHERE `Name`='James' ", "", "")
[12:12:52] [DEBUG] CCallback::Create(amx=0x4ae30c8, name='', format='', params=0x68c9d28, param_offset=5)
[12:12:52] [DEBUG] CHandle::Execute(this=0x6a68730, type=2, query=0x6afb2e8)
[12:12:52] [DEBUG] CConnectionPool::Queue(query=0x6afb2e8, this=0x26bd9b8)
[12:12:52] [DEBUG] CHandle::Execute - return value: true
[12:12:52] [DEBUG] mysql_pquery: return value: '1'
[12:12:52] [DEBUG] mysql_format(1, 0x068C9D3C, 3046, "UPDATE `server_accounts` SET `Gun1`='%d', `Gun2`='%d', `Gun3`='%d', `Gun4`='%d', `Ammo1`='%d', `Ammo2`='%d', `Ammo3`='%d', `Ammo4`='%d', `CarTime`='%d', `PayDay`='%d', ")
[12:12:52] [DEBUG] mysql_format: return value: '158'
[12:12:52] [DEBUG] mysql_format(1, 0x068C9D3C, 3046, "%s`PayDayHad`='%d', `CDPlayer`='%d', `AlcoholPerk`='%d', `PainKillerPerk`='%d', `PistolSkill`='%d', `MaschinePistolSkill`='%d', `SturmgewehrPistolSkill`='%d', `ShotGunSkill`='%d', `DrugPerk`='%d', `MiserPerk`='%d', ")
[12:12:52] [DEBUG] mysql_format: return value: '361'
[12:12:52] [DEBUG] mysql_format(1, 0x068C9D3C, 3046, "%s`TraderPerk`='%d', `Tutorial`='%d', `Cptut`='%d', `Warnings`='%d', `Fuel`='%d', `Married`='%d', `MarriedTo`='%s', `WantedLevel`='%d', `Spawn`='%d', ")
[12:12:52] [DEBUG] mysql_format: return value: '506'
[12:12:52] [DEBUG] mysql_format(1, 0x068C9D3C, 3046, "%s`SavedMaterials`='%d', `SavedDrugs`='%d', `BikeLicense`='%d', `LKWLicense`='%d', `DonatorTime`='%d', `WerberName`='%s', `FightingStyle`='%d', `Handy`='%d', `OnDutySkin`='%d', `CarLicensePoints`='%d', ")
[12:12:52] [DEBUG] mysql_format: return value: '703'
[12:12:52] [DEBUG] mysql_format(1, 0x068C9D3C, 3046, "%s`BikeLicensePoints`='%d', `InviteSperre`='%d', `warntime1`='%d', `warntime2`='%d', `Ticketsopen`='%d', `OldName`='%s', `ClientIP`='%s', `OrgMember`='%d', `OrgLeader`='%d', `OrgManager`='%d', `OrgName`='%s' WHERE `Name`='%s'")
[12:12:52] [DEBUG] mysql_format: return value: '939'
[12:12:52] [DEBUG] mysql_pquery(1, "UPDATE `server_accounts` SET `Gun1`='0', `Gun2`='0', `Gun3`='0', `Gun4`='0', `Ammo1`='0', `Ammo2`='0', `Ammo3`='0', `Ammo4`='0', `CarTime`='0', `PayDay`='0', `PayDayHad`='0', `CDPlayer`='0', `AlcoholPerk`='0', `PainKillerPerk`='0', `PistolSkill`='2', `MaschinePistolSkill`='2', `SturmgewehrPistolSkill`='2', `ShotGunSkill`='1', `DrugPerk`='0', `MiserPerk`='0', `TraderPerk`='0', `Tutorial`='0', `Cptut`='0', `Warnings`='0', `Fuel`='0', `Married`='0', `MarriedTo`='Niemand', `WantedLevel`='0', `Spawn`='0', `SavedMaterials`='0', `SavedDrugs`='0', `BikeLicense`='0', `LKWLicense`='0', `DonatorTime`='0', `WerberName`='Niemand', `FightingStyle`='0', `Handy`='0', `OnDutySkin`='60', `CarLicensePoints`='0', `BikeLicensePoints`='0', `InviteSperre`='0', `warntime1`='0', `warntime2`='0', `Ticketsopen`='0', `OldName`='Niemand', `ClientIP`='127.0.0.1', `OrgMember`='-1', `OrgLeader`='-1', `OrgManager`='-1', `OrgName`='Keine' WHERE `Name`='James'", "", "")
[12:12:52] [DEBUG] CCallback::Create(amx=0x4ae30c8, name='', format='', params=0x68c9d28, param_offset=5)
[12:12:52] [DEBUG] CHandle::Execute(this=0x6a68730, type=2, query=0x6afb5e0)
[12:12:52] [DEBUG] CConnectionPool::Queue(query=0x6afb5e0, this=0x26bd9b8)
[12:12:52] [DEBUG] CHandle::Execute - return value: true
[12:12:52] [DEBUG] mysql_pquery: return value: '1'
[12:12:52] [INFO] query "INSERT INTO `server_accounts` (`Name`, `NewPassword`) VALUES ('James', '57B87A3FFAE0CF4E1C88DDF4FAD66F890AB379D222F6D2F4B8AC4D5099E5BEA8D9797A12039E0CD0079E4BE53C56940888B504274F60B32931188CE63F8739AB')" successfully executed within 53.995 milliseconds
[12:12:52] [DEBUG] CResultSet::Create(connection=0x6ace0e0, query_str='INSERT INTO `server_accounts` (`Name`, `NewPassword`) VALUES ('James', '57B87A3FFAE0CF4E1C88DDF4FAD66F890AB379D222F6D2F4B8AC4D5099E5BEA8D9797A12039E0CD0079E4BE53C56940888B504274F60B32931188CE63F8739AB')')
[12:12:52] [DEBUG] created new resultset '0x6aedfc0'
[12:12:52] [DEBUG] fetched MySQL result '0x0'
[12:12:52] [DEBUG] CConnection::Execute(query=0x6afb2e8, this=0x70cc020, connection=0x6ace0e0)
[12:12:52] [DEBUG] CQuery::Execute(this=0x6afb2e8, connection=0x6ace0e0)
[12:12:52] [INFO] query "UPDATE `server_accounts` SET `RegisterDatum`='1525867972' WHERE `Name`='James'" successfully executed within 95.824 milliseconds
[12:12:52] [DEBUG] CResultSet::Create(connection=0x6ac4cf8, query_str='UPDATE `server_accounts` SET `RegisterDatum`='1525867972' WHERE `Name`='James'')
[12:12:52] [DEBUG] created new resultset '0x6ae31e0'
[12:12:52] [DEBUG] fetched MySQL result '0x0'
[12:12:52] [DEBUG] CConnection::Execute(query=0x6afb5e0, this=0x6ef0020, connection=0x6ac4cf8)
[12:12:52] [DEBUG] CQuery::Execute(this=0x6afb5e0, connection=0x6ac4cf8)
[12:12:52] [INFO] query "UPDATE `server_accounts` SET `Level`='1', `AdminLevel`='0', `Checkpoint`='0', `CPrison`='0', `RunningCP`='0', `TeamRadar`='0', `BNDRadar`='0', `StartCoints`='0', `Coints`='0', `SpawnhealZeit`='0', `DeaglespawnZeit`='0', `M4SpawnZeit`='0', `MP5SpawnZeit`='0', `MehrZinsenZeit`='0', `Tot`='0', `TotUnix`='0', `TotX`='0.000000', `TotY`='0.000000', `TotZ`='0.000000', `TotWorld`='0', `Medickit`='0', `Startbonus`='0', `Kreditkarte`='0', `KreditkarteBenutzung`='0', `Personalausweis`='0', `DonateRank`='0', `UpgradePoints`='0', `ConnectedTime`='0', `Registered`='1', `Geschlecht`='0', `Age`='0', `Origin`='0', `Muted`='0', `Respect`='0', `Gehalt`='0', `Money`='5000', `Bank`='0', `Jobgeld`='0', `Crimes`='0', `Kills`='0', `sKills`='0', `Deaths`='0', `Arrested`='0', `ArrestTime`='0', `PhoneBook`='0', `LottoNr`='0', `Fishes`='0', `BiggestFish`='0', `Job`='0', `HeadValue`='0', `Jailed`='0', `JailTime`='0', `Leader`='-1', `Member`='-1', `Rank`='0', `Skin`='26', `Vertragszeit`='5', `NewsSkill`='0', `FishSkill`='0', `MechSkill`='0', `pSHealth`='50.0', `PhoneNr`='1', `Hotel`='-1', `Biz`='-1', `CarLicense`='0', `FlyLicense`='0', `BoatLicense`='0', `FishLicense`='0', `GunLicense`='0', `Zollpass`='0', `GotMD5`='1' WHERE `Name`='James' " successfully executed within 83.790 milliseconds
[12:12:52] [DEBUG] CResultSet::Create(connection=0x6ace0e0, query_str='UPDATE `server_accounts` SET `Level`='1', `AdminLevel`='0', `Checkpoint`='0', `CPrison`='0', `RunningCP`='0', `TeamRadar`='0', `BNDRadar`='0', `StartCoints`='0', `Coints`='0', `SpawnhealZeit`='0', `DeaglespawnZeit`='0', `M4SpawnZeit`='0', `MP5SpawnZeit`='0', `MehrZinsenZeit`='0', `Tot`='0', `TotUnix`='0', `TotX`='0.000000', `TotY`='0.000000', `TotZ`='0.000000', `TotWorld`='0', `Medickit`='0', `Startbonus`='0', `Kreditkarte`='0', `KreditkarteBenutzung`='0', `Personalausweis`='0', `DonateRank`='0', `UpgradePoints`='0', `ConnectedTime`='0', `Registered`='1', `Geschlecht`='0', `Age`='0', `Origin`='0', `Muted`='0', `Respect`='0', `Gehalt`='0', `Money`='5000', `Bank`='0', `Jobgeld`='0', `Crimes`='0', `Kills`='0', `sKills`='0', `Deaths`='0', `Arrested`='0', `ArrestTime`='0', `PhoneBook`='0', `LottoNr`='0', `Fishes`='0', `BiggestFish`='0', `Job`='0', `HeadValue`='0', `Jailed`='0', `JailTime`='0', `Leader`='-1', `Member`='-1', `Rank`='0', `Skin`='26', `Vertragszeit`='5', `NewsSkill`='0', `FishSkill`='0', `MechSkill`='0', `pSHealth`='50.0', `PhoneNr`='1', `Hotel`='-1', `Biz`='-1', `CarLicense`='0', `FlyLicense`='0', `BoatLicense`='0', `FishLicense`='0', `GunLicense`='0', `Zollpass`='0', `GotMD5`='1' WHERE `Name`='James' ')
[12:12:52] [DEBUG] created new resultset '0x6aedee0'
[12:12:52] [DEBUG] fetched MySQL result '0x0'
[12:12:52] [INFO] query "UPDATE `server_accounts` SET `Gun1`='0', `Gun2`='0', `Gun3`='0', `Gun4`='0', `Ammo1`='0', `Ammo2`='0', `Ammo3`='0', `Ammo4`='0', `CarTime`='0', `PayDay`='0', `PayDayHad`='0', `CDPlayer`='0', `AlcoholPerk`='0', `PainKillerPerk`='0', `PistolSkill`='2', `MaschinePistolSkill`='2', `SturmgewehrPistolSkill`='2', `ShotGunSkill`='1', `DrugPerk`='0', `MiserPerk`='0', `TraderPerk`='0', `Tutorial`='0', `Cptut`='0', `Warnings`='0', `Fuel`='0', `Married`='0', `MarriedTo`='Niemand', `WantedLevel`='0', `Spawn`='0', `SavedMaterials`='0', `SavedDrugs`='0', `BikeLicense`='0', `LKWLicense`='0', `DonatorTime`='0', `WerberName`='Niemand', `FightingStyle`='0', `Handy`='0', `OnDutySkin`='60', `CarLicensePoints`='0', `BikeLicensePoints`='0', `InviteSperre`='0', `warntime1`='0', `warntime2`='0', `Ticketsopen`='0', `OldName`='Niemand', `ClientIP`='127.0.0.1', `OrgMember`='-1', `OrgLeader`='-1', `OrgManager`='-1', `OrgName`='Keine' WHERE `Name`='James'" successfully executed within 73.862 milliseconds
[12:12:52] [DEBUG] CResultSet::Create(connection=0x6ac4cf8, query_str='UPDATE `server_accounts` SET `Gun1`='0', `Gun2`='0', `Gun3`='0', `Gun4`='0', `Ammo1`='0', `Ammo2`='0', `Ammo3`='0', `Ammo4`='0', `CarTime`='0', `PayDay`='0', `PayDayHad`='0', `CDPlayer`='0', `AlcoholPerk`='0', `PainKillerPerk`='0', `PistolSkill`='2', `MaschinePistolSkill`='2', `SturmgewehrPistolSkill`='2', `ShotGunSkill`='1', `DrugPerk`='0', `MiserPerk`='0', `TraderPerk`='0', `Tutorial`='0', `Cptut`='0', `Warnings`='0', `Fuel`='0', `Married`='0', `MarriedTo`='Niemand', `WantedLevel`='0', `Spawn`='0', `SavedMaterials`='0', `SavedDrugs`='0', `BikeLicense`='0', `LKWLicense`='0', `DonatorTime`='0', `WerberName`='Niemand', `FightingStyle`='0', `Handy`='0', `OnDutySkin`='60', `CarLicensePoints`='0', `BikeLicensePoints`='0', `InviteSperre`='0', `warntime1`='0', `warntime2`='0', `Ticketsopen`='0', `OldName`='Niemand', `ClientIP`='127.0.0.1', `OrgMember`='-1', `OrgLeader`='-1', `OrgManager`='-1', `OrgName`='Keine' WHERE `Name`='James'')
[12:12:52] [DEBUG] created new resultset '0x6ae3170'
[12:12:52] [DEBUG] fetched MySQL result '0x0'

Alles anzeigen

Dr. Frauenarzt · 20. Mai 2018

Er greift garnicht zu.

Wie man laut Log sehen kann.

Spoiler anzeigen

Code

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


SA-MP Dedicated Server
----------------------
v0.3.7, (C)2005-2015 SA-MP Team


[11:17:07] filterscripts = ""  (string)
[11:17:07] password = ""  (string)
[11:17:07] 
[11:17:07] Server Plugins
[11:17:07] --------------
[11:17:07]  Loading plugin: crashdetect
[11:17:07]   CrashDetect plugin 4.19
[11:17:07]   Loaded.
[11:17:07]  Loading plugin: mysql
[11:17:07]  >> plugin.mysql: R41-4 successfully loaded.
[11:17:07]   Loaded.
[11:17:07]  Loading plugin: streamer
[11:17:07] 


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


[11:17:07]   Loaded.
[11:17:07]  Loading plugin: sscanf
[11:17:07] 


[11:17:07]  ===============================


[11:17:07]       sscanf plugin loaded.     


[11:17:07]          Version:  2.8.2        


[11:17:07]    (c) 2012 Alex "Y_Less" Cole  


[11:17:07]  ===============================


[11:17:07]   Loaded.
[11:17:07]  Loading plugin: Whirlpool
[11:17:07]  
[11:17:07]  ==================
[11:17:07]  
[11:17:07]   Whirlpool loaded
[11:17:07]  
[11:17:07]  ==================
[11:17:07]  
[11:17:07]   Loaded.
[11:17:07]  Loading plugin: FileManager
[11:17:07] ******************
[11:17:07] ** FILE MANAGER **
[11:17:07] **    Loaded    **
[11:17:07] ** Version 1.5 **
[11:17:07] ******************
[11:17:07]   Loaded.
[11:17:07]  Loaded 6 plugins.


[11:17:07] 
[11:17:07] Ban list
[11:17:07] --------
[11:17:07]  Loaded: samp.ban
[11:17:07] 
[11:17:07] 
[11:17:07] Filterscripts
[11:17:07] ---------------
[11:17:07]   Loaded 0 filterscripts.


[11:17:07] SERVER: Der Server wurde erfolgreich gestartet
[11:17:07] SERVER: Versucht die Verbindung zur Datenbank aufzubauen
[11:17:07] OnGamemodeInt: LoadBiz (0ms)
[11:17:07] OnGamemodeInt: LoadSBiz (0ms)
[11:17:07] OnGamemodeInt: LoadTankenBiz (0ms)
[11:17:07] OnGamemodeInt: LoadStuff (0ms)
[11:17:07] OnGamemodeInt: LoadKassenInfo (0ms)
[11:17:07] OnGamemodeInt: LoadGangfightZones (0ms)
[11:17:07] OnGamemodeInt: LoadGangWarInfos (1ms)
[11:17:07] OnGamemodeInt: LoadGangBNDInfos (0ms)
[11:17:07] OnGamemodeInt: loadDynamicPickups (0ms)
[11:17:07] OnGamemodeInt: loadDynamicMapIcons (0ms)
[11:17:07] OnGamemodeInt: loadDynamicTextLabels (0ms)
[11:17:07] OnGamemodeInt: loadGangWeapons (1ms)
[11:17:07] OnGamemodeInt: loadAmmuWeapons (0ms)
[11:17:07] OnGamemodeInt: loadHausWeapons (0ms)
[11:17:07] Totaltime taken to load MySQL Stuffs: 11sm
[11:17:07] Beginne Autos zu spawnen
[11:17:07] Autos wurden erfolgreich Geladen und Gespawnt
[11:17:07] 3DTexte erfolgreich Geladen
[11:17:07]  
[11:17:07]  
[11:17:07] Coming Soon
[11:17:07] _____________________
[11:17:07] Coming Soon erfolgreich geladen!
[11:17:07]  
[11:17:07] Number of vehicle models: 61
[11:17:07] [connection] 127.0.0.1:65055 requests connection cookie.
[11:17:07] [connection] 127.0.0.1:65056 requests connection cookie.
[11:17:07] [connection] 127.0.0.1:65057 requests connection cookie.
[11:17:07] [connection] 127.0.0.1:65058 requests connection cookie.
[11:17:08] [connection] 127.0.0.1:65059 requests connection cookie.
[11:17:08] [connection] 127.0.0.1:65060 requests connection cookie.
[11:17:08] [connection] 127.0.0.1:65061 requests connection cookie.
[11:17:08] [connection] 127.0.0.1:65062 requests connection cookie.
[11:17:08] Incoming connection: 127.0.0.1:65055 id: 0
[11:17:08] Incoming connection: 127.0.0.1:65056 id: 1
[11:17:08] Incoming connection: 127.0.0.1:65057 id: 2
[11:17:08] [npc:join] Drogendealer has joined the server (0:127.0.0.1)
[11:17:08] [npc:join] Mitarbeiter has joined the server (1:127.0.0.1)
[11:17:08] Incoming connection: 127.0.0.1:65058 id: 3
[11:17:09] Incoming connection: 127.0.0.1:65059 id: 4
[11:17:09] [npc:join] Coinshop has joined the server (2:127.0.0.1)
[11:17:09] [npc:join] Stadthalle has joined the server (3:127.0.0.1)
[11:17:09] Incoming connection: 127.0.0.1:65060 id: 5
[11:17:09] Incoming connection: 127.0.0.1:65061 id: 6
[11:17:09] [npc:join] BSN has joined the server (4:127.0.0.1)
[11:17:09] Incoming connection: 127.0.0.1:65062 id: 7
[11:17:09] [npc:join] Dimitri has joined the server (5:127.0.0.1)
[11:17:09] [npc:join] Manfred has joined the server (6:127.0.0.1)
[11:17:09] [npc:join] Nico has joined the server (7:127.0.0.1)

Alles anzeigen

Dr. Frauenarzt · 20. Mai 2018

Habe das nun so umgeändert der Server Crasht aber trd weiterhin und es werden keine Fahrzeuge geladen:

Um euch den Crash mal zu zeigen:

Spoiler anzeigen

Code

[10:43:23] [debug] Server crashed due to an unknown error
[10:43:23] [debug] Native backtrace:
[10:43:23] [debug] #0 004016eb in ?? () from samp-server.exe
[10:43:23] [debug] #1 5b9e35e9 in ?? () from plugins\mysql.DLL
[10:43:23] [debug] #2 5b9e6688 in ?? () from plugins\mysql.DLL
[10:43:23] [debug] #3 5b9cc52e in ?? () from plugins\mysql.DLL
[10:43:23] [debug] #4 5b9cdc7f in ?? () from plugins\mysql.DLL
[10:43:23] [debug] #5 5b9ce3d3 in ?? () from plugins\mysql.DLL
[10:43:23] [debug] #6 00469a26 in ?? () from samp-server.exe
[10:43:23] [debug] #7 0048ac5d in ?? () from samp-server.exe
[10:43:23] [debug] #8 00499bd1 in ?? () from samp-server.exe
[10:43:23] [debug] #9 00499be1 in ?? () from samp-server.exe
[10:43:23] [debug] Registers:
[10:43:23] [debug] EAX: 05deb668 EBX: 00000000 ECX: 05dff020 EDX: 00000008
[10:43:23] [debug] ESI: 00000038 EDI: ffffd8c2 EBP: 00499bd1 ESP: 0019fe98
[10:43:23] [debug] EIP: 00499be1 EFLAGS: 00010246
[10:43:23] [debug] Stack:
[10:43:23] [debug] ESP+00000000: 004a9b60 0019ff70 004a97d1 ffffffff
[10:43:23] [debug] ESP+00000020: 00000094 00000006 00000002 000023f0
[10:43:23] [debug] ESP+00000040: 00000000 00000000 00000000 00000000
[10:43:23] [debug] ESP+00000060: 00000000 00000000 00000000 00000000
[10:43:23] [debug] ESP+00000080: 00000000 00000000 00000000 00000000
[10:43:23] [debug] ESP+000000a0: 00000000 00000000 00000000 00000000
[10:43:23] [debug] ESP+000000c0: 00000000 00000000 c0000005 00000000
[10:43:23] [debug] ESP+000000e0: 004b68d0 00000000 0019ff94 755e8654
[10:43:23] [debug] ESP+00000100: 776a4b47 002c9000 cc8ee94f 00000000
[10:43:23] [debug] ESP+00000120: 00000000 00000000 cc8ee94f 0019ffa0
[10:43:23] [debug] ESP+00000140: 00000000 0019ffec 776a4b17 ffffffff
[10:43:23] [debug] ESP+00000160: 002c9000 00000000 78746341 00000020
[10:43:23] [debug] ESP+00000180: 00000020 00000000 00000014 00000001
[10:43:23] [debug] ESP+000001a0: 00000000 00000000 00000000 00000000
[10:43:23] [debug] ESP+000001c0: 00000044 000002e0 0000025c 00000000
[10:43:23] [debug] ESP+000001e0: 00000342 00000000 2d59495b 000008cc
[10:43:23] [debug] ESP+00000200: 32ceeacd 00000bfc 00000042 00000c40
[10:43:23] [debug] ESP+00000220: 0000005e 00000fd0 00000362 00000000
[10:43:23] [debug] ESP+00000240: 00000392 00000010 00000009 000000ec
[10:43:23] [debug] ESP+00000260: 00000001 00000002 00001758 000007a0
[10:43:23] [debug] ESP+00000280: 00000001 00000004 00002d84 00000314
[10:43:23] [debug] ESP+000002a0: 00000002 00000006 00003130 000000cc
[10:43:23] [debug] ESP+000002c0: 00000001 00000009 000032ec 00000028
[10:43:23] [debug] ESP+000002e0: 00000001 64487353 0000002c 00000001
[10:43:23] [debug] ESP+00000300: 00000001 000015a4 0000002c 0000005e
[10:43:23] [debug] ESP+00000320: 00000000 00000000 00000000 00000000
[10:43:23] [debug] ESP+00000340: 00000038 00000000 003a0043 0057005c
[10:43:23] [debug] ESP+00000360: 006e0069 00780053 005c0073 00000000
[10:43:23] [debug] ESP+00000380: 0000025c 00000001 f33271ba 000003c0
[10:43:23] [debug] ESP+000003a0: 2d59495b 00000750 00000032 00000784
[10:43:23] [debug] ESP+000003c0: 00000042 00000ac4 00000330 00000004
[10:43:23] [debug] ESP+000003e0: 00000362 00000005 b1280544 000011b8
[10:43:23] [debug] Loaded modules:
[10:43:23] [debug] 00400000 - 004fa000 samp-server.exe
[10:43:23] [debug] 77640000 - 777cd000 ntdll.dll
[10:43:23] [debug] 755d0000 - 756a0000 KERNEL32.DLL
[10:43:23] [debug] 74930000 - 74b07000 KERNELBASE.dll
[10:43:23] [debug] 76040000 - 77374000 SHELL32.dll
[10:43:23] [debug] 77580000 - 7763d000 msvcrt.dll
[10:43:23] [debug] 747f0000 - 74828000 cfgmgr32.dll
[10:43:23] [debug] 756a0000 - 757b7000 ucrtbase.dll
[10:43:23] [debug] 74b10000 - 74b98000 shcore.dll
[10:43:23] [debug] 75820000 - 758de000 RPCRT4.dll
[10:43:23] [debug] 74060000 - 74080000 SspiCli.dll
[10:43:23] [debug] 74050000 - 7405a000 CRYPTBASE.dll
[10:43:23] [debug] 74c60000 - 74cb7000 bcryptPrimitives.dll
[10:43:23] [debug] 74ba0000 - 74be3000 sechost.dll
[10:43:23] [debug] 745a0000 - 747e6000 combase.dll
[10:43:23] [debug] 758f0000 - 75eb6000 windows.storage.dll
[10:43:23] [debug] 74510000 - 74588000 advapi32.dll
[10:43:23] [debug] 748e0000 - 74925000 shlwapi.dll
[10:43:23] [debug] 748b0000 - 748d2000 GDI32.dll
[10:43:23] [debug] 77420000 - 7757f000 gdi32full.dll
[10:43:23] [debug] 741f0000 - 7426c000 msvcp_win.dll
[10:43:23] [debug] 75400000 - 75575000 USER32.dll
[10:43:23] [debug] 742d0000 - 742e6000 win32u.dll
[10:43:23] [debug] 755b0000 - 755be000 kernel.appcore.dll
[10:43:23] [debug] 75210000 - 75255000 powrprof.dll
[10:43:23] [debug] 751f0000 - 75204000 profapi.dll
[10:43:23] [debug] 63920000 - 63928000 WSOCK32.dll
[10:43:23] [debug] 74bf0000 - 74c56000 WS2_32.dll
[10:43:23] [debug] 73fe0000 - 74004000 WINMM.dll
[10:43:23] [debug] 73f50000 - 73f73000 WINMMBASE.dll
[10:43:23] [debug] 75580000 - 755a5000 IMM32.DLL
[10:43:23] [debug] 626c0000 - 62711000 crashdetect.DLL
[10:43:23] [debug] 62650000 - 626b9000 MSVCP100.dll
[10:43:23] [debug] 621a0000 - 6225f000 MSVCR100.dll
[10:43:23] [debug] 5b9c0000 - 5ba0e000 mysql.DLL
[10:43:23] [debug] 62bf0000 - 62c0a000 log-core.dll
[10:43:23] [debug] 5b8f0000 - 5b9bd000 libmariadb.dll
[10:43:23] [debug] 742f0000 - 74472000 CRYPT32.dll
[10:43:23] [debug] 758e0000 - 758ee000 MSASN1.dll
[10:43:23] [debug] 5b880000 - 5b8ed000 MSVCP140.dll
[10:43:23] [debug] 62630000 - 62645000 VCRUNTIME140.dll
[10:43:23] [debug] 72fb0000 - 72fba000 Secur32.dll
[10:43:23] [debug] 6dbd0000 - 6dbe1000 napinsp.dll
[10:43:23] [debug] 6dbb0000 - 6dbc6000 pnrpnsp.dll
[10:43:23] [debug] 6db90000 - 6dba3000 NLAapi.dll
[10:43:23] [debug] 6e440000 - 6e495000 mswsock.dll
[10:43:23] [debug] 72fc0000 - 73054000 DNSAPI.dll
[10:43:23] [debug] 74590000 - 74597000 NSI.dll
[10:43:23] [debug] 73fb0000 - 73fe0000 IPHLPAPI.DLL
[10:43:23] [debug] 6db80000 - 6db8c000 winrnr.dll
[10:43:23] [debug] 6db70000 - 6db80000 wshbth.dll
[10:43:23] [debug] 6dbf0000 - 6dbf8000 rasadhlp.dll
[10:43:23] [debug] 5b810000 - 5b877000 streamer.DLL
[10:43:23] [debug] 10000000 - 1000f000 sscanf.DLL
[10:43:23] [debug] 049e0000 - 049ec000 Whirlpool.DLL
[10:43:23] [debug] 5b770000 - 5b80b000 MSVCR80.dll
[10:43:23] [debug] 63910000 - 6391b000 FileManager.DLL
[10:43:23] [debug] 5ae50000 - 5aed5000 MSVCP110.dll
[10:43:23] [debug] 5aee0000 - 5afb7000 MSVCR110.dll
[10:43:23] [debug] 6db20000 - 6db6e000 fwpuclnt.dll
[10:43:23] [debug] 73530000 - 73549000 bcrypt.dll

Alles anzeigen

//E:

Den Crash habe nun gefixxt lag an was anderem.

Habe aber trd die Probleme mit den Fahrzeug Laden:

enum von den Fraktions Fahrzeugen:

Code

enum eFactionCars
{
	fDBID,
	fModel,
	fFaction,
	Float:fSpawnX,
	Float:fSpawnY,
	Float:fSpawnZ,
	Float:fSpawnA,
	fMod1, fMod2, fMod3, fMod4, fMod5,
	fMod6, fMod7, fMod8, fMod9, fMod10,
	fMod11, fMod12, fMod13, fMod14, fMod15,
	fMod16, fMod17,


	fColor1, fColor2,
	fTank, fStand, fDrogen,
	fGeld, fMats, fRang,
	fAbgeschlossen, fAbschleppzeit, fAbschleppname[50],


	fElement,
	bool:fChanged
};

Alles anzeigen

Die Funktion um die Fahrzeuge zu laden:

Code

PUBLIC:LoadFactionVehicles()
{
	new rows;
	cache_get_row_count(rows);
	new fv = 0;
	if(rows)
	{
		while(fv < rows)
		{
			cache_get_value_name_int(fv,"fID", FactionCarInfo[fv][fDBID]);
			cache_get_value_name_int(fv,"fModel", FactionCarInfo[fv][fModel]);
			cache_get_value_name_int(fv,"fFaction", FactionCarInfo[fv][fFaction]);
			cache_get_value_name_float(fv,"fSpawnX", FactionCarInfo[fv][fSpawnX]);
			cache_get_value_name_float(fv,"fSpawnY", FactionCarInfo[fv][fSpawnY]);
			cache_get_value_name_float(fv,"fSpawnZ", FactionCarInfo[fv][fSpawnZ]);
			cache_get_value_name_float(fv,"fSpawnA", FactionCarInfo[fv][fSpawnA]);
			cache_get_value_name_int(fv,"fMod1", FactionCarInfo[fv][fMod1]);
			cache_get_value_name_int(fv,"fMod2", FactionCarInfo[fv][fMod2]);
			cache_get_value_name_int(fv,"fMod3", FactionCarInfo[fv][fMod3]);
			cache_get_value_name_int(fv,"fMod4", FactionCarInfo[fv][fMod4]);
			cache_get_value_name_int(fv,"fMod5", FactionCarInfo[fv][fMod5]);
			cache_get_value_name_int(fv,"fMod6", FactionCarInfo[fv][fMod6]);
			cache_get_value_name_int(fv,"fMod7", FactionCarInfo[fv][fMod7]);
			cache_get_value_name_int(fv,"fMod8", FactionCarInfo[fv][fMod8]);
			cache_get_value_name_int(fv,"fMod9", FactionCarInfo[fv][fMod9]);
			cache_get_value_name_int(fv,"fMod10", FactionCarInfo[fv][fMod10]);
			cache_get_value_name_int(fv,"fMod11", FactionCarInfo[fv][fMod11]);
			cache_get_value_name_int(fv,"fMod12", FactionCarInfo[fv][fMod12]);
			cache_get_value_name_int(fv,"fMod13", FactionCarInfo[fv][fMod13]);
			cache_get_value_name_int(fv,"fMod14", FactionCarInfo[fv][fMod14]);
			cache_get_value_name_int(fv,"fMod15", FactionCarInfo[fv][fMod15]);
			cache_get_value_name_int(fv,"fMod16", FactionCarInfo[fv][fMod16]);
			cache_get_value_name_int(fv,"fMod17", FactionCarInfo[fv][fMod17]);
			cache_get_value_name_int(fv,"fColor1", FactionCarInfo[fv][fColor1]);
			cache_get_value_name_int(fv,"fColor2", FactionCarInfo[fv][fColor2]);
			cache_get_value_name_int(fv,"fTank", FactionCarInfo[fv][fTank]);
			cache_get_value_name_int(fv,"fStand", FactionCarInfo[fv][fStand]);
			cache_get_value_name_int(fv,"fDrogen", FactionCarInfo[fv][fDrogen]);
			cache_get_value_name_int(fv,"fGeld", FactionCarInfo[fv][fGeld]);
			cache_get_value_name_int(fv,"fMats", FactionCarInfo[fv][fMats]);
			cache_get_value_name_int(fv,"fRang", FactionCarInfo[fv][fRang]);
			cache_get_value_name_int(fv,"fAbgeschlossen", FactionCarInfo[fv][fAbgeschlossen]);
			cache_get_value_name_int(fv,"fAbschleppzeit", FactionCarInfo[fv][fAbschleppzeit]);


			FactionCarInfo[fv][fElement] = CreateVehicle(FactionCarInfo[fv][fModel], FactionCarInfo[fv][fSpawnX], FactionCarInfo[fv][fSpawnY], FactionCarInfo[fv][fSpawnZ], FactionCarInfo[fv][fSpawnA], FactionCarInfo[fv][fColor1], FactionCarInfo[fv][fColor2], -1);


			Meters[FactionCarInfo[fv][fElement]] = FactionCarInfo[fv][fStand];
			GetVehiclePos(FactionCarInfo[fv][fElement], FactionCarInfo[fv][fSpawnX], FactionCarInfo[fv][fSpawnY], FactionCarInfo[fv][fSpawnZ]);
			Gas[FactionCarInfo[fv][fElement]] = FactionCarInfo[fv][fTank];
			TuneFactionVehicle(fv);
			fv++;
        }
    }
    printf("[LOAD] Fraktions Fahrzeuge wurden geladen (%i/%i)", rows, MAX_TOTALFACTIONCARS);
	return 1;
}

Alles anzeigen

So werden Die Fahrzeuge eingespeichert in der Datenbank:

Code

PUBLIC:bool:CreateFactionVehicle(modelID, facID, Float:SpawnX, Float:SpawnY, Float:SpawnZ, Float:SpawnA, Color1, Color2)
{
    new bool:Return = false;

    if((modelID >= 400 && modelID <= 611))
    {
	    for(new i; i < MAX_TOTALFACTIONCARS; ++i)
	    {
	        if(FactionCarInfo[i][fDBID] != 0)
				continue;


	        new query[500];
			mysql_format(handle, query, sizeof(query), "INSERT INTO `faction_vehicles` (`fModel`, `fFaction`, `fSpawnX`, `fSpawnY`, `fSpawnZ`, `fSpawnA`, `fColor1`, `fColor2`, `fTank`, `fStand`, `fDrogen`, `fGeld`, `fMats`, `fRang`, `fAbgeschlossen`) VALUES (%d, %d, %.03f, %.03f, %.03f, %.03f, %d, %d, 100, 0, 0, 0, 0, 1, 0)",
			modelID, facID, SpawnX, SpawnY, SpawnZ, SpawnA, Color1, Color2);
			mysql_pquery(handle, query, "", "");

	        FactionCarInfo[i][fDBID]       = cache_insert_id();
			FactionCarInfo[i][fModel]      = modelID;
	        FactionCarInfo[i][fFaction]    = facID;


			FactionCarInfo[i][fSpawnX]     = SpawnX;
	        FactionCarInfo[i][fSpawnY]     = SpawnY;
	        FactionCarInfo[i][fSpawnZ]     = SpawnZ;
	        FactionCarInfo[i][fSpawnA]     = SpawnA;


	        FactionCarInfo[i][fColor1]     = Color1;
	        FactionCarInfo[i][fColor2]     = Color2;


	        FactionCarInfo[i][fTank]       = 100;
	        FactionCarInfo[i][fStand]      = 0;
	        FactionCarInfo[i][fDrogen]     = 0;
	        FactionCarInfo[i][fGeld]       = 0;
	        FactionCarInfo[i][fMats]       = 0;
	        FactionCarInfo[i][fRang]       = 1;
	        FactionCarInfo[i][fAbschleppzeit]=0;
	        FactionCarInfo[i][fAbgeschlossen]=0;
	        Meters[FactionCarInfo[i][fElement]] = 0;

	        Return = true;
	        break;
	    }
	}
	return Return;
}

Alles anzeigen

Dr. Frauenarzt · 20. Mai 2018

Hey,

Ich habe kurze Frage es wird ein uns kein Fraktions Fahrzeug geladen obwohl einige in der Datenbank vorhanden sind?

OnGamodeInit:

mysql_pquery(handle, "SELECT * FROM `faction_vehicles`","LoadFactionVehicles", "");

Code

PUBLIC:LoadFactionVehicles()
{
	new rows;
	cache_get_row_count(rows);
	new fv = 0;
	if(rows)
	{
		while(fv < rows)
		{
			cache_get_value_name_int(fv,"fID", FactionCarInfo[fv][fDBID]);
			cache_get_value_name_int(fv,"fModel", FactionCarInfo[fv][fModel]);
			cache_get_value_name_int(fv,"fFaction", FactionCarInfo[fv][fFaction]);
			cache_get_value_name_float(fv,"fSpawnX", FactionCarInfo[fv][fSpawnX]);
			cache_get_value_name_float(fv,"fSpawnY", FactionCarInfo[fv][fSpawnY]);
			cache_get_value_name_float(fv,"fSpawnZ", FactionCarInfo[fv][fSpawnZ]);
			cache_get_value_name_float(fv,"fSpawnA", FactionCarInfo[fv][fSpawnA]);
			cache_get_value_name_int(fv,"fMod1", FactionCarInfo[fv][fMod1]);
			cache_get_value_name_int(fv,"fMod2", FactionCarInfo[fv][fMod2]);
			cache_get_value_name_int(fv,"fMod3", FactionCarInfo[fv][fMod3]);
			cache_get_value_name_int(fv,"fMod4", FactionCarInfo[fv][fMod4]);
			cache_get_value_name_int(fv,"fMod5", FactionCarInfo[fv][fMod5]);
			cache_get_value_name_int(fv,"fMod6", FactionCarInfo[fv][fMod6]);
			cache_get_value_name_int(fv,"fMod7", FactionCarInfo[fv][fMod7]);
			cache_get_value_name_int(fv,"fMod8", FactionCarInfo[fv][fMod8]);
			cache_get_value_name_int(fv,"fMod9", FactionCarInfo[fv][fMod9]);
			cache_get_value_name_int(fv,"fMod10", FactionCarInfo[fv][fMod10]);
			cache_get_value_name_int(fv,"fMod11", FactionCarInfo[fv][fMod11]);
			cache_get_value_name_int(fv,"fMod12", FactionCarInfo[fv][fMod12]);
			cache_get_value_name_int(fv,"fMod13", FactionCarInfo[fv][fMod13]);
			cache_get_value_name_int(fv,"fMod14", FactionCarInfo[fv][fMod14]);
			cache_get_value_name_int(fv,"fMod15", FactionCarInfo[fv][fMod15]);
			cache_get_value_name_int(fv,"fMod16", FactionCarInfo[fv][fMod16]);
			cache_get_value_name_int(fv,"fMod17", FactionCarInfo[fv][fMod17]);
			cache_get_value_name_int(fv,"fColor1", FactionCarInfo[fv][fColor1]);
			cache_get_value_name_int(fv,"fColor2", FactionCarInfo[fv][fColor2]);
			cache_get_value_name_int(fv,"fTank", FactionCarInfo[fv][fTank]);
			cache_get_value_name_int(fv,"fStand", FactionCarInfo[fv][fStand]);
			cache_get_value_name_int(fv,"fDrogen", FactionCarInfo[fv][fDrogen]);
			cache_get_value_name_int(fv,"fGeld", FactionCarInfo[fv][fGeld]);
			cache_get_value_name_int(fv,"fMats", FactionCarInfo[fv][fMats]);
			cache_get_value_name_int(fv,"fRang", FactionCarInfo[fv][fRang]);
			cache_get_value_name_int(fv,"fAbgeschlossen", FactionCarInfo[fv][fAbgeschlossen]);
			cache_get_value_name_int(fv,"fAbschleppzeit", FactionCarInfo[fv][fAbschleppzeit]);


			FactionCarInfo[fv][fElement] = CreateVehicle(FactionCarInfo[fv][fModel], FactionCarInfo[fv][fSpawnX], FactionCarInfo[fv][fSpawnY], FactionCarInfo[fv][fSpawnZ], FactionCarInfo[fv][fSpawnA], FactionCarInfo[fv][fColor1], FactionCarInfo[fv][fColor2], -1);


			Meters[FactionCarInfo[fv][fElement]] = FactionCarInfo[fv][fStand];
			GetVehiclePos(FactionCarInfo[fv][fElement], FactionCarInfo[fv][fSpawnX], FactionCarInfo[fv][fSpawnY], FactionCarInfo[fv][fSpawnZ]);
			Gas[FactionCarInfo[fv][fElement]] = FactionCarInfo[fv][fTank];

			TuneFactionVehicle(fv);
			fv++;
        }
    }
    printf("[LOAD] Fraktions Fahrzeuge wurden geladen (%i/%i)", rows, MAX_TOTALFACTIONCARS);
	return 1;
}

Alles anzeigen

//E:

Es wird auch nicht angezeigt wieviel geladen wurden. also irgendwas stimmt hier nicht.

Habe auch versucht die einzelnen Punkte zu printen gibt er mir ebenso nichts aus.

Der fall ist aber das es seid dem ich das so habe nach 1-2 mal vor kommt das er mir Crash codes im log anzeigt.

Dr. Frauenarzt · 19. Mai 2018

Der Teil sollte nach Der Regestration auftreten.

Code

case 2:
		{
		    new count;
			cache_get_row_count(count);
			if(count)
			{
				new query[64+MAX_PLAYER_NAME+1];
				mysql_format(handle, query, sizeof(query), "SELECT * FROM `users` WHERE `Name` = '%s'", SpielerName(playerid));
 				mysql_pquery(handle, query, "LoadPlayerDataSequence", "dd", playerid, 3);
 				print("Ich werde aufgerufen....");
			}
			else
			{
				pPassAttempt[playerid] ++;
				if(pPassAttempt[playerid] >= 3)
				{
					SendClientMessage(playerid, COLOR_WHITE, "{9AB3D0}Du wurdest vom Server gekickt, da du dein Passwort zu oft falsch eingegeben hast.");
					Kick(playerid);
					return 1;
				}
                ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Coming Soon", "{FFEE00}Falsches Passwort\n\n{FFFFFF}Willkommen auf "SERVER_NAME"\n\nDein Account wurde in der Datenbank gefunden.\nGib dein Passwort niemals weiter. Auch nicht an Admins oder Supporter!\nDu kannst dich nun einloggen. Bitte gib dein Passwort ein:","OK"," ");
				return 1;
			}
		}

Alles anzeigen

Aber es passiert danach garnichts..
Relogge ich funktioniert alles.
Aber man sollte ja nicht jedes mal Reloggen das es weiter geht.

OnDialogResponse:

Code

else if(dialogid == DIALOG_REGISTER)
	{
		if(response)
		{
			if(strlen(inputtext) < 6)
			{
				ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Coming Soon", "{FFFFFF}Das Passwort muss mindestens eine Länge von 6 Zeichen haben.\n\nWillkommen auf "SERVER_NAME"\n\nDein Account wurde in der Datenbank gefunden.\nGib dein Passwort niemals weiter. Auch nicht an Admins oder Supporter!\nDu kannst dich nun einloggen. Bitte gib dein Passwort ein:","Erstellen","");
				return 1;
			}
			new query[256];
			new wHash[129];
			WP_Hash(wHash, sizeof(wHash), inputtext);
			mysql_format(handle, query, sizeof(query), "INSERT INTO `users` (`Name`, `NewPassword`) VALUES ('%s', '%e')",  SpielerName(playerid), wHash);
			mysql_pquery(handle, query);
			PlayerPlaySound(playerid, 1188, 0.0, 0.0, 0.0);
			OnPlayerRegister(playerid);
		}
		if(!response)
		{
			Kick(playerid);
			return 1;
		}
	}
	else if(dialogid == DIALOG_LOGIN)
	{
		if(response)
		{
			if(!strlen(inputtext))
			{
				pPassAttempt[playerid] ++;
				if(pPassAttempt[playerid] >= 3)
				{
					SendClientMessage(playerid, COLOR_WHITE, "{9AB3D0}Du wurdest vom Server gekickt, da du dein Passwort zu oft falsch eingegeben hast.");
					Kick(playerid);
					return 1;
				}
                ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Coming Soon", "{FFEE00}Falsches Passwort\n\n{FFFFFF}Willkommen auf "SERVER_NAME"\n\nDein Account wurde in der Datenbank gefunden.\nGib dein Passwort niemals weiter. Auch nicht an Admins oder Supporter!\nDu kannst dich nun einloggen. Bitte gib dein Passwort ein:","OK"," ");
				return 1;
			}
			new query[256];
			if(GotMD5[playerid] == 0){
				mysql_format(handle, query, sizeof(query), "SELECT * FROM `users` WHERE `Name` = '%s' AND `Password` = MD5('%s')", SpielerName(playerid), inputtext);
				mysql_pquery(handle, query, "LoadPlayerDataSequence", "dd", playerid, 2);


			}else{
				new wHash[129];
				WP_Hash(wHash, sizeof(wHash), inputtext);
				mysql_format(handle, query, sizeof(query), "SELECT * FROM `users` WHERE `Name` = '%s' AND `NewPassword` ='%e'", SpielerName(playerid), wHash);
				mysql_pquery(handle, query, "LoadPlayerDataSequence", "dd", playerid, 2);
			}
		}
		if(!response)
		{
			Kick(playerid);
			return 1;
		}
		return 1;
	}

Alles anzeigen

//E:

Für normalerweiße regestrieren geht die schleife weiter und zeigt das Login fenster an aber das macht er ja nicht.

Dr. Frauenarzt · 18. Mai 2018

Zitat von Jeffry

Das Kennzeichen wird vor dem Erstellen des Fahrzeugs gesetzt. Es muss danach gesetzt werden, davor existiert das Fahrzeug ja noch nicht.

Bereits aufgefallen aber dies wird trd nicht gesetzt der rest funktioniert.

Code

ocmd:veh(playerid, params[])
{
	new vID, color1, color2, Float:x, Float:y, Float:z, Float:rot, index = 0;
	if(PlayerInfo[playerid][pAdmin] < 4)return SendClientMessage(playerid, COLOR_WHITE, ERROR_ADMIN);
	if(sscanf(params, "iii", vID, color1, color2))return SendClientMessage(playerid, COLOR_WHITE, "{247BA6}* Benutze: {00FF00}/veh [Model-ID] [Farbe 1] [Farbe 2]");
	if(vID < 400 || vID > 611)return SendClientMessage(playerid, COLOR_WHITE, "{AFAFAF}Model ID muss zwischen 400 und 611 liegen.");
	if(color1 < 0 || color1 > 255)return SendClientMessage(playerid, COLOR_WHITE, "{AFAFAF}Farbe 1 muss zwischen 0 und 255 liegen.");
	if(color2 < 0 || color2 > 255)return SendClientMessage(playerid, COLOR_WHITE, "{AFAFAF}Farbe 2 muss zwischen 0 und 255 liegen.");
	GetPlayerPos(playerid, x, y, z);
	new Interior = GetPlayerInterior(playerid);
	GetPlayerFacingAngle(playerid, rot);
	for(new a=0;a<MAX_ADMINVEHS;a++)
	{
		if(spawnedVeh[a] != INVALID_VEHICLE_ID)index++;
	}
	if(index == MAX_ADMINVEHS)return SendClientMessage(playerid, COLOR_WHITE, "{AFAFAF}Die maximale Anzahl der erstellbaren Fahrzeuge wurde erreicht.");
	for(new a=0;a<MAX_ADMINVEHS;a++)
	{
		if(spawnedVeh[a] == INVALID_VEHICLE_ID)
		{
			spawnedVeh[a] = CreateVehicle(vID, x, y, z, rot, color1, color2, -1);
			PutPlayerInVehicle(playerid, spawnedVeh[a], 0);
			LinkVehicleToInterior(spawnedVeh[a], Interior);

			Meters[spawnedVeh[a]] = 0;
			Gas[spawnedVeh[a]] = 100;

			new playerName[MAX_PLAYER_NAME+1], nPlate[32];
			GetPlayerName(playerid, playerName, sizeof(playerName));
			format(nPlate, sizeof(nPlate), "%s", playerName);
			SetVehicleNumberPlate(spawnedVeh[a], nPlate);
			break;
		}
	}
	return 1;
}

Alles anzeigen

Dr. Frauenarzt · 18. Mai 2018

Hey,

Habe eine Kurze frage warum wird nicht der Name gesetzt als kennzeichen der das Fahrzeug gespawnt hat?

Code

ocmd:veh(playerid, params[])
{
	new vID, color1, color2, Float:x, Float:y, Float:z, Float:rot, index = 0;
	if(PlayerInfo[playerid][pAdmin] < 4)return SendClientMessage(playerid, COLOR_WHITE, ERROR_ADMIN);
	if(sscanf(params, "iii", vID, color1, color2))return SendClientMessage(playerid, COLOR_WHITE, "{247BA6}* Benutze: {00FF00}/veh [Model-ID] [Farbe 1] [Farbe 2]");
	if(vID < 400 || vID > 611)return SendClientMessage(playerid, COLOR_WHITE, "{AFAFAF}Model ID muss zwischen 400 und 611 liegen.");
	if(color1 < 0 || color1 > 255)return SendClientMessage(playerid, COLOR_WHITE, "{AFAFAF}Farbe 1 muss zwischen 0 und 255 liegen.");
	if(color2 < 0 || color2 > 255)return SendClientMessage(playerid, COLOR_WHITE, "{AFAFAF}Farbe 2 muss zwischen 0 und 255 liegen.");
	GetPlayerPos(playerid, x, y, z);
	new Interior = GetPlayerInterior(playerid);
	GetPlayerFacingAngle(playerid, rot);
	for(new a=0;a<MAX_ADMINVEHS;a++)
	{
		if(spawnedVeh[a] != INVALID_VEHICLE_ID)index++;
	}
	if(index == MAX_ADMINVEHS)return SendClientMessage(playerid, COLOR_WHITE, "{AFAFAF}Die maximale Anzahl der erstellbaren Fahrzeuge wurde erreicht.");
	for(new a=0;a<MAX_ADMINVEHS;a++)
	{
		if(spawnedVeh[a] == INVALID_VEHICLE_ID)
		{
			Meters[spawnedVeh[a]] = 0;
			Gas[spawnedVeh[a]] = 100;

			new playerName[MAX_PLAYER_NAME+1], nPlate[32];
			GetPlayerName(playerid, playerName, sizeof(playerName));

			format(nPlate, sizeof(nPlate), "%s", playerName);
			SetVehicleNumberPlate(spawnedVeh[a], nPlate);

			spawnedVeh[a] = CreateVehicle(vID, x, y, z, rot, color1, color2, -1);
			PutPlayerInVehicle(playerid, spawnedVeh[a], 0);
			LinkVehicleToInterior(spawnedVeh[a], Interior);
			break;
		}
	}
	return 1;
}

Alles anzeigen

Dr. Frauenarzt · 18. Mai 2018

Kurze Frage Login/Register Funktioniert einwandfrei jetzt habe das soweit sogut jetzt hin bekommen.

Aber wen der Sich regestriert wird der case 3 nicht abgerufen? warum

https://pastebin.com/qQvCPZ6S

Dr. Frauenarzt · 18. Mai 2018

OK,

Verstehe nicht wieso der das nicht so wirklich alles übernimmt....
Habe mir extra Zeit gelassen und alles sauber ausgearbeitet und geschrieben.

Spoiler anzeigen

Code

PUBLIC:PlayerUpdate(playerid)
{
    new mainQuery[3046], secondQuery[3046];
	if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
	{
		mysql_format(handle, secondQuery, sizeof(secondQuery), "UPDATE `users` SET `Level`='%d', `AdminLevel`='%d', `Checkpoint`='%d', `CPrison`='%d', `RunningCP`='%d', `TeamRadar`='%d', `BNDRadar`='%d', `Rolex`='%d', `Swissonic`='%d', `Casio`='%d', ",
		PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], CCP[playerid], xPrison[playerid], RunningCP[playerid],
		TeamRadar[playerid], BNDRadar[playerid], PlayerInfo[playerid][pRolex], PlayerInfo[playerid][pSwissonic], PlayerInfo[playerid][pCasio]);
		strcat(mainQuery, secondQuery);


		mysql_format(handle, secondQuery, sizeof(secondQuery), "`Breitling`='%d', `Nixon`='%d', `IceWatch`='%d', `StartCoints`='%d', `Coints`='%d', `SpawnhealZeit`='%d', `DeaglespawnZeit`='%d', `M4SpawnZeit`='%d', `MP5SpawnZeit`='%d', `MehrZinsenZeit`='%d', ",
		PlayerInfo[playerid][pBreitling], PlayerInfo[playerid][pNixon], PlayerInfo[playerid][pIceWatch], PlayerInfo[playerid][pStartCoints], PlayerInfo[playerid][pCoints],
		PlayerInfo[playerid][pSpawnhealZeit], PlayerInfo[playerid][pDeaglespawnZeit], PlayerInfo[playerid][pM4SpawnZeit], PlayerInfo[playerid][pMP5SpawnZeit], PlayerInfo[playerid][pMehrZinsenZeit]);
		strcat(mainQuery, secondQuery);


		mysql_format(handle, secondQuery, sizeof(secondQuery), "`Medickit`='%d', `Startbonus`='%d', `Kreditkarte`='%d', `KreditkarteBenutzung`='%d', `Personalausweis`='%d', `Namechange`='%d', `DonateRank`='%d', `UpgradePoints`='%d', `ConnectedTime`='%d', `Registered`='%d', ",
		PlayerInfo[playerid][pMedickit], PlayerInfo[playerid][pStartbonus], PlayerInfo[playerid][pKreditkarte], PlayerInfo[playerid][pKreditkartebenutzen], PlayerInfo[playerid][pPersonalausweis],
		PlayerInfo[playerid][pSchongeandert], PlayerInfo[playerid][pDonatorRank], PlayerInfo[playerid][gPupgrade], PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pReg]);
		strcat(mainQuery, secondQuery);


		mysql_format(handle, secondQuery, sizeof(secondQuery), "`Sex`='%d', `Age`='%d', `Origin`='%d', `Muted`='%d', `Respect`='%d', `Gehalt`='%d', `Money`='%d', `Bank`='%d', `Jobgeld`='%d', `Crimes`='%d', ",
		PlayerInfo[playerid][pSex], PlayerInfo[playerid][pAlter], PlayerInfo[playerid][pOrigin], PlayerInfo[playerid][pMuted], PlayerInfo[playerid][pRespekt],
		PlayerInfo[playerid][pGehalt], PlayerInfo[playerid][pCash], PlayerInfo[playerid][pBank], PlayerInfo[playerid][pJobLohn], PlayerInfo[playerid][pCrimes]);
		strcat(mainQuery, secondQuery);


		mysql_format(handle, secondQuery, sizeof(secondQuery), "`Kills`='%d', `sKills`='%d', `Deaths`='%d', `Arrested`='%d', `ArrestTime`='%d', `PhoneBook`='%d', `LottoNr`='%d', `Fishes`='%d', `BiggestFish`='%d', `Job`='%d', ",
		PlayerInfo[playerid][pKills], PlayerInfo[playerid][psKills], PlayerInfo[playerid][pDeaths], PlayerInfo[playerid][pArrested], PlayerInfo[playerid][pArrestTime],
		PlayerInfo[playerid][pPhoneBook], PlayerInfo[playerid][pLottoNr], PlayerInfo[playerid][pFishes], PlayerInfo[playerid][pBiggestFish], PlayerInfo[playerid][pJob]);
		strcat(mainQuery, secondQuery);


		mysql_format(handle, secondQuery, sizeof(secondQuery), "`HeadValue`='%d', `Jailed`='%d', `JailTime`='%d', `Leader`='%d', `Member`='%d', `Rank`='%d', `Skin`='%d', `Vertragszeit`='%d', ",
		PlayerInfo[playerid][pHeadValue], PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pMember],
		PlayerInfo[playerid][pRank], PlayerInfo[playerid][pChar], PlayerInfo[playerid][pVertragszeit]);
		strcat(mainQuery, secondQuery);


		mysql_format(handle, secondQuery, sizeof(secondQuery), "`NewsSkill`='%d', `House`='%d', `Mieten`='%d', `HealPaket`='%d', `ArmourPaket`='%d', `WaffenPaket`='%d', `OverHealPaket`='%d', `FishSkill`='%d', `MechSkill`='%d', `pSHealth`='%.1f', ",
		PlayerInfo[playerid][pNewsSkill], PlayerInfo[playerid][pHaus], PlayerInfo[playerid][pMieten], PlayerInfo[playerid][pHealPaket], PlayerInfo[playerid][pArmourPaket],
		PlayerInfo[playerid][pWaffenPaket], PlayerInfo[playerid][pOverHealPaket], PlayerInfo[playerid][pFishSkill], PlayerInfo[playerid][pMechSkill], PlayerInfo[playerid][pSHealth]);
		strcat(mainQuery, secondQuery);


		mysql_format(handle, secondQuery, sizeof(secondQuery), "`PhoneNr`='%d', `Hotel`='%d', `Biz`='%d', `CarLic`='%d', `FlyLic`='%d', `BoatLic`='%d', `FishLic`='%d', `GunLic`='%d', `Zollpass`='%d', `GotMD5`='%d' WHERE `Name`='%s' ",
		PlayerInfo[playerid][pNummer], PlayerInfo[playerid][pPhotelkey], PlayerInfo[playerid][pBizKey], PlayerInfo[playerid][pCarLic], PlayerInfo[playerid][pFlyLic],
		PlayerInfo[playerid][pBoatLic], PlayerInfo[playerid][pFishLic], PlayerInfo[playerid][pGunLic], PlayerInfo[playerid][pZollpass], GotMD5[playerid], SpielerName(playerid));
		strcat(mainQuery, secondQuery);


		mysql_pquery(handle, mainQuery, "", "");
		//print(mainQuery);
		strdel(mainQuery, 0, sizeof(mainQuery));
		strdel(secondQuery, 0, sizeof(secondQuery));
		mysql_format(handle, secondQuery, sizeof(secondQuery), "UPDATE `users` SET `Gun1`='%d', `Gun2`='%d', `Gun3`='%d', `Gun4`='%d', `Ammo1`='%d', `Ammo2`='%d', `Ammo3`='%d', `Ammo4`='%d', `CarTime`='%d', `PayDay`='%d', ",
		PlayerInfo[playerid][pGun1], PlayerInfo[playerid][pGun2], PlayerInfo[playerid][pGun3], PlayerInfo[playerid][pGun4], PlayerInfo[playerid][pAmmo1],
		PlayerInfo[playerid][pAmmo2], PlayerInfo[playerid][pAmmo3], PlayerInfo[playerid][pAmmo4], PlayerInfo[playerid][pCarTime], PlayerInfo[playerid][pPayDay]);
		mysql_format(handle, secondQuery, sizeof(secondQuery), "`PayDayHad`='%d', `CDPlayer`='%d', `AlcoholPerk`='%d', `PainKillerPerk`='%d', `PistolSkill`='%d', `MaschinePistolSkill`='%d', `SturmgewehrPistolSkill`='%d', `ShotGunSkill`='%d', `DrugPerk`='%d', `MiserPerk`='%d', ",
		PlayerInfo[playerid][pPayDayHad], PlayerInfo[playerid][pCDPlayer], PlayerInfo[playerid][pAlcoholPerk], PlayerInfo[playerid][pPainKillerPerk], PlayerInfo[playerid][pPistolSkill],
		PlayerInfo[playerid][pMaschinePistolSkill], PlayerInfo[playerid][pSturmgewehrPistolSkill], PlayerInfo[playerid][pShotGunSkill], PlayerInfo[playerid][pDrugPerk], PlayerInfo[playerid][pMiserPerk]);


		mysql_format(handle, secondQuery, sizeof(secondQuery), "%s`TraderPerk`='%d', `Tutorial`='%d', `Cptut`='%d', `kh`='%d', `Warnings`='%d', `Fuel`='%d', `Married`='%d', `MarriedTo`='%s', `WantedLevel`='%d', `Spawn`='%d' WHERE `Name`='%s' ", secondQuery,
        PlayerInfo[playerid][pTraderPerk], PlayerInfo[playerid][pTut], PlayerInfo[playerid][pCPTUT], PlayerInfo[playerid][pKHTIME], PlayerInfo[playerid][pWarns],
        PlayerInfo[playerid][pFuel], PlayerInfo[playerid][pMarried], PlayerInfo[playerid][pMarriedTo], PlayerInfo[playerid][pWantedLevel], PlayerInfo[playerid][pSpawn], SpielerName(playerid));
		mysql_pquery(handle, secondQuery, "", "");
		print(secondQuery);
		strdel(mainQuery, 0, sizeof(mainQuery));
		strdel(secondQuery, 0, sizeof(secondQuery));
	}
	return 1;
}

Alles anzeigen

Dr. Frauenarzt · 18. Mai 2018

Hab ein Problem das die Speicherung nicht wirklich funktioniert.

Laut Log wird es gepeichert abre in der Datenbank steht 0?

Code

[20:03:49] `PayDayHad`='0', `CDPlayer`='0', `AlcoholPerk`='0', `PainKillerPerk`='0', `PistolSkill`='0', `MaschinePistolSkill`='0', `SturmgewehrPistolSkill`='0', `ShotGunSkill`='0', `DrugPerk`='0', `MiserPerk`='0', `TraderPerk`='0', `Tutorial`='1', `Cptut`='1', `kh`='0', `Warnings`='0', `Fuel`='0', `Married`='0', `MarriedTo`='Niemand', `WantedLevel`='0', `Spawn`='0' WHERE `Name`='James.Gordon'

Code:

Code

mysql_format(handle, secondQuery, sizeof(secondQuery), "%s`TraderPerk`='%d', `Tutorial`='%d', `Cptut`='%d', `kh`='%d', `Warnings`='%d', `Fuel`='%d', `Married`='%d', `MarriedTo`='%s', `WantedLevel`='%d', `Spawn`='%d' WHERE `Name`='%s' ", secondQuery,
        PlayerInfo[playerid][pTraderPerk], PlayerInfo[playerid][pTut], PlayerInfo[playerid][pCPTUT], PlayerInfo[playerid][pKHTIME], PlayerInfo[playerid][pWarns],
        PlayerInfo[playerid][pFuel], PlayerInfo[playerid][pMarried], PlayerInfo[playerid][pMarriedTo], PlayerInfo[playerid][pWantedLevel], PlayerInfo[playerid][pSpawn], SpielerName(playerid));

Das Spuckt er per Mysql Log auf:

Spoiler anzeigen

Code

[20:03:49] [DEBUG] mysql_format(1, 0x069D9F70, 3046, "UPDATE `users` SET `Level`='%d', `AdminLevel`='%d', `Checkpoint`='%d', `CPrison`='%d', `RunningCP`='%d', `TeamRadar`='%d', `BNDRadar`='%d', `Rolex`='%d', `Swissonic`='%d', `Casio`='%d', ")
[20:03:49] [DEBUG] mysql_format: return value: '176'
[20:03:49] [DEBUG] mysql_format(1, 0x069D9F70, 3046, "`Breitling`='%d', `Nixon`='%d', `IceWatch`='%d', `StartCoints`='%d', `Coints`='%d', `SpawnhealZeit`='%d', `DeaglespawnZeit`='%d', `M4SpawnZeit`='%d', `MP5SpawnZeit`='%d', `MehrZinsenZeit`='%d', ")
[20:03:49] [DEBUG] mysql_format: return value: '184'
[20:03:49] [DEBUG] mysql_format(1, 0x069D9F70, 3046, "`Medickit`='%d', `Startbonus`='%d', `Kreditkarte`='%d', `KreditkarteBenutzung`='%d', `Personalausweis`='%d', `Namechange`='%d', `DonateRank`='%d', `UpgradePoints`='%d', `ConnectedTime`='%d', `Registered`='%d', ")
[20:03:49] [DEBUG] mysql_format: return value: '201'
[20:03:49] [DEBUG] mysql_format(1, 0x069D9F70, 3046, "`Sex`='%d', `Age`='%d', `Origin`='%d', `Muted`='%d', `Respect`='%d', `Gehalt`='%d', `Money`='%d', `Bank`='%d', `Jobgeld`='%d', `Crimes`='%d', ")
[20:03:49] [DEBUG] mysql_format: return value: '136'
[20:03:49] [DEBUG] mysql_format(1, 0x069D9F70, 3046, "`Kills`='%d', `sKills`='%d', `Deaths`='%d', `Arrested`='%d', `ArrestTime`='%d', `PhoneBook`='%d', `LottoNr`='%d', `Fishes`='%d', `BiggestFish`='%d', `Job`='%d', ")
[20:03:49] [DEBUG] mysql_format: return value: '151'
[20:03:49] [DEBUG] mysql_format(1, 0x069D9F70, 3046, "`HeadValue`='%d', `Jailed`='%d', `JailTime`='%d', `Leader`='%d', `Member`='%d', `Rank`='%d', `Skin`='%d', `Vertragszeit`='%d', ")
[20:03:49] [DEBUG] mysql_format: return value: '122'
[20:03:49] [DEBUG] mysql_format(1, 0x069D9F70, 3046, "`NewsSkill`='%d', `House`='%d', `Mieten`='%d', `HealPaket`='%d', `ArmourPaket`='%d', `WaffenPaket`='%d', `OverHealPaket`='%d', `FishSkill`='%d', `MechSkill`='%d', `pSHealth`='%.1f', ")
[20:03:49] [DEBUG] mysql_format: return value: '173'
[20:03:49] [DEBUG] mysql_format(1, 0x069D9F70, 3046, "`PhoneNr`='%d', `Hotel`='%d', `Biz`='%d', `CarLic`='%d', `FlyLic`='%d', `BoatLic`='%d', `FishLic`='%d', `GunLic`='%d', `Zollpass`='%d', `GotMD5`='%d' WHERE `Name`='%s' ")
[20:03:49] [DEBUG] mysql_format: return value: '170'
[20:03:49] [DEBUG] mysql_pquery(1, "UPDATE `users` SET `Level`='1', `AdminLevel`='0', `Checkpoint`='0', `CPrison`='0', `RunningCP`='0', `TeamRadar`='0', `BNDRadar`='0', `Rolex`='0', `Swissonic`='0', `Casio`='0', `Breitling`='0', `Nixon`='0', `IceWatch`='0', `StartCoints`='0', `Coints`='0', `SpawnhealZeit`='0', `DeaglespawnZeit`='0', `M4SpawnZeit`='0', `MP5SpawnZeit`='0', `MehrZinsenZeit`='0', `Medickit`='0', `Startbonus`='0', `Kreditkarte`='0', `KreditkarteBenutzung`='0', `Personalausweis`='1', `Namechange`='57', `DonateRank`='0', `UpgradePoints`='0', `ConnectedTime`='0', `Registered`='1', `Sex`='1', `Age`='21', `Origin`='1', `Muted`='0', `Respect`='0', `Gehalt`='0', `Money`='4990', `Bank`='0', `Jobgeld`='0', `Crimes`='0', `Kills`='0', `sKills`='0', `Deaths`='0', `Arrested`='0', `ArrestTime`='0', `PhoneBook`='0', `LottoNr`='0', `Fishes`='0', `BiggestFish`='0', `Job`='0', `HeadValue`='0', `Jailed`='0', `JailTime`='0', `Leader`='-1', `Member`='-1', `Rank`='0', `Skin`='26', `Vertragszeit`='5', `NewsSkill`='0', `House`='0', `Mieten`='0', `HealPaket`='0', `ArmourPaket`='0', `WaffenPaket`='0', `OverHealPaket`='0', `FishSkill`='0', `MechSkill`='0', `pSHealth`='50.0', `PhoneNr`='1', `Hotel`='-1', `Biz`='-1', `CarLic`='0', `FlyLic`='0', `BoatLic`='0', `FishLic`='0', `GunLic`='0', `Zollpass`='0', `GotMD5`='1' WHERE `Name`='James.Gordon' ", "", "")
[20:03:49] [DEBUG] CCallback::Create(amx=0x4af30c8, name='', format='', params=0x69d9f5c, param_offset=5)
[20:03:49] [DEBUG] CHandle::Execute(this=0x6b75e18, type=2, query=0x6c1ef08)
[20:03:49] [DEBUG] CConnectionPool::Queue(query=0x6c1ef08, this=0x271c3e8)
[20:03:49] [DEBUG] CHandle::Execute - return value: true
[20:03:49] [DEBUG] mysql_pquery: return value: '1'
[20:03:49] [DEBUG] CConnection::Execute(query=0x6c1ef08, this=0x71df020, connection=0x6bf7860)
[20:03:49] [DEBUG] mysql_format(1, 0x069D9F70, 3046, "UPDATE `users` SET `Gun1`='%d', `Gun2`='%d', `Gun3`='%d', `Gun4`='%d', `Ammo1`='%d', `Ammo2`='%d', `Ammo3`='%d', `Ammo4`='%d', `CarTime`='%d', `PayDay`='%d', ")
[20:03:49] [DEBUG] CQuery::Execute(this=0x6c1ef08, connection=0x6bf7860)
[20:03:49] [DEBUG] mysql_format: return value: '148'
[20:03:49] [DEBUG] mysql_format(1, 0x069D9F70, 3046, "`PayDayHad`='%d', `CDPlayer`='%d', `AlcoholPerk`='%d', `PainKillerPerk`='%d', `PistolSkill`='%d', `MaschinePistolSkill`='%d', `SturmgewehrPistolSkill`='%d', `ShotGunSkill`='%d', `DrugPerk`='%d', `MiserPerk`='%d', ")
[20:03:49] [DEBUG] mysql_format: return value: '203'
[20:03:49] [DEBUG] mysql_format(1, 0x069D9F70, 3046, "%s`TraderPerk`='%d', `Tutorial`='%d', `Cptut`='%d', `kh`='%d', `Warnings`='%d', `Fuel`='%d', `Married`='%d', `MarriedTo`='%s', `WantedLevel`='%d', `Spawn`='%d' WHERE `Name`='%s' ")
[20:03:49] [DEBUG] mysql_format: return value: '385'
[20:03:49] [DEBUG] mysql_pquery(1, "`PayDayHad`='0', `CDPlayer`='0', `AlcoholPerk`='0', `PainKillerPerk`='0', `PistolSkill`='0', `MaschinePistolSkill`='0', `SturmgewehrPistolSkill`='0', `ShotGunSkill`='0', `DrugPerk`='0', `MiserPerk`='0', `TraderPerk`='0', `Tutorial`='1', `Cptut`='1', `kh`='0', `Warnings`='0', `Fuel`='0', `Married`='0', `MarriedTo`='Niemand', `WantedLevel`='0', `Spawn`='0' WHERE `Name`='James.Gordon' ", "", "")
[20:03:49] [DEBUG] CCallback::Create(amx=0x4af30c8, name='', format='', params=0x69d9f5c, param_offset=5)
[20:03:49] [DEBUG] CHandle::Execute(this=0x6b75e18, type=2, query=0x6c1efa0)
[20:03:49] [DEBUG] CConnectionPool::Queue(query=0x6c1efa0, this=0x271c3e8)
[20:03:49] [DEBUG] CConnection::Execute(query=0x6c1efa0, this=0x7005020, connection=0x6bee2a0)
[20:03:49] [DEBUG] CQuery::Execute(this=0x6c1efa0, connection=0x6bee2a0)
[20:03:49] [DEBUG] CHandle::Execute - return value: true
[20:03:49] [DEBUG] mysql_pquery: return value: '1'
[20:03:49] [ERROR] error #1064 while executing query "`PayDayHad`='0', `CDPlayer`='0', `AlcoholPerk`='0', `PainKillerPerk`='0', `PistolSkill`='0', `MaschinePistolSkill`='0', `SturmgewehrPistolSkill`='0', `ShotGunSkill`='0', `DrugPerk`='0', `MiserPerk`='0', `TraderPerk`='0', `Tutorial`='1', `Cptut`='1', `kh`='0', `Warnings`='0', `Fuel`='0', `Married`='0', `MarriedTo`='Niemand', `WantedLevel`='0', `Spawn`='0' WHERE `Name`='James.Gordon' ": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '`PayDayHad`='0', `CDPlayer`='0', `AlcoholPerk`='0', `PainKillerPerk`='0', `Pisto' at line 1
[20:03:49] [DEBUG] CConnection::GetError(this=0x7005020, connection=0x6bee2a0)
[20:03:49] [INFO] query "UPDATE `users` SET `Level`='1', `AdminLevel`='0', `Checkpoint`='0', `CPrison`='0', `RunningCP`='0', `TeamRadar`='0', `BNDRadar`='0', `Rolex`='0', `Swissonic`='0', `Casio`='0', `Breitling`='0', `Nixon`='0', `IceWatch`='0', `StartCoints`='0', `Coints`='0', `SpawnhealZeit`='0', `DeaglespawnZeit`='0', `M4SpawnZeit`='0', `MP5SpawnZeit`='0', `MehrZinsenZeit`='0', `Medickit`='0', `Startbonus`='0', `Kreditkarte`='0', `KreditkarteBenutzung`='0', `Personalausweis`='1', `Namechange`='57', `DonateRank`='0', `UpgradePoints`='0', `ConnectedTime`='0', `Registered`='1', `Sex`='1', `Age`='21', `Origin`='1', `Muted`='0', `Respect`='0', `Gehalt`='0', `Money`='4990', `Bank`='0', `Jobgeld`='0', `Crimes`='0', `Kills`='0', `sKills`='0', `Deaths`='0', `Arrested`='0', `ArrestTime`='0', `PhoneBook`='0', `LottoNr`='0', `Fishes`='0', `BiggestFish`='0', `Job`='0', `HeadValue`='0', `Jailed`='0', `JailTime`='0', `Leader`='-1', `Member`='-1', `Rank`='0', `Skin`='26', `Vertragszeit`='5', `NewsSkill`='0', `House`='0', `Mieten`='0', `HealPaket`='0', `ArmourPaket`='0', `WaffenPaket`='0', `OverHealPaket`='0', `FishSkill`='0', `MechSkill`='0', `pSHealth`='50.0', `PhoneNr`='1', `Hotel`='-1', `Biz`='-1', `CarLic`='0', `FlyLic`='0', `BoatLic`='0', `FishLic`='0', `GunLic`='0', `Zollpass`='0', `GotMD5`='1' WHERE `Name`='James.Gordon' " successfully executed within 62.704 milliseconds
[20:03:49] [DEBUG] CResultSet::Create(connection=0x6bf7860, query_str='UPDATE `users` SET `Level`='1', `AdminLevel`='0', `Checkpoint`='0', `CPrison`='0', `RunningCP`='0', `TeamRadar`='0', `BNDRadar`='0', `Rolex`='0', `Swissonic`='0', `Casio`='0', `Breitling`='0', `Nixon`='0', `IceWatch`='0', `StartCoints`='0', `Coints`='0', `SpawnhealZeit`='0', `DeaglespawnZeit`='0', `M4SpawnZeit`='0', `MP5SpawnZeit`='0', `MehrZinsenZeit`='0', `Medickit`='0', `Startbonus`='0', `Kreditkarte`='0', `KreditkarteBenutzung`='0', `Personalausweis`='1', `Namechange`='57', `DonateRank`='0', `UpgradePoints`='0', `ConnectedTime`='0', `Registered`='1', `Sex`='1', `Age`='21', `Origin`='1', `Muted`='0', `Respect`='0', `Gehalt`='0', `Money`='4990', `Bank`='0', `Jobgeld`='0', `Crimes`='0', `Kills`='0', `sKills`='0', `Deaths`='0', `Arrested`='0', `ArrestTime`='0', `PhoneBook`='0', `LottoNr`='0', `Fishes`='0', `BiggestFish`='0', `Job`='0', `HeadValue`='0', `Jailed`='0', `JailTime`='0', `Leader`='-1', `Member`='-1', `Rank`='0', `Skin`='26', `Vertragszeit`='5', `NewsSkill`='0', `House`='0', `Mieten`='0', `HealPaket`='0', `ArmourPaket`='0', `WaffenPaket`='0', `OverHealPaket`='0', `FishSkill`='0', `MechSkill`='0', `pSHealth`='50.0', `PhoneNr`='1', `Hotel`='-1', `Biz`='-1', `CarLic`='0', `FlyLic`='0', `BoatLic`='0', `FishLic`='0', `GunLic`='0', `Zollpass`='0', `GotMD5`='1' WHERE `Name`='James.Gordon' ')
[20:03:49] [DEBUG] created new resultset '0x6c1e3d8'
[20:03:49] [DEBUG] fetched MySQL result '0x0'
[20:03:49] [DEBUG] CCallback::Create(amx=0x4af30c8, name='OnQueryError', format='dsssd)
[20:03:49] [DEBUG] CCallback::Create - callback index for 'OnQueryError': -10047
[20:03:49] [DEBUG] processing specifier 'd'
[20:03:49] [DEBUG] retrieved and pushed value '1064'
[20:03:49] [DEBUG] processing specifier 's'
[20:03:49] [DEBUG] retrieved and pushed value 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '`PayDayHad`='0', `CDPlayer`='0', `AlcoholPerk`='0', `PainKillerPerk`='0', `Pisto' at line 1'
[20:03:49] [DEBUG] processing specifier 's'
[20:03:49] [DEBUG] retrieved and pushed value ''
[20:03:49] [DEBUG] processing specifier 's'
[20:03:49] [DEBUG] retrieved and pushed value '`PayDayHad`='0', `CDPlayer`='0', `AlcoholPerk`='0', `PainKillerPerk`='0', `PistolSkill`='0', `MaschinePistolSkill`='0', `SturmgewehrPistolSkill`='0', `ShotGunSkill`='0', `DrugPerk`='0', `MiserPerk`='0', `TraderPerk`='0', `Tutorial`='1', `Cptut`='1', `kh`='0', `Warnings`='0', `Fuel`='0', `Married`='0', `MarriedTo`='Niemand', `WantedLevel`='0', `Spawn`='0' WHERE `Name`='James.Gordon' '
[20:03:49] [DEBUG] processing specifier 'd'
[20:03:49] [DEBUG] retrieved and pushed value '1'
[20:03:49] [INFO] Callback 'OnQueryError' set up for delayed execution.
[20:03:49] [DEBUG] created delayed callback with 5 parameters
[20:03:49] [DEBUG] CCallback::Execute(amx=0x4af30c8, index=-10047, num_params=5)
[20:03:49] [INFO] Executing callback 'c‹9' with 5 parameters...
[20:03:49] [DEBUG] processing internal specifier 'c'
[20:03:49] [DEBUG] pushed value '1' onto AMX stack
[20:03:49] [DEBUG] processing internal specifier 's'
[20:03:49] [DEBUG] pushed value '`PayDayHad`='0', `CDPlayer`='0', `AlcoholPerk`='0', `PainKillerPerk`='0', `PistolSkill`='0', `MaschinePistolSkill`='0', `SturmgewehrPistolSkill`='0', `ShotGunSkill`='0', `DrugPerk`='0', `MiserPerk`='0', `TraderPerk`='0', `Tutorial`='1', `Cptut`='1', `kh`='0', `Warnings`='0', `Fuel`='0', `Married`='0', `MarriedTo`='Niemand', `WantedLevel`='0', `Spawn`='0' WHERE `Name`='James.Gordon' ' onto AMX stack
[20:03:49] [DEBUG] processing internal specifier 's'
[20:03:49] [DEBUG] pushed value '' onto AMX stack
[20:03:49] [DEBUG] processing internal specifier 's'
[20:03:49] [DEBUG] pushed value 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '`PayDayHad`='0', `CDPlayer`='0', `AlcoholPerk`='0', `PainKillerPerk`='0', `Pisto' at line 1' onto AMX stack
[20:03:49] [DEBUG] processing internal specifier 'c'
[20:03:49] [DEBUG] pushed value '1064' onto AMX stack
[20:03:49] [DEBUG] executing AMX callback with index '-10047'
[20:03:49] [DEBUG] AMX callback executed with error '0'
[20:03:49] [INFO] Callback successfully executed.

Alles anzeigen

Dr. Frauenarzt · 18. Mai 2018

Code

[16:45:39] [DEBUG] mysql_format(1, 0x0696A82C, 256, "SELECT * FROM `users` WHERE `Name` = '%s' AND `NewPassword` ='%e'")
[16:45:39] [DEBUG] CHandle::EscapeString(this=0x6af7580, src='57B87A3FFAE0CF4E1C88DDF4FAD66F890AB379D222F6D2F4B8AC4D5099E5BEA8D9797A12039E0CD0079E4BE53C56940888B504274F60B32931188CE63F8739AB')
[16:45:39] [DEBUG] CConnection::EscapeString(src='57B87A3FFAE0CF4E1C88DDF4FAD66F890AB379D222F6D2F4B8AC4D5099E5BEA8D9797A12039E0CD0079E4BE53C56940888B504274F60B32931188CE63F8739AB', this=0x268c190, connection=0x6b44828)
[16:45:39] [DEBUG] CHandle::EscapeString - return value: true, escaped string: '57B87A3FFAE0CF4E1C88DDF4FAD66F890AB379D222F6D2F4B8AC4D5099E5BEA8D9797A12039E0CD0079E4BE53C56940888B504274F60B32931188CE63F8739AB'
[16:45:39] [DEBUG] mysql_format: return value: '201'
[16:45:39] [DEBUG] mysql_pquery(1, "SELECT * FROM `users` WHERE `Name` = 'James.Gordon' AND `NewPassword` ='57B87A3FFAE0CF4E1C88DDF4FAD66F890AB379D222F6D2F4B8AC4D5099E5BEA8D9797A12039E0CD0079E4BE53C56940888B504274F60B32931188CE63F8739AB'", "LoadPlayerDataSequence", "dd")
[16:45:39] [DEBUG] CCallback::Create(amx=0x4b730c8, name='LoadPlayerDataSequence', format='dd', params=0x696a60c, param_offset=5)
[16:45:39] [DEBUG] CCallback::Create - callback index for 'LoadPlayerDataSequence': 170
[16:45:39] [DEBUG] processing specifier 'd' with parameter index 0
[16:45:39] [DEBUG] retrieved and pushed value '8'
[16:45:39] [DEBUG] processing specifier 'd' with parameter index 1
[16:45:39] [DEBUG] retrieved and pushed value '2'
[16:45:39] [INFO] Callback 'LoadPlayerDataSequence' set up for delayed execution.
[16:45:39] [DEBUG] created delayed callback with 2 parameters
[16:45:39] [DEBUG] CHandle::Execute(this=0x6af7580, type=2, query=0x6bb3d60)
[16:45:39] [DEBUG] CConnectionPool::Queue(query=0x6bb3d60, this=0x268c450)
[16:45:39] [DEBUG] CConnection::Execute(query=0x6bb3d60, this=0x7158020, connection=0x6b71618)
[16:45:39] [DEBUG] CQuery::Execute(this=0x6bb3d60, connection=0x6b71618)
[16:45:39] [DEBUG] CHandle::Execute - return value: true
[16:45:39] [DEBUG] mysql_pquery: return value: '1'
[16:45:39] [INFO] query "SELECT * FROM `users` WHERE `Name` = 'James.Gordon' AND `NewPassword` ='57B87A3FFAE0CF4E1C88DDF4FAD66F890AB379D222F6D2F4B8AC4D5099E5BEA8D9797A12039E0CD0079E4BE53C56940888B504274F60B32931188CE63F8739AB'" successfully executed within 4.490 milliseconds
[16:45:39] [DEBUG] CResultSet::Create(connection=0x6b71618, query_str='SELECT * FROM `users` WHERE `Name` = 'James.Gordon' AND `NewPassword` ='57B87A3FFAE0CF4E1C88DDF4FAD66F890AB379D222F6D2F4B8AC4D5099E5BEA8D9797A12039E0CD0079E4BE53C56940888B504274F60B32931188CE63F8739AB'')
[16:45:39] [DEBUG] created new resultset '0x6bbead0'
[16:45:39] [DEBUG] fetched MySQL result '0x2692f08'
[16:45:39] [DEBUG] allocated 0 bytes for PAWN result
[16:45:39] [DEBUG] CCallback::Execute(amx=0x4b730c8, index=170, num_params=2)
[16:45:39] [INFO] Executing callback 'LoadPlayerDataSequence' with 2 parameters...
[16:45:39] [DEBUG] processing internal specifier 'c'
[16:45:39] [DEBUG] pushed value '2' onto AMX stack
[16:45:39] [DEBUG] processing internal specifier 'c'
[16:45:39] [DEBUG] pushed value '8' onto AMX stack
[16:45:39] [DEBUG] executing AMX callback with index '170'
[16:45:39] [DEBUG] cache_get_row_count(0x0696AF68)
[16:45:39] [DEBUG] cache_get_row_count: return value: '1'
[16:45:39] [DEBUG] AMX callback executed with error '0'
[16:45:39] [INFO] Callback successfully executed.

Alles anzeigen

Habe folgendes Problem.

Wen ich mich einloggen möchte sagt er mir Falsches Passwort obwohl ich das Richtige eingebe.

//E:

Es sieht voll lange aus das Passwort irgendwie aber in der Datenbank ist das:

57B87A3FFAE0CF4E1C88DDF4FAD66F89

Beiträge von Dr. Frauenarzt

Fragen zum Haussystem (Mieter Rauswerfen & Mieter Auflisten)

Fragen zum Haussystem (Mieter Rauswerfen & Mieter Auflisten)

[SAMMELTHREAD] Kleine Scripting Fragen

[SAMMELTHREAD] Kleine Scripting Fragen

[SAMMELTHREAD] Kleine Scripting Fragen

[SAMMELTHREAD] Kleine Scripting Fragen

[SAMMELTHREAD] Kleine Scripting Fragen

Problem mit der Speicherung der Accounts (Mysql R41-4)

Problem mit der Speicherung der Accounts (Mysql R41-4)

Problem mit der Speicherung der Accounts (Mysql R41-4)

Problem mit Fraktions Fahrzeugen

Problem mit Fraktions Fahrzeugen

Problem mit Fraktions Fahrzeugen

Problem mit der Speicherung der Accounts (Mysql R41-4)

[SAMMELTHREAD] Kleine Scripting Fragen

[SAMMELTHREAD] Kleine Scripting Fragen

Problem mit der Speicherung der Accounts (Mysql R41-4)

Problem mit der Speicherung der Accounts (Mysql R41-4)

Problem mit der Speicherung der Accounts (Mysql R41-4)

Problem mit der Speicherung der Accounts (Mysql R41-4)