[ixesas]

Hello, so I had server without mysql for a long time, yesterday I installed mysql, little bit updated my server and have a problem now..

When player joins, server crashes. I don't understand where's the problem, all plugins, includes, filterscripts working just FINE.

Server log:
[23:32:27] [join] Donuts has joined the server (14:91.187.172.136)
Server crashes...

[22:29:24] [join] hah has joined the server (3:78.61.79.170)
Server crashes...

[22:24:32] [join] RudyGEY has joined the server (11:78.61.155.101)
Server crashes...

Maybe this is some server crasher or something?

[Ha$H_Sexyboy]

Nah,filter script failure try 2 install crash detect and paste the log again

[ixesas]

Quote:

Originally Posted by Ha$H_Sexyboy Nah,filter script failure try 2 install crash detect and paste the log again

Just installed crashdetect, waiting for server to crash.

[ixesas]

Aight.. Server got crashed, here's crash log:

PHP код:

[16:54:18] [debug] Server crashed while executing tkadmin.amx
[16:54:18] [debug] AMX backtrace:
[16:54:18] [debug] #0 native mysql_fetch_field_row () [b744e7a0] from mysql.so
[16:54:18] [debug] #1 00023588 in ?? (0x00000009) from tkadmin.amx
[16:54:18] [debug] #2 000042a4 in public Itter_OnPlayerConnect (0x00000009) from tkadmin.amx
[16:54:18] [debug] #3 native CallLocalFunction () [080d2870] from samp03svr
[16:54:18] [debug] #4 00000ed4 in public SSCANF_OnPlayerConnect (0x00000009) from tkadmin.amx
[16:54:18] [debug] #5 00000d48 in public Streamer_OnPlayerConnect (0x00000009) from tkadmin.amx
[16:54:18] [debug] #6 native CallLocalFunction () [080d2870] from samp03svr
[16:54:18] [debug] #7 000005a8 in public OnPlayerConnect (0x00000009) from tkadmin.amx 


tkadmin OnPlayerConnect callback:

PHP код:

public OnPlayerConnect(playerid)
{
    seconds[playerid] = 0;
   
    Pkickas[playerid] = 0;
   
    PlayerInfo[playerid][Muted] = false;
    PlayerInfo[playerid][MuteTimer] = -1;
    PlayerInfo[playerid][Warnings] = 0;
    //-------------------
    gotost[playerid] = 1;
    label[playerid] = 0;
    duty[playerid] = 0;
    RemoveDefaultObjects(playerid);
    clubAccess[playerid] = false;
    bancheck(playerid);
    GetPlayerIp(playerid, PIP, 18);
    format(Query, sizeof(Query), "SELECT * FROM `playerinfo` WHERE `user` = '%s' LIMIT 1", escpname(playerid), PIP);
    mysql_query(Query);
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        new PIP2[18];
          mysql_fetch_field_row(PIP2, "IP");
        if(!strcmp(PIP, PIP2, true) && strlen(PIP2) != 0)
        {
            SetPVarInt(playerid, "Logged", 1);
            SendClientMessage(playerid, COLOR_GREEN, "[VARTOTOJAS]: "grey"Jыs buvote prijungtas automatiрkai!");
              if(mysql_fetch_row(line))
              {
                new data[3][55];
                new data2[7];
                  sscanf(line, "p<|>s[50]s[300]dddds[50]ddds[100]", data[0], largestring, data2[0], data2[1], data2[2], data2[3], data[2], data2[4], data2[5], data2[6], estring);
                  stringempty(estring);
                  stringempty(largestring);
                  SetPVarInt(playerid, "Kills", data2[0]);
                  SetPVarInt(playerid, "Logged", 1);
                  SetPVarInt(playerid, "Deaths", data2[1]);
                  SetPlayerScore(playerid, data2[2]);
                  GivePlayerMoney(playerid, data2[3]);
                  SetPVarInt(playerid, "AdminLevel", data2[4]);
                  SetPVarInt(playerid, "VIPLevel", data2[5]);
                  SetPVarInt(playerid, "Taskai", data2[6]);
                  mysql_free_result();
              }
          }
          else
          {
            SendClientMessage(playerid, COLOR_GREEN, "[VARTOTOJAS]: "grey"Jыsш vartotojas registruotas duomenш bazлje.");
            SendClientMessage(playerid, COLOR_GREEN, "[VARTOTOJAS]: "grey"Norлdami gauti leidimа юaisti, praрome prisijungti prie sistemos.");
            ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT , ""lightblue"Prisijungimas", ""grey"Jыs nebuvote prijungtas automatiрkai, kadangi рis nustatymas "red"IРJUNGTAS"grey".\nNorлdami юaisti privalote prisijungti su registruotu slaptaюodюiu.", "Prisijungti", "Iseiti");
            TextDrawShowForPlayer(playerid, aTextdraw0);
            TextDrawShowForPlayer(playerid, aTextdraw1);
            TextDrawShowForPlayer(playerid, aTextdraw2);
            TextDrawShowForPlayer(playerid, aTextdraw3);
              TextDrawShowForPlayer(playerid, aTextdraw4);
              TextDrawShowForPlayer(playerid, aTextdraw5);
              TextDrawShowForPlayer(playerid, aTextdraw6);
              TextDrawShowForPlayer(playerid, aTextdraw7);
        }
    }
    else
    {
        SendClientMessage(playerid, COLOR_GREEN, "[VARTOTOJAS]: "grey"Jыsш vartotojas nлra uюregistruotas duomenш bazлje.");
          SendClientMessage(playerid, COLOR_GREEN, "[VARTOTOJAS]: "grey"Norлdami gauti leidimа pilnai юaisti mыsш serveryje, praрome uюregistruoti savo vartotojа.");
        ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT , ""lightblue"Registracija", ""grey"Jыs prisijungлte б serverб pirmа kartа, todлl nebuvote "red"PRIJUNGTAS"grey".\nNorлdami юaisti serveryje privalote uюregistruoti savo vartotojа duombazлje", "Registruotis", "Iseiti");
        TextDrawShowForPlayer(playerid, Textdraw0);
        TextDrawShowForPlayer(playerid, Textdraw1);
        TextDrawShowForPlayer(playerid, Textdraw2);
        TextDrawShowForPlayer(playerid, Textdraw3);
        TextDrawShowForPlayer(playerid, Textdraw4);
        TextDrawShowForPlayer(playerid, Textdraw5);
        TextDrawShowForPlayer(playerid, Textdraw6);
        TextDrawShowForPlayer(playerid, Textdraw7);
    }
    mysql_free_result();
    //------------------
    return 1;
}