Neveikia krovimas/saugojimas MYSQL

SaSkript · Sausio 17, 2014

stock KrautiInfo(playerid)

{

new name[MAX_PLAYER_NAME],query[70];

GetPlayerName(playerid,name,sizeof(name));

format(query,sizeof(query),"SELECT * FROM zaidejai WHERE Vardas = '%s'",name);

mysql_query(query);

mysql_store_result();

if(mysql_retrieve_row())

{

new tmp[32];

GetPlayerPos(playerid,pInfo[playerid][X],pInfo[playerid][Y],pInfo[playerid][Z]);

mysql_fetch_field_row(tmp,"ID"); pInfo[playerid][iD] = strval(tmp);

mysql_fetch_field_row(pInfo[playerid][Vardas],"Vardas");

mysql_fetch_field_row(tmp,"Pinigai"); pInfo[playerid][Pinigai]= strval(tmp);

mysql_fetch_field_row(tmp,"Xp"); pInfo[playerid][Xp] = strval(tmp);

mysql_fetch_field_row(tmp,"Darbas"); pInfo[playerid][Darbas] = strval(tmp);

mysql_fetch_field_row(tmp,"Hp"); pInfo[playerid][Hp] = floatstr(tmp);

mysql_fetch_field_row(tmp,"X"); pInfo[playerid][X] = floatstr(tmp);

mysql_fetch_field_row(tmp,"Y"); pInfo[playerid][Y] = floatstr(tmp);

mysql_fetch_field_row(tmp,"Z"); pInfo[playerid][Z] = floatstr(tmp);

}

mysql_free_result();

return 1;

}

stock SaugotiInfo(playerid)

{

new query[100];

format(query,sizeof(query),"UPDATE zaidejai SET Pinigai = %d, Xp = %d, Darbas = %d, Hp = %f,X = %f,Y = %f,Z = %f WHERE ID = %d",

pInfo[playerid][Pinigai],pInfo[playerid][Xp],pInfo[playerid][Darbas],pInfo[playerid][Hp],pInfo[playerid][X],pInfo[playerid][Y],pInfo[playerid][Z],pInfo[playerid][iD]);

mysql_query(query);

return 1;

}

Logai:

17:10:20] MySQL Debugging activated (01/17/14)

[17:10:20] ---------------------------

[17:10:20]

[17:10:20] >> mysql_connect( )

[17:10:20] CMySQLHandler::CMySQLHandler() - constructor called.

[17:10:20] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "vartotojai" | Username: "root" ...

[17:10:20] CMySQLHandler::Connect() - Connection was successful.

[17:10:20] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[17:10:36] >> mysql_reconnect( Connection handle: 1 )

[17:10:36] CMySQLHandler::Disconnect() - Connection was closed.

[17:10:36] CMySQLHandler::Connect() - Connection was successful.

[17:10:36] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[17:10:36] >> mysql_query( Connection handle: 1 )

[17:10:36] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Darijus_Whitesa') - Successfully executed.

[17:10:36] >> mysql_store_result( Connection handle: 1 )

[17:10:36] CMySQLHandler::StoreResult() - Result was stored.

[17:10:36] >> mysql_num_rows( Connection handle: 1 )

[17:10:36] CMySQLHandler::NumRows() - Returned 1 row(s)

[17:10:36] >> mysql_free_result( Connection handle: 1 )

[17:10:36] CMySQLHandler::FreeResult() - Result was successfully free'd.

[17:10:38] >> mysql_reconnect( Connection handle: 1 )

[17:10:38] CMySQLHandler::Disconnect() - Connection was closed.

[17:10:38] CMySQLHandler::Connect() - Connection was successful.

[17:10:38] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[17:10:38] >> mysql_query( Connection handle: 1 )

[17:10:38] CMySQLHandler::Query(SELECT Pinigai FROM `zaidejai` WHERE Vardas = 'Darijus_Whitesa' AND Slaptazodis = '123456' LIMIT 100) - Successfully executed.

[17:10:38] >> mysql_store_result( Connection handle: 1 )

[17:10:38] CMySQLHandler::StoreResult() - Result was stored.

[17:10:38] >> mysql_num_rows( Connection handle: 1 )

[17:10:38] CMySQLHandler::NumRows() - Returned 1 row(s)

[17:10:38] >> mysql_fetch_int( Connection handle: 1 )

[17:10:38] CMySQLHandler::FetchRow() - Return: 0

[17:10:38] >> mysql_free_result( Connection handle: 1 )

[17:10:38] CMySQLHandler::FreeResult() - Result was successfully free'd.

[17:10:41] >> mysql_query( Connection handle: 1 )

[17:10:41] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Darijus_Whitesa') - Successfully executed.

[17:10:41] >> mysql_store_result( Connection handle: 1 )

[17:10:41] CMySQLHandler::StoreResult() - Result was stored.

[17:10:41] >> mysql_retrieve_row( Connection handle: 1 )

[17:10:41] >> mysql_fetch_field_row( Connection handle: 1 )

[17:10:41] CMySQLHandler::FetchField("ID") - 4

[17:10:41] >> mysql_fetch_field_row( Connection handle: 1 )

[17:10:56]

per phpmyadmin nusistatau 10XP, tai kai prisijungiu rodo: 0XP, kas blogai? :X

bebras · Sausio 17, 2014

Daugiau logo parodyk, svarbiausioje vietoje jis ir baigiasi

SaSkript · Sausio 17, 2014

Daugiau logo parodyk, svarbiausioje vietoje jis ir baigiasi

Kai atsijungiu ir serveris išsijungia

log:

[17:17:56]

[17:17:56] ---------------------------

[17:17:56] MySQL Debugging activated (01/17/14)

[17:17:56] ---------------------------

[17:17:56]

[17:17:56] >> mysql_connect( )

[17:17:56] CMySQLHandler::CMySQLHandler() - constructor called.

[17:17:56] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "vartotojai" | Username: "root" ...

[17:17:56] CMySQLHandler::Connect() - Connection was successful.

[17:17:56] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[17:18:24] >> mysql_reconnect( Connection handle: 1 )

[17:18:24] CMySQLHandler::Disconnect() - Connection was closed.

[17:18:24] CMySQLHandler::Connect() - Connection was successful.

[17:18:24] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[17:18:24] >> mysql_query( Connection handle: 1 )

[17:18:24] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Darijus_Whitene') - Successfully executed.

[17:18:24] >> mysql_store_result( Connection handle: 1 )

[17:18:24] CMySQLHandler::StoreResult() - Result was stored.

[17:18:24] >> mysql_num_rows( Connection handle: 1 )

[17:18:24] CMySQLHandler::NumRows() - Returned 0 row(s)

[17:18:24] >> mysql_free_result( Connection handle: 1 )

[17:18:24] CMySQLHandler::FreeResult() - Result was successfully free'd.

[17:18:26] >> mysql_reconnect( Connection handle: 1 )

[17:18:26] CMySQLHandler::Disconnect() - Connection was closed.

[17:18:26] CMySQLHandler::Connect() - Connection was successful.

[17:18:26] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[17:18:26] >> mysql_query( Connection handle: 1 )

[17:18:26] CMySQLHandler::Query(INSERT INTO `zaidejai` (Vardas,Slaptazodis) VALUES ('Darijus_Whitene','123456')) - Successfully executed.

[17:18:28] >> mysql_query( Connection handle: 1 )

[17:18:28] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Darijus_Whitene') - Successfully executed.

[17:18:28] >> mysql_store_result( Connection handle: 1 )

[17:18:28] CMySQLHandler::StoreResult() - Result was stored.

[17:18:28] >> mysql_retrieve_row( Connection handle: 1 )

[17:18:28] >> mysql_fetch_field_row( Connection handle: 1 )

[17:18:28] CMySQLHandler::FetchField("ID") - 5

[17:18:28] >> mysql_fetch_field_row( Connection handle: 1 )

[17:18:58]

[17:18:58] ---------------------------

[17:18:58] MySQL Debugging activated (01/17/14)

[17:18:58] ---------------------------

[17:18:58]

[17:18:58] >> mysql_connect( )

[17:18:58] CMySQLHandler::CMySQLHandler() - constructor called.

[17:18:58] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "vartotojai" | Username: "root" ...

[17:18:58] CMySQLHandler::Connect() - Connection was successful.

[17:18:58] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[17:19:02] >> mysql_reconnect( Connection handle: 1 )

[17:19:02] CMySQLHandler::Disconnect() - Connection was closed.

[17:19:02] CMySQLHandler::Connect() - Connection was successful.

[17:19:02] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[17:19:02] >> mysql_query( Connection handle: 1 )

[17:19:02] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Darijus_Whitene') - Successfully executed.

[17:19:02] >> mysql_store_result( Connection handle: 1 )

[17:19:02] CMySQLHandler::StoreResult() - Result was stored.

[17:19:02] >> mysql_num_rows( Connection handle: 1 )

[17:19:02] CMySQLHandler::NumRows() - Returned 1 row(s)

[17:19:02] >> mysql_free_result( Connection handle: 1 )

[17:19:02] CMySQLHandler::FreeResult() - Result was successfully free'd.

[17:19:06] >> mysql_reconnect( Connection handle: 1 )

[17:19:06] CMySQLHandler::Disconnect() - Connection was closed.

[17:19:06] CMySQLHandler::Connect() - Connection was successful.

[17:19:06] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[17:19:06] >> mysql_query( Connection handle: 1 )

[17:19:06] CMySQLHandler::Query(SELECT Pinigai FROM `zaidejai` WHERE Vardas = 'Darijus_Whitene' AND Slaptazodis = '123456' LIMIT 100) - Successfully executed.

[17:19:06] >> mysql_store_result( Connection handle: 1 )

[17:19:06] CMySQLHandler::StoreResult() - Result was stored.

[17:19:06] >> mysql_num_rows( Connection handle: 1 )

[17:19:06] CMySQLHandler::NumRows() - Returned 1 row(s)

[17:19:06] >> mysql_fetch_int( Connection handle: 1 )

[17:19:06] CMySQLHandler::FetchRow() - Return: 0

[17:19:06] >> mysql_free_result( Connection handle: 1 )

[17:19:06] CMySQLHandler::FreeResult() - Result was successfully free'd.

[17:19:07] >> mysql_query( Connection handle: 1 )

[17:19:07] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Darijus_Whitene') - Successfully executed.

[17:19:07] >> mysql_store_result( Connection handle: 1 )

[17:19:07] CMySQLHandler::StoreResult() - Result was stored.

[17:19:07] >> mysql_retrieve_row( Connection handle: 1 )

[17:19:07] >> mysql_fetch_field_row( Connection handle: 1 )

[17:19:07] CMySQLHandler::FetchField("ID") - 5

[17:19:07] >> mysql_fetch_field_row( Connection handle: 1 )

SaSkript · Sausio 17, 2014

Crash log:

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

SA-MP Server: 0.3x-R2

Exception At Address: 0x73DFB9F0 Module: (MSVCR90.dll)

Registers:

EAX: 0x007C6FE0 EBX: 0x02B1BF4C ECX: 0x00000000 EDX: 0x007A7088

ESI: 0x0018FA5C EDI: 0x02989710 EBP: 0x0018FA20 ESP: 0x0018FA14

EFLAGS: 0x00010246

Stack:

+0000: 0x73795DB4 0x00000000 0x02989710 0x0018FA54

+0010: 0x003990B4 0x00000000 0x1727E42E 0x0018FA5C

+0020: 0x02B1BF4C 0x007A7088 0x737972AA 0x00000001

+0030: 0x00000000 0x0018FAB8 0x00399B1D 0x00000000

+0040: 0x0018FAC4 0x003966B3 0x003999FB 0x64726156

+0050: 0x00007361 0x0039668F 0x0018FA90 0x00000006

+0060: 0x0000000F 0x1727E4BE 0x00406BA8 0x0018FA5C

+0070: 0x02989710 0x02989710 0x0018FA5C 0x00000001

+0080: 0x64726156 0x00007361 0x0018FAC4 0x02989710

+0090: 0x00000006 0x0000000F 0x1727E4BE 0x007A7088

+00A0: 0x00000000 0x0018FCAC 0x00399C70 0x00000000

+00B0: 0x02B1DACC 0x004010B6 0x02989710 0x02B34C4C

+00C0: 0x02B1E168 0x00402B63 0x02989710 0x0000001F

+00D0: 0x0018FAFC 0x02B34C4C 0x0018FC50 0x02989710

+00E0: 0x00000000 0x02902B0B 0x000012C4 0x00000AF0

+00F0: 0x00016AE4 0x00016D0C 0x00012D10 0x00016CEC

+0100: 0x00012D10 0x02B1BF4C 0x02B1E168 0x00000000

+0110: 0x02B1B798 0x0000221C 0x0046C990 0x02989710

+0120: 0x0018FB48 0x00000018 0x02989710 0x00000000

+0130: 0x00000000 0x00000000 0x00000018 0x0048C7AF

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

Loaded Modules:

samp-server.exe A: 0x00400000 - 0x004F5000 (C:\Users\Darka\Desktop\mg.lt\samp-server.exe)

ntdll.dll A: 0x77BF0000 - 0x77D47000 (C:\Windows\SYSTEM32\ntdll.dll)

KERNEL32.DLL A: 0x771A0000 - 0x772D0000 (C:\Windows\SYSTEM32\KERNEL32.DLL)

KERNELBASE.dll A: 0x75570000 - 0x75616000 (C:\Windows\SYSTEM32\KERNELBASE.dll)

SHELL32.dll A: 0x75800000 - 0x768C6000 (C:\Windows\SYSTEM32\SHELL32.dll)

USER32.dll A: 0x75450000 - 0x75566000 (C:\Windows\SYSTEM32\USER32.dll)

WSOCK32.dll A: 0x74F20000 - 0x74F28000 (C:\Windows\SYSTEM32\WSOCK32.dll)

WINMM.dll A: 0x73CE0000 - 0x73D01000 (C:\Windows\SYSTEM32\WINMM.dll)

msvcrt.dll A: 0x75370000 - 0x75421000 (C:\Windows\SYSTEM32\msvcrt.dll)

combase.dll A: 0x76E70000 - 0x76FA6000 (C:\Windows\SYSTEM32\combase.dll)

SHLWAPI.dll A: 0x76DA0000 - 0x76DE0000 (C:\Windows\SYSTEM32\SHLWAPI.dll)

GDI32.dll A: 0x768D0000 - 0x769CD000 (C:\Windows\SYSTEM32\GDI32.dll)

WS2_32.dll A: 0x75620000 - 0x75670000 (C:\Windows\SYSTEM32\WS2_32.dll)

WINMMBASE.dll A: 0x73740000 - 0x7376B000 (C:\Windows\SYSTEM32\WINMMBASE.dll)

RPCRT4.dll A: 0x75750000 - 0x757FC000 (C:\Windows\SYSTEM32\RPCRT4.dll)

NSI.dll A: 0x75740000 - 0x75748000 (C:\Windows\SYSTEM32\NSI.dll)

cfgmgr32.dll A: 0x772D0000 - 0x77316000 (C:\Windows\SYSTEM32\cfgmgr32.dll)

DEVOBJ.dll A: 0x75670000 - 0x7568E000 (C:\Windows\SYSTEM32\DEVOBJ.dll)

SspiCli.dll A: 0x75220000 - 0x7523C000 (C:\Windows\SYSTEM32\SspiCli.dll)

CRYPTBASE.dll A: 0x75210000 - 0x75219000 (C:\Windows\SYSTEM32\CRYPTBASE.dll)

sechost.dll A: 0x769E0000 - 0x76A14000 (C:\Windows\SYSTEM32\sechost.dll)

bcryptPrimitives.dll A: 0x751B0000 - 0x75201000 (C:\Windows\SYSTEM32\bcryptPrimitives.dll)

IMM32.DLL A: 0x77050000 - 0x77070000 (C:\Windows\system32\IMM32.DLL)

MSCTF.dll A: 0x75240000 - 0x7531E000 (C:\Windows\SYSTEM32\MSCTF.dll)

sscanf.DLL A: 0x10000000 - 0x1000D000 (C:\Users\Darka\Desktop\mg.lt\plugins\sscanf.DLL)

MSVCR100.dll A: 0x71600000 - 0x716BF000 (C:\Windows\SYSTEM32\MSVCR100.dll)

streamer.dll A: 0x6EE30000 - 0x6EE6E000 (C:\Users\Darka\Desktop\mg.lt\plugins\streamer.dll)

MSVCP100.dll A: 0x716C0000 - 0x71729000 (C:\Windows\SYSTEM32\MSVCP100.dll)

mysql.DLL A: 0x00390000 - 0x003A3000 (C:\Users\Darka\Desktop\mg.lt\plugins\mysql.DLL)

LIBMYSQL.dll A: 0x02420000 - 0x0265E000 (C:\Users\Darka\Desktop\mg.lt\LIBMYSQL.dll)

MSVCR90.dll A: 0x73DC0000 - 0x73E63000 (C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6871_none_50944e7cbcb706e5\MSVCR90.dll)

MSVCP90.dll A: 0x73790000 - 0x7381E000 (C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6871_none_50944e7cbcb706e5\MSVCP90.dll)

ADVAPI32.dll A: 0x75690000 - 0x7573E000 (C:\Windows\SYSTEM32\ADVAPI32.dll)

napinsp.dll A: 0x72F80000 - 0x72F90000 (C:\Windows\system32\napinsp.dll)

pnrpnsp.dll A: 0x72E90000 - 0x72EA4000 (C:\Windows\system32\pnrpnsp.dll)

NLAapi.dll A: 0x72F90000 - 0x72FA0000 (C:\Windows\system32\NLAapi.dll)

mswsock.dll A: 0x72EB0000 - 0x72EFA000 (C:\Windows\System32\mswsock.dll)

DNSAPI.dll A: 0x72E00000 - 0x72E75000 (C:\Windows\SYSTEM32\DNSAPI.dll)

winrnr.dll A: 0x72DF0000 - 0x72DF9000 (C:\Windows\System32\winrnr.dll)

wshbth.dll A: 0x72DE0000 - 0x72DF0000 (C:\Windows\system32\wshbth.dll)

mdnsNSP.dll A: 0x72DB0000 - 0x72DD1000 (C:\Program Files (x86)\Bonjour\mdnsNSP.dll)

Iphlpapi.DLL A: 0x74DD0000 - 0x74DF0000 (C:\Windows\SYSTEM32\Iphlpapi.DLL)

WINNSI.DLL A: 0x74D30000 - 0x74D38000 (C:\Windows\SYSTEM32\WINNSI.DLL)

rasadhlp.dll A: 0x72DA0000 - 0x72DA7000 (C:\Windows\System32\rasadhlp.dll)

nativechecker.dll A: 0x718B0000 - 0x718B5000 (C:\Users\Darka\Desktop\mg.lt\plugins\nativechecker.dll)

bebras · Sausio 17, 2014

Dėl serverio išsijungimo, įsikelk "crashdetect" plugin ir tada parodyk server log kai išsijungs.

SaSkript · Sausio 17, 2014

Oke:

SA-MP Dedicated Server

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

v0.3x-R2, ©2005-2013 SA-MP Team

[22:22:16] filterscripts = "" (string)

[22:22:16]

[22:22:16] Server Plugins

[22:22:16] --------------

[22:22:16] Loading plugin: sscanf

[22:22:16]

[22:22:16] ===============================

[22:22:16] sscanf plugin loaded.

[22:22:16] Version: 2.8.1

[22:22:16] © 2012 Alex "Y_Less" Cole

[22:22:16] ===============================

[22:22:16] Loaded.

[22:22:16] Loading plugin: streamer.dll

[22:22:16]

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

[22:22:16] Loaded.

[22:22:16] Loading plugin: mysql

[22:22:16]

> MySQL plugin R5 successfully loaded.

[22:22:16] Loaded.

[22:22:16] Loading plugin: nativechecker.dll

[22:22:16] Loaded.

[22:22:16] Loading plugin: crashdetect.dll

[22:22:16] CrashDetect v4.13 is OK.

[22:22:16] Loaded.

[22:22:16] Loaded 5 plugins.

[22:22:16]

[22:22:16] Filterscripts

[22:22:16] ---------------

[22:22:16] Loaded 0 filterscripts.

[22:22:16]

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

[22:22:16] Hi.

[22:22:16] ----------------------------------

[22:22:16] Number of vehicle models: 0

[22:22:36] Incoming connection: 127.0.0.1:55902

[22:22:36] [join] Darijus_Whitene has joined the server (0:127.0.0.1)

[22:22:39] [debug] Server crashed while executing GM.amx

[22:22:39] [debug] AMX backtrace:

[22:22:39] [debug] #0 native mysql_fetch_field_row () [003a65e0] from mysql.DLL

[22:22:39] [debug] #1 00001b80 in ?? (0x00000000) from GM.amx

[22:22:39] [debug] #2 00000da8 in public OnPlayerSpawn (0x00000000) from GM.amx

[22:22:40] [debug] Native backtrace:

[22:22:40] [debug] #0 73dfb9f0 in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6871_none_50944e7cbcb706e5\MSVCR90.dll

[22:22:40] [debug] #1 003a90b4 in ?? () from plugins\mysql.DLL

[22:22:40] [debug] #2 003a66b3 in ?? () from plugins\mysql.DLL

[22:22:40] [debug] #3 004010b6 in ?? () from samp-server.exe

[22:22:40] [debug] #4 6eec58ca in ?? () from plugins\crashdetect.dll

[22:22:40] [debug] #5 6eec774f in ?? () from plugins\crashdetect.dll

[22:22:40] [debug] #6 6eec0834 in ?? () from plugins\crashdetect.dll

[22:22:40] [debug] #7 6eec591a in ?? () from plugins\crashdetect.dll

[22:22:40] [debug] #8 0046c990 in ?? () from samp-server.exe

[22:22:40] [debug] #9 77c41fbd in ?? () from C:\Windows\SYSTEM32\ntdll.dll

[22:22:40] [debug] #10 00610064 in ?? ()

[22:22:40] [debug] #11 00750067 in ?? ()

bebras · Sausio 17, 2014

Blah ta funkcija "mysql_fetch_field_row ".... Ji yra žinoma kad kartais crashina.(aplinkybės nežinomos...).

Dėl prieš tai buvusios problemos, ten tikrai visas mysql log?

SaSkript · Sausio 17, 2014

Blah ta funkcija "mysql_fetch_field_row ".... Ji yra žinoma kad kartais crashina.(aplinkybės nežinomos...).

Dėl prieš tai buvusios problemos, ten tikrai visas mysql log?

Tai kaip ištaisyti?

[22:22:16] MySQL Debugging activated (01/17/14)

[22:22:16] ---------------------------

[22:22:16]

[22:22:16] >> mysql_connect( )

[22:22:16] CMySQLHandler::CMySQLHandler() - constructor called.

[22:22:16] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "vartotojai" | Username: "root" ...

[22:22:16] CMySQLHandler::Connect() - Connection was successful.

[22:22:16] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[22:22:36] >> mysql_reconnect( Connection handle: 1 )

[22:22:36] CMySQLHandler::Disconnect() - Connection was closed.

[22:22:36] CMySQLHandler::Connect() - Connection was successful.

[22:22:36] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[22:22:36] >> mysql_query( Connection handle: 1 )

[22:22:36] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Darijus_Whitene') - Successfully executed.

[22:22:36] >> mysql_store_result( Connection handle: 1 )

[22:22:36] CMySQLHandler::StoreResult() - Result was stored.

[22:22:36] >> mysql_num_rows( Connection handle: 1 )

[22:22:36] CMySQLHandler::NumRows() - Returned 1 row(s)

[22:22:36] >> mysql_free_result( Connection handle: 1 )

[22:22:36] CMySQLHandler::FreeResult() - Result was successfully free'd.

[22:22:38] >> mysql_reconnect( Connection handle: 1 )

[22:22:38] CMySQLHandler::Disconnect() - Connection was closed.

[22:22:38] CMySQLHandler::Connect() - Connection was successful.

[22:22:38] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[22:22:38] >> mysql_query( Connection handle: 1 )

[22:22:38] CMySQLHandler::Query(SELECT Pinigai FROM `zaidejai` WHERE Vardas = 'Darijus_Whitene' AND Slaptazodis = '123456' LIMIT 100) - Successfully executed.

[22:22:38] >> mysql_store_result( Connection handle: 1 )

[22:22:38] CMySQLHandler::StoreResult() - Result was stored.

[22:22:38] >> mysql_num_rows( Connection handle: 1 )

[22:22:38] CMySQLHandler::NumRows() - Returned 1 row(s)

[22:22:38] >> mysql_fetch_int( Connection handle: 1 )

[22:22:38] CMySQLHandler::FetchRow() - Return: 0

[22:22:38] >> mysql_free_result( Connection handle: 1 )

[22:22:38] CMySQLHandler::FreeResult() - Result was successfully free'd.

[22:22:39] >> mysql_query( Connection handle: 1 )

SaSkript · Sausio 17, 2014

Huh, pasidariau, kad duotu 750 iš pardžiu, užsiregistruoju, duoda, atsijungiu, prisijungiu nieko, pasižiūriu phpmyadmin viskas 0..

bebras · Sausio 17, 2014

Tai kad tavo log'e ir nesimato jokių saugojimo žymių.

SaSkript · Sausio 17, 2014

mm:

public OnPlayerDisconnect(playerid, reason)

{

SaugotiInfo(playerid);

return 1;

}

stock SaugotiInfo(playerid)
{
new query[100];
format(query,sizeof(query),"UPDATE zaidejai SET Pinigai = %d, Xp = %d, Darbas = %d, Hp = %f,X = %f,Y = %f,Z = %f WHERE ID = %d",
pInfo[playerid][Pinigai],pInfo[playerid][Xp],pInfo[playerid][Darbas],pInfo[playerid][Hp],pInfo[playerid][X],pInfo[playerid][Y],pInfo[playerid][Z],pInfo[playerid][ID]);
mysql_query(query);
return 1;
}

What's wrong?

Redaguota Sausio 17, 2014, nario SaSkript

bebras · Sausio 17, 2014

Jeigu log'e nėra reiškia OnPlayerDisconnect nebuvo iškviestas. Taip gali būti tik tada kai išjungi serverį paspaudęs X kampe.

Prisijunk, atsijunk. Ir tada parodyk mysql log.

SaSkript · Sausio 17, 2014

Jeigu log'e nėra reiškia OnPlayerDisconnect nebuvo iškviestas. Taip gali būti tik tada kai išjungi serverį paspaudęs X kampe.

Prisijunk, atsijunk. Ir tada parodyk mysql log.

Oh, supratau, man neišsaugo, nes užcrashina serveris, nes kai išjungiu sa-mp, tuo metu užcrashina :/ Ką daryt? :X

bebras · Sausio 17, 2014

Žinok net nežinau, jei nori gali man į PM atsiųsti GM, patestuosiu. Galiu pasakyti kad problema mane sudomino.

SaSkript · Sausio 17, 2014

Žinok net nežinau, jei nori gali man į PM atsiųsti GM, patestuosiu. Galiu pasakyti kad problema mane sudomino.

Malonu žinoti, gerai, lauk žinutės

Prisijungti

Neveikia krovimas/saugojimas MYSQL

Recommended Posts

SaSkript

bebras

SaSkript

SaSkript

bebras

SaSkript

bebras

SaSkript

SaSkript

bebras

SaSkript

bebras

SaSkript

bebras

SaSkript

Prisijungti prie diskusijos

Šiame puslapyje naršo: 0 nariai

Skelbimai

Naujausios temos

Naujausi būsenos atnaujinimai

Nustatymai

Teksto formatavimas

Nario nuotrauka

Member

Nustatymai

Populiariausi nariai

📝 Referatai, konspektai, kursiniai ir kt. rašto darbai ✏️

📝 Referatai, konspektai, kursiniai ir kt. rašto darbai ✏️

📝 Referatai, konspektai, kursiniai ir kt. rašto darbai ✏️

Naujienos

Bendruomenė

Prisijungti

Neveikia krovimas/saugojimas MYSQL

Recommended Posts

Prisijungti prie diskusijos

Šiame puslapyje naršo: 0 nariai

Skelbimai

Naujausios temos

Naujausi būsenos atnaujinimai Nustatymai Teksto formatavimas Nario nuotrauka Member Išsaugoti

Nustatymai

Populiariausi nariai

Naujausi būsenos atnaujinimai

Nustatymai

Teksto formatavimas

Nario nuotrauka

Member