Balkan SA:MP

Problem(error/warning): Mod je u mysql lepo je povezan sa databazom ali imam problem kad ulazim na kucni server nece da se pokrene reg/log sistem samo osttane ono kao sto cete imati dole u slici
Dio skripte: [ pawn ] ako bude bilo potrebe pitajte sta vam znaci kako bi pomogli [ /pawn ]
Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log): [ code ]Nema nikakvih problema u server_log pregledao sam[ /code ]
Slika/video ingame problema(obavezno ako je ingame problem): https://imgur.com/a/GDPaOW0

Pogledaj mysql log, vise njih je imalo problema oko tog moda, cini mi se da nije sve u `users` table dodato, fali jos nesto

Citat: Emmett poslato April 15, 2020, 02:51:50 PRE PODNE
Pogledaj mysql log, vise njih je imalo problema oko tog moda, cini mi se da nije sve u `users` table dodato, fali jos nesto

[pawn][23:43:53 04/14/20] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[23:43:57 04/14/20] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[23:43:57 04/14/20] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[23:51:35 04/14/20] [ERROR] CMySQLQuery::Execute[CheckPlayerAccount] - (error #1054) Unknown column 'xTogStats' in 'field list' (Query: "SELECT `registered`, `password`, `user_id`, `level`, `exp`, `xOnlineSati`, `country`, `money`, `xBRacun`, `job_id`, `contract`, `skin_id`, `warn`, `admin_lvl`, `helper_level`, `xTestAdmin`, `vip_level`, `v_poen`, `xVCoin`, `xTogStats` FROM `users` WHERE `p_name` = 'Deniro_Houston' LIMIT 1")
[23:53:15 04/14/20] [ERROR] CMySQLQuery::Execute[CheckPlayerAccount] - (error #1054) Unknown column 'xTogStats' in 'field list' (Query: "SELECT `registered`, `password`, `user_id`, `level`, `exp`, `xOnlineSati`, `country`, `money`, `xBRacun`, `job_id`, `contract`, `skin_id`, `warn`, `admin_lvl`, `helper_level`, `xTestAdmin`, `vip_level`, `v_poen`, `xVCoin`, `xTogStats` FROM `users` WHERE `p_name` = 'Deniro_Houston' LIMIT 1")
[00:06:40 04/15/20] [ERROR] CMySQLQuery::Execute[CheckPlayerAccount] - (error #1054) Unknown column 'xTogStats' in 'field list' (Query: "SELECT `registered`, `password`, `user_id`, `level`, `exp`, `xOnlineSati`, `country`, `money`, `xBRacun`, `job_id`, `contract`, `skin_id`, `warn`, `admin_lvl`, `helper_level`, `xTestAdmin`, `vip_level`, `v_poen`, `xVCoin`, `xTogStats` FROM `users` WHERE `p_name` = 'Deniro_Houston' LIMIT 1")
[00:07:27 04/15/20] [ERROR] CMySQLQuery::Execute[CheckPlayerAccount] - (error #1054) Unknown column 'xTogStats' in 'field list' (Query: "SELECT `registered`, `password`, `user_id`, `level`, `exp`, `xOnlineSati`, `country`, `money`, `xBRacun`, `job_id`, `contract`, `skin_id`, `warn`, `admin_lvl`, `helper_level`, `xTestAdmin`, `vip_level`, `v_poen`, `xVCoin`, `xTogStats` FROM `users` WHERE `p_name` = 'Deniro_Houston' LIMIT 1")
[00:09:28 04/15/20] [ERROR] CMySQLQuery::Execute[CheckPlayerAccount] - (error #1054) Unknown column 'xTogStats' in 'field list' (Query: "SELECT `registered`, `password`, `user_id`, `level`, `exp`, `xOnlineSati`, `country`, `money`, `xBRacun`, `job_id`, `contract`, `skin_id`, `warn`, `admin_lvl`, `helper_level`, `xTestAdmin`, `vip_level`, `v_poen`, `xVCoin`, `xTogStats` FROM `users` WHERE `p_name` = 'Deniro_Houston' LIMIT 1")
[00:14:21 04/15/20] [ERROR] CMySQLQuery::Execute[CheckPlayerAccount] - (error #1054) Unknown column 'xTogStats' in 'field list' (Query: "SELECT `registered`, `password`, `user_id`, `level`, `exp`, `xOnlineSati`, `country`, `money`, `xBRacun`, `job_id`, `contract`, `skin_id`, `warn`, `admin_lvl`, `helper_level`, `xTestAdmin`, `vip_level`, `v_poen`, `xVCoin`, `xTogStats` FROM `users` WHERE `p_name` = 'Deniro_Houston' LIMIT 1")[/pawn]
Evo ti mysql log pogledaj

Fali ti column xTogStats u tablici users, kreiraj ga.
Mozes preko phpmyadmin-a ili ako kreiras tablicu u skripti samo dodaj da ti kreira xTogStats.

Citat: Sploxs poslato April 15, 2020, 14:29:46 POSLE PODNE
Fali ti column xTogStats u tablici users, kreiraj ga.
Mozes preko phpmyadmin-a ili ako kreiras tablicu u skripti samo dodaj da ti kreira xTogStats.

Mozes da mi objasnis kako da kreiram to

Skines xxamp.
Pokrenes MySQL
Povezes bazu.. Imas tutoriale.

Udjes u bazu i nadjes tabelu igraci, players ne znam kako je kod tebe
Ides Structure
Onda imas dole ovo https://prnt.sc/rzz62h
Odaberes koliko ces struktura da dodas, i onda ides GO.
Onda ti izbaci ovo https://prnt.sc/rzz6mg
Onda ukucas to tvoje xTogStats, Stavis INT i SAVE.

Citat: .agency poslato April 15, 2020, 19:02:25 POSLE PODNE
Skines xxamp.
Pokrenes MySQL
Povezes bazu.. Imas tutoriale.

Udjes u bazu i nadjes tabelu igraci, players ne znam kako je kod tebe
Ides Structure
Onda imas dole ovo https://prnt.sc/rzz62h
Odaberes koliko ces struktura da dodas, i onda ides GO.
Onda ti izbaci ovo https://prnt.sc/rzz6mg
Onda ukucas to tvoje xTogStats, Stavis INT i SAVE.

Hvala brt reseno,malo se slabo snalazim u mysql al za sve postoji prvi put