Skripta koju koristim:od 0
Detaljan opis problema:Pa 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[playerid][pAdmin], PlayerInfo[playerid][pKills], PlayerInfo[playerid][pDeaths], 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()
Pa jel imas bazu?
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
treba da moze