Beiträge von Studs
-
-
Code
Alles anzeigenSA-MP Dedicated Server ---------------------- v0.3.7-R2, (C)2005-2015 SA-MP Team [15:50:30] [15:50:30] Server Plugins [15:50:30] -------------- [15:50:30] Loading plugin: crashdetect [15:50:30] CrashDetect plugin 4.19.1 [15:50:30] Loaded. [15:50:30] Loading plugin: mysql [15:50:30] >> plugin.mysql: R41-4 successfully loaded. [15:50:30] Loaded. [15:50:30] Loading plugin: streamer [15:50:30] *** Streamer Plugin v2.9.3 by Incognito loaded *** [15:50:30] Loaded. [15:50:30] Loading plugin: sscanf [15:50:30] [15:50:30] =============================== [15:50:30] sscanf plugin loaded. [15:50:30] Version: 2.8.2 [15:50:30] (c) 2012 Alex "Y_Less" Cole [15:50:30] =============================== [15:50:30] Loaded. [15:50:30] Loaded 4 plugins. [15:50:30] [15:50:30] Filterscripts [15:50:30] --------------- [15:50:30] Loading filterscript 'ls_elevator.amx'... [15:50:30] Loading filterscript 'ls_beachside.amx'... [15:50:30] [15:50:30] |--------------------------------------------------- [15:50:30] |--- LS BeachSide Filterscript [15:50:30] |-- Script v1.03 [15:50:30] |-- 19th April 2015 [15:50:30] |--------------------------------------------------- [15:50:30] |-- LS BeachSide Building Elevator created [15:50:30] |--------------------------------------------------- [15:50:30] Loading filterscript 'ls_apartments1.amx'... [15:50:30] [15:50:30] |--------------------------------------------------- [15:50:30] |--- LS Apartments 1 Filterscript [15:50:30] |-- Script v1.02 [15:50:30] |-- 5th February 2015 [15:50:30] |--------------------------------------------------- [15:50:30] |-- LS Apartments 1 Building object created [15:50:30] |-- LS Apartments 1 Car Park object created [15:50:30] |-- LS Apartments 1 Elevator created [15:50:30] |--------------------------------------------------- [15:50:30] Loaded 3 filterscripts. [15:50:30] [MySQL] Verbindungsaufbau... [15:50:30] [MySQL] Die Verbindung zur Datenbank wurde erfolgreich hergestellt! Handle: 1 [15:50:31] ---------------------------------- [15:50:31] Blank Gamemode by your name here [15:50:31] ---------------------------------- [15:50:31] Number of vehicle models: 5 [15:50:31] OnNormalCarsLoad wurde aufgerufen [15:50:50] [connection] 127.0.0.1:58417 requests connection cookie. [15:50:51] [connection] incoming connection: 127.0.0.1:58417 id: 0 [15:51:01] [connection] incoming connection: 127.0.0.1:58423 id: 0 [15:51:11] [connection] incoming connection: 127.0.0.1:58424 id: 0 [15:51:28] [connection] incoming connection: 127.0.0.1:58252 id: 0 [15:51:28] [join] 123 has joined the server (0:127.0.0.1) [15:51:28] ADMIN: Admin 123(0) logged in (level 12) [15:51:29] OnPlayerCarsLoad wurde aufgerufen [15:51:53] INSERT INTO `actors` (actorx, actory, actorz, actora, actorskin, actoryes,actorvworld) VALUES ('317.400726', '-1645.307861', '33.140674','221.022567' ,'15', '1','0') [15:51:54] PlayerID 0 erstellte actor ID 29 Console input: gmx [15:54:49] [debug] Server crashed due to an unknown error [15:54:50] [debug] Native backtrace: [15:54:50] [debug] #0 004792fa in ?? () from samp-server.exe [15:54:50] [debug] #1 71fa6f17 in ?? () from plugins\streamer.DLL [15:54:50] [debug] #2 00469a66 in ?? () from samp-server.exe [15:54:50] [debug] #3 0048d4db in ?? () from samp-server.exe [15:54:50] [debug] #4 0049b4a1 in ?? () from samp-server.exe [15:54:50] [debug] #5 0049b4b1 in ?? () from samp-server.exe [15:54:50] [debug] Registers: [15:54:50] [debug] EAX: 04530003 EBX: 026454a4 ECX: 00000000 EDX: 00000003 [15:54:50] [debug] ESI: 004792e0 EDI: 00000003 EBP: 0049b4a1 ESP: 0019fe98 [15:54:50] [debug] EIP: 0049b4b1 EFLAGS: 00010297 [15:54:50] [debug] Stack: [15:54:50] [debug] ESP+00000000: 004ab4a0 0019ff70 004ab0e1 ffffffff [15:54:50] [debug] ESP+00000020: 00000094 00000006 00000002 000023f0 [15:54:50] [debug] ESP+00000040: 00000000 00000000 00000000 00000000 [15:54:50] [debug] ESP+00000060: 00000000 00000000 00000000 00000000 [15:54:50] [debug] ESP+00000080: 00000000 00000000 00000000 00000000 [15:54:50] [debug] ESP+000000a0: 00000000 00000000 00000000 00000000 [15:54:50] [debug] ESP+000000c0: 00000000 00000000 c0000005 00000000 [15:54:50] [debug] ESP+000000e0: 004ba530 00000000 0019ff94 76328674 [15:54:50] [debug] ESP+00000100: 76fa5d87 00313000 d6559e86 00000000 [15:54:50] [debug] ESP+00000120: 00000000 00000000 d6559e86 0019ffa0 [15:54:50] [debug] ESP+00000140: 00000000 0019ffec 76fa5d57 ffffffff [15:54:50] [debug] ESP+00000160: 00313000 00000000 78746341 00000020 [15:54:50] [debug] ESP+00000180: 00000020 00000000 00000014 00000001 [15:54:50] [debug] ESP+000001a0: 00000000 00000000 00000000 00000000 [15:54:50] [debug] ESP+000001c0: 00000044 000002e0 0000025c 00000000 [15:54:50] [debug] ESP+000001e0: 00000342 00000000 2d59495b 000008cc [15:54:50] [debug] ESP+00000200: 32ceeacd 00000bfc 00000042 00000c40 [15:54:50] [debug] ESP+00000220: 0000005e 00000fd0 00000362 00000000 [15:54:50] [debug] ESP+00000240: 00000392 00000010 00000009 000000ec [15:54:50] [debug] ESP+00000260: 00000001 00000002 00001758 000007a0 [15:54:50] [debug] ESP+00000280: 00000001 00000004 00002d84 00000314 [15:54:50] [debug] ESP+000002a0: 00000002 00000006 00003130 000000cc [15:54:50] [debug] ESP+000002c0: 00000001 00000009 000032ec 00000028 [15:54:50] [debug] ESP+000002e0: 00000001 64487353 0000002c 00000001 [15:54:50] [debug] ESP+00000300: 00000001 000015a4 0000002c 0000005e [15:54:50] [debug] ESP+00000320: 00000000 00000000 00000000 00000000 [15:54:50] [debug] ESP+00000340: 00000038 00000000 003a0043 0057005c [15:54:50] [debug] ESP+00000360: 006e0069 00780053 005c0073 00000000 [15:54:50] [debug] ESP+00000380: 0000025c 00000001 f33271ba 000003c0 [15:54:50] [debug] ESP+000003a0: 2d59495b 00000750 00000032 00000784 [15:54:50] [debug] ESP+000003c0: 00000042 00000ac4 00000330 00000004 [15:54:50] [debug] ESP+000003e0: 00000362 00000005 b1280544 000011b8 [15:54:50] [debug] Loaded modules: [15:54:50] [debug] 00400000 - 00519000 samp-server.exe [15:54:50] [debug] 76f40000 - 770cc000 ntdll.dll [15:54:50] [debug] 76310000 - 763e0000 KERNEL32.DLL [15:54:50] [debug] 756a0000 - 75878000 KERNELBASE.dll [15:54:50] [debug] 73a10000 - 74d44000 SHELL32.dll [15:54:50] [debug] 769e0000 - 76a9d000 msvcrt.dll [15:54:50] [debug] 76220000 - 76258000 cfgmgr32.dll [15:54:50] [debug] 754a0000 - 755b7000 ucrtbase.dll [15:54:50] [debug] 768e0000 - 76968000 shcore.dll [15:54:50] [debug] 76e80000 - 76f3e000 RPCRT4.dll [15:54:50] [debug] 73960000 - 73980000 SspiCli.dll [15:54:50] [debug] 73950000 - 7395a000 CRYPTBASE.dll [15:54:50] [debug] 762b0000 - 76307000 bcryptPrimitives.dll [15:54:50] [debug] 75a80000 - 75ac3000 sechost.dll [15:54:50] [debug] 76c30000 - 76e76000 combase.dll [15:54:50] [debug] 74ed0000 - 75494000 windows.storage.dll [15:54:50] [debug] 765e0000 - 76658000 advapi32.dll [15:54:50] [debug] 76570000 - 765b5000 shlwapi.dll [15:54:50] [debug] 74e30000 - 74e52000 GDI32.dll [15:54:50] [debug] 76ad0000 - 76c2f000 gdi32full.dll [15:54:50] [debug] 75880000 - 758fc000 msvcp_win.dll [15:54:50] [debug] 75900000 - 75a75000 USER32.dll [15:54:50] [debug] 769c0000 - 769d6000 win32u.dll [15:54:50] [debug] 75ae0000 - 75aee000 kernel.appcore.dll [15:54:50] [debug] 76260000 - 762a5000 powrprof.dll [15:54:50] [debug] 765c0000 - 765d4000 profapi.dll [15:54:50] [debug] 723d0000 - 723f4000 WINMM.dll [15:54:50] [debug] 73680000 - 73688000 WSOCK32.dll [15:54:50] [debug] 74e60000 - 74ec6000 WS2_32.dll [15:54:50] [debug] 6f8c0000 - 6f8e3000 winmmbase.dll [15:54:50] [debug] 76aa0000 - 76ac5000 IMM32.DLL [15:54:50] [debug] 73620000 - 73671000 crashdetect.DLL [15:54:50] [debug] 735b0000 - 73619000 MSVCP100.dll [15:54:50] [debug] 73400000 - 734bf000 MSVCR100.dll [15:54:50] [debug] 73560000 - 735ae000 mysql.DLL [15:54:50] [debug] 732c0000 - 7332c000 MSVCP140.dll [15:54:50] [debug] 73330000 - 733fd000 libmariadb.dll [15:54:50] [debug] 73520000 - 73534000 VCRUNTIME140.dll [15:54:50] [debug] 73540000 - 7355a000 log-core.dll [15:54:50] [debug] 75c40000 - 75dc2000 CRYPT32.dll [15:54:50] [debug] 75dd0000 - 75dde000 MSASN1.dll [15:54:50] [debug] 731e0000 - 731ea000 Secur32.dll [15:54:50] [debug] 732a0000 - 732b1000 napinsp.dll [15:54:50] [debug] 73280000 - 73296000 pnrpnsp.dll [15:54:50] [debug] 73260000 - 73273000 NLAapi.dll [15:54:50] [debug] 72f30000 - 72f85000 mswsock.dll [15:54:50] [debug] 6f800000 - 6f894000 DNSAPI.dll [15:54:50] [debug] 75ad0000 - 75ad7000 NSI.dll [15:54:50] [debug] 70f60000 - 70f90000 IPHLPAPI.DLL [15:54:50] [debug] 73250000 - 7325c000 winrnr.dll [15:54:50] [debug] 6e950000 - 6e958000 rasadhlp.dll [15:54:50] [debug] 71f60000 - 71fc7000 streamer.DLL [15:54:50] [debug] 10000000 - 1000f000 sscanf.DLL [15:54:50] [debug] 6e960000 - 6e9ae000 fwpuclnt.dll [15:54:50] [debug] 71e40000 - 71e59000 bcrypt.dll
-
aber natürlich
Code
Alles anzeigen[15:50:31] Number of vehicle models: 5 [15:50:31] OnNormalCarsLoad wurde aufgerufen [15:50:50] [connection] 127.0.0.1:58417 requests connection cookie. [15:50:51] [connection] incoming connection: 127.0.0.1:58417 id: 0 [15:51:01] [connection] incoming connection: 127.0.0.1:58423 id: 0 [15:51:11] [connection] incoming connection: 127.0.0.1:58424 id: 0 [15:51:28] [connection] incoming connection: 127.0.0.1:58252 id: 0 [15:51:28] [join] Owens has joined the server (0:127.0.0.1) [15:51:28] ADMIN: Admin Owens(0) logged in (level 12) [15:51:29] OnPlayerCarsLoad wurde aufgerufen [15:51:53] INSERT INTO `actors` (actorx, actory, actorz, actora, actorskin, actoryes,actorvworld) VALUES ('317.400726', '-1645.307861', '33.140674','221.022567' ,'15', '1','0') [15:51:54] PlayerID 0 erstellte actor ID 29 Console input: gmx [15:54:49] [debug] Server crashed due to an unknown error [15:54:50] [debug] Native backtrace: [15:54:50] [debug] #0 004792fa in ?? () from samp-server.exe [15:54:50] [debug] #1 71fa6f17 in ?? () from plugins\streamer.DLL [15:54:50] [debug] #2 00469a66 in ?? () from samp-server.exe [15:54:50] [debug] #3 0048d4db in ?? () from samp-server.exe [15:54:50] [debug] #4 0049b4a1 in ?? () from samp-server.exe [15:54:50] [debug] #5 0049b4b1 in ?? () from samp-server.exe [15:54:50] [debug] Registers: [15:54:50] [debug] EAX: 04530003 EBX: 026454a4 ECX: 00000000 EDX: 00000003 [15:54:50] [debug] ESI: 004792e0 EDI: 00000003 EBP: 0049b4a1 ESP: 0019fe98 [15:54:50] [debug] EIP: 0049b4b1 EFLAGS: 00010297 [15:54:50] [debug] Stack: [15:54:50] [debug] ESP+00000000: 004ab4a0 0019ff70 004ab0e1 ffffffff [15:54:50] [debug] ESP+00000020: 00000094 00000006 00000002 000023f0 [15:54:50] [debug] ESP+00000040: 00000000 00000000 00000000 00000000 [15:54:50] [debug] ESP+00000060: 00000000 00000000 00000000 00000000 [15:54:50] [debug] ESP+00000080: 00000000 00000000 00000000 00000000 [15:54:50] [debug] ESP+000000a0: 00000000 00000000 00000000 00000000 [15:54:50] [debug] ESP+000000c0: 00000000 00000000 c0000005 00000000 [15:54:50] [debug] ESP+000000e0: 004ba530 00000000 0019ff94 76328674 [15:54:50] [debug] ESP+00000100: 76fa5d87 00313000 d6559e86 00000000 [15:54:50] [debug] ESP+00000120: 00000000 00000000 d6559e86 0019ffa0 [15:54:50] [debug] ESP+00000140: 00000000 0019ffec 76fa5d57 ffffffff [15:54:50] [debug] ESP+00000160: 00313000 00000000 78746341 00000020 [15:54:50] [debug] ESP+00000180: 00000020 00000000 00000014 00000001 [15:54:50] [debug] ESP+000001a0: 00000000 00000000 00000000 00000000 [15:54:50] [debug] ESP+000001c0: 00000044 000002e0 0000025c 00000000 [15:54:50] [debug] ESP+000001e0: 00000342 00000000 2d59495b 000008cc [15:54:50] [debug] ESP+00000200: 32ceeacd 00000bfc 00000042 00000c40 [15:54:50] [debug] ESP+00000220: 0000005e 00000fd0 00000362 00000000 [15:54:50] [debug] ESP+00000240: 00000392 00000010 00000009 000000ec [15:54:50] [debug] ESP+00000260: 00000001 00000002 00001758 000007a0 [15:54:50] [debug] ESP+00000280: 00000001 00000004 00002d84 00000314 [15:54:50] [debug] ESP+000002a0: 00000002 00000006 00003130 000000cc [15:54:50] [debug] ESP+000002c0: 00000001 00000009 000032ec 00000028 [15:54:50] [debug] ESP+000002e0: 00000001 64487353 0000002c 00000001 [15:54:50] [debug] ESP+00000300: 00000001 000015a4 0000002c 0000005e [15:54:50] [debug] ESP+00000320: 00000000 00000000 00000000 00000000 [15:54:50] [debug] ESP+00000340: 00000038 00000000 003a0043 0057005c [15:54:50] [debug] ESP+00000360: 006e0069 00780053 005c0073 00000000 [15:54:50] [debug] ESP+00000380: 0000025c 00000001 f33271ba 000003c0 [15:54:50] [debug] ESP+000003a0: 2d59495b 00000750 00000032 00000784 [15:54:50] [debug] ESP+000003c0: 00000042 00000ac4 00000330 00000004 [15:54:50] [debug] ESP+000003e0: 00000362 00000005 b1280544 000011b8 [15:54:50] [debug] Loaded modules: [15:54:50] [debug] 00400000 - 00519000 samp-server.exe [15:54:50] [debug] 76f40000 - 770cc000 ntdll.dll [15:54:50] [debug] 76310000 - 763e0000 KERNEL32.DLL [15:54:50] [debug] 756a0000 - 75878000 KERNELBASE.dll [15:54:50] [debug] 73a10000 - 74d44000 SHELL32.dll [15:54:50] [debug] 769e0000 - 76a9d000 msvcrt.dll [15:54:50] [debug] 76220000 - 76258000 cfgmgr32.dll [15:54:50] [debug] 754a0000 - 755b7000 ucrtbase.dll [15:54:50] [debug] 768e0000 - 76968000 shcore.dll [15:54:50] [debug] 76e80000 - 76f3e000 RPCRT4.dll [15:54:50] [debug] 73960000 - 73980000 SspiCli.dll [15:54:50] [debug] 73950000 - 7395a000 CRYPTBASE.dll [15:54:50] [debug] 762b0000 - 76307000 bcryptPrimitives.dll [15:54:50] [debug] 75a80000 - 75ac3000 sechost.dll [15:54:50] [debug] 76c30000 - 76e76000 combase.dll [15:54:50] [debug] 74ed0000 - 75494000 windows.storage.dll [15:54:50] [debug] 765e0000 - 76658000 advapi32.dll [15:54:50] [debug] 76570000 - 765b5000 shlwapi.dll [15:54:50] [debug] 74e30000 - 74e52000 GDI32.dll [15:54:50] [debug] 76ad0000 - 76c2f000 gdi32full.dll [15:54:50] [debug] 75880000 - 758fc000 msvcp_win.dll [15:54:50] [debug] 75900000 - 75a75000 USER32.dll [15:54:50] [debug] 769c0000 - 769d6000 win32u.dll [15:54:50] [debug] 75ae0000 - 75aee000 kernel.appcore.dll [15:54:50] [debug] 76260000 - 762a5000 powrprof.dll [15:54:50] [debug] 765c0000 - 765d4000 profapi.dll [15:54:50] [debug] 723d0000 - 723f4000 WINMM.dll [15:54:50] [debug] 73680000 - 73688000 WSOCK32.dll [15:54:50] [debug] 74e60000 - 74ec6000 WS2_32.dll [15:54:50] [debug] 6f8c0000 - 6f8e3000 winmmbase.dll [15:54:50] [debug] 76aa0000 - 76ac5000 IMM32.DLL [15:54:50] [debug] 73620000 - 73671000 crashdetect.DLL [15:54:50] [debug] 735b0000 - 73619000 MSVCP100.dll [15:54:50] [debug] 73400000 - 734bf000 MSVCR100.dll [15:54:50] [debug] 73560000 - 735ae000 mysql.DLL [15:54:50] [debug] 732c0000 - 7332c000 MSVCP140.dll [15:54:50] [debug] 73330000 - 733fd000 libmariadb.dll [15:54:50] [debug] 73520000 - 73534000 VCRUNTIME140.dll [15:54:50] [debug] 73540000 - 7355a000 log-core.dll [15:54:50] [debug] 75c40000 - 75dc2000 CRYPT32.dll [15:54:50] [debug] 75dd0000 - 75dde000 MSASN1.dll [15:54:50] [debug] 731e0000 - 731ea000 Secur32.dll [15:54:50] [debug] 732a0000 - 732b1000 napinsp.dll [15:54:50] [debug] 73280000 - 73296000 pnrpnsp.dll [15:54:50] [debug] 73260000 - 73273000 NLAapi.dll [15:54:50] [debug] 72f30000 - 72f85000 mswsock.dll [15:54:50] [debug] 6f800000 - 6f894000 DNSAPI.dll [15:54:50] [debug] 75ad0000 - 75ad7000 NSI.dll [15:54:50] [debug] 70f60000 - 70f90000 IPHLPAPI.DLL [15:54:50] [debug] 73250000 - 7325c000 winrnr.dll [15:54:50] [debug] 6e950000 - 6e958000 rasadhlp.dll [15:54:50] [debug] 71f60000 - 71fc7000 streamer.DLL [15:54:50] [debug] 10000000 - 1000f000 sscanf.DLL [15:54:50] [debug] 6e960000 - 6e9ae000 fwpuclnt.dll [15:54:50] [debug] 71e40000 - 71e59000 bcrypt.dll
-
Ja ist der falsche code, den richtigen aktuellen hab ich bei meinem letzten post verlinkt
-
/ Klappt wohl doch noch nicht so ganz mit dem actor sys
Servercrash nach ein paar Minuten nach /createactor, an mysql liegt es nicht schon gecheckt,
crashdetect sagt der streamer ist schuld, das laden geht
-
Vielen Dank //
Aber kurze Frage hätte ich noch
Bei OnFrakMembersLoad wird ja einfach alles bis zum letzten match durchgeloopt,
SetPVarString(playerid,"UserEditName",username);
Heißt also wenn ich den User den ich anklicke editieren möchte, wird mir immer der letzte angezeigt, > IG getestet unter der schleife und in
der schleife.
Die schleife beenden nach dem ersten match wär ja auch dumm,
Ideen?
-
forward OnFrakMembersLoad(playerid);
public OnFrakMembersLoad(playerid)
{
new count, str[128];
cache_get_row_count(count);if(count > 0)
{
SendClientMessage(playerid, USAGE, "Members:");
for(new i = 0; i < count; i++)
{
new username[25], Rank[25],showmembs[128],number;
cache_get_value_name(i, "Name", username);
cache_get_value_name_int(i, "number", number);
new pid = getAccIDBesitzer(number);
format(showmembs,sizeof(showmembs),"%s %s\n",username,((IsPlayerConnected(pid))?("{6EF83C}[ONLINE]"):("{ff0000}[OFFLINE]")));ShowPlayerDialog(playerid, 345, DIALOG_STYLE_TABLIST, "Members", showmembs, "Choose", "Exit");
}
}
else return SendClientMessage(playerid, RED, "There are currently no Members > Server Error!");
return 1;}
Okay soweit sogut, jetzt zeigt er mir schon Username + Online Status korrekt an.
Aber halt nur von einer Person, wie kann ich alle anzeigen lassen?
-
Code
format(showmembs,sizeof(showmembs),"%s%s %s\n",str,"Members",((PlayerInfo[i][pLoggedIn] == true)?("{6EF83C}[ONLINE]"):("{ff0000}[OFFLINE]"))); ShowPlayerDialog(playerid, 345, DIALOG_STYLE_LIST, "Members", showmembs, "Choose", "Exit");
Danke schon mal soweit,
was ist mit dem Dialog? Da wird jetzt nur [ONLINE] angezeigt, stelle ich mir irgendwie
komplizierter vor als es vermutlich ist.
format(showmembs,sizeof(showmembs),"%s%s %s\n",str,"Members",((username,PlayerInfo[i][pLoggedIn] == true)?("{6EF83C}[ONLINE]"):("{ff0000}[OFFLINE]")));
ShowPlayerDialog(playerid, 345, DIALOG_STYLE_LIST, "Members", showmembs, "Choose", "Exit"); -
Und das ist fremdcode, habs nur von einem report system kopiert um es als vorlage zu benutzen,
wie gesagt hab keine ahnung wie man sowas scriptet. Scripte sonst auch anders mit MySQL
-
MySQL R41-4 also das aktuellste
Ne Idee wie ich den Code umschreiben muss ? Habe keinen Plan, habe
sowas in der Art noch nie gemacht
2.//
// edit 15:50 > Hab mal den Wert von WelcomeMsg höher zu setzten als MAX_PLAYER_NAME,
crasht leider immernoch
[15:39:30] [INFO] Callback successfully executed.[15:39:44] [DEBUG] mysql_pquery(1, "INSERT INTO `ServerShops` (´EnterX´, `EnterY`, `EnterZ`, `ExitX`, `ExitY`,`ExitZ`,`SpecialShopName`,`WelcomeMsg`,`interior`,`MapIconID`) VALUES ('1953.741333', '-2104.513427', '13.546875', '372.485900', '-133.244598', '1001.492187','Well stacked Pizza','You entered Well stacke','5','29')", "OnServerShopCreated", "i")[15:39:44] [DEBUG] CCallback::Create(amx=0x4b07678, name='OnServerShopCreated', format='i', params=0x5af7250, param_offset=5)[15:39:44] [DEBUG] CCallback::Create - callback index for 'OnServerShopCreated': 63[15:39:44] [DEBUG] processing specifier 'i' with parameter index 0[15:39:44] [DEBUG] retrieved and pushed value '9'[15:39:44] [INFO] Callback 'OnServerShopCreated' set up for delayed execution.[15:39:44] [DEBUG] created delayed callback with 1 parameter[15:39:44] [DEBUG] CHandle::Execute(this=0x258f2d8, type=2, query=0x25909b8)[15:39:44] [DEBUG] CConnectionPool::Queue(query=0x25909b8, this=0x258b9d0)[15:39:44] [DEBUG] CHandle::Execute - return value: true[15:39:44] [DEBUG] mysql_pquery: return value: '1'[15:39:44] [DEBUG] CConnection::Execute(query=0x25909b8, this=0x5fe4020, connection=0x25b7f68)[15:39:44] [DEBUG] CQuery::Execute(this=0x25909b8, connection=0x25b7f68)[15:39:44] [ERROR] error #1064 while executing query "INSERT INTO `ServerShops` (´EnterX´, `EnterY`, `EnterZ`, `ExitX`, `ExitY`,`ExitZ`,`SpecialShopName`,`WelcomeMsg`,`interior`,`MapIconID`) VALUES ('1953.741333', '-2104.513427', '13.546875', '372.485900', '-133.244598', '1001.492187','Well stacked Pizza','You entered Well stacke','5','29')": 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 '´EnterX´, `EnterY`, `EnterZ`, `ExitX`, `ExitY`,`ExitZ`,`SpecialShopName`,`Welc' at line 1[15:39:44] [DEBUG] CConnection::GetError(this=0x5fe4020, connection=0x25b7f68)[15:39:44] [DEBUG] CCallback::Create(amx=0x4b07678, name='OnQueryError', format='dsssd)[15:39:44] [DEBUG] CCallback::Create - callback index for 'OnQueryError': -10046[15:39:44] [DEBUG] processing specifier 'd'[15:39:44] [DEBUG] retrieved and pushed value '1064'[15:39:44] [DEBUG] processing specifier 's'[15:39:44] [DEBUG] retrieved and pushed value '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 '´EnterX´, `EnterY`, `EnterZ`, `ExitX`, `ExitY`,`ExitZ`,`SpecialShopName`,`Welc' at line 1'[15:39:44] [DEBUG] processing specifier 's'[15:39:44] [DEBUG] retrieved and pushed value 'OnServerShopCreated'[15:39:44] [DEBUG] processing specifier 's'[15:39:44] [DEBUG] retrieved and pushed value 'INSERT INTO `ServerShops` (´EnterX´, `EnterY`, `EnterZ`, `ExitX`, `ExitY`,`ExitZ`,`SpecialShopName`,`WelcomeMsg`,`interior`,`MapIconID`) VALUES ('1953.741333', '-2104.513427', '13.546875', '372.485900', '-133.244598', '1001.492187','Well stacked Pizza','You entered Well stacke','5','29')'[15:39:44] [DEBUG] processing specifier 'd'[15:39:44] [DEBUG] retrieved and pushed value '1'[15:39:44] [INFO] Callback 'OnQueryError' set up for delayed execution.[15:39:44] [DEBUG] created delayed callback with 5 parameters[15:39:44] [DEBUG] CCallback::Execute(amx=0x4b07678, index=-10046, num_params=5)
Geht auch mit der Vergrößerung nicht, hier mal der Original code
format(query, sizeof(query),"INSERT INTO `ServerShops` (´EnterX´, `EnterY`, `EnterZ`, `ExitX`, `ExitY`,`ExitZ`,`SpecialShopName`,`WelcomeMsg`,`interior`,`MapIconID`) VALUES ('%f', '%f', '%f', '%f', '%f', '%f','%s','%s','%d','%d')",xc, yc, zc,ServerShop[id][ExitX],ServerShop[id][ExitY],ServerShop[id][ExitZ],ServerShop[id][SpecialShopName],ServerShop[id][WelcomeMsg],ServerShop[id][shopint],ServerShop[id][SMapIconID]);mysql_pquery(handle, query, "OnServerShopCreated", "i", id);printf(query);[15:39:44] INSERT INTO `ServerShops` (´EnterX´, `EnterY`, `EnterZ`, `ExitX`, `ExitY`,`ExitZ`,`SpecialShopName`,`WelcomeMsg`,`interior`,`MapIconID`) VALUES ('1953.741333', '-2104.513427', '13.546875', '372.485900', '-133.244598', '1001.492187','Well stacked Pizza','You entered Well stacke','5','29')[15:39:44] [debug] Server crashed due to an unknown error[15:39:45] [debug] Native backtrace:[15:39:45] [debug] #0 004016eb in ?? () from samp-server.exe[15:39:45] [debug] #1 6f6c35e9 in ?? () from plugins\mysql.DLL[15:39:45] [debug] #2 6f6c6688 in ?? () from plugins\mysql.DLL[15:39:45] [debug] #3 6f6ac52e in ?? () from plugins\mysql.DLL[15:39:45] [debug] #4 6f6adc7f in ?? () from plugins\mysql.DLL[15:39:45] [debug] #5 6f6ae3d3 in ?? () from plugins\mysql.DLL[15:39:45] [debug] #6 00469a66 in ?? () from samp-server.exe[15:39:45] [debug] #7 0048d4db in ?? () from samp-server.exe[15:39:45] [debug] #8 0049b4a1 in ?? () from samp-server.exe[15:39:45] [debug] #9 0049b4b1 in ?? () from samp-server.exe[15:39:45] [debug] Registers:
-
ocmd:members(playerid, params[])
{
// if(!IsPlayerAdmin(playerid)) return 0;
new str[128], Cache:members;
if(PlayerInfo[playerid][FracID] == 0) return SCM(playerid,COOLRED,"You are in no Frac");
mysql_format(handle, str, sizeof(str), "SELECT * FROM `user` WHERE FracID = '%d'",PlayerInfo[playerid][FracID]);
members = mysql_query(handle, str, true);
new count = cache_num_rows();
if(count > 0)
{
SendClientMessage(playerid, USAGE, "Members:");
for(new i = 0; i < count; i++)
{
new username[25], Rank[25],showmembs[128];
cache_get_value_name(i, "Name", username);
format(showmembs,sizeof(showmembs),"%s%s %s",str,"Members",((PlayerInfo[i][pLoggedIn] == true)?("{6EF83C}[ONLINE]"):("{ff0000}[OFFLINE]")));
ShowPlayerDialog(playerid, 345, DIALOG_STYLE_LIST, "Members", showmembs, "Choose", "Exit");
}
}
else return SendClientMessage(playerid, RED, "There are currently no Members > Server Error!");
cache_delete(members);
return 1;
}KEINE ahnung wie ich das richtig angehe xD >> https://www.pic-upload.de/view-36114114/members.png.html
-
Code
Alles anzeigen[20:52:44] [DEBUG] mysql_pquery(1, "INSERT INTO `ServerShops` (´EnterX´, `EnterY`, `EnterZ`, `ExitX`, `ExitY`,`ExitZ`,`SpecialShopName`,`WelcomeMsg`,`interior`,`MapIconID`) VALUES ('2105.487060', '-1806.511840', '13.554687', '373.825653', '-117.270904', '1001.499511','Well stacked Pizza','Y", "OnServerShopCreated", "i") [20:52:44] [DEBUG] CCallback::Create(amx=0x4c67678, name='OnServerShopCreated', format='i', params=0x5c446ec, param_offset=5) [20:52:44] [DEBUG] CCallback::Create - callback index for 'OnServerShopCreated': 63 [20:52:44] [DEBUG] processing specifier 'i' with parameter index 0 [20:52:44] [DEBUG] retrieved and pushed value '9' [20:52:44] [INFO] Callback 'OnServerShopCreated' set up for delayed execution. [20:52:44] [DEBUG] created delayed callback with 1 parameter [20:52:44] [DEBUG] CHandle::Execute(this=0x2761d78, type=2, query=0x61c4558) [20:52:44] [DEBUG] CConnectionPool::Queue(query=0x61c4558, this=0x275c1b8) [20:52:44] [DEBUG] CHandle::Execute - return value: true [20:52:44] [DEBUG] mysql_pquery: return value: '1' [20:52:44] [DEBUG] CConnection::Execute(query=0x61c4558, this=0x5e58020, connection=0x277cf20) [20:52:44] [DEBUG] CQuery::Execute(this=0x61c4558, connection=0x277cf20) [20:52:44] [ERROR] error #1064 while executing query "INSERT INTO `ServerShops` (´EnterX´, `EnterY`, `EnterZ`, `ExitX`, `ExitY`,`ExitZ`,`SpecialShopName`,`WelcomeMsg`,`interior`,`MapIconID`) VALUES ('2105.487060', '-1806.511840', '13.554687', '373.825653', '-117.270904', '1001.499511','Well stacked Pizza','Y": 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 '´EnterX´, `EnterY`, `EnterZ`, `ExitX`, `ExitY`,`ExitZ`,`SpecialShopName`,`Welc' at line 1 [20:52:44] [DEBUG] CConnection::GetError(this=0x5e58020, connection=0x277cf20) [20:52:44] [DEBUG] CCallback::Create(amx=0x4c67678, name='OnQueryError', format='dsssd) [20:52:44] [DEBUG] CCallback::Create - callback index for 'OnQueryError': -10046 [20:52:44] [DEBUG] processing specifier 'd' [20:52:44] [DEBUG] retrieved and pushed value '1064' [20:52:44] [DEBUG] processing specifier 's' [20:52:44] [DEBUG] retrieved and pushed value '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 '´EnterX´, `EnterY`, `EnterZ`, `ExitX`, `ExitY`,`ExitZ`,`SpecialShopName`,`Welc' at line 1' [20:52:44] [DEBUG] processing specifier 's' [20:52:44] [DEBUG] retrieved and pushed value 'OnServerShopCreated' [20:52:44] [DEBUG] processing specifier 's' [20:52:44] [DEBUG] retrieved and pushed value 'INSERT INTO `ServerShops` (´EnterX´, `EnterY`, `EnterZ`, `ExitX`, `ExitY`,`ExitZ`,`SpecialShopName`,`WelcomeMsg`,`interior`,`MapIconID`) VALUES ('2105.487060', '-1806.511840', '13.554687', '373.825653', '-117.270904', '1001.499511','Well stacked Pizza','Y' [20:52:44] [DEBUG] processing specifier 'd' [20:52:44] [DEBUG] retrieved and pushed value '1' [20:52:44] [INFO] Callback 'OnQueryError' set up for delayed execution. [20:52:44] [DEBUG] created delayed callback with 5 parameters [20:52:44] [DEBUG] CCallback::Execute(amx=0x4c67678, index=-10046, num_params=5) [20:52:44] [INFO] Executing callback '$' with 5 parameters... [20:52:44] [DEBUG] processing internal specifier 'c' [20:52:44] [DEBUG] pushed value '1' onto AMX stack [20:52:44] [DEBUG] processing internal specifier 's' [20:52:44] [DEBUG] pushed value 'INSERT INTO `ServerShops` (´EnterX´, `EnterY`, `EnterZ`, `ExitX`, `ExitY`,`ExitZ`,`SpecialShopName`,`WelcomeMsg`,`interior`,`MapIconID`) VALUES ('2105.487060', '-1806.511840', '13.554687', '373.825653', '-117.270904', '1001.499511','Well stacked Pizza','Y' onto AMX stack [20:52:44] [DEBUG] processing internal specifier 's' [20:52:44] [DEBUG] pushed value 'OnServerShopCreated' onto AMX stack [20:52:44] [DEBUG] processing internal specifier 's' [20:52:44] [DEBUG] pushed value '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 '´EnterX´, `EnterY`, `EnterZ`, `ExitX`, `ExitY`,`ExitZ`,`SpecialShopName`,`Welc' at line 1' onto AMX stack [20:52:44] [DEBUG] processing internal specifier 'c' [20:52:44] [DEBUG] pushed value '1064' onto AMX stack [20:52:44] [DEBUG] executing AMX callback with index '-10046' [20:52:44] [DEBUG] AMX callback executed with error '0' [20:52:44] [INFO] Callback successfully executed.
Jemand ne Idee worans liegt? Finde hier den Fehler selbst mit SQL Simulation nicht -
Jo, da wäre wieder das Problem das bei (deinem Code) zeile 13 Unreachable Code kommt
-
Also wenn ich es Richtig verstanden habe dann steigt du als Army in ein Swat Car einsteigt kriegt du die Nachricht dass >
Es ein Army Vehicle ist und ich nicht einsteigen kann und, dass es ein SWAT Vehicle ist und ich nicht einsteigen kann
Also ja
-
Dann bekomme ich nur die Nachricht, dass ich You entered a A.R.M.Y Vehicle ich in ein Army Vehicle eingestiegen bin, da klappt auch alles.
Bei SWAT ist es genauso, nur halt mit der Nachricht, dass ich in ein SWAT Vehicle eingestiegen bin.
Aber ja, wenn ich in ein z.B Army Vehicle einsteige aber SWAT bin bekomme ich beide Fehlermeldungen (Used by US Army, Used by SWAT Team) sonst nichts.
-
Wenn ich in ein ArmyCar einsteige & Army bin, bekomme ich auch die nachricht, dass ich nicht in ein ArmyCar einsteigen kann,
andersrum genauso. Wenn ich in ein SWAT Car als Armyler einsteige bekomme ich beide nachrichten.
Probiere schon seit ner halben stunde rum, mal mit else mal ohne return 1 da und da,
/ Das ding ist, wenn ichs mit else if versuche ( da kann ichs auch umschreiben wie ich will
error 001: expected token: ";", but found "if" bekomme ich den Fehler bei Zeile 42.
-
Problem bei den Army & Swat Cars:
Wenn ich in ein ArmyCar einsteige & Army bin, bekomme ich auch die nachricht, dass ich nicht in ein army car einsteigen kann,
andersrum genauso. Wenn ich in ein swatcar als armyler einsteige bekomme ich beide nachrichten.
Probiere schon seit ner halben stunde rum, mal mit else mal ohne return 1 da und da,
aber kriege es einfach nicht hin
-
public OnPlayerCommandPerformed(playerid, cmdtext[], success)
{
if(success)
{
if(PlayerInfo[playerid][lastcommand]>gettime()) return SendClientMessage(playerid,-1,"* Please wait before using this command again.");
else
{
PlayerInfo[playerid][lastcommand] = gettime()+10000;
return 1;
}
}
return SendClientMessage(playerid,COLOR_RED,"Unkown Command: Use /Commands for help");
}Kann immernoch Befehle Spammen,
hatte das Problem schon mal in anderer Form und war schon damals so nicht zu lösen,
jemand ne Idee?
-
Schau mal diese Zeile an, was sagt uns das?
array of size 2000. Das bedeutet du hast irgendwo ein Array mit MAX_VEHICLES deklariertund versuchst auf den index 65535 zuzugreifen.
65535 entspricht INVALID_PLAYER_ID.
Ich kenn jetzt deinen Code nicht, schau doch einfach mal die einzelnen Variablen an und überlege, welcher den Wert INVALID_PLAYER_ID haben könnte
Hab jetzt mal den Fehlerbereich eingegrenzt indem ich einen neuen Array MAX_USER_CARS erstellt habe, (der andere array waraus einem Include)
Code#define MAX_USER_CARS 311 MAX_USER_CARS wird dafür benutzt newxVehicle[MAX_USER_CARS][xv_data],xVeh[MAX_USER_CARS], offerTimer[MAX_PLAYERS], Iterator:xVehicles<MAX_USER_CARS>, Iterator:xVehicleKeys<MAX_USER_CARS, MAX_USER_CARS>;
Wüsste jetzt auch nicht wie ich herausfinden könnte welcher wert denn jetzt Invalid ist
[xVehicle] 3 vehicle loaded.
[xVehicle] 2 vehicle loaded.
[debug] Run time error 4: "Array index out of bounds"
[debug] Attempted to read/write array element at index 65535 in array of size 311
[debug] AMX backtrace:
[debug] #0 00065004 in ?? (4, 1491104, 1, 1141493789, -996284512, 1099415840, 1124079062, 1, 1) from cops.amx
[debug] #1 0004e7e8 in public OnDialogResponse (0, 37, 1, -1, 1491100) from cops.amx -
Hier sind die einzelnen Werte (markiert)
Number of vehicle models: 5
OnNormalCarsLoad wurde aufgerufen
[xVehicle] 2 vehicle loaded.
[xVehicle] 0 vehicle loaded.
wid wert 5
ID ist 2
[debug] Run time error 4: "Array index out of bounds"
[debug] Attempted to read/write array element at index 65535 in array of size 2000
[debug] AMX backtrace:
[debug] #0 0006518c in ?? (5, 1926440, 1, 1141493789, -996284512, 1099415840, 1124079062, 1, 1) from cops.amx
[debug] #1 0004e918 in public OnDialogResponse (0, 37, 1, -1, 1926436) from cops.amx