unknown column 'account_id' in field 'list' to this guild announce

[kalabasa]

-    script    guild_announce    -1,{
OnWhisperGlobal:
    .@guild_id = getcharid(2);
    if ( getguildmasterid( .@guild_id ) != getcharid(0) ) end;
    if ( @accountid_member == 0 )
        @total_guild_member = query_sql( "select `account_id`, `char_id` from `guild_member` where `guild_id` = "+ .@guild_id, @accountid_member, @charid_member );
    .@mes$ = @whispervar0$;
    .@name$ = strcharinfo(0);
	.@myaid = getcharid(3);
    while( .@i < @total_guild_member ) {
        if ( isloggedin( @accountid_member[.@i], @charid_member[.@i] ) ) {
            attachrid @accountid_member[.@i];
            announce "[ "+ .@name$ +" ]: "+ .@mes$, bc_self;
			attachrid .@myaid;
        }
        .@i++;
    }
}

 

 

 

[KazumaSatou]

1 hour ago, kalabasa said:

-    script    guild_announce    -1,{
OnWhisperGlobal:
    .@guild_id = getcharid(2);
    if ( getguildmasterid( .@guild_id ) != getcharid(0) ) end;
    if ( @accountid_member == 0 )
        @total_guild_member = query_sql( "select `account_id`, `char_id` from `guild_member` where `guild_id` = "+ .@guild_id, @accountid_member, @charid_member );
    .@mes$ = @whispervar0$;
    .@name$ = strcharinfo(0);
	.@myaid = getcharid(3);
    while( .@i < @total_guild_member ) {
        if ( isloggedin( @accountid_member[.@i], @charid_member[.@i] ) ) {
            attachrid @accountid_member[.@i];
            announce "[ "+ .@name$ +" ]: "+ .@mes$, bc_self;
			attachrid .@myaid;
        }
        .@i++;
    }
}

 

 

 

There is no account_id field on guild_member table. Only char_id is available on guild_mamber table. Or you might  wanna add it.

[kalabasa]

10 minutes ago, KazumaSatou said:

There is no account_id field on guild_member table. Only char_id is available on guild_mamber table. Or you might  wanna add it.

do they have the same value?

`account_id` int(11) unsigned NOT NULL default '0',

[KazumaSatou]

Just now, kalabasa said:

11 minutes ago, KazumaSatou said:

o account_id field on guild_member table. Only char_id is available on guild_mamber table. Or you might  wanna add it.

do they have the same value?

`account_id` int(11) unsigned NOT NULL default '0',

Yeah same type. But I think you need to add that in src to make it automatically added the account id once a player joins guild.

[kalabasa]

i added on mysql workbench. no error but it does not work. i have no idea how to put it on src.

[Emistry]

the account_id has been deprecated from the database long time ago, simply adding back the column wont make it work since the column wont have any values stored in it.

You have to change the SQL statement to retrieve the info that you needed.

@total_guild_member = query_sql( "SELECT `account_id`, `char_id` FROM `char` WHERE `guild_id` = "+ .@guild_id, @accountid_member, @charid_member );

 

or a simple attempts

-    script    guild_announce    -1,{
OnWhisperGlobal:
	if (!getcharid(2)) end;
	.message_owner$ = strcharinfo(0);
	.message$ = "";
	for (.@i = 0; .@i < 10; .@i++)
		.message$ = .message$ + ((.@i > 0) ? "#":"") + @whispervar0$;
	addrid(3, 0, getcharid(2));
	announce "[ "+ .message_owner$ +" ]: "+ .message$, bc_self;
	end;
}

 

[kalabasa]

On 3/5/2022 at 8:23 PM, Emistry said:

the account_id has been deprecated from the database long time ago, simply adding back the column wont make it work since the column wont have any values stored in it.

You have to change the SQL statement to retrieve the info that you needed.

@total_guild_member = query_sql( "SELECT `account_id`, `char_id` FROM `char` WHERE `guild_id` = "+ .@guild_id, @accountid_member, @charid_member );

 

or a simple attempts

-    script    guild_announce    -1,{
OnWhisperGlobal:
	if (!getcharid(2)) end;
	.message_owner$ = strcharinfo(0);
	.message$ = "";
	for (.@i = 0; .@i < 10; .@i++)
		.message$ = .message$ + ((.@i > 0) ? "#":"") + @whispervar0$;
	addrid(3, 0, getcharid(2));
	announce "[ "+ .message_owner$ +" ]: "+ .message$, bc_self;
	end;
}

 

no idea if its working but when i type a message it alway shows ########