cristian9900

http://www.r-zone.ro/panel/

Descriere produs: RPG1.B-ZONE.RO Contul deține 4.000.000 $ Vehicule. Infernus , Bullet ,Sultan,NRG,Maverick,Gold:2.100 . FH decent rank 3 lvsi-demisie, rank2 Sfpd- demisie, sancțiuni : doar un suspend la nivel 7 .Contul are si level 33 500 k - 25 lei, 1kk -50 lePreţ:900 de lei !Alte detalii:http://imgur.com/a/h9dvX

Problema intalnita (descriere): Salut , am si eu o problema cu serverul , merge cam 30 deminute maxim , dupa care pica dintr-o data , nu se da restart , nimic , doar ca nu mai poti folosii niciocamanda, nu mai poti scrie nimic , ieri am avut eroarea ackslimit 300/s , dar acum nici eroarea aia nu mai apare in server log , nu apare absolut nicio eraore , in localhost , serverul merge absolut perfect , tin sa mentionez ca nu este de la host , pentru ca dupa ce dau rr din gamecp , serverul merge perfect timp de 30 de minute , si tot asa , ma poate ajuta cineva ?Ero(area / rile) / warning-(ul / urile):-Liniile de cod / sursa / script-ul(obligatoriu):-Imagini / Video (optional):-Ati incercat sa rezolvati singur?: Ieri cand imi dadea eraore akslimit in server log , am incercat tot ce am gasit pe net , pe forumurile de samp , dar acum nu imi mai da nicio eroare , nici nu ma scoate dupa server doar ca nu mai merge nimic ...

[18:50:30] [warning] client exceeded 'ackslimit' 94.176.155.51:26256 (6834) Limit: 3000/sec [18:51:47] [connection] 94.176.155.51:26364 requests connection cookie. [18:51:55] [warning] client exceeded 'ackslimit' 94.176.155.51:26364 (4360) Limit: 3000/sec

Mda , nu inteleg , cum adica sa il optimizez, si de ce logiuri sa scap ?

Mysql : http://imgur.com/a/f3pwB svlog: ---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3.7-R2, (C)2005-2015 SA-MP Team [17:05:38] [17:05:38] Server Plugins [17:05:38] -------------- [17:05:38] Loading plugin: crashdetect.so [17:05:38] CrashDetect v4.15.1 is OK. [17:05:38] Loaded. [17:05:38] Loading plugin: mysql.so [17:05:38] >> plugin.mysql: R34 successfully loaded. [17:05:38] Loaded. [17:05:38] Loading plugin: streamer.so [17:05:38] *** Streamer Plugin v2.7.7 by Incognito loaded *** [17:05:38] Loaded. [17:05:38] Loading plugin: sscanf.so [17:05:38] [17:05:38] =============================== [17:05:38] sscanf plugin loaded. [17:05:38] Version: 2.8.1 [17:05:38] (c) 2012 Alex "Y_Less" Cole [17:05:38] =============================== [17:05:38] Loaded. [17:05:38] Loading plugin: Whirlpool.so [17:05:38] [17:05:38] ================== [17:05:38] [17:05:38] Whirlpool loaded [17:05:38] [17:05:38] ================== [17:05:38] [17:05:38] Loaded. [17:05:38] Loading plugin: fixes2.so [17:05:38] [17:05:38] =============================== [17:05:38] fixes plugin loaded. [17:05:38] (c) 2012 Alex "Y_Less" Cole [17:05:38] =============================== [17:05:38] Loaded. [17:05:38] Loaded 6 plugins. [17:05:38] [17:05:38] Filterscripts [17:05:38] --------------- [17:05:38] Loaded 0 filterscripts. [17:05:39] [17:05:39] [17:05:39] [17:05:39] ======================================= [17:05:39] | | [17:05:39] | YSI version 3.09.0684 | [17:05:39] | By Alex "Y_Less" Cole | [17:05:39] | | [17:05:39] ======================================= [17:05:39] [17:05:39] [17:05:39] [17:05:39] [ -- ] [ Gamemode is Starting ] [ -- ] [17:05:39] [MySQL] Using connection no. 2 [17:05:39] [MYSQL]: Connection succesful! [17:05:39] [Clans Script]: 0 clans loaded. [17:05:39] [MySQL INFO]: 12 businesses loaded. [17:05:39] [MySQL INFO]: 2 entries loaded. [17:05:39] [MySQL INFO]: 4 pickups loaded. [17:05:39] [MySQL INFO]: 4 labels loaded. [17:05:39] [MySQL INFO]: 8 factions loaded. [17:05:39] [MySQL INFO]: 99 server vehicles loaded. [17:05:39] [MySQL - JOBS]: 8 loaded... [17:05:39] [ -- ] [ Gamemode STARTED ] [ -- ] [17:05:39] fixes.plugin: Could not find function TakeAd. [17:05:39] Number of vehicle models: 32 [17:05:39] [MYSQL] Houses: 19 [17:05:39] [MYSQL] Turfs: 23 [17:05:39] [MYSQL] Dealership Vehicles: 131 [17:05:39] [MYSQL] Users: 4 | Record: 2 (05.08.2016 16:47) [17:06:44] [connection] 176.126.185.149:56059 requests connection cookie. [17:06:45] [connection] incoming connection: 176.126.185.149:56059 id: 0 [17:07:16] [connection] 176.126.185.149:56060 requests connection cookie. [17:07:17] [connection] incoming connection: 176.126.185.149:56060 id: 0 [17:07:17] [join] Mihai has joined the server (0:176.126.185.149) [17:07:47] Mihai has logged in from IP: 176.126.185.149 [17:07:47] [death] Mihai died 255 [17:08:22] Player Mihai /setpin [17:08:32] Player Mihai /order [17:08:33] Player Mihai /ah [17:08:35] Player Mihai /jail [17:08:42] Player Mihai /lf [17:08:44] Player Mihai /fpk [17:08:46] Player Mihai /help [17:09:04] Player Mihai /contract [17:09:04] Player Mihai /contracts [17:09:07] Player Mihai /mycontract [17:09:15] Player Mihai /order [17:09:15] Player Mihai /order [17:09:16] Player Mihai /order [17:09:17] Player Mihai /order [17:09:18] Player Mihai /order [17:09:21] Player Mihai /turn [17:09:22] Player Mihai /turn [17:09:24] Player Mihai /help [17:09:29] Player Mihai /language [17:09:51] Player Mihai /friends [17:09:58] Player Mihai /tog [17:10:00] Player Mihai /tog [17:10:14] Player Mihai /engine [17:10:19] Player Mihai /undercover [17:10:48] ABC: AdmCmd: Admin-ul Mihai a folosit comanda /up. [17:10:48] Player Mihai /up [17:10:49] ABC: AdmCmd: Admin-ul Mihai a folosit comanda /up. [17:10:49] Player Mihai /up [17:10:51] Player Mihai /gotocar [17:10:53] [death] Mihai died 54 [17:10:53] Player Mihai /fkly [17:10:56] ABC: AdmCmd: Admin-ul Mihai a respawnat toate masinile de pe server. [17:10:56] Player Mihai /rac [17:11:01] Player Mihai /underccover [17:11:03] Player Mihai /undercover [17:11:07] Player Mihai /spawnchange [17:11:10] ABC: AdmCmd: Admin-ul Mihai l-a respawnat pe Mihai. [17:11:10] Player Mihai /respawn [17:11:16] ABC: AdmCmd: Admin-ul Mihai l-a respawnat pe Mihai. [17:11:16] Player Mihai /respawn [17:11:33] Player Mihai /sellhousetostate [17:11:40] Player Mihai /asellhouse [17:11:42] Player Mihai /asellhouse [17:11:48] Player Mihai /buyhouse [17:11:50] Player Mihai /asellhouse [17:11:53] Player Mihai /asellhouse [17:12:18] Player Mihai /sellhousetostate [17:12:26] Player Mihai /buyhouse [17:12:32] ABC: AdmCmd: Admin-ul Mihai l-a respawnat pe Mihai. [17:12:32] Player Mihai /respawn [17:12:41] [connection] 94.176.155.51:26425 requests connection cookie. [17:12:42] [connection] incoming connection: 94.176.155.51:26425 id: 1 [17:12:42] [join] NinGe has joined the server (1:94.176.155.51) [17:12:48] [debug] Run time error 4: "Array index out of bounds" [17:12:48] [debug] Accessing element at index 65535 past array upper bound 1999 [17:12:48] [debug] AMX backtrace: [17:12:48] [debug] #0 000233ac in ?? (65535) from edproj.amx [17:12:48] [debug] #1 000232d4 in ?? (0, 0, 0, 0, 0, 0, 0, -1) from edproj.amx [17:12:48] [debug] #2 00032528 in ?? (3) from edproj.amx [17:12:48] [debug] #3 001429b4 in ?? (1) from edproj.amx [17:12:48] [debug] #4 0008f92c in public PrePlayerLogin (1) from edproj.amx [17:12:51] NinGe has logged in from IP: 94.176.155.51 [17:12:56] Player Mihai /givealllevel [17:12:57] Player Mihai /gam [17:12:59] Player Mihai /gal [17:13:00] Player Mihai /ah [17:13:15] Player NinGe /spawnchange [17:13:23] ABC: AdmCmd: Admin-ul NinGe l-a respawnat pe NinGe. [17:13:23] Player NinGe /respawn [17:13:26] Player Mihai /spawnchange [17:13:34] ABC: AdmCmd: Admin-ul Mihai l-a respawnat pe Mihai. [17:13:34] Player Mihai /respawn [17:13:38] Player Mihai /order [17:13:39] ABC: AdmCmd: Admin-ul NinGe l-a respawnat pe NinGe. [17:13:39] Player NinGe /respawn [17:13:39] Player Mihai /order [17:13:44] Player Mihai /contract [17:13:45] Player Mihai /contract [17:13:47] Player Mihai /contract [17:13:48] [chat] [Mihai]: aw [17:13:55] Player NinGe /setrent [17:13:58] Player NinGe /setrent [17:14:03] Player Mihai /spawnchange [17:14:22] ABC: AdmCmd: Admin-ul Mihai l-a respawnat pe Mihai. [17:14:22] Player Mihai /respawn [17:14:29] ABC: AdmCmd: Admin-ul NinGe l-a respawnat pe NinGe. [17:14:29] Player NinGe /respawn [17:14:37] Player Mihai /radio [17:14:39] Player NinGe /unrentroom [17:14:45] Player Mihai /auninvite [17:14:47] Player Mihai /auninvite [17:14:48] Player NinGe /setrent [17:14:51] ABC: AdmCmd: Admin-ul NinGe l-a respawnat pe NinGe. [17:14:51] Player NinGe /respawn [17:14:51] [debug] Run time error 4: "Array index out of bounds" [17:14:51] [debug] Accessing element at negative index -1 [17:14:51] [debug] AMX backtrace: [17:14:51] [debug] #0 00097c38 in public L_AFK_OPS (1) from edproj.amx [17:14:51] [debug] #1 native CallLocalFunction () from samp03svr [17:14:51] [debug] #2 0001d254 in ?? (1) from edproj.amx [17:14:51] [debug] #3 00005b1c in public OnPlayerSpawn (1) from edproj.amx [17:14:53] ABC: AdmCmd: Admin-ul NinGe l-a respawnat pe NinGe. [17:14:53] Player NinGe /respawn [17:14:54] [debug] Run time error 4: "Array index out of bounds" [17:14:54] [debug] Accessing element at negative index -1 [17:14:54] [debug] AMX backtrace: [17:14:54] [debug] #0 00097c38 in public L_AFK_OPS (1) from edproj.amx [17:14:54] [debug] #1 native CallLocalFunction () from samp03svr [17:14:54] [debug] #2 0001d254 in ?? (1) from edproj.amx [17:14:54] [debug] #3 00005b1c in public OnPlayerSpawn (1) from edproj.amx [17:14:57] Player Mihai /ticket [17:14:58] Player Mihai /engine [17:14:59] [death] NinGe died 54 [17:15:02] Player Mihai /spawnchange [17:15:05] ABC: AdmCmd: Admin-ul Mihai l-a respawnat pe Mihai. [17:15:05] Player Mihai /respawn [17:15:07] [debug] Run time error 4: "Array index out of bounds" [17:15:07] [debug] Accessing element at negative index -1 [17:15:07] [debug] AMX backtrace: [17:15:07] [debug] #0 00097c38 in public L_AFK_OPS (1) from edproj.amx [17:15:07] [debug] #1 native CallLocalFunction () from samp03svr [17:15:07] [debug] #2 0001d254 in ?? (1) from edproj.amx [17:15:07] [debug] #3 00005b1c in public OnPlayerSpawn (1) from edproj.amx [17:15:14] ABC: AdmCmd: Admin-ul Mihai l-a respawnat pe Mihai. [17:15:14] Player Mihai /respawn [17:15:26] Player Mihai /setleader [17:15:28] Player Mihai /setleader [17:15:30] Player NinGe /setrentr [17:15:30] ABC: AdmCmd: Admin-ul Mihai l-a respawnat pe Mihai. [17:15:30] Player Mihai /respawn [17:15:31] Player Mihai /ticket [17:15:32] Player NinGe /setrent [17:15:34] Player NinGe /setrent [17:15:36] Player Mihai /ah [17:15:39] Player Mihai /help [17:15:42] Player NinGe /setrent [17:15:44] Player NinGe /stats [17:15:51] ABC: AdmCmd: Admin-ul Mihai s-a teleportat la NinGe. [17:15:51] Player Mihai /goto [17:15:52] Player Mihai /so [17:16:06] Player Mihai /so [17:16:07] Player Mihai /so [17:16:23] ABC: AdmCmd: Admin-ul Mihai a sters chat-ul. [17:16:23] Player Mihai /cc [17:16:32] Player Mihai /lay [17:16:35] Player Mihai /lay [17:16:41] Player Mihai /stopanim [17:16:43] Player Mihai /startevent [17:16:48] Player Mihai /requestevent [17:17:05] Player NinGe /setrentr [17:17:06] Player NinGe /setrent [17:17:07] Player NinGe /setrent [17:17:15] Player NinGe /rentroom [17:17:16] Player NinGe /rentroom [17:17:17] Player NinGe /rentroom [17:17:23] Player NinGe /help [17:17:25] ABC: Mihai doreste sa faca un eveniment. Foloseste '/accept event 0' pentru a-i accepta cererea. [17:17:25] ABC: Eveniment 0: Titlu: LMS, Premiu: $100,000, Locatie: GSLS, Timp: Acum [17:17:25] ABC: Eveniment 0: Descriere: Detalii pe /e [17:17:25] Player Mihai /requestevent [17:17:25] ==================================================================== [17:17:25] Error ID: 1064, 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 'event 0' pentru a-i accepta cererea.','05.08.2016 17:17:25')' at line 1 [17:17:25] Callback: [17:17:25] gQuery: INSERT INTO log_abc (`log`,`time`) VALUES ('Mihai doreste sa faca un eveniment. Foloseste '/accept event 0' pentru a-i accepta cererea.','05.08.2016 17:17:25') [17:17:25] ==================================================================== [17:17:31] Player NinGe /tenants [17:17:38] [debug] Run time error 4: "Array index out of bounds" [17:17:38] [debug] Accessing element at negative index -400 [17:17:38] [debug] AMX backtrace: [17:17:38] [debug] #0 000c8508 in ?? (1) from edproj.amx [17:17:38] [debug] #1 000cc1e0 in public @_yCvehicles (1, 93698800, 0) from edproj.amx [17:17:38] [debug] #2 000cc170 in public @yC_vehicles (1, 93698800, 0, 0) from edproj.amx [17:17:38] [debug] #3 native CallRemoteFunction () from samp03svr [17:17:38] [debug] #4 000131dc in ?? (1, 93698788, 0) from edproj.amx [17:17:38] [debug] #5 00012a20 in ?? (1, 93698788) from edproj.amx [17:17:38] [debug] #6 000061fc in public OnPlayerCommandText (1, 93698788) from edproj.amx [17:17:38] Player NinGe /v [17:17:46] Player Mihai /accept [17:17:48] Player NinGe /stats [17:17:49] Player Mihai /loginpin [17:17:53] ABC: AdmCmd: Mihai(0) a acceptat event-ul lui Mihai. [17:17:53] Player Mihai /accept [17:17:57] Player Mihai /e [17:18:01] Player Mihai /stopevent [17:19:06] [part] NinGe has left the server (1:1) [17:19:16] ABC: {FFC266}6 Mihai: /requestevent LMS|GSLS|Acum|Detalii pe /e|100000 [17:19:16] Player Mihai /a [17:19:19] ABC: Mihai doreste sa faca un eveniment. Foloseste '/accept event 0' pentru a-i accepta cererea. [17:19:19] ABC: Eveniment 0: Titlu: LMS, Premiu: $100,000, Locatie: GSLS, Timp: Acum [17:19:19] ABC: Eveniment 0: Descriere: Detalii pe /e [17:19:19] Player Mihai /requestevent [17:19:19] ==================================================================== [17:19:19] Error ID: 1064, 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 'event 0' pentru a-i accepta cererea.','05.08.2016 17:19:19')' at line 1 [17:19:19] Callback: [17:19:19] gQuery: INSERT INTO log_abc (`log`,`time`) VALUES ('Mihai doreste sa faca un eveniment. Foloseste '/accept event 0' pentru a-i accepta cererea.','05.08.2016 17:19:19') [17:19:19] ==================================================================== [17:19:24] ABC: AdmCmd: Mihai(0) a acceptat event-ul lui Mihai. [17:19:24] Player Mihai /accept [17:19:27] [connection] 94.176.155.51:26376 requests connection cookie. [17:19:28] [connection] incoming connection: 94.176.155.51:26376 id: 1 [17:19:28] [join] NinGe has joined the server (1:94.176.155.51) [17:19:33] Player Mihai /stopevent [17:19:34] [debug] Run time error 4: "Array index out of bounds" [17:19:34] [debug] Accessing element at index 65535 past array upper bound 1999 [17:19:34] [debug] AMX backtrace: [17:19:34] [debug] #0 000233ac in ?? (65535) from edproj.amx [17:19:34] [debug] #1 000232d4 in ?? (0, 0, 0, 0, 0, 0, 0, -1) from edproj.amx [17:19:34] [debug] #2 00032528 in ?? (3) from edproj.amx [17:19:34] [debug] #3 001429b4 in ?? (1) from edproj.amx [17:19:34] [debug] #4 0008f92c in public PrePlayerLogin (1) from edproj.amx [17:19:37] NinGe has logged in from IP: 94.176.155.51 [17:19:38] ABC: {FFC266}6 Mihai: /accept event 0 [17:19:38] Player Mihai /a [17:19:40] ABC: Mihai doreste sa faca un eveniment. Foloseste '/accept event 0' pentru a-i accepta cererea. [17:19:40] ABC: Eveniment 0: Titlu: LMS, Premiu: $100,000, Locatie: GSLS, Timp: Acum [17:19:40] ABC: Eveniment 0: Descriere: Detalii pe /e [17:19:40] Player Mihai /requestevent [17:19:40] ==================================================================== [17:19:40] Error ID: 1064, 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 'event 0' pentru a-i accepta cererea.','05.08.2016 17:19:40')' at line 1 [17:19:40] Callback: [17:19:40] gQuery: INSERT INTO log_abc (`log`,`time`) VALUES ('Mihai doreste sa faca un eveniment. Foloseste '/accept event 0' pentru a-i accepta cererea.','05.08.2016 17:19:40') [17:19:40] ==================================================================== [17:19:43] ABC: AdmCmd: NinGe(1) a acceptat event-ul lui Mihai. [17:19:43] Player NinGe /accept [17:19:45] [chat] [Mihai]: /e [17:19:46] Player NinGe /e [17:19:49] Player NinGe /e [17:19:54] Player Mihai /e [17:20:05] Player NinGe /stopevent [17:20:15] Player Mihai /stopevent [17:20:25] ABC: AdmCmd: Admin-ul NinGe a sters chat-ul. [17:20:25] Player NinGe /cc [17:20:27] ABC: AdmCmd: Admin-ul Mihai a sters chat-ul. [17:20:27] Player Mihai /cc [17:20:34] Player NinGe /detele [17:20:36] Player NinGe /detelec [17:20:38] Player NinGe /ah [17:20:42] Player NinGe /clearchat [17:20:43] ABC: AdmCmd: Admin-ul Mihai a folosit comanda /fly. [17:20:43] Player Mihai /fly [17:20:44] ABC: AdmCmd: Admin-ul Mihai a sters chat-ul. [17:20:44] Player Mihai /cc [17:20:45] Player NinGe /clear [17:20:46] Player Mihai /stopevent [17:20:48] Player NinGe /clear [17:20:57] ABC: AdmCmd: Admin-ul NinGe a sters chat-ul. [17:20:57] Player NinGe /cc [17:21:01] ABC: AdmCmd: Admin-ul Mihai a folosit comanda /fly. [17:21:01] Player Mihai /fly [17:21:10] Player Mihai /create [17:21:37] Player Mihai /create [17:22:05] Player Mihai /create [17:23:07] Player Mihai /create [17:23:29] Player Mihai /create [17:24:10] Player Mihai /create [17:24:48] ABC: AdmCmd: Admin-ul Mihai a folosit comanda /fly. [17:24:48] Player Mihai /fly [17:24:58] ABC: AdmCmd: Admin-ul Mihai a folosit comanda /fly. [17:24:58] Player Mihai /fly [17:25:05] Player Mihai /create [17:25:28] Player Mihai /create cateodata nu se mai da restart , ramane doar blocat si nu mai merge sa tastezi nicio comanda

Problema intalnita (descriere): Salut , am si eu o problema cu serverul , la vreo 30-40 de minute , dupa ce intri pe server , nu mai merge, mai intai nu te lasa sa mai folosesti nicio comanda, iar dupa iti spune "you are banned from this server" , am host zero ping , dar nu cred ca este de la host , pentru ca daca dau restart merge , si dupa 30-40 de minute iar apare asa Ero(area / rile) / warning-(ul / urile):-Liniile de cod / sursa / script-ul(obligatoriu):-Imagini / Video (optional):-Ati incercat sa rezolvati singur?: da

Hostul samp este de la zero ping , iar hostul pentru baza de date este de la alta firma , asta sa fie de vina ?

Problema intalnita (descriere): creez o baza de date pe host , completez in gamemode totul corect , iar cand incerc sa intru pe server , nu ma lasa sa imi fac , cont , adica nu apare sa ma inregistrez , in consola apare eroor id 2006 mysql gone away....Ero(area / rile) / warning-(ul / urile): [ -- ] [ Gamemode is Starting ] [ -- ][MySQL] Using connection no. 2[MYSQL]: Connection succesful![Clans Script]: 0 clans loaded.[MySQL INFO]: 0 businesses loaded.[MySQL INFO]: 0 entries loaded.[MySQL INFO]: 0 pickups loaded.[MySQL INFO]: 0 labels loaded.[MySQL INFO]: 0 factions loaded.[MySQL INFO]: 0 server vehicles loaded.[MySQL - JOBS]: 0 loaded...[ -- ] [ Gamemode STARTED ] [ -- ]fixes.plugin: Could not find function TakeAd.Number of vehicle models: 0====================================================================Error ID: 2006, MySQL server has gone awayCallback: LoadHousesgQuery: SELECT * FROM `houses`========================================================================================================================================Error ID: 2006, MySQL server has gone awayCallback: LoadSafeboxgQuery: SELECT * FROM `safeboxs`========================================================================================================================================Error ID: 2006, MySQL server has gone awayCallback: LoadTurfsgQuery: SELECT * FROM `turfs`========================================================================================================================================Error ID: 2006, MySQL server has gone awayCallback: LoadDSVehgQuery: SELECT * FROM `dsveh`========================================================================================================================================Error ID: 2006, MySQL server has gone awayCallback: LoadGInfogQuery: SELECT * FROM `infos`========================================================================================================================================Error ID: 2006, MySQL server has gone awayCallback: PreLoadCarsgQuery: SELECT MAX(ID) FROM `cars`====================================================================[connection] 94.176.155.51:26307 requests connection cookie.[connection] incoming connection: 94.176.155.51:26307 id: 0[join] NinGe has joined the server (0:94.176.155.51)====================================================================Error ID: 2006, MySQL server has gone awayCallback: OnPlayerDataLoadedgQuery: SELECT `Password`, `KeyReset` FROM `users` WHERE `username` = '' LIMIT 1========================================================================================================================================Error ID: 2006, MySQL server has gone awayCallback: gQuery: UPDATE `infos` SET `recordnumber`='1' WHERE ID = 1========================================================================================================================================Error ID: 2006, MySQL server has gone awayCallback: gQuery: UPDATE `infos` SET `recorddate`='04.08.2016 20:36' WHERE ID = 1====================================================================[part] NinGe has left the server (0:1)====================================================================Error ID: 2006, MySQL server has gone awayCallback: gQuery: UPDATE `users` SET `Seconds`='0' WHERE `ID`='0' LIMIT 1========================================================================================================================================Error ID: 2006, MySQL server has gone awayCallback: gQuery: UPDATE `users` SET `online`='0' WHERE `ID`='0' LIMIT 1Liniile de cod / sursa / script-ul(obligatoriu): stock initiateConnections() { new File: fhConnectionInfo = fopen("MySQL.txt", io_read); new szQueryOutput[256]; fread(fhConnectionInfo, szQueryOutput); fclose(fhConnectionInfo); sscanf(szQueryOutput, "p<|>e<i>", conType); printf("[MySQL] Using connection no. %d",conType); if(conType == 1) //localhost SQL = mysql_connect("localhost", "root", "gm_db", ""); if(conType == 2) //remote server SQL = mysql_connect("am colpletat corect totul aici", "-", "-", "-"); return true; } Imagini / Video (optional):Ati incercat sa rezolvati singur?:Da, am incercat , am editat si fisierul mysql.text cu 2 , si tot nu merge >((

if (newkeys & KEY_SECONDARY_ATTACK) { new string[300]; if(GetPlayerState(playerid) == PLAYER_STATE_ONFOOT) { if(IsPlayerConnected(playerid)) { for(new i = 1; i < sizeof(HouseInfo); i++) { if(IsPlayerInRangeOfPoint(playerid,2,HouseInfo[hEntrancex], HouseInfo[hEntrancey], HouseInfo[hEntrancez])) { if(PlayerInfo[playerid][pPhousekey] == i || HouseInfo[hLock] == 0) { SetPlayerInterior(playerid,HouseInfo[hInterior]); SetPlayerPos(playerid,HouseInfo[hExitx],HouseInfo[hExity],HouseInfo[hExitz]); GameTextForPlayer(playerid, "~w~Welcome Home", 5000, 1); PlayerInfo[playerid][pInt] = HouseInfo[hInterior]; PlayerInfo[playerid][pLocal] = i; SetPlayerVirtualWorld(playerid,HouseInfo[hVirtual]); InHouse[playerid] = i; } else { GameTextForPlayer(playerid, "~r~~h~Inchis", 5000, 1); } } problema este teleportul aiurea din casa in casa , si indiferent de rent te spawneaza doar la o casa

Problema intalnita (descriere):Am adaugat cas prin comanda /createhouse , iar daca un player cumpara casa , dupa ce intra din nou in joc are rent in alta casa , sau daca intri intr-o casa ,si vrei sa iesi , te duce la alta casa ...Ero(area / rile) / warning-(ul / urile):=Liniile de cod / sursa / script-ul(obligatoriu): Am sa va dau Ce am eu in gamemode adica ce tine de house public OnPropTextdrawUpdate(update, h) { new PropertyString[256]; if(update == 1) { if(HouseInfo[h][hOwned] == 0) { DestroyDynamic3DTextLabel(HouseLabel[h]); DestroyDynamicPickup(HouseInfo[h][hPickupID]); HouseInfo[h][hPickupID] = CreateDynamicPickup(1273, 23, HouseInfo[h][hEntrancex], HouseInfo[h][hEntrancey], HouseInfo[h][hEntrancez]); format(PropertyString, sizeof(PropertyString),"{FFFFFF}Casa {54CC56}%d \n{FFFFFF}Aceasta casa este de vanzare\nDescription: {54CC56}%s \n{FFFFFF}Valoare: {54CC56}$%s \n{FFFFFF}Nivel: {54CC56}%d \n{FFFFFF}Pentru a cumpara aceasta casa, tasteaza {54CC56}/buyhouse",h,HouseInfo[h][hDiscription],FormatNumber(HouseInfo[h][hValue]),HouseInfo[h][hLevel]); HouseLabel[h] = CreateDynamic3DTextLabel(PropertyString ,0x09FF00FF,HouseInfo[h][hEntrancex], HouseInfo[h][hEntrancey], HouseInfo[h][hEntrancez],25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, -1, -1, 100.0); } else if(HouseInfo[h][hOwned] == 1) { if(HouseInfo[h][hRentabil] == 1) { DestroyDynamic3DTextLabel(HouseLabel[h]); format(PropertyString, sizeof(PropertyString),"{54CC56}%s{FFFFFF}\nCasa {54CC56}%d \n{FFFFFF}Casa detinuta de: {54CC56}%s \n{FFFFFF}Chirie: {54CC56}$%s \n{FFFFFF}Nivel: {54CC56}%d \n{FFFFFF}Pentru a lua chirie la aceasta casa, tasteaza {54CC56}/rentroom",HouseInfo[h][hDiscription],h,HouseInfo[h][hOwner],FormatNumber(HouseInfo[h][hRent]),HouseInfo[h][hLevel]); HouseLabel[h] = CreateDynamic3DTextLabel(PropertyString ,0x09FF00FF,HouseInfo[h][hEntrancex], HouseInfo[h][hEntrancey], HouseInfo[h][hEntrancez],25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, -1, -1, 100.0); } else { DestroyDynamic3DTextLabel(HouseLabel[h]); format(PropertyString, sizeof(PropertyString),"{54CC56}%s{FFFFFF}\nCasa {54CC56}%d \n{FFFFFF}Casa detinuta de: {54CC56}%s \n{FFFFFF}Nivel: {54CC56}%d",HouseInfo[h][hDiscription],h,HouseInfo[h][hOwner], HouseInfo[h][hLevel]); HouseLabel[h] = CreateDynamic3DTextLabel(PropertyString ,0x09FF00FF,HouseInfo[h][hEntrancex], HouseInfo[h][hEntrancey], HouseInfo[h][hEntrancez],25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, -1, -1, 100.0); } DestroyDynamicPickup(HouseInfo[h][hPickupID]); HouseInfo[h][hPickupID] = CreateDynamicPickup(1272, 23, HouseInfo[h][hEntrancex], HouseInfo[h][hEntrancey], HouseInfo[h][hEntrancez]); } // Property and Afacere new PropertyString[256]; for(new h = 1; h <= housess; h++) { if(HouseInfo[h][hOwned] == 0) { DestroyDynamic3DTextLabel(HouseLabel[h]); format(PropertyString, sizeof(PropertyString),"{FFFFFF}Casa {54CC56}%d \n{FFFFFF}Aceasta casa este de vanzare\nDescription: {54CC56}%s \n{FFFFFF}Valoare: {54CC56}$%s \n{FFFFFF}Nivel: {54CC56}%d \n{FFFFFF}Pentru a cumpara aceasta casa, tasteaza {54CC56}/buyhouse",h,HouseInfo[h][hDiscription],FormatNumber(HouseInfo[h][hValue]),HouseInfo[h][hLevel]); HouseLabel[h] = CreateDynamic3DTextLabel(PropertyString ,0x09FF00FF,HouseInfo[h][hEntrancex], HouseInfo[h][hEntrancey], HouseInfo[h][hEntrancez],25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, -1, -1, 100.0); HouseInfo[h][hPickupID] = CreateDynamicPickup(1273, 23, HouseInfo[h][hEntrancex], HouseInfo[h][hEntrancey], HouseInfo[h][hEntrancez]); } else if(HouseInfo[h][hOwned] == 1) { if(HouseInfo[h][hRentabil] == 1) { DestroyDynamic3DTextLabel(HouseLabel[h]); format(PropertyString, sizeof(PropertyString),"{54CC56}%s\n {FFFFFF}Casa {54CC56}%d \n{FFFFFF}Casa detinuta de: {54CC56}%s \n{FFFFFF}Chirie: {54CC56}$%s \n{FFFFFF}Nivel: {54CC56}%d \n{FFFFFF}Pentru a lua chirie la aceasta casa, tasteaza {54CC56}/rentroom",HouseInfo[h][hDiscription],h,HouseInfo[h][hOwner],FormatNumber(HouseInfo[h][hRent]),HouseInfo[h][hLevel]); HouseLabel[h] = CreateDynamic3DTextLabel(PropertyString ,0x09FF00FF,HouseInfo[h][hEntrancex], HouseInfo[h][hEntrancey], HouseInfo[h][hEntrancez],25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, -1, -1, 100.0); } else { DestroyDynamic3DTextLabel(HouseLabel[h]); format(PropertyString, sizeof(PropertyString),"{54CC56}%s\n {FFFFFF}Casa {54CC56}%d \n{FFFFFF}Casa detinuta de: {54CC56}%s \n{FFFFFF}Nivel: {54CC56}%d",HouseInfo[h][hDiscription],h,HouseInfo[h][hOwner], HouseInfo[h][hLevel]); HouseLabel[h] = CreateDynamic3DTextLabel(PropertyString ,0x09FF00FF,HouseInfo[h][hEntrancex], HouseInfo[h][hEntrancey], HouseInfo[h][hEntrancez],25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, -1, -1, 100.0); } HouseInfo[h][hPickupID] = CreateDynamicPickup(1272, 23, HouseInfo[h][hEntrancex], HouseInfo[h][hEntrancey], HouseInfo[h][hEntrancez]); // HOUSE SAVE public HUpdate(hid, type) { new var[256]; switch(type) { case hExitxx: { format(var, sizeof(var), "UPDATE `houses` SET `Exitx`='%f' WHERE `ID`='%d'",HouseInfo[hid][hExitx], hid); mysql_query(SQL ,var); } case hExityx: { format(var, sizeof(var), "UPDATE `houses` SET `Exity`='%f' WHERE `ID`='%d'",HouseInfo[hid][hExity], hid); mysql_query(SQL ,var); } case hExitzx: { format(var, sizeof(var), "UPDATE `houses` SET `Exitz`='%f' WHERE `ID`='%d'",HouseInfo[hid][hExitz], hid); mysql_query(SQL ,var); } case hInteriorx: { format(var, sizeof(var), "UPDATE `houses` SET `Interior`='%d' WHERE `ID`='%d'",HouseInfo[hid][hInterior], hid); mysql_query(SQL ,var); } } return 1; } Imagini / Video (optional):Ati incercat sa rezolvati singur?: da

Problema intalnita (descriere): Problema intalnita (descriere): Cand intru in shop si dau /clothes imi arata mai multe skinuri , iar daca selectez unul dintre skin-uri , imi da un skin din factiune , cum pot sa remediez problema ? Multumesc anticipatEro(area / rile) / warning-(ul / urile):Liniile de cod / sursa / script-ul(obligatoriu): Cred ca este de aici CMD:clothes(playerid,params[]) { if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "Trebuie sa te loghezi mai intai."); if(IsAtClothShop(playerid)) { if(PlayerInfo[playerid][pMember] >= 1) { if(IsPlayerConnected(playerid)) { if(GetPlayerCash(playerid) < 1500) return SCM(playerid,COLOR_YELLOW2, "Error: You do not have enough money($1,500)."); SBizzInfo[9][sbTill] += 1500; SBizzInfo[9][sbProducts]--; GivePlayerCash(playerid,-1500); new rand2 = random(5); SetPlayerVirtualWorld(playerid,rand2); SetPlayerInterior(playerid,0); new rand = random(sizeof(gInviteSpawns)); SetPlayerPos(playerid, gInviteSpawns[rand][0], gInviteSpawns[rand][1], gInviteSpawns[rand][2]); // Warp the player SetPlayerFacingAngle(playerid, gInviteSpawns[rand][3]); SetPlayerCameraPos(playerid,gInviteSpawns[rand][0] + 3, gInviteSpawns[rand][1], gInviteSpawns[rand][2]); SetPlayerCameraLookAt(playerid,gInviteSpawns[rand][0], gInviteSpawns[rand][1], gInviteSpawns[rand][2]); TogglePlayerControllable(playerid, 0); SelectChar[playerid] = 255; SelectCharID[playerid] = PlayerInfo[playerid][pMember]; SelectCharPlace[playerid] = 1; PlayerInfo[playerid][pChar] = ChosenSkin[playerid]; ShowPlayerDialog(playerid, DIALOG_CLOTHES, DIALOG_STYLE_MSGBOX,"Clothes:", "Press 'Next' to select the clothes.\nPress 'Done' once you have chosen the clothes.","Next", "Done"); new sendername[25],string[100]; GetPlayerName(playerid,sendername,sizeof(sendername)); format(string, sizeof(string), "UPDATE users SET Money='%d' WHERE name='%s'", GetPlayerCash(playerid), sendername); mysql_query(SQL,string); format(string,sizeof(string),"UPDATE `sbizz` SET `Till`='%d',`Products`='%d' WHERE `ID`='9'",SBizzInfo[9][sbTill],SBizzInfo[9][sbProducts]); mysql_query(SQL,string); } } else { ShowModelSelectionMenu (playerid, skinlist, "Haine"); } } else { SCM(playerid,COLOR_YELLOW2, "Error: You're not the clothing store."); } return 1; Imagini / Video (optional):http://imgur.com/a/A1Re9Ati incercat sa rezolvati singur?: Da

Problema intalnita (descriere): Atunci cand incerc sa vand masina la dealership , imi da bani inapoi , dar masina tot la mine ramane , si pe langa asta cateodata merge /v cateodata nu Ero(area / rile) / warning-(ul / urile): - Liniile de cod / sursa / script-ul(obligatoriu): "Trebuie să îi setezi player.ului cheia 0 folosesti Delete * from ca să o ștergi din baza de date si destroyVehicle ca să o ștergi de pe server ," - Asta mi-a spus o persoana dupa forum . Dar din baza de date se sterge , dar dupa server nu ... case DIALOG_SELLCAR: { if(!response) return 1; new vsid = PlayerSellCar[playerid]; CarInfo[vsid][cID] = -2; new value; value = floatround((CarInfo[vsid][cValue] * 7) / 10); GivePlayerCash(playerid, value); format(string, sizeof(string), "{FFB870}Distribuitorul Auto ti-a dat %s$ (60%s din pretul vehiculului).",FormatNumber(value), "%%"); SendClientMessage(playerid,COLOR_WHITE,string); if(CarInfo[PlayerInfo[playerid][pCarKey1]][Spawned] == CarInfo[vsid][Spawned] && vsid != 0) DespawnCar[playerid][0] = -1; else if(CarInfo[PlayerInfo[playerid][pCarKey2]][Spawned] == CarInfo[vsid][Spawned] && vsid != 0) DespawnCar[playerid][1] = -1; else if(CarInfo[PlayerInfo[playerid][pCarKey3]][Spawned] == CarInfo[vsid][Spawned] && vsid != 0) DespawnCar[playerid][2] = -1; else if(CarInfo[PlayerInfo[playerid][pCarKey4]][Spawned] == CarInfo[vsid][Spawned] && vsid != 0) DespawnCar[playerid][3] = -1; else if(CarInfo[PlayerInfo[playerid][pCarKey5]][Spawned] == CarInfo[vsid][Spawned] && vsid != 0) DespawnCar[playerid][4] = -1; else if(CarInfo[PlayerInfo[playerid][pCarKey6]][Spawned] == CarInfo[vsid][Spawned] && vsid != 0) DespawnCar[playerid][5] = -1; else if(CarInfo[PlayerInfo[playerid][pCarKey7]][Spawned] == CarInfo[vsid][Spawned] && vsid != 0) DespawnCar[playerid][6] = -1; DestroyVehicle(GetPlayerVehicleID(playerid)); mysql_format(SQL, string,sizeof(string),"DELETE FROM cars WHERE ID=%d",vsid); mysql_tquery(SQL, string, "", ""); if(PlayerInfo[playerid][pCarKey1] == CarInfo[vsid][cID]) { PlayerInfo[playerid][pCarKey1] = 0; mysql_format(SQL, string,sizeof(string),"UPDATE `users`SET CarKey1 = %d WHERE `Name` = '%s'",PlayerInfo[playerid][pCarKey1],PlayerInfo[playerid][pUsername]); } if(PlayerInfo[playerid][pCarKey2] == CarInfo[vsid][cID]) { PlayerInfo[playerid][pCarKey2] = 0; mysql_format(SQL, string,sizeof(string),"UPDATE `users`SET CarKey2 = %d WHERE `Name` = '%s'",PlayerInfo[playerid][pCarKey2],PlayerInfo[playerid][pUsername]); } if(PlayerInfo[playerid][pCarKey3] == CarInfo[vsid][cID]) { PlayerInfo[playerid][pCarKey3] = 0; mysql_format(SQL, string,sizeof(string),"UPDATE `users`SET CarKey3 = %d WHERE `Name` = '%s'",PlayerInfo[playerid][pCarKey3],PlayerInfo[playerid][pUsername]); } if(PlayerInfo[playerid][pCarKey4] == CarInfo[vsid][cID]) { PlayerInfo[playerid][pCarKey4] = 0; mysql_format(SQL, string,sizeof(string),"UPDATE `users`SET CarKey4 = %d WHERE `Name` = '%s'",PlayerInfo[playerid][pCarKey4],PlayerInfo[playerid][pUsername]); } if(PlayerInfo[playerid][pCarKey5] == CarInfo[vsid][cID]) { PlayerInfo[playerid][pCarKey5] = 0; mysql_format(SQL, string,sizeof(string),"UPDATE `users`SET CarKey5 = %d WHERE `Name` = '%s'",PlayerInfo[playerid][pCarKey5],PlayerInfo[playerid][pUsername]); } if(PlayerInfo[playerid][pCarKey6] == CarInfo[vsid][cID]) { PlayerInfo[playerid][pCarKey6] = 0; mysql_format(SQL, string,sizeof(string),"UPDATE `users`SET CarKey6 = %d WHERE `Name` = '%s'",PlayerInfo[playerid][pCarKey6],PlayerInfo[playerid][pUsername]); } if(PlayerInfo[playerid][pCarKey7] == CarInfo[vsid][cID]) { PlayerInfo[playerid][pCarKey7] = 0; mysql_format(SQL, string,sizeof(string),"UPDATE `users`SET CarKey7 = %d WHERE `Name` = '%s'",PlayerInfo[playerid][pCarKey7],PlayerInfo[playerid][pUsername]); } mysql_tquery(SQL, string, "", ""); } Imagini / Video (optional):-Ati incercat sa rezolvati singur?: Da , tin sa mentionez ca din baza de date se sterge vehiculul dar nu se sterge dupa server

Salut , am si eu o problema cu dealership , cand vand masina la dealership , imi da bani , dar masina tot imi ramane , si dupa nu mai merge nici /V , imi poate spune cineva care este problema ?

Imi poti pune si mie un script pentru /Givekey ?

Salut , sunt nou in lumea aceasta a samp-script-ului , dupa cum ati vazut am postat mai multe topicuri pe acest forum , in acest topic va cer sa imi spuneti cum adaug bizuri pe server , daca poate cineva sa imi lase un link de la un script , sau chiar sa imi explice astept reply aici .Multumesc anticipat !

Poti sa ma ajuti ? Ti-am trimis cerere skype ,

Deci cand intru in shop si dau /clothes imi apare asa (vezi imaginea ) ,daca imi aleg un skin imi da altul aiurea , indiferent de ce skin aleg (vezi cealanta imagine ) si uite si script (vezi ultima imagine

Salut , Cand intru in shop si dau /clothes imi arata mai multe skinuri , iar daca selectez unul dintre skin-uri , imi da un skin din factiune , cum pot sa remediez problema ? Multumesc anticipat

Salut , Am descarcat un system de /House de pe net , am adaugat fisierele in filescript si editat cfg si adaugat in includes tot , dar cand intru pe server este tot sistemul acela vechi , stiti cumva ce trebuie sa fac ? Multumesc anticipat

ok mersi mult

cum se foloseste comanda /goto xyz ? Adica ce pun inloc de x,y,z , interior , virtual word ?

contacteaza-ma pe skype te rog

Salut , am si eu o problema la server , cand dau /locations si dau pe dealership , imi pune checkpoint la alta locatie si tot asa, daca imi poate spune cineva unde in GM gasesc coordonatele de la dealership ,sunt foarte multe si nu stiu care dintre ele e cea buna ca sa pot sa inlocuiesc coordonatele . Skype cristian.cristi326