MYSQL problem

[©pawno]

Problem(error/warning): koristim mod V-Roleplay od Mumitze i spojio sam ga u bazu,sve okej i kada ulazim na server nece dalje od connecta

[19:15:57 01/01/20] [ERROR] CMySQLQuery::Execute[CheckPlayerAccount] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM `users` WHERE `p_name` = 'Pawno_Legacy' LIMIT 1' at line 1 (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` = 'Pawno_Legacy' LIMIT 1")

Dio skripte: MYSQL / pawno
Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log): //
Slika/video ingame problema(obavezno ako je ingame problem): SLIKA 1 SLIKA 2

[Salesman]

Zasto nisi stavio query:

SELECT * FROM users WHERE pname = 'Pawno_Legacy'

[©pawno]

@Salesman  nisam shvatio ?

[Salesman]

Probaj ovako:

SELECT * FROM users WHERE p_name = '%e' LIMIT 1

[©pawno]

Probaj ovako:

SELECT * FROM users WHERE p_name = '%e' LIMIT 1

[19:33:37 01/01/20] [ERROR] CMySQLQuery::Execute[CheckPlayerAccount] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SELECT * FROM users WHERE p_name = `Pawno_Legacy` LIMIT 1' at line 1 (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`, SELECT * FROM users WHERE p_name = `Pawno_Legacy` LIMIT 1")

[©pawno]

@Salesman  isto sve..

[Rejk.inc]

Fali ti 1 column u bazi...

Ubaci ovaj .sql fajl umjesto tog koji sada imas (copy,replace) i ponovo importuj bazu sa ovim .sql u phpmyadmin/mysql..

Link fixanog .sql-a: http://www.solidfiles.com/v/Y8mMvL3Y72j4j

[Salesman]

[19:33:37 01/01/20] [ERROR] CMySQLQuery::Execute[CheckPlayerAccount] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SELECT * FROM users WHERE p_name = `Pawno_Legacy` LIMIT 1' at line 1 (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`, SELECT * FROM users WHERE p_name = `Pawno_Legacy` LIMIT 1")

Wtf si ti druze uradio?
Evo ti cijeli query:

SELECT * FROM users WHERE p_name = '%e' LIMIT 1

Znaci ovo sto sam ti iznad napisao pises umjesto ovog tvog.

Da se nadovezem za decka prije mene. Nema nikakve veze sa columnom jer bi bacalo error za isti.

[©pawno]

Wtf si ti druze uradio?
Evo ti cijeli query:

SELECT * FROM users WHERE p_name = '%e' LIMIT 1

Znaci ovo sto sam ti iznad napisao pises umjesto ovog tvog.

Da se nadovezem za decka prije mene. Nema nikakve veze sa columnom jer bi bacalo error za isti.

to kad stavim server se ugasi.....
@Salesman

mysql_format(mSQL, str, sizeof(str),
										"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` = '%e' LIMIT 1", ImeIgraca(playerid));

	mysql_pquery(mSQL, str, "SELECT * FROM users WHERE p_name = `%e` LIMIT 1", "i", playerid);
	return(true);
}

[19:54:14 01/01/20] [ERROR] CMySQLQuery::Execute[SELECT * FROM users WHERE p_name = `%e` LIMIT 1] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM `users` WHERE `p_name` = 'Pawno_Legacy' LIMIT 1' at line 1 (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` = 'Pawno_Legacy' LIMIT 1")

[bunta]

ajde malo procitaj V Roleplay temu!

[Salesman]

to kad stavim server se ugasi.....
@Salesman

mysql_format(mSQL, str, sizeof(str),
										"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` = '%e' LIMIT 1", ImeIgraca(playerid));

	mysql_pquery(mSQL, str, "SELECT * FROM users WHERE p_name = `%e` LIMIT 1", "i", playerid);
	return(true);
}

[19:54:14 01/01/20] [ERROR] CMySQLQuery::Execute[SELECT * FROM users WHERE p_name = `%e` LIMIT 1] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM `users` WHERE `p_name` = 'Pawno_Legacy' LIMIT 1' at line 1 (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` = 'Pawno_Legacy' LIMIT 1")

mysql_format(mSQL, str, sizeof str, "SELECT * FROM users WHERE p_name = '%e' LIMIT 1", ImeIgraca(playerid));

	mysql_tquery(mSQL, str, "CheckPlayerData", "i", playerid);
	return(true);
}

EDIT: Bukvalno samo ides copy paste sad to sto sam ti napisao iznad.

[©pawno]

ajde malo procitaj V Roleplay temu!

sve već urađeno I iznad navedeno....

[Salesman]

Druze znaci uzmes ovo ispod sad sto ti pise "KOD ODABERI" kopiras i zamjenis umjesto svog i probas.

mysql_format(mSQL, str, sizeof str, "SELECT * FROM users WHERE p_name = `%e` LIMIT 1", ImeIgraca(playerid));

	mysql_tquery(mSQL, str, "CheckPlayerData", "i", playerid);
	return(true);
}

[©pawno]

mysql_format(mSQL, str, sizeof str, "SELECT * FROM users WHERE p_name = '%e' LIMIT 1", ImeIgraca(playerid));

	mysql_tquery(mSQL, str, "CheckPlayerData", "i", playerid);
	return(true);
}

EDIT: Bukvalno samo ides copy paste sad to sto sam ti napisao iznad.

I NIŠTA.

[Salesman]

Ništa? Nemoguce da je ništa sta ti izbacuje u logu lmao