problem with script

[Yukaiii]

what's up guys. everything is good?

 

Can someone explain to me if this script is asking for some sql table?

 

it has these sql commands in it..
If you're asking, would it be difficult to create it?

 

the problem I'm having in my script is that it's not checking if the party's member is online.

Quote

                // Offline user (use sql)
                else
                {
                        set .@sql$, .@sql$ + ( .@sql_i ? "OR " : "" ) + "`char_id`='" + $@partymembercid[.@i] + "' ";
                        set .@sql_i, .@sql_i + 1;
                }
        }

        // SQL for offline users
        if ( getstrlen(.@sql$) )
        {
                // get class from offline members
                set .@count, query_sql("SELECT `class` FROM `char` WHERE " + .@sql$, .@class );

                // Check the class.
                for ( set .@i, 0; .@i<.@count; set .@i, .@i+1 )
                {
                        if ( compare( .@tmp_class$ + "|", "|" + .@class[.@i] + "|" ) )
                        {
                                if ( .@rid )
                                        attachrid(.@rid);
                                else
                                        detachrid;
                                return 1;
                        }
                        set .@tmp_class$, .@tmp_class

 

Edited December 15, 2022 by Yukaiii

[Emistry]

based on the snippet above, it check for the char table for data.

sql-files/main.sql