[BiGuy]

Hello i am trying to make a group system but i cant store group id, name and leader name in the variable it always return as blank here is my code:

PHP код:

stock CreateGroup(playerid, groupname[])
{
    new Query[208], string[128];
    format(Query, sizeof Query, "INSERT INTO groups (name, leader, leaderid) VALUES ('%q', '%q', %d)", groupname, PlayerInfo[playerid][pName], PlayerInfo[playerid][pID]);
    db_query(GroupDB, Query);
    SendClientMessage(playerid, 0x00FF00FF, "You have created a group!");
    new DBResult: Result;
    Result = db_query(GroupDB, "SELECT last_insert_rowid()");
    GroupInfo[db_get_field_int(Result)][gID] = db_get_field_int(Result);
    GroupInfo[db_get_field_int(Result)][gLeaderID] = PlayerInfo[playerid][pID];
    GroupInfo[db_get_field_int(Result)][gMembers]++;
    format(GroupInfo[db_get_field_int(Result)][gName], GroupInfo[db_get_field_int(Result)][gName], "%s", groupname);
    format(GroupInfo[db_get_field_int(Result)][gLeader], GroupInfo[db_get_field_int(Result)][gLeader], "%s", PlayerInfo[playerid][pName]);
    format(string, sizeof string, "GroupName: {FF0000}%s", GroupInfo[db_get_field_int(Result)][gName]);
    SendClientMessage(playerid, -1, string);
    format(string, sizeof string, "GroupLeader: {FF0000}%s", GroupInfo[db_get_field_int(Result)][gLeader]);
    SendClientMessage(playerid, -1, string);
    format(string, sizeof string, "GroupID: {FF0000}%s", GroupInfo[db_get_field_int(Result)][gID]);
    SendClientMessage(playerid, -1, string);
    
    PlayerInfo[playerid][pGroupID] = GroupInfo[db_get_field_int(Result)][gID];
    PlayerInfo[playerid][pGroupRank] = 10;
    printf("Group ID iS %d.",GroupInfo[db_get_field_int(Result)][gID]);
    db_free_result(Result);
    format(Query, sizeof Query, "INSERT INTO members (playerid, pname, prank, gid) VALUES (%d, '%q', %d, %d)", PlayerInfo[playerid][pID], PlayerInfo[playerid][pName], PlayerInfo[playerid][pGroupRank], PlayerInfo[playerid][pGroupID]);
    db_query(GroupDB, Query);
    return 1;
} 


database logs:

Код:

[db_log_queries]: INSERT INTO groups (name, leader, leaderid) VALUES ('MyBigGrou
p', 'BiG', 1)
[db_log_queries]: SELECT last_insert_rowid()
Group ID iS 0.
[db_log_queries]: INSERT INTO members (playerid, pname, prank, gid) VALUES (1, '
BiG', 10, 0)

this is what i mean by blank:


just to be more specific the data stores in the database