Can't login to server, game stuck after typing password

Can't login to server, game stuck after typing password - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Can't login to server, game stuck after typing password (/showthread.php?tid=655486)

Can't login to server, game stuck after typing password - srisaikamal - 22.06.2018

I have a Gamemode. When i newly register in that server all the process going nice but when i relog into server and after typing password it stops there can't login into server. Only working for newly registered accounts.

Re: Can't login to server, game stuck after typing password - Exhibit - 22.06.2018

Show
The
Code.

Re: Can't login to server, game stuck after typing password - GTLS - 22.06.2018

I'm pretty sure its MySQL problem. Invalid value for a column or something. Show the logs. (Delete the old log file and let server create a new one.Post the new log created). You can also use Crashdetect to know more about the issue.

Re: Can't login to server, game stuck after typing password - srisaikamal - 23.06.2018

Here is some PHP code

PHP код:



public OnPlayerRequestClass(playerid, classid)

{

    if(PlayerInfo[playerid][pKicked]) return 0;

    if(IsPlayerNPC(playerid)) return 1;


    if(!PlayerInfo[playerid][pLogged])

    {

        ClearChat(playerid);


        TogglePlayerSpectating(playerid, 1);

        SetPlayerColor(playerid, 0xFFFFFF00);


        #if defined SERVER_INTRO

            ShowMainMenuCamera(playerid, 1);

        #else

            SetTimerEx("ShowMainMenuCamera", 400, false, "i", playerid);

        #endif

    }


    return 1;

}

When i change TogglePlayerSpectating from 1 to 0

PHP код:



TogglePlayerSpectating(playerid, 0);

i'm getting spawn option down to spawn in game. I think it's not the correct process. when i do this game running normally but no command are showing in server-log.txt like when we type /b or /help nothig showing in server-log.txt, i cant go admin duty and the server intro song coming continuously until the song ends and im not getting login message like if i was admin it should show adm:cmd kamal has logged in like that. I dont know what causing the problem

Re: Can't login to server, game stuck after typing password - Exhibit - 23.06.2018

PHP код:



public OnPlayerRequestClass(playerid, classid) 
{ 
    if(PlayerInfo[playerid][pKicked]) return SendClientMessage(playerid, -1, "Kicked by pKicked"); 
    if(IsPlayerNPC(playerid)) return 1; 

    if(!PlayerInfo[playerid][pLogged]) 
    { 
        ClearChat(playerid); 

        TogglePlayerSpectating(playerid, 1); 
        SetPlayerColor(playerid, 0xFFFFFF00); 

        #if defined SERVER_INTRO 
            ShowMainMenuCamera(playerid, 1); 
        #else 
            SetTimerEx("ShowMainMenuCamera", 400, false, "i", playerid); 
        #endif 
    } 

    return 1; 
}

Check if the sendclientmessage appears.

Re: Can't login to server, game stuck after typing password - srisaikamal - 23.06.2018

Same it shows nothing. Can't enter into game

Re: Can't login to server, game stuck after typing password - srisaikamal - 23.06.2018

I think this is due to MySQL database problem here is SQL logs

Код HTML:

[07:23:37] [ERROR] CMySQLConnection::Connect - (error #1049) Unknown database 'shoutcast'
[07:23:37] [ERROR] CMySQLConnection::Connect - (error #1049) Unknown database 'shoutcast'
[07:23:37] [ERROR] CMySQLConnection::Connect - (error #1049) Unknown database 'shoutcast'
[07:23:37] [ERROR] CMySQLConnection::Connect - (error #1049) Unknown database 'shoutcast'
[07:23:43] [ERROR] cache_get_field_content_int - invalid datatype
[07:23:43] [ERROR] cache_get_field_content_int - invalid datatype
[07:23:43] [ERROR] cache_get_field_content_int - invalid datatype
[07:23:43] [ERROR] cache_get_field_content_int - invalid datatype
[07:23:43] [ERROR] cache_get_field_content_int - invalid datatype
[07:23:43] [ERROR] cache_get_field_content_int - invalid datatype
[07:24:35] [ERROR] cache_get_field_content_int - invalid datatype

Re: Can't login to server, game stuck after typing password - GTLS - 24.06.2018

Yes. You will have to create the database on the host you used inside your string.

Re: Can't login to server, game stuck after typing password - srisaikamal - 24.06.2018

I didnt understand anything. The script and SQL server on same host and in server log it says server connected to SQL server can you explain me briefly. I dont know anything about SQL queries

Re: Can't login to server, game stuck after typing password - Verc - 24.06.2018

You should learn them before you start a script,the basic atleast,the mysql logs shows clearly that you have a database missing.