Beiträge von Kasakow

**Kasakow** · 2. August 2014

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!

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

**Kasakow** · 2. August 2014

Wann bringst du denn die Version 3.4 raus ?

**Kasakow** · 1. August 2014

Wieso sagt mir denn keiner das der Link down ist -.- (Pastebin)
Neuer Link kommt gleich!

**Kasakow** · 1. August 2014

public OnPlayerDisconnect(playerid,reason){
if(IsPlayerNPC(playerid)){
new botname[24];
GetPlayerName(playerid,botname,24);
ConnectNPC(botname,scriptname);
}
return 1;
}

**Kasakow** · 1. August 2014

Nicht ganz, welcher Timeout ? Von dem NPC oder dem Spieler

**Kasakow** · 1. August 2014

Ja natürlich aber mit GetPlayerVehicleID wird das nichts!

Denn nur wenn du in einem Fahrzeug drinnen sitzt ist GetPlayerVehicleID sinnvoll.

Ich schreibe dich mal per PN an!

**Kasakow** · 1. August 2014

tobialvarez

Mit GetPlayerVehicleID lässt du den die des Fahrzeuges auslesen wo du gerade herinnen sitzt, Ich wette wenn du den Befehl eingibst dann führt er dich zum 0 Punkt
Deswegen musst du das ganze anders Struckturieren.
Ist dies ein Selfmade oder GF ?
Denn zeig mal wie du das Fahrzeug zuweist.

**Kasakow** · 1. August 2014

Mit persöhnlich gefällt das Design

**Kasakow** · 31. Juli 2014

Ach komm heyhooo, bitte optimiere mal deinen code, du bist doch kein Anfänger mehr

**Kasakow** · 30. Juli 2014

@Slider

API:http://pastebin.com/iXCKPFaG

PHP Code:

PHP

require "SampQueryAPI.php";
$Funktion = new Funktion();
$host = $Funktion->GetServerStats("ServerIP", "user_server", $username);
$port = $Funktion->GetServerStats("Port", "user_server", $username);
$SampQueryAPI = new SampQueryAPI('$host','$port');

Ich habe mal die '' weggemacht nun klappt es wieder:
IP - Adresse: 37.4.93.178:7777
Hostname: SA-MP 0.3 Server
Players: 0/496
(Das steht im panel)
Nur sagen wir ich stelle den port in der db & server.cfg auf 1234:
IP - Adresse: 37.4.93.178:1234
Der Server ist aktuell offline.
(Das steht im panel)

**Kasakow** · 30. Juli 2014

@Slider

Ja klar, blöd bin ich nicht

Können wir mal per PN schreiben ?

**Kasakow** · 30. Juli 2014

if(dialogid == DIALOG_BANK_ABHEBEN){
if(!response)return 1;
if(!strval(inputtext))return ShowPlayerDialog(playerid,DIALOG_BANK_ABHEBEN,DIALOG_STYLE_INPUT,"Geld abheben","Gebe den Betrag an.","OK","Abbrechen");
if(strval(inputtext)>sInfo[playerid][bankgeld])return ShowPlayerDialog(playerid,DIALOG_BANK_ABHEBEN,DIALOG_STYLE_INPUT,"Geld abheben","So viel geld hast du nicht","OK","Abbrechen");
new string[128];
format(string,128,"Abgehoben: %i$ Neuer Kontostand: %i$",strval(inputtext),sInfo[playerid][bankgeld] -= strval(inputtext)),SCM(playerid,CL_GELB,string);
return sInfo[playerid][bankgeld] -= strval(inputtext);
}

**Kasakow** · 30. Juli 2014

Guten Tag,

Mein Name lautet CIBERKILLER.
Und zwar bräuchte ich Hilfe beim einrichten der Sampqueriapi.
1. Hat sie nur den Port 7777 angenommen, jetzt habe ich was verändert. (Es geht nun garnicht mehr)

Screen:

Mit freundlichen Grüßen,

CIBERKILLER

**Kasakow** · 29. Juli 2014

SetVehicleVelocity ist z.B für einen Speedhack da, (ist nur ein beispiel)

Ah, ich habe mir gerade mal was durchgelesen.

DE:

Zitat

Diese Funktion hat keine Auswirkungen auf un-besetzte Fahrzeuge und hat keine Auswirkungen auf Züge

EN:

Zitat

This function has no affect on un-occupied vehicles and does not affect trains

//Closed muss mir was anderes einfallen lassen

**Kasakow** · 29. Juli 2014

Guten Tag,

Mein Name lautet CIBERKILLER.
Und zwar bäuchte ich mal eure hilfe.
Ich möchte das ein Zug, sich langsam nachvorne bewegt (flüssig) ohne einen NPC herinnen.
Geplant war so so:
@MoveTrain(playerid); @MoveTrain(playerid){
switch(GetPVarInt(playerid, "Zugstatus")){
case 0:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 1:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 2:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 3:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 4:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 5:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 6:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 7:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 8:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 9:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 10:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 11:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 12:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 13:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 14:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 15:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 16:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 17:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 18:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 19:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 20:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 21:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 22:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 23:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 24:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 25:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 26:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 27:SetVehicleVelocity(sInfo[playerid][sZugCar], 0.450000, 0.014314, 0.0090000),SetPVarInt(playerid, "Zugstatus", GetPVarInt(playerid, "Zugstatus") + 1);
case 28:DestroyVehicle(sInfo[playerid][sZugCar]), KillTimer(pTimer[playerid][0]),SetPlayerPos(playerid, 816.8663, -1362.0260, -0.5078), SetPlayerFacingAngle(playerid, 320.6011);
}
return 1;
}

Doch aktuell bewegt er sich nicht oder ich sehe das nicht. (Timer wird ausgeführt)

pTimer[playerid][0] = SetTimerEx("@MoveTrain", 100, true, "i", playerid);

Mit freundlichen Grüßen,

CIBERKILLER

**Kasakow** · 29. Juli 2014

Ich würde dir es machen. - Dazu müssen wir mal unterhalten. (Preis gemäß etc.)

**Kasakow** · 29. Juli 2014

Ja, das ist ja schon in a_samp drinnen.

**Kasakow** · 29. Juli 2014

Ja, klar.
So müsste das auch Funktionieren.

Im Include
NPC_OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
//...
return 1;
}

Im Skript
OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
NPC_OnPlayerKeyStateChange(playerid, newkeys, oldkeys);
return 1;
}

Versuche das mal

**Kasakow** · 28. Juli 2014

Stimmt, wie konnte ich das nicht sehen. Wenn ein Spieler mit dieser ID wieder herein kommt, dann bekommt er den Timer auch ab

Beiträge von Kasakow

MySQL Fehler | R5

MySQL Fehler | R5

Anti-Cheat v3.3.1 - Der sichere Weg, den Server zu schützen!

Checkpoint System - 1.0

bots nach timeout wieder conacten lassen

bots nach timeout wieder conacten lassen

Problem mit der CarID

Problem mit der CarID

[RACE] NicE! Gaming v1.2

[TRIAL]RaceRun - Eine neue Art des Rennens

[PHP]Hilfe beim einrichten der SAMPQUERYAPI

[PHP]Hilfe beim einrichten der SAMPQUERYAPI

Banksystem (Abheben von der Bank)->begrenzung bis 0 dollar

[PHP]Hilfe beim einrichten der SAMPQUERYAPI

Zug startklar machen| Ohne NPC o.ä

Zug startklar machen| Ohne NPC o.ä

Kleines System

a_npc Include in Gamemode einfügen

a_npc Include in Gamemode einfügen

[part] Nico has left the server <0:2>