Započeo [MG]uNiqu3
•30. Jan. 2014.• Zaključano[POMOC]MySQL
900
pregleda
4
postova
Enforcer
Balkan SA:MP
SA-MP Doprinos
Balkan SA:MP
SA-MP DoprinosNovi Član
90 / 100 XP
Početnik(0)
278
Postovi:
76
Teme:
Pridružio se:Nov. 2012
30. Jan. 2014.
Skripta koju koristim😮d 0
Detaljan opis problema😛a ne daje igracu dialog za register ili login !
Dio skripte:
Neke slike/video za lakse dobivanje pomoci(neobavezno):
CheckPlayer
onplayercon and onplayerdis
mysql_log.txt
Detaljan opis problema😛a ne daje igracu dialog za register ili login !
Dio skripte:
Neke slike/video za lakse dobivanje pomoci(neobavezno):
CheckPlayer
public CheckPlayer(playerid)
{
mysql_store_result();
if(mysql_num_rows() == 1)
{
format(string, sizeof(string), "Dobrodosli %s",GetName(playerid));
ShowPlayerDialog(playerid, 0, DIALOG_STYLE_PASSWORD, "Logiranje", string, "Ok", "Izlezi");
}
else
{
SetPVarInt(playerid, "WrongPassword", GetPVarInt(playerid, "WrongPassword") + 1);
if(GetPVarInt(playerid, "WrongPassword") == 3)
{
return Kick(playerid);
}
format(string, sizeof(string), "Dobrodosli %s",GetName(playerid));
ShowPlayerDialog(playerid, 1, DIALOG_STYLE_PASSWORD, "Registracija", string, "Ok", "Izlezi");
}
mysql_free_result();
return 1;
}onplayercon and onplayerdis
public OnPlayerConnect(playerid)
{
mysql_format(gConnectionHandle, Query, "SELECT * FROM 'users' WHERE Username = '%e'",GetName(playerid));
mysql_function_query(gConnectionHandle, Query, false, "CheckPlayer", "d", playerid);
return 1;
}
public OnPlayerDisconnect(playerid)
{
mysql_format(gConnectionHandle, Query, "UPDATE 'users' SET 'Money' = %d, 'Level' = %d, 'Admin' = %d, 'Kills' = %d, 'Deaths' = %d WHERE Username = '%e'", GetPlayerMoney(playerid), GetPlayerScore(playerid), PlayerInfo, PlayerInfo, PlayerInfo, GetName(playerid));
mysql_function_query(gConnectionHandle, Query, false, "OnQuaryFinish", "s", Query);
return 1;
}
mysql_log.txt
[13:49:06] >> mysql_connect(localhost, root, megagaming, ******) on port 3306
[13:49:06] CMySQLHandler::CMySQLHandler() - constructor called.
[13:49:06] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "megagaming" | Username: "root"
[13:49:06] CMySQLHandler::Connect() - Connection was successful.
[13:49:06] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[13:49:27] >> mysql_format( Connection handle: 1 )
[13:49:27] CMySQLHandler::EscapeString(Tommy_Harrison2); - Escaped 15 characters to Tommy_Harrison2.
[13:49:27] >> mysql_query_callback( Connection handle: 1 )
[13:49:27] Passing query SELECT * FROM 'users' WHERE Username = 'Tommy_Harrison2' | d
[13:49:27] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[13:49:35] >> mysql_format( Connection handle: 1 )
[13:49:36] CMySQLHandler::EscapeString(Tommy_Harrison2); - Escaped 15 characters to Tommy_Harrison2.
[13:49:36] >> mysql_query_callback( Connection handle: 1 )
[13:49:36] Passing query UPDATE 'users' SET 'Money' = 0, 'Level' = 0, 'Admin' = 0, 'Kills' = 0, 'Deaths' = 0 WHERE Username = 'Tommy_Harrison2' | s
[13:49:36] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()Enforcer
Balkan SA:MP
SA-MP Doprinos
Balkan SA:MP
SA-MP DoprinosNovi Član
90 / 100 XP
Početnik(0)
278
Postovi:
76
Teme:
Pridružio se:Nov. 2012
30. Jan. 2014.
Ja sam radio ovo od 0 tut od system32(64) e sada ne daje mi dialog za loginu dali moze databaza da se zove drugacije posto ja imam drugacija data baza od 0sa drugonm imenom
Morate biti prijavljeni da biste odgovorili na ovu temu.
Prijava