kalabasa Posted February 11, 2022 Group: Members Topic Count: 123 Topics Per Day: 0.05 Content Count: 478 Reputation: 14 Joined: 11/30/17 Last Seen: January 23 Share Posted February 11, 2022 - 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++; } } Quote Link to comment Share on other sites More sharing options...
0 KazumaSatou Posted February 11, 2022 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 157 Reputation: 37 Joined: 05/15/20 Last Seen: 1 hour ago Share Posted February 11, 2022 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. Quote Link to comment Share on other sites More sharing options...
0 kalabasa Posted February 11, 2022 Group: Members Topic Count: 123 Topics Per Day: 0.05 Content Count: 478 Reputation: 14 Joined: 11/30/17 Last Seen: January 23 Author Share Posted February 11, 2022 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', Quote Link to comment Share on other sites More sharing options...
0 KazumaSatou Posted February 11, 2022 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 157 Reputation: 37 Joined: 05/15/20 Last Seen: 1 hour ago Share Posted February 11, 2022 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. Quote Link to comment Share on other sites More sharing options...
0 kalabasa Posted February 11, 2022 Group: Members Topic Count: 123 Topics Per Day: 0.05 Content Count: 478 Reputation: 14 Joined: 11/30/17 Last Seen: January 23 Author Share Posted February 11, 2022 i added on mysql workbench. no error but it does not work. i have no idea how to put it on src. Quote Link to comment Share on other sites More sharing options...
0 Emistry Posted March 5, 2022 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10018 Reputation: 2371 Joined: 10/28/11 Last Seen: 23 hours ago Share Posted March 5, 2022 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; } Quote Link to comment Share on other sites More sharing options...
0 kalabasa Posted May 7, 2022 Group: Members Topic Count: 123 Topics Per Day: 0.05 Content Count: 478 Reputation: 14 Joined: 11/30/17 Last Seen: January 23 Author Share Posted May 7, 2022 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 ######## Quote Link to comment Share on other sites More sharing options...
Question
kalabasa
Link to comment
Share on other sites
6 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.