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

Jeffry · 20. Mai 2018

Erkläre bitte mal dein Problem genauer und in ganzen Sätzen, die Sinn machen.

Und was sagt denn der Log?

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

Jeffry · 20. Mai 2018

Wie sieht dein OnPlayerRegister aus?

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

Jeffry · 20. Mai 2018

Wenn du das Login Fenster nicht anzeigen lässt, kann es auch nicht angezeigt werden.

Zuerst mal:
OnPlayerRegister(playerid);
Beim DIALOG_REGISTER entfernen und
mysql_pquery(handle, query);
zu:
mysql_pquery(handle, query, "OnPlayerRegister", "d", playerid);
ändern.

Und dann das dazu einfügen:
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"," ");

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

Jeffry · 20. Mai 2018

Der Unterschied ist hier beschrieben:
http://wiki.sa-mp.com/wiki/MySQL/R40#mysql_pquery

In den meisten Fällen reicht es, mysql_tquery zu nutzen.

breadfish.de 12. März 2022