[Kirollos]

alright, you were just writing in the queries quickweapons, it's quickweapon as written in CREATE TABLE IF NOT EXISTS

pawn Код:

//Ongamemodeinit
    new string[1500];
    mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
    format(string,sizeof(string),"CREATE TABLE IF NOT EXISTS data(user VARCHAR(24), password VARCHAR(40), IP VARCHAR(15), score INT(20), money INT(20), kills INT(20), deaths INT(20), registered INT(20), loggedin INT(20), level INT(20), cookies INT(20),");
    strcat(string,"cakes INT(20), biscuits INT(20), icecreams INT(20), YG INT(20), unlimitedb INT(20), quickweapon INT(20), vgoto INT(20), playerfly INT(20), TP INT(20))");
    //format(string,sizeof(string),"CREATE TABLE IF NOT EXISTS data(user VARCHAR(24), password VARCHAR(40), IP VARCHAR(15), score INT(20), money INT(20),kills INT(20), deaths INT(20),");
    //strcat(string,"registered INT(20), loggedin INT(20), level INT(20), cookies INT(20), cakes INT(20), biscuits INT(20), icecreams INT(20), YG INT(20), unlimitedb INT(20))");
    mysql_query(string);
    mysql_debug(1);

//onplayerdisconnect
new score = GetPlayerScore(playerid);
    new money = GetPlayerMoney(playerid);
    new query[1200], pname[24];
    GetPlayerName(playerid, pname, 24);
    format(query, sizeof(query), "UPDATE data SET score=%d, money=%d, kills=%d, deaths=%d, registered=%d, loggedin=%d, level=%d, cookies=%d, cakes=%d, biscuits=%d, icecreams=%d, YG=%d, unlimitedb=%d, quickweapon=%d, vgoto=%d, playerfly=%d, TP=%d  WHERE user='%s'",
    score,
    money,
    PlayerInfo[playerid][Kills],
    PlayerInfo[playerid][Deaths],
    PlayerInfo[playerid][Registered],
    PlayerInfo[playerid][LoggedIn],
    PlayerInfo[playerid][Level],
    PlayerInfo[playerid][Cookies],
    PlayerInfo[playerid][Cakes],
    PlayerInfo[playerid][Biscuits],
    PlayerInfo[playerid][IceCreams],
    PlayerInfo[playerid][Rb],
    PlayerInfo[playerid][Unlimitedb],
    PlayerInfo[playerid][Quickweapon],
    PlayerInfo[playerid][Vgoto],
    PlayerInfo[playerid][PlayerFly],
    PlayerInfo[playerid][TP],
    pname);
    mysql_query(query);

//onplayerconnect
new query[300], pname[24];
    GetPlayerName(playerid, pname, 24);
    format(query, sizeof(query), "SELECT IP FROM `data` WHERE user = '%s' LIMIT 1", pname);
    mysql_query(query);
    mysql_store_result();
    new rows = mysql_num_rows();
    if(!rows)
    {
        ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""Blue"Please register",""White"Welcome to "Red""White"!\n"White"In order to start playing, you have to register!\n\n"White"Please insert a password below:", "Register", "Cancel");
    }
    if(rows == 1)
    {
        new IP[2][15];
        mysql_fetch_field_row(IP[0],"IP");
        GetPlayerIp(playerid, IP[1], 15);
        if(strlen(IP[0]) != 0 && !strcmp(IP[0], IP[1], true))
        {
            MySQL_Login(playerid);
        }
        else if(!strlen(IP[0]) || strcmp(IP[0], IP[1], true))
        {
            ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, ""Blue"Please log-in", ""White"Welcome back to "Red""White"!\n"White"In order to start playing, you have to log-in!\n\n"White"Please insert "Red"your"White" password below:", "Login", "Cancel");
            PlayerInfo[playerid][Registered] = 1;
        }
    }
    mysql_free_result();

//query

stock MySQL_Register(playerid, passwordstring[])
{
    new query[1600], pname[24], IP[15];
    GetPlayerName(playerid, pname, 24);
    GetPlayerIp(playerid, IP, 15);
    //format(query, sizeof(query), "INSERT INTO data (user, password, IP, score, money, kills, deaths, registered, loggedin, level, cookies, cakes, biscuits, icecreams, YG, unlimitedb, quickweapon, vgoto, playerfly, TP, YGFunction1, YGFunction2, YGFunction3, YGFunction4, YGFunction5, YGFunction6, Bank, weed, Condoms, inalcatraz) VALUES('%s', SHA1('%s'), '%s', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)", pname, passwordstring, IP);
    format(query, sizeof(query), "INSERT INTO data (user, password, IP, score, money, kills, deaths, registered, loggedin, level, cookies, cakes, biscuits, icecreams, YG, unlimitedb,\
    quickweapon, vgoto, playerfly, TP) VALUES('%s', SHA1('%s'), '%s', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)", pname, passwordstring, IP);
    mysql_query(query);
    SendClientMessage(playerid, -1,"Info: You have been registered on this server!");
    PlayerInfo[playerid][LoggedIn] = 1;
    PlayerInfo[playerid][Registered] = 1;
    return 1;
}
stock MySQL_Login(playerid)
{
    new query[1500], pname[24], savingstring[1600];
    new resultline[600];
    GetPlayerName(playerid, pname, 24);
    //format(query, sizeof(query), "SELECT score, money, kills, deaths, registered, loggedin, level, cookies, cakes, biscuits, icecreams, YG, unlimitedb,quickweapon, vgoto, playerfly, TP, YGFunction1, YGFunction2, YGFunction3, YGFunction4, YGFunction5, YGFunction6, Bank, weed, Condoms, inalcatraz  WHERE user = '%s'", pname);
    format(query, sizeof(query), "SELECT score, money, kills, deaths, registered, loggedin, level, cookies, cakes, biscuits, icecreams, YG, unlimitedb, quickweapon, vgoto, playerfly, TP  WHERE user = '%s'", pname);
    mysql_query(query);
    mysql_store_result();
    if(mysql_fetch_row_format(resultline))
    {
        mysql_fetch_field_row(savingstring, "score"); SetPlayerScore(playerid, strval(savingstring));
        mysql_fetch_field_row(savingstring, "money"); MoneyGiven[playerid] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "kills"); PlayerInfo[playerid][Kills] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "deaths"); PlayerInfo[playerid][Deaths] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "registered"); PlayerInfo[playerid][Registered] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "loggedin"); PlayerInfo[playerid][LoggedIn] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "level"); PlayerInfo[playerid][Level] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "cookies"); PlayerInfo[playerid][Cookies] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "cakes"); PlayerInfo[playerid][Cakes] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "biscuits"); PlayerInfo[playerid][Biscuits] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "icecreams"); PlayerInfo[playerid][IceCreams] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "YG"); PlayerInfo[playerid][Rb] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "unlimitedb"); PlayerInfo[playerid][Unlimitedb] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "quickweapon"); PlayerInfo[playerid][Quickweapon] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "vgoto"); PlayerInfo[playerid][Vgoto] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "playerfly"); PlayerInfo[playerid][PlayerFly] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "TP"); PlayerInfo[playerid][TP] = strval(savingstring);
    }
    mysql_free_result();
    JustLogged[playerid] = 1;
    PlayerInfo[playerid][LoggedIn] = 1;
    SendClientMessage(playerid, -1,"Info: You have been logged-in!");
    return 1;
}

stock GetName(playerid)
{
    new pname[24];
    GetPlayerName(playerid, pname, 24);
    return pname;
}