Oko MySQL

Započeo .ysi

•21. Feb. 2022.

746

pregleda

postova

.ysi

Enforcer

Novi Član

90 / 100 XP

Početnik(0)

203

Postovi:

Teme:

Pridružio se:Jul 2020

21. Feb. 2022.

Problem(error/warning): Prvi put se susrecem sa MySQL...znc pravioo sam login register sys i sve radi ovako in game ali nece login da pojasnim kada prvi put udjem na srw pise register kada drugi put udjem pise opet register nece nikako login...
Deo skripte:

Ostavljam cijelu skriptu: https://pastebin.com/v3Sh6SAy

Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log):

Evo errori iz logs / errors 

[19:51:41] [plugins/mysql] error #1054 while executing query "INSERT INTO `users` (`Username`, `Password`, `Score`, `Kills`, `Cash`, `Deaths`)VALUES ('Joz', '5E4B1B691E8E464E5C9D219D5499C66C77C74D4E185492B78233A66119D28EDB','0', '0', '0', '0')": Unknown column 'Kills' in 'field list'
[19:51:51] [plugins/mysql] error #1054 while executing query "UPDATE `users` SET `Score` = 0, `Cash` = 0, `Kills` = 0, `Deaths` = 0 WHERE `ID` = 0 LIMIT 1": Unknown column 'Cash' in 'field list'
[19:52:20] [plugins/mysql] error #1054 while executing query "INSERT INTO `users` (`Username`, `Password`, `Score`, `Kills`, `Cash`, `Deaths`)VALUES ('Joz', '5E4B1B691E8E464E5C9D219D5499C66C77C74D4E185492B78233A66119D28EDB','0', '0', '0', '0')": Unknown column 'Kills' in 'field list'
[19:52:24] [plugins/mysql] error #1054 while executing query "UPDATE `users` SET `Score` = 0, `Cash` = 0, `Kills` = 0, `Deaths` = 0 WHERE `ID` = 0 LIMIT 1": Unknown column 'Cash' in 'field list'
[19:52:50] [plugins/mysql] error #1054 while executing query "INSERT INTO `users` (`Username`, `Password`, `Score`, `Kills`, `Cash`, `Deaths`)VALUES ('Joz', '5E4B1B691E8E464E5C9D219D5499C66C77C74D4E185492B78233A66119D28EDB','0', '0', '0', '0')": Unknown column 'Kills' in 'field list'
[19:53:06] [plugins/mysql] error #1054 while executing query "UPDATE `users` SET `Score` = 0, `Cash` = 0, `Kills` = 0, `Deaths` = 0 WHERE `ID` = 0 LIMIT 1": Unknown column 'Cash' in 'field list'

Slika/video ingame problema(obavezno ako je ingame problem): //

Bit Frosty

Kingpin

Novi Član

240 / 250 XP

Početnik(0)

1,136

Postovi:

Teme:

Pridružio se:Maj 2015

21. Feb. 2022.

Pa naucite vise da citate sta pise...Razumem da ti kaze neki nepoznat error koji se moze tumaciti na vise nacina ali kad ti lepo kaze...

Cash nemas u tabeli...

ʟᴀᴋᴇʀɪɴɢ

Made Man

Novi Član

69 / 100 XP

Početnik(0)

352

Postovi:

Teme:

Pridružio se:Apr. 2021

21. Feb. 2022.

 Unknown column 'Kills' in 'field list'
Unknown column 'Cash' in 'field list'

.ysi

Enforcer

Novi Član

90 / 100 XP

Početnik(0)

203

Postovi:

Teme:

Pridružio se:Jul 2020

21. Feb. 2022.

Deleted User wrote on February 21, 2022, 7:07 pm:

Pa naucite vise da citate sta pise...Razumem da ti kaze neki nepoznat error koji se moze tumaciti na vise nacina ali kad ti lepo kaze...

Cash nemas u tabeli...

Kojoj tabeli ? Gdje trebam dodati ?

Muma

Forum Don

Aktivan Član

119 / 250 XP

Početnik(2)

10,490

Postovi:

765

Teme:

Pridružio se:Maj 2015

21. Feb. 2022.

Sync wrote on February 21, 2022, 7:10 pm:

Kojoj tabeli ? Gdje trebam dodati ?

users

.ysi

Enforcer

Novi Član

90 / 100 XP

Početnik(0)

203

Postovi:

Teme:

Pridružio se:Jul 2020

21. Feb. 2022.

'xza wrote on February 21, 2022, 7:32 pm:

users

ja users vidim samo


public OnPlayerConnect(playerid) {
	GameTextForPlayer(playerid, "~p~Ucitavanje servera,molimo sacekajte", 5, 6);
	new DB_Query;
	GetPlayerName(playerid, PI, MAX_PLAYER_NAME);
	mysql_format(Database, DB_Query, sizeof(DB_Query), "SELECT * FROM `users` WHERE `Username` = '%e' LIMIT 1", PI);
	mysql_tquery(Database, DB_Query, "OnPlayerDataCheck", "i", playerid);
	//++
	PogresnaLozinka = 0;
	return (true);
}


else {
				new DB_Query;
				SHA256_PassHash(inputtext, GetName(playerid), PI, 65);
		    	mysql_format(Database, DB_Query, sizeof(DB_Query), "INSERT INTO `users` (`Username`, `Password`, `Score`, `Kills`, `Cash`, `Deaths`)\
		    	VALUES ('%e', '%s','0', '0', '0', '0')", PI, PI);
		    	mysql_tquery(Database, DB_Query);
		    	SetSpawnInfo(playerid, 0, 26, 1958.33, 1343.12, 15.36, 269.15, 0, 0, 0, 0, 0, 0);
		    	SpawnPlayer(playerid);
		    	SetPlayerScore(playerid, PI);
		    	GivePlayerMoney(playerid, PI);
			}

mysql_format(Database, DB_Query, sizeof(DB_Query),"SELECT * FROM `users` WHERE `Username` = '%e' LIMIT 1", PI);
		    	mysql_tquery(Database, DB_Query, "LoadAcc", "i", playerid);
		    	//++
		    	SetPlayerScore(playerid, PI);
		    	GivePlayerMoney(playerid, PI);
		    	SetSpawnInfo(playerid, 0,26,1328.1277,-1558.4608,13.5469, 139.9262, 0,0,0,0,0,0);
				SpawnPlayer(playerid);


stock SavePlayer(playerid) {
	new DB_Query;
	mysql_format(Database, DB_Query, sizeof(DB_Query), "UPDATE `users` SET `Score` = %d, `Cash` = %d, `Kills` = %d, `Deaths` = %d WHERE `ID` = %d LIMIT 1",
	PI, PI, PI, PI, PI);
	mysql_tquery(Database, DB_Query);
	return (true);
}

V01D

Godfather

Aktivan Član

17 / 250 XP

Početnik(1)

2,272

Postovi:

Teme:

Pridružio se:Maj 2014

21. Feb. 2022.

U mysql tabeli na phpmyadmin moras da dodas red Cash i Kills

.ysi

Enforcer

Novi Član

90 / 100 XP

Početnik(0)

203

Postovi:

Teme:

Pridružio se:Jul 2020

21. Feb. 2022.

V01D wrote on February 21, 2022, 8:42 pm:

U mysql tabeli na phpmyadmin moras da dodas red Cash i Kills

A kako dodati evo trazim pola sata opciju i nmg naci...?

Fr0z3n

Crime Lord

Novi Član

240 / 250 XP

Početnik(0)

964

Postovi:

Teme:

Pridružio se:Dec. 2019

21. Feb. 2022.

u bazi dodaj pa importuj bazu

ʟᴀᴋᴇʀɪɴɢ

Made Man

Novi Član

69 / 100 XP

Početnik(0)

352

Postovi:

Teme:

Pridružio se:Apr. 2021

22. Feb. 2022.

#10

Sync wrote on February 21, 2022, 9:40 pm:

A kako dodati evo trazim pola sata opciju i nmg naci...?

Pa kako si onda kreirao Password, Username i ostalo ?

.qua

Made Man

Novi Član

97 / 100 XP

Početnik(0)

490

Postovi:

Teme:

Pridružio se:Dec. 2019

22. Feb. 2022.

#11

trebas prvo napraviti bazu za mysql u phpmyadminu i kad si napravio bazu u users dodas cash kill i sta vec sve trebas

.ysi

Enforcer

Novi Član

90 / 100 XP

Početnik(0)

203

Postovi:

Teme:

Pridružio se:Jul 2020

24. Feb. 2022.

#12

Hvala rijeseno...lock

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava