mysql

Započeo Iv0r_., Decembar 01, 2021, 20:48:35 POSLE PODNE

prethodna tema - sledeća tema

0 članova i 5 gostiju pregledaju ovu temu.

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 [email protected] -> 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

"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
SPEED HACK (C++) https://github.com/nouddy/samp-speed-hack
Reliant GameMode (open.mp) https://github.com/nouddy/reliant-omp
SA:MP Landing Page https://github.com/nouddy/samp-landing-page


Kolko drama ima u 7 grama

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

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
SPEED HACK (C++) https://github.com/nouddy/samp-speed-hack
Reliant GameMode (open.mp) https://github.com/nouddy/reliant-omp
SA:MP Landing Page https://github.com/nouddy/samp-landing-page


Kolko drama ima u 7 grama

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...
Poslednja Izmena: Decembar 02, 2021, 18:51:07 POSLE PODNE od Iv0r_.


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]

Pa sve ti bukvalno pise, nisu tacni podatci za login na mysql bazu. Jesi compile mod ?

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

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

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?


[pawn]La vita E bella [/pawn]

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

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...
SPEED HACK (C++) https://github.com/nouddy/samp-speed-hack
Reliant GameMode (open.mp) https://github.com/nouddy/reliant-omp
SA:MP Landing Page https://github.com/nouddy/samp-landing-page


Kolko drama ima u 7 grama

Mozda imas nepotpunu bazu ili nesto. pokusaj ovako da uploadas bazu https://www.youtube.com/watch?v=7WUw9J3Xs8Q , ako nece posalji ovamo bazu preko pastebina da vidimo


[pawn]La vita E bella [/pawn]

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 , 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..