Oko MySQL

Započeo .ysi
21. Feb. 2022.
711
pregleda
12
postova
EmrahScript
4
Enforcer
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): //
NegativeIQ
5
Kingpin
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...
Lakering
4
Made Man
21. Feb. 2022.
 Unknown column 'Kills' in 'field list'
Unknown column 'Cash' in 'field list'
EmrahScript
4
Enforcer
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 Rascall
6
Forum Don
21. Feb. 2022.
Sync wrote on February 21, 2022, 7:10 pm:
Kojoj tabeli ? Gdje trebam dodati ?


users
EmrahScript
4
Enforcer
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);
}
Skrilew
6
Godfather
21. Feb. 2022.
U mysql tabeli na phpmyadmin moras da dodas red Cash i Kills
EmrahScript
4
Enforcer
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...?
Frozen_Capone
5
Crime Lord
21. Feb. 2022.
u bazi dodaj pa importuj bazu
Lakering
4
Made Man
22. Feb. 2022.
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 ?
Tomica26
4
Made Man
22. Feb. 2022.
trebas prvo napraviti bazu za mysql u phpmyadminu i kad si napravio bazu u users dodas cash kill i sta vec sve trebas
EmrahScript
4
Enforcer
24. Feb. 2022.
Hvala rijeseno...lock

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava

© 2026 SmartShark. All rights reserved.

Powered by Momentum|v2026.3.001 Alpha