Balkan SA:MP

PAWN skriptanje, gamemodovi, filterskripte, include fajlovi, mape, pluginovi => Razgovor u vezi PAWN - skriptanja => Temu započeo: Iv0r_. poslato Decembar 01, 2021, 20:48:35 POSLE PODNE

Naslov: mysql
Poruka od: Iv0r_. poslato Decembar 01, 2021, 20:48:35 POSLE PODNE
Problem(error/warning): Nece da se poveze na bazu. Znaci, ja znam lepo da spojim bazu i da radi, i na svim modovima kad spajam radi, samo vamo nece, startam xampp, napravim bazu pod tim i tim imenom, prekopiram iz .sql fajla, ono radi, ucitalo je sve users, vehicles itd itd sve na phpmyadmin radi, međutim, kada se starta samp-server.exe, pise ne uspesna konekcija.
Deo skripte: [pawn]Vaš odgovor[/pawn]
Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log): [pawn]VNeuspesna konekcija srv_1086281_EeA@91.134.193.97 -> srv_1086281_EeA
[npc:join] TrainDriver has joined the server (999:127.0.0.1)
[npc:join] Vojnik_1 has joined the server (998:127.0.0.1)
[npc:join] Vojnik_2 has joined the server (997:127.0.0.1)
[npc:join] Vojnik_3 has joined the server (996:127.0.0.1)
[npc:join] Vojnik_4 has joined the server (995:127.0.0.1)
[npc:join] Vojnik_5 has joined the server (994:127.0.0.1)
[npc:join] Kapetan has joined the server (993:127.0.0.1)
[npc:join] Vojnik_6 has joined the server (992:127.0.0.1)
[npc:join] Vojnik_7 has joined the server (991:127.0.0.1)
AntiCheat ocitan!
Statistika servera ocitana!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!





Gamemode ucitan!
       KURAC Gaming Community





Number of vehicle models: 2[/pawn]
Slika/video ingame problema(obavezno ako je ingame problem): znate vec koji je mod :D
Naslov: Odg: mysql
Poruka od: noddy_ poslato Decembar 01, 2021, 21:33:03 POSLE PODNE
"Neuspesna konekcija"
Gle, na PHP-u nazovi bazu kako si je u skripti definisao, importraj .sql fajl, izmjeni ime, pass, host i to u skripti.Definisi kako je i na PHP-u
Ako pokreces na localhostu ovo, upali XAMPP postavi, i localhost definiraj
Naslov: Odg: mysql
Poruka od: Iv0r_. poslato Decembar 01, 2021, 23:20:03 POSLE PODNE
Citat: ɴᴏᴅɪ poslato Decembar 01, 2021, 21:33:03 POSLE PODNE
"Neuspesna konekcija"
Gle, na PHP-u nazovi bazu kako si je u skripti definisao, importraj .sql fajl, izmjeni ime, pass, host i to u skripti.Definisi kako je i na PHP-u
Ako pokreces na localhostu ovo, upali XAMPP postavi, i localhost definiraj
non stop izbacuje neuspesna konekcija.
Kreiram databazu na php, idem sql, prebacim sve sto pise tamo u sql, i onda idem import. i onda pokrecem ? Ili
Naslov: Odg: mysql
Poruka od: noddy_ poslato Decembar 02, 2021, 16:32:08 POSLE PODNE
Citat: Iv0r_. poslato Decembar 01, 2021, 23:20:03 POSLE PODNE
non stop izbacuje neuspesna konekcija.
Kreiram databazu na php, idem sql, prebacim sve sto pise tamo u sql, i onda idem import. i onda pokrecem ? Ili
gle, ja ne znam sta ti paste-as i to.Ali najlakse je da kreiras bazu i importas .sql file ili ti ga samu bazu
Naslov: Odg: mysql
Poruka od: Iv0r_. poslato Decembar 02, 2021, 18:46:09 POSLE PODNE
Citat: %u0274%u1D0F%u1D05%u026A poslato Decembar 02, 2021, 16:32:08 POSLE PODNE
gle, ja ne znam sta ti paste-as i to.Ali najlakse je da kreiras bazu i importas .sql file ili ti ga samu bazu
Napravio sam, izadje ovo.
[pawn]Konekcija uspesna root@localhost -> kurac
[npc:join] Vojnik_1 has joined the server (999:127.0.0.1)
[npc:join] Vojnik_2 has joined the server (998:127.0.0.1)
[npc:join] Vojnik_3 has joined the server (997:127.0.0.1)
[npc:join] Vojnik_4 has joined the server (996:127.0.0.1)
[npc:join] Vojnik_5 has joined the server (995:127.0.0.1)
[npc:join] Kapetan has joined the server (994:127.0.0.1)
[npc:join] Vojnik_6 has joined the server (993:127.0.0.1)
[npc:join] Vojnik_7 has joined the server (992:127.0.0.1)
AntiCheat ocitan!
Statistika servera ocitana!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
KURAC - dadada.com
DEVELOPER: IVOR
v1.0[W] - UCITAVANJE...
Number of vehicle models: 0[/pawn]
i nista kasnije ne loada. P.S ovo vise nije 2.0 ovo je 1.0 ona prva.
Starto XAMPP, kreirao novu databazu, usao u nju, onda import, ubacio .sql fajl, ceko 1min, pisalo ono zeleno kao sve radi. Udjem vidim sve racuni, vozila itd itd... Startam samp-server.exe, pise ono gore ucitano i to. I nece nista poslije tog. Udjem na srw i uvijek je Server closed the connection ili dole one levo i desno strelice... Svaki drugi mod od MYSQL radi samo ovaj nece, svaki radi samo ovaj ne...
Naslov: Odg: mysql
Poruka od: noddy_ poslato Decembar 02, 2021, 18:51:24 POSLE PODNE
Log?Crashdetect?
Naslov: Odg: mysql
Poruka od: Iv0r_. poslato Decembar 02, 2021, 21:35:12 POSLE PODNE
Citat: ɴᴏᴅɪ poslato Decembar 02, 2021, 18:51:24 POSLE PODNE
Log?Crashdetect?
[pawn][ucitano] 0 hotela
[ucitano] 9 auto salona
[ucitano] 42 kapija
[ucitano] 70 firmi
[ucitano] 55 aktora
[ucitano] Plate
[ucitano] 112 kontejnera
[ucitano] 46 farmi
[ucitano] 5 platformi
[ucitano] 24 gps lokacija
[ucitano] 20 bankomata
[ucitano] 18 organizacija
[ucitano] 808 imovina
[ucitano] 3 benzinskih stanica
[connection] IP requests connection cookie.
[ucitano] 135 garaza
Kicking IP because they didn't logon to the game.
[ucitano] 15 teritorija
[ucitano] 43 grafita
[connection] incoming connection: IP id: 0
Invalid client connecting from IP
[connection] IP requests connection cookie.
Kicking IP because they didn't logon to the game.[/pawn]
U mysql.log je sve DEBUG.
[pawn][21:34:46] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[21:34:46] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[21:34:46] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[21:34:46] [DEBUG] CMySQLConnection::Connect - connection was successful
[21:34:46] [DEBUG] CMySQLConnection::Connect - connection was successful
[21:34:46] [DEBUG] CMySQLConnection::Connect - connection was successful
bled
[21:34:46] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[21:34:46] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[21:34:46] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[21:34:46] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 6.628 milliseconds
[21:34:46] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[21:34:46] [DEBUG] mysql_tquery - connection: 1, query: "SELECT bussines.*, IFNULL(users.p_name, 'Drzava') AS `p_name` FR", callback: "OnBussinesLoad", format: "(null)"
[21:34:46] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `buildings`", callback: "OnBuildingsLoad", format: "(null)"
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnBussinesLoad] - starting query execution
[21:34:46] [DEBUG] mysql_pquery - connection: 1, query: "SELECT hotels.*, IFNULL(users.p_name, 'Drzava') AS `p_name` FROM", callback: "OnHotelsLoad", format: "(null)"
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnBussinesLoad] - query was successfully executed within 0.791 milliseconds
[21:34:46] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnBuildingsLoad] - starting query execution
[21:34:46] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `vehicle_salon`", callback: "OnVehSalonsLoad", format: "(null)"
[21:34:46] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `gates`", callback: "OnGatesLoad", format: "(null)"
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnHotelsLoad] - starting query execution
[21:34:46] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `actors`", callback: "OnActorsLoad", format: "(null)"
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnBuildingsLoad] - query was successfully executed within 0.492 milliseconds
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnVehSalonsLoad] - starting query execution
[21:34:46] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnHotelsLoad] - query was successfully executed within 0.402 milliseconds
[21:34:46] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `plate`", callback: "OnPlateLoad", format: "(null)"
[21:34:46] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnActorsLoad] - starting query execution
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnPlateLoad] - starting query execution
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnGatesLoad] - starting query execution
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnActorsLoad] - query was successfully executed within 1.114 milliseconds
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnGatesLoad] - query was successfully executed within 6.238 milliseconds
[21:34:46] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnPlateLoad] - query was successfully executed within 1.52 milliseconds
[21:34:46] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `containers`", callback: "OnContainersLoad", format: "(null)"
[21:34:46] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `platforme`", callback: "OnPlatformsLoad", format: "(null)"
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnContainersLoad] - starting query execution
ack: "OnFarmeLoad", format: "(null)"
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnPlatformsLoad] - starting query execution
[21:34:46] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[21:34:46] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `atms`", callback: "OnATMsLoad", format: "(null)"
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnContainersLoad] - query was successfully executed within 0.672 milliseconds
[21:34:46] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `gps`", callback: "OnGpsLocationsLoad", format: "(null)"
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnPlatformsLoad] - query was successfully executed within 0.412 milliseconds
[21:34:46] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnATMsLoad] - starting query execution
[21:34:46] [DEBUG] Calling callback "OnBussinesLoad"..
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnFarmeLoad] - starting query execution
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnFarmeLoad] - query was successfully executed within 0.415 milliseconds
[21:34:46] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[21:34:46] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[21:34:46] [DEBUG] CMySQLQuery::Execute[OnGpsLocationsLoad] - starting query execution
[21:34:46] [DEBUG] cache_get_data - connection: 1
[21:34:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "bussines_id", connection: 1
[21:34:47] [DEBUG] CMySQLQuery::Execute[OnGpsLocationsLoad] - query was successfully executed within 0.392 milliseconds
[21:34:47] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "bussines_id", data: "2"
[21:34:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "b_owner_sqlID", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_owner_sqlID", data: "0"
[21:34:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "b_price", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_price", data: "7000000"
[21:34:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "b_type", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_type", data: "30"
[21:34:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "b_locked", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_locked", data: "0"
[21:34:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "b_money", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_money", data: "17965"
[21:34:47] [DEBUG] cache_get_field_content_float - row: 0, field_name: "b_enter_x", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_enter_x", data: "1022.47"
[21:34:47] [DEBUG] cache_get_field_content_float - row: 0, field_name: "b_enter_y", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_enter_y", data: "-1121.42"
[21:34:47] [DEBUG] cache_get_field_content_float - row: 0, field_name: "b_enter_z", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_enter_z", data: "23.87"
[21:34:47] [DEBUG] cache_get_field_content_float - row: 0, field_name: "b_exit_x", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_exit_x", data: "1141.8"
[21:34:47] [DEBUG] cache_get_field_content_float - row: 0, field_name: "b_exit_y", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_exit_y", data: "-50.702"
[21:34:47] [DEBUG] cache_get_field_content_float - row: 0, field_name: "b_exit_z", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_exit_z", data: "996.521"
[21:34:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "b_enter_int", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_enter_int", data: "0"
[21:34:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "b_enter_vw", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_enter_vw", data: "0"
[21:34:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "b_exit_int", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_exit_int", data: "3"
[21:34:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "b_exit_vw", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_exit_vw", data: "2"
[21:34:47] [DEBUG] cache_get_field_content - row: 0, field_name: "b_name", connection: 1, max_len: 32
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_name", data: "Casino"
[21:34:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "b_level", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_level", data: "10"
[21:34:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "b_jobID", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_jobID", data: "0"
[21:34:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "b_neaktivnost", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_neaktivnost", data: "0"
[21:34:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "b_facture", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_facture", data: "100"
[21:34:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "b_reket", connection: 1
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "b_reket", data: "0"
[21:34:47] [DEBUG] cache_get_field_content - row: 0, field_name: "p_name", connection: 1, max_len: 24
[21:34:47] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "p_name", data: "Drzava"
[21:34:47] [DEBUG] cache_get_field_content_int - row: 1, field_name: "bussines_id", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "bussines_id", data: "4"
[21:34:48] [DEBUG] cache_get_field_content_int - row: 1, field_name: "b_owner_sqlID", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_owner_sqlID", data: "0"
[21:34:48] [DEBUG] cache_get_field_content_int - row: 1, field_name: "b_price", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_price", data: "7000000"
[21:34:48] [DEBUG] cache_get_field_content_int - row: 1, field_name: "b_type", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_type", data: "18"
[21:34:48] [DEBUG] cache_get_field_content_int - row: 1, field_name: "b_locked", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_locked", data: "0"
[21:34:48] [DEBUG] cache_get_field_content_int - row: 1, field_name: "b_money", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_money", data: "184951"
[21:34:48] [DEBUG] cache_get_field_content_float - row: 1, field_name: "b_enter_x", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_enter_x", data: "-370.21"
[21:34:48] [DEBUG] cache_get_field_content_float - row: 1, field_name: "b_enter_y", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_enter_y", data: "-1442.06"
[21:34:48] [DEBUG] cache_get_field_content_float - row: 1, field_name: "b_enter_z", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_enter_z", data: "26.204"
[21:34:48] [DEBUG] cache_get_field_content_float - row: 1, field_name: "b_exit_x", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_exit_x", data: "0"
[21:34:48] [DEBUG] cache_get_field_content_float - row: 1, field_name: "b_exit_y", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_exit_y", data: "0"
[21:34:48] [DEBUG] cache_get_field_content_float - row: 1, field_name: "b_exit_z", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_exit_z", data: "0"
[21:34:48] [DEBUG] cache_get_field_content_int - row: 1, field_name: "b_enter_int", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_enter_int", data: "0"
[21:34:48] [DEBUG] cache_get_field_content_int - row: 1, field_name: "b_enter_vw", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_enter_vw", data: "0"
[21:34:48] [DEBUG] cache_get_field_content_int - row: 1, field_name: "b_exit_int", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_exit_int", data: "0"
[21:34:48] [DEBUG] cache_get_field_content_int - row: 1, field_name: "b_exit_vw", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_exit_vw", data: "3"
[21:34:48] [DEBUG] cache_get_field_content - row: 1, field_name: "b_name", connection: 1, max_len: 32
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_name", data: "Farmer"
[21:34:48] [DEBUG] cache_get_field_content_int - row: 1, field_name: "b_level", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_level", data: "10"
[21:34:48] [DEBUG] cache_get_field_content_int - row: 1, field_name: "b_jobID", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_jobID", data: "9"
[21:34:48] [DEBUG] cache_get_field_content_int - row: 1, field_name: "b_neaktivnost", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_neaktivnost", data: "0"
[21:34:48] [DEBUG] cache_get_field_content_int - row: 1, field_name: "b_facture", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_facture", data: "100"
[21:34:48] [DEBUG] cache_get_field_content_int - row: 1, field_name: "b_reket", connection: 1
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "b_reket", data: "0"
[21:34:48] [DEBUG] cache_get_field_content - row: 1, field_name: "p_name", connection: 1, max_len: 24
[21:34:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "p_name", data: "Drzava"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 2, field_name: "bussines_id", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "bussines_id", data: "5"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 2, field_name: "b_owner_sqlID", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_owner_sqlID", data: "0"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 2, field_name: "b_price", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_price", data: "7000000"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 2, field_name: "b_type", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_type", data: "31"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 2, field_name: "b_locked", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_locked", data: "0"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 2, field_name: "b_money", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_money", data: "110639"
[21:34:49] [DEBUG] cache_get_field_content_float - row: 2, field_name: "b_enter_x", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_enter_x", data: "1029.02"
[21:34:49] [DEBUG] cache_get_field_content_float - row: 2, field_name: "b_enter_y", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_enter_y", data: "-2037.99"
[21:34:49] [DEBUG] cache_get_field_content_float - row: 2, field_name: "b_enter_z", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_enter_z", data: "13.097"
[21:34:49] [DEBUG] cache_get_field_content_float - row: 2, field_name: "b_exit_x", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_exit_x", data: "0"
[21:34:49] [DEBUG] cache_get_field_content_float - row: 2, field_name: "b_exit_y", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_exit_y", data: "0"
[21:34:49] [DEBUG] cache_get_field_content_float - row: 2, field_name: "b_exit_z", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_exit_z", data: "0"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 2, field_name: "b_enter_int", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_enter_int", data: "0"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 2, field_name: "b_enter_vw", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_enter_vw", data: "0"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 2, field_name: "b_exit_int", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_exit_int", data: "0"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 2, field_name: "b_exit_vw", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_exit_vw", data: "4"
[21:34:49] [DEBUG] cache_get_field_content - row: 2, field_name: "b_name", connection: 1, max_len: 32
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_name", data: "Neon Shop Riely"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 2, field_name: "b_level", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_level", data: "10"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 2, field_name: "b_jobID", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_jobID", data: "0"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 2, field_name: "b_neaktivnost", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_neaktivnost", data: "0"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 2, field_name: "b_facture", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_facture", data: "100"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 2, field_name: "b_reket", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "b_reket", data: "0"
[21:34:49] [DEBUG] cache_get_field_content - row: 2, field_name: "p_name", connection: 1, max_len: 24
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "p_name", data: "Drzava"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 3, field_name: "bussines_id", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "bussines_id", data: "6"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 3, field_name: "b_owner_sqlID", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_owner_sqlID", data: "0"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 3, field_name: "b_price", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_price", data: "7000000"
[21:34:49] [DEBUG] cache_get_field_content_int - row: 3, field_name: "b_type", connection: 1
[21:34:49] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_type", data: "29"
[21:34:50] [DEBUG] cache_get_field_content_int - row: 3, field_name: "b_locked", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_locked", data: "0"
[21:34:50] [DEBUG] cache_get_field_content_int - row: 3, field_name: "b_money", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_money", data: "20748"
[21:34:50] [DEBUG] cache_get_field_content_float - row: 3, field_name: "b_enter_x", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_enter_x", data: "1281.24"
[21:34:50] [DEBUG] cache_get_field_content_float - row: 3, field_name: "b_enter_y", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_enter_y", data: "-1533.95"
[21:34:50] [DEBUG] cache_get_field_content_float - row: 3, field_name: "b_enter_z", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_enter_z", data: "13.567"
[21:34:50] [DEBUG] cache_get_field_content_float - row: 3, field_name: "b_exit_x", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_exit_x", data: "0"
[21:34:50] [DEBUG] cache_get_field_content_float - row: 3, field_name: "b_exit_y", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_exit_y", data: "0"
[21:34:50] [DEBUG] cache_get_field_content_float - row: 3, field_name: "b_exit_z", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_exit_z", data: "0"
[21:34:50] [DEBUG] cache_get_field_content_int - row: 3, field_name: "b_enter_int", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_enter_int", data: "0"
[21:34:50] [DEBUG] cache_get_field_content_int - row: 3, field_name: "b_enter_vw", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_enter_vw", data: "0"
[21:34:50] [DEBUG] cache_get_field_content_int - row: 3, field_name: "b_exit_int", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_exit_int", data: "0"
[21:34:50] [DEBUG] cache_get_field_content_int - row: 3, field_name: "b_exit_vw", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_exit_vw", data: "0"
[21:34:50] [DEBUG] cache_get_field_content - row: 3, field_name: "b_name", connection: 1, max_len: 32
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_name", data: "Lutrija"
[21:34:50] [DEBUG] cache_get_field_content_int - row: 3, field_name: "b_level", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_level", data: "10"
[21:34:50] [DEBUG] cache_get_field_content_int - row: 3, field_name: "b_jobID", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_jobID", data: "0"
[21:34:50] [DEBUG] cache_get_field_content_int - row: 3, field_name: "b_neaktivnost", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_neaktivnost", data: "0"
[21:34:50] [DEBUG] cache_get_field_content_int - row: 3, field_name: "b_facture", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_facture", data: "100"
[21:34:50] [DEBUG] cache_get_field_content_int - row: 3, field_name: "b_reket", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "b_reket", data: "0"
[21:34:50] [DEBUG] cache_get_field_content - row: 3, field_name: "p_name", connection: 1, max_len: 24
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "p_name", data: "Drzava"
[21:34:50] [DEBUG] cache_get_field_content_int - row: 4, field_name: "bussines_id", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "bussines_id", data: "7"
[21:34:50] [DEBUG] cache_get_field_content_int - row: 4, field_name: "b_owner_sqlID", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "b_owner_sqlID", data: "0"
[21:34:50] [DEBUG] cache_get_field_content_int - row: 4, field_name: "b_price", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "b_price", data: "1"
[21:34:50] [DEBUG] cache_get_field_content_int - row: 4, field_name: "b_type", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "b_type", data: "9"
[21:34:50] [DEBUG] cache_get_field_content_int - row: 4, field_name: "b_locked", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "b_locked", data: "0"
[21:34:50] [DEBUG] cache_get_field_content_int - row: 4, field_name: "b_money", connection: 1
[21:34:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "b_money", data: "192500"
[21:34:50] [DEBUG] cache_get_field_content_float - row: 4, field_name: "b_enter_x", connection: 1
[21:34:51] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "b_enter_x", data: "1368.41"
[21:34:51] [DEBUG] cache_get_field_content_float - row: 4, field_name: "b_enter_y", connection: 1
[21:34:51] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "b_enter_y", data: "-1279.81"
[21:34:51] [DEBUG] cache_get_field_content_float - row: 4, field_name: "b_enter_z", connection: 1
[21:34:51] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "b_enter_z", data: "13.547"
[21:34:51] [DEBUG] cache_get_field_content_float - row: 4, field_name: "b_exit_x", connection: 1
[21:34:51] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "b_exit_x", data: "315.763"
[21:34:51] [DEBUG] cache_get_field_content_float - row: 4, field_name: "b_exit_y", connection: 1
[21:34:51] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "b_exit_y", data: "-143.661"
[21:34:51] [DEBUG] cache_get_field_content_float - row: 4, field_name: "b_exit_z", connection: 1
[21:34:51] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "b_exit_z", data: "999.602"
[21:34:51] [DEBUG] cache_get_field_content_int - row: 4, field_name: "b_enter_int", connection: 1
[21:34:51] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "b_enter_int", data: "0"
[21:34:51] [DEBUG] cache_get_field_content_int - row: 4, field_name: "b_enter_vw", connection: 1
[21:34:51] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "b_enter_vw", data: "0"
[21:34:51] [DEBUG] cache_get_field_content_int - row: 4, field_name: "b_exit_int", connection: 1
[21:34:51] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "b_exit_int", data: "7"
[/pawn]
Naslov: Odg: mysql
Poruka od: __vedran.xyz77 poslato Decembar 03, 2021, 01:56:55 PRE PODNE
Pa sve ti bukvalno pise, nisu tacni podatci za login na mysql bazu. Jesi compile mod ?
Naslov: Odg: mysql
Poruka od: Iv0r_. poslato Decembar 03, 2021, 12:34:06 POSLE PODNE
Citat: __vedran.xyz77 poslato Decembar 03, 2021, 01:56:55 PRE PODNE
Pa sve ti bukvalno pise, nisu tacni podatci za login na mysql bazu. Jesi compile mod ?
naravno :D
Naslov: Odg: mysql
Poruka od: Iv0r_. poslato Decembar 03, 2021, 12:52:07 POSLE PODNE
Citat: __vedran.xyz77 poslato Decembar 03, 2021, 01:56:55 PRE PODNE
Pa sve ti bukvalno pise, nisu tacni podatci za login na mysql bazu. Jesi compile mod ?
Jesu... tocni su.. Pogledaj...
Ovako je definisano u skripti...
[pawn]//=================================[ MySql ]====================================

#define kucni

#if defined kucni
    #define MYSQL_HOST "localhost"
   #define MYSQL_USER "root"
   #define MYSQL_PASS ""
   #define MYSQL_DB "kurac"
#else
    #define MYSQL_HOST "localhost"
   #define MYSQL_USER "root"
   #define MYSQL_PASS ""
   #define MYSQL_DB "kurac"
#endif

new _dbConnector, sql_str[ 128 ];

//==================================[ Igraci ]==================================[/pawn]
Otisao sam napravit novu bazu u mysql phpmyadmin i kliknio Novo -> kurac -> otisao import -> kliknio na pregledaj i štiklirao mod -> I onda je pisalo ono zeleno, desno vidim sve kreirano -> Pokrenem samp-server.exe i pise ovo.
Citat
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

filterscripts = ""  (string)

Server Plugins
--------------
Loading plugin: sscanf


===============================

      sscanf plugin loaded.

         Version:  2.8.1

   (c) 2012 Alex "Y_Less" Cole

===============================

  Loaded.
Loading plugin: crashdetect
  CrashDetect v4.17 is OK.
  Loaded.
Loading plugin: pawnraknet
Pawn.RakNet plugin v1.3.0 by urShadow has been loaded
  Loaded.
Loading plugin: mysql
>> plugin.mysql: R39-5 successfully loaded.
  Loaded.
Loading plugin: streamer


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

  Loaded.
Loading plugin: FCNPC

-------------------------------------------------
     FCNPC - Fully Controllable NPC v2.0.0
            Windows SA-MP 0.3.7 R2
           Jan  2 2019 at 23:09:26

  Author:       OrMisicL (2013 - 2015)
  Continued by: ziggi    (2016 - present)

  See full credits in the README.md file
-------------------------------------------------

Loading...

-------------------------------------------------
   ColAndreasv1.4.0

   Created By:
     [uL]Chris42O
     [uL]Slice
     [uL]Pottus
-------------------------------------------------

Loading...
ColAndreas v1.4.0 Loaded.
  Loaded.
Loading plugin: SKY
  Loaded.
Loading plugin: pawncmd
Pawn.CMD plugin v3.2.0 by urShadow has been loaded
  Loaded.
Loaded 8 plugins.


Started server on port: 7777, with maxplayers: 1000 lanmode is OFF.


Filterscripts
---------------
  Loaded 0 filterscripts.

No collision data found.



=======================================
|                                     |
|        YSI version 4.00.0001        |
|        By Alex "Y_Less" Cole        |
|                                     |
=======================================


--------------------------------------
Anticheat Nex-AC loaded!
Anticheat version: 1.9.49
Author: Nexius
--------------------------------------

Konekcija uspesna root@localhost -> kurac
[npc:join] Vojnik_1 has joined the server (999:127.0.0.1)
[npc:join] Vojnik_2 has joined the server (998:127.0.0.1)
[npc:join] Vojnik_3 has joined the server (997:127.0.0.1)
[npc:join] Vojnik_4 has joined the server (996:127.0.0.1)
[npc:join] Vojnik_5 has joined the server (995:127.0.0.1)
[npc:join] Kapetan has joined the server (994:127.0.0.1)
[npc:join] Vojnik_6 has joined the server (993:127.0.0.1)
[npc:join] Vojnik_7 has joined the server (992:127.0.0.1)
AntiCheat ocitan!
Statistika servera ocitana!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
KURAC OGC - USKORO
DEVELOPER: Ivor
v1.0[W] - UCITAVANJE...
Number of vehicle models: 0
[ucitano] 70 firmi
[ucitano] 9 auto salona
[ucitano] 0 hotela
[connection] IP requests connection cookie.
[ucitano] 55 aktora
[ucitano] 42 kapija
[ucitano] Plate
[ucitano] 112 kontejnera
[ucitano] 5 platformi
[ucitano] 46 farmi
[ucitano] 20 bankomata
[ucitano] 24 gps lokacija
Naslov: Odg: mysql
Poruka od: Ghetoven poslato Decembar 03, 2021, 13:13:20 POSLE PODNE
Citat: Iv0r_. poslato Decembar 03, 2021, 12:52:07 POSLE PODNE
Jesu... tocni su.. Pogledaj...
Ovako je definisano u skripti...
[pawn]//=================================[ MySql ]====================================

#define kucni

#if defined kucni
    #define MYSQL_HOST "localhost"
   #define MYSQL_USER "root"
   #define MYSQL_PASS ""
   #define MYSQL_DB "kurac"
#else
    #define MYSQL_HOST "localhost"
   #define MYSQL_USER "root"
   #define MYSQL_PASS ""
   #define MYSQL_DB "kurac"
#endif

new _dbConnector, sql_str[ 128 ];

//==================================[ Igraci ]==================================[/pawn]
Otisao sam napravit novu bazu u mysql phpmyadmin i kliknio Novo -> kurac -> otisao import -> kliknio na pregledaj i štiklirao mod -> I onda je pisalo ono zeleno, desno vidim sve kreirano -> Pokrenem samp-server.exe i pise ovo.

Pa sad bi prema svemu moralo da radi, povezan si na bazu, nemas query errore vise, jesi pokusao sad da udes?
Naslov: Odg: mysql
Poruka od: Iv0r_. poslato Decembar 03, 2021, 13:35:19 POSLE PODNE
Citat: Ghetoven poslato Decembar 03, 2021, 13:13:20 POSLE PODNE
Pa sad bi prema svemu moralo da radi, povezan si na bazu, nemas query errore vise, jesi pokusao sad da udes?
Ne radi.. pustim da ucita ovo ono [ucitano]
Kad dodje do [organizacije]
Udjem i nakon 10 sec pise server closed the connection
Naslov: Odg: mysql
Poruka od: noddy_ poslato Decembar 03, 2021, 13:38:50 POSLE PODNE
Citat: Iv0r_. poslato Decembar 03, 2021, 13:35:19 POSLE PODNE
Ne radi.. pustim da ucita ovo ono [ucitano]
Kad dodje do [organizacije]
Udjem i nakon 10 sec pise server closed the connection
Sacekaj da sve ucita, i u mene na MW modu ucita org i tek nakon nekoliko ucita dalje...
Naslov: Odg: mysql
Poruka od: Ghetoven poslato Decembar 03, 2021, 13:39:01 POSLE PODNE
Mozda imas nepotpunu bazu ili nesto. pokusaj ovako da uploadas bazu https://www.youtube.com/watch?v=7WUw9J3Xs8Q (https://www.youtube.com/watch?v=7WUw9J3Xs8Q) , ako nece posalji ovamo bazu preko pastebina da vidimo
Naslov: Odg: mysql
Poruka od: Iv0r_. poslato Decembar 03, 2021, 14:08:43 POSLE PODNE
Citat: Ghetoven poslato Decembar 03, 2021, 13:39:01 POSLE PODNE
Mozda imas nepotpunu bazu ili nesto. pokusaj ovako da uploadas bazu https://www.youtube.com/watch?v=7WUw9J3Xs8Q (https://www.youtube.com/watch?v=7WUw9J3Xs8Q) , ako nece posalji ovamo bazu preko pastebina da vidimo
moze :D poslat cu nije problem.
Citat: ɴᴏᴅɪ poslato Decembar 03, 2021, 13:38:50 POSLE PODNE
Sacekaj da sve ucita, i u mene na MW modu ucita org i tek nakon nekoliko ucita dalje...
Meni ucitava [ucitano] 18 organizacija i stoji ? Ocel bit nesto kasnije..
Naslov: Odg: mysql
Poruka od: Ghetoven poslato Decembar 03, 2021, 14:37:19 POSLE PODNE
Citat: Iv0r_. poslato Decembar 03, 2021, 14:08:43 POSLE PODNE
moze :D poslat cu nije problem.Meni ucitava [ucitano] 18 organizacija i stoji ? Ocel bit nesto kasnije..

moguce je i da je ukljucen debug kod mysqla ? jer nekad davno imo sam isti problem xD pogledaj imas li pod OnGamemodeInit mysql_log(LOG_ERROR | LOG_WARNING); (ovo je za Blueg 39-6), posto zna da se desi da bude i debug pa ti pokazuje detaljno sva ucitavanja i sve
Naslov: Odg: mysql
Poruka od: Iv0r_. poslato Decembar 03, 2021, 15:24:54 POSLE PODNE
Citat: Ghetoven poslato Decembar 03, 2021, 14:37:19 POSLE PODNE
moguce je i da je ukljucen debug kod mysqla ? jer nekad davno imo sam isti problem xD pogledaj imas li pod OnGamemodeInit mysql_log(LOG_ERROR | LOG_WARNING); (ovo je za Blueg 39-6), posto zna da se desi da bude i debug pa ti pokazuje detaljno sva ucitavanja i sve
Gdje tocno da vidim. Mislis u skripti ? I onaj pastebin? Sta da posaljem u pastebinu?
Citat: Iv0r_. poslato Decembar 03, 2021, 14:08:43 POSLE PODNE
moze :D poslat cu nije problem.Meni ucitava [ucitano] 18 organizacija i stoji ? Ocel bit nesto kasnije..
Ovako sam pokusao... isto je...
Ne zeli, prvo sam bio skinio jedan mod... Bio je na anonymous files... Onda je jedan lik napisao da su na tom nesto sjebali kako ne bi radilo. Dao je novi dl link i ovaj lik kome nije radilo sa anonymous files-a, napisao Majke mi, radi.. I onda sam ja skinio to di mu radio isto je koristio taj mod i meni sada ne radi....
Naslov: Odg: mysql
Poruka od: noddy_ poslato Decembar 03, 2021, 15:39:19 POSLE PODNE
A cek, koji mod koristis?
Naslov: Odg: mysql
Poruka od: Iv0r_. poslato Decembar 03, 2021, 15:43:37 POSLE PODNE
Citat: ɴᴏᴅɪ poslato Decembar 03, 2021, 15:39:19 POSLE PODNE
A cek, koji mod koristis?
mw
Naslov: Odg: mysql
Poruka od: _cameex1 poslato Decembar 03, 2021, 17:25:20 POSLE PODNE
Citat: Iv0r_. poslato Decembar 03, 2021, 13:35:19 POSLE PODNE
Ne radi.. pustim da ucita ovo ono [ucitano]
Kad dodje do [organizacije]
Udjem i nakon 10 sec pise server closed the connection
pospe tpga ti ide ucitavanje drug labs posle org ucitavanja sacekaj jos 2-3min il ocisti drug labs iz baze. A moja ti je preporuka da bazu full ocistis!
Naslov: Odg: mysql
Poruka od: Iv0r_. poslato Decembar 03, 2021, 17:36:51 POSLE PODNE
Citat: _cameex1 poslato Decembar 03, 2021, 17:25:20 POSLE PODNE
pospe tpga ti ide ucitavanje drug labs posle org ucitavanja sacekaj jos 2-3min il ocisti drug labs iz baze. A moja ti je preporuka da bazu full ocistis!
Pokusat cu ostavit 10-ak min da se ucitava. Ali ako cijelu bazu full ocistim otici ce imovina i moram sve radit..
Naslov: Odg: mysql
Poruka od: schatzi poslato Decembar 03, 2021, 18:36:50 POSLE PODNE
Ne zna do sada nisam imao takvih probelma
Naslov: Odg: mysql
Poruka od: Bit Frosty poslato Decembar 03, 2021, 18:42:01 POSLE PODNE
Citat: Iv0r_. poslato Decembar 03, 2021, 17:36:51 POSLE PODNE
Pokusat cu ostavit 10-ak min da se ucitava. Ali ako cijelu bazu full ocistim otici ce imovina i moram sve radit..
Pa pod jedan, niko te ne tera da imas istu bazu za test i live. Obicno ljudi smanje sve zivo za test, dok samo na live imaju full. Jedini slicaj kada hoces da imas pun kurac svega na localhost je kada radis stress test...
Naslov: Odg: mysql
Poruka od: noddy_ poslato Decembar 03, 2021, 19:35:12 POSLE PODNE
Citat: Iv0r_. poslato Decembar 03, 2021, 15:43:37 POSLE PODNE
mw
Probaj sa MW-om koji je trenutno na BS-u, ziv zdrav prav
Naslov: Odg: mysql
Poruka od: Iv0r_. poslato Decembar 03, 2021, 21:14:06 POSLE PODNE
Citat: %u0274%u1D0F%u1D05%u026A poslato Decembar 03, 2021, 19:35:12 POSLE PODNE
Probaj sa MW-om koji je trenutno na BS-u, ziv zdrav prav
Da li je to MW 2.0.0 ? Ovaj od Lanmi-a?
Citat: Deleted User poslato Decembar 03, 2021, 18:42:01 POSLE PODNE
Pa pod jedan, niko te ne tera da imas istu bazu za test i live. Obicno ljudi smanje sve zivo za test, dok samo na live imaju full. Jedini slicaj kada hoces da imas pun kurac svega na localhost je kada radis stress test...
Da stavim onda
[pawn]//=================================[ MySql ]====================================

#define kucni

#if defined kucni
    #define MYSQL_HOST "localhost"
   #define MYSQL_USER "root"
   #define MYSQL_PASS ""
   #define MYSQL_DB "kurac"
#else
    #define MYSQL_HOST "localhost"
   #define MYSQL_USER "root"
   #define MYSQL_PASS ""
   #define MYSQL_DB "kurcina"
#endif

new _dbConnector, sql_str[ 128 ];

//==================================[ Igraci ]==================================[/pawn]
Jel Valja?
BTW @Ghetoven ne mogu paste-at bazu na pastebin iz razloga tog sto je maksimum velicina 512 KB.
Naslov: Odg: mysql
Poruka od: Ghetoven poslato Decembar 03, 2021, 22:50:11 POSLE PODNE
Citat: Iv0r_. poslato Decembar 03, 2021, 21:14:06 POSLE PODNE
Da li je to MW 2.0.0 ? Ovaj od Lanmi-a?Da stavim onda
[pawn]//=================================[ MySql ]====================================

#define kucni

#if defined kucni
    #define MYSQL_HOST "localhost"
   #define MYSQL_USER "root"
   #define MYSQL_PASS ""
   #define MYSQL_DB "kurac"
#else
    #define MYSQL_HOST "localhost"
   #define MYSQL_USER "root"
   #define MYSQL_PASS ""
   #define MYSQL_DB "kurcina"
#endif

new _dbConnector, sql_str[ 128 ];

//==================================[ Igraci ]==================================[/pawn]
Jel Valja?
BTW @Ghetoven ne mogu paste-at bazu na pastebin iz razloga tog sto je maksimum velicina 512 KB.

sendspace onda, pa mi salji priv
Naslov: Odg: mysql
Poruka od: _cameex1 poslato Decembar 03, 2021, 23:10:27 POSLE PODNE
Citat: Iv0r_. poslato Decembar 03, 2021, 17:36:51 POSLE PODNE
Pokusat cu ostavit 10-ak min da se ucitava. Ali ako cijelu bazu full ocistim otici ce imovina i moram sve radit..
Napravis bazu ta live server (gdje je sve kreirano)
Napravis bazu za testnserver i tj to. Jer ima mnogo podataka i sporo ucitava je na test server (windows) a na lumix-u je to drugacije. Bas sam skoro radio na tim modu i sve mi je normalno radilo i ucitavalo... javi mi se Cameex Scripts na FB pa cu ti uci anydesk cim dodjem sutra sa posla GL.
Naslov: Odg: mysql
Poruka od: xLanmi poslato Decembar 03, 2021, 23:46:27 POSLE PODNE
Da bi brze na kucnom windows serveru ucitao bazu:
LOG_ERROR...
Nikako LOG_ALL.
I server se starta automatski odmah, nije poenta kolika je BAZA, vec sta ispisujes u mysql-logu :)
Naslov: Odg: mysql
Poruka od: Iv0r_. poslato Decembar 04, 2021, 11:55:52 PRE PODNE
Citat: xLanmi poslato Decembar 03, 2021, 23:46:27 POSLE PODNE
Da bi brze na kucnom windows serveru ucitao bazu:
LOG_ERROR...
Nikako LOG_ALL.
I server se starta automatski odmah, nije poenta kolika je BAZA, vec sta ispisujes u mysql-logu :)
Imas li FB?