[SAMMELTHREAD] Kleine Scripting Fragen

Studs · 24. August 2018

mysql_pquery(handle, query, "OnSaveUserCheck", "d", playerid);
mysql_format(handle, query, sizeof(query), "UPDATE `user` SET `PlayMinutes` = '%d', `MinutesSinceAn` = '%d', `SFPASS` = '%d', `LVPASS` = '%d', `Offflucht` = '%d', `Uhr` = '%d', `Handy` = '%d', `Perso` = '%d', `FrakSperre` = '%d' WHERE `id` = '%d'",

PlayerInfo[playerid][pPlayMinutes], PlayerInfo[playerid][pMinutesSinceAn], PlayerInfo[playerid][pSFPASS], PlayerInfo[playerid][pLVPASS],OfflineFlucht[playerid], PlayerInfo[playerid][pUhrID],PlayerInfo[playerid][pHandyID], PlayerInfo[playerid][pOwnPerso], PlayerInfo[playerid][pFrakSperre], PlayerInfo[playerid][p_id]);

forward OnSaveUserCheck(playerid);public OnSaveUserCheck(playerid){SendClientMessage(playerid,-1,"Wurde abgerufen.");printf("Wurde abgerufen");return 1;}

Irgendwas ist da falsch, hab mit OnSaveUserCheck geprüft ob der Public überhaupt abgerufen wird,

wird er aber nicht. Keine Ahnung was ich noch tun kann.

Nutze die allerneuste mysql version

Kaliber · 24. August 2018

Zitat von JacLos

Keine Ahnung was ich noch tun kann.

...du musst das query unter das format packen...ansonsten ist der query-string doch leer

+ es gibt extra einen MySQL Log, wo genau drinnen steht, was gerade vor sich geht

Studs · 25. August 2018

[08/25/18 13:00:17] [DEBUG] mysql_format(1, 0x0643AB8C, 128, "SELECT id FROM user WHERE Username = '%e'")[08/25/18 13:00:17] [DEBUG] CHandle::EscapeString(this=0x261e058, src='skskgb')[08/25/18 13:00:17] [DEBUG] CConnection::EscapeString(src='skskgb', this=0x2619f78, connection=0x25f33f0)[08/25/18 13:00:17] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'skskgb'[08/25/18 13:00:17] [DEBUG] mysql_format: return value: '45'[08/25/18 13:00:17] [DEBUG] mysql_pquery(1, "SELECT id FROM user WHERE Username = 'skskgb'", "OnUserCheck", "d")[08/25/18 13:00:17] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnUserCheck', format='d', params=0x643ab74, param_offset=5)[08/25/18 13:00:17] [DEBUG] CCallback::Create - callback index for 'OnUserCheck': 179[08/25/18 13:00:17] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:17] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:17] [INFO] Callback 'OnUserCheck' set up for delayed execution.[08/25/18 13:00:17] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:17] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x2650518)[08/25/18 13:00:17] [DEBUG] CConnectionPool::Queue(query=0x2650518, this=0x261a438)[08/25/18 13:00:17] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:17] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:17] [DEBUG] CConnection::Execute(query=0x2650518, this=0x675c020, connection=0x26373d0)[08/25/18 13:00:17] [DEBUG] CQuery::Execute(this=0x2650518, connection=0x26373d0)[08/25/18 13:00:17] [INFO] query "SELECT id FROM user WHERE Username = 'skskgb'" successfully executed within 14.925 milliseconds[08/25/18 13:00:17] [DEBUG] CResultSet::Create(connection=0x26373d0, query_str='SELECT id FROM user WHERE Username = 'skskgb'')[08/25/18 13:00:17] [DEBUG] created new resultset '0x2650c98'[08/25/18 13:00:17] [DEBUG] fetched MySQL result '0x2654da8'[08/25/18 13:00:17] [DEBUG] allocated 0 bytes for PAWN result[08/25/18 13:00:17] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=179, num_params=1)[08/25/18 13:00:17] [INFO] Executing callback 'OnUserCheck' with 1 parameter...[08/25/18 13:00:17] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:17] [DEBUG] pushed value '0' onto AMX stack[08/25/18 13:00:17] [DEBUG] executing AMX callback with index '179'[08/25/18 13:00:17] [DEBUG] cache_get_row_count(0x0643AF8C)[08/25/18 13:00:17] [DEBUG] cache_get_row_count: return value: '1'[08/25/18 13:00:17] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:17] [INFO] Callback successfully executed.[08/25/18 13:00:18] [DEBUG] mysql_format(1, 0x0643A6C0, 256, "INSERT INTO `user` (`Username`, `Key`) VALUES ('%e', MD5('%e'))")[08/25/18 13:00:18] [DEBUG] CHandle::EscapeString(this=0x261e058, src='skskgb')[08/25/18 13:00:18] [DEBUG] CConnection::EscapeString(src='skskgb', this=0x2619f78, connection=0x25f33f0)[08/25/18 13:00:18] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'skskgb'[08/25/18 13:00:18] [DEBUG] CHandle::EscapeString(this=0x261e058, src='zensiert')[08/25/18 13:00:18] [DEBUG] CConnection::EscapeString(src='zensiert', this=0x2619f78, connection=0x25f33f0)[08/25/18 13:00:18] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'zensiert'[08/25/18 13:00:18] [DEBUG] mysql_format: return value: '71'[08/25/18 13:00:18] [DEBUG] mysql_pquery(1, "INSERT INTO `user` (`Username`, `Key`) VALUES ('skskgb', MD5('zensiert'))", "OnUserRegister", "d")[08/25/18 13:00:18] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnUserRegister', format='d', params=0x643a6a8, param_offset=5)[08/25/18 13:00:18] [DEBUG] CCallback::Create - callback index for 'OnUserRegister': 181[08/25/18 13:00:18] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:18] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:18] [INFO] Callback 'OnUserRegister' set up for delayed execution.[08/25/18 13:00:18] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:18] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x2650518)[08/25/18 13:00:18] [DEBUG] CConnectionPool::Queue(query=0x2650518, this=0x261a438)[08/25/18 13:00:18] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:18] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:18] [DEBUG] CConnection::Execute(query=0x2650518, this=0x6921020, connection=0x26411d8)[08/25/18 13:00:18] [DEBUG] CQuery::Execute(this=0x2650518, connection=0x26411d8)[08/25/18 13:00:19] [INFO] query "INSERT INTO `user` (`Username`, `Key`) VALUES ('skskgb', MD5('ficken'))" successfully executed within 448.236 milliseconds[08/25/18 13:00:19] [DEBUG] CResultSet::Create(connection=0x26411d8, query_str='INSERT INTO `user` (`Username`, `Key`) VALUES ('skskgb', MD5('ficken'))')[08/25/18 13:00:19] [DEBUG] created new resultset '0x2650678'[08/25/18 13:00:19] [DEBUG] fetched MySQL result '0x0'[08/25/18 13:00:19] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=181, num_params=1)[08/25/18 13:00:19] [INFO] Executing callback 'OnUserRegister' with 1 parameter...[08/25/18 13:00:19] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:19] [DEBUG] pushed value '0' onto AMX stack[08/25/18 13:00:19] [DEBUG] executing AMX callback with index '181'[08/25/18 13:00:19] [DEBUG] cache_insert_id()[08/25/18 13:00:19] [DEBUG] cache_insert_id: return value: '12'[08/25/18 13:00:19] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:19] [INFO] Callback successfully executed.[08/25/18 13:00:51] [DEBUG] mysql_format(1, 0x0643A8B0, 256, "UPDATE `user` SET `Level` = '%d', `Money` = '%d', `AdminLevel` = '%d', `DonateRank` = '%d', `UpgradePoint` = '%d', `Registered` = '%d', `Sex` = '%d', `Age` = '%d', `OriginHerkunft` = '%d', `Muted` = '%d', `Bank` = '%d', `Deaths` = '%d' WHERE `Username` = '%e'")[08/25/18 13:00:51] [DEBUG] CHandle::EscapeString(this=0x261e058, src='sskgb')[08/25/18 13:00:51] [DEBUG] CConnection::EscapeString(src='sskgb', this=0x2619f78, connection=0x25f33f0)[08/25/18 13:00:51] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'sskgb'[08/25/18 13:00:51] [DEBUG] mysql_format: return value: '255'[08/25/18 13:00:51] [DEBUG] mysql_pquery(1, "UPDATE `user` SET `Level` = '1', `Money` = '115', `AdminLevel` = '0', `DonateRank` = '0', `UpgradePoint` = '0', `Registered` = '1', `Sex` = '1', `Age` = '27', `OriginHerkunft` = '1', `Muted` = '0', `Bank` = '0', `Deaths` = '2' WHERE `Username` = 'sskgb'", "OnSaveUserCheck", "d")[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnSaveUserCheck', format='d', params=0x643a898, param_offset=5)[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnSaveUserCheck': 178[08/25/18 13:00:51] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:51] [INFO] Callback 'OnSaveUserCheck' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:51] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x26163e0)[08/25/18 13:00:51] [DEBUG] CConnectionPool::Queue(query=0x26163e0, this=0x261a438)[08/25/18 13:00:51] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:51] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:51] [DEBUG] mysql_format(1, 0x0643A8B0, 256, "UPDATE `user` SET `Arrested` = '%d', `Kills` = '%d', `WantedDeaths` = '%d',`Phonebook` = '%d', `LottoNr` = '%d', `Fishes` = '%d', `Job` = '%d', `pPayCheck` = '%d', `Jailed` = '%d',`JailTime` = '%d', `Materials` = '%d', `Drugs` = '%d' WHERE `Username` = '%e'")[08/25/18 13:00:51] [DEBUG] CConnection::Execute(query=0x26163e0, this=0x675c020, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] CHandle::EscapeString(this=0x261e058, src='sskgb')[08/25/18 13:00:51] [DEBUG] CQuery::Execute(this=0x26163e0, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] CConnection::EscapeString(src='sskgb', this=0x2619f78, connection=0x25f33f0)[08/25/18 13:00:51] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'sskgb'[08/25/18 13:00:51] [DEBUG] mysql_format: return value: '250'[08/25/18 13:00:51] [DEBUG] mysql_pquery(1, "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'", "OnSaveUserCheck", "d")[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnSaveUserCheck', format='d', params=0x643a898, param_offset=5)[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnSaveUserCheck': 178[08/25/18 13:00:51] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:51] [INFO] Callback 'OnSaveUserCheck' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:51] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x2654cf0)[08/25/18 13:00:51] [DEBUG] CConnectionPool::Queue(query=0x2654cf0, this=0x261a438)[08/25/18 13:00:51] [DEBUG] CConnection::Execute(query=0x2654cf0, this=0x6921020, connection=0x26411d8)[08/25/18 13:00:51] [DEBUG] CQuery::Execute(this=0x2654cf0, connection=0x26411d8)[08/25/18 13:00:51] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:51] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:51] [DEBUG] mysql_format(1, 0x0643A8B0, 256, "UPDATE `user` SET `Leader` = '%d', `Member` = '%d', `Rank` = '%d', `pChar` = '%d', `ContractTime` = '%d', `DetSkill` = '%d', `SexSkill` = '%d', `BoxSkill` = '%d', `LawSkill` = '%d', `MechSkill` = '%d', `JackSkill` = '%d', `CarSkill` = '%d', `NewsSkill` = '%d' WHERE `Username` = '%e'")[08/25/18 13:00:51] [ERROR] mysql_format: destination size '256' is too small[08/25/18 13:00:51] [DEBUG] mysql_format: return value: '0'[08/25/18 13:00:51] [DEBUG] mysql_pquery(1, "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'", "OnSaveUserCheck", "d")[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnSaveUserCheck', format='d', params=0x643a898, param_offset=5)[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnSaveUserCheck': 178[08/25/18 13:00:51] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:51] [INFO] Callback 'OnSaveUserCheck' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:51] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x2654d88)[08/25/18 13:00:51] [DEBUG] CConnectionPool::Queue(query=0x2654d88, this=0x261a438)[08/25/18 13:00:51] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:51] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:51] [DEBUG] mysql_format(1, 0x0643A8B0, 256, "UPDATE `user` SET `NewsSkill` = '%d', `DrugsSkill` = '%d', `CookSkill` = '%d', `pHealth` = '%f', `IntInt` = '%d', `Local` = '%d', `PhoneNr` = '%d', `House` = '%d', `Bizz` = '%d', `HandyGeld` = '%d', `Pos_x` = '%f', `Pos_y` = '%f', `Pos_z` = '%f', `CarLic` = '%d' WHERE `Username` = '%e'")[08/25/18 13:00:51] [ERROR] mysql_format: destination size '256' is too small[08/25/18 13:00:51] [DEBUG] mysql_format: return value: '0'[08/25/18 13:00:51] [DEBUG] mysql_pquery(1, "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'", "OnSaveUserCheck", "d")[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnSaveUserCheck', format='d', params=0x643a898, param_offset=5)[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnSaveUserCheck': 178[08/25/18 13:00:51] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:51] [INFO] Callback 'OnSaveUserCheck' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:51] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x2654830)[08/25/18 13:00:51] [ERROR] error #1054 while executing query "UPDATE `user` SET `Level` = '1', `Money` = '115', `AdminLevel` = '0', `DonateRank` = '0', `UpgradePoint` = '0', `Registered` = '1', `Sex` = '1', `Age` = '27', `OriginHerkunft` = '1', `Muted` = '0', `Bank` = '0', `Deaths` = '2' WHERE `Username` = 'sskgb'": Unknown column 'UpgradePoint' in 'field list'[08/25/18 13:00:51] [DEBUG] CConnectionPool::Queue(query=0x2654830, this=0x261a438)[08/25/18 13:00:51] [DEBUG] CConnection::GetError(this=0x675c020, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:51] [DEBUG] CConnection::Execute(query=0x2654d88, this=0x675c020, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:51] [DEBUG] CQuery::Execute(this=0x2654d88, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] mysql_format(1, 0x0643A8B0, 256, "UPDATE `user` SET `NewLic` = '%d', `FlyLic` = '%d', `BoatLic` = '%d', `FishLic` = '%d', `GunLic` = '%d', `LKWLic` = '%d', `Zig` = '%d', `Zigsucht` = '%d', `Gun1` = '%d', `Gun2` = '%d', `Gun3` = '%d', `Gun4` = '%d', `Gun5` = '%d', `Gun6` = '%d' WHERE `Username` = '%e'")[08/25/18 13:00:51] [DEBUG] CHandle::EscapeString(this=0x261e058, src='sskgb')[08/25/18 13:00:51] [DEBUG] CConnection::EscapeString(src='sskgb', this=0x2619f78, connection=0x25f33f0)[08/25/18 13:00:51] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'sskgb'[08/25/18 13:00:51] [ERROR] mysql_format: destination size '256' is too small[08/25/18 13:00:51] [DEBUG] mysql_format: return value: '0'[08/25/18 13:00:51] [DEBUG] mysql_pquery(1, "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'", "OnSaveUserCheck", "d")[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnSaveUserCheck', format='d', params=0x643a898, param_offset=5)[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnSaveUserCheck': 178[08/25/18 13:00:51] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:51] [INFO] Callback 'OnSaveUserCheck' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:51] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x2654960)[08/25/18 13:00:51] [DEBUG] CConnectionPool::Queue(query=0x2654960, this=0x261a438)[08/25/18 13:00:51] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:51] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:51] [DEBUG] mysql_format(1, 0x0643A8B0, 256, "UPDATE `user` SET `Gun7` = '%d', `Gun8` = '%d', `Gun9` = '%d', `Gun10` = '%d', `Gun11` = '%d', `Gun12` = '%d', `Ammo1` = '%d', `Ammo2` = '%d', `Ammo3` = '%d', `Ammo4` = '%d', `Ammo5` = '%d', `Ammo6` = '%d', `Ammo7` = '%d', `Ammo8` = '%d', `Ammo9` = '%d', `Ammo10` = '%d', `Ammo11` = '%d', `Ammo12` = '%d' WHERE `Ùsername` = '%e'")[08/25/18 13:00:51] [ERROR] mysql_format: destination size '256' is too small[08/25/18 13:00:51] [DEBUG] mysql_format: return value: '0'[08/25/18 13:00:51] [DEBUG] mysql_pquery(1, "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'", "OnSaveUserCheck", "d")[08/25/18 13:00:51] [INFO] query "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'" successfully executed within 14.875 milliseconds[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnSaveUserCheck', format='d', params=0x643a898, param_offset=5)[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnSaveUserCheck': 178[08/25/18 13:00:51] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:51] [DEBUG] CResultSet::Create(connection=0x26411d8, query_str='UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'')[08/25/18 13:00:51] [INFO] Callback 'OnSaveUserCheck' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:51] [DEBUG] created new resultset '0x265a128'[08/25/18 13:00:51] [DEBUG] fetched MySQL result '0x0'[08/25/18 13:00:51] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x2654240)[08/25/18 13:00:51] [DEBUG] CConnectionPool::Queue(query=0x2654240, this=0x261a438)[08/25/18 13:00:51] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:51] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:51] [DEBUG] CConnection::Execute(query=0x2654830, this=0x6921020, connection=0x26411d8)[08/25/18 13:00:51] [DEBUG] CQuery::Execute(this=0x2654830, connection=0x26411d8)[08/25/18 13:00:51] [DEBUG] mysql_format(1, 0x0643A8B0, 256, "UPDATE `user` SET `CarTime` = '%d', `PayDay` = '%d', `PayDaysHad` = '%d', `CDPlayer` = '%d', `Wins` = '%d', `Loses` = '%d', `AlcoholPerk` = '%d', `DrugPerk` = '%d', `MiserPerk` = '%d', `PainPerk` = '%d', `TraderPerk` = '%d', `Tutorial` = '%d', `Warnings` = '%d', `pAdjustable` = '%d',`FuelKanister` = '%d', `WantedLevel` = '%d', `SpawnChange` = '%d' WHERE `id` = '%d'")[08/25/18 13:00:51] [ERROR] mysql_format: destination size '256' is too small[08/25/18 13:00:51] [DEBUG] mysql_format: return value: '0'[08/25/18 13:00:51] [DEBUG] mysql_pquery(1, "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'", "OnSaveUserCheck", "d")[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnSaveUserCheck', format='d', params=0x643a898, param_offset=5)[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnSaveUserCheck': 178[08/25/18 13:00:51] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:51] [INFO] Callback 'OnSaveUserCheck' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:51] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x26542d8)[08/25/18 13:00:51] [DEBUG] CConnectionPool::Queue(query=0x26542d8, this=0x261a438)[08/25/18 13:00:51] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:51] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:51] [DEBUG] mysql_format(1, 0x0643A8B0, 256, "UPDATE `user` SET `PlayMinutes` = '%d', `MinutesSinceAn` = '%d', `SFPASS` = '%d', `LVPASS` = '%d', `Offflucht` = '%d', `Uhr` = '%d', `Handy` = '%d', `Perso` = '%d', `FrakSperre` = '%d' WHERE `id` = '%d'")[08/25/18 13:00:51] [DEBUG] mysql_format: return value: '194'[08/25/18 13:00:51] [DEBUG] mysql_pquery(1, "UPDATE `user` SET `PlayMinutes` = '0', `MinutesSinceAn` = '0', `SFPASS` = '0', `LVPASS` = '0', `Offflucht` = '0', `Uhr` = '0', `Handy` = '0', `Perso` = '0', `FrakSperre` = '0' WHERE `id` = '12'", "OnSaveUserCheck", "d")[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnSaveUserCheck', format='d', params=0x643a898, param_offset=5)[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnSaveUserCheck': 178[08/25/18 13:00:51] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:51] [INFO] Callback 'OnSaveUserCheck' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:51] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x26544a0)[08/25/18 13:00:51] [DEBUG] CConnectionPool::Queue(query=0x26544a0, this=0x261a438)[08/25/18 13:00:51] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:51] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnQueryError', format='dsssd)[08/25/18 13:00:51] [INFO] query "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'" successfully executed within 14.841 milliseconds[08/25/18 13:00:51] [INFO] query "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'" successfully executed within 14.948 milliseconds[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnQueryError': -10046[08/25/18 13:00:51] [DEBUG] CResultSet::Create(connection=0x26411d8, query_str='UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'')[08/25/18 13:00:51] [DEBUG] processing specifier 'd'[08/25/18 13:00:51] [DEBUG] created new resultset '0x265a208'[08/25/18 13:00:51] [DEBUG] CResultSet::Create(connection=0x26373d0, query_str='UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'')[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '1054'[08/25/18 13:00:51] [DEBUG] fetched MySQL result '0x0'[08/25/18 13:00:51] [DEBUG] created new resultset '0x2650c28'[08/25/18 13:00:51] [DEBUG] processing specifier 's'[08/25/18 13:00:51] [DEBUG] fetched MySQL result '0x0'[08/25/18 13:00:51] [DEBUG] retrieved and pushed value 'Unknown column 'UpgradePoint' in 'field list''[08/25/18 13:00:51] [DEBUG] processing specifier 's'[08/25/18 13:00:51] [DEBUG] retrieved and pushed value 'OnSaveUserCheck'[08/25/18 13:00:51] [DEBUG] processing specifier 's'[08/25/18 13:00:51] [DEBUG] retrieved and pushed value 'UPDATE `user` SET `Level` = '1', `Money` = '115', `AdminLevel` = '0', `DonateRank` = '0', `UpgradePoint` = '0', `Registered` = '1', `Sex` = '1', `Age` = '27', `OriginHerkunft` = '1', `Muted` = '0', `Bank` = '0', `Deaths` = '2' WHERE `Username` = 'sskgb''[08/25/18 13:00:51] [DEBUG] processing specifier 'd'[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '1'[08/25/18 13:00:51] [INFO] Callback 'OnQueryError' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 5 parameters[08/25/18 13:00:51] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=-10046, num_params=5)[08/25/18 13:00:51] [INFO] Executing callback '"ª4' with 5 parameters...[08/25/18 13:00:51] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:51] [DEBUG] pushed value '1' onto AMX stack[08/25/18 13:00:51] [DEBUG] processing internal specifier 's'[08/25/18 13:00:51] [DEBUG] pushed value 'UPDATE `user` SET `Level` = '1', `Money` = '115', `AdminLevel` = '0', `DonateRank` = '0', `UpgradePoint` = '0', `Registered` = '1', `Sex` = '1', `Age` = '27', `OriginHerkunft` = '1', `Muted` = '0', `Bank` = '0', `Deaths` = '2' WHERE `Username` = 'sskgb'' onto AMX stack[08/25/18 13:00:51] [DEBUG] processing internal specifier 's'[08/25/18 13:00:51] [DEBUG] pushed value 'OnSaveUserCheck' onto AMX stack[08/25/18 13:00:51] [DEBUG] processing internal specifier 's'[08/25/18 13:00:51] [DEBUG] pushed value 'Unknown column 'UpgradePoint' in 'field list'' onto AMX stack[08/25/18 13:00:51] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:51] [DEBUG] pushed value '1054' onto AMX stack[08/25/18 13:00:51] [DEBUG] executing AMX callback with index '-10046'[08/25/18 13:00:51] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:51] [INFO] Callback successfully executed.[08/25/18 13:00:51] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=178, num_params=1)[08/25/18 13:00:51] [INFO] Executing callback 'OnSaveUserCheck' with 1 parameter...[08/25/18 13:00:51] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:51] [DEBUG] pushed value '0' onto AMX stack[08/25/18 13:00:51] [DEBUG] executing AMX callback with index '178'[08/25/18 13:00:51] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:51] [INFO] Callback successfully executed.[08/25/18 13:00:51] [DEBUG] CConnection::Execute(query=0x2654240, this=0x6921020, connection=0x26411d8)[08/25/18 13:00:51] [DEBUG] CConnection::Execute(query=0x2654960, this=0x675c020, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] CQuery::Execute(this=0x2654240, connection=0x26411d8)[08/25/18 13:00:51] [DEBUG] CQuery::Execute(this=0x2654960, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=178, num_params=1)[08/25/18 13:00:51] [INFO] query "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'" successfully executed within 15.38 milliseconds[08/25/18 13:00:51] [INFO] query "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'" successfully executed within 15.55 milliseconds[08/25/18 13:00:51] [INFO] Executing callback 'OnSaveUserCheck' with 1 parameter...[08/25/18 13:00:51] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:51] [DEBUG] CResultSet::Create(connection=0x26373d0, query_str='UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'')[08/25/18 13:00:51] [DEBUG] CResultSet::Create(connection=0x26411d8, query_str='UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'')[08/25/18 13:00:51] [DEBUG] pushed value '0' onto AMX stack[08/25/18 13:00:51] [DEBUG] created new resultset '0x26509f8'[08/25/18 13:00:51] [DEBUG] executing AMX callback with index '178'[08/25/18 13:00:51] [DEBUG] fetched MySQL result '0x0'[08/25/18 13:00:51] [DEBUG] created new resultset '0x265a0f0'[08/25/18 13:00:51] [DEBUG] fetched MySQL result '0x0'[08/25/18 13:00:51] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:51] [INFO] Callback successfully executed.[08/25/18 13:00:51] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=178, num_params=1)[08/25/18 13:00:51] [INFO] Executing callback 'OnSaveUserCheck' with 1 parameter...[08/25/18 13:00:51] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:51] [DEBUG] pushed value '0' onto AMX stack[08/25/18 13:00:51] [DEBUG] executing AMX callback with index '178'[08/25/18 13:00:51] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:51] [INFO] Callback successfully executed.[08/25/18 13:00:51] [DEBUG] CConnection::Execute(query=0x26542d8, this=0x675c020, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] CQuery::Execute(this=0x26542d8, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] CConnection::Execute(query=0x26544a0, this=0x6921020, connection=0x26411d8)[08/25/18 13:00:51] [DEBUG] CQuery::Execute(this=0x26544a0, connection=0x26411d8)[08/25/18 13:00:51] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=178, num_params=1)[08/25/18 13:00:51] [INFO] query "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'" successfully executed within 14.737 milliseconds[08/25/18 13:00:51] [INFO] Executing callback 'OnSaveUserCheck' with 1 parameter...[08/25/18 13:00:51] [DEBUG] CResultSet::Create(connection=0x26373d0, query_str='UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'')[08/25/18 13:00:51] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:51] [DEBUG] created new resultset '0x26508a8'[08/25/18 13:00:51] [DEBUG] fetched MySQL result '0x0'[08/25/18 13:00:51] [DEBUG] pushed value '0' onto AMX stack[08/25/18 13:00:51] [DEBUG] executing AMX callback with index '178'[08/25/18 13:00:51] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:51] [INFO] Callback successfully executed.[08/25/18 13:00:51] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=178, num_params=1)[08/25/18 13:00:51] [INFO] Executing callback 'OnSaveUserCheck' with 1 parameter...[08/25/18 13:00:51] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:51] [DEBUG] pushed value '0' onto AMX stack[08/25/18 13:00:51] [DEBUG] executing AMX callback with index '178'[08/25/18 13:00:51] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:51] [INFO] Callback successfully executed.[08/25/18 13:00:51] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=178, num_params=1)[08/25/18 13:00:51] [INFO] Executing callback 'OnSaveUserCheck' with 1 parameter...[08/25/18 13:00:51] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:51] [DEBUG] pushed value '0' onto AMX stack[08/25/18 13:00:51] [DEBUG] executing AMX callback with index '178'[08/25/18 13:00:51] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:51] [INFO] Callback successfully executed.[08/25/18 13:00:52] [INFO] query "UPDATE `user` SET `PlayMinutes` = '0', `MinutesSinceAn` = '0', `SFPASS` = '0', `LVPASS` = '0', `Offflucht` = '0', `Uhr` = '0', `Handy` = '0', `Perso` = '0', `FrakSperre` = '0' WHERE `id` = '12'" successfully executed within 299.301 milliseconds[08/25/18 13:00:52] [DEBUG] CResultSet::Create(connection=0x26411d8, query_str='UPDATE `user` SET `PlayMinutes` = '0', `MinutesSinceAn` = '0', `SFPASS` = '0', `LVPASS` = '0', `Offflucht` = '0', `Uhr` = '0', `Handy` = '0', `Perso` = '0', `FrakSperre` = '0' WHERE `id` = '12'')[08/25/18 13:00:52] [DEBUG] created new resultset '0x265a080'[08/25/18 13:00:52] [DEBUG] fetched MySQL result '0x0'[08/25/18 13:00:52] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=178, num_params=1)[08/25/18 13:00:52] [INFO] Executing callback 'OnSaveUserCheck' with 1 parameter...[08/25/18 13:00:52] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:52] [DEBUG] pushed value '0' onto AMX stack

[08/25/18 13:00:51] [ERROR] mysql_format: destination size '256' is too small

So das ist der mysql log

Hab den string query mal auf 1000 gesetzt (kp ob das so möglich ist, danach war es aber nicht mehr zu klein)

der server ist dann abgestürzt nachdem ich ihn velrassen habe,

jetzt mit 256 ist aber anscheinend auch zu klein.

Was kann ich tun?

Kaliber · 25. August 2018

Zitat von JacLos

der server ist dann abgestürzt nachdem ich ihn velrassen habe

Dann lade mal das crashdetect Plugin, das sagt dir dann genau, wieso er gecrasht ist

Zitat von JacLos

Hab den string query mal auf 1000 gesetzt

Kann man machen, aber ich denke 512 hätten fürs Erste auch gereicht

reaL. · 25. August 2018

Guten Morgen,
Gibt es eine Möglichkeit bei einem Array der ( Primary ID ) einen Wert hinzuzufügen ohne sowas z.b

Code

for(new i = 0; i < sizeof(vInfo); i++)
	{
	    vInfo[i][v_ID] = INVALID_VEHICLE_ID;
	}

Sodass v_ID immer beim Start INVALID_VEHICLE_ID ist.

Studs · 25. August 2018

Zitat von Kaliber

Dann lade mal das crashdetect Plugin, das sagt dir dann genau, wieso er gecrasht ist

Kann man machen, aber ich denke 512 hätten fürs Erste auch gereicht

mysql_format(handle, query, sizeof(query), "UPDATE `user` SET `CarTime` = '%d', `PayDay` = '%d', `PayDaysHad` = '%d', `CDPlayer` = '%d', `Wins` = '%d', `Loses` = '%d', `AlcoholPerk` = '%d', `DrugPerk` = '%d', `MiserPerk` = '%d', `PainPerk` = '%d', `TraderPerk` = '%d', `Tutorial` = '%d', `Warnings` = '%d', `pAdjustable` = '%d',`FuelKanister` = '%d', `WantedLevel` = '%d', `SpawnChange` = '%d' WHERE `Username` = '%e'",
PlayerInfo[playerid][pCarTime], PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pPayDayHad], PlayerInfo[playerid][pCDPlayer],PlayerInfo[playerid][pWins], PlayerInfo[playerid][pLoses], PlayerInfo[playerid][pAlcoholPerk], PlayerInfo[playerid][pDrugPerk], PlayerInfo[playerid][pMiserPerk],PlayerInfo[playerid][pPainPerk], PlayerInfo[playerid][pTraderPerk], PlayerInfo[playerid][pTut],
PlayerInfo[playerid][pWarns], PlayerInfo[playerid][pAdjustable], PlayerInfo[playerid][pFuel], WantedLevel[playerid], SpawnChange[playerid], PlayerInfo[playerid][PlayerName]);
//mysql_pquery(handle, query);
mysql_pquery(handle, query, "OnSaveUserCheck", "d", playerid);

crasher ? = mysql_format(handle, query, sizeof(query), "UPDATE `user` SET `PlayMinutes` = '%d', `MinutesSinceAn` = '%d', `SFPASS` = '%d', `LVPASS` = '%d', `Offflucht` = '%d', `Uhr` = '%d', `Handy` = '%d', `Perso` = '%d', `FrakSperre` = '%d' WHERE `id` = '%d'",
PlayerInfo[playerid][pPlayMinutes], PlayerInfo[playerid][pMinutesSinceAn], PlayerInfo[playerid][pSFPASS], PlayerInfo[playerid][pLVPASS],OfflineFlucht[playerid], PlayerInfo[playerid][pUhrID],PlayerInfo[playerid][pHandyID], PlayerInfo[playerid][pOwnPerso], PlayerInfo[playerid][pFrakSperre], PlayerInfo[playerid][p_id]);

// mysql_pquery(handle, query);

Danke schonmal dafür mit 512 klappts und 6/8 werden aufgerufen

Hab beim ersten mal id auf Username umgeändert, dann lädt er auch nicht,

wenn ich jedoch beim letzten id auf Username ändere crasht der server beim verlassen. / oder lädt einfach nicht wie der erste

LOG:

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

[13:26:26] filterscripts = "" (string)
[13:26:26]
[13:26:26] Server Plugins
[13:26:26] --------------
[13:26:26] Loading plugin: crashdetect.dll
[13:26:26] CrashDetect plugin 4.19.1
[13:26:26] Loaded.
[13:26:26] Loading plugin: mysql.dll
[13:26:26] >> plugin.mysql: R41-4 successfully loaded.
[13:26:26] Loaded.
[13:26:26] Loading plugin: streamer.dll
[13:26:26]

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

[13:26:26] Loaded.
[13:26:26] Loading plugin: sscanf.dll
[13:26:26]

[13:26:26] ===============================

[13:26:26] sscanf plugin loaded.

[13:26:26] Version: 2.8.2

[13:26:26] ===============================

[13:26:26] Loaded.
[13:26:26] Loaded 4 plugins.

[13:26:26]
[13:26:26] Ban list
[13:26:26] --------
[13:26:26] Loaded: samp.ban
[13:26:26]
[13:26:26]
[13:26:26] Filterscripts
[13:26:26] ---------------
[13:26:26] Loaded 0 filterscripts.

[13:26:26] [MySQL] Verbindungsaufbau...
[13:26:26] [MySQL] Die Verbindung zur Datenbank wurde erfolgreich hergestellt! Handle: 1
[13:26:26] AllowAdminTeleport() : function is deprecated. Please see OnPlayerClickMap()
[13:26:26] Pickups Max = 2048, Current Pickups = 298
[13:26:26] _______________________________________
[13:26:26] Das Script wurde Vollständig geladen!
[13:26:26] German Reallife: LS/SF/LV
[13:26:26] _______________________________________
[13:26:26]
[13:26:26] Number of vehicle models: 83
[13:26:43] [connection] 127.0.0.1:55041 requests connection cookie.
[13:26:44] [connection] incoming connection: 127.0.0.1:55041 id: 0
[13:26:48] [join] Testuser01 has joined the server (0:127.0.0.1)
[13:27:03] [chat] [Testuser01]: fertig
[13:27:03] [debug] Run time error 4: "Array index out of bounds"
[13:27:03] [debug] Attempted to read/write array element at index 65535 in array of size 1000
[13:27:03] [debug] AMX backtrace:
[13:27:03] [debug] #0 00020c3c in public OnPlayerDeath (0, 65535, 255) from gfl.amx
[13:27:03] [death] Testuser01 died 255
[13:27:16] [part] Testuser01 has left the server (0:1)
[13:27:16] Wurde abgerufen
[13:27:16] Wurde abgerufen
[13:27:16] Wurde abgerufen
[13:27:16] Wurde abgerufen
[13:27:16] Wurde abgerufen
[13:27:16] Wurde abgerufen

[part] osfsofxdggg has left the server (0:1)
Wurde abgerufen
Wurde abgerufen
Wurde abgerufen
Wurde abgerufen
Wurde abgerufen
Wurde abgerufen

MYSQL LOG:

Kaliber · 25. August 2018

Zitat von JacLos

OnPlayerDeath

Ein Fehler tritt schonmal unter OnPlayerDeath.

Du prüfst nicht, ob killerid != INVALID_PLAYER_ID ist.

Und dadurch kommt es zu Fehlern in einem Array.

Bei deinen Querys sieht doch alles gut aus:
[INFO] Callback successfully executed.

//Edit:

Zitat von reaL.

Gibt es eine Möglichkeit bei einem Array der ( Primary ID ) einen Wert hinzuzufügen ohne sowas z.b

Ja generell schon, aber bei genau so einer Art von Array, ist das nicht ohne weiteres möglich.
Aber ist ja auch nicht schlimm, da das ja nur 1x unter OnGameModeInit aufgerufen wird und gut ist

Studs · 25. August 2018

Zitat von Kaliber

Ein Fehler tritt schonmal unter OnPlayerDeath.
Du prüfst nicht, ob killerid != INVALID_PLAYER_ID ist.

Und dadurch kommt es zu Fehlern in einem Array.

Bei deinen Querys sieht doch alles gut aus:
[INFO] Callback successfully executed.

//Edit:

Ja generell schon, aber bei genau so einer Art von Array, ist das nicht ohne weiteres möglich.Aber ist ja auch nicht schlimm, da das ja nur 1x unter OnGameModeInit aufgerufen wird und gut ist

Alles anzeigen

Ok hab ich geändert, aber die letzten 2 werden ja trotzdem nicht geladen Kriege nur 6 "wurde abgerufen" nachrichten

Kaliber · 25. August 2018

Zitat von JacLos

Kriege nur 6 "wurde abgerufen" nachrichten

Keine Ahnung, was du da machst, wo sind denn die prints dazu?

Und bei dem letzten hast du das query auskommentiert, da kann also nichts kommen und bei dem anderen, wird dieser Codeblock denn überhaupt aufgerufen?!

Studs · 25. August 2018

Zitat von Kaliber

Keine Ahnung, was du da machst, wo sind denn die prints dazu?
Und bei dem letzten hast du das query auskommentiert, da kann also nichts kommen und bei dem anderen, wird dieser Codeblock denn überhaupt aufgerufen?!

forward OnSaveUserCheck(playerid);
public OnSaveUserCheck(playerid)
{
SendClientMessage(playerid,-1,"Wurde abgerufen.");
printf("Wurde abgerufen");
return 1;
}

Kann damit nicht genau bestimmen wer abgerufen wird, wer nicht,

kann ich aber mal kurz machen mit 8 publics für jeden einen.

//mysql_pquery(handle, query); >> Hab nur das hier auskommentiert damit ich gucken kann obs überhaupt abgerufen wird
mysql_pquery(handle, query, "OnSaveUserCheck", "d", playerid); > Das nehme ich an der stelle

Kaliber · 25. August 2018

Brauchst du nicht, es reicht ja, wenn du noch ein print jeweils zu dem Aufruft packst

Denn ich glaube, der letzte Codeblock, wo du die letzten beiden Querys drinnen hast, wird einfach nicht aufgerufen.

Studs · 25. August 2018

Zitat von Kaliber

Brauchst du nicht, es reicht ja, wenn du noch ein print jeweils zu dem Aufruft packst

Denn ich glaube, der letzte Codeblock, wo du die letzten beiden Querys drinnen hast, wird einfach nicht aufgerufen.

Aufruft ? Was ist das xD

// edit aso habs im falschen kontext verstanden xD

Aber kannste das nochmal genau erklären, bin noch nicht so im scripten drinne xD

Ja glaube auch, denke mal die letzten beide

Kaliber · 25. August 2018

Unterlasse doch bitte vollzitate

Zitat von JacLos

Aufruft ? Was ist das xD

Aufruf...

Zitat von JacLos

denke mal die letzten beide

..ja das sage ich seid 3 Posts...printe das doch einfach mal und prüfe es dadurch

Studs · 25. August 2018

Zitat von Kaliber

Unterlasse doch bitte vollzitate

Aufruf...

..ja das sage ich seid 3 Posts...printe das doch einfach mal und prüfe es dadurch

[14:09:59] [debug] Server crashed due to an unknown error
[14:09:59] [debug] Native backtrace:
[14:09:59] [debug] #0 004016eb in ?? () from samp-server.exe
[14:09:59] [debug] #1 61ca35e9 in ?? () from plugins\mysql.dll
[14:09:59] [debug] #2 61ca6688 in ?? () from plugins\mysql.dll
[14:09:59] [debug] #3 61c8c52e in ?? () from plugins\mysql.dll
[14:09:59] [debug] #4 61c8dc7f in ?? () from plugins\mysql.dll
[14:09:59] [debug] #5 61c8e3d3 in ?? () from plugins\mysql.dll
[14:09:59] [debug] #6 00469a66 in ?? () from samp-server.exe
[14:09:59] [debug] #7 0048d4db in ?? () from samp-server.exe
[14:09:59] [debug] #8 0049b4a1 in ?? () from samp-server.exe
[14:09:59] [debug] #9 0049b4b1 in ?? () from samp-server.exe
[14:09:59] [debug] Registers:
[14:09:59] [debug] EAX: 057ba660 EBX: 00000000 ECX: 057ce020 EDX: 00000008
[14:09:59] [debug] ESI: 00000038 EDI: ffffd8c1 EBP: 0049b4a1 ESP: 0019fe98
[14:09:59] [debug] EIP: 0049b4b1 EFLAGS: 00010246
[14:09:59] [debug] Stack:
[14:09:59] [debug] ESP+00000000: 004ab4a0 0019ff70 004ab0e1 ffffffff
[14:09:59] [debug] ESP+00000020: 00000094 00000006 00000002 000023f0
[14:09:59] [debug] ESP+00000040: 00000000 00000000 00000000 00000000
[14:09:59] [debug] ESP+00000060: 00000000 00000000 00000000 00000000
[14:09:59] [debug] ESP+00000080: 00000000 00000000 00000000 00000000
[14:09:59] [debug] ESP+000000a0: 00000000 00000000 00000000 00000000
[14:09:59] [debug] ESP+000000c0: 00000000 00000000 c0000005 00000000
[14:09:59] [debug] ESP+000000e0: 004ba530 00000000 0019ff94 77378674
[14:09:59] [debug] ESP+00000100: 77ec5d87 003a2000 2154297d 00000000
[14:09:59] [debug] ESP+00000120: 00000000 00000000 2154297d 0019ffa0
[14:09:59] [debug] ESP+00000140: 00000000 0019ffec 77ec5d57 ffffffff
[14:09:59] [debug] ESP+00000160: 003a2000 00000000 78746341 00000020
[14:09:59] [debug] ESP+00000180: 00000020 00000000 00000014 00000001
[14:09:59] [debug] ESP+000001a0: 00000000 00000000 00000000 00000000
[14:09:59] [debug] ESP+000001c0: 00000044 000002e0 0000025c 00000000
[14:09:59] [debug] ESP+000001e0: 00000342 00000000 2d59495b 000008cc
[14:09:59] [debug] ESP+00000200: 32ceeacd 00000bfc 00000042 00000c40
[14:09:59] [debug] ESP+00000220: 0000005e 00000fd0 00000362 00000000
[14:09:59] [debug] ESP+00000240: 00000392 00000010 00000009 000000ec
[14:09:59] [debug] ESP+00000260: 00000001 00000002 00001758 000007a0
[14:09:59] [debug] ESP+00000280: 00000001 00000004 00002d84 00000314
[14:09:59] [debug] ESP+000002a0: 00000002 00000006 00003130 000000cc
[14:09:59] [debug] ESP+000002c0: 00000001 00000009 000032ec 00000028
[14:09:59] [debug] ESP+000002e0: 00000001 64487353 0000002c 00000001
[14:09:59] [debug] ESP+00000300: 00000001 000015a4 0000002c 0000005e
[14:09:59] [debug] ESP+00000320: 00000000 00000000 00000000 00000000
[14:09:59] [debug] ESP+00000340: 00000038 00000000 003a0043 0057005c
[14:09:59] [debug] ESP+00000360: 006e0069 00780053 005c0073 00000000
[14:09:59] [debug] ESP+00000380: 0000025c 00000001 f33271ba 000003c0
[14:09:59] [debug] ESP+000003a0: 2d59495b 00000750 00000032 00000784
[14:09:59] [debug] ESP+000003c0: 00000042 00000ac4 00000330 00000004
[14:09:59] [debug] ESP+000003e0: 00000362 00000005 b1280544 000011b8
[14:09:59] [debug] Loaded modules:
[14:09:59] [debug] 00400000 - 00519000 samp-server.exe
[14:09:59] [debug] 77e60000 - 77fec000 ntdll.dll
[14:09:59] [debug] 77360000 - 77430000 KERNEL32.DLL
[14:09:59] [debug] 76790000 - 76968000 KERNELBASE.dll
[14:09:59] [debug] 744e0000 - 75814000 SHELL32.dll
[14:09:59] [debug] 77c00000 - 77cbd000 msvcrt.dll
[14:09:59] [debug] 76f50000 - 76f88000 cfgmgr32.dll
[14:09:59] [debug] 76d80000 - 76e97000 ucrtbase.dll
[14:09:59] [debug] 77b60000 - 77be8000 shcore.dll
[14:09:59] [debug] 75c70000 - 75d2e000 RPCRT4.dll
[14:09:59] [debug] 75bc0000 - 75be0000 SspiCli.dll
[14:09:59] [debug] 75bb0000 - 75bba000 CRYPTBASE.dll
[14:09:59] [debug] 770e0000 - 77137000 bcryptPrimitives.dll
[14:09:59] [debug] 76ea0000 - 76ee3000 sechost.dll
[14:09:59] [debug] 76970000 - 76bb6000 combase.dll
[14:09:59] [debug] 761c0000 - 76784000 windows.storage.dll
[14:09:59] [debug] 76d00000 - 76d78000 advapi32.dll
[14:09:59] [debug] 76c10000 - 76c55000 shlwapi.dll
[14:09:59] [debug] 77190000 - 771b2000 GDI32.dll
[14:09:59] [debug] 77540000 - 7769f000 gdi32full.dll
[14:09:59] [debug] 774c0000 - 7753c000 msvcp_win.dll
[14:09:59] [debug] 77cc0000 - 77e35000 USER32.dll
[14:09:59] [debug] 77430000 - 77446000 win32u.dll
[14:09:59] [debug] 77bf0000 - 77bfe000 kernel.appcore.dll
[14:09:59] [debug] 77140000 - 77185000 powrprof.dll
[14:09:59] [debug] 77e40000 - 77e54000 profapi.dll
[14:09:59] [debug] 73420000 - 73444000 WINMM.dll
[14:09:59] [debug] 75af0000 - 75af8000 WSOCK32.dll
[14:09:59] [debug] 77450000 - 774b6000 WS2_32.dll
[14:09:59] [debug] 71fc0000 - 71fe3000 winmmbase.dll
[14:09:59] [debug] 77330000 - 77355000 IMM32.DLL
[14:09:59] [debug] 75a90000 - 75ae1000 crashdetect.dll
[14:09:59] [debug] 74230000 - 742ef000 MSVCR100.dll
[14:09:59] [debug] 74190000 - 741f9000 MSVCP100.dll
[14:09:59] [debug] 61c80000 - 61cce000 mysql.dll
[14:09:59] [debug] 75940000 - 759ac000 MSVCP140.dll
[14:09:59] [debug] 75a20000 - 75a34000 VCRUNTIME140.dll
[14:09:59] [debug] 6aae0000 - 6aafa000 log-core.dll
[14:09:59] [debug] 5ea70000 - 5eb3d000 libmariadb.dll
[14:09:59] [debug] 75fb0000 - 76132000 CRYPT32.dll
[14:09:59] [debug] 770d0000 - 770de000 MSASN1.dll
[14:09:59] [debug] 73d40000 - 73d4a000 Secur32.dll
[14:09:59] [debug] 75a00000 - 75a11000 napinsp.dll
[14:09:59] [debug] 759e0000 - 759f6000 pnrpnsp.dll
[14:09:59] [debug] 74200000 - 74213000 NLAapi.dll
[14:09:59] [debug] 73470000 - 734c5000 mswsock.dll
[14:09:59] [debug] 71c10000 - 71ca4000 DNSAPI.dll
[14:09:59] [debug] 75d50000 - 75d57000 NSI.dll
[14:09:59] [debug] 71d10000 - 71d40000 IPHLPAPI.DLL
[14:09:59] [debug] 75a70000 - 75a7c000 winrnr.dll
[14:09:59] [debug] 70290000 - 70298000 rasadhlp.dll
[14:09:59] [debug] 61c10000 - 61c77000 streamer.dll
[14:09:59] [debug] 10000000 - 1000f000 sscanf.dll
[14:09:59] [debug] 70320000 - 7036e000 fwpuclnt.dll

[14:09:59] [debug] 72cb0000 - 72cc9000 bcrypt.dll

forward OnSaveUserCheck2(playerid);
public OnSaveUserCheck2(playerid)
{
SendClientMessage(playerid,-1,"der erste abgerufen.");
printf("der erste abgerufen");
return 1;
}
forward OnSaveUserCheck3(playerid);
public OnSaveUserCheck3(playerid)
{
SendClientMessage(playerid,-1,"der zweite abgerufen.");
printf("der zweite abgerufen");
return 1;
}

hm jetzt ist er gecrasht

Lol ?

Wurde abgerufen
Wurde abgerufen
Wurde abgerufen
Wurde abgerufen
der erste abgerufen
der zweite abgerufen

anscheinend sind das doch nicht die schwarzen schafe

// EDIT:

der zweite abgerufen
der dritte abgerufen
der vierte abgerufen
der fuenfte abgerufen
der siebte abgerufen
der achte abgerufen

Alles in korrekter reihenfolge 3 mal kontrolliert und nichts wird doppelt abgerufen laut script

Kaliber · 25. August 2018

Zitat von JacLos

anscheinend sind das doch nicht die schwarzen schafe

In der Log Datei steht doch, wieso es scheitert, hast dir das eigentlich mal angeschaut?

SQL

[08/25/18 14:09:56] [DEBUG] retrieved and pushed value 'UPDATE `user` SET `Level` = '1', `Money` = '115',  `AdminLevel` = '0', `DonateRank` = '0', `UpgradePoint` = '0', `Registered` = '1', `Sex` = '1', `Age` = '27', `OriginHerkunft` = '1', `Muted` = '0', `Bank` = '0', `Deaths` = '1' WHERE `Username` = 'Tstuser01gg''
[08/25/18 14:09:56] [ERROR] error #1054 while executing query "UPDATE `user` SET  `Gun7` = '0', `Gun8` = '0', `Gun9` = '0', `Gun10` = '0', `Gun11` = '0', `Gun12` = '0', `Ammo1` = '0', `Ammo2` = '0', `Ammo3` = '0', `Ammo4` = '0', `Ammo5` = '0', `Ammo6` = '0', `Ammo7` = '0', `Ammo8` = '0', `Ammo9` = '0', `Ammo10` = '0', `Ammo11` = '0', `Ammo12` = '0'  WHERE `Ùsername` = 'Tstuser01gg'": Unknown column 'Ùsername' in 'where clause'

Etwas stimmt mit deinem String, wo du den Spielernamen speicherst.
Und du solltest deine %d überprüfen, da scheint ein Fehler zu sein...

reaL. · 25. August 2018

mysql_format(handle, query, sizeof(query), "INSERT INTO Hotelzimmer (Hotel, Zimmernummer, Spawn_Out[0], Spawn_Out[1], Spawn_Out[2], Spawn_Out[3], Spawn_In[0], Spawn_In[1], Spawn_In[2], Spawn_In[3], Interior_In, Interior_Out, VirtuelleWelt_In, VirtuelleWelt_Out) VALUES ('%d', '%d', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%d', '%d', '%d', '%d')", 1, zimmerid, Pos[0], Pos[1], Pos[2], Pos[3], 443.0924, 509.3115, 1001.4195, 274.1910, 12, 18, 1000-i, 5);
mysql_pquery(handle, query);

[14:17:10] [ERROR] error #1064 while executing query "INSERT INTO Hotelzimmer (Hotel, Zimmernummer, Spawn_Out[0], Spawn_Out[1], Spawn_Out[2], Spawn_Out[3], Spawn_In[0], Spawn_In[1], Spawn_In[2], Spawn_In[3], Interior_In, Interior_Out, VirtuelleWelt_In, VirtuelleWelt_Out) VALUES ('0', '1', '0.000000', '1734.788452', '-1660.140015', '23.718327', '90.200233', '443.092407', '509.311493', '1001.419495', '1133058163', '12', '18', '1000')": You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[0], Spawn_Out[1], Spawn_Out[2], Spawn_Out[3], Spawn_In[0], Spawn_In[1], Spawn_I' at line 1

Ich finde irgendwie den Fehler nicht

Kaliber · 25. August 2018

Zitat von reaL.

Ich finde irgendwie den Fehler nicht

Du packst random Arrays in dein Query.

Wolltest du evtl ein %s nutzen bei den Spawn_Out[0] oder hast du wirklich die Spalte so genannt?

Dann probier mal sowas: `Spawn_Out[0]`

_Max · 25. August 2018

Hi,
habe einen /setskin Befehl gemacht, der auch wunderbar funktioniert.
Wenn ich relogge, setzt er mir auch den Skin wenn ich spawne, bis dahin alles gut.
Aber wenn ich den Server per /restart neustarte. wird der Skin auf den Standart Wert aus der Datenbank gesetzt.
Der /restart Befehl:
ocmd:restart(playerid, params[]){new nachricht[128];if(!isAdmin(playerid, 4)) return SendClientMessage(playerid, COLOR_GREY, "Diesen Befehl darfst du nicht benutzen!");if(PlayerInfo[playerid][pLoggedIn] == 0) return SendClientMessage(playerid, COLOR_GREY, "Du bist nicht eingeloggt.");format(nachricht, sizeof(nachricht), "[Server-Restart] %s %s hat den Server neugestartet, wir bitten um einen Moment Geduld!", TeamNames[PlayerInfo[playerid][adminlevel]], SpielerName(playerid));SendClientMessageToAll(COLOR_GREEN, nachricht);SendRconCommand("gmx");SaveUserStats(playerid);return 1;}

SaveUserStats:
stock SaveUserStats(playerid){if(!PlayerInfo[playerid][pLoggedIn]) return 1;new query[256];mysql_format(handle, query, sizeof(query), "UPDATE users SET level = '%d', money = '%d', kills = '%d', deaths = '%d', skinid = '%d', adminlevel = '%d' WHERE id = '%d'",PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pKills], PlayerInfo[playerid][pDeaths], PlayerInfo[playerid][pSkinid], PlayerInfo[playerid][adminlevel], PlayerInfo[playerid][p_id]);mysql_pquery(handle, query);return 1;}

In den Logs ist auch nichts zu finden.

Studs · 25. August 2018

Zitat von Kaliber

In der Log Datei steht doch, wieso es scheitert, hast dir das eigentlich mal angeschaut?

SQL

[08/25/18 14:09:56] [DEBUG] retrieved and pushed value 'UPDATE `user` SET `Level` = '1', `Money` = '115',  `AdminLevel` = '0', `DonateRank` = '0', `UpgradePoint` = '0', `Registered` = '1', `Sex` = '1', `Age` = '27', `OriginHerkunft` = '1', `Muted` = '0', `Bank` = '0', `Deaths` = '1' WHERE `Username` = 'Tstuser01gg''
[08/25/18 14:09:56] [ERROR] error #1054 while executing query "UPDATE `user` SET  `Gun7` = '0', `Gun8` = '0', `Gun9` = '0', `Gun10` = '0', `Gun11` = '0', `Gun12` = '0', `Ammo1` = '0', `Ammo2` = '0', `Ammo3` = '0', `Ammo4` = '0', `Ammo5` = '0', `Ammo6` = '0', `Ammo7` = '0', `Ammo8` = '0', `Ammo9` = '0', `Ammo10` = '0', `Ammo11` = '0', `Ammo12` = '0'  WHERE `Ùsername` = 'Tstuser01gg'": Unknown column 'Ùsername' in 'where clause'

Etwas stimmt mit deinem String, wo du den Spielernamen speicherst.
Und du solltest deine %d überprüfen, da scheint ein Fehler zu sein...

Bin mal alle %d s durchgegangen, konnte da jz aber nichts entdecken.

Hab mal nen string anstatt eines enums genommen beim namen speichern, gucke jz nochmal alle logs durch

Kaliber · 25. August 2018

Zitat von _Max

Der /restart Befehl:

Du Restartest den Server, bevor du SaveUserStats verwendest.

Und du speicherst auch nur für den, der den restart Befehl eingibt, du Egoist

Ich empfehle dir sowas:

C

ocmd:restart(playerid, params[])
{
    if(!isAdmin(playerid, 4)) return SendClientMessage(playerid, COLOR_GREY, "Diesen Befehl darfst du nicht benutzen!");
    if(PlayerInfo[playerid][pLoggedIn] == 0) return SendClientMessage(playerid, COLOR_GREY, "Du bist nicht eingeloggt.");
    new nachricht[128];
    format(nachricht, sizeof(nachricht), "[Server-Restart] %s %s hat den Server neugestartet, wir bitten um einen Moment Geduld!", TeamNames[PlayerInfo[playerid][adminlevel]], SpielerName(playerid));
    SendClientMessageToAll(COLOR_GREEN, nachricht);
    for(new i=GetPlayerPoolSize(); i!=-1; i--)
    {
        if(IsPlayerConnected(i) && PlayerInfo[i][pLoggedIn])
        {
            SaveUserStats(i);
        }
    }
    //Bisschen Zeit lassen für die Datenbank
    SetTimer("@restart",1000,0);
    return 1;
}
@restart();@restart()
{
    SendRconCommand("gmx");
    return 1;
}

Alles anzeigen

Und schau mal hier rein: Schneller & strukturierter skripten Eventuell hilft das ein wenig