[Jimmy0wns]

Tried loading the server MOTD and just can't get it working.

pawn Код:

stock InitializeServer()
{
    new Cache:result = mysql_query(MySQL_Connection, "SELECT * FROM `server` WHERE id = '1'");
    cache_get_field_content(0, "servermotd", ServerMOTD);
    cache_get_field_content(0, "setby", ServerMOTDby);
    cache_delete(result);
    return 1;
}

Checked multiple times, initializeserver is indeed being called.
Tried printing (debugging) and printed everything.
Tried printing the MOTD itself: empty.

[Misiur]

What does your mysql_log say?

[Jimmy0wns]

Quote:

Originally Posted by Misiur What does your mysql_log say?

No errors at all.

[Konstantinos]

After executing the query, print the number of rows using cache_num_rows so we can be sure there are some results.

[Jimmy0wns]

After doing some checks, I realized gamemodeinit gets called before main, my loading function was at gamemodeinit but my mysql initializes at main. I've put the mysql initialization at gamemode init and that worked.

- solved -