MySQL register system // server crashing
#1

Hey, i'm creating a new gamemode and i have a problem. When i delete register system - server not crashing, when i insert register system - server has crashing.

Crashinfo:
Код HTML:
SA-MP Server: 0.3z



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



Registers:

EAX: 0x0018E174	EBX: 0x002C0000	ECX: 0x0018FBF0	EDX: 0x00000000

ESI: 0x00250000	EDI: 0x00000000	EBP: 0x0045B280	ESP: 0x004AD6AC

EFLAGS: 0x00010246



Stack:

+0000: 0x00000000   0x0045B300   0x0045A800   0x0045A7D0

+0010: 0x0045A7F0   0x0045A880   0x0045A8C0   0x0045A8E0

+0020: 0x0045A930   0x0045A8F0   0x0045B320   0x0045B370

+0030: 0x0045A970   0x0045A9A0   0x0045A9B0   0x0045A9C0

+0040: 0x0045A9D0   0x0045A9F0   0x0045AA30   0x0045AA50

+0050: 0x0045AA70   0x0045AA90   0x0045AAB0   0x0045AAC0

+0060: 0x0045AAD0   0x0045AAE0   0x0045AAF0   0x0045AB00

+0070: 0x0045AB10   0x0045AB20   0x0045AB30   0x0045AB40

+0080: 0x0045AB50   0x0045AC80   0x0045ABC0   0x0045AB60

+0090: 0x0045AC20   0x0045ACE0   0x0045AD10   0x0045AD20

+00A0: 0x0045AD30   0x0045AD40   0x0045AD50   0x0045AD60

+00B0: 0x0045AD70   0x0045ADA0   0x0045ADD0   0x0045ADE0

+00C0: 0x0045AE00   0x0045AE10   0x0045AE30   0x0045B530

+00D0: 0x0045AE60   0x0045AEC0   0x0045AE70   0x0045AE90

+00E0: 0x0045AEA0   0x0045AEB0   0x0045AED0   0x0045AEF0

+00F0: 0x0045AF10   0x0045AF20   0x0045AF30   0x0045AF40

+0100: 0x0045AF50   0x0045AF80   0x0045AFB0   0x0045AFC0

+0110: 0x0045AFD0   0x0045AFE0   0x0045B000   0x0045B020

+0120: 0x00000000   0x00000000   0x3DF00000   0x3CA3D70A

+0130: 0x00000000   0x00000000   0x40CC2000   0x00000000



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



Loaded Modules:

samp-server.exe	A: 0x00400000 - 0x004F5000	(C:\Users\Dominykas-PC\Desktop\SF-STORIES.LT GAMEMODE\samp-server.exe)

ntdll.dll	A: 0x77910000 - 0x77A78000	(C:\WINDOWS\SYSTEM32\ntdll.dll)

KERNEL32.DLL	A: 0x76100000 - 0x76240000	(C:\WINDOWS\SYSTEM32\KERNEL32.DLL)

KERNELBASE.dll	A: 0x75E90000 - 0x75F5F000	(C:\WINDOWS\SYSTEM32\KERNELBASE.dll)

SHELL32.dll	A: 0x76240000 - 0x77400000	(C:\WINDOWS\SYSTEM32\SHELL32.dll)

USER32.dll	A: 0x776F0000 - 0x7783F000	(C:\WINDOWS\SYSTEM32\USER32.dll)

WSOCK32.dll	A: 0x74AC0000 - 0x74AC8000	(C:\WINDOWS\SYSTEM32\WSOCK32.dll)

WINMM.dll	A: 0x751C0000 - 0x751E0000	(C:\WINDOWS\SYSTEM32\WINMM.dll)

msvcrt.dll	A: 0x75C00000 - 0x75CBE000	(C:\WINDOWS\SYSTEM32\msvcrt.dll)

combase.dll	A: 0x77560000 - 0x776AE000	(C:\WINDOWS\SYSTEM32\combase.dll)

SHLWAPI.dll	A: 0x757A0000 - 0x757E1000	(C:\WINDOWS\SYSTEM32\SHLWAPI.dll)

GDI32.dll	A: 0x75800000 - 0x75907000	(C:\WINDOWS\SYSTEM32\GDI32.dll)

WS2_32.dll	A: 0x755C0000 - 0x7560D000	(C:\WINDOWS\SYSTEM32\WS2_32.dll)

WINMMBASE.dll	A: 0x74AA0000 - 0x74AC0000	(C:\WINDOWS\SYSTEM32\WINMMBASE.dll)

RPCRT4.dll	A: 0x75DC0000 - 0x75E71000	(C:\WINDOWS\SYSTEM32\RPCRT4.dll)

NSI.dll	A: 0x75E80000 - 0x75E87000	(C:\WINDOWS\SYSTEM32\NSI.dll)

cfgmgr32.dll	A: 0x75560000 - 0x7559A000	(C:\WINDOWS\SYSTEM32\cfgmgr32.dll)

DEVOBJ.dll	A: 0x74A80000 - 0x74A9F000	(C:\WINDOWS\SYSTEM32\DEVOBJ.dll)

SspiCli.dll	A: 0x75330000 - 0x7534D000	(C:\WINDOWS\SYSTEM32\SspiCli.dll)

CRYPTBASE.dll	A: 0x75320000 - 0x75329000	(C:\WINDOWS\SYSTEM32\CRYPTBASE.dll)

sechost.dll	A: 0x75BC0000 - 0x75BFE000	(C:\WINDOWS\SYSTEM32\sechost.dll)

bcryptPrimitives.dll	A: 0x752C0000 - 0x75313000	(C:\WINDOWS\SYSTEM32\bcryptPrimitives.dll)

IMM32.DLL	A: 0x75910000 - 0x75935000	(C:\WINDOWS\system32\IMM32.DLL)

MSCTF.dll	A: 0x75CC0000 - 0x75DB7000	(C:\WINDOWS\SYSTEM32\MSCTF.dll)

streamer.DLL	A: 0x6D9B0000 - 0x6D9EF000	(C:\Users\Dominykas-PC\Desktop\SF-STORIES.LT GAMEMODE\plugins\streamer.DLL)

MSVCP100.dll	A: 0x6D430000 - 0x6D499000	(C:\WINDOWS\SYSTEM32\MSVCP100.dll)

MSVCR100.dll	A: 0x74BE0000 - 0x74C9F000	(C:\WINDOWS\SYSTEM32\MSVCR100.dll)

sscanf.DLL	A: 0x10000000 - 0x1000D000	(C:\Users\Dominykas-PC\Desktop\SF-STORIES.LT GAMEMODE\plugins\sscanf.DLL)

dbghelp.dll	A: 0x73B90000 - 0x73CD8000	(C:\WINDOWS\SYSTEM32\dbghelp.dll)

mysql.DLL	A: 0x00510000 - 0x0051F000	(C:\Users\Dominykas-PC\Desktop\SF-STORIES.LT GAMEMODE\plugins\mysql.DLL)

LIBMYSQL.dll	A: 0x02150000 - 0x022C6000	(C:\Users\Dominykas-PC\Desktop\SF-STORIES.LT GAMEMODE\LIBMYSQL.dll)

MSVCR90.dll	A: 0x708C0000 - 0x70963000	(C:\WINDOWS\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.8387_none_5094ca96bcb6b2bb\MSVCR90.dll)

MSVCP90.dll	A: 0x667E0000 - 0x6686E000	(C:\WINDOWS\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.8387_none_5094ca96bcb6b2bb\MSVCP90.dll)

ADVAPI32.dll	A: 0x774E0000 - 0x77558000	(C:\WINDOWS\SYSTEM32\ADVAPI32.dll)

napinsp.dll	A: 0x73A60000 - 0x73A70000	(C:\WINDOWS\system32\napinsp.dll)

pnrpnsp.dll	A: 0x736B0000 - 0x736C4000	(C:\WINDOWS\system32\pnrpnsp.dll)

NLAapi.dll	A: 0x734D0000 - 0x734E2000	(C:\WINDOWS\system32\NLAapi.dll)

mswsock.dll	A: 0x73850000 - 0x73895000	(C:\WINDOWS\System32\mswsock.dll)

DNSAPI.dll	A: 0x745F0000 - 0x7466C000	(C:\WINDOWS\SYSTEM32\DNSAPI.dll)
Server log
Код HTML:
SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team

[18:12:50] filterscripts = ""  (string)
[18:12:50] 
[18:12:50] Server Plugins
[18:12:50] --------------
[18:12:50]  Loading plugin: streamer
[18:12:50] 

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

[18:12:50]   Loaded.
[18:12:50]  Loading plugin: sscanf
[18:12:50] 

[18:12:50]  ===============================

[18:12:50]       sscanf plugin loaded.     

[18:12:50]          Version:  2.8.1        

[18:12:50]    © 2012 Alex "******" Cole  

[18:12:50]  ===============================

[18:12:50]   Loaded.
[18:12:50]  Loading plugin: crashdetect
[18:12:50]   CrashDetect v4.13.1-lse is OK.
[18:12:50]   Loaded.
[18:12:50]  Loading plugin: mysql
[18:12:50]  SA:MP MySQL Plugin v2.1.1 Loaded.
[18:12:50]   Loaded.
[18:12:50]  Loaded 4 plugins.

[18:12:50] [MySQL] Thread running. Threadsafe: Yes.
[18:12:50] 
[18:12:50] Filterscripts
[18:12:50] ---------------
[18:12:50]   Loaded 0 filterscripts.

[18:12:50] *** Streamer Plugin: Include file version (0x27002) does not match plugin version (0x26105) (script needs to be recompiled with the latest include file)
[18:12:50] Function: mysql_connect called with incorrect parameter count.
[18:12:50] [MySQL] Prisijungimas prie MySQL pavyko!
[18:12:50] 
----------------------------------
[18:12:50]  Modifikacijos kūrėjai Jeremy`Johnson bei Domis`Domkė
[18:12:50] ----------------------------------

[18:12:50] Number of vehicle models: 0
[18:13:18] Incoming connection: 25.35.90.13:62996
[18:13:18] [join] Harry_Jones has joined the server (0:25.35.90.13)
[18:13:18] [debug] Server crashed while executing sfstories.amx
[18:13:18] [debug] AMX backtrace:
[18:13:18] [debug] #0 native mysql_query () [00517780] from mysql.DLL
[18:13:18] [debug] #1 00006f98 in public SSCANF_OnPlayerConnect (0x00000000) from sfstories.amx
[18:13:18] [debug] #2 native CallLocalFunction () [00472ad0] from samp-server.exe
[18:13:18] [debug] #3 00000c7c in public Streamer_OnPlayerConnect (0x00000000) from sfstories.amx
[18:13:18] [debug] #4 00000054 in public OnPlayerConnect (0x00000000) from sfstories.amx
[18:13:19] [debug] Native backtrace:
[18:13:19] [debug] #0 005142ea in ?? () from plugins\mysql.DLL
[18:13:19] [debug] #1 00517820 in ?? () from plugins\mysql.DLL
[18:13:19] [debug] #2 004010b6 in ?? () from samp-server.exe
[18:13:19] [debug] #3 6d52543a in ?? () from plugins\crashdetect.DLL
[18:13:19] [debug] #4 6d52728f in ?? () from plugins\crashdetect.DLL
[18:13:19] [debug] #5 6d519d54 in ?? () from plugins\crashdetect.DLL
[18:13:19] [debug] #6 6d52548a in ?? () from plugins\crashdetect.DLL
[18:13:19] [debug] #7 00472dde in ?? () from samp-server.exe
[18:13:19] [debug] #8 004010b6 in ?? () from samp-server.exe
[18:13:19] [debug] #9 6d52543a in ?? () from plugins\crashdetect.DLL
[18:13:19] [debug] #10 6d52728f in ?? () from plugins\crashdetect.DLL
[18:13:19] [debug] #11 6d519d54 in ?? () from plugins\crashdetect.DLL
[18:13:19] [debug] #12 6d52548a in ?? () from plugins\crashdetect.DLL
[18:13:19] [debug] #13 0046cc20 in ?? () from samp-server.exe
[18:13:19] [debug] #14 00465f3f in ?? () from samp-server.exe
[18:13:19] [debug] #15 00493b36 in ?? () from samp-server.exe
[18:13:19] [debug] #16 00469089 in ?? () from samp-server.exe
[18:13:19] [debug] #17 00258178 in ?? ()
[18:13:19] [debug] Server crashed while executing sfstories.amx
[18:13:19] [debug] AMX backtrace:
[18:13:19] [debug] #0 native mysql_query () [00517780] from mysql.DLL
[18:13:19] [debug] #1 00006f98 in public Streamer_OnPlayerConnect (0x00000000) from sfstories.amx
[18:13:19] [debug] #2 00000054 in public SSCANF_OnPlayerConnect (0x00000000) from sfstories.amx
[18:13:19] [debug] #3 native CallLocalFunction () [00472ad0] from samp-server.exe
[18:13:19] [debug] #4 00000c7c in public Streamer_OnPlayerConnect (0x00000000) from sfstories.amx
[18:13:19] [debug] #5 00000054 in public OnPlayerConnect (0x00000000) from sfstories.amx
[18:13:20] [debug] Native backtrace:
[18:13:20] [debug] #0 7794f94d in ?? () from C:\WINDOWS\SYSTEM32\ntdll.dll
[18:13:20] [debug] #1 00493bf1 in ?? () from samp-server.exe
[18:13:20] [debug] #2 0044e129 in ?? () from samp-server.exe
[18:13:20] [debug] #3 00458bcc in ?? () from samp-server.exe
[18:13:20] [debug] #4 00010100 in ?? ()
[18:13:20] [debug] #5 0045a3b0 in ?? () from samp-server.exe
[18:13:20] [debug] #6 0045a650 in ?? () from samp-server.exe
[18:13:20] [debug] #7 0045b040 in ?? () from samp-server.exe
[18:13:20] [debug] #8 00450660 in ?? () from samp-server.exe
[18:13:20] [debug] #9 00450670 in ?? () from samp-server.exe
[18:13:20] [debug] #10 00450680 in ?? () from samp-server.exe
[18:13:20] [debug] #11 004506d0 in ?? () from samp-server.exe
[18:13:20] [debug] #12 00458160 in ?? () from samp-server.exe
[18:13:20] [debug] #13 0045b050 in ?? () from samp-server.exe
[18:13:20] [debug] #14 0045b060 in ?? () from samp-server.exe
[18:13:20] [debug] #15 00450720 in ?? () from samp-server.exe
[18:13:20] [debug] #16 0045b070 in ?? () from samp-server.exe
[18:13:20] [debug] #17 0045b080 in ?? () from samp-server.exe
[18:13:20] [debug] #18 0045b630 in ?? () from samp-server.exe
[18:13:20] [debug] #19 0045b090 in ?? () from samp-server.exe
[18:13:20] [debug] #20 00450830 in ?? () from samp-server.exe
[18:13:20] [debug] #21 0045b0a0 in ?? () from samp-server.exe
[18:13:20] [debug] #22 0045b0b0 in ?? () from samp-server.exe
[18:13:20] [debug] #23 0045b0c0 in ?? () from samp-server.exe
[18:13:20] [debug] #24 0045b0d0 in ?? () from samp-server.exe
[18:13:20] [debug] #25 0045b0e0 in ?? () from samp-server.exe
[18:13:20] [debug] #26 00458610 in ?? () from samp-server.exe
[18:13:20] [debug] #27 0045b0f0 in ?? () from samp-server.exe
[18:13:20] [debug] #28 0045b100 in ?? () from samp-server.exe
[18:13:20] [debug] #29 00452210 in ?? () from samp-server.exe
[18:13:20] [debug] #30 0045b110 in ?? () from samp-server.exe
[18:13:20] [debug] #31 0045b120 in ?? () from samp-server.exe
[18:13:20] [debug] #32 0045b130 in ?? () from samp-server.exe
[18:13:20] [debug] #33 00452410 in ?? () from samp-server.exe
[18:13:20] [debug] #34 00458640 in ?? () from samp-server.exe
[18:13:20] [debug] #35 0045b140 in ?? () from samp-server.exe
[18:13:20] [debug] #36 00455d60 in ?? () from samp-server.exe
[18:13:20] [debug] #37 00455db0 in ?? () from samp-server.exe
[18:13:20] [debug] #38 00450910 in ?? () from samp-server.exe
[18:13:20] [debug] #39 00455df0 in ?? () from samp-server.exe
[18:13:20] [debug] #40 00455e40 in ?? () from samp-server.exe
[18:13:20] [debug] #41 00458660 in ?? () from samp-server.exe
[18:13:20] [debug] #42 0045b150 in ?? () from samp-server.exe
[18:13:20] [debug] #43 0045b160 in ?? () from samp-server.exe
[18:13:20] [debug] #44 00450990 in ?? () from samp-server.exe
[18:13:20] [debug] #45 0045b170 in ?? () from samp-server.exe
[18:13:20] [debug] #46 0045b180 in ?? () from samp-server.exe
[18:13:20] [debug] #47 0045b190 in ?? () from samp-server.exe
[18:13:20] [debug] #48 0045b1a0 in ?? () from samp-server.exe
[18:13:20] [debug] #49 0045b1b0 in ?? () from samp-server.exe
[18:13:20] [debug] #50 00450b00 in ?? () from samp-server.exe
[18:13:20] [debug] #51 00450e80 in ?? () from samp-server.exe
[18:13:20] [debug] #52 00450b50 in ?? () from samp-server.exe
[18:13:20] [debug] #53 0045b1c0 in ?? () from samp-server.exe
[18:13:20] [debug] #54 00450b60 in ?? () from samp-server.exe
[18:13:20] [debug] #55 00450bb0 in ?? () from samp-server.exe
[18:13:20] [debug] #56 00450c00 in ?? () from samp-server.exe
[18:13:20] [debug] #57 00450c10 in ?? () from samp-server.exe
[18:13:20] [debug] #58 0045b1d0 in ?? () from samp-server.exe
[18:13:20] [debug] #59 0045b1e0 in ?? () from samp-server.exe
[18:13:20] [debug] #60 0045b1f0 in ?? () from samp-server.exe
[18:13:20] [debug] #61 0045b200 in ?? () from samp-server.exe
[18:13:20] [debug] #62 0045b210 in ?? () from samp-server.exe
[18:13:20] [debug] #63 0045b220 in ?? () from samp-server.exe
[18:13:20] [debug] #64 0045b230 in ?? () from samp-server.exe
[18:13:20] [debug] #65 0045b240 in ?? () from samp-server.exe
[18:13:20] [debug] #66 0045b250 in ?? () from samp-server.exe
[18:13:20] [debug] #67 0045b260 in ?? () from samp-server.exe
[18:13:20] [debug] #68 0045b270 in ?? () from samp-server.exe
[18:13:20] [debug] #69 0045b280 in ?? () from samp-server.exe
[18:13:20] [debug] #70 00455f10 in ?? () from samp-server.exe
Code pwn
Код HTML:
public OnPlayerConnect(playerid)
{
	Logged[playerid] = false;
	new Query[80],pName[24],string[300], ip[16];
	GetPlayerIp(playerid,ip,sizeof(ip));
	GetPlayerName(playerid,pName,24);
	format(Query,sizeof(Query),"SELECT `Vardas` FROM `vartotojai` WHERE `Vardas` = '%s' LIMIT 1;",pName);
	mysql_query(Query);
	mysql_store_result();
	if(mysql_num_rows() != 0)
	{
	format(string,sizeof(string),"Sveikas, %s! \nJūsų IP adresas: %i\nPraљome įvesti slaptaћodį į laukelį norint prisijungti!",pName, ip);
	ShowPlayerDialog(playerid,4,DIALOG_STYLE_INPUT,"SF-STORIES.LT - PRISIJUNGIMAS",string,"Prisijungti","Atљaukti");
	}
	else
	{
	format(string,sizeof(string),"Sveikas, %s! \nJūsų vartotojas nebuvo atpaћintas mūsų duomenų bazėje. \nPraљome įvesti savo vartotojo slaptaћodį kurį naudosite prisijungiant!",pName);
	ShowPlayerDialog(playerid,5,DIALOG_STYLE_INPUT,"SF-STORIES.LT - REGISTRACIJA",string,"Registruotis","Atљaukti");
	}
	mysql_free_result();
	return 1;
}
Reply
#2

help pls
Reply
#3

help..
Reply
#4

Not certain, but try removing ";" in your query string, maybe that plugin adds it's own separator and crash occurs.
Reply
#5

Quote:
Originally Posted by Misiur
Посмотреть сообщение
Not certain, but try removing ";" in your query string, maybe that plugin adds it's own separator and crash occurs.
C:\Users\Dominykas-PC\Desktop\SF-STORIES.LT GAMEMODE\gamemodes\sfstories.pwn(105) : error 001: expected token: ";", but found "-identifier-"
Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase


1 Error.
Reply
#6

He means you should write it like this:

Код:
format(Query,sizeof(Query),"SELECT `Vardas` FROM `vartotojai` WHERE `Vardas` = '%s' LIMIT 1",pName);
//Edit:
But it shouldn't crash because of it...well, maybe dont make it under OnPlayerConnect, use OnPlayerRequestClass instead
Reply
#7

Quote:
Originally Posted by Kaliber
Посмотреть сообщение
He means you should write it like this:

Код:
format(Query,sizeof(Query),"SELECT `Vardas` FROM `vartotojai` WHERE `Vardas` = '%s' LIMIT 1",pName);
//Edit:
But it shouldn't crash because of it...well, maybe dont make it under OnPlayerConnect, use OnPlayerRequestClass instead
i am fixed a problem, updated mysql plugin to r6

thanks all, lock.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)