[POMOC]MySQL

Započeo [MG]uNiqu3
30. Jan. 2014. Zaključano
878
pregleda
4
postova
hristijan.kiki
4
Enforcer
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
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()
Kroni
5
Underboss
30. Jan. 2014.
Pa jel imas bazu?
hristijan.kiki
4
Enforcer
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
Kroni
5
Underboss
30. Jan. 2014.
treba da moze

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava

© 2026 SmartShark. All rights reserved.

Powered by Momentum|v2026.3.001 Alpha