Like this?
prontera,150,150,0 script Sample 100,{
query_sql "SELECT `name` , `class` FROM `char` WHERE `online` = '1'", .@name$, .@class;
mes "-----------------------------------";
mes "Online Users: " + getusers(1);
mes "-----------------------------------";
for( set .@a,0; .@a < getarraysize(.@name$); set .@a,.@a + 1)
mes .@name$[.@a]+ " | Job: " +jobname(.@class[.@a]);
mes "-----------------------------------";
close;
}