1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
MySQL Problem
C0oL3r
Big Clucker
***
Posts: 109
Threads: 28
Joined: Feb 2017
Reputation: 0
#1

04.02.2018, 22:37
Hello, i set that when someone connect to the server to show on screen CHECKING BAN STATUS... for 3 seconds, and after that 3 seconds to call a function, and i do that thing:

Код:
public OnPlayerConnect(playerid)
{
	GetPlayerName(playerid, pInfo[playerid][Name], MAX_PLAYER_NAME);
	Corrupt_Check[playerid]++;
	pInfo[playerid][RemainingAtt] = 3;
	
	GameTextForPlayer(playerid, "~r~CHECKING BAN STATUS...", 3000, 3);
	SetTimer("OnPlayerChecked", 3000, 0);
	return 1;
}

forward public OnPlayerChecked(playerid);
public OnPlayerChecked(playerid)
{
	new DB_Query[115];
	mysql_format(Database, DB_Query, sizeof(DB_Query), "SELECT * FROM `users` WHERE `Username` = '%e' LIMIT 1", pInfo[playerid][Name]);
	mysql_tquery(Database, DB_Query, "OnPlayerDataCheck", "ii", playerid, Corrupt_Check[playerid]);
	TextDrawShowForAll(Text:blackbox);
	return 1;
}

forward public OnPlayerDataCheck(playerid, corrupt_check);
public OnPlayerDataCheck(playerid, corrupt_check)
{
	if(corrupt_check != Corrupt_Check[playerid]) return Kick(playerid);

	if(cache_num_rows() > 0)
	{	
		cache_get_value(0, "Password", pInfo[playerid][Password], 65);
		ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "SERVER: Login", "Welcome to *********.\n\nPlease enter you password below!", "Login", "Cancel");
	}
	else
	{
		 ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "SERVER: Registration", "Welcome to *********.\n\nPlease enter your desired password below!", "Register", "Cancel");
	}
	return 1;
}
and after i connect to server after checking ban status dissapear server-samp.exe is stopping, and i have crashdetect and in my server_log is that:

[00:39:56] ===============================

[00:39:56] sscanf plugin loaded.

[00:39:56] Version: 2.8.2

[00:39:56] © 2012 Alex "******" Cole

[00:39:56] ===============================

[00:39:57] Loaded.
[00:39:57] Loaded 3 plugins.

[00:39:57]
[00:39:57] Filterscripts
[00:39:57] ---------------
[00:39:57] Loaded 0 filterscripts.

[00:39:57] Conectat la baza de date!
[00:39:57]
----------------------------------
[00:39:57] Blank Gamemode by your name here
[00:39:57] ----------------------------------

[00:39:57] Number of vehicle models: 0
[00:39:59] [connection] 127.0.0.1:57088 requests connection cookie.
[00:40:00] [connection] incoming connection: 127.0.0.1:57088 id: 0
[00:40:01] [join] 0To= has joined the server (0:127.0.0.1)
[00:40:04] [debug] Server crashed while executing RPG-C0oL3r.amx
[00:40:04] [debug] AMX backtrace:
[00:40:04] [debug] #0 native mysql_tquery () from mysql.DLL
[00:40:04] [debug] #1 00006724 in public OnPlayerChecked () from RPG-C0oL3r.amx
[00:40:04] [debug] Native backtrace:
[00:40:04] [debug] #0 5a5874d3 in ?? () from plugins\mysql.DLL
[00:40:04] [debug] #1 5a5a5035 in ?? () from plugins\mysql.DLL
[00:40:04] [debug] #2 5a5ad7d1 in ?? () from plugins\mysql.DLL
[00:40:04] [debug] #3 004010b6 in ?? () from samp-server.exe
[00:40:04] [debug] #4 5a65d60a in ?? () from plugins\crashdetect.DLL
[00:40:04] [debug] #5 5a664078 in ?? () from plugins\crashdetect.DLL
[00:40:04] [debug] #6 5a65a767 in ?? () from plugins\crashdetect.DLL
[00:40:04] [debug] #7 5a65d65a in ?? () from plugins\crashdetect.DLL
[00:40:04] [debug] #8 00482a68 in ?? () from samp-server.exe
[00:40:04] [debug] #9 004912ba in ?? () from samp-server.exe
[00:40:04] [debug] Registers:
[00:40:04] [debug] EAX: 00000000 EBX: 04b54944 ECX: 0019f9ac EDX: 04af00fc
[00:40:04] [debug] ESI: 0019fb1c EDI: 0019fadc EBP: 00000000 ESP: 0019fe18
[00:40:04] [debug] EIP: 004912ba EFLAGS: 00010246
[00:40:04] [debug] Stack:
[00:40:04] [debug] ESP+00000000: 00000005 7723dd70 7723dd20 00000000
[00:40:04] [debug] ESP+00000020: 0019ff80 0020b000 0000401c 00010101
[00:40:04] [debug] ESP+00000040: 02739e10 656d6167 65646f6d 00003531
[00:40:04] [debug] ESP+00000060: 0019fe68 0019ff70 0019ff70 0049d208
[00:40:04] [debug] ESP+00000080: 004ab4a0 0019ff70 004ab0e1 ffffffff
[00:40:04] [debug] ESP+000000a0: 00000094 00000006 00000002 000023f0
[00:40:04] [debug] ESP+000000c0: 00000000 00000000 00000000 00000000
[00:40:04] [debug] ESP+000000e0: 00000000 00000000 00000000 00000000
[00:40:04] [debug] ESP+00000100: 00000000 00000000 00000000 00000000
[00:40:04] [debug] ESP+00000120: 00000000 00000000 00000000 00000000
[00:40:04] [debug] ESP+00000140: 00000000 00000000 c0000005 00000000
[00:40:04] [debug] ESP+00000160: 004ba530 00000000 0019ff94 771e8654
[00:40:04] [debug] ESP+00000180: 77d94a77 0020b000 fd851713 00000000
[00:40:04] [debug] ESP+000001a0: 00000000 00000000 fd851713 0019ffa0
[00:40:04] [debug] ESP+000001c0: 00000000 0019ffec 77d94a47 ffffffff
[00:40:04] [debug] ESP+000001e0: 0020b000 00000000 78746341 00000020
[00:40:04] [debug] ESP+00000200: 00000020 00000000 00000014 00000001
[00:40:04] [debug] ESP+00000220: 00000000 00000000 00000000 00000000
[00:40:04] [debug] ESP+00000240: 00000044 000002e0 0000025c 00000000
[00:40:04] [debug] ESP+00000260: 00000342 00000000 2d59495b 000008cc
[00:40:04] [debug] ESP+00000280: 32ceeacd 00000bfc 00000042 00000c40
[00:40:04] [debug] ESP+000002a0: 0000005e 00000fd0 00000362 00000000
[00:40:04] [debug] ESP+000002c0: 00000392 00000010 00000009 000000ec
[00:40:04] [debug] ESP+000002e0: 00000001 00000002 00001758 000007a0
[00:40:04] [debug] ESP+00000300: 00000001 00000004 00002d84 00000314
[00:40:04] [debug] ESP+00000320: 00000002 00000006 00003130 000000cc
[00:40:04] [debug] ESP+00000340: 00000001 00000009 000032ec 00000028
[00:40:04] [debug] ESP+00000360: 00000001 64487353 0000002c 00000001
[00:40:04] [debug] ESP+00000380: 00000001 000015a4 0000002c 0000005e
[00:40:04] [debug] ESP+000003a0: 00000000 00000000 00000000 00000000
[00:40:04] [debug] ESP+000003c0: 00000038 00000000 003a0043 0057005c
[00:40:04] [debug] ESP+000003e0: 006e0069 00780053 005c0073 00000000
[00:40:04] [debug] Loaded modules:
[00:40:04] [debug] 00400000 - 00519000 samp-server.exe
[00:40:04] [debug] 77d30000 - 77ebd000 ntdll.dll
[00:40:04] [debug] 771d0000 - 772a0000 KERNEL32.DLL
[00:40:04] [debug] 77b50000 - 77d27000 KERNELBASE.dll
[00:40:04] [debug] 75910000 - 76c43000 SHELL32.dll
[00:40:04] [debug] 77020000 - 770dd000 msvcrt.dll
[00:40:04] [debug] 758d0000 - 75908000 cfgmgr32.dll
[00:40:04] [debug] 77770000 - 77887000 ucrtbase.dll
[00:40:04] [debug] 772b0000 - 77338000 shcore.dll
[00:40:04] [debug] 774c0000 - 7757e000 RPCRT4.dll
[00:40:04] [debug] 74750000 - 74770000 SspiCli.dll
[00:40:04] [debug] 74740000 - 7474a000 CRYPTBASE.dll
[00:40:04] [debug] 77710000 - 77767000 bcryptPrimitives.dll
[00:40:04] [debug] 75780000 - 757c3000 sechost.dll
[00:40:04] [debug] 75480000 - 756c6000 combase.dll
[00:40:04] [debug] 74a60000 - 75026000 windows.storage.dll
[00:40:04] [debug] 757e0000 - 75858000 advapi32.dll
[00:40:04] [debug] 74770000 - 747b5000 shlwapi.dll
[00:40:04] [debug] 77580000 - 775a2000 GDI32.dll
[00:40:04] [debug] 775b0000 - 7770e000 gdi32full.dll
[00:40:04] [debug] 75700000 - 7577c000 msvcp_win.dll
[00:40:04] [debug] 77340000 - 774b5000 USER32.dll
[00:40:04] [debug] 75030000 - 75046000 win32u.dll
[00:40:04] [debug] 77b40000 - 77b4e000 kernel.appcore.dll
[00:40:04] [debug] 76f70000 - 76fb5000 powrprof.dll
[00:40:04] [debug] 77a20000 - 77a34000 profapi.dll
[00:40:04] [debug] 6d810000 - 6d818000 WSOCK32.dll
[00:40:04] [debug] 71010000 - 71034000 WINMM.dll
[00:40:04] [debug] 75860000 - 758c6000 WS2_32.dll
[00:40:04] [debug] 70fe0000 - 71003000 winmmbase.dll
[00:40:04] [debug] 76df0000 - 76e15000 IMM32.DLL
[00:40:04] [debug] 5a640000 - 5a690000 crashdetect.DLL
[00:40:04] [debug] 61580000 - 6163f000 MSVCR100.dll
[00:40:04] [debug] 5a5d0000 - 5a639000 MSVCP100.dll
[00:40:04] [debug] 5a580000 - 5a5ce000 mysql.DLL
[00:40:04] [debug] 5a560000 - 5a57a000 log-core.dll
[00:40:04] [debug] 5a490000 - 5a55d000 libmariadb.dll
[00:40:04] [debug] 59270000 - 592e1000 MSVCP140.dll
[00:40:04] [debug] 77890000 - 77a12000 CRYPT32.dll
[00:40:04] [debug] 59250000 - 59265000 VCRUNTIME140.dll
[00:40:04] [debug] 772a0000 - 772ae000 MSASN1.dll
[00:40:04] [debug] 698a0000 - 698aa000 Secur32.dll
[00:40:04] [debug] 72790000 - 727a1000 napinsp.dll
[00:40:04] [debug] 72770000 - 72786000 pnrpnsp.dll
[00:40:04] [debug] 710e0000 - 710f3000 NLAapi.dll
[00:40:04] [debug] 72bd0000 - 72c25000 mswsock.dll
[00:40:04] [debug] 727c0000 - 72854000 DNSAPI.dll
[00:40:04] [debug] 757d0000 - 757d7000 NSI.dll
[00:40:04] [debug] 741a0000 - 741d0000 IPHLPAPI.DLL
[00:40:04] [debug] 72760000 - 7276c000 winrnr.dll
[00:40:04] [debug] 710d0000 - 710e0000 wshbth.dll
[00:40:04] [debug] 72af0000 - 72af8000 rasadhlp.dll
[00:40:04] [debug] 10000000 - 1000f000 sscanf.DLL
[00:40:04] [debug] 70be0000 - 70c2e000 fwpuclnt.dll
[00:40:04] [debug] 740d0000 - 740e9000 bcrypt.dll
Find
Reply
Sew_Sumi
Banned
Posts: 6,242
Threads: 8
Joined: Jun 2008
#2

04.02.2018, 22:38
Post the entire startup log, not just the bottom of it.

Код:
[00:39:56] ===============================

[00:39:56] sscanf plugin loaded. 

[00:39:56] Version: 2.8.2 

[00:39:56] © 2012 Alex "******" Cole 

[00:39:56] ===============================

[00:39:57] Loaded.
[00:39:57] Loaded 3 plugins.
Everything above that.
Find
Reply
C0oL3r
Big Clucker
***
Posts: 109
Threads: 28
Joined: Feb 2017
Reputation: 0
#3

04.02.2018, 22:53
SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[00:39:56] filterscripts = "" (string)
[00:39:56]
[00:39:56] Server Plugins
[00:39:56] --------------
[00:39:56] Loading plugin: crashdetect
[00:39:56] CrashDetect v4.18.1 is OK.
[00:39:56] Loaded.
[00:39:56] Loading plugin: mysql
[00:39:56] >> plugin.mysql: R41-4 successfully loaded.
[00:39:56] Loaded.
[00:39:56] Loading plugin: sscanf
[00:39:56]

[00:39:56] ===============================

[00:39:56] sscanf plugin loaded.

[00:39:56] Version: 2.8.2

[00:39:56] © 2012 Alex "******" Cole

[00:39:56] ===============================

[00:39:57] Loaded.
[00:39:57] Loaded 3 plugins.

[00:39:57]
[00:39:57] Filterscripts
[00:39:57] ---------------
[00:39:57] Loaded 0 filterscripts.

[00:39:57] Conectat la baza de date!
[00:39:57]
----------------------------------
[00:39:57] Blank Gamemode by your name here
[00:39:57] ----------------------------------

[00:39:57] Number of vehicle models: 0
[00:39:59] [connection] 127.0.0.1:57088 requests connection cookie.
[00:40:00] [connection] incoming connection: 127.0.0.1:57088 id: 0
[00:40:01] [join] 0To= has joined the server (0:127.0.0.1)
[00:40:04] [debug] Server crashed while executing RPG-C0oL3r.amx
[00:40:04] [debug] AMX backtrace:
[00:40:04] [debug] #0 native mysql_tquery () from mysql.DLL
[00:40:04] [debug] #1 00006724 in public OnPlayerChecked () from RPG-C0oL3r.amx
[00:40:04] [debug] Native backtrace:
[00:40:04] [debug] #0 5a5874d3 in ?? () from plugins\mysql.DLL
[00:40:04] [debug] #1 5a5a5035 in ?? () from plugins\mysql.DLL
[00:40:04] [debug] #2 5a5ad7d1 in ?? () from plugins\mysql.DLL
[00:40:04] [debug] #3 004010b6 in ?? () from samp-server.exe
[00:40:04] [debug] #4 5a65d60a in ?? () from plugins\crashdetect.DLL
[00:40:04] [debug] #5 5a664078 in ?? () from plugins\crashdetect.DLL
[00:40:04] [debug] #6 5a65a767 in ?? () from plugins\crashdetect.DLL
[00:40:04] [debug] #7 5a65d65a in ?? () from plugins\crashdetect.DLL
[00:40:04] [debug] #8 00482a68 in ?? () from samp-server.exe
[00:40:04] [debug] #9 004912ba in ?? () from samp-server.exe
[00:40:04] [debug] Registers:
[00:40:04] [debug] EAX: 00000000 EBX: 04b54944 ECX: 0019f9ac EDX: 04af00fc
[00:40:04] [debug] ESI: 0019fb1c EDI: 0019fadc EBP: 00000000 ESP: 0019fe18
[00:40:04] [debug] EIP: 004912ba EFLAGS: 00010246
[00:40:04] [debug] Stack:
[00:40:04] [debug] ESP+00000000: 00000005 7723dd70 7723dd20 00000000
[00:40:04] [debug] ESP+00000020: 0019ff80 0020b000 0000401c 00010101
[00:40:04] [debug] ESP+00000040: 02739e10 656d6167 65646f6d 00003531
[00:40:04] [debug] ESP+00000060: 0019fe68 0019ff70 0019ff70 0049d208
[00:40:04] [debug] ESP+00000080: 004ab4a0 0019ff70 004ab0e1 ffffffff
[00:40:04] [debug] ESP+000000a0: 00000094 00000006 00000002 000023f0
[00:40:04] [debug] ESP+000000c0: 00000000 00000000 00000000 00000000
[00:40:04] [debug] ESP+000000e0: 00000000 00000000 00000000 00000000
[00:40:04] [debug] ESP+00000100: 00000000 00000000 00000000 00000000
[00:40:04] [debug] ESP+00000120: 00000000 00000000 00000000 00000000
[00:40:04] [debug] ESP+00000140: 00000000 00000000 c0000005 00000000
[00:40:04] [debug] ESP+00000160: 004ba530 00000000 0019ff94 771e8654
[00:40:04] [debug] ESP+00000180: 77d94a77 0020b000 fd851713 00000000
[00:40:04] [debug] ESP+000001a0: 00000000 00000000 fd851713 0019ffa0
[00:40:04] [debug] ESP+000001c0: 00000000 0019ffec 77d94a47 ffffffff
[00:40:04] [debug] ESP+000001e0: 0020b000 00000000 78746341 00000020
[00:40:04] [debug] ESP+00000200: 00000020 00000000 00000014 00000001
[00:40:04] [debug] ESP+00000220: 00000000 00000000 00000000 00000000
[00:40:04] [debug] ESP+00000240: 00000044 000002e0 0000025c 00000000
[00:40:04] [debug] ESP+00000260: 00000342 00000000 2d59495b 000008cc
[00:40:04] [debug] ESP+00000280: 32ceeacd 00000bfc 00000042 00000c40
[00:40:04] [debug] ESP+000002a0: 0000005e 00000fd0 00000362 00000000
[00:40:04] [debug] ESP+000002c0: 00000392 00000010 00000009 000000ec
[00:40:04] [debug] ESP+000002e0: 00000001 00000002 00001758 000007a0
[00:40:04] [debug] ESP+00000300: 00000001 00000004 00002d84 00000314
[00:40:04] [debug] ESP+00000320: 00000002 00000006 00003130 000000cc
[00:40:04] [debug] ESP+00000340: 00000001 00000009 000032ec 00000028
[00:40:04] [debug] ESP+00000360: 00000001 64487353 0000002c 00000001
[00:40:04] [debug] ESP+00000380: 00000001 000015a4 0000002c 0000005e
[00:40:04] [debug] ESP+000003a0: 00000000 00000000 00000000 00000000
[00:40:04] [debug] ESP+000003c0: 00000038 00000000 003a0043 0057005c
[00:40:04] [debug] ESP+000003e0: 006e0069 00780053 005c0073 00000000
[00:40:04] [debug] Loaded modules:
[00:40:04] [debug] 00400000 - 00519000 samp-server.exe
[00:40:04] [debug] 77d30000 - 77ebd000 ntdll.dll
[00:40:04] [debug] 771d0000 - 772a0000 KERNEL32.DLL
[00:40:04] [debug] 77b50000 - 77d27000 KERNELBASE.dll
[00:40:04] [debug] 75910000 - 76c43000 SHELL32.dll
[00:40:04] [debug] 77020000 - 770dd000 msvcrt.dll
[00:40:04] [debug] 758d0000 - 75908000 cfgmgr32.dll
[00:40:04] [debug] 77770000 - 77887000 ucrtbase.dll
[00:40:04] [debug] 772b0000 - 77338000 shcore.dll
[00:40:04] [debug] 774c0000 - 7757e000 RPCRT4.dll
[00:40:04] [debug] 74750000 - 74770000 SspiCli.dll
[00:40:04] [debug] 74740000 - 7474a000 CRYPTBASE.dll
[00:40:04] [debug] 77710000 - 77767000 bcryptPrimitives.dll
[00:40:04] [debug] 75780000 - 757c3000 sechost.dll
[00:40:04] [debug] 75480000 - 756c6000 combase.dll
[00:40:04] [debug] 74a60000 - 75026000 windows.storage.dll
[00:40:04] [debug] 757e0000 - 75858000 advapi32.dll
[00:40:04] [debug] 74770000 - 747b5000 shlwapi.dll
[00:40:04] [debug] 77580000 - 775a2000 GDI32.dll
[00:40:04] [debug] 775b0000 - 7770e000 gdi32full.dll
[00:40:04] [debug] 75700000 - 7577c000 msvcp_win.dll
[00:40:04] [debug] 77340000 - 774b5000 USER32.dll
[00:40:04] [debug] 75030000 - 75046000 win32u.dll
[00:40:04] [debug] 77b40000 - 77b4e000 kernel.appcore.dll
[00:40:04] [debug] 76f70000 - 76fb5000 powrprof.dll
[00:40:04] [debug] 77a20000 - 77a34000 profapi.dll
[00:40:04] [debug] 6d810000 - 6d818000 WSOCK32.dll
[00:40:04] [debug] 71010000 - 71034000 WINMM.dll
[00:40:04] [debug] 75860000 - 758c6000 WS2_32.dll
[00:40:04] [debug] 70fe0000 - 71003000 winmmbase.dll
[00:40:04] [debug] 76df0000 - 76e15000 IMM32.DLL
[00:40:04] [debug] 5a640000 - 5a690000 crashdetect.DLL
[00:40:04] [debug] 61580000 - 6163f000 MSVCR100.dll
[00:40:04] [debug] 5a5d0000 - 5a639000 MSVCP100.dll
[00:40:04] [debug] 5a580000 - 5a5ce000 mysql.DLL
[00:40:04] [debug] 5a560000 - 5a57a000 log-core.dll
[00:40:04] [debug] 5a490000 - 5a55d000 libmariadb.dll
[00:40:04] [debug] 59270000 - 592e1000 MSVCP140.dll
[00:40:04] [debug] 77890000 - 77a12000 CRYPT32.dll
[00:40:04] [debug] 59250000 - 59265000 VCRUNTIME140.dll
[00:40:04] [debug] 772a0000 - 772ae000 MSASN1.dll
[00:40:04] [debug] 698a0000 - 698aa000 Secur32.dll
[00:40:04] [debug] 72790000 - 727a1000 napinsp.dll
[00:40:04] [debug] 72770000 - 72786000 pnrpnsp.dll
[00:40:04] [debug] 710e0000 - 710f3000 NLAapi.dll
[00:40:04] [debug] 72bd0000 - 72c25000 mswsock.dll
[00:40:04] [debug] 727c0000 - 72854000 DNSAPI.dll
[00:40:04] [debug] 757d0000 - 757d7000 NSI.dll
[00:40:04] [debug] 741a0000 - 741d0000 IPHLPAPI.DLL
[00:40:04] [debug] 72760000 - 7276c000 winrnr.dll
[00:40:04] [debug] 710d0000 - 710e0000 wshbth.dll
[00:40:04] [debug] 72af0000 - 72af8000 rasadhlp.dll
[00:40:04] [debug] 10000000 - 1000f000 sscanf.DLL
[00:40:04] [debug] 70be0000 - 70c2e000 fwpuclnt.dll
[00:40:04] [debug] 740d0000 - 740e9000 bcrypt.dll

Sorry, i doesn't see that i don't all of that
Find
Reply
PepsiCola23
Gangsta
****
Posts: 728
Threads: 109
Joined: May 2015
Reputation: 0
#4

04.02.2018, 23:17
show us
Quote:

public OnPlayerChecked ()
Find
Reply
C0oL3r
Big Clucker
***
Posts: 109
Threads: 28
Joined: Feb 2017
Reputation: 0
#5

04.02.2018, 23:24
it's all at top but:

Код:
forward public OnPlayerChecked(playerid);
public OnPlayerChecked(playerid)
{
	new DB_Query[115];
	mysql_format(Database, DB_Query, sizeof(DB_Query), "SELECT * FROM `users` WHERE `Username` = '%e' LIMIT 1", pInfo[playerid][Name]);
	mysql_tquery(Database, DB_Query, "OnPlayerDataCheck", "ii", playerid, Corrupt_Check[playerid]);
	TextDrawShowForAll(Text:blackbox);
	return 1;
}
Find
Reply
Sew_Sumi
Banned
Posts: 6,242
Threads: 8
Joined: Jun 2008
#6

04.02.2018, 23:37
Was it working prior? And have you got a MySQL log in the server folder? (You may need to set a variable in the gamemode to get the plugin to report to logs)

I've not messed with MySQL much.

Check your mysql_log in the server folder for errors.
Find
Reply
C0oL3r
Big Clucker
***
Posts: 109
Threads: 28
Joined: Feb 2017
Reputation: 0
#7

04.02.2018, 23:50
I don't have a mysql_log.
If i messed with mysql to much, you have an other option to make that checking ban status?

I know that the problem is because i use SetInterval, and if i put all that mysql_format and mysql_tquery to onplayerconnect without the interval it will work
Find
Reply
Sew_Sumi
Banned
Posts: 6,242
Threads: 8
Joined: Jun 2008
#8

05.02.2018, 00:08
Try adding https://sampwiki.blast.hk/wiki/MySQL/R40#mysql_log

Код:
mysql_log(ALL);
in OnGamemodeInit.

This should bring the log out, just check the subfolders such as scriptfiles and the servers base folder (where sa-mp-server.exe is) before you do, just to be completely sure it's not there as it seems like it should be there regardless of the setting.

If anything, if it's 'messed with to much' it'd just be a case of seeing what it is indeed doing. This should be able to handle what you're wanting.
Find
Reply
C0oL3r
Big Clucker
***
Posts: 109
Threads: 28
Joined: Feb 2017
Reputation: 0
#9

05.02.2018, 00:13
Oh, i found the mysql.log in the logs folder:

mysql_tquery: callback error: callback "OnPlayerDataCheck" does not exist

but the function is forwarded and exists

Код:
forward public OnPlayerChecked(playerid);
public OnPlayerChecked(playerid)
{
	new DB_Query[115];
	mysql_format(Database, DB_Query, sizeof(DB_Query), "SELECT * FROM `users` WHERE `Username` = '%e' LIMIT 1", pInfo[playerid][Name]);
	mysql_tquery(Database, DB_Query, "OnPlayerDataCheck", "ii", playerid, Corrupt_Check[playerid]);
	TextDrawShowForAll(Text:blackbox);
	return 1;
}

forward public OnPlayerDataCheck(playerid, corrupt_check);
public OnPlayerDataCheck(playerid, corrupt_check)
{
	if(corrupt_check != Corrupt_Check[playerid]) return Kick(playerid);

	if(cache_num_rows() > 0)
	{	
		cache_get_value(0, "Password", pInfo[playerid][Password], 65);
		ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "SERVER: Login", "Welcome to *********.\n\nPlease enter you password below!", "Login", "Cancel");
	}
	else
	{
		 ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "SERVER: Registration", "Welcome to *********.\n\nPlease enter your desired password below!", "Register", "Cancel");
	}
	return 1;
}
Find
Reply
Kane
Gangsta
*****
Posts: 824
Threads: 6
Joined: Sep 2012
Reputation: 0
#10

05.02.2018, 00:19
There's no need to do forward public function( ).

PHP код:
forward OnMyFunction( playerid ); 
public OnMyFunction( playerid ) {
       do{
        return 1;
    }
          return 1;
} 
OR:

PHP код:
OnMyFunction( playerid ); public OnMyFunction( playerid ) {
     return 1;
} 
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help