Server make restart, when player log in.
#1

Hello!,

I don't undestand why this happend? When i go in server first time, i register and i get in server and play! But when i log out and go server aigan, then it says log in, and when i type my incorrect password, it says Wrong Password, but when i type correct password the server is restart.
SORRY FOR MY BAD ENGLISH, I HOPE YOUR UNDESTAND MY PROBLEM!
pawn Код:
// OnDialogResponse
if(dialogid == DIALOG_LOGIN)
    {
        if(!response)
        {
        SendClientMessage(playerid, V_PUNANE, "[VIGA]: Et mдngida, pead sa logima oma kasutajasse sisse!");
        SetTimerEx("ViskaKasutaja", 100, false, "i", playerid);
        }
        if(response)
        {
            new query[200], pname[24], escapepass[100];
            GetPlayerName(playerid, pname, 24);
            mysql_real_escape_string(inputtext, escapepass);
            format(query, sizeof(query), "SELECT `user` FROM playerdata WHERE user = '%s' AND password = SHA1('%s')", pname, escapepass);
            mysql_query(query);
            mysql_store_result();
            new numrows = mysql_num_rows();
            if(numrows == 1) MySQL_Login(playerid);
            if(!numrows)
            {
                new teade[128];
                GetPlayerName(playerid, pname, 24);
                format(teade, sizeof(teade), ""White"Tere tulemast tagasi "Red""SERVERI_NIMI""White"!\n"White"Selline kasutaja nagu %s eksisteerib andmebaasis!\n\n"White"Palun logi sisse, kirjutades alla lahtrisse "Red"oma"White" parool:", pname);
                ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, ""Blue"Logi sisse", teade, "Logi Sisse", "Tьhista");
                GameTextForPlayer(playerid,"~r~Vale parool!",2000,6);
            }
            mysql_free_result();
        }
    }
pawn Код:
// OnPlayerConnect
IsPlayerBanned(playerid);
    //================================================================//
    //                              MySQL part                        //
    //================================================================//
    MoneyGiven[playerid] = -1;
    JustLogged[playerid] = 0;
    new query[300], pname[24], teade[128];
    GetPlayerName(playerid, pname, 24);
    format(query, sizeof(query), "SELECT IP FROM `playerdata` WHERE user = '%s' LIMIT 1", pname);
    mysql_query(query);
    mysql_store_result();

    new rows = mysql_num_rows();
    if(!rows)
    {
        format(teade, sizeof(teade), ""White"Tere tulemast "Red""SERVERI_NIMI""White"!\n"White"Sellist kasutajat nagu %s ei eksisteeri meie andmebaasis! \n\n"White"Palun registreeri, kirjutades alla lahtrisse oma tulevane parool:", pname);
        ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""Blue"Registreerimine",teade, "Registreeri", "Tьhista");
    }
    if(rows == 1)
    {
        format(teade, sizeof(teade), ""White"Tere tulemast tagasi "Red""SERVERI_NIMI""White"!\n"White"Selline kasutaja nagu %s eksisteerib andmebaasis!\n\n"White"Palun logi sisse, kirjutades alla lahtrisse "Red"oma"White" parool:", pname);
        ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, ""Blue"Logi sisse", teade, "Logi Sisse", "Tьhista");
        IsRegistered[playerid] = 1;
    }
    mysql_free_result();
pawn Код:
//STOCK
stock MySQL_Login(playerid)
{
    new query2[300], pname[24], savingstring[20];
    GetPlayerName(playerid, pname, 24);
    format(query2, sizeof(query2), "SELECT score, money, level, vip, kma, rank, kills, deaths, muted, jailed, frozen, mutedtimes, jailedtimes, frozentimes, Drift, logins, Meetrid, Kilomeetrid FROM playerdata WHERE user = '%s'", pname);
    mysql_query(query2);
    mysql_store_result();
    while(mysql_fetch_row_format(query2,"|"))
    {
        mysql_fetch_field_row(savingstring, "score"); AnnaRaha(playerid, 0, strval(savingstring));
        mysql_fetch_field_row(savingstring, "money"); AnnaRaha(playerid, strval(savingstring), 0);
        mysql_fetch_field_row(savingstring, "level"); PlayerInfo[playerid][pLevel] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "vip"); PlayerInfo[playerid][pVIP] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "kma"); PlayerInfo[playerid][pKMA] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "rank"); PlayerInfo[playerid][pRank] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "kills"); PlayerInfo[playerid][pKills] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "deaths"); PlayerInfo[playerid][pDeaths] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "muted"); PlayerInfo[playerid][pMuted] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "jailed"); PlayerInfo[playerid][pJailed] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "frozen"); PlayerInfo[playerid][pFrozen] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "mutedtimes"); PlayerInfo[playerid][pMutedTimes] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "jailedtimes"); PlayerInfo[playerid][pJailedTimes] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "frozentimes"); PlayerInfo[playerid][pFrozenTimes] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Drift"); PlayerInfo[playerid][Drift] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "logins"); PlayerInfo[playerid][pLogins] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Meetrid"); PlayerInfo[playerid][Meetrid] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Kilomeetrid"); PlayerInfo[playerid][Kilomeetrid] = strval(savingstring);
    }
    mysql_free_result();
    JustLogged[playerid] = 1;
    Logged[playerid] = 1;
    PlayerInfo[playerid][pLogins]++;
    GameTextForPlayer(playerid,"~g~Sa oled edukalt ~n~sisse logitud!",5000,5);
    new st[128];
    format(st,128,"{1FF231}%s {F2B01F}logis enda kasutajasse sisse !",GetName(playerid));
    SendClientMessageToAll(COLOR_LIGHTBLUE,st);
    CargarDatosVehiculos(playerid);
    return 1;
}
Reply
#2

you connected mysql to host?
Reply
#3

Quote:
Originally Posted by TheNerka
Посмотреть сообщение
you connected mysql to host?
Yes, i connected.
pawn Код:
mysql_connect(SQL_HOST, SQL_KASUTAJA, SQL_AB, SQL_PASS);
// ETC...
Reply
#4

imported SQL file to phpmyadmin?
Reply
#5

Quote:
Originally Posted by TheNerka
Посмотреть сообщение
imported SQL file to phpmyadmin?
What that mean?
Reply
#6

you have mysql database on phpmyadmin and imported tables?
Reply
#7

Quote:
Originally Posted by TheNerka
Посмотреть сообщение
you have mysql database on phpmyadmin and imported tables?
Yes i Have!
pawn Код:
//OnGameModeInit
mysql_debug(1);
    mysql_connect(SQL_HOST, SQL_KASUTAJA, SQL_AB, SQL_PASS);
    mysql_query("CREATE TABLE IF NOT EXISTS playerdata(user VARCHAR(24), password VARCHAR(40), score INT(20), money INT(20), level INT(1), vip INT(20), kma INT(20), rank INT(20), kills INT(20), deaths INT(20), muted INT(20), jailed INT(20), frozen INT(20), mutedtimes INT(20), jailedtimes INT(20), frozentimes INT(20), Drift INT(20), logins INT(20), IP VARCHAR(16), Meetrid INT(20), Kilomeetrid INT(20) )");
    mysql_query("CREATE TABLE IF NOT EXISTS Bans(Username VARCHAR(32), Admin VARCHAR(32), IP VARCHAR(16), Reason VARCHAR(64), Seconds INT(12), Banned INT(5) )");
    mysql_debug(1);
    print("\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n");
    print("\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n");
    print("\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n");
    print("\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n");
    print("Eesti Fun Server Mдngumood");
    print("Skripter: ESTPanther");
    print("----------------------------");
    print("Mдngumood on edukalt laetud!");
    if(mysql_ping()>2)
    print("[ANDMEBAAS]: Ьhendus andmebaasiga ebaхnnestus!");
    else print("[ANDMEBAAS]: Ьhendust andmebaasiga хnnestus!");
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)