[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

[cSharp]

format(..)'s second parameter should be an integer defining the string's size.

[BiGuy]

Quote:

Originally Posted by cSharp format(..)'s second parameter should be an integer defining the string's size.

string size is already defined above with new string[128]; but you ignored my main problem and commented on something which is already working fine

[cSharp]

Quote:

Originally Posted by BiGuy string size is already defined above with new string[128]; but you ignored my main problem and commented on something which is already working fine

Don't be an ignorant cunt and act toxic, please. Explain me this if you so has given the string size to the format paramter:

pawn Код:

format(GroupInfo[db_get_field_int(Result)][gName], GroupInfo[db_get_field_int(Result)][gName], "%s", groupname);

You're the one on the forums requesting help, don't be a bitch when someone tells you the issue.
If you still can't figure out the issue, here, have a couple of eye hints:

Код:

format(GroupInfo[db_get_field_int(Result)][gName], GroupInfo[db_get_field_int(Result)][gName], "%s", groupname);

Код:

format(GroupInfo[db_get_field_int(Result)][gName], sizeof groupname, "%s", groupname);

And now you tell me, does the text appear? I'll go ahead and answer that for you - yes it does.

[BiGuy]

calm your tits down why are you mad? its my bad thanks for the help lol

btw i fixed it doing this:

PHP код:

    format(GroupInfo[db_get_field_int(Result)][gLeader], 24, "%s", PlayerInfo[playerid][pName]);
    format(GroupInfo[db_get_field_int(Result)][gName], 16, "%s", groupname); 


[v1k1nG]

Quote:

Originally Posted by cSharp should be an integer

I doubt this

PHP код:

GroupInfo[db_get_field_int(Result)][gName] 


are bananas. Even if its value is 1 a letter should appear after formatting, and it doesn't.

Also

PHP код:

sizeof groupname 


is an indeterminate array size.

[cSharp]

Quote:

Originally Posted by v1k1nG I doubt this PHP код: GroupInfo[db_get_field_int(Result)][gName]  are bananas. Even if its value is 1 a letter should appear after formatting, and it doesn't. Also PHP код: sizeof groupname  is an indeterminate array size.

fuck gives a fuck what the variable is, an integer is an integer.

[v1k1nG]

Keyboard lion(ess)