[Karl[NDZ]]

Can someone help me converting this:

pawn Код:

stock CheckUser(playerid)
{
        new Query[100]; format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s';", GetPlayerNameEx(playerid));
        mysql_query(Query);
        mysql_store_result();
        if(mysql_num_rows()) return 1;
        return 0;
}

stock LoadPlayerInfo(playerid)
{
        new Query[100]; format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s';", GetPlayerNameEx(playerid));
        mysql_query(Query);
        mysql_store_result();
        mysql_fetch_row(Query, "|");
        sscanf(Query, "p<|>e<is[25]i>", PlayerInfo[playerid]);
}

stock CheckGangByName(Name[])
{
        new Query[100]; format(Query, sizeof(Query), "SELECT * FROM gangs WHERE name = '%s';", Name);
        mysql_query(Query);
        mysql_store_result();
        if(mysql_num_rows()) return 1;
        return 0;
}

stock CheckGangById(GangID)
{
        new Query[100]; format(Query, sizeof(Query), "SELECT * FROM gangs WHERE id = %d;", GangID;
        mysql_query(Query);
        mysql_store_result();
        if(mysql_num_rows()) return 1;
        return 0;
}

stock ResetPlayerInfo(playerid)
{
        Invite[playerid] = 0;
        PlayerInfo[playerid][Gang] = 0;
}

stock InitMysqlConnection()
{
    mysql_init();
    mysql_connect(DB_HOST, DB_USER, DB_PASS, DB_DB);
    mysql_query(CREATE_DB_USERS);
    mysql_query(CREATE_DB_GANGS);
}

stock IsPlayerGangLeader(playerid)
{
        new Query[100]; format(Query, sizeof(Query), "SELECT * FROM gangs WHERE id = %d AND owner = '%s';", PlayerInfo[playerid][Gang], GetPlayerNameEx(playerid));
        mysql_query(Query);
        mysql_store_result();
        if(mysql_num_rows()) return 1;
        return 0;
}

stock IsMySelf(pID, oID)
{
        if(pID == oID) return 1;
        return 0;
}

stock GetGangName(GangID)
{
        new gName[100], Query[150]; format(Query, sizeof(Query), "SELECT name FROM gangs WHERE id = %d;", GangID);
        mysql_query(Query);
        mysql_store_result();
        mysql_fetch_string(gName);
        return gName;
}

stock GetGangMemberCount(gID)
{
    new Query[150]; format(Query, sizeof(Query), "SELECT * FROM users WHERE gang = %d;", gID);
    mysql_query(Query);
        mysql_store_result();
        return mysql_num_rows();
}

stock GetGangCount()
{
    new Query[150]; format(Query, sizeof(Query), "SELECT * FROM gangs;");
    mysql_query(Query);
        mysql_store_result();
        return mysql_num_rows();
}

stock ShowGangInfoForPlayer(GangID, pID)
{
    new tGid, tGname[100], tGOwner[25], Query[150], string[200];
    format(Query, sizeof(Query), "SELECT * FROM gangs WHERE id = %d;", GangID);
    mysql_query(Query);
        mysql_store_result();
        if(!mysql_num_rows()) return 0;
        mysql_fetch_row(Query, "|");
        sscanf(Query, "p<|>is[100]s[25]", tGid, tGname, tGOwner);
        format(string, sizeof(string), "Id: %d - Name: %s - Owner: %s - Members: %d", tGid, tGname, tGOwner, GetGangMemberCount(GangID));
        return ShowPlayerDialog(pID, DIALOG_GANG_INFO, DIALOG_STYLE_MSGBOX, "Gang info", string, "Cancel", "");
}

stock GetPlayerNameEx(playerid)
{
        new pName[25];
        GetPlayerName(playerid, pName, 25);
        return pName;
}

stock strmatch(const String1[], const String2[])
{
        if ((strcmp(String1, String2, true, strlen(String2)) == 0) && (strlen(String2) == strlen(String1))) return true;
        else return false;
}

to a normal text file that i use for my saving?
Tell me if you need more codes, because I have no idea how to convert mysql

[Kindred]

Should really tell us what file saving system you have and shit.

Will help you eventually if no one else does.

[Karl[NDZ]]

I followed this guide for the login system: https://sampforum.blast.hk/showthread.php?tid=273088]

[Karl[NDZ]]

Sorry for double post.