MySQL Fehler | R5

**Kasakow** · 2. August 2014

Guten Tag,

Mein Name lautet CIBERKILLER.
Und zwar hatte ich diesen Gamemode vor 6 Monaten geschrieben, möchte ich nun aber zum "meisterwerk" machen, zuerst einmal habe ich das ganze auf MySQL umgeschrieben.
Damals habe ich aber mysql_getint benutzt (maddin like<3).
Jetzt arbeite ich aber mit while & mysql_retrive_row().

Und wenn der Spieler geladen wird stürzt der Server ab.

Skriptcode:
stock SpielerLaden(playerid)
{

ShowEuro(playerid);
new query[128];
format(query, sizeof(query), "SELECT * FROM `acc` WHERE `Name`='%s'", GetName(playerid));
mysql_query(query); mysql_store_result();
while(mysql_retrieve_row())
{
mysql_fetch_field_row(query, "id"), sStats[playerid][sSQLID] = strval(query);
mysql_fetch_field_row(query, "Euro"), SetPlayerEuro(playerid, strval(query));
mysql_fetch_field_row(query, "Level"), SetPlayerScore(playerid, strval(query));
mysql_fetch_field_row(sStats[playerid][sGeschlecht], "Geschlecht");
mysql_fetch_field_row(query, "Kleidung"), sStats[playerid][sKleidung] = strval(query);
mysql_fetch_field_row(query, "Adminlevel"), sStats[playerid][sAdmin] = strval(query);
mysql_fetch_field_row(query, "Alter"), sStats[playerid][sAlter] = strval(query);
mysql_fetch_field_row(query, "Armor"), sStats[playerid][sArmor] = floatstr(query);
mysql_fetch_field_row(query, "Wanted"), sStats[playerid][sWanted] = strval(query);
mysql_fetch_field_row(query, "Fraktion"), sStats[playerid][sFraktion] = strval(query);
mysql_fetch_field_row(query, "Nummer"), sStats[playerid][sNummer] = strval(query);
mysql_fetch_field_row(query, "Bankguthaben"), sStats[playerid][sBankMoney] = strval(query);
mysql_fetch_field_row(query, "Fahrschein"), sStats[playerid][sCarLic] = strval(query);
mysql_fetch_field_row(query, "Motorradschein"), sStats[playerid][sMotorradLic] = strval(query);
mysql_fetch_field_row(query, "Flugschein"), sStats[playerid][sFlugLic] = strval(query);
mysql_fetch_field_row(query, "Truckerschein"), sStats[playerid][sTruckerLic] = strval(query);
mysql_fetch_field_row(query, "Waffenschein"), sStats[playerid][sWaffenLic] = strval(query);
mysql_fetch_field_row(query, "Beruf"), sStats[playerid][sBeruf] = strval(query);
mysql_fetch_field_row(query, "Gehalt"), sStats[playerid][sGehalt] = strval(query);
mysql_fetch_field_row(query, "Rang"), sStats[playerid][sRang] = strval(query);
mysql_fetch_field_row(query, "Hitsound"), sStats[playerid][sHitsound] = strval(query);
mysql_fetch_field_row(query, "Autologin"), sStats[playerid][sAutologin] = strval(query);
mysql_fetch_field_row(sStats[playerid][sSpawn], "Spawn");
}
mysql_free_result();

SetPlayerArmour(playerid, sStats[playerid][sArmor]);
TextDrawHideForPlayer(playerid,Textdraw[4]);
TextDrawHideForPlayer(playerid,Textdraw[5]);
TextDrawHideForPlayer(playerid,Textdraw[6]);
TextDrawHideForPlayer(playerid,Textdraw[7]);
TextDrawHideForPlayer(playerid,Textdraw[8]);
SetCameraBehindPlayer(playerid);
Spawn(playerid);
sStats[playerid][Eingeloggt] = 1;

SetTimerEx("eingeloggtmove", 250, false, "i", playerid);

//Zivispawn - VIP
Schild[0]=CreatePlayerObject(playerid, 19353, 1666.5688, -1901.3144, 15.6568, 0.0000, 0.0000, 82.6349);
SetPlayerObjectMaterialText(playerid, Schild[0], "V.I.P", 0, 50, "Arial", 24, 0, -16776961, 0, 1);

Schild[1] = CreatePlayerObject(playerid, 19353, 1660.3814, -1892.7495, 16.8083, -0.1000, 1.5000, -179.9973);
SetPlayerObjectMaterialText(playerid, Schild[1], "Zivispawn", 0, 100, "Courier New", 45, 0, -65536, 0, 1);
return 1;
}

Wenn ich es ausklammere Funktioniert alles (bis auf das Laden xD).

Sollte ich das mal Debuggen was meint ihr leute ?

Mit freundlichen Grüßen,

CIBERKILLER

Jeffry · 2. August 2014

MySQL Debug anschalten, Code debuggen lassen und crashdetect Plugin nutzen.
Dann mal posten was im Server Log steht.

**Kasakow** · 2. August 2014

Jeffry

Crashdetect spuckt das hier aus:

Code

[15:34:49 [debug] Server crashed while executing RP.amx
[15:34:49 [debug] AMX backtrace:
[15:34:49 [debug] #0 native mysql_fetch_field_row () [100065e0] from mysql.DLL
[15:34:49 [debug] #1 000171d0 in ?? (0x00000001) from RP.amx
[15:34:49 [debug] #2 0000b224 in public OnPlayerRequestClass (0x00000001, 0x00000000) from RP.amx
[15:34:49 [debug] Native backtrace:
[15:34:49 [debug] #0 5bddb9f0 in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\MSVCR90.dll
[15:34:49 [debug] #1 100090b4 in ?? () from plugins\mysql.DLL
[15:34:49 [debug] #2 100066b3 in ?? () from plugins\mysql.DLL
[15:34:49 [debug] #3 004010b6 in ?? () from samp-server.exe
[15:34:49 [debug] #4 5c1e543a in ?? () from plugins\crashdetect.DLL
[15:34:49 [debug] #5 5c1e728f in ?? () from plugins\crashdetect.DLL
[15:34:49 [debug] #6 5c1d9d54 in ?? () from plugins\crashdetect.DLL
[15:34:49 [debug] #7 5c1e548a in ?? () from plugins\crashdetect.DLL
[15:34:49 [debug] #8 0046d069 in ?? () from samp-server.exe
[15:34:49 [debug] #9 0048c258 in ?? () from samp-server.exe

Alles anzeigen

Die MySQL Debug(Es wird sehr viel abgefragt)

Code

[15:34:25]  


[15:34:25] ---------------------------


[15:34:25] MySQL Debugging activated (08/02/14)


[15:34:25] ---------------------------


[15:34:25]  


[15:34:25] >> mysql_ping( Connection handle: 1 )


[15:34:25] CMySQLHandler::Ping() - Connection is still alive.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(acc); - Escaped 3 characters to acc.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(Michael_Weiner); - Escaped 14 characters to Michael_Weiner.


[15:34:49] >> mysql_query( Connection handle: 1 )


[15:34:49] CMySQLHandler::Query(SELECT `Adminlevel` FROM `acc` WHERE `Name` = 'Michael_Weiner') - Successfully executed.


[15:34:49] >> mysql_store_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::StoreResult() - Result was stored.


[15:34:49] >> mysql_fetch_int( Connection handle: 1 )


[15:34:49] CMySQLHandler::FetchRow() - Return: 7


[15:34:49] >> mysql_free_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::FreeResult() - Result was successfully free'd.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(192.168.1.105); - Escaped 13 characters to 192.168.1.105.


[15:34:49] >> mysql_query( Connection handle: 1 )


[15:34:49] CMySQLHandler::Query(SELECT * FROM ip WHERE BIP = '192.168.1.105') - Successfully executed.


[15:34:49] >> mysql_store_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::StoreResult() - Result was stored.


[15:34:49] >> mysql_num_rows( Connection handle: 1 )


[15:34:49] CMySQLHandler::NumRows() - Returned 0 row(s)


[15:34:49] >> mysql_free_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::FreeResult() - Result was successfully free'd.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(Michael_Weiner); - Escaped 14 characters to Michael_Weiner.


[15:34:49] >> mysql_query( Connection handle: 1 )


[15:34:49] CMySQLHandler::Query(SELECT * FROM acc WHERE Name = 'Michael_Weiner') - Successfully executed.


[15:34:49] >> mysql_store_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::StoreResult() - Result was stored.


[15:34:49] >> mysql_num_rows( Connection handle: 1 )


[15:34:49] CMySQLHandler::NumRows() - Returned 1 row(s)


[15:34:49] >> mysql_free_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::FreeResult() - Result was successfully free'd.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(acc); - Escaped 3 characters to acc.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(Gesperrt); - Escaped 8 characters to Gesperrt.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(Michael_Weiner); - Escaped 14 characters to Michael_Weiner.


[15:34:49] >> mysql_query( Connection handle: 1 )


[15:34:49] CMySQLHandler::Query(SELECT `Gesperrt` FROM `acc` WHERE `Name` = 'Michael_Weiner') - Successfully executed.


[15:34:49] >> mysql_store_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::StoreResult() - Result was stored.


[15:34:49] >> mysql_fetch_int( Connection handle: 1 )


[15:34:49] CMySQLHandler::FetchRow() - Return: 0


[15:34:49] >> mysql_free_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::FreeResult() - Result was successfully free'd.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(192.168.1.105); - Escaped 13 characters to 192.168.1.105.


[15:34:49] >> mysql_query( Connection handle: 1 )


[15:34:49] CMySQLHandler::Query(SELECT * FROM `alogin` WHERE IP = '192.168.1.105' AND Name = 'Michael_Weiner') - Successfully executed.


[15:34:49] >> mysql_store_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::StoreResult() - Result was stored.


[15:34:49] >> mysql_num_rows( Connection handle: 1 )


[15:34:49] CMySQLHandler::NumRows() - Returned 1 row(s)


[15:34:49] >> mysql_free_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::FreeResult() - Result was successfully free'd.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(192.168.1.105); - Escaped 13 characters to 192.168.1.105.


[15:34:49] >> mysql_query( Connection handle: 1 )


[15:34:49] CMySQLHandler::Query(SELECT * FROM ip WHERE BIP = '192.168.1.105') - Successfully executed.


[15:34:49] >> mysql_store_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::StoreResult() - Result was stored.


[15:34:49] >> mysql_num_rows( Connection handle: 1 )


[15:34:49] CMySQLHandler::NumRows() - Returned 0 row(s)


[15:34:49] >> mysql_free_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::FreeResult() - Result was successfully free'd.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(Michael_Weiner); - Escaped 14 characters to Michael_Weiner.


[15:34:49] >> mysql_query( Connection handle: 1 )


[15:34:49] CMySQLHandler::Query(SELECT * FROM acc WHERE Name = 'Michael_Weiner') - Successfully executed.


[15:34:49] >> mysql_store_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::StoreResult() - Result was stored.


[15:34:49] >> mysql_num_rows( Connection handle: 1 )


[15:34:49] CMySQLHandler::NumRows() - Returned 1 row(s)


[15:34:49] >> mysql_free_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::FreeResult() - Result was successfully free'd.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(acc); - Escaped 3 characters to acc.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(Gesperrt); - Escaped 8 characters to Gesperrt.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(Michael_Weiner); - Escaped 14 characters to Michael_Weiner.


[15:34:49] >> mysql_query( Connection handle: 1 )


[15:34:49] CMySQLHandler::Query(SELECT `Gesperrt` FROM `acc` WHERE `Name` = 'Michael_Weiner') - Successfully executed.


[15:34:49] >> mysql_store_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::StoreResult() - Result was stored.


[15:34:49] >> mysql_fetch_int( Connection handle: 1 )


[15:34:49] CMySQLHandler::FetchRow() - Return: 0


[15:34:49] >> mysql_free_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::FreeResult() - Result was successfully free'd.


[15:34:49] >> mysql_real_escape_string( Connection handle: 1 )


[15:34:49] CMySQLHandler::EscapeString(192.168.1.105); - Escaped 13 characters to 192.168.1.105.


[15:34:49] >> mysql_query( Connection handle: 1 )


[15:34:49] CMySQLHandler::Query(SELECT * FROM `alogin` WHERE IP = '192.168.1.105' AND Name = 'Michael_Weiner') - Successfully executed.


[15:34:49] >> mysql_store_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::StoreResult() - Result was stored.


[15:34:49] >> mysql_num_rows( Connection handle: 1 )


[15:34:49] CMySQLHandler::NumRows() - Returned 1 row(s)


[15:34:49] >> mysql_free_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::FreeResult() - Result was successfully free'd.


[15:34:49] >> mysql_query( Connection handle: 1 )


[15:34:49] CMySQLHandler::Query(SELECT * FROM `acc` WHERE `Name`='Michael_Weiner') - Successfully executed.


[15:34:49] >> mysql_store_result( Connection handle: 1 )


[15:34:49] CMySQLHandler::StoreResult() - Result was stored.


[15:34:49] >> mysql_retrieve_row( Connection handle: 1 )


[15:34:49] >> mysql_fetch_field_row( Connection handle: 1 )

Alles anzeigen

Crashinfo:

Code

--------------------------


SA-MP Server: 0.3z






Exception At Address: 0x0048C258 Module: (samp-server.exe)






Registers:


EAX: 0x04D9A488	EBX: 0x00000001	ECX: 0x00000000	EDX: 0x02A0EB88


ESI: 0x0018F750	EDI: 0x00000088	EBP: 0x00000001	ESP: 0x0018F908


EFLAGS: 0x00010246






Stack:


+0000: 0x0000001B   0x00000000   0x01F790C8   0x0018FB70


+0010: 0x0018FC54   0x01E52D01   0x00000000   0x00000000


+0020: 0x04168218   0x00000000   0x0000FAF5   0x00000028


+0030: 0x00000028   0x00000020   0x0018FB70   0x00000000


+0040: 0x00000000   0x00000000   0x00000000   0x00000000


+0050: 0x00000000   0x00000000   0x00000000   0x00000000


+0060: 0x00000000   0x00000000   0x00000000   0x00000009


+0070: 0xA84C8AF9   0xC44C44ED   0x0ADC9485   0x8EC9D448


+0080: 0xA4D90CC8   0x00000000   0x00000000   0x00000000


+0090: 0x00000000   0x00000000   0x00000000   0x00000000


+00A0: 0x00000000   0x00000000   0x00000000   0x00000000


+00B0: 0x00000000   0x00000000   0x00000000   0x00000000


+00C0: 0x00000000   0x00000000   0x00000000   0x00000000


+00D0: 0x00000000   0x00000000   0x00000000   0x00000000


+00E0: 0x00000000   0x00000000   0x00000000   0x00000000


+00F0: 0x00000000   0x00000000   0x00000000   0x00000000


+0100: 0x00000000   0x00000000   0x00000000   0x00000000


+0110: 0x00000000   0x00000000   0x00000000   0x00000000


+0120: 0x00000000   0x00000000   0x00000000   0x00000000


+0130: 0x00000000   0x00000000   0x00000000   0x00000000






--------------------------






Loaded Modules:


samp-server.exe	A: 0x00400000 - 0x004F5000	(C:\Users\Weiner\Desktop\SAMP - Alles\samp\samp-server.exe)


ntdll.dll	A: 0x77580000 - 0x77700000	(C:\Windows\SysWOW64\ntdll.dll)


kernel32.dll	A: 0x76220000 - 0x76320000	(C:\Windows\syswow64\kernel32.dll)


KERNELBASE.dll	A: 0x76A60000 - 0x76AA6000	(C:\Windows\syswow64\KERNELBASE.dll)


SHELL32.dll	A: 0x75240000 - 0x75E89000	(C:\Windows\syswow64\SHELL32.dll)


msvcrt.dll	A: 0x76530000 - 0x765DC000	(C:\Windows\syswow64\msvcrt.dll)


SHLWAPI.dll	A: 0x76070000 - 0x760C7000	(C:\Windows\syswow64\SHLWAPI.dll)


GDI32.dll	A: 0x770F0000 - 0x77180000	(C:\Windows\syswow64\GDI32.dll)


USER32.dll	A: 0x76AD0000 - 0x76BD0000	(C:\Windows\syswow64\USER32.dll)


ADVAPI32.dll	A: 0x760D0000 - 0x76170000	(C:\Windows\syswow64\ADVAPI32.dll)


sechost.dll	A: 0x76AB0000 - 0x76AC9000	(C:\Windows\SysWOW64\sechost.dll)


RPCRT4.dll	A: 0x75EA0000 - 0x75F90000	(C:\Windows\syswow64\RPCRT4.dll)


SspiCli.dll	A: 0x750F0000 - 0x75150000	(C:\Windows\syswow64\SspiCli.dll)


CRYPTBASE.dll	A: 0x750E0000 - 0x750EC000	(C:\Windows\syswow64\CRYPTBASE.dll)


LPK.dll	A: 0x77550000 - 0x7755A000	(C:\Windows\syswow64\LPK.dll)


USP10.dll	A: 0x75FD0000 - 0x7606D000	(C:\Windows\syswow64\USP10.dll)


WSOCK32.dll	A: 0x721D0000 - 0x721D7000	(C:\Windows\system32\WSOCK32.dll)


WS2_32.dll	A: 0x769F0000 - 0x76A25000	(C:\Windows\syswow64\WS2_32.dll)


NSI.dll	A: 0x768C0000 - 0x768C6000	(C:\Windows\syswow64\NSI.dll)


WINMM.dll	A: 0x6FEE0000 - 0x6FF12000	(C:\Windows\system32\WINMM.dll)


IMM32.DLL	A: 0x75150000 - 0x751B0000	(C:\Windows\system32\IMM32.DLL)


MSCTF.dll	A: 0x76D10000 - 0x76DDC000	(C:\Windows\syswow64\MSCTF.dll)


mysql.DLL	A: 0x10000000 - 0x10013000	(C:\Users\Weiner\Desktop\SAMP - Alles\samp\plugins\mysql.DLL)


LIBMYSQL.dll	A: 0x026D0000 - 0x0290E000	(C:\Users\Weiner\Desktop\SAMP - Alles\samp\LIBMYSQL.dll)


MSVCR90.dll	A: 0x5BDA0000 - 0x5BE43000	(C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\MSVCR90.dll)


MSVCP90.dll	A: 0x5BD10000 - 0x5BD9E000	(C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\MSVCP90.dll)


NLAapi.dll	A: 0x6F960000 - 0x6F970000	(C:\Windows\system32\NLAapi.dll)


mswsock.dll	A: 0x72AE0000 - 0x72B1C000	(C:\Windows\System32\mswsock.dll)


DNSAPI.dll	A: 0x70D50000 - 0x70D94000	(C:\Windows\system32\DNSAPI.dll)


winrnr.dll	A: 0x6F950000 - 0x6F958000	(C:\Windows\System32\winrnr.dll)


napinsp.dll	A: 0x6F940000 - 0x6F950000	(C:\Windows\system32\napinsp.dll)


pnrpnsp.dll	A: 0x6F4B0000 - 0x6F4C2000	(C:\Windows\system32\pnrpnsp.dll)


WLIDNSP.DLL	A: 0x6F480000 - 0x6F4A4000	(C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live\WLIDNSP.DLL)


PSAPI.DLL	A: 0x76520000 - 0x76525000	(C:\Windows\syswow64\PSAPI.DLL)


rasadhlp.dll	A: 0x6ED10000 - 0x6ED16000	(C:\Windows\system32\rasadhlp.dll)


nativechecker.DLL	A: 0x6DAF0000 - 0x6DAF5000	(C:\Users\Weiner\Desktop\SAMP - Alles\samp\plugins\nativechecker.DLL)


streamer.DLL	A: 0x5C200000 - 0x5C23E000	(C:\Users\Weiner\Desktop\SAMP - Alles\samp\plugins\streamer.DLL)


MSVCP100.dll	A: 0x5BCA0000 - 0x5BD09000	(C:\Windows\system32\MSVCP100.dll)


MSVCR100.dll	A: 0x5BBE0000 - 0x5BC9F000	(C:\Windows\system32\MSVCR100.dll)


dbghelp.dll	A: 0x6EE70000 - 0x6EF5B000	(C:\Windows\system32\dbghelp.dll)


wshtcpip.dll	A: 0x72A80000 - 0x72A85000	(C:\Windows\System32\wshtcpip.dll)


IPHLPAPI.DLL	A: 0x70840000 - 0x7085C000	(C:\Windows\system32\IPHLPAPI.DLL)


WINNSI.DLL	A: 0x70830000 - 0x70837000	(C:\Windows\system32\WINNSI.DLL)


uxtheme.dll	A: 0x6FB70000 - 0x6FBF0000	(C:\Windows\system32\uxtheme.dll)


PROPSYS.dll	A: 0x6F610000 - 0x6F705000	(C:\Windows\system32\PROPSYS.dll)


OLEAUT32.dll	A: 0x76C80000 - 0x76D0F000	(C:\Windows\syswow64\OLEAUT32.dll)


comctl32.dll	A: 0x6F9B0000 - 0x6FB4E000	(C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7600.16385_none_421189da2b7fabfc\comctl32.dll)


apphelp.dll	A: 0x706F0000 - 0x7073B000	(C:\Windows\system32\apphelp.dll)


CLBCatQ.DLL	A: 0x76E00000 - 0x76E83000	(C:\Windows\syswow64\CLBCatQ.DLL)


iertutil.dll	A: 0x76320000 - 0x76519000	(C:\Windows\syswow64\iertutil.dll)


urlmon.dll	A: 0x76780000 - 0x768B5000	(C:\Windows\syswow64\urlmon.dll)


CRYPT32.dll	A: 0x768D0000 - 0x769EC000	(C:\Windows\syswow64\CRYPT32.dll)


MSASN1.dll	A: 0x75E90000 - 0x75E9C000	(C:\Windows\syswow64\MSASN1.dll)


SETUPAPI.dll	A: 0x765E0000 - 0x7677D000	(C:\Windows\syswow64\SETUPAPI.dll)


CFGMGR32.dll	A: 0x75FA0000 - 0x75FC7000	(C:\Windows\syswow64\CFGMGR32.dll)


DEVOBJ.dll	A: 0x76DE0000 - 0x76DF2000	(C:\Windows\syswow64\DEVOBJ.dll)


ntmarta.dll	A: 0x74F30000 - 0x74F51000	(C:\Windows\system32\ntmarta.dll)


WLDAP32.dll	A: 0x76170000 - 0x761B5000	(C:\Windows\syswow64\WLDAP32.dll)

Alles anzeigen

OnPlayerRequestClass:
public OnPlayerRequestClass(playerid, classid)
{
if(IsPlayerNPC(playerid))return 1;
if(mysql_CheckIP(playerid) == 1)
{
new string[128];
format(string, sizeof(string), "* Der IP Gesperrte Spieler %s hat versucht sich einzuloggen!",GetName(playerid));
SendAdminMessage(playerid, HellRot, string);
SendClientMessage(playerid, Rot, "Deine IP wurde Gesperrt. Du wirst nun gekickt!");
Kick_Ex(playerid);
return 1;
}
if(mysql_CheckBan(playerid) == 1)
{
new string[128];
format(string, sizeof(string), "* Der Gesperrte Spieler %s hat versucht sich einzuloggen!",GetName(playerid));
SendAdminMessage(playerid,HellRot, string);
SendClientMessage(playerid, Rot, "Dein Account wurde Gesperrt. Du wirst nun gekickt!");
Kick_Ex(playerid);
return 1;
}
if(strfind(GetName(playerid),"_",true) == -1)
{
SendClientMessage(playerid, Rot, "Dies ist kein RolePlay Name (Vorname_Nachname)");
return Kick_Ex(playerid);
}
if(strfind(GetName(playerid),"[",true) != -1 && sStats[playerid][sAdmin] == 0)
{
SendClientMessage(playerid, Rot, "Du hast verbotene Zeichen im Namen '['");
return Kick_Ex(playerid);
}
if(mysql_autologin(playerid))
{
SpielerLaden(playerid);
SetCameraBehindPlayer(playerid);
SendClientMessage(playerid, Weis, "Du hast dich erfolgreich über autologin eingeloggt!");
return StopAudioStreamForPlayer(playerid);
}
return 1;
}

Ich werde immer mit autlogin eingeloggt, es liegt also warscheinlich an Spielerladen!

Jeffry · 2. August 2014

Füge mal nach dem mysql_store_result() in deinem SpielerLaden das hier ein:

new result[256];
mysql_fetch_row(result);
print(result);

Wird das geprintet? Wenn ja, könntest du es darüber splitten (sscanf oder manuell).

**Kasakow** · 2. August 2014

Jeffry

Jetzt crash der server nicht mehr. Nur das komische ist: Es gibt die werte im print aus aber ich bekomme das zeug nicht
[21:39:40] CMySQLHandler::FetchRow() - Return: 2|Michael_Weiner|b697b5fed028c19dcbc...|4000|0|0||15|7|0|0|0|0|0|0|0|0|0|0|0|0|0|0||0|0|http://xh244.xeon-hosting.de/JBB.wav

ShowEuro(playerid);
new query[128];
format(query, sizeof(query), "SELECT * FROM `acc` WHERE `Name`='%s'", GetName(playerid));
mysql_query(query); mysql_store_result();
new result[128];
mysql_fetch_row(result), print(result);
while(mysql_retrieve_row())
{
mysql_fetch_field_row(query, "id"), sStats[playerid][sSQLID] = strval(query);
mysql_fetch_field_row(query, "Euro"), SetPlayerEuro(playerid, strval(query));
mysql_fetch_field_row(query, "Level"), SetPlayerScore(playerid, strval(query));
mysql_fetch_field_row(sStats[playerid][sGeschlecht], "Geschlecht");
mysql_fetch_field_row(query, "Kleidung"), sStats[playerid][sKleidung] = strval(query);
mysql_fetch_field_row(query, "Adminlevel"), sStats[playerid][sAdmin] = strval(query);
mysql_fetch_field_row(query, "Alter"), sStats[playerid][sAlter] = strval(query);
mysql_fetch_field_row(query, "Armor"), sStats[playerid][sArmor] = floatstr(query);
mysql_fetch_field_row(query, "Wanted"), sStats[playerid][sWanted] = strval(query);
mysql_fetch_field_row(query, "Fraktion"), sStats[playerid][sFraktion] = strval(query);
mysql_fetch_field_row(query, "Nummer"), sStats[playerid][sNummer] = strval(query);
mysql_fetch_field_row(query, "Bankguthaben"), sStats[playerid][sBankMoney] = strval(query);
mysql_fetch_field_row(query, "Fahrschein"), sStats[playerid][sCarLic] = strval(query);
mysql_fetch_field_row(query, "Motorradschein"), sStats[playerid][sMotorradLic] = strval(query);
mysql_fetch_field_row(query, "Flugschein"), sStats[playerid][sFlugLic] = strval(query);
mysql_fetch_field_row(query, "Truckerschein"), sStats[playerid][sTruckerLic] = strval(query);
mysql_fetch_field_row(query, "Waffenschein"), sStats[playerid][sWaffenLic] = strval(query);
mysql_fetch_field_row(query, "Beruf"), sStats[playerid][sBeruf] = strval(query);
mysql_fetch_field_row(query, "Gehalt"), sStats[playerid][sGehalt] = strval(query);
mysql_fetch_field_row(query, "Rang"), sStats[playerid][sRang] = strval(query);
mysql_fetch_field_row(query, "Hitsound"), sStats[playerid][sHitsound] = strval(query);
mysql_fetch_field_row(query, "Autologin"), sStats[playerid][sAutoLogin] = strval(query);
mysql_fetch_field_row(sStats[playerid][sSpawn], "Spawn");
}
mysql_free_result();

Jeffry · 2. August 2014

Gut!
Jetzt kannst du die ganze while-Schleife weg machen.

Dann nimm dir genau diesen Post als Beispiel: MYSQL Lädt falsche werte
string in dem Post entspricht "result" bei dir, musst entweder "result" zu "string" umbenennen, oder andersrum.

Dann bei den case's die jeweiligen Variablen setzen.

EDIT:
0 = id
1 = Name
2 = Passwort hash
etc... (du weißt ja wie deine DB aufgebaut ist.)

Wenn du einen Wert nicht auslesen willst, lasse die case ID einfach aus.

**Kasakow** · 2. August 2014

Naja das komische ist, Adminlevel lädt er
Aber alles andere nicht

Jeffry · 2. August 2014

Vielleicht lädst du das noch wo anders, oder du hast den Wert bei OnPlayerDisconnect nicht zurück gesetzt.
Sieh dir bitte den Beispielcode an, den ich dir oben verlinkt habe, damit solltest du klar kommen.

**Kasakow** · 2. August 2014

Dann soll ich das ganze also sozusagen "splitten" ? Weil da ein | herinnen ist? und nach & nach nach row das zeug auslesen lassen oder wie ?
Also Adminlevel liest er allgemein aus.. egal welche zahl

Jeffry · 2. August 2014

Ja, splitten.
Die while-Schleife (und alles was darin ist) entfernen und das an die Stelle setzen:

strins(string, "|", strlen(string));
new oldi=0;
new count=0;
for(new i=0; i<strlen(string); i++)
{
if(string[i]=='|')
{
count++;
new tmpstring[sizeof(string)]; tmpstring=string;
strdel(tmpstring, i, strlen(tmpstring));
strdel(tmpstring, 0, oldi+1);
switch(count)
{
case 1: id = strval(tmpstring);
case 2: format(name, sizeof(name), "%s", tmpstring);
case 3: x = floatstr(tmpstring);
case 4: y = floatstr(tmpstring);
case 5: z = floatstr(tmpstring);
case 6: a = floatstr(tmpstring);
case 7: interior = strval(tmpstring);
//usw...
}
oldi=i;
}
}

Dann bei den case's deine Variablen (sStats[playerid][sSQLID], etc) an die richtige Stelle setzen und mit strval (Integer), format (String) oder floatstr (Float) auslesen.

Nicht vergessen das vorherige "result" zu "string" umzubenennen, oder andersrum.

**Kasakow** · 2. August 2014

Jeffry

Ok, das wäre eine Möglichkeit gibt es noch andere um strings,integer,floats auszulesen ?

Jeffry · 2. August 2014

Das sscanf Plugin ist eine Alternative. Davon bin ich aber kein Freund, ich mache es lieber nach dieser Methode, da weiß ich, dass es funktioniert, und zwar immer.

**Kasakow** · 2. August 2014

Wie soll ich das mit sscanf machen habe dies noch nicht gemacht.

sscanf(params,"iiis[lenght]", var1, var2....); oder wie geht das ?

Manniac · 2. August 2014

Lass das mit sscanf. Wenn man sich nicht auskennt, kann man viel falsch machen. ( Vorallem, da man nicht weiß, was sscanf genau macht - im gegensatz zu Jeffrys code)

**Kasakow** · 2. August 2014

Ich weis was sscanf ist und ich verwende es normalerweise für Parameter. (/kick [param1] [param2])
Müsste nur erklärt bekommen wie das genau Funktioniert

maddin · 2. August 2014

[ SCRIPTING ] sscanf 2.0
Ist zwar schon uralt, aber soweit ich weiss hat sich an sscanf nicht großartig was verändert. Im Tutorial ist auch ein Beispiel mit Erklärung wie man mit MySQL und enum arbeitet

**Kasakow** · 3. August 2014

So habe das ganze mal auf meinen Linux VServer gelegt, sowie db gewechselt, klappt nun mit while & mysql_retrieve_row wunderbar

Mellnik · 3. August 2014

Eh warum nicht gleich cache und threaded mit R39-2 lul

MySQL Fehler | R5

Beitrag von Kasakow (2. August 2014)

Beitrag von Kasakow (2. August 2014)