[srisaikamal]

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.

[Exhibit]

Show
The
Code.

[GTLS]

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.

[srisaikamal]

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

[Exhibit]

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.

[srisaikamal]

Same it shows nothing. Can't enter into game

[srisaikamal]

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

[GTLS]

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

[srisaikamal]

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

[Verc]

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