Wysłany: 2017-03-24, 19:00
Adis.exe
LUA Developer
Wiek: 23 Na forum: 3498 dni Posty: 292
Nick w MP: Adiś.exe
Piwa : 997
Witam, otoz mam problem... Nie chce mi si? za??czy? serwer przez to
Pawn
forward LoadHouses ();
public LoadHouses ()
{
new queryhouse [ 400 ], idxh = 1 ;
new stringhouse [ 200 ];
mysql_query ( "SELECT * FROM house WHERE house_uid != '-1'" );
mysql_store_result ();
while( mysql_fetch_row ( queryhouse , "|" ))
{
sscanf ( queryhouse , "p<|>dds[24]s[24]s[100]dfffddfffdd" , //Dobrze tutaj jest
PrivHouse [ idxh ][ dUID ], //UID Domu
PrivHouse [ idxh ][ dPickup ], //id pickupu
PrivHouse [ idxh ][ dOwner ], //Wlasciciel domu
PrivHouse [ idxh ][ dRoomer ], //Lokator Domu
PrivHouse [ idxh ][ dNameHouse ], //Nazwa domu
PrivHouse [ idxh ][ dHouseOpen ], //1 - ZAMKNIETY 0 - OTWARTY
PrivHouse [ idxh ][ dOutX ], //Pozycja wejscia
PrivHouse [ idxh ][ dOutY ], //Pozycja wejscia
PrivHouse [ idxh ][ dOutZ ], //Pozycja wejscia
PrivHouse [ idxh ][ dOutInt ], //Interior wejscia
PrivHouse [ idxh ][ dOutVW ], //VW wejscia
PrivHouse [ idxh ][ dInX ], //poz wyjscia
PrivHouse [ idxh ][ dInY ], //poz wyjscia
PrivHouse [ idxh ][ dInZ ], //poz wyjscia
PrivHouse [ idxh ][ dInInt ], //poz interior
PrivHouse [ idxh ][ dInVW ]); //poz virtualword
PrivHouse [ idxh ][ PickupID ] = CreatePickup ( PrivHouse [ idxh ][ dPickup ], 0 , PrivHouse [ idxh ][ dOutX ], PrivHouse [ idxh ][ dOutY ], PrivHouse [ idxh ][ dOutZ ], PrivHouse [ idxh ][ dOutVW ]);
format ( stringhouse , sizeof ( stringhouse ), "[Prywatny Dom]\n %s \nWlasciciel: %s\nLokator: %s\n|UID: %d|" , PrivHouse [ idxh ][ dNameHouse ], PrivHouse [ idxh ][ dOwner ], PrivHouse [ idxh ][ dRoomer ], PrivHouse [ idxh ][ dUID ]);
Create3DTextLabel ( stringhouse , COLOR_PINK , PrivHouse [ idxh ][ dOutX ], PrivHouse [ idxh ][ dOutY ], PrivHouse [ idxh ][ dOutZ ], 5.0 , PrivHouse [ idxh ][ dOutVW ], 0 );
idxh ++;
}
mysql_free_result ();
return 1 ;
}
a dok?adnie, nie dzia?a mi "mysql_query"... Wiem, dlatego ?e zakomentowa?em wszystko po kolei i odkomentowywa?em, i co linijka, sprawdza?em, i serwer zacz?? si? wy??cza? gdy by?o odkomentowane "mysql_query". Formatowa?em to do stringa, i dawa?em mysql_query(string); ale to nie pomaga?o, wszystkiego probowa?em ! Jak ten publick nie jest w u?yciu, w sensie ze np nie ma nigdzie LoadHouse(); Serwer noramlnie odpala, dopiero jak go u?ywam, serwer nie chce odpali?
CrashDetected:
Kod:
[16] [debug] f692b000 - f6941253 /lib/i386-linux-gnu/i686/cmov/libresolv.so.2
[16] [debug] f6942000 - f69469bf /lib/i386-linux-gnu/i686/cmov/libnss_dns.so.2
[16] [debug] f774b000 - f775209f /lib/i386-linux-gnu/i686/cmov/librt.so.1
[16] [debug] f675a000 - f680014c plugins/streamer.so
[16] [debug] f6949000 - f69581d4 plugins/sscanf.so
[16] [debug] f715a000 - f71653ef /lib/i386-linux-gnu/i686/cmov/libnss_files.so.2
[16] [debug] f7167000 - f7182d4c /lib/i386-linux-gnu/libz.so.1
[16] [debug] f7184000 - f719c1a7 /lib/i386-linux-gnu/i686/cmov/libnsl.so.1
[16] [debug] f719d000 - f71cc64f /lib/i386-linux-gnu/i686/cmov/libcrypt.so.1
[16] [debug] f71ce000 - f73c862c /usr/lib/i386-linux-gnu/libmysqlclient_r.so.16
[16] [debug] f73d2000 - f73dee1f plugins/mysql.so
[16] [debug] f73e0000 - f7422ac4 plugins/crashdetect.so
[16] [debug] f7759000 - f77795bc /lib/ld-linux.so.2
[16] [debug] f7427000 - f75dc3a3 /lib/i386-linux-gnu/i686/cmov/libc.so.6
[16] [debug] f75d4000 - f75f03c4 /lib/i386-linux-gnu/libgcc_s.so.1
[16] [debug] f75f1000 - f7635b43 /lib/i386-linux-gnu/i686/cmov/libm.so.6
[16] [debug] f7637000 - f7730cda /usr/lib/i386-linux-gnu/libstdc++.so.6
[16] [debug] f772a000 - f7744d97 /lib/i386-linux-gnu/i686/cmov/libpthread.so.0
[16] [debug] f7746000 - f774881b /lib/i386-linux-gnu/i686/cmov/libdl.so.2
[16] [debug] f775a000 - f775a50c linux-gate.so.1
[16] [debug] 00000000 - 00187dc3 samp03svr
[16] [debug] Loaded modules:
[16] [debug] ESP+000003e0: 08278cc8 082adc48 0000000d f73fc384
[16] [debug] ESP+000003c0: ffa20910 f4f63c9f 00000018 0000000a
[16] [debug] ESP+000003a0: 00000000 00000000 00000000 081cdc98
[16] [debug] ESP+00000380: 0055d67c 00008b14 0000000d 0809fbc4
[16] [debug] ESP+00000360: 0000000d f767fe56 f7721000 f76e6ec8
[16] [debug] ESP+00000340: 08159aec 00000001 ffa209f8 0000000c
[16] [debug] ESP+00000320: 08278cc8 ffa209fc 0000000d 0055d67c
[16] [debug] ESP+00000300: ffa20878 00000001 08278cc8 f7422ff4
[16] [debug] ESP+000002e0: 0003c258 08278cc8 00000000 f4f9cfd0
[16] [debug] ESP+000002c0: f4fa148c 0055cfe0 005596bc 0055cfe4
[16] [debug] ESP+000002a0: 08278cc8 0000004b ffa207fc f54fe46c
[16] [debug] ESP+00000280: ffa20874 00000000 00000001 08278cc8
[16] [debug] ESP+00000260: 082adc48 0000004b ffa207fc f54fe46c
[16] [debug] ESP+00000240: 00000000 08159af2 ffa20bb8 f7422ff4
[16] [debug] ESP+00000220: 00037dd4 00000008 f746edee 00000000
[16] [debug] ESP+00000200: 08278cc8 00000000 0055d638 00037e18
[16] [debug] ESP+000001e0: 00000000 00000000 00000000 00000000
[16] [debug] ESP+000001c0: 00000000 00000000 00000000 00000000
[16] [debug] ESP+000001a0: 082e5262 082e5262 00000010 00000000
[16] [debug] ESP+00000180: f757c400 00000000 00000000 082adbf2
[16] [debug] ESP+00000160: 081cd008 08159af1 081cd008 f746a5f4
[16] [debug] ESP+00000140: f7755032 08159af1 00000001 00000000
[16] [debug] ESP+00000120: 00037e18 0000004b 00000000 00000000
[16] [debug] ESP+00000100: 08278cc8 082adc48 ffa209fc f73f7ad3
[16] [debug] ESP+000000e0: 08278cc8 f54fe46c f6948000 f73ef14a
[16] [debug] ESP+000000c0: 000000c8 3d3d3d3d 00000013 f73ef1e4
[16] [debug] ESP+000000a0: 08278cc8 08278cc8 ffa205d8 080dce72
[16] [debug] ESP+00000080: 61206f74 6420796e 62617461 00657361
[16] [debug] ESP+00000060: 72657571 61632079 64656c6c 65687720
[16] [debug] ESP+00000040: 00000000 ffa20550 00000004 f749cbb1
[16] [debug] ESP+00000020: ffa20550 f73dd4d4 ffa20548 ffa20550
[16] [debug] ESP+00000000: 00000000 f75cfb00 00000000 f748c6f8
[16] [debug] Stack:
[16] [debug] EIP: f73d7a2c EFLAGS: 00010286
[16] [debug] ESI: 00000000 EDI: 08278cc8 EBP: ffa20538 ESP: ffa20500
[16] [debug] EAX: 00000000 EBX: ffa20550 ECX: 00000000 EDX: 00000000
[16] [debug] Registers:
[16] [debug] #10 0000000d in () from ?q?Hõq?¡,¡,£,¡,??,¥,?r?
[16] [debug] #9 f73f7ad3 in _ZN11CrashDetect17HandleAMXCallbackEiPiS0_ () from plugins/crashdetect.so
[16] [debug] #8 080950e4 in () from ./samp03svr
[16] [debug] #7 f73db9eb in _ZN7Natives13n_mysql_queryEP6tagAMXPi () from plugins/mysql.so
[16] [debug] #6 f73d7a2c in _Z5ErrorP5MySQLPKci () from plugins/mysql.so
[16] [debug] #5 f7758410 in __kernel_rt_sigreturn () from linux-gate.so.1
[16] [debug] #4 f73fd4d5 in () from plugins/crashdetect.so
[16] [debug] #3 f73f8cdb in _ZN11CrashDetect7OnCrashERKN2os7ContextE () from plugins/crashdetect.so
[16] [debug] #2 f73f6d64 in _ZN11CrashDetect20PrintNativeBacktraceERKN2os7ContextE () from plugins/crashdetect.so
[16] [debug] #1 f73f6064 in _ZN11CrashDetect20PrintNativeBacktraceERSoRKN2os7ContextE () from plugins/crashdetect.so
[16] [debug] #0 f73fe180 in _Z13GetStackTraceRSt6vectorI10StackFrameSaIS0_EEPv () from plugins/crashdetect.so
[16] [debug] Native backtrace:
[16] [debug] #9 000002e4 in public OnGameModeInit () at C:\Program Files\pawno\include\zcmd.inc:68
[16] [debug] #8 native CallLocalFunction () from samp03svr
[16] [debug] #7 00000cb0 in public zcmd_OnGameModeInit () at C:\Program Files\pawno\include\sscanf2.inc:205
[16] [debug] #6 00007734 in public SSCANF_OnGameModeInit () at C:\Program Files\pawno\include\YSI\internal\..\y_scriptinit.inc:171
[16] [debug] #5 00008b14 in public ScriptInit_OnGameModeInit () at C:\Program Files\pawno\include\YSI\y_iterate.inc:791
[16] [debug] #4 native CallLocalFunction () from samp03svr
[16] [debug] #3 0000d524 in public Itter_OnGameModeInit () at C:\Program Files\pawno\include\YSI\y_hooks/impl.inc:484
[16] [debug] #2 00013ac4 in () at D:\SAMP\SERWER TEST\TRUCK !\Gamemod.pwn:341
[16] [debug] #1 00037e18 in LoadHouses () at D:\SAMP\SERWER TEST\TRUCK !\Gamemod.pwn:3889
[16] [debug] #0 native mysql_query () from mysql.so
[16] [debug] AMX backtrace:
[16] [debug] Server crashed while executing Gamemod.amx
[ Dodano : 2017-03-25, 11:17 ]
@ref
Prosze o pomoc !
Podpis
KONTAKT:
GG: 60968224
Discord: Adiś.exe#3828
Użytkownik : 05.11.2016
GTAO Member : 20.02.2019
Support-Team : 25.07.2018
Support-Team : 19.01.2019
Test Mod : 08.02.2019
Ostatnio zmieniony przez Adis.exe 2017-03-25, 17:19, w całości zmieniany 2 razy
Wysłany: 2017-03-25, 15:34
Combacior
Wiek: 29 Na forum: 5796 dni Posty: 1516
Piwa : 2161
Zatem co? nie gra z zapytaniem SELECT, spr?buj je zmieni?, np. bez tego warunku. Ewentualnie poka? struktur? i zawarto?? tabeli, to spr?buj? u siebie.
Więcej szczegółów
Wystawiono 1 piw(a):Adis.exe
Wysłany: 2017-03-25, 17:18
Adis.exe
LUA Developer
Wiek: 23 Na forum: 3498 dni Posty: 292
Nick w MP: Adiś.exe
Piwa : 997
Struktura:
Zawarto??:
probowa?em bez warunku, z warunkiem, formatowa?em, dawa?em w stocku...
I teraz sprawdza?em, i jak usun? linijk? "mysql_query(...);" to i tak serwer nie dzia?a i wyskakuj? crash'e
I tu masz jeszcze enuma:
Pawn
enum PRIV_HOUSE
{
dUID ,
dPickup ,
dOwner [ 24 ],
dRoomer [ 24 ],
dNameHouse [ 100 ],
dHouseOpen , //1 - ZAMKNIETY 0 - OTWARTY
Float : dOutX ,
Float : dOutY ,
Float : dOutZ ,
dOutInt ,
dOutVW ,
Float : dInX ,
Float : dInY ,
Float : dInZ ,
dInInt ,
dInVW ,
PickupID
}
new PrivHouse [ MAX_PRIVATE_HOUSE ][ PRIV_HOUSE ];
I jeszcze dopowiem, ?e pluginy i includy mam najnowsze
Podpis
KONTAKT:
GG: 60968224
Discord: Adiś.exe#3828
Użytkownik : 05.11.2016
GTAO Member : 20.02.2019
Support-Team : 25.07.2018
Support-Team : 19.01.2019
Test Mod : 08.02.2019
Wysłany: 2017-03-25, 17:28
Combacior
Wiek: 29 Na forum: 5796 dni Posty: 1516
Piwa : 2161
Spr?buj to zapytanie da? w nowy, pusty skrypt. Skoro piszesz, ?e nawet jak usuniesz to zapytanie i serwer dalej nie dzia?a, to gdzie? indziej le?y problem.
Więcej szczegółów
Wystawiono 1 piw(a):Adis.exe
Wysłany: 2017-03-25, 17:58
Adis.exe
LUA Developer
Wiek: 23 Na forum: 3498 dni Posty: 292
Nick w MP: Adiś.exe
Piwa : 997
jak usune zapytanie... Jak usune ca?? funkcje LoadHouse() to dzia?a
[ Dodano : 2017-03-25, 19:07 ]
wklei?em do pustego skryptu i dalej to samo
Podpis
KONTAKT:
GG: 60968224
Discord: Adiś.exe#3828
Użytkownik : 05.11.2016
GTAO Member : 20.02.2019
Support-Team : 25.07.2018
Support-Team : 19.01.2019
Test Mod : 08.02.2019
Wysłany: 2017-03-25, 19:20
Combacior
Wiek: 29 Na forum: 5796 dni Posty: 1516
Piwa : 2161
Daj kod z eksportu tabeli (struktura + dane, nie chc? mi si? spisywa? z obrazka), sprawdz? u siebie.
Więcej szczegółów
Wystawiono 1 piw(a):Adis.exe
Wysłany: 2017-03-25, 19:29
Adis.exe
LUA Developer
Wiek: 23 Na forum: 3498 dni Posty: 292
Nick w MP: Adiś.exe
Piwa : 997
CREATE TABLE `house` (
`house_uid` int(5) NOT NULL,
`house_pickup` int(8) NOT NULL,
`house_owner` varchar(24) NOT NULL,
`house_roomer` varchar(24) NOT NULL,
`house_name` varchar(100) NOT NULL,
`house_open` int(3) NOT NULL DEFAULT '0',
`house_outX` float NOT NULL,
`house_outY` float NOT NULL,
`house_outZ` float NOT NULL,
`house_outint` int(8) NOT NULL,
`house_outVW` int(8) NOT NULL,
`house_inX` float NOT NULL,
`house_inY` float NOT NULL,
`house_inZ` float NOT NULL,
`house_inint` int(8) NOT NULL,
`house_inVW` int(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `house` (`house_uid`, `house_pickup`, `house_owner`, `house_roomer`, `house_name`, `house_open`, `house_outX`, `house_outY`, `house_outZ`, `house_outint`, `house_outVW`, `house_inX`, `house_inY`, `house_inZ`, `house_inint`, `house_inVW`) VALUES
(1, 1272, 'Adikoo1302', 'BRAK', 'Moja villa', 0, 1364.51, 1896.69, 11.4688, 0, 0, 2350.34, -1181.65, 1027.98, 5, 0);
ALTER TABLE `house`
ADD PRIMARY KEY (`house_uid`);
[ Dodano : 2017-03-25, 19:30 ]
albo w .sql
http://www.mediafire.com/...yje74/house.sql
Podpis
KONTAKT:
GG: 60968224
Discord: Adiś.exe#3828
Użytkownik : 05.11.2016
GTAO Member : 20.02.2019
Support-Team : 25.07.2018
Support-Team : 19.01.2019
Test Mod : 08.02.2019
Wysłany: 2017-03-25, 19:58
Combacior
Wiek: 29 Na forum: 5796 dni Posty: 1516
Piwa : 2161
Jeste? w og?le po??czony z baz? danych? U?y?e? funkcji mysql_init? Sprawdzi?em kod, bez po??czenia z baz? danych crash nast?pi raczej przy ka?dej pr?bie wykonania zapytania. P??niej po??czy?em si? z baz? danych i crasha nie ma
Kod: mysql_init(LOG_ONLY_ERRORS, 0);
mysql_connect("127.0.0.1", "root", "pass", "a_shoot");
mysql_query("SELECT * FROM house WHERE house_uid != '-1'");
while(...)
Więcej szczegółów
Wystawiono 1 piw(a):Adis.exe
Wysłany: 2017-03-25, 20:03
Adis.exe
LUA Developer
Wiek: 23 Na forum: 3498 dni Posty: 292
Nick w MP: Adiś.exe
Piwa : 997
jestem po??czony
[ Dodano : 2017-03-25, 20:27 ]
JESTEM G?UPI !
[ Dodano : 2017-03-25, 20:28 ]
Mia?em t? funkcj? przed po??czeniem si? z bazy danych xDD
Podpis
KONTAKT:
GG: 60968224
Discord: Adiś.exe#3828
Użytkownik : 05.11.2016
GTAO Member : 20.02.2019
Support-Team : 25.07.2018
Support-Team : 19.01.2019
Test Mod : 08.02.2019
Tagi: zapytanie :: mysql
Anonymous
Na forum: 245 dni
Posty: 1
Anonymous Koniecznie zajrzyj na: