[Ajuda] Problemas com MySQL

lucasms14

Eu estou fazendo um sistema de admin e estou quebrando a cabeça com a tela de login sobrepondo a dialog de ban do player. Basicamente anula esta dialog abaixo, me da kick e mostra a tela de login. Alguem sabe como posso fazer para resolver isto?

Código:
[color=#569cd6]    new[/color][color=#d4d4d4] query[[/color][color=#b5cea8]128[/color][color=#d4d4d4]];[/color]

[color=#d4d4d4]    [/color][color=#dcdcaa]format[/color][color=#d4d4d4](query, sizeof(query), [/color][color=#ce9178]"SELECT * FROM `banidos` WHERE `nome` = '%s'"[/color][color=#d4d4d4], [/color][color=#dcdcaa]PlayerName[/color][color=#d4d4d4](playerid));[/color]

[color=#d4d4d4]    [/color][color=#dcdcaa]mysql_query[/color][color=#d4d4d4](DBConn, query);[/color]

[color=#d4d4d4]    [/color][color=#c586c0]if[/color][color=#d4d4d4]([/color][color=#dcdcaa]cache_num_rows[/color][color=#d4d4d4]())[/color]

[color=#d4d4d4]    {[/color]

[color=#d4d4d4]        [/color][color=#569cd6]new[/color][color=#d4d4d4] str[[/color][color=#b5cea8]130[/color][color=#d4d4d4]], nomeadm[[/color][color=#b5cea8]20[/color][color=#d4d4d4]], motivo[[/color][color=#b5cea8]15[/color][color=#d4d4d4]];[/color]

[color=#d4d4d4]        [/color][color=#dcdcaa]cache_get_value_name[/color][color=#d4d4d4]([/color][color=#b5cea8]0[/color][color=#d4d4d4], [/color][color=#ce9178]"admin"[/color][color=#d4d4d4], nomeadm);[/color]

[color=#d4d4d4]        [/color][color=#dcdcaa]cache_get_value_name[/color][color=#d4d4d4]([/color][color=#b5cea8]0[/color][color=#d4d4d4], [/color][color=#ce9178]"motivo"[/color][color=#d4d4d4], motivo);[/color]

[color=#d4d4d4]        [/color]

[color=#d4d4d4]        [/color][color=#dcdcaa]strcat[/color][color=#d4d4d4](str, [/color][color=#ce9178]"[/color][color=#d7ba7d]\n[/color][color=#ce9178]ID {FF0000}"[/color][color=#d4d4d4]);[/color]

[color=#d4d4d4]        [/color][color=#dcdcaa]strcat[/color][color=#d4d4d4](str, PlayerData[playerid][accid]);[/color]

[color=#d4d4d4]        [/color][color=#dcdcaa]strcat[/color][color=#d4d4d4](str, [/color][color=#ce9178]"[/color][color=#d7ba7d]\n[/color][color=#ce9178]Conta {FF0000}"[/color][color=#d4d4d4]);[/color]

[color=#d4d4d4]        [/color][color=#dcdcaa]strcat[/color][color=#d4d4d4](str, [/color][color=#dcdcaa]PlayerName[/color][color=#d4d4d4](playerid));[/color]

[color=#d4d4d4]        [/color][color=#dcdcaa]strcat[/color][color=#d4d4d4](str, [/color][color=#ce9178]"[/color][color=#d7ba7d]\n[/color][color=#ce9178]Admin {FF0000}"[/color][color=#d4d4d4]);[/color]

[color=#d4d4d4]        [/color][color=#dcdcaa]strcat[/color][color=#d4d4d4](str, nomeadm);[/color]

[color=#d4d4d4]        [/color][color=#dcdcaa]strcat[/color][color=#d4d4d4](str, [/color][color=#ce9178]"[/color][color=#d7ba7d]\n[/color][color=#ce9178]Motivo {FF0000}"[/color][color=#d4d4d4]);[/color]

[color=#d4d4d4]        [/color][color=#dcdcaa]strcat[/color][color=#d4d4d4](str, motivo);[/color]

[color=#d4d4d4]        [/color][color=#dcdcaa]ShowPlayerDialog[/color][color=#d4d4d4](playerid, DIALOG_BANIDO, DIALOG_STYLE_MSGBOX, [/color][color=#ce9178]"Banido:"[/color][color=#d4d4d4], str,[/color][color=#ce9178]"Ok"[/color][color=#d4d4d4], [/color][color=#ce9178]""[/color][color=#d4d4d4]);[/color]

[color=#d4d4d4]        [/color][color=#dcdcaa]Kick[/color][color=#d4d4d4](playerid);[/color]

[color=#d4d4d4]        [/color][color=#c586c0]return[/color][color=#d4d4d4] [/color][color=#b5cea8]1[/color][color=#d4d4d4];[/color]

[color=#d4d4d4]    }[/color]

MateusCandido · 11/05/2021 11:59

(05/05/2021 13:37)lucasms14 Escreveu: Eu estou fazendo um sistema de admin e estou quebrando a cabeça com a tela de login sobrepondo a dialog de ban do player. Basicamente anula esta dialog abaixo, me da kick e mostra a tela de login. Alguem sabe como posso fazer para resolver isto?

Código:
[color=#569cd6] new[/color][color=#d4d4d4] query[[/color][color=#b5cea8]128[/color][color=#d4d4d4]];[/color] [color=#d4d4d4] [/color][color=#dcdcaa]format[/color][color=#d4d4d4](query, sizeof(query), [/color][color=#ce9178]"SELECT * FROM `banidos` WHERE `nome` = '%s'"[/color][color=#d4d4d4], [/color][color=#dcdcaa]PlayerName[/color][color=#d4d4d4](playerid));[/color] [color=#d4d4d4] [/color][color=#dcdcaa]mysql_query[/color][color=#d4d4d4](DBConn, query);[/color] [color=#d4d4d4] [/color][color=#c586c0]if[/color][color=#d4d4d4]([/color][color=#dcdcaa]cache_num_rows[/color][color=#d4d4d4]())[/color] [color=#d4d4d4] {[/color] [color=#d4d4d4] [/color][color=#569cd6]new[/color][color=#d4d4d4] str[[/color][color=#b5cea8]130[/color][color=#d4d4d4]], nomeadm[[/color][color=#b5cea8]20[/color][color=#d4d4d4]], motivo[[/color][color=#b5cea8]15[/color][color=#d4d4d4]];[/color] [color=#d4d4d4] [/color][color=#dcdcaa]cache_get_value_name[/color][color=#d4d4d4]([/color][color=#b5cea8]0[/color][color=#d4d4d4], [/color][color=#ce9178]"admin"[/color][color=#d4d4d4], nomeadm);[/color] [color=#d4d4d4] [/color][color=#dcdcaa]cache_get_value_name[/color][color=#d4d4d4]([/color][color=#b5cea8]0[/color][color=#d4d4d4], [/color][color=#ce9178]"motivo"[/color][color=#d4d4d4], motivo);[/color] [color=#d4d4d4] [/color] [color=#d4d4d4] [/color][color=#dcdcaa]strcat[/color][color=#d4d4d4](str, [/color][color=#ce9178]"[/color][color=#d7ba7d]\n[/color][color=#ce9178]ID {FF0000}"[/color][color=#d4d4d4]);[/color] [color=#d4d4d4] [/color][color=#dcdcaa]strcat[/color][color=#d4d4d4](str, PlayerData[playerid][accid]);[/color] [color=#d4d4d4] [/color][color=#dcdcaa]strcat[/color][color=#d4d4d4](str, [/color][color=#ce9178]"[/color][color=#d7ba7d]\n[/color][color=#ce9178]Conta {FF0000}"[/color][color=#d4d4d4]);[/color] [color=#d4d4d4] [/color][color=#dcdcaa]strcat[/color][color=#d4d4d4](str, [/color][color=#dcdcaa]PlayerName[/color][color=#d4d4d4](playerid));[/color] [color=#d4d4d4] [/color][color=#dcdcaa]strcat[/color][color=#d4d4d4](str, [/color][color=#ce9178]"[/color][color=#d7ba7d]\n[/color][color=#ce9178]Admin {FF0000}"[/color][color=#d4d4d4]);[/color] [color=#d4d4d4] [/color][color=#dcdcaa]strcat[/color][color=#d4d4d4](str, nomeadm);[/color] [color=#d4d4d4] [/color][color=#dcdcaa]strcat[/color][color=#d4d4d4](str, [/color][color=#ce9178]"[/color][color=#d7ba7d]\n[/color][color=#ce9178]Motivo {FF0000}"[/color][color=#d4d4d4]);[/color] [color=#d4d4d4] [/color][color=#dcdcaa]strcat[/color][color=#d4d4d4](str, motivo);[/color] [color=#d4d4d4] [/color][color=#dcdcaa]ShowPlayerDialog[/color][color=#d4d4d4](playerid, DIALOG_BANIDO, DIALOG_STYLE_MSGBOX, [/color][color=#ce9178]"Banido:"[/color][color=#d4d4d4], str,[/color][color=#ce9178]"Ok"[/color][color=#d4d4d4], [/color][color=#ce9178]""[/color][color=#d4d4d4]);[/color] [color=#d4d4d4] [/color][color=#dcdcaa]Kick[/color][color=#d4d4d4](playerid);[/color] [color=#d4d4d4] [/color][color=#c586c0]return[/color][color=#d4d4d4] [/color][color=#b5cea8]1[/color][color=#d4d4d4];[/color] [color=#d4d4d4] }[/color]

Provavelmente a ordem que você colocou o código no gamemode, você pode tentar ou invés de usar "return 1" usar "return Kick()" ou você pode colocar pra só mostrar o dialog de login caso não encontre o ban do jogador.

Obs: Este problema não esta relacionado ao MySQL é mais um erro na ordem do código.